$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)) {
$ilineItemCode[] = $Data['vItemCode'];
$where = " vItemCode='" . $Data['vItemCode'] . "'";
unset($Data['vItemCode']);
$id = $invLineObj->updateData($Data, $where);
} else {
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";
$dt['iItemID'] = $in;
$dt['eSubject'] = $sub1;
$dt['eType'] = $type;
$where = "AND vType='{$sub1}' AND eSection='Member'";
$db_email = $emailObj->getDetails('*', $where);
$invdt = $iohObj->select($in);
$orgpref = $orgprefObj->getStatusDetails($invdt[0]['iSupplierOrganizationID']);
} 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();
}
}
}
}
}
if ($scs == 'y') {
$var_msg = 'invimportsucc';
} else {
$var_msg = 'invimporterr';
