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,
    ];
  }

  public function dadosDashboardPrestador(): array
  {
    $user = Auth::user();
    $provider = Provider::where('user_id', $user->id)->first();

    $headerBar = [
      'rating' => $provider->average_rating,
      'total_ratings' => Review::where('reviews.origin', 'client')->leftJoin('schedules', 'schedules.id', '=', 'reviews.schedule_id')->where('schedules.provider_id', $provider->id)->count(),
      'total_services' => $provider->total_services,
    ];

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

    $priceSuggestedAvg = Provider::where('user_id', '!=', $user->id)
      ->whereNotNull('daily_price_8h')
      ->pluck('daily_price_8h')
      ->avg();

    $priceActual = $provider->daily_price_8h;

    $priceSuggested = [
      'average_price' => $priceSuggestedAvg,
      'your_price' => $priceActual,
    ];

    $solicitations = Schedule::where('schedules.provider_id', $provider->id)
      ->where('schedules.status', 'pending')
      ->leftJoin('clients', 'clients.id', '=', 'schedules.client_id')
      ->leftJoin('users as client_user', 'client_user.id', '=', 'clients.user_id')
      ->select(
        // bairro
        'schedules.id',
        'client_user.name as client_name',
        'clients.average_rating',
        'schedules.date',
        DB::raw("TO_CHAR(schedules.date, 'DD/MM/YYYY') as formatted_date"),
        'schedules.start_time',
        'schedules.end_time',
        'schedules.total_amount',
        'schedules.period_type',
        'schedules.schedule_type',
      )
      ->orderBy('schedules.date', 'asc')
      ->get();

    $nextSchedules = Schedule::where('schedules.provider_id', $provider->id)
      ->whereIn('schedules.status', ['accepted', 'paid'])
      ->leftJoin('clients', 'clients.id', '=', 'schedules.client_id')
      ->leftJoin('users as client_user', 'client_user.id', '=', 'clients.user_id')
      ->leftJoin('custom_schedules', 'custom_schedules.schedule_id', '=', 'schedules.id')
      ->select(
        'schedules.id',
        'client_user.name as client_name',
        'schedules.date',
        'schedules.start_time',
        'schedules.end_time',
        'schedules.total_amount',
        'schedules.period_type',
        'schedules.schedule_type',
        'custom_schedules.offers_meal'
        // bairro
      )
      ->orderBy('schedules.date', 'asc')
      ->get();

    $opportunities = Schedule::where('schedules.schedule_type', 'custom')
      ->where('schedules.status', 'pending')
      ->leftJoin('clients', 'clients.id', '=', 'schedules.client_id')
      ->leftJoin('users as client_user', 'client_user.id', '=', 'clients.user_id')
      ->select(
        'schedules.id',
        'client_user.name as client_name',
        'clients.average_rating',
        'schedules.date',
        'schedules.start_time',
        'schedules.end_time',
        'schedules.period_type',
        'schedules.schedule_type',
      )
      ->orderBy('schedules.date', 'asc')
      ->get();

    $opportunities = $opportunities->map(function ($item) use ($provider) {
      $price = 0;
      switch ($item->period_type) {
        case 2:
          $price = $provider->daily_price_2h;
          break;
        case 4:
          $price = $provider->daily_price_4h;
          break;
        case 6:
          $price = $provider->daily_price_6h;
          break;
        case 8:
          $price = $provider->daily_price_8h;
          break;
      }
      $item->total_amount = $price;
      return $item;
    });

    return [
      'headerBar' => $headerBar,
      'summaryInfos' => $summaryInfos,
      'priceSuggested' => $priceSuggested,
      'solicitations' => $solicitations,
      'nextSchedules' => $nextSchedules,
      'opportunities' => $opportunities,
    ];
  }
}