Laravel: Data to Monthly Converter
Using this package you will be able to converts your collection using a timestamp field to order data monthly or yearly and calculate monthly/yearly expenses. You can use this package to build some expenses app and apply in chart.js efficiently.
Require this package in your composer.json and update composer.
composer require 101infotech/data2monthly
Code Examples
use Infotech\Data2Monthly\Monthly;
▶
To get a ordered monthly data upto current month.
$data = Visitors::all();
Monthly::current($data,'created_at'));
// $data must be a Collection
// 'created_at' exist in collection, holds a timestamp or date
Result: It counts the data found on the respective month and returns an array.
array:5 [▼
0 => 0
1 => 0
2 => 0
3 => 0
4 => 1
]
▶
To get a sum of a field grouped monthly.
$data = Expenses::all();
Monthly::expenseMonthly($data,'created_at','price');
Result: It sums all the 'price' field and group monthly.
array:12 [▼
0 => 150
1 => 900
2 => 300
3 => 600
4 => 300
5 => 450
6 => 0
7 => 0
8 => 0
9 => 0
10 => 0
11 => 0
]
▶
To get a data counted monthly data upto current month according to a given year.
$data = Expenses::all();
Monthly::currentWithYear($data,'created_at','price','2021'));
Result: It counts the data found on the respective month upto current month and with respective year and returns an array.
array:6 [▼
0 => 0
1 => 0
2 => 0
3 => 0
4 => 2
5 => 0
]
▶
Some List of Available Codes
Monthly::current($data,'created_at'));
Monthly::monthly($data,'created_at'));
Monthly::yearly($data,'created_at'));
Monthly::expenseCurrent($data,'created_at','price'));
Monthly::expenseMonthly($data,'created_at','price));
Monthly::expenseYearly($data,'created_at','price'));
Monthly::currentWithYear($data,'created_at','price','2021'));
Monthly::monthlyWithYear($data,'created_at','price','2021'));
▶
Using in chart.js
$dataArr = Monthly::current($data,'created_at'));
4k Jan 6, 2023
11 Apr 21, 2021
30 Oct 19, 2022
52 Nov 15, 2022
55 Oct 28, 2022
2.4k Jan 3, 2023
128 Dec 24, 2022
47 Oct 3, 2022
456 Dec 21, 2022
2.4k Jan 3, 2023
87 Nov 26, 2022
27 Mar 2, 2022
66 Sep 19, 2022
32 Dec 21, 2022
15 Aug 11, 2022
9 Nov 29, 2022
2 Jul 27, 2022
88 Dec 23, 2022