Menus_model::getMenu PHP Method

getMenu() public method

public getMenu ( $menu_id )
    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();
        }
    }