function logIn($user, $pass) { $DAO = new GenericoDAO(); $query = $DAO->Query("SELECT id, email, senha FROM " . MYSQL_BASE_USUARIOS . " WHERE email = '" . $user . "' AND senha = SHA1('" . $pass . "') LIMIT 1"); if ($query->rowCount() == 1) { foreach ($query as $row) { session_start(); $data = Date('d-m-Y'); $ip = $_SERVER['REMOTE_ADDR']; $host = $_SERVER['REMOTE_HOST']; $criptografia = sha1($data); $_SESSION['id'] = $criptografia . $row['id']; echo '<script language= "JavaScript">location.href="dashboard.php";</script>'; } } else { echo '<script language= "JavaScript">location.href="index.php?error=true";</script>'; } }
<?php include_once '../includes.sys/ini.php'; include_once '../includes.sys/metodos.php'; include_once '../DAO/GenericoDAO.php'; header('Cache-Control: no-cache'); header('Content-type: application/xml; charset="utf-8"', true); $DAO = new GenericoDAO(); $lista = $_GET['lista']; $array = array(); $sql = "SELECT \r\n\t\t\t\tNF.num_nota,\r\n\t\t\t\tNF.id,\r\n\t\t\t\tF.razao_social\r\n\t\t\tFROM \r\n\t\t\t\t" . MYSQL_BASE_NOTA_FISCAL . " NF\r\n\t\t\t\tINNER JOIN " . MYSQL_BASE_FORNECEDORES . " F ON F.id = NF.id_fornecedor\r\n\t\t\tWHERE\r\n\t\t\t\tF.id = " . $lista; $res = $DAO->Query($sql); foreach ($res as $row) { $array[] = array('id_nota' => $row['id'], 'num_nota' => $row['num_nota'], 'razao_sociao' => $row['razao_sociao']); } echo json_encode($array); ?>
function select($sql) { $DAO = new GenericoDAO(); $resultado = $DAO->Query($sql); return $resultado; }
function validadeChave() { $DAO = new GenericoDAO(); $query = $DAO->Query("SELECT \n\t\t\t\t\t\t\t\tDATE_FORMAT(DATE_ADD(criado, INTERVAL 2 MONTH), '%d/%m/%Y') as validade, \n\t\t\t\t\t\t\t\tDATE_FORMAT(DATE_ADD(criado, INTERVAL 2 MONTH), '%Y-%m-%d') as data \n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t" . MYSQL_BASE_CAHVES . " \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\tDATEDIFF(DATE_ADD(criado, INTERVAL 2 MONTH), NOW()) <= 14 ORDER BY id DESC LIMIT 1;"); if ($query->rowCount() == 1) { foreach ($query as $item) { if ($item['data'] < date('Y-m-d')) { echo '<script language= "JavaScript">location.href="' . EXTERNAL_ROOT_PORTAL . '/chave.php";</script>'; } else { echo '<div class="alert alert-warning text-center" role="alert"> <strong>Chave expira em ' . $item['validade'] . '!</strong> entre em contato com suporte@hexti.com.br </div>'; } } } }
<?php include_once 'includes.sys/ini.php'; include_once 'includes.sys/metodos.php'; include_once 'includes.sys/faxada.class.php'; include_once 'DAO/GenericoDAO.php'; $faxada = new Faxada(); if (!empty($_POST['chave'])) { $DAO = new GenericoDAO(); $query = $DAO->Query("SELECT id FROM " . MYSQL_BASE_CAHVES . " WHERE serial = '" . $_POST['chave'] . "' LIMIT 1"); if ($query->rowCount() == 0) { if (validaSerial($_POST['chave'])) { $date = date('Y-m-d H:m:s'); $data = array('serial' => $_POST['chave'], 'chave' => sha1($date), 'criado' => $date); $resultado = $faxada->salvar(MYSQL_BASE_CAHVES, $data); if ($resultado['validacao']) { echo '<script language= "JavaScript">location.href="chave.php?error=false";</script>'; } else { echo '<script language= "JavaScript">location.href="chave.php?error=true";</script>'; } } else { echo '<script language= "JavaScript">location.href="chave.php?error=true";</script>'; } } else { echo '<script language= "JavaScript">location.href="chave.php?error=duplicate";</script>'; } } ?> <!DOCTYPE html> <html lang="pt-br"> <head>
<?php include_once '../head.php'; include_once '../DAO/GenericoDAO.php'; $DAO = new GenericoDAO(); //SQL para listar a despesas e pagamentos $query = $DAO->Query("SELECT \r\n\t\t\t\t\t\t\tSUM(valor_total) as divida, \r\n\t\t\t\t\t\t\tSUM(0) as pagamento \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t" . MYSQL_BASE_CONTRATOS . "\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\texcluido IS NULL\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tUNION ALL\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\tSUM(0) as divida,\r\n\t\t\t\t\t\t\tSUM(P.valor) as pagamento \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t" . MYSQL_BASE_CONTRATOS . " C\r\n\t\t\t\t\t\t INNER JOIN " . MYSQL_BASE_PAGAMENTOS . " P ON P.id_contrato = C.id\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tP.excluido IS NULL;"); $despesa = 0; $pagamento = 0; foreach ($query as $row) { $despesa += $row['divida']; $pagamento = $row['pagamento']; } //SQL para listar o que cada fonte pagou $query = $DAO->Query("SELECT\r\n\t\t\t\t\t\t\tF.nome,\r\n\t\t\t\t\t\t\tSUM(valor) as valor \r\n\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t" . MYSQL_BASE_PAGAMENTOS . " P\r\n\t\t\t\t\t\t INNER JOIN " . MYSQL_BASE_FONTES . " F ON F.id = P.id_fonte\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tP.excluido IS NULL\r\n\t\t\t\t\t\tGROUP BY F.id"); $var_fonte = ""; foreach ($query as $row) { $var_fonte .= "['" . $row['nome'] . "', " . $row['valor'] . "],"; } $var_fonte = substr($var_fonte, 0, -1); //SQL para saber o valor que cada despesa tem $query = $DAO->Query("SELECT * FROM " . MYSQL_BASE_CONTRATOS . " WHERE excluido IS NULL"); $var_despesa = ""; foreach ($query as $row) { $var_despesa .= "['" . $row['estabelecimento'] . "', " . $row['valor_total'] . "],"; } ?> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart);