$statusNameShow = array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
if (isset($_GET['products']) && $_GET['products'] != '') {
$status = tep_db_prepare_input($_GET['products']);
$result = '';
if ($status == '10') {
//Cancel & Return Tab
$result .= $class_o->retrieveCancelRequestList();
$result .= '<div> </div>';
$result .= $class_o->retrieveReturnList();
} else {
//Other Tabs
$status_with_package = array('6', '7');
if (in_array($status, $status_with_package)) {
$result = $class_o->manageListProductPackageList($status, $ean_list, $date_range_start, $date_range_end, $brand_id, $cat_id);
} else {
$result = $class_o->retrieveListProductOverview($status, $ean_list, $date_range_start, $date_range_end, $brand_id, $cat_id);
}
}
echo utf8_encode($result);
exit;
}
if (isset($_GET['orders']) && $_GET['orders'] != '') {
$status = tep_db_prepare_input($_GET['orders']);
if (substr($status, 0, 4) == 'doa-') {
$order_prob_query = "SELECT opp.orders_products_problem_id, opp.products_quantity, opp.products_orders_status";
$order_prob_query .= ", o.orders_id, o.orders_no, o.customers_name, o.currency, o.customers_order_count, os.orders_status_name";
$order_prob_query .= ", op.products_id, op.products_model, op.final_price";
$order_prob_query .= " FROM orders_products_problem opp";
$order_prob_query .= " LEFT JOIN orders_products op ON op.orders_products_id=opp.orders_products_id";
$order_prob_query .= " LEFT JOIN orders o ON o.orders_id=op.orders_id";
$order_prob_query .= " LEFT JOIN orders_status os ON os.orders_status_id=opp.products_orders_status AND os.language_id=" . LANGUAGEID;
