} 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($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']);
$famount = PostVar('amount'); $eStatus = PostVar('eStatus'); //$dStartDate = calcGTzTime($dStartDate, 'Y-m-d H:i:s'); //$dEndDate = calcGTzTime($dEndDate, 'Y-m-d H:i:s'); $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($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(); } $asts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction!='' AND vStatus_en='Auth3' "); $asts = $asts[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}%')";
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)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
} 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(); } $lastlogins = $lghObj->getDetails("*", " AND iAdminId={$sess_id}", " dLoginDate DESC ", '', " LIMIT 0,3"); $lastLoginDate = $lastlogins[0]['dLoginDate']; $smarty->assign("lastlogins", $lastlogins);
} if (!isset($purOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $purOrdObj = new PurchaseOrderHeading(); } 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) {
<?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)) {
<?php $iAwardId = GetVar('id'); if (!isset($rfq2awObj)) { include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php"; $rfq2awObj = new Rfq2Award(); } $dtls = $rfq2awObj->select($iAwardId); $hdtls = $rfq2awObj->getHistory($iAwardId, $curORGID); // pr($hdtls); exit; $smarty->assign('dtls', $dtls); $smarty->assign('hdtls', $hdtls);
$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'); $sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Bid,%' AND vStatus_en='Verify' "); $bdt['iStatusID'] = $sts[0]['iStatusID']; $bdt['eStatus'] = 'current'; $rs = $bid = $r2bdObj->insert($bdt); if ($rdtls[0]['eFrom'] != "PO") { $ress = $rfq2Obj->updateData(array('eAuctionStatus' => 'Completed'), " iRFQ2Id={$iRFQ2Id} "); } // add award to bid as accepted if (!isset($r2awObj)) { include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php"; $r2awObj = new Rfq2Award(); } $dat = array(); $dat['iBidId'] = $bid; $dat['iRFQ2Id'] = $dtls[0]['iRFQ2Id']; $dat['eOrgCreatedBy'] = $rfq2Obj->getR2InvOrgType($curORGID, $dtls[0]['iRFQ2Id'], $rdtls[0]['eFrom']); $dat['iCreatedById'] = $sess_id; $dat['iModifiedById'] = $sess_id; $dat['dADate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $dat['vAwardNum'] = $r2awObj->getUniqueCode(); $asts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Accepted' "); $dat['iStatusID'] = $asts[0]['iStatusID']; $dat['iaStatusID'] = $asts[0]['iStatusID']; $r2awid = $r2awObj->insert($dat); if ($r2awid > 0) { //
} 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; $where = " AND iOrganizationID={$orgid}"; //$where = ""; //prints($assocstats); exit; $smarty->assign("assocstats", $assocstats);
} 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(); } if (trim($urights['acpt']) != '') { $urights['acpt'] = @explode(',', $urights['acpt']); } else {
} 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($rfq2awObj)) { include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php"; $rfq2awObj = new Rfq2Award(); } 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)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php"; $orgprefObj = new OrganizationPreference(); } if (!isset($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php";
<?php $view = PostVar('view'); $iAwardId = PostVar('iAwardId'); if (!($iAwardId > 0 && trim($view) != '')) { header("Location: " . SITE_URL_DUM . "rfq2awardlist"); exit; } if (!isset($rfq2awObj)) { include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php"; $rfq2awObj = new Rfq2Award(); } 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($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPermObj = new OrganizationUserPermission(); } if (!isset($invOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $invOrdObj = new InvoiceOrderHeading(); } if (!isset($purOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $purOrdObj = new PurchaseOrderHeading();