@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;}

  </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('final_price'), 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')

{{--{{dd($data)}}--}}
            <div class="header"> <a href="/generate-monthly-execution-report-excel?{{$queryString}}" class="btn add_button btn-line"><i class="fa fa-download"></i> <span>Export Excel</span></a>
                <h2>@if($requestType=='daily-execution-report') Daily @else Monthly @endif Execution <span> Report @if($type=='summary') (Summary) @endif @if($type=='detail') (Detail) @endif</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="monthlyReportTable" >
                            <thead>
                                <tr>
                                    <th style="white-space: nowrap !important;">Created Date</th>
                                    <th style="white-space: nowrap !important;">Completed Date</th>
                                    <th style="white-space: nowrap !important;">Shop ID</th>
                                    <th style="white-space: nowrap !important;">Order Booker ID</th>
                                    <th style="white-space: nowrap !important;">Order Booker Name</th>
                                    <th style="white-space: nowrap !important;">Distributor</th>
                                    <th style="white-space: nowrap !important;">ASM/TSM</th>
                                    <th style="white-space: nowrap !important;">Order ID</th>
                                    <th style="white-space: nowrap !important;">Retailer Name</th>
                                    <th style="white-space: nowrap !important;">Segment</th>
                                    <th style="white-space: nowrap !important;">Channel</th>
                                    <th style="white-space: nowrap !important;">Product SKU</th>
                                    <th style="white-space: nowrap !important;">Product Name</th>
                                    <th style="white-space: nowrap !important;">Unit Name</th>
                                    <th style="white-space: nowrap !important;">Booked Qty</th>
                                    <th style="white-space: nowrap !important;">Executed Qty</th>
                                    <th style="white-space: nowrap !important;">Booking Vs Executed %</th>
                                    <th style="white-space: nowrap !important;">Trade Price</th>
                                    <th style="white-space: nowrap !important;">Trade Offer</th>
                                    <th style="white-space: nowrap !important;">Trade Discount Type</th>
                                    <th style="white-space: nowrap !important;">Trade Discount In PKR</th>
                                    <th style="white-space: nowrap !important;">Special Discount In PKR</th>
                                    <th style="white-space: nowrap !important;">Booker Discount</th>
                                    <th style="white-space: nowrap !important;">Total Execution Value</th>
                                </tr>
                            </thead>
                            {{-- {{number_format($item->total_revenue, 2)}} --}}
                            <tbody>
                                @if (collect($data)->count()>0)
                                    @foreach ($data as $item)
{{--                                        {{dd($item)}}--}}
                                        <tr>
                                            <td>{{$item->order_date_created_at}}</td>
                                            <td>{{$item->order_date_completed_at}}</td>
                                            <td>{{$item->retailer_id}}</td>
                                            <td>{{$item->employee_id}}</td>
                                            <td>{{$item->employee}}</td>
                                            <td>{{$item->distributor_name}}</td>
                                            <td>{{$item->asm_tsm}}</td>
                                            <td>{{$item->order_id}}</td>
                                            <td>{{$item->retailer_name}}</td>
                                            <td>{{$item->segment}}</td>
                                            <td>{{$item->channel}}</td>
                                            <td>{{$item->item_sku}}</td>
                                            <td>{{$item->item_name}}</td>
                                            <td>{{$item->unit_name}}</td>
                                            <td>{{$item->booked_qty}}</td>
                                            <td>{{$item->executed_qty}}</td>
                                            <td>{{($item->booked_qty>0)? number_format($item->executed_qty/$item->booked_qty*100, 2).'%' : '0%'}}</td>
                                            <td>{{number_format($item->trade_price,2)}}</td>
                                            <td>{{$item->trade_offer}}</td>
                                            <td>{{@$item->trade_discount_type ? ucfirst(@$item->trade_discount_type):'NA'}}</td>
                                            <td>{{number_format($item->trade_discount_pkr,2)}}</td>
                                            <td>{{number_format($item->special_discount,2)}}</td>
                                            <td>{{number_format($item->booker_discount,2)}}</td>
                                            <td>{{number_format($item->execution_value,2)}}</td>
                                        </tr>
                                    @endforeach
                                @endif

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

@section('scripts')
<script>
    // $(function () {

    //     var table = $('#monthlyReportTable').DataTable({
    //         processing: true,
    //         serverSide: true,
    //         scrollX: true,
    //         ajax: "{{ route('testingResult') }}",
    //         columns: [
    //             {data: 'employee_id', name: 'employee_id'},
    //             {data: 'booker_lats', name: 'booker_lats'},
    //             {data: 'booker_longs', name: 'booker_longs'}
    //         ]
    //     });

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