Viewing file:  obsPagtoCongresso.php (3.27 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include("../../config/config.php");
include(INCLUDES . "conexaoBD.php");
include(INCLUDES . "funcoes_uteis.php");
include(INCLUDES . "sentencas_sql.php");
include(INCLUDES . "valida_usuario.inc.php");
if ($_POST) {
extract($_POST);
$upd = "UPDATE inscricao_congresso SET
INS_PagoSN = 'S',
INS_DataPagamento = now(),
INS_Valor = '0.00',
INS_ValorPago = '0.00',
INS_Justificativa = '$txtJustificativa'
WHERE INS_RowID = $hdRowID";
//echo '<pre>'.$upd.'</pre>';
if($conexao->query($upd)) {
$conexao->commit();
}
?>
<div style="width:100%; text-align:center; margin-top:150px;"><h2>ISENÇÃO REALIZADA COM SUCESSO!</h2></div>
<script src="../../includes/jquery-1.2.6.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
setTimeout('fechar()', 1500);
});
function fechar() {
window.opener.location.reload('congresso_boletos.php?sit=0');
window.close();
}
</script>
<?php
die();
}
$id = $_GET['id'];
//busca os dados da inscrição selecionada
$sql = "
SELECT *
FROM inscricao_congresso
WHERE INS_RowID = $id
";
$exe = $conexao->query($sql);
$rs = $exe->fetch_array();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script src="../../includes/jquery-1.2.6.js" type="text/javascript"></script>
<style type="text/css">
body{ font-family: verdana; font-size: 13px;}
</style>
<script type="text/javascript">
$(function() {
$('#txtJustificativa').focus();
});
</script>
</head>
<body>
<div id="logo">
<img src="<?= HOST;?>imagens/logo.jpg" width="250" height="72"></img>
</div>
<form id="form1" name="form1" method="post" action="">
<table width="500" border="0" align="center">
<tr>
<td colspan="2">Preencha os campos abaixo para confirmação manual da inscrição</td>
</tr>
<tr>
<td colspan="2" style="background: #033455; text-align: center; color: #FFFFFF;">Isento de Pagamento</td>
</tr>
<tr>
<td width="100"> </td>
<td width="400"><input name="hdRowID" type="hidden" id="hdRowID" value="<?= $rs['INS_RowID']?>" /></td>
</tr>
<tr>
<td>Nome:</td>
<td><?= $rs['INS_Nome']?></td>
</tr>
<tr>
<td>Ofício:</td>
<td><?= $rs['INS_Oficio']?></td>
</tr>
<tr>
<td>Cidade:</td>
<td><?= $rs['INS_Cidade']?></td>
</tr>
<tr>
<td>Valor:</td>
<td>R$ 0,00</td>
</tr>
<tr>
<td valign="top">Justificativa:</td>
<td><textarea name="txtJustificativa" id="txtJustificativa" cols="45" rows="5"></textarea></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="btnConfirma" id="btnConfirma" value="Isentar Pagamento" /></td>
</tr>
</table>
<script type="text/javascript" src="../../includes/jquery-1.2.6.js"></script>
</form>
</body>
</html>
|