}
if (!isset($orgUserPermObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php";
$orgUserPermObj = new OrganizationUserPermission();
}
if ($msg == 'pb2m') {
$msg = $smarty->get_template_vars('MSG_PRODUCT_BUYER2_MISMATCH');
}
$invoiceid = 0;
$view = 'add';
if (trim($irfq2id) != '' && $irfq2id > 0 && $msg != 'i') {
$view = 'edit';
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n LEFT 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";
$where .= " AND rfq2.iRFQ2ID={$irfq2id} ";
$fields = " rfq2.*, ioh.*, rfq2.iPurchaseOrderID, poh.vPOCode, poh.vBuyerCompanyName,poh.vSupplierName as poh_vSupplierName, poh.fPOTotal, sm.vStatus_en as vStatus, rfq2.eSaved, rfq2.eDelete ";
$dtls = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
//pr($dtls); exit;
// $orgprf = $orgprefObj->select($dtls[0]['iOrganizationID']);
if (isset($dtls[0]['eAuctionStatus']) && strtolower($dtls[0]['eAuctionStatus']) == 'cancelled' || isset($dtls[0]['iOrganizationID']) && $dtls[0]['iOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "rfq2view/{$irfq2id}");
exit;
}
if (!is_array($dtls) || count($dtls) < 1) {
header("Location: " . SITE_URL_DUM . "rfq2list/rnme");
exit;
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$crsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Create' ");
// rfq2 status
$rs = $rfq2Obj->setAllRfq2Ststus();
//
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
// echo $where;
$jtbl = " LEFT 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 LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\r\n LEFT 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 rfq2.eDelete!='Verified' ";
// echo $where = " AND rpb2.iBuyer2Id=71 AND rfq2.eDelete!='Verified' ";
$fields = " DISTINCT 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,\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 eStatus,\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,\r\n @rd:=IF(rfq2.dStartDate>UTC_TIMESTAMP(), TIMESTAMPDIFF(DAY,UTC_TIMESTAMP(),rfq2.dStartDate), 0) as rdays, IF(rfq2.dStartDate>UTC_TIMESTAMP(), TIME_FORMAT(SEC_TO_TIME(TIMESTAMPDIFF(SECOND,UTC_TIMESTAMP(),rfq2.dStartDate) - (@rd * 24*60*60) ), '%H:%i'), 0) as rtime,\r\n\t\t\t\t\t(Select COUNT(iBidId) FROM " . PRJ_DB_PREFIX . "_rfq2_bids WHERE iRFQ2Id=rfq2.iRFQ2Id AND eStatus='current') AS totbid ";
// ,
// 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 = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, 'rfq2.iRFQ2Id' . $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, "listrfq2", $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);