Changeset 767 for pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_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/paidlog_model.php (modified) (4 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']."'";
                         }
                 }
+                //}