} } else { $Data['iSubQuantity'] = 0; $Data['fSubRate'] = 0; $Data['fSubAmount'] = 0; } } } if ($Data['fLineTotal'] <= 0) { // $Data['fAmount']<=0 || continue; } // echo $view; // prints($Data); // exit; if ($view == '' || $view == 'add') { $ilineItemCode[] = $vItmCode = $poLineObj->getUniqueCode(); $Data['vItemCode'] = $vItmCode; $vPOItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10"); $Data['iLineNumber'] = $vPOItemLineNumber; $Data['dETA'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $poLineObj->setAllVar($Data); $id = $poLineObj->insert(); if ($id) { $msg = "ras"; } else { $msg = "raserr"; } } else { if ($view == 'edit') { $podtls = $poLineObj->getDetails('*', " AND vItemCode='" . $Data['vItemCode'] . "'"); if (count($podtls) > 0 && is_array($podtls)) {
$po = $pohObj->insert(); $poitems = $invLineObj->getDetails('*', " AND iInvoiceID={$iInvoiceID}"); // prints($poitems); exit; for ($l = 0; $l < count($poitems); $l++) { $invItems = $poitems[$l]; $invItems['iRelatedInvoiceLineID'] = $invItems['iInvoiceLineID']; unset($invItems['iInvoiceLineID']); unset($invItems['dCreatedDate']); unset($invItems['iRelatedPurchaseOrderLineID']); // $vItemCode = $invItems['vItemCode']; // prints($vItemCode); exit; // $invitmdtl = $invLineObj->getDetails('*'," AND vItemCode=$vItemCode"); /* if(count($invitmdtl) > 0) { $vItemCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_invoice_detail_line","vItemCode"); } */ $vItemCode = $poLineObj->getUniqueCode(); $vPOItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10"); $invItems['vItemCode'] = $vItemCode; $invItems['iLineNumber'] = $vPOItemLineNumber; $invItems['dETA'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $invItems['iPurchaseOrderID'] = $po; // prints($invItems); exit; $poLineObj->setAllVar($invItems); $itm = $poLineObj->insert(); } } // mail if ($po > 0) { $sub1 = "Purchase Order Created"; $type = "Create"; $actn = "Create";
$it = 0; foreach ($itemTagArr as $itemkey1 => $itemval1) { if ($type == '.xml') { $itemkey1 = strtolower(str_replace(" ", "", $itemkey1)); $Data_item[$itemval1] = trim($itemvals[$itemkey1]); } else { $Data_item[$itemval1] = trim($itemvals[$it]); } $it++; } if ($enc == 'y') { foreach ($Data_item as $k => $v) { $Data_item[$k] = $encobj->mdecrypt($v); } } $itmCode = $poLineObj->getUniqueCode(); $Data_item['vItemCode'] = $itmCode; $Data_item['dETA'] = date('Y-m-d H:i:s'); $Data_item['iPurchaseOrderID'] = $id; $Data_item['iLineNumber'] = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10"); $poLineObj->setAllVar($Data_item); $dupit = $poLineObj->chkDuplicate('iLineNumber', $Data_item); if ($dupit > 0) { $id_items = $poLineObj->updateData($Data_item, " iOrderLineID = {$dupit} "); $id_items = $dupit; } else { $id_items = $poLineObj->insert(); } } } }