<?php
//error_reporting(E_ALL);
//ini_set('display_errors', 1);
require_once("head.php");
require_once("../../inc/config.inc.php");
$sql = "SELECT * FROM Schriftverkehr ORDER BY datum DESC";
$id = $_POST['id'];
$statement = $pdo->prepare("DELETE FROM Schriftverkehr WHERE id = $id");
$statement->execute(array('id' => $user["id"]));
require_once("navi.php");
?>
<style>
thead { background-color:#F0F0F0; color:green; font-size:12px; }
tbody { font-size:11px; }
</style>
<div class="container" style="margin-bottom:100px;">
<h1>Allgemein gesendete Emails</h1>
<hr />
<table class="table table-hover">
<thead>
<td>Sendedatum</td>
<td>Versender</td>
<td>Einrichtung/Firma</td>
<td>Anprechpartner</td>
<td>Adresse</td>
<td>Kontakt</td>
<td>Text</td>
<td> </td>
<td align="center">Löschen</td>
</thead>
<?php
foreach ($pdo->query($sql) as $row) {
?>
<tbody>
<td><?php echo date('d.m.Y', strtotime($row['datum'])) ?></td>
<td><?php echo $row['absende_vorname'].' '.$row['absende_nachname'] ?></td>
<td><?php echo $row['einrichtung_name'] ?></td>
<td><?php echo $row['anrede'] ?> <?php echo $row['vorname'] ?> <?php echo $row['nachname'] ?></td>
<td><?php echo $row['strasse'] ?> <?php echo $row['nr'] ?><br /><?php echo $row['plz'] ?> <?php echo $row['ort'] ?></td>
<td>Telefon: <?php echo $row['telefon'] ?><br />Email: <?php echo $row['email'] ?></td>
<td>
<?php echo $row['text'] ?>
</td>
<td> </td>
<td align="center">
<form action="#" method="post">
<input type="hidden" name="id" value="<?php echo $row["id"] ?>">
<button type="submit" name="submit" class="btn btn-default btn-xs">
<span class="glyphicon glyphicon-trash" style="padding:3px 3px 3px 3px; color:red;"></span>
</button>
</form>
</td>
</tbody>
<?php } ?>
</table>
</div>