Changeset 610

Timestamp:

Nov 21, 2014 4:26:12 PM (10 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

@@ -24 +24 @@
         {
                 $sql="SELECT * FROM ".$this->table_name;
-                if ($data['keyword'])
-                {
-                        $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()";
@@ -33 +29 @@
                 if ($data['status'] == 2){
                         $sql.=" WHERE expire_date < NOW()";
+                }
+                if (isset($data['keyword']))
+                {
+                        if (strlen($data['keyword'])>0){
+                                if ($data['status']==0){
+                                        $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                                }else
+                                {
+                                        $sql.=" AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                                }
+                        }
                 }
                 $order = "";
@@ -59 +66 @@
                 if (isset($data['keyword']))
                 {
-                        if (strlen($data['keyword'])>0)
-                                $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                        if (strlen($data['keyword'])>0){
+                                if ($data['status']==0){
+                                        $sql.=" WHERE (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                                }else
+                                {
+                                        $sql.=" AND (cellphone LIKE '%".$data['keyword']."%' OR collaborator LIKE '%".$data['keyword']."%' OR acc_balanced LIKE '%".$data['keyword']."%') ";
+                                }
+                        }
                 }