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

Timestamp:

Nov 3, 2014 9:51:10 AM (11 years ago)

Author:

quyenla

Message:

collaborator order sourcecode

File:

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

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

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