}
use_class('orders');
use_class('jng_sp');
use_class('jng_sp_orders');
use_class('products_ean');
use_class('products_minierp');
use_class('bins');
$class_o = new orders();
$class_sp = new jng_sp();
$class_jo = new jng_sp_orders();
$class_ean = new products_ean();
$class_pm = new products_minierp();
$class_bin = new bins();
$segment_id = $_GET['segment_id'];
$clearance_period = $_GET['clearance_period'];
$log_column = $class_pm->translateBestGoodPeriod($clearance_period);
$segment = $class_bin->retrieveSegmentDetail($segment_id);
if ($segment['used_for'] == 'P') {
    $q = "SELECT b.*, ps.`products_id`, ps.`stock`, ps.`articles_id`, p.`products_image`, p.`products_model` FROM bins b INNER JOIN products_stock ps";
    $q .= " ON b.`products_stock_id` = ps.`products_stock_id` AND ps.`jng_warehouses_id` = {$segment['warehouses_id']}";
    $q .= " LEFT JOIN products_log pl ON pl.`products_id` = ps.`products_id`";
    $q .= " LEFT JOIN products p ON p.`products_id` = ps.`products_id`";
    $q .= " LEFT OUTER JOIN `jng_sp_orders_items` joi ON joi.`products_id` = pl.`products_id` AND joi.`status` IN (1, 8)";
    $q .= " WHERE (pl.`{$log_column}` = 0 OR pl.`products_id` IS NULL)";
    $q .= " AND joi.`jng_sp_orders_items_id` IS NULL";
    $q .= " AND b.`bin_segments_id` = {$segment_id}";
    $q .= " ORDER BY b.code";
} elseif ($segment['used_for'] == 'E') {
}
$clean_picklists = array();
$dbq = tep_db_query($q);
warehouseFGCombo();
$session_page = 'sp-products-manage';
$page = 1;
if (isset($_GET['page'])) {
    $page = intval($_GET['page']);
}
if (isset($_POST['keywords'])) {
    $_SESSION[$session_page]['keywords'] = tep_db_prepare_input($_POST['keywords']);
}
if (!isset($_SESSION[$session_page]['keywords'])) {
    $_SESSION[$session_page]['keywords'] = '';
}
$keywords = $_SESSION[$session_page]['keywords'];
$sort_options = array();
foreach ($class_pm->bestgood_periods as $p => $name) {
    $sort_options[$class_pm->translateBestGoodPeriod($p)] = 'Top Selling ' . $name;
}
if (isset($_POST['sortby'])) {
    $_SESSION[$session_page]['sortby'] = tep_db_prepare_input($_POST['sortby']);
}
if (!isset($_SESSION[$session_page]['sortby'])) {
    $sort_options_keys = array_keys($sort_options);
    $_SESSION[$session_page]['sortby'] = $sort_options_keys[1];
}
$sort_option = $_SESSION[$session_page]['sortby'];
if (isset($_POST['viewall'])) {
    $_SESSION[$session_page]['viewall'] = tep_db_prepare_input($_POST['viewall']);
}
if (!isset($_SESSION[$session_page]['viewall'])) {
    $_SESSION[$session_page]['viewall'] = '1';
}