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