public static function get_locations()
{
global $wpdb;
global $carrental_db;
if (!self::$db) {
self::$db = $carrental_db;
}
try {
$branches = $wpdb->get_results('SELECT *
FROM `' . self::$db['branch'] . '`
WHERE `deleted` IS NULL
AND `active` = 1
ORDER BY `ordering` DESC');
$data = array();
if ($branches && !empty($branches)) {
foreach ($branches as $key => $val) {
$data[$val->id_branch] = $val;
$data[$val->id_branch]->enter_hours = unserialize($val->enter_hours);
$data[$val->id_branch]->return_hours = unserialize($val->return_hours);
$data[$val->id_branch]->hours = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . self::$db['branch_hours'] . '`
WHERE `id_branch` = %d ORDER BY `day` ASC', $val->id_branch));
}
}
return $data;
} catch (Exception $e) {
return $e->getMessage();
}
}
