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); }
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 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); }