} } 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)) { $ilineItemCode[] = $Data['vItemCode']; $where = " vItemCode='" . $Data['vItemCode'] . "'"; unset($Data['vItemCode']); $id = $poLineObj->updateData($Data, $where); // for adding/updating tax } else {
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"; $sub2 = "New Purchase Order"; $dt['iItemID'] = $po; $dt['eSubject'] = $sub1; $dt['eType'] = $type; $where = "AND vType='{$sub1}' AND eSection='Member'"; $db_email = $emailObj->getDetails('*', $where); $invdt = $pohObj->select($po); $orgpref = $orgprefObj->getStatusDetails($invdt[0]['iBuyerOrganizationID']);
} 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(); } } } } } if ($scs == 'y') { $var_msg = 'poimportsucc'; } else { $var_msg = 'poimporterr'; } @unlink($filepath); header("Location:" . SITE_URL . "importpurchaseorders/{$var_msg}"); exit;