Hallo,
Ik wil graag statistieken maken van de facturen in mijn database, maar ik heb geen idee hoe ik dat aanpak.
Ik gebruik laravel en chartjs.
Mijn code:
```$thismonth = Invoice::where('created_at', '>=', Carbon::now()->startOfMonth())->with('list')->groupBy('id')->get();```
Dit is dus $thismonth: [code][{
"id": 1,
"fact_id": "2017-10-11-0",
"secret": "Fb54TjqAa7",
"client_id": 1,
"interval": "30",
"created_at": "2017-10-11 10:29:14",
"updated_at": null,
"list": [{
"id": 1,
"fact": 1,
"product": "Betalen",
"category": "en",
"price": 12,
"amount": 12,
"created_at": null,
"updated_at": null
}, {
"id": 2,
"fact": 1,
"product": "een beetje",
"category": "snel",
"price": 10,
"amount": 10,
"created_at": null,
"updated_at": null
}]
}, {
"id": 2,
"fact_id": "2017-10-11-1",
"secret": "n0a3ucFE2v",
"client_id": 1,
"interval": null,
"created_at": "2017-10-11 11:18:10",
"updated_at": null,
"list": [{
"id": 3,
"fact": 2,
"product": "Test",
"category": "test",
"price": 13,
"amount": 12,
"created_at": null,
"updated_at": null
}, {
"id": 4,
"fact": 2,
"product": "Test",
"category": "111",
"price": 11,
"amount": 11,
"created_at": null,
"updated_at": null
}]
}][/code]