<?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...
    require ("./MOREfn.php3"); // include the functions file...
  }
  
  if (count($HTTP_POST_VARS) > 0) {
    while (list($key, $value) = each($HTTP_POST_VARS)) {
      ${$key} = $value;
    }  
  }
  
  if ($mode == "sts") {
    // we basically update the status of user to deleted..
    switch($chgStatus) {
      case "rqs" :
        $chgStatus = "requested";
        break;
      case "cnf" :
        $chgStatus = "confirmed";
        break;
      case "del" :
        $chgStatus = "deleted";
        break;
      case "wtd" :
        $chgStatus = "withdrawn";
        break;
      case "pna" :
        $chgStatus = "Appr. reqd.";
        break;  
    }
    $db_CMS->db_process_query("update",$rgsTbl,"rgsStatus = '$chgStatus'","none","rgsID = '$rgsID'","none");
  }

  switch ($viewBy) {
    case "vewAll" :
      $cndValue = "none";
      break;
    case "vewConfirmed" :
      $cndValue = "rgsStatus = 'confirmed'";
      break;
    case "vewPending" :
      $cndValue = "rgsStatus = 'Appr. reqd.'";
      break;
    case "vewRequested" :
      $cndValue = "rgsStatus = 'requested'";
      break;
    case "vewWithdrawn":
      $cndValue = "rgsStatus = 'withdrawn'";
      break;
    case "vewDeleted" :
      $cndValue = "rgsStatus = 'deleted'";
      break;
    case "vewDef" :
      $cndValue = "NOT (rgsStatus = 'deleted' or rgsStatus = 'withdrawn')";
      break;
    default :
      $cndValue = "NOT (rgsStatus = 'deleted' or rgsStatus = 'withdrawn')";
      break;
  }  
  
  // find out all participants registered for the umc2k conferences..
  switch ($orderBy) {
    case null :
      $orderBy = "rgsID";
      break;
    case "" :
      $orderBy = "rgsID";
      break;
  }
        
  if ($orderBy != "anbName") {
    $db_CMS->db_process_query("select",$rgsTbl,"*","none","$cndValue","$orderBy");
  }
  else {
    $db_CMS->db_process_query("select",$rgsTbl,"*","none","$cndValue","none");
  }
  
  $sRsltSet_rgs = $db_CMS->dbRsltSet;
  
  if ($db_CMS->dbNumRow > 0) { //ok there are people registered.. now find out details about them..
    $errFlag = false;
    $rowCount = 0; // initialize a counter..

    // list of coloumn names to be displayed..
    $colValue = array("ID","Full Name","Phone","Registration Date","Category","Status","anbodyID","paymentID","email","userName","tagName","tagAddress ");

    while ($sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet_rgs)) {
      $rgsID = $sCurRow_rgs["rgsID"];
      $anbID = $sCurRow_rgs["anbID"];
      $cnfID = $sCurRow_rgs["cnfID"];
      $pymID = $sCurRow_rgs["pymID"];
      $ctgID = $sCurRow_rgs["ctgID"];

      $rgsRegisterDate = $sCurRow_rgs["rgsRegisterDate"];
      $rgsStatus = $sCurRow_rgs["rgsStatus"];
      $rgsTagName = $sCurRow_rgs["rgsTagName"];
      $rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];

      // look up personal information for now..
      $db_CMS->db_process_query("select",$anbTbl,"*","none","anbID = '$anbID'","none");
      $sRsltSet_anb = $db_CMS->dbRsltSet;
      $sCurRow_anb = $db_CMS->db_fetch_array($sRsltSet_anb);

      // ok store the respective values...
      $rowValue[$rowCount][$colValue[0]] = $rgsID;
      
      $rowValue[$rowCount][$colValue[1]] .= $sCurRow_anb["anbTitle"];
      $rowValue[$rowCount][$colValue[1]] .= "&nbsp;".$sCurRow_anb["anbFName"];
      $rowValue[$rowCount][$colValue[1]] .="&nbsp;".$sCurRow_anb["anbLName"];
      
      $rowValue[$rowCount][$colValue[2]] = $sCurRow_anb["anbPhone"];
      $rowValue[$rowCount][$colValue[3]] = $rgsRegisterDate;
      $rowValue[$rowCount][$colValue[4]] = $ctgID;
      $rowValue[$rowCount][$colValue[5]] = $rgsStatus;
      $rowValue[$rowCount][$colValue[6]] = $anbID;
      $rowValue[$rowCount][$colValue[7]] = $pymID;
      $rowValue[$rowCount][$colValue[8]] = $sCurRow_anb["anbEmail"]; 
      $rowValue[$rowCount][$colValue[9]] = $sCurRow_anb["athUserName"];
      $rowValue[$rowCount][$colValue[10]] = $rgsTagName;
      $rowValue[$rowCount][$colValue[11]] = $rgsTagAddress;

      $rowCount++;
    }
    
    // let's do the sorting..here.. based on the orderby variable.. 
    // we only have to do it for full Name
    
    switch ($orderBy) {
      case "anbName" :
        // create a new array..
        for ($rowTmpCnt=0;$rowTmpCnt<count($rowValue);$rowTmpCnt++) {
          $rowTmpValue[$rowTmpCnt] = $rowValue[$rowTmpCnt][$colValue[1]];
        }
        asort($rowTmpValue);
        break;
    }
  }
  else {
    // list of coloumn names to be displayed..
    $colValue = array("ID","Full Name","Phone","Registration Date","Category","Status","anbodyID","paymentID","email","userName");
  
    $errMsg = "Sorry, registrations of this status are not present.";
    $errFlag = true;
  }
// php codes ends ..............................................................................  
?>
    <html>
      <head>
	<script LANGUAGE="JavaScript">
	  function submitFormValue(rgsID,ctgID,anbID,pymID,modeValue, countValue) {
	    document.administration.rgsID.value = rgsID;
	    document.administration.ctgID.value = ctgID;
	    document.administration.anbID.value = anbID;
	    document.administration.pymID.value = pymID;
	    if (modeValue == 'sts') {
	      myEvalString = 'optionIndex = document.administration.status'+countValue+'.selectedIndex;';
	      eval(myEvalString);
	      myEvalString = 'document.administration.chgStatus.value = document.administration.status'+countValue+'.options[optionIndex].value;';
	      eval(myEvalString);
	      document.administration.action='usrAdministration.php3';
              switch (document.administration.chgStatus.value) {
               case 'del' : // mark for deletion.. 
	         confirmMsg = 'You are about to delete a participant. Are you sure??';
	         if (confirm(confirmMsg)) {
	           document.administration.mode.value = 'sts';
	         }
	         else {
	           document.administration.mode.value = 'rld';
	         }
                 break;
               default :
	        document.administration.mode.value = 'sts';
	      }
	    }
	    else {
	      document.administration.action='individualInfo.php3';
	    }
	    document.administration.submit();
	  }
	 
	  function submitFinanceValue(pymID, anbID) {
	    document.administration.action='financialInfo.php3';
	    document.administration.pymID.value = pymID;
	    document.administration.searchField.value = anbID;
	    document.administration.submit();
	  }
	  
	  //Calls the participantFeesSummary.php3 file to bring up a full summary of participants
        function viewSummaryList() {
          document.administration.action = 'participantFeesSummary.php3';
          document.administration.submit();
        }
       
        </script>
      </head>
     
      <body BGCOLOR="#ffffcc">
  	<form NAME="administration" ACTION="usrAdministration.php3" METHOD="post">
  	  <table CELLSPACING="1" CELLPADDING="2" ALIGN="center" WIDTH="100%" BORDER="0" BGCOLOR="#bbbbbb">
  	    <tr>
  	      <td COLSPAN="7">
  		<font SIZE="+1">Participant Administration</font>
  	      </td>
  	    </tr>
  	    <input TYPE="hidden" NAME="rgsID" VALUE="">
  	    <input TYPE="hidden" NAME="ctgID" VALUE="">
  	    <input TYPE="hidden" NAME="anbID" VALUE="">
  	    <input TYPE="hidden" NAME="pymID" VALUE="">
            <input TYPE="hidden" NAME="passwdDel" VALUE="">
  	    <input TYPE="hidden" NAME="chgStatus" VALUE="">
  	    <input TYPE="hidden" NAME="mode" VALUE="">
  	    <input TYPE="hidden" NAME="searchField" VALUE="">
 
<?php
// php code starts here..............................................................
  	    $colCount = count($colValue)-6; // get the number of columns.
  	    echo "<tr BGCOLOR=\"#4444dd\" WIDTH=\"100%\">";
  	      // create the coloumn names...
  	      for ($count=0;$count<$colCount;$count++) {
  		echo "<td>";
  		  echo "<font COLOR=\"#ffffff\" SIZE=\"-1\" FACE=\"arial\"><b>".$colValue[$count]."</b></font>";
  		echo "</td>";
  	      }
  	      echo "<td>";
  		echo "&nbsp;";
  	      echo "</td>";
  	    echo "</tr>";
 
  	    if ($errFlag) {
  	      echo "<tr bgColor=\"#9999cc\">";
  		echo "<td COLSPAN=\"7\">";
  		  echo $errMsg;
  		echo "</td>";
  	      echo "</tr>";
  	    }
  	    else {
  	      // lets print their respective values...........
  	      if (count($rowTmpValue) > 0) {
  		reset($rowTmpValue);
  		$countX = 0;
  		while (list($key,$value) = each($rowTmpValue)) {
  		  if (($rowValue[$key][$colValue[5]] == "deleted") || ($rowValue[$key][$colValue[5]] == "withdrawn")){
  		    echo "<tr bgColor=\"#cc9999\">";
  		  }
  		  else {
  		    if ($rowValue[$key][$colValue[5]] == "confirmed") {
  		      echo "<tr bgColor=\"#99cc99\">";
  		    }
  		    else {
  		      echo "<tr bgColor=\"#9999cc\">";
  		    }
  		  }
  		  for ($countY=0;$countY<$colCount;$countY++) {
  		    if ($rowValue[$key][$colValue[$countY]] == "") {
  		      $rowValue[key][$colValue[$countY]] = "&nbsp;";
  		    }
  		    echo "<td>";
  		      echo "<font COLOR=\"#000000\" SIZE=\"-1\" FACE=\"arial\">";
  		        switch ($countY) {
  		          case 0 :
  		            echo $countX+1;
  		            break;
  		          case 1 :
  		            echo "<a HREF=\"mailto:".$rowValue[$key][$colValue[8]]."\">".$rowValue[$key][$colValue[$countY]]."</a>";
  		            echo "<script LANGUAGE=\"javascript\">\n";
  		            echo "  var myUrlPDF = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME='+escape('".$rowValue[$key][$colValue[10]]."')+'&INSTITUTION='+escape('".$rowValue[$key][$colValue[11]]."')+'&CONFERENCE=UMC2K - Unconventional Models of Computation&FORMAT=PDF\"><img BORDER=\"0\" SRC=\"images/pdftag.gif\"></a>';";
  		            echo "  var myUrlPS = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME='+escape('".$rowValue[$key][$colValue[10]]."')+'&INSTITUTION='+escape('".$rowValue[$key][$colValue[11]]."')+'&CONFERENCE=UMC2K - Unconventional Models of Computation&FORMAT=PS\"><img BORDER=\"0\" SRC=\"images/pstag.gif\"></a>';"; 		              		            
  		            echo "  document.write('<font SIZE=\"-2\">Name tag in ');";
  		            echo "  document.write(myUrlPDF);";
  		            echo "  document.write(' or ');";
  		            echo "  document.write(myUrlPS);";
  		            echo "  document.writeln('</font>');";
                            echo "</script>";
  		            break;
  		          case 5 :
  		            echo "<font COLOR=\"#000000\" SIZE=\"-2\" FACE=\"arial\">";
		              echo "<select NAME=\"status".$key."\" WIDTH=\"10\" ONCHANGE=\"submitFormValue('".$rowValue[$key][$colValue[0]]."','".$rowValue[$key][$colValue[4]]."','".$rowValue[$key][$colValue[6]]."','".$rowValue[$key][$colValue[7]]."','sts', '$key');\">";
		                echo "<option VALUE=\"\">".$rowValue[$key][$colValue[$countY]]."</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>";
		            break;
  		          default :
  		            echo $rowValue[$key][$colValue[$countY]];
  		        }
  		      echo "</font>";
  		    echo "</td>";
  		  }
  		    echo "<td>";
  		      echo "<input TYPE=\"submit\" NAME=\"personal".$key."\" VALUE=\"personal\" ONCLICK=\"submitFormValue('".$rowValue[$key][$colValue[0]]."','".$rowValue[$key][$colValue[4]]."','".$rowValue[$key][$colValue[6]]."','".$rowValue[$key][$colValue[7]]."','vew', '$key');\">";
  		      echo "<br>";
		      echo "<input TYPE=\"submit\" NAME=\"financial".$key."\" VALUE=\"financial\" ONCLICK=\"submitFinanceValue('".$rowValue[$key][$colValue[7]]."','".$rowValue[$key][$colValue[9]]."');\">";
		    echo "</td>";
		    $countX++; // increment the row counter...
		  echo "</tr>";
	        }
	      }
	      else {
	        $rowCount = count($rowValue);
	        for ($countX=0;$countX<$rowCount;$countX++) {
	   	  if (($rowValue[$countX][$colValue[5]] == "deleted") || ($rowValue[$countX][$colValue[5]] == "withdrawn")){
		    echo "<tr bgColor=\"#cc9999\">";
		  }
		  else {
		    if ($rowValue[$countX][$colValue[5]] == "confirmed") {
		      echo "<tr bgColor=\"#99cc99\">";
		    }
		    else {
		      echo "<tr bgColor=\"#9999cc\">";
		    }
		  }
		  for ($countY=0;$countY<$colCount;$countY++) {
		    if ($rowValue[$countX][$colValue[$countY]] == "") {
		      $rowValue[$countX][$colValue[$countY]] = "&nbsp;";
		    }
  		    echo "<td>";
  		      echo "<font COLOR=\"#000000\" SIZE=\"-1\" FACE=\"arial\">";
  		        switch ($countY) {
  		          case 0 :
  		            echo $countX+1;
  		            break;
  		          case 1 :
  		            echo "<a HREF=\"mailto:".$rowValue[$countX][$colValue[8]]."\">".$rowValue[$countX][$colValue[$countY]]."</a><br>";
  		            echo "<script LANGUAGE=\"javascript\">\n";
  		            echo "  var myUrlPDF = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME='+escape('".$rowValue[$countX][$colValue[10]]."')+'&INSTITUTION='+escape('".$rowValue[$countX][$colValue[11]]."')+'&CONFERENCE=UMC2K - Unconventional Models of Computation&FORMAT=PDF\"><img BORDER=\"0\" SRC=\"images/pdftag.gif\"></a>';";
  		            echo "  var myUrlPS = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME='+escape('".$rowValue[$countX][$colValue[10]]."')+'&INSTITUTION='+escape('".$rowValue[$countX][$colValue[11]]."')+'&CONFERENCE=UMC2K - Unconventional Models of Computation&FORMAT=PS\"><img BORDER=\"0\" SRC=\"images/pstag.gif\"></a>';";
  		            echo "  document.write('<font SIZE=\"-2\">Name tags in ');";
  		            echo "  document.write(myUrlPDF);";
  		            echo "  document.write(' or ');";
  		            echo "  document.write(myUrlPS);";
  		            echo "  document.writeln('</font>');";
                            echo "</script>";
  		            break;
  		          case 5 :
  		            echo "<font COLOR=\"#000000\" SIZE=\"-2\" FACE=\"arial\">";
		              echo "<select NAME=\"status".$countX."\" ONCHANGE=\"submitFormValue('".$rowValue[$countX][$colValue[0]]."','".$rowValue[$countX][$colValue[4]]."','".$rowValue[$countX][$colValue[6]]."','".$rowValue[$countX][$colValue[7]]."','sts', '$countX');\">";
		                echo "<option VALUE=\"\">".$rowValue[$countX][$colValue[$countY]]."</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>";
		            break;
  		          default :
  		            echo $rowValue[$countX][$colValue[$countY]];
  		            break;
  		        }
  		      echo "</font>";
  		    echo "</td>";
  		  }
  		  echo "<td>";
  		    echo "<font COLOR=\"#000000\" SIZE=\"-2\" FACE=\"arial\">";
   		      echo "<input TYPE=\"submit\" NAME=\"personal".$countX."\" VALUE=\"personal\" ONCLICK=\"submitFormValue('".$rowValue[$countX][$colValue[0]]."','".$rowValue[$countX][$colValue[4]]."','".$rowValue[$countX][$colValue[6]]."','".$rowValue[$countX][$colValue[7]]."','vew','$countX');\">";
   		      echo "<br>";
   		      echo "<input TYPE=\"submit\" NAME=\"financial".$countX."\" VALUE=\"financial\" ONCLICK=\"submitFinanceValue('".$rowValue[$countX][$colValue[7]]."','".$rowValue[$countX][$colValue[9]]."');\">";
   		    echo "</font>";
   		  echo "</td>";
  		echo "</tr>";
  	      }
	    }
	  }
  	      echo "<tr>";
  	        echo "<td COLSPAN=\"2\">";
  	          echo "Order By : <br>";
  	          echo "<select NAME=\"orderBy\" onChange=\"document.administration.submit();\">";
  	  	    echo "<option VALUE=\"".$orderBy."\"></option>";
  		    echo "<option VALUE=\"anbName\">Name</option>";
  		    echo "<option VALUE=\"rgsStatus\">Status</option>";
  		    echo "<option VALUE=\"ctgID\">Category</option>";
  		    echo "<option VALUE=\"rgsRegisterDate\">Registration Date</option>";
  	          echo "</select>";
  	        echo "</td>";
 
  	        echo "<td COLSPAN=\"1\">";
  	          echo "View by status : <br>";
  	          echo "<select NAME=\"viewBy\" onChange=\"document.administration.submit();\">";
  	  	    echo "<option VALUE=\"".$viewBy."\"></option>";
  	  	    echo "<option VALUE=\"vewDef\">Default</option>";
  		    echo "<option VALUE=\"vewConfirmed\">Confirmed</option>";
  		    echo "<option VALUE=\"vewPending\">Appr. reqd.</option>";
  		    echo "<option VALUE=\"vewRequested\">Requested</option>";
  		    echo "<option VALUE=\"vewWithdrawn\">Withdrawn</option>";
  		    echo "<option VALUE=\"vewDeleted\">Deleted</option>";
                    echo "<option VALUE=\"vewAll\">All</option>";
  	          echo "</select>";
  	        echo "</td>";
 
                echo "<td COLSPAN=\"1\">";
    		  echo "<input TYPE=\"submit\" NAME=\"sList\" VALUE=\"Summary List\" ONCLICK=\"viewSummaryList();\">";
    	        echo "</td>";
    	        
  	        echo "<td COLSPAN=\"1\">";
  	          echo "<input TYPE=\"submit\" NAME=\"refresh\" VALUE=\"Refresh\" onClick=\"document.administration.submit();\">";
  	        echo "</td>";
  	      echo "</tr>";
// php code ends here..
?>    	     
          </table>
        </form>
      </body>
    </html>