You are NOT allowed to QA your own WORK";
$barcode=isset($_POST['barcode']) ? $_POST['barcode'] : '';
$usestk=isset($_POST['stkref']) ? $_POST['stkref'] : '';
$usedescription=isset($_POST['description']) ? $_POST['description'] : '';
$question_type=isset($_POST['questiontype']) ? $_POST['questiontype'] : '';
$useserialno=isset($_POST['serialno']) ? $_POST['serialno'] : '';
$nowis=date("U");
if ($barcode=='')
{
$barcode=isset($_GET['barcode']) ? $_GET['barcode'] : '';
$question_type=isset($_GET['qt']) ? $_GET['qt'] : '';
}
$issrn=substr($barcode,0,3);
$srnnum=substr($barcode,3);
$sql="SELECT * FROM Serialnumbers where id = ? limit 0,1";
$stmt = pdoquery($sql, array($barcode));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk=$row['Stock_ref'];
$builtby=$row['producedby'];
}
if ($issrn=='SRN')
{
$sql="SELECT * FROM viamed_customer_repairs_details where id = ?";
print "$sql";
$stmt = pdoquery($sql, array($srnnum));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$usestk=$row['stock_ref'];
}
}
?>
'0'";
$stmt = pdoquery($sql, array($vui, $usestk, $question_type));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$num=count($rows);
//print "$num $s ";
if ($num >0)
{
foreach ($rows as $row) {
$pdate=date("d M Y",$row['trainedon']);
$tname=getusername($row['trainedby']);
print "$localname Trained on $question_type of $usestk on the $pdate ";
}
} else
{
print "$localname Needs Training Records for $question_type of $usestk NOT FOUND ";
?>
&question_type=&trainee=&stock_ref="> Request Training
";
$sql="SELECT ISO_quality_manual_files.docid as docid,ISO_quality_manual_files.description as des FROM ISO_quality_manual_files, ISO_quality_manual_stock_links WHERE
ISO_quality_manual_stock_links.docid = ISO_quality_manual_files.docid AND
ISO_quality_manual_files.type = 'COP' AND ISO_quality_manual_stock_links.stock_ref = ? AND
ISO_quality_manual_files.archived='' ";
$stmt = pdoquery($sql, array($usestk));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$docid=$row['docid'];
$active[$docid]=-1;
$description[$docid]=$row['des'];
}
$sql="SELECT ISO_quality_manual_files.docid as docid,ISO_quality_manual_user_read.last_read as lastread FROM ISO_quality_manual_files, ISO_quality_manual_stock_links,ISO_quality_manual_user_read WHERE
ISO_quality_manual_stock_links.docid = ISO_quality_manual_files.docid AND
ISO_quality_manual_files.type = 'COP' AND ISO_quality_manual_stock_links.stock_ref = ? AND
ISO_quality_manual_files.archived='' AND
ISO_quality_manual_user_read.docid=ISO_quality_manual_files.docid AND
ISO_quality_manual_user_read.userid = ?
ORDER BY ISO_quality_manual_user_read.last_read
";
$stmt = pdoquery($sql, array($usestk, $vui));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$docid=$row['docid'];
$prndate=date("d M y",$row['lastread']);
$active[$docid]=$prndate;
}
if ($active != '')
{
foreach ($active as $key => $value){
if ($value==-1)
{
$havenotread=2;
?>
">Please Read the Following Document
">
2) {
if ($issrn=='SRN' or $issrn=='srn') {
print "
$issrn$srnnum
";
$sql="SELECT * FROM viamed_customer_repairs_details where id = ?";
$stmt = pdoquery($sql, array($srnnum));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
if ($row['equipment_type']=="Pulse Oximetery Finger Sensor" OR $row['equipment_type']=="Pulse Oximetery Ear Clip Sensor" OR $row['equipment_type']=="Pulse Oximetery Extension Cable" OR $row['equipment_type']=="Pulse Oximetery Y Sensor") {
$usestk="SRNERPROBE";
$usedescription=$row['equipment_type'];
$useserialno=$row['serialnumber'];
print "->>$useserialno";
}
else {
$usestk=$row['stock_ref'];
if ($barcode=='')
{
$barcode=$row['barcode'];
}
if ($barcode=='')
{
$usedescription=$row['equipment_type'];
$useserialno=$row['serialnumber'];
}
}
}
}
ELSE
{
$sql= "SELECT * FROM Serialnumbers WHERE id = ?";
$stmt = pdoquery($sql, array($barcode));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$numcon=count($rows);
foreach ($rows as $row) {
$usestk=$row['Stock_ref'];
$usedescription=$row['usedescription'];
$useserialno=$row['Serialnumber'];
$builtby=$row['producedby'];
$hasbeeninvoiced=$row['Invoicenumber'];
$invoiceon=$row['Dateout'];
}
if ($barcode=='')
{
$barcode=isset($_GET['barcode']) ? $_GET['barcode'] : '';
$usestk=isset($_GET['stkref']) ? $_GET['stkref'] : '';
$usedescription=isset($_GET['description']) ? $_GET['description'] : '';
$question_type=isset($_GET['questiontype']) ? $_GET['questiontype'] : '';
$useserialno=isset($_GET['serialno']) ? $_GET['serialno'] : '';
}
if ($question_type=='Global Information')
{
$barcode='1';
$useserialno='All Units';
}
}
$sql= "SELECT * FROM serialnumber_questions WHERE question_text <>'Pass' and special_function<>'hide' AND stock_ref = ? AND question_type = ? order by question_order limit 0,1";
$stmt = pdoquery($sql, array($usestk, $question_type));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$firstQ="Q".$row['id'];
//print "$firstQ";
}
//print "$barcode";
$hasmerge=0;
$sql="SELECT * FROM serialnumber_questions WHERE stock_ref = ? AND question_type = ?";
$stmt = pdoquery($sql, array($usestk, $question_type));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$numq=count($rows);
foreach ($rows as $row) {
if ($row['special_function']=='merge')
{
$hasmerge=1;
}
}
// do we have a merge function if so disable the enter Key
if ($hasmerge==1)
{
?>
Enter Key Disabled
.focus()">
0)
{
print "Built by ".getusername($builtby);
}
if (($builtby==$vui and $question_type=="QA") )
{
Print "
You cannot QA your own Builds Please get this Item QA by someone Else
";
} else
{
if ($numq>0)
{
$cc=0;
foreach ($rows as $row) {
//$shwdate=date("d/M/Y ",$row['date_created']);
$shwdate='';
if ($cc=='0')
{
Print "Previous Form Submission(s) on ";
}
?>
">
";
$cc=$cc+1;
}
print "