Yii v2 snippet guide II

Comparing #38 with #39

Revision #39 was created by rackycz rackycz on Oct 5, 2020, 6:22:52 PM.

Child aggregation in Parent GridView

Content

[...]
```sql
CREATE VIEW v_invoice AS
SELECT invoice.*,
SUM(invoice_item.units * invoice_item.price_per_unit) as amount,
COUNT(invoice_item.id_invoice*) as items
FROM invoice
LEFT JOIN invoice_item
ON (invoice.id = invoice_item.id_invoice)
GROUP BY invoice.id
```
[...]