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