Get millage report between 7:00am - 7:00pm during a month, possible?

[quantumapps0]

Dear Sir,

Thank you for your services.
I would like to get a report for vehicles for a period of the month but only between 7:00 am - 7:00 pm (19:00). Unfortunately, with the current version, I'm not able to do that.
Is there any solution for that, is there any query I can run on MySQL that calculates for me this? Please, anything would be helpful as I urgently need this.

Kind regards,

[vitalidze]

Not sure why you need it and why the report for a month does not work. I don't know an SQL query to run it because it needs to calculate distance between positions loaded from DB. In theory you can run 30/31 reports and then combine them somehow. You can do it via the /traccar/report endpoint by supplying there a JSON with report parameters. I cannot quickly give you an exact structure, but you can definitely reverse engineer it in your web browser console if you run a report for the desired period of time just once.

[quantumapps0]

Dear Vitalidze,

The reason our working time is 7:00 - 19:00, after that drivers brig their vehicles to home. Since I'm providing them fuel based on millage detail. I want to filter out only working hours between this period only because of the vehicles used after working time for personal uses which is not my responsibility.
So, now I have to run 30/31 reports and Sum them per each vehicle which takes a lot of time because the number of vehicles exceeds 100.

If in any way this is possible, I'm ready.
Thanks for your help.

[vitalidze]

As I said you can run these 30/31 reports programmatically for all your vehicles and then process them with some application. This is the only doable way without changing the Traccar code.

[quantumapps0]

Let's leave the traccar code, I only need a query to calculate the millage between a period. I'm familiar to MySQL and PHP and HTML, I can create a view and get my report also I can implement it in an interface.
But all I need an algorithm or a QUERY to calculate the millage inside MySQL.
Thanks