public function index(Request $request)
{
$mark = Mark::get();
if ($request->isMethod('get')) {
$this->data['items'] = $mark;
return view('pages.mark.index', $this->data);
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$marks = Mark::create(['exam_id' => $request->exam_id, 'student_id' => $request->student_id, 'obt_marks' => $request->obt_marks]);
$exams = Exam::find($request->exam_id);
$students = Student::find($request->student_id);
$marks->exams()->save($exams);
$marks->students()->save($students);
return redirect('principal/create#mark-tab')->withInput();
}
public function showProfile($userid)
{
$user = User::where("alphaid", "=", $userid);
if (!$user->exists()) {
abort(404);
}
$user = $user->first();
$favorites = Mark::where("username", "=", $user->alphaid)->orderBy("created_at", "desc")->get();
$uploads = Sprite::where("username", "=", $user->alphaid)->orderBy("created_at", "desc")->get();
return view("user/show", ["username" => $user->username, "name" => $user->name, "about" => $user->about, "favorites" => $favorites, "uploads" => $uploads, "creation" => $user->created_at, "modification" => $user->updated_at]);
}
public function detail($id, $userid)
{
$this->data['user'] = User::find($userid);
$this->data['marks'] = Mark::where('userid', $userid)->get();
return view('pages.viewmark.detail', $this->data);
}
return view('site.mail');
});
Route::get('privacidade', function () {
return view('site.privacidade');
});
/**
* API
*/
Route::get('api/users', ['middleware' => 'cors', function () {
return \Response::json(\App\User::get(), 200);
}]);
Route::get('api/markers', ['middleware' => 'cors', function () {
return \Response::json(\App\Mark::get(), 200);
}]);
Route::post('api/markers', ['middleware' => 'cors', function () {
return \Response::json(\App\Mark::get(), 200);
}]);
Route::get('api/contributors', ['middleware' => 'cors', function () {
return \Response::json(\App\Contributor::get(), 200);
}]);
Route::get('api/posts', ['middleware' => 'cors', function () {
return \Response::json(\App\Posts::get(), 200);
}]);
Route::get('api/news', ['middleware' => 'cors', function () {
return \Response::json(\App\Posts::get(), 200);
}]);
Route::post('oauth/access_token', function () {
return Response::json(Authorizer::issueAccessToken());
});
Route::get('email', function () {
Mail::raw('Novo voluntário cadastrado', function ($m) {
public function unfavorite($spriteid, Request $request)
{
if ($request->input("t") == csrf_token()) {
$favorite = Mark::where("alphaid", "=", $spriteid)->where("username", "=", Auth::user()->alphaid);
if ($favorite->exists()) {
$favorite->first()->delete();
}
} else {
abort(403);
}
return redirect()->back();
}
public function getMarkViews()
{
// $stdInfo=Students::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class','=',$cid)->first();
$stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('st_id', '=', Auth::user()->uid)->first();
$stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name');
//return $stdInof->class;
$showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get();
$showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->select('exam_name')->distinct()->get();
// $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->first();
//return $showAllMark->sub_mark;
$allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $stdInfo->roll)->where('class_id', '=', $stdInfo->class)->get();
return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName);
}
public function yes($id, $userid)
{
if (Request::isMethod('get')) {
//cek event aktif, anaknya bukan, udah pernah ngisi belum, kadept bukan
if (Auth::user()->positionid != 1) {
$user = User::find($userid);
// dd($user->deptid);
if ($user->deptid != Auth::user()->deptid) {
return redirect('/');
}
$data = Event::where('enabled', 1)->find($id);
if (!$data) {
return redirect('/');
}
if (!$data->enabled) {
return redirect('/');
}
$cek = Flag::where('eventid', $id)->where('from', '!=', $userid)->where('to', $userid)->first();
if ($cek != null) {
return redirect('/');
}
$this->data['event'] = $data;
$this->data['questions'] = Pivot::where('eventid', $id)->get();
return view('pages.submit.yes', $this->data);
} else {
return redirect('/');
}
} else {
$input = Input::get('score');
$data = Event::where('enabled', 1)->find($id);
if (!$data) {
return redirect('/');
}
if (!$data->enabled) {
return redirect('/');
}
// dd($input);
//set ke mark
foreach ($input as $key => $value) {
$mark = new Mark();
$mark->userid = $userid;
$mark->questionid = $key;
$mark->string = $value;
$mark->save();
}
//set ke score
$score = Score::where('eventid', $id)->where('userid', $userid)->first();
if ($score) {
foreach ($input as $key => $value) {
$question = Question::find($key);
if ($question->type == 1) {
$pivot = Pivot::where('eventid', $id)->where('questionid', $key)->first();
$score->score += $value * $pivot->score / 100;
$score->save();
}
}
} else {
$score = new Score();
$score->eventid = $id;
$score->userid = $userid;
$score->score = 0;
foreach ($input as $key => $value) {
$question = Question::find($key);
// dd($input);
if ($question->type == 1) {
$pivot = Pivot::where('eventid', $id)->where('questionid', $key)->first();
$score->score += $value * $pivot->score / 100;
$score->save();
}
}
}
//set ke flag
$flag = new Flag();
$flag->from = Auth::id();
$flag->to = $userid;
$flag->eventid = $id;
$flag->save();
return redirect('submit/' . $id);
}
}
public function getMarkViews($roll, $cid)
{
$stdInfo = Students::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class', '=', $cid)->first();
$stdClass = ClassAdd::where('class_id', '=', $stdInfo->class)->pluck('class_name');
$showAllMark = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get();
$showAllMarkExamName = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->select('exam_name')->distinct()->get();
// $showAllMarkExamName=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->first();
//return $showAllMark->sub_mark;
$allGrad = GradeSystem::where('institute_code', '=', Auth::user()->institute_id)->get();
$MarkViewGrade = Mark::where('institute_code', '=', Auth::user()->institute_id)->where('roll', '=', $roll)->where('class_id', '=', $cid)->get();
/* foreach ($allGrad as $key => $value) {
//return $MarkViewGrade->sub_mark;
$MarkViewGrade=Mark::where('institute_code','=',Auth::user()->institute_id)->where('roll','=', $roll)->where('class_id','=',$cid)->get();
//return $MarkViewGrade;
foreach ($MarkViewGrade as $key => $markget) {
// return $value->mark_form;
if ($markget->sub_mark>=$value->mark_form && $markget->sub_mark<=$value->mark_upto) {
$point=$value->grade_point ;
$grade=$value->grade_name ;
return view('admin.resultMark.markviews')->with('stdInfo',$stdInfo)->with('stdClass',$stdClass)
->with('showAllMark',$showAllMark)->with('MarkViewGrade',$MarkViewGrade)->with('allGrad',$allGrad)->with('point',$point)->with('grade',$grade);
}
else {
return 2 ;
}
}
}*/
// return $point.$grade;
return view('admin.resultMark.markviews')->with('stdInfo', $stdInfo)->with('stdClass', $stdClass)->with('showAllMark', $showAllMark)->with('MarkViewGrade', $MarkViewGrade)->with('allGrad', $allGrad)->with('showAllMarkExamName', $showAllMarkExamName);
}
public function delete($id)
{
$mark = Mark::findOrFail($id);
$mark->delete();
}
