trying to apply a filter in listing,getting SQLSTATE[42S22] error

Viewed 14

`<?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;
}

}`

0 Answers
Related