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

Timestamp:

Mar 3, 2015 4:43:43 PM (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

@@ -13 +13 @@
         }
         function getPaidlogs($data) {
+                if ($data['paid_type'] == 0){
+                        $sql = "SELECT SUM(amount) as total_amount FROM tblpaidlog";
+                }else{
+                        $sql = "SELECT SUM(amount) as total_amount FROM tblpaidlog WHERE paid_type = ".$data['paid_type'];
+                }
+                $r = $this->db->query($sql)->row_array();
+                $total_amount = (int)$r['total_amount'];
         $sql = "SELECT * FROM " . $this->table_name. " INNER JOIN tbluser ON tbluser.us_id = tblpaidlog.us_id ";
                 if ($data['paid_type'] == 1){
@@ -47 +54 @@
         }
         $sql=$sql . " " . $order . " LIMIT " . $data['start'] . ", " . $data['perpage'] . " ";
-        return $this->db->query($sql)->result_array();
+        //return $this->db->query($sql)->result_array();
+                $re = $this->db->query($sql)->result_array();
+                $result['paid_logs'] = $re;
+                $result['total_amount'] = $total_amount;
+                return $result;
     }