}
            $sp .= '<br />' . displayCurrency('EUR', $row[$alias . '_price']);
            $sp .= '<br /><a target="_blank" href="?open=sp-product&amp;id=' . $row['products_id'] . '&amp;jng_sp_id=' . $jng_sp_id . '" title="Manage product detail for ' . $temp_sp['name'] . ' Catalog">Edit</a>';
            $sp .= '<input type="hidden" name="spid" value="' . $jng_sp_id . '" />';
        }
        $spdata[$alias] = $sp;
    }
    $products[] = $spdata;
}
//START TEMPLATE
$filter2 = ' <select name="sold-filter" class="input" onchange="frm_filsort.submit();">' . loadComboListFromArray($sold_options, null, $soldfilter_selected) . '</select>';
$content = '';
$content .= '<div style="float:right;">';
$content .= '<form name="frm_filsort" action="?open=sp-products-activation" method="post">';
$content .= '<table class="form" border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td width="50">Filter By</td><td>' . $class_pb->drawCombo($brands, true, 'brand-filter', $brandfiltered, 'class="input" onchange="frm_filsort.submit();"') . $filter2 . '</td></tr>';
$content .= '<tr><td>Sort By</td><td>' . $sort_opt . '</td></tr>';
$content .= '</table>';
$content .= '</form>';
$content .= '</div>';
$content .= '<div id="button-set-2">';
$content .= '<form name="searchpro" action="?open=sp-products-activation" method="post">';
$content .= '<input type="hidden" name="me_action" value="SEARCHPRODUCTS" /> ';
$content .= '<input type="text" id="keywords" class="iwbutton input" name="keywords" value="' . $keywords . '" /> ';
$content .= '<input type="submit" id="btn-submit" class="blue" name="submit" value="Search" /> ';
$content .= '<input type="button" id="btn-tips" name="tips" value="Tips" /> ';
$content .= '</form>';
$content .= '</div>';
$content .= '<div>&nbsp;</div>';
$content .= '<div id="searchtips" style="display:none;margin-bottom:20px;border:2px solid #ccc;background:#efefef;padding:10px;width:500px;" class="ui-corner-all">';
$content .= '<h3>SEARCH TIPS (special search function)</h3>';
    case '1':
        $navid_filters = '<tr><td>Nav ID</td><td>' . ComboBoxneckermannNavIDs('*', 'nav-filter', $navfiltered, '', 'onchange="filtering.submit();"') . '</td></tr>';
        break;
    case '2':
        $navid_filters = '<tr><td>Nav ID</td><td>' . ComboBoxottoDeNavIDs('nav-filter', $navfiltered, '', 'onchange="filtering.submit();"') . '</td></tr>';
        break;
    default:
        $navid_filters = '';
}
$content = '';
$content .= '<div style="float:right;">';
$content .= '<form name="filtering" action="?open=sp-products-links" method="post">';
$content .= '<table class="form" border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td colspan="2"><strong>Filter By</strong></td></tr>';
$content .= $navid_filters;
$content .= '<tr><td>Logo</td><td>' . $class_pb->drawCombo($brands, true, 'brand-filter', $brandfiltered, 'onchange="filtering.submit();"') . '</td></tr>';
$content .= '</table>';
$content .= '</form>';
$content .= '</div>';
$content .= '<div style="margin-bottom:10px;">' . $sort_opt . '</div>';
$content .= '<div id="button-set-2">';
$content .= '<form name="searchpro" action="?open=sp-products-links" method="post">';
$content .= '<input type="hidden" name="me_action" value="SEARCHPRODUCTS" /> ';
$content .= '<input type="text" class="iwbutton" name="keywords" value="' . $keywords . '" style="width:195px;" /> ';
$content .= '<input type="submit" class="blue" name="submit" value="Search" /> ';
$content .= '</form>';
$content .= '</div>';
$content .= '<div>&nbsp;</div>';
$content .= '<div style="padding:5px 0px"><small>* Changing links affects all Sales Partner and J&amp;G Website</a></small></div>';
$content .= tep_draw_table('prolinks', $cat);
$content .= '<div>&nbsp;</div>';
    $c['tpr'] = $row['total_returned'];
    $c['rr'] = number_format($row['returned_rate'], 1) . '%';
    $c['tps'] = number_format($row['total_sales'], 2);
    //$c['psd'] = $row['sales_daily'];
    if ($sort_table == 'pl.weekly_sold' || $sort_table == 'pl.sold_monthly_1' || $sort_table_2 == 'pl.weekly_sold' || $sort_table_2 == 'pl.sold_monthly_1') {
        $c['psw'] = number_format($row['weekly_sold'], 1);
        $c['psm'] = number_format($row['sold_monthly_1'], 1);
    } else {
        $c['psw'] = number_format($row['sales_weekly'], 1);
        $c['psm'] = number_format($row['sales_monthly'], 1);
    }
    $current_brand = $row['products_brand_id'];
    if ($current_brand == '0') {
        $current_brand = $row['use_logo'] == '1' ? '0' : 'N';
    }
    $c['l'] = $class_pb->drawCombo($brands, false, 'probrand', $current_brand) . '<input type="hidden" name="products_id" value="' . $row['products_id'] . '" />';
    $c['act'] = '<img src="images/icon-yes.png" title="Click to deactivate product and remove it from this list" />';
    $c['action'] = '<div align="center"><span class="ui-icon ui-icon-trash" id="' . $row['products_id'] . '" style="cursor: pointer;" title="Kill Product!"></span></div>';
    $cat[] = $c;
}
if (count($cat) == 1) {
    $c = array();
    foreach ($cat[0] as $key => $val) {
        $c[$key] = '&nbsp;';
    }
    $cat[] = $c;
}
$navids = array('0' => 'Please select a navigation...', 'UNSET' => 'None / Unset') + retrieveNavIDs($jng_sp_id, '*');
$navid_filters = '<select name="nav-filter" class="input" onchange="filtering.submit();">';
$navid_filters .= loadComboListFromArray($navids, null, $navfiltered, false);
$navid_filters .= '</select>';