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

Timestamp:

Jan 9, 2015 10:35:30 AM (10 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -18 +18 @@
                 $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
             } 
-        }
+        }else{
+                        if(strlen($data['daterange_start'])>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);
+                        }
+                }
 
         $order = "";
@@ -42 +48 @@
                 $sql.=" WHERE (cellphone LIKE '%" . $data['keyword'] . "%')";
             } 
-        }
+        }else{
+                        if(strlen($data['daterange_start'])>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);
+                        }
+                }
+                
         
         $result = $this->db->query($sql)->row_array();