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