} } } 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 { $ilineItemCode[] = $vItmCode = $invLineObj->getUniqueCode();
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']); $orginvstatus = $orgpref['inv'];
} 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'; } @unlink($filepath); header("Location:" . SITE_URL . "importinvoice/{$var_msg}"); exit;