![(please configure the [header_logo] section in trac.ini)](/space/chrome/site/your_project_logo.png){kind=logo}
- Timestamp:
- Nov 14, 2014 7:03:33 PM (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php
r510 r517 1 <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');1 <?php 2 2 3 class User_model extends CI_Model 4 { 5 3 if (! defined ( 'BASEPATH' )) 4 exit ( 'No direct script access allowed' ); 5 6 class User_model extends CI_Model { 6 7 const TOKENPW = 'violet'; 7 8 8 public function __construct(){ 9 parent::__construct(); 10 $this->vservices->setApiUrl($this->config->item('api_url')); 11 $this->vservices->setConnection($this->curl); 12 } 13 14 public function checkLogin ($src, $token, $username, $password) 15 { 16 $data = $this->vservices->actionExecute('login', array('src' => $src, 'token' => $token, 'username' => $username, 'password' => $password), 'user'); 17 18 $arr_users = explode("&", $data); 9 public function __construct() { 10 parent::__construct (); 11 $this->vservices->setApiUrl ( $this->config->item ( 'api_url' ) ); 12 $this->vservices->setConnection ( $this->curl ); 13 } 14 15 public function checkLogin($src, $token, $username, $password) { 16 $data = $this->vservices->actionExecute ( 'login', array ( 17 'src' => $src, 18 'token' => $token, 19 'username' => $username, 20 'password' => $password 21 ), 'user' ); 22 23 $arr_users = explode ( "&", $data ); 19 24 $str_status = ''; 20 25 $str_fullname = ''; … … 23 28 $fullname = ''; 24 29 25 for ($i=0; $i < count($arr_users); $i++) 26 { 27 if (strpos($arr_users[$i], 'status=') !== false) 28 { 29 $str_status = $arr_users[$i]; 30 for($i = 0; $i < count ( $arr_users ); $i ++) { 31 if (strpos ( $arr_users [$i], 'status=' ) !== false) { 32 $str_status = $arr_users [$i]; 30 33 } 31 34 32 if (strpos($arr_users[$i], 'fullname=') !== false) 33 { 34 $str_fullname = $arr_users[$i]; 35 if (strpos ( $arr_users [$i], 'fullname=' ) !== false) { 36 $str_fullname = $arr_users [$i]; 35 37 } 36 38 37 if (strpos($arr_users[$i], 'id=') !== false) 38 { 39 $str_usid = $arr_users[$i]; 40 } 41 } 42 $arr_status = explode("=", $str_status); 43 if ($str_fullname != '') 44 { 45 $arr_fullname = explode("=", $str_fullname); 46 $fullname = $arr_fullname[1]; 47 } 48 if ($str_usid !== '') 49 { 50 $arr_usid = explode("=", $str_usid); 51 $usid = $arr_usid[1]; 52 } 53 $status = (int)$arr_status[1]; 54 55 if ($status == 0 || $status == 4){ 56 $us_id = (int)$usid; 39 if (strpos ( $arr_users [$i], 'id=' ) !== false) { 40 $str_usid = $arr_users [$i]; 41 } 42 } 43 $arr_status = explode ( "=", $str_status ); 44 if ($str_fullname != '') { 45 $arr_fullname = explode ( "=", $str_fullname ); 46 $fullname = $arr_fullname [1]; 47 } 48 if ($str_usid !== '') { 49 $arr_usid = explode ( "=", $str_usid ); 50 $usid = $arr_usid [1]; 51 } 52 $status = ( int ) $arr_status [1]; 53 54 if ($status == 0 || $status == 4) { 55 $us_id = ( int ) $usid; 57 56 $query = "SELECT * FROM tbluser WHERE us_id = ?"; 58 $result = $this->db->query($query, array($us_id)); 59 if($result->num_rows() == 1){ 57 $result = $this->db->query ( $query, array ( 58 $us_id 59 ) ); 60 if ($result->num_rows () == 1) { 60 61 return $data; 61 }else 62 { 62 } else { 63 63 return null; 64 64 } 65 }else 66 { 65 } else { 67 66 return $data; 68 67 } 69 68 } 70 71 public function register ($username, $collaborator, &$status='') 72 { 73 $user = array(); 74 $password = $this->create_random_password(); 69 70 public function register($username, $collaborator, &$status = '') { 71 $user = array (); 72 $password = $this->create_random_password (); 75 73 $src = 'SBG'; 76 74 $sms = ''; 77 75 $id = 0; 78 76 $errMsg = ''; 79 $token = md5 ($username.self::TOKENPW);77 $token = md5 ( $username . self::TOKENPW ); 80 78 $phone = $username; 81 79 82 if (! is_null($collaborator) || $collaborator != ''){83 if (!$this->isExistcollaborator($collaborator)){84 $sms = "Khong tim thay cong tac vien nao co so dien thoai [" .$collaborator."] tren soanbaigiang.smas.vn!";80 if (! is_null ( $collaborator ) || $collaborator != '') { 81 if (! $this->isExistcollaborator ( $collaborator )) { 82 $sms = "Khong tim thay cong tac vien nao co so dien thoai [" . $collaborator . "] tren soanbaigiang.smas.vn!"; 85 83 $status = 0; 86 return $status.'|'.$sms; 87 } 88 } 89 90 $data = $this->vservices->actionExecute('update', array('src'=>$src, 'username'=>$username, 'password'=>$password, 'fullname'=>null, 'phone'=>$username, 'token'=>$token), 'user'); 91 parse_str($data); 92 switch((int)$status) 93 { 94 case 0: 84 return $status . '|' . $sms; 85 } 86 } 87 88 $data = $this->vservices->actionExecute ( 'update', array ( 89 'src' => $src, 90 'username' => $username, 91 'password' => $password, 92 'fullname' => null, 93 'phone' => $username, 94 'token' => $token 95 ), 'user' ); 96 97 parse_str ( $data ); 98 99 switch (( int ) $status) { 100 case 0 : 95 101 $us_id = $id; 96 $user ['created_time'] = date('Y-m-d H:i:s');97 $user ['us_id'] = $us_id;98 $user ['cellphone'] = $username;99 if (! is_null($collaborator) || $collaborator != ''){100 $user ['collaborator'] = $collaborator;102 $user ['created_time'] = date ( 'Y-m-d H:i:s' ); 103 $user ['us_id'] = $us_id; 104 $user ['cellphone'] = $username; 105 if (! is_null ( $collaborator ) || $collaborator != '') { 106 $user ['collaborator'] = $collaborator; 101 107 } 102 $this->db->query ('UNLOCK TABLES');103 $this->db->insert ('tbluser', $user);104 $sms = "Chuc mung Qui vi da dang ky thanh cong tai khoan Soan Bai giang Online. Hay dang nhap vao soanbaigiang.smas.vn voi ten truy nhap " .$username.", mat khau ".$password." de su dung.";108 $this->db->query ( 'UNLOCK TABLES' ); 109 $this->db->insert ( 'tbluser', $user ); 110 $sms = "Chuc mung Qui vi da dang ky thanh cong tai khoan Soan Bai giang Online. Hay dang nhap vao soanbaigiang.smas.vn voi ten truy nhap " . $username . ", mat khau " . $password . " de su dung."; 105 111 $status = 1; 106 112 break; 107 case 2 :108 case 4 :113 case 2 : 114 case 4 : 109 115 $sms = "So dien thoai cua Qui vi da duoc dang ky!"; 110 116 $status = 0; 111 117 break; 112 default :118 default : 113 119 $status = 0; 114 120 $sms = $errMsg; … … 116 122 } 117 123 118 return $status.'|'.$sms; 119 } 120 121 public function create_random_password() 122 { 123 //$alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789"; 124 return $status . '|' . $sms; 125 } 126 127 public function create_random_password() { 128 // $alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789"; 124 129 $alphabet = "0123456789"; 125 $pass = array(); 126 $alphaLength = strlen($alphabet) - 1; 127 for ($i = 0; $i < 6; $i++) { 128 $n = rand(0, $alphaLength); 129 $pass[] = $alphabet[$n]; 130 } 131 return implode($pass); 132 } 133 134 public function get_user_by_id($us_id) 135 { 136 $this->db->query('UNLOCK TABLES'); 137 $this->db->select('*')->from('tbluser')->where('us_id', $us_id); 138 $query = $this->db->get(); 139 if($query->num_rows() > 0) 140 { 141 $row = $query->row_array(); 130 $pass = array (); 131 $alphaLength = strlen ( $alphabet ) - 1; 132 for($i = 0; $i < 6; $i ++) { 133 $n = rand ( 0, $alphaLength ); 134 $pass [] = $alphabet [$n]; 135 } 136 return implode ( $pass ); 137 } 138 139 public function get_user_by_id($us_id) { 140 $this->db->query ( 'UNLOCK TABLES' ); 141 $this->db->select ( '*' )->from ( 'tbluser' )->where ( 'us_id', $us_id ); 142 $query = $this->db->get (); 143 if ($query->num_rows () > 0) { 144 $row = $query->row_array (); 142 145 return $row; 143 146 } 144 147 } 145 148 146 public function get_user_info($src, $token, $us_id) 147 { 148 $data = $this->vservices->actionExecute('getinfo', array('src' => $src, 'us_id' => $us_id, 'token'=>$token), 'user'); 149 return $data; 150 } 151 152 public function update_user($src, $token, $user, $us_id) 153 { 154 $data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id, 155 'password'=>$user['password'], 'fullname'=>$user['fullname'], 156 'school'=>$user['school'], 'province'=>$user['province'], 'oldpass'=>$user['oldpass']), 157 'user'); 149 public function get_user_info($src, $token, $us_id) { 150 $data = $this->vservices->actionExecute ( 'getinfo', array ( 151 'src' => $src, 152 'us_id' => $us_id, 153 'token' => $token 154 ), 'user' ); 158 155 return $data; 159 160 } 161 162 public function changeProfile($sentNumber, $username, $password, &$status='') 163 { 164 $user = array(); 156 } 157 158 public function update_user($src, $token, $user, $us_id) { 159 $data = $this->vservices->actionExecute ( 'update', array ( 160 'src' => $src, 161 'token' => $token, 162 'us_id' => $us_id, 163 'password' => $user ['password'], 164 'fullname' => $user ['fullname'], 165 'school' => $user ['school'], 166 'province' => $user ['province'], 167 'oldpass' => $user ['oldpass'] 168 ), 'user' ); 169 return $data; 170 } 171 172 public function changeProfile($sentNumber, $username, $password, &$status = '') { 173 $user = array (); 165 174 $src = 'SBG'; 166 175 $errMsg = ''; 167 176 $sms = ''; 168 $checkSentNumber = $this->get_user_by_cellphone ($sentNumber);169 if($checkSentNumber)170 {171 $sms = "So Dien thoai " .$sentNumber." da dang ky tren he thong SBG Online soanbaigiang.smas.vn nen Qui vi khong the doi sang so dien thoai nay duoc.";177 $checkSentNumber = $this->get_user_by_cellphone ( $sentNumber ); 178 179 if ($checkSentNumber) { 180 $sms = "So Dien thoai " . $sentNumber . " da dang ky tren he thong SBG Online soanbaigiang.smas.vn nen Qui vi khong the doi sang so dien thoai nay duoc."; 172 181 $status = 0; 173 return $status.'|'.$sms; 174 } 175 $result = $this->get_user_by_cellphone($username); 176 if($result) 177 { 178 $us_id = $result['us_id']; 179 $token = md5($us_id.self::TOKENPW); 180 $data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id, 'username'=>$sentNumber, "password"=>$password, 'oldpass'=>$password, 'phone'=>$sentNumber), 'user'); 181 parse_str($data); 182 switch((int)$status) 183 { 184 case 0: 182 return $status . '|' . $sms; 183 } 184 185 $result = $this->get_user_by_cellphone ( $username ); 186 187 if ($result) { 188 $us_id = $result ['us_id']; 189 $token = md5 ( $us_id . self::TOKENPW ); 190 $data = $this->vservices->actionExecute ( 'update', array ( 191 'src' => $src, 192 'token' => $token, 193 'us_id' => $us_id, 194 'username' => $sentNumber, 195 "password" => $password, 196 'oldpass' => $password, 197 'phone' => $sentNumber 198 ), 'user' ); 199 parse_str ( $data ); 200 switch (( int ) $status) { 201 case 0 : 185 202 $us_id = $id; 186 $user ['updated_time'] = date('Y-m-d H:i:s');187 $user ['us_id'] = $us_id;188 $user ['cellphone'] = $sentNumber;189 $this->updateUser ($us_id, $user);190 $sms = "Qui vi da doi so dien thoai tren soanbaigiang.smas.vn sang so dien thoai [".$sentNumber."]";203 $user ['updated_time'] = date ( 'Y-m-d H:i:s' ); 204 $user ['us_id'] = $us_id; 205 $user ['cellphone'] = $sentNumber; 206 $this->updateUser ( $us_id, $user ); 207 $sms = "Qui vi da doi so dien thoai tren soanbaigiang.smas.vn sang so dien thoai " . $sentNumber; 191 208 $status = 1; 192 209 break; 193 case 5 :210 case 5 : 194 211 $sms = "So dien thoai của Qui vi chua duoc dang ky!"; 195 212 $status = 0; 196 213 break; 197 case 6 :214 case 6 : 198 215 $sms = "Mat khau cua qui vi khong dung !"; 199 216 $status = 0; 200 217 break; 201 default :218 default : 202 219 $status = 0; 203 220 $sms = $errMsg; 204 break; 205 } 206 }else 207 { 221 break; 222 } 223 } else { 208 224 $sms = "So dien thoai của Qui vi chua duoc dang ky!"; 209 225 $status = 0; 210 226 } 211 return $status.'|'.$sms; 212 } 213 214 public function changePassword($username, $password, &$status = '') 215 { 216 $user = array(); 227 return $status . '|' . $sms; 228 } 229 230 public function changePassword($username, $password, &$status = '') { 231 $user = array (); 217 232 $src = 'SBG'; 218 233 $errMsg = ''; … … 220 235 $isForgotPassword = false; 221 236 $pass = $password; 222 if (is_null($password) || $password == '')223 {224 $pass = $this->create_random_password ();237 238 if (is_null ( $password ) || $password == '') { 239 $pass = $this->create_random_password (); 225 240 $isForgotPassword = true; 226 241 } 227 $result = $this->get_user_by_cellphone($username); 228 if($result) 229 { 230 $us_id = $result['us_id']; 231 $token = md5($us_id.self::TOKENPW); 232 $data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id, "password"=>$pass), 'user'); 233 parse_str($data); 234 switch((int)$status) 235 { 236 case 0: 242 243 $result = $this->get_user_by_cellphone ( $username ); 244 if ($result) { 245 $us_id = $result ['us_id']; 246 $token = md5 ( $us_id . self::TOKENPW ); 247 $data = $this->vservices->actionExecute ( 'update', array ( 248 'src' => $src, 249 'token' => $token, 250 'us_id' => $us_id, 251 "password" => $pass 252 ), 'user' ); 253 parse_str ( $data ); 254 switch (( int ) $status) { 255 case 0 : 237 256 $us_id = $id; 238 $user['updated_time'] = date('Y-m-d H:i:s'); 239 $this->updateUser($us_id, $user); 240 if ($isForgotPassword) 241 { 242 $sms = "Mat khau moi cua quy vi tren soanbaigiang.smas.vn la [".$pass."]"; 243 }else{ 257 $user ['updated_time'] = date ( 'Y-m-d H:i:s' ); 258 $this->updateUser ( $us_id, $user ); 259 if ($isForgotPassword) { 260 $sms = "Mat khau moi cua quy vi tren soanbaigiang.smas.vn la " . $pass; 261 } else { 244 262 $sms = "Qui vi da doi thanh cong mat khau tren soanbaigiang.smas.vn."; 245 263 } 246 264 $status = 1; 247 265 break; 248 case 5 :266 case 5 : 249 267 $sms = "So dien thoai của Qui vi chua duoc dang ky!"; 250 268 $status = 0; 251 269 break; 252 default :270 default : 253 271 $status = 0; 254 272 $sms = $errMsg; 255 break; 256 } 257 } 258 else 259 { 273 break; 274 } 275 } else { 260 276 $sms = "So dien thoai của Qui vi da duoc dang ky!"; 261 277 $status = 0; 262 278 } 263 return $status.'|'.$sms; 264 } 265 266 267 public function checkLicense ($userId) 268 { 279 return $status . '|' . $sms; 280 } 281 282 public function checkLicense($userId) { 269 283 $isNotExpired = false; 270 $userInfo = array(); 271 $userInfo = $this->get_user_by_id($userId); 272 273 $expireDate = $userInfo['expire_date']; 274 275 if ((trim($expireDate) == '')) return $isNotExpired; 276 277 $today = mktime(); 278 $expireTime = strtotime($expireDate.' 23:59:59'); 284 $userInfo = array (); 285 $userInfo = $this->get_user_by_id ( $userId ); 286 287 $expireDate = $userInfo ['expire_date']; 288 289 if ((trim ( $expireDate ) == '')) 290 return $isNotExpired; 291 292 $today = mktime (); 293 $expireTime = strtotime ( $expireDate . ' 23:59:59' ); 279 294 $isNotExpired = ($today < $expireTime); 280 295 return $isNotExpired; 281 296 } 282 297 283 public function registerVip($username, $p_code) 284 { 285 $user = array(); 298 public function registerVip($username, $p_code) { 299 $user = array (); 286 300 $sms = ''; 287 301 288 $result = $this->get_user_by_cellphone ($username);289 $package = $this->get_package ((int)$p_code);290 if ($result){302 $result = $this->get_user_by_cellphone ( $username ); 303 $package = $this->get_package ( ( int ) $p_code ); 304 if ($result) { 291 305 292 if ($result['acc_balanced'] >= $package['p_price']) 293 { 294 $us_id = $result['us_id']; 295 $user['acc_balanced'] = $result['acc_balanced'] - $package['p_price']; 296 if ($this->checkLicense($us_id)){ 297 $user['expire_date'] = date('Y-m-d', strtotime($result['expire_date'].' + '.$package['p_period'].' month')); 298 }else 299 { 300 $user['expire_date'] = date('Y-m-d', strtotime('now + '.$package['p_period'].' month')); 306 if ($result ['acc_balanced'] >= $package ['p_price']) { 307 $us_id = $result ['us_id']; 308 $user ['acc_balanced'] = $result ['acc_balanced'] - $package ['p_price']; 309 if ($this->checkLicense ( $us_id )) { 310 $user ['expire_date'] = date ( 'Y-m-d', strtotime ( $result ['expire_date'] . ' + ' . $package ['p_period'] . ' month' ) ); 311 } else { 312 $user ['expire_date'] = date ( 'Y-m-d', strtotime ( 'now + ' . $package ['p_period'] . ' month' ) ); 301 313 } 302 314 303 $user ['p_id'] = $package['p_id'];304 $user ['updated_time'] = date('Y-m-d H:i:s');315 $user ['p_id'] = $package ['p_id']; 316 $user ['updated_time'] = date ( 'Y-m-d H:i:s' ); 305 317 306 $this->updateUser ($us_id, $user);307 $sms = "Chuc mung Qui vi da dang ky su dung Soan Bai giang truc tuyen tren soanbaigiang.smas.vn. Qui vi co the su dung dich vu den 24h00 ngay " .date('d/m/Y', strtotime($user['expire_date']));318 $this->updateUser ( $us_id, $user ); 319 $sms = "Chuc mung Qui vi da dang ky su dung Soan Bai giang truc tuyen tren soanbaigiang.smas.vn. Qui vi co the su dung dich vu den 24h00 ngay " . date ( 'd/m/Y', strtotime ( $user ['expire_date'] ) ); 308 320 $status = 1; 309 }else 310 { 321 } else { 311 322 $sms = "Tai khoan cua qui vi khong du de dang ky su dung dich vu Soan Bai giang truc tuyen tren soanbaigiang.smas.vn. Hay nap tien va dang ky lai. Cam on!"; 312 323 $status = 0; 313 324 } 314 315 }else{ 316 $sms = "Tai khoan [".$username."] chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn."; 325 } else { 326 $sms = "Tai khoan [" . $username . "] chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn."; 317 327 $status = 0; 318 328 } 319 return $status.'|'.$sms; 320 } 321 322 public function rechargeAccount($username, $amount) 323 { 324 $user = array(); 329 return $status . '|' . $sms; 330 } 331 332 public function rechargeAccount($username, $amount) { 333 $user = array (); 325 334 $sms = ''; 326 $result = $this->get_user_by_cellphone($username); 327 if($result) 328 { 329 $us_id = $result['us_id']; 330 $user['acc_balanced'] = $result['acc_balanced'] + $amount; 331 $user['updated_time'] = date('Y-m-d H:i:s'); 332 $this->updateUser($us_id, $user); 333 $sms = "Qui vi da nap thanh cong ".$amount."VND vao tai khoan ".$username." tren soanbaigiang.smas.vn"; 335 $result = $this->get_user_by_cellphone ( $username ); 336 if ($result) { 337 $us_id = $result ['us_id']; 338 $user ['acc_balanced'] = $result ['acc_balanced'] + $amount; 339 $user ['updated_time'] = date ( 'Y-m-d H:i:s' ); 340 $this->updateUser ( $us_id, $user ); 341 $sms = "Qui vi da nap thanh cong " . $amount . "VND vao tai khoan " . $username . " tren soanbaigiang.smas.vn"; 334 342 $status = 1; 335 }else 336 { 337 $sms = "Tai khoan ".$username." chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn."; 343 } else { 344 $sms = "Tai khoan " . $username . " chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn."; 338 345 $status = 0; 339 346 } 340 return $status.'|'.$sms; 341 } 342 343 public function get_user_by_cellphone($cellphone) 344 { 345 $this->db->query('UNLOCK TABLES'); 347 return $status . '|' . $sms; 348 } 349 350 public function get_user_by_cellphone($cellphone) { 351 $this->db->query ( 'UNLOCK TABLES' ); 346 352 $sql = 'SELECT * FROM tbluser where cellphone = ? LIMIT 0,1'; 347 $query = $this->db->query($sql, array($cellphone)); 348 $row = $query->row_array(); 353 $query = $this->db->query ( $sql, array ( 354 $cellphone 355 ) ); 356 $row = $query->row_array (); 349 357 return $row; 350 358 } 351 359 352 public function isExistcollaborator($collaborator) 353 {354 $this->db-> query('UNLOCK TABLES');355 $ this->db->select('*')->from('tblcollaborator')->where('login_name', $collaborator)->limit(1);356 $result = $this->db->get()->row_array();357 if ($result) return true; else return false;358 }359 360 public function updateUser($us_id, $data)361 {362 $this->db->query('UNLOCK TABLES');363 $this->db-> where('us_id', $us_id);364 $this->db-> update('tbluser', $data);365 }366 367 public function get_package($p_code)368 {369 $this->db->query ('UNLOCK TABLES');360 public function isExistcollaborator($collaborator) { 361 $this->db->query ( 'UNLOCK TABLES' ); 362 $this->db->select ( '*' )->from ( 'tblcollaborator' )->where ( 'login_name', $collaborator )->limit ( 1 ); 363 $result = $this->db->get ()->row_array (); 364 if ($result) 365 return true; 366 else 367 return false; 368 } 369 370 public function updateUser($us_id, $data) { 371 $this->db->query ( 'UNLOCK TABLES' ); 372 $this->db->where ( 'us_id', $us_id ); 373 $this->db->update ( 'tbluser', $data ); 374 } 375 376 public function get_package($p_code) { 377 $this->db->query ( 'UNLOCK TABLES' ); 370 378 $sql = 'SELECT * FROM tblservicepackage where p_code = ? LIMIT 0,1'; 371 $query = $this->db->query($sql, array($p_code)); 372 $row = $query->row_array(); 379 $query = $this->db->query ( $sql, array ( 380 $p_code 381 ) ); 382 $row = $query->row_array (); 373 383 return $row; 374 384 } 375 385 376 public function insertSmslog($sentNumber, $serviceID, $commandcode, $info, $receiveTime) 377 { 378 if (preg_match('/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch) == 1) { 379 $sentNumber = '0'. $aryMatch[2]; 386 public function insertSmslog($sentNumber, $serviceID, $commandcode, $info, $receiveTime) { 387 if (preg_match ( '/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch ) == 1) { 388 $sentNumber = '0' . $aryMatch [2]; 380 389 } 381 390 382 391 try { 383 $user = $this->get_user_by_cellphone($sentNumber); 384 } 385 catch(Exception $e) { 386 387 } 388 389 $smslog = array(); 390 $smslog['sender'] = $sentNumber; 391 $smslog['us_id'] = isset($user['us_id']) ? $user['us_id']:NULL; 392 $smslog['service_id'] = $serviceID; 393 $smslog['commandcode'] = $commandcode; 394 $smslog['info'] = $info; 395 $smslog['created_time'] = $receiveTime; 396 $this->db->query('UNLOCK TABLES'); 392 $user = $this->get_user_by_cellphone ( $sentNumber ); 393 } catch ( Exception $e ) { 394 } 395 396 $smslog = array (); 397 $smslog ['sender'] = $sentNumber; 398 $smslog ['us_id'] = isset ( $user ['us_id'] ) ? $user ['us_id'] : NULL; 399 $smslog ['service_id'] = $serviceID; 400 $smslog ['commandcode'] = $commandcode; 401 $smslog ['info'] = $info; 402 $smslog ['created_time'] = $receiveTime; 403 $this->db->query ( 'UNLOCK TABLES' ); 397 404 $sql = 'INSERT INTO tblsmslog(sender, us_id, service_id, commandcode, info, created_time) VALUES(?,?,?,?,?,?)'; 398 405 $query = $this->db->query($sql, $smslog); 399 //$this->db->insert('tblsmslog', $smslog); 400 } 401 402 public function insertPaidlog($sentNumber, $receiveID, $paidType, $amount, $paidTime) 403 { 404 if (preg_match('/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch) == 1) { 405 $sentNumber = '0'. $aryMatch[2]; 406 } 407 408 public function insertPaidlog($sentNumber, $receiveID, $paidType, $amount, $paidTime) { 409 if (preg_match ( '/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch ) == 1) { 410 $sentNumber = '0' . $aryMatch [2]; 406 411 } 407 412 408 413 try { 409 $user = $this->get_user_by_cellphone($sentNumber); 410 } 411 catch(Exception $e) { 412 413 } 414 $paidlog = array(); 415 $paidlog['us_id'] = isset($user['us_id']) ? $user['us_id']:NULL; 416 $paidlog['paidType'] = $paidType; 417 $paidlog['amount'] = $amount; 418 $paidlog['paidTime'] = $paidTime; 419 $this->db->query('UNLOCK TABLES'); 414 $user = $this->get_user_by_cellphone ( $sentNumber ); 415 } catch ( Exception $e ) { 416 } 417 $paidlog = array (); 418 $paidlog ['us_id'] = isset ( $user ['us_id'] ) ? $user ['us_id'] : NULL; 419 $paidlog ['paidType'] = $paidType; 420 $paidlog ['amount'] = $amount; 421 $paidlog ['paidTime'] = $paidTime; 422 $this->db->query ( 'UNLOCK TABLES' ); 420 423 $sql = 'INSERT INTO tblpaidlog(us_id, paidType, amount, paidTime) VALUES (?,?,?,?)'; 421 $query = $this->db->query ($sql, $paidog);424 $query = $this->db->query ( $sql, $paidog ); 422 425 } 423 426 }
Note: See TracChangeset
for help on using the changeset viewer.
