public function actionApply()
{
$trainId = Yii::$app->request->get('id');
$trainInfo = Train::findOne(['id' => $trainId]);
if ($trainInfo['status'] != Train::BEGIN_SIGN_UP) {
throw new ServerErrorHttpException('该课程的状态不是开始报名，谢谢。');
}
if (Yii::$app->user->isGuest) {
return $this->redirect(['/user/register', 'train_id' => $trainId]);
} else {
$userId = Yii::$app->user->id;
if (Yii::$app->user->identity->status != '1') {
throw new ServerErrorHttpException('您目前的状态是未审核，不能报名课程，谢谢。');
}
$trainLevelInfo = Level::findOne($trainInfo['level_id']);
if ($trainLevelInfo['order'] != Yii::$app->user->identity->level_order + 1) {
throw new ServerErrorHttpException('您目前没有权限报名该级别下的课程，谢谢。');
}
//检查用户参与的课程，状态不是取消的都算是已经参与了报名
$isExist = TrainUsers::getUserIsExistTrainStatus($userId, $trainInfo['level_id']);
if (!empty($isExist)) {
throw new ServerErrorHttpException('您已经参与了该级别下的培训课程，请耐心等待培训结果，谢谢。');
}
// if (strtotime($trainInfo['sign_up_begin_time']) < time()) {
// throw new ServerErrorHttpException('此课程已过期。');
// }
$noPassInfo = TrainUsers::findOne(['user_id' => Yii::$app->user->id, 'level_id' => Yii::$app->user->identity->level_id + 1, 'status' => TrainUsers::NO_PASS]);
if (!empty($noPassInfo)) {
$noPassTrainInfo = Train::findOne($noPassInfo['train_id']);
if (!empty($noPassTrainInfo)) {
if ($noPassTrainInfo['end_time'] > $trainInfo['begin_time']) {
throw new ServerErrorHttpException('训课课程的开课时间一定要大于未通过考试培训课程结束时间。');
}
}
}
//报名成功，给出用户的序号
$trainUsersOrder = TrainUsers::getMaxSignUpOrder($trainId);
if (empty($trainUsersOrder)) {
$trainUsersOrder = 1;
} else {
$trainUsersOrder = $trainUsersOrder + 1;
}
$data = ['train_id' => $trainId, 'user_id' => $userId, 'status' => TrainUsers::APPROVED, 'practice_score' => 0, 'theory_score' => 0, 'rule_score' => 0, 'level_id' => $trainInfo['level_id'], 'orders' => $trainUsersOrder];
$model = new TrainUsers();
$model->setAttributes($data);
if ($model->save()) {
$trainUserId = $model->id;
$trainUser = TrainUsers::findOne(['id' => $trainUserId]);
$trainName = Train::getOneTrainNameById($trainUser['train_id']);
$data = ['orders' => $trainUser['orders'], 'trainName' => $trainName];
//更新级别信息的信息
UsersLevel::updateAll(['train_id' => $trainId], ['user_id' => $userId, 'level_id' => Yii::$app->user->identity->level_id]);
return $this->render('/train/apply-success', ['data' => $data]);
} else {
throw new ServerErrorHttpException('' . json_encode($model->errors, JSON_UNESCAPED_UNICODE));
}
}
}
public function actionApply()
{
$activityId = Yii::$app->request->get('id');
$activityInfo = Activity::findOne(['id' => $activityId]);
if ($activityInfo['status'] != Activity::BEGIN_SIGN_UP) {
throw new ServerErrorHttpException('该活动的状态不是开始报名，谢谢。');
}
if (Yii::$app->user->isGuest) {
return $this->redirect(['/user/register', 'activity_id' => $activityId]);
} else {
$userId = Yii::$app->user->id;
$CredentialsNumber = UsersInfo::getCredentialsNumberByUserId($userId);
if (Yii::$app->user->identity->status != '1') {
throw new ServerErrorHttpException('系统错误,原因：您目前的状态是未审核，不能报名课程，谢谢。');
}
$activityLevelInfo = Level::findOne(['id' => $activityInfo['level_id']]);
if ($activityLevelInfo['order'] != Yii::$app->user->identity->level_order + 1) {
throw new ServerErrorHttpException('系统错误,原因：您目前没有权限报名该级别下的课程，谢谢。');
}
//检查用户参与的课程，状态不是取消的都算是已经参与了报名
$isExist = ActivityUsers::getUserIsExistActivityStatus($userId, $activityInfo['level_id']);
if (!empty($isExist)) {
throw new ServerErrorHttpException('系统错误,原因：您已经参与了该级别下的培训课程，请耐心等待培训结果，谢谢。');
}
//报名成功，给出用户的序号
$activityUsersOrder = ActivityUsers::getActivityUsersOrder($userId, $activityId);
if (empty($activityUsersOrder)) {
$activityUsersOrder = 1;
}
$transaction = Yii::$app->db->beginTransaction();
$data = ['activity_id' => $activityId, 'user_id' => $userId, 'status' => ActivityUsers::APPROVED, 'practice_score' => 0, 'theory_score' => 0, 'rule_score' => 0, 'level_id' => $activityInfo['level_id'], 'orders' => $activityUsersOrder];
$model = new ActivityUsers();
$model->setAttributes($data);
if ($model->save()) {
$activityUserId = $model->id;
$activityUser = ActivityUsers::findOne(['id' => $activityUserId]);
$activityName = Activity::getOneActivityNameById($activityUser['activity_id']);
$data = ['orders' => $activityUser['orders'], 'activityName' => $activityName];
//新增一条用户和级别对应的信息
$userLevelModel = new UsersLevel();
$userLevelModel->user_id = $userId;
$userLevelModel->activity_id = $activityId;
$userLevelModel->level_id = $activityInfo['level_id'];
$userLevelModel->credentials_number = $CredentialsNumber;
if (!$userLevelModel->save()) {
$transaction->rollBack();
throw new ServerErrorHttpException('更新状态错误，原因：' . json_encode($userLevelModel->errors, JSON_UNESCAPED_UNICODE) . '！');
} else {
$transaction->commit();
}
return $this->render('/activity/apply-success', ['data' => $data]);
} else {
throw new ServerErrorHttpException('系统错误,原因：' . json_encode($model->errors, JSON_UNESCAPED_UNICODE));
}
}
}
/**
* Updates an existing TrainUsers model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$trainInfo = Train::findOne(['id', $model->train_id]);
$sourceStatus = $model->status;
$userInfo = Users::findOne($model->user_id);
$model->userName = $userInfo['username'];
$model->trainName = $trainInfo->name;
$statusList[TrainUsers::SIGN] = ['list' => [TrainUsers::APPROVED => TrainUsers::$statusList[TrainUsers::APPROVED]]];
$statusList[TrainUsers::APPROVED] = ['list' => [TrainUsers::ENROLL => TrainUsers::$statusList[TrainUsers::ENROLL], TrainUsers::NO_APPROVED => TrainUsers::$statusList[TrainUsers::NO_APPROVED]]];
$statusList[TrainUsers::ENROLL] = ['list' => [TrainUsers::DOING => TrainUsers::$statusList[TrainUsers::DOING]]];
$statusList[TrainUsers::DOING] = ['list' => [TrainUsers::END => TrainUsers::$statusList[TrainUsers::END]]];
$statusList[TrainUsers::END] = ['list' => [TrainUsers::END => TrainUsers::$statusList[TrainUsers::END]]];
$statusList[TrainUsers::NO_APPROVED] = ['list' => [TrainUsers::APPROVED => TrainUsers::$statusList[TrainUsers::APPROVED]]];
$statusList[TrainUsers::CANCEL] = ['list' => [TrainUsers::CANCEL => TrainUsers::$statusList[TrainUsers::CANCEL]]];
$statusList[TrainUsers::PASS] = ['list' => [TrainUsers::PASS => TrainUsers::$statusList[TrainUsers::PASS]]];
$statusList[TrainUsers::NO_PASS] = ['list' => [TrainUsers::NO_PASS => TrainUsers::$statusList[TrainUsers::NO_PASS]]];
if (Yii::$app->request->isPost) {
$updateParams = Yii::$app->request->post();
$transaction = Yii::$app->db->beginTransaction();
if ($model->load($updateParams) && $model->save()) {
if ($updateParams['TrainUsers']['status'] == TrainUsers::END) {
//如果结束状态，必须评分
if ($sourceStatus == TrainUsers::END) {
$transaction->rollBack();
throw new ServerErrorHttpException('请提交不同的状态！');
}
if ($updateParams['TrainUsers']['practice_score'] <= 0 || $updateParams['TrainUsers']['theory_score'] <= 0 || $updateParams['TrainUsers']['rule_score'] <= 0) {
$transaction->rollBack();
throw new ServerErrorHttpException('每项评分都必须大于零！');
}
if ($updateParams['TrainUsers']['practice_score'] > 100 || $updateParams['TrainUsers']['theory_score'] > 100 || $updateParams['TrainUsers']['rule_score'] > 100) {
$transaction->rollBack();
throw new ServerErrorHttpException('每项评分都不能超过100分！');
}
//根据3个单项评分计算全部评价内容包括考勤
$result = $this->getSource($model->train_id, $model->user_id, $model->practice_score, $model->theory_score, $model->rule_score);
$model->score_appraise = $result['scoreAppraise'];
$model->appraise_result = $result['performance'];
$model->attendance_appraise = $result['attendanceComment'];
$model->practice_comment = $result['practiceComment'];
$model->theory_comment = $result['theoryComment'];
$model->rule_comment = $result['rulesComment'];
$model->total_comment = $result['commentAppraise'];
$model->result_comment = $result['scoreAppraise'];
$model->status = $result['status'];
if ($model->save()) {
//如果通过更新晋级信息
if ($model->status == TrainUsers::PASS) {
$trainCode = $trainInfo['code'];
$trainPeriodNum = $trainInfo['period_num'];
$levelInfo = Level::findOne($model->level_id);
$certificateNumber = $this->getCertificateNumber($trainCode, $trainPeriodNum, sprintf("%04d", $model->orders), $levelInfo['code']);
$res = UsersLevel::updateAll(['status' => 1, 'certificate_number' => $certificateNumber, 'update_time' => date('Y-m-d H:i:s', time()), 'update_user' => Yii::$app->admin->identity->username], ['user_id' => $model->user_id, 'train_id' => $model->train_id]);
if ($res) {
//通过发短信
$content = "您好，您的培训课程考试已经通过，请进入教练员管理系统-我的课程查看。【教练系统】";
$result = $this->sendMessage($content, Messages::TRAIN_PASS, $model->user_id, $userInfo['mobile_phone'], '1');
if ($result != '0') {
$transaction->rollBack();
throw new ServerErrorHttpException('' . $result . '！');
} else {
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
}
} else {
$transaction->rollBack();
throw new ServerErrorHttpException(json_encode($res, JSON_UNESCAPED_UNICODE) . '！');
}
} else {
UsersLevel::updateAll(['status' => UsersLevel::TRAIN_NO_PASS], ['user_id' => $userInfo['id'], 'train_id' => $model->train_id]);
//未通过发短信
$content = "尊敬的学员，您没有通过培训课程，谢谢！【教练系统】";
$result = $this->sendMessage($content, Messages::TRAIN_NO_PASS, $model->user_id, $userInfo['mobile_phone'], '1');
if ($result != '0') {
$transaction->rollBack();
throw new ServerErrorHttpException('' . $result . '！');
}
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
}
} else {
$transaction->rollBack();
throw new ServerErrorHttpException(json_encode($model->errors, JSON_UNESCAPED_UNICODE) . '！');
}
} else {
if ($updateParams['TrainUsers']['status'] == TrainUsers::ENROLL) {
if ($sourceStatus == TrainUsers::ENROLL) {
$transaction->rollBack();
throw new ServerErrorHttpException('请提交不同的状态！');
}
//录取发短信
$content = "您好，很高兴的通知您，您报名的培训班已通过审核，请按指定日期前往培训地点缴费上课。【教练系统】";
$result = $this->sendMessage($content, Messages::TRAIN_SIGN_SUCCESS, $model->user_id, $userInfo['mobile_phone'], '1');
if ($result != '0') {
$transaction->rollBack();
throw new ServerErrorHttpException('' . $result . '！');
}
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
} elseif ($updateParams['TrainUsers']['status'] == TrainUsers::NO_APPROVED) {
if ($sourceStatus == TrainUsers::NO_APPROVED) {
$transaction->rollBack();
throw new ServerErrorHttpException('请提交不同的状态！');
}
//未通过审核发短信
$content = "尊敬的学员，您没有通过培训课程审核，谢谢！【教练系统】";
$result = $this->sendMessage($content, Messages::TRAIN_SIGN_ERROR, $model->user_id, $userInfo['mobile_phone'], '1');
if ($result != '0') {
$transaction->rollBack();
throw new ServerErrorHttpException('' . $result . '！');
}
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
} elseif ($updateParams['TrainUsers']['status'] == TrainUsers::DOING) {
if ($sourceStatus == TrainUsers::DOING) {
$transaction->rollBack();
throw new ServerErrorHttpException('请提交不同的状态！');
}
//培训开始发短信
$content = "尊敬的学员您好，您已缴费成功，请根据课培训班的课程安排按时上下课，谢谢！【教练系统】";
$result = $this->sendMessage($content, Messages::TRAIN_DOING, $model->user_id, $userInfo['mobile_phone'], '1');
if ($result != '0') {
$transaction->rollBack();
throw new ServerErrorHttpException('' . $result . '！');
}
$transaction->commit();
return $this->redirect(['view', 'id' => $model->id]);
} else {
if ($updateParams['TrainUsers']['practice_score'] != 0 || $updateParams['TrainUsers']['theory_score'] != 0 || $updateParams['TrainUsers']['rule_score'] != 0) {
throw new ServerErrorHttpException('只有更新结束状态需要评分！');
}
$transaction->commit();
Yii::$app->getSession()->setFlash('success', '更新成功！');
return $this->redirect(['view', 'id' => $model->id]);
}
}
} else {
$transaction->rollBack();
throw new ServerErrorHttpException('' . json_encode($model->errors, JSON_UNESCAPED_UNICODE) . '！');
}
} else {
return $this->render('update', ['model' => $model, 'statusList' => $statusList]);
}
}
public function actionApply()
{
$trainId = Yii::$app->request->get('train_id');
$trainInfo = Train::findOne(['id' => $trainId]);
if ($trainInfo['status'] != Train::BEGIN_SIGN_UP) {
throw new ServerErrorHttpException('该课程的状态不是开始报名，谢谢。');
}
if (Yii::$app->user->isGuest) {
return $this->redirect(['/user/register', 'train_id' => $trainId]);
} else {
$userId = Yii::$app->user->id;
if (Yii::$app->user->identity->status != '1') {
throw new ServerErrorHttpException('您目前的状态是未审核，不能报名课程，谢谢。');
}
$trainLevelInfo = Level::findOne($trainInfo['level_id']);
if ($trainLevelInfo['order'] != Yii::$app->user->identity->level_order + 1) {
throw new ServerErrorHttpException('您目前没有权限报名该级别下的课程，谢谢。');
}
//检查用户参与的课程，状态不是取消，注册未完成，审核未通过，未通过的都算是已经参与了报名
$isExist = TrainUsers::getUserIsExistTrainStatus($userId, $trainInfo['level_id']);
if (!empty($isExist)) {
throw new ServerErrorHttpException('您已经参与了该级别下的培训课程，请耐心等待培训结果，谢谢。');
}
//报名成功，给出用户的序号
$trainUsersOrder = TrainUsers::getTrainUsersOrder($trainId);
if (empty($trainUsersOrder)) {
$trainUsersOrder = 1;
} else {
$trainUsersOrder = $trainUsersOrder + 1;
}
$transaction = Yii::$app->db->beginTransaction();
//如果用户未完成报名流程，更新状态为审核中
$isSignExist = TrainUsers::getUserIsExistTrainStatusSign($userId, $trainInfo['level_id']);
if (!empty($isSignExist)) {
TrainUsers::updateAll(['status' => TrainUsers::APPROVED], ['id' => $isSignExist['id']]);
$trainName = Train::getOneTrainNameById($isSignExist['train_id']);
$data = ['orders' => $isSignExist['orders'], 'trainName' => $trainName];
$transaction->commit();
return $this->render('/user/apply-success', ['data' => $data]);
} else {
//如果没有记录，新增一条
$data = ['train_id' => $trainId, 'user_id' => $userId, 'status' => TrainUsers::APPROVED, 'practice_score' => 0, 'theory_score' => 0, 'rule_score' => 0, 'level_id' => $trainInfo['level_id'], 'orders' => $trainUsersOrder];
$model = new TrainUsers();
$model->setAttributes($data);
if ($model->save()) {
$trainName = Train::getOneTrainNameById($model->train_id);
$data = ['orders' => $model->orders, 'trainName' => $trainName];
$transaction->commit();
return $this->render('/user/apply-success', ['data' => $data]);
} else {
throw new ServerErrorHttpException('系统错误,原因：' . json_encode($model->errors, JSON_UNESCAPED_UNICODE));
}
}
}
}
public function actionLevelUp()
{
$levelInfo = Level::findOne(['id' => Yii::$app->user->identity->level_id + 1]);
$usersLevel = UsersLevel::findOne(['user_id' => Yii::$app->user->id, 'level_id' => Yii::$app->user->identity->level_id]);
$usersLevelStatusCurrent = $usersLevel['status'];
if ($usersLevelStatusCurrent != UsersLevel::SEND_CARD) {
throw new ServerErrorHttpException('当前注册状态不符合！');
}
$loginDuration = Users::getLoginDuration(Yii::$app->user->id);
$loginDurationDiff = $levelInfo['login_duration'] - $loginDuration;
if ($loginDurationDiff > 0) {
throw new ServerErrorHttpException('当前注册时长不符合！');
}
$scoreDiff = $levelInfo['score'] - Yii::$app->user->identity->score;
if ($scoreDiff > 0) {
throw new ServerErrorHttpException('当前一般活动积分不符合！');
}
$creditDiff = $levelInfo['credit'] - Yii::$app->user->identity->credit;
if ($creditDiff > 0) {
throw new ServerErrorHttpException('当前公益活动积分不符合！');
}
$transaction = Yii::$app->db->beginTransaction();
UsersLevel::updateAll(['status' => UsersLevel::LEVEL_UP], ['user_id' => Yii::$app->user->id, 'level_id' => Yii::$app->user->identity->level_id]);
$userInfo = UsersInfo::findOne(['user_id' => Yii::$app->user->id]);
//新增一条用户和级别对应的信息
$userLevelModel = new UsersLevel();
$userLevelModel->user_id = Yii::$app->user->id;
$userLevelModel->level_id = Yii::$app->user->identity->level_id + 1;
$userLevelModel->credentials_number = $userInfo['credentials_number'];
$userLevelModel->district = $userInfo['account_location'];
$userLevelModel->receive_address = $userInfo['contact_address'];
$userLevelModel->postcode = $userInfo['contact_postcode'];
$userLevelModel->status = UsersLevel::NO_TRAIN;
if (!$userLevelModel->save()) {
$transaction->rollBack();
throw new ServerErrorHttpException('更新状态错误，原因：' . json_encode($userLevelModel->errors, JSON_UNESCAPED_UNICODE) . '！');
} else {
Users::updateAll(['level_id' => Yii::$app->user->identity->level_id + 1, 'level_order' => Yii::$app->user->identity->level_order + 1], ['id' => Yii::$app->user->id]);
$transaction->commit();
}
return $this->redirect('/user-center/index');
}
/**
* Finds the Level model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Level the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Level::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
