=";
$st = "<=";
$parr = $_GET;
array($parr);
foreach ($parr as $var)
{
$i ++;
if(!empty($var) and $var!="dd.mm.yyyy" and $var!="Check Data" and $var!="Action")
{
switch (key($parr))
{
case 'Customer':
$str = "request.ID_People ".$tr."'".$var."' AND ";
break;
case 'formDnaBankNumber':
$str = "dnabanknumbers.Dna_Bank_Number ".$tr."'".$var."' AND ";
break;
case 'formOrderDateFrom':
if ($OrderDateFrom!="") {
$str = "request.Request_Date ".$bt."'".$OrderDateFrom."' AND ";
}
break;
case 'formOrderDateTo':
if ($OrderDateTo!="") {
$str = "request.Request_Date ".$st."'".$OrderDateTo."' AND ";
}
break;
case 'formShippingDateFrom':
if ($ShippingDateFrom!="") {
$str = "request.Shipping_Date ".$bt."'".$ShippingDateFrom."' AND ";
}
break;
case 'formShippingDateTo':
if ($ShippingDateTo!="") {
$str = "request.Shipping_Date ".$st."'".$ShippingDateTo."' AND ";
}
break;
case 'Status':
if($Status=="order") {
$str = "(aliquots.Shipping_Partial ".$no."'YES' AND ";
$str .= "aliquots.Shipping_All ".$no."'YES') AND ";}
if($Status=="shipping") {
$str = "(aliquots.Shipping_Partial ".$tr."'YES' OR ";
$str .= "aliquots.Shipping_All ".$tr."'YES') AND "; }
if($Status=="all") {
$str = "(aliquots.Shipping_Partial ".$tr."'YES' OR ";
$str .= "aliquots.Shipping_All ".$tr."'YES' OR ";
$str .= "aliquots.Order_Partial ".$tr."'YES' OR ";
$str .= "aliquots.Order_All ".$tr."'YES') AND ";}
break;
}
$where[$i] = $str;
}
next($parr);
}
if(empty($str))
{ echo ""; }
else {
foreach($where AS $a) $string .= $a;
$l=strlen ($string);
$max = $l-4;
$where_str = substr($string, 0, $max);
$wherestr = " WHERE " . $where_str . " AND request.Agreement = 'Yes'";
//abfrage
$result = "SELECT request.ID_Request, " .
"request.ID_Aliquots, " .
"dnabanknumbers.Dna_Bank_Number, " .
"request.Request_Number_Aliquots, " .
"request.Shipping_All, " .
"request.Shipping_Partial, " .
"request.Shipping_Rest, " .
"request.Order_All, " .
"request.Order_Partial, " .
"request.Order_Rest, " .
"request.Agreement, " .
"aliquots.Aliquot_Barcode, " .
"aliquots.Aliquot_Position, " .
"aliquots_box.Aliquots_Box, " .
"aliquots_rack.Aliquots_Rack, " .
"aliquots_fridge.Aliquots_Fridge, " .
"request.Request_Date, " .
"request.Request_Volume, " .
"request.Request_Notes, " .
"request.Shipping_Date, " .
"request.Price, " .
"request.Created_When, " .
"request.Created_Who, " .
"people.Name_All " .
"FROM request
LEFT JOIN aliquots ON request.ID_Aliquots = aliquots.ID_Aliquots
LEFT JOIN dnabanknumbers ON request.ID_DNA = dnabanknumbers.ID_DNA
LEFT JOIN aliquots_box ON aliquots.ID_Aliquots_Box = aliquots_box.ID_Aliquots_Box
LEFT JOIN aliquots_rack ON aliquots.ID_Aliquots_Rack = aliquots_rack.ID_Aliquots_Rack
LEFT JOIN aliquots_fridge ON aliquots.ID_Aliquots_Fridge = aliquots_fridge.ID_Aliquots_Fridge
LEFT JOIN people ON request.ID_People = people.ID_People " .
$wherestr.$sqllimit;
$sql = mysqli_query($GLOBALS["___mysqli_ston"], $result) or die($result.'
'.((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
$gesamt = mysqli_num_rows($sql);
if(!mysqli_num_rows($sql))
{ echo "No hits found."; }
else {
echo "Liste zeigt nur Aliquots, zu denen ein Material Transfer Agreement existiert!";
//NORMAL
echo "| Customer | DNA Extraction No | Aliquot No | Shipping volume | Fridge | Rack | Box | Order Date | Notes | ";
//ZSM MÜNCHEN
//echo "| Customer | DNA Extraction No | Position | Aliquot No | Barcode | Shipping volume | Fridge | Drawer | Rack | Order Date | Notes | ";
for ($i=1; $i<=$gesamt; $i++) {
$row=mysqli_fetch_array($sql);
$Name_All = $row['Name_All'];
$DnaBankNumber = $row['Dna_Bank_Number'];
$Aliquot_Number = $row['Request_Number_Aliquots'];
$Request_Volume = $row['Request_Volume'];
$Box = $row['Aliquots_Box'];
$Rack = $row['Aliquots_Rack'];
$Fridge = $row['Aliquots_Fridge'];
$Barcode = $row['Aliquot_Barcode'];
$Position = $row['Aliquot_Position'];
$OrderAll = $row['Order_All'];
$OrderPartial = $row['Order_Partial'];
$OrderRest = $row['Order_Rest'];
$ShippingAll = $row['Shipping_All'];
$ShippingPartial = $row['Shipping_Partial'];
$ShippingRest = $row['Shipping_Rest'];
$Request_Date = $row['Request_Date'];
$Request_Notes = $row['Request_Notes'];
$Shipping_Date = $row['Shipping_Date'];
$ID_Request = $row['ID_Request'];
$ID_Aliquots = $row['ID_Aliquots'];
//NORMAL START
echo "| ".$Name_All." | ".$DnaBankNumber." | ".$Aliquot_Number." | ";
echo "".$Request_Volume." µl | ".$Fridge." | ".$Rack." | ".$Box." | ";
echo "".DatumsWandler($Request_Date)." | ";
echo " | ".$Request_Notes." | ";
echo " "; }
//NORMAL ENDE
/*ZSM MÜNCHEN START
echo "| ".$Name_All." | ".$DnaBankNumber." | ".$Position." | ".$Aliquot_Number." | ";
echo "".$Barcode." | ";
echo "".$Request_Volume." µl | ".$Fridge." | ".$Rack." | ".$Box." | ";
echo "".DatumsWandler($Request_Date)." | ";
echo " | ".$Request_Notes." | ";
echo " "; }
ZSM MÜNCHEN Ende*/
echo "
";
echo "
| "; }
}
}
?>
|