- Timestamp:
- Apr 7, 2015 1:52:40 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/admin/models/paidlog_model.php
r818 r883 13 13 } 14 14 function getPaidlogs($data) { 15 15 16 if ($data['paid_type'] == 0){ 16 17 $sql = "SELECT SUM(amount) as total_amount FROM tblpaidlog"; … … 19 20 } 20 21 $r = $this->db->query($sql)->row_array(); 22 21 23 $total_amount = (int)$r['total_amount']; 22 24 $sql = "SELECT * FROM " . $this->table_name. " INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id "; … … 54 56 } 55 57 } 56 if ($data['start']){ 58 59 //if ($data['start']){ 60 57 61 $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " "; 58 } 62 //} 63 59 64 //return $this->db->query($sql)->result_array(); 60 65 $re = $this->db->query($sql)->result_array(); 66 61 67 $result['paid_logs'] = $re; 68 62 69 $result['total_amount'] = $total_amount; 63 70 return $result;
Note: See TracChangeset
for help on using the changeset viewer.