ldc-crm/app/Http/Controllers/Api/V2/StatsController.php

<?php

namespace App\Http\Controllers\Api\V2;

use App\Http\Controllers\Controller;
use App\Http\Requests\Api\V2\GetBrandStatsRequest;
use App\Http\Requests\Api\V2\GetQuestionStatsRequest;
use App\Http\Resources\Api\V2\BrandStatsResource;
use App\Http\Resources\Api\V2\QuestionStatsResource;
use App\Models\BrandStat;
use App\Models\CustomerAnswer;
use App\Models\Question;
use App\Models\Service;
use Illuminate\Http\Resources\Json\ResourceCollection;
use Illuminate\Support\Carbon;
use Illuminate\Support\Collection;

class StatsController extends Controller
{
    /**
     * Get specific brand statistics
     *
     * @param \App\Http\Requests\Api\V2\GetBrandStatsRequest $request
     * @param \App\Models\Service                            $service
     * @return \Illuminate\Http\Resources\Json\ResourceCollection
     */
    public function brandStats(GetBrandStatsRequest $request, Service $service): ResourceCollection
    {
        $stats = BrandStat::whereDate('created_at', '>=', $request->start)
            ->whereDate('created_at', '<=', $request->end)
            ->whereBrandId($service->brand->id)->get();
        return new BrandStatsResource($stats);
    }

    /**
     * Get statistics for a specific question
     *
     * @param \App\Http\Requests\Api\V2\GetQuestionStatsRequest $request
     * @param \App\Models\Question                              $question
     * @return \App\Http\Resources\Api\V2\QuestionStatsResource
     */
    public function questionStats(GetQuestionStatsRequest $request, Question $question): QuestionStatsResource
    {
        // * Make sure we are accessing a customer that belongs to our service.
        $this->authorize('questionBelongsToService', $question);

        $answers = $question->answers;
        $start   = Carbon::parse($request->start);
        $end     = Carbon::parse($request->end);

        return new QuestionStatsResource(
            $this->answersByDays($answers, $start, $end),
            $question
        );
    }

    /**
     * Total réponses par dates
     *
     * @param \Illuminate\Support\Collection $answers
     * @param \Illuminate\Support\Carbon     $start
     * @param \Illuminate\Support\Carbon     $end
     * @return \Illuminate\Support\Collection
     */
    private function answersByDays(Collection $answers, Carbon $start, Carbon $end): Collection
    {
        // * Totalize by date all answers.
        $answersByDays = CustomerAnswer::whereDate('created_at', '>=', $start)
            ->whereDate('created_at', '<=', $end)
            ->whereIn('answer_id', $answers->pluck('id'))
            ->get()->map(function ($custAnswer) {
                return [
                    'answer_id' => $custAnswer->answer_id,
                    'created_at' => $custAnswer->created_at->format('Y-m-d'),
                ];
            })->groupBy(['created_at', 'answer_id'])->map(function ($day) {
                return $day->map(function ($custAnswers) {
                    return $custAnswers->count();
                });
            });

        do {
            $currentDate = $start->format('Y-m-d');
            /** @var \Illuminate\Support\Collection $answersByDays */
            if (!$answersByDays->has($currentDate)) {
                $answersByDays->put(
                    $currentDate,
                    $answers->mapWithKeys(function ($answer) {
                        return [$answer->id => 0];
                    })
                );
            } else {
                $curentAnswers = $answersByDays->pull($currentDate);
                $answersByDays->put(
                    $currentDate,
                    $answers->mapWithKeys(function ($answer) use ($curentAnswers) {
                        return [$answer->id =>
                        $curentAnswers->has($answer->id) ?
                            $curentAnswers->get($answer->id) : 0];
                    })
                );
            }

            $start = $start->addDay();
        } while ($start->lessThanOrEqualTo($end));

        return $answersByDays;
    }
}