*/
require_once __DIR__ . '/../../includes/auth.inc';
$tze = new tze();
$oDatenbank = $tze->mysql();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (filter_input(INPUT_POST, 'mode') == "admin") {
#
# Admin Status Prüfen
#
if (!$_SESSION['iAdmin'] == 1) {
exit_error('unzureichende Rechte!');
} else {
// Tabelle Mitarbeiter
if (filter_input(INPUT_POST, 'action') == 'get-users') {
$Date = filter_input(INPUT_POST, 'Date', FILTER_SANITIZE_STRIPPED);
$Date = $tze->sqlDate($Date);
$strQuery = 'select
userId as iUserID, sVorname, sNachname, iArbeitszeit,
sec_to_time(iArbeitszeit * 60 * 60) as Arbeitszeit,
zeiten.AZ, zeiten.PZ, zeiten.iProjekt, zeiten.Projekt,
zeiten.`Status`, zeiten.`working`, zeiten.`timestamp`
from ma_view mitarbeiter
left join (
select
(select
if(Time_End = 0, Projekt, null)
from ze_full ze2
where ze1.iUserID = ze2.iUserID and date=?
order by Time_Start desc limit 1)
as Projekt,
(select
