//pr($rfq2pb2_dtls);
$product_dtls = array();
$buyer2_dtls = array();
if (is_array($rfq2pb2_dtls) && count($rfq2pb2_dtls) > 0) {
if (isset($rfq2pb2_dtls[0]['iProductId']) && $rfq2pb2_dtls[0]['iProductId'] > 0) {
if (isset($rfq2pb2_dtls[0]['ePType']) && $rfq2pb2_dtls[0]['ePType'] == 'BProduct') {
if (!isset($bproductObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.BProductOrganization.php';
$bproductObj = new BProductOrganization();
}
$product_dtls = $bproductObj->select($rfq2pb2_dtls[0]['iProductId']);
} else {
if (isset($rfq2pb2_dtls[0]['ePType']) && $rfq2pb2_dtls[0]['ePType'] == 'SProduct') {
if (!isset($sproductObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sproductObj = new SProductOrganization();
}
$product_dtls = $sproductObj->select($rfq2pb2_dtls[0]['iProductId']);
//pr($product_dtls);exit;
}
}
}
}
//
$rfq2_dtls = $rfq2Obj->select($bdtls[0]['iRFQ2Id']);
//
$rsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Rejected' ");
$rsts = $rsts[0]['iStatusID'];
$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\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.iRFQ2Id=" . $bdtls[0]['iRFQ2Id'] . " AND r2bd.iBidId NOT IN (Select iBidId from " . PRJ_DB_PREFIX . "_rfq2award_master where iStatusID={$rsts}) AND r2bd.iBidId!=" . $bdtls[0]['iBidId'] . " AND r2bd.eSaved!='Yes' AND r2bd.eStatus Not IN ('pending','rejected') ";
// AND r2bd.iBidId!=".$bdtls[0]['iBidId']."
}
if (isset($post_data['Data']) && count($post_data['Data']) > 0) {
$arr[0] = $post_data['Data'];
if (isset($arr[0]['iBuyer2Id']) && $arr[0]['iBuyer2Id'] > 0) {
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
$buyer2 = $orgObj->getDetails('vCompanyName, vCompCode', " AND iOrganizationID='" . $arr[0]['iBuyer2Id'] . "'");
$arr[0]['vBuyer2'] = $buyer2[0]['vCompanyName'];
$arr[0]['vB2Code'] = $buyer2[0]['vCompCode'];
}
if (isset($arr[0]['iProductId']) && $arr[0]['iProductId'] > 0) {
if (!isset($spoObj)) {
include_once SITE_CLASS_APPLICATION . "productorganization/class.SProductOrganization.php";
$spoObj = new SProductOrganization();
}
$product = $spoObj->getDetails('vProductName, vProductCode', " AND iProductId='" . $arr[0]['iProductId'] . "'");
$arr[0]['vProduct'] = $product[0]['vProductName'];
$arr[0]['vProductCode'] = $product[0]['vProductCode'];
}
$arr[0]['iSupplierId'] = 0;
}
// pr($arr); exit;
}
// For OAs
// pr($_SESSION); exit;
if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] != 'Buyer2' && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USRTYPE'] != 'SM') {
if ($iAssociationId > 0) {
header("Location: " . SITE_URL_DUM . "b2sprodtsasocview/{$iAssociationId}");
} else {
$html = "";
$iBuyer2Id = GetVar('b2orgid');
$fid = GetVar('fid');
$fnm = GetVar('fnm');
$snm = GetVar('snm');
$scd = GetVar('scd');
$sid = GetVar('sid');
$cls = GetVar('cls');
$styl = GetVar('styl');
$ea = GetVar('ea');
$whr = GetVar('whr');
$fr = GetVar('fr');
// pr($_GET); exit;
if (!isset($sprdtObj)) {
include_once SITE_CLASS_APPLICATION . "productorganization/class.SProductOrganization.php";
$sprdtObj = new SProductOrganization();
}
if (trim($snm) != '' && trim($scd) == '') {
$whr .= " AND spo.vProductName LIKE '%{$snm}%' ";
} else {
if (trim($scd) != '' && trim($snm) == '') {
$whr .= " AND spo.vProductCode LIKE '%{$scd}%' ";
} else {
if (trim($scd) != '' && trim($snm) != '') {
$whr .= " AND (spo.vProductName LIKE '%{$snm}%' OR spo.vProductCode LIKE '%{$scd}%') ";
}
}
}
if (trim($iBuyer2Id) != '' && $iBuyer2Id > 0) {
$whr .= " AND spo.iProductId NOT IN (Select iProductId from " . PRJ_DB_PREFIX . "_buyer2_sproduct_association where iBuyer2Id={$iBuyer2Id} AND NOT (eStatus='Delete' AND eNeedToVerify='No'))";
}
<?php
if (!isset($sProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sProductOrgObj = new SProductOrganization();
}
include SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
//prints($_POST);exit;
$view = PostVar("view");
$Data = PostVar("Data");
/* $dupl = PostVar('dpr');
if(!isset($Data['eEmailNotification'])) {
$Data['eEmailNotification'] = 'No';
}*/
//$Data_access = PostVar("Data_access");
$iProductId = PostVar("iProductId");
$curr_date = date("Y-m-d h:i:s");
// $iAdminID = $_SESSION['B2B_SESS_USERID'];
/** This is for Check Duplicate Record------------------------------------------- */
$generalobj->getRequestVars();
$redirect_file = "index.php?file={$file}&view={$view}&iProductId={$iProductId}";
$generalobj->checkDuplicate('iProductId', PRJ_DB_PREFIX . "_sproduct_organization", array('vProductCode' => $Data['vProductCode']), $redirect_file, 'Record Already Exists', $iProductId);
if ($view == "add") {
// $Data['dAddedDate'] = date("Y-m-d H:i:s");
// $Data['vIP'] = $_SERVER[REMOTE_ADDR];
// $Data['iAdminID'] = $_SESSION['B2B_SESS_USERID'];
$sProductOrgObj->setAllVar($Data);
$id = $sProductOrgObj->insert();
if ($id) {
$var_msg = "Record Added Successfully.";
<?php
if (!isset($sProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sProductOrgObj = new SProductOrganization();
}
// $gdbobj->getRequestVars();
$view = GetVar("view");
$iProductId = GetVar("iProductId");
$file = GetVar("file");
$arr = array();
if (count($_POST) > 0) {
$arr[0] = $_POST;
} else {
if ($view == 'edit') {
$arr = $sProductOrgObj->select($iProductId);
//prints($arr); exit;
} else {
$view = "add";
}
}
$bankcombary = array("ID" => "iBankId", "Name" => "Data[iBankId]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_bank_master", "fieldId" => "iBankId", "fieldName" => "vBankName", "extVal" => '', "selectedVal" => isset($arr[0]['iBankId']) ? $arr[0]['iBankId'] : '', "width" => '210px', "height" => '', "onchange" => '', "selectText" => "--- Select Bank ---", "where" => " eStatus = 'Active'", "multiple_select" => "", "orderby" => 'vBankName', "validationmsg" => 'Select Bank', "class" => "required", "extra" => " title='Select Bank' ");
$bankcombo = $gdbobj->DynamicDropDown($bankcombary);
?>
<form name="frmadd" id="frmadd" action="index.php?file=<?php
echo $file;
?>
&view=action" method="post">
<?php
echo $generalobj->PrintElement("view", "view", $view, "Hidden");
echo $generalobj->PrintElement("iProductId", "iProductId", $iProductId, "Hidden");
$whr .= " AND vProductCode LIKE '{$productcode}%' ";
}
}
$dtls = array();
if ($curORGID > 0 && $orgas != '' && ($iInvoiceID > 0 || $iPurchaseOrderID > 0)) {
if ($orgas == 'Buyer') {
if (!isset($bProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.BProductOrganization.php';
$bProductOrgObj = new BProductOrganization();
}
$dtls = $bProductOrgObj->getDetails("iProductId, vProductName, vProductCode, 'bproduct' as eProductType", " AND eAvailability='{$availability}' {$whr}");
} else {
if ($orgas == 'Supplier') {
if (!isset($sProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sProductOrgObj = new SProductOrganization();
}
$dtls = $sProductOrgObj->getDetails("iProductId, vProductName, vProductCode, 'sproduct' as eProductType", " AND eAvailability='{$availability}' {$whr}");
} else {
if ($orgas == 'Both') {
$sql = "(Select iProductId, vProductName, vProductCode, 'b' as eProductType from " . PRJ_DB_PREFIX . "_bproduct_organization where eAvailability='{$availability} {$whr}')\r\n\t\t\t\t\tUNION\r\n\t\t\t\t\t(Select iProductId, vProductName, vProductCode, 's' as eProductType from " . PRJ_DB_PREFIX . "_sproduct_organization where eAvailability='{$availability} {$whr}')\r\n\t\t\t\t\tORDER BY vProductName ASC";
$dtls = $dbobj->MySQLSelect($sql);
}
}
}
}
?>
<select id="<?php
echo $elid;
?>
" class="save required" name="<?php
<?php
$iProductId = GetVar('id');
$dtls = array();
if (trim($iProductId) != '' && $iProductId > 0) {
if (!isset($sProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sProductOrgObj = new SProductOrganization();
}
$flds = "spo.iProductId, spo.vProductName, spo.vProductCode, 'sproduct' as eProductType, spo.eAvailability, (select vBankName from " . PRJ_DB_PREFIX . "_bank_master bm where bm.iBankId=spo.iBankId) as vBankName, spo.vBankAccount";
$dtls = $sProductOrgObj->getDetails($flds, " AND iProductId='{$iProductId}' ");
}
if (!(is_array($dtls) && count($dtls) > 0)) {
$dtls = 'nrf';
}
$smarty->assign("dtls", $dtls);
$availability = PostVar('availability');
$typ = preg_replace('/-\\d/', '', $iProductId);
$ipids = preg_replace('/\\w-/', '', $iProductId);
if (trim($typ) != '' && $ipids > 0) {
if ($typ == 'b') {
if (!isset($bProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.BProductOrganization.php';
$bProductOrgObj = new BProductOrganization();
}
$flds = "bpo.iProductId, bpo.vProductName, bpo.vProductCode, 'sproduct' as eProductType, bpo.eAvailability, (select vBankName from " . PRJ_DB_PREFIX . "_bank_master bm where bm.iBankId=bpo.iBankId) as vBankName, bpo.vBankAccount";
$dtls = $bProductOrgObj->getDetails($flds, " AND iProductId='{$ipids}' ");
} else {
if ($typ == 's') {
if (!isset($sProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
$sProductOrgObj = new SProductOrganization();
}
$flds = "spo.iProductId, spo.vProductName, spo.vProductCode, 'sproduct' as eProductType, spo.eAvailability, (select vBankName from " . PRJ_DB_PREFIX . "_bank_master bm where bm.iBankId=spo.iBankId) as vBankName, spo.vBankAccount";
// echo "Select ". $flds ." from "." where AND iProductId='$ipids'"; exit;
$dtls = $sProductOrgObj->getDetails($flds, " AND spo.iProductId='{$ipids}' ");
}
}
}
if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iProductId']) && $dtls[0]['iProductId'] > 0) {
?>
<table cellpadding="0" cellspacing="0" style="background:#f7f7f7; font-size:12px;">
<tr>
<td colspan="2" align="left" valign="top"><b><u><?php
echo $smarty->get_template_vars('LBL_PRODUCT') . ' ' . $smarty->get_template_vars('LBL_DETAILS');
?>
</u>:-</b></td>
