/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(QuestionRequest $request)
{
$this->askQuestion($request);
$question = Questions::where('question', $request->input('question'))->get();
$count = Questions::where('question', $request->input('question'))->count();
flash('Your Question Has Been Posted');
return redirect(action('QuestionsController@show', $question[$count - 1]->slug));
}
public function get_all_questions()
{
$questions = Questions::where('questions.id', '>', 0)->leftJoin('answers', 'questions.id', '=', 'answers.question_id')->selectRaw('questions.*, count(answers.id) as total_answers')->groupBy('questions.id')->orderBy('questions.created_at', 'dec')->get();
if (count($questions) > 0) {
return $questions;
} else {
return "";
}
}
public function index()
{
if (Auth::check()) {
$data['questions'] = Questions::all();
} else {
$data['questions'] = Questions::where('status', '0002')->get();
}
return view('questions/questionsList', $data);
}
public function searchTag($tag)
{
if ($tag == "null") {
$view = QAController::index();
} else {
//Gathers Questions where the tags are alike with the tags given.
$questions = Questions::where('tags', 'LIKE', "%{$tag}%")->orderBy('id', 'desc')->paginate(10);
$questions->setPath('QA');
//creating view accordingly attaching questions that we have gathered with.
$view = view('QA.index')->with('questions', $questions);
}
//renders section in view and for ajax setting the related section(content).
$sections = $view->renderSections();
return $sections['content'];
}
public function adminViewCourse($courseid)
{
$course = Courses::find($courseid);
if (count($course) < 1) {
return view('errors.404');
}
// $result = array('Title' => $course['Title']);
$course = $course->toArray();
$posts = Posts::where('CourseID', '=', $courseid)->get()->toArray();
$numQuestions = [];
foreach ($posts as $p) {
$numQuestions += [$p['id'] => count(Questions::where('PostID', '=', $p['id'])->get()->toArray())];
}
$r = array('posts' => $posts);
$r += array('Title' => $course['Title']);
$r += array('NumQuestions' => $numQuestions);
$r += array('CourseID' => $courseid);
// return var_dump($r);
// dd($r);
return view('viewcourse', $r);
}
public static function destroy($id)
{
if (!AuthController::checkPermission()) {
return redirect('/');
}
$post = Posts::find($id);
@unlink(public_path('images/imagePost/' . $post['Photo']));
$questions = Questions::where('PostID', '=', $id)->get()->toArray();
foreach ($questions as $question) {
QuestionsController::destroy($question['id']);
}
$courseid = $post['CourseID'];
$post->delete();
$course = Courses::find($post->CourseID);
$course->NoOfPosts--;
$course->update();
return redirect(route('admin.viewcourse', $courseid));
}
