editImages.php | searchcode

/ collman/editImages.php

http://collman.googlecode.com/
PHP | 298 lines | 208 code | 58 blank | 32 comment | 35 complexity | c5eed5be3d0b82d80c5eae07b3b95163 MD5 | raw file

<?php

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

	$Title = "Edit Images";

	$PageName = "Edit Images";

$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; 

	}

	

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

  include("ta_opendb.inc");

	include("ta_fn_dropdownfield.inc");



//Security level handling

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

	$userlevel = "Administrator";	 }

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

	$userlevel = "Guest";	 }

	else 

	$userlevel = "User";

	

	

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

	$FormData =$_REQUEST['FormData'];

	$Category = $_REQUEST['Category'];

  $Task	= $_REQUEST['Task'];

	$OrderBy = $_REQUEST['OrderBy'];

	

	$imageID = $_REQUEST['imageID'];

	$imageNumber = $_REQUEST['imageNumber'];

	$catalogNumber = $_REQUEST['catalogNumber'];

	$fieldNumber = $_REQUEST['fieldNumber'];

	$imageSubject = $_REQUEST['imageSubject'];

	$imageContent = $_REQUEST['imageContent'];

	$imageCategory= $_REQUEST['imageCategory'];

	$imageColor = $_REQUEST['imageColor'];

	$imageArchive = $_REQUEST['imageArchive'];

	$imageArchiveID = $_REQUEST['imageArchiveID'];

	$imageCopyright = $_REQUEST['imageCopyright'];

	$imageCopyrightHolder = $_REQUEST['imageCopyrightHolder'];

	$imageArtist = $_REQUEST['imageArtist'];

	$imageSecondArtist = $_REQUEST['imageSecondArtist'];

  $textDateImageMade = $_REQUEST['textDateImageMade'];

  $dateImageMade = $_REQUEST['dateImageMade'];

  $imageInformation = $_REQUEST['imageInformation'];

  $originalImageFile = $_REQUEST['originalImageFile'];	

  $imageFile = $_REQUEST['imageFile'];

  $imageFileCompressed = $_REQUEST['imageFileCompressed'];

  $flagNotPublic = $_REQUEST['flagNotPublic'];

  $timeStamp = $_REQUEST['timeStamp'];	

  $enteredBy = $_REQUEST['enteredBy'];

  $lastModified= $_REQUEST['lastModified'];

  $modifiedBy= $_REQUEST['modifiedBy'];

  $imageRemarks= $_REQUEST['imageRemarks'];	



// thispage

	$idxfield = "imageNumber";

	$tablename = "images";



//If no initial value

	if ($FormData == "Initiate") {

		$sql = mysqli_query($dbcnx, "SELECT $idxfield FROM $tablename ORDER BY $idxfield DESC LIMIT 1");

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

			$FormData = $row[0];

		}

  }		

	

	

	if (empty($imageNumber)) {

		$imageNumber=$FormData;

	}

	

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

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



//===== IN CASE MODIFY REQUESTED: MODIFY ===========	

  if ($Task == "Modify") {

		$imageNumber = $FormData;

		

		// Get and show Old data

		$sql= mysqli_query($dbcnx, "SELECT imageNumber, catalogNumber, fieldNumber from $tablename WHERE $idxfield ='$imageNumber'");

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

		//VALIDATION OF FORM IN HERE

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

  	// Update operation

		if (isset($imageColor)){$imageColor = 1;}

		if (isset($flagNotPublic)) {$flagNotPublic = 1;}

		mysqli_query($dbcnx, "UPDATE $tablename SET catalogNumber ='$catalogNumber', fieldNumber = '$fieldNumber', imageSubject='$imageSubject', imageCategory='$imageCategory', imageContent = '$imageContent', imageColor ='$imageColor', imageArchive='$imageArchive', imageArchiveID ='$imageArchiveID', imageCopyright ='$imageCopyright', imageCopyrightHolder='$imageCopyrightHolder', imageArtist = '$imageArtist', imageSecondArtist = '$imageSecondArtist', textDateImageMade = '$textDateImageMade', dateImageMade='$dateImageMade', imageInformation='$imageInformation', originalImageFile='$originalImageFile', imageFile='$imageFile', imageFileCompressed='$imageFileCompressed', flagNotPublic='$flagNotPublic', lastModified = CURRENT_TIMESTAMP, modifiedBy ='".$session->username."', imageRemarks = '$imageRemarks' WHERE imageNumber = '$imageNumber'"); 

		// Get and show NEW Data	

		$sql= mysqli_query($dbcnx, "SELECT catalogNumber from $tablename WHERE $idxfield ='$imageNumber'");

		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 $tablename 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 Image: ". $inf["imageNumber"]." 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)){

					$headline = $row[0];

					echo "<div class=\"infohead\" id=\"infohead\">Image: ".$headline."</div>";				

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

				} 	

//FORM ITSELF

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



//IMAGE NUMBER etc in one row          

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



inputfield("catalogNumber","Cat No","text","16","16","".$inf['catalogNumber'].""); 



inputfield("fieldNumber","Field No","text","16","16","".$inf['fieldNumber'].""); 

echo "<br />";

inputfield("imageSubject","Subject","text","16","16","".$inf['imageSubject'].""); 



dropdownfield("imageContent","lk_imagecontents","Content","".$inf['imageContent'].""); 

 

dropdownfield("imageCategory","lk_imagecategories","Image Category","".$inf['imageContent']."");

	if ($inf["imageColor"] == '1') {

		echo "<label for=\"imageColor\">Color :</label><input type=\"checkbox\" name=\"imageColor\" checked onkeypress=\"return handleEnter(this, event)\">\n";

	}

	else { 

		echo "<label for=\"imageColor\">Color :</label><input type=\"checkbox\" name=\"imageColor\" onkeypress=\"return handleEnter(this, event)\">\n";

		}

echo "<br />\n";



inputfield("imageArchive","Archive","text","25","25","".$inf['imageArchive'].""); 



inputfield("imageArchiveID","Archive ID","text","25","25","".$inf['imageArchiveID'].""); 



inputfield("imageCopyright","Copyright","text","16","16","".$inf['imageCopyright']."");

 

inputfield("imageCopyrightHolder","Copyright Holder","text","25","25","".$inf['imageCopyrightHolder'].""); 

echo "<br />\n";

inputfield("imageArtist","Artist","text","25","25","".$inf['imageArtist'].""); 



inputfield("imageSecondArtist","Second Artist","text","25","25","".$inf['imageSecondArtist'].""); 



inputfield("textDateImageMade","Date (text)","text","16","16","".$inf['textDateImageMade'].""); 



inputfield("dateImageMade","Date","text","16","16","".$inf['dateImageMade'].""); 

echo "<br />\n";

inputfield("imageInformation","Image Data","text","100","100","".$inf['imageInformation'].""); 

echo "<br />\n";



inputfield("originalImageFile","Image File","text","50","50","".$inf['originalImageFile']."");



inputfield("imageFile","Image File","text","50","50","".$inf['imageFile']."");

echo "<br />\n";

inputfield("imageFileCompressed","Compressed File","text","50","50","".$inf['imageFileCompressed']."");



	if ($inf["flagNotPublic"] == '1') {

		echo "<label for=\"flagNotPublic\">Not Public :</label><input type=\"checkbox\" name=\"flagNotPublic\" value='".$inf["flagNotPublic"]."' checked onkeypress=\"return handleEnter(this, event)\">\n";

	}

	else {

		echo "<label for=\"flagNotPublic\">Not Public :</label><input type=\"checkbox\" name=\"flagNotPublic\" value='".$inf["flagNotPublic"]."' onkeypress=\"return handleEnter(this, event)\">\n";

	}

	

echo "<br />";



          echo "<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>";

          }

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

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

		  ;} 	

	 }



//========== IMAGE DISPLAY =============================

		include ("ta_fn_convertimage.inc");



		echo "<div id='divimagedisplay'>";	 

//			$sql = mysqli_query($dbcnx,"SELECT SQL_CACHE imageFile, imageNumber FROM images ORDER BY imageNumber DESC LIMIT 1");

//			$row = mysqli_fetch_array($sql);

			$outimage =&convertimage("images\\".$inf["imageFile"]."", 300);

			$urlstring= "displayImages.php?Category=imageFile&Precision==&FormData=".$inf["imageFile"]."&Ordering=imageNumber&MaxRecs=1&Submit=Submit";

					echo "<p><a href='".$urlstring."' target='_blank'><img style='width:300px;margin-left: 20px;margin-bottom: 10px;' src='thumbs/".$outimage."' /></a>";

				echo "</div>"; //imagedisplay

// End of Most Recent Image =========================

	

	 



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

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

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



//SHOW REFERENCES

$sql = mysqli_query($dbcnx, "select * from citedObjects WHERE catalogNumber ='".$inf["catalogNumber"]."'");

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

		echo "<div class=\"info\" id=\"divReferenceInfo\">Citations: ";

		do {

			printf("<a href='editCitations.php?FormData=%s'>%s</a> |\n",$row[0],$row[0]);

		}

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

		echo "</div>"; //divReferenceInfo

	}





//SHOW INTERNAL COMMENTS

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

	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	

	

include("ta_citedobjectslist.inc");	

	

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

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



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

$findlabel = "Find Image";		

	

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

	

			

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

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

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

  echo "<option value='genus'>Genus</option>";

	  echo "<option value='individualCount'>N Specimens</option>";

		  echo "<option value='typeStatus'>Type status</option>";

	echo "<option value='fieldNumber'>Field No</option>";

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

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

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

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



findform($findlabel,$idxfield);	



//======Links to output lists

	echo "LIST : ";

  echo "<a href=\"objectListing.php?Category=objects.genus&FormData=".$inf["genus"]."&OrderBy=scientificName&Direction=ASC\">CONGENERIC</a>";

	echo " | ";

  echo "<a href=\"objectListing.php?Category=scientificName&FormData=".$inf["scientificName"]."&OrderBy=scientificName&Direction=ASC\">CONSPECIFIC</a>";

	if (isset ($family)){

		echo " | ";	

  	echo "<a href=\"objectListing.php?Category=family&FormData=".$family."&OrderBy=scientificName&Direction=ASC\">ALL ".strtoupper($family)."</a>";

	}

//======End output lists



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



//echo "</div>\n"; //class content

?>	

<script type="text/javascript">

	var options1 = {

		script:"as_names.php?",

		varname:"input",

		minchars:1

	};

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



	var options2 = {

		script:"as_fieldNumbers.php?",

		varname:"input",

		minchars:3

	};

	var as2 = new AutoSuggest('fieldNumber', options2);	

</script>	





<?php



echo "</body>";		

echo "</html>";

//include ("ta_footer.inc");



?>