<?php
    $SQLITE = "sqlite:db.sqlite";

    $pdo = new PDO($SQLITE);

    function doLogin($user, $pass){
        global $pdo;

        $pass = md5(md5($pass));

        $query = $pdo -> prepare('select * from users where user = :user and pass = :pass');
        $query -> bindParam(':user', $user, PDO::PARAM_STR);
        $query -> bindParam(':pass', $pass, PDO::PARAM_STR);

        $query -> execute();

        $result = $query -> fetchAll();

        if(count($result) > 0){
            session_start();
            $_SESSION['user'] = $user;
            $_SESSION['pass'] = $pass;
            return true;
        }else{
            return false;
        }
    }

    function checkLogin(){
        session_start();
        if(!isset($_SESSION['user']) || !isset($_SESSION['pass'])){
            Header('Location: login.php');
        }
    }

    function logOut(){
        session_start();
        session_destroy();
        Header('Location: login.php');
    }

    function addMsg($nome, $telefone, $assunto, $mensagem){
        $SQLITE = "sqlite:./admin/db.sqlite";

        $pdo = new PDO($SQLITE);

        $query = $pdo -> prepare("insert into mensagens(nome, telefone, assunto, mensagem, lida) values(:nome, :telefone, :assunto, :mensagem, 'false')");
        $query -> bindParam(':nome', $nome, PDO::PARAM_STR);
        $query -> bindParam(':telefone', $telefone, PDO::PARAM_STR);
        $query -> bindParam(':assunto', $assunto, PDO::PARAM_STR);
        $query -> bindParam(':mensagem', $mensagem, PDO::PARAM_STR);
        $query -> execute();
    }

    function getMensangens(){
        global $pdo;

        $query = $pdo -> prepare("select * from mensagens where lida = 'false'");
        $query -> execute();

        $rows = $query -> fetchAll();

        echo "<table class='table_mensagens'>";
        echo '<tr>';
        echo '<td><b>Nome:</b></td>';
        echo '<td><b>Telefone:</b></td>';
        echo '<td><b>Assunto:</b></td>';
        echo '<td><b>Mensagem:</b></td>';
        echo '<td><b>Opção:</b></td>';
        echo '</tr>';

        foreach($rows as $row){
            echo ('<tr>');
            echo ('<td>'.$row['nome'].' </td>');
            echo ('<td>'.$row['telefone'].' </td>');
            echo ('<td>'.$row['assunto'].' </td>');
            echo ('<td>'.$row['mensagem'].' </td>');
            echo ("<td><a href='marca_como_lida.php?id=".$row['id']."' class='a_btn'>Marcar como lido</a></td>");
            echo ('</tr>');
        }

        echo '</table>';
    }

    function apagaMensagem($id){
        global $pdo;

        $query = $pdo -> prepare("update mensagens set lida = 'true' where id = :id");
        $query -> bindParam(":id", $id, PDO::PARAM_STR);
        $query -> execute();
    }

    function addUser($user, $pass){
        global $pdo;

        $query = $pdo -> prepare("insert into users(user, pass) values(:user, :pass)");
        $query -> bindParam(":user", $user, PDO::PARAM_STR);
        $query -> bindParam(":pass", $pass, PDO::PARAM_STR);
        $query -> execute();
    }

    function getUsers(){
        global $pdo;

        $query = $pdo -> prepare("select * from users");
        $query -> execute();

        $rows = $query -> fetchAll();

        echo "<table class='table_mensagens'>";
        echo '<tr>';
        echo '<td><b>Usuário:</b></td>';
        echo '<td><b>Opção:</b></td>';
        echo '</tr>';

        foreach($rows as $row){
            echo ('<tr>');
            echo ('<td>'.$row['user'].' </td>');
            echo ("<td><center><a href='apaga_usuario.php?id=".$row['id']."' class='a_btn'>Apagar</a></center></td>");
            echo ('</tr>');
        }

        echo '</table>';
    }

    function apagaUsuario($id){
        global $pdo;

        $query = $pdo -> prepare("select * from users");
        $query -> execute();

        $result = $query -> fetchAll();

        if(count($result) > 1){
            $query = $pdo -> prepare("delete from users where id = :id");
            $query -> bindParam(":id", $id, PDO::PARAM_STR);
            $query -> execute();
        }
    }

?>