20 lines
No EOL
812 B
PHP
20 lines
No EOL
812 B
PHP
<?php
|
|
|
|
$kw_alt = (int)date('W',time()-604800);
|
|
$jahr_alt = (int)date('Y',time()-604800);
|
|
$key=0;
|
|
$lastweek = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw_alt."' and jahr='".$jahr_alt."' and typ='".$_POST['typ']."'");
|
|
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.tpl');
|
|
?>
|