Changes between Version 8 and Version 9 of UseCase216049

Timestamp:

12/24/23 14:33:06 (11 months ago)

Author:

216049

Comment:

--

UseCase216049

@@ -63 +63 @@
 {{{#!div style="font-size: 80%"
   {{{#!sql
-select b_id from project.Bileti b where b.l_id = 1
+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))
   }}}
 }}}