' >
purely so we can navigate the DOM using javascript and access items in it, and convert to
's
//as well as getting first and last samples, also need to create the badge, which shows number of samples
$sql="
Select
dw_unit.unitID,
dw_unit.unitText,
dw_unit.unitActive,
dw_location.locationID,
dw_location.locationText,
dw_user.userFirst,
dw_user.userLast,
dw_change.changeText,
dw_unit.unitModDate,
dw_unit.unitCompText
From
dw_user Right Join
(dw_change Right Join
(dw_location Right Join
dw_unit
On dw_location.locationID = dw_unit.unitLocation)
On dw_change.changeID = dw_unit.unitChangeCode)
On dw_user.userID = dw_unit.unitModUser
Where
dw_unit.unitCypher = ?
Order By
dw_unit.unitActive Desc,
Case dw_unit.unitText
When 'F' Then 1
When 'M' Then 2
When 'L' Then 3
Else 4
End,
Field(dw_unit.unitText, 'F', 'M', 'L', 'Comp', 'comp', 'Comp1', 'Comp 1', 'Comp2', 'Comp 2'),
LPad(dw_unit.unitText, 20, 0),
dw_location.locationOrder,
dw_location.locationText
";
if(!$sample_query = mysqli_prepared_query($link, $sql, "i", array($cypher_row['cypherID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
?>
console.log("cypher didnt exist, getting now");';
//need to include the required cypher (from get)
if(!empty($_GET['c']) && $c==0) $c=clean($_GET['c']);
$sql="# sql for main table
Select
dw_cypher.cypherID, dw_cypher.cypherText, dw_cypher.cypherOrderID, dw_spec.specText,
dw_cypher.cypherManuDate, dw_cypher.cypherExpiryDate, dw_cypher.cypherNotesFP,
dw_expiry.expiryYear, dw_expiry.expiryMonth, dw_expiry.expiryDay, dw_user.userFirst,
dw_user.userLast, dw_cypher.cypherModDate, dw_spec.specStyle, dw_change.changeText,
dw_spec.specUnitTypeText, dw_cypher.cypherReceivedDate, dw_cypher.cypherReceivedBy,
dw_file.fileName, dw_file.fileID, dw_file.fileSize, dw_file.fileType
From
dw_change Right Join
(dw_user Right Join
(dw_expiry Right Join
(dw_spec Right Join
dw_cypher
On dw_spec.specID = dw_cypher.cypherSpec)
On dw_expiry.expiryID = dw_spec.specExpiry)
On dw_user.userID = dw_cypher.cypherModUser)
On dw_change.changeID = dw_cypher.cypherChangeCode Left Join
dw_file
On dw_cypher.cypherFile = dw_file.fileID
Where
dw_cypher.cypherID = ? And
dw_cypher.cypherSite = ?
";
if(!$cypher_query = mysqli_prepared_query($link, $sql, "ii", array($c, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
echo '';
echo '';
echo '';
if(mysqli_prepared_num_rows($cypher_query)>0){
$cypher_row = $cypher_query[0];
$unitinfo = get_units($cypher_row['cypherID']); //this is used to get data for table
?>
" id="cypher-">
"; ?>
[".$cypher_row['cypherID']."]";
?>
' >
purely so we can navigate the DOM using javascript and access items in it, and convert to
's
//as well as getting first and last samples, also need to create the badge, which shows number of samples
$sql="
Select
dw_unit.unitID,
dw_unit.unitText,
dw_unit.unitActive,
dw_location.locationID,
dw_location.locationText,
dw_user.userFirst,
dw_user.userLast,
dw_change.changeText,
dw_unit.unitModDate,
dw_unit.unitCompText
From
dw_user Right Join
(dw_change Right Join
(dw_location Right Join
dw_unit
On dw_location.locationID = dw_unit.unitLocation)
On dw_change.changeID = dw_unit.unitChangeCode)
On dw_user.userID = dw_unit.unitModUser
Where
dw_unit.unitCypher = ?
Order By
dw_unit.unitActive Desc,
Case dw_unit.unitText
When 'F' Then 1
When 'M' Then 2
When 'L' Then 3
Else 4
End,
Field(dw_unit.unitText, 'F', 'M', 'L', 'Comp', 'comp', 'Comp1', 'Comp 1', 'Comp2', 'Comp 2'),
LPad(dw_unit.unitText, 20, 0),
dw_location.locationOrder,
dw_location.locationText
";
if(!$sample_query = mysqli_prepared_query($link, $sql, "i", array($cypher_row['cypherID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
?>
"; ?>