<?php

namespace App\Main\Repositories;

use App\Models\PurchaseOrderMachineManual;
use App\Models\PurchaseOrderMachineManualDetail;
use App\Main\Attrs\Fillable\PurchaseOrderMachineManualAttr;
use App\Main\Attrs\Fillable\PurchaseOrderMachineManualDetailAttr;

class PurchaseOrderMachineManualRepository
{
    public function create(PurchaseOrderMachineManualAttr $attr)
    {
        $data                       = new PurchaseOrderMachineManual();
        $data->purchase_order_id    = $attr->getPurchaseOrderId();
        $data->asset_id             = $attr->getAssetId();
        $data->ref_pr               = $attr->getRefPr();
        $data->unit                 = $attr->getUnit();
        $data->price                = str_replace('.', '', $attr->getPrice());
        $data->save();

        return $data;
    }

    public function createMachineManualDetail(PurchaseOrderMachineManualDetailAttr $detailAttr)
    {
        $data                                       = new PurchaseOrderMachineManualDetail();
        $data->purchase_order_machine_manual_id     = $detailAttr->getPurchaseOrderMachineManualId();
        $data->unit_price_id                        = $detailAttr->getunitPriceId();
        $data->qty                                  = $detailAttr->getQty() ?? 0;
        $data->save();

        return $data;
    }

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

        return $res;
    }

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

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