/**
* With this you make a reservartion
*
* @param - int $reservation_id The id off the reservation
*/
function add_subscription_timepicker($reservation_id, $user_id, $start_date, $end_date, $accepted, $min, $max)
{
$start_date = Database::escape_string($start_date);
$end_date = Database::escape_string($end_date);
if (Rsys::check_date_subscription($reservation_id, $start_date, $end_date) != 0) {
return 1;
}
if (!($min == 0 && $max == 0)) {
if (Rsys::mysql_datetime_to_timestamp($end_date) - Rsys::mysql_datetime_to_timestamp($start_date) < $min * 60) {
return 2;
}
if (Rsys::mysql_datetime_to_timestamp($end_date) - Rsys::mysql_datetime_to_timestamp($start_date) > $max * 60) {
return 3;
}
}
$sql = "INSERT INTO " . Rsys::getTable("subscription") . " (user_id,reservation_id,accepted,start_at,end_at) VALUES ('" . Database::escape_string($user_id) . "','" . Database::escape_string($reservation_id) . "','" . ($accepted ? '1' : '0') . "','" . $start_date . "','" . $end_date . "')";
Database::query($sql);
return 0;
}
