brendt/aggregate.stitcher.io

{
    "name" : "brendt/aggregate.stitcher.io",
    "require" : {
        "php": "^7.4",
        "abraham/twitteroauth": "^1.0",
        // ...
 
        "spatie/period": "^1.1",
 
        // ...
    },
}

// These methods create Periods of the last 30 days
// Spatie Period package helps to manipulate them easier
 
use Spatie\Period\Period;
 
final class Analytics
{
    // ... other methods
 
    public function viewsPerDay(): Collection
    {
        $period = Period::make(now()->subDays(30), now());
 
        /** @var \Domain\Post\Collections\ViewCollection $views */
        $views = View::query()
            ->where('created_at', '>=', $period->getStart())
            ->get();
 
        return $views->spreadForPeriod($period);
    }
 
    public function votesPerDay(): Collection
    {
        $period = Period::make(now()->subDays(30), now());
 
        /** @var \Domain\Post\Collections\VoteCollection $votes */
        $votes = Vote::query()
            ->where('created_at', '>=', $period->getStart())
            ->get();
 
        return $votes->spreadForPeriod($period);
    }
}

// This method prepares a collection of all period elements, one for each day
// It's used for Analytics reports - all 30 days have 0 records by default, in the beginning
 
use Carbon\Carbon;
use Spatie\Period\Period;
 
trait SpreadForPeriod
{
    public function spreadForPeriod(Period $period)
    {
        $day = Carbon::make($period->getStart());
 
        $data = collect([]);
 
        while ($day <= $period->getEnd()) {
            $data[$day->toDateString()] = 0;
 
            $day->addDay();
        }
 
        foreach ($this as $model) {
            $data[$model->created_at->toDateString()] += 1;
        }
 
        return $data;
    }
}