public static function get_day_timeunits($date, $user = null)
{
global $DB;
$courts = Court::get_all();
$sql = '
SELECT
*
FROM timeunits
WHERE
date=:date
ORDER BY `date`, `from`
';
$sth = $DB->prepare($sql);
$sth->bindParam(':date', $date, PDO::PARAM_STR);
$sth->execute();
$timeunits = array();
foreach ($sth->fetchAll() as $tmp) {
$timeunit = new TimeUnit($tmp, false);
$timeunit->user = $user;
if (!is_array($timeunits[$timeunit->court_id])) {
$timeunits[$timeunit->court_id] = array();
}
$timeunits[$timeunit->court_id][] = $timeunit;
}
$ret = array();
$ret['date'] = $date;
$ret['fields'] = array();
$i = 0;
foreach ($courts as $court) {
$j = 0;
$ret['fields'][$i] = array();
$ret['fields'][$i]['id'] = $court->id;
$ret['fields'][$i]['title'] = $court->name;
$ret['fields'][$i]['subtitle'] = $court->subtitle;
$ret['fields'][$i]['intervals'] = array();
if (is_array($timeunits[$court->id])) {
foreach ($timeunits[$court->id] as $timeunit) {
$ret['fields'][$i]['intervals'][$j] = $timeunit->get_array();
$j++;
}
}
$i++;
}
return $ret;
}
