229 lines
No EOL
12 KiB
PHP
229 lines
No EOL
12 KiB
PHP
<?php
|
|
$_SESSION['m1']=7; $_SESSION['m2']=0;
|
|
|
|
error_reporting(E_ALL); ini_set('display_errors', 1);
|
|
|
|
// echo "<pre>"; print_r($tarifi); echo "</pre>";
|
|
|
|
|
|
/*
|
|
$test = $GLOBALS['mysql']->query("SELECT id,name FROM fahrzeuge ORDER BY id ASC");
|
|
while($row = $test->fetch_assoc()) {
|
|
//$testarray = array($row[$row['id']]['id'],$row['name']); echo "<pre>"; print_r($row); echo "</pre>";
|
|
$testarray[$row['id']]['id']=$row['id'];
|
|
$testarray[$row['id']]['name']=$row['name'];
|
|
|
|
}
|
|
$template->assign('testarray', $testarray);
|
|
|
|
echo "<pre>"; print_r($testarray); echo "</pre>";
|
|
*/
|
|
|
|
|
|
|
|
|
|
|
|
$maf1=[];$maf2=[];$maf3=[];$maf4=[];$maf5=[];
|
|
$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
|
|
|
|
$tagp = strtotime("+0 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day1=$tag.".".$monat.".".$jahr; $tna1=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$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'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf1[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf1[$key]['bez']=$jahre.". Geburtstag"; $maf1[$key]['icon']="bday.png";
|
|
$key++;
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf1[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf1[$key]['bez']=$row_icon['bez'];
|
|
$maf1[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+1 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$tag.".".$monat.".".$jahr; $tna2=$tagname[date("w",$tagp)];
|
|
$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++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf2[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf2[$key]['bez']=$jahre.". Geburtstag"; $maf2[$key]['icon']="bday.png";
|
|
$key++;
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf2[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf2[$key]['bez']=$row_icon['bez'];
|
|
$maf2[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+2 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day3=$tag.".".$monat.".".$jahr; $tna3=$tagname[date("w",$tagp)];
|
|
$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++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf3[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf3[$key]['bez']=$jahre.". Geburtstag"; $maf3[$key]['icon']="bday.png";
|
|
$key++;
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf3[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf3[$key]['bez']=$row_icon['bez'];
|
|
$maf3[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+3 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day4=$tag.".".$monat.".".$jahr; $tna4=$tagname[date("w",$tagp)];
|
|
$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++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf4[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf4[$key]['bez']=$jahre.". Geburtstag"; $maf4[$key]['icon']="bday.png";
|
|
$key++;
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf4[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf4[$key]['bez']=$row_icon['bez'];
|
|
$maf4[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+4 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day5=$tag.".".$monat.".".$jahr; $tna5=$tagname[date("w",$tagp)];
|
|
$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++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf5[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf5[$key]['bez']=$jahre.". Geburtstag"; $maf5[$key]['icon']="bday.png";
|
|
$key++;
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf5[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf5[$key]['bez']=$row_icon['bez'];
|
|
$maf5[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
//-------------------------------------------------------------------------------------------------------------
|
|
$madata = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv=1 ORDER BY id DESC LIMIT 0,3");
|
|
//-------------------------------------------------------------------------------------------------------------
|
|
$test = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE aktiv=1"); $ma_aktive=$test['num_rows'];
|
|
$test = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE aktiv=0"); $ma_inaktive=$test['num_rows'];
|
|
$test = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE aktiv>1"); $ma_sonstige=$test['num_rows'];
|
|
//-------------------------------------------------------------------------
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter ORDER BY name"); $key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$temp=0;
|
|
if (empty($row['strasse'])&& $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Anschrift: Strasse/Hnr."; $key++; $temp++; }
|
|
if (empty($row['plz'])&& $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Anschrift: Postleitzahl"; $key++; $temp++; }
|
|
if (empty($row['ort'])&& $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Anschrift: Wohnort"; $key++; $temp++; }
|
|
if (empty($row['handy'])&& $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Handynummer"; $key++; $temp++; }
|
|
if($row['gebtag']== 0 && $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Geburtsdatum"; $key++; $temp++; }
|
|
if($row['eintag']== 0 && $row['aktiv']==1) { $mafehler[$key]['name']=$row['name']; $mafehler[$key]['grund']="Eintrittsdatum"; $key++; $temp++; }
|
|
if($temp>0) { $mafehler[$key]['line']=1; }
|
|
}
|
|
|
|
|
|
//-------------------------------------------------------------------------
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter ORDER BY name"); $key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
if($row['austag']== 0 && $row['aktiv']==0) { $maerror[$key]['name']=$row['name']; $maerror[$key]['grund']="Austrittsdatum"; $key++; }
|
|
}
|
|
//-------------------------------------------------------------------------
|
|
|
|
|
|
//-------------------------------------------------------------------------
|
|
|
|
|
|
|
|
//-------------------------------------------
|
|
$template->assign('maf1', $maf1);
|
|
$template->assign('maf2', $maf2);
|
|
$template->assign('maf3', $maf3);
|
|
$template->assign('maf4', $maf4);
|
|
$template->assign('maf5', $maf5);
|
|
//-------------------------------------------
|
|
$template->assign('day1', $day1);
|
|
$template->assign('day2', $day2);
|
|
$template->assign('day3', $day3);
|
|
$template->assign('day4', $day4);
|
|
$template->assign('day5', $day5);
|
|
//-------------------------------------------
|
|
$template->assign('tna1', $tna1);
|
|
$template->assign('tna2', $tna2);
|
|
$template->assign('tna3', $tna3);
|
|
$template->assign('tna4', $tna4);
|
|
$template->assign('tna5', $tna5);
|
|
//--------------------------------------------
|
|
$template->assign('madata', $madata);
|
|
$template->assign('mafehler', $mafehler);
|
|
$template->assign('maerror', $maerror);
|
|
$template->assign('ma_aktive', $ma_aktive);
|
|
$template->assign('ma_inaktive', $ma_inaktive);
|
|
$template->assign('ma_sonstige', $ma_sonstige);
|
|
|
|
$template->assign('content', 'tpl/mainfo.tpl');
|
|
?>
|