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

function onStart()
{

    
    $flats = Flat::with('floors')
                 ->where('type',3)
                 ->orderBy('rooms', 'asc')
                 ->orderBy('id', 'asc');
                
    $this['flats'] = $flats->get();
  
  
    $floors = Flat::leftJoin('creas_realestate_floors', function ($join) {
        $join->on('creas_realestate_flats.floor_id', '=', 'creas_realestate_floors.id')
            ->where('creas_realestate_flats.type','=',3);
            
    })->groupBy('creas_realestate_floors.id');
    
    $this['floors'] = $floors->get();
    
}

function onFilterChange() 
{
    
    $floor_id = input('floor_id');
    $status = input('status');
    $price = input('price');
    
    $flats = Flat::with('floors')
                 ->where('type',3);  
    
    if($floor_id) {
        $flats->where('floor_id', $floor_id);
    }
    if($status) {
       $flats->where('status', $status)
            ->orderBy('rooms', 'asc')
            ->orderBy('id', 'asc');  
    }
    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="active animated bounceIn four" href="/cennik3"><strong>PARKOVANIE</strong></a> </div>
          <div class="col-md-2 text-center"><a class="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="tablepark: '#tbody'">
        <ul id="filterpark" class="nav navbar-nav navbar-default">
        
          <li><a href="">Označenie</a></li>
          <li><select class="form-control" id="floor_id" name="floor_id" onchange="$('#form').trigger('submit')">
               {% partial "floor-parking" %}
            </select></li>
          <li><a href="">Popis</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="unseenpark" class="container">
    <table class="table table-hover">
      <thead>
        <tr>
          <th>označenie</th>
          <th>podlažie</th>
          <th>popis</th>
          <th>cena s DPH</th>
          <th>dostupnosť</th>
        </tr>
      </thead>
      <tbody id="tbody">
      
         {% partial "tablepark" %}
         
      </tbody>
      </table>
      
      <p>&nbsp;</p>
      <p>&nbsp;</p> 
      
  </div>
</section>