✏️ Editing: inmuebles.php

<?php
date_default_timezone_set('America/Caracas');
$fes = date("Y-m-d");
?>
<?php
include '../conex.php';
  $sql=$conex->query ("SELECT * FROM  imagenes where id='1' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $archivo=$row{'archivo'};           
             }
}

$sql=$conex->query ("SELECT razonsocial  FROM  configuracion where id='1' ") or die(mysqli_error());
     if($row_cnt = $sql->num_rows>0) {       
          while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {           
            $razonsocialxx=$row{'razonsocial'};           
             }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
  <title><?=$razonsocialxx?></title>
  
  <link rel="shortcut icon" href="../../imagenes/<?=$archivo?>" />
  
  <link rel="stylesheet" href="../assets/vendors/mdi/css/materialdesignicons.min.css">
  <link rel="stylesheet" href="../assets/vendors/flag-icon-css/css/flag-icon.min.css">
  <link rel="stylesheet" href="../assets/vendors/css/vendor.bundle.base.css">
  
  
  <link rel="stylesheet" href="../assets/vendors/jquery-bar-rating/css-stars.css" />
  <link rel="stylesheet" href="../assets/vendors/font-awesome/css/font-awesome.min.css" />
  
  
  
  
  <link rel="stylesheet" href="../assets/css/demo_1/style.css" />

</head>
<body>
  <div class="container-scroller">
    
    <?php
    include 'menu.php';
    
    ?>
    
    <div class="container-fluid page-body-wrapper">

<?php
      include 'nav.php';

$categoriax= isset($_GET['categoria']) ? $_GET['categoria'] : '' ;
      $tipox= isset($_GET['tipo']) ? $_GET['tipo'] : '' ;
      $statusx= isset($_GET['status']) ? $_GET['status'] : '' ;
      $desde= isset($_GET['desde']) ? $_GET['desde'] : '' ;
      $hasta= isset($_GET['hasta']) ? $_GET['hasta'] : '' ;

//if($desde=='')$desde=$hasta=$fes;
      if($statusx=='1')$sw1='selected';
      if($statusx=='2')$sw2='selected'; 
$idXy=0;
if($categoriax=='' and $tipox=='' and $statusx=='' and $desde=='' and $hasta=='') $sql=$conex->query ("SELECT `id` FROM inmueble where 1 order by id desc limit 300") or die(mysqli_error());

if($categoriax=='' and $tipox=='' and $statusx=='' and $desde!='' and $hasta!='') $sql=$conex->query ("SELECT `id` FROM inmueble where (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());

if($categoriax!='' and $tipox=='' and $statusx=='') $sql=$conex->query ("SELECT `id` FROM inmueble where cpcategoria='$categoriax' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox!='' and $statusx=='') $sql=$conex->query ("SELECT `id` FROM inmueble where cptipo='$tipox' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox=='' and $statusx!='') $sql=$conex->query ("SELECT `id` FROM inmueble where status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox!='' and $statusx=='') $sql=$conex->query ("SELECT `id` FROM inmueble where cpcategoria='$categoriax' and cptipo='$tipox' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox=='' and $statusx!='') $sql=$conex->query ("SELECT `id` FROM inmueble where cpcategoria='$categoriax' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox!='' and $statusx!='') $sql=$conex->query ("SELECT `id` FROM inmueble where cptipo='$tipox' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox!='' and $statusx!='') $sql=$conex->query ("SELECT `id` FROM inmueble where cpcategoria='$categoriax' and cptipo='$tipox' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());             
             if($row_cnt = $sql->num_rows>0) {       
              while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                $idXy++;
                }
                      }
                
      ?>
      
      <div class="main-panel">
        <div class="content-wrapper">

<h2> <i class="mdi mdi-home-variant"></i> Estate: <?=$idXy?></h2> </div>

<div class="col-md-2"> <a href="tipoinmueble"  id="bt"  class="btn btn-success" > <i class="mdi mdi-plus"></i> &nbsp;&nbsp;Property</a> </div>                        
                     </div>

<div class="col-md-2">
                          <div class="form-group row">
                            <label class="col-sm-12 col-form-label">Category</label>
                            <div class="col-sm-12">
                             <select class="form-control" id="exampleFormControlSelect1"  name="categoria" >
                              <option value="" >Select Category</option>
                              <?php

$sqls=$conex->query ("SELECT * FROM categoria WHERE 1 ") or die(mysqli_error());   
                              if($row_cnt = $sqls->num_rows>0) {       
                                while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
                                 $id = $rows["id"]; 
                                 $categoria = $rows["nombreen"];   
                                 $sx='';
                                 if($categoriax==$id) $sx='selected';
                                 echo "<option value='$id' $sx>$categoria</option> ";                               
                               }
                             }

?>                      
                           </select>
                         </div>
                       </div>
                     </div>

<div class="col-md-2">
                          <div class="form-group row">
                            <label class="col-sm-12 col-form-label">Type</label>
                            <div class="col-sm-12">
                             <select class="form-control" id="exampleFormControlSelect1"  name="tipo" >
                              <option value="" >Select Type</option>
                              <?php

$sqls=$conex->query ("SELECT * FROM tipo WHERE 1 ") or die(mysqli_error());   
                              if($row_cnt = $sqls->num_rows>0) {       
                                while ($rows = $sqls->fetch_array(MYSQLI_ASSOC) ) { 
                                 $id = $rows["id"]; 
                                 $tipo = $rows["nombreen"];   
                                 $sx='';
                                 if($tipox==$id) $sx='selected';
                                 echo "<option value='$id' $sx>$tipo</option> ";                               
                               }
                             }

?>                      
                           </select>
                         </div>
                       </div>
                     </div>

<div class="col-md-2">
                      <div class="form-group row">
                        <label class="col-sm-12 col-form-label">Status</label>
                        <div class="col-sm-12">
                          <select class="form-control" name="status" id="status">
                           <option value="" >Seleccionar Status</option>
                           <option value="1" <?=$sw1?> >Enabled</option>
                           <option value="2" <?=$sw2?> >Disabled</option>

</select>
                       </div>
                     </div>
                   </div>

<div class="col-md-2"   >
                    <div class="form-group row">
                      <label class="col-sm-12 col-form-label">Until</label>
                      <div class="col-sm-12" >
                        <input type="date" class="form-control" name="hasta" id="hasta" value="<?=$hasta?>">
                      </div>
                    </div>
                  </div>

<div class="col-md-2"   >
                    <div class="form-group row">
                      <label class="col-sm-12 col-form-label"></label>
                      <div class="col-sm-12" >
                        <button type="submit" class="btn btn-success" >Search</button>
                      </div>
                    </div>
                  </div>

</div>
          </form>
          <div class="row">

<tbody>

<?php 
             $idX=0;

if($categoriax=='' and $tipox=='' and $statusx=='' and $desde=='' and $hasta=='') $sql=$conex->query ("SELECT * FROM inmueble where 1 order by id desc limit 300") or die(mysqli_error());

if($categoriax=='' and $tipox=='' and $statusx=='' and $desde!='' and $hasta!='') $sql=$conex->query ("SELECT * FROM inmueble where (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());

if($categoriax!='' and $tipox=='' and $statusx=='') $sql=$conex->query ("SELECT * FROM inmueble where cpcategoria='$categoriax' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox!='' and $statusx=='') $sql=$conex->query ("SELECT * FROM inmueble where cptipo='$tipox' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox=='' and $statusx!='') $sql=$conex->query ("SELECT * FROM inmueble where status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox!='' and $statusx=='') $sql=$conex->query ("SELECT * FROM inmueble where cpcategoria='$categoriax' and cptipo='$tipox' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox=='' and $statusx!='') $sql=$conex->query ("SELECT * FROM inmueble where cpcategoria='$categoriax' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax=='' and $tipox!='' and $statusx!='') $sql=$conex->query ("SELECT * FROM inmueble where cptipo='$tipox' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
if($categoriax!='' and $tipox!='' and $statusx!='') $sql=$conex->query ("SELECT * FROM inmueble where cpcategoria='$categoriax' and cptipo='$tipox' and status='$statusx' and (fecha BETWEEN '$desde' AND '$hasta')") or die(mysqli_error());
             
             if($row_cnt = $sql->num_rows>0) {       
              while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) { 
                $idX++;
                $id=$row{'id'}; 
                $cptitulopublicacion=$row{'cptitulopublicacion'};  
                $imagenprincipal=$row{'imagenprincipal'};  
                $status=$row{'status'};
                $cptipo=$row{'cptipo'};  
                $cpcategoria=$row{'cpcategoria'};
                $cpprecio=$row{'cpprecio'};
                $cpagente=$row{'cpagente'};
                $fecha=$row{'fecha'};

$cptitulopublicacion = substr($cptitulopublicacion, 0,38);

$tipo='';
                $sqlx=$conex->query ("SELECT * FROM tipo where id='$cptipo' ") or die(mysqli_error());
                if($row_cnt = $sqlx->num_rows>0) {       
                  while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                    $tipo=$rowx{'nombreen'};
                  }
                }

$categoria='';
                $sqlx=$conex->query ("SELECT * FROM categoria where id='$cpcategoria' ") or die(mysqli_error());
                if($row_cnt = $sqlx->num_rows>0) {       
                  while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                    $categoria=$rowx{'nombreen'};
                  }
                }

$nagente='';
                $aagente='';
                $fagente='';
                $nombreagente='';
                $sqlx=$conex->query ("SELECT * FROM agente where id='$cpagente' ") or die(mysqli_error());
                if($row_cnt = $sqlx->num_rows>0) {       
                  while ($rowx = $sqlx->fetch_array(MYSQLI_ASSOC) ) { 
                    $nagente=$rowx{'nombre'};
                    $aagente=$rowx{'apellido'};
                    $fagente=$rowx{'foto'};
                    $nombreagente=$nagente.' '.$aagente;
                  }
                }

$ss='';
                if($status=='1'){ 
                  $status='Habilitado';
                  $ss='badge badge-success';
                }
                if($status=='2'){
                  $status='Deshabilitado';
                  $ss='badge badge-danger';
                }

$url='';
                if($cpcategoria=='1')$url='apartamento';
                if($cpcategoria=='2')$url='casas';
                if($cpcategoria=='3')$url='locales';
                if($cpcategoria=='4')$url='oficinas';
                if($cpcategoria=='5')$url='galpones';
                if($cpcategoria=='6')$url='townhouses';
                if($cpcategoria=='7')$url='terrenos';
                if($cpcategoria=='8')$url='edificios';
                if($cpcategoria=='9')$url='negocios';
                if($cpcategoria=='10')$url='haciendas';
                if($cpcategoria=='11')$url='hoteles';
                if($cpcategoria=='12')$url='anexos';
                if($cpcategoria=='13')$url='habitaciones';
                if($cpcategoria=='14')$url='cementerios';

echo '

<label class="'.$ss.'">'.$status.'</label>
                </div>
                <h4 class="font-weight-semibold"> '.$cptitulopublicacion.' </h4>
                <h5 class="font-weight-semibold"> '.$categoria.' </h5>
                <div class="d-flex justify-content-between font-weight-semibold">
                <p class="mb-0">Type: '.$tipo.' </p>
                <p class="mb-0"><b>Price: '.number_format($cpprecio).'$</b></p>
                </div>
                </div>
                </div>
                </div>

}
            }

</div>
        </div>

</div>
      
    </div>
    
  </div>
  
  
  <script src="../assets/vendors/js/vendor.bundle.base.js"></script>
  
  
  
  
  <script src="../assets/js/off-canvas.js"></script>
  <script src="../assets/js/hoverable-collapse.js"></script>
  <script src="../assets/js/misc.js"></script>
  <script src="../assets/js/settings.js"></script>
  <script src="../assets/js/todolist.js"></script>
  
  
  
</body>
</html>

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team