<?php

Prado::using('Application.facades.Facade');
Prado::using('Application.dto.EventDTO');
Prado::using('Application.dto.GridEventDTO');
Prado::using('Application.dto.CalendarGridDTO');
Prado::using('Application.model.Calendar');
Prado::using('Application.facades.CalendarFacade');
Prado::using('Application.user.DbUser');

class EventFacade extends Facade {

    public function getEventList(string $dateFrom=NULL, string $dateTo=NULL,
                                 array $calendars=NULL, string $order='ASC') {
        $calendarClause = '1=1';
        if ($calendars) {
            $calendarClause = sprintf(
                '_calendar IN (%s)',
                implode(
                    ',',
                    array_map(
                        function($calendar) {
                            return $this->quoteString($calendar->UID);
                        },
                        $calendars
                    )
                )
            );
        }
        return $this->fetchList(
            'getEvents',
            [
                'date_from' => $dateFrom ?: '0000-00-00 00:00:00',
                'date_to' => $dateTo ?: '9999-99-99',
                'calendar_clause' => $calendarClause,
                'order_clause' => $order
            ]
        );
    }

    public function getTimeframeListForUser(DbUser $user,
                                            DateTime $dateFrom,
                                            DateTime $dateTo) {
        $calendars = CalendarFacade::getInstance()->getCalendarPreference($user);
        if ($calendars) {
            $events = $this->getEventList(
                $dateFrom->format('Y-m-d H:i:s'),
                $dateTo->format('Y-m-d H:i:s'),
                $calendars
            );
            $calendars = $this->_getCalendarsForEvents($events);
            return array_map(
                function($event) use($calendars) {
                    $dto = new EventDTO();
                    $dto->loadRecord($event, $calendars);
                    return $dto;
                },
                $events
            );
        }
        return [];
    }

    private function _getCalendarsForEvents(array $events) {
        if ($events) {
            return Calendar::finder()->findAllByPks(
                array_map(
                    function($event) {
                        return $event->CalendarID;
                    },
                    $events
                )
            );
        }
        return [];
    }

}

?>