<h1 id="form">Criar Solicitação de exames</h1>
<?php
if (file_exists('include/fast-exames/_models/AdminExames.class.php')) {
include_once 'include/fast-exames/_models/AdminExames.class.php';
}
$Dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
$AdminExames = new AdminExames();
$FeAcoes = new FeAcoes();
$WsSetor = new WsSetor();
$FeMaterial = new FeMaterial();
if (!empty($Dados)) {
$Dados['ws_users_soli'] = Check::UserLogin()['user_id'];
$Dados['ex_data_abertura'] = date('Y-m-d H:i:s');
if ($AdminExames->ExeCreate($Dados)) {
WSErro("Solicitação cadastrada com sucesso!", WS_ACCEPT);
header("Location: " . FAST_INCLUDE . "admin/&exe=exames/update&examesId=" . $AdminExames->getResult() . "&create=true");
} else {
WSErro("Erro ao cadastrar solicitação!", WS_ERROR);
}
}
?>
<form method="post" class="form">
<div class="row bg-info">
<div class="form-group col-md-8">
<label>Descrição:</label>
<input required="true" class="form-control" title="Descrição" type="text" name="ex_descricao" placeholder="Descrição" value="<?php
echo $Dados['ex_descricao'];
?>
">
<?php
if (file_exists('include/fast-exames/_models/AdminExames.class.php')) {
include_once 'include/fast-exames/_models/AdminExames.class.php';
}
$action = filter_input(INPUT_GET, "action", FILTER_DEFAULT);
$AdminExames = new AdminExames();
if (!empty($action)) {
$toaction = explode("/", $action);
$exame = $AdminExames->FindId($toaction[1]);
if (!empty($exame)) {
switch ($toaction[0]) {
case "active":
$AdminExames->ExeStatus($toaction[1], 1);
WSErro("Exame <b>{$exame->ex_descricao}</b> concluido com sucesso!", WS_ACCEPT);
break;
case "inative":
$AdminExames->ExeStatus($toaction[1], 0);
WSErro("Exame <b>{$exame->ex_descricao}</b> aberto com sucesso!", WS_ACCEPT);
break;
case "delete":
if ($AdminExames->ExeCancelar($toaction[1], 1)) {
WSErro("Exame <b>{$exame->ex_descricao}</b> deletado com sucesso!", WS_ACCEPT);
} else {
WSErro("Erro ao deletar", WS_ERROR);
}
break;
case "undelete":
if ($AdminExames->ExeCancelar($toaction[1], 0)) {
WSErro("Exame <b>{$exame->ex_descricao}</b> ativo com sucesso!", WS_ACCEPT);
} else {
<?php
if (file_exists('include/fast-exames/_models/AdminExames.class.php')) {
include_once 'include/fast-exames/_models/AdminExames.class.php';
}
Register::addRegister("<script src='" . HOME . "/js/google-charts/columns.charts.js'></script>");
$using = filter_input(INPUT_GET, 'using', FILTER_VALIDATE_BOOLEAN);
if ($using) {
WSErro("Este exame já esta sendo usado por outra pessoa.", WS_ALERT);
}
$FeExames = new FeExames();
$AdminExames = new AdminExames();
//Total por usuarios
$FeExames->Execute()->FullRead("SELECT count(e.ws_users) as 'cont' , u.* FROM fe_exames e " . "JOIN ws_users u ON(u.user_id = e.ws_users) " . "GROUP BY e.ws_users;");
$usuarios = $FeExames->Execute()->getResult();
//Tempo Medio dias corrisdos
$ListaTempoMedio = $FeExames->Execute()->FullRead("SELECT e.ex_data_abertura as 'data_inicio' , e.ex_data_fechamento as 'data_fim' " . "FROM fe_exames e where e.ex_status=1");
$TempoMedio = $AdminExames->TempoMedio($ListaTempoMedio);
//Tempo medio de resolução por periodo
//LastMonth
$lastMonth = date('Y-m-d H:i:s', strtotime('-1 month'));
$mes = $FeExames->Execute()->FullRead("SELECT e.ex_data_abertura as 'data_inicio' , e.ex_data_fechamento as 'data_fim' " . "FROM fe_exames e where e.ex_status=1 AND e.ex_data_abertura >= '{$lastMonth}'");
$month = $AdminExames->TempoMedio($mes);
//LastWeek
$lastWeek = date('Y-m-d H:i:s', strtotime('-1 week'));
$semana = $FeExames->Execute()->FullRead("SELECT e.ex_data_abertura as 'data_inicio' , e.ex_data_fechamento as 'data_fim' " . "FROM fe_exames e where e.ex_status=1 AND e.ex_data_abertura >= '{$lastWeek}'");
$week = $AdminExames->TempoMedio($semana);
//LastDay
$lastDay = date('Y-m-d H:i:s', strtotime('-1 day'));
$dia = $FeExames->Execute()->FullRead("SELECT e.ex_data_abertura as 'data_inicio' , e.ex_data_fechamento as 'data_fim' " . "FROM fe_exames e where e.ex_status=1 AND e.ex_data_abertura >= '{$lastDay}'");
$day = $AdminExames->TempoMedio($dia);
<?php
if (file_exists('include/fast-exames/_models/AdminExames.class.php')) {
include_once 'include/fast-exames/_models/AdminExames.class.php';
}
$Dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
$cad = filter_input(INPUT_GET, "cadastro", FILTER_VALIDATE_BOOLEAN);
if (!empty($cad)) {
if (!$cad) {
WSErro("Erro ao cadastrar solicitação!", WS_ERROR);
} else {
WSErro("Solicitação cadastrada com sucesso!", WS_ACCEPT);
}
}
$AdminExames = new AdminExames();
$FeAcoes = new FeAcoes();
$WsSetor = new WsSetor();
$FeMaterial = new FeMaterial();
$FeExames = new FeExames();
$getPage = filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT);
$Pager = new Pager(FAST_INCLUDE . "&page=");
$Pager->ExePager($getPage, 15);
$FeExames->Execute()->FullRead("SELECT * FROM fe_exames WHERE ex_cancelado = 0 ORDER BY ex_status, ex_data_abertura DESC LIMIT :limit OFFSET :offset", "limit={$Pager->getLimit()}&offset={$Pager->getOffset()}", true);
if (!empty($Dados)) {
$obs = $Dados['ex_observacao'];
unset($Dados['ex_observacao']);
if (!in_array("", $Dados)) {
$Dados['ws_users_soli'] = Check::UserLogin()['user_id'];
$Dados['ex_data_abertura'] = date('Y-m-d H:i:s');
$Dados['ex_observacao'] = $obs;
if ($AdminExames->ExeCreate($Dados)) {
<h1 id="form">Atualizar Solicitação de exames</h1>
<?php
if (file_exists('include/fast-exames/_models/AdminExames.class.php')) {
include_once 'include/fast-exames/_models/AdminExames.class.php';
}
if (!Check::UsingPage()) {
header("Location: " . HOME . '/plugin/fast-exames/admin/&using=true');
}
$Dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
$examesId = filter_input(INPUT_GET, "examesId", FILTER_DEFAULT);
$create = filter_input(INPUT_GET, "create", FILTER_DEFAULT);
$AdminExames = new AdminExames();
$FeAcoes = new FeAcoes();
$WsSetor = new WsSetor();
$FeMaterial = new FeMaterial();
if (!empty($Dados) && !empty($Dados['sendPostForm'])) {
unset($Dados['sendPostForm']);
$Dados['ex_id'] = $examesId;
$Dados['ws_users'] = Check::UserLogin()['user_id'];
$Dados['ex_data_fechamento'] = date('Y-m-d H:i:s');
$Dados['ex_status'] = true;
$Obs = $Dados['ex_observacao'];
unset($Dados['ex_observacao']);
if (!in_array("", $Dados)) {
$Dados['ex_observacao'] = $Obs;
$AdminExames->ExeUpdate($Dados) ? WSErro("Solicitação <b>{$Dados['ex_descricao']}</b> atualizada com sucesso!", WS_ACCEPT) : WSErro("Erro ao atualizar solicitação!", WS_ERROR);
} else {
WSErro("Ops! preecha todos os campos", WS_INFOR);
}
} else {
if ($AdminExames->FindId($examesId)) {
