$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName']; $email = $emailArr[$i]['vEmail']; $post_arr = array($smname, $sess_user_name . "({$sess_usertype_short})", $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link, $MAIL_FOOTER, SITE_URL); $sendMail->Send("{$sub}", "Member", $email, $body_arr, $post_arr); } } } // } // if ($res && trim($sub) != '' && $sub == 'New Bid For RFQ2' && $id > 0) { $bdtls = $r2bdObj->select($id); if (is_array($bdtls) && count($bdtls) > 0) { //set rfq2 best bid $udt = array('fBestBidAdvance' => $bdtls[0]['fBidAdvanceTotal'], 'fBestBidPrice' => $bdtls[0]['fBidPriceTotal'], 'fBestBidAmount' => $bdtls[0]['fBidAmount']); $rs = $rfq2Obj->updateData($udt, " iRFQ2Id=" . $bdtls[0]['iRFQ2Id'] . " "); // set status of all other bids for rfq2 as outbided, $rs = $r2bdObj->setAuctionAllBidStatus($id); $rfq2dtls = $rfq2Obj->select($bdtls[0]['iRFQ2Id']); $orgdtls = $orgObj->select($dtls[0]['iBuyer2Id']); if ($rfq2dtls[0]['eAuctionType'] == 'Auction') { // send email to users of those org with create status $emailArr = array(); $sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Bid,%' AND vStatus_en='Create' "); $csts = $sts[0]['iStatusID']; $orgin = "Select DISTINCT r2pb.iBuyer2Id from " . PRJ_DB_PREFIX . "_rfq2_product_buyer2 r2pb where iRFQ2Id=" . $bdtls[0]['iRFQ2Id'] . ""; $b2orgs = $dbobj->MySQLSelect($orgin); $emailArr = $orgUsrObj->getPermittedUsers($orgin, "{$csts}%", '', 'vRFQ2BidPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ", 'y'); // pr($emailArr); exit; // $db_email = $emailObj->getDetails('*', " AND vType='{$sub}' AND eSection='Member' ");
} else { $msg = "raer"; } } else { $msg = "raer"; } // } else { if (trim(strtolower($view)) == 'reject') { $dtls = $r2bdObj->select($iBidId); if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iBidId']) && $dtls[0]['iBidId'] > 0 && isset($dtls[0]['iRFQ2Id']) && $dtls[0]['iRFQ2Id'] > 0) { $rsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Rejected' "); $ur2dt['iStatusID'] = $rsts[0]['iStatusID']; $ur2dt['iRejectedById'] = $sess_id; $ur2dt['eAuctionStatus'] = 'Cancelled'; $res = $rfq2Obj->updateData($ur2dt, " iRFQ2Id='" . $dtls[0]['iRFQ2Id'] . "'"); if ($res) { $msg = "rrs"; } else { $msg = 'rrer'; } } 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 ";
include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($sendMail)) { include SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } $ids = PostVar('val'); $mode = PostVar('mode'); if ($mode == 'delete' || $mode == 'deleteall') { if (trim($ids) != '') { $rsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Rejected' "); $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);
if (strtotime($Data['dStartDate']) - strtotime(calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s')) > 0 || $Data['eSaved'] == 'Yes') { $Data['eAuctionStatus'] = "Not Started"; } else { if (strtotime($Data['dEndDate']) - strtotime(calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s')) > 0) { $Data['eAuctionStatus'] = "Live"; } else { if ($Data['dStartDate'] == $Data['dEndDate']) { $Data['eAuctionStatus'] = "Completed"; } else { $Data['eAuctionStatus'] = "Cancelled"; } } } } //pr($Data); exit; $res = $rfq2Obj->updateData($Data, " iRFQ2Id={$iRFQ2Id} "); if ($res > 0) { $opatype = trim($orgas) == 'Buyer' ? 'BProduct' : ($orgas == 'Supplier' ? 'SProduct' : ''); $atbl = $opatype == 'BProduct' ? PRJ_DB_PREFIX . "_buyer2_buyer_bproduct_association" : ($opatype == 'SProduct' ? PRJ_DB_PREFIX . "_buyer2_supplier_sproduct_association" : ''); $absfld = $opatype == 'BProduct' ? "iBuyerId" : ($opatype == 'SProduct' ? "iSupplierId" : ''); if (is_array($abdata) && count($abdata) > 0 && $iProductId > 0 && $curORGID > 0 && $atbl != '') { $drs = $rpb2Obj->del(" iRFQ2Id={$iRFQ2Id} "); for ($l = 0; $l < count($abdata); $l++) { $sql = "Select iAssociationId from {$atbl} where iProductId={$iProductId} AND {$absfld}={$curORGID} AND iBuyer2Id=" . $abdata[$l]; $adt = $dbobj->MySQLSelect($sql); if (isset($adt[0]['iAssociationId']) && $adt[0]['iAssociationId'] > 0) { $adata['iRFQ2Id'] = $id; $adata['iBuyer2Id'] = $abdata[$l]; $adata['iAssociationId'] = $adt[0]['iAssociationId']; $adata['ePType'] = $opatype; $adata['dADate'] = calcGTzTime(date('Y-m-d'), 'Y-m-d');
} } // if ($prv_dtls[0]['eFrom'] == "Invoice") { $ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $prv_dtls[0]['iInvoiceID'] . " "); } else { if ($prv_dtls[0]['eFrom'] == "PO") { $ress = $purOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $prv_dtls[0]['iPurchaseOrderID'] . " "); if ($prv_dtls[0]['iPurchaseOrderID'] != "0" && $prv_dtls[0]['iPurchaseOrderID'] != "") { $inv_det = $invOrdObj->getDetails('*', " AND iPurchaseOrderID = '" . $prv_dtls[0]['iPurchaseOrderID'] . "' "); $rfq2_dets = $rfq2Obj->getDetails('*', " AND iInvoiceID = '" . $inv_det[0]['iInvoiceID'] . "' "); if (count($rfq2_dets) > 0) { $rfq2_dtls['fPOAwardAdvace'] = $prv_dtls[0]['fBidAdvanceTotal']; $rfq2_dtls['fPOAwardPrice'] = $prv_dtls[0]['fBidPriceTotal']; $rfq2_dtls['fPOAwardAmount'] = $prv_dtls[0]['fBidAmount']; $ress = $rfq2Obj->updateData($rfq2_dtls, " iRFQ2Id=" . $prv_dtls[0]['iRFQ2Id'] . " "); } } } } } } } } else { $msg = 'rver'; } } else { if ($view == 'reject') { $rsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Rejected' "); $nsts = $rsts[0]['iStatusID']; $data['iStatusID'] = $rsts[0]['iStatusID'];