<?php

namespace App\Main\Repositories;

use App\Models\PurchaseOrderVendor;
use App\Main\Attrs\Fillable\PurchaseOrderVendorManualAttr;
use App\Main\Contracts\PurchaseOrderVendorManualRepositoryInterface;
use App\Models\PurchaseOrderVendorManual;
use App\Models\PurchaseRequestVendorManual;
use App\Models\PurchaseRequestVendorManualDetail;

class PurchaseOrderVendorManualRepository implements PurchaseOrderVendorManualRepositoryInterface
{
    public function create(PurchaseOrderVendorManualAttr $purchaseOrderVendorManualAttr)
    {
        $data                       = new PurchaseOrderVendorManual();
        $data->purchase_order_id    = $purchaseOrderVendorManualAttr->getPurchaseOrderId();
        $data->vendor_product_id    = $purchaseOrderVendorManualAttr->getVendorProductId();
        $data->price                = str_replace('.', '', $purchaseOrderVendorManualAttr->getPrice());
        $data->ref_pr               = $purchaseOrderVendorManualAttr->getRefPr();
        $data->save();

        return $data;
    }

    public function delete($id)
    {
        $check = PurchaseOrderVendorManual::where('purchase_order_id', $id);
        $purchaseOrderVendorManual = $check->delete();

        return $purchaseOrderVendorManual;
    }

    public function getMachineManualPurchaseRequest($purchaseRequestId)
    {
        return PurchaseRequestVendorManual::selectRaw('id, purchase_request_id, vendor_product_id, name, unit, price, qty')
            ->with(['vendorProduct' => function ($query) {
                $query->selectRaw('id, name, unit, price');
            }, 'purchaseRequestVendorManualDetails' => function ($query) {
                $query->selectRaw('id, purchase_request_vendor_manual_id, unit_price_id, qty, used_qty');
                $query->with(['unitPrice' => function ($query){
                    $query->selectRaw('id, name, unit, prices');
                }]);
            }])
            ->where('purchase_request_id', $purchaseRequestId)
            ->get();
    }

    public function updateUsedQtyDetail($create, $detail, $isUpdated = false)
    {
        $updt = PurchaseRequestVendorManualDetail::whereHas('purchaseRequestVendorManual', function ($q) use ($create){
            $q->where([
                ['purchase_request_id', '=' , $create->ref_pr],
                ['vendor_product_id', '=', $create->vendor_product_id]
            ]);
        })->where('unit_price_id', $detail->unit_price_id)->first();

        $qty = $isUpdated ? (float)$detail->qty : (float)$updt->used_qty + (float)$detail->qty;

        $updt->update([
            "used_qty" =>  $qty
        ]);
    }
}