perakitan migrasi manual dr fakhry

<?php
namespace App\Http\Controllers\Inventories;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Inventories;
use App\Assemblies;
use App\AssemblyUpdates;

class AssemblyUpdatesController extends Controller
{
    public function index() {
        $result = AssemblyUpdates::with('branch', 'branch.legalEntity', 'employee', 'inventory')->get();
        return response()->json($result);
    }

    public function store(Request $request) {
        $id = AssemblyUpdates::create($request->all())->Id;

        $assemblerItem = AssemblyUpdates::find($id);
        // $existingInventory = Inventories::find($assemblerItem->ItemId);
        $maintenanceInventory1 = AssemblyUpdates::find($assemblerItem->MaintenanceItem1Id);
        $maintenanceInventory2 = AssemblyUpdates::find($assemblerItem->MaintenanceItem2Id);
        $maintenanceInventory3 = AssemblyUpdates::find($assemblerItem->MaintenanceItem3Id);
        $maintenanceInventory4 = AssemblyUpdates::find($assemblerItem->MaintenanceItem4Id);
        $maintenanceInventory5 = AssemblyUpdates::find($assemblerItem->MaintenanceItem5Id);

        // data dari inventory
        $existingInventory = Inventories::find($request->ItemId);

        // data dari perakitan
        $existingAssembly = Assemblies::find($request->Id);

        // Pengurangan ke tabel perakitan
        if($existingAssembly->Id != null) {
            $existingAssembly->UnassemblyQuantity = $existingAssembly->UnassemblyQuantity - $assemblerItem->TotalAssemblyQuantity;
            $existingAssembly->AssemblyQuantity = $existingAssembly->AssemblyQuantity + $assemblerItem->TotalAssembly;
            $existingAssembly->Quantity100 = $existingAssembly->Quantity100 - $assemblerItem->Quantity100;
            $existingAssembly->Quantity90 = $existingAssembly->Quantity90 - $assemblerItem->Quantity90;
            $existingAssembly->Quantity60 = $existingAssembly->Quantity60 - $assemblerItem->Quantity60;
            $existingAssembly->Quantity30 = $existingAssembly->Quantity30 - $assemblerItem->Quantity30;
            $existingAssembly->save();
        }

        $existingItemAfterAssembly->Quantity100 = $existingItemAfterAssembly->Quantity100 + $assemblerItem->AssemblyAmount100;
        $existingItemAfterAssembly->Quantity90 = $existingItemAfterAssembly->Quantity90 + $assemblerItem->AssemblyAmount90;
        $existingItemAfterAssembly->Quantity60 = $existingItemAfterAssembly->Quantity60 + $assemblerItem->AssemblyAmount60;
        $existingItemAfterAssembly->Quantity30 = $existingItemAfterAssembly->Quantity30 + $assemblerItem->AssemblyAmount30;

        $existingItemAfterRefurbish->RefurbishQuantity = $existingItemAfterRefurbish->RefurbishQuantity + $request->TotalAssemblyAmount;

        // if ($assemblerItem->MaintenanceItem1Id != null && $maintenanceInventory1->Id == $assemblerItem->MaintenanceItem1Id) {
        //     $existingInventory->TotalQuantity = $existingInventory->TotalQuantity - $assemblerItem->MaintenanceItem1Amount;
        //     $existingInventory->Quantity100 = $existingInventory->Quantity100 - $assemblerItem->MaintenanceItem1Amount100;
        //     $existingInventory->Quantity90 = $existingInventory->Quantity90 - $assemblerItem->MaintenanceItem1Amount90;
        //     $existingInventory->Quantity60 = $existingInventory->Quantity60 - $assemblerItem->MaintenanceItem1Amount60;
        //     $existingInventory->Quantity30 = $existingInventory->Quantity30 - $assemblerItem->MaintenanceItem1Amount30;
        //     $existingInventory->save();
        // } else {
        //     $existingInventory->save();
        // }

        // if ($assemblerItem->MaintenanceItem2Id != null && $maintenanceInventory2->Id == $assemblerItem->MaintenanceItem2Id) {
        //     $existingInventory->TotalQuantity = $existingInventory->TotalQuantity - $assemblerItem->MaintenanceItem2Amount;
        //     $existingInventory->Quantity100 = $existingInventory->Quantity100 - $assemblerItem->MaintenanceItem2Amount100;
        //     $existingInventory->Quantity90 = $existingInventory->Quantity90 - $assemblerItem->MaintenanceItem2Amount90;
        //     $existingInventory->Quantity60 = $existingInventory->Quantity60 - $assemblerItem->MaintenanceItem2Amount60;
        //     $existingInventory->Quantity30 = $existingInventory->Quantity30 - $assemblerItem->MaintenanceItem2Amount30;
        //     $existingInventory->save();
        // } else {
        //     $existingInventory->save();
        // }

        // if ($assemblerItem->MaintenanceItem3Id != null && $maintenanceInventory3->Id == $assemblerItem->MaintenanceItem3Id) {
        //     $existingInventory->TotalQuantity = $existingInventory->TotalQuantity - $assemblerItem->MaintenanceItem3Amount;
        //     $existingInventory->Quantity100 = $existingInventory->Quantity100 - $assemblerItem->MaintenanceItem3Amount100;
        //     $existingInventory->Quantity90 = $existingInventory->Quantity90 - $assemblerItem->MaintenanceItem3Amount90;
        //     $existingInventory->Quantity60 = $existingInventory->Quantity60 - $assemblerItem->MaintenanceItem3Amount60;
        //     $existingInventory->Quantity30 = $existingInventory->Quantity30 - $assemblerItem->MaintenanceItem3Amount30;
        //     $existingInventory->save();
        // } else {
        //     $existingInventory->save();
        // }

        // if ($assemblerItem->MaintenanceItem4Id != null && $maintenanceInventory4->Id == $assemblerItem->MaintenanceItem4Id) {
        //     $existingInventory->TotalQuantity = $existingInventory->TotalQuantity - $assemblerItem->MaintenanceItem4Amount;
        //     $existingInventory->Quantity100 = $existingInventory->Quantity100 - $assemblerItem->MaintenanceItem4Amount100;
        //     $existingInventory->Quantity90 = $existingInventory->Quantity90 - $assemblerItem->MaintenanceItem4Amount90;
        //     $existingInventory->Quantity60 = $existingInventory->Quantity60 - $assemblerItem->MaintenanceItem4Amount60;
        //     $existingInventory->Quantity30 = $existingInventory->Quantity30 - $assemblerItem->MaintenanceItem4Amount30;
        //     $existingInventory->save();
        // } else {
        //     $existingInventory->save();
        // }

        // if ($assemblerItem->MaintenanceItem5Id != null && $maintenanceInventory5->Id == $assemblerItem->MaintenanceItem5Id) {
        //     $existingInventory->TotalQuantity = $existingInventory->TotalQuantity - $assemblerItem->MaintenanceItem5Amount;
        //     $existingInventory->Quantity100 = $existingInventory->Quantity100 - $assemblerItem->MaintenanceItem5Amount100;
        //     $existingInventory->Quantity90 = $existingInventory->Quantity90 - $assemblerItem->MaintenanceItem5Amount90;
        //     $existingInventory->Quantity60 = $existingInventory->Quantity60 - $assemblerItem->MaintenanceItem5Amount60;
        //     $existingInventory->Quantity30 = $existingInventory->Quantity30 - $assemblerItem->MaintenanceItem5Amount30;
        //     $existingInventory->save();
        // } else {
        //     $existingInventory->save();
        // }

        // $assembly = Assemblies::find($request->AssemblyId);
        // if($assembly->UnassemblyQuantity - $request->TotalAssemblyAmount >= 0) {
        //     $assembly->AssemblyQuantity = $assembly->AssemblyQuantity + $request->TotalAssemblyAmount;
        //     $assembly->UnassemblyQuantity = $assembly->UnassemblyQuantity - $request->TotalAssemblyAmount;
        //     $assembly->save();

        //     $existingItemAfterAssembly = Inventories::find($assembly->ItemId);
        //     $existingItemAfterAssembly->TotalQuantity = $existingItemAfterAssembly->TotalQuantity + $request->TotalAssemblyAmount;
        //     $existingItemAfterAssembly->Quantity100 = $existingItemAfterAssembly->Quantity100 + $assemblerItem->AssemblyAmount100;
        //     $existingItemAfterAssembly->Quantity90 = $existingItemAfterAssembly->Quantity90 + $assemblerItem->AssemblyAmount90;
        //     $existingItemAfterAssembly->Quantity60 = $existingItemAfterAssembly->Quantity60 + $assemblerItem->AssemblyAmount60;
        //     $existingItemAfterAssembly->Quantity30 = $existingItemAfterAssembly->Quantity30 + $assemblerItem->AssemblyAmount30;
        //     $existingItemAfterAssembly->save();

        //     if($request->AssemblyType == "Item Perakitan Rekondisi") {
        //         $existingItemAfterRefurbish = Inventories::find($assembly->ItemId);
        //         $existingItemAfterRefurbish->RefurbishQuantity = $existingItemAfterRefurbish->RefurbishQuantity + $request->TotalAssemblyAmount;
        //         $existingItemAfterRefurbish->save();
        //     }

        // } else {
        //     $assembly->AssemblyQuantity = $assembly->AssemblyQuantity + $request->TotalAssemblyAmount;
        //     $assembly->UnassemblyQuantity = 0;
        //     $assembly->save();

        //     $existingItemAfterAssembly = Inventories::find($assembly->ItemId);
        //     $existingItemAfterAssembly->TotalQuantity = $existingItemAfterAssembly->TotalQuantity + $assembly->AssemblyQuantity;
        //     $existingItemAfterAssembly->Quantity100 = $existingItemAfterAssembly->Quantity100 + $assemblerItem->AssemblyAmount100;
        //     $existingItemAfterAssembly->Quantity90 = $existingItemAfterAssembly->Quantity90 + $assemblerItem->AssemblyAmount90;
        //     $existingItemAfterAssembly->Quantity60 = $existingItemAfterAssembly->Quantity60 + $assemblerItem->AssemblyAmount60;
        //     $existingItemAfterAssembly->Quantity30 = $existingItemAfterAssembly->Quantity30 + $assemblerItem->AssemblyAmount30;
        //     $existingItemAfterAssembly->save();

        //     if($request->AssemblyType == "Item Perakitan Rekondisi") {
        //         $existingItemAfterRefurbish = Inventories::find($assembly->ItemId);
        //         $existingItemAfterRefurbish->RefurbishQuantity = $existingItemAfterRefurbish->RefurbishQuantity + $request->TotalAssemblyAmount;
        //         $existingItemAfterRefurbish->save();
        //     }
        // }

        return response()->json(['message' => 'Successfull create']);

    }

    public function show($id) {
        $result = AssemblyUpdates::find($id);
        return response()->json($result);
    }

    public function update(Request $request, $id) {
        $result = AssemblyUpdates::find($id);
        $result->update($request->all());
        return response()->json([ 'message' => 'Successfull update']);
    }

    public function delete($id) {
        AssemblyUpdates::destroy($id);
        return response()->json([ 'message' => 'Successfull delete']);
    }
}