/collection/{slug}/estimation: optimize summing of prices

[0pdd]

The puzzle 884-03637f5c from #884 has to be resolved:

mystamps/src/main/webapp/WEB-INF/views/collection/estimation.html

Line 119 in 9287473

@todo #884 /collection/{slug}/estimation: optimize summing of prices

The puzzle was created by Slava Semushin on 20-Jun-18.

[0pdd]

The puzzle 884-03637f5c has disappeared from the source code, that's why I closed this issue.

[php-coder]

Here is the sql query for that:

select sum(price) as total,currency from collections_series where price is not null group by currency;
+---------+----------+
| total   | currency |
+---------+----------+
|  300.00 | EUR      |
| 2137.50 | RUB      |
|  150.00 | USD      |
+---------+----------+
3 rows in set (0.00 sec)

[php-coder]

Yet another way is to use window functions and get total price together with data:

SUM(cs.price) OVER(PARTITION BY cs.currency) AS total_price

But such data list will be hard to process from within Thymeleaf, so we can apply a little transformation on DAO layer.