<?php 
// The script in this file generates a form that is filled with the personal details of a participant.
// The form is shown only to organizers and can be used to change and save participant details.
//
// 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..
  include ("./DBDYNHTMLFUNCTIONS.php");
   
  if (sizeof($HTTP_POST_VARS) > 0) { 
    while (list($key, $value) = each($HTTP_POST_VARS)) {
      if (($magic_quotes_gpc_off) && (! $slashesadded)){
	$value = addslashes($value);
      }
      ${$key} = $value;
    }
  }
  $slashesadded = true;
  
  //authenticate user....
  $db_CMS->db_process_query("select", $athTbl, "*", "none", "athUserName = '$usernm' and athPassword = '$passwd' and athLevel = 'organizer'", "none"); 
  
  $db_CMS->dbNumRow = 1;
  if ($db_CMS->dbNumRow == 0) {
   // error something wrong..... reset the whole page...
   echo "something wrong";
  }
  else {
    if ($mode == "save") {
      if ($athUserName != '') {
        // save registration information ...
        $fldName = "rgsParticipantNote = '$rgsParticipantNote', rgsInternalNote = '$rgsInternalNote', rgsTagName = '$rgsTagName', rgsTagAddress = '$rgsTagAddress', rgsCategory='$rgsCategory'";    
        $db_CMS->db_process_query("update", $rgsTbl, $fldName, "none","athUserName = '$athUserName'", "none");

	// save password information
	$fldName = "athUserName = '$athUserNameOfParticipant',athPassword = '$athPasswordForParticipant'";    
        $db_CMS->db_process_query("update", $athTbl, $fldName, "none","athUserName = '$athUserName'", "none");

        // save anybody information ....
        $fldName = "anbTitle = '$anbTitle',anbFName = '$anbFName',anbLName = '$anbLName',anbAddress = '$anbAddress',anbEmail = '$anbEmail',anbSEmail = '$anbSEmail',anbPCode = '$anbPCode',anbCountry = '$anbCountry'";
        $db_CMS->db_process_query("update", $anbTbl, $fldName, "none","athUserName = '$athUserName'", "none");
    
        // save miscellaneous information ....
        $fldName = "mscDescription = '$mondayPlan'";
        $db_CMS->db_process_query("update", $mscTbl, $fldName, "none","mscID = '$mscMPID'", "none");

	// update registration category - this is messy because we need to arrange for a refund if required.
	if ($rgsCategory != $rgsCategoryOld) {
  	  // First, get the descriptions, prices etc. for the two registration categories involved:
	  // For the new category...
          $db_CMS->db_process_query("select",$ctgTbl,"*","none","ctgShortName = '$rgsCategory'","none");
	  $sRsltSet_ctg = $db_CMS->dbRsltSet;
   
          if ($db_CMS->dbNumRow > 0) { //ok we found the registration..
            $sCurRow_ctg = $db_CMS->db_fetch_array($sRsltSet_ctg);  
            $ctgName = $sCurRow_ctg["ctgName"];
            $ctgCost = $sCurRow_ctg["ctgCost"];
            $ctgDescription = $sCurRow_ctg["ctgDescription"];	
	  }	
	  // For the old category...
          $db_CMS->db_process_query("select",$ctgTbl,"*","none","ctgShortName = '$rgsCategoryOld'","none");
	  $sRsltSet_ctg = $db_CMS->dbRsltSet;
   
          if ($db_CMS->dbNumRow > 0) { //ok we found the registration..
            $sCurRow_ctg = $db_CMS->db_fetch_array($sRsltSet_ctg);  
            $ctgNameOld = $sCurRow_ctg["ctgName"];
            $ctgRefund = $sCurRow_ctg["ctgCost"];
            $ctgDescriptionOld = $sCurRow_ctg["ctgDescription"]." - Refund";	
	  }	
	  // now update the orderLine table
	  // refund:
          $db_CMS->db_process_query("insert", $odlTbl, "odlName, odlDescription, odlPrice, odlEntryType, odlStartDate, odlEndDate, rgsID, odlOrderedAmount","'$ctgNameOld','$ctgDescriptionOld','$ctgRefund','Cr','2000-12-13','2000-12-16','$rgsID',1","none","none"); 
       	  // charge for new category:
          $db_CMS->db_process_query("insert", $odlTbl, "odlName, odlDescription, odlPrice, odlEntryType, odlStartDate, odlEndDate, rgsID, odlOrderedAmount","'$ctgName','$ctgDescription','$ctgCost','Dr','2000-12-13','2000-12-16','$rgsID',1","none","none"); 
	}
      }
    }
  
    // get the registration details....
    $db_CMS->db_process_query("select",$rgsTbl,"*","none","athUserName = '$athUserName'","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);  
      
      $rgsID = $sCurRow_rgs["rgsID"];
      $pymID = $sCurRow_rgs["pymID"];
      $rgsStatus = $sCurRow_rgs["rgsStatus"];
      $rgsCategory = $sCurRow_rgs["rgsCategory"];
      $rgsParticipantNote = $sCurRow_rgs["rgsParticipantNote"];
      $rgsInternalNote = $sCurRow_rgs["rgsInternalNote"];
	$rgsTagName = $sCurRow_rgs["rgsTagName"];
	$rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];
    }
    else {
	echo "Partipant record not found!";
    }
    
    // get the participant details....
    $db_CMS->db_process_query("select",$athTbl,"*","none","athUserName = '$athUserName'","none");
    $sRsltSet_ath = $db_CMS->dbRsltSet;
    if ($db_CMS->dbNumRow > 0) { //ok we found the user..
	$sCurRow_ath = $db_CMS->db_fetch_array($sRsltSet_ath);
        $athUserName_ofParticipant = $sCurRow_ath["athUserName"];
    	$athPassword_forParticipant = $sCurRow_ath["athPassword"];
    }	

    // get address details
    $db_CMS->db_process_query("select",$anbTbl,"*","none","athUserName = '$athUserName'","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"];
      $anbAddress = $sCurRow_anb["anbAddress"];
      $anbPCode = $sCurRow_anb["anbPCode"];
      $anbCountry = $sCurRow_anb["anbCountry"];
      $anbEmail = $sCurRow_anb["anbEmail"];
      $anbSEmail = $sCurRow_anb["anbSEmail"];
    }
  
    
    // 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"];
      $pymParticipantNote = $sCurRow_pym["pymParticipantNote"];
      $pymCardStatus = $sCurRow_pym["pymCardStatus"];
    }
  
    // get the miscellaneous 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..
      while ($sCurRow_msc = $db_CMS->db_fetch_array($sRsltSet_msc)) {  
        switch ($sCurRow_msc["mscName"]) {
          case "Monday plan" :
            $mscMPID=$sCurRow_msc["mscID"];  // monday plan...
            $mondayPlan=$sCurRow_msc["mscDescription"];
            break;
        }
      }
    }
  
    // represent some the short forms in understandable format... 
    switch ($rgsCategory) {
      case "Full" :
        $rgsCategoryE = "Full Registration: US$100";
        break;
      case "Stdn" :
        $rgsCategoryE = "Student Registration: US$50";
        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 "other" :
        $pymMethode = "other (approval required)";
        break;
      case "inv" :
        $pymMethode = "invited speaker";
        break;
    }
    
    if ($pymParticipantNote == "") {
      $pymParticipantNote = "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 viewParticipantList() {
            document.individual.action = 'usrAdministration.php3';
            document.individual.submit();
          }
        </script>
      </head>
      <body BGCOLOR="#ffffff">
        <form name="individual" action="" method="POST">
   	  <table CELLSPACING="1" CELLPADDING="2" ALIGN="center" WIDTH="800" BORDER="0" BGCOLOR="#ffffff">
   	    <tr>
   	      <td COLSPAN="2" BGCOLOR="#99cccc">
   		<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 htmlspecialchars($anbFName,ENT_QUOTES); ?>" 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 htmlspecialchars($anbLName,ENT_QUOTES); ?>" MAXLENGTH="40" SIZE="20"></td>
	    </tr>
	    <tr>
   	      <td><B>Address:</B><font COLOR="#ff0000">*</font></td>
   	      <td><textarea NAME="anbAddress" cols="30" rows="4"><?php echo htmlspecialchars($anbAddress,ENT_QUOTES); ?></textarea></td>
   	    </tr>
	    <tr>
	      <td><B>Username:</B><font COLOR="#ff0000">*</font></td>
	      <td><input TYPE="text" NAME="athUserNameOfParticipant" VALUE="<?php echo htmlspecialchars($athUserName_ofParticipant,ENT_QUOTES); ?>" MAXLENGTH="40" SIZE="20"></td>
	    </tr>
	    <tr>
	      <td><B>Password:</B><font COLOR="#ff0000">*</font></td>
	      <td><input TYPE="text" NAME="athPasswordForParticipant" VALUE="<?php echo $athPassword_forParticipant; ?>" MAXLENGTH="40" SIZE="20"></td>
	    </tr>
   	    <tr>
   	      <td><B>Country:</B><font COLOR="#ff0000">*</font></td>
   	      <td><input TYPE="text" NAME="anbCountry" VALUE="<?php echo htmlspecialchars($anbCountry,ENT_QUOTES); ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>PostCode:</B></td>
   	      <td><input TYPE="text" NAME="anbPCode" VALUE="<?php echo htmlspecialchars($anbPCode,ENT_QUOTES); ?>" 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 htmlspecialchars($anbEmail,ENT_QUOTES); ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Alternative E-mail:</B></td>
   	      <td><input  TYPE="text" NAME="anbSEmail" VALUE="<?php echo htmlspecialchars($anbSEmail,ENT_QUOTES); ?>" MAXLENGTH="80" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Name on name tag:</B></td>
   	      <td><input  TYPE="text" NAME="rgsTagName" VALUE="<?php echo htmlspecialchars($rgsTagName,ENT_QUOTES); ?>" MAXLENGTH="50" SIZE="40"></td>
   	    </tr>
   	    <tr>
   	      <td><B>Address on name tag:</B></td>
   	      <td><input  TYPE="text" NAME="rgsTagAddress" VALUE="<?php echo htmlspecialchars($rgsTagAddress,ENT_QUOTES); ?>" MAXLENGTH="50" SIZE="40"></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>
                <input TYPE="hidden" NAME="rgsCategoryOld" VALUE="<?php echo $rgsCategory; ?>">
	        <?php echo generateCategorySelectList($rgsCategory); ?><br>
	      </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 htmlspecialchars($pymCardHolderName,ENT_QUOTES); ?>
              </td>
            </tr>
            <tr>
              <td><b>Card number:</b></td>
              <td>
            	<?php echo htmlspecialchars($pymCardNumber,ENT_QUOTES); ?>
              </td>
            </tr>
            <tr>
              <td><b>Expiry date:</b></td>
              <td>
            	<?php echo htmlspecialchars($pymCardExpiryDate,ENT_QUOTES); ?>
              </td>
            </tr>
            <tr>
              <td><b>Special Payment Notes:</b></td>
              <td><?php echo htmlspecialchars($pymParticipantNote,ENT_QUOTES); ?></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="rgsParticipantNote" cols="55" rows="5"><?php echo htmlspecialchars($rgsParticipantNote,ENT_QUOTES); ?></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 htmlspecialchars($rgsInternalNote,ENT_QUOTES); ?></textarea></td>
            </tr>
            
   	    <input TYPE="hidden" NAME="rgsID" VALUE="<?php echo $rgsID; ?>">
   	    <input TYPE="hidden" NAME="athUserName" VALUE="<?php echo $athUserName; ?>">
   	    <input TYPE="hidden" NAME="usernm" VALUE="<?php echo $usernm; ?>">
   	    <input TYPE="hidden" NAME="passwd" VALUE="<?php echo $passwd; ?>">
   	    <input TYPE="hidden" NAME="mscMPID" VALUE="<?php echo $mscMPID; ?>">
   	    <input TYPE="hidden" NAME="mode" VALUE="">   	    
          </table>
          
          <table CELLSPACING="1" CELLPADDING="2" BORDER="0"  ALIGN="center" WIDTH="800" BGCOLOR="#99cccc">
            <tr>
              <td>
                <table CELLSPACING="1" CELLPADDING="2" BORDER="0" WIDTH="100%" BGCOLOR="#99cccc">
                  <tr>
                    <td COLSPAN="2" ALIGN="center" BGCOLOR="#99cccc">
                      <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>
<?php
  }
?>