Changeset 354 for pro-violet-viettel/sourcecode/application/modules/admin/controllers

Timestamp:

Oct 30, 2014 6:21:10 PM (11 years ago)

Author:

quyenla

Message:

collaborator

File:

• pro-violet-viettel/sourcecode/application/modules/admin/controllers/collaborator.php (modified) (3 diffs)

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

@@ -17 +17 @@
         if ($admin_info) {
             $data['content'] = $this->getCollaborators();
-            $this->parser->parse('collaborator/index',$data);
+            $this->load->view('collaborator/index',$data);
         } else {
             $this->load->view('login');
@@ -24 +24 @@
     public function getCollaborators($filters=array())
     {
-        $this->load->driver("pp");
+  
         $data['current_page'] = $this->uri->segment(4,1);
         $data['itemsoptions']=array(10,25,50,100);
-        $data['perpage'] = 10;    
+        $data['perpage'] = 10;   
+        
         if ($this->input->post('items'))
         {
         $data['perpage'] = $this->input->post('items');    
         }
-        
+        $sql="SELECT * FROM tblcollaborator";
         $data['keyword']='';
-        $sql=" FROM Entities\Tblcollaborator c";
+       
         if ($this->input->post('keyword'))
         {
-        $sql.=" WHERE c.full_name LIKE '%".$this->input->post('keyword')."%'"; 
-        $data['keyword']=$this->input->post('keyword');
+        $sql.=" WHERE (full_name LIKE '%".$this->input->post('keyword')."%' OR login_name LIKE '%".$this->input->post('keyword')."%')";
         }
-        
-        $query = $this->doctrine->em->createQuery('SELECT COUNT(c.id) '.$sql);
-        $data['total'] = $query->getSingleScalarResult();
-        
-        $query = $this->doctrine->em->createQuery('SELECT c '.$sql);
-        $query->setFirstResult(($data['current_page']-1)*$data['perpage']);
-        $query->setMaxResults($data['perpage']);
-        $data['collaborators'] = $query->getArrayResult();
-        
-        
+
+        $data['total']=500;
+        $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/";
@@ -79 +74 @@
 
         if ($this->input->is_ajax_request()) {
-        return $this->pp->parse('modules/admin/views/collaborator/listview', $data);   
+        return $this->load->view('collaborator/listview', $data);   
         }
-        return $this->pp->parse('modules/admin/views/collaborator/listview', $data,true);   
+        return $this->load->view('collaborator/listview', $data,true);   
     }
     public function test() {
+        $data=$this->db->get_where('tblcollaborator');
+        print_r ($data->result_array());
+        die();
         for ($i = 1; $i <= 500; $i++) {
             $collaborator = new Entities\Tblcollaborator();