public static function getOrdersReturn($customer_id, $order_id = false, $no_denied = false, JeproshopContext $context = null) { if (!$context) { $context = JeproshopContext::getContext(); } $db = JFactory::getDBO(); $query = "SELECT * FROM " . $db->quoteName('#__jeproshop_order_return') . " WHERE " . $db->quoteName('customer_id'); $query .= " = " . (int) $customer_id . ($order_id ? " AND " . $db->quoteName('order_id') . " = " . (int) $order_id : ""); $query .= ($no_denied ? " AND " . $db->quoteName('state') . " != 4" : "") . " ORDER BY " . $db->quoteName('date_add') . " DESC "; $db->setQuery($query); $data = $db->loadObjectList(); foreach ($data as $k => $order) { $state = new JeproshopOrderReturnStateModelOrderReturnState($order->state); $data[$k]->state_name = $state->name[$context->language->lang_id]; $data[$k]->type = 'Return'; $data[$k]->tracking_number = $order->order_return_id; $data[$k]->can_edit = false; $data[$k]->reference = JeproshopOrderModelOrder::getUniqueReferenceOf($order->order_id); } return $data; }