Get users and subscriptions per week

4 years ago

marijnbent

Code

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();
}

Output

[!] 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
Video course: PHP Package Development