| | 1 | = Регистрација на корисник |
| | 2 | |
| | 3 | ==== Објанување: |
| | 4 | |
| | 5 | Секој корисник кога ќе создаде профил на апликацијата се подразбира дека е патник и затоа му се доделува улогата Патник. Потоа администраторите можат да додадат или одземат улоги: Кондуктер, Возач или Админ. |
| | 6 | |
| | 7 | === Регистрација: |
| | 8 | |
| | 9 | -- slika za register |
| | 10 | |
| | 11 | {{{#!div style="font-size: 80%" |
| | 12 | {{{#!sql |
| | 13 | |
| | 14 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon from public.korisnik k1_0 where k1_0.email=? |
| | 15 | Hibernate: select r1_0.id,r1_0.description,r1_0.name from public.role r1_0 where upper(r1_0.name) like upper(?) escape '\' |
| | 16 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon,r1_0.korisnik_id,r1_0.id,r2_0.id,r2_0.description,r2_0.name from public.korisnik k1_0 left join public.korisnik_role r1_0 on k1_0.id=r1_0.korisnik_id left join public.role r2_0 on r2_0.id=r1_0.role_id where k1_0.id=? |
| | 17 | Hibernate: update public.korisnik set is_admin=?,adresa=?,email=?,ime=?,lozinka=?,telefon=? where id=? |
| | 18 | Hibernate: insert into public.patnik (korisnik_id) values (?) returning id |
| | 19 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon from public.korisnik k1_0 where k1_0.email=? |
| | 20 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon from public.korisnik k1_0 where k1_0.email=? |
| | 21 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon from public.korisnik k1_0 where k1_0.email=? |
| | 22 | Hibernate: select r1_0.korisnik_id,r1_0.id,r2_0.id,r2_0.description,r2_0.name from public.korisnik_role r1_0 left join public.role r2_0 on r2_0.id=r1_0.role_id where r1_0.korisnik_id=? |
| | 23 | Hibernate: select k1_0.id,k1_0.is_admin,k1_0.adresa,k1_0.email,k1_0.ime,k1_0.lozinka,k1_0.telefon from public.korisnik k1_0 where k1_0.email=? |
| | 24 | Hibernate: select r1_0.korisnik_id,r1_0.id,r2_0.id,r2_0.description,r2_0.name from public.korisnik_role r1_0 left join public.role r2_0 on r2_0.id=r1_0.role_id where r1_0.korisnik_id=? |
| | 25 | }}} |
| | 26 | }}} |
| | 27 | |
| | 28 | --- slika od admin panel so users i roles |