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

Timestamp:

Oct 31, 2014 2:55:30 PM (11 years ago)

Author:

quyenla

Message:

collaborator

File:

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

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

@@ -4 +4 @@
 {
         
-        protected $table_name = 'tblcollabolator';
+        protected $table_name = 'tblcollaborator';
         protected $id_name = 'id';
 
@@ -13 +13 @@
         function getCollaborator($data)
         {
-            $sql="SELECT * FROM tblcollaborator";
+            $sql="SELECT * FROM ".$this->table_name;
             $data['keyword']='';
 
             if ($data['keyword'])
             {
-            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$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();
+            return $this->db->query($sql." ORDER BY id DESC LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
 
+        }
+        function isExist($data)
+        {
+            $sql="SELECT COUNT(id) as total FROM ".$this->table_name." WHERE ".$data['field']." = '".$data['value']."' LIMIT 1";
+            if ($this->db->query($sql)->row_array()['total']==1)
+            {
+                return true;
+            }
+            else
+            {
+                return false;
+            }
+            
         }
         function countCollaborator($data)
         {
-            $sql="SELECT COUNT(id) as total FROM tblcollaborator";
+            $sql="SELECT COUNT(id) as total FROM ".$this->table_name;
             if (isset($data['keyword']))
             {
-            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
+            $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%') ";
             }