@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: 28px !important;
        }
        .table th, .table td {
                padding: 0px 5px;
                color: black;
            }
            .table th {
            background: var(--tableHeader);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;
            }
            #data_table_apply_filter{
                display: none;
            }
            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">
            <form action="{{  Request::url() }}" method="get">
                    <div class="row d-flex flex-wrap">
                        <div class="col-2">
                            <div class="form-group">
                                <select name="product_id" id="product_id" class="form-control select_2">
                                    <option value="0">{{__('obs.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">
                            <select name="showroom" id="showroom" class="form-control select_2">
                                <option value="0">{{__('obs.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="col-2">
                            <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>{{__('obs.by_quantity')}}</option>
                                    <option value="1" @if(Request()->get_value==1) selected="selected" @endif>{{__('obs.by_value')}}</option>
                                </select>
                            </div>
                        </div>
                        @if($type!=3)
                        <div class="col-2">
                            <div class="form-group">
                                <select name="return_type" id="return_type" class="form-control select_2">
                                    <option value="0" @if(Request()->return_type==0) selected="selected" @endif>{{__('obs.all')}}</option>
                                    <option value="1" @if(Request()->return_type==1) selected="selected" @endif>{{__('obs.sales_return')}}</option>
                                    <option value="2" @if(Request()->return_type==2) selected="selected" @endif>{{__('obs.fd_return')}}</option>
                                </select>
                            </div>
                        </div>
                        @endif
                        <div class="col-4 pl-0">
                            <div class="form-group">
                                <div class="input-group-append">
                                    {!!getDateInput('date_from','date_from',Request()->date_from)!!}
                                    <label class="input-group-text" style="height: 28px; margin-left: -2px; margin-right: -2px">{{__('obs.date_to')}}</label>
                                    {!!getDateInput('date_to','date_to',Request()->date_to)!!}
                                    {{-- <input type="text" class="form-control date_picker_report" 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">{{__('obs.date_to')}}</label>
                                    <input type="text" class="form-control date_picker_report" 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']!!}
           
            <table style="width:100%" class="table table-bordered table-hover" id="data_table_apply">
                <thead>
                    <tr>
                        <th rowspan="2" style="border: 1px solid #000 !important;text-align:center;background: var(--tableHeader);padding: 5px !important;color: white !important;" style="background: var(--tableHeader);padding: 5px !important;color: white !important;">#</th>
                        <th rowspan="2" style="border: 1px solid #000 !important;text-align:center;background: var(--tableHeader);padding: 5px !important;color: white !important;">{{__('obs.showroom')}}</th>
                        @forelse ($months as $month=>$dates)
                            <th colspan="{{count($dates)}}" style="border: 1px solid #000 !important;text-align:center;background: var(--tableHeader);padding: 5px !important;color: white !important;">{{$month}}</th>
                        @empty

                        @endforelse
                        
                        <th rowspan="2" style="border: 1px solid #000 !important;text-align:center;background: var(--tableHeader);padding: 5px !important;color: white !important;">{{__('obs.total')}}</th>
                    </tr>
                    <tr>
                        @forelse ($dateArray as $date)
                            <th style="border: 1px solid #000 !important;text-align:center;background: var(--tableHeader);padding: 5px !important;color: white !important;">{{date('d',strtotime($date))}}</th>
                        @empty

                        @endforelse
                    </tr>
                </thead>
                @php
                    $i=1;
                    $total=[];
                @endphp
                <tbody>
                    @forelse ($showRooms as $party_id => $showRoom)
                    <tr>
                        @php
                            $s_qty=0;
                        @endphp
                        <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)){
                                $qty=0;
                                    foreach ($dayWiseSales[$date]->where('party_id',$party_id)->groupBy('product_id') as $product_id=>$items){
                                        if(Request()->get_value==1){
                                            if($type==3){
                                                $qty=$items->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);});
                                            }else{
                                                $return_type=Request()->return_type;
                                                $qty=$items->sum(function($t)use($return_type){
                                                                                $a=($t->quantity * $t->avg_price);
                                                                                $p=($a*((100-$t->dc_price)/100));
                                                                                $inv=$t->invoice;
                                                                                if($return_type && ($t->transaction_type==7) && ($t->dr_cr==0)){
                                                                                    if($return_type==2){
                                                                                        return $p;
                                                                                    }else{
                                                                                        $p=($p*($inv->party_return_percentage/100));
                                                                                    }
                                                                                } 
                                                                                // if($inv && $inv->other_dc_percentage!=0){
                                                                                //         return ($p+($p*$inv->other_dc_percentage)/100);
                                                                                // }else{
                                                                                    return $p;
                                                                                // }
                                                                            });
                                            }
                                        }else{
                                            $qty=$items->sum('quantity');
                                        }
                                    }
                            }else{
                                $qty=0;
                            }
                            if(array_key_exists($date,$total)){
                                $total[$date]+=$qty;
                            }else{
                                $total[$date]=$qty;
                            }
                            $s_qty+=$qty;
                        @endphp
                            <td style="border: 1px solid #000 !important;" class="text-right">{{number_format($qty,2)}}</td>
                        @empty

                        @endforelse
                        <td style="border: 1px solid #000 !important;" class="text-right">{{number_format($s_qty,2)}}</td>
                        </tr>

                    @empty
                    @endforelse
                </tbody>
                <tfoot>
                    <tr>
                        @php
                            $ts_qty=0;
                        @endphp
                        <td style="border: 1px solid #000 !important;text-align:center;" colspan="2">{{__('obs.total')}}</td>
                        @forelse ($dateArray as $date)
                        @php
                        $tqty=0;
                        if(array_key_exists($date,$total)){
                            $tqty=$total[$date];
                        }
                        $ts_qty+=$tqty;
                        @endphp
                            <td style="border: 1px solid #000 !important;" class="text-right">{{number_format($tqty,2)}}</td>
                        @empty
    
                        @endforelse
                        <td style="border: 1px solid #000 !important;" class="text-right">{{number_format($ts_qty,2)}}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <hr>
        <div class="row pb-0  modal-footer">
        </div>
    </div>
</div>
{{-- @include('inventory.order.detail_modal') --}}
@endsection
@section('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