Revize d58f0fda
Přidáno uživatelem Cajova-Houba před téměř 7 roky(ů)
backend/app/Model/Zarizeni.php | ||
---|---|---|
34 | 34 |
return DB::table('zarizeni') |
35 | 35 |
->join('ulice', 'zarizeni.ulice_id', '=', 'ulice.id') |
36 | 36 |
->join('mesto', 'ulice.mesto_id', '=', 'mesto.id') |
37 |
->select('zarizeni.*', 'ulice.nazev as ulice_nazev', 'ulice.id as ulice_id', 'mesto.nazev as mesto_nazev', 'mesto.id as mesto_id')
|
|
37 |
->select('zarizeni.id as id', 'zarizeni.smer_popis as name', 'ulice.nazev as street', 'ulice.id as street_id', 'mesto.nazev as town', 'mesto.id as town_id')
|
|
38 | 38 |
->get(); |
39 | 39 |
} |
40 | 40 |
|
... | ... | |
50 | 50 |
return DB::table('zarizeni') |
51 | 51 |
->join('ulice', 'zarizeni.ulice_id', '=', 'ulice.id') |
52 | 52 |
->join('mesto', 'ulice.mesto_id', '=', 'mesto.id') |
53 |
->select('zarizeni.*', 'ulice.nazev as ulice_nazev', 'ulice.id as ulice_id', 'mesto.nazev as mesto_nazev', 'mesto.id as mesto_id')
|
|
53 |
->select('zarizeni.id as id', 'zarizeni.smer_popis as name', 'ulice.nazev as street', 'ulice.id as street_id', 'mesto.nazev as town', 'mesto.id as town_id')
|
|
54 | 54 |
->where('ulice.nazev', '=', $street) |
55 | 55 |
->where('mesto.nazev', '=', $town) |
56 | 56 |
->get(); |
... | ... | |
67 | 67 |
return DB::table('zarizeni') |
68 | 68 |
->join('ulice', 'zarizeni.ulice_id', '=', 'ulice.id') |
69 | 69 |
->join('mesto', 'ulice.mesto_id', '=', 'mesto.id') |
70 |
->select('zarizeni.*', 'ulice.nazev as ulice_nazev', 'ulice.id as ulice_id', 'mesto.nazev as mesto_nazev', 'mesto.id as mesto_id')
|
|
70 |
->select('zarizeni.id as id', 'zarizeni.smer_popis as name', 'ulice.nazev as street', 'ulice.id as street_id', 'mesto.nazev as town', 'mesto.id as town_id')
|
|
71 | 71 |
->where('zarizeni.id', '=', $id) |
72 |
->orderBy('zarizeni.id') |
|
72 | 73 |
->get(); |
73 | 74 |
} |
74 | 75 |
|
Také k dispozici: Unified diff
#6638: Prejmenovana tabulka vozidla na vozidlo. Pridana zbyla implementace rest api. Pridany zbyle modely.