<header>
    <meta charset="utf-8"/>
    <meta name="viewport" content="width=device-width, user-scalable=no" />
    <link href="./Styles/bootstrap.css" rel="stylesheet" type="text/css"/>
    <script src="./Styles/bootstrap-3.3.1/js/bootstrap.js" type="text/javascript"></script>
    <link href="./Styles/bootstrap-3.3.1/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
    <script src="http://code.jquery.com/jquery-1.9.1.js" type="text/javascript"></script>
    <script src="http://code.jquery.com/ui/1.9.2/jquery-ui.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">
</header>

<?php
    include_once("includes/conexao.php");
    include_once("aviso.php");
    session_start();
    $login = $_POST['txt_usuario'];
    $senha = md5($_POST['txt_senha']);
    //$exercicio = $_POST['txt_exercicio'];
    $exercicio = '2018';
    $acesso    = mysql_query("SELECT * FROM usuarios WHERE usu_usuario = '$login' AND usu_senha = '$senha'");
    $cargo     = mysql_query("SELECT * FROM v_lista_usuarios WHERE usu_usuario = '$login' AND usu_senha = '$senha'");
    $entidade  = mysql_query("SELECT * FROM entidade");
    $cargu     = mysql_fetch_array($cargo);
    $admin     = mysql_fetch_array($acesso);
    $enti      = mysql_fetch_array($entidade);
    if (mysql_num_rows($acesso) > 0) {
        $_SESSION['txt_usuario']   = $login;
        $_SESSION['txt_senha']     = $senha;
        $_SESSION['admin']         = $admin['usu_admin'];
        $_SESSION['idusu']         = $admin['usu_id'];
        $_SESSION['escola']        = $admin['usu_escola'];
        $_SESSION['usu_status']    = $admin['usu_situacao'];
        $_SESSION['usu_escola']    = $admin['usu_escola'];
        $_SESSION['usu_nutri']     = $admin['usu_nutricionista'];
        $_SESSION['usu_mail']      = $admin['usu_mail'];
        $_SESSION['treina_escola'] = $admin['usu_treina_escola'];
        $_SESSION['usu_cargo']     = $cargu['ass_assin_cargo'];
        $_SESSION['exercicio']     = $exercicio;
        $_SESSION['prefeitura']    = $enti['ent_entidade'];
        $_SESSION['secretaria']    = $enti['ent_secretaria'];
        $id_usu                    = $_SESSION['idusu'];
        
        //********LOG USUARIOS*******/
        $datal = date('d/m/Y');
        $horal = date('H:i');
        $ipnum = $_SERVER['REMOTE_ADDR'];
        $log = mysql_query("INSERT INTO usuariolog
            (
              log_usu_id,log_data,log_hora,log_acao,log_ip
            )
            VALUES
            (
              '$id_usu','$datal','$horal','Acessou o sistema','$ipnum'
            )") or die('Erro ao gravar log: ' . mysql_error());
        //********LOG USUARIOS*******/
        if ($admin['usu_escola']=='0' or $admin['usu_escola']=='') {
            $a = new aviso();
            $a->avisoSucesso('index.php', "<center><img src='./logo/logo.png' class='img-responsive'/><br>" . 'Bem vindo(a) <b><br>' . strtoupper($login) . '</b></center>', 'Usu&aacute;rio logado!');
        } else {
            $a = new aviso();
            $a->avisoSucesso('escola.php', "<center><img src='./logo/logo.png' class='img-responsive'/><br>" . 'Bem vindo(a) <b><br>' . strtoupper($login) . '</b></center>', 'Usu&aacute;rio logado!');
        }
        
        
    } else {
        unset ($_SESSION['txt_usuario']);
        unset ($_SESSION['txt_senha']);
        $a = new aviso();
        $a->avisoErro('login.php', "<center><img src='./logo/logo.png' class='img-responsive'/><br>" . 'Tente efetuar o login novamente</center>', 'Usu&aacute;rio ou senha inv&aacute;lidos!');
    }