search.php

<?php include_once 'header.php';?>

<seccion>
  <div class="container">
     <div class="space-40 clearfix"></div> 
     <div class="space-20"></div>
	<h1 class="text-uppercase text-center"><b>PEsquisa</b></h1>
	<hr>
	<div class="space-40"></div>
    <!-- div da esquerda notícias-->
    <div CLASS="col-lg-12 col-md-12 col-sm-12 col-xs-12 bg-branco">
    <div class="row">
      <?php 
		$con_db = new config\connect_db();
		$con = $con_db->connect();  
      
      
      if( empty($_GET['pag']) or !isset($_GET['page']))      {
        $pag = '0';
      }
      else{
        $pag = filter_var($_GET['pag'], FILTER_SANITIZE_NUMBER_INT);
      }
      
      if(empty($_GET['limite']) == true or !isset($_GET['limite'])){
        $limite = '25';
      }
      else if ($_GET['limite'] == 'all'){
        $inicio = 0;
        $limite = 99999;
      }
      else{
        $limite = filter_var($_GET['limite'], FILTER_SANITIZE_NUMBER_INT);
      }
      
      if ($pag and $pag != ''){
        $inicio = ($pag - 1) * $limite;
      }
      else{
        $inicio = 0;
      }
            
      if( empty($_GET['search']) or !isset($_GET['search'])){
        $where = '';
        $search = '';
      }
      else{
        $search = filter_var($_GET['search'], FILTER_SANITIZE_SPECIAL_CHARS);
        $where = "WHERE MATCH(`situation`, `finality`, `ref`, `segment`, `type`, `address_state`, `address_city`, `address_street`, `address_number`, `address_neighborhood`) AGAINST ('$search' IN BOOLEAN MODE) LIMIT $inicio, $limite " ; 
      }
     
      // alterar aqui depois que tiver bstante noticias
      $properties = $con->query("SELECT * FROM `properties` $where ") or die (mysqli_error($con));
      
$rows = $properties->num_rows;

if( $properties and $rows > 0){

    $item = '';
    $item .= '<div class="container">';
    $item .= '<div class="row">';

    while( $reg = $properties->fetch_assoc() ){

        $cover_image = (!empty($reg['cover_image'])) ? SUBDOMAIN_IMGS.'/docs/properties/'.$reg['id'].'/small/'.$reg['cover_image'] : '/app/images/no-image.png' ;

        if($reg['finality'] === 'venda-aluguel'){
            $finality = 'venda ou aluguel';

            if($reg['hidden_value_total'] === 'Y' and !empty( $reg['value_total'])){
                $venda = '<p>Venda:<strong class="text-iguacu"> R$ '.decimalMoeda( $reg['value_total']).' </strong> - <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_total'] === 'Y' and empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> Não informado </strong> - <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_total'] === 'N' and !empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> R$ '.decimalMoeda( $reg['value_total']).' </strong></p>';
            }
            else if($reg['hidden_value_total'] === 'N' and empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> Não informado </strong></p>';
            }
            else
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> Indefinido </strong></p>';
            }

            if($reg['hidden_value_monthly'] === 'Y' and !empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> R$ '.decimalMoeda($reg['value_monthly']).' </strong> - <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_monthly'] === 'Y' and empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> Não informado </strong> - <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_monthly'] === 'N' and !empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> R$ '.decimalMoeda($reg['value_monthly']).' </strong></p>';
            }
            else if($reg['hidden_value_monthly'] === 'N' and empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> Não informado </strong></p>';
            }
            else
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> Indefinido </strong></p>';
            }

        }
        else if( $reg['finality'] === 'venda' )
        {
            $finality = 'venda';
            if($reg['hidden_value_total'] == 'Y' and !empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> R$ '.decimalMoeda( $reg['value_total']).' </strong> - <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_total'] == 'Y' and empty( $reg['value_total']))
            {
                $venda = '<p>Venda: <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_total'] == 'N' and !empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> R$ '.decimalMoeda( $reg['value_total']).' </strong></p>';
            }
            else if($reg['hidden_value_total'] == 'N' and empty( $reg['value_total']))
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> Não informado </strong></p>';
            }
            else
            {
                $venda = '<p>Venda:<strong class="text-iguacu"> Indefinido </strong></p>';
            }

            $aluguel = '';
        }
        else if( $reg['finality'] === 'aluguel' or $reg['finality'] === 'temporada' or $reg['finality'] === 'arrendamento')
        {
            $finality = 'aluguel';
            if($reg['hidden_value_monthly'] == 'Y' and !empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> R$ '.decimalMoeda($reg['value_monthly']).' </strong> - Sob consulta</p>';
            }
            else if($reg['hidden_value_monthly'] == 'Y' and empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:  <small>Sob consulta</small></p>';
            }
            else if($reg['hidden_value_monthly'] == 'N' and !empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> R$ '.decimalMoeda($reg['value_monthly']).' </strong></p>';
            }
            else if($reg['hidden_value_monthly'] == 'N' and empty($reg['value_monthly']))
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> Não informado </strong></p>';
            }
            else
            {
                $aluguel = '<p>Aluguel:<strong class="text-iguacu"> Indefinido </strong></p>';
            }

            $venda = '';

        }
        else
        {
            $finality = $reg['finality'];
            $venda = '<p>Indefinido</p>';
            $aluguel = '<p>Indefinido</p>';
        }

        
        //---------------------------

        $status = ( !empty($reg['status']) ) ? '<span class="sale-status text-capitalize">'.$reg['status'].'</span>' : '';

        $item .= '<div class="col-md-4 col-sm-6 col-xs-12" data-control="elem-filter">';
		$item .= '<a href="view_properties/'.base64_encode($reg['id']).'">';
        $item .= '<div class="card sr-icons animated zoomIn">';
        $item .= $status;
        $item .= '<div class="card-image" data-background="'.$cover_image.'" style="background-image: url(/app/images/load.gif);">';
		$item .= '<div class="card-for">';
		$item .= $finality;
		$item .= '</div>';
        $item .= '</div>';		
        $item .= '<div class="card-content card-properties text-canzi">';
		$item .= '<h4 class="text-iguacu text-capitalize"><b>'.$reg['type'].' para '.$finality.'</b></h4>';
        $item .= '<p class="text-darkgray text-uppercase">'.$reg['segment'].'</p>';
        $item .= $venda;
        $item .= $aluguel;
		$item .= '<p class="text-darkgray"><b><i class="fa fa-map-marker" style="color: #ED3237 !important; margin-right: 10px;"></i> '.$reg['address_street'].', '.$reg['address_number'].','.$reg['address_neighborhood'].', '.$reg['address_city'].'-'.$reg['address_state'].'</b></p>';
		$item .= '<p><b>Ref.:</b> '.$reg['ref'].'</p>';
        $item .= '</div>';       
        $item .= '</div>';
		$item .= '</a>';
        $item .= '</div><!-- //. Card item -->';

    }// end while

    $item .= '</div>';
    $item .= '</section>';
    
    echo $item;

}
else
{
  echo('<div class="alert alert-danger" role="alert">Não encontramos nenhum registro para <b>'.$search.'.</b> Tente outra pesquisa.</div>');
    
}
      
   ?>
				</div> <!-- div da esquerda notícias--> 
			</div>
		</div>
	</div>
</section>
<?php include_once 'footer.php';?>
<!--****************************************************************** -->
</body>
</html>