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

Timestamp:

Nov 14, 2014 6:18:06 AM (11 years ago)

Author:

dungnv

Message:

 

File:

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

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

@@ -17 +17 @@
     function getAllPackages()
     {
+        $this->db->query('UNLOCK TABLES');
         $sql="SELECT * FROM ".$this->table_name."";
         return $this->db->query($sql)->result_array();
@@ -23 +24 @@
     function getPackage($p_id)
     {
+        $this->db->query('UNLOCK TABLES');
         $sql="SELECT * FROM ".$this->table_name." WHERE ".$this->id_name."=".$p_id;
         return $this->db->query($sql)->row_array();
@@ -29 +31 @@
     function getPackagePriceByCode ($p_code) 
     {
+        $this->db->query('UNLOCK TABLES');
         $sql='SELECT p_price FROM '. $this->table_name .' WHERE p_code = ?';
         $query =  $this->db->query($sql , array($p_code));
@@ -37 +40 @@
     function getPackageByCode ($p_code)
     {
+        $this->db->query('UNLOCK TABLES');
         $sql='SELECT * FROM '. $this->table_name .' WHERE p_code = ?';
         $query =  $this->db->query($sql , array($p_code));