<?php

namespace App\Main\Repositories;

use App\Models\PurchaseOrderMachine;
use App\Models\PurchaseOrderMachineDetail;
use App\Main\Attrs\Fillable\PurchaseOrderMachineAttr;
use App\Main\Attrs\Fillable\PurchaseOrderMachineDetailAttr;

class PurchaseOrderMachineRepository
{
    public function create(PurchaseOrderMachineAttr $attr)
    {
        $data                       = new PurchaseOrderMachine();
        $data->purchase_order_id    = $attr->getPurchaseOrderId();
        $data->asset_id             = $attr->getAssetId();
        $data->ref_pr               = $attr->getRefPr();
        $data->price                = $attr->getPrice();
        $data->save();

        return $data;
    }

    public function createMachineDetail(PurchaseOrderMachineDetailAttr $detailAttr)
    {
        $data                               = new PurchaseOrderMachineDetail();
        $data->purchase_order_machine_id    = $detailAttr->getPurchaseOrderMachineId();
        $data->unit_price_id                = $detailAttr->getunitPrices();
        $data->qty                          = $detailAttr->getQty() ?? 0;
        $data->save();

        return $data;
    }

    public function delete($id)
    {
        $res = PurchaseOrderMachine::where('purchase_order_id', $id)->delete();

        return $res;
    }

    public function fetch($purchaseOrderId)
    {
        $res = PurchaseOrderMachine::where('purchase_order_id', $purchaseOrderId)->first();
        return $res;
    }

    public function getUsedQty($assetId, $projectId)
    {
        return PurchaseOrderMachine::whereHas('purchaseOrder', function ($query) use ($projectId) {
            $query->where('project_id', $projectId);
        })->where('asset_id', $assetId)->first()->qty ?? 0;
    }
}