if ($res) {
$orgdtls = $orgObj->select($iOrganizationID);
/*if($orgdtls[0]['eOrganizationType'] == 'Supplier'){
$opdt['vOrderStatusLevel'] = '';
$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
} else if($orgdtls[0]['eOrganizationType'] == 'Buyer'){
$opdt['vInvoiceStatusLevel'] = '';
$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
}*/
$rs = $orgUserPermObj->clearExtraPermits($iOrganizationID, $orgdtls[0]['eOrganizationType']);
// $rs = $orgUserPermObj->clearExPermits($iOrganizationID,$orgdtls[0]['eOrganizationType'],$Data1);
}
//INSERT THIS RECORD IN USER_ACTION_VERIFICATION TABLE
if (count($arr) > 0) {
$where = 'AND vType="Organization Preference Updated" AND eSection = "Member"';
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL_DUM . "organizationprefview/" . $iOrganizationID;
$body = array("#SMNAME#", "#CNAME#", "#LINK#", "#MODIFIED_BY#", "#REGNO#", "#ORGCODE#");
$post = array($sname, $cname, $link, $sess_user_name . "({$sess_usertype_short})", $regno, $code);
$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));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
//prints($emailContent);exit;
$Data['iItemID'] = $res;
$Data['iOrganizationID'] = $iOrganizationID;
$Data['eSubject'] = 'OA';
$Data['eType'] = 'Modified';
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
}
$rs = false;
$type = '';
$esubtyp = '';
if ($mode == 'status' && trim($vl) != '') {
$sql1 = "UPDATE " . PRJ_DB_PREFIX . "_buyer2_buyer_association SET eStatus = IF(eStatus='Inactive','Active','Inactive'), eNeedToVerify='Yes', eModifiedBy='" . $sess_usertype_short . "', iModifiedByID='" . $sess_id . "', dModifiedDate='" . date('Y-m-d H:i:s') . "', eVerifiedBy='', iVerifiedByID='', dVerifiedDate='', eRejectedBy='', iRejectedByID='', dRejectedDate='' WHERE iAssociationId IN ({$vl})";
$sql2 = "INSERT INTO b2b_buyer2_buyer_association_toverify\r\n (iAssociationId,iBuyer2Id,iBuyerId,vACode,vAccount1,vAcc1Code,vCurrency1,vAccount2,vAcc2Code,vCurrency2,dADate,vFromIP,iCreatedByID,eCreatedBy,iModifiedByID,eModifiedBy,dModifiedDate,iRejectedByID,eRejectedBy,dRejectedDate,iVerifiedByID,eVerifiedBy,dVerifiedDate,tReasonToReject,eNeedToVerify,eStatus)\r\n SELECT * FROM b2b_buyer2_buyer_association WHERE iAssociationId IN ({$vl})";
// $rs = $dbobj->dotransaction($sqls);
$rs = $dbobj->sql_query($sql1);
if ($rs) {
$r = $dbobj->sql_query($sql2);
//
$msg = $smarty->get_template_vars('MSG_STATUS_SENT_SUCC');
$esubtyp = 'Buyer2 Buyer Association Status Changed';
$whr_cndt = " AND vType='{$esubtyp}' AND eSection='Member' ";
$email_cnt = $emailObj->getDetails('*', $whr_cndt);
$type = "Modified";
$body = array("#BUYER2#", "#BUYER#", "#ACODE#", "#LINK#", "#MODIFIED_BY#");
} else {
$msg = $smarty->get_template_vars('MSG_STATUS_SENT_ERR');
}
} else {
if (($mode == 'delete' || $mode == 'deleteall') && trim($vl) != '') {
$sql1 = "UPDATE " . PRJ_DB_PREFIX . "_buyer2_buyer_association SET eStatus='Delete', eNeedToVerify='Yes', eModifiedBy='" . $sess_usertype_short . "', iModifiedByID='" . $sess_id . "', dModifiedDate='" . date('Y-m-d H:i:s') . "', eVerifiedBy='', iVerifiedByID='', dVerifiedDate='', eRejectedBy='', iRejectedByID='', dRejectedDate='' WHERE iAssociationId IN ({$vl})";
$sql2 = "INSERT INTO b2b_buyer2_buyer_association_toverify\r\n (iAssociationId,iBuyer2Id,iBuyerId,vACode,vAccount1,vAcc1Code,vCurrency1,vAccount2,vAcc2Code,vCurrency2,dADate,vFromIP,iCreatedByID,eCreatedBy,iModifiedByID,eModifiedBy,dModifiedDate,iRejectedByID,eRejectedBy,dRejectedDate,iVerifiedByID,eVerifiedBy,dVerifiedDate,tReasonToReject,eNeedToVerify,eStatus)\r\n SELECT * FROM b2b_buyer2_buyer_association WHERE iAssociationId IN ({$vl})";
// $rs = $dbobj->dotransaction($sqls);
$rs = $dbobj->sql_query($sql1);
if ($rs) {
$r = $dbobj->sql_query($sql2);
//
$msg = $smarty->get_template_vars('MSG_DEL_SENT_SUCC');
$updt['eStatus'] = 'rejected';
$updt['tReasonToReject'] = Postvar('tReasonToReject');
$res = $r2bdObj->updateData($updt, " iBidId={$iBidId} ");
if ($res) {
$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'];
$vrfydt['vAction'] = 'Rejected';
$ivid = $userActionObj->getDetails('iVerifiedID', " AND iItemID={$iBidId} AND eSubject='RFQ2 Bid' ", " iVerifiedID DESC ");
if (isset($ivid[0]['iVerifiedID']) && trim($ivid[0]['iVerifiedID']) != '' && $ivid[0]['iVerifiedID'] > 0) {
$ivid = $ivid[0]['iVerifiedID'];
$rs = $userActionObj->updateData($vrfydt, " iVerifiedID={$ivid} ");
}
//
$db_email = $emailObj->getDetails('*', " AND vType='RFQ2 Bid Rejected' AND eSection='Member' ");
if (is_array($db_email) && count($db_email) > 0) {
$link = SITE_URL . "viewsrfq2bid/" . $id;
$body_arr = array("#REJECTED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#");
$post = array($sess_user_name . "({$sess_usertype_short})", $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link);
$rplarr = array("Hello #USER#,", "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));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
$dt = array();
$dt['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
*/
if (!isset($emailTempObj)) {
include_once SITE_CLASS_APPLICATION . "class.EmailTemplate.php";
$emailTempObj = new EmailTemplate();
}
$gdbobj->getRequestVars();
$view = GetVar("view");
$iFormatId = GetVar("iFormatId");
$actionfile = GetVar("file");
$arr = array();
$bdt = array();
if (count($_POST) > 0) {
$arr[0] = $_POST;
} else {
if ($view == 'edit') {
$arr = $emailTempObj->getDetails("*", "AND iFormatId = '{$iFormatId}'");
//prints($arr);exit;
$bodytext = strip_tags(stripslashes($arr[0]['tBody_en']));
//$bdt = array();
$bt = preg_match_all('/\\#(.*)\\#/', $bodytext, $bdt);
//prints($bdt);exit;
} else {
$view = "add";
}
}
$arr[0]['eSection'] = isset($arr[0]['eSection']) ? $arr[0]['eSection'] : '';
$arr[0]['vType'] = isset($arr[0]['vType']) ? $arr[0]['vType'] : '';
$arr[0]['vSub_en'] = isset($arr[0]['vSub_en']) ? $arr[0]['vSub_en'] : '';
$arr[0]['vSub_fr'] = isset($arr[0]['vSub_fr']) ? $arr[0]['vSub_fr'] : '';
$bdt[0] = isset($bdt[0]) ? $bdt[0] : '';
include_once CK_EDITOR_PATH . 'ckeditor.php';
}
} else {
$msg = 'rrer';
}
}
}
if (trim(strtolower($view)) == 'award') {
//
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on r2bd.iStatusID=sm.iStatusID\r\n\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id ";
$where .= " AND r2bd.iBidId={$iBidId} ";
$fields = " r2bd.*, rfq2.*, sm.vStatus_en as vStatus, r2bd.eSaved ";
$dtls = $r2bdObj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
//
if ($sacpt == 'y') {
//
$db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' ");
$orgdtls = $orgObj->select($dtls[0]['iOrganizationID']);
$link = SITE_URL . "b2rfq2awardview/" . $id;
$body_arr = 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);
$rplarr = array("Hello #NAME#,", "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));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
$dt = array();
$dt['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$rsts = $rsts[0]['iStatusID'];
$dt['iModifiedById'] = $sess_id;
$dt['eDelete'] = 'Yes';
$res = $rfq2Obj->updateData($dt, " iRFQ2Id IN ({$ids}) AND iStatusID={$rsts} ");
//
if ($res) {
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n\t\t\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ioh on rfq2.iInvoiceID=ioh.iInvoiceID\r\n\t\t\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on org.iOrganizationID=rfq2.iOrganizationID ";
$where .= " AND iRFQ2Id IN ({$ids}) AND iStatusID={$rsts} ";
$fields = " DISTINCT rfq2.*, ioh.*, org.*, sm.vStatus_en as vStatus, rfq2.eSaved ";
$dtls = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
if (is_array($dtls) && count($dtls) > 0) {
for ($l = 0; $l < count($dtls); $l++) {
// $orgdtls = $orgObj->select($dtls[0]['iOrganizationID']);
//if(is_array($dtls) && count($dtls)>0 && is_array($orgdtls) && count($orgdtls)>0)
//{
$db_email = $emailObj->getDetails('*', " AND vType='RFQ2 Deleted' AND eSection='Member' ");
$link = SITE_URL . "rfq2view/" . $id;
$body = array("#CREATEDBY#", "#RFQ2CODE#", "#INVOICECODE#", "#STARTDATE#", "#ENDDATE#", "#TYPE#", "#LINK#");
$post = array($dtls[$l]['vCompanyName'] . '(' . $dtls[$l]['vOrganizationCode'] . ')', $dtls[$l]['vRFQ2Code'], $dtls[$l]['vInvoiceCode'], $dtls[$l]['dStartDate'], $dtls[$l]['dEndDate'], $link);
$rplarr = array("Hello #NAME#,", "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));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
$dt['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[$l]['iOrganizationID'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$dt['tMailContent_fr'] = $emailContent_fr;
$dt['eSubject'] = "RFQ2";
$data['iVerifiedById'] = $sess_id;
$asts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Accepted' ");
if ($data['iaStatusID'] == $asts[0]['iStatusID']) {
$data['iStatusID'] = $asts[0]['iStatusID'];
}
// pr($data);
// pr($nsts);
// pr($nxtk); exit;
$res = $rfq2awObj->updateData($data, " iAwardId={$iAwardId} ");
//
if ($res) {
$msg = 'rvs';
//
// if($nstatus[0]['vStatus_en']!='Auth3' && $nstatus[0]['vStatus_en']!='Accepted')
// {
$db_email = $emailObj->getDetails('*', " AND vType='RFQ2 Award Status Changed' AND eSection='Member' ");
$link = SITE_URL . "rfq2awardview/" . $iAwardId;
$body_arr = array("#MODIFIED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#");
$post = array($sess_user_name . "({$sess_usertype_short})", $prv_dtls[0]['vRFQ2Code'], $prv_dtls[0]['vBidNum'], $prv_dtls[0]['fBidAdvanceTotal'], $prv_dtls[0]['fBidPriceTotal'], $link);
$rplarr = array("Hello #NAME#,", "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));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
$dt = array();
$dt['iItemID'] = $iAwardId;
$dt['iOrganizationID'] = $curORGID;
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$dt['tMailContent_fr'] = $emailContent_fr;
