Changeset 763

Timestamp:

Feb 12, 2015 4:01:01 PM (10 years ago)

Author:

quyenla

Message:

fix

File:

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

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

@@ -22 +22 @@
         $provinces = lang('_PROVINCES_');
         // Tinh doanh thu theo tinh theo nam
-        $sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE tblpaidlog.paid_time >'" . $input['year'] . "-01-01' AND tblpaidlog.paid_time <'" . ($input['year'] + 1) . "-01-01' GROUP BY tbluser.province";
+        $sql = "SELECT *,SUM(amount) as total FROM tblpaidlog LEFT JOIN tbluser ON tbluser.us_id=tblpaidlog.us_id WHERE tblpaidlog.paid_time >= '" . $input['year'] . "-01-01' AND tblpaidlog.paid_time <= '" . ($input['year'] + 1) . "-01-01' GROUP BY tbluser.province";
         $query = $this->db->query($sql);
         $dtns = $query->result_array();