@extends('admin.layout.master')
@section('title',($type==3?'SALES':'SALES RETURN').' Summery')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 35px !important;
    }
    .table th, .table td {
            padding: 0px 5px;
            color: black;
        }
        .table th {
           background: #ab3535;padding: 5px !important;color: white !important;
        }
        .table-bordered th, .table-bordered td {
            border: 1px solid #000 !important;text-align:right
        }
        .special-cell{
            background: #bfbfbf;
            padding: 5px !important;
            color: black !important;
        }
</style>
<style>
    table {width:100%;}table, td, th {border: 1px solid gray;border-collapse:initial;border-spacing: 0;padding: 2px 4px;} td { vertical-align: top; }
    @media print {
    thead { display: table-header-group; }

    }

</style>

@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'SALES SUMMERY(ITEM WISE)'])
    <div class="card-body">
        {{-- <input type="hidden" name="" id="csrf-token" value="{{ Session::token() }}" /> --}}
        <div class="card-body" style="padding-bottom:0">
            <form action="{{  Request::url() }}" method="get">
                <div class="form-group">
                    <div class="row">
                        {{-- <div class="input-group col-2">
                            <select name="category_code" id="category_code" class="form-control select_2" onchange="getProduct()">
                                @forelse ($products->GroupBy('category_id') as $category_id=>$category)
                                <option value="{{$category->first()->category->code}}" data-category_id="{{$category_id}}">{{$category->first()->category->name_eng}}</option>
                                @empty
                                @endforelse
                            </select>
                        </div> --}}
                        <div class="col-3">
                            <div class="form-group">
                                <select name="product_id" id="product_id" class="form-control select_2">
                                    <option value="0">SELECT PRODUCT</option>
                                    @forelse ($products as $product)
                                    <option value="{{$product->id}}" @if(Request()->product_id==$product->id) selected="selected" @endif>{{$product->name_eng}}</option>
                                    @empty

                                    @endforelse
                                </select>
                            </div>
                        </div>
                        <div class="input-group col-2">
                            <select name="showroom" id="showroom" class="form-control select_2">
                                <option value="0">All ShowRoom</option>
                                @forelse ($customers as $customer)
                                <option value="{{$customer->id}}">{{$customer->name_eng}}</option>
                                @empty

                                @endforelse
                            </select>
                        </div>
                        <div class="col-3">
                            <div class="form-group">
                                <select name="get_value" id="get_value" class="form-control select_2">
                                    <option value="0" @if(Request()->get_value==0) selected="selected" @endif>By Quantity</option>
                                    <option value="1" @if(Request()->get_value==1) selected="selected" @endif>By Value</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-6 pl-0">
                            <div class="form-group">
                                <div class="input-group-append">
                                    <input type="date" class="form-control bsdatepicker" id="date_from" name="date_from" value="{{Request()->date_from?date('Y-m-d',strtotime(Request()->date_from)):date('Y-m-d')}}">
                                    <label class="input-group-text" style="height: 28px; margin-left: -2px; margin-right: -2px">To</label>
                                    <input type="date" class="form-control bsdatepicker" id="date_to" name="date_to" value="{{Request()->date_to?date('Y-m-d',strtotime(Request()->date_to)):date('Y-m-d')}}">

                                    <button type="submit" style="height: 28px; margin-left: -2px" class="btn btn-pill btn-sm btn-hover btn-danger">
                                        <i class="fa fa-search"></i>
                                    </button>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </form>
        </div>
            <div class="table-responsive" id="divTableDataHolder">
                @php
            
                    $printData['title']='SHOWROOM-WISE '.($type==3?'SALES':'SALES RETURN');
                    $printData['start_date']=Request()->date_from?date('d-M-Y',strtotime(Request()->date_from)):date('d-M-Y');
                    $printData['end_date']=Request()->date_to?date('d-M-Y',strtotime(Request()->date_to)):date('d-M-Y');
                    $printData['showroom']=Request()->showroom && Request()->showroom!=0?$customers->where('id',Request()->showroom)->first()->name_eng:'All Showroom';
                    $printData['search_by']=(Request()->product_id?strtoupper($products->find(Request()->product_id)->name_eng):'');
                    $routeName=Route::currentRouteName();   
                    $printData=getPrintData($routeName,$printData);
                @endphp
                 <style type="text/css">{!!$printData['style_css']!!}</style>
                {!!$printData['head']!!}
                {{-- <h3 class="table-caption text-center">{{Request()->product_id?strtoupper($products->find(Request()->product_id)->name_eng):''}}</h3>
                <h4 class="table-caption text-center">SHOWROOM-WISE {{($type==3?'SALES':'SALES RETURN')}} SUMMERY</h4>
                @if(Request()->date_from)
                <h6 class="table-caption text-center">{{ 'From '.date('d-M-Y',strtotime(Request()->date_from)).' To '.date('d-M-Y',strtotime(Request()->date_to))}}</h6>
                @endif --}}
                <table style="width:100%" class="table table-bordered table-hover">
                    <thead>
                        <tr>
                            <th style="border: 1px solid #000 !important;text-align:center;background: #ab3535;padding: 5px !important;color: white !important;" style="background: #ab3535;padding: 5px !important;color: white !important;">#</th>
                            <th style="border: 1px solid #000 !important;text-align:center;background: #ab3535;padding: 5px !important;color: white !important;">Showroom</th>
                            @forelse ($dateArray as $date)
                                <th style="border: 1px solid #000 !important;text-align:center;background: #ab3535;padding: 5px !important;color: white !important;">{{$date}}</th>
                            @empty

                            @endforelse
                        </tr>
                    </thead>
                    @php
                        $i=1;
                    @endphp
                   @forelse ($showRooms as $party_id => $showRoom)
                    <tr>
                        <td style="border: 1px solid #000 !important;text-align:center;">{{$i++}}</td>
                        <td style="border: 1px solid #000 !important;text-align:left;" class="bg-success">{{$showRoom->first()->showroom->name_eng}}</td>
                        @forelse ($dateArray as $date)
                        @php
                            if($dayWiseSales->has($date)){
                                    foreach ($dayWiseSales[$date]->where('party_id',$party_id)->groupBy('product_id') as $product_id=>$items){
                                       if(Request()->get_value==1){
                                           $qty=$items->sum(function($t){ return $t->quantity * $t->avg_price;});
                                       }else{
                                        $qty=$items->sum('quantity');
                                       }
                                }

                            }else{
                                $qty=0;
                            }
                             @endphp
                            <td style="border: 1px solid #000 !important;text-align:right">{{number_format($qty,2)}}</td>
                        @empty

                        @endforelse

                        </tr>

                    @empty
                    @endforelse
                        </table>
            </div>

            <hr>

            <div class="row pb-0  modal-footer">
            </div>
    </div>
</div>
{{-- @include('inventory.order.detail_modal') --}}
@endsection
@section('script')

<script>
    $('.select_2').select2();
</script>
@stop