Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
timerec3public/ma-data-editor.php
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
653 lines (626 sloc)
32.3 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| session_start(); | |
| error_reporting(-1); | |
| /* echo "<pre>"; | |
| var_dump($_POST); | |
| echo "</pre>"; | |
| echo $_POST['restanspruch'] != "" ? $_POST['restanspruch'] : $_POST['jahresanspruch']; | |
| exit; */ | |
| //submit | |
| if(!$_SESSION['userid']){ | |
| session_destroy(); | |
| include('login.php'); | |
| exit; | |
| } | |
| if(!$_SESSION['userarray']['admin']){ | |
| echo "<h3>keine Rechte, diese Seite einzusehen!</h3>"; | |
| echo "<br><a href='index.php'><< Back to Home</a>"; | |
| exit; | |
| } | |
| include('dbconnect.php'); | |
| //submit | |
| if(isset($_POST['persnr'])){ | |
| $fail = false; | |
| $dbc->query("start transaction;"); | |
| $getolddatumab = $dbc->query("select datum_ab from az_data_copy where maID = $_POST[persnr] order by azdID desc, datum_ab desc;"); | |
| $olddatumab = $getolddatumab->fetch_array()[0]; | |
| if($_POST['new'] == 'no'){ | |
| //update mitarbeiter | |
| if(!$fail){ | |
| $ausgeschieden = (!empty($_POST['deletedate'])) ? '"' . $_POST['deletedate'] . '"' : 'NULL'; | |
| $dbc->query("update mitarbeiter set | |
| nachname = '$_POST[nachname]', | |
| vorname = '$_POST[vorname]', | |
| agID = '$_POST[ag]', | |
| email = '$_POST[email]', | |
| vggrp = '$_POST[VGgrp]', | |
| gleitzeit = '$_POST[gleitzeit]', | |
| admin = '$_POST[admin]', | |
| ausgeschieden = $ausgeschieden | |
| where maID = '$_POST[persnr]';"); | |
| if($dbc->error) $fail = "update ma: $dbc->error"; | |
| } | |
| //update oder insert az_data (wenn delaydate anders ist als vorher) | |
| if(!$fail){ | |
| $getolddate = $dbc->query("select datum_ab from az_data_copy where azdID = $_POST[azdID];"); | |
| $olddate = $getolddate->fetch_array()[0]; | |
| $azdID = $_POST['azdID']; | |
| if($olddate != $_POST['delaydate']){ | |
| //insert | |
| $dbc->query("insert into az_data_copy (maID, datum_ab, pause, pauseab, fixpause, wochenarbeit, jahresurlaub) values | |
| ('$_POST[persnr]', '$_POST[delaydate]', '$_POST[pause]', '$_POST[pauseab]', '$_POST[fixpause]', '$_POST[wochenarbeit]', '$_POST[jahresanspruch]');"); | |
| if($dbc->error) $fail = "insert new azdata: $dbc->error"; | |
| //wenn insert: dann get last insert id (speichern als azdID) | |
| $azdID = $dbc->query("select last_insert_id();"); | |
| $azdID = $azdID->fetch_array()[0]; | |
| }else{ | |
| //update | |
| $dbc->query("update az_data_copy set | |
| pause = '$_POST[pause]', | |
| pauseab = '$_POST[pauseab]', | |
| fixpause = '$_POST[fixpause]', | |
| wochenarbeit = '$_POST[wochenarbeit]', | |
| jahresurlaub = '$_POST[jahresanspruch]' | |
| where azdID = $_POST[azdID];"); | |
| if($dbc->error) $fail = "insert new azdata: $dbc->error"; | |
| $azdID = $_POST['azdID']; | |
| } | |
| } | |
| //update urlaub (mit resturlaub. jahresurlaub wird ignoriert bzw nur im modell geändert) | |
| if(!$fail){ | |
| if($_POST['restanspruch'] != ""){ | |
| $urlaubsjahr = substr($_POST['delaydate'], 0, 4); | |
| $dbc->query("update urlaub set | |
| tage = '$_POST[restanspruch]' | |
| where maID = '$_POST[persnr]' and jahr = $urlaubsjahr;"); | |
| if($dbc->error) $fail = "update urlaub: $dbc->error"; | |
| } | |
| } | |
| }else{ | |
| //insert mitarbeiter | |
| if(!$fail){ | |
| $ausgeschieden = (!empty($_POST['deletedate'])) ? '"' . $_POST['deletedate'] : 'NULL'; | |
| $dbc->query("insert into mitarbeiter values | |
| ('$_POST[persnr]', | |
| '$_POST[nachname]', | |
| '$_POST[vorname]', | |
| '$_POST[ag]', | |
| '$_POST[email]', | |
| '$_POST[VGgrp]', | |
| '$_POST[gleitzeit]', | |
| '$_POST[userid]', | |
| '$_POST[admin]', | |
| $ausgeschieden);"); | |
| if($dbc->error) $fail = "insert ma: " . $dbc->error; | |
| } | |
| //insert az_data | |
| if(!$fail){ | |
| $dbc->query("insert into az_data_copy (maID, datum_ab, pause, pauseab, fixpause, wochenarbeit, jahresurlaub) values | |
| ('$_POST[persnr]', | |
| '$_POST[delaydate]', | |
| '$_POST[pause]', | |
| '$_POST[pauseab]', | |
| '$_POST[fixpause]', | |
| '$_POST[wochenarbeit]', | |
| '$_POST[jahresanspruch]');"); | |
| if($dbc->error) $fail = "insert az_data: " . $dbc->error; | |
| //get azdID für insert az_time(lastinsert id, speichern als azdID) | |
| $azdID = $dbc->query("select last_insert_id();"); | |
| $azdID = $azdID->fetch_array()[0]; | |
| } | |
| //insert urlaub (jahresanspruch oder wenn gesetzt resturlaub) | |
| if(!$fail){ | |
| $urlaubsjahr = substr($_POST['delaydate'], 0, 4); | |
| $urlaub = $_POST['restanspruch'] != "" ? $_POST['restanspruch'] : $_POST['jahresanspruch']; | |
| $urlaubquery = "insert into urlaub (maID, jahr, tage) values ('$_POST[persnr]', $urlaubsjahr, $urlaub);"; | |
| $dbc->query($urlaubquery); | |
| if($dbc->error) $fail = "insert urlaub: " . $dbc->error; | |
| } | |
| } | |
| //update / insert az_time mittels delete + insert, mit azdID | |
| if(!$fail){ | |
| $dbc->query("delete from az_time where azdID = $azdID;"); | |
| if($dbc->error) $fail = "delete az_time: " . $dbc->error; | |
| } | |
| if(!$fail){ | |
| if(count($_POST['day']) > 1){ | |
| $inserttime = "insert into az_time values "; | |
| foreach($_POST['day'] as $tagnr=>$tag){ | |
| if($tagnr == 0) continue; | |
| $inserttime .= "($azdID, | |
| $tag, | |
| '".$_POST['azvon'][$tag]."', | |
| '".$_POST['azbis'][$tag]."', | |
| '".$_POST['kzvvon'][$tag]."', | |
| '".$_POST['kzvbis'][$tag]."', | |
| '".$_POST['kznvon'][$tag]."', | |
| '".$_POST['kznbis'][$tag]."'), "; | |
| } | |
| $inserttime = substr($inserttime, 0, -2); | |
| $inserttime .= ";"; | |
| $dbc->query($inserttime); | |
| if($dbc->error) $fail = "insert az_time: " . $dbc->error . "<br> query: " . $inserttime; | |
| } | |
| } | |
| //update transponder | |
| if(!$fail && $_POST['gleitzeit']){ | |
| $dbc->query("update transponder set maID = NULL where maID ='$_POST[persnr]';"); | |
| $updaterfid = "update transponder set maID = '$_POST[persnr]' where rfid in ("; | |
| foreach($_POST['rfid'] as $rfid){ | |
| $updaterfid .= "'$rfid', "; | |
| } | |
| $updaterfid = substr($updaterfid, 0, -2); | |
| $updaterfid .= ");"; | |
| $dbc->query($updaterfid); | |
| if($dbc->error) $fail = "update rfid: " . $dbc->error; | |
| } | |
| /* print_r($_POST); | |
| var_dump($fail); | |
| $fail = "testing disabled submission"; //testing */ | |
| if(!$fail){ | |
| $dbc->query("commit;"); | |
| $_SESSION['newmaID'] = $_POST['persnr']; | |
| header("Location: ma-data-editor.php?success=true"); | |
| exit; | |
| }else{ | |
| $dbc->query("rollback;"); | |
| echo "<h3 class='red'>$fail</h3>"; | |
| } | |
| } | |
| ?> | |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>timerec | Mitarbeiter bearbeiten</title> | |
| <link rel="stylesheet" type="text/css" href="style.css"> | |
| <link rel="stylesheet" href="DatePickerX.css"> | |
| <link rel="stylesheet" href="timepickerW.css"> | |
| <script src="timepickerW.js"></script> | |
| <script src="DatePickerX.js"></script> | |
| <script> | |
| var open; | |
| var firsttime = true; | |
| function opentab(tab){ | |
| if(firsttime){ | |
| open = tab; | |
| firsttime = false; | |
| } | |
| document.getElementById(open.value).style.display = 'none'; | |
| open.style = 'background-color: none'; | |
| document.getElementById(tab.value).style.display = 'block'; | |
| tab.style = 'background-color: rgb(219, 233, 0)'; | |
| open = tab; | |
| } | |
| function toggleReadOnly(id){ | |
| var element = document.getElementById(id); | |
| if(element.getAttribute('readonly')){ | |
| element.removeAttribute('readonly'); | |
| }else{ | |
| element.setAttribute('readonly', 'true'); | |
| } | |
| } | |
| function setname(){ | |
| var nachname = document.getElementById('nachnamespan'); | |
| var vorname = document.getElementById('vornamespan'); | |
| var nachnamefeld = document.getElementById('nachnamefeld'); | |
| var vornamefeld = document.getElementById('vornamefeld'); | |
| nachname.innerHTML = nachnamefeld.value; | |
| vorname.innerHTML = vornamefeld.value; | |
| } | |
| function loadrfidnames(){ | |
| var button = document.getElementById("transponderbutton"); | |
| var select = document.getElementById("transponder"); | |
| button.innerHTML = "-"; | |
| var stop = false; | |
| //das alles nur, um die ersten paar zugewiesenen Transponder auf dem Button sehen zu können | |
| for(i=0; i < select.childNodes.length; i++){ | |
| if(select.childNodes[i].selected){ | |
| button.innerHTML = button.innerHTML + select.childNodes[i].innerHTML + "; "; | |
| if(button.innerHTML.length >= 24){ | |
| button.innerHTML = button.innerHTML.slice(1, -2); | |
| button.innerHTML = button.innerHTML + "[...]"; | |
| stop = true; | |
| break; | |
| } | |
| } | |
| } | |
| if(stop == false && button.innerHTML.length >= 2){ | |
| button.innerHTML = button.innerHTML.slice(1, -2); | |
| } | |
| } | |
| function checkmaID(maid){ | |
| var xhr = new XMLHttpRequest(); | |
| var result = document.getElementById('checkresult'); | |
| var inputfield = document.getElementById('persnr'); | |
| xhr.open('GET', 'checkmaid.php?check=' + maid); | |
| xhr.onload = function() { | |
| if (xhr.status === 200) { | |
| var text = xhr.responseText.slice(1); | |
| var state = xhr.responseText.slice(0, 1); | |
| if(state == 1){ | |
| result.className = 'light-green'; | |
| result.innerHTML = text; | |
| inputfield.setCustomValidity(''); | |
| }else{ | |
| result.className = 'red'; | |
| result.innerHTML = text; | |
| inputfield.setCustomValidity('schon belegt'); | |
| } | |
| } | |
| else { | |
| console.log(xhr.status); | |
| } | |
| }; | |
| xhr.send(); | |
| } | |
| function copytimes(){ | |
| var checkboxen = document.getElementsByClassName('checkbox'); | |
| var azvon = document.getElementsByName('azvon[]')[1].value; | |
| var azbis = document.getElementsByName('azbis[]')[1].value; | |
| var kzvvon = document.getElementsByName('kzvvon[]')[1].value; | |
| var kzvbis = document.getElementsByName('kzvbis[]')[1].value; | |
| var kznvon = document.getElementsByName('kznvon[]')[1].value; | |
| var kznbis = document.getElementsByName('kznbis[]')[1].value; | |
| for(box of checkboxen){ | |
| if(box.id.indexOf('timebox') !== -1){ | |
| if(box.checked){ | |
| document.getElementsByName("azvon[]")[box.value].value = azvon; | |
| document.getElementsByName("azbis[]")[box.value].value = azbis; | |
| document.getElementsByName("kzvvon[]")[box.value].value = kzvvon; | |
| document.getElementsByName("kzvbis[]")[box.value].value = kzvbis; | |
| document.getElementsByName("kznvon[]")[box.value].value = kznvon; | |
| document.getElementsByName("kznbis[]")[box.value].value = kznbis; | |
| }else{ | |
| if(box.value == '1'){ | |
| if(!confirm("Montag leeren?")){ | |
| continue; | |
| } | |
| } | |
| document.getElementsByName("azvon[]")[box.value].value = ""; | |
| document.getElementsByName("azbis[]")[box.value].value = ""; | |
| document.getElementsByName("kzvvon[]")[box.value].value = ""; | |
| document.getElementsByName("kzvbis[]")[box.value].value = ""; | |
| document.getElementsByName("kznvon[]")[box.value].value = ""; | |
| document.getElementsByName("kznbis[]")[box.value].value = ""; | |
| } | |
| } | |
| } | |
| } | |
| function maneu(){ | |
| document.getElementById('maneu').innerHTML = 'hinzufügen'; | |
| document.getElementsByName('selectaz')[0].style.display = 'none'; | |
| document.getElementById('maneubutton').style.display = 'none'; | |
| document.getElementById('ldap-button').style.display = 'inline-block'; | |
| document.getElementById('nachnamefeld').placeholder = 'Name eingeben, dann Enter ⟶'; | |
| document.getElementById('nachnamefeld').setAttribute("onKeyPress", 'document.getElementById("searchterm").value = this.value; onEnter(event)'); | |
| document.getElementById('persnr').removeAttribute('readonly'); | |
| document.getElementById('persnrhelp').style.display = 'none'; | |
| for(input of document.getElementsByTagName('input')){ | |
| if(input.type != 'checkbox'){ | |
| input.value = ''; | |
| }else{ | |
| input.removeAttribute('checked'); | |
| } | |
| } | |
| for(select of document.getElementsByTagName('select')){ | |
| for(option of select){ | |
| if(option.id != 'noUnselect'){ | |
| option.removeAttribute('selected'); | |
| } | |
| } | |
| } | |
| document.getElementById('switchtonew').value = 'yes'; | |
| var heute = new Date().toISOString(); | |
| document.getElementById('delaydate').value = heute.slice(0, 10); | |
| loadrfidnames(); | |
| setname(); | |
| } | |
| function jumpToError(form){ | |
| for(child of form.getElementsByTagName('input')){ | |
| if(!child.checkValidity()) break; | |
| } | |
| var el = child; | |
| var cls = "reiter"; | |
| while((el = el.parentElement) && !el.classList.contains(cls)); | |
| for(tabbutton of document.getElementById('reiterleiste').childNodes){ | |
| if(tabbutton.value == el.id){ | |
| opentab(tabbutton); | |
| break; | |
| } | |
| } | |
| return false; | |
| } | |
| function onEnter(event){ | |
| var code = 0; | |
| code = event.keyCode; | |
| if (code==13) document.getElementById('ldap').submit(); | |
| } | |
| document.addEventListener("DOMContentLoaded", function(event) { | |
| opentab(document.getElementById('first')); | |
| loadrfidnames(); | |
| setname(); | |
| for(input of document.querySelectorAll('[type="date"]')){ | |
| input.DatePickerX.init({ | |
| // options here | |
| format : 'yyyy-mm-dd', | |
| weekDayLabels : ['Mo', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So'], | |
| shortMonthLabels : ['Jan', 'Feb', 'Mär', 'Apr', 'Mai', 'Jun', 'Jul', 'Aug', 'Sep', 'Okt', 'Nov', 'Dez'], | |
| singleMonthLabels: ['Januar', 'Februar', 'März', 'April', 'Mai', 'Juni', 'Juli', 'August', 'September', 'Oktober', 'November', 'Dezember'], | |
| todayButtonLabel : 'Heute', | |
| clearButton: true, | |
| clearButtonLabel: 'Leeren' | |
| }); | |
| } | |
| for(zeitfeld of document.querySelectorAll('[type="time"]')){ | |
| zeitfeld.pattern = '(0[0-9]|1[0-9]|2[0-3])(:[0-5][0-9])'; | |
| } | |
| inittimepicker(); | |
| }); | |
| </script> | |
| </head> | |
| <body> | |
| <?php | |
| //session_start(); | |
| //generic stuff | |
| //session_start 1. zeile! | |
| //submit routine auch 1. zeile, da nur so header() funktioniert. | |
| if($_GET['success'] === 'true'){ | |
| echo "<h3 class='light-green'>Erfolgreich gespeichert!</h3>"; | |
| } | |
| //Daten aus allen Tabellen holen | |
| if(isset($_SESSION['newmaID'])){ | |
| $getma = $dbc->query("select * from mitarbeiter where maID = $_SESSION[newmaID];"); | |
| $infoarray = $getma->fetch_assoc(); | |
| $_SESSION['infoarray'] = $infoarray; | |
| unset($_SESSION['newmaID']); | |
| }else{ | |
| $infoarray = $_SESSION['infoarray']; | |
| } | |
| $maID = $infoarray['maID']; | |
| $nachname = $infoarray['nachname']; | |
| $vorname = $infoarray['vorname']; | |
| $uid = $infoarray['userid']; | |
| /* print_r($infoarray); | |
| echo "<br>"; */ | |
| $azdid = isset($_POST['selectaz']) ? "and azdID = $_POST[selectaz]" : ""; | |
| $getazdata = $dbc->query("select * from az_data_copy where maID = $maID $azdid order by azdID desc, datum_ab desc limit 1;"); | |
| $azdata = $getazdata->fetch_assoc(); | |
| /* print_r($azdata); | |
| echo "<br>"; */ | |
| $getaztimes = $dbc->query("select * from az_time where azdID = $azdata[azdID];"); | |
| foreach($getaztimes as $time){ | |
| $aztimes[$time['tag']] = $time; | |
| } | |
| /*print_r($aztimes); | |
| echo "<br>"; | |
| echo "days per week: "; | |
| print_r(count($aztimes)); | |
| echo "<br>"; */ | |
| //routine für befüllen aus LDAP | |
| if(isset($_POST['ldapresult']) && !$_POST['abort']){ | |
| $ldap_data = explode(";", $_POST['ldapresult']); | |
| $nachname = $ldap_data[0]; | |
| $vorname = $ldap_data[1]; | |
| $uid = $ldap_data[2]; | |
| $mailaddr = $ldap_data[3]; //redundant? uid -> mailaddr | |
| } | |
| //debug | |
| //print_r($infoarray); | |
| //echo "<br>"; | |
| //print_r($_POST); | |
| ?> | |
| <div id='content'> | |
| <a href="index.php?ma=<?= $maID ?>"><button><< Menü</button></a> | |
| <button id='maneubutton' class='topline' onclick='maneu()'>neuen Mitarbeiter anlegen</button> | |
| <select form='selectaz' name='selectaz' class='select inputheight' onchange='this.form.submit();'> | |
| <?php | |
| $getazlist = $dbc->query("select azdID, date_format(datum_ab, '%d.%m.%Y') as datum_ab from az_data_copy where maID = $maID order by azdID desc, datum_ab desc;"); | |
| foreach($getazlist as $azentry){ | |
| $selected = $azdata['azdID'] == $azentry['azdID'] ? "selected" : ""; | |
| echo "<option $selected value='$azentry[azdID]'>($azentry[azdID]) $azentry[datum_ab]</option>"; | |
| } | |
| ?> | |
| </select> | |
| <form id='selectaz' action='#' method='post'></form> | |
| <form id='ldap' action='ldap.php' method='post'><input id='searchterm' type='hidden' name='search'></form> | |
| <form id='centered_form' action='#' method='post' onkeypress='return event.keyCode != 13;'> | |
| <input id='switchtonew' type='hidden' name='new' value='no'> | |
| <h3>Mitarbeiter <span id='maneu'>bearbeiten</span> [ <span id='nachnamespan'></span>, <span id='vornamespan'></span> ]</h3> | |
| <div id='reiterleiste'> | |
| <button type='button' id='first' onclick='opentab(this)' form='' value='allgemein'>Allgemein</button> ⟶ | |
| <button type='button' onclick='opentab(this)' form='' value='gleitzeit'>Gleitzeit</button> ⟶ | |
| <button type='button' onclick='opentab(this)' form='' value='urlaub'>Urlaub</button> ⟶ | |
| <button type='button' onclick='opentab(this)' form='' value='fertig'>Fertigstellen</button> | |
| </div> | |
| <div id='reiter'> | |
| <div id='allgemein' class='reiter'> | |
| <table> | |
| <tr><th class='rechts'>UserID <span class='help' title='Der Benutzer kann zwar ohne UserID angelegt werden; ist dann allerdings nicht in der Lage, sich einzuloggen.'>(?)</span></th><td class='links'><input name='userid' id='useridfeld' value='<?= $uid ?>' type='text' required readonly placeholder='wird aus LDAP gelesen'></td></tr> | |
| <tr><th class='rechts'>Nachname</th><td class='links'><input required onkeyup='setname()' name='nachname' value="<?= $nachname ?>" id='nachnamefeld' type='text'></td> | |
| <td class='rechts'><button id='ldap-button' style='display: none' form='ldap' onclick='document.getElementById("searchterm").value = document.getElementById("nachnamefeld").value' type='submit' tabindex='-1'>LDAP-Suche</button></td></tr> | |
| <tr><th class='rechts'>Vorname</th><td class='links'><input required onkeyup='setname()' name='vorname' value='<?= $vorname ?>' id='vornamefeld' type='text'></td></tr> | |
| <tr><th class='rechts'>Personalnummer <span id='persnrhelp' class='help' title="Kann nicht nachträglich geändert werden, da Mitarbeiter anhand dieser Nummer im System verwaltet werden. Bei einer Änderung würden alle Verbindungen (Gesteckte Zeiten uvm.) verloren gehen.">(?)</span></th><td class='links'> | |
| <input readonly required onkeyup='checkmaID(this.value);' id='persnr' name='persnr' value='<?= $maID ?>' type='number' pattern='[0-9]'><span id='checkresult'></span></td></tr> | |
| <tr><th class='rechts'>AG</th><td class='links'><select name='ag' class='auswahl' size=1 onmousedown='this.size=10' onfocus='for(option of this.childNodes){if(option.selected){option.scrollIntoView(); break;}}' onblur='this.size=1'> | |
| <?php | |
| $getaglist = $dbc->query("select * from ag order by name;"); | |
| echo "<option value=''> - </option>"; | |
| foreach($getaglist as $ag){ | |
| $selected = $ag['ag_ID'] == $infoarray['agID'] ? 'selected' : ''; | |
| echo "<option $selected value='$ag[ag_ID]'>$ag[name]</option>"; | |
| } | |
| ?> | |
| </select></td></tr> | |
| <tr><th class='rechts'>Vergütungsgruppe</th><td><select name='VGgrp' class='select'> | |
| <?php | |
| $vggruppen = [ | |
| "I", | |
| "II", | |
| "III" | |
| ]; | |
| foreach($vggruppen as $vggruppe){ | |
| $selected = $vggruppe == $infoarray['vggrp'] ? 'selected' : ''; | |
| echo "<option $selected value='$vggruppe'>Gruppe $vggruppe</option>"; | |
| } | |
| ?> | |
| </select> | |
| </td></tr> | |
| <tr><th class='rechts'>Admin?</th><td class='links'><input class='hackbox' <?php echo $infoarray['admin'] ? 'checked' : '' ?> name='admin' id='admin' type='checkbox' value='1'><label for='admin'></label></td></tr> | |
| <tr><th class='rechts'>deaktivieren ab <span class='help' title='Der Mitarbeiter wird am eingestellten Tag aus dem System entfernt. Es gehen dabei keine Daten verloren, er wird lediglich ausgeblendet.'>(?)</span></th> | |
| <td class='links'><input name='deletedate' value="<?= $infoarray['ausgeschieden'] ?>" type='date' title='JJJJ-MM-DD' pattern='(?:19|20)[0-9]{2}-(?:(?:0[1-9]|1[0-2])-(?:0[1-9]|1[0-9]|2[0-9])|(?:(?!02)(?:0[1-9]|1[0-2])-(?:30))|(?:(?:0[13578]|1[02])-31))'></td> | |
| </tr> | |
| </table> | |
| </div> | |
| <div id='gleitzeit' class='reiter'> | |
| <table> | |
| <tr><th class='rechts'>Gleitzeit?</th><td class='links'><input class='hackbox' id='gleitzeitbox' onchange='document.getElementById("transponder").required=this.checked' <?php echo $infoarray['gleitzeit'] ? 'checked' : '' ?> name='gleitzeit' type='checkbox' value='1'><label for='gleitzeitbox'></label></td></tr> | |
| <tr><th class='rechts'>Pausenlänge</th><td class='links'><input type='time' name='pause' value='<?= substr($azdata['pause'], 0, 5) ?>'></td></tr> | |
| <tr><th class='rechts'>Pause ab</th><td class='links'><input type='time' name='pauseab' value='<?= substr($azdata['pauseab'], 0, 5) ?>'></td></tr> | |
| <tr><th class='rechts'>Fix-Pause ab</th><td class='links'><input type='time' name='fixpause' value='<?= substr($azdata['fixpause'], 0, 5) ?>'> Uhr</td></tr> | |
| <tr><th class='rechts'>Wochenarbeit <span class='help' title="Stunden ohne Einarbeitungszeit eingeben (wie im Vertrag).
Wird auf Knopfdruck umgewandelt in Minuten inkl. Einarbeitungszeit.">(?)</span></th> | |
| <td class='links threeinput'> | |
| <input class='rechts' type='number' min='0' placeholder='Std.' onkeyup='if(event.keyCode == 13){this.nextElementSibling.click();}'> | |
| <button type='button' onclick='this.nextElementSibling.value = Math.ceil(this.previousElementSibling.value*60+((this.previousElementSibling.value*60)/2340)*35)'>⟶</button> | |
| <input type='number' placeholder='min.' name='wochenarbeit' value='<?= $azdata['wochenarbeit'] ?>'> min. | |
| </td> | |
| </tr> | |
| <tr><th class='rechts'>Transponder</th><td class='links'><div style='display: inline-block' id='transponderbutton' title='anklicken zum ändern' onclick="document.getElementById('transponder').className='auswahl nachoben'; document.getElementById('transponder').focus(); this.style='display: none'">.</div> | |
| <select id='transponder' multiple size=10 onblur='loadrfidnames(); this.className="auswahl nachoben versteckt"; document.getElementById("transponderbutton").style="display: inline-block"' onfocus='for(option of this.childNodes){if(option.selected){option.scrollIntoView(); break;}}' class='auswahl nachoben versteckt' name='rfid[]'> | |
| <?php | |
| if($_POST['ldapresult']){ | |
| $onlyunused = 'where maID is NULL'; | |
| $selectempty = 'selected'; | |
| }else{ | |
| $onlyunused = ''; | |
| $selectempty = ''; | |
| } | |
| echo "<option id='noUnselect' $selectempty value=''> - </option>"; | |
| $gettransponders = $dbc->query("select * from transponder $onlyunused order by name;"); | |
| foreach($gettransponders as $transponder){ | |
| $selected = $transponder['maID'] == $maID ? 'selected' : ''; | |
| echo "<option $selected value='$transponder[rfid]'>$transponder[name]</option>"; | |
| } | |
| ?> | |
| </select></td></tr> | |
| </table> | |
| <table class="timetable"> | |
| <h3>Zeiteinstellungen</h3> | |
| <tr> | |
| <th> </th> | |
| <th> </th> | |
| <input type='hidden' name='day[]' value='dummy'> | |
| <th><label><input class='checkbox' id='motimebox' type='checkbox' name='day[]' value='1' <?= $aztimes[1] ? 'checked' : '' ?>><label for='motimebox'></label> Mo</label></th> | |
| <th><label><input class='checkbox' id='ditimebox' type='checkbox' name='day[]' value='2' <?= $aztimes[2] ? 'checked' : '' ?>><label for='ditimebox'></label> Di</label></th> | |
| <th><label><input class='checkbox' id='mitimebox' type='checkbox' name='day[]' value='3' <?= $aztimes[3] ? 'checked' : '' ?>><label for='mitimebox'></label> Mi</label></th> | |
| <th><label><input class='checkbox' id='dotimebox' type='checkbox' name='day[]' value='4' <?= $aztimes[4] ? 'checked' : '' ?>><label for='dotimebox'></label> Do</label></th> | |
| <th><label><input class='checkbox' id='frtimebox' type='checkbox' name='day[]' value='5' <?= $aztimes[5] ? 'checked' : '' ?>><label for='frtimebox'></label> Fr</label></th> | |
| <th><label><input class='checkbox' id='satimebox' type='checkbox' name='day[]' value='6' <?= $aztimes[6] ? 'checked' : '' ?>><label for='satimebox'></label> Sa</label></th> | |
| <th class='lastcol'><label><input class='checkbox' id='sotimebox' type='checkbox' name='day[]' value='7' <?= $aztimes[7] ? 'checked' : '' ?>><label for='sotimebox'></label> So</label></th> | |
| </tr> | |
| <tr> | |
| <td class='rechts'>AZ</td> | |
| <td>von<br>bis</td> | |
| <input type='hidden' name='azvon[]' value='dummy'> | |
| <input type='hidden' name='azbis[]' value='dummy'> | |
| <td><input type='time' name='azvon[]' tabindex='1' value='<?= substr($aztimes[1]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' tabindex='2' value='<?= substr($aztimes[1]['azende'], 0, 5)?>'></td> | |
| <td><input type='time' name='azvon[]' value='<?= substr($aztimes[2]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[2]['azende'], 0, 5) ?>'></td> | |
| <td><input type='time' name='azvon[]' value='<?= substr($aztimes[3]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[3]['azende'], 0, 5) ?>'></td> | |
| <td><input type='time' name='azvon[]' value='<?= substr($aztimes[4]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[4]['azende'], 0, 5) ?>'></td> | |
| <td><input type='time' name='azvon[]' value='<?= substr($aztimes[5]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[5]['azende'], 0, 5) ?>'></td> | |
| <td><input type='time' name='azvon[]' value='<?= substr($aztimes[6]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[6]['azende'], 0, 5) ?>'></td> | |
| <td class='lastcol'><input type='time' name='azvon[]' value='<?= substr($aztimes[7]['azstart'], 0, 5) ?>'><br><input type='time' name='azbis[]' value='<?= substr($aztimes[7]['azende'], 0, 5) ?>'></td> | |
| </tr> | |
| <tr> | |
| <td class='rechts'>Kernz<br> Vorm</td> | |
| <td>von<br>bis</td> | |
| <input type='hidden' name='kzvvon[]' value='dummy'> | |
| <input type='hidden' name='kzvbis[]' value='dummy'> | |
| <td><input type='time' name='kzvvon[]' tabindex='3' value='<?= substr($aztimes[1]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' tabindex='4' value='<?= substr($aztimes[1]['kzvende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kzvvon[]' value='<?= substr($aztimes[2]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[2]['kzvende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kzvvon[]' value='<?= substr($aztimes[3]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[3]['kzvende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kzvvon[]' value='<?= substr($aztimes[4]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[4]['kzvende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kzvvon[]' value='<?= substr($aztimes[5]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[5]['kzvende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kzvvon[]' value='<?= substr($aztimes[6]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[6]['kzvende'], 0, 5)?>'></td> | |
| <td class='lastcol'><input type='time' name='kzvvon[]' value='<?= substr($aztimes[7]['kzvstart'], 0, 5)?>'><br><input type='time' name='kzvbis[]' value='<?= substr($aztimes[7]['kzvende'], 0, 5)?>'></td> | |
| </tr> | |
| <tr> | |
| <td class='rechts'>Kernz<br> Nachm</td> | |
| <td>von<br>bis</td> | |
| <input type='hidden' name='kznvon[]' value='dummy'> | |
| <input type='hidden' name='kznbis[]' value='dummy'> | |
| <td><input type='time' name='kznvon[]' tabindex='5' value='<?= substr($aztimes[1]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' tabindex='6' value='<?= substr($aztimes[1]['kznende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kznvon[]' value='<?= substr($aztimes[2]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[2]['kznende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kznvon[]' value='<?= substr($aztimes[3]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[3]['kznende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kznvon[]' value='<?= substr($aztimes[4]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[4]['kznende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kznvon[]' value='<?= substr($aztimes[5]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[5]['kznende'], 0, 5)?>'></td> | |
| <td><input type='time' name='kznvon[]' value='<?= substr($aztimes[6]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[6]['kznende'], 0, 5)?>'></td> | |
| <td class='lastcol'><input type='time' name='kznvon[]' value='<?= substr($aztimes[7]['kznstart'], 0, 5)?>'><br><input type='time' name='kznbis[]' value='<?= substr($aztimes[7]['kznende'], 0, 5)?>'></td> | |
| </tr> | |
| <tr> | |
| <td colspan='2'></td> | |
| <td><button type='button' style='width: 75px' onclick='copytimes()'>⟶</button></td> | |
| <td class='lastcol' colspan='6'></td> | |
| </tr> | |
| </table> | |
| </div> | |
| <div id='urlaub' class='reiter'> | |
| <table> | |
| <tr><th class='rechts'>Jahresanspruch</th><td class='links'><input name='jahresanspruch' value='<?= $azdata["jahresurlaub"]?>' type='number' required class='rechts'> Tage</td></tr> | |
| <tr><th class='rechts'>eMail-Ordner</th><td class='links'><select class='select' name='email'> | |
| <?php | |
| $urlaub = [ | |
| "urlaub_ak", | |
| "urlaub_lm", | |
| "urlaub_nz" | |
| ]; | |
| if($_POST['ldapresult'] && !$_POST['abort']){ | |
| $noUnselect = 'noUnselect'; | |
| }else{ | |
| $noUnselect = ''; | |
| } | |
| foreach($urlaub as $auswahl){ | |
| //email ordner automatisch anhand des nachnamens festlegen | |
| $letters = range(substr($auswahl,-2,1), substr($auswahl,-1,1)); | |
| //echo "<script>console.log('".substr($auswahl,-2,1)."----".strtolower($nachname[0])."');</script>"; | |
| if(in_array(strtolower($nachname[0]), $letters)){ | |
| $selected = "selected"; | |
| }else{ | |
| $selected = ""; | |
| } | |
| echo "<option id='$noUnselect' $selected value='$auswahl'>$auswahl</option>"; | |
| } | |
| ?> | |
| </select> | |
| </td></tr> | |
| <tr><td colspan=2><span class='trenner optional'>optional: Urlaub für das laufende Jahr anpassen</span></td></tr> | |
| <tr><th class='rechts'>Resturlaub</th><td class='links'><input name='restanspruch' type='number' class='rechts'> Tage</td></tr> | |
| </table> | |
| </div> | |
| <div id='fertig' class='reiter'> | |
| <table> | |
| <tr><th class='rechts'>Einstellungen gültig ab</th> | |
| <td class='links'><input id='delaydate' name='delaydate' value='<?= $azdata["datum_ab"] ?>' type='date' title='JJJJ-MM-DD' pattern='(?:19|20)[0-9]{2}-(?:(?:0[1-9]|1[0-2])-(?:0[1-9]|1[0-9]|2[0-9])|(?:(?!02)(?:0[1-9]|1[0-2])-(?:30))|(?:(?:0[13578]|1[02])-31))'></td></tr> | |
| <tr><th class='rechts'></th><td class='links'><button type='submit' onclick="if(!this.form.checkValidity()){return jumpToError(this.form);}; return confirm('Alle Daten korrekt?');">Speichern</button></td></tr> | |
| </table> | |
| </div> | |
| </div> | |
| <input type='hidden' name='azdID' value='<?= $azdata['azdID'] ?>'> | |
| </form> | |
| </div> | |
| </body> | |
| <?php | |
| if($_POST['ldapresult'] && !$_POST['abort']){ | |
| echo "<script> | |
| maneu(); | |
| document.getElementById('useridfeld').value = '$uid'; | |
| document.getElementById('nachnamefeld').value = '$nachname'; | |
| document.getElementById('vornamefeld').value = '$vorname'; | |
| </script>"; | |
| }elseif($_POST['abort']){ | |
| echo "<script> | |
| maneu(); | |
| </script>"; | |
| } | |
| ?> | |
| </html> |