public function getMenu($menu_id)
{
//$this->db->select('menus.menu_id, *');
$this->db->select('menus.menu_id, menu_name, menu_description, menu_price, menu_photo, menu_category_id, stock_qty,
minimum_qty, subtract_stock, menu_status, menu_priority, category_id, categories.name, description, special_id, start_date,
end_date, special_price, special_status, menus.mealtime_id, mealtimes.mealtime_name, mealtimes.start_time, mealtimes.end_time, mealtime_status');
$this->db->from('menus');
$this->db->join('categories', 'categories.category_id = menus.menu_category_id', 'left');
$this->db->join('menus_specials', 'menus_specials.menu_id = menus.menu_id', 'left');
$this->db->join('mealtimes', 'mealtimes.mealtime_id = menus.mealtime_id', 'left');
$this->db->where('menus.menu_id', $menu_id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
return $query->row_array();
}
}