Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

01/05/23 06:53:47 (3 years ago)

Author:

201094

Comment:

--

AdvancedReports

@@ -255 +255 @@
 from films f 
 }}}
+
+=== Извештај за секое кино, колку вработени има и колку пари треба да исплати секое кино следниов месец на неговите вработени ===
+{{{#!sql
+select c.id_cinema, 
+coalesce((
+select count(distinct w.id_worker) from workers w
+left join cinemas c1 on c1.id_cinema=w.id_cinema 
+where c1.id_cinema=c.id_cinema
+),0),
+coalesce((
+select sum(s.sum) from salaries s 
+left join workers w2 on s.id_worker=w2.id_worker
+left join cinemas c1 on c1.id_cinema=w2.id_cinema 
+where c1.id_cinema=c.id_cinema and s.date_to is null
+),0)
+from cinemas c 
+}}}