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 => $or) {
$state = new JeproshopOrderReturnStateModelOrderReturnState($or->state);
$data[$k]->state_name = $state->name[$context->language->lang_id];
$data[$k]->type = 'Return';
$data[$k]->tracking_number = $or->order_return_id;
$data[$k]->can_edit = false;
$data[$k]->reference = JeproshopOrderModelOrder::getUniqReferenceOf($or->order_id);
}
return $data;
}
