Changes between Version 8 and Version 9 of AdvancedReports

Timestamp:

12/27/22 21:23:33 (3 years ago)

Author:

201065

Comment:

--

AdvancedReports

@@ -113 +113 @@
 {{{#!sql
 select s.supplierinfo, u.firstname, u.lastname, u.username, coalesce(sum(o2.quantity), 0) as koldostavena, coalesce(sum(o2.quantity*o2.price)) as zarabotkasupp from suppliers s 
-                left join users u on u.userid=s.userid
-                left join orders o on o.supplieruserid=s.userid and (o.status='Delivered' or o.status='Processed') 
-                left join orderedarticles o2 on o2.orderid=o.orderid and (o2.articlestatus='Delivered' or o2.articlestatus='Processed')
-                group by s.userid, u.userid
-                order by zarabotkasupp desc
+        left join users u on u.userid=s.userid
+        left join orders o on o.supplieruserid=s.userid and (o.status='Delivered' or o.status='Processed') 
+        left join orderedarticles o2 on o2.orderid=o.orderid and (o2.articlestatus='Delivered' or o2.articlestatus='Processed')
+        group by s.userid, u.userid
+        order by zarabotkasupp desc
 }}}