Changes between Version 4 and Version 5 of AdvancedReports

Timestamp:

12/23/22 11:57:49 (2 years ago)

Author:

192007

Comment:

--

AdvancedReports

@@ -53 +53 @@
 
 {{{#!sql 
-select a.user_id,b.username, a.prihod  
+select a.user_id,
+                b.username, 
+                a.prihod  
         from (
-select user_id,
-                sum(v.daily_rental_price * (c.end_date - c.start_date)) as prihod
-        from contracts c
-        join vehicles v on v.vehicle_id = c.vehicle_id 
-                group by c.user_id ) a
-                join (
-                        select c.user_id, u.username  from clients as c
-                        join users u on u.user_id = c.user_id 
-                ) b on a.user_id = b.user_id
+                        select user_id,
+                                sum(v.daily_rental_price * (c.end_date - c.start_date)) as prihod
+                from contracts c
+                join vehicles v on v.vehicle_id = c.vehicle_id 
+                        group by c.user_id ) a
+                        join (
+                                        select c.user_id, u.username  from clients as c
+                                                join users u on u.user_id = c.user_id 
+                        ) b on a.user_id = b.user_id
                 where a.prihod = 
-                                (select max(prihod) from (select user_id,sum(v2.daily_rental_price * (c4.end_date - c4.start_date)) as prihod from contracts c4
-                                        join vehicles v2 on v2.vehicle_id = c4.vehicle_id group by user_id) maximprihod)  
+                                (select max(prihod) from (
+                                                select user_id,sum(v2.daily_rental_price * (c4.end_date - c4.start_date)) as prihod 
+                                                        from contracts c4
+                                                        join vehicles v2 on v2.vehicle_id = c4.vehicle_id
+                                                        group by user_id) maximprihod
+                                )  
 }}}