@extends('layouts.master')
@section('styles')
<style>
    .topstats {
        margin-top: 10px;
        font-size: 13px;
        margin-bottom: -5px;
    }

    .topstats .gary-box {
        line-height: 1;
        background-color: #f9f9f9;
        border-bottom: solid 1px #d1d1d1;
        padding: 10px;
    }

    .topstats .gary-box span {
        font-family: 'Rationale', sans-serif;
        color: #0038ba;
        font-size: 20px;
        float: right;
        margin-top: -4px;
    }



    .dis-slab-card {
        font-size: 13px;
        margin: 0;
    }

    .dis-input {
        font-size: 13px;
        border: solid 1px #E8E8E8;
        width: 240px;
        height: 25px;
        padding-left: 8px
    }

    .dis-input:focus {
        border: solid 1px #0038BA
    }

    .topsec {
        background-color: #F7F7F7;
        font-size: 14px;
        line-height: 25px;
        padding: 5px 0px;
        margin: 0;
        border-bottom: solid 1px #0038BA;
        cursor: pointer
    }

    .topsec i {
        float: right;
        font-size: 18px;
        line-height: 25px;
        color: #a4a4a4
    }

    .bottomsec {
        background-color: #ededed;
        padding: 10px 15px;
    }

    .dis-slab-card .btn-primary {
        font-size: 13px;
        padding: 5px 12px;
        line-height: 1;
        box-shadow: none;
    }

    .dis-slab-card .red-bg {
        border-color: #F12300;
        box-shadow: none;
    }

    .dis-slab-card .add-slab-btn {
        font-size: 14px;
        padding: 5px 12px;
        height: 28px;
        letter-spacing: 1px;
        margin-left: 10px;
    }

    .criteria-sh {
        padding-top: 10px;
        padding-bottom: 10px;
        border: solid 1px #F1F1F1;
        background-color: #F9F9F9
    }

    .criteria-sh strong {
        padding-right: 10px;
    }

    .table-wrap{
        width: 1060px;
        overflow-x: scroll;
    }
</style>
@endsection
@section('content')
<div class="row mt-2 mb-3">
    <div class="col-lg-6 col-md-6 col-sm-6">
        <h2 class="_head01">Report <span> Management</span></h2>
    </div>

    <div class="col-lg-6 col-md-6 col-sm-6">
        <ol class="breadcrumb">
            <li><a href="#"><span>Report</span></a></li>
            <li><span>List</span></li>
        </ol>
    </div>
</div>


<div class="row">
    <div class="col-md-12">
        <div class="card">

            <div class="topstats">
                <div class="row m-0">
                    <div class="col pr-0">
                        <div class="gary-box"><strong>Total Orders:</strong>
                            <span>{{collect($data)->sum('total_orders')}}</span>
                        </div>
                    </div>
                    <div class="col pr-0">
                        <div class="gary-box"><strong>Total Sales:</strong>
                            <span>{{number_format(collect($data)->sum('total_revenue'), 2)}}</span>
                        </div>
                    </div>
                    <div class="col pr-0">
                        <div class="gary-box"><strong>Avg. SKU/Order:</strong>
                            <span>{{(collect($data)->count()>0)? number_format(collect($data)->sum('average_sku')/collect($data)->count(), 2) : 0}}</span>
                        </div>
                    </div>
                    <div class="col pr-0">
                        <div class="gary-box"><strong>Avg. Bill Value:</strong>
                            <span>{{(collect($data)->count()>0)? number_format(collect($data)->sum('average_bill_value')/collect($data)->count(), 2) : 0}}</span>
                        </div>
                    </div>
                    <div class="col">
                        <div class="gary-box"><strong>Avg. Drop Size:</strong>
                            <span>{{(collect($data)->count()>0)? number_format(collect($data)->sum('average_drop_size')/collect($data)->count(), 2) : 0}}</span>
                        </div>
                    </div>
                </div>
            </div>



            @include('reports.MonthlyExecution.criteria')

            <div class="header"> <a href="/genrateBrandWiseReportExcel?{{$queryString}}"
                    class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                {{-- <a href="/generate-monthly-execution-report-excel?{{$queryString}}" class="btn btn-primary btn-line
                export_excel" style="line-height:1; height: 34px; box-shadow:none">Export Excel</a> --}}
                <h2>Monthly Execution <span> Report</span>
                    <div class="_list-total total_count">{{collect($data)->count()}}</div>
                </h2>
            </div>
            <div class="body body_table">
                <div class="col-md-12 p-0">
                    <div class="table-wrap">
                        <table class="table table-hover display pb-30" style="width:100%;" id="brandWiseTable">
                            <thead>
                                <tr>
                                    <th style="white-space: nowrap !important;">Order Date</th>
                                    <th style="white-space: nowrap !important;">Order Status</th>
                                    <th style="white-space: nowrap !important;">Order ID</th>
                                    <th style="white-space: nowrap !important;">Product Code</th>
                                    <th style="white-space: nowrap !important; width: 194px !important">Product Name</th>
                                    <th style="white-space: nowrap !important;">Booked Quantity</th>
                                    <th style="white-space: nowrap !important;">Final Price</th>
                                    <th style="white-space: nowrap !important;">Shop ID</th>
                                    <th style="white-space: nowrap !important;">Shop Name</th>
                                    <th style="white-space: nowrap !important;">Shop Phone</th>
                                    <th style="white-space: nowrap !important;">Shop Address</th>
                                    <th style="white-space: nowrap !important;">Neighbourhood</th>
                                    <th style="white-space: nowrap !important;">Segment</th>
                                    <th style="white-space: nowrap !important;">Channel</th>
                                    <th style="white-space: nowrap !important;">Order Booked By</th>
                                    <th style="white-space: nowrap !important;">Added By</th>
                                    <th style="white-space: nowrap !important;">Route Name</th>
                                </tr>
                            </thead>
                            <tbody>
                                @if (collect($data)->count()>0)
                                @foreach ($data as $item)
                                <tr>
                                    <td>{{$item->created_date}}</td>
                                    <td>{{$item->order_status}}</td>
                                    <td>{{$item->order_id}}</td>
                                    <td>{{$item->sku}}</td>
                                    <td style="width: 200px !important;display:block">{{$item->product_name}}</td>
                                    <td>{{$item->booked_quantity}}</td>
                                    <td>{{$item->final_price}}</td>
                                    <td>{{$item->retailer_id}}</td>
                                    <td>{{$item->retailer_name}}</td>
                                    <td>{{$item->retailer_phone}}</td>
                                    <td>{{$item->retailer_address}}</td>
                                    <td>{{$item->neighbourhood}}</td>
                                    <td>{{$item->segment_name}}</td>
                                    <td>{{$item->channel}}</td>
                                    <td>{{$item->order_booked_by}}</td>
                                    <td>{{$item->added_by}}</td>
                                    <td>{{$item->route_name}}</td>
                                </tr>
                                @endforeach
                                @endif

                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
    $('#brandWiseTable').dataTable({
        "scrollX": true
    });
</script>
@endsection