Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

12/27/22 11:39:58 (2 years ago)

Author:

201091

Comment:

--

AdvancedReports

@@ -64 +64 @@
                                 )odliv  on odliv.categoryid=c.categoryid)
 }}}
+
+===  Извештај за профитот на сите магацини според набавени артикли и продадени артикли во период од една година===
+
+{{{#!sql
+select q1.locationname, prihod-odliv as profit from 
+(
+        select l.locationid, l.locationname, sum(i.price*i.quantity) as prihod from locations l 
+        left join storedarticles s on s.locationid=l.locationid 
+        left join invoicedarticles i on i.articleid=s.articleid
+        left join invoices i2 on i2.invoiceid=i.invoiceid and i2.datecreate between now()-interval '1 year' and now()
+        group by l.locationid
+        
+) as q1
+full outer join 
+(
+        select l.locationid, l.locationname, sum(o.price*o.quantity) as odliv from locations l 
+        left join orderedarticles o on o.locationid=l.locationid 
+        left join orders o2 on o2.orderid=o.orderid and o2.datecreated between now()-interval '1 year' and now()
+        group by l.locationid
+        
+) q2 on q2.locationid=q1.locationid
+
+}}}