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

Timestamp:

Nov 14, 2014 6:01:48 AM (11 years ago)

Author:

dungnv

Message:

 

File:

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

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

@@ -8 +8 @@
         const TOKENPW = 'violet';
         
-        function __construct(){
+        function __construct()
+        {
         parent::__construct();
                 $this->vservices->setApiUrl($this->config->item('api_url'));
@@ -19 +20 @@
         return $this->db->query($sql)->result_array();
     }
+    
     function getPackage($p_id)
     {
@@ -24 +26 @@
         return $this->db->query($sql)->row_array();
     }
+    
+    function getPackagePriceByCode ($p_code) 
+    {
+        $sql='SELECT p_price FROM '. $this->table_name .' WHERE p_code = ?';
+        $query =  $this->db->query($sql , array($p_code));
+        $row = $query->row_array();
+        return $row['p_price'];
+    }
+    
+    function getPackageByCode ($p_code)
+    {
+        $sql='SELECT * FROM '. $this->table_name .' WHERE p_code = ?';
+        $query =  $this->db->query($sql , array($p_code));
+        $row = $query->row_array();
+        return $row;
+    }
         
 }