Add the grouping of data requests by year

[laihoel]

The volume of data requests is already so large (almost 10 000) that it is not possible to display all requests in a single list. Split the list by year, so that the oldest requests are grouped into the year 2021.

In the user interface, this could look for example like this. Since not all datasets have requests from the beginning, in such cases only the years with requests are shown in the handler’s view.

[aorin]

@laihoel The easiest way to implement this is that the year select appears when the user chooses "all requests". Can be tested here https://staging-pyha.laji.fi/. Do you think it's important to group the request after the year 2021? I tested that with the year filter it's still little slow with the production data, it takes a few seconds to load for admins but it's still a significant improvement.

[laihoel]

Thanks! This looks great! It's not important to group the requests once there's the selection of the year, so it don't take too much space on the screen.

[aorin]

This is now on prod https://pyha.laji.fi/. It's slower than I thought, it takes multiple seconds to load a year (for admins). Is it ok for now or should we make bigger changes?

[laihoel]

I think the waiting time itself is ok (although quite long, about 30 sec). But I get this error if I try to change the year, before I have waited that it has loaded all the requests.

[aorin]

Fixed, it doesn't show the error message anymore