LBMC » MyLabStocks

if ($tb != "home" & $tb != "rack" & $tb != "add_box" & $tb != "publish_it") {

function dump_genotype($strain) {

  $geno = "<p>$strain->Name_ Genotype: ".

  	"<I>".

 	"<B>". 

  	$strain->Mating_Type ." ".

 	"</B>" .

 	$strain->ADE2 ." ".

 	$strain->HIS3 ." ".

 	$strain->LEU2 ." ".

 	$strain->LYS2 ." ".

 	$strain->MET15 ." ".

 	$strain->TRP1 ." ".

 	$strain->URA3 ." ".

 	$strain->HO_ ." ".

 	$strain->locus1 ." ".

 	$strain->locus2 ." ".

 	$strain->locus3 ." ".

 	$strain->locus4 ." ".

 	$strain->locus5 ." ".

 	"</I>".

 	" [" .

 	$strain->Cytoplasmic_Character ." ".

 	"] (" .

 	$strain->extrachromosomal_plasmid ." ".

 	")" .

 	"</p>"; 

  return($geno);

} 

  if (($tb == "admin" || $tb == "add_box" || $tb == "publish_it") && $session->mode != "super") {

<?php

session_start();

require("headers.php");

if (isset($_REQUEST["action"])) {

  // print_r($_REQUEST);

  $ids = $_REQUEST["ids"];

  $all_ids = explode(" ", preg_replace("/([^0-9]+)/"," ",$ids));

  // print("<pre>");

  // print_r($all_ids);

  // print("</pre>");

  if ($_REQUEST["action"] == "publish_genotypes") {

    $where_clause = "id IN (" . implode(",", $all_ids) . ")";

    $qry = "SELECT * FROM strains WHERE $where_clause";

    $result = mysql_query($qry, $connexion);

    while($strain = mysql_fetch_object($result)) {

      // print("<pre>");

      // print_r($strain);

      // print("</pre>");

      echo dump_genotype($strain);

    }

  }

}

  $output = "";

  $output .= "<p>Enter IDs of strains (blank separated) that you want to publish genotypes.</p>";

  $output .= "<form>";

  $output .= "<textarea name='ids' cols='25' rows='5'>$ids</textarea><br>";

  $output .= "<input type='hidden' name='action' value='publish_genotypes'>\n";

  $output .= "<br><input type='submit' value='Extract genotypes.'>\n";

  $output .= "</form>";

  echo $output;

  // session_start ();

  require("footers.php");

?>

  $output .= "Passage: <select name='passage' onChange='submit()'>";

  $output .= "Container: <select name='container' onChange='submit()'>";

  $qry = "SELECT DISTINCT container FROM cl_storage ORDER BY container";

  $output .= "Rack: <select name='rack' onChange='submit()'>";

  $qry = "SELECT DISTINCT rack FROM cl_storage WHERE container='$container' ORDER BY rack";

  $tmp_racks = array();

    array_push($tmp_racks, $storage->rack);

  }

  if (isset($rack)) {

    if (!in_array($rack, $tmp_racks)) {

      unset($rack);

    }

  }  

  foreach ($tmp_racks as $storage_rack) {

      $rack = $storage_rack;

    $rack == $storage_rack ? $selected = "selected" : $selected = "";

    $output .= "<option value='$storage_rack' $selected>$storage_rack</option>";

  // while($storage = mysql_fetch_object($result)) {

  // if (!isset($rack)) {

  //   $rack = $storage->rack;

  // }

  // $rack == $storage->rack ? $selected = "selected" : $selected = "";

  // $output .= "<option value='$storage->rack' $selected>$storage->rack</option>";

  // }

  $output .= "Box: <select name='box' onChange='submit()'>";

  $qry = "SELECT DISTINCT box FROM cl_storage WHERE container='$container' AND rack='$rack' ORDER BY box";

  $tmp_boxes = array();

    array_push($tmp_boxes, $storage->box);

  }

  if (isset($box)) {

    if (!in_array($box, $tmp_boxes)) {

      unset($box);

    }

  }  

  foreach ($tmp_boxes as $storage_box) {

      $box = $storage_box;

    $box == $storage_box ? $selected = "selected" : $selected = "";

    $output .= "<option value='$storage_box' $selected>$storage_box</option>";

  $qry = "SELECT name FROM cl_passages WHERE ID='$passage'";

  $result = mysql_query($qry, $connexion);

  $cell_line = mysql_fetch_object($result)->name;

  $content_cell_line = array();

    $content_cell_line[$key] = $joint_passage->name ;

      @$content_cell_line[$key] == $cell_line ? $color="PowderBlue": $color=$color;

      @$content_index[$key] == $passage ? $color="RoyalBlue": $color=$color;

  $output2 = "<table class='pme-main'><tr class='pme-header'><th class='pme-header'>Cell Line</th><th class='pme-header'>#Vials</th><th class='pme-header'>Note</th></tr>";

  $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 = "<blink><b>Please freeze additional passages to maintain frozen stocks!</b></blink>";

    } else {

      $note = "Sufficient stock.";

    }

    $output2 .= "<tr class='pme-row-0'><td class='pme-cell-0'>$joint_passage->name</td><td class='pme-cell-0'>$joint_passage->cnt</td><td class='pme-cell-0'>$note</td></tr>";    

    // print($joint_passage->name . " "  . $joint_passage->cnt . "<pre>");

    // print_r($joint_passage);

    // print("</pre>");

    // $key = $joint_passage->container . $joint_passage->rack . $joint_passage->box . $joint_passage->field_y . $joint_passage->field_x;;

    // $value = $joint_passage->name . "<br>" . $joint_passage->passage . "<br>" . $joint_passage->date_of_freezing;

    // $content[$key] = $value;

    // $content_index[$key] = $joint_passage->cl_passages ;

  }

  $output2 .= "</table>";

    print($output2);

 echo dump_genotype($strain);

if ($session->mode == "super") {

  print("<p><a href='publish_it.php'>Publish genotypes.</a></p>");

}