Context Navigation

source: pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php @ 501

Last change on this file since 501 was 499, checked in by dungnv, 11 years ago

File size: 10.8 KB

Rev	Line
[447]	1	<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
[310]	2
	3	class User_model extends CI_Model
	4	{
	5
[447]	6	const TOKENPW = 'violet';
	7
[499]	8	public function __construct(){
[310]	9	parent::__construct();
[314]	10	$this->vservices->setApiUrl($this->config->item('api_url'));
	11	$this->vservices->setConnection($this->curl);
[310]	12	}
	13
[499]	14	public function checkLogin ($src, $token, $username, $password)
[310]	15	{
[472]	16	$data = $this->vservices->actionExecute('login', array('src' => $src, 'token' => $token, 'username' => $username, 'password' => $password), 'user');
[499]	17
[326]	18	$arr_users = explode("&", $data);
[472]	19	$str_status = '';
	20	$str_fullname = '';
	21	$str_usid = '';
	22	$usid = '';
	23	$fullname = '';
[499]	24
[472]	25	for ($i=0; $i < count($arr_users); $i++)
[326]	26	{
	27	if (strpos($arr_users[$i], 'status=') !== false)
	28	{
	29	$str_status = $arr_users[$i];
	30	}
	31
	32	if (strpos($arr_users[$i], 'fullname=') !== false)
	33	{
	34	$str_fullname = $arr_users[$i];
	35	}
	36
[393]	37	if (strpos($arr_users[$i], 'id=') !== false)
[326]	38	{
	39	$str_usid = $arr_users[$i];
	40	}
	41	}
	42	$arr_status = explode("=", $str_status);
[472]	43	if ($str_fullname != '')
[326]	44	{
	45	$arr_fullname = explode("=", $str_fullname);
	46	$fullname = $arr_fullname[1];
	47	}
[472]	48	if ($str_usid !== '')
[326]	49	{
	50	$arr_usid = explode("=", $str_usid);
	51	$usid = $arr_usid[1];
	52	}
	53	$status = (int)$arr_status[1];
[472]	54
	55	if ($status == 0 \|\| $status == 4){
[326]	56	$us_id = (int)$usid;
	57	$query = "SELECT * FROM tbluser WHERE us_id = ?";
	58	$result = $this->db->query($query, array($us_id));
	59	if($result->num_rows() == 1){
	60	return $data;
	61	}else
	62	{
	63	return null;
	64	}
	65	}else
	66	{
	67	return $data;
	68	}
[438]	69	}
	70
[499]	71	public function register ($username, $collaborator, &$status='')
[447]	72	{
	73	$user = array();
	74	$password = $this->create_random_password();
	75	$src = 'SBG';
[492]	76	$sms = '';
	77	$id = 0;
	78	$errMsg = '';
[460]	79	$token = md5($username.self::TOKENPW);
[447]	80	$phone = $username;
[499]	81
[496]	82	if (!is_null($collaborator) \|\| $collaborator != ''){
[499]	83	if(!$this->isExistcollaborator($collaborator)){
[498]	84	$sms = "Khong tim thay cong tac vien nao co so dien thoai [".$collaborator."] tren soanbaigiang.smas.vn!";
[492]	85	$status = 0;
[499]	86	return $status.'\|'.$sms;
[492]	87	}
[499]	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)
[447]	93	{
[499]	94	case 0:
	95	$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;
	101	}
	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.";
	105	$status = 1;
	106	break;
	107	case 2:
	108	case 4:
	109	$sms = "So dien thoai cua Qui vi da duoc dang ky!";
	110	$status = 0;
	111	break;
	112	default:
	113	$status = 0;
	114	$sms = $errMsg;
	115	break;
[447]	116	}
[460]	117
	118	return $status.'\|'.$sms;
[310]	119	}
[447]	120
[499]	121	public function create_random_password()
[447]	122	{
[499]	123	//$alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789";
	124	$alphabet = "0123456789";
[447]	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	}
[454]	133
[499]	134	public function get_user_by_id($us_id)
[454]	135	{
[499]	136	$this->db->query('UNLOCK TABLES');
[454]	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();
	142	return $row;
	143	}
	144	}
[466]	145
[499]	146	public function get_user_info($src, $token, $us_id)
[466]	147	{
	148	$data = $this->vservices->actionExecute('getinfo', array('src' => $src, 'us_id' => $us_id, 'token'=>$token), 'user');
	149	return $data;
	150	}
	151
[499]	152	public function update_user($src, $token, $user, $us_id)
[466]	153	{
	154	$data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id,
	155	'password'=>$user['password'], 'fullname'=>$user['fullname'], 'gender'=>$user['gender'],
	156	'email'=>$user['email'], 'school'=>$user['school'], 'province'=>$user['province'], 'oldpass'=>$user['oldpass']),
	157	'user');
	158	return $data;
	159
	160	}
	161
[499]	162	public function changeProfile($sentNumber, $username, $password, &$status='')
[466]	163	{
	164	$user = array();
	165	$src = 'SBG';
	166	$errMsg = '';
[472]	167	$sms = '';
[486]	168	$result = $this->get_user_by_cellphone($username);
	169	if($result)
[466]	170	{
[486]	171	$us_id = $result['us_id'];
[466]	172	$token = md5($us_id.self::TOKENPW);
[469]	173	$data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id, 'username'=>$sentNumber, "password"=>$password, 'oldpass'=>$password, 'phone'=>$sentNumber), 'user');
[466]	174	parse_str($data);
	175	switch((int)$status)
	176	{
	177	case 0:
	178	$us_id = $id;
[486]	179	$user['updated_time'] = date('Y-m-d H:i:s');
[466]	180	$user['us_id'] = $us_id;
	181	$user['cellphone'] = $sentNumber;
[486]	182	$this->updateUser($us_id, $user);
[466]	183	$sms = "Qui vi da doi so dien thoai tren soanbaigiang.smas.vn sang so dien thoai [".$sentNumber."]";
	184	$status = 1;
	185	break;
	186	case 5:
[499]	187	$sms = "So dien thoai cá»§a Qui vi chua duoc dang ky!";
[466]	188	$status = 0;
	189	break;
	190	case 6:
	191	$sms = "Mat khau cua qui vi khong dung !";
	192	$status = 0;
	193	break;
	194	default:
	195	$status = 0;
	196	$sms = $errMsg;
	197	break;
	198	}
	199	}else
	200	{
[499]	201	$sms = "So dien thoai cá»§a Qui vi chua duoc dang ky!";
[466]	202	$status = 0;
	203	}
	204	return $status.'\|'.$sms;
	205	}
	206
[499]	207	public function changePassword($username, $password, &$status = '')
[466]	208	{
	209	$user = array();
	210	$src = 'SBG';
	211	$errMsg = '';
[472]	212	$sms = '';
[486]	213	$isForgotPassword = false;
[466]	214	$pass = $password;
[472]	215	if (is_null($password) \|\| $password == '')
[466]	216	{
	217	$pass = $this->create_random_password();
[486]	218	$$isForgotPassword = true;
[466]	219	}
[486]	220	$result = $this->get_user_by_cellphone($username);
	221	if($result)
[466]	222	{
[486]	223	$us_id = $result['us_id'];
[466]	224	$token = md5($us_id.self::TOKENPW);
	225	$data = $this->vservices->actionExecute('update', array('src'=>$src, 'token'=>$token, 'us_id'=>$us_id, "password"=>$pass), 'user');
	226	parse_str($data);
	227	switch((int)$status)
	228	{
	229	case 0:
	230	$us_id = $id;
[486]	231	$user['updated_time'] = date('Y-m-d H:i:s');
	232	$this->updateUser($us_id, $user);
	233	if ($isForgotPassword)
[466]	234	{
[497]	235	$sms = "Mat khau moi cua quy vi tren soanbaigiang.smas.vn la [".$pass."]";
[466]	236	}else{
[499]	237	$sms = "Qui vi da doi thanh cong mat khau tren soanbaigiang.smas.vn.";
[466]	238	}
	239	$status = 1;
	240	break;
	241	case 5:
[499]	242	$sms = "So dien thoai cá»§a Qui vi chua duoc dang ky!";
[466]	243	$status = 0;
	244	break;
	245	default:
	246	$status = 0;
	247	$sms = $errMsg;
	248	break;
	249	}
	250	}
	251	else
	252	{
[499]	253	$sms = "So dien thoai cá»§a Qui vi da duoc dang ky!";
[466]	254	$status = 0;
	255	}
	256	return $status.'\|'.$sms;
	257	}
	258
[472]	259
[499]	260	public function checkLicense ($userId)
[472]	261	{
	262	$isNotExpired = false;
[499]	263	$userInfo = array();
	264	$userInfo = $this->get_user_by_id($userId);
	265
[472]	266	$expireDate = $userInfo['expire_date'];
	267
	268	if ((trim($expireDate) == '')) return $isNotExpired;
	269
	270	$today = mktime();
	271	$expireTime = strtotime($expireDate.' 23:59:59');
	272	$isNotExpired = ($today < $expireTime);
	273	return $isNotExpired;
	274	}
	275
[499]	276	public function registerVip($username, $p_code)
[466]	277	{
[486]	278	$user = array();
	279	$sms = '';
[499]	280
[486]	281	$result = $this->get_user_by_cellphone($username);
[499]	282	$package = $this->get_package((int)$p_code);
[486]	283	if($result){
[499]	284
	285	if ($result['acc_balanced'] >= $package['p_price'])
[486]	286	{
	287	$us_id = $result['us_id'];
[499]	288	$user['acc_balanced'] = $result['acc_balanced'] - $package['p_price'];
[486]	289	if ($this->checkLicense($us_id)){
[492]	290	$user['expire_date'] = date('Y-m-d', strtotime($result['expire_date'].' + '.$package['p_period'].' month'));
[486]	291	}else
	292	{
[492]	293	$user['expire_date'] = date('Y-m-d', strtotime('now + '.$package['p_period'].' month'));
[486]	294	}
[499]	295
	296	$user['p_id'] = $package['p_id'];
[486]	297	$user['updated_time'] = date('Y-m-d H:i:s');
[499]	298
[486]	299	$this->updateUser($us_id, $user);
	300	$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']));
	301	$status = 1;
	302	}else
	303	{
	304	$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!";
	305	$status = 0;
	306	}
	307
	308	}else{
	309	$sms = "Tai khoan [".$username."] chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn.";
	310	$status = 0;
	311	}
	312	return $status.'\|'.$sms;
	313	}
	314
[499]	315	public function rechargeAccount($username, $amount)
[486]	316	{
	317	$user = array();
	318	$sms = '';
	319	$result = $this->get_user_by_cellphone($username);
	320	if($result)
	321	{
	322	$us_id = $result['us_id'];
	323	$user['acc_balanced'] = $result['acc_balanced'] + $amount;
	324	$user['updated_time'] = date('Y-m-d H:i:s');
	325	$this->updateUser($us_id, $user);
[499]	326	$sms = "Qui vi da nap thanh cong ".$amount."VND vao tai khoan ".$username." tren soanbaigiang.smas.vn";
[486]	327	$status = 1;
	328	}else
	329	{
[499]	330	$sms = "Tai khoan ".$username." chua dang ki tai khoan tren he thong SBG Online soanbaigiang.smas.vn.";
[486]	331	$status = 0;
	332	}
[492]	333	return $status.'\|'.$sms;
[486]	334	}
	335
[499]	336	public function get_user_by_cellphone($cellphone)
[486]	337	{
[499]	338	$this->db->query('UNLOCK TABLES');
	339	$sql = 'SELECT * FROM tbluser where cellphone = ? LIMIT 0,1';
	340	$query = $this->db->query($sql, array($cellphone));
	341	$row = $query->row_array();
	342	return $row;
[486]	343	}
	344
[499]	345	public function isExistcollaborator($collaborator)
[492]	346	{
[499]	347	$this->db->query('UNLOCK TABLES');
[496]	348	$this->db->select('*')->from('tblcollaborator')->where('login_name', $collaborator)->limit(1);
[492]	349	$result = $this->db->get()->row_array();
	350	if ($result) return true; else return false;
	351	}
	352
[499]	353	public function updateUser($us_id, $data)
[486]	354	{
[499]	355	$this->db->query('UNLOCK TABLES');
[486]	356	$this->db->where('us_id', $us_id);
	357	$this->db->update('tbluser', $data);
	358	}
	359
[499]	360	public function get_package($p_code)
[492]	361	{
[499]	362	$this->db->query('UNLOCK TABLES');
	363	$sql = 'SELECT * FROM tblservicepackage where p_code = ? LIMIT 0,1';
	364	$query = $this->db->query($sql, array($p_code));
	365	$row = $query->row_array();
	366	return $row;
[492]	367	}
	368
[499]	369	public function insertSmslog($sentNumber, $serviceID, $commandcode, $info, $receiveTime)
[486]	370	{
[499]	371	if (preg_match('/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch) == 1) {
	372	$sentNumber = '0'. $aryMatch[2];
	373	}
	374
	375	try {
	376	$user = $this->get_user_by_cellphone($sentNumber);
	377	}
	378	catch(Exception $e) {
	379
	380	}
	381
[466]	382	$smslog = array();
	383	$smslog['sender'] = $sentNumber;
[499]	384	$smslog['us_id'] = isset($user['us_id']) ? $user['us_id']:NULL;
[466]	385	$smslog['service_id'] = $serviceID;
	386	$smslog['commandcode'] = $commandcode;
	387	$smslog['info'] = $info;
	388	$smslog['created_time'] = $receiveTime;
[499]	389	$this->db->query('UNLOCK TABLES');
	390	$sql = 'INSERT INTO tblsmslog(sender, us_id, service_id, commandcode, info, created_time) VALUES(?,?,?,?,?,?)';
	391	$query = $this->db->query($sql, $smslog);
	392	//$this->db->insert('tblsmslog', $smslog);
[466]	393	}
	394	}

Note: See TracBrowser for help on using the repository browser.

Download in other formats: