}
}
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;
