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;
}
}
}
}
$holderstock->createHolderStockList();
$sel = new selectlist('Holder_Stock_ID', $holderstock->getHolderStockList(), 'Select Holder Stock', 'Holder_Stock_ID', 'tsid', '', '');
break;
case 'minward':
//material inward
$mi = new Material();
if (isset($_GET['cid'])) {
$mi->setCustID($_GET['cid']);
}
$mi->createMaterialInwardList();
$sel = new selectlist('Material_Inward_ID', $mi->getMaterialInwardList(), 'Select Challan', 'Material_Inward_ID', 'refer', '', '');
break;
case 'pmlist':
//part material inward list
$mi = new PartMaterial();
if (isset($_GET['miid'])) {
$mi->setInwardID($_GET['miid']);
}
$mi->createPartMaterialList();
$sel = new selectlist('MI_Drg_Qty_ID', $mi->getPartMaterialList(), 'Select Part', 'MI_Drg_Qty_ID', 'des', '', '');
break;
case 'batch':
//batch details for editing
$bn = new Batch();
if (isset($_GET['did'])) {
$bn->setPartID($_GET['did']);
}
if (isset($_GET['openonly'])) {
$bn->setOpenOnly($_GET['openonly']);
}
$part->setPartID($dq_list[$j][0]);
$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++;
}
<?php
require_once 'autoload.php';
$mi = new PartMaterial();
if (isset($_POST['exchallanno']) || isset($_POST['prefno'])) {
//print_r($_POST);
//var_dump($_FILES);
if (isset($_POST['Material_Inward_ID'])) {
$mi->setInwardID($_POST['Material_Inward_ID']);
}
if (isset($_POST['exchallanno'])) {
$mi->setExchallanNo($_POST['exchallanno']);
}
if (isset($_POST['exchallandatedb'])) {
$mi->setExchallanDate($_POST['exchallandatedb']);
}
if (isset($_POST['dano'])) {
$mi->setDano($_POST['dano']);
}
if (isset($_POST['dadatedb'])) {
$mi->setDaDate($_POST['dadatedb']);
}
if (isset($_POST['gpno'])) {
$mi->setGpno($_POST['gpno']);
}
if (isset($_POST['gpdatedb'])) {
$mi->setGpDate($_POST['gpdatedb']);
}
if (isset($_POST['prefno'])) {
$mi->setPurchaseRef($_POST['prefno']);
}
