";
$sql="
Select
dw_cypher.cypherID,
dw_cypher.cypherText,
dw_cypher.cypherOrderID,
dw_spec.specText,
dw_unit.unitText,
dw_location.locationText,
dw_group.groupText,
dw_test.testText,
dw_result.resultFriendly,
dw_user.userFirst,
dw_user.userLast,
dw_result.resultModDate
From
dw_result Left Join
dw_unit
On dw_result.resultUnit = dw_unit.unitID Left Join
dw_test
On dw_result.resultTest = dw_test.testID Left Join
dw_location
On dw_unit.unitLocation = dw_location.locationID Left Join
dw_cypher
On dw_unit.unitCypher = dw_cypher.cypherID Left Join
dw_spec
On dw_cypher.cypherSpec = dw_spec.specID Left Join
dw_user
On dw_result.resultModUser = dw_user.userID Left Join
dw_group
On dw_group.groupID = dw_test.testGroup
Where
dw_cypher.cypherSite = ? And
dw_result.resultModDate >= ?
Order By
dw_cypher.cypherManuDate Desc,
dw_spec.specOrder,
dw_unit.unitText,
dw_group.groupOrder,
dw_test.testOrder,
dw_result.resultModDate
";
if(!$resultquery = mysqli_prepared_query($link, $sql, "is", array($_SESSION['userSite'], date('Y-m-d',strtotime('yesterday'))), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
echo "
| Cypher |
Product |
Sample |
Location |
Group |
Test |
Result |
Entered by |
Date |
";
if(mysqli_prepared_num_rows($resultquery)>0){
foreach($resultquery as $resultarray){
echo "
| ".$resultarray['cypherText'].' '.$resultarray['cypherOrderID']." |
".$resultarray['specText']." |
".$resultarray['unitText']." |
".$resultarray['locationText']." |
".$resultarray['groupText']." |
".$resultarray['testText']." |
".$resultarray['resultFriendly']." |
".$resultarray['userFirst']." ".$resultarray['userLast']." |
".date('d/m/y h:m:s',strtotime($resultarray['resultModDate']))." |
";
}
}
echo "
";
require "inc/footer.php"; ?>
Please wait while loading...