$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.";