@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: #000 !important;
        }
        .table-bordered th, .table-bordered td {
            border: 1px solid #000 !important;
        }
        .special-cell{
            background: #bfbfbf;
            padding: 5px !important;
            color: black !important;
        }
        #data_table_apply_filter{
            display: none;
        }
</style>
<style>
    table {

        width:100%
    }
    table, td, th {
        border: 1px solid #000;
        border-collapse:initial;
        border-spacing: 0;
        padding: 2px 4px;
    }
    td {
        vertical-align: top;
    }
    @media print {
    /* thead { display: table-header-group; } */
        .table th, .table td {
            padding: 0px 5px;
            color: black;
        }
        .table th {
           background: #fff;
           padding: 5px !important;
           color: #000 !important;
        }
        .table-bordered th, .table-bordered td {
            border: 1px solid #000 !important;
        }
        .special-cell{
            background: #bfbfbf;
            padding: 5px !important;
            color: black !important;
        }


        table {

        width:100%
        }
        table, td, th {
            border: 1px solid #000;
            border-collapse:initial;
            border-spacing: 0;
            padding: 2px 4px;
        }
        td {
            vertical-align: top;
        }
    }
    /* .verticalTableHeader {
    text-align:center;
    white-space:nowrap;
    g-origin:50% 50%;
    -webkit-transform: rotate(90deg);
    -moz-transform: rotate(90deg);
    -ms-transform: rotate(90deg);
    -o-transform: rotate(90deg);
    transform: rotate(90deg);

    }
    .verticalTableHeader p {
        margin:0 -100% ;
        display:inline-block;
    }
    .verticalTableHeader p:before{
        content:'';
        width:0;
        padding-top:110%;/* takes width as reference, + 10% for faking some extra padding
        display:inline-block;
        vertical-align:middle;
    } */

</style>

@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'SALES SUMMERY(ITEM WISE)'])
    {{-- <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <h4 class="col-6 pl-0">ORDER SUMMERY {{$type==0?'(ORDER VS DELIVERY)':($type==1?'(PRODUCT VS SHOWROOM)':'(SHOWROOM VS SECTIONWISE-PRODUCT)')}}</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>
    </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="">
                    <div class="row">
                        <div class="col-3">
                            <div class="form-group">
                                <select name="name_type" id="name_type" class="form-control select_2">
                                    <option value="0"  @if(Request()->name_type==0) selected="selected" @endif>English</option>
                                    <option value="1"  @if(Request()->name_type==1) selected="selected" @endif>Bangla</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-3">
                            <div class="form-group">
                                <select name="category_code" id="category_code" class="form-control select_2">
                                    @forelse ($categories as $category)
                                        <option value="{{$type==2?$category->id:$category->code}}" data-category_id="{{$category->id}}" @if(Request()->category_code==($type==2?$category->id:$category->code)) selected="selected" @endif>{{$type==2?$category->chart_name:$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>
                        <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="col-2">
                            <div class="form-group">
                                <select name="group" id="group" class="form-control select_2">
                                    <option value="0"  @if(Request()->group==0) selected="selected" @endif>All</option>
                                    @forelse ($groups as $group)
                                        <option value="{{$group->id}}"  @if(Request()->group==$group->id) selected="selected" @endif>{{$group->name_eng}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div>
                        <div class="col-3">
                            <div class="form-group">
                                <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>
                        <div class="col-3">
                            <div class="form-group">
                                <select name="report_layout" id="report_layout" class="form-control select_2">
                                    <option value="0"  @if(Request()->report_layout==0) selected="selected" @endif>Showroom By Product</option>
                                    <option value="1"  @if(Request()->report_layout==1) selected="selected" @endif>Product By Showroom</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-6">
                            <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
                $showroom_order_total=[];
                $showroom_delivery_total=[];
                $printData['title']='ORDER SUMMERY '.($type==0?'(ORDER VS DELIVERY)':($type==1?'(PRODUCT VS SHOWROOM)':'(SHOWROOM VS SECTIONWISE-PRODUCT)'));
                $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()->group?$groups->where('id',Request()->group)->first()->name_eng:(Request()->showroom && Request()->showroom!=0?$customers->where('id',Request()->showroom)->first()->name_eng:'All Showroom');
                $printData['search_by']=$type==2?(Request()->category_code && Request()->category_code!=0?$categories->where('id',Request()->category_code)->first()->chart_name:'All Section'):(Request()->category_code && Request()->category_code!=0?$categories->where('code',Request()->category_code)->first()->name_eng:'All Category');
                $routeName=Route::currentRouteName();   
                $printData=getPrintData($routeName,$printData);
            @endphp
             <style type="text/css">{!!$printData['style_css']!!}</style>
            {!!$printData['head']!!}
              
                @if($type==0 || $type==2)
                <table class="table table-bordered table-hover" style="font-size:20px !important" id="data_table_apply">
                    <thead style="background-color: white !important;color:black !important;">
                        @php
                            $tr='<tr class="second-head-tr">';
                            $tr2='<tr class="second-head-tr">';
                        @endphp
                        <tr class="first-head-tr">
                            <th class="verticalTableHeader" style="vertical-align: middle;" rowspan="2">#</th>
                            <th class="verticalTableHeader" style="vertical-align: middle;" rowspan="2">Showroom</th>
                            @forelse ($transacted_products as $a=>$transacted_product)
                                    <th class="text-center verticalTableHeader" style="vertical-align: middle;" colspan="2">{{Request()->name_type==1?$transacted_product->first()->product->name_local:$transacted_product->first()->product->name_eng}}</th>
                                @php
                                    $showroom_order_total[$a]=0;
                                    $showroom_delivery_total[$a]=0;
                                    $tr2.='<th class="text-center verticalTableHeader" style="vertical-align: middle;">O</th><th class="text-center verticalTableHeader" style="vertical-align: middle;">D</th>';
                                @endphp
                            @empty
                            @endforelse
                            <th class="verticalTableHeader text-center" colspan="2">Total</th>
                            @php
                            $tr2.='<th class="text-center verticalTableHeader" style="vertical-align: middle;">O</th><th class="text-center verticalTableHeader" style="vertical-align: middle;">D</th>';
                        @endphp
                        </tr>
                        {!!$tr2.'</tr>'!!}
                    </thead>
                    @php
                        $i=1;
                    @endphp
                    <tbody>
                        {{-- @forelse (Request()->showroom?$customers->where('id',Request()->showroom):$customers as $showroom) --}}
                        @forelse (Request()->showroom?$loopableCustomers->where('id',Request()->showroom):$loopableCustomers as $showroom)
                            @php
                                $s_order_qty=0;
                                $s_qty=0;
                            @endphp
                                <tr>
                                    <td>{{$i++}}</td>
                                    <td>{{$showroom->user_name}}</td>
                                    @forelse ($transacted_products as $k=>$transacted_product)
                                       @php
                                            $transaction_pro=$transacted_product->where('party_id',$showroom->id)->where('product_id',$k);
                                            $s_order_qty+=$order_qty=$transaction_pro->sum('order_qty');
                                            $s_qty+=$qty=$transaction_pro->sum('quantity');
                                            $showroom_order_total[$k]+=$order_qty;
                                            $showroom_delivery_total[$k]+=$qty;
                                        @endphp
                                                <td class="text-right">{{ number_format($order_qty,2) }}</td>
                                                <td class="text-right" style="background-color: #a4a096;">{{ number_format($qty,2) }}</td>
                                    @empty
                                    @endforelse
                                        <td class="text-right"> {{ number_format($s_order_qty,2) }}</td>
                                        <td class="text-right" style="background-color: #a4a096;">{{ number_format($s_qty,2) }}</td>
                                </tr>
                        @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)
                                <td class="text-right"><strong>{{ number_format($showroom_order_total[$m],2) }}<strong></td>
                                <td class="text-right" style="background-color: #a4a096;"><strong>{{ number_format($showroom_delivery_total[$m],2)}}</strong></td>
                            @empty
                            @endforelse
                            <td class="text-right"><strong>{{ number_format(array_sum($showroom_order_total),2) }}</strong></td>
                            <td class="text-right" style="background-color: #a4a096;"><strong>{{ number_format(array_sum($showroom_delivery_total),2) }}</strong></td>
                        </tr>
                    </tfoot>

                </table>
                @else
                <table class="table table-bordered table-hover" id="data_table_apply">
                    <thead style="background-color: white !important;color:black !important;">
                        @php
                            $tr='<tr class="second-head-tr">';
                            $tr2='<tr class="second-head-tr">';
                        @endphp
                        <tr class="first-head-tr">
                            <th class="verticalTableHeader" rowspan="2">#</th>
                            <th class="verticalTableHeader" rowspan="2">PRODUCT</th>
                            {{-- @forelse (Request()->showroom?$customers->where('id',Request()->showroom):$customers as $showroom) --}}
                            @forelse (Request()->showroom?$loopableCustomers->where('id',Request()->showroom):$loopableCustomers as $showroom)
                                    <th class="text-center verticalTableHeader"  colspan="2">{{$showroom->user_name}}</th>
                                    @php
                                        $showroom_order_total[$showroom->id]=0;
                                        $showroom_delivery_total[$showroom->id]=0;
                                        $tr2.='<th class="text-center verticalTableHeader" style="vertical-align: middle;">O</th><th class="text-center verticalTableHeader" style="vertical-align: middle;">D</th>';
                                    @endphp
                            @empty
                            @endforelse
                            <th class="verticalTableHeader text-center" colspan="2">Total</th>
                            @php
                                $tr2.='<th class="text-center verticalTableHeader" style="vertical-align: middle;">O</th><th class="text-center verticalTableHeader" style="vertical-align: middle;">D</th>';
                            @endphp
                        </tr>
                        {!!$tr2.'</tr>'!!}
                    </thead>
                     @php
                        $i=1;
                    @endphp
                    <tbody>
                        @forelse ($transacted_products as $a=>$transacted_product)
                        @php
                            $p_order_qty=0;
                            $p_qty=0;
                        @endphp
                                <tr>
                                    <td>{{$i++}}</td>
                                    <td>{{Request()->name_type==1?$transacted_product->first()->product->name_local:$transacted_product->first()->product->name_eng}}</td>
                                    @forelse (Request()->showroom?$loopableCustomers->where('id',Request()->showroom):$loopableCustomers as $showroom)
                                        @php
                                            $transaction_pro=$transacted_product->where('party_id',$showroom->id)->where('product_id',$a);
                                            $p_order_qty+=$order_qty=$transaction_pro->sum('order_qty');
                                            $p_qty+=$qty=$transaction_pro->sum('quantity');
                                            $showroom_order_total[$showroom->id]+=$order_qty;
                                            $showroom_delivery_total[$showroom->id]+=$qty;
                                        @endphp
                                                <td class="text-right">{{ number_format($order_qty,2) }}</td>
                                                <td class="text-right" style="background-color: #a4a096;">{{ number_format($qty,2) }}</td>
                                    @empty
                                    @endforelse
                                    {{-- @php
                                        $pro_tran=$transacted_product->where('product_id',$a);
                                    @endphp --}}
                                        <td class="text-right"> <strong>{{number_format($p_order_qty,2) }}</strong></td>
                                        <td class="text-right" style="background-color: #a4a096;"><strong>{{number_format($p_qty,2) }} </strong></td>
                                </tr>
                        @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 (Request()->showroom?$loopableCustomers->where('id',Request()->showroom):$loopableCustomers as $showroom)
                            {{-- @forelse (Request()->showroom?$customers->where('id',Request()->showroom):$customers as $showroom) --}}
                                @php

                                   // $tras_total=count($transactions)?$transactions->where('party_id',$showroom->id):[];
                                @endphp
                                    <td class="text-right"><strong>{{ number_format($showroom_order_total[$showroom->id],2) }}<strong></td>
                                    <td class="text-right" style="background-color: #a4a096;"><strong>{{ number_format($showroom_delivery_total[$showroom->id],2)}}</strong></td>
                            @empty
                            @endforelse
                            <td class="text-right"><strong>{{ number_format(array_sum($showroom_order_total),2) }}</strong></td>
                            <td class="text-right" style="background-color: #a4a096;"><strong>{{ number_format(array_sum($showroom_delivery_total),2) }}</strong></td>
                        </tr>
                    </tfoot>

                </table>
                @endif
            </div>
            {{-- vice varcaa dynamic --}}

            <hr>

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

<script type="text/javascript">
    // function PrintDiv() {
    //    var divToPrint = document.getElementById('divTableDataHolder');
    //    var popupWin = window.open('', '_blank', 'width=900,height=900');
    //     popupWin.document.open();
    //     popupWin.document.write('<html><body onload="window.print()">' + divToPrint.innerHTML + '</html>');
    //     popupWin.document.close();
    //         }
</script>
<script>
     $( document ).ready(function() {
        $('.text-right').each(function() {
            var cellText = $(this).text();
            if(cellText=='0.00'){
                $(this).html('-');
                $(this).attr('class', 'text-center');
            }
        });
        $('#data_table_apply').dataTable({
            "paging": false,
        });
    });
    $('.select_2').select2();
</script>
@stop