title = "Cenník bytov"
url = "/cennik"
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',1);
                
    $this['flats'] = $flats->get();
  
    $this['floors'] = Floor::get();
    
    $this['blocks'] = Floor::groupBy('block')->lists('block');
 
}


function onFilterChange() 
{
    
    $floor_id = input('floor_id');
    $status = input('status');
    $area = input('area');
    $rooms = input('rooms');
    $price = input('price');

    switch($area) {
        case '50' :
          $from = 1;
          $to = 50;
          break;

        case '70' :
          $from = 50;
          $to = 70;
          break;
    
        case '71' :
          $from = 71;
          $to = 200;
          break;
    }

    if(input('block')) {
    $flats = Flat::with('floors')
                 ->where('type',1)
                 ->whereHas('floors', function ($query) {
                    $query->where('block', '=', input('block'));
                 });
    } else {
    $flats = Flat::with('floors')
                 ->where('type',1);    
    }
    if($floor_id) {
        $flats->where('floor_id', $floor_id);
    }
    if($area) {
       $flats->whereBetween('area', [$from, $to]);  
    }
    if($rooms) {
       $flats->where('rooms', $rooms );  
    }
    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['blocks'] = Floor::groupBy('block')->lists('block');
    
    $this['flats'] = $flats->get();
    
}

function onFloorChange()
{
  $flats = Flat::with('floors')
                 ->where('type',1)
                 ->whereHas('floors', function ($query) {
                    $query->where('block', '=', input('block'));
                 });
  $this['flats'] = $flats->get();
  
  $this['blocks'] = Floor::groupBy('block')->lists('block');
    
  $floors = Floor::where('block', input('block'));
  $this['floors'] = $floors->get();  
}
?>
==
<div id="block_view" class="">
<form id="floor-form" data-request="onFloorChange" data-request-data="block: $('.rect-active').attr('value')" data-request-update="table: '#tbody', floor:'#floor_id' ">
    <div class="block-b animated fadeIn seven">
        <div class="block-title"> Blok B</div>
       <svg width="90" height="30">
          <rect id="b-block" class="rect-view"  value="B" width="90" height="30" fill="#c2bebd" onclick=" $('#a-block').removeClass('rect-active'); $('#floor_id').removeAttr('disabled'); $('#block').val('B');  $('#b-block').addClass('rect-active'); $('#floor-form').trigger('submit');"/>
        </svg>
    </div>
    <div class="block-a animated fadeIn eight">
         <div class="block-title"> Blok A</div>
        <svg width="45" height="100">
          <rect  id="a-block" class="rect-view" value="A" width="45" height="100" fill="#c2bebd" onclick=" $('#b-block').removeClass('rect-active'); $('#floor_id').removeAttr('disabled');  $('#block').val('A');  $('#a-block').addClass('rect-active'); $('#floor-form').trigger('submit');"/>
        </svg>
    </div>
</form>
</div>
<section id="cennik">
    <div class="container">
      <div class="row">
      
          <div class="col-md-2 text-center"><a class="active 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="animated bounceIn five" href="/cennik5"><strong>KOBKY</strong></a> </div>
      
      </div>
    </div>
    
    <p>&nbsp;</p>

    <div class="navbar animated fadeIn six">
      <div class="container">
      <form id="form" class="z-depth-1" data-request="onFilterChange" data-request-update="table: '#tbody', floor:'#floor'">
        <ul id="filter" class="nav navbar-nav navbar-default">       
          <li>
             <select class="form-control" id="block" name="block" data-request="onFloorChange" data-request-update="table: '#tbody', floor:'#floor_id'">
                  {% partial "block" %}
            </select>
          </li>
          <li>
            <select  disabled class="form-control" id="floor_id" name="floor_id" onchange="$('#form').trigger('submit')">
               {% partial "floor" %}
            </select>
          </li>
          <li>
            <select class="form-control"  id="rooms" name="rooms" onchange="$('#form').trigger('submit')">
              <option value="">Miestnosti</option>
              <option value="1">1 izba</option>
              <option value="2">2 izby</option>
              <option value="3">3 izby</option>
              <option value="4">4 izby</option>
            </select>
          <li>
             <select class="form-control"  id="area" name="area" onchange="$('#form').trigger('submit')">
              <option value="">Rozloha</option>
              <option value="50">do 50m<sup>2</sup></option>
              <option value="70">do 70m<sup>2</sup></option>
              <option value="71">viac než 70m<sup>2</sup></option>
            </select>
          </li>

          <li><a href="">Balkón/terasa</a></li>
          <li>
            <select  class="form-control" id="price" name="price" onchange="$('#form').trigger('submit')">
              <option value="">Podľa ceny</option>
              <option value="1">Najlacnejšie</option>
              <option value="2">Najdrahšie</option>
            </select>
          </li>
          <li><a title="Akciová cena s DPH pri financovaní 10/40/40/10" href="">Akciová cena *</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="unseen" class="container">
    <table class="table table-hover">
      <thead>
        <tr>
          <th>číslo bytu</th>
          <th>podlažie</th>
          <th>počet izieb</th>
          <th>výmera v m<sup>2</sup></th>
          <th>balkón / terasa v m<sup>2</sup></th>
          <th>spolu v m<sup>2</sup></th>
          <th>cena s DPH</th>
          <th>akciová cena</th>
          <th>dostupnosť</th>
        </tr>
      </thead>
      <tbody id="tbody">
         {% partial "table" %}
      </tbody>
      </table>
      
      <p>&nbsp;</p>
      <p>* Akciová cena s DPH pri financovaní 10/40/40/10</p>
      <p>&nbsp;</p> 
      
  </div>
</section>