$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);
//
}
$vreq = 'n';
$permitted = 'n';
$asts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Auth3' ");
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();
}
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);
}
if (!isset($rfq2bidObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$rfq2bidObj = new Rfq2Bids();
}
$iInvoiceID = PostVar('invoiceid');
$iPurchaseOrderID = PostVar('poid');
// $orgdtls = $orgObj->select($curORGID);
$dtls = array();
if (trim($iInvoiceID) != '' && $iInvoiceID > 0) {
$dtls = $invOrdObj->select($iInvoiceID);
$bdtls = $bnkObj->select($dtls[0]['iBankId']);
if ($dtls[0]['iPurchaseOrderID'] != "" && $dtls[0]['iPurchaseOrderID'] != "0") {
$rfq2_dets = $rfq2Obj->getDetails('*', " AND iPurchaseOrderID = '" . $dtls[0]['iPurchaseOrderID'] . "' ");
if (count($rfq2_dets) > 0) {
$awrdtls = $rfq2awObj->getDetails('*', " AND iRFQ2Id='" . $rfq2_dets[0]['iRFQ2Id'] . "' ");
$bid_dtls = $rfq2bidObj->getDetails('*', " AND iBidId='" . $awrdtls[0]['iBidId'] . "' ");
$dtls[0]['fPOAwardAdvace'] = $bid_dtls[0]['fBidAdvanceTotal'];
$dtls[0]['fPOAwardPrice'] = $bid_dtls[0]['fBidPriceTotal'];
$dtls[0]['fPOAwardAmount'] = $bid_dtls[0]['fBidAmount'];
}
}
}
if (trim($iPurchaseOrderID) != '' && $iPurchaseOrderID > 0) {
$dtls = $purOrdObj->select($iPurchaseOrderID);
}
if (trim($iInvoiceID) != '' && $iInvoiceID > 0) {
?>
<input type="hidden" name="dNetPaymentdate" id="dNetPaymentdate" value="<?php
echo $dtls[0]['dNetPaymentdate'];
?>
