Projekt

Obecné

Profil

« Předchozí | Další » 

Revize d3462f57

Přidáno uživatelem Cajova-Houba před téměř 7 roky(ů)

refs #6846: Pridany sloupce s geosouradnicemi do tabulky ulice. Pole se souradnicemi pridany do select klausule v prislusnych query.

Zobrazit rozdíly:

backend/app/Model/Zarizeni.php
38 38 
                'zarizeni.smer_popis as name',
39 39 
                'ulice.nazev as street',
40 40 
                'ulice.id as street_id',
41 
                'ulice.lat as lat',
42 
                'ulice.lng as lng',
41 43 
                'mesto.nazev as town',
42 44 
                'mesto.id as town_id')
43 45 
            ->get();
......
58 60 
                'zarizeni.smer_popis as name',
59 61 
                'ulice.nazev as street',
60 62 
                'ulice.id as street_id',
63 
                'ulice.lat as lat',
64 
                'ulice.lng as lng',
61 65 
                'mesto.nazev as town',
62 66 
                'mesto.id as town_id')
63 67 
            ->where('ulice.nazev', 'like', '%'.$address.'%')
......
86 90 
                'zarizeni.smer_popis as name',
87 91 
                'ulice.nazev as street',
88 92 
                'ulice.id as street_id',
93 
                'ulice.lat as lat',
94 
                'ulice.lng as lng',
89 95 
                'mesto.nazev as town',
90 96 
                'mesto.id as town_id')
91 97 
            ->where('zarizeni.id', '=', $id)
db/v4__geosouradnice.sql
1 
-- skript prida sloupecky pro geosouradnice do tabulky ulice
2 
alter table `prujezd_vozidel`.`ulice` add column `lng` double not null;
3 
alter table `prujezd_vozidel`.`ulice` add column `lat` double not null;

Také k dispozici: Unified diff