modif_imb.php | searchcode

/provadm/administrador/inmuebles/modif_imb.php

https://gitlab.com/albert925/inmoprov
PHP | 359 lines | 359 code | 0 blank | 0 comment | 19 complexity | 83a4d00caf896f3f2f35f00d585b3089 MD5 | raw file

<?php
	include '../../../config.php';
	include '../../../fecha_format.php';
	session_start();
	if (isset($_SESSION['adm'])) {
		$idradd=$_SESSION['adm'];
		$datadm="SELECT * from administrador where id_adm=$idradd";
		$sql_adm=mysql_query($datadm,$conexion) or die (mysql_error());
		while ($ad=mysql_fetch_array($sql_adm)) {
			$usad=$ad['user_adm'];
			$tpad=$ad['tp_adm'];
		}
		$arrestado=["Seleccione","Arrendar","Venta","Arrendado","Vendido"];
		$idR=$_GET['ib'];
		if ($idR=="") {
			echo "<script type='text/javascript'>";
				echo "alert('id de inmueble no disponible');";
				echo "var pagina='../inmuebles';";
				echo "document.location.href=pagina;";
			echo "</script>";
		}
		else{
			$datos="SELECT * from inmuebles where cod_inm=$idR";
			$sql_datos=mysql_query($datos,$conexion) or die (mysql_error());
			while ($dt=mysql_fetch_array($sql_datos)) {
				$usb=$dt['usuario_id'];
				$tpb=$dt['tip_inm_id'];
				$ab=$dt['muni_id'];
				$bb=$dt['barr_id'];
				$cb=$dt['direccion_inm'];
				$db=$dt['estrato'];
				$eb=$dt['hab_inm'];
				$fb=$dt['sal_inm'];
				$gb=$dt['com_inm'];
				$hb=$dt['ban_inm'];
				$ib=$dt['coc_inm'];
				$jb=$dt['bal_inm'];
				$kb=$dt['pat_inm'];
				$lb=$dt['par_inm'];
				$mb=$dt['prec_inm'];
				$nb=$dt['prec_m2_inm'];
				$ob=$dt['area'];
				$pb=$dt['adminis_inm'];
				$qb=$dt['amobla_inm'];
				$rb=$dt['superficie_m2_inm'];
				$sb=$dt['superf_terre_inm'];
				$tb=$dt['estd_inm'];
				$ub=$dt['fe_inm'];
				$vb=$dt['lat_inm'];
				$wb=$dt['lon_inm'];
				$xb=$dt['descip_inm'];
				$yb=$dt['ff_inm'];
				$zb=$dt['fp_inm'];
				$aab=$dt['quin_publico'];
			}
?>
<!DOCTYPE html>
<html lang="es">
<head>
	<meta charset="utf-8" />
	<meta name="viewport" content="width=device-width, maximun-scale=1" />
	<meta name="description" content="Administra usuarios" />
	<meta name="keywords" content="Todos los usuarios" />
	<title>Administrar Inmuebles|Inmobiliaria Provase</title>
	<link rel="icon" href="../../../imagenes/icon.png" />
	<link rel="stylesheet" href="../../../css/normalize.css" />
	<link rel="stylesheet" href="../../../css/iconos/style.css" />
	<link rel="stylesheet" href="../../../css/style.css" />
	<link rel="stylesheet" href="../../../css/admin.css" />
	<script src="../../../js/jquery_2_1_1.js"></script>
	<script src="../../../js/scripag.js"></script>
	<script src="../../../js/scriadmin.js"></script>
	<script src="../../../js/adminmuebles.js"></script>
	<script src="../../../ckeditor/ckeditor.js"></script>
</head>
<body>
	<header>
		<figure id="logo">
			<a href="../">
				<img src="../../../imagenes/logo.png" alt="logo" />
			</a>
		</figure>
	</header>
	<article id="menuybusc">
		<nav id="mnP">
			<ul>
				<li><a href="../munins">Municipios y Barrios</a></li>
				<li><a href="../usuarios">Usuarios</a></li>
				<li><a class="sel" href="../inmuebles">Inmuebles</a></li>
				<li><a href="../proyectos">Proyectos</a></li>
				<li><a href="../"><?php echo "$usad"; ?></a></li>
				<li><a href="../../../cerrar">Salir</a></li>
			</ul>
		</nav>
		<div id="boton_mov"><span class="icon-menu"></span></div>
		<article id="buscador">
			<div><span class="icon-search"></span></div>
		</article>
	</article>
	<nav id="mnB">
		<a href="../inmuebles">Ver Inmuebles</a>
		<a href="images_inmueble.php">Imagenes de Inmuebles</a>
		<a href="tipos_inmuebles.php">Tipos de Inmuebles</a>
	</nav>
	<section>
		<h1>Datos del inmueble <?php echo "$idR"; ?></h1>
		<article id="automargen">
			<form action="modifc_inmueble.php" method="post" class="columninput">
				<input type="text" name="idib" required value="<?php echo $idR ?>" style="display:none;" />
				<label>*<b>Del Propietario (usuario)</b></label>
				<select id="prus" name="prus">
					<option value="0">Seleccione</option>
					<?php
						$Tous="SELECT * from usuarios order by id_us desc";
						$sql_us=mysql_query($Tous,$conexion) or die (mysql_error());
						while ($osus=mysql_fetch_array($sql_us)) {
							$idus=$osus['id_us'];
							$nmus=$osus['nom_ap_us'];
							if ($idus==$usb) {
								$selidusb="selected";
							}
							else{
								$selidusb="";
							}
					?>
					<option value="<?php echo $idus ?>" <?php echo $selidusb ?>><?php echo "$nmus"; ?></option>
					<?php
						}
					?>
				</select>
				<label>*<b>Del tipo</b></label>
				<select id="tpib" name="tpib">
					<option value="0">Seleccione</option>
					<?php
						$tdtp="SELECT * from tipo_inmueble order by nam_tp asc";
						$sql_tdtp=mysql_query($tdtp,$conexion) or die (mysql_error());
						while ($tpU=mysql_fetch_array($sql_tdtp)) {
							$idtpU=$tpU['id_tp'];
							$nmtpU=$tpU['nam_tp'];
							if ($idtpU==$tpb) {
								$seltipo="selected";
							}
							else{
								$seltipo="";
							}
					?>
					<option value="<?php echo $idtpU ?>" <?php echo $seltipo ?>><?php echo "$nmtpU"; ?></option>
					<?php
						}
					?>
				</select>
				<label>*<b>Municipio</b></label>
				<select id="mnib" name="mnib">
					<option value="0">Seleccione</option>
					<?php
						$Tmnnt="SELECT * from muni_nt_s order by nam_nt asc";
						$sql_mnnt=mysql_query($Tmnnt,$conexion) or die (mysql_error());
						while ($Umn=mysql_fetch_array($sql_mnnt)) {
							$idUmn=$Umn['id_nt'];
							$nmUmn=$Umn['nam_nt'];
							if ($idUmn==$ab) {
								$selab="selected";
							}
							else{
								$selab="";
							}
					?>
					<option value="<?php echo $idUmn ?>" <?php echo $selab ?>><?php echo "$nmUmn"; ?></option>
					<?php
						}
					?>
				</select>
				<div id="loadbarr"></div>
				<label>*<b>Barrio</b></label>
				<select id="barib" name="barib">
					<option value="0">Seleccione</option>
					<?php
						$Tdbarr="SELECT * from barrios order by nam_barr asc";
						$sql_tdbar=mysql_query($Tdbarr,$conexion) or die (mysql_error());
						while ($Ubarr=mysql_fetch_array($sql_tdbar)) {
							$idUbar=$Ubarr['id_barrio'];
							$nmUbarr=$Ubarr['nam_barr'];
							if ($idUbar==$bb) {
								$selbb="selected";
							}
							else{
								$selbb="";
							}
					?>
					<option value="<?php echo $idUbar ?>" <?php echo $selbb ?>><?php echo "$nmUbarr"; ?></option>
					<?php
						}
					?>
				</select>
				<label>*<b>Dirección</b></label>
				<input type="text" id="dirib" name="dirib" required value="<?php echo $cb ?>" />
				<label><b>Estrato</b></label>
				<select id="estib" name="estib">
					<?php
						for ($hes=1; $hes <=6 ; $hes++) {
							if ($hes==$db) {
								$selestrato="selected";
							}
							else{
								$selestrato="";
							}
					?>
					<option value="<?php echo $hes ?>" <?php echo $selestrato ?>><?php echo "$hes"; ?></option>
					<?php
						}
					?>
				</select>
				<article class="foofform">
					<div>
						<label><b>Hab</b></label>
						<input type="number" id="hb" name="hb" required value="<?php echo $eb ?>" />
					</div>
					<div>
						<label><b>Sal</b></label>
						<input type="number" id="sl" name="sl" required value="<?php echo $fb ?>" />
					</div>
					<div>
						<label><b>Com</b></label>
						<input type="number" id="cm" name="cm" required value="<?php echo $gb ?>" />
					</div>
					<div>
						<label><b>Bañ</b></label>
						<input type="number" id="bn" name="bn" required value="<?php echo $hb ?>" />
					</div>
					<div>
						<label><b>Coc</b></label>
						<input type="number" id="coc" name="coc" required value="<?php echo $ib ?>" />
					</div>
					<div>
						<label><b>Bal</b></label>
						<input type="number" id="bal" name="bal" required value="<?php echo $jb ?>" />
					</div>
					<div>
						<label><b>Pat</b></label>
						<input type="number" id="pat" name="pat" required value="<?php echo $kb ?>" />
					</div>
					<div>
						<label><b>Par</b></label>
						<input type="number" id="par" name="par" required value="<?php echo $lb ?>" />
					</div>
				</article>
				<label>*<b>Precio</b></label>
				<input type="number" id="preib" name="preib" required placeholder="solo numeros" value="<?php echo $mb ?>" />
				<label><b>Precio por m<sup>2</sup></b></label>
				<input type="number" id="precdosib" name="precdosib" placeholder="solo numeros" value="<?php echo $nb ?>" />
				<label><b>Area</b></label>
				<input type="text" id="areib" name="areib" value="<?php echo $ob ?>" />
				<label><b>Administración</b></label>
				<input type="text" id="adminib" name="adminib" value="<?php echo $pb ?>" />
				<label><b>Amoblado</b></label>
				<select id="amobib" name="amobib">
					<?php
						if ($qb=="Si") {
							$numselam=1;
						}
						else{
							$numselam=2;
						}
						$arrsino=["Selecione","Si","No"];
						for ($has=1; $has <=2 ; $has++) {
							if ($has==$numselam) {
								$selamobaldo="selected";
							}
							else{
								$selamobaldo="";
							}
					?>
					<option value="<?php echo $arrsino[$has] ?>" <?php echo $selamobaldo ?>><?php echo $arrsino[$has]; ?></option>
					<?php
						}
					?>
				</select>
				<label style="display:none;"><b>Superficie m<sup>2</sup></b></label>
				<input style="display:none;" type="text" id="superfib" name="superfib" value="<?php echo $rb ?>" />
				<label><b>Superficie terreno</b></label>
				<input type="text" id="superterib" name="superterib" value="<?php echo $sb ?>" />
				<label><b>Estado</b></label>
				<select id="esdib" name="esdib">
					<?php
						for ($ioes=0; $ioes <=2 ; $ioes++) {
							if ($ioes==$tb) {
								$selestado="selected";
							}
							else{
								$selestado="";
							}
					?>
					<option value="<?php echo $ioes ?>" <?php echo $selestado ?>><?php echo "$arrestado[$ioes]"; ?></option>
					<?php
						}
					?>
				</select>
				<label><b>Disponible a partir de</b></label>
				<input type="date" id="disfeib" name="disfeib" value="<?php echo $ub ?>" />
				<label style="display:none;"><b>Ubiacion google maps (Lat,Long)</b></label>
				<article style="display:none;" class="foofformBb">
					<div>
						<label><b>Latitud (positivo)</b></label>
						<input type="text" id="latib" name="latib" placeholder="7.858777" value="<?php echo $vb ?>" />
					</div>
					<div>
						<label><b>Longitud (negativo)</b></label>
						<input type="text" id="logib" name="logib" placeholder="-7.565456" value="<?php echo $wb ?>" />
					</div>
				</article>
				<label><b>Descripción</b></label>
				<textarea id="editor1" name="txib"><?php echo "$xb"; ?></textarea>
				<script>
					CKEDITOR.replace('txib');
				</script>
				<div id="txA"></div>
				<input type="submit" id="nvimb" value="Modificar" />
			</form>
		</article>
	</section>
	<footer>
		<article class="flexfoot">
			<article id="contfo">
				<h2>CONTACTO DETALLES</h2>
				<article>
					<div><span class="icon-location"></span>Av. 1E # 11-142 Barrio Caobos</div>
					<div>Colombia - Cúcuta</div>
					<div>
						<span class="icon-phone"></span>
						314 394 1701 - 315 827 4399
					</div>
					<div>
						<span class="icon-old-phone"></span>
						583 0897/98 - 573 0190 - 571 22 62
					</div>
					<div><span class="icon-mail"></span> Info@inmobiliariaprovase.com.co</div>
				</article>
			</article>
			<article id="mapagoogle">
				<article id="map_canvas" class="mapas"></article>
			</article>
		</article>
		<article class="finfoot">
			CONAXPORT © 2015 &nbsp;&nbsp;todos los derechos reservados &nbsp;- &nbsp;PBX (5) 841 733 &nbsp;&nbsp;Cúcuta - Colombia &nbsp;&nbsp;
			<a href="http://conaxport.com/" target="_blank">www.conaxport.com</a>
		</article>
	</footer>
</body>
</html>
<?php
		}
	}
	else{
		echo "<script type='text/javascript'>";
			echo "var pagina='../../errroadm.html';";
			echo "document.location.href=pagina;";
		echo "</script>";
	}
?>