Changes between Version 9 and Version 10 of UseCase216049

Timestamp:

12/27/23 23:21:52 (9 months ago)

Author:

216049

Comment:

--

UseCase216049

@@ -8 +8 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-insert into Lugje(l_ime, l_prezime, l_email, l_adresa, l_telefon, l_is_admin, l_lozinka)
-values ('Test', 'Test', 'test@test.com', 'test adresa 1', '070111222', false, 'tt');
+insert into Korisnik (k_ime, k_adresa, k_telefon, k_email, k_embg, k_is_admin, k_lozinka)
+values ('Test', 'test adresa 1', '070010202', 'test@test.com', '1010002450050', false, 'tt');
 
-insert into Patnik(l_id);
-  }}}
-}}}
-
-{{{#!div style="font-size: 80%"
-  {{{#!sql
-insert into Dokument(d_broj_na_dok, d_koj_go_izdal, d_datum_izd, d_datum_ist, l_id)
-values ('A012345', 'MVR test', '2022-12-12', '2027-12-11', 5);
+insert into Patnik(k_id);
   }}}
 }}}
 
 [[Image(registracija_216049.png)]]
-
-
-[[Image(dokumenti_216049.png)]]
 
 
@@ -33 +23 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-select l_id from project.Lugje where l_email = 'test@test.com' and l_lozinka = 'tt';
+select k_id from project.Korisnik where k_email = 'test@test.com' and k_lozinka = 'tt';
   }}}
 }}}
@@ -43 +33 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-select tb_ime from KategorijaNaBilet
+select tb_ime from TipBilet
   }}}
 }}}
@@ -50 +40 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-insert into Bilet(l_id, tb_id, b_datum_kupuvanje)
-values (5, 1, now());
+insert into Bilet (b_datum_na_kupuvanje, b_status, patnik_k_id, tb_id)
+values (now(), 'INACTIVE', 5, 1);
   }}}
 }}}
@@ -63 +53 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
+
 select b_id 
 from project.bilet b 
-join project.kategorijanabilet kb on kb.tb_id = b.tb_id
-where b.patnik_l_id  = 1 and now() between b.b_datum_na_kupuvanje and (b.b_datum_na_kupuvanje + ((kb.tb_trajnost||' minutes')::interval))
+join project.tipbilet tb on tb.tb_id = b.tb_id
+where b.patnik_k_id  = 5 and b.b_status in ('ACTIVE', 'INACTIVE')
+
   }}}
 }}}
@@ -72 +64 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-insert into Vozenje(vozenje_start, patnik_l_id, kacuva_pnl_id, dr_id, b_id)
-values (now(), 5, 2, 1, 1);
+
+update project.vozenje 
+set vozenje_status = 'FINISHED'
+where vozenje_id = (select vozenje_id from project.vozenje where patnik_k_id = 5 and vozenje_status = 'ACTIVE')
+
+insert into Vozenje(vozenje_start, vozenje_end, patnik_k_id, kacuva_pnl_id, inl_id, b_id, vozenje_status)
+values ('2023-01-01 12:00:00', null, 5, 2, 1, 6, 'ACTIVE');
+
+update project.bilet
+set b_status = 'ACTIVE'
+where b_id = 6;
 
   }}}
@@ -87 +88 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
+
+vozenje_id = (select vozenje_id from project.vozenje where patnik_k_id = 1 and vozenje_status = 'ACTIVE')
 insert into se_simnuva_na(pnl_id, vozenje_id)
+
+update project.vozenje 
+set vozenje_status = 'FINISHED'
+where vozenje_id = (select vozenje_id from project.vozenje where patnik_k_id = 1 and vozenje_status = 'ACTIVE')
   }}}
 }}}