21 lines
No EOL
897 B
PHP
21 lines
No EOL
897 B
PHP
<?php
|
|
|
|
error_reporting(E_ALL); ini_set('display_errors',1);
|
|
|
|
$kw_alt = date('W',time()-604800);
|
|
$jahr_alt = date('Y',time()-604800);
|
|
$key=0;
|
|
$lastweek = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw_alt."' and jahr='".$jahr_alt."' and typ=11 or kw='".$kw_alt."' and jahr='".$jahr_alt."' and typ=14");
|
|
while($row = $lastweek->fetch_assoc()) {
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$lw[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$lw[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$lw[$key]['kennz']=$row_autox['kz'];
|
|
$key++;
|
|
|
|
}
|
|
$template->assign('lw', $lw);
|
|
$template->assign('content', 'tpl/ajax/last_week_11.tpl');
|
|
?>
|