61 lines
No EOL
2.9 KiB
PHP
61 lines
No EOL
2.9 KiB
PHP
<?php
|
|
|
|
// echo'<pre>'; print_r($row_nichtda); echo'</pre>';
|
|
|
|
error_reporting(0);
|
|
ini_set('display_errors',0);
|
|
header('Content-Type: text/html; charset=utf-8');
|
|
//-----------------------------------------------------
|
|
$wochentag=date('w');
|
|
$jahr = (int)date('Y');
|
|
$kw = (int)date('W');
|
|
//-----------------------------------------------------
|
|
//-----------------------------------------------------
|
|
//-------------------- wiederkehrende abfragen -------------------------------------------------
|
|
$a_touren = $GLOBALS['a_touren'];
|
|
$a_fahrzg = $GLOBALS['a_fahrzg'];
|
|
$a_fahrer = $GLOBALS['a_fahrer'];
|
|
$a_planbz = $GLOBALS['a_planbz'];
|
|
$a_planbf = $GLOBALS['a_planbf'];
|
|
//-----------------------------------------------------
|
|
//-----------------------------------------------------
|
|
//-----------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------------------------
|
|
//-------- Sachsen-Sonntag 2019 neu -----------------------------------------------------------------------------------------------------
|
|
//--------------------------------------------------------------------------------------------------------------------------------------
|
|
if($wochentag==4 || $wochentag==5 || $wochentag==6 || $wochentag==0) { //------------------------- donnerstag bis Sonntag Saso laden
|
|
//--------------------------------------------------------------------------------------------------------------------------------------
|
|
//---------------------------------------- Halle Block
|
|
$key=0;
|
|
$saso_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and typ=19 ORDER BY tour");
|
|
while($row = $saso_tour->fetch_assoc()) {
|
|
$saso_tour1[$key]['binfo']='Block: '.$row['utyp'].' geplant: '.$row['zeit']." Uhr";
|
|
$wechsel=$row['utyp'];
|
|
$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
|
|
$aa_id= array_search($row['auto'], array_column($a_fahrzg, 'id'));
|
|
$ma_id= array_search($row['fahrer'], array_column($a_fahrer, 'id'));
|
|
$saso_tour1[$key]['start']=$key;
|
|
$saso_tour1[$key]['aktiv']=$a_touren[$ta_id]['aktiv'];
|
|
$saso_tour1[$key]['tour']=$a_touren[$ta_id]['tour3'];
|
|
$saso_tour1[$key]['auto']=$a_fahrzg[$aa_id]['kz'];
|
|
$saso_tour1[$key]['status']=$row['status'];
|
|
$saso_tour1[$key]['fahrerid']=$row['fahrer'];
|
|
$saso_tour1[$key]['zeit']=$row['zeit'];
|
|
$saso_tour1[$key]['autoid']=$row['auto'];
|
|
$saso_tour1[$key]['fahrer']=$a_fahrer[$ma_id]['name'];
|
|
$saso_tour1[$key]['look']=$row['fertig'];
|
|
$saso_tour1[$key]['gewicht']=$row['gewicht'];
|
|
$saso_tour1[$key]['gewicht4']=$row['gewicht4'];
|
|
$sasonorm=$row['Norm'];
|
|
$key++;
|
|
}
|
|
$template->assign('saso_tour',$saso_tour1);
|
|
$template->assign('sasoanzeige',$key);
|
|
$template->assign('sasonorm',$sasonorm);
|
|
}
|
|
|
|
|
|
$template->assign('kw', $kw);
|
|
|
|
$template->assign('content', 'tpl/ajax/pi_werbung19.tpl');
|
|
?>
|