Inheritance: extends CI_Model
 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);
 }
Example #3
0
 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;
     }
 }
Example #4
0
 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);
 }