}
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}%'";
}
