<?


namespace App\Services\D0;

use App\Models\Client;
use Illuminate\Support\Facades\DB;

use App\Models\SchedulingHours;


class D0DatailsService
{

    public function hundle($id)
    {
        $client = Client::find($id);

        $agendamentos = DB::connection('smartsafe')->table('d0_scheduled_hours as dsh')
            ->join('clients as c', 'c.id', '=', 'dsh.client_id')
            ->join('d0_available_scheduling_workdays as dasw', 'dsh.scheduled_weekday_number', '=', 'dasw.weekday_number')
            ->select('dsh.scheduled_hour', 'dsh.scheduled_weekday_number', 'dasw.name', 'c.name', 'dsh.id', 'dsh.active')
            ->where('c.id', $id)
            ->get();

        // Organizar por dias da semana
        $semana = [
            1 => 'Segunda',
            2 => 'Terça',
            3 => 'Quarta',
            4 => 'Quinta',
            5 => 'Sexta',

        ];

        $agenda = [];

        foreach ($semana as $numero => $nome) {
            $agenda[$nome] = $agendamentos->where('scheduled_weekday_number', $numero)->map(function ($agendamento) {
                return [
                    'id' => $agendamento->id,
                    'hora' => $agendamento->scheduled_hour,
                    'active' => $agendamento->active
                ];
            });
        }


        return $agenda;

    }
}