@php
   $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';
    // $routeName=Route::currentRouteName();   
    $printData=getPrintData('order.item_wise_product_sales',$printData);
@endphp
<style type="text/css" media="print">
    {!! $printData['style_css'] !!}
    @media print{@page {size: auto !important}}
</style>
{!! $printData['head'] !!}
<table class="table table-striped">
    @php
        $get_value=$request->get_value;
        $rowspan=$request->get_value?2:3;
        $colspan=$get_value==0?'colspan="2"':'';
    @endphp
    <thead>
        <tr>
            <th class="text-center" rowspan="{{$rowspan}}">#</th>
            <th class="text-center" rowspan="{{$rowspan}}">{{__('obs.product')}}</th>
            <th class="text-center" {!!$colspan!!} rowspan="2">{{__('obs.sales')}}</th>
            <th class="text-center" colspan="{{$get_value?2:4}}">{{__('obs.sales')}} {{__('obs.return')}}</th>
            <th class="text-center" {!!$colspan!!} rowspan="2">{{__('obs.net')}} {{__('obs.sale')}}</th>
        </tr>
        <tr>
            <th {!!$colspan!!} class="text-center">{{__('obs.sd')}}</th>
            <th {!!$colspan!!} class="text-center">{{__('obs.fd')}}</th>
        </tr>
        @if(!$get_value)
            <tr>
                <th class="text-center">{{__('obs.qty')}}</th>
                <th class="text-center">{{__('obs.value')}}</th>
                <th class="text-center">{{__('obs.qty')}}</th>
                <th class="text-center">{{__('obs.value')}}</th>
                <th class="text-center">{{__('obs.qty')}}</th>
                <th class="text-center">{{__('obs.value')}}</th>
                <th class="text-center">{{__('obs.qty')}}</th>
                <th class="text-center">{{__('obs.value')}}</th>
            </tr>
        @endif
    </thead>
    <tbody>
        @php
            $cat_code = '';

            $cat['sales'] = 0;
            $cat['sales_return'] = 0;
            $cat['sales_return_fd'] = 0;
            $cat['net'] = 0;
            $cat['sales_qty'] = 0;
            $cat['sales_return_qty'] = 0;
            $cat['sales_return_fd_qty'] = 0;
            $cat['net_qty'] = 0;
        @endphp
        @foreach ($cat_products as $i=> $item)
            @if ($item->cat_code != $cat_code)
                @if (!$request->product_id)
                    <tr> <td colspan="{{$get_value==0?10:6}}" class="text-center"> <strong> {{ $item->cat_name }} ({{ $item->cat_code }}) </strong> </td> </tr>
                @endif
                @php
                    $cat_code = $item->cat_code;
                @endphp
            @endif
            <tr>
                @php

                    if(in_array($get_value,[0,2])){
                        $cat['sales'] += $item->sales;
                        $cat['sales_return'] += $item->sales_return;
                        $cat['sales_return_fd'] += $item->sales_return_fd;
                        $cat['net'] += $net=($item->sales-$item->sales_return-$item->sales_return_fd);
                    }
                    if(in_array($get_value,[0,1])){
                        $cat['sales_qty'] += $item->sales_qty;
                        $cat['sales_return_qty'] += $item->sales_return_qty;
                        $cat['sales_return_fd_qty'] += $item->sales_return_fd_qty;
                        $cat['net_qty'] += $net_qty=($item->sales_qty-$item->sales_return_qty-$item->sales_return_fd_qty);
                    }
                @endphp
                <td>{{ $i+1 }}</td>
                <td>{{ $item->name_eng }}</td>
                @if(in_array($get_value,[0,1])) 
                    <td class="text-right">{{ number_format($item->sales_qty, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <td class="text-right">{{ number_format($item->sales, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <td class="text-right">{{ number_format($item->sales_return_qty, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <td class="text-right">{{ number_format($item->sales_return, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <td class="text-right">{{ number_format($item->sales_return_fd_qty, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <td class="text-right">{{ number_format($item->sales_return_fd, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <td class="text-right">{{ number_format($net_qty, 2, '.', '') }}</td>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <td class="text-right">{{ number_format($net, 2, '.', '') }}</td>
                @endif
                    
                    
               
            </tr>
            @if (!array_key_exists($i+1, $cat_products->toArray()) || $cat_code != $cat_products[$i+1]->cat_code)
                <tr>
                    <td colspan="2"> <b>{{ $request->product_id?'':$item->cat_name }} Total</b></td>
                    @if(in_array($get_value,[0,1])) 
                        <td class="text-right"><b>{{ number_format($cat['sales_qty'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,2])) 
                        <td class="text-right"><b>{{ number_format($cat['sales'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,1])) 
                        <td class="text-right"><b>{{ number_format($cat['sales_return_qty'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,2])) 
                        <td class="text-right"><b>{{ number_format($cat['sales_return'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,1])) 
                        <td class="text-right"><b>{{ number_format($cat['sales_return_fd_qty'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,2])) 
                        <td class="text-right"><b>{{ number_format($cat['sales_return_fd'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,1])) 
                        <td class="text-right"><b>{{ number_format($cat['net_qty'], 2, '.', '') }}</b></td>
                    @endif
                    @if(in_array($get_value,[0,2])) 
                        <td class="text-right"><b>{{ number_format($cat['net'], 2, '.', '') }}</b></td>
                    @endif

                    {{-- <td class="text-right">{{ number_format($cat['sales'], 2, '.', '') }}</td>
                    <td class="text-right">{{ number_format($cat['sales_return'], 2, '.', '') }}</td>
                    <td class="text-right">{{ number_format($cat['sales_return_fd'], 2, '.', '') }}</td>
                    <td class="text-right">{{ number_format($cat['net'], 2, '.', '') }}</td> --}}
                </tr>
                @php
                    $cat['sales'] = 0;
                    $cat['sales_return'] = 0;
                    $cat['sales_return_fd'] = 0;
                    $cat['net'] = 0;
                    $cat['sales_qty'] = 0;
                    $cat['sales_return_qty'] = 0;
                    $cat['sales_return_fd_qty'] = 0;
                    $cat['net_qty'] = 0;
                @endphp
            @endif
        @endforeach
    </tbody>
    @if (!$request->product_id)
        <tfoot>
            <tr>
                <th colspan="2" class="text-center"> <strong>Total</strong></th>
                @if(in_array($get_value,[0,1])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_qty'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_return_qty'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_return'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_return_fd_qty'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_return_fd'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,1])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales_qty')-$cat_products->sum('sales_return_qty')-$cat_products->sum('sales_return_fd_qty'), 2, '.', '') }}</th>
                @endif
                @if(in_array($get_value,[0,2])) 
                    <th class="text-right">{{ number_format($cat_products->sum('sales')-$cat_products->sum('sales_return')-$cat_products->sum('sales_return_fd'), 2, '.', '') }}</th>
                   
                @endif
                {{-- <td class="text-right">{{ number_format($cat_products->sum('sales'), 2, '.', '') }}</td>
                <td class="text-right">{{ number_format($cat_products->sum('sales_return'), 2, '.', '') }}</td>
                <td class="text-right">{{ number_format($cat_products->sum('sales_return_fd'), 2, '.', '') }}</td>
                <td class="text-right">{{ number_format($cat_products->sum('net'), 2, '.', '') }}</td> --}}
            </tr>
        </tfoot>
    @endif
</table>
{!! $printData['foot'] !!}