marijnbent
use App\User;
use Laravel\Cashier\Subscription;
$now = Carbon::now();
$week = Carbon::now()->subWeeks(52);
while ($now > $week) {
$start = $week->startOfWeek()->toDateString();
$end = $week->endOfWeek()->toDateString();
echo "*$start - $end* \n";
$newUsers = User::whereDate('created_at', '>=', $start)
->whereDate('created_at', '<=', $end)
->get();
echo "New users: {$newUsers->count()} \n";
$newSubscriptions = Subscription::whereDate('created_at', '>=', $start)
->whereDate('created_at', '<=', $end)
->get();
echo "New subscriptions: {$newSubscriptions->count()} \n";
echo "\n";
$week->addWeek();
}
[!] Aliasing 'Carbon' to 'Carbon\Carbon' for this Tinker session.
*2019-11-18 - 2019-11-24*
New users: 3
New subscriptions: 0
*2019-11-25 - 2019-12-01*
New users: 13
New subscriptions: 0
*2019-12-02 - 2019-12-08*
New users: 3
New subscriptions: 0
*2019-12-09 - 2019-12-15*
New users: 6
New subscriptions: 0
*2019-12-16 - 2019-12-22*
New users: 11
New subscriptions: 1
*2019-12-23 - 2019-12-29*
New users: 1
New subscriptions: 0
*2019-12-30 - 2020-01-05*
New users: 9
New subscriptions: 0
*2020-01-06 - 2020-01-12*
New users: 16
New subscriptions: 1
*2020-01-13 - 2020-01-19*
New users: 10
New subscriptions: 0
*2020-01-20 - 2020-01-26*
New users: 8
New subscriptions: 0
*2020-01-27 - 2020-02-02*
New users: 7
New subscriptions: 0
*2020-02-03 - 2020-02-09*
New users: 12
New subscriptions: 0
*2020-02-10 - 2020-02-16*
New users: 11
New subscriptions: 0
*2020-02-17 - 2020-02-23*
New users: 15
New subscriptions: 0
*2020-02-24 - 2020-03-01*
New users: 8
New subscriptions: 1
*2020-03-02 - 2020-03-08*
New users: 9
New subscriptions: 0
*2020-03-09 - 2020-03-15*
New users: 5
New subscriptions: 0
*2020-03-16 - 2020-03-22*
New users: 9
New subscriptions: 0
*2020-03-23 - 2020-03-29*
New users: 8
New subscriptions: 0
*2020-03-30 - 2020-04-05*
New users: 13
New subscriptions: 1
*2020-04-06 - 2020-04-12*
New users: 10
New subscriptions: 0
*2020-04-13 - 2020-04-19*
New users: 7
New subscriptions: 0
*2020-04-20 - 2020-04-26*
New users: 9
New subscriptions: 0
*2020-04-27 - 2020-05-03*
New users: 5
New subscriptions: 0
*2020-05-04 - 2020-05-10*
New users: 8
New subscriptions: 0
*2020-05-11 - 2020-05-17*
New users: 8
New subscriptions: 0
*2020-05-18 - 2020-05-24*
New users: 10
New subscriptions: 0
*2020-05-25 - 2020-05-31*
New users: 14
New subscriptions: 0
*2020-06-01 - 2020-06-07*
New users: 11
New subscriptions: 0
*2020-06-08 - 2020-06-14*
New users: 9
New subscriptions: 0
*2020-06-15 - 2020-06-21*
New users: 10
New subscriptions: 0
*2020-06-22 - 2020-06-28*
New users: 14
New subscriptions: 2
*2020-06-29 - 2020-07-05*
New users: 31
New subscriptions: 1
*2020-07-06 - 2020-07-12*
New users: 46
New subscriptions: 1
*2020-07-13 - 2020-07-19*
New users: 26
New subscriptions: 3
*2020-07-20 - 2020-07-26*
New users: 17
New subscriptions: 3
*2020-07-27 - 2020-08-02*
New users: 18
New subscriptions: 3
*2020-08-03 - 2020-08-09*
New users: 5
New subscriptions: 10
*2020-08-10 - 2020-08-16*
New users: 14
New subscriptions: 1
*2020-08-17 - 2020-08-23*
New users: 13
New subscriptions: 0
*2020-08-24 - 2020-08-30*
New users: 7
New subscriptions: 1
*2020-08-31 - 2020-09-06*
New users: 51
New subscriptions: 6
*2020-09-07 - 2020-09-13*
New users: 18
New subscriptions: 1
*2020-09-14 - 2020-09-20*
New users: 11
New subscriptions: 0
*2020-09-21 - 2020-09-27*
New users: 16
New subscriptions: 1
*2020-09-28 - 2020-10-04*
New users: 16
New subscriptions: 1
*2020-10-05 - 2020-10-11*
New users: 22
New subscriptions: 1
*2020-10-12 - 2020-10-18*
New users: 11
New subscriptions: 1
*2020-10-19 - 2020-10-25*
New users: 35
New subscriptions: 3
*2020-10-26 - 2020-11-01*
New users: 31
New subscriptions: 5
*2020-11-02 - 2020-11-08*
New users: 17
New subscriptions: 2
*2020-11-09 - 2020-11-15*
New users: 16
New subscriptions: 0