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

Timestamp:

Nov 4, 2014 6:48:37 PM (11 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -10 +10 @@
         {
                 parent::__construct();
+                $this->vservices->setApiUrl($this->config->item('api_url'));
+                $this->vservices->setConnection($this->curl);
         }
         
@@ -26 +28 @@
                         $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
                 }
+                if ($data['status'] == 1){
+                        $sql.=" WHERE expire_date > NOW()";
+                }
+                if ($data['status'] == 2){
+                        $sql.=" WHERE expire_date < NOW()";
+                }
                 $order = "";
                 if ($data['sorting_order'] != "sorting") {
-                        $sort = "DESC";
-                        if ($data['sorting_order'] == "sorting_asc")
-                                $sort = "ASC";
-                        $order = "ORDER BY " . $data['sorting_field'] . " " . $sort;
+                        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();
@@ -39 +49 @@
         {
                 $sql="SELECT COUNT(".$this->id_name.") AS total FROM ".$this->table_name;
+                
+                if ($data['status'] == 1){
+                        $sql.=" WHERE expire_date > NOW()";
+                }
+                if ($data['status'] == 2){
+                        $sql.=" WHERE expire_date < NOW()";
+                }
+                
                 if (isset($data['keyword']))
                 {
-                        $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                        if (strlen($data['keyword'])>0)
+                                $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'];
         }
+        
+        function get_user_info($src, $us_id, $token)
+        {
+                $data = $this->vservices->actionExecute('getinfo', array('src' => $src, 'us_id' => $us_id, 'token'=>$token), 'user');
+                return $data;
+        }
 }