66 lines
2.7 KiB
PHP
66 lines
2.7 KiB
PHP
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=4;
|
|
|
|
$kw_aktuell = (int)date('W');
|
|
$jahr_aktuell = (int)date('Y');
|
|
$key=0;
|
|
$rs_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw_aktuell."' and jahr='".$jahr_aktuell."' and typ=7");
|
|
while($row = $rs_tour->fetch_assoc()) {
|
|
$rskw[$key]['datum']=$row['tag'].".".$row['monat'].".".$row['jahr'];
|
|
$rskw[$key]['id']=$row['id'];
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$rskw[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$rskw[$key]['fahrer']=$row_fahrerx['name'];
|
|
$rskw[$key]['zeit']=$row['zeit'];
|
|
$rskw[$key]['gewicht']=$row['gewicht'];
|
|
$rskw[$key]['norm']=$row['Norm'];
|
|
$rskw[$key]['exemplare']=$row['exemplare'];
|
|
$rskw[$key]['pakete']=$row['Pakete'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$rskw[$key]['kennz']=$row_autox['kz'];
|
|
$rskw[$key]['infotext']=$row_tour['infotitel'];
|
|
$rskw[$key]['sms']="OK";
|
|
$key++;
|
|
}
|
|
$key=0;
|
|
$mp_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw_aktuell."' and jahr='".$jahr_aktuell."' and typ=10");
|
|
while($row = $mp_tour->fetch_assoc()) {
|
|
$mpkw[$key]['datum']=$row['tag'].".".$row['monat'].".".$row['jahr'];
|
|
$mpkw[$key]['id']=$row['id'];
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$mpkw[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$mpkw[$key]['fahrer']=$row_fahrerx['name'];
|
|
$mpkw[$key]['zeit']=$row['zeit'];
|
|
$mpkw[$key]['gewicht']=$row['gewicht'];
|
|
$mpkw[$key]['norm']=$row['Norm'];
|
|
$mpkw[$key]['exemplare']=$row['exemplare'];
|
|
$mpkw[$key]['pakete']=$row['Pakete'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$mpkw[$key]['kennz']=$row_autox['kz'];
|
|
$mpkw[$key]['infotext']=$row_tour['infotitel'];
|
|
$mpkw[$key]['sms']="OK";
|
|
$key++;
|
|
}
|
|
|
|
if(($week = date('W', mktime(0, 0, 0, 12, 31,$jahr_aktuell))) == 1) { $kwgesamt=52; } else { $kwgesamt=53; }
|
|
$key=0; $tmp=0;
|
|
for ($i = 1; $i <= $kwgesamt; $i++) {
|
|
$s_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE jahr='".$jahr_aktuell."' and kw='".$i."' and typ=7");
|
|
$kws[$key]=$i;
|
|
while($row = $s_tour->fetch_assoc()) {
|
|
$tmp=$tmp+$row['gewicht'];
|
|
|
|
}
|
|
$data[$key]=$tmp; $tmp=0;
|
|
$key++;
|
|
}
|
|
$template->assign('data',json_encode($data));
|
|
$template->assign('kws',json_encode($kws));
|
|
|
|
$template->assign('rskw', $rskw);
|
|
$template->assign('mpkw', $mpkw);
|
|
$template->assign('kw', $kw_aktuell);
|
|
$template->assign('content', 'tpl/rskw.tpl');
|
|
?>
|