function getBatchSummary()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$bn = new Batch();
$bn->setBatchID($this->batchid);
$bqty = $bn->getBatchQty();
$query = "SELECT cust.Customer_Name,Machine_Name,\nSUM(CASE WHEN Activity_ID=1 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Production,\nSUM(CASE WHEN Activity_ID=2 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Setup,\nSUM(CASE WHEN Activity_ID=16 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Proving,\nSUM(CASE WHEN Activity_ID=3 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Rework,\nSUM(CASE WHEN Activity_ID=9 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS CMM,\nSUM(TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time)) AS Total From ActivityLog as actl\nINNER JOIN Production as prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\nINNER JOIN Operation as ope On ope.Operation_ID=prod.Operation_ID\nINNER JOIN Component as comp on comp.Drawing_ID=ope.Drawing_ID\nINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID \nINNER JOIN Machine as mach ON mach.Machine_ID=actl.Machine_ID\nWHERE ope.Drawing_ID={$this->drawingid} AND Batch_ID='{$this->batchid}' AND mach.Machine_ID!=9 GROUP BY mach.Machine_ID;";
if (!($res = $cxn->query($query))) {
exit("error (getBatchSummary1: {$query} ) : {$cxn->error}");
}
echo '<table class="pcd">';
echo '<tr><th>Machines used</th><th>Production</th><th>Set Up</th><th>Prog. Proving</th><th>Rework</th><th>CMM Programing</th><th>Total</th></tr>';
$mtime = 0;
$mtimewcmm = 0;
while ($row = mysqli_fetch_assoc($res)) {
if ($row['Production'] != '') {
$p = $this->min2hm($row['Production']);
$mtime += $row['Production'];
} else {
$p = '';
}
if ($row['Setup'] != '') {
$s = $this->min2hm($row['Setup']);
$mtime += $row['Setup'];
} else {
$s = '';
}
if ($row['Proving'] != '') {
$pp = $this->min2hm($row['Proving']);
$mtime += $row['Proving'];
} else {
$pp = '';
}
if ($row['Rework'] != '') {
$rw = $this->min2hm($row['Rework']);
} else {
$rw = '';
}
if ($row['CMM'] != '') {
$cmm = $this->min2hm($row['CMM']);
} else {
$cmm = '';
}
if ($row['Total'] != '') {
$t = $this->min2hm($row['Total']);
} else {
$t = '';
}
echo '<tr><td>' . $row['Machine_Name'] . '</td><td>' . $p . '</td><td>' . $s . '</td><td>' . $pp . '</td><td>' . $rw . '</td><td>' . $cmm . '</td><td>' . $t . '</td></tr>';
}
$tti = $this->min2hm($mtime);
$avgtime = $mtime / $bqty;
$avt = $this->min2hm($avgtime);
$q8 = "SELECT TIME_TO_SEC(ADDTIME(Clamping_Time,Machining_Time)) as tmt FROM Operation as ope\nINNER JOIN Component as comp on comp.Drawing_ID=ope.Drawing_ID\nWHERE ope.Drawing_ID={$this->drawingid} AND ope.In_Op_List=1;";
if (!($res8 = $cxn->query($q8))) {
exit("error (getBatchSummary2: {$q8} ) : {$cxn->error}");
}
$stime = 0;
while ($ror8 = mysqli_fetch_assoc($res8)) {
$stime += $ror8['tmt'];
}
$stime = $this->min2hm($stime / 60);
$q2 = "SELECT cust.Customer_Name,Machine_Name,\nSUM(CASE WHEN Activity_ID=11 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS FAI,\nSUM(CASE WHEN Activity_ID=4 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Fixture,\nSUM(TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time)) AS Total From ActivityLog as actl\nINNER JOIN NonProduction as nprod ON nprod.Activity_Log_ID=actl.Activity_Log_ID\nINNER JOIN BNo_MI_Challans as bmc on bmc.Batch_ID=nprod.Batch_ID\nINNER JOIN MI_Drg_Qty as mdq on mdq.MI_Drg_Qty_Id=bmc.MI_Drg_Qty_ID\nINNER JOIN Component as comp on comp.Drawing_ID=mdq.Drawing_ID\nINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID\nINNER JOIN Machine as mach ON mach.Machine_ID=actl.Machine_ID\nWHERE mdq.Drawing_ID={$this->drawingid} AND nprod.Batch_ID={$this->batchid} GROUP BY mach.Machine_ID;";
if (!($r2 = $cxn->query($q2))) {
exit("error (getBatchSummary3: {$q2} ) : {$cxn->error}");
}
if ($r2->num_rows > 0) {
echo '<table class="pcd"><tr><th>Machine</th><th>Fixture Work</th><th>FAI</th><th>Total</th></tr>';
while ($row = mysqli_fetch_assoc($r2)) {
if ($row['FAI'] != '') {
$fai = $this->min2hm($row['FAI']);
} else {
$fai = '';
}
if ($row['Fixture'] != '') {
$fxt = $this->min2hm($row['Fixture']);
} else {
$fxt = '';
}
if ($row['Total'] != '') {
$t = $this->min2hm($row['Total']);
} else {
$t = '';
}
echo '<tr><td>' . $row['Machine_Name'] . '</td><td>' . $fxt . '</td><td>' . $fai . '</td><td>' . $t . '</td></tr>';
}
}
$q3 = "SELECT ope.Operation_Desc,TIME_TO_SEC(ADDTIME(Clamping_Time,Machining_Time)) as tmt,\nSUM(CASE WHEN Activity_ID=1 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Production,\nSUM(CASE WHEN Activity_ID=2 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Setup,\nSUM(CASE WHEN Activity_ID=16 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Proving,\nSUM(CASE WHEN Activity_ID=3 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS Rework,\nSUM(CASE WHEN Activity_ID=9 THEN TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time) END) AS CMM,\nSUM(TIMESTAMPDIFF(minute,Start_Date_Time,End_Date_Time)) AS Total From ActivityLog as actl\nINNER JOIN Production as prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\nINNER JOIN Operation as ope On ope.Operation_ID=prod.Operation_ID\nINNER JOIN Component as comp on comp.Drawing_ID=ope.Drawing_ID\nINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID \nWHERE ope.Drawing_ID={$this->drawingid} AND Batch_ID={$this->batchid} GROUP BY ope.Operation_ID;";
if (!($r3 = $cxn->query($q3))) {
exit("error (getBatchSummary4: {$q3} ) : {$cxn->error}");
}
if ($r3->num_rows > 0) {
echo '<table class="pcd"><tr><th>Operation</th><th>Standard Time/Part</th><th>Avg Time/Part</th><th>Setup/Batch</th><th>Proving/Batch</th>
<th>Production/Batch</th><th>Rework</th><th>Total</th></tr>';
while ($row = mysqli_fetch_assoc($r3)) {
if ($row['Production'] != '') {
$p = $this->min2hm($row['Production']);
$apt = $this->min2hm($row['Production'] / $bqty);
} else {
$p = '';
}
if ($row['Setup'] != '') {
$s = $this->min2hm($row['Setup']);
} else {
$s = '';
}
if ($row['Proving'] != '') {
$pp = $this->min2hm($row['Proving']);
} else {
$pp = '';
}
if ($row['Rework'] != '') {
$rw = $this->min2hm($row['Rework']);
} else {
$rw = '';
}
if ($row['CMM'] != '') {
$cmm = $this->min2hm($row['CMM']);
} else {
$cmm = '';
}
if ($row['Total'] != '') {
$t = $this->min2hm($row['Total']);
} else {
$t = '';
}
if ($row['tmt'] != '') {
$tmt = $this->min2hm($row['tmt'] / 60);
} else {
$tmt = '';
}
echo '<tr><td>' . $row['Operation_Desc'] . '</td><td>' . $tmt . '</td><td>' . $apt . '</td><td>' . $s . '</td><td>' . $pp . '</td><td>' . $p . '</td><td>' . $rw . '</td><td>' . $t . '</td></tr>';
}
}
echo '<p>Cycle Time(STD) ' . $stime . '<p/>';
echo '<p>Cycle Time (Avg) ' . $avt . '<p/>';
echo '<p>Total hours for the Batch ' . $tti . '<p/>';
}
$cqty = $_POST['cqty'];
//commited quantites
$cremark = $_POST['cremark'];
//commitment remarks
$miid = $_POST['MI_Drg_Qty_ID'];
//inward challan ids
$mqty = $_POST['mqty'];
//challan vice quanties in batch
$hcode = $_POST['hcode'];
//heat codes
$bn->saveBatch();
$batchid = $bn->getBatchID();
$i = 0;
$j = count($cdates);
while ($i < $j) {
$bn->setBatchID($batchid);
$bn->setCommitedDate($cdates[$i]);
$bn->setCommitedQty($cqty[$i]);
$bn->setCommitedRemarks($cremark[$i]);
$bn->saveCommitment();
$i++;
}
$i = 0;
$j = count($miid);
while ($i < $j) {
$bn->setBatchID($batchid);
$bn->setMIDQID($miid[$i]);
$bn->setQuantity($mqty[$i]);
$bn->setHeatCode($hcode[$i]);
$bn->saveQtyDetails();
$i++;
