29 lines
No EOL
1.4 KiB
PHP
29 lines
No EOL
1.4 KiB
PHP
<?php
|
|
$tt = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE aktiv=1 ORDER BY typ,id"); $key=0;
|
|
while($row = $tt->fetch_assoc()) {
|
|
$tour=0; $tour=[$row['tour']];
|
|
|
|
$tmp2 = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$monat."' and jahr='".$jahr."' and tour='".$row['id']."'");
|
|
$touraktiv[$key]['wert']=$tmp2['num_rows'];
|
|
|
|
|
|
$stat=" "; $stat=[$row['status']];
|
|
|
|
if($row['smsstatus']==0) { $stat="<i class='fal fa-comment-alt fa-1x' style='color:gray' ></i>"; }
|
|
if($row['smsstatus']==1) { $stat="<i class='fas fa-comment-alt-exclamation fa-1x' style='color:orange' ></i>"; }
|
|
if($row['smsstatus']==2) { $stat="<i class='fas fa-comment-alt-check fa-1x' style='color:green' ></i>"; }
|
|
if($row['smsstatus']==8) { $stat="<i class='fas fa-comment-alt-dots fa-1x' style='color:gray' ></i>"; }
|
|
if($row['smsstatus']==20){ $stat="<i class='fas fa-spinner fa-spin fa-1x' style='color:gray' ></i>"; }
|
|
if($row['smsstatus']==3) { $stat="<i class='fas fa-comment-alt-times fa-1x' style='color:red' ></i>"; }
|
|
if($row['smsstatus']==4) { $stat="<i class='fas fa-comment-alt-times fa-1x' style='color:red' ></i>"; }
|
|
if($row['smsstatus']==5) { $stat="<i class='fas fa-comment-alt-times fa-1x' style='color:red' ></i>"; }
|
|
$t[]=$tour;
|
|
$s[]=$stat;
|
|
$key++;
|
|
}
|
|
$back['t'] = $t;
|
|
$back['s'] = $s;
|
|
$back['success'] = true;
|
|
$back['length'] = $key;
|
|
echo json_encode($back);
|
|
?>
|