Tul xxx Tul

Viewing: propertygrid.php

<?php 
ini_set('session.cache_limiter','public');
session_cache_limiter(false);
session_start();
include("config.php");

function pd_has_value($value) {
	$value = trim((string)$value);
	if ($value === '') { return false; }
	if (is_numeric($value) && (float)$value == 0.0) { return false; }
	return true;
}

// Dynamic filter options from actual property data
$typesResult = mysqli_query($con, "SELECT DISTINCT type FROM property WHERE type IS NOT NULL AND type != '' ORDER BY type ASC");
$types = [];
if ($typesResult) { while ($r = mysqli_fetch_assoc($typesResult)) $types[] = $r['type']; }

$stypesResult = mysqli_query($con, "SELECT DISTINCT stype FROM property WHERE stype IS NOT NULL AND stype != '' ORDER BY stype ASC");
$stypes = [];
if ($stypesResult) { while ($r = mysqli_fetch_assoc($stypesResult)) $stypes[] = $r['stype']; }

$statesResult = mysqli_query($con, "SELECT DISTINCT TRIM(state) AS state FROM property WHERE state IS NOT NULL AND state != '' ORDER BY TRIM(state) ASC");
$states = [];
if ($statesResult) { while ($r = mysqli_fetch_assoc($statesResult)) { if($r['state'] !== '') $states[] = $r['state']; } }

$citiesResult = mysqli_query($con, "SELECT DISTINCT city FROM property WHERE city IS NOT NULL AND city != '' ORDER BY city ASC");
$cities = [];
if ($citiesResult) { while ($r = mysqli_fetch_assoc($citiesResult)) $cities[] = $r['city']; }

$typeLabels  = ['apartment'=>'Apartamento','flat'=>'Piso','building'=>'Edificio','house'=>'Casa','villa'=>'Villa','office'=>'Oficina'];
$stypeLabels = ['rent'=>'Alquiler','sale'=>'Venta'];

// Current filter values (to keep selects selected after submit)
$selType  = isset($_REQUEST['type'])  ? trim($_REQUEST['type'])  : '';
$selStype = isset($_REQUEST['stype']) ? trim($_REQUEST['stype']) : '';
$selState = isset($_REQUEST['state']) ? trim($_REQUEST['state']) : '';
$selCity  = isset($_REQUEST['city'])  ? trim($_REQUEST['city'])  : '';

?><!-- FOR MORE PROJECTS visit: codeastro.com -->
<!DOCTYPE html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<!-- Meta Tags -->
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="description" content="Real Estate PHP">
<meta name="keywords" content="">
<meta name="author" content="Unicoder">
<link rel="shortcut icon" type="image/png" href="images/logo/logo.png">

<!--	Fonts
	========================================================-->
<link href="https://fonts.googleapis.com/css?family=Muli:400,400i,500,600,700&amp;display=swap" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Comfortaa:400,700" rel="stylesheet">

<!--	Css Link
	========================================================-->
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap-slider.css">
<link rel="stylesheet" type="text/css" href="css/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="css/layerslider.css">
<link rel="stylesheet" type="text/css" href="css/color.css" id="color-change">
<link rel="stylesheet" type="text/css" href="css/owl.carousel.min.css">
<link rel="stylesheet" type="text/css" href="css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" href="fonts/flaticon/flaticon.css">
<link rel="stylesheet" type="text/css" href="css/style.css">

<!--	Title
	=========================================================-->
<title>Inmobiliaria PHP</title>
</head>
<body>

<!--	Page Loader
=============================================================
<div class="page-loader position-fixed z-index-9999 w-100 bg-white vh-100">
	<div class="d-flex justify-content-center y-middle position-relative">
	  <div class="spinner-border" role="status">
		<span class="sr-only">Loading...</span>
	  </div>
	</div>
</div>
--> 


<div id="page-wrapper">
    <div class="row"> 
        <!--	Header start  -->
		<?php include("include/header.php");?>
        <!--	Header end  -->
        
        <!--	Banner   --->
        <div class="banner-full-row page-banner" style="background-image:url('images/breadcromb.jpg');">
            <div class="container">
                <div class="row">
                    <div class="col-md-6">
                        <h2 class="page-name float-left text-white text-uppercase mt-1 mb-0"><b>Filtrar Propiedad</b></h2>
                    </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
                    <div class="col-md-6">
                        <nav aria-label="breadcrumb" class="float-left float-md-right">
                            <ol class="breadcrumb bg-transparent m-0 p-0">
                                <li class="breadcrumb-item text-white"><a href="#">Inicio</a></li>
                                <li class="breadcrumb-item active">Filtrar Propiedad</li>
                            </ol>
                        </nav>
                    </div>
                </div>
            </div>
        </div>
         <!--	Banner   --->
        
        <!--	Property Grid
		===============================================================-->
        <div class="full-row">
            <div class="container">
                <div class="row">
				
					<div class="col-lg-8">
                        <div class="row">
						<!-- FOR MORE PROJECTS visit: codeastro.com -->
							<?php 
							
							if(isset($_REQUEST['filter']))
							{
								$type = isset($_REQUEST['type']) ? trim($_REQUEST['type']) : '';
								$stype = isset($_REQUEST['stype']) ? trim($_REQUEST['stype']) : '';
								$state = isset($_REQUEST['state']) ? trim($_REQUEST['state']) : '';
								$city = isset($_REQUEST['city']) ? trim($_REQUEST['city']) : '';
								
								$conditions = array("1=1");
								if($type !== '')
								{
									$type = mysqli_real_escape_string($con, $type);
									$conditions[] = "p.type='{$type}'";
								}
								if($stype !== '')
								{
									$stype = mysqli_real_escape_string($con, $stype);
									$conditions[] = "p.stype='{$stype}'";
								}
								if($state !== '')
								{
									$state = mysqli_real_escape_string($con, $state);
									$conditions[] = "p.state='{$state}'";
								}
								if($city !== '')
								{
									$city = mysqli_real_escape_string($con, $city);
									$conditions[] = "p.city='{$city}'";
								}
								
								$sql="SELECT p.*, COALESCE(u.uname,'Admin') AS uname FROM `property` p LEFT JOIN `user` u ON p.uid=u.uid WHERE " . implode(' and ', $conditions);
								//SELECT * FROM `property` WHERE type='office' or type='office' and stype='sale' or stype='rent' and city='valsad' OR state='mumbai'
								//SELECT * FROM `property` WHERE type='office' and stype='sale'  and city='valsad' OR state='mumbai'
								$result=mysqli_query($con,$sql);
							
								if(mysqli_num_rows($result)>0)
								{
									if($result == true)
									{
										while($row=mysqli_fetch_array($result))
										{
							?>
									
                            <div class="col-md-6">
                                <div class="featured-thumb hover-zoomer mb-4">
									<?php
										$thumbSrc = '';
										foreach (['18', '19', '20', '21', '22'] as $imgField) {
											$filename = isset($row[$imgField]) ? trim((string)$row[$imgField]) : '';
											if ($filename === '') {
												continue;
											}
											$filePath = __DIR__ . DIRECTORY_SEPARATOR . 'admin' . DIRECTORY_SEPARATOR . 'property' . DIRECTORY_SEPARATOR . $filename;
											if (!is_file($filePath)) {
												continue;
											}
											$thumbSrc = 'admin/property/' . $filename;
											break;
										}
									?>
									<div class="overlay-black overflow-hidden position-relative">
										<?php if ($thumbSrc !== '') { ?>
										<img src="<?php echo htmlspecialchars($thumbSrc, ENT_QUOTES); ?>" alt="pimage">
										<?php } else { ?>
										<div style="height: 250px; background: #f3f4f6;"></div>
										<?php } ?>
										<?php if (pd_has_value($row['5'])) { ?>
										<div class="sale bg-success text-white">En <?php echo $row['5'];?></div>
										<?php } ?>
										<?php if (pd_has_value($row['13']) || pd_has_value($row['12'])) { ?>
										<div class="price text-primary text-capitalize">
											<?php if (pd_has_value($row['13'])) { ?>$<?php echo $row['13'];?><?php } ?>
											<?php if (pd_has_value($row['12'])) { ?> <span class="text-white"><?php echo $row['12'];?> Sqft</span><?php } ?>
										</div>
										<?php } ?>
									
									</div>
                                    <div class="featured-thumb-data shadow-one">
                                        <div class="p-4">
                                            <h5 class="text-secondary hover-text-success mb-2 text-capitalize"><a href="propertydetail.php?pid=<?php echo $row['0'];?>"><?php echo $row['1'];?></a></h5>
										<?php if (pd_has_value($row['14'])) { ?>
                                            <span class="location text-capitalize"><i class="fas fa-map-marker-alt text-success"></i> <?php echo $row['14'];?></span>
										<?php } ?> </div>
                                        <div class="px-4 pb-4 d-inline-block w-100">
                                            <div class="float-left text-capitalize"><i class="fas fa-user text-success mr-1"></i>Por : <?php echo $row['uname'];?></div>
                                            <div class="float-right"><i class="far fa-calendar-alt text-success mr-1"></i> <?php echo date('d-m-Y', strtotime($row['date']));?></div>
                                        </div>
                                    </div>
                                </div>
                            </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
                            <?php 		
										} 
					
									}
								}
								else {
									
									echo "<h1 class='mb-5'><center>No Hay Propiedades Disponibles</center></h1>";
								}
									
							}

							?>
                            

                            
                            
                        <!--    <div class="col-md-12">
                                <nav aria-label="Page navigation">
                                    <ul class="pagination justify-content-center mt-4">
                                        <li class="page-item disabled"> <span class="page-link">Previous</span> </li>
                                        <li class="page-item active" aria-current="page"> <span class="page-link"> 1 <span class="sr-only">(current)</span> </span> </li>
                                        <li class="page-item"><a class="page-link" href="#">2</a></li>
                                        <li class="page-item"><a class="page-link" href="#">3</a></li>
                                        <li class="page-item">...</li>
                                        <li class="page-item"><a class="page-link" href="#">5</a></li>
                                        <li class="page-item"> <a class="page-link" href="#">Next</a> </li>
                                    </ul>
                                </nav>
                            </div>  -->
                        </div>
                    </div><!-- FOR MORE PROJECTS visit: codeastro.com -->
					
                    <div class="col-lg-4">
                        <!-- Filter Sidebar -->
                        <div class="sidebar-widget mb-4">
                            <h4 class="double-down-line-left text-secondary position-relative pb-4 my-4">Filtrar Propiedades</h4>
                            <form method="post" action="propertygrid.php">
                                <div class="form-group">
                                    <select class="form-control" name="type">
                                        <option value="">Todos los Tipos</option>
                                        <?php foreach ($types as $t): ?>
                                        <option value="<?php echo htmlspecialchars($t, ENT_QUOTES); ?>" <?php echo ($selType===$t)?'selected':''; ?>>
                                            <?php echo isset($typeLabels[$t]) ? $typeLabels[$t] : ucfirst($t); ?>
                                        </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <select class="form-control" name="stype">
                                        <option value="">Venta y Alquiler</option>
                                        <?php foreach ($stypes as $st): ?>
                                        <option value="<?php echo htmlspecialchars($st, ENT_QUOTES); ?>" <?php echo ($selStype===$st)?'selected':''; ?>>
                                            <?php echo isset($stypeLabels[$st]) ? $stypeLabels[$st] : ucfirst($st); ?>
                                        </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <select class="form-control" name="state">
                                        <option value="">Todos los Departamentos</option>
                                        <?php foreach ($states as $s): ?>
                                        <option value="<?php echo htmlspecialchars($s, ENT_QUOTES); ?>" <?php echo ($selState===$s)?'selected':''; ?>>
                                            <?php echo htmlspecialchars($s); ?>
                                        </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <div class="form-group">
                                    <select class="form-control" name="city">
                                        <option value="">Todas las Ciudades</option>
                                        <?php foreach ($cities as $c): ?>
                                        <option value="<?php echo htmlspecialchars($c, ENT_QUOTES); ?>" <?php echo ($selCity===$c)?'selected':''; ?>>
                                            <?php echo htmlspecialchars($c); ?>
                                        </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                                <button type="submit" name="filter" class="btn btn-success w-100">
                                    <i class="fas fa-search mr-1"></i> Buscar
                                </button>
                                <?php if($selType || $selStype || $selState || $selCity): ?>
                                <a href="propertygrid.php" class="btn btn-outline-secondary w-100 mt-2">
                                    <i class="fas fa-times mr-1"></i> Limpiar Filtros
                                </a>
                                <?php endif; ?>
                            </form>
                        </div>

                        <div class="sidebar-widget">
                            <h4 class="double-down-line-left text-secondary position-relative pb-4 my-4">Calculadora de Cuotas</h4>
						<form class="d-inline-block w-100" action="calc.php" method="post">
                            <label class="sr-only">Property Amount</label>
                            <div class="input-group mb-2 mr-sm-2">
                                <div class="input-group-prepend">
                                    <div class="input-group-text">$</div>
                                </div>
                                <input type="text" class="form-control" name="amount" placeholder="Precio de la Propiedad">
                            </div>
                            <label class="sr-only">Month</label>
                            <div class="input-group mb-2 mr-sm-2">
                                <div class="input-group-prepend">
                                    <div class="input-group-text"><i class="far fa-calendar-alt"></i></div>
                                </div>
                                <input type="text" class="form-control" name="month" placeholder="Duración en Años">
                            </div>
                            <label class="sr-only">Interest Rate</label>
                            <div class="input-group mb-2 mr-sm-2">
                                <div class="input-group-prepend">
                                    <div class="input-group-text">%</div>
                                </div>
                                <input type="text" class="form-control" name="interest" placeholder="Tasa de Interés">
                            </div>
                            <button type="submit" value="submit" name="calc" class="btn btn-danger mt-4">Calcular Cuota</button>
                        </form>
                        </div>
                        
                        <div class="sidebar-widget mt-5">
                            <h4 class="double-down-line-left text-secondary position-relative pb-4 mb-4">Propiedades Agregadas Recientemente</h4>
                            <ul class="property_list_widget">
							
								<?php 
								$query=mysqli_query($con,"SELECT * FROM `property` ORDER BY date DESC LIMIT 6");
										while($row=mysqli_fetch_array($query))
										{
								?>
								<?php
									$thumbSrc = '';
									foreach (['18', '19', '20', '21', '22'] as $imgField) {
										$filename = isset($row[$imgField]) ? trim((string)$row[$imgField]) : '';
										if ($filename === '') {
											continue;
										}
										$filePath = __DIR__ . DIRECTORY_SEPARATOR . 'admin' . DIRECTORY_SEPARATOR . 'property' . DIRECTORY_SEPARATOR . $filename;
										if (!is_file($filePath)) {
											continue;
										}
										$thumbSrc = 'admin/property/' . $filename;
										break;
									}
								?>
                                <li>
									<?php if ($thumbSrc !== '') { ?><img src="<?php echo htmlspecialchars($thumbSrc, ENT_QUOTES); ?>" alt="pimage"><?php } ?>
                                    <h6 class="text-secondary hover-text-success text-capitalize"><a href="propertydetail.php?pid=<?php echo $row['0'];?>"><?php echo $row['1'];?></a></h6>
									<?php if (pd_has_value($row['14'])) { ?>
                                    <span class="font-14"><i class="fas fa-map-marker-alt icon-success icon-small"></i> <?php echo $row['14'];?></span>
									<?php } ?>
                                    
                                </li>
                                <?php } ?>

                            </ul>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>

        
        <!--	Footer   start-->
		<?php include("include/footer.php");?>
		<!--	Footer   start-->
        
        <!-- Scroll to top --> 
        <a href="#" class="bg-secondary text-white hover-text-secondary" id="scroll"><i class="fas fa-angle-up"></i></a> 
        <!-- End Scroll To top --> 
    </div>
</div>
<!-- Wrapper End --> 

<!--	Js Link
============================================================--> 
<script src="js/jquery.min.js"></script> 
<!--jQuery Layer Slider --> 
<script src="js/greensock.js"></script> 
<script src="js/layerslider.transitions.js"></script> 
<script src="js/layerslider.kreaturamedia.jquery.js"></script> 
<!--jQuery Layer Slider --> 
<script src="js/popper.min.js"></script> 
<script src="js/bootstrap.min.js"></script> 
<script src="js/owl.carousel.min.js"></script> 
<script src="js/tmpl.js"></script> 
<script src="js/jquery.dependClass-0.1.js"></script> 
<script src="js/draggable-0.1.js"></script> 
<script src="js/jquery.slider.js"></script> 
<script src="js/wow.js"></script> 

<script src="js/custom.js"></script>
</body>

</html>
User / IP	: 216.73.216.227
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64