Projekt

Obecné

Profil

« Předchozí | Další » 

Revize d58f0fda

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

#6638: Prejmenovana tabulka vozidla na vozidlo. Pridana zbyla implementace rest api. Pridany zbyle modely.

Zobrazit rozdíly:

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