function savePartQuantity() { $db = Database::getInstance(); $cxn = $db->getConnection(); if ($this->supplierid == '' && $this->moutwardid != '') { $q = "INSERT INTO MO_Drg_Qty (Material_Outward_ID,MI_Drg_Qty_ID,Drawing_ID,Outward_Qty)\n\t\t\tVALUES({$this->moutwardid},{$this->midrgqtyid},{$this->partid},{$this->qty})"; //print("<br>$q"); if (!($res = $cxn->query($q))) { echo "error :", $cxn->error; } else { $pm = new PartMaterial(); $pm->setMIDQID($this->midrgqtyid); $pm->setPartMaterialDetails(); $materialreceived = $pm->getQuantity(); $query = "SELECT sum(Outward_Qty) as oq from MO_Drg_Qty where Drawing_ID={$this->partid} and MI_Drg_Qty_ID={$this->midrgqtyid}"; // print("<br>$query"); if (!($resq = $cxn->query($query))) { echo "error :", $cxn->error; } else { $r = mysqli_fetch_assoc($resq); $oq = $r['oq']; $tq = $materialreceived - $oq; // print("<br>Material received=$materialreceived"); if ($tq == 0) { $q3 = "UPDATE MI_Drg_Qty SET Qty_Open='0' WHERE MI_Drg_Qty_ID={$this->midrgqtyid}"; // print("<br>$q3"); if (!($resq = $cxn->query($q3))) { echo "error :", $cxn->error; } } } // print("Part Quantity of $this->qty Updated in Challan"); } $inwardid = $pm->getInwardID(); $q4 = "SELECT Drawing_ID FROM MI_Drg_Qty WHERE Qty_Open=1 AND Material_Inward_ID={$inwardid};"; //print("<br>$q4"); $res4 = $cxn->query($q4); $opendqty = $res4->num_rows; if ($opendqty == 0) { $q5 = "UPDATE Material_Inward SET Open=0 WHERE Material_Inward_Id={$inwardid};"; //print("<br>$q5"); $res5 = $cxn->query($q5); } } else { $q = "INSERT INTO Misc_Material (Material_Outward_ID,Supplier_ID,Material_Desc,Misc_Qty,Misc_Remarks)\n\t\t\tVALUES({$this->moutwardid},{$this->supplierid},'{$this->miscdec}',{$this->qty},'{$this->remark}')"; //print("<br>$q"); if (!($res = $cxn->query($q))) { echo "error :", $cxn->error; } } }
$part->setPartDetails(); $pdf->MultiCell(80, 8, $part->getPartName() . " " . $part->getDrawingNO() . ' Rev No: ' . $part->getPartRevision(), 0, 'L', 0, 0, '', '', true, 0, false, true, 8, 'M', true); //part name and drawing no $pdf->Cell(35, 8, $dq_list[$j][1], 0, 0, 'C'); //total quantity $pdf->Cell(50, 8, $dq_list[$j][2], 0, 1, 'L'); //remarks for each part ///print material receipt details if ($cqr_list[$j][0] != '') { $t = 0; while ($t < $dq_list[$j][1]) { $t += $cqr_list[$l][2]; $pdf->SetFont('helvetica', 'I', 8); //body font $pma = new PartMaterial(); $pma->setMIDQID($cqr_list[$l][1]); $pma->setPartMaterialDetails(); if ($custid == 3 || $custid == 10) { $pdf->Cell(50, 7, 'GP No: ' . $pma->getGpno() . " Dated: " . $pma->getGpDate(), 0, 0, 'L'); $pdf->Cell(50, 7, ",DA No: " . $pma->getDano() . " Dated: " . $pma->getDaDate(), 0, 0, 'L'); $pdf->Cell(50, 7, ",Ex Ch No: " . $pma->getExchallanno() . " Dated: " . $pma->getExchallandate(), 0, 1, 'L'); } else { $pdf->Cell(20, 7, '', 0, 0, 'C'); $pdf->MultiCell(80, 7, 'Ex Ch No: ' . $pma->getExchallanno() . " Dated: " . $pma->getExchallandate() . ', Qty: ' . $cqr_list[$l][2], 0, 'L', 0, 1, '', '', true, 0, false, true, 7, 'M', true); //part name and drawing no // $pdf->Cell(50,7,'Ex Ch No: '.$pma->getExchallanno()." Dated: ".$pma->getExchallandate(),0,0,'L'); } // $pdf->Cell(15,7," Qty: ".$cqr_list[$l][2],0,1,'L'); $l++; } }
$l = count($partlist); $i = 0; while ($i < $l) { $mi->setPartID($partlist[$i][0]); $mi->setQuantity($partlist[$i][1]); $mi->setMaterialCode($partlist[$i][2]); $mi->setRackno($partlist[$i][3]); $mi->savePartMaterial(); $i += 1; } } if ($emidqid != '') { $l = count($emidqid); $i = 0; while ($i < $l) { $mi->setMIDQID($emidqid[$i]); $mi->setQuantity($eqty[$i]); $mi->setMaterialCode($emcode[$i]); $mi->setRackno($racknoe[$i]); $mi->savePartMaterial(); $i++; } } if ($tdel != '') { $mi->delPartQuantites($tdel); } } else { if (isset($_GET['did'])) { $mi->showPartInwardUI(); } if (isset($_GET['t'])) {