<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class PurchaseOrderManual extends Model
{
    protected $table = "purchase_orders_manuals";
    protected $guarded = ['id'];

    // protected $appends = ['amount', 'amount_due'];
    // protected $appends = ['payment_amount', 'amount_due', 'current_status'];
    // Disini masih bingung amount dan amount_due kalo di PurchaseOrderManual dapet dari mana (ref: SaleOrder).

    public function getAmountAttribute()
    {
        $subtotal = 0;
        foreach ($this->items as $item) {
            if ($item->pivot->sign == "-") {
                $subtotal = $subtotal - (int) ($item->pivot->subtotal ?? 0);
            } else {
                $subtotal = $subtotal + (int) ($item->pivot->subtotal ?? 0);
            }
        }

        if ((int) $subtotal < 0) {
            return (int) $subtotal + (int) $this->discount - (int) $this->postal_fee_price;
        } else {
            return (int) $subtotal - (int) $this->discount + (int) $this->postal_fee_price;
        }

        // return $this->items->sum('pivot.subtotal') - (int) $this->discount + (int) $this->postal_fee_price;
    }

    public function getAmountDueAttribute()
    {
        return $this->amount - $this->paymentAmount;
    }

    public function scopeSearch($q, $keyword)
    {
        return $q->where(function ($q) use ($keyword) {
            $q->where('name', 'like', "%$keyword%")
                ->orWhere('unit', 'like', "%$keyword%");
        });
    }

    public function purchaseRequest()
    {
        return $this->belongsTo(PurchaseRequest::class);
    }

    public function purchaseOrderManualDetails()
    {
        return $this->hasMany(PurchaseOrderManualDetail::class);
    }
}