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

Timestamp:

Feb 25, 2015 5:25:04 PM (10 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -25 +25 @@
                 $sql="SELECT * FROM ".$this->table_name;
                 if ($data['status'] == 1){
-                        $sql.=" WHERE expire_date > NOW()";
+                        $sql.=" WHERE expire_date > NOW() AND p_id <> 5";
                 }
                 if ($data['status'] == 2){
-                        $sql.=" WHERE expire_date < NOW()";
+                        $sql.=" WHERE expire_date > NOW() AND p_id = 5";
+                }
+                if ($data['status'] == 3){
+                        $sql.=" WHERE expire_date < NOW() AND p_id = 5";
+                }
+                if ($data['status'] == 4){
+                        $sql.=" WHERE expire_date < NOW() AND p_id <> 5";
                 }
                 if (isset($data['keyword']))
@@ -76 +82 @@
                 
                 if ($data['status'] == 1){
-                        $sql.=" WHERE expire_date > NOW()";
+                        $sql.=" WHERE expire_date > NOW() AND p_id <> 5";
                 }
                 if ($data['status'] == 2){
-                        $sql.=" WHERE expire_date < NOW()";
+                        $sql.=" WHERE expire_date > NOW() AND p_id = 5";
+                }
+                if ($data['status'] == 3){
+                        $sql.=" WHERE expire_date < NOW() AND p_id = 5";
+                }
+                if ($data['status'] == 4){
+                        $sql.=" WHERE expire_date < NOW() AND p_id <> 5";
                 }