steven/jb-data.de
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
jb-data.de/scripts/heute1.php
steven 72a26edcff init
2025-08-11 22:23:30 +02:00

274 lines
No EOL
13 KiB
PHP
Raw Permalink Blame History

<?php
$tagp = strtotime("+0 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day1=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf1[$key]['tag']=$tag;
$maf1[$key]['monat']=$row['monat'];
$maf1[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf1[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf1[$key]['bez']=$row_icon['bez'];
$maf1[$key]['icon']=$row_icon['icon'];
$maf1[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+1 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf2[$key]['tag']=$tag;
$maf2[$key]['monat']=$row['monat'];
$maf2[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf2[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf2[$key]['bez']=$row_icon['bez'];
$maf2[$key]['icon']=$row_icon['icon'];
$maf2[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+2 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day3=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf3[$key]['tag']=$tag;
$maf3[$key]['monat']=$row['monat'];
$maf3[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf3[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf3[$key]['bez']=$row_icon['bez'];
$maf3[$key]['icon']=$row_icon['icon'];
$maf3[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+3 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day4=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf4[$key]['tag']=$tag;
$maf4[$key]['monat']=$row['monat'];
$maf4[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf4[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf4[$key]['bez']=$row_icon['bez'];
$maf4[$key]['icon']=$row_icon['icon'];
$maf4[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+4 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day5=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf5[$key]['tag']=$tag;
$maf5[$key]['monat']=$row['monat'];
$maf5[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf5[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf5[$key]['bez']=$row_icon['bez'];
$maf5[$key]['icon']=$row_icon['icon'];
$maf5[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+5 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day6=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf6[$key]['tag']=$tag;
$maf6[$key]['monat']=$row['monat'];
$maf6[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf6[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf6[$key]['bez']=$row_icon['bez'];
$maf6[$key]['icon']=$row_icon['icon'];
$maf6[$key]['info']=$row['info'];
$key++;
}
$tagp = strtotime("+6 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day7=$tag.".".$monat.".".$jahr;
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$key=0;
while($row = $test->fetch_assoc()) {
$maf7[$key]['tag']=$tag;
$maf7[$key]['monat']=$row['monat'];
$maf7[$key]['jahr']=$row['jahr'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
$maf7[$key]['fahrer']=$row_fahrerx['name'];
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
$maf7[$key]['bez']=$row_icon['bez'];
$maf7[$key]['icon']=$row_icon['icon'];
$maf7[$key]['info']=$row['info'];
$key++;
}
// $success="Neu: Kalender (Urlaub-frei-krank) ***** Datenbank anpassung Feiertage 2014 ***** PIN Touren 04/12/14-a added";
// $template->assign('information', $success);
//------------------------------------------------------------------------- änder kw !!!!!!!!!!!!
$tag1_jahr = date("Y");
$tag1_monat = date("m");
$tag1_tag = date("d");
//---------------------------- änderungen !!!!!!!!!!
$wtag = date("w");
if($wtag == "0") {
$tp1 = strtotime("+1 day");
$tp2 = strtotime("+2 day");
} else if($wtag == "6") {
$tp1 = strtotime("+0 day");
$tp2 = strtotime("+2 day");
} else {
$tp1 = strtotime("+0 day");
$tp2 = strtotime("+1 day");
}
$tag1 = date("d.m.Y", $tp1); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1);
$tag2 = date("d.m.Y", $tp2); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2);
//---------------------------- heute änderungen !!!!!!!!!!
$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'"); $key=0;
while($row = $tour1->fetch_assoc()) {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
$stamm=0;
$stamma=$row_tour['s_auto'];
$stammf=$row_tour['s_fahrer'];
if($stamma != $row['auto'] OR $stammf != $row['fahrer']) { $stamm=1; }
if($row['typ']==3) {
$gh1[$key]['id']=$row['id'];
$gh1[$key]['stamm']=$stamm;
$gh1[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$gh1[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$gh1[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==4) {
$lvz1[$key]['id']=$row['id'];
$lvz1[$key]['stamm']=$stamm;
$lvz1[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$lvz1[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$lvz1[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==5) {
$pin1[$key]['id']=$row['id'];
$pin1[$key]['stamm']=$stamm;
$pin1[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$pin1[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$pin1[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==6) {
$post1[$key]['id']=$row['id'];
$post1[$key]['stamm']=$stamm;
$post1[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$post1[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$post1[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']>6) {
$werb1[$key]['id']=$row['id'];
$werb1[$key]['stamm']=$stamm;
$werb1[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$werb1[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$werb1[$key]['kennz']=$row_auto1['kz']; $key++;
}
}
//---------------------------- morgen änderungen !!!!!!!!!!
$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'"); $key=0;
while($row = $tour1->fetch_assoc()) {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
$stamma=$row_tour['s_auto'];
$stammf=$row_tour['s_fahrer'];
$stamm=0;
if($stamma != $row['auto'] OR $stammf != $row['fahrer']) { $stamm=1; }
if($row['typ']==3) {
$gh2[$key]['id']=$row['id'];
$gh2[$key]['stamm']=$stamm;
$gh2[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$gh2[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$gh2[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==4) {
$lvz2[$key]['id']=$row['id'];
$lvz2[$key]['stamm']=$stamm;
$lvz2[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$lvz2[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$lvz2[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==5) {
$pin2[$key]['id']=$row['id'];
$pin2[$key]['stamm']=$stamm;
$pin2[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$pin2[$key]['fahrer']=$row_fahrer1['name'];
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$pin2[$key]['kennz']=$row_auto1['kz']; $key++;
}
if($row['typ']==6) {
$post2[$key]['id']=$row['id'];
$post2[$key]['stamm']=$stamm;
$post2[$key]['tour']=$row_tour['tour'];
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$post2[$key]['fahrer']=$row_fahrer1['name'];
$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$post2[$key]['kennz']=$row_auto2['kz']; $key++;
}
if($row['typ']>6) {
$werb2[$key]['id']=$row['id'];
$werb2[$key]['stamm']=$stamm;
$werb2[$key]['tour']=$row_tour['tour'];
$row_fahrer2 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$werb2[$key]['fahrer']=$row_fahrer2['name'];
$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
$werb2[$key]['kennz']=$row_auto2['kz']; $key++;
}
}
$template->assign('maf1', $maf1);
$template->assign('maf2', $maf2);
$template->assign('maf3', $maf3);
$template->assign('maf4', $maf4);
$template->assign('maf5', $maf5);
$template->assign('maf6', $maf6);
$template->assign('maf7', $maf7);
$template->assign('day1', $day1);
$template->assign('day2', $day2);
$template->assign('day3', $day3);
$template->assign('day4', $day4);
$template->assign('day5', $day5);
$template->assign('day6', $day6);
$template->assign('day7', $day7);
$template->assign('gh1', $gh1);
$template->assign('lvz1', $lvz1);
$template->assign('pin1', $pin1);
$template->assign('post1', $post1);
$template->assign('werb1', $werb1);
$template->assign('gh2', $gh2);
$template->assign('lvz2', $lvz2);
$template->assign('pin2', $pin2);
$template->assign('post2', $post2);
$template->assign('werb2', $werb2);
$template->assign('tag1', $tag1);
$template->assign('tag2', $tag2);
$template->assign('content', 'tpl/heute1.tpl');
?>
Reference in a new issue View git blame Copy permalink