CakePHP 4 Sum and group by month name.(50)

This tutorial I have given an example how to use mysql aggregate function in cakephp. This example on Sum a column then group by month name.

[thies]

can you show us how to import a CSV file into a database, optimally with prior validation and manipulation. There's nothing about it on yt but a common case. Thanks for your super cake howto's, keep it up!

[rodrigocabotajejr]

Can you do drop down filter that only show the selected Fields?

[janainamoreiraclemente]

Bom dia. Como coloco dessa maneira "SELECT as total, impressora
FROM impressao i
WHERE i.impressora = 'Nuvera 2 - Z7PK' and MONTH(i.dataImpressao) = month(current_date()) and YEAR(i.dataImpressao) = year(current_date())";