Context Navigation

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

Last change on this file since 721 was 716, checked in by dungnv, 10 years ago

File size: 18.6 KB

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

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

Download in other formats: