Context Navigation

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

Last change on this file since 642 was 642, checked in by namnd, 10 years ago

File size: 17.1 KB

Rev	Line
[517]	1	<?php
	2
	3	if (! defined ( 'BASEPATH' ))
	4	exit ( 'No direct script access allowed' );
	5
[561]	6	if ( ! defined('_SBG_PAIDTYPE_SMS')) define('_SBG_PAIDTYPE_SMS', 1);
	7	if ( ! defined('_SBG_PAIDTYPE_CARD')) define('_SBG_PAIDTYPE_CARD', 2);
	8
[517]	9	class User_model extends CI_Model {
	10	const TOKENPW = 'violet';
	11
	12	public function __construct() {
	13	parent::__construct ();
	14	$this->vservices->setApiUrl ( $this->config->item ( 'api_url' ) );
	15	$this->vservices->setConnection ( $this->curl );
[636]	16	$this->load->helper('language');
	17	$this->lang->load('messages', 'message');
[517]	18	}
	19
	20	public function checkLogin($src, $token, $username, $password) {
	21	$data = $this->vservices->actionExecute ( 'login', array (
	22	'src' => $src,
	23	'token' => $token,
	24	'username' => $username,
	25	'password' => $password
	26	), 'user' );
[633]	27	if(!($data) \|\| is_null($data)) return array('success'=>-1, 'data'=>$data);
	28	parse_str ( $data );
[517]	29	if ($status == 0 \|\| $status == 4) {
[633]	30	$us_id = ( int ) $id;
[517]	31	$query = "SELECT * FROM tbluser WHERE us_id = ?";
	32	$result = $this->db->query ( $query, array (
	33	$us_id
	34	) );
	35	if ($result->num_rows () == 1) {
[633]	36	return array('success'=>1, 'data'=>$data);
[517]	37	} else {
[633]	38	return array('success'=>0, 'data'=>$data);
[517]	39	}
	40	} else {
[633]	41	return array('success'=>0, 'data'=>$data);
[517]	42	}
	43	}
	44
[579]	45	public function register($username, $collaborator, &$collaboratorMsg = '') {
[517]	46	$user = array ();
	47	$password = $this->create_random_password ();
	48	$src = 'SBG';
	49	$sms = '';
	50	$id = 0;
	51	$errMsg = '';
	52	$token = md5 ( $username . self::TOKENPW );
	53	$phone = $username;
[579]	54	$status = 0;
[517]	55
	56	if (! is_null ( $collaborator ) \|\| $collaborator != '') {
	57	if (! $this->isExistcollaborator ( $collaborator )) {
[636]	58	$aryPatterns = array('/:collaborator:/');
	59	$sms = preg_replace($aryPatterns, array($collaborator), lang('_SBG_MO_COLLABORATOR_NOT_FOUND_MSG'));
[579]	60	$collaboratorMsg = $status . '\|'.$sms;
[517]	61	return $status . '\|' . $sms;
	62	}
	63	}
	64
	65	$data = $this->vservices->actionExecute ( 'update', array (
	66	'src' => $src,
	67	'username' => $username,
	68	'password' => $password,
	69	'fullname' => null,
	70	'phone' => $username,
	71	'token' => $token
	72	), 'user' );
[556]	73
[550]	74	if(!($data) \|\| is_null($data))
	75	{
[636]	76	$sms = lang('_SBG_MO_REGISTER_DISCONTINUE_MSG');
[579]	77	$collaboratorMsg = $status . '\|'.$sms;
[550]	78	return $status . '\|' . $sms;
	79	}
[556]	80
[517]	81	parse_str ( $data );
[581]	82
[517]	83	switch (( int ) $status) {
	84	case 0 :
	85	$us_id = $id;
	86	$user ['created_time'] = date ( 'Y-m-d H:i:s' );
	87	$user ['us_id'] = $us_id;
	88	$user ['cellphone'] = $username;
	89	if (! is_null ( $collaborator ) \|\| $collaborator != '') {
	90	$user ['collaborator'] = $collaborator;
	91	}
	92	$this->db->query ( 'UNLOCK TABLES' );
	93	$this->db->insert ( 'tbluser', $user );
[636]	94	$aryPatterns = array ('/:username:/', '/:password:/');
	95	$sms = preg_replace($aryPatterns, array($collaborator), lang('_SBG_MO_USER_REGISTER_SUCCESS_MSG'));
[517]	96	$status = 1;
[636]	97	$aryPatterns = array('/:username:/');
	98	$collaboratorMsg = $status . '\|'. preg_replace($aryPatterns, array($username), lang('_SBG_MO_COLLABOLATOR_REGISTER_SUCCESS_MSG'));
[517]	99	break;
	100	case 2 :
	101	case 4 :
[636]	102	$sms = lang('_SBG_MO_USER_REGISTER_DUPLICATE_MSG');
[517]	103	$status = 0;
[636]	104	$aryPatterns = array('/:username:/');
	105	$collaboratorMsg = $status . '\|'. preg_replace($aryPatterns, array($username), lang('_SBG_MO_COLLABOLATOR_REGISTER_DUPLICATE_MSG'));
[517]	106	break;
	107	default :
	108	$status = 0;
	109	$sms = $errMsg;
[579]	110	$collaboratorMsg = $status . '\|'. $sms;
[517]	111	break;
	112	}
	113
	114	return $status . '\|' . $sms;
	115	}
	116
	117	public function create_random_password() {
	118	// $alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789";
	119	$alphabet = "0123456789";
	120	$pass = array ();
	121	$alphaLength = strlen ( $alphabet ) - 1;
	122	for($i = 0; $i < 6; $i ++) {
	123	$n = rand ( 0, $alphaLength );
	124	$pass [] = $alphabet [$n];
	125	}
	126	return implode ( $pass );
	127	}
	128
	129	public function get_user_by_id($us_id) {
	130	$this->db->query ( 'UNLOCK TABLES' );
	131	$this->db->select ( '*' )->from ( 'tbluser' )->where ( 'us_id', $us_id );
	132	$query = $this->db->get ();
	133	if ($query->num_rows () > 0) {
	134	$row = $query->row_array ();
	135	return $row;
	136	}
	137	}
	138
	139	public function get_user_info($src, $token, $us_id) {
	140	$data = $this->vservices->actionExecute ( 'getinfo', array (
	141	'src' => $src,
	142	'us_id' => $us_id,
	143	'token' => $token
	144	), 'user' );
	145	return $data;
	146	}
	147
	148	public function update_user($src, $token, $user, $us_id) {
	149	$data = $this->vservices->actionExecute ( 'update', array (
	150	'src' => $src,
	151	'token' => $token,
	152	'us_id' => $us_id,
	153	'password' => $user ['password'],
	154	'fullname' => $user ['fullname'],
	155	'school' => $user ['school'],
	156	'province' => $user ['province'],
	157	'oldpass' => $user ['oldpass']
	158	), 'user' );
	159	return $data;
	160	}
	161
	162	public function changeProfile($sentNumber, $username, $password, &$status = '') {
	163	$user = array ();
	164	$src = 'SBG';
	165	$errMsg = '';
	166	$sms = '';
	167	$checkSentNumber = $this->get_user_by_cellphone ( $sentNumber );
	168
	169	if ($checkSentNumber) {
[636]	170	$aryPatterns = array('/:sentNumber:/');
	171	$sms = preg_replace($aryPatterns, array($sentNumber), lang('_SBG_MO_USER_PHONENUM_CHANGE_DUPLICATE_MSG'));
[517]	172	$status = 0;
	173	return $status . '\|' . $sms;
	174	}
	175
	176	$result = $this->get_user_by_cellphone ( $username );
	177
	178	if ($result) {
[582]	179
[517]	180	$us_id = $result ['us_id'];
	181	$token = md5 ( $us_id . self::TOKENPW );
[582]	182	$isCorrectPassword = $this->checkPassword($src, $us_id, $token, $password);
[636]	183	if(!$isCorrectPassword) return '0\|'.lang('_SBG_MO_USER_PHONENUM_CHANGE_INCORRECT_PASSWORD_MSG');
[582]	184
[517]	185	$data = $this->vservices->actionExecute ( 'update', array (
	186	'src' => $src,
	187	'token' => $token,
	188	'us_id' => $us_id,
	189	'username' => $sentNumber,
	190	"password" => $password,
	191	'oldpass' => $password,
	192	'phone' => $sentNumber
	193	), 'user' );
[582]	194
[550]	195	if(!($data) \|\| is_null($data))
	196	{
[636]	197	$sms = lang('_SBG_MO_PHONENUM_CHANGE_DISCONTINUE_MSG');
[550]	198	$status = 0;
	199	return $status . '\|' . $sms;
	200	}
[517]	201	parse_str ( $data );
	202	switch (( int ) $status) {
	203	case 0 :
	204	$us_id = $id;
	205	$user ['updated_time'] = date ( 'Y-m-d H:i:s' );
	206	$user ['us_id'] = $us_id;
	207	$user ['cellphone'] = $sentNumber;
	208	$this->updateUser ( $us_id, $user );
[636]	209	$aryPatterns = array('/:username:/', '/:sentNumber:/');
	210	$sms = preg_replace($aryPatterns, array($username, $sentNumber), lang('_SBG_MO_USER_NEW_PHONENUM_CHANGE_SUCCESS_MSG'));
[517]	211	$status = 1;
	212	break;
[581]	213	case 2:
[636]	214	$aryPatterns = array('/:sentNumber:/');
	215	$sms = preg_replace($aryPatterns, array($sentNumber), lang('_SBG_MO_USER_PHONENUM_CHANGE_DUPLICATE_MSG'));
[581]	216	$status = 0;
	217	break;
[517]	218	case 5 :
[636]	219	$aryPatterns = array('/:username:/');
	220	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_USER_PHONENUM_NOT_REGISTER_MSG'));
[517]	221	$status = 0;
	222	break;
	223	default :
	224	$status = 0;
	225	$sms = $errMsg;
	226	break;
	227	}
	228	} else {
[636]	229	$aryPatterns = array('/:username:/');
	230	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_USER_PHONENUM_NOT_REGISTER_MSG'));
[517]	231	$status = 0;
	232	}
	233	return $status . '\|' . $sms;
	234	}
	235
	236	public function changePassword($username, $password, &$status = '') {
	237	$user = array ();
	238	$src = 'SBG';
	239	$errMsg = '';
	240	$sms = '';
	241	$isForgotPassword = false;
	242	$pass = $password;
	243
	244	if (is_null ( $password ) \|\| $password == '') {
	245	$pass = $this->create_random_password ();
	246	$isForgotPassword = true;
	247	}
	248
	249	$result = $this->get_user_by_cellphone ( $username );
[579]	250
[517]	251	if ($result) {
	252	$us_id = $result ['us_id'];
	253	$token = md5 ( $us_id . self::TOKENPW );
	254	$data = $this->vservices->actionExecute ( 'update', array (
	255	'src' => $src,
	256	'token' => $token,
	257	'us_id' => $us_id,
	258	"password" => $pass
	259	), 'user' );
[550]	260
	261	if(!($data) \|\| is_null($data))
	262	{
[636]	263	$sms = lang('_SBG_MO_PASSWORD_CHANGE_DISCONTINUE_MSG');
[550]	264	$status = 0;
	265	return $status . '\|' . $sms;
	266	}
[517]	267	parse_str ( $data );
	268	switch (( int ) $status) {
	269	case 0 :
	270	$us_id = $id;
	271	$user ['updated_time'] = date ( 'Y-m-d H:i:s' );
	272	$this->updateUser ( $us_id, $user );
	273	if ($isForgotPassword) {
[636]	274	$aryPatterns = array('/:pass:/');
	275	$sms = preg_replace($aryPatterns, array($pass), lang('_SBG_MO_USER_PASSWORD_RECOVERY_MSG'));
[517]	276	} else {
[636]	277	$aryPatterns = array('/:password:/');
	278	$sms = preg_replace($aryPatterns, array($pass), lang('_SBG_MO_USER_PASSWORD_CHANGE_SUCCESS_MSG'));
[517]	279	}
	280	$status = 1;
	281	break;
	282	case 5 :
[636]	283	$aryPatterns = array('/:username:/');
	284	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_USER_PHONENUM_NOT_REGISTER_MSG'));
[517]	285	$status = 0;
	286	break;
	287	default :
	288	$status = 0;
	289	$sms = $errMsg;
	290	break;
	291	}
	292	} else {
[636]	293	$aryPatterns = array('/:username:/');
	294	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_USER_PHONENUM_NOT_REGISTER_MSG'));
[517]	295	$status = 0;
	296	}
	297	return $status . '\|' . $sms;
	298	}
	299
	300	public function checkLicense($userId) {
	301	$isNotExpired = false;
	302	$userInfo = array ();
	303	$userInfo = $this->get_user_by_id ( $userId );
	304
	305	$expireDate = $userInfo ['expire_date'];
	306
	307	if ((trim ( $expireDate ) == ''))
	308	return $isNotExpired;
	309
	310	$today = mktime ();
	311	$expireTime = strtotime ( $expireDate . ' 23:59:59' );
	312	$isNotExpired = ($today < $expireTime);
	313	return $isNotExpired;
	314	}
	315
	316	public function registerVip($username, $p_code) {
	317	$user = array ();
	318	$sms = '';
	319
	320	$result = $this->get_user_by_cellphone ( $username );
	321	$package = $this->get_package ( ( int ) $p_code );
[544]	322	if (!$package)
	323	{
[636]	324	$sms = lang('_SBG_MO_USER_REGISTER_VIP_NOT_FOUND_MSG');
[544]	325	$status = 0;
	326	return $status . '\|' . $sms;
	327	}
[517]	328	if ($result) {
	329
	330	if ($result ['acc_balanced'] >= $package ['p_price']) {
	331	$us_id = $result ['us_id'];
	332	$user ['acc_balanced'] = $result ['acc_balanced'] - $package ['p_price'];
	333	if ($this->checkLicense ( $us_id )) {
	334	$user ['expire_date'] = date ( 'Y-m-d', strtotime ( $result ['expire_date'] . ' + ' . $package ['p_period'] . ' month' ) );
	335	} else {
	336	$user ['expire_date'] = date ( 'Y-m-d', strtotime ( 'now + ' . $package ['p_period'] . ' month' ) );
	337	}
	338
	339	$user ['p_id'] = $package ['p_id'];
	340	$user ['updated_time'] = date ( 'Y-m-d H:i:s' );
	341
	342	$this->updateUser ( $us_id, $user );
[636]	343	$aryPatterns = array('/:period:/');
	344	$sms = preg_replace($aryPatterns, array(date ( 'd/m/Y', strtotime ( $user ['expire_date'] ) )), lang('_SBG_MO_USER_REGISTER_VIP_SUCCESS_MSG'));
[517]	345	$status = 1;
	346	} else {
[636]	347	$sms = lang('_SBG_MO_USER_REGISTER_VIP_FAIL_NOT_ENOUGH_MSG');
[517]	348	$status = 0;
	349	}
	350	} else {
[636]	351	$aryPatterns = array('/:username:/');
	352	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_ACCOUNT_NOT_FOUND_MSG'));
[517]	353	$status = 0;
	354	}
	355	return $status . '\|' . $sms;
	356	}
	357
	358	public function rechargeAccount($username, $amount) {
	359	$user = array ();
	360	$sms = '';
	361	$result = $this->get_user_by_cellphone ( $username );
	362	if ($result) {
	363	$us_id = $result ['us_id'];
	364	$user ['acc_balanced'] = $result ['acc_balanced'] + $amount;
	365	$user ['updated_time'] = date ( 'Y-m-d H:i:s' );
	366	$this->updateUser ( $us_id, $user );
[636]	367	$aryPatterns = array('/:amount:/', '/:username:/');
	368	$sms = preg_replace($aryPatterns, array($amount, $username), lang('_SBG_MO_PAY_TO_ACCOUNT_SUCCESS_MSG'));
[517]	369	$status = 1;
	370	} else {
[636]	371	$aryPatterns = array('/:username:/');
	372	$sms = preg_replace($aryPatterns, array($username), lang('_SBG_MO_ACCOUNT_NOT_FOUND_MSG'));
[517]	373	$status = 0;
	374	}
	375	return $status . '\|' . $sms;
	376	}
	377
	378	public function get_user_by_cellphone($cellphone) {
	379	$this->db->query ( 'UNLOCK TABLES' );
	380	$sql = 'SELECT * FROM tbluser where cellphone = ? LIMIT 0,1';
	381	$query = $this->db->query ( $sql, array (
	382	$cellphone
	383	) );
	384	$row = $query->row_array ();
	385	return $row;
	386	}
	387
	388	public function isExistcollaborator($collaborator) {
	389	$this->db->query ( 'UNLOCK TABLES' );
	390	$this->db->select ( '*' )->from ( 'tblcollaborator' )->where ( 'login_name', $collaborator )->limit ( 1 );
	391	$result = $this->db->get ()->row_array ();
	392	if ($result)
	393	return true;
	394	else
	395	return false;
	396	}
	397
	398	public function updateUser($us_id, $data) {
	399	$this->db->query ( 'UNLOCK TABLES' );
	400	$this->db->where ( 'us_id', $us_id );
	401	$this->db->update ( 'tbluser', $data );
	402	}
	403
	404	public function get_package($p_code) {
	405	$this->db->query ( 'UNLOCK TABLES' );
	406	$sql = 'SELECT * FROM tblservicepackage where p_code = ? LIMIT 0,1';
	407	$query = $this->db->query ( $sql, array (
	408	$p_code
	409	) );
	410	$row = $query->row_array ();
	411	return $row;
	412	}
	413
	414	public function insertSmslog($sentNumber, $serviceID, $commandcode, $info, $receiveTime) {
	415	if (preg_match ( '/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch ) == 1) {
	416	$sentNumber = '0' . $aryMatch [2];
	417	}
	418
	419	try {
	420	$user = $this->get_user_by_cellphone ( $sentNumber );
	421	} catch ( Exception $e ) {
	422	}
	423
	424	$smslog = array ();
	425	$smslog ['sender'] = $sentNumber;
	426	$smslog ['us_id'] = isset ( $user ['us_id'] ) ? $user ['us_id'] : NULL;
	427	$smslog ['service_id'] = $serviceID;
	428	$smslog ['commandcode'] = $commandcode;
	429	$smslog ['info'] = $info;
	430	$smslog ['created_time'] = $receiveTime;
	431	$this->db->query ( 'UNLOCK TABLES' );
	432	$sql = 'INSERT INTO tblsmslog(sender, us_id, service_id, commandcode, info, created_time) VALUES(?,?,?,?,?,?)';
	433	$query = $this->db->query($sql, $smslog);
	434	}
	435
	436	public function insertPaidlog($sentNumber, $receiveID, $paidType, $amount, $paidTime) {
	437	if (preg_match ( '/^(84)([0-9]{9,10})$/', $sentNumber, $aryMatch ) == 1) {
	438	$sentNumber = '0' . $aryMatch [2];
	439	}
	440
	441	try {
[560]	442	$user = $this->get_user_by_cellphone ( $receiveID );
[517]	443	} catch ( Exception $e ) {
	444	}
	445	$paidlog = array ();
	446	$paidlog ['us_id'] = isset ( $user ['us_id'] ) ? $user ['us_id'] : NULL;
	447	$paidlog ['paidType'] = $paidType;
	448	$paidlog ['amount'] = $amount;
[559]	449	$paidlog['source'] = "";
	450	if ($paidType == 1)
	451	{
	452	$paidlog['source'] = $sentNumber;
	453
	454	}else
	455	{
	456	$paidlog['source'] = "Tháº» cÃ o";
	457	}
[517]	458	$paidlog ['paidTime'] = $paidTime;
	459	$this->db->query ( 'UNLOCK TABLES' );
[559]	460	$sql = 'INSERT INTO tblpaidlog(us_id, paid_type, amount, source, paid_time) VALUES (?,?,?,?,?)';
[519]	461	$query = $this->db->query ( $sql, $paidlog );
[517]	462	}
[544]	463
	464	public function insertCardlog($username, $pinCode, $serialNum, $cardValue, $receiveTime)
	465	{
	466	try {
	467	$user = $this->get_user_by_cellphone ( $username );
	468	} catch ( Exception $e ) {
	469	}
	470
	471	$cardlog = array();
	472	$cardlog['sender'] = $username;
	473	$cardlog['us_id'] = isset ( $user ['us_id'] ) ? $user ['us_id'] : NULL;
	474	$cardlog['pin_code'] = $pinCode;
	475	$cardlog['serial_num'] = $serialNum;
	476	$cardlog['card_value'] = $cardValue;
	477	$cardlog['created_time'] = $receiveTime;
	478	$this->db->query ( 'UNLOCK TABLES' );
	479	$sql = 'INSERT INTO tblcardlog(sender, us_id, pin_code, serial_num, card_value, created_time) VALUES(?,?,?,?,?,?)';
	480	$query = $this->db->query ($sql, $cardlog);
	481	}
[559]	482
[574]	483	public function getPaidlog($data)
[559]	484	{
[574]	485	$us_id = $data['us_id'];
[559]	486	$this->db->query ( 'UNLOCK TABLES' );
[574]	487	$sql = "SELECT * FROM tblpaidlog where us_id = ? ORDER BY paid_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
[559]	488	$query = $this->db->query ( $sql, array (
	489	$us_id
	490	) );
	491	$row = $query->result_array();
	492	return $row;
	493	}
[574]	494
	495	public function countPaiglogs($us_id)
	496	{
	497	$this->db->query ( 'UNLOCK TABLES' );
	498	$sql="SELECT COUNT(paid_id) AS total FROM tblpaidlog WHERE us_id = ?";
	499	$query = $this->db->query ( $sql, array (
	500	$us_id
	501	) );
	502	$result = $query->row_array();
	503	return $result['total'];
	504	}
[582]	505
	506	public function checkPassword($src, $us_id, $token, $password)
	507	{
	508	$data = $this->vservices->actionExecute ( 'getinfo', array (
	509	'src' => $src,
	510	'us_id' => $us_id,
	511	'token' => $token,
	512	'ponly'=>1
	513	), 'user' );
	514
	515	parse_str($data);
	516	if(md5($password) == $pencrypted) return true; else return false;
	517	}
[633]	518
[642]	519	public function insertRegisterVipLog($username, $source, $p_code)
[633]	520	{
	521	$createdTime = date('Y-m-d H:i:s');
[642]	522	$this->db->query ( 'UNLOCK TABLES' );
	523	$sql = 'INSERT INTO tblregisterpackagelog (username, source, p_code, created_time) VALUES (?,?,?,?)';
[633]	524	$query = $this->db->query ( $sql, array (
[642]	525	'username'=>$username,
[633]	526	'source'=>$source,
	527	'p_code'=>$p_code,
	528	'created_time'=>$createdTime
	529	) );
	530	}
[642]	531
	532	public function getPackagelog($data)
	533	{
	534	$username = $data['username'];
	535	$this->db->query ( 'UNLOCK TABLES' );
	536	$sql = "SELECT * FROM tblregisterpackagelog where username = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage']." ";
	537	$query = $this->db->query ( $sql, array (
	538	$username
	539	) );
	540	$row = $query->result_array();
	541	return $row;
	542	}
	543
	544	public function countPackagelogs($username)
	545	{
	546	$this->db->query ( 'UNLOCK TABLES' );
	547	$sql="SELECT COUNT(id) AS total FROM tblregisterpackagelog WHERE username = ?";
	548	$query = $this->db->query ( $sql, array (
	549	$username
	550	) );
	551	$result = $query->row_array();
	552	return $result['total'];
	553	}
[637]	554	}

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

Download in other formats: