Changeset 360 for pro-violet-viettel/sourcecode/application/modules/admin

Timestamp:

Oct 31, 2014 11:14:19 AM (11 years ago)

Author:

quyenla

Message:

collaborator

Location:

pro-violet-viettel/sourcecode/application/modules/admin

Files:

• controllers/collaborator.php (modified) (1 diff)
• controllers/home.php (modified) (2 diffs)
• models/admin_model.php (modified) (1 diff)
• models/collabolator_model.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/admin/controllers/collaborator.php

@@ -12 +12 @@
 
     public function index() {
-        $data=array();
+        $data = array();
         $this->load->driver("pp");
         $admin_info = $this->session->userdata('adminInfo');
         if ($admin_info) {
             $data['content'] = $this->getCollaborators();
-            $this->load->view('collaborator/index',$data);
+            $this->load->view('collaborator/index', $data);
         } else {
             $this->load->view('login');
         }
     }
-    public function getCollaborators($filters=array())
-    {
-  
-        $data['current_page'] = $this->uri->segment(4,1);
-        $data['itemsoptions']=array(10,25,50,100);
-        $data['perpage'] = 10;   
+
+    public function getCollaborators($filters = array()) {
+        $this->load->helper('pagging');
+        $this->load->model('collabolator_model');
+        $data['current_page'] = $this->uri->segment(4, 1);
+        $data['itemsoptions'] = array(10, 25, 50, 100);
+        $data['perpage'] = 10;
+        $data['keyword'] = "";
+
+        if ($this->input->post('items')) {
+            $data['perpage'] = $this->input->post('items');
+        }
+        if ($this->input->post('keyword')) {
+            $data['keyword'] = $this->input->post('keyword');
+        }
         
-        if ($this->input->post('items'))
-        {
-        $data['perpage'] = $this->input->post('items');    
-        }
-        $sql="SELECT * FROM tblcollaborator";
-        $data['keyword']='';
-       
-        if ($this->input->post('keyword'))
-        {
-        $data['keyword']=$this->input->post('keyword');
-        $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
-        }
+        $data['start'] = ($data['current_page'] - 1) * $data['perpage'];
+        $data['total'] = $this->collabolator_model->countCollaborator($data);  
+        $data['collaborators'] = $this->collabolator_model->getCollaborator($data);
 
-        $data['total']=$this->db->query($sql)->num_rows();
-        $data['start']=($data['current_page']-1)*$data['perpage'];
-        $query = $this->db->query($sql." LIMIT ".$data['start'].", ".$data['perpage']."");
-        $data['collaborators']=$query->result_array();
-        $this->load->library('pagination');
-        $url = "http://$_SERVER[HTTP_HOST]/admin/cong_tac_vien/trang/";
-        $config['base_url'] = $url;
-        $config['total_rows'] = $data['total'];
-        $config['use_page_numbers'] = TRUE;
-        $config['per_page'] = $data['perpage'];
-        $config['num_tag_open'] = "<li>";
-        $config['num_tag_close'] = "</li>";
-        $config['cur_tag_open'] = "<li class='active'><a>";
-        $config['cur_tag_close'] = '</a></li>';
-        $config['last_link'] = '»';
-        $config['first_link'] = '«';
-        $config['first_tag_open'] = "<li title='Trang đầu tiên'>";
-        $config['first_tag_close'] = '</li>';
-        $config['last_tag_open'] = "<li title='Trang cuối cùng'>";
-        $config['last_tag_close'] = '</li>';
-        $config['next_link'] = '>';
-        $config['next_tag_open'] = "<li title='Trang kế tiếp'>";
-        $config['next_tag_close'] = '</li>';
-        $config['prev_link'] = '<';
-        $config['prev_tag_open'] = "<li title='Trang trước'>";
-        $config['prev_tag_close'] = '</li>';
-        $config['num_links'] = 2;
-        $config['current_page'] = $data['current_page'];
-        $config['ajax_class'] = 'ajax_paging';
-        $this->pagination->initialize($config);
-        $data['paging'] = $this->pagination->create_links();
+        $data['paging_url'] = base_url() . "/admin/cong_tac_vien/trang/";
+        $data['num_links'] = 2;
+        $data['paging'] = pagging($data);
 
         if ($this->input->is_ajax_request()) {
-        return $this->load->view('collaborator/listview', $data);   
+            return $this->load->view('collaborator/listview', $data);
         }
-        return $this->load->view('collaborator/listview', $data,true);   
+        return $this->load->view('collaborator/listview', $data, true);
     }
-    public function addCollaborator()
-    {
-        $result=array();
-        $input=$this->input->post();
-        $this->db->insert('tblcollaborator', $input); 
-        $result['success']=1;
+
+    public function addCollaborator() {
+        $result = array();
+        $input = $this->input->post();
+        $this->db->insert('tblcollaborator', $input);
+        $result['success'] = 1;
         echo json_encode($result);
     }
+
     public function test() {
-        
+
         for ($i = 1; $i <= 500; $i++) {
             $collaborator = new Entities\Tblcollaborator();
             $collaborator->setActivated(rand(0, 1));
             $collaborator->setAuthor(1);
-            $collaborator->setCellphone('0' . (1695061706+$i));
+            $collaborator->setCellphone('0' . (1695061706 + $i));
             $collaborator->setCreatedTime(date("Y-m-d H:i:s"));
-            $collaborator->setFullName("Full Name ".$i);
-            $collaborator->setLoginName("loginname".$i);
+            $collaborator->setFullName("Full Name " . $i);
+            $collaborator->setLoginName("loginname" . $i);
             $collaborator->setPasswd(md5("12345678"));
             $collaborator->setUpdatedTime(date("Y-m-d H:i:s"));

pro-violet-viettel/sourcecode/application/modules/admin/controllers/home.php

@@ -11 +11 @@
         public function index ()
         {
+            
                 $admin_info = $this->session->userdata('adminInfo');
                 if ($admin_info)
@@ -23 +24 @@
         public function login()
         {
+           
                 $username = $this->input->post('user_admin');
                 $password = $this->input->post('password');

pro-violet-viettel/sourcecode/application/modules/admin/models/admin_model.php

@@ -16 +16 @@
                 $hash_password = md5($password);
                 $query = "SELECT * FROM tbladmin WHERE  login_name = ? AND  passwd = ?";
-                $result = $this->db->query($query, array($login_name, $hash_password));
+                $result = $this->db->query($query, array($login_name, $hash_password));
                 if($result->num_rows() == 1){
                         return $result->row(0);

pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php

@@ -11 +11 @@
                 parent::__construct();
         }
-        
+        function getCollaborator($data)
+        {
+            $sql="SELECT * FROM tblcollaborator";
+            $data['keyword']='';
+
+            if ($data['keyword'])
+            {
+            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
+            }
+            return $this->db->query($sql." LIMIT ".$data['start'].", ".$data['perpage']."")->result_array();
+
+        }
+        function countCollaborator($data)
+        {
+            $sql="SELECT COUNT(id) as total FROM tblcollaborator";
+            if (isset($data['keyword']))
+            {
+            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
+            }
+
+            return $this->db->query($sql)->row_array()['total'];
+            
+        }
 }