Changeset 883 for pro-violet-viettel/sourcecode/application/modules/frontend/models

Timestamp:

Apr 7, 2015 1:52:40 PM (10 years ago)

Author:

namnd

Message:

 

File:

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

pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php

@@ -576 +576 @@
                 $this->db->query ( 'UNLOCK TABLES' );
                 //$sql="SELECT tblregisterpackagelog.source,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']."";
-                $sql="SELECT tblregisterpackagelog.source,0 as amount,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,'Nạp tiền' as name,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']."";
+                $sql="SELECT tblregisterpackagelog.source,0 as amount,tblservicepackage.p_name,tblregisterpackagelog.created_time, tblregisterpackagelog.p_code FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,'Nạp tiền' as name,tblpaidlog.paid_time, 0 as p_code FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']."";
                 $query = $this->db->query ( $sql, array ("$username", $us_id) );
                 $row = $query->result_array();
@@ -582 +582 @@
         }
         
-        public function countPackagelogs($username)
+        public function countPackagelogs($username, $us_id)
         {
                 $this->db->query ( 'UNLOCK TABLES' );
                 $sql="SELECT COUNT(id) AS total FROM tblregisterpackagelog WHERE username = ?";
+                
                 $query = $this->db->query ( $sql, array (
                                 $username
                 ) );
                 $result = $query->row_array();
+                $total = $result['total'];
+                $sql="SELECT COUNT(paid_id) AS total FROM tblpaidlog WHERE us_id = ?";
+                $query = $this->db->query ( $sql, array (
+                                $us_id
+                ) );
+                $result = $query->row_array();
+                $total = $total + $result['total'];
+                $result['total'] = $total;
+                
                 return $result['total'];
         }