@extends('admin.template.master')

@section('title')
    <section class="content-header">
        <h1>
            B2B Customers Queries Summary Report
            <small> </small>
        </h1>
        <ol class="breadcrumb">
            <li><a href="{!! url('admin/') !!}"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">B2B Customer Queries  Summary Report</li>
        </ol>
    </section>
@endsection


@section('stylesheets')
    {!! Html::style('assets/admin/bower_components/select2/dist/css/select2.min.css') !!}
    <style>
        table {
            width: 100% !important;
        }

        .hide {
            display: none;
        }

        th, td {
            text-align: center;
        }

        .loader {
            display: none;
        }

        tr:nth-child(even) {
            background-color: #efefef;
        }
    </style>
@endsection

@section('main-content')
    <section class="content">

        @if(Session::has('messages'))
        <div class="row">
            <div class="col-xs-12">
                <div class="alert alert-success alert-dismissible">
                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                    {{Session('messages')}}
                </div>
            </div>
        </div>
        @endif











        <div class="row">
            <div class="col-md-12">
                <div class="box">

                    <div class="form-group col-md-1" style="width: 153px;">
                        {!! Form::label('from_date', 'From Date') !!}
                        {!! Form::date('from_date', \Carbon\Carbon::now(), ['class' => 'form-control', 'id' => 'from_date']) !!}
                    </div>

                    <div class="form-group col-md-1" style="width: 153px;">
                        {!! Form::label('to_date', 'To Date') !!}
                        {!! Form::date('to_date', \Carbon\Carbon::now(), ['class' => 'form-control', 'id' => 'to_date']) !!}
                    </div>


                    <div class="form-group col-md-1" style="width: 142px;">
                        {!! Form::label('Branch affiliation', 'Branch.Affiliation') !!}
                        {!! Form::select('branch_affiliation', $branch_affiliations, null , ['class' => 'form-control desktop_b_type_select2', 'style' => 'width: 142px;', 'id' => 'branch_affiliation']) !!}
                    </div>

                    <div class="form-group col-md-1" style="width: 100px;">
                        {!! Form::label('category', 'Category') !!}
                        {!! Form::select('category', $categories, null , ['class' => 'form-control desktop_b_type_select2', 'style' => 'width: 100px;', 'id' => 'category']) !!}
                    </div>



                    <div class="col-md-1" style="width: 250px;padding-top: 22px; /*margin-left: -40px;*/">
                        {!! Form::button('Search',['class' => 'btn btn-primary btn-order-search', 'id'=> 'search_btn']) !!}
                        {!! Form::button('Reset',['class' => 'btn btn-danger btn-order-search', 'id'=> 'reset_btn']) !!}

                    </div>

                </div>
            </div>
        </div>


        <div class="row">
            <div class="col-md-12">

                <div class="box">
                    <div class="box-body table-responsive">
                        <span class="loader">Loading...</span>
                        <table class="table table-hover" id="b2b_customer_queries_table">
                            <thead>
                            <tr style="background-color:#3c8dbc;color:#fff;">

                                <th >Branch Affiliation</th>

                                <th>Query Qty</th>
                                <th>Query Amount (৳)</th>

                                <th>Price Given Qty</th>
                                <th>Price Given Amount (৳)</th>

                                <th>Done Qty</th>
                                <th>Done Amount (৳)</th>


                                <th>Void Qty</th>
                                <th>Void Amount (৳)</th>



                                <th>Not Available Qty</th>
                                <th>Not Available Amount (৳)</th>


                                <th class="hide">Expired Qty</th>
                                <th class="hide">Expired Amount (৳)</thle=>

                                <th >Query vs Done (%)</th>


                            </tr>
                            </thead>
                            <tbody></tbody>
                            <tfoot>
                                <tr>
                                <th >Branch Affiliation</th>

                                <th>Query Qty</th>
                                <th>Query Amount (৳)</th>

                                <th>Price Given Qty</th>
                                <th>Price Given Amount (৳)</th>

                                <th>Done Qty</th>
                                <th>Done Amount (৳)</th>


                                <th>Void Qty</th>
                                <th>Void Amount (৳)</th>


                                <th>Not Available Qty</th>
                                <th>Not Available Amount (৳)</th>


                                <th class="hide">Expired Qty</th>
                                <th class="hide">Expired Amount (৳)</thle=>

                                <th >Query vs Done (%)</th>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>

            </div>
        </div>













    </section>
@endsection

@section('javascripts')
    {!! Html::script('assets/admin/bower_components/select2/dist/js/select2.full.min.js') !!}


    <script type="text/javascript">
        $(document).ready(function () {

            $("#branch_affiliation").select2();
            $("#category").select2();

            function init() {
                $(".loader").show();
                $("#b2b_customer_queries_table").hide();
                let from_date = $('#from_date').val();
                let to_date = $('#to_date').val();
                let branch_affiliation = $('#branch_affiliation').val();
                let category = $('#category').val();

                $.ajax({
                    type: "GET",
                    url: "{{ route('getCustomerQuerySummary') }}",
                    data: "from="+from_date+"&to="+to_date+"&branch_affiliation="+branch_affiliation+"&category="+category,
                    success:function(res) {
                        // console.log(res, res.length);

                        $("tbody").html('');
                        let str = '';

                        if (parseInt(res.length) <= 6) {
                            $("tfoot").hide();
                        }

                        for(let i=0; i< parseInt(res.length); i++) {
                            // console.log(res[i].order_total_pending_qty);
                            // console.log(res[i].order_total_pending_amount);

                            // console.log(res[i].order_total_price_given_qty);
                            // console.log(res[i].order_total_price_given_amount);


                            // console.log(res[i].order_total_done_qty);
                            // console.log(res[i].order_total_done_amount);

                            // console.log(res[i].order_total_not_available_qty);
                            // console.log(res[i].order_total_not_available_amount);

                            // console.log(res[i].order_total_expired_qty);
                            // console.log(res[i].order_total_expired_amount);

                            // console.log(res[i].percentage);

                            let cssClass = '';
                            if (parseInt(res.length) == 1 ) {
                                cssClass = '';
                            } else {
                                cssClass = (parseInt(i) == 23) ? 'background-color: #3c8dbc;color:#fff;' : ''
                            }

                            str += `<tr style="`+ cssClass +`">
                                    <td>`+ res[i].name +`</td>

                                    <td>`+ res[i].order_total_pending_qty +`</td>
                                    <td>`+ (res[i].order_total_pending_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>

                                    <td>`+ res[i].order_total_price_given_qty +`</td>
                                    <td>`+ (res[i].order_total_price_given_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>

                                    <td>`+ res[i].order_total_done_qty +`</td>
                                    <td>`+ (res[i].order_total_done_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>


                                    <td>`+ res[i].order_void_total_qty +`</td>
                                    <td>`+ (res[i].order_void_total_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>



                                    <td>`+ res[i].order_total_not_available_qty +`</td>
                                    <td>`+ (res[i].order_total_not_available_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>

                                    <td class="hide">`+ res[i].order_total_expired_qty +`</td>
                                    <td class="hide">`+ (res[i].order_total_expired_amount).toLocaleString().replace(/\B(?=(\d{3})+(?!\d))/g, ",") +`</td>

                                    <td >`+ res[i].percentage +`</td>

                                </tr>`;

                        }

                        $("tbody").html(str);
                        $(".loader").hide();
                        $("#b2b_customer_queries_table").show();
                    }
                });
            }
            //   {data: 'order_total_pending_qty' ,sortable:true},{data: 'order_total_pending_amount' ,sortable:true},

            init();


            $("#search_btn").click(function() {
                let from_date = new Date($('#from_date').val());
                let to_date = new Date($('#to_date').val());

                let daysDiff = parseInt((to_date - from_date) / (1000 * 60 * 60 * 24), 10);

                if (parseInt(daysDiff) < 0) {
                    alert('Please select from date must be less than to date');
                } else {

                    // console.log('daysDiff :: ', daysDiff )
                    $("tbody").html('');
                    init();
                }
            });

            $("#reset_btn").click(function() {
                window.location.reload();
            });
        });
    </script>
@endsection