// $fMaxPrice = PostVar('fMaxPrice');
// $fMinPrice = PostVar('fMinPrice');
$famount = PostVar('amount');
$eStatus = PostVar('eStatus');
//$dStartDate = calcGTzTime($dStartDate, 'Y-m-d H:i:s');
//$dEndDate = calcGTzTime($dEndDate, 'Y-m-d H:i:s');
// echo $status; exit;
// $page = (isset($_POST['page']))? $_POST['page'] : '';
$page = PostVar('page');
if (trim($page) == '' || trim($page) < 1) {
$page = 1;
}
//Prints($_POST); exit;
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$csts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Create' ");
$csts = $csts[0]['iStatusID'];
$where = "";
$having = "";
if ($mode == 'srch') {
if (trim($vRFQ2Code) != '') {
$where = " AND rfq2.vRFQ2Code LIKE '%{$vRFQ2Code}%'";
}
if (trim($vInvoiceCode) != '') {
$where .= " AND (ioh.vInvoiceCode LIKE '%{$vInvoiceCode}%' OR poh.vPOCode LIKE '%{$vInvoiceCode}%')";
<?php
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($rpb2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2ProductBuyer2.php";
$rpb2Obj = new Rfq2ProductBuyer2();
}
if (!isset($rfq2fObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Files.php";
$rfq2fObj = new Rfq2Files();
}
if (!isset($rfq2awObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awObj = new Rfq2Award();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
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($orgprefObj)) {
<?php
$iBidId = GetVar('id');
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($rpb2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2ProductBuyer2.php";
$rpb2Obj = new Rfq2ProductBuyer2();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
if (!isset($rfq2fObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Files.php";
$rfq2fObj = new Rfq2Files();
}
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();
}
}
if (!isset($bnkObj)) {
include_once SITE_CLASS_APPLICATION . "class.BankMaster.php";
$bnkObj = new BankMaster();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Masterphp";
$rfq2Obj = new RFQ2Master();
}
if (!isset($rfq2awObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awObj = new Rfq2Award();
}
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'];
<?php
$iBidId = GetVar('id');
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
$bdtls = $r2bdObj->select($iBidId);
$hdtls = $r2bdObj->getHistory($iBidId);
$smarty->assign('bdtls', $bdtls);
$smarty->assign('hdtls', $hdtls);
}*/
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
if (!isset($rpb2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2ProductBuyer2.php";
$rpb2Obj = new Rfq2ProductBuyer2();
}
if (!isset($rfq2fObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Files.php";
$rfq2fObj = new Rfq2Files();
}
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($r2bdflObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2BidFiles.php";
$r2bdflObj = new RFQ2BidFiles();
}
if ($id > 0) {
$lang = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'];
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on rfq2.iStatusID=sm.iStatusID\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 ";
$where .= " AND rfq2.iRFQ2ID={$id} ";
$fields = " *, ioh.iInvoiceID,poh.vSupplierName as poh_vSupplierName,poh.fPOTotal, poh.iPurchaseOrderID, vStatusMsg_" . LANG . " as vStatusMsg, vStatus_" . LANG . " as vStatus, rfq2.eSaved, rfq2.eDelete ";
$dtls = $rfq2Obj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
if (!(is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iRFQ2Id']) && $dtls[0]['iRFQ2Id'] > 0)) {
header("Location: " . SITE_URL_DUM . "b2rfq2list");
exit;
}
}
if (!isset($orgprefObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
$orgprefObj = new OrganizationPreference();
}
if (!isset($stMstrObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$stMstrObj = new StatusMaster();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($r2bdobj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdobj = new Rfq2Bids();
}
if (!isset($rfq2awardObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awardObj = new Rfq2Award();
}
// --- Statistics --------------------------------------------------------------------------------------------
// -----------
$sts = $statusmasterObj->getDetails(" DISTINCT iStatusID, vStatus_en, vStatus_fr, vStatus_" . LANG . " as vStatus ", " AND vForAuction LIKE '%RFQ2%'");
#pr($sts);exit;
$smarty->assign("sts", $sts);
// -----------------------------------------------------------------------------------------------------------
// --- Last Logins -------------------------------------------------------------------------------------------
if (!isset($lghObj)) {
require_once SITE_CLASS_APPLICATION . "class.LoginHistory.php";
$lghObj = new LoginHistory();
<?php
$iBidId = PostVar('iBidId');
$view = PostVar('view');
$Data = PostVar('Data');
$sub = "";
$typ = "";
// pr($_FILES);
// pr($_POST); exit;
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($r2bdflObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2BidFiles.php";
$r2bdflObj = new RFQ2BidFiles();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.Organization.php';
$orgObj = new Organization();
}
if (!isset($orgprefObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
<?php
$iBidId = GetVar('id');
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($rpb2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2ProductBuyer2.php";
$rpb2Obj = new Rfq2ProductBuyer2();
}
if (!isset($rfq2fObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Files.php";
$rfq2fObj = new Rfq2Files();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
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();
}
<?php
// pr($_POST); exit;
$view = PostVar('view');
$iBidId = PostVar('iBidId');
$iAwardId = PostVar('iAwardId');
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($r2awObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Award.php";
$r2awObj = new Rfq2Award();
}
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.Organization.php';
$orgObj = new Organization();
}
if (!isset($orgprefObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
$orgprefObj = new OrganizationPreference();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($userActionObj)) {
$sendMail->Send("New RFQ2", "Member", $email, $body_arr, $post_arr);
}
}
//
}
//
}
}
//
}
// Auto Accept RFQ2
if ($iRFQ2Id > 0 && $dt[0]['eAuctionType'] == 'Tender' && $aacptl['chk'] == 'y') {
// && $aacptl['bidamount']>0
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
$rdtls = $rfq2Obj->select($iRFQ2Id);
// add bid
$bdt['iRFQ2Id'] = $iRFQ2Id;
$dtls[0]['iBuyer2Id'] = $bdt['iBuyer2Id'] = $aacptl['iBuyer2Id'];
$bdt['vBidNum'] = $r2bdObj->getUniqueCode('');
$bdt['fBidAdvancePc'] = $rdtls[0]['fAdvanceMinPc'];
$bdt['fBidAdvanceAmt'] = $rdtls[0]['fAdvanceMinAmt'];
$bdt['fBidPricePc'] = $rdtls[0]['fPriceMaxPc'];
$bdt['fBidPriceAmt '] = $rdtls[0]['fPriceMaxAmt'];
$bdt['fBidAdvanceTotal'] = $rdtls[0]['fAdvanceTotal'];
$bdt['fBidPriceTotal'] = $rdtls[0]['fPriceTotal'];
$bdt['fBidAmount'] = $rdtls[0]['fTotal'];
$gmtoffset = $_POST['gmtoffset'];
$bdt['dBidDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
<?php
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
$id = GetVar('id');
$msg = GetVar('msg');
//echo SITE_CLASS_APPLICATION;exit;
if (!isset($bidobj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$bidobj = new Rfq2Bids();
}
$bidarr = $bidobj->getviewbidhistory($id, $curORGID);
//prints($bidarr);exit;
$smarty->assign('bidarr', $bidarr);
$smarty->assign('iRFQ2Id', $id);
}
if (!isset($orgUserObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php";
$orgUserObj = new OrganizationUser();
}
if (!isset($poheadingObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$poheadingObj = new PurchaseOrderHeading();
}
if (!isset($invordheadingObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$invordheadingObj = new InvoiceOrderHeading();
}
if (!isset($r2bdobj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdobj = new Rfq2Bids();
}
if (!isset($rfq2awardObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awardObj = new Rfq2Award();
}
// --- Statistics --------------------------------------------------------------------------------------------
$where = " iBuyerOrganizationID={$orgid} ";
$assocstats = $orgObj->getOADashboardAssocStats(PRJ_DB_PREFIX . "_organization_association", $where);
$where = " iOrganizationID={$orgid} ";
$groupstats = $orgObj->getOADashboardGrpStats(PRJ_DB_PREFIX . "_organization_group", $where);
$orguserstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='User' ");
$orgadminstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='Admin' ");
$where = " iUserID IN (Select iUserID from " . PRJ_DB_PREFIX . "_organization_user where {$where} AND eUserType='User' ) ";
$userrightsstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user_permission", $where);
// prints($userrightsstats); exit;
}
if (!isset($poheadingObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$poheadingObj = new PurchaseOrderHeading();
}
if (!isset($invordheadingObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$invordheadingObj = new InvoiceOrderHeading();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($r2bdobj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdobj = new Rfq2Bids();
}
if (!isset($rfq2awardObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awardObj = new Rfq2Award();
}
// --- Statistics --------------------------------------------------------------------------------------------
$userrights = $orgUserObj->getUserPermission($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']);
// echo $userrights; exit;
if (is_array($userrights) && count($userrights) > 0) {
$urights = $userrights;
}
if (trim($urights['issu']) != '') {
$urights['issu'] = @explode(',', $urights['issu']);
} else {
$urights['issu'] = array();
