@extends('admin.layout.master')
@section('title','Sales 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: var(--tableHeader);
           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;
        }
        #data_table_apply_filter{
            display: none;
        }
</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; }

    .table th {
        background: #fff;
        color: #000 !important;
    }
    }

</style>

@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'SALES SUMMERY(ITEM WISE)'])
    <div class="card-body">
        <div class="card-body" style="padding-bottom:0">
            <form action="{{  Request::url() }}" method="get">
                <div class="">
                    <div class="row">
                        <div class="col-4">
                            <div class="form-group">
                                <select name="category_code[]" id="category_code" class="form-control select_2" multiple>
                                    @forelse ($categories as $category)
                                        <option value="{{$category->id}}" data-category_id="{{$category->id}}">{{$category->name_eng}}</option>
                                    @empty
                                    @endforelse
                                </select>
                            </div>
                        </div>

                        <div class="col-4">
                            <div class="form-group">
                                <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>

                        <div class="col-4">
                            <div class="form-group">
                                <select name="get_value" id="get_value" class="form-control select_2">
                                    <option value="1" @if(Request()->get_value==1) selected="selected" @endif>{{__("obs.by_quantity")}}</option>
                                    <option value="2" @if(Request()->get_value==2) selected="selected" @endif>{{__("obs.by_value")}}</option>
                                    <option value="0" @if(Request()->get_value==0) selected="selected" @endif>{{__("obs.by_quantity_and_value")}}</option>
                                </select>
                            </div>
                        </div>
                        @php
                            $r_types=[3=>'Sales',4=>'Return',0=>'Sales & Return'];
                        @endphp
                        <div class="col-4">
                            <div class="form-group">
                                <select name="transaction_type" id="transaction_type" class="form-control select_2">
                                    @forelse ($r_types as $kk=>$tt)   
                                        <option value="{{$kk}}" @if($kk==$type) selected="selected" @endif>{{$tt}}</option>
                                    @empty
                                        
                                    @endforelse
                                </select>
                            </div>
                        </div>
                        <div class="col-8 col-lg-offset-2 col-md-offset-2 col-sm-offset-2">
                            <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']='SALES SUMMERY';
                    $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['search_by']=$r_types[$type];
                    $printData['showroom']=Request()->showroom && Request()->showroom!=0?$customers->where('id',Request()->showroom)->first()->name_eng:'All Showroom';
                    $routeName=Route::currentRouteName();
                    $printData=getPrintData($routeName,$printData);
                @endphp
                 <style type="text/css">
                    {!!$printData['style_css']!!}
                 </style>
                {!!$printData['head']!!}
                <table class="table table-bordered table-hover" id="data_table_apply">
                    <thead> 
                        @php
                            $tr='<tr class="second-head-tr">';
                            $tr2='<tr class="third-head-tr">';
                        @endphp
                        <tr class="first-head-tr">
                            <th rowspan="{{$type==0?3:2}}" class="text-center" style="vertical-align: middle;">#</th>
                            <th rowspan="{{$type==0?3:2}}" class="text-center" style="vertical-align: middle;">{{__("obs.showroom")}}</th>
                            @forelse ($transactions->groupBy('product.sub_category_id') as $cc=>$categoryProduct)
                                @if($cc!=null)
                                    <th colspan="{{Request()->get_value?($type==0?3:1):($type==0?6:2)}}" class="text-center">{{$categoryProduct->first()->product->subCategory?$categoryProduct->first()->product->subCategory->name_eng:'N/A'}}</th>
                                    @php
                                        if(Request()->get_value==1){
                                            $tr.='<th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.qty")}}</th>';
                                            if($type==0){
                                                $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                            }
                                        }else if(Request()->get_value==2){
                                            $tr.='<th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.amount")}}</th>';
                                            if($type==0){
                                                $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                            }
                                        }else{
                                            $tr.='<th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.qty")}}</th><th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.amount")}}</th>';
                                            if($type==0){
                                                $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                                $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                            }
                                        }
                                    @endphp
                                @endif
                            @empty
                            @endforelse
                            <th class="text-center" colspan="{{Request()->get_value?($type==0?(Request()->get_value==2?4:3):3):($type==0?7:4)}}">{{__("obs.total")}}</th>
                            @php
                                if(Request()->get_value==1){
                                    $tr.='<th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.qty")}}</th>';
                                    if($type==0){
                                        $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                    }
                                }else if(Request()->get_value==2){
                                    $tr.='<th'.($type==0? ' colspan="4"':'').' class="text-center">{{__("obs.amount")}}</th>';
                                    if($type==0){
                                        $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.other_charge")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                    }else{
                                        $tr.='<th class="text-center">{{__("obs.other_charge")}}</th>';
                                        $tr.='<th class="text-center">{{__("obs.net")}}</th>';
                                    }
                                }else{
                                    $tr.='<th'.($type==0? ' colspan="3"':'').' class="text-center">{{__("obs.qty")}}</th><th'.($type==0? ' colspan="4"':'').' class="text-center">{{__("obs.amount")}}</th>';
                                    if($type==0){
                                        $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.sales")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.sales_return")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.other_charge")}}</th>';
                                        $tr2.='<th class="text-center">{{__("obs.net")}}</th>';
                                    }else{
                                        $tr.='<th class="text-center">{{__("obs.other_charge")}}</th>';
                                        $tr.='<th class="text-center">{{__("obs.net")}}</th>';
                                    }
                                }
                            @endphp
                    </tr>
                    {!! newBladeStringCompiler($tr.'</tr>', []) !!}
                    {{-- {!! $tr.'</tr>' !!} --}}
                    @if($type==0)
                        {!! newBladeStringCompiler($tr2.'</tr>', []) !!}
                        {{-- {!! $tr2.'</tr>' !!} --}}
                    @endif
                    </thead>

                    @php
                        $i=1;
                        $total_oc_gt=0;
                    @endphp
                    <tbody>
                        @forelse ($transactions->groupBy('party_id') as $key=>$showroom)
                            @if($key!=null)
                                    @php
                                        $total_cat_qty=0;
                                        $total_cat_sum=0;
                                        $total_cat_r_qty=0;
                                        $total_cat_r_sum=0;
                                    @endphp
                                <tr>
                                    <td class="text-center">{{$i++}}</td>
                                    <td><strong>{{$showroom->first()->showroom->name_eng}}</strong></td>
                                    @forelse ($transactions->groupBy('product.sub_category_id') as $m=>$categoryProduct)
                                    @if($m!=null)
                                        @php
                                            $cat_qty=0;
                                            $cat_sum=0;
                                            $cat_r_qty=0;
                                            $cat_r_sum=0;
                                        @endphp
                                        {{-- product Category --}}
                                        @forelse ($categoryProduct->groupBy('product_id') as $k=>$transacted_product)
                                            @php
                                                $filtered_transaction= $transacted_product->where('party_id',$key)->where('product_id',$k);
                                                $cat_qty+=$filtered_transaction->where('transaction_type','=',3)->sum('quantity');
                                                // $cat_sum+=$filtered_transaction->where('transaction_type','=',3)->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);});
                                                $cat_sum+=$filtered_transaction->where('transaction_type','=',3)
                                                                                ->sum(function($t){
                                                                                    $a=($t->quantity * $t->avg_price);
                                                                                    $p=($a*((100-$t->dc_price)/100));
                                                                                    $inv=$t->invoice; 
                                                                                    if($inv->other_dc_percentage!=0){
                                                                                         return ($p+($p*$inv->other_dc_percentage)/100);
                                                                                    }else{
                                                                                        return $p;
                                                                                    }
                                                                                });
                                                $cat_r_qty+=$filtered_transaction->where('transaction_type','!=',3)->sum('quantity');
                                                // $cat_r_sum+=$filtered_transaction->where('transaction_type','!=',3)->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);});
                                                $cat_r_sum+=$filtered_transaction->where('transaction_type','!=',3)
                                                                                    ->sum(function($t){
                                                                                        $a=($t->quantity * $t->avg_price);
                                                                                        $p=($a*((100-$t->dc_price)/100));
                                                                                        $inv=$t->invoice;
                                                                                        if(($t->transaction_type==7) && ($t->dr_cr==0)){
                                                                                            $p=($p*($inv->party_return_percentage/100));
                                                                                        } 
                                                                                        if($inv->other_dc_percentage!=0){
                                                                                             return ($p+($p*$inv->other_dc_percentage)/100);
                                                                                        }else{
                                                                                            return $p;
                                                                                        }
                                                                                    });
                                            @endphp
                                        @empty
                                        @endforelse
                                        {{-- product Category --}}
                                        @php 
                                            $total_cat_qty+=$cat_qty;
                                            $total_cat_sum+=$cat_sum; 
                                            $total_cat_r_qty+=$cat_r_qty;
                                            $total_cat_r_sum+=$cat_r_sum; 
                                        @endphp
                                        
                                       

                                        @if(Request()->get_value==1)
                                            @if($type==0)
                                                <td class="text-right">{{number_format($cat_qty,2)}}</td>
                                                <td class="text-right">{{number_format($cat_r_qty,2)}}</td>
                                                <td class="text-right">{{number_format(($cat_qty-$cat_r_qty),2)}}</td>
                                            @elseif($type==3)
                                                <td class="text-right">{{number_format($cat_qty,2)}}</td>
                                            @elseif($type==4)
                                                <td class="text-right">{{number_format($cat_r_qty,2)}}</td>
                                            @endif
                                        @elseif(Request()->get_value==2)
                                            @if($type==0)
                                                <td class="text-right">{{number_format($cat_sum,2)}}</td>
                                                <td class="text-right">{{number_format($cat_r_sum,2)}}</td>
                                                <td class="text-right">{{number_format(($cat_sum-$cat_r_sum),2)}}</td>
                                            @elseif($type==3)
                                                <td class="text-right">{{number_format($cat_sum,2)}}</td>
                                            @elseif($type==4)
                                                <td class="text-right">{{number_format($cat_r_sum,2)}}</td>
                                            @endif
                                        @else
                                            @if($type==0)
                                                <td class="text-right">{{number_format($cat_qty,2)}}</td>
                                                <td class="text-right">{{number_format($cat_r_qty,2)}}</td>
                                                <td class="text-right">{{number_format(($cat_qty-$cat_r_qty),2)}}</td>
                                                <td class="text-right">{{number_format($cat_sum,2)}}</td>
                                                <td class="text-right">{{number_format($cat_r_sum,2)}}</td>
                                                <td class="text-right">{{number_format(($cat_sum-$cat_r_sum),2)}}</td>
                                            @elseif($type==3)
                                                <td class="text-right">{{number_format($cat_qty,2)}}</td>
                                                <td class="text-right">{{number_format($cat_sum,2)}}</td>
                                            @elseif($type==4)
                                                <td class="text-right">{{number_format($cat_r_qty,2)}}</td>
                                                <td class="text-right">{{number_format($cat_r_sum,2)}}</td>
                                            @endif
                                        @endif
                                    @endif

                                    @empty
                                    @endforelse
                                    @php
                                        $total_oc=$showRoomWiseInvoices[$key]->sum('other_charge');
                                        $total_oc_gt+=$total_oc; 
                                    @endphp
                                    @if(Request()->get_value==1)
                                            @if($type==0)
                                                <td class="text-right">{{number_format($total_cat_qty,2)}}</td>
                                                <td class="text-right">{{number_format($total_cat_r_qty,2)}}</td>
                                                <td class="text-right">{{number_format(($total_cat_qty-$total_cat_r_qty),2)}}</td>
                                            @elseif($type==3)
                                                <td class="text-right">{{number_format($total_cat_qty,2)}}</td>
                                            @elseif($type==4)
                                                <td class="text-right">{{number_format($total_cat_r_qty,2)}}</td>
                                            @endif
                                    @elseif(Request()->get_value==2)
                                        @if($type==0)
                                            <td class="text-right">{{number_format($total_cat_sum,2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_r_sum,2)}}</td>
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_sum-$total_cat_r_sum),2)}}</td>
                                        @elseif($type==3)
                                            <td class="text-right">{{number_format($total_cat_sum,2)}}</td>
                                            {{--  --}}
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_sum),2)}}</td>
                                        @elseif($type==4)
                                            <td class="text-right">{{number_format($total_cat_r_sum,2)}}</td>
                                            {{--  --}}
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_r_sum),2)}}</td>
                                        @endif
                                    @else
                                        @if($type==0)
                                            <td class="text-right">{{number_format($total_cat_qty,2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_r_qty,2)}}</td>
                                            <td class="text-right">{{number_format(($total_cat_qty-$total_cat_r_qty),2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_sum,2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_r_sum,2)}}</td>
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_sum-$total_cat_r_sum),2)}}</td>
                                        @elseif($type==3)
                                            <td class="text-right">{{number_format($total_cat_qty,2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_sum,2)}}</td>
                                            {{--  --}}
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_sum),2)}}</td>
                                        @elseif($type==4)
                                            <td class="text-right">{{number_format($total_cat_r_qty,2)}}</td>
                                            <td class="text-right">{{number_format($total_cat_r_sum,2)}}</td>
                                            {{--  --}}
                                            <td class="text-right">{{number_format($total_oc,2)}}</td>
                                            <td class="text-right">{{number_format(($total_oc+$total_cat_r_sum),2)}}</td>
                                        @endif
                                    @endif
                                </tr>
                            @endif
                        @empty
                        @endforelse
                    </tbody>
                    <tfoot>
                        <tr class="first-head-tr">
                            <th colspan="2" class="text-right">{{__("obs.total")}}</th>
                            @php
                                $gtotal_cat_qty=0;
                                $gtotal_cat_sum=0;
                                $gtotal_cat_r_qty=0;
                                $gtotal_cat_r_sum=0;
                            @endphp
                            @forelse ($transactions->groupBy('product.sub_category_id') as $m=>$categoryProduct)
                            @if($m!=null)
                                @php
                                    $cat_qty_gt=0;
                                    $cat_sum_gt=0;
                                    $cat_r_qty_gt=0;
                                    $cat_r_sum_gt=0;
                                @endphp
                                @forelse ($categoryProduct->groupBy('product_id') as $k=>$transacted_product)
                                    @php
                                        $sales_transaction=$transacted_product->where('product_id',$k)->where('transaction_type','=',3);
                                        $sales__return_transaction=$transacted_product->where('product_id',$k)->where('transaction_type','!=',3);
                                        $cat_qty_gt+=$sales_transaction->sum('quantity');
                                        // $cat_sum_gt+=$sales_transaction->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);});
                                        $cat_sum_gt+=$sales_transaction->sum(function($t){
                                                                            $a=($t->quantity * $t->avg_price);
                                                                            $p=($a*((100-$t->dc_price)/100));
                                                                            $inv=$t->invoice; 
                                                                            if($inv->other_dc_percentage!=0){
                                                                                 return ($p+($p*$inv->other_dc_percentage)/100);
                                                                            }else{
                                                                                return $p;
                                                                            }
                                                                        });
                                        $cat_r_qty_gt+=$sales__return_transaction->sum('quantity');
                                        // $cat_r_sum_gt+=$sales__return_transaction->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);}); 
                                        $cat_r_sum_gt+=$sales__return_transaction->sum(function($t){
                                                                                    $a=($t->quantity * $t->avg_price);
                                                                                    $p=($a*((100-$t->dc_price)/100));
                                                                                    $inv=$t->invoice;
                                                                                    if(($t->transaction_type==7) && ($t->dr_cr==0)){
                                                                                        $p=($p*($inv->party_return_percentage/100));
                                                                                    } 
                                                                                    if($inv->other_dc_percentage!=0){
                                                                                         return ($p+($p*$inv->other_dc_percentage)/100);
                                                                                    }else{
                                                                                        return $p;
                                                                                    }
                                                                                }); 
                                    @endphp
                                @empty
                                @endforelse
                            @php 
                                $gtotal_cat_qty+=$cat_qty_gt;
                                $gtotal_cat_sum+=$cat_sum_gt; 
                                $gtotal_cat_r_qty+=$cat_r_qty_gt;
                                $gtotal_cat_r_sum+=$cat_r_sum_gt; 
                            @endphp

                                @if(Request()->get_value==1)
                                    @if($type==0)
                                        <td class="text-right">{{number_format($cat_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_r_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format(($cat_qty_gt-$cat_r_qty_gt),2)}}</td>
                                    @elseif($type==3)
                                        <td class="text-right">{{number_format($cat_qty_gt,2)}}</td>
                                    @elseif($type==4)
                                        <td class="text-right">{{number_format($cat_r_qty_gt,2)}}</td>
                                    @endif
                                @elseif(Request()->get_value==2)
                                    @if($type==0)
                                        <td class="text-right">{{number_format($cat_sum_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_r_sum_gt,2)}}</td>
                                        <td class="text-right">{{number_format(($cat_sum_gt-$cat_r_sum_gt),2)}}</td>
                                    @elseif($type==3)
                                        <td class="text-right">{{number_format($cat_sum_gt,2)}}</td>
                                    @elseif($type==4)
                                        <td class="text-right">{{number_format($cat_r_sum_gt,2)}}</td>
                                    @endif
                                @else
                                    @if($type==0)
                                        <td class="text-right">{{number_format($cat_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_r_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format(($cat_qty_gt-$cat_r_qty_gt),2)}}</td>
                                        <td class="text-right">{{number_format($cat_sum_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_r_sum_gt,2)}}</td>
                                        <td class="text-right">{{number_format(($cat_sum_gt-$cat_r_sum_gt),2)}}</td>
                                    @elseif($type==3)
                                        <td class="text-right">{{number_format($cat_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_sum_gt,2)}}</td>
                                    @elseif($type==4)
                                        <td class="text-right">{{number_format($cat_r_qty_gt,2)}}</td>
                                        <td class="text-right">{{number_format($cat_r_sum_gt,2)}}</td>
                                    @endif
                                @endif

                            @endif
                            @empty
                            @endforelse
                            @if(Request()->get_value==1)
                                @if($type==0)
                                    <td class="text-right">{{number_format($gtotal_cat_qty,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_r_qty,2)}}</td>
                                    <td class="text-right">{{number_format(($gtotal_cat_qty-$gtotal_cat_r_qty),2)}}</td>
                                @elseif($type==3)
                                    <td class="text-right">{{number_format($gtotal_cat_qty,2)}}</td>
                                @elseif($type==4)
                                    <td class="text-right">{{number_format($gtotal_cat_r_qty,2)}}</td>
                                @endif
                            @elseif(Request()->get_value==2)
                                @if($type==0)
                                    <td class="text-right">{{number_format($gtotal_cat_sum,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_r_sum,2)}}</td>
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_sum-$gtotal_cat_r_sum),2)}}</td>
                                @elseif($type==3)
                                    <td class="text-right">{{number_format($gtotal_cat_sum,2)}}</td>
                                    {{--  --}}
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_sum-$gtotal_cat_r_sum),2)}}</td>
                                @elseif($type==4)
                                    <td class="text-right">{{number_format($gtotal_cat_r_sum,2)}}</td>
                                    {{--  --}}
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_sum-$gtotal_cat_r_sum),2)}}</td>
                                @endif
                            @else
                                @if($type==0)
                                    <td class="text-right">{{number_format($gtotal_cat_qty,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_r_qty,2)}}</td>
                                    <td class="text-right">{{number_format(($gtotal_cat_qty-$gtotal_cat_r_qty),2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_sum,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_r_sum,2)}}</td>
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_sum-$gtotal_cat_r_sum),2)}}</td>
                                @elseif($type==3)
                                    <td class="text-right">{{number_format($gtotal_cat_qty,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_sum,2)}}</td>
                                    {{--  --}}
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_sum),2)}}</td>
                                @elseif($type==4)
                                    <td class="text-right">{{number_format($gtotal_cat_r_qty,2)}}</td>
                                    <td class="text-right">{{number_format($gtotal_cat_r_sum,2)}}</td>
                                    {{--  --}}
                                    <td class="text-right">{{number_format($total_oc_gt,2)}}</td>
                                    <td class="text-right">{{number_format(($total_oc_gt+$gtotal_cat_r_sum),2)}}</td>
                                @endif
                            @endif
                        </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() {
        //alert();
            var cellText = $(this).text();
            if(cellText=='0.00'){
                $(this).text('-');
                $(this).attr('class', 'text-center');
            }
        });
        $('#data_table_apply').dataTable({
            "paging": false,
            // "ordering": false,
            // "columnDefs": [ {
            //     "orderable": true,
            //     'targets': 1,
            // } ]
        });
    });
    $('.select_2').select2();
    
</script>
@stop