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