@extends('layouts.app')

@section('content')
<style>
    .table-bordered th,
    .table-bordered td {
        border: 2px solid black !important;
    }

    .table td,
    .table th {
        text-align: left;
        /* Default alignment for text */
    }

    .table td:nth-child(2),
    /* Rate column */
    .table td:nth-child(4),
    /* Total Cost column */
    .table td:last-child,
    .table th:nth-child(2),
    .table th:nth-child(4),
    .table th:last-child {
        text-align: right;
        /* Align numbers to the right */
    }


    @media print {
    .no-print {
        display: none !important;
    }
}



    .dropdown-row {
        display: flex;
        gap: 20px;
        flex-wrap: wrap;
        margin-bottom: 20px;
    }

    .dropdown-group {
        flex: 1;
        min-width: 200px;
    }

    .dropdown-group label {
        display: block;
        margin-bottom: 5px;
        font-weight: bold;
    }

    .dropdown-group select {
        width: 100%;
        padding: 6px;
        font-size: 14px;
    }
</style>

</style>
<button class="no-print" id="printBtn" style="padding: 10px 20px; background-color: #6a19db; color: white; border: none; cursor: pointer; margin-bottom: 20px;">
    Print TCO
</button>

<div class="container mt-4">
    <div class="no-print-section">
        <form id="saveBankForm">
            @csrf
            <input type="hidden" name="lead_id" value="{{ $lead->id }}">

            <div class="dropdown-row">
                <!-- Office Dropdown -->
                <div class="dropdown-group">
                    <label for="office_id">Select Office</label>
                    <select name="office_id" id="office_id" class="form-control" required>
                        <option value="">-- Choose Office --</option>
                        @foreach($my_offices as $my_office)
                        <option
                            value="{{ $my_office->id }}"
                            data-gstin="{{ $my_office->gstin }}"
                            data-address="{{ $my_office->address }}"
                            data-state="{{ $my_office->state->name }}"
                            {{ $lead->office_id == $my_office->id ? 'selected' : '' }}>
                            {{ $my_office->state->name }} - {{ $my_office->gstin }}
                        </option>
                        @endforeach
                    </select>
                </div>

                <!-- Bank Dropdown -->
                <div class="dropdown-group">
                    <label for="bank_detail_id">Select Bank</label>
                    <select name="bank_detail_id" id="bank_detail_id" class="form-control" required>
                        <option value="">-- Choose Bank --</option>
                        @foreach($banks as $bank)
                        <option
                            value="{{ $bank->id }}"
                            data-signatory="{{ $bank->authorised_signatory_name }}"
                            data-account-number="{{ $bank->account_number }}"
                            data-ifsc="{{ $bank->ifsc }}"
                            data-branch="{{ $bank->branch_details }}"
                            data-upi="{{ $bank->upi_details }}"
                            {{ $lead->bank_detail_id == $bank->id ? 'selected' : '' }}>
                            {{ $bank->account_type }} - {{ $bank->account_number }} ({{ $bank->branch_details }})
                        </option>
                        @endforeach
                    </select>
                </div>

                <!-- Warranty Dropdown -->
                <div class="dropdown-group">
                    <label for="warrantySelect">Select Warranty</label>
                    <select id="warrantySelect" name="warranty">
    <option value="0" {{ $lead->warranty == 0 ? 'selected' : '' }}>0 years</option>
    <option value="1" {{ $lead->warranty == 1 ? 'selected' : '' }}>1 year</option>
    <option value="2" {{ $lead->warranty == 2 ? 'selected' : '' }}>2 years</option>
    <option value="3" {{ $lead->warranty == 3 ? 'selected' : '' }}>3 years</option>
</select>
               </div>
            </div>

            <!-- Submit Button -->
            <button type="submit" class="btn btn-primary">Save Details</button>
        </form>
    </div>



    <h2 class="text-center mb-3">Technical Commercial Offer</h2>

    <table class="table table-bordered">
        <tr>
            {{-- <th>Project Estimate:</th>
                <th>{{ $projec->type }}</th>
            <th>{{ $project->category }}</th> --}}
            <th>Project Estimate:</th>
            <td>{{ $projectCapacity }}</td>

            <th>On-Grid</th>
            @php
            $project_cats = [1 => 'OnGrid', 2 => 'OffGrid', 3 => 'Hybrid'];
            @endphp
            <th>{{ $project_cats[$lead->project_cats_id] ?? 'Unknown' }}</th>

        </tr>
        <tr>
            <td colspan="2">
                <p><strong>Name:</strong> {{ $lead->site_name }}</p>
                <p><strong>Address:</strong> {{ $lead->address }}</p>
                <p><strong>City:</strong> {{ $lead->city }}, {{ $lead->state }}</p>
                <p><strong>Gst-In:</strong> {{ $lead->gstin }}</p>
            </td>
            <!-- <td colspan="2">
                
                GSTIN: 06ADAF56650N1ZQ<br><br>
                81 High Street Business Hub, Sector 81<br>
                Faridabad, Haryana 121006
            </td> -->
            @php
            $selectedGstin = $my_offices->firstWhere('id', $lead->office_id);
            @endphp

            <td colspan="2">
                <strong>Surjaa Enertech and Infra Corporation</strong><br><br>

                <!-- GSTIN dropdown (hide during print) -->


                <!-- Display selected GSTIN details -->
                <div id="selected-gstin-details" class="mt-2">
                    @if($selectedGstin)
                    <div class="form-group">
                        <strong>State:</strong> {{ $selectedGstin->state->name }}<br>
                        <strong>GSTIN:</strong> {{ $selectedGstin->gstin }}<br>
                        <strong>Address:</strong> {{ $selectedGstin->address }}
                    </div>
                    @endif
                </div>
            </td>

        </tr>
        <tr>
            <td colspan="4">
                <p><strong>Date:</strong> {{ now()->format('d/m/Y') }}</p>
            </td>
        </tr>
    </table>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Description</th>
                <th>Price per unit</th>
                <th>GST (in %)</th>
                <th>Quantity</th>
                <th>Total Cost</th>
            </tr>
        </thead>
        <tbody>
            @php
            $estimatedCost = 0;
            $gst12 = 0;
            $gst18 = 0;
            $gst28 = 0;
            @endphp

            @foreach ($bomItems as $item)
            @php
            $totalCost = $item->total_price;
            $estimatedCost += $totalCost;

            // GST Calculation
            if (in_array(strtolower($item->product->category->name), ['module', 'inverter'])) {
            $gst12 += $totalCost * 0.12;
            } elseif (in_array(strtolower($item->product->category->name), ['bos', 'structure', 'inc'])) {
            $gst18 += $totalCost * 0.18;
            } elseif (in_array(strtolower($item->product->category->name), ['battery','storage'])) {
            $gst28 += $totalCost * 0.28;
            }
            @endphp

            <tr>
                <td>{{ $item->product->name }} <br> {{ $item->product->description }}</td>
                <td>₹{{ number_format($item->final_price) }}</td>
                <td>{{$item->gst}}</td>
                <td>{{ $item->total_quantity }}</td>
                <td>₹{{ number_format($totalCost, 2) }}</td>
            </tr>
            @endforeach

            {{-- Total Row --}}
            <tr>
                <td colspan="4" class="text-start"><strong>Total Amount</strong></td>
                <td><strong>₹{{ number_format($estimatedCost, 2) }}</strong></td>
            </tr>
        </tbody>
    </table>


    <!-- Cost Breakdown Table -->
    <!-- <h4 class="text-center">Cost Breakdown</h4>
    <table class="table table-bordered">
        <tr>
            <th>Estimated Cost</th>
            <td>₹{{ number_format($estimatedCost, 2) }}</td>
        </tr>
        <tr>
            <th>GST (12%) for Modules & Inverters</th>
            <td>₹{{ number_format($gst12, 2) }}</td>
        </tr>
        <tr>
            <th>GST (18%) for BOS, Structure & INC</th>
            <td>₹{{ number_format($gst18, 2) }}</td>
        </tr>
        <tr>
            <th>GST (28%) for Battery & Storage</th>
            <td>₹{{ number_format($gst28, 2) }}</td>
        </tr>
        <tr class="table-light">
            <th>Total Amount</th>
            <td>₹{{ number_format($totalAmount = $estimatedCost + $gst12 + $gst18 + $gst28, 2) }}</td>
        </tr>
    </table> -->





    {{-- Bank Details Display --}}
    <div id="bankDetailsSection" class="mt-3" style="display: none;">
        <h4 class="mt-3 text-center">Bank Details</h4>
        <table class="table table-bordered" id="bankDetailsContent" style="margin-top: 15px;">
            <thead>
                <tr>
                    <th>Details</th>
                    <th>Information</th>
                </tr>
            </thead>
            <tbody></tbody>
        </table>

    </div>




    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  <script>
    document.addEventListener('DOMContentLoaded', function () {
        const saveForm = document.getElementById('saveBankForm');
        const warrantySelect = document.getElementById('warrantySelect');
        const bankSelect = document.getElementById('bank_detail_id');
        const warrantyRow = document.getElementById('warrantyRow');
        const warrantyValueTd = document.getElementById('warrantyValue');
        const bankDetailsSection = document.getElementById('bankDetailsSection');
        const bankDetailsTbody = document.querySelector('#bankDetailsContent tbody');

        function updateWarrantyRow() {
            const years = parseInt(warrantySelect.value, 10);

            if (years === 0) {
                warrantyRow.style.display = 'none';
                warrantyRow.classList.add('no-print');
            } else {
                warrantyRow.style.display = 'table-row';
                warrantyRow.classList.remove('no-print');
                warrantyValueTd.textContent = years + (years > 1 ? ' years' : ' year');
            }
        }

        function updateBankDetails() {
            const selectedOption = bankSelect.options[bankSelect.selectedIndex];
            if (!selectedOption || selectedOption.value === "") {
                bankDetailsSection.style.display = 'none';
                bankDetailsTbody.innerHTML = '';
                return;
            }

            const rows = `
                <tr><td>Authorised Signatory</td><td>${selectedOption.dataset.signatory || '-'}</td></tr>
                <tr><td>Account Number</td><td>${selectedOption.dataset.accountNumber || '-'}</td></tr>
                <tr><td>IFSC</td><td>${selectedOption.dataset.ifsc || '-'}</td></tr>
                <tr><td>Branch Details</td><td>${selectedOption.dataset.branch || '-'}</td></tr>
                <tr><td>UPI Details</td><td>${selectedOption.dataset.upi || '-'}</td></tr>
            `;
            bankDetailsTbody.innerHTML = rows;
            bankDetailsSection.style.display = 'block';
        }

        // Initial on page load
        updateWarrantyRow();
        updateBankDetails();

        // Event bindings
        warrantySelect.addEventListener('change', updateWarrantyRow);
        bankSelect.addEventListener('change', updateBankDetails);

        saveForm.addEventListener('submit', function (e) {
            e.preventDefault();

            saveForm.querySelectorAll('.is-invalid').forEach(el => el.classList.remove('is-invalid'));
            saveForm.querySelectorAll('small.text-danger').forEach(el => el.textContent = '');

            const formData = new FormData(saveForm);
            formData.append('warranty', warrantySelect.value);
            formData.append('office_id', document.getElementById('office_id').value);

            fetch("{{ route('save.bank.warranty') }}", {
                method: 'POST',
                headers: {
                    'X-CSRF-TOKEN': '{{ csrf_token() }}',
                },
                body: formData
            })
            .then(response => response.json().then(data => {
                if (!response.ok) {
                    throw {
                        status: response.status,
                        data: data
                    };
                }
                return data;
            }))
            .then(data => {
                swal({
						title: "Good job!",
						text: data.msg,
						icon: "success",
					}).then(() => {
                    window.location.reload();
                });
            })
            .catch(error => {
                if (error.status === 422) {
                    const errors = error.data.errors;
                    for (let field in errors) {
                        const input = document.querySelector(`[name="${field}"]`);
                        if (input) {
                            input.classList.add('is-invalid');
                            const errorSpan = document.getElementById(`${field}-error`);
                            if (errorSpan) errorSpan.textContent = errors[field][0];
                        }
                    }
                } else {
                    swal({
                        title: "Oops!",
                        text: "Something went wrong. Please try again.",
                        icon: "error"
                    });
                }
            });
        });

        // Print button
        document.getElementById('printBtn').addEventListener('click', function () {
            window.print();
        });
    });
</script>


    <!-- Additional Services -->
    {{-- <h4 class="text-center">ADDITIONAL SERVICES (Extra Charges Apply)</h4>
        <table class="table table-bordered">
            <tbody>
                @foreach ($services as $service)
                    <tr>
                        <td><strong>{{ $service->name }}</strong> ({{ $service->description }})</td>
    <td>₹{{ $service->price ?? '-' }}</td>
    <td>18%</td>
    <td>{{ $service->note }}</td>
    </tr>
    @endforeach
    </tbody>
    </table> --}}
    <h4 class="text-center">ADDITIONAL SERVICES (Extra Charges Apply)</h4>
    <table class="table table-bordered">
        <tbody>
            <tr>
                <td><strong>Netmetering</strong> (Includes paperwork for Safety, Feasibility, Agreement, etc.)</td>
                <td>₹ -</td>
                <td>18%</td>
                <td>Liaison fees included, client pays dept. fees</td>
            </tr>
            <tr>
                <td><strong>Annual Maintenance Contract</strong><br>4 Quarterly Assessments per year, 12 Call
                    Support</td>
                <td>₹ -</td>
                <td>18%</td>
                <td>Client has not opted</td>
            </tr>
        </tbody>
    </table>

    <!-- Payment Terms -->
    {{-- <h4 class="text-center">PAYMENT TERMS</h4> --}}
    {{-- <table class="table table-bordered">
            <tbody>
                @foreach ($paymentTerms as $term)
                    <tr>
                        <td><strong>{{ $term->title }}</strong><br>{{ $term->description }}</td>
    <td>₹{{ number_format($term->amount, 2) }}</td>
    </tr>
    @endforeach
    </tbody>
    </table> --}}
    <br />
    <br />
    <!-- <br />
    <br />
    <br />
    <br />
    <br /> -->
    @if ($invoices->count())
    <h4 class="mt-4 text-center">Payment Terms</h4>
    <table class="table table-bordered" style="width: 100%;">
        <thead>
            <tr>
                <th>S no.</th>
                <th>Invoice Number</th>
                <th>Due Date</th>
                <th>Amount</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($invoices as $index => $invoice)
            <tr>
                <td>{{ $index + 1 }}</td>
                <td>{{ $invoice->id }}</td>
                <td>{{ \Carbon\Carbon::parse($invoice->invoice_date)->format('d M, Y') }}</td>
                <td>₹{{ number_format($invoice->invoice_amount, 2) }}</td>
            </tr>
            @endforeach
        </tbody>
    </table>
    @else
    <h4 class="mt-4">Payment Terms</h4>
    <p>No invoices available for this lead.</p>
    @endif

    <br>
    <br>
    <br>
    <br>
    <br>

    <!-- Delivery Schedule -->
    {{-- <h4 class="text-center">DELIVERY SCHEDULE</h4>
        <table class="table table-bordered">
            <tbody>
                @foreach ($deliverySchedule as $schedule)
                    <tr>
                        <td>{{ $schedule->milestone }}</td>
    <td>{{ $schedule->duration }}</td>
    </tr>
    @endforeach
    </tbody>
    </table> --}}

    <h4 class="text-center">DELIVERY SCHEDULE</h4>
    <table class="table table-bordered">
        <tbody>
            <tr>
                <td>Design Finalization</td>
                <td>Week 1</td>
            </tr>
            <tr>
                <td>Structure Fabrication</td>
                <td>Week 1 and 2</td>
            </tr>
            <tr>
                <td>Structure and BOS Installation</td>
                <td>Week 1, 2, and 3</td>
            </tr>
            <tr>
                <td>Module and Inverter Installation</td>
                <td>Week 3 and 4</td>
            </tr>
            <tr>
                <td>Testing and Handover</td>
                <td>Week 4</td>
            </tr>
        </tbody>
    </table>
    <h4 class="text-center">PROJECT SUMMARY</h4>
    <table class="table table-bordered">
        <tbody>
            @php
            $cost = is_numeric($estimatedCost) ? $estimatedCost : 0;

            // Remove "kw", "KW", spaces, etc. and cast to float
            $cleanedCapacity = preg_replace('/[^0-9.]/', '', $projectCapacity);
            $capacityKW = is_numeric($cleanedCapacity) ? (float) $cleanedCapacity : 1;

            $capacityWatts = $capacityKW * 1000;
            $perWattCost = $capacityWatts > 0 ? ($cost / $capacityWatts) : 0;
            @endphp

            <tr>
                <td>Estimated Per Watt Project Cost:</td>
                <td>₹ {{ number_format($perWattCost, 2) }}</td>
            </tr>




            </tr>
            <tr>
                <td>Breakeven / ROI projected:</td>
                <td>2.17 years</td>
            </tr>
            <tr>
                <td>IRR% (estimated):</td>
                <td>37%</td>
            </tr>
            <tr>
                <td>Solar Module Warranty:</td>
                <td>10 years</td>
            </tr>
            <tr>
                <td>Generation Guarantee:</td>
                <td>25 years</td>
            </tr>
            <tr>
                <td>Solar Inverter Warranty:</td>
                <td>10 years</td>
            </tr>
            <tr id="warrantyRow">
                <td>Surjaa Warranty:</td>
                <td id="warrantyValue">
                    {{ $lead->warranty }} {{ $lead->warranty > 1 ? 'years' : 'year' }}
                </td>
            </tr>



        </tbody>
    </table>

    <p class="text-center">Power Grid | Solar | Wind | Hydro | Telecom | Energy Storage | O&M | Infrastructure</p>
    <p class="text-center">All disputes subject to Faridabad courts only. E.&O.E.</p>

    <h5>Signed and Accepted</h5>
    <p><strong>Name:</strong> ______________</p>
    <p><strong>Phone:</strong> ______________</p>
    <p><strong>Date:</strong> ______________</p>
    <p><strong>Salesperson:</strong> ______________</p>
    <p><strong>Notes:</strong></p>
    <hr>

</div>
@endsection