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;