}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " r2bd.dBidDate DESC ";
}
## ENDS HERE ###
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
$jtbl = " INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on rfq2.iRFQ2Id=r2bd.iRFQ2Id\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ioh on rfq2.iInvoiceID=ioh.iInvoiceID\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on rfq2.iPurchaseOrderID=poh.iPurchaseOrderID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_rfq2_product_buyer2 rpb2 on rpb2.iRFQ2Id=rfq2.iRFQ2Id ";
// echo $where; exit;
// $where .= " AND rfq2.iStatusID!=$csts ";
// $where .= " AND rfq2.dStartDate<NOW() ";
$where .= " AND r2bd.eDelete!='Verified' AND r2bd.iBuyer2Id={$curORGID} ";
$fields = " DISTINCT r2bd.*, rfq2.*, IF(rfq2.eFrom='Invoice',ioh.vInvoiceCode,poh.vPOCode) as vInvoiceCode, IF(rfq2.eFrom='Invoice',ioh.fAcceptedAmount,poh.fPOTotal) as fAcceptedAmount, IF(rfq2.eFrom='Invoice',ioh.vBuyerName,poh.vBuyerCompanyName) as vBuyerName, IF(rfq2.eFrom='Invoice',ioh.vSupplierName,poh.vSupplierName) as vSupplierName, sm.vStatus_" . LANG . " as status, r2bd.eStatus, r2bd.eSaved, r2bd.eDelete,\r\n\t\t\t\t\tIF(rfq2.eAuctionStatus='Completed' || rfq2.eAuctionStatus='Cancelled', rfq2.eAuctionStatus, IF(rfq2.dStartDate<NOW() AND rfq2.dEndDate>NOW(),'Live', IF(rfq2.dStartDate>NOW() AND rfq2.dEndDate>NOW(),'Not Started', rfq2.eAuctionStatus)) ) as rfq2Status,\r\n\t\t\t\t\tIF(rpb2.ePType='BProduct',(Select vProductName from " . PRJ_DB_PREFIX . "_bproduct_organization where iProductId=rpb2.ePType), (Select vProductName from " . PRJ_DB_PREFIX . "_sproduct_organization where iProductId=rpb2.ePType) ) as vProductName";
// IF(rfq2.dStartDate<NOW() AND rfq2.dEndDate>NOW(), 'Live', IF(rfq2.dStartDate>NOW() AND rfq2.dEndDate>NOW(), 'Not Started', IF(rfq2.eAuctionStatus!='Completed' AND rfq2.eAuctionStatus!='Cancelled', 'Completed', rfq2.eAuctionStatus) ) ) as eStatus,
// "IF(rfq2.dStartDate>NOW(), TIMESTAMPDIFF(DAY,NOW(),rfq2.dStartDate), 0) as rdays, IF(rfq2.dStartDate>NOW(), TIME_FORMAT(SEC_TO_TIME(TIMESTAMPDIFF(SECOND,NOW(),rfq2.dStartDate) - (TIMESTAMPDIFF(DAY,NOW(),rfq2.dStartDate) * 24*60*60) ), '%H:%i'), 0) as rtime ";
$dtls = $r2bdObj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, 'r2bd.iBidId' . $having, $limit, 'yes');
// pr($dtls); exit;
$count = $dtls['tot'];
unset($dtls['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
$pgajxobj = new Paging($count, $page, "listrfq2bid", $REC_LIMIT_FRONT);
}
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
//echo $paging; exit;
$smarty->assign('dtls', $dtls);
$smarty->assign('isusts', $isusts);
$smarty->assign('count', $count);
$smarty->assign('paging', $paging);
$smarty->assign('pgmsg', $pgmsg);
}
if (!isset($r2awObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Award.php";
$r2awObj = new Rfq2Award();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$award_created = $r2awObj->getDetails('*', ' AND iBidId = "' . $iBidId . '" ');
//pr($award_created); exit;
$rs = $rfq2Obj->setAllRfq2Ststus();
$rfq2_awarded = 'n';
$jtbl = "INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ih ON rfq2.iInvoiceID=ih.iInvoiceID\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading ph ON rfq2.iPurchaseOrderID=ph.iPurchaseOrderID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm ON sm.iStatusID=r2bd.iStatusID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org ON org.iOrganizationID=r2bd.iBuyer2Id ";
$where = " AND r2bd.iBidId={$iBidId} ";
$bdtls = $r2bdObj->getJoinTableInfo($jtbl, " DISTINCT *, ph.vPOCode, ph.vSupplierName as ph_vSupplierName, ph.fPOTotal, rfq2.iOrganizationID, org.vCompanyName as vBuyer2, r2bd.eStatus, r2bd.eSaved, r2bd.eDelete, r2bd.iModifiedById, rfq2.fBestBidAdvance, rfq2.fBestBidPrice, rfq2.fBestBidAmount ", "{$where}", "", "", "", "");
//pr($bdtls); exit;
if (is_array($bdtls) && count($bdtls) > 0 && isset($bdtls[0]['iBidId']) && $bdtls[0]['iBidId'] > 0) {
$rfq2bidfiles = $r2bdflObj->getDetails("*", " AND iBidId=" . $bdtls[0]['iBidId']);
if (is_array($rfq2bidfiles) && count($rfq2bidfiles) > 0) {
for ($l = 0; $l < count($rfq2bidfiles); $l++) {
if (is_file($cfgimg['rfq2bid']['docs']['path'] . $rfq2bidfiles[$l]['iBidId'] . '/' . $rfq2bidfiles[$l]['vFile'])) {
$bidfiles = $rfq2bidfiles[$l]['vFile'];
$no = strpos($bidfiles, "_", "_");
$bidfiles = substr($bidfiles, $no + 1);
$no = strpos($bidfiles, "_", "_");
$bidfiles = substr($bidfiles, $no + 1);
$rfq2bidfilearr[$l]['iFileId'] = $rfq2bidfiles[$l]['iBidFileId'];
$rfq2bidfilearr[$l]['vFileName'] = $bidfiles;
$rfq2bidfilearr[$l]['vFile'] = $cfgimg['rfq2bid']['docs']['url'] . $rfq2bidfiles[$l]['iBidId'] . '/' . $rfq2bidfiles[$l]['vFile'];
}
}
if (!isset($invoiceorderObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderAttachment.php";
$invoiceorderObj = new InvoiceOrderAttachment();
}
if (!isset($r2bdflObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2BidFiles.php";
$r2bdflObj = new RFQ2BidFiles();
}
if (!isset($orgUserPermObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php";
$orgUserPermObj = new OrganizationUserPermission();
}
$jtbl = "INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user bu ON bu.iUserID=rfq2.iUserID\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ih ON rfq2.iInvoiceID=ih.iInvoiceID\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on rfq2.iPurchaseOrderID=poh.iPurchaseOrderID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm ON sm.iStatusID=r2bd.iStatusID ";
$where = "AND r2bd.iBidId={$iBidId}";
$bdtls = $r2bdObj->getJoinTableInfo($jtbl, " DISTINCT *, ih.iInvoiceID, poh.vSupplierName as poh_vSupplierName, r2bd.eStatus, r2bd.eSaved, r2bd.eDelete, r2bd.iModifiedById ", "{$where}", "", "", "", "");
if (is_array($bdtls) && count($bdtls) > 0 && isset($bdtls[0]['iBidId']) && $bdtls[0]['iBidId'] > 0) {
if ($uorg_type == 'Buyer2' && $bdtls[0]['iBuyer2Id'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "b2rfq2bidlist");
exit;
}
$rfq2bidfiles = $r2bdflObj->getDetails("*", " AND iBidId=" . $bdtls[0]['iBidId']);
if (is_array($rfq2bidfiles) && count($rfq2bidfiles) > 0) {
for ($l = 0; $l < count($rfq2bidfiles); $l++) {
if (is_file($cfgimg['rfq2bid']['docs']['path'] . $rfq2bidfiles[$l]['iBidId'] . '/' . $rfq2bidfiles[$l]['vFile'])) {
$bidfiles = $rfq2bidfiles[$l]['vFile'];
$no = strpos($bidfiles, "_", "_");
$bidfiles = substr($bidfiles, $no + 1);
$no = strpos($bidfiles, "_", "_");
$bidfiles = substr($bidfiles, $no + 1);
$rfq2bidfilearr[$l]['iFileId'] = $rfq2bidfiles[$l]['iBidFileId'];
//
if ($b2rfq2sts == 'completed') {
$rsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Rejected' ");
$rsts = $rsts[0]['iStatusID'];
$jtbl = "INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ih ON rfq2.iInvoiceID=ih.iInvoiceID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm ON sm.iStatusID=r2bd.iStatusID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org ON org.iOrganizationID=r2bd.iBuyer2Id ";
$where = " AND r2bd.iRFQ2Id=" . $bdtls[0]['iRFQ2Id'] . " AND r2bd.iBidId NOT IN (Select iBidId from " . PRJ_DB_PREFIX . "_rfq2award_master where iStatusID={$rsts}) AND iBidId!=" . $bdtls[0]['iBidId'] . " AND r2bd.eSaved!='Yes' AND r2bd.eStatus Not IN ('pending','rejected') ";
// AND r2bd.iBidId!=".$bdtls[0]['iBidId']."
$orderby = " fBidAmount DESC ";
if ($rfq2_dtls[0]['eBidCriteria'] == 'Advance') {
$orderby = " fBidAdvanceTotal DESC ";
} else {
if ($rfq2_dtls[0]['eBidCriteria'] == 'Advance') {
$orderby = " fBidPriceTotal ASC ";
}
}
$obid_dtls = $r2bdObj->getJoinTableInfo($jtbl, " DISTINCT *, org.vCompanyName as vBuyer2, r2bd.eStatus, r2bd.eSaved, r2bd.eDelete, r2bd.iModifiedById, rfq2.eAuctionStatus as rStatus ", "{$where}", "{$orderby}", "", "", "");
// pr($obid_dtls); exit;
$smarty->assign('obid_dtls', $obid_dtls);
}
//
$awrdtls = $rfq2awObj->getDetails('*', " AND iRFQ2Id='" . $bdtls[0]['iRFQ2Id'] . "' AND iStatusID!='{$rsts}' AND eSaved!='Yes' AND eDelete!='Verified' ");
if (is_array($awrdtls) && count($awrdtls) > 0) {
$rfq2_awarded = 'y';
}
$smarty->assign('rfq2_awarded', $rfq2_awarded);
//
$rejdt = '';
if (strtolower($bdtls[0]['status']) == 'rejected') {
$rejdt = 'ex';
}
$smarty->assign('rejdt', $rejdt);
}
}
$msg = "rrs";
} else {
$msg = "rrer";
}
} else {
$msg = "rrer";
}
}
}
if ($res && trim($sub) != '' && $sub != 'New Bid For RFQ2') {
$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={$id} ";
$fields = " r2bd.*, rfq2.*, sm.vStatus_en as vStatus, r2bd.eSaved ";
$dtls = $r2bdObj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
//
$orgdtls = $orgObj->select($dtls[0]['iBuyer2Id']);
if (is_array($dtls) && count($dtls) > 0 && is_array($orgdtls) && count($orgdtls) > 0) {
$db_email = $emailObj->getDetails('*', " AND vType='{$sub}' AND eSection='Member' ");
$link = SITE_URL . "viewsrfq2bid/" . $id;
// $body
$post = array($sess_user_name . "({$sess_usertype_short})", $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['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
