Problem
As a commercial, it would be useful to be able to list the contracts ordered by their time consumption percentage. This would allow to get the ones that require more attention.
Solution
Add a new order option above the contracts list
The main difficulty comes from the fact that ordering actually must be done with SQL and, so, consumption must be calculated in the SearchEngine\Contract\QueryBuilder class. It is already done in getAlertTimeDql(), but it cannot be used as it is for ordering. I guess it could be done in the select query, and that this result will be usable to get both the time alert and to order the results.
Problem
As a commercial, it would be useful to be able to list the contracts ordered by their time consumption percentage. This would allow to get the ones that require more attention.
Solution
Add a new order option above the contracts list
The main difficulty comes from the fact that ordering actually must be done with SQL and, so, consumption must be calculated in the
SearchEngine\Contract\QueryBuilderclass. It is already done ingetAlertTimeDql(), but it cannot be used as it is for ordering. I guess it could be done in the select query, and that this result will be usable to get both the time alert and to order the results.