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);
