Lines n/a 0 / 0
Functions and Methods n/a 0 / 0
Classes and Traits n/a 0 / 0
Name Lines Functions and Methods CRAP Classes and Traits
Calendar n/a 0 / 0 n/a 0 / 0 0 n/a 0 / 0
1<?php
2
3namespace BO\Zmsbackend\Calendar\Repository;
4
5/**
6 *
7 * Calculate Slots for available booking times
8 */
9class Calendar extends \BO\Zmsbackend\Query\Base
10{
11    const string QUERY_CALENDAR_BOOKABLEEND = "
12        SELECT 
13            MAX(CONCAT(slot.year, '-', LPAD(slot.month, 2, '0'), '-', LPAD(slot.day, 2, '0'))) as bookableEnd
14        FROM
15            calendarscope c
16            LEFT JOIN slot USING(scopeID)
17        WHERE
18            slot.status = 'free'
19        ;
20    ";
21}