<?php 
// The script in this file is used to extract a participant record from the database and
// present it to the participant for editing. Only some fields are editable.
//
// php code starts here........................................................................
  if ($includeConfigFlag == 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...
  }
  
  if (sizeof($HTTP_GET_VARS) > 0) {
    while (list($key, $value) = each($HTTP_GET_VARS)) {
      if (($magic_quotes_gpc_off) && (! $slashesadded)){
	$value = addslashes($value);
      }
      ${$key} = $value;
    }
  }
  
  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 = '$athUserName' and athPassword = '$athPassword'", "none"); 
  
  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', rgsTagName = '$rgsTagName', rgsTagAddress = '$rgsTagAddress'";    
        $db_CMS->db_process_query("update", $rgsTbl, $fldName, "none","athUserName = '$athUserName'", "none");

        // save anybody information ....
        $fldName = "anbAddress = '$anbAddress', 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");
      }
    }
  
    // 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"];
	$rgsTagName = $sCurRow_rgs["rgsTagName"];
	$rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];
    }
    
    // get the participant 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);  
      $pymMethod = $sCurRow_pym["pymMethod"];    
      $pymParticipantNote = $sCurRow_pym["pymParticipantNote"];
    }
    
    // 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: NZ$500";
        break;
      case "Stdn" :
        $rgsCategoryE = "Student Registration: NZ$400";
        break;
    }
  
    switch ($pymMethod) {
      case "crd" : 
        $pymMethodE = "credit card";
        break;
      case "cbd" :
        $pymMethodE = "cheque/bank draft by mail";
        break;
      case "inv" :
        $pymMethodE = "invoice";
        break;
    }
    
    switch ($mondayPlan) {
      case "none" :
        $mondayPlanE = "I have other plans";
        break;
      case "seakayak" :
        $mondayPlanE = "I would like to make a booking for the sea-kayak trip to rangitoto";
        break;
      case "skycity" :
        $mondayPlanE = "I would like to make a dinner reservation at the revolving restaurant in the Sky City Tower";
        break;
    }
  
    if ($pymParticipantNote == "") {
      $pymParticipantNote = "none";
    }
  
    if ($rgsParticipantNote == "") {
      $rgsNote = "none";
    }

// php codes ends ..............................................................................  
?>
    <html>
      <head>
        <script LANGUAGE="JavaScript1.1">
          function saveInfoFrm() {
            document.individual.mode.value = 'save';
            document.individual.action = 'participantView.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">
   		  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="anbAddress" cols="30" rows="4"><?php echo htmlspecialchars($anbAddress,ENT_QUOTES); ?></textarea></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><?php echo $anbEmail; ?></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="80" 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="80" 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>
	        <?php echo $rgsCategoryE; ?><br>
	      </td>
	    </tr>
            <tr>
   	      <td COLSPAN="2" BGCOLOR="#999999">
   		<font SIZE="+1">Total Costs :</font>
   	      </td>
   	    </tr>

<?php
            // get the activity Details.....
            $db_CMS->db_process_query("select", $odlTbl, "*", "none", "rgsID = '$rgsID'", "odlID");
            $sRsltSet_odl = $db_CMS->dbRsltSet;
    
            while ($sCurRow_odl = $db_CMS->db_fetch_array($sRsltSet_odl)) {
              $odlName = $sCurRow_odl['odlName'];
              $odlPrice = $sCurRow_odl['odlPrice'];

              // Price is actually ticket_price * num_of_tick - Vincent
              if ($odlName == 'Extra Tickets')
                 $odlPrice = $odlPrice * $sCurRow_odl['odlOrderedAmount'];
                
              echo "<tr>";
                echo "<td>$odlName :</td>";
                echo "<td>NZ$ $odlPrice</td>";
              echo "</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 $pymParticipantNote; ?></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="rgsParticipantNote" cols="55" rows="5"><?php echo htmlspecialchars($rgsParticipantNote,ENT_QUOTES); ?></textarea></td>
            </tr>
   	    <input TYPE="hidden" NAME="athUserName" VALUE="<?php echo $athUserName; ?>">
   	    <input TYPE="hidden" NAME="athPassword" VALUE="<?php echo $athPassword; ?>">
   	    <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="save" VALUE="Save_Changes" ONCLICK="saveInfoFrm();">
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
          </table>
        </form>
      </body>
    </html>
<?php
// php code starts here......   
  }
// php code ends here........
?>