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

Timestamp:

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

Author:

namnd

Message:

 

Location:

pro-violet-viettel/sourcecode/application/modules/admin/models

Files:

• paidlog_model.php (modified) (4 diffs)
• user_model.php (modified) (2 diffs)

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

@@ -14 +14 @@
         function getPaidlogs($data) {
         $sql = "SELECT * FROM " . $this->table_name. " INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id ";
+                if ($data['paid_type'] == 1){
+                        $sql.=" WHERE paid_type = 1";
+                }
+                if ($data['paid_type'] == 2){
+                        $sql.=" WHERE paid_type = 2";
+                }
+                /*
         if ($data['keyword']) {
             if ($data['search_field'] == "cellphone") {
@@ -19 +26 @@
             } 
         }else{
-                        if(strlen($data['daterange_start'])>0){
-                                
+                */
+                if(strlen($data['daterange_start'])>0){
+                        if ($data['paid_type'] ==0){
                                 $sql.=" WHERE paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
-                                write_file('./log/sql.log', date("m/d/Y H:i:s")." ".$sql."\n", FOPEN_WRITE_CREATE);
+                                //write_file('./log/sql.log', date("m/d/Y H:i:s")." ".$sql."\n", FOPEN_WRITE_CREATE);
+                        }else{
+                                $sql.=" AND paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
                         }
                 }
+                //}
 
         $order = "";
@@ -36 +47 @@
         }
         $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
-      // echo $sql;
         return $this->db->query($sql)->result_array();
     }
@@ -44 +54 @@
     function countPaidlog($data) {
         $sql = "SELECT COUNT(".$this->id_name.") as total FROM " . $this->table_name." INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id";
-        if ($data['keyword']) {
+        /*if ($data['keyword']) {
             if ($data['search_field'] == "cellphone") {
                 $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
             } 
         }else{
-                        if(strlen($data['daterange_start'])>0){
-                                
+                */
+                if ($data['paid_type'] == 1){
+                        $sql.=" WHERE paid_type = 1";
+                }
+                if ($data['paid_type'] == 2){
+                        $sql.=" WHERE paid_type = 2";
+                }
+                if(strlen($data['daterange_start'])>0){
+                        if ($data['paid_type'] ==0){
                                 $sql.=" WHERE paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
-                                //write_file('./log/sql.log', date("m/d/Y H:i:s")." ".$sql."\n", FOPEN_WRITE_CREATE);
+                        }else{
+                                $sql.=" AND paid_time BETWEEN '".$data['daterange_start']."' AND '".$data['daterange_end']."'";
                         }
                 }
+                //}
                 
         

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";
                 }