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