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

Timestamp:

Nov 19, 2014 2:08:05 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

@@ -482 +482 @@
         }
         
-        public function getPaidlog($us_id)
+        public function getPaidlog($data)
         {
-                $this->db->query ( 'UNLOCK TABLES' );
-                $sql = 'SELECT * FROM tblpaidlog where us_id = ?';
+                $us_id = $data['us_id'];
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql = "SELECT * FROM tblpaidlog where us_id = ? ORDER BY paid_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
                 $query = $this->db->query ( $sql, array (
                                 $us_id
@@ -492 +493 @@
                 return $row;
         }
+        
+        public function countPaiglogs($us_id)
+        {
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql="SELECT COUNT(paid_id) AS total FROM tblpaidlog WHERE us_id = ?";
+                $query = $this->db->query ( $sql, array (
+                                $us_id
+                ) );
+                $result = $query->row_array();
+                return $result['total'];
+        }
 }