<?
// Desculpe a prigui�a! N�o comentei
// todo codigo pro falta de tempo e
// disponibilidade. fica aqui minhas
// desculpas
// aqui vai sua base de dados
// crianca � o nome da minha base de dados
require_once('Connections/crianca.php');
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1']))
{
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_crianca, $crianca);
$query_Recordset1 = "
SELECT nome_bai, servico.nome_uni, notificacao.num_notic, notificacao.nome_criad, notificacao.end_criad, notificacao.cid_criad, notificacao.cep_criad, notificacao.fone_criad, notificacao.ponto_ref
FROM notificacao inner join bairros ON notificacao.cod_bai=bairros.cod_bai, servico
WHERE notificacao.cod_uni=servico.cod_uni order by servico.nome_uni";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $crianca) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($HTTP_GET_VARS['totalRows_Recordset1']))
{
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
}
else
{
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<html>
<head>
<title>Relat�rio de Notifica��es</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#0099FF" background="backgsms.jpg" text="#000066" link="#CC0000" vlink="#308CFE">
<center><font face="arial" size="5"><b>Relat�rio de Notifica��es por Unidade</b></font></center>
<br>
<br>
<table width=100% border=0 cellspacing=1 cellpadding=0 align=center>
<tr bgcolor="#6699CC">
<td colspan="6">
<div align="center">
<font face="Arial" size="3">
<b><font color="#FFFFFF">Relat�rios</font></b>
</font>
</div>
</td>
</tr>
</table>
<table width=100% border=0 cellspacing=1 cellpadding=0 align=center>
<tr bgcolor="cccccc">
<td align="center"><font face="Arial" size="2" color="#008080"><b>Unidade</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>N� da Notifica��o</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Crian�a/Adolescente</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Endere�o</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Bairro </b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Cidade</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>CEP </b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Fone</b></font></td>
<td align="center"><font face="Arial" size="2" color="#008080"><b>Ponto de Ref.</b></font></td>
</tr>
<?php do { ?>
<tr bgcolor="ebebeb">
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['nome_uni'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['num_notic'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['nome_criad'];?></font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['end_criad'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['nome_bai'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['cid_criad'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['cep_criad'];?> </font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['fone_criad'];?></font></div></td>
<td align="center"><font face="Arial" size="2"><?php echo $row_Recordset1['ponto_ref'];?> </font></div></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<br>
<center><font face="arial"><b><a href="Relatorios.php"><<- Voltar</a></b></font></center>
<br>
<br>
<hr width="100%" size="5">
<font face="Arial,Helvetica, sans-serif"size="1">
<center>Coordenadoria da Inform�tica</center><br>
<center>Copyright � 2003 Secretaria Municipal da Sa�de, Campinas<sup>2003</sup>.<center><br>
<center>Todos os direitos reservados.</center><br>
<center>Projeto Quebrando o Sil�ncio: <!--webbot bot="TimeStamp" S-Type="EDITED" S-Format="%B %d, %Y" startspan --><?echo($data_sis);?>
<!--webbot bot="TimeStamp" i-CheckSum="41731" endspan --></center>
</font>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>