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

Timestamp:

Nov 3, 2014 12:25:15 PM (11 years ago)

Author:

namnd

Message:

 

Location:

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

Files:

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

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

@@ -31 +31 @@
                 return $query->num_rows();
         }
+        
+        function get_list_admins($data)
+        {
+                $sql="SELECT * FROM ".$this->table_name;
+                $data['keyword']='';
+                if ($data['keyword'])
+                {
+                        $sql.=" WHERE (login_name LIKE '%".$data['keyword']."%' OR full_name LIKE '%".$data['keyword']."%') ";
+                }
+                return $this->db->query($sql." ORDER BY admin_id DESC LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
+        }
+
+        function get_total_admins($data)
+        {
+                $sql="SELECT COUNT(".$this->id_name.") AS total FROM ".$this->table_name;
+                if (isset($data['keyword']))
+                {
+                        $sql.=" WHERE (login_name LIKE '%".$data['keyword']."%' OR full_name LIKE '%".$data['keyword']."%') ";
+                }
+                return $this->db->query($sql)->row_array()['total'];
+        }
 }

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

@@ -18 +18 @@
                 return $query->num_rows();
         }
+        
+        function get_list_users($data)
+        {
+                $sql="SELECT * FROM ".$this->table_name;
+                $data['keyword']='';
+                if ($data['keyword'])
+                {
+                        $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                }
+                return $this->db->query($sql." ORDER BY us_id DESC LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
+        }
 
+        function get_total_users($data)
+        {
+                $sql="SELECT COUNT(".$this->id_name.") AS total FROM ".$this->table_name;
+                if (isset($data['keyword']))
+                {
+                        $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                }
+                return $this->db->query($sql)->row_array()['total'];
+        }
 }