Changeset 644 for pro-violet-viettel/sourcecode/application/modules/frontend

Timestamp:

Dec 4, 2014 3:10:46 PM (10 years ago)

Author:

namnd

Message:

 

Location:

pro-violet-viettel/sourcecode/application/modules/frontend

Files:

• controllers/user.php (modified) (1 diff)
• models/user_model.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/frontend/controllers/user.php

@@ -387 +387 @@
                         $packagelogs = array();
                         foreach ($result as $packagelog):
-                                $packagelog['vip_name'] = 'VIP '.$packagelog['p_code'];
                                 $packagelog['created_time'] = date('d/m/Y H:i:s', strtotime($packagelog['created_time']));
                                 array_push($packagelogs, $packagelog);

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

@@ -534 +534 @@
                 $username = $data['username'];
                 $this->db->query ( 'UNLOCK TABLES' );
-                $sql = "SELECT * FROM tblregisterpackagelog where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
+                $sql = "SELECT * FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
                 $query = $this->db->query ( $sql, array (
                                 $username