/**
* @param $quizz
* @param $question
*/
public function storeUnansweredQuestion($quizz, $question)
{
$score = new Score();
$score->user()->associate(Auth::user());
$score->quizz()->associate($quizz);
$score->question()->associate($question);
$score->setAttribute('answer_id', null);
$score->setAttribute('already_answered', false);
$score->setAttribute('correct', null);
$score->save();
}
public function addScore($license, $points)
{
$lic = License::whereLicense($license)->first();
if ($lic == null) {
return new JsonResponse(['Licentie bestaat niet, heeft u zich aangemeld?'], 200);
}
$score = new Score();
$score->license = $license;
$score->score = $points;
$score->save();
return new JsonResponse(['Gelukt'], 200);
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$user = new User();
$user->fill($request->all());
$user->status_level = 0;
$user->password = \Hash::make($request->password);
$user->save();
$scores = new Score();
$scores->user_id = $user->id;
$scores->value = 0;
$scores->save();
\Mail::send('emails.new_user', ['user' => $user], function ($message) use($user) {
$message->to("*****@*****.**", $user->name)->subject(trans('emails.new_user_title'));
});
\Auth::attempt(array('email' => $request->email, 'password' => $request->password));
return redirect()->intended('/profile');
}
private function _users()
{
$provinces = Province::all();
foreach ($provinces as $p) {
$faker = \Faker\Factory::create();
$user = new User();
$user->name = $faker->name;
$user->province_id = $p->id;
$user->email = $faker->email;
$user->password = Hash::make('123456');
$user->save();
$license = License::where('used', 0)->first();
$license->used = 1;
$license->save();
$license->user()->attach($user);
$score = new Score();
$score->score = rand(100, 3500);
$score->license = $license->license;
$score->save();
}
}
/**
* 显示可录入成绩学生名单
* @author FuRongxin
* @date 2016-03-19
* @version 2.0
* @param string $kcxh 12位课程序号
* @return \Illuminate\Http\Response 学生名单
*/
public function edit($kcxh)
{
$course = Mjcourse::whereNd(session('year'))->whereXq(session('term'))->whereKcxh($kcxh)->firstOrFail();
$task = Task::whereKcxh($kcxh)->whereNd(session('year'))->whereXq(session('term'))->whereJsgh(Auth::user()->jsgh)->firstOrFail();
$ratios = [];
$items = Ratio::whereFs($task->cjfs)->orderBy('id')->get();
foreach ($items as $ratio) {
$ratios[] = ['id' => $ratio->id, 'name' => $ratio->idm, 'value' => $ratio->bl];
}
$exists = Score::whereNd(session('year'))->whereXq(session('term'))->whereKcxh($course->kcxh)->whereTjzt(config('constants.score.uncommitted'))->exists();
$statuses = Status::orderBy('dm')->get()->filter(function ($status) {
return config('constants.score.deferral') != $status->dm && config('constants.score.retake') != $status->dm;
});
$noScoreStudents = Selcourse::whereNd(session('year'))->whereXq(session('term'))->whereKcxh($kcxh)->whereNotExists(function ($query) {
$query->from('cj_web')->whereRaw('t_cj_web.nd = t_xk_xkxx.nd AND t_cj_web.xq = t_xk_xkxx.xq AND t_cj_web.kcxh = t_xk_xkxx.kcxh AND t_cj_web.xh = t_xk_xkxx.xh');
})->get();
if (count($noScoreStudents)) {
foreach ($noScoreStudents as $student) {
$score = new Score();
$score->xh = $student->xh;
$score->xm = $student->xm;
$score->kcxh = $student->kcxh;
$score->kcpt = $student->pt;
$score->kcxz = $student->xz;
$score->xl = $student->xl;
$score->nd = $student->nd;
$score->xq = $student->xq;
$score->kh = $course->plan->kh;
$score->zpcj = 0;
$score->kszt = 0;
// 考试状态：正常
$score->zy = $student->zy;
$score->tjzt = 0;
// 提交状态：未提交
$score->kkxy = $student->kkxy;
for ($i = 1; $i <= 6; ++$i) {
$score->{'cj' . $i} = 0;
}
$score->save();
}
}
$scoreNoStudents = Score::whereNd(session('year'))->whereXq(session('term'))->whereKcxh($kcxh)->whereNotExists(function ($query) {
$query->from('xk_xkxx')->whereRaw('t_xk_xkxx.nd = t_cj_web.nd AND t_xk_xkxx.xq = t_cj_web.xq AND t_xk_xkxx.kcxh = t_cj_web.kcxh AND t_xk_xkxx.xh = t_cj_web.xh');
})->select('nd', 'xq', 'xh', 'kcxh')->get();
if (count($scoreNoStudents)) {
foreach ($scoreNoStudents as $student) {
$student->delete();
}
}
$students = Score::with('status')->wherend(session('year'))->whereXq(session('term'))->whereKcxh($kcxh)->orderBy('xh')->get();
$title = $course->college->mc . $course->nd . '年度' . $course->term->mc . '学期' . $course->kcxh . $course->plan->course->kcmc . '课程';
return view('score.edit')->withTitle($title . '成绩录入')->withRatios($ratios)->withStudents($students)->withCourse($course)->withExists($exists)->withStatuses($statuses);
}
