gistfile1.txt

    public function findByVendorIdByMonth($vendor, $id)
    {
        $data = $this->select(DB::raw("DATE_FORMAT(date, '%Y-%m-01 00:00:00') as date, SUM(views) as views, SUM(uniques) as uniques, SUM(inquiries) as inquiries"))
            ->groupBy(DB::raw("YEAR(date), MONTH(date)"))
            ->whereBetween('date', [date('Y-m-d 00:00:00', strtotime('-1 year')), date('Y-m-d 00:00:00', strtotime('today'))])
            ->where('vendor_type', $vendor)
            ->where('vendor_id', $id)->get();

        $monthly = ['totals' => [
            'uniques' => 0,
            'views' => 0,
            'inquiries' => 0
        ]];

        for ($key = 0; $key < 12; $key++) {
            $monthly['totals']['uniques'] += (isset($data[$key])) ? $data[$key]->uniques : 0;
            $monthly['totals']['views'] += (isset($data[$key])) ? $data[$key]->views : 0;
            $monthly['totals']['inquiries'] += (isset($data[$key])) ? $data[$key]->inquiries : 0;

            if (isset($data[$key])) {
                $monthly['intervals'][] = $data[$key]->getResourceAttributes();
            } else {
                $dummy = new Analytics();
                $dummy->date = date('Y-m-1 00:00:00', strtotime("-$key months"));
                $monthly['intervals'][] = $dummy->getResourceAttributes();
            }
        }

        return $monthly;
    }