Changes between Version 1 and Version 2 of AdvancedReports

Timestamp:

02/14/24 20:21:28 (5 months ago)

Author:

191572

Comment:

--

AdvancedReports

@@ +1 @@
+{{{#!div style="font-size: 100%"
+  {{{#!sql
+
 -- Zarabotka otstvarena preku narackite od aplikacijata za sekoj restoran na mesecno nivo
 SELECT r.ime, DATE_PART('Month', n.datum) AS mesec, DATE_PART('Year', n.datum) AS godina, SUM(iznos) AS zarabotka
@@ -34 +37 @@
 JOIN naplata np ON n.id=np.naracka_id
 GROUP BY r.ime, np.nacin_na_plakjane, DATE_PART('Month', n.datum), DATE_PART('Year', n.datum);
+  }}}
+}}}