`<?php
namespace Modules\Revenue\Entities;
use Illuminate\Support\Arr; use Illuminate\Database\Eloquent\Model;
class RevenueProceed extends Model { protected $table = 'revenue_proceeds';
protected $guarded = [];
protected $fillable = ['name', 'category', 'currency', 'amount', 'recieved_at', 'year', 'month', 'notes'];
public function scopeApplyFilters($query, $filters)
{
if ($year = Arr::get($filters, 'year', false)) {
$query = $query->where(function ($q) use($year) {
$q->where('year', '=', $year)->where('month' > 3);
})
->orWhere(function ($q) use($year) {
$q->where('month' < 4)->where('year', '=', $year+1);
});
}
return $query;
}
}`