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

Timestamp:

Mar 27, 2015 9:49:55 AM (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

@@ -173 +173 @@
                 ), 'user' );
                 $u = array('province'=>$user['province'],
+                                'district' => $user['district'],
                                 'updated_time'=>date('Y-m-d H:i:s')
                                 );
@@ -617 +618 @@
         }
         
+        public function getDistrictByProvince($provinceId){
+                $sql = "SELECT * FROM tbldistrict WHERE province_id = ?";
+                $query = $this->db->query ( $sql, array (
+                                $provinceId
+                ) );
+                $results = $query->result_array();
+                return $results;
+        }
+        
+        public function insertDistrict($data){
+                $this->db->insert_batch('tbldistrict', $data);
+                return $this->db->affected_rows();
+        }
+        
+        public function getDistrictByIdAndProvince($districtId, $provinceId){
+                $sql = "SELECT * FROM tbldistrict WHERE district_id = ? AND province_id = ?";
+                $query = $this->db->query ( $sql,array ($districtId, $provinceId) );
+                if ($query->num_rows () > 0) {
+                        $row = $query->row_array ();
+                        return $row;
+                }
+        }
+        
 }