} 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>";