} else {
$from_till = "";
$min_timepicker = 1;
//een reservatieperiode moet toch wel minimum 1 minuut zijn
}
$res_start_at = $reservation[0][5];
$res_end_at = $reservation[0][6];
//echo time()."-".$res_start_at;
if (time() > Rsys :: mysql_datetime_to_timestamp($res_start_at)) {
$time_start = time();
} else {
$time_start = Rsys :: mysql_datetime_to_timestamp($res_start_at);
}
$sql = "SELECT start_at, end_at FROM ".Rsys :: getTable('subscription')."
WHERE reservation_id='".$reservationid."' and end_at > NOW() ORDER BY start_at";
$result = Database::query($sql);
if (Database::num_rows($result) != 0){
$start_end = "<ul>";
while ($array = Database::fetch_array($result)) {
//print_r($array);
if (time() < Rsys :: mysql_datetime_to_timestamp($array["start_at"]))
{
if (((Rsys :: mysql_datetime_to_timestamp($array["start_at"]) - $time_start) >= ($min_timepicker*60)) && ($time_start < Rsys :: mysql_datetime_to_timestamp($array["start_at"])))
{
$start_end .= "<li>".Rsys :: timestamp_to_datetime($time_start)." en ".$array["start_at"]."</li>";
}
}
$time_start = Rsys :: mysql_datetime_to_timestamp($array["end_at"]);
$end_time_last_block = $array["end_at"];
function get_item_id($item_name)
{
$item_name = Database::escape_string($item_name);
$sql = "SELECT id FROM " . Rsys::getTable('item') . " WHERE name='" . $item_name . "'";
$result = Database::query($sql);
$result_array = Database::fetch_array($result);
return $result_array['id'];
}
$from_till = "van " . $min_timepicker_show . " tot " . $max_timepicker_show;
}
} else {
$from_till = "";
$min_timepicker = 1;
//een reservatieperiode moet toch wel minimum 1 minuut zijn
}
$res_start_at = $reservation[0][5];
$res_end_at = $reservation[0][6];
//echo time()."-".$res_start_at;
if (time() > Rsys::mysql_datetime_to_timestamp($res_start_at)) {
$time_start = time();
} else {
$time_start = Rsys::mysql_datetime_to_timestamp($res_start_at);
}
$sql = "SELECT start_at, end_at FROM " . Rsys::getTable('subscription') . "\n\t\t\t\tWHERE reservation_id='" . $reservationid . "' and end_at > NOW() ORDER BY start_at";
$result = Database::query($sql);
if (Database::num_rows($result) != 0) {
$start_end = "<ul>";
while ($array = Database::fetch_array($result)) {
//print_r($array);
if (time() < Rsys::mysql_datetime_to_timestamp($array["start_at"])) {
if (Rsys::mysql_datetime_to_timestamp($array["start_at"]) - $time_start >= $min_timepicker * 60 && $time_start < Rsys::mysql_datetime_to_timestamp($array["start_at"])) {
$start_end .= "<li>" . Rsys::timestamp_to_datetime($time_start) . " en " . $array["start_at"] . "</li>";
}
}
$time_start = Rsys::mysql_datetime_to_timestamp($array["end_at"]);
$end_time_last_block = $array["end_at"];
}
if (Rsys::mysql_datetime_to_timestamp($res_end_at) - Rsys::mysql_datetime_to_timestamp($end_time_last_block) >= $min_timepicker * 60) {
$start_end .= "<li>" . $end_time_last_block . " en " . $res_end_at . "</li>";
