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(); } }