Newer
Older
<?php
head("Bilanzsystem");
echo 'Hier eine übersicht über die Einnahmen und Ausgaben der Seite';
foot();
$aus = '';
$da = db_query("SELECT datum FROM ". $db_prefix ."_bilanz GROUP BY datum ORDER BY datum ASC ");
while($d = mysqli_fetch_array($da)){
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
$saldo_tag = 0;
$g_d = db_query("SELECT gruppe FROM ". $db_prefix ."_bilanz WHERE datum = '". $d['datum'] ."' GROUP BY gruppe");
while($g = mysqli_fetch_array($g_d)){
$gruppe = '
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">'. $g['gruppe'] .'</h3>
</div>
<div class="panel-body">
<table class="table table-hover">
<tr>
<th>Typ</th>
<th>Einnahmen</th>
<th>Ausgaben</th>
</tr>
';
$saldo = 0;
$b_g = db_query("SELECT * FROM ". $db_prefix ."_bilanz WHERE gruppe = '". $g['gruppe'] ."' AND datum = '". $d['datum'] ."' ");
while($b = mysqli_fetch_array($b_g)){
if($b['ein'] < $b['aus']){
$class = 'alert alert-danger';
$saldo_plus += $b['ein'];
$saldo_minus += $b['aus'];
}else{
$class = 'alert alert-success';
$saldo_plus += $b['ein'];
$saldo_minus += $b['aus'];
}
$saldo = $saldo_tag+$b['ein']-$b['aus'];
$saldo_tag = $saldo_tag+$b['ein']-$b['aus'];
$gruppe .= '
<tr class="'. $class .'">
<td>'. $b['name'] .'</td>
<td>'. $b['ein'] .'</td>
<td>'. $b['aus'] .'</td>
</tr>
';
}
$gruppe .= '
</table>
Gewinn/Verlust: '. number_format($saldo,0,',','.') .'
</div>
</div>
';
$tag .= $gruppe;
}
$tag .= 'Tagessaldo:'. number_format($saldo_tag,0,',','.');
if($saldo_tag >= 0){ $farbe_tag = 'alert alert-success';}else{ $class = 'alert alert-danger';}
$aus .= '
<div class="panel-group '. $farbe_tag .'" id="accordion" role="tablist" aria-multiselectable="true">
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="'. $d['datum'] .'">
<h4 class="panel-title">
<a role="button" data-toggle="collapse" data-parent="#accordion" href="#collapse'. $d['datum'] .'" aria-expanded="false" aria-controls"collapse'. $d['datum'] .'">
'. date("d.m.Y", $d['datum']) .' || Tagessaldo: '. number_format($saldo_tag,0,',','.').'
</a>
</h4>
</div>
<div id="collapse'. $d['datum'] .'" class="panel-collapse collapse" role="tabpanel" aria-labelledby="'. $d['datum'] .'">
<div class="panel-body">';
$aus .= $tag.'
</div>
</div>
</div>
</div>
';
}
echo $aus;
?>