Skip to content
Permalink
master
Switch branches/tags

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/az-modell.php

Go to file
 
 
Cannot retrieve contributors at this time
223 lines (218 sloc) 9.66 KB
Raw Blame
Open in GitHub Desktop
<!DOCTYPE html>
<html>
<head>
<title>Arbeitszeit-Modelle</title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="style.css">
<link rel="shortcut icon" href="favicon.ico">
</head>
<body>
<?php
//KERNZEIT DEAKTIVIERT. WIRD DERZEIT NICHT BENÖTIGT UND WIRD VON KEINEM ANDEREN TEIL DER SOFTWARE BERÜCKSICHTIGT!!!
session_start();
if(!$_SESSION['userid']){
session_destroy();
include('login.php');
exit;
}
$infoarray = $_SESSION['infoarray'];
$userarray = $_SESSION['userarray'];
include('dbconnect.php');
if(!$_SESSION['userarray']['admin']){
echo "<h3>keine Rechte, diese Seite einzusehen!</h3>";
exit;
}
if(!empty($_POST)){
//update
//(name, wochenmin, tage, start, ende, kern_start, kern_ende, arbeitstage, urlaub)
foreach($_POST as $key=>$post){
$key = substr($key, 0, -1); //unterstrich löschen
if($key != "neu" && $key != "del"){
$update = "update azmodell set ";
$update .= "name = '".$post['name']."',
wochenmin = '".$post['wochenmin']."', tage = '".$post['tage']."',
start = '".$post['start']."', ende = '".$post['ende']./*"',
kern_start = '".$post['kern_start']."', kern_ende = '".$post['kern_ende'].*/"', ";
if(!empty($post['arbeitstage'])){
$update .= "arbeitstage = '";
foreach($post['arbeitstage'] as $tag){
$update .= "$tag,";
}
$update = substr($update, 0, -1); //letztes überflüssiges komma löschen
$update .= "', ";
}else{
$update .= "arbeitstage = NULL, ";
}
$update .= "urlaub = '".$post['urlaub']."'";
$update .= " where azm_ID = $post[azm_ID]; ";
$update = str_replace("''", "NULL", $update); //leere einträge mit NULL füllen statt mit ''
$dbc->query($update);
if($dbc->error){
echo "<h3 class= 'red'>UPDATE ERROR: ".$dbc->error."</h3>";
echo $update;
exit;
}
}elseif($key == 'neu'){
if(!empty($post['name'])){
$insert = "insert into azmodell
(name, wochenmin, tage, start, ende, "/*."kern_start, kern_ende,"*/."arbeitstage, urlaub)
values
('$post[name]', '$post[wochenmin]', '$post[tage]', '$post[start]', '$post[ende]', '";
//'$post[kern_start]', '$post[kern_ende]', '";
foreach($post['arbeitstage'] as $tag){
$insert .= "$tag,";
}
$insert .= "', '$post[urlaub]');";
$insert = str_replace("''", "NULL", $insert); //leere einträge mit NULL füllen statt mit ''
$dbc->query($insert);
if($dbc->error){
echo "<h3 class= 'red'>INSERT ERROR: ".$dbc->error."</h3>";
echo $insert;
exit;
}
}
}
}
if(!empty($_POST['del_'])){
//check if used
$checkusage = "select model_nr from (select maID, model_nr from ma_azmodel group by maID desc order by datum_ab desc) result
where result.model_nr in (";
//delete
$delete = "delete from azmodell where azm_ID in (";
//routine
foreach($_POST['del_'] as $del){
$delete .= "$del, ";
$checkusage .= "$del, ";
}
$delete = substr($delete, 0, -2);
$delete .= ");";
$checkusage = substr($checkusage, 0, -2);
$checkusage .= ") group by model_nr;";
$usage = $dbc->query($checkusage);
foreach($usage as $user){
$azuser[] = $user['model_nr'];
}
if(!empty($azuser)){
foreach($azuser as $model){
$nummern .= "$model,";
}
$nummern = substr($nummern, 0, -1);
header("Location: az-modell.php?fail=inuse&model=$nummern");
exit;
}
$dbc->query($delete);
if($dbc->error){
echo "<h3 class='red'>DELETE ERROR: ".$dbc->error."</h3>";
exit;
}
}
header('Location: az-modell.php?success=true');
}
echo "<div id='headline'>
<div id='home'>
<a href='index.php?ma=".$infoarray['maID']."'><button><< Menü</button></a>
</div>
<div id='back'><a href='az-modell.php'><button>Abbrechen</button></a></div>
<b>Arbeitszeitmodelle</b>
<div id='forward'><button type='submit' form='azmodell' onclick='return confirm(\"Sicher?\")'>Speichern</button></div>
<div class='scroll down' onclick='window.scrollTo(0,document.documentElement.scrollHeight)'>runter &darr;</div>
<div class='scroll up' onclick='window.scrollTo(0,0)'>&uarr; rauf</div>
</div>";
echo "<form id='azmodell' method='post' action=''>";
if($_GET['success'] === 'true') echo "<h3 class='light-green'>SUCCESS!</h3>";
if($_GET['fail'] === 'inuse'){
$inuseausgabe = "<h3 class='red'>AZ-Modell ist noch belegt! Betroffen: ";
$nummern = explode(",", $_GET['model']);
foreach($nummern as $nummer){
$inuseausgabe .= "$nummer, ";
}
$inuseausgabe = substr($inuseausgabe, 0, -2);
$inuseausgabe .= "</h3>";
echo $inuseausgabe;
}
echo "<b>Tabelle ist editierbar!</b> // Suchen per Strg+F
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Minuten / Woche</th>
<th>Tage pro Woche</th>
<th>Startzeit</th>
<th>Endzeit</th>";
/*echo "<th>Kernzeit Start</th>
<th>Kernzeit Ende</th>";*/
echo "<th>Arbeitstage<br><br>Mo | Di | Mi | Do | Fr | Sa | So</th>
<th>Urlaub / Jahr</th>
<td class='help centered red' title='zum Löschen Haken setzen'>X</td>
</tr>";
$getaz = $dbc->query("select * from azmodell;");
$switch = true;
foreach($getaz as $az){
if($switch){
$color = "line1";
}else{
$color = "line2";
}
$switch = !$switch;
echo "<tr class='$color'>";
$key = $az['azm_ID'];
echo "<td><div><input type='hidden' name='$key [azm_ID]' value='".$az['azm_ID']."'>".$az['azm_ID']."</div></td>";
echo "<td><div><input type='text' name='$key [name]' value='".$az['name']."'></div></td>";
echo "<td><div><input type='number' min='0' name='$key [wochenmin]' value='".$az['wochenmin']."'></div></td>";
echo "<td><div><input type='number' min='0' max='5' name='$key [tage]' value='".$az['tage']."'></div></td>";
echo "<td><div><input type='time' name='$key [start]' value='".$az['start']."'></div></td>";
echo "<td><div><input type='time' name='$key [ende]' value='".$az['ende']."'></div></td>";
/*echo "<td><div><input type='time' name='$key [kern_start]' value='".$az['kern_start']."'></div></td>";
echo "<td><div><input type='time' name='$key [kern_ende]' value='".$az['kern_ende']."'></div></td>";*/
echo "<td><div class='days'>";
$tage = explode(',', $az['arbeitstage']);
$output = '';
for($i = 1; $i <= 7; $i++){
if(in_array($i, $tage)){
$checked = 'checked';
}else{
$checked = '';
}
$output .= "<input id='checkbox$i-$key' type='checkbox' class='checkbox' name='$key [arbeitstage][]' value='$i' $checked>
<label for='checkbox$i-$key'></label>";
}
$output = substr($output, 0, -3);
echo $output;
echo "</div></td>";
echo "<td><div><input type='number' min='0' name='$key [urlaub]' value='".$az['urlaub']."'></div></td>
<td><input id='deletebox$key' type='checkbox' class='checkbox' name='del []' value='$key'><label for='deletebox$key'></label></td>";
echo "</tr>";
}
echo "<tr class='topline'><td colspan='10'></td></tr>
<tr>
<td><input type='hidden' name='neu [azm_ID]' value='neu'>neu</td>
<td><div class='longtext'><input type='text' name='neu [name]'></div></td>
<td><div><input type='number' min='0' name='neu [wochenmin]'></div></td>
<td><div><input type='number' min='1' max='5' name='neu [tage]'></div></td>
<td><div><input type='time' name='neu [start]'></div></td>
<td><div><input type='time' name='neu [ende]'></div></td>";
/*echo "<td><div><input type='time' name='neu [kern_start]'></div></td>
<td><div><input type='time' name='neu [kern_ende]'></div></td>";*/
echo "<td><div class='days'>
<input id='checkbox1' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='1'>
<label for='checkbox1'></label>
<input id='checkbox2' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='2'>
<label for='checkbox2'></label>
<input id='checkbox3' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='3'>
<label for='checkbox3'></label>
<input id='checkbox4' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='4'>
<label for='checkbox4'></label>
<input id='checkbox5' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='5'>
<label for='checkbox5'></label>
<input id='checkbox6' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='6'>
<label for='checkbox6'></label>
<input id='checkbox7' class='checkbox' type='checkbox' name='neu [arbeitstage][]' value='7'>
<label for='checkbox7'></label>
</div>
</td>
<td><div><input type='number' min='0' name='neu [urlaub]'></div></td>";
echo "</table>
</form>";
?>
</body>
</html>