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