$q .= " AND e.attribute_category_id=" . $_SESSION[$session_page]['ef-category'];
}
if ($_SESSION[$session_page]['ef-supplier'] > 0) {
$q .= " AND etes.elements_suppliers_id=" . $_SESSION[$session_page]['ef-supplier'];
}
}
$q .= " GROUP BY elements_id";
//$q .= " ORDER BY esup.suppliers_name, firstadd";
$q .= " ORDER BY stars DESC, dioh_shadow_for_sorting_only ASC";
$r = tep_db_query($q);
$categories_combo = array();
$categories = $class_ea->retrieveListData('cat');
foreach ($categories as $cat) {
$categories_combo[$cat['element_category_id']] = $cat['name'];
}
$suppliers = elements_suppliers::retrieveListCombo();
$tabcontent = '';
$tabcontent .= '<div style="margin-bottom:10px;">Filter by Category ';
$tabcontent .= '<select name="ef-category" class="ef input"><option value="0">Show All</option>' . loadComboListFromArray($categories_combo, null, $_SESSION[$session_page]['ef-category']) . '</select>';
$tabcontent .= ' ⋅ Default Supplier <select name="ef-supplier" class="ef input"><option value="0">Show All</option>' . loadComboListFromArray($suppliers, null, $_SESSION[$session_page]['ef-supplier']) . '</select>';
$tabcontent .= '</div>';
if (tep_db_num_rows($r) == 0) {
$tabcontent .= '<h3 class="red">No Sourcing Data Found</h3>';
} else {
element::loadDIOHsettings();
$epo_list = array();
$epo_total = 0;
while ($row = tep_db_fetch_array($r)) {
$epo_total++;
if ($status == 'M' || $row['stock'] <= $row['quantity']) {
$epo_list[] = $row;
/**
* Get all outsourcing suppliers
* @return Array
*/
function getOutsourceSuppliers()
{
use_class('elements_suppliers');
return elements_suppliers::retrieveListCombo("suppliers_outsourced='1'");
}
