<?php
function timeFromMinutes($minutes, $format = '%02d:%02d')
{
    if ($minutes < 1) {
        return;
    }
    $hours = floor($minutes / 60);
    $min = ($minutes % 60);
    return sprintf($format, $hours, $min);
}

function FormatEntryTimeBy15Minutes($time)
{
    $hour = date("H", strtotime($time));
    $minutes = date("i", strtotime($time));

    if ($minutes == 00) {
        $entry_time = $hour . ":00";
    } else if ($minutes > 00 && $minutes <= 15) {
        $entry_time = $hour . ":15";
    } else if ($minutes > 15 && $minutes <= 30) {
        $entry_time = $hour . ":30";
    } else if ($minutes > 30 && $minutes <= 45) {
        $entry_time = $hour . ":45";
    } else if ($minutes > 45 && $minutes < 60) {
        $entry_time = ($hour + 1) . ":00";
    }

    return $entry_time;
}

function FormatExitTimeBy15Minutes($time)
{
    $hour = date("H", strtotime($time));
    $minutes = date("i", strtotime($time));

    if ($minutes >= 00 && $minutes < 15) {
        $exit_time =  $hour . ":00";
    } else if ($minutes >= 15 && $minutes < 30) {
        $exit_time =  $hour . ":15";
    } else if ($minutes >= 30 && $minutes < 45) {
        $exit_time =  $hour . ":30";
    } else if ($minutes >= 45 && $minutes < 60) {
        $exit_time =  $hour . ":45";
    }

    return $exit_time;
}

function CalcMinutesBetweenTimes($start_time, $end_time)
{
    $start = date_create($start_time);
    $end = date_create($end_time);

    $interval = date_diff($end, $start);
    $minutes = $interval->days * 24 * 60;
    $minutes += $interval->h * 60;
    $minutes += $interval->i;

    return $minutes;
}

function InsertProblem($user_id, $source_type, $source_id, $description, $suggestion, $date, $calendar_type, $run_user_id)
{
    include "database.php";

    $sql = "INSERT INTO problems VALUES(NULL,$user_id,'$source_type'," . $source_id . ",'$description','$suggestion','$date','" . date("Y-m-d H:i:s") . "', $run_user_id,'$calendar_type')";
    $con->query($sql);
}