/** * Expire login * User need change password to insite * @return boolean whether login */ public static function expire() { $user = WUser::model()->find('LOWER(username)=?', array(strtolower(Yii::app()->user->name))); $time_changepass = strtotime($user['time_changepass']); $now = time(); $datediff = $now - $time_changepass; $number_date = floor($datediff / (60 * 60 * 24)); if (isset($time_changepass) && $time_changepass != '' || $number_date <= Yii::app()->params->number_date_expire) { return false; } else { return true; } }
/** * Authenticates a user. * @return boolean whether authentication succeeds. */ public function authenticate() { $user = WUser::model()->find('LOWER(username)=?', array(strtolower($this->username))); //var_dump($user); exit(); //echo CFunction::encrypt($this->password,Yii::app()->params->hashkey);exit(); //echo $user->validatePassword($this->password,Yii::app()->params->hashkey);exit(); if ($user === null) { $this->errorCode = self::ERROR_USERNAME_INVALID; } else { if (!$user->validatePassword($this->password, Yii::app()->params->hashkey)) { $this->errorCode = self::ERROR_PASSWORD_INVALID; } else { $this->_id = $user->id; //$this->_group_id = $user->group; $this->username = $user->username; $this->errorCode = self::ERROR_NONE; //update login } } return $this->errorCode == self::ERROR_NONE; }
} ?> "> </div> </div> <div class="form-group"> <label for="inputCompany" class="col-sm-4 control-label">Company</label> <div class="col-sm-8"> <input type="text" id="inputCompany" class="form-control" style="margin-bottom: 10px;" name="company" value="<?php if ($data['company']) { echo $data['company']; } ?> "> <?php echo CHtml::dropDownList("compay_id", "company_id", CHtml::listData(WUser::model()->findAll(), "company", "company"), array('prompt' => '--' . Yii::t('web/home', 'Select Company') . '--', "onchange" => "return OnChangeCompany(this)", "class" => "form-control chosen-select", "style" => "margin-top:10px")); ?> </div> </div> <div class="form-group"> <label for="inputPhone" class="col-sm-4 control-label">Phone</label> <div class="col-sm-8"> <input type="text" id="inputPhone" class="form-control" name="phone" value="<?php if ($data['region']) { echo $data['phone']; } ?> "> </div> </div> <div class="form-group">
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return WUser the loaded model * @throws CHttpException */ public function loadModel($id) { $model = WUser::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
?> /webRTC/js/firebase.js"></script> <script type="text/javascript" src="<?php echo Yii::app()->params['url_base']; ?> /webRTC/js/RTCMultiConnection-v2.2.4.js"></script> <!--<script type="text/javascript" src="--><?php //echo Yii::app()->params['url_base']; ?> <!--/webRTC/js/getMediaElement.css"></script>--> <script type="text/javascript" src="<?php echo Yii::app()->params['url_base']; ?> /webRTC/js/getMediaElement.js"></script> <?php $dataUser = WUser::model()->find("id=" . Yii::app()->user->id); ?> <div class="primary_boxtop"> <div class="primary_boxtop_content"> <h1 class="fl"><img src="<?php echo Yii::app()->theme->baseUrl; ?> /img/icon-webinar.png" align="middle" alt="Course" /><?php echo $dataCourseLecture['lecture_name']; ?> </h1> <div class="clear"></div> </div> </div> <div class="primary_container">
/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionTraineeViewCourse($id) { if (empty(Yii::app()->user->id)) { $this->redirect(Yii::app()->createUrl('')); } $dataCourseLecture = array(); $listTrainee = array(); $db = Yii::app()->db; if (!empty($id)) { $data = WCourseLecture::model()->findAll('course_id=' . $id . ' ORDER BY start_date ASC'); $data = CJSON::decode(CJSON::encode($data)); $course_data = WCourse::getDetailCourse($id); if (!empty($data)) { foreach ($data as $key => $item) { if (!empty($item["lecture_id"])) { $lectureDetails = WLecture::model()->find('id=' . $item['lecture_id']); if (!empty($lectureDetails)) { $category = $lectureDetails->category; $lectureDetails = CJSON::decode(CJSON::encode($lectureDetails)); $dataCourseLecture[$item['id']] = $item; $dataCourseLecture[$item['id']]['details'] = $lectureDetails; $dataCourseLecture[$item['id']]['cat_name'] = $category->cat_name; $dataCourseLecture[$item['id']]['PreTest'] = FALSE; if (strtotime($course_data["end_date"]) < strtotime($item["end_date"])) { $dataCourseLecture[$item['id']]['end_date'] = $course_data["end_date"]; } if (!empty($item['pre_test_id'])) { $comm = $db->createCommand()->select('t.*')->from('pls_user_test t')->where('course_id=' . $item['course_id'] . ' AND success = 2 AND lecture_id=' . $item['lecture_id'] . ' AND test_id=' . $item['pre_test_id'] . ' AND user_id=' . Yii::app()->user->id); $preTest = $comm->queryRow(); $comm->reset(); if (!empty($preTest)) { $dataCourseLecture[$item['id']]['PreTest'] = TRUE; } } $dataCourseLecture[$item['id']]['Test'] = FALSE; if (!empty($item['test_id'])) { $comm = $db->createCommand()->select('t.*')->from('pls_user_test t')->where('course_id=' . $item['course_id'] . ' AND success=2 AND lecture_id=' . $item['lecture_id'] . ' AND test_id=' . $item['test_id'] . ' AND user_id=' . Yii::app()->user->id); $Test = $comm->queryRow(); $comm->reset(); if (!empty($Test)) { $dataCourseLecture[$item['id']]['Test'] = TRUE; } } } } // Info Pre-Test } } $dataTrainee = WCourseTrainee::model()->findAll('course_id=' . $id); $dataTrainee = CJSON::decode(CJSON::encode($dataTrainee)); if (!empty($dataTrainee)) { foreach ($dataTrainee as $item) { $traineeDetails = WUser::model()->find('id=' . $item['trainee_id']); if (!empty($traineeDetails)) { $traineeDetails = CJSON::decode(CJSON::encode($traineeDetails)); $listTrainee[$traineeDetails['id']]['id'] = $traineeDetails['id']; $listTrainee[$traineeDetails['id']]['course_id'] = $id; $listTrainee[$traineeDetails['id']]['fullname'] = $traineeDetails['fullname']; $listTrainee[$traineeDetails['id']]['username'] = $traineeDetails['username']; } } } } $this->render('trainee/view', array('model' => $this->loadModel($id), 'dataCourseLecture' => $dataCourseLecture, 'listTrainee' => $listTrainee)); }
?> <?php echo $form->dropDownList($model, 'course_id', CHtml::listData(WCourse::model()->findAll(), 'id', 'course_name'), array('prompt' => 'Chọn khóa học :')); ?> <?php echo $form->error($model, 'course_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'trainee_id'); ?> <?php echo $form->dropDownList($model, 'trainee_id', CHtml::listData(WUser::model()->findAll("group_id=2"), 'id', 'fullname'), array('class' => 'chosen-select', 'multiple' => 'multiple', 'data-placeholder' => "Chọn học viên vào lớp")); ?> <?php echo $form->error($model, 'trainee_id'); ?> <input type="hidden" id="list_trainee" name="list_trainee" /> <?php $cs = Yii::app()->getClientScript(); $cs->registerCssFile(Yii::app()->theme->baseUrl . '/chosen/chosen.css'); ?> <script type="text/javascript"> function add_chosen(item) { $('#list_trainee').val($('#list_trainee').val()+item.value+","); }; function delete_chosen(item) {
public static function getUserById($id) { return WUser::model()->find('id=:id', array(':id' => $id)); }
/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionViewCourse($id) { if (empty(Yii::app()->user->id)) { $this->redirect(Yii::app()->createUrl('')); } $dataCourseLecture = array(); $listTrainee = array(); if (!empty($id)) { $data = WCourseLecture::model()->findAll('course_id=' . $id); $data = CJSON::decode(CJSON::encode($data)); if (!empty($data)) { foreach ($data as $key => $item) { $lectureDetails = WLecture::model()->find('id=' . $item['lecture_id']); if (!empty($lectureDetails)) { $category = $lectureDetails->category; $lectureDetails = CJSON::decode(CJSON::encode($lectureDetails)); $dataCourseLecture[$item['id']] = $item; $dataCourseLecture[$item['id']]['details'] = $lectureDetails; $dataCourseLecture[$item['id']]['cat_name'] = $category->cat_name; } } } $dataTrainee = WCourseTrainee::model()->findAll('course_id=' . $id); $dataTrainee = CJSON::decode(CJSON::encode($dataTrainee)); if (!empty($dataTrainee)) { foreach ($dataTrainee as $item) { $traineeDetails = WUser::model()->find('id=' . $item['trainee_id']); if (!empty($traineeDetails)) { $traineeDetails = CJSON::decode(CJSON::encode($traineeDetails)); $listTrainee[$traineeDetails['id']]['id'] = $traineeDetails['id']; $listTrainee[$traineeDetails['id']]['course_id'] = $id; $listTrainee[$traineeDetails['id']]['fullname'] = $traineeDetails['fullname']; $listTrainee[$traineeDetails['id']]['username'] = $traineeDetails['username']; } } } } $this->render('supervisor/view', array('model' => $this->loadModel($id), 'dataCourseLecture' => $dataCourseLecture, 'listTrainee' => $listTrainee)); }
<div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4 class="modal-title"><?php echo Yii::t('web/home', 'titleBoxAddTrainee'); ?> </h4> </div> <!--form search--> <div class="modal-body" > <label class="sr-only"><?php echo Yii::t('web/home', 'Search'); ?> </label> <input type="text" id="trainee_username" class="form-control" placeholder="Username Or Fullname Or Email" style="width: 600px;float: left;"> <?php echo Chtml::dropDownList('dataListCompany', 'id', Chtml::listData(WUser::model()->findAll('company is NOT NULL GROUP BY company'), "company", "company"), array('empty' => Yii::t('web/home', 'Select a Company'), 'style' => 'width:215px;float:left;margin-left:10px', 'class' => 'form-control')); ?> <button type="button" onclick="return loadTraineeOption();" class="btn btn-success" style="margin-left: 10px; float: left;"><?php echo Yii::t('web/home', 'Search'); ?> </button> <div id="bodyTraineeList" style="float: left;width: 100%; margin-top: 10px;"></div> <div class="clear"></div> </div> <div class="modal-footer"> <button type="button" class="btn btn-success btn-sm" onclick="return addMutilTrainee();"><?php echo Yii::t('web/home', 'titleBoxAddTraineeButtonAdd'); ?> </button> <button type="button" class="btn btn-danger btn-sm" data-dismiss="modal" ><?php echo Yii::t('web/home', 'titleBoxAddTraineeButtonClose');
/** * This is the default 'index' action that is invoked * when an action is not explicitly requested by users. */ public function actionIndex() { $view = 'index'; if (Yii::app()->user->isGuest) { $this->redirect(array('login')); } else { if (Yii::app()->session['group_id'] == 2) { $this->layout = '//layouts/main'; $view = 'trainee/index'; $this->render($view); } elseif (Yii::app()->session['group_id'] == 1) { $this->layout = '//layouts/main'; $view = 'trainer/index'; $this->render($view); } elseif (Yii::app()->session['group_id'] == 4) { $this->layout = '//layouts/main'; $view = 'teamleader/index'; $this->render($view); } elseif (Yii::app()->session['group_id'] == 3) { $view = 'supervisor/index'; // $view = 'index'; $this->layout = '//layouts/main'; $data = array(); // biểu đồ liên quan $infoCourse = array(); $criteria = new CDbCriteria(); $criteria->condition = 'status = 1'; $criteria->order = 'id desc'; $criteria->limit = 6; $count = WUser::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = Params::$rowsPerPage; $pages->applyLimit($criteria); $infosupper = WUser::model()->findAll($criteria); // course_lecture /* $courseLecture = array(); $db = Yii::app()->db; $comm = $db->createCommand() ->select('COUNT(*)') ->from('pls_course_lecture t') ->leftJoin('pls_course t1','t1.id = t.course_id') ->leftJoin('pls_lecture t2','t2.id = t.lecture_id') ->leftJoin('pls_test t3','t3.id = t.pre_test_id') ->leftJoin('pls_test t4','t4.id = t.test_id') ->leftJoin('pls_user t5','t5.id = t.trainer_id') ->order('t.id DESC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand() ->select(' t.*, t1.course_name, t2.lecture_name, t3.test_name, t4.test_name, t5.fullname ') ->from('pls_course_lecture t') ->leftJoin('pls_course t1','t1.id = t.course_id') ->leftJoin('pls_lecture t2','t2.id = t.lecture_id') ->leftJoin('pls_test t3','t3.id = t.pre_test_id') ->leftJoin('pls_test t4','t4.id = t.test_id') ->leftJoin('pls_user t5','t5.id = t.trainer_id') ->order('t.id ASC'); $limit = 6; $page = (isset($_GET['page']) AND !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page-1); $comm->limit = $limit; $comm->offset = $offset; $courseLecture = $comm->queryAll(); $pages = new CPagination($total); $pages->pageSize = $limit; */ $courseLecture = array(); $courseLecture = WCourseLecture::model()->findAll(); $Lectures = array(); $Lectures = WLecture::model()->findAll(); // course trainne /* $courseTrainee = array(); $db = Yii::app()->db; $comm = $db->createCommand() ->select('COUNT(*)') ->from('pls_course_trainee t') ->leftJoin('pls_course t1','t1.id = t.course_id') ->leftJoin('pls_user t2','t2.id = t.trainee_id') ->order('t.id DESC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand() ->select(' t.*, t1.course_name, t2.fullname ') ->from('pls_course_trainee t') ->leftJoin('pls_course t1','t1.id = t.course_id') ->leftJoin('pls_user t2','t2.id = t.trainee_id') ->order('t.id ASC'); $limit = 10; $page = (isset($_GET['page']) AND !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page-1); $comm->limit = $limit; $comm->offset = $offset; $courseTrainee = $comm->queryAll(); $pages = new CPagination($total); $pages->pageSize = $limit;*/ // course_trainee $db = Yii::app()->db; $comm = $db->createCommand()->select('count(*)')->from('pls_user t')->where('t.user_group_id=2'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select('*')->from('pls_user t')->where('t.user_group_id=2'); $limit = 5; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $data = $comm->queryAll(); $result = array(); if (!empty($data)) { foreach ($data as $item) { $result[$item['id']] = $item; $comm->reset(); $comm = $db->createCommand()->select('t2.course_name')->from('pls_course_trainee t')->leftJoin('pls_course t2', 't.course_id= t2.id')->where('t.trainee_id=' . $item['id'] . ' AND t.status = 1'); $Trainee = $comm->queryAll(); $result[$item['id']]['course_list'] = $Trainee; } } $pages = new CPagination($total); $pages->pageSize = $limit; $TraineeUser = array(); $TraineeUser = WUser::model()->findAll('status=1 and user_group_id=2'); // var_dump(count($TraineeUser)); $TrainerUser = array(); $TrainerUser = WUser::model()->findAll('status =1 and user_group_id=1'); // var_dump(count($TrainerUser)); $sum = array(); $sum = array_merge($TraineeUser, $TrainerUser); // var_dump(count($sum));die; // var_dump(count($sumUser));die; // course_trainer $db = Yii::app()->db; $comm = $db->createCommand()->select('count(*)')->from('pls_user t')->where('t.user_group_id=1'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select('*')->from('pls_user t')->where('t.user_group_id=1'); $limit = 6; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $data = $comm->queryAll(); $resultTrainer = array(); if (!empty($data)) { foreach ($data as $item) { $result[$item['id']] = $item; $comm->reset(); $comm = $db->createCommand()->select('t2.course_name')->from('pls_course_trainee t')->leftJoin('pls_course t2', 't.course_id= t2.id')->where('t.trainee_id=' . $item['id'] . ' AND t.status = 1'); $courseTrainee = $comm->queryAll(); $resultTrainer[$item['id']]['course_list'] = $courseTrainee; } } $pages = new CPagination($total); $pages->pageSize = $limit; // var_dump(count($resultTrainer));die; // course_result_test $courseTest = array(); $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_user_test t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_user t2', 't2.id = t.user_id')->leftJoin('pls_test t3', 't3.id = t.test_id')->order('t.course_id DESC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select(' t.*, t1.course_name, t2.fullname, t3.total_point ')->from('pls_user_test t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_user t2', 't2.id = t.user_id')->leftJoin('pls_test t3', 't3.id = t.test_id')->order('t.course_id ASC'); $limit = 6; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $courseTest = $comm->queryAll(); $pages = new CPagination($total); $pages->pageSize = $limit; // lecture_schedule $lectureSchedule = array(); $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course_lecture t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_lecture t2', 't2.id = t.lecture_id')->leftJoin('pls_user t5', 't5.id = t.trainer_id')->order('t.trainer_id DESC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select(' t.*, t1.course_name, t2.lecture_name, t5.fullname ')->from('pls_course_lecture t')->leftJoin('pls_course t1', 't1.id = t.course_id')->leftJoin('pls_lecture t2', 't2.id = t.lecture_id')->leftJoin('pls_user t5', 't5.id = t.trainer_id')->order('t.trainer_id DESC'); $limit = 6; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $lectureSchedule = $comm->queryAll(); $pages = new CPagination($total); $pages->pageSize = $limit; // running course $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course t')->leftJoin('pls_course_cat t1', 't1.id = t.course_cat_id')->where('t.status = 2 and t.end_date > NOW()')->order('t.start_date ASC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select(' t.*, t1.course_cat, t1.avatar ')->from('pls_course t')->leftJoin('pls_course_cat t1', 't1.id = t.course_cat_id')->where('t.status = 2 and t.end_date > NOW()')->order('t.start_date ASC'); $limit = 6; $page = (isset($_GET['page']) and !empty($_GET['page'])) ? $_GET['page'] : 1; $offset = $limit * ($page - 1); $comm->limit = $limit; $comm->offset = $offset; $runningCourse = $comm->queryAll(); $pages = new CPagination($total); $pages->pageSize = $limit; $totalCourse = array(); $coursependding = array(); $courseactive = array(); $coursestart = array(); $coursecomplete = array(); $totalCourse = WCourse::model()->findAll(); $coursependding = WCourse::model()->findAll('status=0'); $courseactive = WCourse::model()->findAll('status=1'); $coursestart = WCourse::model()->findAll('status=2'); $coursecomplete = WCourse::model()->findAll('status=5'); $imgoverview = '<img width="680px" height="360px" src="' . Yii::app()->theme->baseUrl . '/img/overview.png" />'; // training proccessing $dashCourse = array(); $db = Yii::app()->db; $comm = $db->createCommand()->select('COUNT(*)')->from('pls_course t')->leftJoin('pls_user t2', 't2.id = t.trainer_id')->order('t.status ASC'); $total = $comm->queryScalar(); $comm->reset(); $comm = $db->createCommand()->select(' t.*, t2.fullname ')->from('pls_course t')->leftJoin('pls_user t2', 't2.id = t.trainer_id')->order('t.status ASC'); $dashCourse = $comm->queryAll(); $total_pages = ceil(count($dashCourse) / Params::$coursePerPage); $test = $db->createCommand(' SELECT course_id, user_id, AVG(point_percent), YEAR(end_date) ,Y.course_name FROM( SELECT A.course_id, A.lecture_id, A.test_id, A.pass_score_point, A.user_id, C.total_point, ROUND(IFNULL(A.pass_score_point, 0)*100 / C.total_point, 0) point_percent FROM pls_user_test A INNER JOIN pls_test C ON A.test_id = C.id WHERE A. status = 1 AND A.success = 2 GROUP BY A.course_id, A.test_id, A.user_id, A.lecture_id ) X INNER JOIN pls_course Y ON X.course_id = Y.id WHERE Y.end_date < NOW() GROUP BY course_id, end_date ,course_name , YEAR(end_date) ORDER BY YEAR(end_date) ASC '); $test = $test->queryAll(); // MyHelper::dump($test);die; $this->render($view, array('total_pages' => $total_pages, 'test' => $test, 'totalCourse' => $totalCourse, 'coursependding' => $coursependding, 'courseactive' => $courseactive, 'coursestart' => $coursestart, 'coursecomplete' => $coursecomplete, 'Lectures' => $Lectures, 'TraineeUser' => $TraineeUser, 'TrainerUser' => $TrainerUser, 'sum' => $sum, 'imgoverview' => $imgoverview, 'runningCourse' => $runningCourse, 'courseTrainer' => $resultTrainer, 'courseTrainee' => $result, 'courseLecture' => $courseLecture, 'courseTest' => $courseTest, 'lectureSchedule' => $lectureSchedule)); // $this->render($view,array('courseTrainee'=>$courseTrainee, 'courseLecture'=>$courseLecture, 'courseTest'=>$courseTest,'lectureSchedule'=>$lectureSchedule)); } } }
<?php echo $form->textArea($model, 'address', array('size' => 60, 'maxlength' => 255, 'class' => 'form-control')); ?> <?php echo $form->error($model, 'address'); ?> </td> </tr> <tr> <td width="130"><?php echo $form->labelEx($model, 'supervisor_code'); ?> </td> <td style="padding-bottom: 10px;"> <?php echo $form->dropDownList($model, 'supervisor_code', CHtml::listData(WUser::model()->findAll('status=:status and user_group_id=:group_id', array(':status' => 1, ':group_id' => 3)), "username", "fullname"), array('class' => 'form-control')); ?> <?php echo $form->error($model, 'supervisor_code'); ?> </td> </tr> <tr> <td width="130"><?php echo $form->labelEx($model, 'time_startwork'); ?> </td> <td style="padding-bottom: 10px;"> <?php echo $form->textField($model, 'time_startwork', array('size' => 50, 'maxlength' => 50, 'class' => 'form-control')); ?>
public static function getUserByUsername($username) { return WUser::model()->find('username=:username', array(':username' => $username)); }
public function actionRspass() { // thu vien mail Yii::import('application.extensions.phpmailer.JPhpMailer'); $check_date = ''; // check login if (!empty(Yii::app()->user->id)) { $this->redirect(Yii::app()->createurl('')); } $page = 0; if (!empty($_REQUEST['acc']) && !empty($_REQUEST['token'])) { $username_var = trim($_REQUEST['acc']); $username_var = str_replace(array(',', "'", '"', ' ', '%'), '', $username_var); $token_string = trim($_REQUEST['token']); $token_string = str_replace(array(',', "'", '"', ' ', '%'), '', $token_string); //check token $criteria = new CDbCriteria(); $criteria->select = array('*'); $criteria->addCondition('user_name= "' . $username_var . '" AND token_check="' . $token_string . '"'); $check_token = WUserLosePass::model()->find($criteria); $check_token = CJSON::decode(CJSON::encode($check_token)); if (empty($check_token)) { $check_date = 'Chuỗi kick hoạt không đúng ! bạn vui lòng sử dụng đúng URL trong Email !'; } else { $date_now = date('Y-m-d'); //get id lost $criteria = new CDbCriteria(); $criteria->select = array('*'); $criteria->addCondition('user_name= "' . $username_var . '"'); $get_lost_id = WUserLosePass::model()->findAll($criteria); $get_lost_id = CJSON::decode(CJSON::encode($get_lost_id)); $criteria = new CDbCriteria(); $criteria->select = array('*'); $criteria->addCondition('user_name= "' . $username_var . '" AND end_time_change >= "' . $date_now . '"'); $data_lost = WUserLosePass::model()->findAll($criteria); $data_lost = CJSON::decode(CJSON::encode($data_lost)); //check user $criteria = new CDbCriteria(); $criteria->select = array('*'); $criteria->addCondition('username= "******"'); $data = WUser::model()->find($criteria); $data = CJSON::decode(CJSON::encode($data)); if (empty($data_lost)) { // var_dump($data_lost); $check_date = 'Quá hạn kich hoạt email!'; } if (empty($check_date) && !empty($data)) { if (!empty($_REQUEST['password'])) { $pass_new = CFunction::encrypt($_REQUEST['password'], Yii::app()->params->hashkey); $model = WUserUpdate::model()->find('id=' . $data['id']); $model->password = $pass_new; if ($model->save()) { if ($get_lost_id) { foreach ($get_lost_id as $key => $value) { $id = $value['id']; $this->loadModel($id)->delete(); } } $this->render('success_change_pass'); $page = 1; } } } } } if ($page == 0) { $dataProvider = new CActiveDataProvider('WUserLosePass'); $this->render('lostpass', array('dataProvider' => $dataProvider, 'check_date' => $check_date)); } }