- Timestamp:
- Mar 24, 2015 2:15:02 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php
r773 r818 88 88 $us_id = $id; 89 89 $user ['created_time'] = date ( 'Y-m-d H:i:s' ); 90 $user ['updated_time'] = date ( 'Y-m-d H:i:s' ); 90 91 $user ['us_id'] = $us_id; 91 92 $user ['p_id'] = $trialpackage['p_id']; … … 98 99 $this->db->query ( 'UNLOCK TABLES' ); 99 100 $this->db->insert ( 'tbluser', $user ); 101 //write_file('./log/test.log', date("H:i:s m-d-Y").": ". var_export($user, TRUE)."\n" , FOPEN_WRITE_CREATE); 100 102 $aryPatterns = array ('/:trialdays:/', '/:username:/', '/:password:/'); 101 103 $trialdays = $this->config->item('trial_period'); 102 104 $trialdays = strlen($trialdays) < 2 ? '0'. $trialdays : $trialdays; 103 $sms = preg_replace($aryPatterns, array($trialdays. ' ngay', $username, $password), lang('_SBG_MO_USER_REGISTER_SUCCESS_MSG')); 105 if ($this->isViettel($username)){ 106 $sms = preg_replace($aryPatterns, array($trialdays. ' ngay', $username, $password), lang('_SBG_MO_USER_VIETTEL_REGISTER_SUCCESS_MSG')); 107 }else{ 108 $aryPatterns = array ('/:username:/', '/:password:/'); 109 $sms = preg_replace($aryPatterns, array($username, $password), lang('_SBG_MO_USER_NOT_VIETTEL_REGISTER_SUCCESS_MSG')); 110 } 104 111 $status = 1; 105 112 $aryPatterns = array('/:username:/'); … … 565 572 { 566 573 $username = $data['username']; 567 $us_id = $data['us_id']; 568 $this->db->query ( 'UNLOCK TABLES' ); 569 //$sql="SELECT tblregisterpackagelog.source,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage'].""; 570 $sql="SELECT tblregisterpackagelog.source,0 as amount,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,'Nạp tiền' as name,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage'].""; 571 $query = $this->db->query ( $sql, array ( 572 "$username", 573 $us_id 574 ) ); 574 $us_id = $data['us_id']; 575 $this->db->query ( 'UNLOCK TABLES' ); 576 //$sql="SELECT tblregisterpackagelog.source,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage'].""; 577 $sql="SELECT tblregisterpackagelog.source,0 as amount,tblservicepackage.p_name,tblregisterpackagelog.created_time FROM tblregisterpackagelog INNER JOIN tblservicepackage ON tblservicepackage.p_code = tblregisterpackagelog.p_code where username = ? UNION SELECT tblpaidlog.source,tblpaidlog.amount,'Nạp tiền' as name,tblpaidlog.paid_time FROM tblpaidlog where us_id = ? ORDER BY created_time DESC LIMIT ".$data['start'].", ".$data['perpage'].""; 578 $query = $this->db->query ( $sql, array ("$username", $us_id) ); 575 579 $row = $query->result_array(); 576 580 return $row; … … 597 601 } 598 602 } 603 604 public function isViettel($number) { 605 $prefixViettel = array ( 606 '96', '97', '98', 607 '096', '097', '098', '162', '163', '164', '165', '166', '167', '168', '169', 608 '8496', '8497', '8498', '0162', '0163', '0164', '0165', '0166', '0167', '0168', '0169', 609 '84162', '84163', '84164', '84165', '84166', '84167', '84168', '84169' 610 ); 611 foreach ( $prefixViettel as $value ) { 612 if (strpos ( $number, $value ) === 0) { 613 return 1; 614 } 615 } 616 return 0; 617 } 618 599 619 }
Note: See TracChangeset
for help on using the changeset viewer.