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

Timestamp:

Dec 4, 2014 12:17:30 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

@@ -517 +517 @@
         }
         
-        public function insertRegisterVipLog($source, $p_code)
+        public function insertRegisterVipLog($username, $source, $p_code)
         {
                 $createdTime = date('Y-m-d H:i:s');
-                $sql = 'INSERT INTO tblregisterpackagelog (source, p_code, created_time) VALUES (?,?,?)';
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql = 'INSERT INTO tblregisterpackagelog (username, source, p_code, created_time) VALUES (?,?,?,?)';
                 $query = $this->db->query ( $sql,  array (
+                                'username'=>$username,
                                 'source'=>$source,
                                 'p_code'=>$p_code,
@@ -527 +529 @@
                 ) );
         }
+        
+        public function getPackagelog($data)
+        {
+                $username = $data['username'];
+                $this->db->query ( 'UNLOCK TABLES' );
+                $sql = "SELECT * FROM tblregisterpackagelog where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
+                $query = $this->db->query ( $sql, array (
+                                $username
+                ) );
+                $row = $query->result_array();
+                return $row;
+        }
+        
+        public function countPackagelogs($username)
+        {
+                $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();
+                return $result['total'];
+        }
 }