- Timestamp:
- Jan 30, 2015 6:49:37 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/admin/models/reportmodel.php
r702 r728 67 67 } 68 68 } 69 69 70 return $provinces; 70 71 } … … 74 75 $provinces = lang('_PROVINCES_'); 75 76 // tinh thue bao theo thang 76 $sql = "SELECT * FROM tbluser LEFT JOIN tblservicepackage ON tbluser.p_id=tblservicepackage.p_id WHERE tbluser.created_time >'" .$input['year']."-".$input['month']."-01' AND tbluser.created_time <'".$input['year']."-".$input['month']."-31' AND tblservicepackage.p_period > 0 ";77 $sql = "SELECT * FROM tbluser LEFT JOIN tblservicepackage ON tbluser.p_id=tblservicepackage.p_id WHERE tbluser.created_time >'" . $input['year'] . "-" . $input['month'] . "-01' AND tbluser.created_time <'" . $input['year'] . "-" . $input['month'] . "-31' AND tblservicepackage.p_period > 0 "; 77 78 $query = $this->db->query($sql); 78 79 $users = $query->result_array(); … … 96 97 97 98 foreach ($provinces as $index => $province) { 98 $provinces[$index]['stt'] =$index+1;99 $provinces[$index]['stt'] = $index + 1; 99 100 $provinces[$index]['total'] = 0; 100 101 $totaluser = 0; … … 123 124 } 124 125 } 125 126 $data['packages'] =$packages;127 $data['provinces'] =$provinces;126 127 $data['packages'] = $packages; 128 $data['provinces'] = $provinces; 128 129 return $data; 129 130 }
Note: See TracChangeset
for help on using the changeset viewer.