function printTable($conn, $result)
{
echo '<div align="center"> Current Schedule: <br> <table id="mainTable"><tr>';
drawTableCell("");
drawTableCell("id");
drawTableCell("name");
drawTableCell("toRepeat");
drawTableCell("startTime");
drawTableCell("endTime");
echo '</tr>';
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
if (handleDailyQuery($conn, $row)) {
drawTableRow($row);
}
}
} else {
echo "0 results";
}
echo '</table></div>';
}
function printStartEnd($conn, $result)
{
$minStart = 99999;
$minEnd = 99999;
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
if (handleDailyQuery($conn, $row) === FALSE) {
continue;
}
$minTmpStart = round((strtotime($row["startTime"]) - strtotime(date("Y-m-d H:i:s"))) / 60);
$minTMPEnd = round((strtotime($row["endTime"]) - strtotime(date("Y-m-d H:i:s"))) / 60);
if ($minTmpStart > $minEnd || $minEnd < 99999 && $minTMPEnd < $minEnd) {
break;
}
$minEnd = $minTMPEnd;
if ($minStart == 99999) {
$minStart = $minTmpStart;
}
}
}
echo 'NextStart:' . $minStart . "\r\n" . 'Next_End_:' . $minEnd;
}
