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