@extends('admin.layouts.master')
@section('title', 'Customer Ledger')
@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">Customer Ledger</h3>
                    <ul class="breadcrumb">
                        <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                        <li class="breadcrumb-item active">Customer Ledger</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">
                                @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>
                                        @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')}}">
                                <input type="hidden" name="city" value="{{request('city')}}">
                                @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 class="col-md-4">
                                    <label>Customer / Mobile</label>
                                    <div style="display:flex; gap:5px;">
                                        <input type="search" 
                                            name="search" 
                                            value="{{ request('search') }}" 
                                            class="form-control"
                                            placeholder="Search">

                                        <button type="submit" class="btn btn-primary" style="white-space: nowrap;">
                                            Search
                                        </button>
                                    </div>
                                </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">Customer Ledger (Locality Wise)</h4>
        </div>

        <div class="card-body">
            <div class="table-responsive">
                <table class="datatable table table-bordered table-striped">
                    <thead style="background-color: #f87b44;color: white;">
                        <tr>
                            <th>Sl.No</th>
                            <th>Customer</th>
                            <th>Locality</th>
                            <th class="text-center">Last 3 Months Avg</th>
                            <th class="text-center">Last Month</th>
                            <th class="text-center">Current Month</th>
                            <th class="text-center">Outstanding</th>
                        </tr>
                    </thead>

                    <tbody>
                        @forelse($customers as $key => $row)
                        <tr>
                            <td>{{ $key + 1 }}</td>

                            <td>
                                <strong>{{ $row->name }}</strong><br>
                                {{ $row->mobile }}
                            </td>

                            <td>
                                {{ $row->locality }}
                            </td>

                            <td class="text-center" data-order="{{ $row->avg_3_month }}">
                                ₹ {{ number_format($row->avg_3_month ?? 0, 2) }}
                            </td>

                            <td class="text-center" data-order="{{ $row->last_month }}">
                                ₹ {{ number_format($row->last_month ?? 0, 2) }}
                            </td>

                            <td class="text-center" data-order="{{ $row->current_month }}">
                                ₹ {{ number_format($row->current_month ?? 0, 2) }}
                            </td>

                            <td class="text-center" data-order="{{ $row->outstanding }}">
                                @if(($row->outstanding ?? 0) > 0)
                                <span style="color:red; font-weight:bold;">
                                    ₹ {{ number_format($row->outstanding, 2) }}
                                </span>
                                @else
                                <span style="color:green;">
                                    ₹ 0.00
                                </span>
                                @endif
                            </td>
                        </tr>
                        @empty
                        <tr>
                            <td colspan="7" class="text-center">
                                No records found
                            </td>
                        </tr>
                        @endforelse
                    </tbody>

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

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

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

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

                            <td class="text-center">
                                ₹ {{ number_format(collect($customers)->sum('outstanding'), 2) }}
                            </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>