public static function getStatus($id = 0)
{
if (!array_key_exists($id, self::$status)) {
$db = Factory::getDBO();
$query = ' SELECT a.title, a.stock_movements, a.change_user_group, a.change_points_needed, a.change_points_received,' . ' a.email_customer, a.email_others, a.email_subject, a.email_subject_others, a.email_text, a.email_footer,' . ' a.email_text_others, a.email_send, a.email_send_format, a.email_attachments, a.orders_view_display, a.download,' . ' a.activate_gift, a.email_gift, a.email_subject_gift_sender, a.email_text_gift_sender, a.email_subject_gift_recipient, a.email_text_gift_recipient, a.email_gift_format' . ' FROM #__phocacart_order_statuses AS a' . ' WHERE a.id = ' . (int) $id . ' ORDER BY a.id';
$db->setQuery($query);
$s = $db->loadObject();
if (!empty($s) && isset($s->title) && $s->title != '') {
self::$status[$id]['title'] = Text::_($s->title);
self::$status[$id]['id'] = (int) $id;
self::$status[$id]['stock_movements'] = $s->stock_movements;
self::$status[$id]['change_user_group'] = $s->change_user_group;
self::$status[$id]['change_points_needed'] = $s->change_points_needed;
self::$status[$id]['change_points_received'] = $s->change_points_received;
self::$status[$id]['email_customer'] = $s->email_customer;
self::$status[$id]['email_others'] = $s->email_others;
self::$status[$id]['email_subject'] = $s->email_subject;
self::$status[$id]['email_subject_others'] = $s->email_subject_others;
self::$status[$id]['email_text'] = $s->email_text;
self::$status[$id]['email_footer'] = $s->email_footer;
self::$status[$id]['email_text_others'] = $s->email_text_others;
self::$status[$id]['email_send'] = $s->email_send;
self::$status[$id]['email_send_format'] = $s->email_send_format;
self::$status[$id]['email_attachments'] = $s->email_attachments;
self::$status[$id]['activate_gift'] = $s->activate_gift;
self::$status[$id]['email_gift'] = $s->email_gift;
self::$status[$id]['email_subject_gift_sender'] = $s->email_subject_gift_sender;
self::$status[$id]['email_text_gift_sender'] = $s->email_text_gift_sender;
self::$status[$id]['email_subject_gift_recipient'] = $s->email_subject_gift_recipient;
self::$status[$id]['email_text_gift_recipient'] = $s->email_text_gift_recipient;
self::$status[$id]['email_gift_format'] = $s->email_gift_format;
self::$status[$id]['orders_view_display'] = $s->orders_view_display;
self::$status[$id]['download'] = $s->download;
$query = 'SELECT a.title AS text, a.id AS value' . ' FROM #__phocacart_order_statuses AS a' . ' WHERE a.published = 1' . ' ORDER BY a.ordering';
$db->setQuery($query);
$data = $db->loadObjectList();
if (!empty($data)) {
foreach ($data as $k => $v) {
$v->text = Text::_($v->text);
}
}
self::$status[$id]['data'] = $data;
} else {
self::$status[$id] = false;
}
}
return self::$status[$id];
}