$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'];
