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

function onStart()
{
	$this['flats'] = Flat::join('creas_realestate_floors', function ($join) {
        $join->on('creas_realestate_flats.floor_id', '=', 'creas_realestate_floors.id')
            ->where('creas_realestate_flats.type','=',2);
    })
    ->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="active 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 ">
      <div class="container">
        <ul id="filterop" class="nav navbar-nav navbar-default z-depth-1">
        
          <li><a href="">označenie</a></li>
          <li><a href="">podlažie</a></li>
          <li><a href="">popis</a></li>
          <li><a href="">výmera</a></li>
          <li><a href="">cena s DPH</a></li>
          <li><a href="">dostupnosť</a></li>
          
        </ul>
      </div>
    </div>
    <div class="clearfix"></div>
    <div id="unseenop" class="container">
    <table class="table table-hover">
      <thead>
        <tr>
          <th>číslo bytu</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>
         {% for flat in flats %}
            <tr {% if flat.status == 3 %} class="danger" {% elseif flat.status == 2 %} class="warning" {% elseif flat.status == 9 %} class="greytext" {% endif %} >
              <td><a target="_blank" href="/storage/app/media/pdf/OP_1NP.pdf">{{ flat.name }}</a></td>
              <td><a href="/poschodie/{{ flat.floor_id }}">{{ flat.descr }}</a></td>
              <td>{{ flat.desc }}</td>
              <td>{{ flat.area|number_format(2,',',' ') }} m<sup>2</sup></td>
              <td>{% if flat.status == 3 %} - {% elseif flat.status == 9 %} - {% else %}{{ flat.price|number_format(0,',',' ') }} €{% endif %}</td>
              <td>{% if flat.status == 1 %} volný {% elseif flat.status == 2 %} rezervovaný {% elseif flat.status == 3 %} predaný {% elseif flat.status == 9 %} pripravujeme {% endif %}</td>
            </tr>
         {% endfor %}
      </tbody>
      </table>
      
      <p>&nbsp;</p>
      <p>&nbsp;</p> 
      
  </div>
</section>