mode == "super") { print("

Add a new box for your Liquid N2 storage.

"); } if (isset($_REQUEST["action"])) { // print_r($_REQUEST); $passage = $_REQUEST["passage"]; $container = $_REQUEST["container"]; $rack = $_REQUEST["rack"]; $box = $_REQUEST["box"]; if ($_REQUEST["action"] == "update_storage") { $where_clause = ""; $try_to_update = FALSE; foreach ($_REQUEST as $key => $value) { if (preg_match("/fieldy_fieldx/i", $key)) { $try_to_update = TRUE; $tmp_exp = explode("_", $key); $tmp_field_y = $tmp_exp[2]; $tmp_field_x = $tmp_exp[3]; $where_clause .= "(container='$container' AND rack='$rack' AND box='$box' AND field_y='$tmp_field_y' AND field_x='$tmp_field_x') OR "; // $output .= "

$tmp_box $tmp_field***********

"; } } $where_clause .= "0"; if ($passage == "drop") { $qry = "UPDATE cl_storage SET cl_passages=NULL WHERE $where_clause"; $result = mysql_query($qry, $connexion); } else { $qry = "SELECT * FROM cl_storage WHERE $where_clause"; // echo "
" . $qry . "
"; $result = mysql_query($qry, $connexion); $error = FALSE; while($tmp_passage = mysql_fetch_object($result)) { if (isset($tmp_passage->cl_passages)) { $error = TRUE; echo "

ERROR! $tmp_passage->container $tmp_passage->rack $tmp_passage->box $tmp_passage->field_y $tmp_passage->field_x is not empty.

"; } } if ($try_to_update & $session->mode == "view") { echo "

ERROR! You can't update Liquid N2 storage in view mode.

"; } if (!$error & $session->mode != "view") { $qry = "UPDATE cl_storage SET cl_passages='$passage' WHERE $where_clause"; $result = mysql_query($qry, $connexion); } } } } // $qry = "SELECT * FROM cl_passages"; // $result = mysql_query($qry, $connexion); // while($tmp_passage = mysql_fetch_object($result)) { // if (!isset($passage)) { // $passage = $tmp_passage->ID; // echo "Passage: $tmp_passage->name $tmp_passage->passage $tmp_passage->date_of_freezing"; // } // } $output = ""; $output .= "

"; $output .= "Which passage do you want to precise storage?
"; $output .= "Passage:
"; $output .= "In which container/rack/box?
"; $output .= "Container:
"; $output .= "Rack:
"; $output .= "Box:
"; $qry = "SELECT name FROM cl_passages WHERE ID='$passage'"; $result = mysql_query($qry, $connexion); $cell_line = mysql_fetch_object($result)->name; $qry = "SELECT * FROM cl_storage, cl_passages WHERE container='$container' AND rack='$rack' AND box='$box' AND cl_storage.cl_passages=cl_passages.ID"; $result = mysql_query($qry, $connexion); $content = array(); $content_index = array(); $content_cell_line = array(); while($joint_passage = mysql_fetch_object($result)) { $key = $joint_passage->container . $joint_passage->rack . $joint_passage->box . $joint_passage->field_y . $joint_passage->field_x;; $value = $joint_passage->name . "
" . $joint_passage->passage . "
" . $joint_passage->date_of_freezing; $content[$key] = $value; $content_index[$key] = $joint_passage->cl_passages ; $content_cell_line[$key] = $joint_passage->name ; } $box_map = array( "A" => range(1,2), "B" => range(1,3), "C" => range(1,4), "D" => range(1,5), "E" => range(1,6), "F" => range(1,7), "G" => range(1,8), "H" => range(1,9), "I" => range(1,10), "J" => range(1,9), "K" => range(1,4), ); $output .= "In which boxes/fields?
"; $output .= ""; foreach ($box_map as $field_y => $fields) { $output .= ""; $output .= ""; } $output .= "

"; $output .= $field_y; $output .= "

"; $output .= ""; foreach($fields as $field_x) { $key = $container . $rack . $box . $field_y . $field_x; isset($content[$key]) ? $color="LightGray" : $color="LightGreen"; @$content_cell_line[$key] == $cell_line ? $color="PowderBlue": $color=$color; @$content_index[$key] == $passage ? $color="RoyalBlue": $color=$color; $output .= ""; } $output .= "

"; if ($session->mode != "view") { $output .= "$field_x
"; } else { $output .= "$field_x
"; } $output .= isset($content[$key]) ? $content[$key] : "empty

"; $output .= "

"; $output .= "

"; $output .= "\n"; $output .= "\n"; $output .= ""; $output .= "

"; echo $output; $output2 = ""; $qry = "SELECT name, COUNT(cl_passages) as cnt FROM cl_storage, cl_passages WHERE cl_storage.cl_passages=cl_passages.ID GROUP BY name"; $result = mysql_query($qry, $connexion); $content = array(); $content_index = array(); while($joint_passage = mysql_fetch_object($result)) { if ($joint_passage->cnt <= 5) { $note = "Please freeze additional passages to maintain frozen stocks!"; } else { $note = "Sufficient stock."; } $output2 .= ""; // print($joint_passage->name . " " . $joint_passage->cnt . "

");
    // print_r($joint_passage);
    // print("

"); // $key = $joint_passage->container . $joint_passage->rack . $joint_passage->box . $joint_passage->field_y . $joint_passage->field_x;; // $value = $joint_passage->name . "
" . $joint_passage->passage . "
" . $joint_passage->date_of_freezing; // $content[$key] = $value; // $content_index[$key] = $joint_passage->cl_passages ; } $output2 .= "

Cell Line	#Vials	Note
$joint_passage->name	$joint_passage->cnt	$note

"; print($output2); // session_start (); require("footers.php"); ?>