$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;