75 lines
No EOL
2.1 KiB
PHP
75 lines
No EOL
2.1 KiB
PHP
<?php
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 0);
|
|
|
|
|
|
|
|
$monat = (int)date('n');
|
|
$jahr = (int)date('Y');
|
|
$kw_aktuell = (int)date('W');
|
|
|
|
|
|
if(isset($_POST['save'])) {
|
|
$monat=$_POST['ma2'];
|
|
$jahr=$_POST['ma3'];
|
|
}
|
|
//------------------ FAZ
|
|
$i=0; $stag=0; $key=0;
|
|
for($i = 0; $i < date("t", $monat); $i++) {
|
|
$monat2 = mktime(0, 0, 0, $monat,$i, $jahr);
|
|
if(date("w", $monat2)==0) {
|
|
$faz_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$i."' and monat='".$_POST['ma2']."' and jahr='".$_POST['ma3']."' and typ=15") ;
|
|
while($row = $faz_tour->fetch_assoc()) {
|
|
$row_tour1 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$tour1[$key]['tour']=$row_tour1['tour'];
|
|
$afirma=$row_tour1['afirma'];
|
|
$stammf=$row_tour1['s_fahrer'];
|
|
if($stammf == $row['fahrer']) { $tour1[$key]['fremd']=1; } else { $tour1[$key]['fremd']=0; }
|
|
$tour1[$key]['id']=$row['id'];
|
|
$tour1[$key]['tag']=$row['tag'];
|
|
$tour1[$key]['monat']=$row['monat'];
|
|
$tour1[$key]['jahr']=$row['jahr'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$tour1[$key]['fahrer']=$row_fahrerx['name'];
|
|
$tour1[$key]['infotext']=$row['infotext'];
|
|
$tour1[$key]['exemplare']=$row['exemplare'];
|
|
$summe[$afirma]['menge']=$summe[$afirma]['menge']+$row['exemplare'];
|
|
$row_tour2 = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$afirma."'");
|
|
$summe[$afirma]['firma']=$row_tour2['name'];
|
|
$key++;
|
|
}
|
|
$stag++;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$ma2['id']= array(1,2,3,4,5,6,7,8,9,10,11,12);
|
|
$ma2['name']=array("Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");
|
|
$ma2['monat']=$monat;
|
|
$ma3['id']= array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
|
|
$ma3['name']=array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
|
|
$ma3['jahr']=$jahr;
|
|
|
|
$template->assign('summe', $summe);
|
|
$template->assign('ma2', $ma2);
|
|
$template->assign('ma3', $ma3);
|
|
$template->assign('monat', $monat);
|
|
$template->assign('jahr', $jahr);
|
|
$template->assign('tour1', $tour1);
|
|
$template->assign('content', 'tpl/a_faz.tpl'); //_list
|
|
|
|
?>
|