I'm going to attempt to simplify the reporting queries. I've been hung up on using GROUP BY in the queries, when I don't need it. I forgot that GROUP BY is used in conjunction with aggregate functions. In this application, I think it's better to move that to presentation layer, which also implies that the presentation Model, a Laravel Collection, needs to do some of the work.
So, this Issue, if successful and completed will deal with that.
I'm going to attempt to simplify the reporting queries. I've been hung up on using GROUP BY in the queries, when I don't need it. I forgot that GROUP BY is used in conjunction with aggregate functions. In this application, I think it's better to move that to presentation layer, which also implies that the presentation Model, a Laravel Collection, needs to do some of the work.
So, this Issue, if successful and completed will deal with that.