Please enable Javascript!
"; } else { ?> "; echo ""; } } } ?>
Sorry, you don't have permission for this site! If you want to search for existing DNA data please use the Search function!
="; $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 ""; echo "
No search key entered.
New Search.
"; } 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 ""; //ZSM MÜNCHEN //echo "
CustomerDNA Extraction NoAliquot NoShipping volumeFridgeRackBoxOrder DateNotes
"; 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 ""; echo ""; echo ""; echo ""; } //NORMAL ENDE /*ZSM MÜNCHEN START echo ""; echo ""; echo ""; echo ""; echo ""; } ZSM MÜNCHEN Ende*/ echo "
CustomerDNA Extraction NoPositionAliquot NoBarcodeShipping volumeFridgeDrawerRackOrder DateNotes
".$Name_All."".$DnaBankNumber."".$Aliquot_Number."".$Request_Volume." µl".$Fridge."".$Rack."".$Box."".DatumsWandler($Request_Date).""; echo "".$Request_Notes."
".$Name_All."".$DnaBankNumber."".$Position."".$Aliquot_Number."".$Barcode."".$Request_Volume." µl".$Fridge."".$Rack."".$Box."".DatumsWandler($Request_Date).""; echo "".$Request_Notes."