//$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#"); $tbody_en = str_replace($rplarr, " ", $db_email[0]['tBody_en']); $emailContent_en = trim(str_replace($body, $post, $tbody_en));
} $act = $statusmasterObj->getDetails('vStatus_en', " AND iStatusID=" . $dt['iaStatusID']); } $dt['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; // prints($dt); exit; $nsts = $dt['iStatusID']; if (isset($_POST['Data']['fAcceptedAmount']) && $dt['iaStatusID'] > 0) { $dt['fAcceptedAmount'] = $_POST['Data']['fAcceptedAmount']; $dt['dAcceptedVat'] = $_POST['Data']['dAcceptedVat']; $dt['dAcceptedOtherTax'] = $_POST['Data']['dAcceptedOtherTax']; $dt['dAcceptedWHTax'] = $_POST['Data']['dAcceptedWHTax']; $dt['dAcceptedNetPaymentDate'] = $_POST['Data']['dAcceptedNetPaymentDate']; } // pr($_POST); // pr($dt); exit; $id = $invOrdObj->updateData($dt, " iInvoiceID={$iInvoiceID} "); $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR']; $res = $userActionObj->updateData($vrfydt, "iItemID={$iInvoiceID} AND eSubject='Invoice'"); // prints($act); exit; if ($id) { $act = $act[0]['vStatus_en']; if ($dt['iaStatusID'] == $cstsdtl[0]['iStatusID']) { $sub1 = "New Invoice Created"; $type = "Create"; $actn = "Create"; $sub2 = "New Invoice"; $vorgid = $invdtl[0]['iBuyerOrganizationID']; } else {
$ioextdtls = $ioprefObj->getDetails("*", " AND iInvoiceID={$iInvoiceID} "); // prints($ioextdtls); exit; if (is_array($ioextdtls) && count($ioextdtls) > 0) { $rs = $ioprefObj->updateData($Data, "iInvoiceID={$iInvoiceID}"); $msg = "rus"; } else { $rs = $ioprefObj->insert($Data); $msg = "ras"; } $eSaved = $_POST['eSaved']; $_SESSION['invadd'] = 'yes'; if ($rs > 0) { if ($eSaved == 'Yes') { $dtl['eSaved'] = $eSaved; $wh_cn = "iInvoiceID={$iInvoiceID}"; $rs = $iohObj->updateData($dtl, $wh_cn); if ($eFrom == "Next") { $redirecturl = SITE_URL_DUM . "invoiceadditems/{$iInvoiceID}/sucss"; } else { $redirecturl = SITE_URL_DUM . "invoicelist/{$msg}"; } $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg; } else { $redirecturl = SITE_URL_DUM . "invoiceadditems/{$iInvoiceID}/sucss"; } } else { $redirecturl = SITE_URL_DUM . "invpref/{$iInvoiceID}/rerr"; } header("Location: {$redirecturl}"); exit; //------------------------------------------------------------------------------------------------------------------------------------------------
} if ($id) { $msg = "rus"; } else { $msg = "ruserr"; } } } } // echo "$subt<br/>$dist<br/>$chgt<br/>$ltl"; // exit; $eSaved = $_POST['eSaved']; if ($eSaved != '') { $dtl['eSaved'] = $eSaved; $wh_cn = "iInvoiceID={$iInvoiceID}"; $rs = $invOrdObj->updateData($dtl, $wh_cn); if ($rs && $eSaved != 'Yes') { $sub1 = "New Invoice Created"; $type = "Create"; $actn = "Create"; $sub2 = "New Invoice"; } // /*if($rs && trim($sub1)!='') { $dt = array(); $dt['iItemID'] = $id = $iInvoiceID; $dt['eSubject'] = $sub1; $dt['eType'] = $type; $dt['vAction'] = $actn; $where = "AND vType='$sub1' AND eSection='Member'" ;
if ($r2awid > 0) { // if (!isset($rfq2extractObj)) { include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Extract.php"; $rfq2extractObj = new RFQ2Extract(); } # // need to chqange this array $redtl = array('iRFQ2Id' => $dtls[0]['iRFQ2Id'], 'iBuyer2Id' => $dtls[0]['iBuyer2Id'], 'iBuyerId' => $dtls[0]['iBuyerOrganizationId'], 'iSupplierId' => $dtls[0]['iSupplierOrganizationId'], 'iInvoiceID' => $dtls[0]['iInvoiceID'], 'iPurchaseOrderID' => $dtls[0]['iPurchaseOrderID'], 'vCurrency' => $dtls[0]['vCurrency'], 'dReviewDate' => date('Y-m-d', strtotime("+5 day", strtotime(date('Y-m-d')))), 'eFrom' => $dtls[0]['eFrom']); $re = $rfq2extractObj->insert($redtl); // set invoice rfq2awarded yes if ($dtls[0]['eFrom'] == 'Invoice') { if (!isset($invOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $invOrdObj = new InvoiceOrderHeading(); } $ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $dtls[0]['iInvoiceID']); } else { if ($dtls[0]['eFrom'] == 'PO') { if (!isset($poOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $poOrdObj = new PurchaseOrderHeading(); } $ress = $poOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $dtls[0]['iPurchaseOrderID']); } } //send mail to buyer2 for award. $db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' "); $orgdtls = $orgObj->select($dtls[0]['iOrganizationID']); $link = SITE_URL . "b2rfq2awardview/" . $r2awid; $body = array("#CREATED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#"); $post = array($orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link);
$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']; $orgdt = $orgObj->select($curORGID); $code[] = $orgdt[0]['vOrganizationCode'] . $orgdt[0]['iOrganizationID']; $code[] = $orgdt[0]['dCreatedDate']; if (isset($encobj) && $encobj != '') {
<?php $invid = PostVar('iInvoiceID'); if (!isset($invOrderObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $invOrderObj = new InvoiceOrderHeading(); } $invdtls = $invOrderObj->select($invid); if ($view == 'bifp' && trim($invid) != '' && $invid > 0 && is_array($invdtls) && count($invdtls) > 0 && isset($invdtls[0]['eSaved']) && $invdtls[0]['eSaved'] == 'Yes') { $Data = isset($_POST['Data']) ? $_POST['Data'] : array(); $invdtls[0]['iaStatusID'] = '1'; $Data['eSaved'] = 'No'; $rs = $invOrderObj->updateData($Data, " iInvoiceID={$invid} "); } $msg = ''; // 'invc'; $redirecturl = SITE_URL_DUM . "invacptlist/" . $msg; header("Location:" . $redirecturl); exit;