</div> </div> <div class="box-content"> <table class="table table-striped table-bordered bootstrap-datatable datatable"> <thead> <tr> <th style="display:none;">Id</th> <th>Nome</th> <th width="20%">Ação</th> </tr> </thead> <tbody> <?php $DAO->Listar(); ?> </tbody> </table> </div> </div> </div> <!-- content ends --> </div><!--/#content.span10--> </div><!--/fluid-row--> <hr> <?php include_once INTERNAL_ROOT_PORTAL . '/footer.php';
function listarNaoReembolsaveis($id) { $DAO = new NaoReembolsavelDAO(); $resultado = $DAO->Listar("SELECT\r\n\t\t\t\t\t\t\t\t\t\tA.id, \r\n\t\t\t\t\t\t\t\t\t\tB.nome,\r\n\t\t\t\t\t\t\t\t\t\tA.quantidade,\r\n\t\t\t\t\t\t\t\t\t\tA.valor,\r\n\t\t\t\t\t\t\t\t\t\tC.nome as empresa\r\n\t\t\t\t\t\t\t\t FROM tb_medicao_naoreembolsavel_item A\r\n\t\t\t\t\t\t\t\t INNER JOIN \r\n\t\t\t\t\t\t\t\t\t\ttb_medicao_naoreembolsavel B ON A.id_naoreembolsavel = B.id\r\n\t\t\t\t\t\t\t\t INNER JOIN \r\n\t\t\t\t\t\t\t\t\t\ttb_empresa C ON A.id_empresa = C.Id \r\n\t\t\t\t\t\t\t\t WHERE \r\n\t\t\t\t\t\t\t\t\t\tA.id_medicao = " . $id . " AND \r\n\t\t\t\t\t\t\t\t\t\tA.excluido IS NULL AND\r\n\t\t\t\t\t\t\t\t\t\tB.excluido IS NULL\r\n\t\t\t\t\t\t\t\t ORDER BY A.id DESC"); $confirm = "return confirm('Deseja remover esse registro?');"; foreach ($resultado as $item) { echo '<tr>'; echo ' <td>' . $item['nome'] . '</td>'; echo ' <td class="center">' . number_format($item['quantidade'], 3, ',', '.') . '</td>'; echo ' <td class="center">' . number_format($item['valor'], 2, ',', '.') . '</td>'; echo ' <td>' . $item['empresa'] . '</td>'; echo ' <td><a class="btn btn-info" href="anexo_naoReembolsavelEdit.php?id=' . $item['id'] . '">'; echo ' <i class="icon-edit icon-white"></i> Editar'; echo ' </a>'; echo ' <a class="btn btn-danger" onclick="' . $confirm . '" href="anexo_naoReembolsavel.php?cmd=del&id=' . $id . '&item=' . $item['id'] . '">'; echo ' <i class="icon-trash icon-white"></i> Deletar'; echo ' </a>'; echo '</tr>'; } }
$naoreembolsavel = new NaoReembolsavel(); //Verifica se a opcao de salvar foi iniciada if (!empty($_POST['cmd']) && $_POST['cmd'] == 'editar') { $DAO = new NaoReembolsavelDAO(); $naoreembolsavel->setNome($_POST['nome']); $naoreembolsavel->setId($id); $resultado = $DAO->Atualizar($naoreembolsavel); if ($resultado == 1) { echo '<script language= "JavaScript">alert("Registro cadastrado com sucesso");</script>'; echo '<script language= "JavaScript">location.href="index.php";</script>'; } else { echo '<script language= "JavaScript">alert("Erro ao gravar o registro, favor entrar em contato com a TI.");</script>'; } } else { $DAO = new NaoReembolsavelDAO(); $resultado = $DAO->Listar("SELECT * FROM " . MYSQL_BASE_MEDICAO_NAOREEMBOLSAVEL . " WHERE excluido IS NULL AND id=" . $id); foreach ($resultado as $item) { $naoreembolsavel->setNome($item['nome']); } } ?> <!-- topbar ends --> <div class="container-fluid"> <div class="row-fluid"> <!-- left menu starts --> <div class="span2 main-menu-span"> <?php include_once INTERNAL_ROOT_PORTAL . '/medicao/menu.php'; ?> </div>