111 lines
No EOL
4.1 KiB
PHP
111 lines
No EOL
4.1 KiB
PHP
<?php
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
|
|
$template->assign('m',1);
|
|
|
|
$jahr1= (int)date('Y'); $j1['j']=$jahr1;
|
|
$jahr2=$jahr1-1; $j2['j']=$jahr2;
|
|
$jahr3=$jahr1-2; $j3['j']=$jahr3;
|
|
$jahr4=$jahr1-3; $j4['j']=$jahr4;
|
|
|
|
$maID=$_SESSION['maID']; $template->assign('maID', $maID);
|
|
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr1."' ORDER BY grund"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a1[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a1[$key]['name']=$bez['bez'];
|
|
$a1[$key]['grund']=$row['grund'];
|
|
} else { $a1[$key]['menge']++;
|
|
|
|
}
|
|
|
|
$j1['a']=$a1;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr2."' ORDER BY grund"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a2[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a2[$key]['name']=$bez['bez'];
|
|
$a2[$key]['grund']=$row['grund'];
|
|
} else { $a2[$key]['menge']++;
|
|
|
|
}
|
|
|
|
$j2['a']=$a2;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr3."' ORDER BY grund"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a3[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a3[$key]['name']=$bez['bez'];
|
|
$a3[$key]['grund']=$row['grund'];
|
|
} else { $a3[$key]['menge']++;
|
|
|
|
}
|
|
|
|
$j3['a']=$a3;
|
|
}
|
|
//--------------------------------------------------
|
|
$ktemp = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_POST['maID']."' AND jahr='".$jahr4."' ORDER BY grund"); $key=0; $grund=0;
|
|
while($row = $ktemp->fetch_assoc()) {
|
|
|
|
if($grund!=$row['grund']) {
|
|
$grund=$row['grund']; $key++;
|
|
$a4[$key]['menge']=1;
|
|
|
|
|
|
$bez=$GLOBALS['mysql']->query_single("SELECT bez FROM planer_bez WHERE id='".$grund."'");
|
|
$a4[$key]['name']=$bez['bez'];
|
|
$a4[$key]['grund']=$row['grund'];
|
|
} else { $a4[$key]['menge']++;
|
|
|
|
}
|
|
|
|
$j4['a']=$a4;
|
|
}
|
|
//-----------------------------------------------------------------------------------------------------------------------
|
|
$j1['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr1."' ");
|
|
$j2['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr2."' ");
|
|
$j3['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr3."' ");
|
|
$j4['s'] = $GLOBALS['mysql']->summe("SELECT * FROM planer WHERE mid='".$_POST['maID']."' and jahr='".$jahr4."' ");
|
|
//-----------------------------------------------------------------------------------------------------------------------
|
|
//$test=$GLOBALS['mysql']->query_single("SELECT * FROM kartenlog WHERE user='".$_POST['maID']."'");
|
|
//$klog = $GLOBALS['mysql']->query("SELECT zeit FROM kartenlog WHERE user='".$_POST['maID']."' DESC LIMIT 30");
|
|
|
|
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog WHERE user='".$_POST['maID']."' ORDER BY logID DESC LIMIT 0,30"); $time=0; $key;
|
|
while($row_anlage = $anlage->fetch_assoc()) {
|
|
if ($time==0) { $time=$row_anlage['zeit']; }
|
|
$status[$key]['diff']=gmdate("H:i", $time-$row_anlage['zeit']);
|
|
$time=$row_anlage['zeit'];
|
|
$status[$key]['zeit']=gmdate("d.m.Y - H:i",$row_anlage['zeit']);
|
|
$key++;
|
|
}
|
|
//-----------------------------------------------------------------------------------------------------------------------
|
|
// echo "<pre>"; print_r($status); echo "</pre>";
|
|
|
|
$template->assign('klog', $status);
|
|
$template->assign('j1', $j1);
|
|
$template->assign('j2', $j2);
|
|
$template->assign('j3', $j3);
|
|
$template->assign('j4', $j4);
|
|
|
|
$template->assign('content', 'tpl/ajax/ma_edit_sb.tpl');
|
|
?>
|