= ? And
dw_cypher.cypherManuDate <= ? And
dw_cypher.cypherSite = ?".$where."
Order By
dw_cypher.cypherManuDate
";
if(!$cypherquery = mysqli_prepared_query($link, $sql, "ssi", array($datefrom, $dateto, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
if(mysqli_prepared_num_rows($cypherquery)>0){
$counter=0;
foreach($cypherquery as $cypherarray){
$cypherID = $cypherarray['cypherID'];
$cypherText = $cypherarray['cypherText'];
$cypherOrderID = $cypherarray['cypherOrderID'];
$specText = $cypherarray['specText'];
$sql="
Select
dw_test.testID,
dw_test.testText,
dw_test.testFormat,
dw_test.testRound,
dw_test.testUnits
From
dw_spec Right Join
(dw_cypher Right Join
(dw_group Right Join
(dw_unit Right Join
(dw_test Right Join
dw_result
On dw_test.testID = dw_result.resultTest)
On dw_unit.unitID = dw_result.resultUnit)
On dw_group.groupID = dw_test.testGroup)
On dw_cypher.cypherID = dw_unit.unitCypher)
On dw_spec.specID = dw_cypher.cypherSpec
Where
dw_cypher.cypherID = ? And
dw_test.testSite = ? And
dw_test.testActive = 1
Group By
dw_test.testID
Order By
dw_group.groupOrder,
dw_group.groupText,
dw_test.testOrder,
dw_test.testText
";
if(!$testquery = mysqli_prepared_query($link, $sql, "ii", array($cypherID, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
if(mysqli_prepared_num_rows($testquery)>0){
echo "
| ".$cypherText." ".$cypherOrderID." ".$specText." | Average | Units | ";
foreach($testquery as $testarray){
$testID = $testarray['testID' ];
$testFormat = $testarray['testFormat'];
$testRound = $testarray['testRound' ];
$testUnits = $testarray['testUnits' ];
$testText = $testarray['testText' ];
$sql="
# get results for each test
Select
dw_result.resultFriendly,
max(dw_result.resultModDate) # this is to get rid of retests
From
dw_cypher Right Join(
dw_unit Right Join(
dw_test Right Join
dw_result
On dw_test.testID = dw_result.resultTest
)
On dw_unit.unitID = dw_result.resultUnit
)
On dw_cypher.cypherID = dw_unit.unitCypher
Where
dw_cypher.cypherID = ? And
dw_test.testID = ? And
dw_unit.unitActive = 1
Group By
dw_unit.unitID,
dw_result.resultFriendly
";
if(!$resultquery = mysqli_prepared_query($link, $sql, "ii", array($cypherID, $testID), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
$sum = 0;
$count = 0;
foreach($resultquery as $resultarray){
$sum += texttonumber($resultarray['resultFriendly'], $testFormat);
$count++;
}
if(mysqli_prepared_num_rows($resultquery)>0){
echo "
|---|
| ".$testText;
if($debug) echo " [".$testID."]";
echo " | ".str_replace('<',"<",numbertotext(($sum/$count), $testFormat, $testRound))." | ".$testUnits." |
";
}
}
echo "
";
}
}
}
?>
Please wait while loading...