public function resetpwd()
{
Fn::ajax_call($this, 'login', 'logout');
$hash = $this->input->get('code');
$uid = email_hash('decode', $hash, 1800);
$uid && ($student = StudentModel::get_student($uid));
if (!$student) {
message('重置链接已失效，请重新提交申请', 'student/index/forget');
}
if ($this->input->post('act') == 'submit') {
$password = $this->input->post('password');
$newpwd_confirm = $this->input->post('password_confirm');
if (is_string($passwd_msg = is_password($password))) {
message($passwd_msg);
}
if ($password != $newpwd_confirm) {
message('您两次输入密码不一致，返回请确认！');
}
$this->db->update('student', array('password' => my_md5($password)), array('uid' => $uid));
$now_time = time() - 1800;
$sql = "UPDATE {pre}user_resetpassword SET expiretime='{$now_time}' WHERE uid='{$uid}' and hash = '{$hash}'";
$row = $this->db->query($sql);
message('您的新密码已设置成功.', 'student/index/login', 'success');
} else {
$data = array();
$data['uinfo'] = StudentModel::studentLoginUInfo();
$data['hash'] = $hash;
// 模版
$this->load->view('index/resetpwd', $data);
}
}
$comment = "Your alert is not activated.";
}
} else {
$status = "error";
$comment = "Wrong verification code. We can't remove your email address.";
}
}
} elseif ($cmd == "add") {
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$status = "error";
$comment = "Your email address is invalid.";
} else {
$sqlstr = "select ID, Email, Enabled, UpdateTime from useralert where LOWER(email)='{$email}'";
$result = mysqli_query($conni, $sqlstr);
if (mysql_num_rows($result) == 0) {
$hash = email_hash($email);
$curtime = date("Y-m-d H:i:s");
$sqlstr = "insert into useralert (Email, Type, Enabled, Hash, CreateTime, UpdateTime) VALUES ('{$email}', 'boot;', FALSE, '{$hash}', '{$curtime}', '{$curtime}')";
mysqli_query($conni, $sqlstr);
$status = "info";
$comment = "A confirmation email has been sent to your email address. Please click on the Activation Link to activate your alert.";
exec("python {$PythonPath} mail {$email} verify > /dev/null &");
} else {
$row = mysqli_fetch_array($result);
if ($row['Enabled'] == true) {
$status = "error";
$comment = "The email address has already been used.";
} else {
$UpdateTime = new DateTime($row['UpdateTime']);
$UpdateTime->modify("+3 minutes");
$curtime = new DateTime();
public function submit()
{
Fn::ajax_call($this, 'logout');
$uid = $this->_uinfo['uid'];
if ($uid or !$this->session->userdata('complete')) {
// 已注册，或未填写完整信息。跳转到报名信息复核页面
redirect('student/profile/preview');
}
// 读取sesseion数据
$student = $this->session->userdata('student');
$score_ranks = $this->session->userdata('score_ranks');
$awards_list = $this->session->userdata('awards_list');
$practice = $this->session->userdata('practice');
$student_wish = $this->session->userdata('student_wish');
$parent_wish = $this->session->userdata('parent_wish');
$xuekao_xuankao = $this->session->userdata('xuekao_xuankao');
$student['source_from'] = 3;
//普通注册
// 检查email是否已注册
$query = $this->db->select('uid')->get_where('student', array('email' => $student['email']), 1);
if ($query->num_rows()) {
message('Email地址已被注册！');
}
// 如果上传图片，转移图片
if ($student['picture']) {
$new_picture = 'uploads/student/' . date('Ym') . '/' . basename($student['picture']);
if (my_copy($student['picture'], $new_picture, TRUE)) {
$student['picture'] = $new_picture;
}
}
if (!is_array($awards_list)) {
$awards_list = array();
}
$new_awards_list = array();
foreach ($awards_list as $type_id => $type_list) {
$new_awards_list = array_merge($new_awards_list, $type_list);
}
$extends = array('score_ranking' => &$score_ranks, 'awards_list' => &$new_awards_list, 'practice' => &$practice, 'student_wish' => &$student_wish, 'parent_wish' => &$parent_wish, 'xuekao_xuankao' => &$xuekao_xuankao);
//补充学生的所在区域
$school_id = $student['school_id'];
if ($school_id) {
$school = Fn::db()->fetchRow("select province,city,area from rd_school where school_id={$school_id}");
} else {
$school = array();
}
$student['province'] = isset($school['province']) ? $school['province'] : 0;
$student['city'] = isset($school['city']) ? $school['city'] : 0;
$student['area'] = isset($school['area']) ? $school['area'] : 0;
//将学校名称移除
if (isset($student['school_name'])) {
unset($student['school_name']);
}
if (isset($student['external_account'])) {
$student_ticket = $student['external_account'];
}
$result = StudentModel::add($student, $extends);
if ($result['success'] == false) {
message($result['msg']);
}
$uid = $result['uid'];
$exam_ticket = $result['exam_ticket'];
$student_base = $this->session->userdata('student_base');
$student1 = array();
//$student1['school_id'] = $student_base['school_id'];
$student1['address'] = $student_base['address'];
$student1['zipcode'] = $student_base['zipcode'];
$sbinfo = array();
$sbinfo['sb_addr_provid'] = $student_base['sb_addr_provid'];
$sbinfo['sb_addr_cityid'] = $student_base['sb_addr_cityid'];
$sbinfo['sb_addr_areaid'] = $student_base['sb_addr_areaid'];
$sbinfo['sb_addr_desc'] = $student_base['sb_addr_desc'];
// 培训机构、培训课程、授课教师
$sbcinfo = array();
$sbcinfo['no_tiid'] = $student_base['no_tiid'];
$sbcinfo['sbc_tiid'] = $student_base['sbc_tiid'];
$sbcinfo['ti_name'] = $student_base['ti_name'];
$sbcinfo['sbc_corsid'] = $student_base['sbc_corsid'];
$sbcinfo['cors_cmid'] = $student_base['cors_cmid'];
$sbcinfo['cors_name'] = $student_base['cors_name'];
$sbcinfo['sbc_teachers'] = $student_base['sbc_teachers'];
$sbs_stunumtype = $student_base['sbs_stunumtype'];
if (!is_array($sbs_stunumtype)) {
$sbs_stunumtype = array();
}
$sbclassid_classid = $student_base['sbclassid_classid'];
if (!is_array($sbclassid_classid)) {
$sbclassid_classid = array();
}
$db = Fn::db();
$bOk = false;
try {
if ($db->beginTransaction()) {
$db->update('rd_student', $student1, "uid = {$uid}");
//$db->delete('t_student_base', "sb_uid = $uid");
$sbinfo['sb_uid'] = $uid;
$db->insert('t_student_base', $sbinfo);
//$db->delete('t_student_base_classid', "sbclassid_uid = $uid");
foreach ($sbclassid_classid as $v) {
$db->insert('t_student_base_classid', array('sbclassid_uid' => $uid, 'sbclassid_classid' => $v));
}
//$db->delete('t_student_base_stunumtype', "sbs_uid = $uid");
foreach ($sbs_stunumtype as $v) {
$db->insert('t_student_base_stunumtype', array('sbs_uid' => $uid, 'sbs_stunumtype' => $v));
}
//$db->delete('t_student_base_course', 'sbc_uid = ' . $uid);
if (empty($sbcinfo['no_tiid'])) {
$now_time = time();
if (!$sbcinfo['sbc_tiid']) {
$row = array('ti_name' => $sbcinfo['ti_name'], 'ti_typeid' => 1, 'ti_flag' => $now_time, 'ti_priid' => 0, 'ti_provid' => $sbinfo['sb_addr_provid'], 'ti_cityid' => $sbinfo['sb_addr_cityid'], 'ti_areaid' => $sbinfo['sb_addr_areaid'], 'ti_addtime' => date('Y-m-d H:i:s', $now_time), 'ti_adduid' => 1);
$db->insert('t_training_institution', $row);
$ti_id = $db->lastInsertId('t_training_institution', 'ti_id');
$sbcinfo['sbc_tiid'] = $ti_id;
}
if (!$sbcinfo['sbc_corsid']) {
if ($sbcinfo['cors_cmid'] != 1) {
$sbcinfo['cors_cmid'] = 2;
}
$row = array('cors_name' => $sbcinfo['cors_name'], 'cors_cmid' => $sbcinfo['cors_cmid'], 'cors_flag' => $now_time, 'cors_tiid' => $sbcinfo['sbc_tiid'], 'cors_stunumtype' => $sbcinfo['cors_cmid'], 'cors_addtime' => date('Y-m-d H:i:s', $now_time), 'cors_adduid' => 1);
$db->insert('t_course', $row);
$cors_id = $db->lastInsertId('t_course', 'cors_id');
$sbcinfo['sbc_corsid'] = $cors_id;
}
$db->insert('t_student_base_course', array('sbc_uid' => $uid, 'sbc_idx' => 0, 'sbc_tiid' => $sbcinfo['sbc_tiid'], 'sbc_corsid' => $sbcinfo['sbc_corsid'], 'sbc_teachers' => $sbcinfo['sbc_teachers']));
}
$bOk = $db->commit();
if (!$bOk) {
$err = $db->errorInfo()[2];
$db->rollBack();
//message($err);
}
}
if (!$bOk) {
//message('执行事务处理失败');
}
} catch (Exception $e) {
//message($e->getMessage());
}
StudentModel::studentAjaxLogin(array('ticket' => $exam_ticket, 'password' => $student['password']), true);
// 清除其他session
$unset_items = array('student' => '', 'student_base', 'score_ranks' => '', 'awards_list' => '', 'practice' => '', 'student_wish' => '', 'parent_wish' => '', 'xuekao_xuankao' => '', 'complete' => '');
$this->session->unset_userdata($unset_items);
// 发送邮件
$email_tpl = C('email_template/register');
$mail = array('student' => $student, 'hash' => email_hash('encode', $uid));
send_email($email_tpl['subject'], $this->load->view($email_tpl['tpl'], $mail, TRUE), $student['email']);
// 成功信息显示
$data['student'] = $student;
$data['exam_ticket'] = $result['exam_ticket'];
$line_width = array(1, 2, 3, 4, 4, 5, 5, 6, 7, 8);
$data['line_width'] = $line_width;
$this->_uinfo = StudentModel::studentLoginUInfo();
$data['uinfo'] = $this->_uinfo;
// 模版
$this->load->view('profile/success', $data);
}
