Move queries for generating reports from JSP to actual API resource

[vesavlad]

Is your enhancement request to replace an existing functionality within TheTransitClock?
If the functionality already exists, please provide a clear description of its current behavior.

Is your enhancement request related to a problem? Please describe.
A clear description of what the problem is.

Describe the solution you'd like
A clear description of the expected functionality.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Example datasets
Please provide related datasets to test and validate the new functionality.