function get_filters_names($conn) { $filter = array(); //Reputation Activities $filter['act'] = Reputation::get_reputation_activities($conn); //Product types $product_types = Product_type::get_list($conn); $filter['ptype'][0] = _('ANY'); foreach ($product_types as $ptype) { $filter['ptype'][$ptype->get_id()] = $ptype->get_name(); } //Subcategories $subcategories = Subcategory::get_list($conn); $filter['subcat'][0] = _('ANY'); foreach ($subcategories as $subc) { $filter['subcat'][$subc->get_id()] = $subc->get_name(); } //Categories $categories = Category::get_list($conn); $filter['cat'][0] = _('ANY'); foreach ($categories as $cat) { $filter['cat'][$cat->get_id()] = $cat->get_name(); } return $filter; }
echo _("Select a category"); ?> -- </option> </select> <?php exit; } $db = new ossim_db(); $conn = $db->connect(); ?> <select class='vfield' name="subcategory" id="subcategory"> <?php // Subcategory require_once 'classes/Subcategory.inc'; $list_subcategories = Subcategory::get_list($conn, 'WHERE cat_id=' . $category_id . ' ORDER BY name'); foreach ($list_subcategories as $subcategory) { $selected = $category_id == $subcategory->get_id() ? ' selected="selected"' : ''; ?> <option value='<?php echo $subcategory->get_id(); ?> '<?php echo $selected; ?> ><?php echo str_replace('_', ' ', $subcategory->get_name()); ?> </option> <?php }
if (ossim_error()) { die(ossim_error()); } $db = new ossim_db(); $conn = $db->connect(); // translate category id $category_name = ''; if ($category_id != "") { if ($category_list = Category::get_list($conn, "WHERE id = '{$category_id}'")) { $category_name = $category_list[0]->get_name(); } } //Subcategory $subcategory_name = ''; if ($subcategory_id != "") { if ($subcategory_list = Subcategory::get_list($conn, "WHERE id = '{$subcategory_id}'")) { $subcategory_name = $subcategory_list[0]->get_name(); } } $category_filter = $subcategory_name != "" ? "{$category_name} - {$subcategory_name}" : $category_name; $dt_url = "getpluginsid.php?plugin_id={$plugin_id}"; if ($category_id != "") { $dt_url .= "&category_id={$category_id}"; } if ($subcategory_id != "") { $dt_url .= "&subcategory_id={$subcategory_id}"; } $back_url = urlencode(preg_replace('/([&|\\?]msg\\=)(\\w+)/', '\\1', $_SERVER["REQUEST_URI"])); ?>
<td class="nobborder"> <?php echo gettext("Subcategory"); ?> : </td> <td class="nobborder left"> <div id="ajaxSubCategory"> <select name="subcategory"> <?php if ($plugin->get_subcategory_id() == '') { ?> <option value='NULL' SELECTED> </option> <?php } else { // Subcategory require_once 'classes/Subcategory.inc'; $list_subcategories = Subcategory::get_list($conn, 'WHERE cat_id=' . $plugin->get_category_id() . ' ORDER BY name'); foreach ($list_subcategories as $subcategory) { ?> <option value='<?php echo $subcategory->get_id(); ?> '<?php if ($plugin->get_subcategory_id() == $subcategory->get_id()) { echo ' SELECTED'; } ?> ><?php echo str_replace('_', ' ', $subcategory->get_name()); ?> </option> <?php
function subcategory_select($conn, $id) { $select = "<option title='" . _('Any') . "' value='0' >" . _('Any') . "</option>"; $subcat_list = Subcategory::get_list($conn, " where cat_id='{$id}'"); if (is_array($subcat_list)) { foreach ($subcat_list as $subcat) { $subcat_name = strlen($subcat->get_name()) > 36 ? substr($subcat->get_name(), 0, 39) . "..." : $subcat->get_name(); $select .= "<option title='" . $subcat->get_name() . "' value='" . $subcat->get_id() . "' >" . $subcat_name . "</option>"; } } return $select; }