public function readcategory($cate_id) { $cate = new Categories_model(); $query = $this->db->get_where('categories', array('id' => $cate_id)); if ($query->num_rows !== 1) { throw new Exception("Cate id {$cate_id} not found in database"); } $rows = $query->result(); $row = $rows[0]; $cate->load($row); return $cate; }
public function load_dishes_view($dishes_name, $category) { $message = array('title', 'search_name', 'search', 'description', 'name', 'category', 'image', 'create_dish', 'edit', 'delete', 'are_you_sure', 'yes', 'cancel'); $data = $this->common->set_language_and_data('dishes', $message); $this->load->library('pagination'); $config['base_url'] = $dishes_name == NULL && $category == NULL ? base_url() . '/admin/dishes' : base_url() . '/admin/dishes/search'; if ($dishes_name == NULL) { $config['total_rows'] = Dishes_model::get_num_of_dishes_by_category($category); } elseif ($dishes_name != NULL) { $config['total_rows'] = Dishes_model::get_num_of_dishes_by_category($category, $dishes_name); } $config['per_page'] = 10; $config['use_page_numbers'] = TRUE; $config['uri_segment'] = $dishes_name == NULL && $category == NULL ? 3 : 4; $config['num_links'] = 3; $config['full_tag_open'] = "<ul class='pagination'>"; $config['full_tag_close'] = "</ul>"; $config['first_link'] = false; $config['last_link'] = false; $config['num_tag_open'] = '<li>'; $config['num_tag_close'] = '</li>'; $config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>"; $config['cur_tag_close'] = "<span class='sr-only'></span></a></li>"; $config['next_tag_open'] = "<li>"; $config['next_tagl_close'] = "</li>"; $config['prev_tag_open'] = "<li>"; $config['prev_tagl_close'] = "</li>"; $config['first_tag_open'] = "<li>"; $config['first_tagl_close'] = "</li>"; $config['last_tag_open'] = "<li>"; $config['last_tagl_close'] = "</li>"; $this->pagination->initialize($config); $data['pagination'] = $this->pagination->create_links(); $data['page'] = $dishes_name == NULL && $category == NULL ? $this->uri->segment(3) ? $this->uri->segment(3) : 0 : ($this->uri->segment(4) ? $this->uri->segment(4) : 0); $dishes = Dishes_model::get_all_dishes($config['per_page'], ($data['page'] == 0 ? $data['page'] : $data['page'] - 1) * $config['per_page'], $dishes_name, $category); $data['dishes'] = $dishes; $this->load->model('categories_model'); $data['categories'] = Categories_model::get_all_categories(); $this->common->load_view('admin/dishes/dishes', $data); }
function unique_url_title($url_title, $current_url_title = '') { $Categories = new Categories_model(); // If in edit mode ignore its current name if ($current_url_title != '') { $Categories->where('url_title !=', $current_url_title); } $Categories->where('category_group_id', $this->uri->segment(5))->where('url_title', $url_title)->get(); if ($Categories->exists()) { $this->form_validation->set_message('unique_url_title', 'The %s provided is already in use by anohter category in this category group.'); return FALSE; } else { return TRUE; } }
public function load_edit_menu_view($menu_id) { $message = array('title', 'description', 'name', 'manage_menus', 'dishes', 'dishes_of_menu', 'filtered_by', 'edit'); $data = $this->common->set_language_and_data('edit_menu', $message); $menu = Menus_model::get_menu_by_id($menu_id); $data['menu'] = $menu; $this->load->model('categories_model'); $data['categories'] = Categories_model::get_all_categories(); $this->load->model('dishes_model'); $data['dishes_of_menu'] = Dishes_model::get_dishes_from_menu($menu_id); $this->common->load_view('admin/menus/edit_menu', $data); }
public function sort_cats() { $this->common->authenticate(); $cats = $this->input->post('cats'); $message = $this->common->get_message('edit_category', array('edit_success', 'edit_failure')); if (Categories_model::order_cats($cats)) { $data = array('status' => 'success', 'message' => $message['edit_success']); } else { $data = array('status' => 'failure', 'message' => $message['edit_failure']); } echo json_encode($data); }