function casosSurto($comNome = true)
{
$nomeId = $comNome ? 'id' : 'i';
$nomeTotal = $comNome ? 'total' : 't';
$select = $comNome ? "nome, tabela as '{$nomeId}'" : "tabela as '{$nomeId}'";
$db = new MySQL();
$selectFinal = "SELECT {$select} from tabelas_questionarios q WHERE q.tabela = 'surto'";
$db->ExecuteSQL($selectFinal);
$tabelasVigilancia = $db->ArrayResults();
$resultado = array();
foreach ($tabelasVigilancia as $tabelaVigilancia) {
$tabela = $tabelaVigilancia[$nomeId];
$db->ExecuteSQL("SELECT count(id) as total \n\t\t\t\t\t\t from {$tabela} q \n\t\t\t\t\t\t where q.data_hora BETWEEN '" . $_SESSION["data_inicio"] . " 00:00:00' AND '" . $_SESSION["data_final"] . " 23:59:59'\n\t\t\t\t\t\t and q.ativo = 1");
$total = $tabelasVigilancia = $db->ArrayResult();
$tabelaVigilancia[$nomeTotal] = $total['total'];
array_push($resultado, $tabelaVigilancia);
}
return $resultado;
}
<?php
include "../php/class.MySQL.php";
$conn = new MySQL();
$sqlTotal = "SELECT count(id) as total FROM usuario_sentimento";
$conn->ExecuteSQL($sqlTotal);
$total = $conn->ArrayResult();
$totalTodos = (int) $total["total"];
$sql = "SELECT\n\t\t\tcount(us.id) as total, \n\t\t\tus.cidade_regiao_metro as nome,\n\t\t\t\n\t\t\tsum(us.campo1) as campo1, \n\t\t\tsum(us.campo2) as campo2, \n\t\t\tsum(us.campo3) as campo3,\n\t\t\tsum(us.campo4) as campo4,\n\t\t\tsum(us.campo5) as campo5,\n\t\t\tsum(us.campo6) as campo6,\n\t\t\tsum(us.campo7) as campo7,\n\t\t\tsum(us.campo8) as campo8,\n\t\t\tsum(us.campo9) as campo9,\n\t\t\tsum(us.campo10) as campo10,\n\t\t\tsum(us.campo11) as campo11,\n\t\t\tsum(us.campo12) as campo12\n\t\t\tFROM usuario_sentimento us\n\t\t\t\n\t\t\twhere us.sentimento in (3,4)\n\t\t\tand us.cidade_regiao_metro <> ''\n\t\t\t\n\t\t\tGROUP BY us.cidade_regiao_metro";
$conn->ExecuteSQL($sql);
$dados = $conn->ArrayResults();
$sql = "select * from sentimentos";
$conn->ExecuteSQL($sql);
$sentimentos = $conn->ArrayResults();
$campo1 = 0;
foreach ($dados as $dado) {
//$total+=$dado["total"];
$campo1 += $dado["campo1"];
$campo2 += $dado["campo2"];
$campo3 += $dado["campo3"];
$campo4 += $dado["campo4"];
$campo5 += $dado["campo5"];
$campo6 += $dado["campo6"];
$campo7 += $dado["campo7"];
$campo8 += $dado["campo8"];
$campo9 += $dado["campo9"];
$campo10 += $dado["campo10"];
$campo11 += $dado["campo11"];
$campo12 += $dado["campo12"];
}
//$totalTodos = $campo1 + $campo2 + $campo3 + $campo4 + $campo5 + $campo6 + $campo7 + $campo8 + $campo9 + $campo10;
<?php
/**
* Amber
* @package principal
* @author César Martins
* @version 1.0
*/
include "class.MySQL.php";
include "class.Auth.php";
$conn = new MySQL();
$auth = new Auth();
header("Content-type: application/json; charset=utf-8");
$email = $_POST["email"];
$senha = $_POST["senha"];
$password = $auth->hashpass($senha);
//$activekey = $auth->randomkey(15);
if ($auth->validaCadastroLogin($password, $email)) {
$conn->ExecuteSQL("select * from usuarios where email = '{$email}'");
$lista = $conn->ArrayResult();
$resultado = array("status" => TRUE, "hash" => $hash);
} else {
$erros = "";
foreach ($auth->errormsg as $erro) {
$erros .= $erro;
}
$resultado['status'] = FALSE;
$resultado['mensagem'] = "Mensagem de erro. " . $erros . " " . time();
}
echo json_encode($resultado);
$dnciNome = "";
if ($row["dnci_id"] != 0) {
$sqlDnci = "select descricao from suspeita_dnci where id = " . $row["dnci_id"];
$conn->ExecuteSQL($sqlDnci);
$dnci = $conn->ArrayResults();
$dnciNome = $dnci[0]["descricao"];
} else {
$dnciNome = "";
}
$arraySexo = array('', 'Masculino', 'Feminino', 'Ignorado');
$sexoTipo = $arraySexo[$row["sexo"]];
$pais = array();
if ($row["pais"] != "") {
$sqlPais = "select * from paises where id = " . $row["pais"];
$conn->ExecuteSQL($sqlPais);
$pais = $conn->ArrayResult();
//var_dump($pais);
} else {
$pais["nome"] = "";
}
$estado = array();
if ($row["estado"] != "" or $row["estado"] != 0) {
$slqEstado = "select * from estado where id = " . $row["estado"];
$retorno = $conn->ExecuteSQL($slqEstado);
if ($conn->iRecords > 0) {
$estado = $conn->ArrayResult();
} else {
$estado["nome"] = "";
}
} else {
$estado["nome"] = "";
<?php
/**
* Amber
* @package principal
* @author César Martins
* @version 1.0
*/
include "class.MySQL.php";
$conn = new MySQL();
$conn->ExecuteSQL("select * from usuario_sentimento where atualizado = 0");
$num_rows = $conn->ArrayResults();
$total = count($num_rows);
if ($total > 0) {
foreach ($num_rows as $row) {
$url = "http://maps.google.com/maps/api/geocode/json?latlng={$row['latitude']},{$row['longitude']}&sensor=false";
$data = json_decode(file_get_contents($url));
$cidade = $data->results[0]->address_components[3]->long_name;
$sql = "select * from cidade where nome like '{$cidade}'";
$conn->ExecuteSQL($sql);
$listaCidade = $conn->ArrayResult();
$sql = $conn->ExecuteSQL("update usuario_sentimento set atualizado = 1, cidade_id = {$listaCidade['id']} where id = {$row['id']}");
}
} else {
echo "Não ha dados a serem atualizados";
}
<?php
/**
* Amber
* @package principal
* @author César Martins
* @version 1.0
*/
include "class.MySQL.php";
$db = new MySQL();
$db->ExecuteSQL("select * from users");
$users = $db->ArrayResults();
foreach ($users as $user) {
if ($user["ponto_monitoramento"] != 0) {
$sql = "select * from sub_unidades where id = " . $user["ponto_monitoramento"];
$db->ExecuteSQL($sql);
$unidade = $db->ArrayResult();
} else {
$unidade["nome"] = "";
}
$array[] = array("id" => $user["id"], "nome" => utf8_encode($user["username"]), "senha" => utf8_encode($user["password"]), "email" => utf8_encode($user["email"]), "ponto_monitoramento" => utf8_encode($user["ponto_monitoramento"]), "unidade" => utf8_encode($unidade["nome"]));
}
echo json_encode($array);
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
header("Last-Modified: {$now} GMT");
// force download
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
// disposition / encoding on response body
header("Content-Disposition: attachment;filename={$filename}");
header("Content-Transfer-Encoding: binary");
readfile($filename);
}
include "class.MySQL.php";
$conn = new MySQL();
$sql = "SELECT COUNT(us.id) as total FROM usuarios u\n\t\tINNER JOIN usuario_sentimento us ON us.usuario_id = u.id";
$conn->ExecuteSQL($sql);
$total = $conn->ArrayResult();
$sql = "SELECT total FROM total_usuario_sentimento";
$conn->ExecuteSQL($sql);
$total_sentimento = $conn->ArrayResult();
$total_sentimento["total"];
$sql = "UPDATE total_usuario_sentimento SET total= " . $total["total"];
//$conn->ExecuteSQL($sql);
$listagem = $total["total"] - $total_sentimento["total"];
//echo "<br>";
$titulo = array("ID_REG_SEQ", "ID_USUARIO", "APELIDO", "IDADE", "SEXO", "EMAIL", "IDIOMA", "DT_CADASTRO", "DT_REGISTRO_DIA", "DT_REGISTRO_HORA", "LOC_REGISTRO", "REGIAO", "EQUIPAMENTO", "LAT", "LONG", "STATUS", "FEBRE", "TOSSE", "DORGARGANTA", "FALTAR", "NAUSEA", "DIARREIA", "ARTRALGIA", "CEFALEIA", "HEMORRAGIA", "EXANTEMA", "CONTATO", "SERVSAUDE", "CADASTRO", "SINTOMA", "CONTAGEM", "SIND_DIA", "SIND_RES", "SIND_EXA", "ATUALIZA");
/*
$sql = "SELECT u.id, u.apelido, u.idade, u.sexo, u.email , u.data_hora,
u.hash, u.gcmid, u.idioma, us.data_cadastro, us.pontuacao,
us.latitude, us.longitude, c.nome, us.campo1, us.campo2, us.campo3,
us.campo4, us.campo5, us.campo6, us.campo7, us.campo8, us.campo9,
us.campo10, us.campo11, us.campo12
break;
default:
require_once ENGINE_DIR . '/modules/index.php';
//if(LEVEL==1) //require_once ENGINE_DIR. '/modules/dashboard/list.php';
//require_once ENGINE_DIR. '/modules/dashboard/dashboard.php';
$thispage = "Главная";
break;
}
$tpl->assign("USERNAME", ADMINLOGIN);
$tpl->assign("USERID", ADMINID);
$tpl->assign("USERLEVEL", LEVEL);
$tpl->assign("HEAD", $HEAD);
$tpl->assign("END", $END);
$tpl->assign("AJAX", $AJAX);
$dataMySQL->ExecuteSQL("SELECT COUNT(*) from `" . DB_PREFIX . "users` WHERE 1 ;");
$allUSERS = $dataMySQL->ArrayResult();
$dataMySQL->ExecuteSQL("SELECT COUNT(*) FROM `" . DB_PREFIX . "users` WHERE `idc` > 4150;");
$cUSERS = $dataMySQL->ArrayResult();
$COUS = $cUSERS['COUNT(*)'] / $allUSERS['COUNT(*)'] * 100;
$NCOUS = $cUSERS['COUNT(*)'];
$ACOUS = $allUSERS['COUNT(*)'] - $cUSERS['COUNT(*)'];
$tpl->assign("COUS", $COUS);
$tpl->assign("COUS2", 100 - $COUS);
$tpl->assign("NCOUS", $NCOUS);
$tpl->assign("ACOUS", $ACOUS);
$tpl->assign("DATE", date("Y") . " " . $version);
$tpl->assign("IP", $_SERVER["REMOTE_ADDR"]);
$tpl->assign("module", $thispage);
//echo $dataMySQL->sLastQuery;
//if($ajaxer!==3 && LEVEL!=="1") $content.="<script>console.log('".LEVEL." {$thispage}');$(\".current\").html(\"{$thispage}\")</script>";
//if($ajaxer!==3 && LEVEL==1) $content.="<script>console.log('LEVEL ".LEVEL.": {$thispage}');$(\".current\").html(\"{$thispage} (query:".$dataMySQL->queryS.")\")</script>";
include "../php/class.MySQL.php";
$conn = new MySQL();
if (isset($_SESSION["errormsg"])) {
if (is_array($_SESSION["errormsg"])) {
foreach ($_SESSION["errormsg"] as $list) {
echo utf8_decode($list) . "<br>";
}
} else {
echo $_SESSION["errormsg"];
}
unset($_SESSION["errormsg"]);
}
if (isset($_GET["alt"])) {
$sql = "SELECT * FROM users where id = " . $_GET["alt"];
$conn->ExecuteSQL($sql);
$dados = $conn->ArrayResult();
}
?>
<form action="cad_user01.php" method="post">
<table>
<tr>
<td>Nome</td>
<td><input name="username" type="text"></td>
</tr>
<tr>
<td>e-mail</td>
<td><input name="email" type="text"></td>
</tr>
<tr>
<td>Senha</td>
<td><input name="password" type="password"></td>
*/
include "bibliotecas/php/class.Auth.php";
$auth = new Auth();
$auth->notLogged("login.php");
include "bibliotecas/php/class.MySQL.php";
$db = new MySQL();
$db->ExecuteSQL("select * from paises");
$paises = $db->ArrayResults();
$db->ExecuteSQL("select * from sinais_sintomas order by sinais_desc");
$sinais_sintomas = $db->ArrayResults();
$db->ExecuteSQL("select * from hipotese_diagnostica order by hip_dia_desc");
$hipotese_diagnostica = $db->ArrayResults();
$session = $auth->sessioninfo($_COOKIE["auth_session"]);
$sql = "select ponto_monitoramento from users where id = " . $session['uid'];
$db->ExecuteSQL($sql);
$user = $db->ArrayResult();
$subUnidade = false;
$sqlComplemento = "";
if ($user["ponto_monitoramento"] > 0) {
$sql = "select id, unidade_id from sub_unidades where id = " . $user["ponto_monitoramento"];
$db->ExecuteSQL($sql);
$subUnidade = $db->ArrayResult();
$sqlComplemento .= " and id = " . $subUnidade["unidade_id"];
}
$sql = "select * from unidades where ativo = 1 {$sqlComplemento} order by nome";
$db->ExecuteSQL($sql);
$unidades = $db->ArrayResults();
?>
<!doctype html>
<html lang="en">
<head>
require "mysql.class.php";
$m = new MySQL();
// API
// if(isset($_GET['addusers'])){
// $id = $_GET['trainid'];
// $num = $_GET['num'];
// // echo $num;
// $m->Update("trainData", array("numBheed" => $num), array("id" => $id));
// }
// if(isset($_GET['update'])){
// $id = $_GET['trainid'];
// $m->Select("trainData", array("numBheed"), array("id" => $id));
// $num = $m->ArrayResult();
// echo json_encode(Array("status"=>$num["numBheed"]));
// }
// REST API formation
if (isset($_GET)) {
if (!isset($_POST['num'])) {
$id = $_GET['trainid'];
$m->Select("trainData", array("numBheed"), array("id" => $id));
$num = $m->ArrayResult();
http_response_code(200);
echo json_encode(array("status" => $num["numBheed"]));
} else {
$id = $_GET['trainid'];
$num = $_POST['num'];
$m->Update("trainData", array("numBheed" => $num), array("id" => $id));
http_response_code(201);
return;
}
}
