<?php

// Oktober 2019

require_once('../includes/config.php');
$modulname = 'Crud';
require_once(INC_DIR.'header.php');

if (!$user->is_logged_in()){
header('Location: login.php');
exit;
}

$repository = new PDODatenRepository($db);

echo '<div class="grid">'."\n";
echo '<div class="g12">'."\n\n";

echo '<section><h5><a href="/">Startseite</a> - <a href="/admin">Admin</a> - <a href="crud.php">'.$modulname.'</a></h5></section>'."\n\n";

if (isset($_GET['delcrud'])){
$entitiy = $repository->findById($_GET['id']);
$repository->delete($entity);
header('Location: crud.php');
exit;
}

?>

<script>
function delcrud(id, title){
if (confirm('Den Eintrag von "' + title + '" wirklich löschen ?')){
window.location.href = 'crud.php?delcrud=' + id;
}
}
</script>

<?php

$id = filter_input(INPUT_GET, 'id', FILTER_VALIDATE_INT);

// CREATE
if (isset($_POST['neu'])){

$entitty = DataFactory::fromPostArray($_POST);
$repository->add($entity);
header('Location: crud.php');
exit;
}

// UPDATE
if (isset($_POST['aendern'])){

$entity = $repository->findById((int)$_POST['id']);
$entitiy->setVorname($_POST['vorname']);
// weitere felder
$repository->replace($entitiy);


exit;
}



echo '<article>';

// FORMULAR
if (isset($_GET['action']) && $_GET['action'] == 'update'){
$entity = $repository->findById((int)$_GET['id']);
// EDIT
echo '<h3>'.$modulname.' ID: '.$id.' Ändern</h3>'."\n";
echo '<form method="post">'."\n";
echo '<p>';
echo '<input type="text" name="vorname" value="'.$entity->getVorname().'" placeholder="Vorname" required>'."\n";
echo '<input type="text" name="nachname" value="'.$entity->getNachname().'" placeholder="Nachname">'."\n";
echo '<input type="text" name="email" value="'.$email.'" placeholder="eMail">'."\n";
echo '<input type="text" name="telefon" value="'.$telefon.'" placeholder="Telefon">'."\n";
echo '<input type="text" name="datum" value="'.sicher($row['datum']).'" placeholder="'.$datum.'">';
echo '<input type="submit" name="aendern" value="Ändern">'."\n";
echo '</p>';
echo '</form>'."\n\n";
}
else {
// ADD
echo '<h3>'.$modulname.' Hinzufügen</h3>'."\n";
echo '<form method="post">'."\n";
echo '<p>';
echo '<input type="text" name="vorname" placeholder="Vorname" required>'."\n";
echo '<input type="text" name="nachname" placeholder="Nachname">'."\n";
echo '<input type="text" name="email" placeholder="eMail">'."\n";
echo '<input type="text" name="telefon" placeholder="Telefon">'."\n";
echo '<input type="submit" name="neu" value="Hinzufügen">'."\n";
echo '</p>';
echo '</form>'."\n\n";
}

echo '</article>';

echo '<article>';
echo '<h3>'.$modulname.' Daten</h3>'."\n";

echo '<table>';
echo '<tr><th>ID</th><th>CRUD</th><th>KONTAKT</th><th>DATUM</th><th class="textmitte">OPTION</th></tr>';

$pages = new Paging('5','seite');
$entities = $repository->findAll($pages->get_limit());

echo '<tr>'."\n";
echo '<td>'.$id.'</td>'."\n";
echo '<td>'.$vorname.'<br>'.$nachname.'</td>'."\n";
echo '<td>'.$email.'<br>'.$telefon.'</td>'."\n";
echo '<td>'.$datum.'</td>'."\n";
echo '<td class="textmitte">';
echo '<a class="buttonblau" href="crud.php?action=update&amp;id='.$id.'" title="Ändern"><i class="fas fa-pencil-alt"></i></a>'."\n";
echo '<a class="buttonrot" href=\'javascript:delcrud("'.$id.'","'. $vorname.'")\' title="Löschen"><i class="fas fa-trash"></i></a>';
echo '</tr>'."\n\n";
}

echo '</table>'."\n\n";

echo '</article>';

echo $pages->page_links();

echo '</div>'."\n\n";
echo '</div>'."\n\n";

require_once(INC_DIR.'footer.php');

?>