<?php
    class sessao{

        function fazSessao($conexao){

        }
    }
?>

<?php

class administracao {

            public $TF;
            public $id_usuario=0;
            public $acao='';
            public $ano=2016;
            public $mes=01;
            public $dia=0;
            public $hora=01;
            public $min=01;
            public $seg=00;
            public $tabela='';
            public $posts='';
            public $ip='';


           function __construct() {
                $this->ano = date("Y");
                $this->mes = date("m");
                $this->dia = date("d");
                $this->hora = date("H");
                $this->min = date("i");
                $this->seg = date("s");
           }



            function  conectaBanco($config) {

                        $host = $config['host'];
                        $user = $config['user'];
                        $password = $config['password'];
                        $db = $config['db'];
                        $port =$config['port'];

                        $conexao = mysqli_connect($host,$user,$password,$db,$port);
                        if(!$conexao)
                        {
                            echo "erro ao conectar ao banco de dados!";
                        }
                        return $conexao;


            }

            function seguranca($post){
                $codMalicioso = array('<script>', '</script>');
                $post = $post;
                $n = count($codMalicioso);
                $cont = 0;
                while($n > $cont){
                    $pegaCodigo = count(explode($codMalicioso[$cont], $post));
                    if($pegaCodigo > 1){
                        $this->TF = true;
                    }
                    $cont++;
                }
                if($this->TF){
                    $post = "";
                }

                return $post;

            }

            function criaAuditoria($par,$conexao){
                if(isset($par['id_usuario'])){
                    $this->id_usuario = $par['id_usuario'];
                }
                if(isset($par['acao'])){
                    $this->acao = $par['acao'];
                }
                if(isset($par['data'])){
                    $this->data = $par['data'];
                }
                if(isset($par['hora'])){
                    $this->hora = $par['hora'];
                }
                if(isset($par['tabela'])){
                    $this->tabela = $par['tabela'];
                }
                if(isset($par['posts'])){
                    $this->posts = $par['posts'];
                }
                $administracao = new administracao();
                $this->ip = $administracao->getIp();

                $sql = "INSERT INTO auditorias (id, id_usuario, acao, data, hora, tabela, ativo, posts, ip) VALUES (null,'$this->id_usuario','$this->acao','$this->data', '$this->hora', '$this->tabela','1','$this->posts','$this->ip')";


                mysqli_query($conexao,$sql);
            }


           function getIP() {
            $ip = $_SERVER['SERVER_ADDR'];

            if (PHP_OS == 'WINNT'){
                $ip = getHostByName(getHostName());
            }

            if (PHP_OS == 'Linux'){
                $command="/sbin/ifconfig";
                exec($command, $output);

                $pattern = '/inet addr:?([^ ]+)/';

                $ip = array();
                foreach ($output as $key => $subject) {
                    $result = preg_match_all($pattern, $subject, $subpattern);
                    if ($result == 1) {
                        if ($subpattern[1][0] != "127.0.0.1")
                        $ip = $subpattern[1][0];
                    }

                }
            }

            $this->ip = $ip;

            return array('ip' => $this->ip);
        }

            function data_hora_atual($par,$conexao){
                date_default_timezone_set('America/Sao_Paulo');

                return array('ano' => $this->ano, 'mes' => $this->mes, 'dia' => $this->dia,'hora' => $this->hora,'min' => $this->min,'seg' => $this->seg,'data_hora'=>$this->data_hora = date("Y-m-d H:i:s"));

            }
}

?>