<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Invoice extends Model
{
    public function bulan ()
    {
        return $this->hasMany('App\Invoice', 'bill_year','bill_year');
    }

    public function scopeWithBulan ($q, $status = 0)
    {
        return $q->whereStatus($status)->with(['bulan' => function ($q) use ($status) {
            $q->select('bill_month','bill_year', \DB::raw('count(id) as jumlah'))->groupBy('bill_year','bill_month')->whereStatus($status);
        }]);
    }
}