iao_team/app/Http/Livewire/AbsenceReport.php

<?php

namespace App\Http\Livewire;

use Illuminate\Support\Carbon;
use Livewire\Component;

class AbsenceReport extends Component
{

    public $records;
    public $record_assenze;

    public $fiscalStartMonth = 9;
    public $year;

    public function mount()
    {
        setlocale(LC_ALL, 'it_IT');
    }

    public function render()
    {
        setlocale(LC_ALL, 'it_IT');

        $this->record_assenze = [];

        $today = now();
        $this->year = ($today->month >= $this->fiscalStartMonth) ? $today->year : $today->year - 1;

        $dayMap = [
            'lun' => 1,
            'mar' => 2,
            'mer' => 3,
            'gio' => 4,
            'ven' => 5,
            'sab' => 6,
            'dom' => 0,
        ];

        try {
            $courses = \App\Models\Course::whereDate('date_from', '<=', now())
                ->whereDate('date_to', '>=', now())
                ->where('active', true)
                ->where('enabled', true)
                ->get();

            $limit = now()->endOfDay();

            foreach ($courses as $course) {
                $course_members = \App\Models\MemberCourse::join('members', 'member_id', 'members.id')
                    ->where('course_id', $course->id)
                    ->where(function($query) {
                        $query->where('members.is_archived', false);
                        $query->orWhereNull('members.is_archived');
                    })
                    ->where(function($query) {
                        $query->where('members.is_deleted', false);
                        $query->orWhereNull('members.is_deleted');
                    })
                    ->get();

                $courseCalendars = \App\Models\Calendar::where('course_id', $course->id)->where('from', '<=', $limit)->get();

                $calendarIndex = [];
                foreach ($courseCalendars as $cal) {
                    $key = $cal->from . '|' . $cal->to;
                    $calendarIndex[$key] = $cal;
                }

                $memberIds = $course_members->pluck('member_id')->unique()->values();

                $presences = \App\Models\Presence::whereIn('calendar_id', $courseCalendars->pluck('id'))->whereIn('member_id', $memberIds)->get();

                $presenceIndex = [];
                foreach ($presences as $p) {
                    $presenceIndex[$p->member_id . '|' . $p->calendar_id] = true;
                }

                $this->record_assenze[$course->id] = [
                    'course' => $course,
                    'members' => [],
                ];

                foreach ($course_members as $course_member) {
                    $this->record_assenze[$course->id]['members'][$course_member->id] = [
                        'member' => $course_member->member,
                        'count'  => 0,
                        'dates'  => [],
                    ];

                    $months = array_column(
                        array_filter(json_decode($course_member->months, true), fn($m) => $m['status'] != 2),
                        'm'
                    );
                    sort($months);

                    $when = json_decode($course_member->when, true);

                    $memberCalendars = [];

                    foreach ($when as $period) {
                        $days = $period['day'];

                        if (!$days) {
                            continue;
                        }

                        $fromTime = $period['from'];
                        $toTime   = $period['to'];

                        $ranges = $this->generateFiscalDateRanges($months, $days, $dayMap, $fromTime, $toTime);

                        foreach ($ranges as $range) {
                            $key = $range['from']->toDateTimeString() . '|' . $range['to']->toDateTimeString();

                            if (isset($calendarIndex[$key])) {
                                $memberCalendars[] = $calendarIndex[$key];
                            }
                        }
                    }

                    usort($memberCalendars, fn($a, $b) => $b->to <=> $a->to);

                    foreach ($memberCalendars as $calendar) {
                        $pKey = $course_member->member_id . '|' . $calendar->id;

                        $hasPresence = isset($presenceIndex[$pKey]);

                        if (!$hasPresence) {
                            $this->record_assenze[$course->id]['members'][$course_member->id]['count']++;
                            $this->record_assenze[$course->id]['members'][$course_member->id]['dates'][] = [
                                'calendar_id' => $calendar->id,
                                'date' => Carbon::parse($calendar->from)->translatedFormat('d/m'),
                            ];
                        } else {
                            break;
                        }
                    }

                    if ($this->record_assenze[$course->id]['members'][$course_member->id]['count'] < 2) {
                        unset($this->record_assenze[$course->id]['members'][$course_member->id]);
                    }
                }

                if (empty($this->record_assenze[$course->id]['members'])) {
                    unset($this->record_assenze[$course->id]);
                } else {
                    $members = $this->record_assenze[$course->id]['members'];
                    usort($members, function ($a, $b) {
                        if ($a['count'] !== $b['count']) {
                            return $b['count'] <=> $a['count'];
                        }

                        $last = strcmp($a['member']->last_name, $b['member']->last_name);
                        if ($last !== 0) {
                            return $last;
                        }

                        return strcmp($a['member']->first_name, $b['member']->first_name);
                    });
                    $this->record_assenze[$course->id]['members'] = $members;
                }
            }
        } catch (\Throwable $e) {
            dd($e->getMessage());
        }

        // $this->records = [];

        // $to = date("Y-m-d 23:59:59");
        // $calendars = \App\Models\Calendar::where('from', '<=', $to)->orderBy('from')->get();

        // $month = date("n");
        // $this->year = ($month >= 9) ? date("Y") : date("Y") - 1;

        // $start = date("Y-m-d H:i:s", mktime(0, 0, 0, 9, 1, $this->year));
        // $end   = date("Y-m-d 23:59:59");

        // $calendars = \App\Models\Calendar::whereBetween('from', [$start, $end])->orderBy('from')->get();

        // foreach ($calendars as $calendar) {

        //     $presences = \App\Models\Presence::where('calendar_id', $calendar->id)->where('status', '<>', 99);
        //     $presences = $presences->pluck('member_id')->toArray();
        //     $presences_annullate = \App\Models\Presence::where('calendar_id', $calendar->id)->where('status', 99)->pluck('member_id')->toArray();

        //     $days = ['dom', 'lun', 'mar', 'mer', 'gio', 'ven', 'sab'];
        //     $dow = date('w', strtotime($calendar->from));
        //     $d = $days[$dow];

        //     $h = date('H:i', strtotime($calendar->from));

        //     // Elenco corsi per tipologia in base al calendario
        //     $courses = \App\Models\Course::where('name', $calendar->name)->where('date_from', '<=', $calendar->from)->where('date_to', '>=', $calendar->to);
        //     $courses = $courses->pluck('id')->toArray();

        //     $months = date("n", strtotime($calendar->from));

        //     // Elenco utenti iscritti al corso "padre"
        //     $members = \App\Models\MemberCourse::where('when', 'like', "%" . $d . "%")
        //         ->where('when', 'like', '%"from":"' . $h . '"%')
        //         ->whereNot('months', 'like', '%"m":' . $months . ',"status":2%')
        //         ->whereDate('date_from', '<=', $calendar->from)
        //         ->whereDate('date_to', '>=', $calendar->from)
        //         ->whereIn('course_id', $courses)
        //         ->orderBy('member_id')
        //         ->get();
        //     //$members = \App\Models\MemberCourse::where('when', 'like', "%" . $d . "%")->where('when', 'like', '%"from":"' . $h . '"%')->whereIn('member_id', $presences)->whereIn('course_id', $courses)->get();
        //     foreach ($members as $member) {

        //         $presence = \App\Models\Presence::where('member_id', $member->member->id)->where('calendar_id', $calendar->id)->first();

        //         if (!in_array($member->member->id, $presences)) {
        //             if (!in_array($member->member->id, $presences_annullate)) {
        //                 if (array_key_exists($member->member->id, $this->records)) {
        //                     $this->records[$member->member->id]['total'] += 1;
        //                     $this->records[$member->member->id]['date'] .= " - " . date("d/m", strtotime($calendar->from));
        //                 } else
        //                     $this->records[$member->member->id] = array("last_name" => $member->member->last_name, "first_name" => $member->member->first_name, "course" => $calendar->name, "total" => 1, "date" => date("d/m", strtotime($calendar->from)));
        //             }
        //         } else {
        //             if (array_key_exists($member->member->id, $this->records))
        //                 unset($this->records[$member->member->id]);
        //         }
        //     }
        // }

        // array_multisort(array_column($this->records, 'total'), SORT_DESC, $this->records);

        return view('livewire.absence_report');
    }

    protected function generateFiscalDateRanges($months, $days, $dayMap, $fromTime, $toTime)
    {
        $limit = now()->endOfDay();

        $today = $limit;

        $startYear = ($today->month >= $this->fiscalStartMonth) ? $today->year : $today->year - 1;

        $allowedDow = collect($days)
            ->map(fn($d) => $dayMap[$d] ?? null)
            ->filter(fn($v) => $v !== null)
            ->unique()
            ->values();

        $fromCarbon = Carbon::parse($fromTime);
        $toCarbon = Carbon::parse($toTime);

        $fromHour = $fromCarbon->hour;
        $fromMinute = $fromCarbon->minute;
        $fromSecond = $fromCarbon->second;

        $toHour = $toCarbon->hour;
        $toMinute = $toCarbon->minute;
        $toSecond = $toCarbon->second;

        $ranges = [];

        foreach ($months as $month) {
            $yearForMonth = ($month >= $this->fiscalStartMonth)
                ? $startYear
                : $startYear + 1;

            if (
                $yearForMonth > $limit->year ||
                ($yearForMonth === $limit->year && $month > $limit->month)
            ) {
                continue;
            }

            $firstOfMonth = Carbon::create($yearForMonth, $month, 1)->startOfDay();

            foreach ($allowedDow as $dow) {
                $offset  = ($dow - $firstOfMonth->dayOfWeek + 7) % 7;
                $current = $firstOfMonth->copy()->addDays($offset);

                while ($current->month === $month) {
                    $fromDateTime = $current->copy()->setTime($fromHour, $fromMinute, $fromSecond);
                    $toDateTime   = $current->copy()->setTime($toHour, $toMinute, $toSecond);

                    if ($fromDateTime->gt($limit)) {
                        break;
                    }

                    $ranges[] = [
                        'from' => $fromDateTime,
                        'to'   => $toDateTime,
                    ];

                    $current->addWeek();
                }
            }
        }

        usort($ranges, fn($a, $b) => $a['from'] <=> $b['from']);

        return $ranges;
    }
}