<?php
//include("conexion.php");
$connect = pg_connect("host=localhost port=5432 dbname=administra user=postgres password=1234");
$select = "SELECT propietarios1.nroapto,propietarios1.nombres,propietarios1.apellidos FROM administra.propietarios1 ORDER BY propietarios1.nroapto";
//$propietarios1 = "SELECT * FROM administ.propietarios1 ORDER BY propietarios1.nombres";
$connect4 = "SELECT * FROM administra.public.propietarios1 ORDER BY propietarios1.nroapto";
$respuesta=@pg_query($connect,$connect4);
$sql="SELECT * FROM administra.propietarios1 ORDER BY ".$_GET['nroapto']." ASC";
?>
<!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>Ingreso de propietarios1</TITLE>
<style type="text/css">
.sr {
background-color: #FFFFCF;
color: #000000;
font-family: Arial;
font-size: 12px;
}
input.color1 {background-color: #00CC99; font-weight: bold; font-size: 12px; color: white;}
</style>
<script type="text/javascript">
var patron = new Array(2,2)
function mascara(d,sep,pat,nums){
if(d.valant != d.value){
val = d.value
largo = val.length
val = val.split(sep)
val2 = ''
for(r=0;r<val.length;r++){
val2 += val[r]
}
if(nums){
for(z=0;z<val2.length;z++){
if(isNaN(val2.charAt(z))){
letra = new RegExp(val2.charAt(z),"g")
val2 = val2.replace(letra,"")
}
}
}
val = ''
val3 = new Array()
for(s=0; s<pat.length; s++){
val3[s] = val2.substring(0,pat[s])
val2 = val2.substr(pat[s])
}
for(q=0;q<val3.length; q++){
if(q ==0){
val = val3[q]
}
else{
if(val3[q] != ""){
val += sep + val3[q]
}
}
}
d.value = val
d.valant = val
}
}
</script>
</HEAD>
<BODY>
<FORM action="actualizacion1.php" method="post"><fieldset style='width:auto'><LEGEND>Ingreso de propietarios1</LEGEND>
<table align="center">
<TR>
<td class="sr"><?php echo "Nro Apartamento:" ?></td>
<td class="sr"><input type="text" name = "nroapto" onkeyup="mascara(this,'-',patron,true)" size="5" maxlength="5" /></td>
</TR>
<TR>
<td class="sr"><?php echo "Apellidos:" ." " ?></td>
<TD class="sr"><input type="text" name="apellidos" size="100" align="right"/></TD>
</TR>
<TR>
<td class="sr"><?php echo "Nombres:" ." " ?></td>
<TD class="sr"><input type="text" name="nombres" size="100" /></TD>
</TR>
<TR>
<td class="sr"><?php echo "Alícuota:" ." "." " ." "?></td>
<TD class="sr"><input type="text" name="alicuota" size="10" maxlength="5" value="0.00" align="right"/></TD>
</TR>
<TR>
<td class="sr"><?php echo "Cédula:" ." "." " ." "?></td>
<TD class="sr"><input type="text" name="cedula" size="8" maxlength="8" /></TD>
</TR>
</table>
</fieldset>
<table width="200" border="0" align="center">
<tr>
<td>
<input type="submit" name="action" value="Enviar"/></td>
<td><input type="reset" value="Deshacer"/></td>
<td><INPUT TYPE="BUTTON" VALUE="Salir" ONCLICK="window.location.href='menu.html'"/></td>
</tr>
</table>
<table align="center" border="1" bordercolor="#00CC99" bgcolor="#99CC00">
<tr>
<th width="250">Apellidos
<th width="250">Nombres
</tr>
</table>
<?php
$nroapto =$_POST['nroapto'];
$apellidos =$_POST['apellidos'];
$nombres =$_POST['nombres'];
$alicuota =$_POST['alicuota'];
$cedula =$_POST['cedula'];
if (isset($_POST['action'])):
//--Declara Funcion para grabar registros
function insertar($nroapto,$apellidos,$nombres,$alicuota,$cedula)
{
$connect2 = pg_connect("host=localhost port=5432 dbname=administra user=postgres password=1234");
$guardar = "INSERT INTO administra.public.propietarios1(nroapto,apellidos,nombres,alicuota,cedula) VALUES ('$nroapto', UPPER('$apellidos'),UPPER('$nombres'),'$alicuota','$cedula')";
$actualiza = @pg_query($connect2,$guardar);
}
if (insertar($nroapto,$apellidos,$nombres,$alicuota,$cedula)>=1):
echo("<script type='text/javascript'>window.location='actualizacion1.php'; </script>");
header("Location:actualizacion1.php");
endif;
endif;
$propietarios1 = "SELECT * FROM propietarios1 ORDER BY apellidos,nombres";
$seleccionados = @pg_query($connect,$propietarios1);
while ($listado = @pg_fetch_array($seleccionados)):
$nroapto = $listado['nroapto'];
$apellidos = strtoupper($listado['apellidos']);
$nombres = strtoupper($listado['nombres']);
$cedula = $listado['cedula'];
echo"<table border='1' align='center' bordercolor='#FFCC99'>
<tr class='sr'>
<td width='20'><a title='Modificar' href='modificaprop.php?cod=$nroapto'>$nroapto</a>
<td width='240'>$apellidos
<td width='240'>$nombres
<td width=100>
<A href='eliminaprop.php?nro=$nroapto'
onClick='return confirm(\"¿Está Seguro de Eliminar este Registro?\");'>
<img src='img/equis.gif' title='Eliminar'></A>
</tr>
</table>";
endwhile;
?>
</FORM>
</BODY>
</HTML>