// Initialize variables to prevent undefined notices
$ord = '';
$erorr = '';
$uncheck = '';
$errorselect = '';
$titleid = '';
$actual = '';
$fix = '';
$areaerror = '';
fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$erorr=$row['errorwas'];
}
$enotes="Fault:
$actual
Possible Fix
$fix
";
$sql="SELECT * FROM ordernumbertrack where ordernumber=?";
$stmt=pdoquery($sql, array($ord));
$rows=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$checkedby=ucwords($row['checkedby']);
$chkby=$row['checkedby'];
$entby=$row['operaenteredby'];
$enteredby=getusername($row['operaenteredby']);
}
$sql="SELECT * FROM viamedquote_orders where id=?";
$stmt=pdoquery($sql, array($ord));
$rows=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$hostcompany=$row['hostcompany'];
}
$erorr = $global_company_name[$hostcompany]."
$erorr";
$sql="INSERT INTO ordernumbertrack_errors (areaatfault,addedon , addedby , ordnum , errorwas , errorid , notes1,notes2,titleid)
VALUES (?,?,?,?,?,?,?,?,?) ";
pdoquery($sql, array($areaerror,$nowis,$vui,$ord,$erorr,$errorselect,$actual,$fix,$titleid));
if ( $erorr=='')
{
print "NEED TO PICK AN ERROR!!!";
} else
{
if ($uncheck<>'')
{
$sql="UPDATE ordernumbertrack set checked='',checkedby='',checkedon='' where ordernumber=?";
pdoquery($sql, array($ord));
}
$sql="INSERT INTO ordernumbertrack_whencheckedlist (userid , addedon , ord , uncheckedreason) VALUES (?,?,?,?)";
pdoquery($sql, array($vui,$nowis,$ord,$erorr));
print "$ord $erorr LOGGED";
if ($checkedby<>'')
{
$sql="SELECT * FROM ISO_job_titles_employeeid where titleid=?";
$stmt=pdoquery($sql, array($titleid));
$rows=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
$warehouseuserid=$row['employid'];
$warehouseusername=getusername($warehouseuserid);
}
if ($warehouseusername=='')
{
$warehouseusername='Helen Lamb';
}
$warehouseusername='Helen Lamb';
$subject="Order Error : $ord $erorr";
$body="Auto Issue from Error Log $ord
Order Entered by $enteredby
Order Checked by $checkedby
$areaerror
Error was $erorr
$enotes
";
$i="INSERT INTO viamedagendahistory
( subject,agendid , notes , createdate , investigateby , createpresent,historytrackid ,createmeetingdate ,informationonly)
VALUES ('$subject','238','$body', '$usenow' , 'Auto_Issue' ,'Auto_Issue' , '238' ,'$usenow','on')";
//getquery($i);
$sql="INSERT INTO viamedagendahistory
( subject,agendid , notes , createdate , investigateby , createpresent,historytrackid ,createmeetingdate ,informationonly,
vigilancenotice,vigilancenoticeby,vigilancenoticeon)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?)";
pdoquery($sql, array($subject,'238',$body, $usenow , $warehouseusername ,'Auto_Issue' , '238' ,$usenow,'on',
'Order Processing Error',$vui,$nowis));
}
}
?>