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

Timestamp:

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

Author:

quyenla

Message:

collaborator

Location:

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

Files:

• admin_model.php (modified) (1 diff)
• collabolator_model.php (modified) (1 diff)

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