public function getdatas(Request $request) { $dateline = null; $data = null; $sort = Input::get("sort"); $filters = [Input::get("subject") ? Input::get("subject") : null, Input::get("chapter") ? Input::get("chapter") : null, Input::get("topic") ? Input::get("topic") : null, Input::get("rating") ? Input::get("rating") : null, Input::get("level") ? Input::get("level") : null, Input::get("type") ? Input::get("type") : null]; $activequestions = Question::where('type', '!=', 7)->active()->orderBy("created_at", "DESC"); //filter subject,chapter,topic if ($filters[2]) { $activequestions = $activequestions->where('topic_id', $filters[2]); } else { if ($filters[1]) { $activequestions = $activequestions->where('chapter_id', $filters[1]); } else { if ($filters[0]) { $activequestions = $activequestions->where('subject_id', $filters[0]); } } } //filter RATING if if ($filters[3]) { $activequestions = $activequestions->where('rating', $filters[3]); } //filter LEVEL if if ($filters[4]) { $activequestions = $activequestions->where('level', $filters[4]); } //filter TYPE if if ($filters[5]) { $activequestions = $activequestions->where('type', $filters[5]); } //get the query results $activequestions = $activequestions->get(); // if ($sort == "authorwise") { $data = $this->convertToAuthorwise($activequestions); $dateline = $this->getDateLine($activequestions); } else { if ($sort == "datewise") { $data = $this->convertToDatewise($activequestions); } else { $data = $this->convertToOverall($activequestions); $dateline = $this->getDateLine($activequestions); } } return view('superadmin.analytics')->with('questions', $data)->with('datelines', $dateline)->with('sort', $sort)->with('filters', $filters)->with('qtypes', \App\QuestionType::all())->with('subjects', Subject::all())->with('path', $request->path()); }
public function tobereviewedquestions(Request $req, $type = null) { // $type=$req->input('type',null); $qbCtrl = new QuestionBankController(); $selectedSubject = Input::get('subject') ? Subject::find(Input::get('subject')) : null; $selectedChapter = Input::get('chapter') ? Chapter::find(Input::get('chapter')) : null; $selectedTopic = Input::get('topic') ? Topic::find(Input::get('topic')) : null; $questions = []; if (!$type) { return redirect("/admin/question-reviews/new"); // $questions=Question::where('status','!=',1)->where('type','!=',7)->orderBy('created_at','DESC'); } else { if ($type == "rejected") { $questions = Question::where('type', '!=', 7)->rejected()->orderBy('created_at', 'DESC'); } else { if ($type == "new") { $questions = Question::where('type', '!=', 7)->notreviewed()->orderBy('created_at', 'DESC'); } else { if ($type == "accepted") { $questions = Question::where('type', '!=', 7)->active()->orderBy('created_at', 'DESC'); } else { if ($type == "edited") { $questions = Question::where('type', '!=', 7)->where('status', 3)->orderBy('created_at', 'DESC'); } } } } } if ($selectedTopic) { $questions = $questions->where("topic_id", $selectedTopic->id)->paginate(15); } else { if ($selectedChapter) { $questions = $questions->where("chapter_id", $selectedChapter->id)->paginate(15); } else { if ($selectedSubject) { $questions = $questions->where("subject_id", $selectedSubject->id)->paginate(15); } else { $questions = $questions->paginate(15); } } } return view('superadmin.review_question')->with('data', $questions)->with('type', $type)->with('subjects', Subject::all())->with('path', $req->path())->with('selected', [$selectedSubject, $selectedChapter, $selectedTopic]); }
public function getindex() { return view("superadmin.rqg", ["subjects" => Subject::all(), "chapters" => Chapter::all(), "topics" => Topic::all(), "modules" => Module::all()]); }