Changeset 838 for pro-violet-viettel/sourcecode/application/modules/admin/models/reportmodel.php

Timestamp:

Mar 27, 2015 9:49:55 AM (10 years ago)

Author:

namnd

Message:

 

File:

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

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

@@ -33 +33 @@
                 
                 // tinh doanh thu theo thang
+                $from = "tblpaidlog.paid_time >= '" . $input ['year'] . "-" . $input ['month'] . "-01 00:00:00'";
                 $sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE $from AND $to  GROUP BY tbluser.province";
                 $query = $this->db->query ( $sql );
@@ -133 +134 @@
                 $data['totalDtn'] = $totalDtn;
                 
-                //return $provinces;
                 return $data;
         }