<?php 
// php code starts here........................................................................
  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)) {
    ${$key} = $value;
  }
  
  switch ($mode) {
    case "save":
      if ($rgsID != '') {
        // save registration information ...
        $fldName = "rgsTagName = '$rgsTagName', rgsTagAddress = '$rgsTagAddress', ctgID = '$ctgID', rgsNote = '$rgsNote', rgsInternalNote = '$rgsInternalNote'";
        $db_CMS->db_process_query("update", $rgsTbl, $fldName, "none","rgsID = '$rgsID'", "none");
    
        // save anybody information ....
        $fldName = "anbTitle = '$anbTitle', anbFName = '$anbFName', anbLName = '$anbLName', anbAddr = '$anbAddr', anbEmail = '$anbEmail', anbSEmail = '$anbSEmail', anbPCode = '$anbPCode', anbCntry = '$anbCntry',anbPhone = '$anbPhone', anbFax = '$anbFax'";
        $db_CMS->db_process_query("update", $anbTbl, $fldName, "none","anbID = '$anbID'", "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;
    case "status":
      // we basically update the status of user to deleted..
      switch($rgsStatus) {
        case "rqs" :
          $rgsStatus = "requested";
          break;
        case "cnf" :
          $rgsStatus = "confirmed";
          break;
        case "del" :
          $rgsStatuss = "deleted";
          break;
        case "wtd" :
          $rgsStatus = "withdrawn";
          break;
        case "pna" :
          $rgsStatus = "Appr. reqd.";
          break;  
      }
      if ($rgsID != '') {
        //update the registration status for this individual..
        $fldName = "rgsStatus = '$rgsStatus'";
        $db_CMS->db_process_query("update",$rgsTbl,$fldName,"none","rgsID = '$rgsID'", "none");
      }
      break;
  }
    
  // 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 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);  
    $rgsTagName = $sCurRow_rgs["rgsTagName"];
    $rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];
    $rgsStatus = $sCurRow_rgs["rgsStatus"];
    $rgsInternalNote = $sCurRow_rgs["rgsInternalNote"];
    $rgsNote = $sCurRow_rgs["rgsNote"];
  }
  
  // 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);  
    $pymCardType = $sCurRow_pym["pymCardType"];
    $pymMethod = $sCurRow_pym["pymMethod"];    
    $pymCardHolderName = $sCurRow_pym["pymCardHolderName"];
    $pymCardNumber = $sCurRow_pym["pymCardNumber"];
    $pymCardExpiryDate = $sCurRow_pym["pymCardExpiryDate"];
    $pymNote = $sCurRow_pym["pymNote"];
    $pymCardStatus = $sCurRow_pym["pymCardStatus"];
  }
  
  // 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 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 ($pymCardType) {
    case "visa" : 
      $pymCardTypee = "Visa";
      break;
    case "mastercard" :
      $pymCardTypee = "Master Card";
      break;
    case "americanexpress" :
      $pymCardTypee = "American Express";
      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";
      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";
  }

// php codes ends ..............................................................................  
?>
    <html>
      <head>
        <script LANGUAGE="JavaScript1.1">
          function saveInfoFrm() {
            document.individual.mode.value = 'save';
            document.individual.action = 'individualInfo.php3';
            document.individual.submit();
          }
          
          function submitFormValue() {
            document.individual.mode.value = 'status';
            document.individual.action = 'individualInfo.php3';
            document.individual.submit();
          }
                    
          function viewParticipantList() {
            document.individual.action = 'usrAdministration.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">Indvidual Information - Full User Name</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>
	        <select NAME="anbTitle">
	          <option VALUE="<?php echo $anbTitle; ?>"></option>
	          <option VALUE="Dr">Dr</option>
	          <option VALUE="Prof">Prof</option>
	          <option VALUE="Mr">Mr</option>
	          <option VALUE="Ms">Ms</option>
	          <option VALUE="Mrs">Mrs</option>
	        </select>
	      </td>
	    </tr>
	    <tr>
	      <td><B>First Name:</B><font COLOR="#ff0000">*</font></td>
	      <td><input TYPE="text" NAME="anbFName" VALUE="<?php echo $anbFName; ?>" MAXLENGTH="40" SIZE="20"></td>
	    </tr>
	    <tr>
	      <td><B>Last Name:</B><font COLOR="#ff0000">*</font></td>
	      <td><input TYPE="text" NAME="anbLName" VALUE="<?php echo $anbLName; ?>" MAXLENGTH="40" SIZE="20"></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><input  TYPE="text" NAME="anbEmail" VALUE="<?php echo $anbEmail; ?>" MAXLENGTH="80" SIZE="40"></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><input TYPE="text" NAME="rgsTagName" VALUE="<?php echo $rgsTagName; ?>" MAXLENGTH="40" SIZE="50"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Institution on tag:</B><font COLOR="#ff0000">*</font></td>
   	      <td><input TYPE="text" NAME="rgsTagAddress" VALUE="<?php echo $rgsTagAddress; ?>" MAXLENGTH="45" SIZE="50"></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>
	        <select NAME="ctgID">
	          <option VALUE="<?php echo $ctgID; ?>"></option>
	          <option VALUE="umc2kFul">Full (UMC2K): US$100</option>
	          <option VALUE="umc2kStd">Student (UMC2K) US$50 (no discounts)</option>
	        </select>
	      </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>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>Type of card:</b></td>
	      <td>
	        <?php echo $pymCardTypee; ?>
              </td>
            </tr>
            <tr>
              <td><b>Name on card:</b></td>
              <td>
            	<?php echo $pymCardHolderName; ?>
              </td>
            </tr>
            <tr>
              <td><b>Card number:</b></td>
              <td>
            	<?php echo $pymCardNumber; ?>
              </td>
            </tr>
            <tr>
              <td><b>Expiry date:</b></td>
              <td>
            	<?php echo $pymCardExpiryDate; ?>
              </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>
  	        (Entered by participants - can be viewed/edited by them)
  	      </td>
  	      <td><textarea name="rgsNote" cols="55" rows="5"><?php echo $rgsNote; ?></textarea></td>
            </tr>
            <tr>
  	      <td>
  	        <b>Internal Memorandum:</b> <br>
  	        (Can only be viewed/edited by organizers)
  	      </td>
  	      <td><textarea name="rgsInternalNote" cols="55" rows="5"><?php echo $rgsInternalNote; ?></textarea></td>
            </tr>
            <tr>
              <td><b>Registration Category : </b></td>
              <td>
                <?php
                  echo "<font COLOR=\"#000000\" SIZE=\"-2\" FACE=\"arial\">";
                    echo "<select NAME=\"rgsStatus\" ONCHANGE=\"submitFormValue();\">";
                      echo "<option VALUE=\"\">".$rgsStatus."</option>";
                      echo "<option VALUE=\"rqs\">Requested</option>";
                      echo "<option VALUE=\"cnf\">Confirmed</option>";
                      echo "<option VALUE=\"del\">Deleted</option>";
                      echo "<option VALUE=\"wtd\">Withdrawn</option>";
                      echo "<option VALUE=\"pna\">Appr. reqd.</option>";
                    echo "</select>";
                  echo "</font>";
                ?>
              </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="pList" VALUE="Participant_List" ONCLICK="viewParticipantList();">
                      <input TYPE="submit" NAME="save" VALUE="Save_Changes" ONCLICK="saveInfoFrm();">
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
          </table>
        </form>
      </body>
    </html>