/ collman/editPCRproducts.php
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\"> </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>";
-
- ?>
-