Changes between Version 13 and Version 14 of AdvancedDatabaseReports

Timestamp:

01/29/23 18:57:00 (17 months ago)

Author:

181085

Comment:

--

AdvancedDatabaseReports

@@ -13 +13 @@
 
 {{{#!sql:
-SELECT d.driver_id, SUM(d.km_travelled) as km_travelled_with_driver, 
+SELECT uuid_generate_v4() as id, pay.passenger_id, d.driver_id, SUM(d.km_travelled) as km_travelled_with_driver, 
 SUM(pay.total_sum_payed) as total_price_paid, SUM(pay.total_sum_payed)/SUM(d.km_travelled) as price_per_km
 FROM request r
 JOIN drive d ON r.request_id = d.request_id 
-JOIN payment pay ON pay.passenger_id = r.passenger_id
-WHERE r.passenger_id = '87da7c89-fc2e-44a0-9bfa-d89de68c2a22'
-GROUP BY d.driver_id 
-ORDER BY price_per_km ASC
+JOIN payment pay ON d.drive_id = pay.drive_id 
+GROUP BY d.driver_id, pay.passenger_id 
+ORDER BY price_per_km asc
 }}}