$last = max(array_column($rows, "timestamp"));
$message = json_encode(["Result" => "OK", "Records" => $rows, "last" => $last]);
exit($message);
}
session_write_close();
sleep(2);
}
$message = json_encode(["Result" => "OK", "Records" => [], "last" => $last, "query" => $strQuery . $lastQuery . $strQuerySort, "date" => $Date]);
exit($message);
}
// Tabelle Mitarbeiter > Zeiterfassung
if (filter_input(INPUT_POST, 'action') == "get-users-timetable") {
$iUseriD = filter_input(INPUT_POST, 'iUserID', FILTER_VALIDATE_INT);
if ($iUseriD > 0) {
$Date = filter_input(INPUT_POST, 'Date', FILTER_SANITIZE_STRIPPED);
$Date = $tze->sqldate($Date);
$string_query_timetable = 'SELECT * FROM `ze_full` ' . 'WHERE `iUserID` = ? AND `Date` = ? ORDER BY `Time_Start` ASC';
$rows = $tze->get_Results($string_query_timetable, "is", $iUseriD, $Date);
// $last = max(array_column($rows, "timestamp"));
// if (empty($last)) {
// $last = "0000-00-00 00:00:00";
// }
$message = json_encode(["Result" => "OK", "Records" => $rows]);
exit($message);
}
}
// Erzeugen eines Eintrages
if (filter_input(INPUT_POST, 'action') == "insert-users-timetable") {
$insArray['iUserID'] = filter_input(INPUT_POST, 'iUserID', FILTER_VALIDATE_INT);
$insArray['Time_Start'] = filter_input(INPUT_POST, 'Time_Start', FILTER_SANITIZE_STRIPPED);
$insArray['Time_End'] = filter_input(INPUT_POST, 'Time_End', FILTER_SANITIZE_STRIPPED);
