$rfq2files[$l][filename] = $bidfiles;
$rfq2files[$l][fileurl] = $cfgimg['rfq2']['docs']['url'] . $rfq2file[0]['iRFQ2Id'] . '/' . $rfq2file[$l]['vFile'];
}
}
}
// pr($rfq2files);exit;
$rfq2pb2_dtls = $rpb2Obj->getDetails('*', " AND iRFQ2Id='" . $bdtls[0]['iRFQ2Id'] . "'");
//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;
}
}
}
}
//
<?php
$iProductId = GetVar('id');
$dtls = array();
if (trim($iProductId) != '' && $iProductId > 0) {
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='{$iProductId}' ");
}
if (!(is_array($dtls) && count($dtls) > 0)) {
$dtls = 'nrf';
}
$smarty->assign("dtls", $dtls);
<?php
if (!isset($bProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.BProductOrganization.php';
$bProductOrgObj = new BProductOrganization();
}
// $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 = $bProductOrgObj->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");
$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');
$oc = GetVar('oc');
$whr = GetVar('whr');
$fr = GetVar('fr');
if (!isset($bprdtObj)) {
include_once SITE_CLASS_APPLICATION . "productorganization/class.BProductOrganization.php";
$bprdtObj = new BProductOrganization();
}
if (trim($snm) != '' && trim($scd) == '') {
$whr .= " AND bpo.vProductName LIKE '%{$snm}%' ";
} else {
if (trim($scd) != '' && trim($snm) == '') {
$whr .= " AND bpo.vProductCode LIKE '%{$scd}%' ";
} else {
if (trim($scd) != '' && trim($snm) != '') {
$whr .= " AND (bpo.vProductName LIKE '%{$snm}%' OR bpo.vProductCode LIKE '%{$scd}%') ";
}
}
}
if (trim($iBuyer2Id) != '' && $iBuyer2Id > 0) {
$whr .= " AND bpo.iProductId IN (Select iProductId from " . PRJ_DB_PREFIX . "_buyer2_bproduct_association where iBuyer2Id={$iBuyer2Id} AND NOT (eStatus='Delete' AND eNeedToVerify='No'))";
}
}
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($bpoObj)) {
include_once SITE_CLASS_APPLICATION . "productorganization/class.BProductOrganization.php";
$bpoObj = new BProductOrganization();
}
$product = $bpoObj->getDetails('vProductName, vProductCode', " AND iProductId='" . $arr[0]['iProductId'] . "'");
$arr[0]['vProduct'] = $product[0]['vProductName'];
$arr[0]['vProductCode'] = $product[0]['vProductCode'];
}
$arr[0]['iBuyerId'] = 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 . "b2bprodtbasocview/{$iAssociationId}");
} else {
$orgas = trim($orgas) != '' ? $orgas : $uorg_type;
// echo $orgas; exit;
$whr = "";
if (trim($productname) != '') {
$whr .= " AND vProductName LIKE '{$productname}%' ";
} else {
if (trim($productcode) != '') {
$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);
}
}
<?php
if (!isset($bProductOrgObj)) {
include_once SITE_CLASS_APPLICATION . 'productorganization/class.BProductOrganization.php';
$bProductOrgObj = new BProductOrganization();
}
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 . "_bproduct_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'];
$bProductOrgObj->setAllVar($Data);
$id = $bProductOrgObj->insert();
if ($id) {
$var_msg = "Record Added Successfully.";
