function display_supporters ($dbh, $date, $start, $end, $fragment)
{
+ if ($start == "24:00") { $start = "23:59"; }
+ if ($end == "24:00") { $end = "23:59"; }
+
$query = sprintf ("SELECT name,starttime,endtime,person.oid FROM person,availability "
."WHERE starttime <= '%s %s' AND endtime >= '%s %s' "
."AND person.name = availability.person ORDER BY name",
function display_jobs ($dbh, $date, $start, $end, $name)
{
+ if ($start == "24:00") { $start = "23:59"; }
+ if ($end == "24:00") { $end = "23:59"; }
+
$query = sprintf ("SELECT fragment.id,job.title,starttime,endtime,job FROM job,fragment "
."WHERE starttime >= '%s %s' AND endtime <= '%s %s' "
."AND job.id=fragment.job ORDER BY starttime,endtime",