/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $answers = Answer::all(); return $this->respond(['data' => $this->AnswerTransformer->transformCollection($answers->toArray())]); }
public function getHotAnswer() { $request = Request::capture(); $token = $request->input('token'); $questionId = $request->input('questionId'); $answersQuery = Answer::select('id', 'answer_brief', 'answer_time', 'question_id', 'user_id', 'is_resolved')->where('question_id', $questionId); $answerIds = $answersQuery->lists('id')->toArray(); $upAnswers = AnswerUp::select('answer_id', DB::raw('count(*) as up_number'))->whereIn('answer_id', $answerIds)->groupBy('answer_id')->orderBy('up_number', 'desc')->take(2); // print_r($upAnswers->lists('answer_id')->toArray()); $answersQuery = Answer::select('id', 'answer_brief', 'answer_time', 'question_id', 'user_id', 'is_resolved')->where('question_id', $questionId)->whereIn('id', $upAnswers->lists('answer_id')->toArray()); $answers = $answersQuery->get()->toArray(); $upNumber = $upAnswers->get()->toArray(); $result = array(); foreach ($answers as $an) { foreach ($upNumber as $up) { if ($up['answer_id'] == $an['id']) { $an = array_merge($an, ['upNumber' => $up['up_number']]); array_push($result, $an); } } } return Utility::response_format(Utility::RESPONSE_CODE_SUCCESS, $result, '请求成功'); }