$pdf->Cell(65, 6, $cdt[$i], 'LRTB', 0, 'C');
$pdf->Cell(65, 6, $qib[$i], 'LRTB', 1, 'C');
$i++;
}
$pdf->SetTextColor(27, 12, 235);
$pdf->Cell(198, 6, 'Process Details', 1, 1, 'C');
$pdf->SetTextColor(0, 1, 0);
$q = "SELECT Operation_ID From Operation WHERE Drawing_ID={$did} AND In_Op_List=1 ORDER BY Display_Order ASC";
$db = Database::getInstance();
$cxn = $db->getConnection();
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
while ($r = mysqli_fetch_assoc($res)) {
$rou->setValue('operationid', $r['Operation_ID']);
$rou->setOperationDetails();
if (in_array($rou->getValue('opnotation'), $rou->getValue('nonmachining'))) {
$q1 = "SELECT *,DATE_FORMAT(Commited_Date,'%d-%m-%Y') as cdt FROM Batch_Commit WHERE Batch_ID=" . $rou->getValue('batchid');
if (!($r1 = $cxn->query($q1))) {
exit("error (Routecard.php) {$q1} : {$cxn->error}");
}
while ($r1r = mysqli_fetch_assoc($r1)) {
$pdf->SetTextColor(27, 12, 235);
$pdf->Cell(98, 6, 'Stage:' . $rou->getValue('opnotationfull'), 'LRTB', 0, 'L');
$pdf->Cell(100, 6, 'Description:' . $rou->getValue('opedesc'), 'LRTB', 1, 'L');
$pdf->SetTextColor(0, 1, 0);
//SELECT *,DATE_FORMAT(Start_Date_Time,'%d-%m-%Y') as sdt,DATE_FORMAT(End_Date_Time,'%d-%m-%Y') as edt,DATE_FORMAT(Qualification_Date,'%d-%m-%Y') as qdt,
//DATE_FORMAT(Done_Date,'%d-%m-%Y') as ddt FROM Routecard WHERE Batch_ID=248 AND Commit_ID=294 AND Operation_ID=480
$qc = "SELECT *,DATE_FORMAT(Start_Date_Time,'%d-%m-%Y') as sdt,DATE_FORMAT(End_Date_Time,'%d-%m-%Y') as edt,DATE_FORMAT(Qualification_Date,'%d-%m-%Y') as qdt,\n\tDATE_FORMAT(Done_Date,'%d-%m-%Y') as ddt,\n\top1.Operator_Name as donebyname, op2.Operator_Name as qualifiedby FROM Routecard as rc \n\tINNER JOIN Operator as op1 ON op1.Operator_ID=rc.Done_BY \n\tINNER JOIN Operator as op2 ON op2.Operator_ID=rc.Qualified_BY \n\tINNER JOIN Batch_Commit as bc ON bc.Commit_ID=rc.Commit_ID\n\tWHERE rc.Batch_ID={$r1r['Batch_ID']} AND rc.Commit_ID={$r1r['Commit_ID']} AND Operation_ID={$r['Operation_ID']}";
if (!($rc = $cxn->query($qc))) {
exit("error (routcard.php2) {$qc} : {$cxn->error}");
