@extends('layouts.app')
@section('content')
@php
$yes_no_options = ['Yes' => 'Yes', 'No' => 'No'];
@endphp

<!-- PAGE-HEADER -->
<div class="page-header">
    <div>
        <h1>Project Template Quotation <small></small></h1>
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="#">Home</a></li>
            <li class="breadcrumb-item"><a href="#">Project Template</a></li>
            <li class="breadcrumb-item active" aria-current="page">Costing</li>
        </ol>
    </div>

    <div class="float-end">
        <a class="btn btn-primary float-right" href="{{ url('project_templates') }}"> <i
                class="fa fa-arrow mb-3-left"></i> Back to Templates</a>
    </div>

</div>
<!-- PAGE-HEADER END -->

<div class="content mt-3">

    @if ($message = Session::get('success'))
    <div class="alert alert-warning alert-dismissible fade show" role="alert">
        <strong>Greate Job!</strong> {{ $message }}
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
    @endif


    <div class="row mb-3">
        <div class="col-md-12 ml-auto mr-auto">

            <!-- Nav tabs -->
            <div class="card">
                <div class="card-header">
                    <ul class="nav nav-tabs justify-content-center" role="tablist">

                        <li class="nav-item">
                            <a class="nav-link " href="{{ url('project_template/bom/' . $data->id) }}">
                                BOM
                            </a>
                        </li>

                        <li class="nav-item">
                            <a class="nav-link" href="{{ url('project_template/costing/' . $data->id) }}">
                                Costing Management
                            </a>
                        </li>

                        <li class="nav-item">
                            <a class="nav-link active" href="{{ url('project_template/quotation/' . $data->id) }}">
                                Quotation
                            </a>
                        </li>
                    </ul>
                </div>





            </div>

        </div>
    </div>


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

    <div class="card">
        <div class="card-body">


            <h2 class="text-center mb-3">Quotation</h2>
            <table class="table table-bordered">
                <tr>
                    <th>Project Estimate: {{ $template->title }}</th>
                </tr>
                <tr>


                    <td>
                        <strong>Surjaa Enertech and Infra Corporation</strong><br><br>

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

                </tr>
            </table>




            <div class="print-break mt-3">

                <p>There is no Plan(et) - B. Today, we are facing high degrees of air, water and soil pollution. It is therefore important we preserve our earth. At Surjaa, we endeavour to give our future generations comprising our children cleaner air to breathe, purer drinking water, and nutritional food to eat. Lets preserve our environment by switching to renewable sources of energy and partner with Surjaa.</p>

                <p>Associating with Surjaa brings you the following benefits:</p>

                <ul>
                    <li>Empanelled with the Ministry of New and Renewable Energy (under Ministry of Power, Government of India) under GCRT; Reg No: 4352 under JNRM – PAN India.</li>
                    <li>Empanelled with HAREDA, Startup India, Skill up India, and MSME, ISO 9001:2015</li>
                    <li>Preferred vendors for L&T (Electrical and Infra Projects)</li>
                    <li>Preferred vendors for ACME CleanTech</li>
                    <li>Business Partners to Luminous (Prestigious SPG PAN - India)</li>
                    <li>Authorized Resellers for JSW (Core Iron and Steel Products)</li>
                    <li>Authorized Resellers for SCharge (EV Chargers and products)</li>
                    <li>Authorized Resellers for Excel Abrasives (Core Products)</li>
                    <li>Channel Partners to Rishabh Instruments</li>
                    <li>Channel Partners to Servotech Power (PAN - India)</li>
                </ul>


                <p>we are also undertaking repowering and repair, maintenance of power plants and restoring power plants as part of OnM. our team is trained for inverter repairs and isolating electrical fault and providig quick resolution.</p>

                <p>Surjaa deals in top tier brands listed below and recommends these be used in the project under consideration.</p>


                <table class="table table-bordered">
                    <tr>
                        <th>Solar Inverters</th>
                        <th>Solar Modules</th>
                        <th>Wires and Cables</th>
                        <th>Mechanical Structure</th>
                        <th>Electrical Protection</th>
                    </tr>
                    <tr>
                        <td>
                            Radius<br>
                            Sungrow<br>
                            Sineng<br>
                            Luminous<br>
                            Servotech<br>
                            Growatt<br>
                        </td>
                        <td>
                            Luminous<br>
                            Rayzon<br>
                            Vikram<br>
                            Waaree<br>
                            Adani<br>
                            Servotech<br>
                        </td>
                        <td>
                            Polycab<br>
                            Havells<br>
                        </td>
                        <td>
                            Pre Galvanized<br>
                            Hot Dip (on request)<br>
                            MS Steel<br>
                            FRP<br>
                            SS 304<br>
                            Anodized Alum<br>
                        </td>
                        <td>
                            Chint<br>
                            Phoenix-Contact<br>
                            Havells<br>
                            HPL<br>
                            NCR<br>
                        </td>
                    </tr>
                </table>

                <p>
                    We thank you for choosing to become an environmental champion and partnering with Surjaa for your renewable energy. As per your requirements, we are sharing a preliminary estimate for your renewable energy project. We look forward to your project confirmation with us
                </p>

                <p>Authorized Signatory</p>
                <p class="mb-3">for Surjaa</p>
            </div>



            <div class="no-break mt-3">
                <table class="table table-bordered">
                    <tr>
                        <th>Description</th>
                        <th>Price per unit</th>
                        <th>GST (in %)</th>
                        <th>Quantity</th>
                        <th style="text-align: right">Total Cost</th>
                    </tr>
                    <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, 2) }}</td>
                            <td>{{$item->gst}}</td>
                            <td>{{ $item->total_quantity }}</td>
                            <td style="text-align: right">₹{{ 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>
            </div>


            {{-- 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>

            <!-- Payment Terms -->
            <div class="no-break mt-3">
                <h4 class="mt-4 text-center">Payment Terms</h4>
                <table class="table table-bordered" style="width: 100%;">
                    <thead>
                        <tr>
                            <th>Sr.</th>
                            <th>Payment Term</th>
                            <th>Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $count = 1; @endphp
                        @foreach($invoices->getAttributes() as $key => $value)

                        @if($value != 0)

                        <tr>
                            <td>{{ $count }}</td>
                            <td>Payment {{ $count }}</td>
                            <td>₹{{ number_format($value, 2) }}</td>
                        </tr>
                        @php $count++; @endphp
                        @endif


                        @endforeach
                    </tbody>
                </table>

            </div>



            <!-- Delivery Schedule -->
            <div class="no-break mt-3">
                <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>
            </div>





            <div class="no-break mt-3">
                <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.]/', '', $template->capacity);
                        $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>
                            <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>
            </div>



            <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>

        </div>
    </div>



</div>
@endsection


@section('scripting')
<script type="text/javascript">
    $(document).ready(function() {

        // $(".standardSelect").selectpicker();

        $('.standardSelect').on('change', function() {
            $(this).selectpicker('refresh');
            $(this).removeClass('open');
        });

        let template_id = "{{ $data->id }}";

    });

    function store_cost(id) {
        $.ajax({
            data: {
                "bom_item_id": id,
                "gst": $('#gst_' + id).val(),
                "price": $('#price_' + id).val(),
                "risk": $('#risk_' + id).val(),
                "markup": $('#markup_' + id).val(),
                "_token": "{{ csrf_token() }}",
            },
            url: "{{ url('project_template/costing/store') }}",
            type: "POST",
            dataType: 'json',
            success: function(data) {
                $('#dataForm').trigger("reset");
                $('#ajaxModel').modal('hide');
                swal({
                    title: "Good job!",
                    text: data.msg,
                    icon: "success",
                });
                $('.data-table').DataTable().ajax.reload(null, false);
                console.log(data);
            },
            error: function(data) {
                if (data.status == 422) {
                    var x = data.responseJSON;
                    $.each(x.errors, function(index, value) {
                        $("#" + index).addClass("is-invalid");
                        $("#" + index + "-error").html(value[0]);
                    });
                }
                $('#saveBtn').html('Save Changes');
            }
        });
    }
</script>
@endsection