editPCRproducts.php | searchcode

/ collman/editPCRproducts.php

http://collman.googlecode.com/
PHP | 198 lines | 139 code | 36 blank | 23 comment | 21 complexity | 563805680f0e4dd03c188d473d82e696 MD5 | raw file

<?php

//=========== HEADER STUFF ========

	$Title = "Edit PCR products";

	$PageName = "Edit PCR products";

	$JavaScript = "ajaxValidator.js"; //ajax script updates locality information

//	$JavaScript = "localityInfo.js"; //ajax script updates locality information

//	$JavaScriptA = "validateInfo.js"; //ajax script validates Scientific Name

//	$JavaScriptB = "namesInfo.js"; //ajax script validates Scientific Name

	require("ta_header.inc");

	if($session->logged_in){

	   echo "<p style=\"color:white;font-size:14px;position:absolute;top:50px;right:20px;\">Logged in:<strong>$session->username</strong><br />";

  	 echo "[<a style='color:white;' href=\"login_process.php\">Logout</a>]";

	}

	else {

		include("ta_loginform.inc");

		exit; 

	}



//============ POST/GET VARIABLES ============

	$FormData =$_REQUEST['FormData'];

	$Category = $_REQUEST['Category'];

  $Task	= $_REQUEST['Task'];

	$OrderBy = $_REQUEST['OrderBy'];

	

	$tissuePcrProductID = $_REQUEST['tissuePcrProductID'];

	$tissueDnaExtractID = $_REQUEST['tissueDnaExtractID'];

	$datePcred = $_REQUEST['datePcred'];

	$pcredBy = $_REQUEST['pcredBy'];

	$pcrProtocol= $_REQUEST['pcrProtocol'];

	$pcrPrimerF= $_REQUEST['pcrPrimerF'];

	$pcrPrimerR= $_REQUEST['pcrPrimerR'];

  $pcrProductStorageStatus= $_REQUEST['pcrProductStorageStatus'];

  $timeStamp= $_REQUEST['timeStamp'];

  $enteredBy= $_REQUEST['enteredBy'];

  $lastModified= $_REQUEST['lastModified'];

  $modifiedBy= $_REQUEST['modifiedBy'];

  $tissuePcrProductRemarks= $_REQUEST['tissuePcrProductRemarks'];	



	if (empty($tissuePcrProductID)) {

		$tissuePcrProductID=$FormData;

	}

	

	if(empty($Category)) {$Category ='tissuePcrProductID';}

	if(empty($OrderBy)) {$OrderBy ='tissuePcrProductID';}



	if ($session->userlevel == 9) {

	$userlevel = "Administrator";	 }

	elseif ($session->userlevel == 1) {

	$userlevel = "Guest";	 }

	else 

	$userlevel = "User";

	

//===== OPEN DATABASE ============	

  include("ta_opendb.inc");

	include("ta_fn_dropdownfield.inc");



//===== IN CASE UPDATE REQUESTED: UPDATE ===========	

  if ($Task == "Update") {

		$tissueNumber = $FormData;

		

		// Get and show Old data

		$sql= mysqli_query($dbcnx, "SELECT tissueDnaExtractID, datePcred from tissuepcrproducts WHERE tissuePcrProductID ='$tissuePcrProductID'");

		if($row = mysqli_fetch_row($sql)){

			echo "<p style='color:white;background-color:red;font-size:12px;'>Box updated from ".$row[0]; }

  	// Update operation

		mysqli_query($dbcnx, "UPDATE tissuepcrproducts SET tissueDnaExtractID ='".$tissueDnaExtractID."', datePcred = '".$datePcred."', pcrProtocol='".$pcrProtocol."', pcrPrimerF='".$pcrPrimerF."', pcrPrimerR = '$pcrPrimerR', pcrProductStorageStatus ='".$pcrProductStorageStatus."', tissuePcrProductRemarks='".$tissuePcrProductRemarks."', lastModified = CURRENT_TIMESTAMP, modifiedBy ='".$session->username."' WHERE tissuePcrProductID = '$tissuePcrProductID'"); 

		// Get and show NEW Data	

		$sql= mysqli_query($dbcnx, "SELECT tissueDNAExtractID from tissuepcrproducts  WHERE tissuePcrProductID ='$tissuePcrProductID'");

		if($row = mysqli_fetch_row($sql)){

			echo " to ".$row[0]."</p>"; }

  } //if task



// ====== DISPLAY EDITABLE FORM ========================  

  if(isset($_REQUEST['FormData'])){

	

    $res = mysqli_query($dbcnx, "SELECT * FROM tissuepcrproducts WHERE $Category = $FormData ORDER BY $OrderBy") or die(mysql_error());

  

    	if($inf = mysqli_fetch_array($res)){

			

//announcement line will not show on one line in print

				echo "<div style=\"font-size:0.8em;color:blue;\">";

  			echo "<div class=\"lefthalf\">Editing PCR product Number: ". $inf["tissuePcrProductID"]." as $userlevel</div>";

				echo "<div class=\"righthalf\">Search field = $Category, Sorted by $OrderBy</div>";

				echo "</div>";

				echo "<div class=\"spacer\">&nbsp;</div>";

			

				$sql= mysqli_query($dbcnx, "SELECT scientificName FROM objects WHERE catalogNumber = '".$inf["catalogNumber"]."'");

				if($row = mysqli_fetch_row($sql)){

					echo "<div class=\"infohead\" id=\"infohead\">Species: <i>".$row[0]."</i></div>";

				} 	

// ====== FORM ITSELF

        	echo "<form class=\"main\" method=\"POST\" name=\"frmPCREdit\" action=\"$_SERVER[PHP_SELF]?FormData=".$inf["tissuePcrProductID"]."\">";



// ====== PRIMARY KEY          

					echo "<p><label for =\"tissuePcrProductID\" style=\"font-size:1.4em;font-weight:600;\">PCR Product No: </label><input style=\"text-align:left;font-size:1.4em;font-weight:600;border:0;background-color:#cccccc;\" type=\"text\" name=\"tissuePcrProductID\" size=\"2\" value='".$inf["tissuePcrProductID"]."' readonly>";



					echo "<br />\n";

					dropdownfield("tissueDnaExtractID","tissuednaextracts","tissueDnaExtractID :","".$inf['tissueDnaExtractID']."");



        	echo "<label for=\"datePcred\">Date processed :</label><input type=\"text\" name=\"datePcred\" id=\"datePcred\" size=\"16\" value='".$inf["datePcred"]."' onchange=\"requestValidation('datePcred')\" onkeypress=\"return handleEnter(this, event)\">";



					echo "<label for=\"pcredBy\">Processed By :</label><input type=\"text\" name=\"pcredBy\" id=\"pcredBy\" size=\"30\" value='".$inf["pcredBy"]."' onchange=\"requestValidation('pcredBy')\" onkeypress=\"return handleEnter(this, event)\">"; 

					

					echo "<br />\n";

					inputfield("pcrProtocol","Protocol","text","30","30","".$inf['pcrProtocol']."");

					inputfield("pcrPrimerF","Forward Primer","text","30","30","".$inf['pcrPrimerF']."");

					inputfield("pcrPrimerR","Backward Primer","text","30","30","".$inf['pcrPrimerR']."");

					

										echo "<br />\n";

					inputfield("pcrProductStorageStatus","Storage Status","text","30","30","".$inf['pcrProductStorageStatus']."");



// ====== ADMINISTRATIVE BLOCK         					

          echo "<br /><label for=\"timeStamp\">Time Stamp :</label><input type=\"text\" name=\"timeStamp\" size=\"20\" value='".$inf["timeStamp"]."' onkeypress=\"return handleEnter(this, event)\" readonly>";

          echo "<label for=\"enteredBy\">Entered By: </label><input type=\"text\" name=\"enteredBy\" size=\"30\" value='".$inf["enteredBy"]."' onkeypress=\"return handleEnter(this, event)\" readonly>";

					if (!$inf["lastModified"] == NULL) {

          echo "<label for=\"lastModified\">Last Modified: </label><input type=\"text\" name=\"lastModified\" size=\"20\" value='".$inf["lastModified"]."' onkeypress=\"return handleEnter(this, event)\" readonly>";

          echo "<label for=\"modifiedBy\">Modified By: </label><input type=\"text\" name=\"modifiedBy\" size=\"30\" value='".$inf["modifiedBy"]."' onkeypress=\"return handleEnter(this, event)\" readonly>";

          }

// ====== REMARKS

					echo "</p><p><label for=\"tissuePcrProductRemarks\" style=\"float:left\">PCR Remarks: </label><textarea name=\"tissuePcrProductRemarks\" wrap=\"virtual\" cols=\"130\" rows=\"2\" >".$inf["tissuePcrProductRemarks"]."</textarea></p>";

// ====== BUTTONS

          echo "<p<input type=\"submit\" value=\"Update\" name=\"Task\"><input type=\"reset\" name=\"Cancel\" value=\"Reset\"></p></form>";

		  ;} 	

	 }



// ====== BLOCK OF LOOKUPDATA ==============



	echo "<div class=\"lookup\" id=\"lookup\">";

		echo "<div id=\"divConfirmation\"></div>";



// ====== SHOW TAXON INFORMATION

		$sql =mysqli_query($dbcnx, "Select objects.catalogNumber, objects.scientificName, objects.fieldNumber From tissuednaextracts Inner Join tissuepcrproducts ON tissuepcrproducts.tissueDnaExtractID = tissuednaextracts.tissueDnaExtractID Inner Join tissuesubsamples ON tissuednaextracts.tissueSubSampleID = tissuesubsamples.tissueSubsampleID Inner Join tissues ON tissuesubsamples.tissueNumber = tissues.tissueNumber Inner Join objects ON tissues.catalogNumber = objects.catalogNumber WHERE tissuepcrproducts.tissuePcrProductID ='".$inf["tissuePcrProductID"]."'");

	 

		$row = mysqli_fetch_assoc($sql);

		echo "<div class=\"info\" id=\"divTaxonInfo\">";

		echo "$COLL_CODE <a href=\"editObjects.php?FormData=".$row["catalogNumber"]."\">".$row["catalogNumber"]."</a> ".$row["scientificName"]." Field Number: <a href=\"editLocalities.php?FormData=".$row["fieldNumber"]."\">".$row["fieldNumber"]."</a>";

		echo "</div>"; // divTaxonInfo



// ====== SHOW INTERNAL COMMENTS

		$sql = mysqli_query($dbcnx, "SELECT commentID, commentText, timeStamp FROM comments WHERE itemNumber ='".$inf["tissuePCRproductID"]."'");

		if ($row = mysqli_fetch_array($sql)) {

			echo "<div class=\"info\" id=\"divCommentInfo\">Comments: ";

			do {

				printf("<a href='editComments.php?FormData=%s'>%s</a> (%s. Time stamp: %s)\n",$row[0],$row[0],$row[1],$row[2]);

			}

			while ($row = mysqli_fetch_array($sql)); 

			echo "</div>"; //divCommentInfo 		

		}	

	echo "</div>"; //lookups	

	

// ====== BOX AT BOTTOM ======

	echo "<div class=\"bottombox\" id=\"bottombox\">";



	$idxfield = "tissuePcrProductID";

	$tablename = "tissuepcrproducts";

	$infvalue = "".$inf['tissuePcrProductID']."";

	$findlabel = "Find PCR product";		

	

	recnavigator($idxfield,$tablename,$infvalue,"".$OrderBy."");	

			

/******SOMETHING NOT WORKING */

echo "<form style=\"font-family:arial;\" method=\"GET\" name=\"frmSortPCR\" action=\"$_SERVER[PHP_SELF]\">";

	echo "<label for=\"OrderBy\"> Sort by: <select id=\"OrderBy\" name=\"OrderBy\"><option value='tissuePcrProductID'>PCR No</option>";

  echo "<option value='pcredBy'>Processed By</option>";

	  echo "<option value='pcrPrimerF'>Forward primer</option>";

		  echo "<option value='pcrPrimerR'>Backward primer</option>";

	echo "<option value='pcrProductStorageStatus'>Storageo</option>";

	echo "<option value='lastModified'>Date Last Modified</option></select>";

		echo "<input type=\"hidden\" value=\"catalogNumber\" name=\"Category\">";

				echo "<input type=\"hidden\" value=\"".$inf["tissuePcrProductID"]."\" name=\"FormData\">";

	echo "<input type=\"submit\" value=\"Order\" name=\"Task\"></form>";

	

echo "<form style=\"font-family:arial;\" method=\"GET\" name=\"frmFindPCR\" action=\"$_SERVER[PHP_SELF]\">";

	echo "<label for=\"findFormData\">Find PCR Number:</label> <input type=\"text\" id=\"findFormData\" name=\"FormData\" size=\"30\">";

	echo "<input type=\"hidden\" value=\"tissuePcrProductID\" name=\"Category\">";

		echo "<input type=\"hidden\" value=\"tissuePcrProductID\" name=\"OrderBy\">";

	echo "<input type=\"submit\" value=\"Find\" name=\"Task\"></form>";

	

	echo "</div>\n"; //bottombox



// ====== AUTOSUGGEST FOR pcredBy ======

?>

<script type="text/javascript">

	var options1 = {

		script:"as_names.php?",

		varname:"input",

		minchars:1

	};

	var as1 = new AutoSuggest('pcredBy', options1);



</script>	

<?php



echo "</body>";		

echo "</html>";



?>