I have Table Entradaestoques
id - prod - qtd
1 - soap - 10
2 - cloth - 7
3 - soap - 20
4 - disinfectant - 4
5 - soap - 20
6 - cloth - 3
I want to show in View
Soap: 50 units
Cloth: 10 pcs
How do I calculate the sum of the amount of the soap product and the other products in controller
of CakePHP
and send that sum to show in View
?