<?php 
// php code starts here........................................................................
  if ($includeFlag == false) {
    HEADER("Expires: Mon, 07 FEB 2000 05:00:00 GMT");             // Date in the past
    HEADER("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
    HEADER("Cache-Control: no-cache, must-revalidate");           // HTTP/1.1
    HEADER("Pragma: no-cache");
    include ("./CMSconfig.phpi"); // include the config file...
  }
   
  while (list($key, $value) = each($HTTP_POST_VARS)) {
    rmvQuotes($value);
    ${$key} = $value;
  }
  
  switch($mode)  {
    case "save":
      if ($rgsID != '') {
        // save registration information ...
        $fldName = "rgsNote = '$rgsNote'";    
        $db_CMS->db_process_query("update", $rgsTbl, $fldName, "none","rgsID = '$rgsID'", "none");
    
        // save anybody information ....
        $fldName = "anbAddr = '$anbAddr', anbSEmail = '$anbSEmail', anbPCode = '$anbPCode', anbCntry = '$anbCntry',anbPhone = '$anbPhone', anbFax = '$anbFax'";
        $db_CMS->db_process_query("update", $anbTbl, $fldName, "none","anbID = '$anbID'", "none");
    
        // save orderline information...
      
        // First find the cost out xtra proceedings..
        $fldName = "odlOrderedAmount = '$xtraProceedingNumber'";
        $db_CMS->db_process_query("update", $odlTbl, $fldName, "none","rgsID = '$rgsID' and odlName = 'xtraProceedingNumber'", "none");
      
        $fldName = "odlOrderedAmount = '$xtraDinnerTicket'";
        $db_CMS->db_process_query("update", $odlTbl, $fldName, "none","rgsID = '$rgsID' and odlName = 'xtraDinnerTicket'", "none");

        // save miscellaneous information ....
        $fldName = "mscDescription = '$reception'";
        $db_CMS->db_process_query("update", $mscTbl, $fldName, "none","mscID = '$mscRAID'", "none");
    
        $fldName = "mscDescription = '$dinner'";
        $db_CMS->db_process_query("update", $mscTbl, $fldName, "none","mscID = '$mscDRID'", "none");
      }
      break;
  }
  
  // get the registration details....
  $db_CMS->db_process_query("select",$rgsTbl,"*","none","rgsID = '$rgsID'","none");
  $sRsltSet_rgs = $db_CMS->dbRsltSet;

  if ($db_CMS->dbNumRow > 0) { //ok we found the registration..
    $sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet_rgs);  
    
    $anbID = $sCurRow_rgs["anbID"];
    $pymID = $sCurRow_rgs["pymID"];
    $ctgID = $sCurRow_rgs["ctgID"];
    $rgsTagName = $sCurRow_rgs["rgsTagName"];
    $rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];
    $rgsStatus = $sCurRow_rgs["rgsStatus"];
    $rgsNote = $sCurRow_rgs["rgsNote"];
  }
    
  // get the participant details....
  $db_CMS->db_process_query("select",$anbTbl,"*","none","anbID = '$anbID'","none");
  $sRsltSet_anb = $db_CMS->dbRsltSet;
  
  if ($db_CMS->dbNumRow > 0) { //ok we found the user..
    $sCurRow_anb = $db_CMS->db_fetch_array($sRsltSet_anb);
    
    $anbTitle = $sCurRow_anb["anbTitle"];
    $anbFName = $sCurRow_anb["anbFName"];
    $anbLName = $sCurRow_anb["anbLName"];
    $anbAddr = $sCurRow_anb["anbAddr"];
    $anbPCode = $sCurRow_anb["anbPCode"];
    $anbCntry = $sCurRow_anb["anbCntry"];
    $anbEmail = $sCurRow_anb["anbEmail"];
    $anbSEmail = $sCurRow_anb["anbSEmail"];
    $anbPhone = $sCurRow_anb["anbPhone"];
    $anbFax = $sCurRow_anb["anbFax"];
  }

  // get the orderLine requests.. for xtra proceedings..
  $db_CMS->db_process_query("select",$odlTbl,"*","none","rgsID = '$rgsID' and odlName = 'xtraProceedingNumber'","none");
  $sRsltSet_odl = $db_CMS->dbRsltSet;
  
  if ($db_CMS->dbNumRow > 0) {
    $sCurRow_odl = $db_CMS->db_fetch_array($sRsltSet_odl);
    $xtraProceedingNumber = $sCurRow_odl["odlOrderedAmount"];
  }
  
  // get the orderLine requests.. for xtra dinner tickets...
  $db_CMS->db_process_query("select",$odlTbl,"*","none","rgsID = '$rgsID' and odlName = 'xtraDinnerTicket'","none");
  $sRsltSet_odl = $db_CMS->dbRsltSet;
  
  if ($db_CMS->dbNumRow > 0) {
    $sCurRow_odl = $db_CMS->db_fetch_array($sRsltSet_odl);
    $xtraDinnerTicket = $sCurRow_odl["odlOrderedAmount"];
  }
    
  // get the payment details....
  $db_CMS->db_process_query("select",$pymTbl,"*","none","pymID = '$pymID'","none");
  $sRsltSet_pym = $db_CMS->dbRsltSet;

  if ($db_CMS->dbNumRow > 0) { //ok we found the registration..
    $sCurRow_pym = $db_CMS->db_fetch_array($sRsltSet_pym);  
    $pymMethod = $sCurRow_pym["pymMethod"];    
    $pymNote = $sCurRow_pym["pymNote"];
  }
  
  // get the rest of the details....
  $db_CMS->db_process_query("select",$mscTbl,"*","none","rgsID = '$rgsID'","mscID");
  $sRsltSet_msc = $db_CMS->dbRsltSet;

  if ($db_CMS->dbNumRow > 0) { //ok we found the registration..
  
    // the reception attendance thingee..
    $sCurRow_msc = $db_CMS->db_fetch_array($sRsltSet_msc);  
    $mscRAID=$sCurRow_msc["mscID"];
    $reception=$sCurRow_msc["mscDescription"];
    
    // the dinner request thingee...
    $sCurRow_msc = $db_CMS->db_fetch_array($sRsltSet_msc);  
    $mscDRID=$sCurRow_msc["mscID"];
    $dinner=$sCurRow_msc["mscDescription"];
  }
  
  // represent some of the short forms in understandable format...  
  switch ($ctgID) {
    case "umc2kFul" :
      $ctgIDE = "Full (UMC2K): US$100";
      break;
    case "umc2kStd" :
      $ctgIDE = "Student (UMC2K) US$50 (no discounts)";
      break;
  }

  switch ($xtraProceedingNumber) {
    case "0" :
      $xtraProceedingNumberE = "Zero";
      break;
    case "1" :
      $xtraProceedingNumberE = "One";
      break;
    case "2" :
      $xtraProceedingNumberE = "Two";
      break;
    case "3" :
      $xtraProceedingNumberE = "Three";
      break;
    case "4" :
      $xtraProceedingNumberE = "Four";
      break;
    case "5" :
      $xtraProceedingNumberE = "Five";
      break;
  }
  
  switch ($xtraDinnerTicket) {
    case "0" :
      $xtraDinnerTicketE = "Zero";
      break;
    case "1" :
      $xtraDinnerTicketE = "One";
      break;
    case "2" :
      $xtraDinnerTicketE = "Two";
      break;
    case "3" :
      $xtraDinnerTicketEE = "Three";
      break;
    case "4" :
      $xtraDinnerTicketE = "Four";
      break;
    case "5" :
      $xtraDinnerTicketE = "Five";
      break;
  }  
  
  switch ($pymMethod) {
    case "crd" : 
      $pymMethodE = "credit card";
      break;
    case "cbd" :
      $pymMethodE = "cheque/bank draft by mail";
      break;
    case "inv" :
      $pymMethodE = "invoice";
      break;
    case "cmt" :
      $pymMethodE = "committee member";
      break;
  }
    
  switch ($reception) {
    case "yes" :
      $receptionE = "Yes, I am attending the welcome reception";
      break;
    case "no" :
      $receptionE = "No, I am not attending the welcome reception";
      break;
  }
  
  if ($pymNote == "") {
    $pymNote = "none";
  }
  
  if ($rgsNote == "") {
    $rgsNote = "none";
  }

// php codes ends ..............................................................................  
?>
    <html>
      <head>
        <script LANGUAGE="JavaScript1.1">
          function saveInfoFrm() {
            document.individual.mode.value = 'save';
            document.individual.action = 'participantVew.php3';
            document.individual.submit();
          }
        </script>
      </head>
      <body BGCOLOR="#ffffcc">
        <form name="individual" action="" method="POST">
   	  <table CELLSPACING="1" CELLPADDING="2" ALIGN="center" WIDTH="800" BORDER="0" BGCOLOR="#9999cc">
   	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#cccccc">
   		<font SIZE="+1">
   		  Individual Information - <?php echo $anbTitle." ".$anbFName." ".$anbLName;?>. Registration Status - <?php echo $rgsStatus; ?>
   		</font>
   	      </td>
   	    </tr>
   	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#999999">
   		<font SIZE="+1">Participant Details</font>
   	      </td>
   	    </tr>
   	    <tr>
   	      <td><b>Title:</b><font COLOR="#ff0000">*</font></td>
	      <td>
	        <?php echo $anbTitle; ?><br>
	      </td>
	    </tr>
	    <tr>
	      <td><B>First Name:</B><font COLOR="#ff0000">*</font></td>
	      <td><?php echo $anbFName; ?></td>
	    </tr>
	    <tr>
	      <td><B>Last Name:</B><font COLOR="#ff0000">*</font></td>
	      <td><?php echo $anbLName; ?></td>
	    </tr>
	    <tr>
   	      <td><B>Address:</B><font COLOR="#ff0000">*</font></td>
   	      <td><textarea NAME="anbAddr" cols="30" rows="4"><?php echo $anbAddr; ?></textarea></td>
   	    </tr>
   	    <tr>
   	      <td><B>Country:</B><font COLOR="#ff0000">*</font></td>
   	      <td><input TYPE="text" NAME="anbCntry" VALUE="<?php echo $anbCntry; ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>PostCode:</B></td>
   	      <td><input TYPE="text" NAME="anbPCode" VALUE="<?php echo $anbPCode; ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>E-mail:</B><font COLOR="#ff0000">*</font></td>
   	      <td><?php echo $anbEmail; ?></td>
   	    </tr>
   	    <tr>
   	      <td><B>Alternative E-mail:</B></td>
   	      <td><input  TYPE="text" NAME="anbSEmail" VALUE="<?php echo $anbSEmail; ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Telephone:</B><font COLOR="#ff0000">*</font></td>
   	      <td><input  TYPE="text" NAME="anbPhone" VALUE="<?php echo $anbPhone; ?>" MAXLENGTH="60" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Fax:</B></td>
   	      <td><input  TYPE="text" NAME="anbFax" VALUE="<?php echo $anbFax; ?>" MAXLENGTH="60" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Name on tag:</B><font COLOR="#ff0000">*</font></td>
   	      <td><?php echo $rgsTagName; ?></td>
   	    </tr>
   	    <tr>
   	      <td><B>Institution on tag:</B><font COLOR="#ff0000">*</font></td>
   	      <td><?php echo $rgsTagAddress; ?></td>
   	    </tr>
   	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#999999">
   		<font SIZE="+1">Conference Details</font>
   	      </td>
   	    </tr>
   	    <tr>
	      <td><b>Registration Category:</b><font COLOR="ff0000">*</font></td>
	      <td>
	        <?php echo $ctgIDE; ?><br>
	      </td>
	    </tr>
	    <tr>
              <td><b>Reception :</b></td>
              <td>
                <?php echo $receptionE; ?><br>
                <select NAME="reception">
                  <option VALUE="<?php echo $reception; ?>"></option>
	          <option VALUE="no">No, I am not attending the reception</option>
	          <option VALUE="yes">Yes, I am attending the reception</option>
	        </select>
	      </td>
            </tr>
            <tr>
              <td><b>Extra Proceedings :</b></td>
              <td ALIGN="top">
                <?php echo $xtraProceedingNumberE; ?> extra proceedings <br>
                <select NAME="xtraProceedingNumber">
                  <option VALUE="<?php echo $xtraProceedingNumber; ?>"></option>
	          <option VALUE="0">Zero</option>
	          <option VALUE="1">One</option>
	          <option VALUE="2">Two</option>
	          <option VALUE="3">Three</option>
	          <option VALUE="4">Four</option>
	          <option VALUE="5">Five</option>
	        </select>
	      </td>
            </tr>
            <tr>
              <td><b>Extra Dinner Tickets :</b></td>
              <td ALIGN="top">
                <?php echo $xtraDinnerTicketE; ?> extra dinner tickets <br>
                <select NAME="xtraDinnerTicket">
                  <option VALUE="<?php echo $xtraDinnerTicket; ?>"></option>
	          <option VALUE="0">Zero</option>
	          <option VALUE="1">One</option>
	          <option VALUE="2">Two</option>
	          <option VALUE="3">Three</option>
	          <option VALUE="4">Four</option>
	          <option VALUE="5">Five</option>
	        </select>
	      </td>
            </tr>
            <tr>
              <td><b>Special Dinner Requests :</b></td>
	      <td>
	        <textarea NAME="dinner" ROWS="3" COLS="40"><?php echo $dinner; ?></textarea>
	      </td>
	    </tr>
 	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#999999">
   		<font SIZE="+1">Payment Details</font>
   	      </td>
   	    </tr>
   	    <tr>
	      <td><b>Form of payment:</b><font COLOR="#ff0000">*</font></td>
	      <td>
	        <?php echo $pymMethodE; ?>
              </td>
            </tr>
            <tr>
              <td><b>Special Payment Notes:</b></td>
              <td><?php echo $pymNote; ?></td>
            </tr>
 	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#999999">
   		<font SIZE="+1">Notes</font>
   	      </td>
   	    </tr>
            <tr>
  	      <td>
  	        <b>Other Information / Requests:</b><br>
  	      </td>
  	      <td><textarea name="rgsNote" cols="55" rows="5"><?php echo $rgsNote; ?></textarea></td>
            </tr>
   	    <input TYPE="hidden" NAME="rgsID" VALUE="<?php echo $rgsID; ?>">
   	    <input TYPE="hidden" NAME="cnfID" VALUE="<?php echo $cnfID; ?>">
   	    <input TYPE="hidden" NAME="anbID" VALUE="<?php echo $anbID; ?>">
   	    <input TYPE="hidden" NAME="mscRAID" VALUE="<?php echo $mscRAID; ?>">
   	    <input TYPE="hidden" NAME="mscDRID" VALUE="<?php echo $mscDRID; ?>">
   	    <input TYPE="hidden" NAME="mode" VALUE="">   	    
          </table>
          
          <table CELLSPACING="1" CELLPADDING="2" BORDER="0"  ALIGN="center" WIDTH="800" BGCOLOR="#9999cc">
            <tr>
              <td>
                <table CELLSPACING="1" CELLPADDING="2" BORDER="0" WIDTH="100%" BGCOLOR="#9999cc">
                  <tr>
                    <td COLSPAN="2" ALIGN="center" BGCOLOR="#cccccc">
                      <input TYPE="submit" NAME="save" VALUE="Save_Changes" ONCLICK="saveInfoFrm();">
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
          </table>
        </form>
      </body>
    </html>