0){
$testarray = $testquery[0];
$testFormat = $testarray['testFormat'];
$testUnits = $testarray['testUnits'];
$testRound = $testarray['testRound'];
}else{
$testFormat = 0;
$testUnits = "";
$testRound = 0;
}
}else{
$testFormat = 0;
$testUnits = "";
$testRound = 0;
}
$where = "cypherManuDate>='".$datefrom."' AND cypherManuDate<='".$dateto."' AND cypherSite=".$_SESSION['userSite'];
if(isset($_REQUEST['s']) && $_REQUEST['s']!="" && $_REQUEST['s']!=null){
$where .= " AND (";
foreach($_REQUEST['s'] as $s){
if($s!=0){
$where .= "specID=".clean($s)." OR ";
}
}
if(substr($where,-6)!=" AND ("){
$where=substr($where,0,strlen($where)-4); //take off the last " OR "
$where .= ")";
}else{
$where=substr($where,0,strlen($where)-6); //take off " AND ("
}
}
$cyphersql="
Select
dw_cypher.cypherID,
dw_cypher.cypherManuDate,
dw_cypher.cypherOrderID,
dw_spec.specID,
dw_spec.specText
From
dw_spec Right Join
dw_cypher
On dw_spec.specID = dw_cypher.cypherSpec
Where
dw_cypher.cypherID > ? And
".$where."
Order By
dw_cypher.cypherManuDate Desc
";
$counter = 0;
if(!$cypherquery = mysqli_prepared_query($link, $cyphersql, "i", array(0), __FILE__, __LINE__)) reporterror(get_error(), $cyphersql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
if(mysqli_prepared_num_rows($cypherquery)>0){
echo "
";
$cypherarray = $cypherquery[0];
$locationsql="
Select
dw_location.locationText,
dw_location.locationID
From
dw_result Left Join
dw_unit
On dw_result.resultUnit = dw_unit.unitID Left Join
dw_cypher
On dw_unit.unitCypher = dw_cypher.cypherID Left Join
dw_location
On dw_unit.unitLocation = dw_location.locationID
Where
dw_result.resultModDate >= ? And
dw_result.resultModDate <= ? And
dw_result.resultTest = ? And
dw_cypher.cypherSpec = ? And
dw_location.locationActive = 1
Group By
dw_location.locationID
";
//for top row
if(!$locationquery = mysqli_prepared_query($link, $locationsql, "ssii", array($datefrom, $dateto, $_REQUEST['t'], $cypherarray['specID']), __FILE__, __LINE__)) reporterror(get_error(), $locationsql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
if(mysqli_prepared_num_rows($locationquery)>0){
echo "| | ";
foreach($locationquery as $locationarray){
echo "".$locationarray['locationText'];
if($debug) echo " [".$locationarray['locationID']."]";
echo " | ";
}
echo "
";
}
if(mysqli_prepared_num_rows($cypherquery)>0){
foreach($cypherquery as $cypherarray){
$cypherID = $cypherarray['cypherID'];
$cypherManuDate = $cypherarray['cypherManuDate'];
$cypherOrderID = $cypherarray['cypherOrderID'];
$specID = $cypherarray['specID'];
$specText = $cypherarray['specText'];
if(mysqli_prepared_num_rows($locationquery)>0){
echo "| ".date('d/m/Y',strtotime($cypherManuDate))." ".$cypherOrderID." ".$specText." | ";
foreach($locationquery as $locationarray){
$locationID = $locationarray['locationID'];
$sql="
Select
dw_result.resultFriendly,
Max(dw_result.resultModDate) As resultModDate # for retests
From
dw_result Inner Join
dw_unit On dw_result.resultUnit = dw_unit.unitID
Where
dw_unit.unitCypher = ? And
dw_unit.unitLocation = ? And
dw_result.resultTest = ?
";
if(!$resultquery = mysqli_prepared_query($link, $sql, "iii", array($cypherID, $locationID, $_REQUEST['t']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
//echo "";
//echo $sql." ";
$sum = 0;
$count = 0;
if($debug) $result_soft_array = "{";
foreach($resultquery as $resultarray){
if($resultarray['resultFriendly']!=""){
$result = texttonumber($resultarray['resultFriendly'], $testFormat);
$sum += $result;
$count++;
if($debug) $result_soft_array .= $resultarray['resultFriendly'].",";
}
}
if($debug) $result_soft_array = substr($result_soft_array,0,-1)."} ";
$sql="
Select
dw_limit.limitLow,
dw_limit.limitHigh
From
dw_limit
Where
dw_limit.limitTest = ? And
dw_limit.limitSpec = ? And
dw_limit.limitLocation = ? And
dw_limit.limitDateFrom <= ? And
dw_limit.limitDateTo >= ?
";
if(!$limit_query = mysqli_prepared_query($link, $sql, "iiiss", array($_REQUEST['t'], $specID, $locationID, $cypherManuDate, $cypherManuDate), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
$limitarray = $limit_query[0];
if($count>0) $average = numbertotext(($sum/$count), $testFormat, $testRound);
else $average = $sum;
if($count==0){
//no result
echo " | ";
}else if(mysqli_prepared_num_rows($limit_query)==0){
//no limits
echo " | ";
}else if($average < $limitarray['limitLow'] || $average > $limitarray['limitHigh']){
//oos
echo " | ";
}else{
//in spec
echo " | ";
}
if($debug){
echo $result_soft_array." (".$limitarray['limitLow']."-".$limitarray['limitLow'].") ";
}
if($count>0) echo $average." ".$testUnits;
//else echo "-";
echo " | ";
}
echo "
";
}
echo "";
$counter++;
}
echo "
| In spec |
| Out of spec |
| No limits |
";
}else echo "
There were no results found for the search criteria you supplied";
}else echo "
There were no results found for the search criteria you supplied";
}
?>
Please wait while loading...