<?
include("../../inc/i_conect.php");
include("../../inc/i_comunes.php");
include("../inc/i_tabla.php");
include("../inc/tbl_inmueble.php");
include("../inc/tbl_inmb_ubicacion.php");
include("../inc/tbl_inmb_relacionado.php");
include("../inc/tbl_inmb_varios.php");
include("../inc/tbl_area_aux.php");
include("../inc/tbl_inmb_estado_propied.php");
include("../inc/tbl_inmb_area.php");
include("../inc/tbl_inmb_obser.php");
include("../inc/tbl_foto.php");
include("../inc/tbl_user.php");
include("../inc/tbl_divisa.php");
/****************************************************************/
/*
-- File Name: list_ficha_inmb.php
-- Description : página para el listado de usuarios
-- Programmer  : Christian Diaz
-- Date  : 08/Jun/2006 
*/
/****************************************************************/
$vlCod = $_GET["hddCod"];
/****************************************************************/
$vlLabel = "Inmueble " ;
$vlLabels = "Inmuebles " ;
$vlFlag = true;
$vlCriterio = "";
$vlBusca = "";
$VLTamPag = "";
$vlTotalPag = "";
$vlPlanta= "";
$vlClassName = "";
$vlMontoBol = "";
/****************************************************************/
$vecCampos[0]="list_inmueble.php";
$vecCampos[1]="mod_inmueble.php";
$vecCampos[2]="list_foto.php";
/****************************************************************/
if(isset($_SESSION["vgVecUser"]) == "")
{
	fm_carga_user();
}
$vlResult = fm_bus_inmueble($vlCod, "", "", "", "", "", "", "", "", "", "","", "", "", "", "", "", "", "");

$vlReturn = mysql_num_rows($vlResult);
$vecInmb = array();
if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecInmb[0] = $vlObjrst["inmb_cod"];

		$vecInmb[1] = $vlObjrst["inmb_transac"];
		$vecInmb[2] = $vlObjrst["inmb_codigo_as"];
		$vecInmb[3] = $vlObjrst["inmb_monto"];
		$vecInmb[39] = $vlObjrst["inmb_monto2"];
		$vecInmb[4] = $vlObjrst["inmb_div_cod"];
		$vecInmb[5] = $vlObjrst["inmb_stat_pub"];
		$vecInmb[6] = $vlObjrst["inmb_stat_ofer"];
		$vecInmb[7] = $vlObjrst["inmb_fech_venc_ofer"];
		$vecInmb[8] = $vlObjrst["inmb_fech_ing"];
		$vecInmb[9] = $vlObjrst["inmb_fech_ult_act"];
		$vecInmb[10] = $vlObjrst["inmb_fech_firma"];
		$vecInmb[11] = $vlObjrst["inmb_fech_dispon"]; 
		$vecInmb[12] = $vlObjrst["inmb_fuen_cod"]; 
		$vecInmb[13] = $vlObjrst["inmb_user_cod"];
		$vecInmb[14] = $vlObjrst["inmb_firma"];  
		$vecInmb[15] = $vlObjrst["inmb_publ_fot"];
		$vecInmb[16] = $vlObjrst["inmb_stat"];
		
		$vecInmb[17] = $vlObjrst["inubic_cod"]; 
		$vecInmb[18] = $vlObjrst["inubic_zon_cod"]; 
		$vecInmb[19] = $vlObjrst["inubic_cdad_cod"];
		$vecInmb[20] = $vlObjrst["inubic_mncp_cod"];  
		$vecInmb[21] = $vlObjrst["inubic_zmun_cod"];
		$vecInmb[22] = $vlObjrst["inubic_nomb"];		
		$vecInmb[23] = $vlObjrst["inubic_dir"]; 
		$vecInmb[24] = $vlObjrst["inubic_tel"]; 
		$vecInmb[25] = $vlObjrst["inubic_tel2"];
		
		$vecInmb[26] = $vlObjrst["inubic_tinm_cod"];  
		$vecInmb[27] = $vlObjrst["inubic_tinm_plan"];	
		$vecInmb[29] = $vlObjrst["inubic_estad_estruc"];
		$vecInmb[30] = $vlObjrst["inubic_tipo_estruc"];	

		$vecInmb[31] = $vlObjrst["inmb_area"];  
		$vecInmb[32] = $vlObjrst["inmb_ano_const"];
		$vecInmb[33] = $vlObjrst["inmb_habit"];
		$vecInmb[34] = $vlObjrst["inmb_banos"];
		$vecInmb[35] = $vlObjrst["inmb_terraza"];	
		$vecInmb[36] = $vlObjrst["inmb_piscina"];
		$vecInmb[37] = $vlObjrst["inmb_cant_estacio"];
		$vecInmb[38] = $vlObjrst["inmb_amoblado"];		
		$vecInmb[40] = $vlObjrst["inmb_fech_anive"];		
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/

$vlResult = fm_bus_relacionado("", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
$vecRel = array(array(), array()); 
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vlCont = count($vecRel[0]);
		$vecRel[0][$vlCont]  = trim($vlObjrst["inrel_cod"]);
		$vecRel[1][$vlCont]  = trim($vlObjrst["inrel_inmb_cod"]);

		$vecRel[2][$vlCont]  = trim($vlObjrst["inrel_nombre"]);
		$vecRel[3][$vlCont]  = trim($vlObjrst["inrel_ced"]);
		$vecRel[4][$vlCont]  = trim($vlObjrst["inrel_tel_hab"]);
		$vecRel[5][$vlCont]  = trim($vlObjrst["inrel_tel_ofic"]);
		$vecRel[6][$vlCont]  = trim($vlObjrst["inrel_tel_cel"]);
		$vecRel[7][$vlCont]  = trim($vlObjrst["inrel_fax"]);
		$vecRel[8][$vlCont]  = trim($vlObjrst["inrel_mail"]);
		$vecRel[9][$vlCont]  = trim($vlObjrst["inrel_observ"]);
		$vecRel[10][$vlCont] = trim($vlObjrst["inrel_tipo_rela"]);
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/

$vlResult = fm_bus_varios( "", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecVarios[0] = $vlObjrst["invar_cod"];
		$vecVarios[1] = $vlObjrst["invar_inmb_cod"];

		$vecVarios[2] = $vlObjrst["invar_tennis"];
		$vecVarios[3] = $vlObjrst["invar_gimnasio"];
		$vecVarios[4] = $vlObjrst["invar_squash"];
		$vecVarios[5] = $vlObjrst["invar_sala_fies"];
		$vecVarios[6] = $vlObjrst["invar_sauna"];
		$vecVarios[7] = $vlObjrst["invar_jardin"];
		$vecVarios[8] = $vlObjrst["invar_tip_vigilancia"];
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/

$vlResult = fm_bus_area_aux( "", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecAreaAux[0] = $vlObjrst["areaux_cod"];
		$vecAreaAux[1] = $vlObjrst["areaux_inmb_cod"];

		$vecAreaAux[2] = $vlObjrst["areaux_const"];
		$vecAreaAux[3] = $vlObjrst["areaux_jardin"];
		$vecAreaAux[4] = $vlObjrst["areaux_terra"];
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/

$vlResult = fm_bus_est_prop( "", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecEstProp[0] = $vlObjrst["inep_cod"] ;
		$vecEstProp[1] = $vlObjrst["inep_inmb_cod"] ;

		$vecEstProp[2] = $vlObjrst["inep_estad_propied"] ; 	
		$vecEstProp[4] = $vlObjrst["inep_piso"] ;
		$vecEstProp[6] = $vlObjrst["inep_aire_acond"] ;
		$vecEstProp[7] = $vlObjrst["inep_tip_cable"] ;
		$vecEstProp[8] = $vlObjrst["inep_lineas_tel"] ;
		$vecEstProp[9] = $vlObjrst["inep_aba"] ;
		$vecEstProp[10] = $vlObjrst["inep_mascota"] ;
		$vecEstProp[11] = $vlObjrst["inep_luminosidad"] ;
		$vecEstProp[12] = $vlObjrst["inep_tipo_vista"] ;	
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/

$vlResult = fm_bus_Area("", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecArea[0] = $vlObjrst["inarea_cod"];
		$vecArea[1] = $vlObjrst["inarea_inmb_cod"];

		$vecArea[3] = $vlObjrst["inarea_hab_ppal"];
		$vecArea[5] = $vlObjrst["inarea_bano_visit"];
		$vecArea[6] = $vlObjrst["inarea_bano_med"];
		$vecArea[7] = $vlObjrst["inarea_tipo_cocina"];
		$vecArea[8] = $vlObjrst["inarea_estad_cocina"];
		$vecArea[9] = $vlObjrst["inarea_tipo_estufa"]; 
		$vecArea[10] = $vlObjrst["inarea_tipo_horno"];  
		$vecArea[11] = $vlObjrst["inarea_nevera"]; 
		$vecArea[12] = $vlObjrst["inarea_congelador"];  
		$vecArea[13] = $vlObjrst["inarea_lavaplato"];
		$vecArea[14] = $vlObjrst["inarea_micro"];  
		$vecArea[15] = $vlObjrst["inarea_pantry"]; 
		$vecArea[16] = $vlObjrst["inarea_lavadora"];
		$vecArea[17] = $vlObjrst["inarea_secadora"];
		$vecArea[18] = $vlObjrst["inarea_utensilio"];
		$vecArea[19] = $vlObjrst["inarea_tipo_salon_comedor"];
		$vecArea[21] = $vlObjrst["inarea_estudio"];
		$vecArea[22] = $vlObjrst["inarea_family_room"]; 
		$vecArea[23] = $vlObjrst["inarea_hab_serv"];
		$vecArea[24] = $vlObjrst["inarea_bano_serv"];
		$vecArea[25] = $vlObjrst["inarea_hab_chofer"];  
		$vecArea[27] = $vlObjrst["inarea_tipo_estaciona"];
		$vecArea[28] = $vlObjrst["inarea_maletero"];
	}
	mysql_free_result($vlResult);
}

/*****************************************************************************************/
$vlResult = fm_bus_Observ( "", $vlCod);

$vlReturn = mysql_num_rows($vlResult);

if(!empty($vlReturn))
{
	while($vlObjrst = mysql_fetch_array($vlResult))
	{
		$vecObser[0] = $vlObjrst["inobs_cod"];
		$vecObser[1] = $vlObjrst["inobs_inmb_cod"];

		$vecObser[2] = $vlObjrst["inobs_hist_propied"];
		$vecObser[3] = $vlObjrst["inobs_otros_datos"];
	}
	mysql_free_result($vlResult);
}
/*****************************************************************************************/

?>
<html>
<head>
<script language="javascript" src="../../js/Calendar.js"></script>
<title>..::  ::..</title>

<? include("meta_scripts.html"); ?>

</head>
<body>
<table width="100%" align="center" cellpadding="0" cellspacing="1">
<!-- Inicio Encabezado -->
	<tr>
	  <td>
	  	<table width="720" border="0" align="center" cellpadding="0" cellspacing="0">
         <tr>
					<td>
           <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="#000000">
						<tr>
							<td>
								<img alt="" src="../../img/top_ficha.jpg" border="0" width="720" height="45"></td>
						</tr>
					 </table>
					</td>
				 </tr>
				 <tr>
           <td>
           <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1"  bgcolor="#000000">
            <tr bgcolor="#F4F4F4">
             <td class="titulo_ficha">AUTORIZACION - PROPIEDADES </td>
              <td>
              	<table width="100%" align="center" cellpadding="0" cellspacing="0" >
              		<tr class="titulo_ficha">
              			<td width="50%" align="center" valign="top">&nbsp;Alquiler&nbsp;</td>
              		 	<td width="50%" align="center" valign="baseline"> <? if ($vecInmb[1] == 1) {?> <img src="../../img/admin/marca.gif"/> <? }else{ ?> <img src="../../img/admin/no_marca.gif"/>  <? } ?></td>
              		</tr>
              	</table>              </td>
              <td>
              	<table width="100%" align="center" cellpadding="0" cellspacing="0">
              		<tr class="titulo_ficha">
              			<td width="50%" align="center" valign="top">&nbsp;Venta&nbsp;</td>
              		 	<td width="50%" align="center" valign="baseline"> <? if ($vecInmb[1] == 2) {?> <img src="../../img/admin/marca.gif"/> <? }else{ ?> <img src="../../img/admin/no_marca.gif"/>  <? } ?></td>
              		</tr>
              	</table>              </td>
              <td>
              	<table width="100%" align="center" cellpadding="0" cellspacing="0">
              		<tr class="titulo_ficha">
              			<td width="50%" align="center" valign="top">&nbsp;Alquiler/Venta&nbsp;</td>
              		 	<td width="50%" align="center" valign="bottom"> <? if ($vecInmb[1] == 3) {?> <img src="../../img/admin/marca.gif"/> <? }else{ ?> <img src="../../img/admin/no_marca.gif"/>  <? } ?></td>
              		</tr>
              	</table>              </td>
              <td>
              	<table width="100%" align="center" cellpadding="0" cellspacing="0">
              		<tr class="titulo_ficha">
              			<td width="50%" align="center" valign="top">&nbsp;Administraci&oacute;n&nbsp;</td>
              		 	<td width="50%" align="center" valign="bottom"> <? if ($vecInmb[1] == 4) {?> <img src="../../img/admin/marca.gif"/> <? }else{ ?> <img src="../../img/admin/no_marca.gif"/>  <? } ?></td>
              		</tr>
              	</table>              </td>
             </tr>
          </table>         </td>
        </tr>
        
        <tr>
          <td>
          <table width="100%" border="0" cellspacing="0" cellpadding="0" >
            <tr>
              <td width="25%" valign="top">
              	<table width="100%" height="157" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000">
                <tr bgcolor="#F4F4F4">
                  <td colspan="2" class="titulo_ficha">DATOS DE LA PROPIEDAD </td>
                </tr>
                <tr bgcolor="#F4F4F4">
                  <td width="23%" class="titulo_ficha">Ficha:</td>
                  <td width="77%" class="dato_ficha"	><b></b></td>
                </tr>
                <tr bgcolor="#F4F4F4">
                  <td width="23%" class="titulo_ficha">Nombre:</td>
                  <td width="77%" class="dato_ficha"	></td>
                </tr>                
                <tr bgcolor="#F4F4F4">
                  <td valign="top" class="titulo_ficha">Direcci&oacute;n :</td>
                  <td valign="top" class="dato_ficha"	><table width="100%" height="35" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td class="dato_ficha">
											<p>
												. Urbanizaci&oacute;n