@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: var(--tableHeader_font) !important;
           text-align: center !important;
           vertical-align: middle !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">
    @include('admin.layout.title_header', ['title'=>'SALES SUMMERY(ITEM WISE)'])
    
    <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">
                        <div class="col-4">
                            <div class="form-group">
                                <select name="category_code" id="category_code" class="form-control select_2">
                                <option value="0">{{__('obs.select_category')}}</option>
                                @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>
                        <div class="col-3">
                            <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-3">
                            <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-2">
                            <div class="form-group">
                                <select name="fd_type" id="fd_type" class="form-control select_2">
                                    <option value="0" @if(Request()->fd_type==0) selected="selected" @endif>{{__('obs.partial_fd')}} ({{__('obs.percent')}})</option>
                                    <option value="1" @if(Request()->fd_type==1) selected="selected" @endif>{{__('obs.full_fd')}}</option>
                                </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="0" @if(Request()->get_value==0) selected="selected" @endif>{{__('obs.both')}}</option>
                                    <option value="1" @if(Request()->get_value==1) selected="selected" @endif>{{__('obs.quantity')}}</option>
                                    <option value="2" @if(Request()->get_value==2) selected="selected" @endif>{{__('obs.value')}}</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-8">
                            <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="button" onclick="getReport()" 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">
                <div id="report_html">

                </div>
                {{-- @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($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>
                        <tr>
                            <th rowspan="2">#</th>
                            <th rowspan="2">{{__('obs.product')}}</th>
                            <th rowspan="2">{{__('obs.sales')}}</th>
                            <th colspan="2">{{__('obs.sales')}} {{__('obs.return')}}</th>
                            <th rowspan="2">{{__('obs.netsale')}}</th>
                        </tr>
                        <tr>
                            <th>{{__('obs.sd')}}</th>
                            <th>{{__('obs.fd')}}</th>
                        </tr>
                    </thead>
                    @php
                        $i=1;
                        $sales_total=0;
                        $sales_return_total=0;
                        $sales_return_fd_total=0;
                    @endphp
                    <tbody>
                       @forelse ($transactions->groupBy('product.cat_code') as $k=>$categoryProduct)
                            @php
                                $sales_total_g=0;
                                $sales_return_total_g=0;
                                $sales_return_fd_total_g=0;
                                $cat_name=$categoryProduct->first()->product->catByCatCode?$categoryProduct->first()->product->catByCatCode->name_eng:'N/A';
                            @endphp
                            <tr>
                                <td colspan="6" class="text-center" style="text-align: center; font-weight: bold;">{{$cat_name}}</td>
                            </tr>

                            @forelse ($categoryProduct->groupBy('product_id') as $key=>$item)
                                @php
                                    $sales=Request()->get_value==1
                                            ?$item->where('transaction_type',3)
                                            // ->sum(function($t){ return ($t->quantity * $t->avg_price)-(($t->quantity * $t->avg_price * $t->dc_price)/100);})
                                            ->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;
                                                }
                                            })
                                            :$item->where('transaction_type',3)->sum('quantity');
                                            $sales_return=Request()->get_value==1?$item->where('transaction_type','=',4)
                                                                                            ->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;
                                                                                                }
                                                                                            })
                                                                                        :$item->where('transaction_type','=',4)->sum('quantity');
                                            $sales_return_fd=Request()->get_value==1?$item->where('transaction_type','=',7)
                                                                                            ->sum(function($t){
                                                                                                $a=($t->quantity * $t->avg_price);
                                                                                                $p=($a*((100-$t->dc_price)/100));
                                                                                                $inv=$t->invoice;
                                                                                                if(($t->dr_cr==0) && (!Request()->fd_type)){
                                                                                                    $p=($p*($inv->party_return_percentage/100));
                                                                                                } 
                                                                                                if($inv->other_dc_percentage!=0){
                                                                                                    return ($p+($p*$inv->other_dc_percentage)/100);
                                                                                                }else{
                                                                                                    return $p;
                                                                                                }
                                                                                            })
                                                                                        :$item->where('transaction_type','=',7)->sum('quantity');
                                @endphp
                                @if($sales>0 || $sales_return>0 || $sales_return_fd>0)
                                    <tr>
                                        <td>{{$i++}}</td>
                                        <td>{{$item->first()->product->name_eng}}</td>
                                        <td class="text-right">{{number_format($sales,2)}}</td>
                                        <td class="text-right">{{number_format($sales_return,2)}}</td>
                                        <td class="text-right">{{number_format($sales_return_fd,2)}}</td>
                                        <td class="text-right">{{number_format(($sales-$sales_return-$sales_return_fd),2)}}</td>
                                    </tr>
                                    @php
                                        $sales_total_g+=$sales;
                                        $sales_return_total_g+=$sales_return;
                                        $sales_return_fd_total_g+=$sales_return_fd;

                                        $sales_total+=$sales;
                                        $sales_return_total+=$sales_return;
                                        $sales_return_fd_total+=$sales_return_fd;
                                    @endphp
                                @endif
                            @empty
                            @endforelse
                            <tr>
                                <td class="text-right" colspan="2">Total {{$cat_name}}</td>
                                <td class="text-right">{{number_format(($sales_total_g),2)}}</td>
                                <td class="text-right">{{number_format(($sales_return_total_g),2)}}</td>
                                <td class="text-right">{{number_format(($sales_return_fd_total_g),2)}}</td>
                                <td class="text-right">{{number_format(($sales_total_g-$sales_return_total_g-$sales_return_fd_total_g),2)}}</td>
                            </tr>
                        @empty
                        <tr>
                            <td colspan="6" class="bg-dark text-center text-warning">{{__('obs.no')}} {{__('obs.data')}} {{__('obs.available')}}</td>
                        </tr>
                       @endforelse
                    </tbody>
                      <tfoot>
                        <tr>
                            <th class="text-right" colspan="2">{{__('obs.total')}}</th>
                            <th class="text-right">{{number_format(($sales_total),2)}}</th>
                            <th class="text-right">{{number_format(($sales_return_total),2)}}</th>
                            <th class="text-right">{{number_format(($sales_return_fd_total),2)}}</th>
                            <th class="text-right">{{number_format(($sales_total-$sales_return_total-$sales_return_fd_total),2)}}</th>
                        </tr>
                    </tfoot>
                </table> --}}
            </div>

            <hr>

            <div class="row pb-0  modal-footer">
            </div>
    </div>
</div>
@include('admin.global.loader')
@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();
    const getReport=()=>
    {
        let link="{{route('order.item_wise_product_sales_api')}}";
        let c=null;
        let int_data_param={
            category_code:$('#category_code').val(),
            product_id:$('#product_id').val(),
            showroom:$('#showroom').val(),
            fd_type:$('#fd_type').val(),
            get_value:$('#get_value').val(),
            date_from:$('#date_from').val(),
            date_to:$('#date_to').val(),
            ajax_call:1
        }
        const setReportHtml = data => {
            $('#report_html').html(data);
            $('#loader').hide();
        }
        ajaxCall(link,'GET',int_data_param, setReportHtml);
    }

</script>
@stop