<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Warehouse;
use App\Models\Product_Warehouse;
use App\Models\Product;
use App\Models\Adjustment;
use App\Models\ProductAdjustment;
use DB;
use App\Models\StockCount;
use App\Models\ProductVariant;
use App\Models\ProductPurchase;
use Auth;
use Spatie\Permission\Models\Role;
use Spatie\Permission\Models\Permission;
use App\Services\JournalService;
use App\Models\Rack;
use Illuminate\Validation\ValidationException;

class AdjustmentController extends Controller
{
    /**
     * Rak is only made mandatory per line when the target warehouse actually
     * has racks set up (Warehouse > Kelola Rak). A gudang/toko that never
     * uses racks must not be forced to pick one - only warehouses that do
     * use racks require every adjustment line to specify which rack.
     */
    private function validateRackRequirement(array $data)
    {
        $warehouseId = $data['warehouse_id'] ?? null;
        if (!$warehouseId) {
            return;
        }
        $warehouseUsesRacks = Rack::where(['warehouse_id' => $warehouseId, 'is_active' => true])->exists();
        if (!$warehouseUsesRacks) {
            return;
        }
        $rackIds = $data['rack_id'] ?? [];
        $productIds = $data['product_id'] ?? [];
        foreach ($productIds as $key => $proId) {
            if (empty($rackIds[$key])) {
                throw ValidationException::withMessages([
                    'rack_id' => ['Gudang/toko ini menggunakan rak - pilih rak untuk setiap barang di tabel penyesuaian.'],
                ]);
            }
        }
    }

    private function adjustmentWarehouseRow($productId, $warehouseId, $variantId = null, $rackId = null)
    {
        $query = Product_Warehouse::where([
            ['product_id', $productId],
            ['warehouse_id', $warehouseId],
        ]);
        if($variantId)
            $query->where('variant_id', $variantId);
        else
            $query->whereNull('variant_id');

        $row = $query->first();
        if($row)
            return $row;

        return Product_Warehouse::create([
            'product_id' => $productId,
            'variant_id' => $variantId,
            'warehouse_id' => $warehouseId,
            'rack_id' => $rackId,
            'qty' => 0,
        ]);
    }
    /**
     * Post (or re-post) the "Selisih Stok" journal entry for a stock
     * adjustment batch. Nets every line's (qty * unit_cost): lines with
     * action '-' (physical count lower than system => loss) increase the
     * net loss, lines with action '+' (physical count higher => gain)
     * decrease it.
     * Net loss  => Dr Selisih Stok Warehouse / Cr Persediaan Warehouse
     * Net gain  => Dr Persediaan Warehouse   / Cr Selisih Stok Warehouse
     */
    private function postAdjustmentJournal($adjustmentId)
    {
        JournalService::reverseForReference('adjustment', $adjustmentId);

        $lines = ProductAdjustment::where('adjustment_id', $adjustmentId)->get();
        $netLoss = 0;
        foreach ($lines as $line) {
            $value = (float) $line->qty * (float) $line->unit_cost;
            $netLoss += ($line->action == '-') ? $value : -$value;
        }

        if (round($netLoss, 2) == 0) {
            return;
        }

        $lims_adjustment_data = Adjustment::find($adjustmentId);
        $journalDate = $lims_adjustment_data && $lims_adjustment_data->created_at
            ? date('Y-m-d', strtotime($lims_adjustment_data->created_at))
            : date('Y-m-d');
        $description = 'Penyesuaian Stok - ' . ($lims_adjustment_data ? $lims_adjustment_data->reference_no : $adjustmentId);

        $warehouseId = $lims_adjustment_data ? $lims_adjustment_data->warehouse_id : null;
        $selisihStokId = method_exists(JournalService::class, 'stockVarianceAccountIdForWarehouse')
            ? JournalService::stockVarianceAccountIdForWarehouse($warehouseId)
            : JournalService::accountIdByCode(JournalService::SELISIH_KASIR);
        $persediaanId = method_exists(JournalService::class, 'inventoryAccountIdForWarehouse')
            ? JournalService::inventoryAccountIdForWarehouse($warehouseId)
            : JournalService::accountIdByCode(JournalService::PERSEDIAAN);

        if ($netLoss > 0) {
            JournalService::postSimple($journalDate, $description, $selisihStokId, $persediaanId, $netLoss, 'adjustment', $adjustmentId, $description);
        }
        else {
            JournalService::postSimple($journalDate, $description, $persediaanId, $selisihStokId, abs($netLoss), 'adjustment', $adjustmentId, $description);
        }
    }
    public function index()
    {
        $role = Role::find(Auth::user()->role_id);
        if( $role->hasPermissionTo('adjustment') ) {
            /*if(Auth::user()->role_id > 2 && config('staff_access') == 'own')
                $lims_adjustment_all = Adjustment::orderBy('id', 'desc')->where('user_id', Auth::id())->get();
            else*/
                $lims_adjustment_all = Adjustment::orderBy('id', 'desc')->get();
            return view('backend.adjustment.index', compact('lims_adjustment_all'));
        }
        else
            return redirect()->back()->with('not_permitted', 'Sorry! You are not allowed to access this module');
    }

    public function getProduct($id)
    {
        // Kalau gudang/toko ini menggunakan rak, barang yang belum di-plan ke
        // rak (product_warehouse.rack_id masih kosong) TIDAK BOLEH muncul di
        // pool pencarian penyesuaian sama sekali - harus di-plan dulu lewat
        // menu Plan Toko/Plan Gudang sebelum bisa disesuaikan.
        $warehouseUsesRacks = Rack::where(['warehouse_id' => $id, 'is_active' => true])->exists();

        $lims_product_warehouse_data = DB::table('products')
                                    ->join('product_warehouse', 'products.id', '=', 'product_warehouse.product_id')
                                    ->leftJoin('racks', 'product_warehouse.rack_id', '=', 'racks.id')
                                    ->whereNull('products.is_variant')
                                    ->where([
                                        ['products.is_active', true],
                                        ['product_warehouse.warehouse_id', $id]
                                    ])
                                    ->when($warehouseUsesRacks, function($query) {
                                        $query->whereNotNull('product_warehouse.rack_id');
                                    })
                                    ->select('product_warehouse.qty', 'products.code', 'products.name', 'product_warehouse.product_id', 'products.cost', 'product_warehouse.rack_id', 'racks.name as rack_name')
                                    ->get();
        $lims_product_withVariant_warehouse_data = DB::table('products')
                                    ->join('product_warehouse', 'products.id', '=', 'product_warehouse.product_id')
                                    ->leftJoin('racks', 'product_warehouse.rack_id', '=', 'racks.id')
                                    ->whereNotNull('products.is_variant')
                                    ->where([
                                        ['products.is_active', true],
                                        ['product_warehouse.warehouse_id', $id]
                                    ])
                                    ->when($warehouseUsesRacks, function($query) {
                                        $query->whereNotNull('product_warehouse.rack_id');
                                    })
                                    ->select('products.name', 'product_warehouse.qty', 'product_warehouse.product_id', 'product_warehouse.variant_id', 'products.cost', 'product_warehouse.rack_id', 'racks.name as rack_name')
                                    ->get();
        $product_code = [];
        $product_name = [];
        $product_qty = [];
        $product_cost = [];
        $product_rack_id = [];
        $product_rack_name = [];
        $product_data = [];
        foreach ($lims_product_warehouse_data as $product_warehouse)
        {
            $product_qty[] = $product_warehouse->qty;
            $product_code[] =  $product_warehouse->code;
            $product_name[] = $product_warehouse->name;
            $product_rack_id[] = $product_warehouse->rack_id;
            $product_rack_name[] = $product_warehouse->rack_name;
            $query = array(
                    'SUM(qty) AS total_qty',
                    'SUM(total) AS total_cost'
                );
            $product_purchase_data = ProductPurchase::join('purchases', 'product_purchases.purchase_id', '=', 'purchases.id')
                                    ->where([
                                        ['product_id', $product_warehouse->product_id],
                                        ['warehouse_id', $id]
                                    ])->selectRaw(implode(',', $query))->get();
            if(count($product_purchase_data) && $product_purchase_data[0]->total_qty > 0)
                $product_cost[] = $product_purchase_data[0]->total_cost / $product_purchase_data[0]->total_qty;
            else
                $product_cost[] = $product_warehouse->cost;
        }

        foreach ($lims_product_withVariant_warehouse_data as $product_warehouse)
        {
            $product_variant = ProductVariant::select('item_code')->FindExactProduct($product_warehouse->product_id, $product_warehouse->variant_id)->first();
            if($product_variant) {
                $product_qty[] = $product_warehouse->qty;
                $product_code[] =  $product_variant->item_code;
                $product_name[] = $product_warehouse->name;
                $product_rack_id[] = $product_warehouse->rack_id;
                $product_rack_name[] = $product_warehouse->rack_name;
                $query = array(
                    'SUM(qty) AS total_qty',
                    'SUM(total) AS total_cost'
                );
                $product_purchase_data = ProductPurchase::join('purchases', 'product_purchases.purchase_id', '=', 'purchases.id')
                                        ->where([
                                            ['product_id', $product_warehouse->product_id],
                                            ['variant_id', $product_warehouse->variant_id],
                                            ['warehouse_id', $id]
                                        ])->selectRaw(implode(',', $query))->get();
                if(count($product_purchase_data) && $product_purchase_data[0]->total_qty > 0)
                    $product_cost[] = $product_purchase_data[0]->total_cost / $product_purchase_data[0]->total_qty;
                else
                    $product_cost[] = $product_warehouse->cost;
                }
        }

        $product_data[] = $product_code;
        $product_data[] = $product_name;
        $product_data[] = $product_qty;
        $product_data[] = $product_cost;
        $product_data[] = $product_rack_id;
        $product_data[] = $product_rack_name;
        return $product_data;
    }

    public function productSuggestions(Request $request)
    {
        $warehouse_id = $request->input('warehouse_id');
        $term = trim($request->input('term', ''));
        if (!$warehouse_id || $term === '') {
            return response()->json([]);
        }

        $product_data = $this->getProduct($warehouse_id);
        $codes = $product_data[0] ?? [];
        $names = $product_data[1] ?? [];
        $costs = $product_data[3] ?? [];
        $suggestions = [];
        foreach ($codes as $index => $code) {
            $name = $names[$index] ?? '';
            $item = $code . ' (' . $name . ')|' . ($costs[$index] ?? 0);
            if (stripos($code, $term) !== false || stripos($name, $term) !== false || stripos($item, $term) !== false) {
                $suggestions[] = $item;
            }
            if (count($suggestions) >= 20) {
                break;
            }
        }

        return response()->json($suggestions);
    }

    public function limsProductSearch(Request $request)
    {
        $product_code = explode("(", $request['data']);
        $product_info = explode("|", $request['data']);
        $product_code[0] = rtrim($product_code[0], " ");
        $lims_product_data = Product::where([
            ['code', $product_code[0]],
            ['is_active', true]
        ])->first();
        if(!$lims_product_data) {
            $lims_product_data = Product::join('product_variants', 'products.id', 'product_variants.product_id')
                ->select('products.id', 'products.name', 'products.is_variant', 'product_variants.id as product_variant_id', 'product_variants.item_code')
                ->where([
                    ['product_variants.item_code', $product_code[0]],
                    ['products.is_active', true]
                ])->first();
        }

        $product[] = $lims_product_data->name;
        $product_variant_id = null;
        if($lims_product_data->is_variant) {
            $product[] = $lims_product_data->item_code;
            $product_variant_id = $lims_product_data->product_variant_id;
        }
        else
            $product[] = $lims_product_data->code;

        $product[] = $lims_product_data->id;
        $product[] = $product_variant_id;
        $product[] = $product_info[1];

        // Stok sistem diambil LANGSUNG dari product_warehouse untuk gudang/toko
        // yang sedang dipilih, bukan dari array yang di-cache di browser. Tanpa
        // ini, array lama (dari gudang/toko yang sebelumnya dipilih) bisa
        // terbawa dan stok awal toko lain ikut terbaca. index 5 = qty,
        // 6 = rack_id, 7 = rack_name.
        $warehouse_id = $request->input('warehouse_id');
        $current_qty = 0;
        $current_rack_id = null;
        $current_rack_name = null;
        if ($warehouse_id) {
            $pwQuery = DB::table('product_warehouse')
                ->leftJoin('racks', 'product_warehouse.rack_id', '=', 'racks.id')
                ->where('product_warehouse.product_id', $lims_product_data->id)
                ->where('product_warehouse.warehouse_id', $warehouse_id);

            if ($lims_product_data->is_variant) {
                $variant_row = ProductVariant::where('product_id', $lims_product_data->id)
                    ->where('item_code', $product_code[0])->first();
                if ($variant_row)
                    $pwQuery->where('product_warehouse.variant_id', $variant_row->variant_id);
            }
            else {
                $pwQuery->whereNull('product_warehouse.variant_id');
            }

            $pw = $pwQuery->select('product_warehouse.qty', 'product_warehouse.rack_id', 'racks.name as rack_name')->first();
            if ($pw) {
                $current_qty = $pw->qty;
                $current_rack_id = $pw->rack_id;
                $current_rack_name = $pw->rack_name;
            }
        }
        $product[] = $current_qty;
        $product[] = $current_rack_id;
        $product[] = $current_rack_name;
        $product[] = $warehouse_id;

        return $product;
    }

    public function create()
    {
        $lims_warehouse_list = Warehouse::where('is_active', true)->get();
        return view('backend.adjustment.create', compact('lims_warehouse_list'));
    }

    public function store(Request $request)
    {
        $data = $request->except('document');
        $this->validateRackRequirement($data);
        //return $data;
        if( isset($data['stock_count_id']) ){
            $lims_stock_count_data = StockCount::find($data['stock_count_id']);
            $lims_stock_count_data->is_adjusted = true;
            $lims_stock_count_data->save();
        }
        $data['reference_no'] = 'adr-' . date("Ymd") . '-'. date("his");
        $document = $request->document;
        if ($document) {
            $documentName = $document->getClientOriginalName();
            $document->move('public/documents/adjustment', $documentName);
            $data['document'] = $documentName;
        }
        $lims_adjustment_data = Adjustment::create($data);

        $product_id = $data['product_id'];
        $product_code = $data['product_code'];
        $qty = $data['qty'];
        $unit_cost = $data['unit_cost'];
        $action = $data['action'];
        $rack_id = $data['rack_id'] ?? [];

        foreach ($product_id as $key => $pro_id) {
            $lims_product_data = Product::find($pro_id);
            if($lims_product_data->is_variant) {
                $lims_product_variant_data = ProductVariant::select('id', 'variant_id', 'qty')->FindExactProductWithCode($pro_id, $product_code[$key])->first();
                $lims_product_warehouse_data = $this->adjustmentWarehouseRow($pro_id, $data['warehouse_id'], $lims_product_variant_data->variant_id, $rack_id[$key] ?? null);

                if($action[$key] == '-'){
                    $lims_product_variant_data->qty -= $qty[$key];
                }
                elseif($action[$key] == '+'){
                    $lims_product_variant_data->qty += $qty[$key];
                }
                $lims_product_variant_data->save();
                $variant_id = $lims_product_variant_data->variant_id;
            }
            else {
                $lims_product_warehouse_data = $this->adjustmentWarehouseRow($pro_id, $data['warehouse_id'], null, $rack_id[$key] ?? null);
                $variant_id = null;
            }

            if($action[$key] == '-') {
                $lims_product_data->qty -= $qty[$key];
                $lims_product_warehouse_data->qty -= $qty[$key];
            }
            elseif($action[$key] == '+') {
                $lims_product_data->qty += $qty[$key];
                $lims_product_warehouse_data->qty += $qty[$key];
            }
            $lims_product_data->save();
            if(!empty($rack_id[$key])) {
                $lims_product_warehouse_data->rack_id = $rack_id[$key];
            }
            $lims_product_warehouse_data->save();

            $product_adjustment['product_id'] = $pro_id;
            $product_adjustment['variant_id'] = $variant_id;
            $product_adjustment['rack_id'] = $rack_id[$key] ?? null;
            $product_adjustment['adjustment_id'] = $lims_adjustment_data->id;
            $product_adjustment['qty'] = $qty[$key];
            $product_adjustment['unit_cost'] = $unit_cost[$key];
            $product_adjustment['action'] = $action[$key];
            ProductAdjustment::create($product_adjustment);
        }
        $this->postAdjustmentJournal($lims_adjustment_data->id);
        return redirect('qty_adjustment')->with('message', 'Data inserted successfully');
    }

    public function edit($id)
    {
        $lims_adjustment_data = Adjustment::find($id);
        $lims_product_adjustment_data = ProductAdjustment::where('adjustment_id', $id)->get();
        $lims_warehouse_list = Warehouse::where('is_active', true)->get();
        return view('backend.adjustment.edit', compact('lims_adjustment_data', 'lims_warehouse_list', 'lims_product_adjustment_data'));
    }

    public function update(Request $request, $id)
    {
        $data = $request->except('document');
        $this->validateRackRequirement($data);
        $lims_adjustment_data = Adjustment::find($id);

        $document = $request->document;
        if ($document) {
            $this->fileDelete('documents/adjustment/', $lims_adjustment_data->document);

            $documentName = $document->getClientOriginalName();
            $document->move('public/documents/adjustment', $documentName);
            $data['document'] = $documentName;
        }

        $lims_adjustment_data = Adjustment::find($id);
        $lims_product_adjustment_data = ProductAdjustment::where('adjustment_id', $id)->get();
        $product_id = $data['product_id'];
        $product_variant_id = $data['product_variant_id'];
        $product_code = $data['product_code'];
        $qty = $data['qty'];
        $unit_cost = $data['unit_cost'];
        $action = $data['action'];
        $rack_id = $data['rack_id'] ?? [];
        $old_product_variant_id = [];
        foreach ($lims_product_adjustment_data as $key => $product_adjustment_data) {
            $old_product_id[] = $product_adjustment_data->product_id;
            $lims_product_data = Product::find($product_adjustment_data->product_id);
            if($product_adjustment_data->variant_id) {
                $lims_product_variant_data = ProductVariant::where([
                    ['product_id', $product_adjustment_data->product_id],
                    ['variant_id', $product_adjustment_data->variant_id]
                ])->first();
                $old_product_variant_id[$key] = $lims_product_variant_data->id;

                if($product_adjustment_data->action == '-') {
                    $lims_product_variant_data->qty += $product_adjustment_data->qty;
                }
                elseif($product_adjustment_data->action == '+') {
                    $lims_product_variant_data->qty -= $product_adjustment_data->qty;
                }
                $lims_product_variant_data->save();
                $lims_product_warehouse_data = Product_Warehouse::where([
                    ['product_id', $product_adjustment_data->product_id],
                    ['variant_id', $product_adjustment_data->variant_id],
                    ['warehouse_id', $lims_adjustment_data->warehouse_id]
                ])->first();
            }
            else {
                $lims_product_warehouse_data = Product_Warehouse::where([
                        ['product_id', $product_adjustment_data->product_id],
                        ['warehouse_id', $lims_adjustment_data->warehouse_id]
                    ])->first();
            }
            if($product_adjustment_data->action == '-'){
                $lims_product_data->qty += $product_adjustment_data->qty;
                $lims_product_warehouse_data->qty += $product_adjustment_data->qty;
            }
            elseif($product_adjustment_data->action == '+'){
                $lims_product_data->qty -= $product_adjustment_data->qty;
                $lims_product_warehouse_data->qty -= $product_adjustment_data->qty;
            }
            $lims_product_data->save();
            $lims_product_warehouse_data->save();

            if($product_adjustment_data->variant_id && !(in_array($old_product_variant_id[$key], $product_variant_id)) ){
                $product_adjustment_data->delete();
            }
            elseif( !(in_array($old_product_id[$key], $product_id)) )
                $product_adjustment_data->delete();
        }

        foreach ($product_id as $key => $pro_id) {
            $lims_product_data = Product::find($pro_id);
            if($lims_product_data->is_variant) {
                $lims_product_variant_data = ProductVariant::select('id', 'variant_id', 'qty')->FindExactProductWithCode($pro_id, $product_code[$key])->first();
                $lims_product_warehouse_data = $this->adjustmentWarehouseRow($pro_id, $data['warehouse_id'], $lims_product_variant_data->variant_id, $rack_id[$key] ?? null);
                //return $action[$key];

                if($action[$key] == '-'){
                    $lims_product_variant_data->qty -= $qty[$key];
                }
                elseif($action[$key] == '+'){
                    $lims_product_variant_data->qty += $qty[$key];
                }
                $lims_product_variant_data->save();
                $variant_id = $lims_product_variant_data->variant_id;
            }
            else {
                $lims_product_warehouse_data = $this->adjustmentWarehouseRow($pro_id, $data['warehouse_id'], null, $rack_id[$key] ?? null);
                $variant_id = null;
            }

            if($action[$key] == '-'){
                $lims_product_data->qty -= $qty[$key];
                $lims_product_warehouse_data->qty -= $qty[$key];
            }
            elseif($action[$key] == '+'){
                $lims_product_data->qty += $qty[$key];
                $lims_product_warehouse_data->qty += $qty[$key];
            }
            $lims_product_data->save();
            if(!empty($rack_id[$key])) {
                $lims_product_warehouse_data->rack_id = $rack_id[$key];
            }
            $lims_product_warehouse_data->save();

            $product_adjustment['product_id'] = $pro_id;
            $product_adjustment['variant_id'] = $variant_id;
            $product_adjustment['rack_id'] = $rack_id[$key] ?? null;
            $product_adjustment['adjustment_id'] = $id;
            $product_adjustment['qty'] = $qty[$key];
            $product_adjustment['unit_cost'] = $unit_cost[$key];
            $product_adjustment['action'] = $action[$key];

            if($product_adjustment['variant_id'] && in_array($product_variant_id[$key], $old_product_variant_id)) {
                ProductAdjustment::where([
                    ['product_id', $pro_id],
                    ['variant_id', $product_adjustment['variant_id']],
                    ['adjustment_id', $id]
                ])->update($product_adjustment);
            }
            elseif( $product_adjustment['variant_id'] === null && in_array($pro_id, $old_product_id) ){
                ProductAdjustment::where([
                ['adjustment_id', $id],
                ['product_id', $pro_id]
                ])->update($product_adjustment);
            }
            else
                ProductAdjustment::create($product_adjustment);
        }
        $lims_adjustment_data->update($data);
        $this->postAdjustmentJournal($id);
        return redirect('qty_adjustment')->with('message', 'Data updated successfully');
    }

    public function deleteBySelection(Request $request)
    {
        $adjustment_id = $request['adjustmentIdArray'];
        foreach ($adjustment_id as $id) {
            $lims_adjustment_data = Adjustment::find($id);
            $this->fileDelete('documents/adjustment/', $lims_adjustment_data->document);
            JournalService::reverseForReference('adjustment', $id);

            $lims_product_adjustment_data = ProductAdjustment::where('adjustment_id', $id)->get();
            foreach ($lims_product_adjustment_data as $key => $product_adjustment_data) {
                $lims_product_data = Product::find($product_adjustment_data->product_id);
                if($product_adjustment_data->variant_id) {
                    $lims_product_variant_data = ProductVariant::select('id', 'qty')->FindExactProduct($product_adjustment_data->product_id, $product_adjustment_data->variant_id)->first();
                    $lims_product_warehouse_data = Product_Warehouse::where([
                            ['product_id', $product_adjustment_data->product_id],
                            ['variant_id', $product_adjustment_data->variant_id],
                            ['warehouse_id', $lims_adjustment_data->warehouse_id]
                        ])->first();
                    if($product_adjustment_data->action == '-'){
                        $lims_product_variant_data->qty += $product_adjustment_data->qty;
                    }
                    elseif($product_adjustment_data->action == '+'){
                        $lims_product_variant_data->qty -= $product_adjustment_data->qty;
                    }
                    $lims_product_variant_data->save();
                }
                else {
                    $lims_product_warehouse_data = Product_Warehouse::where([
                            ['product_id', $product_adjustment_data->product_id],
                            ['warehouse_id', $lims_adjustment_data->warehouse_id]
                        ])->first();
                }
                if($product_adjustment_data->action == '-'){
                    $lims_product_data->qty += $product_adjustment_data->qty;
                    $lims_product_warehouse_data->qty += $product_adjustment_data->qty;
                }
                elseif($product_adjustment_data->action == '+'){
                    $lims_product_data->qty -= $product_adjustment_data->qty;
                    $lims_product_warehouse_data->qty -= $product_adjustment_data->qty;
                }
                $lims_product_data->save();
                $lims_product_warehouse_data->save();
                $product_adjustment_data->delete();
            }
            $lims_adjustment_data->delete();
        }
        return 'Data deleted successfully';
    }

    public function destroy($id)
    {
        $lims_adjustment_data = Adjustment::find($id);
        JournalService::reverseForReference('adjustment', $id);
        $lims_product_adjustment_data = ProductAdjustment::where('adjustment_id', $id)->get();
        foreach ($lims_product_adjustment_data as $key => $product_adjustment_data) {
            $lims_product_data = Product::find($product_adjustment_data->product_id);
            if($product_adjustment_data->variant_id) {
                $lims_product_variant_data = ProductVariant::select('id', 'qty')->FindExactProduct($product_adjustment_data->product_id, $product_adjustment_data->variant_id)->first();
                $lims_product_warehouse_data = Product_Warehouse::where([
                        ['product_id', $product_adjustment_data->product_id],
                        ['variant_id', $product_adjustment_data->variant_id],
                        ['warehouse_id', $lims_adjustment_data->warehouse_id]
                    ])->first();
                if($product_adjustment_data->action == '-'){
                    $lims_product_variant_data->qty += $product_adjustment_data->qty;
                }
                elseif($product_adjustment_data->action == '+'){
                    $lims_product_variant_data->qty -= $product_adjustment_data->qty;
                }
                $lims_product_variant_data->save();
            }
            else {
                $lims_product_warehouse_data = Product_Warehouse::where([
                        ['product_id', $product_adjustment_data->product_id],
                        ['warehouse_id', $lims_adjustment_data->warehouse_id]
                    ])->first();
            }
            if($product_adjustment_data->action == '-'){
                $lims_product_data->qty += $product_adjustment_data->qty;
                $lims_product_warehouse_data->qty += $product_adjustment_data->qty;
            }
            elseif($product_adjustment_data->action == '+'){
                $lims_product_data->qty -= $product_adjustment_data->qty;
                $lims_product_warehouse_data->qty -= $product_adjustment_data->qty;
            }
            $lims_product_data->save();
            $lims_product_warehouse_data->save();
            $product_adjustment_data->delete();
        }
        $lims_adjustment_data->delete();
        $this->fileDelete('documents/adjustment/', $lims_adjustment_data->document);

        return redirect('qty_adjustment')->with('not_permitted', 'Data deleted successfully');
    }
}