Difference between #38 and #39 of
Yii v2 snippet guide II

Revision #39 has been created by rackycz on Oct 5, 2020, 6:22:52 PM with the memo:

Child aggregation in Parent GridView
« previous (#38) next (#40) »

Changes

Title unchanged

Yii v2 snippet guide II

Category unchanged

Tutorials

Yii version unchanged

2.0

Tags unchanged

tutorial,beginner,yii2,snippets

Content changed

[...]
```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
```
[...]
4 0
3 followers
Viewed: 68 881 times
Version: 2.0
Category: Tutorials
Tags: beginner, snippets, tutorial, yii2
Written by: rackycz
Last updated by: rackycz
Created on: Aug 26, 2020
Last updated: 2 years ago
Update Article
Revert to #38 | Revert to #39

Revisions

View all history