@extends('admin.layouts.master')
@section('title', 'Sales per company')
@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">Sales per company</h3>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
                            <li class="breadcrumb-item active">Sales per company</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">
                            @php
                                $grandTotal = collect($report)->sum(function ($row) {
                                    return collect($row)->sum();
                                });
                            @endphp
                            <h4 class="card-title">
                                Sales Per Company (Locality Wise)
                                <span style="font-weight:bold;">
                                    ({{ number_format($grandTotal, 2) }})
                                </span>
                            </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>
                                            @foreach($companies as $company)
                                                <th class="text-center">
                                                    {{ $company }}<br>
                                                    <span style="font-size:12px; font-weight:bold;">
                                                        ({{
                                                            number_format(
                                                                collect($report)->sum(function ($row) use ($company) {
                                                                    return $row[$company] ?? 0;
                                                                }), 2
                                                            )
                                                        }})
                                                    </span>
                                                </th>
                                            @endforeach
                                        </tr>
                                    </thead>

                                    <tbody>
                                        @forelse($report as $locality => $companyData)
                                            @php
                                                $rowTotal = collect($companyData)->sum();
                                            @endphp
                                            <tr>
                                                <td>
                                                    <strong>{{ $locality }}</strong><br>
                                                    <span style="font-size:12px; font-weight:bold;">
                                                        ({{ number_format($rowTotal, 2) }})
                                                    </span>
                                                </td>

                                                @foreach($companies as $company)
                                                    <td class="text-center">
                                                        {{ number_format($companyData[$company] ?? 0, 2) }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="{{ count($companies) + 1 }}" class="text-center">
                                                    No records found
                                                </td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </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>