} } } else { $Data['iSubQuantity'] = 0; $Data['fSubRate'] = 0; $Data['fSubAmount'] = 0; } } } if ($Data['fLineTotal'] <= 0) { // $Data['fAmount']<=0 || continue; } // pr($Data); // exit; if ($view == '' || $view == 'add') { $ilineItemCode[] = $vItmCode = $invLineObj->getUniqueCode(); $Data['vItemCode'] = $vItmCode; $vInvItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_invoice_detail_line", "iLineNumber", $charlimit = "10"); $Data['iLineNumber'] = $vInvItemLineNumber; $Data['dCreatedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $invLineObj->setAllVar($Data); $id = $invLineObj->insert(); if ($id) { $msg = "ras"; } else { $msg = "raserr"; } } else { if ($view == 'edit') { $invdtls = $invLineObj->getDetails('*', " AND vItemCode='" . $Data['vItemCode'] . "'"); if (count($invdtls) > 0 && is_array($invdtls)) {
$in = $iohObj->insert(); $poitems = $poLineObj->getDetails('*', " AND iPurchaseOrderID={$iPurchaseOrderID}"); // prints($poitems); exit; for ($l = 0; $l < count($poitems); $l++) { $invItems = $poitems[0]; $invItems['iRelatedPurchaseOrderLineID'] = $invItems['iOrderLineID']; unset($invItems['iOrderLineID']); unset($invItems['dETA']); unset($invItems['iRelatedInvoiceLineID']); // $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 = $invLineObj->getUniqueCode(); $vInvItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_invoice_detail_line", "iLineNumber", $charlimit = "10"); $invItems['vItemCode'] = $vItemCode; $invItems['iLineNumber'] = $vInvItemLineNumber; $invItems['dCreatedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $invItems['iInvoiceID'] = $in; // prints($invItems); exit; $invLineObj->setAllVar($invItems); $itm = $invLineObj->insert(); } } // mail if ($in > 0) { $sub1 = "New Invoice Created"; $type = "Create"; $sub2 = "New Invoice";
$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['dCreatedDate'] = date('Y-m-d H:i:s'); $Data_item['iInvoiceID'] = $id; $Data_item['iLineNumber'] = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_invoice_detail_line", "iLineNumber", $charlimit = "10"); $poLineObj->setAllVar($Data_item); $dupit = $poLineObj->chkDuplicate('iLineNumber', $Data_item); if ($dupit > 0) { $id_items = $poLineObj->updateData($Data_item, " iInvoiceLineID = {$dupit} "); $id_items = $dupit; } else { $id_items = $poLineObj->insert(); } } } }