} if (!isset($stMstrObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $stMstrObj = new StatusMaster(); } 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 (!isset($orgvrfObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization_Toverify.php"; $orgvrfObj = new Organization_Toverify(); } if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.OrganizationUser.php'; $orgUserObj = new OrganizationUser(); } if (!isset($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPermObj = new OrganizationUserPermission(); } if (!isset($stMstrObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $stMstrObj = new StatusMaster(); } if (!isset($userActionObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php'; $userActionObj = new UserActionVerification(); } if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } $Data = PostVar("Data"); if (is_array($Data['vCurrency'])) { $Data['vCurrency'] = @implode(',', $Data['vCurrency']); } if (trim($Data['eSecureImportExport']) != 'Yes') { $Data['eSecureImportExport'] = 'No';
// // pr($rfq2prdt); exit; $smarty->assign('dtls', $dtls); $smarty->assign('orgprf', $orgprf); $smarty->assign('rfq2b2', $rfq2b2); $smarty->assign('rfq2files', $rfq2files); $smarty->assign('rfq2prdt', $rfq2prdt); $smarty->assign('rfq2pb2asoc', $rfq2pb2asoc); } else { if ($irfq2id > 0 && $msg == 'i') { $invoiceid = $irfq2id; $irfq2id = 0; } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $acptsts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' "); $acptsts = $acptsts[0]['iStatusID']; $invCombAry = array("ID" => "iInvoiceID", "Name" => "Data[iInvoiceID]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_inovice_order_heading", "fieldId" => "iInvoiceID", "fieldName" => "vInvSupplierCode", "extVal" => '', "selectedVal" => "{$invoiceid}", "width" => '', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . " ---", "where" => " iStatusID='{$acptsts}' AND iaStatusID='{$acptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) AND eRfq2Awarded='No' AND iInvoiceID NOT IN (SELECT iInvoiceID FROM " . PRJ_DB_PREFIX . "_rfq2_master WHERE eDelete!='Verified' AND eAuctionStatus!='Cancelled') OR iInvoiceID={$invoiceid} ", "multiple_select" => "", "orderby" => 'vInvSupplierCode', "validationmsg" => '', "extra" => " title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . "' ", "class" => "form-control"); $invoices = $gdbobj->DynamicDropDown($invCombAry); $smarty->assign('invoices', $invoices); // $pacptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' "); $pacptsts = $pacptsts[0]['iStatusID']; $poCombAry = array("ID" => "iPurchaseOrderID", "Name" => "Data[iPurchaseOrderID]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_purchase_order_heading", "fieldId" => "iPurchaseOrderID", "fieldName" => "vPoBuyerCode", "extVal" => '', "selectedVal" => $dtls[0]['iPurchaseOrderID'], "width" => '', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PURCHASE_ORDER') . " ---", "where" => " iStatusID='{$pacptsts}' AND iaStatusID='{$pacptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) AND eRfq2Awarded='No' AND iPurchaseOrderID NOT IN (SELECT iPurchaseOrderID FROM " . PRJ_DB_PREFIX . "_rfq2_master WHERE eFrom='PO' AND eDelete!='Verified' AND eAuctionStatus!='Cancelled') AND (Select COUNT(iInvoiceID) from " . PRJ_DB_PREFIX . "_inovice_order_heading where iPurchaseOrderID=" . PRJ_DB_PREFIX . "_purchase_order_heading.iPurchaseOrderID AND iStatusID='{$acptsts}' AND iaStatusID='{$acptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) {$invsc}) < 1 {$posc} ", "multiple_select" => "", "orderby" => 'vPoBuyerCode', "validationmsg" => '', "extra" => " title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PO') . "' ", "class" => "form-control"); $pos = $gdbobj->DynamicDropDown($poCombAry); # pr($pos); exit; $smarty->assign('pos', $pos); // }
} if (!isset($invLineObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceDetailLine.php"; $invLineObj = new InvoiceDetailLine(); } if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/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($orgUsrObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUsrObj = new OrganizationUser(); } if (!isset($secManObj)) { require_once SITE_CLASS_APPLICATION . "securitymanager/class.SecurityManager.php"; $secManObj = new SecurityManager(); } if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($userActionObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php';
} 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']); 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'];
* @author hidden * @copyright 2010 */ include S_SECTIONS . "/member/memberaccess.php"; if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($orgPerObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPermission.php"; $orgPerObj = new OrganizationPermission(); //$sess_id } if (!isset($orgStaObj)) { require_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $orgStaObj = new StatusMaster(); //$sess_id } if (!isset($orgUserPerObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPerObj = new OrganizationUserPermission(); } if (!isset($orgPrefObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php"; $orgPrefObj = new OrganizationPreference(); //$sess_id } if (!isset($orgGroupObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationGroup.php"; $orgGroupObj = new OrganizationGroup(); }
$pg = GetVar('pg'); if ($sess_usertype == 'orgadmin' && $orgid != $iOrganizationID) { header("Location: " . SITE_URL_DUM . "oadashboard"); exit; } if (!isset($orgprefObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php"; $orgprefObj = new OrganizationPreference(); } if (!isset($orgPrefVrfObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreferenceToverify.php"; $orgPrefVrfObj = new OrganizationPreferenceToverify(); } if (!isset($stMstrObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $stMstrObj = new StatusMaster(); } if (!isset($orgObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($orgvrfObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization_Toverify.php"; $orgvrfObj = new Organization_Toverify(); } if ($iOrganizationID != '') { $view = 'edit'; // $orgObj->setiOrganizationID($iOrganizationID); $orgdtls = $orgObj->select($iOrganizationID); $orgvf = $orgvrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); // prints($orgdtls); exit;
} if (!isset($userActionObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php'; $userActionObj = new UserActionVerification(); } if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($sendMail)) { include_once SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $Data = $_POST['Data']; $iUserId = $Data['iUserID']; $iPermissionID = isset($_POST['iPermissionID']) ? $_POST['iPermissionID'] : ''; $view = $_POST['view']; $usrdt = $orgUsrObj->getDetails('*', " AND iUserID={$iUserId}"); $orgdt = $orgObj->getDetails('*', " AND iOrganizationID=" . $usrdt[0]['iOrganizationID'] . ""); // prints($orgdt);exit; // pr($_POST); exit; if ($iUserId != '') { $uprmt = $orgUserPermObj->getDetails('*', " AND iUserID={$iUserId}"); if (is_array($uprmt) && count($uprmt) > 0) { if (($uprmt[0]['eStatus'] == 'Active' || $uprmt[0]['eStatus'] == 'Inactive') && $uprmt[0]['eNeedToVerify'] != 'Yes') { // prints($orgdt); exit; } else {
} 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)) { include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php'; $userActionObj = new UserActionVerification(); } if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($sendMail)) { include SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } $sacpt = 'n'; if (trim(strtolower($view)) == 'award' || trim(strtolower($view)) == 'save') {
} if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($sendMail)) { include_once SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUsrObj = new OrganizationUser(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } if ($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] == 'SM') { $smdt = $secManObj->getDetails('*', " AND iSMID!=" . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . " AND eStatus='Active' AND eEmailNotification='Yes' "); $ordt = $orgUsrObj->getDetails('*', " AND eStatus='Active' AND eEmailNotification='Yes' AND eUserType='Admin' AND iOrganizationID=" . $usrdt[0]['iOrganizationID']); } else { if ($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] == 'OA') { $smdt = $secManObj->getDetails('*', " AND eStatus='Active' AND eEmailNotification='Yes' "); $ordt = $orgUsrObj->getDetails('*', " AND iUserID!=" . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . " AND eStatus='Active' AND eUserType='Admin' AND eEmailNotification='Yes' AND iOrganizationID=" . $usrdt[0]['iOrganizationID']); } } if (is_array($smdt) && is_array($ordt)) { $emailarr = array_merge($smdt, $ordt); } else { if (is_array($smdt)) { $emailarr = $smdt;
if (count($reqVal) > 0) { if (!isset($poLineObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderLine.php"; $poLineObj = new PurchaseOrderLine(); } if (!isset($orgUsrObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUsrObj = new OrganizationUser(); } if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $TagArr = array('Buyer Company ID' => 'iBuyerOrganizationID', 'Buyer Company Name' => 'vBuyerCompanyName', 'Buyer Code' => 'vBuyerCode', 'Suplier Company ID' => 'iSupplierOrganizationID', 'Suplier Company Name' => 'vSupplierName', 'Supplier Contact Party' => 'vSupplierContactParty', 'Po Buyer Code' => 'vPoBuyerCode', 'PO Code' => 'vPOCode', 'Order date' => 'dOrderDate', 'Order Description' => 'tOrderDescription', 'Opening Unit' => 'iOpeningUnit', 'Supplier Order Num' => 'vSupplierOrderNum', 'Carrier' => 'tCarrier', 'Line Item Tax' => 'eLineItemTax', 'VAT' => 'fVAT', 'Other tax 1' => 'fOther_tax_1', 'ShipToParty' => 'vShipToParty', 'Ship To Address Line1' => 'vShipToAddressLine1', 'Ship To Address Line 2' => 'vShipToAddressLine2', 'Ship To City' => 'vShipToCity', 'Ship To Country' => 'vShipToCountry', 'Ship To State' => 'vShipToState', 'Ship To Zip Code' => 'vShipToZipCode', 'Ship To Contact Party' => 'vShipToContactParty', 'Ship To Contact Telephone' => 'vShipToContactTelephone', 'Bill To Party' => 'vBillToParty', 'Bill To AddLine 1' => 'vBillToAddLine1', 'Bill To AddLine 2' => 'vBillToAddLine2', 'Bill To City' => 'vBillToCity', 'Bill To Country' => 'vBillToCountry', 'Bill To State' => 'vBillToState', 'Bill To ZipCode' => 'vBillToZipCode', 'Bill To Contact Party' => 'vBillToContactParty', 'Bill To Contact Telephone' => 'vBillToContactTelephone', 'Currency' => 'vCurrency', 'PO Total' => 'fPOTotal', 'Prepayment' => 'fPrepayment', 'Sourcing Document' => 'tSourcingDocument', 'Global Agreement' => 'tGlobalAgreement', 'Payment Terms' => 'tPaymentTerms', 'FOB' => 'tFOB', 'Delivery Terms' => 'tDeliveryTerms', 'Shipping Control' => 'tShippingControl', 'Conditions For Payment' => 'tConditionsForPayment', 'Penalties' => 'tPenalties', 'Special Instruction' => 'tSpecialInstruction', 'Note' => 'tNote'); $pref_ary = array('tSourcingDocument', 'tGlobalAgreement', 'tPaymentTerms', 'tFOB', 'tDeliveryTerms', 'tShippingControl', 'tConditionsForPayment', 'tPenalties', 'tSpecialInstruction', 'tNote'); /*$TagArr = array( 'po-num' => 'vPONumber', 'po-date' => 'dCreateDate', 'sender-id' => 'iSupplierID', 'receiver-id' => 'iBuyerID', 'currency' => 'vCurrency', 'taxable' => 'eLineItemTax', 'tax-rate' => 'fVAT', 'tax-amount' => 'fOther_tax_1', 'po-total' => 'fPOTotal', 'grand-total' => 'fPOTotal', 'bill-to-code' => 'vBillToParty',
} if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUserObj = new OrganizationUser(); } 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(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $sts = $statusmasterObj->getDetails(" DISTINCT iStatusID, vStatus_en, vStatus_fr, vStatus_" . LANG . " as vStatus ", " AND vForAuction LIKE '%RFQ2%'"); $smarty->assign("sts", $sts); // --- 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 = "";
include S_SECTIONS . "/member/memberaccess.php"; /** * @author hidden * @copyright 2010 */ if (!isset($UsrObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $UsrObj = new OrganizationUser(); } if (!isset($pohObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $pohObj = new PurchaseOrderHeading(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $key = $_GET['q']; $type = $_GET['type']; $iId = $_GET['iId']; $name = trim($_GET['name']); $iOrganizationID = trim($_GET['icompid']); $htmlTag = $_GET['htmltag']; $val = $_GET['val']; // prints($_GET); exit; $stsdtls = $statusmasterObj->getDetails('*', " AND vStatus_en='Accepted' AND eFor='PO' "); $sts = $stsdtls[0]['iStatusID']; // prints($stsdtls); exit; /* if($sess_usertype == 'securitymanager') $where=" AND bom.iASMID='".$sess_id."'";
$poOrgAcptIds = $crsts . "," . $opf[0]['vOrderAcceptanceLevel']; if (trim($poOrgAcptIds) != '') { if (strpos($poOrgAcptIds, ',') !== false) { $poacpt = @explode(',', $poOrgAcptIds); } else { $poacpt = $poOrgAcptIds; } } else { $poacpt = array(); } // prints($orgposl); exit; $iprvsts = ''; if ($poStatus != 'all' && $poStatus != '') { if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $orgposl = @explode(",", $opf[0]['vOrderAcceptanceLevel']); // prints($orgposl); exit; if ($poStatus == $crsts) { $poStatus = 0; $where .= " AND poh.iStatusID={$isusts} AND poh.iaStatusID=0 "; } else { if ($poStatus == $vsts) { $poStatus = $crsts; $where .= " AND poh.iaStatusID={$crsts} "; } else { if ($poStatus != $isusts && $poStatus != $acptsts && $poStatus != $rsts) { for ($l = 0; $l < count($orgposl); $l++) { if ($orgposl[$l] == $poStatus) { if (isset($orgposl[$l - 1])) {
$msg = ''; } if (isset($_SESSION['from']) && $_SESSION['from'] == 'org') { $msg = ''; } if (!isset($orgObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } 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 ($iOrganizationID != '') { $orgdtls = $orgObj->select($iOrganizationID); if ($orgdtls[0]['eOrganizationType'] == 'Supplier') { $suplvl = 'Yes'; } else { if ($orgdtls[0]['eOrganizationType'] == 'Buyer') { $bylvl = 'Yes'; } else { if ($orgdtls[0]['eOrganizationType'] == 'Both') { $bylvl = 'Yes'; $suplvl = 'Yes'; } else { $bylvl = 'No'; $suplvl = 'No';
// 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"; $orgprefObj = new OrganizationPreference(); } if (!isset($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPermObj = new OrganizationUserPermission(); } if (!isset($fluplObj)) { include_once SITE_CLASS_GEN . "class.imagecrop.php";
<?php /** * Add/Update File For Language Label * * @package addlanguagelebel.inc.php * @section main/general * @author Snehasis Mohapatra */ if (!isset($stMstrObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $stMstrObj = new StatusMaster(); } $gdbobj->getRequestVars(); $view = GetVar("view"); $iStatusID = GetVar("iStatusID"); $actionfile = GetVar("file"); if (count($_POST) > 0) { $arr = array(); $arr[0] = $_POST; } else { if ($view == 'edit') { $arr = $stMstrObj->getDetails("*", "AND iStatusID = '{$iStatusID}'"); $db_order = $stMstrObj->getDetails("count(*)", ""); $order = $db_order[0]['count(*)']; //prints($arr);exit; } else { $view = "add"; $db_order = $stMstrObj->getDetails("count(*)", ""); $order = $db_order[0]['count(*)'] + 1; //prints($order);exit;
} if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($invOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $invOrdObj = new InvoiceOrderHeading(); } 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($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } if (!isset($userActionObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php'; $userActionObj = new UserActionVerification(); } if (!isset($sendMail)) { include SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } $eInvoiceType = $_POST['invoiceType']; $iInvoiceID = $_POST['iInvoiceID'];
$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 (trim($vProductName) != '') { $having .= " HAVING vProductName LIKE '%{$vProductName}%'"; }
if (!isset($orgUserPerObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPerObj = new OrganizationUserPermission(); } if (!isset($orgUserPermVerifyObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermissionToVerify.php"; $orgUserPermVerifyObj = new OrganizationUserPermissionToVerify(); } if (!isset($userToVerifyObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.OrganizationUserToverify.php'; $userToVerifyObj = new OrganizationUserToverify(); } $orgUserObj->setiUserID($iUserID); if (!isset($orgStaObj)) { require_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $orgStaObj = new StatusMaster(); } if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($orgPrefObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php"; $orgPrefObj = new OrganizationPreference(); //$sess_id } $userStatus = array(); $userAcpt = array(); $ures = array(); $view = 'verify'; // $msg = $smarty->get_template_vars('MSG_NEED_VERIFY');
} 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($iohObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $iohObj = new InvoiceOrderHeading(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } // $poData=$pohObj->select($iPurchaseOrderID); $fields = " poh.*, (select vState from b2b_state_master sm where BINARY sm.vStateCode=poh.vShipToState AND BINARY sm.vCountryCode=poh.vShipToCountry) as vShipToState,\r\n\t\t\t\t(select vCountry from b2b_country_master cm where BINARY cm.vCountryCode=poh.vShipToCountry) as vShipToCountry,\r\n\t\t\t\t(select vState from b2b_state_master sm where BINARY sm.vStateCode=poh.vBillToState AND BINARY sm.vCountryCode=poh.vBillToCountry) as vBillToState,\r\n\t\t\t\t(select vCountry from b2b_country_master cm where BINARY cm.vCountryCode=poh.vBillToCountry) as vBillToCountry,\r\n\t\t\t\t(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=poh.iSupplierOrganizationID) as vSupplierName,\r\n\t\t\t\t(select CONCAT(usr.vFirstName,' ',usr.vLastName) as name from b2b_organization_user usr where usr.iUserID=poh.iSupplierID) as vSupplierContactParty "; $poData = $pohObj->getJoinTableInfo('', $fields, " AND iPurchaseOrderID={$iPurchaseOrderID} "); $isdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' "); $isdtls = $isdtls[0]['iStatusID']; if ($uorg_type == 'Buyer2') { $b2us = $pohObj->getPurchaseOrderRfq2Buyer2OrgIds($iPurchaseOrderID); if (!in_array($curORGID, $b2us)) { header("Location: " . SITE_URL_DUM . "invoicelist"); exit;
$vmsg = $smarty->get_template_vars('MSG_LESSER_BID_ADVANCE_PRICE'); } else { if ($vmsg == 'nl') { $vmsg = $smarty->get_template_vars('MSG_RFQ2_NOT_LIVE'); } else { if ($msg == 'rae') { $vmsg = $smarty->get_template_vars('MSG_BID_ALREADY_EXISTS'); $msg = ''; } } } } } 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"; $orgprefObj = new OrganizationPreference(); } if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . 'user/class.OrganizationUser.php'; $orgUserObj = new OrganizationUser(); } if (!isset($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php";
} 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"; $orgUserPermObj = new OrganizationUserPermission(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $iAwardId = GetVar('id'); $jtbl = " INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2aw.iRFQ2Id=rfq2.iRFQ2Id\r\n INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_bids r2bd ON r2bd.iBidId=r2aw.iBidId\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=r2aw.iStatusID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org ON org.iOrganizationID=r2bd.iBuyer2Id"; $where = " AND r2aw.iAwardId={$iAwardId} "; $bdtls = $rfq2awObj->getJoinTableInfo($jtbl, " DISTINCT *, ih.iInvoiceID,ph.vPOCode, r2aw.iAwardId, rfq2.iOrganizationID, org.vCompanyName as vBuyer2, r2aw.iStatusID, r2aw.iaStatusID, sm.vStatus_en as status, sm.vStatus_" . LANG . " as eStatus, r2aw.eSaved, r2aw.eDelete, r2aw.iModifiedById ", "{$where}", "", "", "", ""); // pr($bdtls); exit; if (!(is_array($bdtls) && count($bdtls) > 0) || trim($bdtls[0]['iBidId']) == '' || $bdtls[0]['iBidId'] < 1 || trim($bdtls[0]['iRFQ2Id']) == '' || $bdtls[0]['iRFQ2Id'] < 1) { header("Location: " . SITE_URL_DUM . "rfq2awardlist"); exit; } // pr($bdtls); exit; $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'])) {
include S_SECTIONS . "/member/memberaccess.php"; if (!isset($orgUserObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php"; $orgUserObj = new OrganizationUser(); } 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); // -----------------------------------------------------------------------------------------------------------
} if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($pohObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $pohObj = new PurchaseOrderHeading(); } if (!isset($asocObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationAssociation.php"; $asocObj = new OrganizationAssociation(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } if (!isset($orgUserPermObj)) { include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php"; $orgUserPermObj = new OrganizationUserPermission(); } if (!isset($orgprefObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php"; $orgprefObj = new OrganizationPreference(); } if (!isset($poAttachmentObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderAttachment.php"; $poAttachmentObj = new PurchaseOrderAttachment(); } if (!isset($invOrdObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
if (!isset($pohObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php"; $pohObj = new PurchaseOrderHeading(); } if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/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($iohObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php"; $iohObj = new InvoiceOrderHeading(); } if (!isset($invLineObj)) { include_once SITE_CLASS_APPLICATION . "user/class.InvoiceDetailLine.php"; $invLineObj = new InvoiceDetailLine(); } if (!isset($poLineObj)) { include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderLine.php"; $poLineObj = new PurchaseOrderLine(); } if (!isset($orgUsrObj)) { require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php";
//echo $where;exit; $invOrgStatusIds = $crsts . "," . $opf[0]['vInvoiceStatusLevel']; if (trim($invOrgStatusIds) != '') { if (strpos($invOrgStatusIds, ',') !== false) { $invusts = @explode(',', $invOrgStatusIds); } else { $invusts = $invOrgStatusIds; } } else { $invusts = array(); } $iprvsts = ''; if ($invStatus != 'all' && $invStatus != '') { if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $orgposl = @explode(",", $opf[0]['vInvoiceStatusLevel']); if ($invStatus == $crsts) { $invStatus = $crsts; $where .= " AND ioh.eSaved='Yes' "; } else { if ($invStatus == $vsts) { $invStatus = $crsts; $where .= " AND ioh.iStatusID={$crsts} AND ioh.eSaved!='Yes' "; } else { if ($invStatus != $isusts && $invStatus != $acptsts && $invStatus != $rsts) { $where .= " AND ioh.eSaved!='Yes' "; for ($l = 0; $l < count($orgposl); $l++) { if ($orgposl[$l] == $invStatus) { if (isset($orgposl[$l - 1])) {
unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']); if ($msg == 'ras') { $msg = $smarty->get_template_vars('MSG_ADD_SUCC'); } elseif ($msg == 'raserr') { $msg = $smarty->get_template_vars('MSG_ADD_ERR'); } elseif ($msg == 'rus') { $msg = $smarty->get_template_vars('MSG_UPDATE_SUCC'); } elseif ($msg == 'ruserr') { $msg = $smarty->get_template_vars('MSG_UPDATE_ERR'); } else { if ($msg == 'pocr') { $msg = $smarty->get_template_vars('MSG_PO_CREATED'); } else { $msg = ''; } } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $poStatus = $_GET['id']; $_SESSION['polvl'] = $poStatus; $rejectStatusID = $statusmasterObj->getDetails('iStatusID', ' AND vStatus_en="Rejected" AND eFor="PO"'); $rejectStatusID = $rejectStatusID[0]['iStatusID']; $deletepo = ''; if ($poStatus == $rejectStatusID) { $deletepo = 'Yes'; } $smarty->assign('deletepo', $deletepo); $smarty->assign('poStatus', $poStatus); $smarty->assign("msg", $msg);
//$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}%')"; } if (trim($vProductName) != '') { $having .= " HAVING vProductName LIKE '%{$vProductName}%'"; }
//$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($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(); } $rsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Rejected' "); $rsts = $rsts[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 (trim($vProductName) != '') { $having .= " HAVING vProductName LIKE '%{$vProductName}%'"; }