0 && $_GET['wahl']==0) { $monat=$_GET['monat']; $jahr=$_GET['jahr']; } else { $jahr = (int)date('Y'); $monat = (int)date('m'); $kw_aktuell = (int)date('W'); } if($_GET['id']>0 OR $_POST['mid']>0) { if($_GET['id']>0) { $lmid=$_GET['id']; } if($_POST['mid']>0) { $lmid=$_POST['mid']; } $anzeige=1; $mitarbeiter = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$lmid."'"); $istjahr = (int)date('Y'); $lastjahr=$istjahr-1; //----------- zeitkonto $tmpkonto=$mitarbeiter['zeitkonto']; } //--------------------------- $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$lmid."'"); $ma_tmp = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER by name"); $key=0; while($row = $ma_tmp->fetch_assoc()) { $ma[$key]['zkonto']=$row['zeitkonto']; $tmpkonto=$row['zeitkonto']; //------------------------ if($row['zlvz']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=4 "); while($trow = $tl_tmp->fetch_assoc()) { //echo "

"; print_r($trow); echo "

"; $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zgh']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=3 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zpin']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=5 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zpost']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=6 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zrs']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=7 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zsaso']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=8 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zgrm']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=9 "); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zwerb']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=11"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zmb']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=12"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zfaz']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=15"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zpleer']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=16"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zlvzz']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=17"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zsasoz']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=18"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } if($row['zsonstige']==1) { $tl_tmp = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$monat."' AND jahr='".$jahr."' and fahrer='".$row['id']."' and typ=99"); while($trow = $tl_tmp->fetch_assoc()) { $tour_data = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$trow['tour']."'"); $tmpkonto=$tmpkonto-$tour_data['zeit']; } } //------------------------------ $ma[$key]['aktuell']=$tmpkonto; $ma[$key]['name']=$row['name']; $key++; } // $tmpkonto=$mitarbeiter['zeitkonto']; //echo $monat."-".$jahr; //--------------------------- $mitarbeiterlist_a = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER by name"); $mitarbeiterlist_d = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv<1 ORDER by name"); $template->assign('mitarbeiterlist_a', $mitarbeiterlist_a); $template->assign('mitarbeiterlist_d', $mitarbeiterlist_d); $template->assign('monat', $monat); $template->assign('jahr', $jahr); $template->assign('anzeige', $_GET['id']); $template->assign('ma', $ma); $template->assign('content', 'tpl/a_zeitk.tpl'); ?>