} $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);