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