sfp_api_laravel_serprati/app/Http/Controllers/ReportController.php

<?php

namespace App\Http\Controllers;

use App\Exports\ContatosAssociadosExport;
use App\Exports\ExclusoesMesExport;
use App\Exports\NovoAssociadosExport;
use App\Exports\UsosConvenioExport;
use App\Services\ReportService;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
use Symfony\Component\HttpFoundation\BinaryFileResponse;

class ReportController extends Controller
{
    public function __construct(protected ReportService $service) {}

    public function getCounters(): JsonResponse
    {
        return $this->successResponse(payload: $this->service->getCounters());
    }

    public function getNovoAssociadosPaginated(Request $request): JsonResponse
    {
        $filters   = $request->only(['search']);
        $perPage   = min((int) $request->get('per_page', 10), 100);
        $paginator = $this->service->getNovoAssociadosPaginated($filters, $perPage);

        return $this->successResponse(payload: [
            'data'  => array_map(
                fn($u) => [
                    'id'         => $u->id,
                    'name'       => $u->name,
                    'cpf'        => $u->cpf,
                    'created_at' => $u->created_at?->format('d/m/Y'),
                ],
                $paginator->items()
            ),
            'total' => $paginator->total(),
            'from'  => $paginator->firstItem() ?? 0,
            'to'    => $paginator->lastItem() ?? 0,
        ]);
    }

    public function getContatosAssociadosPaginated(Request $request): JsonResponse
    {
        $filters   = $request->only(['search']);
        $perPage   = min((int) $request->get('per_page', 10), 100);
        $paginator = $this->service->getContatosAssociadosPaginated($filters, $perPage);

        return $this->successResponse(payload: [
            'data'  => array_map(
                fn($u) => [
                    'id'    => $u->id,
                    'name'  => $u->name,
                    'phone' => $u->phone,
                    'email' => $u->email,
                ],
                $paginator->items()
            ),
            'total' => $paginator->total(),
            'from'  => $paginator->firstItem() ?? 0,
            'to'    => $paginator->lastItem() ?? 0,
        ]);
    }

    public function getExclusoesMesPaginated(Request $request): JsonResponse
    {
        $filters   = $request->only(['search']);
        $perPage   = min((int) $request->get('per_page', 10), 100);
        $paginator = $this->service->getExclusoesMesPaginated($filters, $perPage);

        return $this->successResponse(payload: [
            'data'  => array_map(
                fn($u) => [
                    'id'          => $u->id,
                    'name'        => $u->name,
                    'cpf'         => $u->cpf,
                    'excluded_at' => $u->excluded_at?->format('d/m/Y'),
                ],
                $paginator->items()
            ),
            'total' => $paginator->total(),
            'from'  => $paginator->firstItem() ?? 0,
            'to'    => $paginator->lastItem() ?? 0,
        ]);
    }

    public function getUsosConvenioPaginated(Request $request): JsonResponse
    {
        $filters   = $request->only(['search']);
        $perPage   = min((int) $request->get('per_page', 10), 100);
        $paginator = $this->service->getUsosConvenioPaginated($filters, $perPage);

        return $this->successResponse(payload: [
            'data'  => array_map(
                fn($a) => $this->service->formatUsoConvenio($a),
                $paginator->items()
            ),
            'total' => $paginator->total(),
            'from'  => $paginator->firstItem() ?? 0,
            'to'    => $paginator->lastItem() ?? 0,
        ]);
    }

    public function exportNovoAssociados(Request $request): BinaryFileResponse
    {
        $filename = 'novos_associados_' . now()->format('d-m-Y') . '.xlsx';
        return Excel::download(new NovoAssociadosExport($request->get('search')), $filename);
    }

    public function exportContatosAssociados(Request $request): BinaryFileResponse
    {
        $filename = 'contatos_associados_' . now()->format('d-m-Y') . '.xlsx';
        return Excel::download(new ContatosAssociadosExport($request->get('search')), $filename);
    }

    public function exportExclusoesMes(Request $request): BinaryFileResponse
    {
        $filename = 'exclusoes_mes_' . now()->format('d-m-Y') . '.xlsx';
        return Excel::download(new ExclusoesMesExport($request->get('search')), $filename);
    }

    public function exportUsosConvenio(Request $request): BinaryFileResponse
    {
        $filename = 'usos_convenio_' . now()->format('d-m-Y') . '.xlsx';
        return Excel::download(new UsosConvenioExport($this->service, $request->get('search')), $filename);
    }
}