title = "Bývanie"
url = "/byvanie"
layout = "default"
is_hidden = 0
==
<?php
use Creas\Realestate\Models\Flat as Flat;
use Creas\Realestate\Models\Floor as Floor;

function onStart()
{
    
    $flats =  Db::table('creas_realestate_flats AS flats')
        ->select(Db::raw('floors.floor, floors.id, flats.floor_id, floors.mapping, flats.status, 
        SUM(flats.status = 1) AS volne,
         SUM(flats.status = 2) AS rezervovane,
        SUM(flats.status = 3) AS predane,
         SUM(flats.status = 9) AS pripravujeme
        
        '))
        ->where('flats.type', 1)
        ->leftJoin('creas_realestate_floors AS floors', 'flats.floor_id' , '=', 'floors.id')
        ->groupBy('floor_id')
        ->get();
    
    
   // return $flats;
      $this['floors'] = $flats;
      
     $stores =  Db::table('creas_realestate_flats AS flats')
        ->select(Db::raw('floors.floor, flats.floor_id, floors.id, floors.mapping, flats.status, 
        SUM(flats.status = 1) AS volne,
         SUM(flats.status = 2) AS rezervovane,
        SUM(flats.status = 3) AS predane,
         SUM(flats.status = 9) AS pripravujeme
        
        '))
        ->where('flats.type', 2)
        ->leftJoin('creas_realestate_floors AS floors', 'flats.floor_id' , '=', 'floors.id')
        ->groupBy('floor_id')
        ->get();
    $this['stores'] = $stores;
   
}
?>
==
<section class="lokalita">


    <div class="container">
        <div class="row hidden-xs hidden-sm animated fadeIn budova">
            <img src="/storage/app/media/building/model_ponuka.jpg" id="matadorka" alt="Matadorka" usemap="#map">
            <map name="map">
            {% for floor in stores %}
             
                <area class="floor-building" 
                    shape="poly" 
                    data-title="Prízemie"
                    data-state="{{ floor.id}}"
                {% if floor.status != 9 %}
                     
                    data-free="{{ floor.volne }} obchodných priestorov voľných "
                    data-sold="{{ floor.predane }} obchodných priestorov predaných" 
                    
                {% else %}
                    data-sold="{{ floor.pripravujeme }} bytov pripravujeme" 
                {% endif %}  
                    class="animated fadeIn"
                    coords="{{floor.mapping}}" 
                    href="/byvanie/{{floor.id}}">
                {% endfor %}
                
             {% for floor in floors %}
             
                <area class="floor-building" 
                    shape="poly" 
                    data-title="{{ floor.floor }}. Poschodie" 
                    data-state="{{ floor.id}}"
                {% if floor.status != 9 %}
                     
                    data-free="{{ floor.volne }} bytov voľných "
                    data-sold="{{ floor.predane }} bytov predaných" 
                    
                {% else %}
                    data-sold="{{ floor.pripravujeme }} bytov pripravujeme" 
                {% endif %}  
                    class="animated fadeIn"
                    coords="{{floor.mapping}}" 
                    href="/byvanie/{{floor.id}}">
                {% endfor %}
                
                
               
                
                
            </map>
           
            <div class="building-tooltip">
                
            </div>
        </div>
        <div class="row hidden-md hidden-lg">
            <a href="/cennik"><img class="img-responsive animated fadeIn" src="/storage/app/media/building/model_ponuka.jpg"></a>
        </div>    
    </div>
</section>