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'))"; } if (trim($sid) != '' && $sid > 0) { $whr .= " OR spo.iProductId={$sid} "; } // echo $whr; exit; $sprdt = $sprdtObj->getDetails("*", " AND spo.eAvailability='association' {$whr} ", " spo.vProductName ASC "); // prints($sprdt); exit; if (is_array($sprdt) && count($sprdt) > 0) { $ln = count($sprdt); $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_SPRODUCT') . "'>"; for ($l = 0; $l < $ln; $l++) { $sel = ""; if ($sid > 0 && $bprdt[$l]['iProductId'] == $sid) { $sel = "selected='selected'"; } $html .= "<option value='" . $sprdt[$l]['iProductId'] . "'>" . $sprdt[$l]['vProductName'] . " (" . $sprdt[$l]['vProductCode'] . ")" . "</option>"; } $html .= "</select>"; } else { $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_SPRODUCT') . "'>"; $html .= "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_SPRODUCT') . "---</option>";
$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 { header("Location: " . SITE_URL_DUM . "b2sprodtsasoclist"); }
<?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);
} $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 echo $elnm; ?>
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> </tr> <tr> <td width="190px" valign="top"><?php echo $smarty->get_template_vars('LBL_PRODUCT');