title = "Cenník kobky"
url = "/cennik5"
layout = "default"
is_hidden = 0
==
<?php
use Creas\Realestate\Models\Flat as Flat;
use Creas\Realestate\Models\Floor;

function onStart()
{
	$floors = Flat::leftJoin('creas_realestate_floors', function ($join) {
        $join->on('creas_realestate_flats.floor_id', '=', 'creas_realestate_floors.id')
            ->where('creas_realestate_flats.type','=',5);
            
    })->groupBy('creas_realestate_floors.id');

   
    
    $flats = Flat::with('floors')
                 ->where('type',5); 
                
    $this['flats'] = $flats->get();
  
    $this['floors'] = $floors->get();

}


function onFilterChange() 
{
    
    $floor_id = input('floor_id');
    $status = input('status');
    $price = input('price');
    
    $flats = Flat::with('floors')
                 ->where('type',5);  
    
    if($floor_id) {
        $flats->where('floor_id', $floor_id);
    }
    if($status) {
       $flats->where('status', $status );  
    }
    if($price == 1) {
       $flats->where('status', '<', '3')->orderBy('price', 'asc' );  
    } elseif ($price == 2) {
       $flats->where('status', '<', '3')->orderBy('price', 'desc' );      
    }
        
    $this['flats'] = $flats->get();    
}
?>
==
<section id="cennik">
    <div class="container">
    <div class="row">
    
        <div class="col-md-2 text-center"><a class="animated bounceIn one" href="/cennik"><strong>BYTY</strong></a> </div>
          <div class="col-md-2 text-center"><a class="animated bounceIn two" href="/cennik2"><strong>OBCHODY</strong></a> </div>
          <div class="col-md-2 text-center"><a class="animated bounceIn three" href="/cennik4"><strong>PRÉMIUM</strong></a> </div>
          <div class="col-md-2 text-center"><a class="animated bounceIn four" href="/cennik3"><strong>PARKOVANIE</strong></a> </div>
          <div class="col-md-2 text-center"><a class="active animated bounceIn five" href="/cennik5"><strong>KOBKY</strong></a> </div>
    
    </div>
    </div>
    
    <p>&nbsp;</p>

    <div class="navbar ">
      <div class="container">
      
      <form id="form" class="z-depth-1" data-request="onFilterChange" data-request-update="tablekob: '#tbody'">
        <ul id="filterkob" class="nav navbar-nav navbar-default">
        
          <li><a href="">označenie</a></li>
          <li>
          <select class="form-control" placeholder="Poschodie" id="floor_id" name="floor_id" onchange="$('#form').trigger('submit')">
            {% partial "floor-kobka" %}
          </select>
          </li>
          <li><a href="">popis</a></li>
          <li><a href="">výmera</a></li>
          <li><a href="">cena s DPH</a></li>
          <li>
          <select class="form-control" id="status" name="status" onchange="$('#form').trigger('submit')">
              <option value="">Status</option>
              <option value="1">Voľný</option>
              <option value="2">Rezervovaný</option>
              <option value="3">Predaný</option>
              <option value="9">Pripravujeme</option>
            </select>
          </li>
          </ul>
        </form>
        
      </div>
    </div>
    <div class="clearfix"></div>
    <div id="unseenkob" class="container">
    <table class="table table-hover">
      <thead>
        <tr>
          <th>označenie</th>
          <th>podlažie</th>
          <th>popis</th>
          <th>výmera v m<sup>2</sup></th>
          <th>cena s DPH</th>
          <th>dostupnosť</th>
        </tr>
      </thead>
      <tbody id="tbody">
         
         {% partial "tablekob" %}
         
      </tbody>
      </table>
      
      <p>&nbsp;</p>
      <p>&nbsp;</p> 
      
  </div>
</section>