// $vInvoiceCode=$generalobj->UniqueID("INV",PRJ_DB_PREFIX."_inovice_order_heading","vInvoiceCode",$charlimit="10");
// $Data['iSupplierOrganizationID'] = $curORGID;
//
if ($uorg_type == 'Buyer' || $uorg_type == 'Both' && $frmbuyer == 'y') {
$icstsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$Data['iStatusID'] = $icstsdtls[0]['iStatusID'];
$Data['iaStatusID'] = 0;
}
//
$vInvoiceCode = $invOrdObj->getUniqueCode();
$Data['vInvoiceCode'] = $vInvoiceCode;
$vInvoiceNumber = "INV" . $Data['vInvoiceCode'] . "-" . trim($Data['vInvoiceSupplierCode']);
$Data['vInvoiceNumber'] = $vInvoiceNumber;
$Data['eDelete'] = 'No';
// pr($Data); exit;
$invOrdObj->setAllVar($Data);
$id = $invOrdObj->insert();
//exit;
//if($Data['eSaved']!='Yes')
//{
if ($id) {
$sub1 = "New Invoice Created";
$type = "Create";
$actn = "Create";
$sub2 = "New Invoice";
}
//}
if ($id) {
$files = $_FILES['files'];
$titles = $_POST['titles'];
$descprtiption = $_POST['descriptions'];
if ($totusrs > 1) {
if ($byrpf[0]['eReqVerifyInvAcpt'] == 'Yes') {
$invdt['iStatusID'] = '0';
} else {
if (trim($invstatus) != '') {
$invstatus = @explode(',', $invstatus);
sort($invstatus);
$invdt['iStatusID'] = $invstatus[0];
}
}
} else {
$invisusts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$invdt['iStatusID'] = $invisusts[0];
}
// prints($invdt); exit;
$iohObj->setAllVar($invdt);
$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");
} */
if ($mode == 'delete') {
$where = "AND iInvoiceID IN ({$val})";
//$fields="ioh.*,(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=ioh.iBuyerOrganizationID) as vBuyerName";
$fields = "*";
$arr = $invObj->getJoinTableInfo("", $fields, $where);
$userId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$orgId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGID'];
$where = " AND iOrganizationID='{$orgId}'";
$emailArr = $orgUserObj->getDetails('vFirstName,vLastName,vEmail', $where);
$where = "";
foreach ($arr as $k => $v) {
$data['eDelete'] = 'Yes';
$data['iModifiedByID'] = $userId;
// $data['eModifiedBy'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT'];
// $data['dModifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$invObj->setAllVar($data);
$where = "iInvoiceID IN (" . $v['iInvoiceID'] . ")";
$res = $invObj->updateData($data, $where);
$link = SITE_URL_DUM . "invoiceview/" . $v['iInvoiceID'];
$INVCODE = $v['vInvoiceCode'];
$INVNUMBER = $v['vInvoiceNumber'];
$SUPPLIER = $v['vSupplierName'];
if ($SUPPLIER == '') {
$SUPPLIER = "---";
}
$BUYER = $v['vBuyerName'];
$where = "AND vType='Invoice Deleted' AND eSection='Member'";
$db_email = $emailObj->getDetails('*', $where);
$body = array("#DELETE_BY#", "#INVNUMBER#", "#INVCODE#", "#SUPPLIER#", "#BUYER#", "#LINK#");
$post = array($sess_user_name . "({$sess_usertype_short})", $INVNUMBER, $INVCODE, $SUPPLIER, $BUYER, $link);
$rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
$Data['iSupplierID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['vSupplierContactParty'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
$supOrgDtls = $orgObj->select($curORGID);
$Data['vInvoiceSupplierCode'] = $supOrgDtls[0]['vOrganizationCode'];
$Data['vSupplierName'] = $supOrgDtls[0]['vCompanyName'];
$Data['vSupplierContactTelephone'] = $supOrgDtls[0]['vPhone'];
// $Data['vBuyerContactEmail'] = $supOrgDtls[0]['vEmail'];
$vItmCode = $pohObj->getUniqueCode();
$Data['vInvoiceCode'] = $vItmCode;
$vInvoiceNumber = "INV" . $vItmCode . "-" . trim($Data['vInvoiceSupplierCode']);
$Data['vInvoiceNumber'] = $vInvoiceNumber;
if (trim($Data['eSaved']) == '') {
$Data['eSaved'] = 'No';
}
// prints($Data); exit;
$pohObj->setAllVar($Data);
$iInvId = $pohObj->insert();
$vImage = $imgObj->ImageUpload('INV', 'image', $iInvId, $_FILES['importfile'], '');
$Dta['vImage'] = $vImage;
$iInvId = $pohObj->updateData($Dta, "iInvoiceID={$iInvId}");
$var_msg = 'invimportsucc';
@unlink($filepath);
header("Location:" . SITE_URL . "importinvoice/{$var_msg}");
exit;
}
$opf = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID} ");
if ($opf[0]['eSecureImportInvoice'] == 'Yes') {
$enc = 'y';
}
$encKey = $opf[0]['vEncryptionKey'];
$encAlgo = $opf[0]['eCryptAlgo'];
