41 lines
No EOL
1.6 KiB
PHP
41 lines
No EOL
1.6 KiB
PHP
<?php
|
|
$tag=$_POST['tag']; $monat=$_POST['monat']; $jahr=$_POST['jahr'];
|
|
$tourd = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and typ in (3,4,5,17) ORDER BY tour");
|
|
$key=0;
|
|
while($row = $tourd->fetch_assoc()) {
|
|
$back[$key]['id']=$row['id'];
|
|
if($row['fahrer']==0) {
|
|
$back['$tour']="<i class='fa fa-times' style='color:#000000;'></i>";
|
|
} else {
|
|
if ($row['smsstatus']==0) { $back[$key]['tour']="<i class='fa fa-commenting-o' style='color:#0080FF;'></i>"; }
|
|
if ($row['smsstatus']==1) { $back[$key]['tour']="<i class='fa fa-check-square-o' style='color:#FF8000;'></i>"; }
|
|
if ($row['smsstatus']==2) { $back[$key]['tour']="<i class='fa fa-check-square-o' style='color:#04B404;'></i>"; }
|
|
if ($row['smsstatus']==3) { $back[$key]['tour']="<i class='fa fa-exclamation-triangle' style='color:#FF8000;'></i>"; }
|
|
if ($row['smsstatus']==4) { $back[$key]['tour']="<i class='fa fa-check-square-o' style='color:#FF8000;'></i>"; }
|
|
if ($row['smsstatus']==5) { $back[$key]['tour']="<i class='fa fa-ban' style='color:#ff0000;'></i>"; }
|
|
if ($row['smsstatus']==8) { $back[$key]['tour']="<i class='fa fa-check-square-o' style='color:#C0C0C0;'></i>"; }
|
|
if ($row['smsstatus']==20) { $back[$key]['tour']="<i class='fa fa-spinner fa-pulse' style='color:#FF8000;'></i>"; }
|
|
if ($row['smsstatus']==99) { $back[$key]['tour']="<i class='fa fa-question' style='color:#FF8000;'></i>"; }
|
|
|
|
}
|
|
$key++;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
echo json_encode($back);
|
|
//echo $back;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//$template->assign('data', $tourd);
|
|
//$template->assign('content', 'tpl/ajax/sms_nacht.tpl');
|
|
?>
|