<?php

namespace Yajny\Member\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class ProcessedBalanceTransaction extends Model
{
    protected $table = 'processed_balance_transactions';
    protected $primaryKey = 'id';
    protected $guarded = [];

    public function hasUnprocessed()
    {
        $query = DB::table('processed_balance_transactions')
            ->where('user_id', '=', $this->user_id)
            ->where('is_processed', '=', 0);

        if ($this->id)
            $query->where('id', '!=', $this->id);

        return $query->count() > 0;
    }
}