Ver Mensaje Individual
  #5 (permalink)  
Antiguo 31/01/2011, 14:28
dianays
 
Fecha de Ingreso: agosto-2010
Mensajes: 147
Antigüedad: 13 años, 8 meses
Puntos: 1
Respuesta: ayuda con juego de registros

<?php require_once('Connections/informa.php'); ?>
<?php
$colname_imp1 = "-1";
if (isset($_POST['folio'])) {
$colname_imp1 = (get_magic_quotes_gpc()) ? $_POST['folio'] : addslashes($_POST['folio']);
}
mysql_select_db($database_informa, $informa);
$query_imp1 = sprintf("SELECT reporte.*, unidades.unidad, usuarios.nombre FROM reporte inner join unidades on reporte.id_unidad = unidades.id_unidad inner join usuarios on reporte.id_nom = usuarios.id_nom WHERE folio = %s", $colname_imp1);
$imp1 = mysql_query($query_imp1, $informa) or die(mysql_error());
$row_imp1 = mysql_fetch_assoc($imp1);
$totalRows_imp1 = mysql_num_rows($imp1);
?><!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>.::Imprimir Reporte::.</title>
<link href="imagenes/favicon.ico" rel="shortcut icon"/>
<style type="text/css">
<!--
.Estilo2 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; }
.Estilo5 {font-size: 12px}
.Estilo6 { font-size: 14px;
font-weight: bold;
}
.Estilo8 {font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif; }
.Estilo17 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
.Estilo19 {font-size: 12px; font-family: Geneva, Arial, Helvetica, sans-serif; font-weight: bold; }
.Estilo23 {font-size: 12}
.Estilo24 {font-family: Geneva, Arial, Helvetica, sans-serif}
-->
</style>
</head>

<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10%" height="101" rowspan="4" scope="col"><p align="center"><img src="Imagenes/logo vivir mejor.gif" width="73" height="64" /></p></td>
<td height="18" colspan="2" scope="col"><p align="center" class="Estilo17"></p></td>
<td width="13%" rowspan="4" scope="col"><div align="center"><img src="Imagenes/IMSS-.gif" width="73" height="64" /></div></td>
</tr>
<tr>
<td height="17" colspan="2" scope="col"><div align="center"><strong><span class="Estilo2"></span></strong></div></td>
</tr>
<tr>
<td height="19" colspan="2" scope="col"><div align="center"><strong><span class="Estilo2"></span></strong></div></td>
</tr>
<tr>
<td height="35" colspan="2" scope="col"><div align="center"><strong>.:: R E P O R T E ::. </strong></div></td>
</tr>
<tr>
<td>&nbsp;</td>
<td width="41%">&nbsp;</td>
<td colspan="2"><table width="350" border="1" align="center" cellspacing="0" bordercolor="#000000">
<tr>
<td height="19" colspan="2" scope="col"><span class="Estilo5">FOLIO: <strong><?php echo $row_imp1['folio']; ?></strong></span></td>
</tr>
<tr>
<td width="174" scope="row"><span class="Estilo5">FECHA:<strong><?php echo $row_imp1['fecha']; ?></strong></span></td>
<td width="166"><span class="Estilo5">HORA:<strong><?php echo $row_imp1['hora']; ?></strong></span></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="4"><blockquote>
<p align="center">&nbsp;</p>
<p align="center"><span class="Estilo6">.::DATOS DE QUIEN REPORT&Oacute;::.</span></p>
</blockquote></td>
</tr>
<tr>
<td colspan="4"><table width="735" border="1" align="center" cellspacing="0" bordercolor="#000000">
<tr>
<td width="144" scope="row"><div align="center" class="Estilo8">UNIDAD:</div></td>
<td colspan="6" class="Estilo19"><?php echo $row_imp1['id_unidad']; ?></td>
</tr>
<tr>
<td scope="row"><div align="center"><span class="Estilo8">AREA:</span></div></td>
<td colspan="6" class="Estilo19"><?php echo $row_imp1['area']; ?></td>
</tr>
<tr>
<td scope="row"><div align="center"><span class="Estilo8">NOMBRE : </span></div></td>
<td colspan="6" class="Estilo19"><?php echo $row_imp1['reporta']; ?></td>
</tr>
<tr>
<td scope="row"><div align="center"><span class="Estilo8">TEL:</span></div></td>
<td width="124" class="Estilo19"><?php echo $row_imp1['tel']; ?></td>
<td width="97" class="Estilo19"><div align="center" class="Estilo23"><span class="Estilo24">EXT:</span></div></td>
<td width="146" class="Estilo19"><?php echo $row_imp1['ext']; ?></td>
<td colspan="2" class="Estilo19"><div align="center" class="Estilo23"><span class="Estilo24">VPN:</span></div></td>
<td width="146" class="Estilo19"><?php echo $row_imp1['vpn']; ?></td>
</tr>
</table></td>
</tr>
<tr>
<td>&nbsp;</td>
<td colspan="2">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td colspan="4"><div align="center" class="Estilo6">
<p><strong>.::DATOS DEL EQUIPO::.</strong></p>
<p>&nbsp;</p>
</div></td>
</tr>
<tr>
<td colspan="4"><table width="735" border="1" align="center" cellspacing="0" bordercolor="#000000">

<tr>
<td width="144" scope="row"><div align="center"><span class="Estilo8">INVENTARIO:</span></div></td>
<td width="124" class="Estilo19"><?php echo $row_imp1['inventario']; ?></td>
<td width="97"><div align="center"><span class="Estilo8">SERIE:</span></div></td>
<td width="146" class="Estilo19"><?php echo $row_imp1['serie']; ?></td>
<td><div align="center"><span class="Estilo8">NUM. IP :</span></div></td>
<td width="146" class="Estilo19"><?php echo $row_imp1['ip']; ?></td>
</tr>
<tr>
<td scope="row"><div align="center"><span class="Estilo8">MARCA:</span></div></td>
<td class="Estilo19"><?php echo $row_imp1['marca']; ?></td>
<td><div align="center"><span class="Estilo8">MODELO:</span></div></td>
<td class="Estilo19"><?php echo $row_imp1['modelo']; ?></td>
<td><div align="center"><span class="Estilo8">DISPOSITIVO:</span></div></td>
<td class="Estilo19"><?php echo $row_imp1['dispositivo']; ?></td>
</tr>
<tr>
<td colspan="6" scope="row"><p class="Estilo8">DESCRIPCI&Oacute;N DE LA FALLA :</p>
<p class="Estilo19"><?php echo $row_imp1['falla']; ?></p></td>
</tr>
<tr>
<td scope="row"><span class="Estilo8">ATENDI&Oacute;:</span></td>
<td colspan="5" class="Estilo19"><?php echo $row_imp1['id_nom']; ?></td>
</tr>
<tr>
<td colspan="6" scope="row"><p class="Estilo8">ACTIVIDADES REALIZADAS :</p>
<p class="Estilo19"><?php echo $row_imp1['actividades']; ?></p></td>
</tr>
</table>
<p>&nbsp;</p></td>
</tr>
<tr>
<script language="JavaScript" type="text/javascript">

function imprime(){
//desaparece el boton
document.getElementById("btnImprimir").style.displ ay='none'
//se imprime la pagina
window.print()

}

</script>
<td height="30" colspan="4"><div align="center"><span class="Estilo5">
<input name="btnImprimir" id="btnImprimir" type="button" class="button" value="IMPRIMIR" onclick="imprime()" />
</span><a href="menu_admon.php">&lt;&lt;</a></div></td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="">
</form>
</body>
</html>
<?php
mysql_free_result($imp1);
?>
__________________
ѕiεмpяε εѕтoy ѕoñαиdo *εи iиviεrиo coи εℓ ѕoℓ, coи ℓαѕ иubεѕ εи vεrαиo*
***DiαиiтHα***