public function update()
{
//implement new state answered
$data = Questions::find(Input::get("id"));
if (!$data || !Auth::check()) {
return "not found";
}
$validator = Validator::make(['title' => Input::get("title")], ['title' => 'max:255']);
if ($validator->fails()) {
return "i wanna more";
}
if (Input::get("title") != "") {
$data->title = Input::get("title");
}
if (Input::get("question") != "") {
$data->question = Input::get("question");
}
if (Input::get("status") != "") {
$data->status = Input::get("status");
}
if (Input::get("state") != "") {
$state = Classif::where('name', 'PARAGRAPH_STATE')->where('code', Input::get("state"))->first();
if ($state->id) {
$data->cid = $state->id;
}
$data->save();
return $state;
}
$data->save();
//return redirect("/question/$data->title/$data->id"); //maybe dynamic insert without refresh
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$id = $request->input('parentID');
$questions = Questions::find($id);
$comment = new Comment();
$comment->body = $request->input('comment');
$comment->user_id = Auth::id();
$questions->comments()->save($comment);
echo $comment;
}
public function update($QuestionID)
{
$question = Questions::find($QuestionID);
$old_subquestions = Subquestions::where('QuestionID', '=', $QuestionID)->get()->toArray();
foreach ($old_subquestions as $value) {
SubquestionsController::destroy($value['id']);
}
$data = Request::capture()->all();
$count = $data['numAnswer'];
for ($i = 0; $i < $count; $i++) {
$subQ = $data['answer' . ($i + 1)];
$SubQuestionID = DB::table('subquestions')->insertGetId(['QuestionID' => $QuestionID, 'Question' => $subQ, 'created_at' => new \DateTime(), 'updated_at' => new \DateTime()]);
$answer = new Answers();
$answer->SubQuestionID = $SubQuestionID;
$answer->Detail = $data['ta_answer' . ($i + 1)];
$answer->Logical = 1;
$answer->save();
}
return redirect(route('user.viewquestion', $QuestionID));
}
public function update($QuestionID)
{
$question = Questions::find($QuestionID);
$old_subquestions = Subquestions::where('QuestionID', '=', $QuestionID)->get()->toArray();
foreach ($old_subquestions as $value) {
SubquestionsController::destroy($value['id']);
}
$request = Request::capture();
$data = $request->all();
$count = $data['numAnswer'];
for ($i = 1; $i <= $count; $i++) {
$subQ = $data['answer' . $i];
$SubQuestionID = DB::table('subquestions')->insertGetId(['QuestionID' => $QuestionID, 'Question' => $subQ, 'created_at' => new \DateTime(), 'updated_at' => new \DateTime()]);
$file = $request->file('subquestion_photo_' . $i);
if ($file != null) {
$sq = Subquestions::orderBy('id', 'desc')->first();
$sq->Photo = 'Subquestion_' . $QuestionID . '_' . $SubQuestionID . "_-Evangels-English-www.evangelsenglish.com_" . "." . $file->getClientOriginalExtension();
$file->move(base_path() . '/public/images/imageSubquestion/', $sq->Photo);
$sq->update();
}
$answer = new Answers();
$answer->SubQuestionID = $SubQuestionID;
$answer->Detail = $data['ta_answer' . $i];
$answer->Logical = 1;
$answer->save();
if ($request->hasFile('answer_photo_' . $i) && $request->file('answer_photo_' . $i)->isValid()) {
$a = Answers::orderBy('id', 'desc')->first();
$file = $request->file('answer_photo_' . $i);
if ($file != null) {
$a->Photo = 'Answer_SQ_' . $SubQuestionID . '_' . $a->id . "_-Evangels-English-www.evangelsenglish.com_" . "." . $file->getClientOriginalExtension();
$file->move(base_path() . '/public/images/imageAnswer/', $a->Photo);
$a->update();
}
}
}
return redirect(route('user.viewquestion', $QuestionID));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($QuestionID)
{
if (!AuthController::checkPermission()) {
return redirect('/');
}
$Answers = Answers::where('QuestionID', '=', $QuestionID)->get();
foreach ($Answers as $answer) {
$answer['Detail'] = $this->s2c_convert($answer['Detail']);
}
$question = Questions::find($QuestionID)->toArray();
switch ($question['FormatID']) {
case 1:
$view = 'admin.editanswer';
break;
case 6:
$view = 'admin.editdragdropanswer';
break;
default:
$view = 'admin.editanswer';
break;
}
$photo = $question['Photo'];
return view($view)->with(['PostID' => $question['PostID'], "QuestionID" => $QuestionID, 'Answers' => $Answers, 'Photo' => $photo]);
}
public static function destroy($id)
{
if (!AuthController::checkPermission()) {
return redirect('/');
}
$question = Questions::find($id);
@unlink(public_path('images/imageQuestion/' . $question['Photo']));
$postid = $question['PostID'];
$format = $question['FormatID'];
switch ($format) {
case 1:
case 6:
$answers = Answers::where('QuestionID', '=', $id)->get()->toArray();
foreach ($answers as $answer) {
AnswersController::destroy($answer['id']);
}
break;
case 2:
$spaces = Spaces::where('QuestionID', '=', $id)->get()->toArray();
foreach ($spaces as $value) {
SpacesController::destroy($value['id']);
}
break;
case 3:
$answers = Answers::where('QuestionID', '=', $id)->get()->toArray();
foreach ($answers as $answer) {
AnswersController::destroy($answer['id']);
}
break;
case 4:
$answers = Answers::where('QuestionID', '=', $id)->get()->toArray();
foreach ($answers as $answer) {
AnswersController::destroy($answer['id']);
}
break;
case 5:
$subq = Subquestions::where('QuestionID', '=', $id)->get()->toArray();
foreach ($subq as $s) {
SubquestionsController::destroy($s['id']);
}
}
$question->delete();
return redirect(route('user.viewpost', $postid));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public static function destroy($id)
{
if (!AuthController::checkPermission()) {
return redirect('/');
}
$question = Questions::find($id);
@unlink(public_path('images/imageQuestion/' . $question['Photo']));
$postid = $question['PostID'];
$format = Posts::find($postid)['FormatID'];
if ($format == 1) {
$answers = Answers::where('QuestionID', '=', $id)->get()->toArray();
foreach ($answers as $answer) {
Answers::destroy($answer['id']);
}
} else {
if ($format == 2) {
$spaces = Spaces::where('QuestionID', '=', $id)->get()->toArray();
foreach ($spaces as $value) {
SpacesController::destroy($value['id']);
}
}
}
$question->delete();
return redirect(route('user.viewpost', $postid));
}
public function getQuestion($id)
{
$question = Questions::find($id);
return $question->question_name;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($QuestionID)
{
if (!AuthController::checkPermission()) {
return redirect('/');
}
$Answers = Answers::where('QuestionID', '=', $QuestionID)->get();
foreach ($Answers as $answer) {
$answer['Detail'] = $this->s2c_convert($answer['Detail']);
}
$question = Questions::find($QuestionID)->toArray();
$photo = $question['Photo'];
return view('admin.editanswer')->with(['PostID' => $question['PostID'], "QuestionID" => $QuestionID, 'Answers' => $Answers, 'Photo' => $photo]);
}
/**
*
* Get single question page
**/
public function getSingleQuestionPage($id)
{
$question = Questions::find($id);
$quiz = QuestionCategories::where('question_id', '=', $id)->get()->first();
$is_answered = count(Answers::where('question_id', '=', $id)->get());
if ($is_answered > 0) {
$is_answered = true;
} else {
$is_answered = false;
}
if (count($question) > 0) {
return view('admin.single-question')->with(['quiz' => $quiz, 'question' => $question, 'is_answered' => $is_answered]);
}
}