<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$IIIIIIIIIIl1 = new SQLite3('./a/.eggziedb.db');
$IIIIIIIIIIl1->exec('CREATE TABLE IF NOT EXISTS ibo(id INTEGER PRIMARY KEY NOT NULL,mac_address VARCHAR(100),username VARCHAR(100),password VARCHAR(100),expire_date VARCHAR(100),url VARCHAR(100),title VARCHAR(100),created_at VARCHAR(100))');

$IIIIIIIIII1I = $IIIIIIIIIIl1->query('SELECT * FROM ibo');

if (isset($_POST['submit'])) {
    $IIIIIII1lll1 = strtotime($_POST['expire_date']);
    $IIIIIII1ll1l = date('Y-m-d', $IIIIIII1lll1);
    $IIIIIII1ll11 = date('Y-m-d');
    $IIIIIII1l1II = date('h:m:s');
    $IIIIIII1l1Il = $IIIIIII1ll11 . 'T' . $IIIIIII1l1II . '.000000Z';

    $IIIIIIIIIIl1->exec('INSERT INTO ibo(mac_address, username, password, expire_date, url, title, created_at) VALUES(\'' . strtoupper($_POST['mac_address']) . '\', \'' . $_POST['username'] . '\', \'' . $_POST['password'] . '\', \'' . $IIIIIII1ll1l . '\', \'' . $_POST['dns'] . '\', \'' . $_POST['title'] . '\',\'' . $IIIIIII1l1Il . '\')');

    $IIIIIIIIIIl1->close();
    header('Location: users.php');
}

include 'includes/header.php';
?>

<div class="container-fluid">

    <h1 class="h3 mb-1 text-gray-800">Ativar Usuário</h1>

    <div class="card border-left-primary shadow h-100 card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary"><i class="fas fa-user"></i> Detalhes do Usuário</h6>
        </div>
        <div class="card-body">
            <form method="post">

                <div class="form-group">
                    <label class="control-label" for="mac_address">
                        <strong>Endereço MAC</strong>
                    </label>
                    <div class="input-group">
                        <input class="form-control text-primary" id="description" name="mac_address" placeholder="Digite o Endereço MAC" type="text" required/>
                    </div>
                </div>

                <div class="form-group">
                    <label class="control-label" for="title">
                        <strong>Nome do Servidor</strong>
                    </label>
                    <div class="input-group">
                        <input type="text" class="form-control text-primary" name="title" placeholder="Digite o Nome do Servidor" id="discription" required/>
                    </div>
                </div>

                <div class="form-group">
                    <label class="control-label" for="dns">
                        <strong>DNS</strong>
                    </label>
                    <div class="input-group">
                        <input type="text" class="form-control text-primary" name="dns" placeholder="Digite o DNS" id="discription" required/>
                    </div>
                </div>

                <div class="form-group">
                    <label class="control-label" for="username">
                        <strong>Usuário</strong>
                    </label>
                    <div class="input-group">
                        <input type="text" class="form-control text-primary" name="username" placeholder="Digite o Usuário" id="discription" required/>
                    </div>
                </div>

                <div class="form-group">
                    <label class="control-label" for="password">
                        <strong>Senha</strong>
                    </label>
                    <div class="input-group">
                        <input type="text" class="form-control text-primary" name="password" placeholder="Digite a Senha" id="discription" required/>
                    </div>
                </div>

                <div class="form-group">
                    <label class="control-label" for="expire_date">
                        <strong>Validade</strong>
                    </label>
                    <div class="input-group">
                        <input type="text" placeholder="AAAA-MM-DD" class="form-control text-primary" name="expire_date" id="datetimepicker"/> 
                    </div>
                </div>

                <div class="form-group">
                    <div>
                        <button class="btn btn-success btn-icon-split" name="submit" type="submit">
                            <span class="icon text-white-50"><i class="fas fa-check"></i></span>
                            <span class="text">Enviar</span>
                        </button>
                    </div>
                </div>

            </form>
        </div>
    </div>

    <br><br><br>

<?php
include 'includes/footer.php';
?>

<script>
const macInput = document.getElementById('description');

macInput.addEventListener('input', function(e) {
    let value = macInput.value.toUpperCase().replace(/[^A-F0-9]/g, ''); // remove caracteres inválidos
    let formatted = '';
    
    for (let i = 0; i < value.length; i++) {
        formatted += value[i];
        if ((i + 1) % 2 === 0 && i !== value.length - 1) {
            formatted += ':';
        }
    }

    macInput.value = formatted;
});

$('#confirm-delete').on('show.bs.modal', function(e) {
    $(this).find('.btn-ok').attr('href', $(e.relatedTarget).data('href'));
});
</script>

</body>
</html>