sfp_api_laravel_diarista/app/Services/DashboardService.php

<?php

namespace App\Services;

use App\Models\Address;
use App\Models\Client;
use App\Models\ClientFavoriteProvider;
use App\Models\Provider;
use App\Models\Review;
use App\Models\Schedule;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;

class DashboardService
{
  public function __construct() {}

  public function dadosDashboardCliente(): array
  {
    $user = Auth::user();
    $cliente = Client::where('user_id', $user->id)->first();
    $headerBar = [
      'rating' => $cliente->average_rating,
      'total_ratings' => Review::where('reviews.origin', 'provider')->leftJoin('schedules', 'schedules.id', '=', 'reviews.schedule_id')->where('schedules.client_id', $cliente->id)->count(),
      'total_services' => $cliente->total_services,
    ];

    $summaryInfos = [
      'name' => $user->name,
      'address' => Address::where('source', 'client')->where('source_id', $cliente->id)->first()->address ?? null,
      'pending_services' => Schedule::where('client_id', $cliente->id)->where('status', 'pending')->count(),
    ];

    $nextSchedules = Schedule::where('schedules.client_id', $cliente->id)
      ->whereIn('schedules.status', ['accepted', 'paid'])
      ->leftJoin('providers', 'providers.id', '=', 'schedules.provider_id')
      ->leftJoin('users as provider_user', 'provider_user.id', '=', 'providers.user_id')
      ->leftJoin('addresses', function ($join) {
        $join->on('addresses.source_id', '=', 'providers.id')
          ->where('addresses.source', 'provider');
      })
      ->where('schedules.date', '>=', now()->toDateString())
      ->select(
        'schedules.id',
        'provider_user.name as provider_name',
        'schedules.date',
        'schedules.start_time',
        'schedules.end_time',
        'schedules.total_amount',
        'schedules.period_type',
        'schedules.schedule_type',
        'addresses.address_type',
      )
      ->orderBy('schedules.date', 'asc')
      ->get();

    $lastDoneSchedules = Schedule::where('schedules.client_id', $cliente->id)
      ->where('schedules.status', 'finished')
      ->leftJoin('providers', 'providers.id', '=', 'schedules.provider_id')
      ->leftJoin('users as provider_user', 'provider_user.id', '=', 'providers.user_id')
      ->leftJoin('addresses', function ($join) {
        $join->on('addresses.source_id', '=', 'providers.id')
          ->where('addresses.source', 'provider');
      })
      ->select(
        'schedules.id',
        'provider_user.name as provider_name',
      )
      ->orderBy('schedules.date', 'desc')
      ->limit(5)
      ->get();

    $favoriteProviders = ClientFavoriteProvider::where('client_id', $cliente->id)
      ->leftJoin('providers', 'providers.id', '=', 'client_favorite_providers.provider_id')
      ->leftJoin('users as provider_user', 'provider_user.id', '=', 'providers.user_id')
      ->select(
        'providers.id',
        'provider_user.name as provider_name',
        'providers.average_rating',
      )
      ->get();

    $providersClose = Provider::leftJoin('users as provider_user', 'provider_user.id', '=', 'providers.user_id')
      ->leftJoin('addresses as provider_address', function ($join) {
        $join->on('provider_address.source_id', '=', 'providers.id')
          ->where('provider_address.source', 'provider');
      })
      ->leftJoin('addresses as client_address', function ($join) use ($cliente) {
          $join->where('client_address.source_id', $cliente->id)
              ->where('client_address.source', 'client');
      })
      ->whereColumn('provider_address.city_id', '=', 'client_address.city_id')
      ->select(
        'providers.id',
        'provider_user.name as provider_name',
        'provider_address.address_type', // refatorar para pegar o bairro
        'providers.average_rating',
        DB::raw("(SELECT COUNT(*) FROM reviews LEFT JOIN schedules ON schedules.id = reviews.schedule_id WHERE reviews.origin = 'provider' AND schedules.provider_id = providers.id) as total_reviews"),
        'providers.total_services',
        'providers.daily_price_8h',
      )
      ->get();

    return [
      'headerBar' => $headerBar,
      'summaryInfos' => $summaryInfos,
      'nextSchedules' => $nextSchedules,
      'lastDoneSchedules' => $lastDoneSchedules,
      'favoriteProviders' => $favoriteProviders,
      'providersClose' => $providersClose,
    ];
  }
}