Kent-logistics-Laravel/app/Http/Controllers/Admin/AdminInvoiceController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\Invoice;
use App\Models\InvoiceItem;
use App\Models\InvoiceInstallment;
use App\Models\InvoiceChargeGroup;
use App\Models\InvoiceChargeGroupItem;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Log;
use Mpdf\Mpdf;

class AdminInvoiceController extends Controller
{
    // -------------------------------------------------------------
    // INVOICE LIST PAGE
    // -------------------------------------------------------------
    public function index(Request $request)
    {
        $query = Invoice::with(['items', 'customer', 'container']);

        if ($request->filled('search')) {
            $search = $request->search;
            $query->where(function ($q) use ($search) {
                $q->where('invoice_number', 'like', "%{$search}%")
                    ->orWhere('customer_name', 'like', "%{$search}%");
            });
        }

        if ($request->filled('status') && $request->status !== 'all') {
            $query->where('status', $request->status);
        }

        if ($request->filled('start_date')) {
            $query->whereDate('invoice_date', '>=', $request->start_date);
        }

        if ($request->filled('end_date')) {
            $query->whereDate('invoice_date', '<=', $request->end_date);
        }

        $invoices = $query->latest()->get();

        return view('admin.invoice', compact('invoices'));
    }

    // -------------------------------------------------------------
    // POPUP VIEW
    // -------------------------------------------------------------
    public function popup($id)
    {
        $invoice = Invoice::with([
            'items',
            'chargeGroups.items',
        ])->findOrFail($id);

        // demo update असेल तर
        $invoice->update([
            'customer_email'   => 'test@demo.com',
            'customer_address' => 'TEST ADDRESS',
            'pincode'          => '999999',
        ]);

        $shipment = null;

        $groupedItemIds = $invoice->chargeGroups
            ->flatMap(fn($group) => $group->items->pluck('invoice_item_id'))
            ->unique()
            ->values()
            ->toArray();

        return view('admin.popup_invoice', compact('invoice', 'shipment', 'groupedItemIds'));
    }

    // -------------------------------------------------------------
    // EDIT INVOICE PAGE
    // -------------------------------------------------------------
    public function edit($id)
    {
        $invoice = Invoice::with([
            'items',
            'customer',
            'container',
            'chargeGroups.items',
            'installments',
        ])->findOrFail($id);

        $shipment = null;

        $groupedItemIds = $invoice->chargeGroups
            ->flatMap(function ($group) {
                return $group->items->pluck('invoice_item_id');
            })
            ->unique()
            ->values()
            ->toArray();

        return view('admin.invoice_edit', compact('invoice', 'shipment', 'groupedItemIds'));
    }

    // -------------------------------------------------------------
    // UPDATE INVOICE (HEADER ONLY)
    // -------------------------------------------------------------
    public function update(Request $request, $id)
    {
        Log::info('🟡 Invoice Update Request Received', [
            'invoice_id' => $id,
            'request'    => $request->all(),
        ]);

        $invoice = Invoice::findOrFail($id);

        $data = $request->validate([
            'invoice_date' => 'required|date',
            'due_date'     => 'required|date|after_or_equal:invoice_date',
            'status'       => 'required|in:pending,paid,overdue',
            'notes'        => 'nullable|string',
        ]);

        Log::info('✅ Validated Invoice Header Update Data', $data);

        $invoice->update($data);
        $invoice->refresh();

        Log::info('🔍 Invoice AFTER HEADER UPDATE', [
            'invoice_id'              => $invoice->id,
            'charge_groups_total'     => $invoice->charge_groups_total,
            'gst_amount'              => $invoice->gst_amount,
            'grand_total_with_charges'=> $invoice->grand_total_with_charges,
        ]);

        $this->generateInvoicePDF($invoice);

        return redirect()
            ->route('admin.invoices.index')
            ->with('success', 'Invoice updated & PDF generated successfully.');
    }

    // -------------------------------------------------------------
    // UPDATE INVOICE ITEMS (फक्त items save)
    // -------------------------------------------------------------
    public function updateItems(Request $request, Invoice $invoice)
    {
        Log::info('🟡 Invoice Items Update Request', [
            'invoice_id' => $invoice->id,
            'payload'    => $request->all(),
        ]);

        $data = $request->validate([
            'items'              => ['required', 'array'],
            'items.*.price'      => ['required', 'numeric', 'min:0'],
            'items.*.ttl_amount' => ['required', 'numeric', 'min:0'],
        ]);

        foreach ($data['items'] as $itemId => $itemData) {
            $item = InvoiceItem::where('id', $itemId)
                ->where('invoice_id', $invoice->id)
                ->first();

            if (!$item) {
                Log::warning('Invoice item not found or mismatched invoice', [
                    'invoice_id' => $invoice->id,
                    'item_id'    => $itemId,
                ]);
                continue;
            }

            $item->price      = $itemData['price'];
            $item->ttl_amount = $itemData['ttl_amount'];
            $item->save();
        }

        Log::info('✅ Invoice items updated (no totals recalculation)', [
            'invoice_id' => $invoice->id,
        ]);

        return back()->with('success', 'Invoice items updated successfully.');
    }

    // -------------------------------------------------------------
    // PDF GENERATION
    // -------------------------------------------------------------
    public function generateInvoicePDF($invoice)
    {
        $invoice->load(['items', 'customer', 'container']);
        $shipment = null;

        $fileName = 'invoice-' . $invoice->invoice_number . '.pdf';
        $folder   = public_path('invoices/');

        if (!file_exists($folder)) {
            mkdir($folder, 0777, true);
        }

        $filePath = $folder . $fileName;

        if (file_exists($filePath)) {
            unlink($filePath);
        }

        $mpdf = new Mpdf([
            'mode'         => 'utf-8',
            'format'       => 'A4',
            'default_font' => 'sans-serif',
        ]);

        $html = view('admin.pdf.invoice', [
            'invoice'  => $invoice,
            'shipment' => $shipment,
        ])->render();

        $mpdf->WriteHTML($html);
        $mpdf->Output($filePath, 'F');

        $invoice->update(['pdf_path' => 'invoices/' . $fileName]);
    }

    // -------------------------------------------------------------
    // INSTALLMENTS (ADD)
    // -------------------------------------------------------------
    public function storeInstallment(Request $request, $invoice_id)
    {
        $request->validate([
            'installment_date' => 'required|date',
            'payment_method'   => 'required|string',
            'reference_no'     => 'nullable|string',
            'amount'           => 'required|numeric|min:1',
        ]);

        $invoice = Invoice::findOrFail($invoice_id);

        $grandTotal = $invoice->grand_total_with_charges ?? 0;

        $paidTotal = $invoice->installments()->sum('amount');
        $remaining = $grandTotal - $paidTotal;

        if ($request->amount > $remaining) {
            return response()->json([
                'status'  => 'error',
                'message' => 'Installment amount exceeds remaining balance.',
            ], 422);
        }

        $installment = InvoiceInstallment::create([
            'invoice_id'       => $invoice_id,
            'installment_date' => $request->installment_date,
            'payment_method'   => $request->payment_method,
            'reference_no'     => $request->reference_no,
            'amount'           => $request->amount,
        ]);

        $newPaid   = $paidTotal + $request->amount;
        $remaining = max(0, $grandTotal - $newPaid);

        if ($newPaid >= $grandTotal && $grandTotal > 0) {
            $invoice->update(['status' => 'paid']);
        }

        return response()->json([
            'status'            => 'success',
            'message'           => 'Installment added successfully.',
            'installment'       => $installment,
            'chargeGroupsTotal' => $invoice->charge_groups_total ?? 0,
            'gstAmount'         => $invoice->gst_amount ?? 0,
            'grandTotal'        => $grandTotal,
            'totalPaid'         => $newPaid,
            'remaining'         => $remaining,
            'isCompleted'       => $remaining <= 0,
            'isZero'            => $newPaid == 0,
        ]);
    }

    // -------------------------------------------------------------
    // INSTALLMENTS (DELETE)
    // -------------------------------------------------------------
    public function deleteInstallment($id)
    {
        $installment = InvoiceInstallment::findOrFail($id);
        $invoice     = $installment->invoice;

        $installment->delete();
        $invoice->refresh();

        $grandTotal = $invoice->grand_total_with_charges ?? 0;

        $paidTotal = $invoice->installments()->sum('amount');
        $remaining = max(0, $grandTotal - $paidTotal);

        if ($paidTotal <= 0 && $grandTotal > 0) {
            $invoice->update(['status' => 'pending']);
        } elseif ($paidTotal > 0 && $paidTotal < $grandTotal) {
            $invoice->update(['status' => 'pending']);
        }

        return response()->json([
            'status'            => 'success',
            'message'           => 'Installment deleted.',
            'chargeGroupsTotal' => $invoice->charge_groups_total ?? 0,
            'gstAmount'         => $invoice->gst_amount ?? 0,
            'grandTotal'        => $grandTotal,
            'totalPaid'         => $paidTotal,
            'remaining'         => $remaining,
            'isZero'            => $paidTotal == 0,
        ]);
    }

    // -------------------------------------------------------------
    // CHARGE GROUP SAVE
    // -------------------------------------------------------------
    public function storeChargeGroup(Request $request, $invoiceId)
    {
        Log::info('🟡 storeChargeGroup HIT', [
            'invoice_id' => $invoiceId,
            'payload'    => $request->all(),
        ]);
    
        $invoice = Invoice::with('items', 'chargeGroups')->findOrFail($invoiceId);
    
        $data = $request->validate([
            'groupname'      => 'required|string|max:255',
            'basistype'      => 'required|in:ttl_qty,amount,ttl_cbm,ttl_kg',
            'basisvalue'     => 'required|numeric',
            'rate'           => 'required|numeric|min:0.0001',
            'autototal'      => 'required|numeric|min:0.01',
            'itemids'        => 'required|array',
            'itemids.*'      => 'integer|exists:invoice_items,id',
    
            'tax_type'       => 'nullable|in:none,gst,igst',
            'gst_percent'    => 'nullable|numeric|min:0|max:28',
            'total_with_gst' => 'nullable|numeric|min:0',
        ]);
    
        Log::info('✅ storeChargeGroup VALIDATED', $data);
    
        // duplicate name check
        $exists = InvoiceChargeGroup::where('invoice_id', $invoice->id)
            ->where('group_name', $data['groupname'])
            ->exists();
    
        if ($exists) {
            return back()
                ->withErrors(['groupname' => 'This group name is already used for this invoice.'])
                ->withInput();
        }
    
        $taxType    = $data['tax_type']    ?? 'gst';
        $gstPercent = $data['gst_percent'] ?? 0;
        $baseTotal  = $data['autototal'];
    
        $totalWithGst = $data['total_with_gst'] ?? $baseTotal;
        if ($totalWithGst == 0 && $gstPercent > 0) {
            $gstAmount    = ($baseTotal * $gstPercent) / 100;
            $totalWithGst = $baseTotal + $gstAmount;
        }
    
        // 1) Group create
        $group = InvoiceChargeGroup::create([
            'invoice_id'     => $invoice->id,
            'group_name'     => $data['groupname'],
            'basis_type'     => $data['basistype'],
            'basis_value'    => $data['basisvalue'],
            'rate'           => $data['rate'],
            'total_charge'   => $baseTotal,
            'tax_type'       => $taxType,
            'gst_percent'    => $gstPercent,
            'total_with_gst' => $totalWithGst,
        ]);
    
        // 2) Items link
        foreach ($data['itemids'] as $itemId) {
            InvoiceChargeGroupItem::create([
                'group_id'        => $group->id,
                'invoice_item_id' => $itemId,
            ]);
        }
    
        // 3) सर्व groups वरून invoice level totals
        $invoice->load('chargeGroups');
    
        $chargeGroupsBase  = $invoice->chargeGroups->sum('total_charge');      // base
        $chargeGroupsWithG = $invoice->chargeGroups->sum('total_with_gst');    // base + gst
        $chargeGroupsGst   = $chargeGroupsWithG - $chargeGroupsBase;           // gst only
    
        $invoiceGstPercent = $group->gst_percent ?? 0;
        $invoiceTaxType    = $group->tax_type    ?? 'gst';
    
        $cgstPercent = 0;
        $sgstPercent = 0;
        $igstPercent = 0;
    
        if ($invoiceTaxType === 'gst') {
            $cgstPercent = $invoiceGstPercent / 2;
            $sgstPercent = $invoiceGstPercent / 2;
        } elseif ($invoiceTaxType === 'igst') {
            $igstPercent = $invoiceGstPercent;
        }
    
        // 🔴 इथे main fix:
        // final_amount      = base (total_charge sum)
        // final_amount_with_gst = base + gst (total_with_gst sum)
        // grand_total_with_charges = final_amount_with_gst (same)
        $invoice->update([
            'charge_groups_total'      => $chargeGroupsBase,
            'gst_amount'               => $chargeGroupsGst,
            'gst_percent'              => $invoiceGstPercent,
            'tax_type'                 => $invoiceTaxType,
            'cgst_percent'             => $cgstPercent,
            'sgst_percent'             => $sgstPercent,
            'igst_percent'             => $igstPercent,
    
            'final_amount'             => $chargeGroupsBase,
            'final_amount_with_gst'    => $chargeGroupsWithG,
            'grand_total_with_charges' => $chargeGroupsWithG,
        ]);
    
        Log::info('✅ Invoice updated from Charge Group (CG total + GST)', [
            'invoice_id'              => $invoice->id,
            'charge_groups_total'     => $chargeGroupsBase,
            'gst_amount'              => $chargeGroupsGst,
            'gst_percent'             => $invoiceGstPercent,
            'tax_type'                => $invoiceTaxType,
            'cgst_percent'            => $cgstPercent,
            'sgst_percent'            => $sgstPercent,
            'igst_percent'            => $igstPercent,
            'final_amount'            => $invoice->final_amount,
            'final_amount_with_gst'   => $invoice->final_amount_with_gst,
            'grand_total_with_charges'=> $invoice->grand_total_with_charges,
        ]);
    
       return response()->json([
            'success' => true,
            'message' => 'Charge group saved successfully.',
            'group_id' => $group->id,
        ]);
    }
}