@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: #ab3535;
           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;
    }
    tfoot td {
        background: #ab3535 !important;
        color: white !important;
    }
    @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">
        {{-- <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-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">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>By Quantity</option>
                                    <option value="2" @if(Request()->get_value==2) selected="selected" @endif>By Value</option>
                                    <option value="0" @if(Request()->get_value==0) selected="selected" @endif>By Quantity & Value</option>
                                </select>
                            </div>
                        </div>
                        @php
                            $r_types=[3=>'Sales',4=>'Return',1=>'NET',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
                                    {{-- <option value="3" @if(3==$type) selected="selected" @endif>Sales</option>
                                    <option value="4" @if(4==$type) selected="selected" @endif>Return</option>
                                    <option value="0" @if(0==$type) selected="selected" @endif>Sales & Return</option> --}}
                                </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">
                                    <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="button" style="height: 28px; margin-left: -2px" onclick="getReportData()" 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="reportTableDataHolder">
                    
                </table>
                {{-- <table class="table table-bordered table-hover" id="data_table_apply">

                </table> --}}
                @include('inventory.global.loader')
            </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,
        //         drawCallback: function () {
        //         var api = this.api();
        //         $('#total').html(
        //             parseFloat(api.column( 9 ).data().sum()).toFixed(2)
        //         );
        // }
        // });
    });
    $('.select_2').select2();
    const getReportData=()=>{
        let link= "{{route('order.new_sales_summery')}}";
        let data_param={
            category_code   :$('#category_code').val(),
            showroom        :$('#showroom').val(),
            get_value       :$('#get_value').val(),
            transaction_type:$('#transaction_type').val(),
            date_from         :$('#date_from').val(),
            date_to         :$('#date_to').val()
        };
        const setReportDataPartyWise = data => {
            $('#reportTableDataHolder').html(data);
            $("#showroom_name").text($("#showroom option:selected" ).text());
            $("#search_by").text($("#transaction_type option:selected" ).text());
            $('#search_date').text(($('#date_from').val())+' - '+($('#date_to').val()));
            
            // $('#reportTableDataHolder').DataTable({
            //     columnDefs: [
            //         // { "targets": 0, "orderable": false}
            //     ],
            //     drawCallback: function () {
            //         var api = this.api();
            //         $('#total').html(
            //             parseFloat(api.column( 9, {page:'current'} ).data().sum()).toFixed(2)
            //         );
            //     }
            // } );
            $('#loader').hide();
        }
        ajaxCall(link,'GET',data_param, setReportDataPartyWise);

    }
    const getFormatedReportDate=(dateToBeFormated)=>{
        const month = ["","January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
        var now = new Date(dateToBeFormated);
        var day = ("0" + now.getDate()).slice(-2)
        // var month = ("0" + (now.getMonth() + 1)).slice(-2);
        var return_date = (day)+nth(day)+"-"+(month[now.getMonth()])+"-"+now.getFullYear() ;
        return return_date;//now.toLocaleFormat('%dS-%b-%Y');
    }
    const nth = function(d) {
        if (d > 3 && d < 21) return 'th';
        switch (d % 10) {
            case 1:  return "st";
            case 2:  return "nd";
            case 3:  return "rd";
            default: return "th";
        }
    }
    
</script>
@stop