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;
}
