<?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)){
		
		$tag = '';
		$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;
?>