query($query);
$years = array();
while ($year = $res->fetch_assoc()) {
$years[] = $year["sy"];
}
$name = isset($_POST["section"]) && $_POST["section"]!="" ? $_POST["section"] : ($years[0] ?? 2017);
$table = "| Einsatzart | Anzahl Einsätze |
|---|
| |
";
$query = "select count(*) c,k.Name kn,k.Farbe,a.Name an from Einsätze b "
."left join Einsatzarten a on a.ID=b.Einsatzart "
."left join Einsatzkategorien k on k.ID=a.Einsatzkategorie "
."where year(Alarmierungszeit) = ? group by b.Einsatzart order by k.ID asc ";
$gesamt = array("Gesamt" => 0);
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param("i", $name);
$stmt->execute();
$res = $stmt->get_result();
while ($stat = $res->fetch_assoc()) {
$table.= "| ".$stat["an"]." | ".$stat["c"]." |
";
$gesamt["Gesamt"]+= $stat["c"];
if (!isset($gesamt[$stat["kn"]])) {
$gesamt[$stat["kn"]] = 0;
}
$gesamt[$stat["kn"]]+= $stat["c"];
}
} else {
$table.= "| ".$mysqli->error." |
";
}
$table.= "| |
| Summen |
|---|
| |
";
foreach ($gesamt as $k => $v) {
$table.= "| ".$k." | ".$v." |
";
}
$table.= "
";
$article = $_POST["article"] ?? "Empty";
$id = preg_replace('/\s+/', '', $article."_".$name);
?>