38 lines
No EOL
1.5 KiB
PHP
38 lines
No EOL
1.5 KiB
PHP
<?php
|
|
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
|
|
$tagp = strtotime("+0 day");
|
|
$tag = date("d",$tagp);
|
|
$monat = date("m",$tagp);
|
|
$jahr = date("Y",$tagp);
|
|
$datum=$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()) {
|
|
$ma_id= array_search($row['mid'], array_column($a_fahrer, 'id'));
|
|
$maf1[$key]['fahrer']=$a_fahrer[$ma_id]['name'];
|
|
$pa_id= array_search($row['grund'], array_column($a_planbz, 'id'));
|
|
$maf1[$key]['bez']= $a_planbz[$pa_id]['bez'];
|
|
$maf1[$key]['icon']=$a_planbz[$pa_id]['icon'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE aktiv>0 AND 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()) {
|
|
$aa_id= array_search($row['fid'], array_column($a_fahrzg, 'id'));
|
|
$maf1[$key]['fahrer']=$a_fahrzg[$aa_id]['kz'];
|
|
$fa_id= array_search($row['grund'], array_column($a_planbf, 'id'));
|
|
$maf1[$key]['bez']= $a_planbz[$fa_id]['bez'];
|
|
$maf1[$key]['icon']=$a_planbz[$fa_id]['icon'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum', $datum);
|
|
$template->assign('kal', $maf1);
|
|
$template->assign('content', 'tpl/ajax/pkal_1.tpl');
|
|
?>
|