// $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'];