sfp_api_laravel_ginastica_cerebro/app/Services/ClassPackageUnitService.php

<?php

namespace App\Services;

use App\Models\ClassPackageUnit;
use App\Models\ClassPackageUnitProduct;
use App\Models\IrrecusableProposalUnit;
use App\Models\IrrecusableProposalUnitProduct;
use App\Models\PavaoProposalUnit;
use App\Models\PavaoProposalUnitProduct;
use Illuminate\Database\Eloquent\Collection;

class ClassPackageUnitService
{
    public function __construct(
        protected ProposalPricingService $pricingService,
    ) {}

    private const EAGER_LOAD = [
        'products.product',
        'pavaoProposalUnit.products.product',
        'irrecusableProposalUnit.products.product',
    ];

    public function getByUnit(int $unitId): Collection
    {
        return ClassPackageUnit::with(self::EAGER_LOAD)
            ->where('unit_id', $unitId)
            ->where('visible', true)
            ->orderBy('name')
            ->get();
    }

    public function getAllByUnit(int $unitId): Collection
    {
        return ClassPackageUnit::with(self::EAGER_LOAD)
            ->where('unit_id', $unitId)
            ->orderBy('name')
            ->get();
    }

    public function findByIdForUnit(int $id, int $unitId): ClassPackageUnit
    {
        return ClassPackageUnit::with(self::EAGER_LOAD)
            ->where('unit_id', $unitId)
            ->findOrFail($id);
    }

    public function create(array $data): ClassPackageUnit
    {
        $materials   = $data['materials'] ?? [];
        $pavao       = $data['pavao'] ?? [];
        $irrecusavel = $data['irrecusavel'] ?? [];
        unset($data['materials'], $data['pavao'], $data['irrecusavel']);

        $data['contract_material_value'] = $this->calcMaterialValue($materials);

        $packageUnit = ClassPackageUnit::create($data);

        $this->syncProducts($packageUnit, $materials);

        $this->pricingService->upsert(PavaoProposalUnit::class, PavaoProposalUnitProduct::class, 'class_package_unit_id', $packageUnit->id, $pavao);
        $this->pricingService->upsert(IrrecusableProposalUnit::class, IrrecusableProposalUnitProduct::class, 'class_package_unit_id', $packageUnit->id, $irrecusavel, withCondition: true);

        return $packageUnit->load(self::EAGER_LOAD);
    }

    public function update(int $id, int $unitId, array $data): ClassPackageUnit
    {
        $packageUnit = $this->findByIdForUnit($id, $unitId);

        $materials   = $data['materials'] ?? null;
        $pavao       = $data['pavao'] ?? null;
        $irrecusavel = $data['irrecusavel'] ?? null;
        unset($data['materials'], $data['pavao'], $data['irrecusavel']);

        if ($materials !== null) {
            $data['contract_material_value'] = $this->calcMaterialValue($materials);
        }

        $packageUnit->update($data);

        if ($materials !== null) {
            $this->syncProducts($packageUnit, $materials);
        }

        // Edits here only affect this unit's own copy — never propagate up to the base package.
        if ($pavao !== null) {
            $this->pricingService->upsert(PavaoProposalUnit::class, PavaoProposalUnitProduct::class, 'class_package_unit_id', $packageUnit->id, $pavao);
        }

        if ($irrecusavel !== null) {
            $this->pricingService->upsert(IrrecusableProposalUnit::class, IrrecusableProposalUnitProduct::class, 'class_package_unit_id', $packageUnit->id, $irrecusavel, withCondition: true);
        }

        return $packageUnit->fresh(self::EAGER_LOAD);
    }

    public function toggleVisibility(int $id, int $unitId): ClassPackageUnit
    {
        $packageUnit = $this->findByIdForUnit($id, $unitId);

        $packageUnit->update(['visible' => !$packageUnit->visible]);

        return $packageUnit->fresh();
    }

    public function delete(int $id, int $unitId): bool
    {
        $packageUnit = $this->findByIdForUnit($id, $unitId);

        return $packageUnit->delete();
    }

    /**
     * Sync products on an existing ClassPackageUnit from the base package.
     */
    public function syncProductsFromBasePackage(ClassPackageUnit $packageUnit, \App\Models\ClassPackage $basePackage): void
    {
        $packageUnit->products()->delete();

        $basePackage->products->each(function ($product) use ($packageUnit) {
            ClassPackageUnitProduct::create([
                'class_package_unit_id' => $packageUnit->id,
                'product_id'            => $product->id,
                'quantity'              => $product->pivot->quantity,
                'price'                 => $product->pivot->price,
            ]);
        });
    }

    public function replicateFromBasePackage(int $unitId, \App\Models\ClassPackage $basePackage): ClassPackageUnit
    {
        $packageUnit = ClassPackageUnit::create([
            'unit_id'                 => $unitId,
            'class_package_id'        => $basePackage->id,
            'name'                    => $basePackage->name,
            'quantity_classes'        => $basePackage->quantity_classes,
            'contract_value'          => $basePackage->contract_value,
            'contract_material_value' => $basePackage->contract_material_value,
            'contract_register_value' => $basePackage->contract_register_value,
            'contrat_discount_value'  => $basePackage->contrat_discount_value,
            'class_duration_minutes'  => $basePackage->class_duration_minutes,
            'weekday'                 => $basePackage->weekday,
            'start_time'              => $basePackage->start_time,
            'second_weekday'          => $basePackage->second_weekday,
            'second_start_time'       => $basePackage->second_start_time,
            'visible'                 => true,
        ]);

        $basePackage->products->each(function ($product) use ($packageUnit) {
            ClassPackageUnitProduct::create([
                'class_package_unit_id' => $packageUnit->id,
                'product_id'            => $product->id,
                'quantity'              => $product->pivot->quantity,
                'price'                 => $product->pivot->price,
            ]);
        });

        $this->pricingService->cloneToUnit(
            $basePackage->pavaoProposal,
            PavaoProposalUnit::class,
            PavaoProposalUnitProduct::class,
            'class_package_unit_id',
            $packageUnit->id,
            'pavao_proposal_id',
        );

        $this->pricingService->cloneToUnit(
            $basePackage->irrecusableProposal,
            IrrecusableProposalUnit::class,
            IrrecusableProposalUnitProduct::class,
            'class_package_unit_id',
            $packageUnit->id,
            'irrecusable_proposal_id',
            withCondition: true,
        );

        return $packageUnit;
    }

    private function syncProducts(ClassPackageUnit $packageUnit, array $materials): void
    {
        $packageUnit->products()->delete();

        foreach ($materials as $m) {
            ClassPackageUnitProduct::create([
                'class_package_unit_id' => $packageUnit->id,
                'product_id'            => $m['product_id'],
                'quantity'              => $m['quantity'],
                'price'                 => $m['price'],
            ]);
        }
    }

    private function calcMaterialValue(array $materials): float
    {
        return array_reduce($materials, fn($carry, $m) => $carry + ($m['quantity'] * $m['price']), 0.0);
    }
}