@extends('admin.layout.master')
@section('title','ORDER 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 #c1c1c1 !important;
        }
        .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">
    <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="col-6 pl-0">ORDER SUMMERY</h4>
        <div class="col-6 d-flex justify-content-end">
            <button id="myButtonControlID" class="btn-sina-title-add d-flex align-items-center" type="button" name="button">
                <div class=""> Excel </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-download"></i>
                </div>
            </button>
            &nbsp;
            <button class="btn-sina-title-add d-flex align-items-center" type="button" name="button" onclick="PrintDiv()">
                <div class=""> Print </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-print"></i>
                </div>
            </button>
        </div>
        {{-- <button id="myButtonControlID" class="pull-right">Excel</button> --}}
    </div>
    <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 justify-content-end">
                        <div class="input-group col-2">
                            <select name="category_code" id="category_code" class="form-control select_2" onchange="getProduct()">
                                @forelse ($categories as $category)
                                    <option value="{{$category->code}}" data-category_id="{{$category->id}}" @if(Request()->category_code==$category->code) selected="selected" @endif>{{$category->name_eng}}</option>
                                @empty  
                                @endforelse
                                {{-- @forelse ($products->GroupBy('category_id') as $category_id=>$category)
                                <option value="{{$category->first()->category->code}}" data-category_id="{{$category_id}}" @if(Request()->category_code==$category->first()->category->code) selected="selected" @endif>{{$category->first()->category->name_eng}}</option>
                                @empty  
                                @endforelse --}}
                            </select>
                        </div>
                        <div class="input-group col-2">
                            <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 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}}"  @if(Request()->showroom==$customer->id) selected="selected" @endif>{{$customer->name_eng}}</option>
                                @empty
                                    
                                @endforelse
                            </select>
                        </div>
                        <div class="input-group col-2">
                            <select name="delivered" id="delivered" class="form-control select_2">
                                <option value="0"  @if(Request()->delivered==0) selected="selected" @endif>Order</option>
                                <option value="1"  @if(Request()->delivered==1) selected="selected" @endif>Delivered</option>
                            </select>
                        </div>
                        <div class="input-group col-4 pl-0">
                            <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>
            </form>
        </div>
            <div class="table-responsive" id="divTableDataHolder">
                <h4 class="table-caption text-center">ORDER SUMMERY (SHOWROOM WISE)</h4>
                {{-- @if(Request()->showroom && Request()->showroom!=0)
                    <h5 class="table-caption text-center">{{$customers->where('id',Request()->showroom)->first()->name_eng}}</h5>
                @else
                <h5 class="table-caption text-center">All Showroom</h5>
                @endif --}}
                @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 class="table table-bordered table-hover">
                    <thead>
                        @php
                            $tr='<tr class="second-head-tr">';
                        @endphp
                        <tr class="first-head-tr">
                            <th rowspan="2">#</th>
                            <th rowspan="2">Showroom</th>
                            @forelse ($transactions->groupBy('product.cat_code') as $k=>$categoryProduct)
                                <th colspan="{{count($categoryProduct)}}" class="text-center">{{$categoryProduct->first()->product->catByCatCode->name_eng}}</th>
                            @forelse ($categoryProduct->groupBy('product_id') as $key=>$transacted_product)
                            {{-- @forelse ($transacted_products as $a=>$transacted_product) --}}
                                {{-- @if($a!='') --}}
                                @php
                                    $tr.='<th class="text-center" >'.$transacted_product->first()->product->name_eng.'</th>';
                                @endphp 
                                    {{-- <th class="text-center" >{{$transacted_product->first()->product->name_eng}}</th>   --}}
                                {{-- @endif --}}
                            @empty
                            @endforelse

                            @empty
                            @endforelse
                        </tr>
                        {!! $tr.'</tr>' !!}
                    </thead>
                   {{-- @forelse ($showRooms as $party_id => $showRoom)
                    <tr><td colspan="5" class="text-center bg-success">SHOWROOM :{{$showRoom->first()->showroom->name_eng}}<br>Address :{{$showRoom->first()->showroom->address}}</td></tr> --}}
                    @php
                        $i=1;
                    @endphp
                    <tbody>
                        @forelse ($transactions->groupBy('party_id') as $key=>$showroom)
                            @if($key!='')
                                <tr>
                                    <td>{{$i++}}</td>
                                    <td>{{$showroom->first()->showroom->name_eng}}</td>
                                    {{-- <td>{{$showroom->first()->unit}}</td> --}}
                                    @forelse ($transacted_products as $k=>$transacted_product) 
                                        <td class="text-right">{{ $transacted_product->where('party_id',$key)->where('product_id',$k)->where('transaction_type','=',14)->sum('order_qty') }}</td>
                                    @empty
                                    @endforelse
                                </tr>
                            @endif
                        @empty
                            <tr>
                                <td colspan="5" class="bg-dark text-center text-warning">No Data Available</td>
                            </tr>
                        @endforelse
                    </tbody>
                    <tfoot>
                        <tr class="first-head-tr">
                            <th colspan="2" class="text-right">Total</th>
                            @forelse ($transacted_products as $m=>$transacted_product)
                                {{-- @if($a!='') --}}
                                    <th class="text-right" >{{ $transacted_product->where('product_id',$m)->where('transaction_type','=',14)->sum('order_qty') }}</th>  
                                {{-- @endif --}}
                            @empty
                            @endforelse
                        </tr>
                    </tfoot>
                  
                </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