<?php

namespace ChurchCRM\model\ChurchCRM;

use ChurchCRM\dto\KioskAssignmentTypes;
use ChurchCRM\model\ChurchCRM\Base\KioskAssignment as BaseKioskAssignment;
use ChurchCRM\model\ChurchCRM\Map\ListOptionTableMap;
use Propel\Runtime\ActiveQuery\Criteria;
use Propel\Runtime\ActiveQuery\Join;
use Propel\Runtime\Collection\ArrayCollection;

/**
 * Skeleton subclass for representing a row from the 'kioskassginment_kasm' table.
 *
 * You should add additional methods to this class to meet the
 * application requirements.  This class will only be generated as
 * long as it does not already exist in the output directory.
 */
class KioskAssignment extends BaseKioskAssignment
{
    private function getActiveEvent(): ?Event
    {
        if ($this->getAssignmentType() == KioskAssignmentTypes::EVENTATTENDANCEKIOSK) {
            return EventQuery::create()
            ->filterByStart('now', Criteria::LESS_EQUAL)
            ->filterByEnd('now', Criteria::GREATER_EQUAL)
            ->filterById($this->getEventId())
            ->findOne();
        } else {
            throw new \Exception('This kiosk does not support group attendance');
        }
    }

    public function getActiveGroupMembers()
    {
        if ($this->getAssignmentType() == KioskAssignmentTypes::EVENTATTENDANCEKIOSK) {
            // Get the event's linked groups
            $event = $this->getEvent();
            $groups = $event->getGroups();
            
            if ($groups->count() === 0) {
                // No groups linked to this event - return empty collection
                return new ArrayCollection();
            }
            
            // Get the first linked group for role list
            $firstGroup = $groups->getFirst();
            
            $groupTypeJoin = new Join();
            $groupTypeJoin->addCondition('Person2group2roleP2g2r.RoleId', 'list_lst.lst_OptionId', Join::EQUAL);
            $groupTypeJoin->addForeignValueCondition('list_lst', 'lst_ID', '', $firstGroup->getRoleListId(), Join::EQUAL);
            $groupTypeJoin->setJoinType(Criteria::LEFT_JOIN);

            return PersonQuery::create()
                ->joinWithPerson2group2roleP2g2r()
                ->usePerson2group2roleP2g2rQuery()
                    ->filterByGroup($groups)
                    ->joinGroup()
                    ->addJoinObject($groupTypeJoin)
                ->addAsColumn('RoleName', ListOptionTableMap::COL_LST_OPTIONNAME)
                ->endUse()
                    ->leftJoin('EventAttend')
                    ->addAsColumn('status', '(CASE WHEN event_attend.event_id is not null AND event_attend.checkout_date IS NULL then 1 else 0 end)')
                ->orderByLastName()
                ->orderByFirstName()
                ->find();
        } else {
            throw new \Exception('This kiosk does not support group attendance');
        }
    }
}
