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

Timestamp:

Nov 3, 2014 5:26:42 PM (11 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -37 +37 @@
                 if ($data['keyword'])
                 {
-                        $sql.=" WHERE (login_name LIKE '%".$data['keyword']."%' OR full_name LIKE '%".$data['keyword']."%') ";
+                        $sql.=" WHERE (phone LIKE '%".$data['keyword']."%' OR 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();
+                
+                $order = "";
+                if ($data['sorting_order'] != "sorting") {
+                        if ($data['sorting_field'] != "status") {
+                                $sort = "DESC";
+                                if ($data['sorting_order'] == "sorting_asc")
+                                        $sort = "ASC";
+                                $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
+                        }
+                }
+                return $this->db->query($sql." ".$order." LIMIT ".$data['start'].", ".$data['perpage']." ")->result_array();
         }