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

Timestamp:

Nov 3, 2014 6:48:32 PM (11 years ago)

Author:

namnd

Message:

 

File:

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

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

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