load->model('field_m'); $this->load->model('listing_m'); $this->load->model('listingfield_m'); $this->load->model('location_m'); $this->load->model('category_m'); $this->load->load_helper('listing'); /* [Table Actions Bulk Form] */ $table_action = $this->input->post_get('table_action'); $action = $this->input->post_get('action'); $posts_selected = $this->input->post_get('post'); if(!empty($table_action)) { switch ($action) { case 'delete': $this->bulk_delete($posts_selected); break; case 'deactivate': $this->bulk_deactivate($posts_selected); break; case 'activate': $this->bulk_activate($posts_selected); break; case 'deapprove': $this->bulk_deapprove($posts_selected); break; case 'approve': $this->bulk_approve($posts_selected); break; default: } } /* [Search Form] */ $controller = 'listing'; $columns = array('ID', 'location_id', 'category_id', 'post_title', 'post_date', 'search', 'order_by', 'address'); $external_columns = array('location_id', 'category_id', 'post_title'); $this->data['categories'] = $this->category_m->get_parents(); $this->data['locations'] = $this->location_m->get_parents(); $this->data['order_by'] = array('ID DESC' => __('ID', 'wpdirectorykit').' DESC', 'ID ASC' => __('ID', 'wpdirectorykit').' ASC', 'post_title ASC' => __('Post Title', 'wpdirectorykit').' ASC', 'post_title DESC' => __('Post Title', 'wpdirectorykit').' DESC', 'post_date ASC' => __('Post Date', 'wpdirectorykit').' ASC', 'post_date DESC' => __('Post Date', 'wpdirectorykit').' DESC',); $rules = array( array( 'field' => 'location_id', 'label' => __('Location', 'wpdirectorykit'), 'rules' => '' ), array( 'field' => 'category_id', 'label' => __('Category', 'wpdirectorykit'), 'rules' => '' ), array( 'field' => 'search', 'label' => __('Search tag', 'wpdirectorykit'), 'rules' => '' ), array( 'field' => 'order_by', 'label' => __('Order By', 'wpdirectorykit'), 'rules' => '' ), ); $this->data['db_data'] = $this->listing_m->prepare_data($this->input->get(), $rules); /* [/Search Form] */ wdk_prepare_search_query_GET($columns, $controller.'_m', $external_columns); $total_items = $this->listing_m->total(); $current_page = 1; if(isset($_GET['paged'])) $current_page = intval($_GET['paged']); $this->data['paged'] = $current_page; $per_page = 20; $offset = $per_page*($current_page-1); $this->data['pagination_output'] = ''; if(function_exists('wmvc_wp_paginate')) $this->data['pagination_output'] = wmvc_wp_paginate($total_items, $per_page); wdk_prepare_search_query_GET($columns, $controller.'_m', $external_columns); $this->data['listings'] = $this->listing_m->get_pagination($per_page, $offset); // Load view $this->load->view('wdk/index', $this->data); } public function delete() { $this->load->model('listing_m'); $post_id = (int) $this->input->post_get('id'); $paged = (int) $this->input->post_get('paged'); $this->listing_m->delete($post_id); wp_redirect(admin_url("admin.php?page=wdk&paged=$paged")); } public function bulk_delete($posts_selected) { $this->load->model('listing_m'); foreach($posts_selected as $key=>$post_id) { $this->listing_m->delete($post_id); } wp_redirect(admin_url("admin.php?page=wdk")); } public function bulk_deactivate($posts_selected) { $this->load->model('listing_m'); foreach($posts_selected as $key=>$post_id) { if($this->listing_m->check_deletable($post_id)) $this->listing_m->insert(array('is_activated'=>NULL), $post_id); } wp_redirect(admin_url("admin.php?page=wdk")); } public function bulk_activate($posts_selected) { $this->load->model('listing_m'); foreach($posts_selected as $key=>$post_id) { if($this->listing_m->check_deletable($post_id)) $this->listing_m->insert(array('is_activated'=>1), $post_id); } wp_redirect(admin_url("admin.php?page=wdk")); } public function bulk_deapprove($posts_selected) { $this->load->model('listing_m'); foreach($posts_selected as $key=>$post_id) { if($this->listing_m->check_deletable($post_id)) $this->listing_m->insert(array('is_approved'=>NULL), $post_id); } wp_redirect(admin_url("admin.php?page=wdk")); } public function bulk_approve($posts_selected) { $this->load->model('listing_m'); foreach($posts_selected as $key=>$post_id) { if($this->listing_m->check_deletable($post_id)) $this->listing_m->insert(array('is_approved'=>1), $post_id); } wp_redirect(admin_url("admin.php?page=wdk")); } }