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

Timestamp:

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

Author:

quyenla

Message:

collaborator

File:

• pro-violet-viettel/sourcecode/application/modules/admin/models/collabolator_model.php (modified) (1 diff)

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'];
+            
+        }
 }