@extends('admin.layouts.master')
@section('title', 'ECO')
@section('content')

    <!-- Page Wrapper -->
    <div class="page-wrapper">
        <div class="content container-fluid">

            <!-- Page Header -->
            <div class="page-header">
                <div class="row">
                    <div class="col">
                        <h3 class="page-title">ECO</h3>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                            <li class="breadcrumb-item active">ECO</li>
                        </ul>
                    </div>
                    <div class="panel-heading col-md-2">
                        <!-- <a href="" class="btn btn-block btn-primary">Add Order</a>-->

                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-sm-12">
                    <div class="card">
                        <div class="card-header">
                            Filter
                        </div>
                        @php
                            $user = Auth::user();
                            $isTelecaller = $user->user_type == 2;
                            $isManager = $user->designation == 'Manager';
                            $NotTelecaller = 1;
                            if ($isTelecaller && !$isManager) {
                                $NotTelecaller = 0;
                            }
                        @endphp  
                        <div class="card-body">
                            <form action="" method="get" id="filter">
                                <div class="row">
                                    <div class="col-md-3">
                                        <label>Date Range</label>
                                        <input type="text" name="date" @if(isset($_GET['date'])) value="{{$_GET['date']}}" @else value="{{ date('Y-m-d', strtotime(' -1 day')) }} - {{ date('Y-m-d') }}"
                                               @endif placeholder="Filter Time" class="form-control" id="daterange">
                                    </div>
                                    @php if($NotTelecaller){ @endphp 
                                    <div class="col-md-3">
                                        <label>Select City</label>
                                        <select class="form-control" name="city" id="citySelect">
                                            <option value="">--Search by city--</option>
                                            @foreach($city as $c)
                                                <option value="{{ $c->id }}" 
                                                    @if(request('city') == $c->id) selected @endif>
                                                    {{ $c->cityName }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label>Select Telecaller</label>
                                        <select class="form-control" name="telecaller" id="telecallerSelect">
                                            <option value="">--Search by Telecaller--</option>
                                            <!--<option value="pos">Point of sale</option>-->                                            
                                            @foreach($telecaller as $r)
                                                <option value="{{ $r->id }}" 
                                                    @if(request('telecaller') == $r->id) selected @endif>
                                                    {{ $r->name }} ({{ $r->address }})
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    @php }else{@endphp
                                    <input type="hidden" name="telecaller" value="{{request('telecaller')}}">
                                    @php } @endphp 
                                    <div class="col-md-3">
                                        <label>Select Locality</label>
                                        <select class="form-control" name="locality" id="localitySelect">
                                            <option value="">--Search by locality--</option>
                                            @foreach($localities as $c)
                                                <option value="{{ $c->id }}" 
                                                    @if(request('locality') == $c->id) selected @endif>
                                                    {{ $c->locality }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
<!--                                <div class="row" style="padding-top: 20px;">
                                    <div class="col-sm-12 col-md-6"></div>
                                    <div class="col-sm-12 col-md-6">
                                        <div id="DataTables_Table_0_filter" style="text-align: right;">
                                            <label>
                                                <form action="" method="get">
                                                    <input type="search" name="search" value="" class="search form-control form-control-sm" placeholder="Search By order Id" style="margin-left: 0.5em;display: inline-block;width: auto;">
                                                    <button type="submit" class="btn btn-sm btn-primary">
                                                        Search
                                                    </button>
                                                </form>
                                            </label>
                                        </div>
                                    </div>
                                </div>-->
                            </form>
                        </div>
                    </div>
                    <div class="card">
                        <div class="card-header">
                            <h4 class="card-title">ECO (Locality Wise)</h4>
                        </div>

                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped">
                                    <thead style="background-color: #f87b44;color: white;">
                                        <tr>
                                            <th>Locality</th>
                                            <th class="text-center">Total Customers</th>
                                            <th class="text-center">Billed Customers</th>
                                            <th class="text-center">Amount</th>
                                            <th class="text-center">Conversion %</th>
                                        </tr>
                                    </thead>

                                    <tbody>
                                        @forelse($report as $row)
                                            <tr>
                                                <td><strong>{{ $row['locality'] }}</strong></td>

                                                <td class="text-center">
                                                    <a target="_blank" 
                                                        href="{{ url('/ecocustomer') . '?' . http_build_query(array_merge(request()->query(), ['locality' => $row['locality_id']])) }}">
                                                            {{ $row['total_customers'] }}
                                                     </a>
                                                </td>

                                                <td class="text-center">
                                                    {{ $row['billed_customers'] }}
                                                </td>

                                                <td class="text-center">
                                                    ₹ {{ number_format($row['amount'],2) }}
                                                </td>

                                                <td class="text-center">
                                                    @if($row['total_customers'] > 0)
                                                        {{ round(($row['billed_customers'] / $row['total_customers']) * 100, 2) }} %
                                                    @else
                                                        0 %
                                                    @endif
                                                </td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="4" class="text-center">
                                                    No records found
                                                </td>
                                            </tr>
                                        @endforelse
                                    </tbody>

                                    <tfoot>
                                        <tr class="font-weight-bold bg-light">
                                            <td>Total</td>

                                            <td class="text-center">
                                                {{ collect($report)->sum('total_customers') }}
                                            </td>

                                            <td class="text-center">
                                                {{ collect($report)->sum('billed_customers') }}
                                            </td>

                                            <td class="text-center">
                                                ₹ {{ number_format(collect($report)->sum('amount'),2) }}
                                            </td>

                                            <td class="text-center">
                                                @php
                                                    $totalCustomers = collect($report)->sum('total_customers');
                                                    $totalBilled = collect($report)->sum('billed_customers');
                                                @endphp

                                                @if($totalCustomers > 0)
                                                    {{ round(($totalBilled / $totalCustomers) * 100, 2) }} %
                                                @else
                                                    0 %
                                                @endif
                                            </td>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
            </div>


        </div>
    </div>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
    <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css"/>


    <script>
        $(function () {
            $('#daterange').daterangepicker({
                timePicker: false,

                locale: {
                    format: 'Y-M-D',
                }
            }, function (start, end, label) {
                setTimeout(function () {
                    $("#filter").submit();
                }, 500);

            });
        });

    </script>
    <script>
        document.addEventListener('DOMContentLoaded', function () {
            const citySelect = document.getElementById('citySelect');
//            const retailerSelect = document.getElementById('retailerSelect');
            const telecallerSelect = document.getElementById('telecallerSelect');
            const localitySelect = document.getElementById('localitySelect');
            if (citySelect) {
                citySelect.addEventListener('change', function () {
                    document.getElementById('filter').submit();
                });
            }
//            retailerSelect.addEventListener('change', function () {
//                document.getElementById('filter').submit();
//            });
            if (telecallerSelect) {
                telecallerSelect.addEventListener('change', function () {
                    document.getElementById('filter').submit();
                });
            }
            if (localitySelect) {
                localitySelect.addEventListener('change', function () {
                    document.getElementById('filter').submit();
                });
            }
        });
    </script>
@endsection
<script>
    function details(id) {
        $(".modal-footer").hide();
        $(".modal-title").text("Details");
        $.get("/details/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function track(id) {
        $(".modal-footer").hide();
        $(".modal-title").text("Tracking");
        $.get("/track/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function billprofit(id) {
        $(".modal-footer").show();
        $(".modal-title").text("Bill");
        $.get("/billprofit/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

    function eway(id) {
        $(".modal-footer").show();
        $(".modal-title").text("E-way");
        $.get("/eway/" + id, function (res) {
            $(".modal-body").html(res);
        })
    }

</script>


<!-- Modal -->
<div id="myModal" class="modal fade" role="dialog">
    <div class="modal-dialog modal-lg">

        <!-- Modal content-->
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title">Modal Header</h4>
                <button type="button" class="close" data-dismiss="modal">&times;</button>
            </div>
            <div class="modal-body" id="printableArea">

            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-primary" onclick="printDiv('printableArea')">Print</button>
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
            </div>

        </div>
    </div>
</div>