@include('layouts.header');
@include('layouts.sidebar');


<script type="text/javascript" src="https://cdn.datatables.net/plug-ins/1.11.5/api/sum().js"></script>


<!--<script src="https://cdn.jsdelivr.net/gh/linways/table-to-excel@v1.0.4/dist/tableToExcel.js"></script>-->
<link href='css/jquery-ui.css' rel='stylesheet'>

<link href='css/jquery-ui.css' rel='stylesheet'>
<script src="js/jquery.min.js"></script>
<script src="js/jquery-ui.min.js"></script>
<script src="js/jquery.validate.js"></script>


<!--<link rel="stylesheet" href="assets/vendor/timepicker/jquery.timepicker.min.css" />
<script src="assets/vendor/timepicker/jquery.timepicker.min.js"></script>
-->

<style>
    /* .dataTables_wrapper .dt-buttons{
float:none;
text-align:left;
}
.dataTables_wrapper .dataTables_filter {
  float:none;
text-align:right;
} */

    /*fixed column datatable css*/

    table.dataTable thead tr>.dtfc-fixed-left,
    table.dataTable thead tr>.dtfc-fixed-right {
        z-index: 1;
        background-color: #ffd4d4;
        size: 250px;
    }

    table.dataTable tbody tr>.dtfc-fixed-left,
    table.dataTable tbody tr>.dtfc-fixed-right {
        z-index: 1;
        background-color: #ffd4d4
    }

    div.dtfc-left-top-blocker,
    div.dtfc-right-top-blocker {
        background-color: #ffd4d4
    }

    /*fixed header datatable css*/
    table.fixedHeader-floating {
        background-color: white
    }

    table.fixedHeader-floating.no-footer {
        border-bottom-width: 0
    }

    table.fixedHeader-locked {
        position: absolute !important;
        background-color: white
    }

    @media print {
        table.fixedHeader-floating {
            display: none,

        }
    }



    /*excel export*/



    div.dt-buttons {

        float: right;
        top: -60px;
    }

    .dataTables_wrapper .dataTables_filter {

        margin-right: -45px;
    }

    button.dt-button,
    div.dt-button,
    a.dt-button {
        position: relative;
        display: inline-block;
        box-sizing: border-box;
        margin-right: 0;
        padding: 0;
        border: 0;
        border-radius: 0;
        cursor: pointer;
        font-size: 0;
        color: black;
        white-space: nowrap;
        overflow: hidden;
        background-color: #e9e9e900;
        background-image: -webkit-linear-gradient(top, #e9e9e900 0%, #e9e9e900 100%);
        background-image: -moz-linear-gradient(top, #e9e9e900 0%, #e9e9e900 100%);
        background-image: -ms-linear-gradient(top, #e9e9e900 0%, #e9e9e900 100%);
        background-image: -o-linear-gradient(top, #e9e9e900 0%, #e9e9e900 100%);
        background-image: linear-gradient(to bottom, #e9e9e900 0%, #e9e9e900 100%);
        filter: progid:DXImageTransform.Microsoft.gradient(GradientType=0, StartColorStr='#e9e9e900', EndColorStr='#e9e9e900');
        -webkit-user-select: none;
        -moz-user-select: none;
        -ms-user-select: none;
        user-select: none;
        text-decoration: none;
        outline: none;
    }

    .row-odd {
        border-radius: 2px;
        background: #9631312b;
        padding: 5px;
    }

    .row-even {
        border-radius: 2px;
        background: #9631315e;
        padding: 5px;
    }

    .button {
        background-color: #963131;
        color: white;
        text-align: center;
        font-size: 12px;
        padding-top: 3px;

    }

    .button:hover {
        background-color: antiquewhite;
        color: #963131;
    }

    button:hover {
        background-color: white;
    }

    /* .chart-area11 {
    margin-top: 0px;
    width: 498px;
    display: block;
    box-sizing: border-box;
    height: 325.6px;
    margin-left: -92px;
  } */

    .filter {
        width: 165px;
    }

    .ui-datepicker {
        width: 300px;
        height: 300px;
        color: #963131;
        margin: 5px auto 0;
        font: 12pt Arial, sans-serif;
        /*-webkit-box-shadow: 0px 0px 10px 0px rgba(0, 0, 0, .5);
    -moz-box-shadow: 0px 0px 10px 0px rgba(0, 0, 0, .5);*/

    }

    .ui-datepicker-header {
        background: #963131;
        color: #963131;
        font-family: 'Times New Roman';
        border-width: 1px 0 0 0;
        border-style: solid;
        border-color: #111;
    }

    .ui-datepicker-calendar .ui-state-default {
        background: linear-gradient(#963131, #963131);
        color: #ffffff;
        height: 35px;
        width: 35px;
        border: 1px;
        border-radius: 2px;

    }

    .ui-datepicker-calendar .ui-state-hover {
        background: white;
        color: #963131;
    }



    .ui-timepicker-standard a {
        border: 1px solid #d4d4d4;
        color: #ffffff;
        display: block;
        padding: 0.2em 0.4em;
        text-decoration: none;
        background-color: #963131;
    }

    /* .ui-menu .ui-menu-item {
    margin: 0;
    cursor: pointer;
    list-style-image: url(data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7);
    background-color: #963131;
} */

    .ui-timepicker-standard .ui-menu-item {
        margin: 0 auto;
        padding: 0 30%;
    }

    .export_excel {
        float: right;
        margin-top: -54px;
    }


    @media screen and (max-width: 640px) {
        div.dt-buttons {
            float: right !important;
            text-align: center;
        }
    }


    #pageloader {
        background: rgb(255 255 255 / 20%);
        display: none;
        height: 100%;
        position: fixed;
        width: 100%;
        z-index: 9999;
    }

    #pageloader img {
        left: 60%;
        margin-left: -90px;
        margin-top: -32px;
        position: absolute;
        top: 40%;
        height: 150px;
        border: black;
        border-style: double;
        background-color: antiquewhite;
        border-radius: 20px;
    }

    @media screen and (max-width: 600px) {
        #pageloader img {
            left: 50%;
            margin-left: -90px;
            margin-top: -32px;
            position: absolute;
            top: 50%;
            height: 150px;
            border: black;
            border-style: double;
            background-color: antiquewhite;
            border-radius: 20px;
        }


    }

    #rhi_report_length,
    #rhi_report_filter {
        padding: 5px;
    }

    #rhi_report_filter {
        margin-right: -13px !important;
    }

    /* .kpt_report {
        display: none;
    } */

    .export {
        float: right;
        margin-top: -50px;
        border: 0;
        background-color: white;
        color: #963131;
        display: none;
    }
</style>

<body>
    <div class="col-lg-12" id="pageloader">
        <img src="images/256x256.gif">

    </div>
    @include ('layouts.head')


    <main id="main" class="main">

        <!-- <h1>All Live Oreder status </h1> -->
        <div class="card">
            <div class="card-body">
                <h5 class="card-title">Restaurant Health Index</h5>
                <button id="export" class="export" onclick="ExportToExcel('xlsx')" type="button"><i
                        class="fas fa-file-excel" title="Download Excel"></i></button>

                <!-- Default Tabs -->
                <ul class="nav nav-tabs d-flex" id="myTabjustified" role="tablist">
                    <!-- <li class="nav-item flex-fill" role="presentation">
                    <button class="nav-link w-100 active" id="home-tab" data-bs-toggle="tab" data-bs-target="#home-justified" type="button" role="tab" aria-controls="home" aria-selected="true">Sales Report</button>
                </li> -->
                    <!-- <li class="nav-item flex-fill" role="presentation">
                    <button class="nav-link w-100" id="profile-tab" data-bs-toggle="tab" data-bs-target="#profile-justified" type="button" role="tab" aria-controls="profile" aria-selected="false">Weekly</button>
                </li>
                <li class="nav-item flex-fill" role="presentation">
                    <button class="nav-link w-100" id="contact-tab" data-bs-toggle="tab" data-bs-target="#contact-justified" type="button" role="tab" aria-controls="contact" aria-selected="false">Mothly</button>
                </li>
                <li class="nav-item flex-fill" role="presentation">
                    <button class="nav-link w-100" id="year-tab" data-bs-toggle="tab" data-bs-target="#year-justified" type="button" role="tab" aria-controls="year" aria-selected="false">Yearly</button>
                </li> -->
                </ul>
                <div class="tab-content pt-1" id="myTabjustifiedContent">
                    <div class="tab-pane fade show active" id="home-justified" role="tabpanel"
                        aria-labelledby="home-tab">
                        <div class="card">
                            <div class="card-body">
                                <!-- <h5 class="card-title">Search Accourding To</h5> -->
                                <!-- Floating Labels Form -->
                                <form class="pt-3 g-3" id="cancel_report" method="POST">
                                    <div class="row">
                                        <input type="hidden" value="{{ csrf_token() }}" name="_token">


                                        <div class="col-md-4">
                                            <div class="form-floating mb-3">
                                                <select class="form-select" id="kitchen" name="kitchen"
                                                    aria-label="">
                                                    <!-- <select class="form-select" id="kitchen" name="kitchen" onchange="get_brands_on_kitchen(this.value);" aria-label=""> -->
                                                    <option value="">All</option>
                                                    @foreach ($kitchens as $Kitchen)
                                                                                                                <option value="{{ $Kitchen['id'] }}">
                                                            {{ $Kitchen['kitchen_name'] }} </option>
                                                    @endforeach

                                                </select>
                                                <label for="floatingName">Select Kitchen</label>
                                            </div>
                                        </div>
                                        {{-- <div class="col-md-4">
                                            <div class="form-floating mb-3">
                                                <select class="form-select" id="brand" name="brand"
                                                    aria-label="">
                                                    <option value=""></option>


                                                </select>
                                                <label for="floatingName">Select Brand/Entity</label>
                                            </div>
                                        </div> --}}
                                        <div class="col-md-4">
                                            <div class="form-floating mb-3">
                                                <select class="form-select" id="aggrator" name="aggrator"
                                                    aria-label="">
                                                    <option></option>
                                                    <option value="zomato">Zomato</option>
                                                    <option value="swiggy">Swiggy</option>
                                                    <option value="take_away">Take Away</option>
                                                </select>
                                                <label for="floatingName">Select Aggregator</label>
                                                <p id="projectIDSelectError3" style="color:red"></p>
                                            </div>
                                        </div>
                                        <!-- <div class="col-md-3"></div> -->
                                        <!-- <div class="col-md-4">
                                                <div class="form-floating">
                                                <select class="form-select" id="sub_brand" name="sub_brand" aria-label="">
                                                    <option value=""></option>
                                                    <option value="">Sub Brand 1</option>
                                                    <option value="">Sub Brand 2</option>
                                                    <option value="">Sub Brand 3</option>


                                                </select>
                                                <label for="floatingName">Select Sub Brand</span></label>
                                                </div>
                                            </div>-->
                                        <!-- <div class="col-md-3"></div> -->
                                        <div class="col-md-4">
                                            <div class="form-floating">
                                                <input type="text" class="form-control" id="from_date"
                                                    name="from_date" autocomplete="off" placeholder="Your Name"
                                                    required="" readonly='true'>
                                                <label for="floatingName">From Date</span></label>
                                                <p id="projectIDSelectError1" style="color:red"></p>
                                            </div>
                                        </div>

                                        <div class="col-md-4">
                                            <div class="form-floating">
                                                <input type="text" class="form-control" id="to_date"
                                                    name="to_date" autocomplete="off" placeholder="Your Name"
                                                    required="" readonly='true'>
                                                <label for="floatingName">To Date</span></label>
                                                <p id="projectIDSelectError2" style="color:red"></p>

                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                        </div>
                                        <div class="col-md-4">
                                        </div>


                                    </div>

                                    <div class="row">

                                        <!-- <div class="col-md-5"></div> -->
                                        <div class="col-md-5"></div>


                                        <div class="text-center col-md-1" style="align-self: center; padding:0px;">
                                            <button type="button" id="submit" onclick="get_rhi()"
                                                class="btn btn-primary">Submit</button>
                                        </div>
                                        &nbsp;
                                        <div class="text-center col-md-1" style="align-self: center;">
                                            <button type="reset" id=""
                                                class="btn btn-primary">Reset</button>
                                        </div>
                                    </div>
                                </form>


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

                </div>

            </div>
        </div>


        <div class="col-lg-12" id="reset_tables">
            <div class="card">

                <!-- <div class="col-lg-12"> -->
                <!-- <a href="{{ url('export') }}" type="button" class="btn btn-primary">EXPORT</a> -->
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Revenue</h5>

                        <table id="rhi_report_revenue" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Orders</h5>

                        <table id="rhi_report_orders" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">AOV</h5>

                        <table id="rhi_report_aov" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Order Growth %</h5>

                        <table id="rhi_report_order_growth" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Revenue Growth %</h5>

                        <table id="rhi_report_revenue_growth" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Discount</h5>

                        <table id="rhi_report_discount" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">Discount %</h5>

                        <table id="rhi_report_discount_percent" class='display dataTable nowrap'>


                        </table>


                    </div>
                </div>
                <div class="card">

                    <div class="card-body" id="tcp_table1" style="overflow-x:auto;">
                        <h5 class="card-title">KPT</h5>

                        <table id="rhi_report_kpt" class='display dataTable nowrap'>


                        </table>


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

        </div>

    </main>

    @include('layouts.footer');

    <script>
        var data = {};
        var arr = {};
        data['_token'] = "{{ csrf_token() }}";
        arr['_token'] = "{{ csrf_token() }}";

        $(document).ready(function() {
            // $("#tcp_table1").load(location.href+" #tcp_table1>*","");
            //$("#from_date").val('2022-11-01');
            // $("#to_date").val('2022-11-14');
            $(function() {
                $("#from_date").datepicker({
                    dateFormat: "yy-mm-dd",
                    maxDate: "+0m +0w",
                    changeMonth: true,
                    changeYear: true,


                });
                $("#from_date").change(function() {
                    test = $(this).datepicker('getDate');
                    testm = new Date(test.getTime());
                    testm.setDate(testm.getDate() + 0);

                    $("#to_date").datepicker("option", "minDate", testm);
                });
                $("#to_date").datepicker({
                    dateFormat: "yy-mm-dd",
                    maxDate: "+0m +0w",
                    changeMonth: true,
                    changeYear: true,

                });


            });

            $('#cancel_report').validate({
                rules: {
                    //country: "required",
                    from_date: "required",
                    to_date: "required",
                    aggrator:"required"
                },

                highlight: function(element) {
                    $(element).addClass('error-border');
                    $(element).removeClass('success-border');
                },
                unhighlight: function(element) {
                    $(element).removeClass('error-border');
                    $(element).addClass('success-border');
                },
                messages: {
                    from_date: {
                        required: "This field is required."
                    },
                    to_date: {
                        required: "This field is required."
                    },
                    aggrator: {
                        required: "This field is required."
                    },

                },
                errorPlacement: function(error, element) {
                    if (element.attr("name") == "from_date") {
                        error.appendTo('#projectIDSelectError1');

                    } else if (element.attr("name") == "to_date") {
                        error.appendTo('#projectIDSelectError2');

                    } else if (element.attr("name") == "aggrator") {
                        error.appendTo('#projectIDSelectError3');

                    } else {
                        error.insertAfter(element);
                    }
                }
            });


            setInterval(function() {
                $('#rhi_report_revenue').children('thead:not(:last)').remove();
                $('#rhi_report_orders').children('thead:not(:last)').remove();
                // $('#rhi_report_orders').children('tfoot:not(:last)').remove();
                $('#rhi_report_aov').children('thead:not(:last)').remove();
                $('#rhi_report_revenue_growth').children('thead:not(:last)').remove();
                $('#rhi_report_order_growth').children('thead:not(:last)').remove();
                $('#rhi_report_discount').children('thead:not(:last)').remove();
                $('#rhi_report_discount_percent').children('thead:not(:last)').remove();
                $('#rhi_report_kpt').children('thead:not(:last)').remove();
            }, 100);



        });

        function ExportToExcel(type, fn, dl) {

            var elt = [];
            elt.push('rhi_report_revenue');
            elt.push('rhi_report_orders');
            elt.push('rhi_report_aov');
            elt.push('rhi_report_revenue_growth');
            elt.push('rhi_report_order_growth');
            elt.push('rhi_report_discount');
            elt.push('rhi_report_discount_percent');
            elt.push('rhi_report_kpt');
            var htmltable = '';
            elt.forEach(myFunction);

            var idTable = '';
            var table = '';
            // $("th").css("border", "solid");
            // $("td").css("border", "groove");
            function myFunction(item, index) {
                //function fnExcelReport() {

                var fullTable = document.getElementById(item);
                //     $("td").removeAttr("style");
                // $("th").removeAttr("style");
                // console.log(item);
                var tableHtml = '';
                if (item == 'rhi_report_revenue') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Revenue Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_orders') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Orders Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_aov') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">AOV Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_revenue_growth') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Revenue Growth Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_order_growth') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Order Growth  Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces


                }
                if (item == 'rhi_report_discount') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Discount Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_discount_percent') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">Discount Percent Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_kpt') {

                    idTable =
                        '<table><thead><tr><th></th></tr><tr><th style="font-size: 24px;">KPT Report</th></tr></thead></table>';
                    tableHTML = idTable.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                    htmltable = htmltable + tableHTML;

                }



                table = fullTable; // id of table
                tableHTML = table.outerHTML;



                tableHTML = tableHTML.replace(/  /g, '').replace(/ /g, '%20'); // replaces spaces

                htmltable = htmltable + tableHTML;


            }
            // $("th").css("border", "none");
            // $("td").css("border", "none");

            //console.log(htmltable);return false;
            var a = document.createElement('a');
            
            let currentDate = new Date().toJSON().slice(0, 10);
            var fileName = 'HOB_'+currentDate+'.xls';
            
            a.href = 'data:application/vnd.ms-excel,' + htmltable;
            a.setAttribute('download', fileName);
            document.body.appendChild(a);
            a.click();
            document.body.removeChild(a);



        }


        function get_rhi() {
            if ($("#cancel_report").valid()) {
                // $("#reset_tables").load(location.href + " #reset_tables");
                // $('#rhi_report').DataTable().destroy();
                data['kitchen_id'] = $("#kitchen").val();
                data['from_date'] = $("#from_date").val();
                data['to_date'] = $("#to_date").val();
                //data['brand_id'] = $("#brand").val();
                data['aggrator'] = $("#aggrator").val();
                data['_token'] = "{{ csrf_token() }}";

                $.ajax({
                    url: "{{ url('get_rhi_report') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data = '';
                        var dates = '';
                        var kitchens = '';
                        data = obj['data'];
                        dates = obj['dates'];
                        kitchens = obj['kitchens'];
                        load_table(data, dates, kitchens);
                        orders_data(data, dates, kitchens);
                        aov(data, dates, kitchens);
                        order_growth(data, dates, kitchens);
                        revenue_growth(data, dates, kitchens);
                        discount(data, dates, kitchens);
                        discount_percentage(data, dates, kitchens);
                        kpt();


                        $(".export").css("display", "block")
                    },
                    error: function() {}

                });
            }

        }

        function load_table(arr, dates, kitchens) {

            $('#rhi_report_revenue').find("tr").remove();

            //***************************revenue table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_revenue").append('<thead><tr>' + t_row + '</tr></thead>');

            //***************************revenue table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            //  $("#rhi_report_revenue").append('<tfoot><tr>' + t_row_foot + '</tr></tfoot>');


            //***************************revenue table body*********************//
            $("#rhi_report_revenue").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.revenue + '</td>';
                                    total = total + value2.revenue;
                                }

                            });
                        }
                    }
                });
                revenueTotal = 0;
                var revenueTotal = '<td>' + total + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenueTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue").append('<tr>' + n_row + '</tr>');
                }


                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.revenue + '</td>';
                                    total = total + value2.revenue;
                                }

                            });
                        }
                    }
                });
                revenueTotal = 0;
                revenueTotal = '<td>' + total + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenueTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.revenue + '</td>';
                                    total = total + value2.revenue;
                                }

                            });
                        }
                    }
                });
                revenueTotal = 0;
                revenueTotal = '<td>' + total + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenueTotal;
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue").append('<tr>' + n_row + '</tr>');
                }


                $("#rhi_report_revenue").append('</tbody>');
            });

            sum_data('rhi_report_revenue');
        }


        function orders_data(arr, dates, kitchens) {
            $('#rhi_report_orders').find("tr").remove();
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';
            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_orders").append('<thead>' + t_row + '</thead>');


            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';
            });

            t_row_foot = t_row_foot + '<th>--</th>';
            //  $("#rhi_report_orders").append('<tfoot>' + t_row_foot + '</tfoot>');




            $("#rhi_report_orders").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    if (value2.revenue == 0) {
                                        next_row = next_row + '<td>' + 0 + '</td>';
                                        total = parseInt(total) + 0;
                                    } else {
                                        next_row = next_row + '<td>' + value2.order_count + '</td>';
                                        total = parseInt(total) + parseInt(value2.order_count);
                                        //console.log(total); console.log(value2.order_count);
                                    }

                                }
                              
                            });
                        }
                    }
                });
                
                order_countTotal = 0;
                var order_countTotal = '<td>' + total + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_countTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_orders").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    if (value2.revenue == 0) {
                                        next_row = next_row + '<td>' + 0 + '</td>';
                                        total = parseInt(total) + 0;
                                    } else {
                                        next_row = next_row + '<td>' + value2.order_count + '</td>';
                                        total = parseInt(total) + parseInt(value2.order_count);
                                        //console.log(total); console.log(value2.order_count);
                                    }

                                }

                            });
                        }
                    }
                });
                order_countTotal = 0;
                order_countTotal = '<td>' + total + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_countTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_orders").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    if (value2.revenue == 0) {
                                        next_row = next_row + '<td>' + 0 + '</td>';
                                        total = parseInt(total) + 0;
                                    } else {
                                        next_row = next_row + '<td>' + value2.order_count + '</td>';
                                        total = parseInt(total) + parseInt(value2.order_count);
                                        //console.log(total); console.log(value2.order_count);
                                    }

                                }

                            });
                        }
                    }
                });
                order_countTotal = 0;
                order_countTotal = '<td>' + total + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_countTotal;
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_orders").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_orders").append('</tbody>');

            });
            sum_data('rhi_report_orders');
        }

        function aov(arr, dates, kitchens) {
            $('#rhi_report_aov').find("tr").remove();
            //***************************aov table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_aov").append('<thead>' + t_row + '</thead>');


            //***************************aov table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            // $("#rhi_report_aov").append('<tfoot>' + t_row_foot + '</tfoot>');
            $("#rhi_report_aov").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.avg.replace(/\,/g, '') +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.avg);
                                }

                            });
                        }
                    }
                });
                aovTotal = 0;
                aovTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                var n_row = '';
                n_row = next_row_kitchen.replace(/\,/g, '') + next_row_type.replace(/\,/g, '') + next_row.replace(
                    /\,/g, '') + aovTotal.replace(/\,/g, '');

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_aov").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.avg.replace(/\,/g, '') +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.avg);
                                }

                            });
                        }
                    }
                });
                aovTotal = 0;
                aovTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen.replace(/\,/g, '') + next_row_type.replace(/\,/g, '') + next_row.replace(
                    /\,/g, '') + aovTotal.replace(/\,/g, '');

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_aov").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.avg.replace(/\,/g, '') +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.avg);
                                }

                            });
                        }
                    }
                });
                aovTotal = 0;
                aovTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen.replace(/\,/g, '') + next_row_type.replace(/\,/g, '') + next_row.replace(
                    /\,/g, '') + aovTotal.replace(/\,/g, '');
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_aov").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_aov").append('</tbody>');

            });
            sum_data('rhi_report_aov');

        }

        function order_growth(arr, dates, kitchens) {
            $('#rhi_report_order_growth').find("tr").remove();
            //***************************order_growth table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_order_growth").append('<thead>' + t_row + '</thead>');

            //***************************order_growth table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            //$("#rhi_report_order_growth").append('<tfoot>' + t_row_foot + '</tfoot>');

            //***************************order_growth table body*********************//
            $("#rhi_report_order_growth").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                   // console.log(value2.order_growth);
                                    next_row = next_row + '<td>' + value2.order_growth.toFixed(2) +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.order_growth);
                                }

                            });
                        }
                    }
                });
                order_growthTotal = 0;
                order_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_growthTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_order_growth").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    //console.log(value2.order_growth);
                                    next_row = next_row + '<td>' + value2.order_growth.toFixed(2) +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.order_growth);
                                }

                            });
                        }
                    }
                });
                order_growthTotal = 0;
                order_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_growthTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_order_growth").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.order_growth.toFixed(2) +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2.order_growth);
                                }

                            });
                        }
                    }
                });

                order_growthTotal = 0;
                order_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + order_growthTotal;
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_order_growth").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_order_growth").append('</tbody>');

            });
            sum_data('rhi_report_order_growth');


        }

        function revenue_growth(arr, dates, kitchens) {
            $('#rhi_report_revenue_growth').find("tr").remove();
            //***************************order_growth table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_revenue_growth").append('<thead>' + t_row + '</thead>');

            //***************************order_growth table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            // $("#rhi_report_revenue_growth").append('<tfoot>' + t_row_foot + '</tfoot>');

            //***************************order_growth table body*********************//
            $("#rhi_report_revenue_growth").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.revenue_growth.toFixed(
                                        2) + '</td>';
                                    total = parseFloat(total) + parseFloat(value2.revenue_growth);
                                }

                            });
                        }
                    }
                });
                revenue_growthTotal = 0;
                revenue_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenue_growthTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue_growth").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.revenue_growth.toFixed(
                                        2) + '</td>';
                                    total = parseFloat(total) + parseFloat(value2.revenue_growth);
                                }

                            });
                        }
                    }
                });
                revenue_growthTotal = 0;
                revenue_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenue_growthTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue_growth").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.revenue_growth.toFixed(
                                        2) + '</td>';
                                    total = parseFloat(total) + parseFloat(value2.revenue_growth);
                                }

                            });
                        }
                    }
                });
                revenue_growthTotal = 0;
                revenue_growthTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + revenue_growthTotal;
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_revenue_growth").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_revenue_growth").append('</tbody>');

            });
            sum_data('rhi_report_revenue_growth');
        }


        function discount(arr, dates, kitchens) {
            $('#rhi_report_discount').find("tr").remove();
            //***************************discount table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_discount").append('<thead>' + t_row + '</thead>');

            //***************************discount table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            //$("#rhi_report_discount").append('<tfoot>' + t_row_foot + '</tfoot>');

            //***************************discount table body*********************//
            $("#rhi_report_discount").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    //                                     next_row = next_row + '<td>' + parseFloat(value2.discount)
                                    //                                         .toLocaleString(undefined, {
                                    //                                             minimumFractionDigits: 2
                                    //                                         }) + '</td>';
                                    next_row = next_row + '<td>' + value2.discount.toFixed(2) +
                                        '</td>';
                                    total = total + value2.discount;
                                }

                            });
                        }
                    }
                });
                discountTotal = 0;
                discountTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discountTotal.replace(/\,/g, '');

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    //                                     next_row = next_row + '<td>' + parseFloat(value2.discount)
                                    //                                         .toLocaleString(undefined, {
                                    //                                             minimumFractionDigits: 2
                                    //                                         }) + '</td>';
                                    next_row = next_row + '<td>' + value2.discount.toFixed(2) +
                                        '</td>';
                                    total = total + value2.discount;
                                }

                            });
                        }
                    }
                });
                discountTotal = 0;
                discountTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discountTotal.replace(/\,/g, '');

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    //                                     next_row = next_row + '<td>' + parseFloat(value2.discount)
                                    //                                         .toLocaleString(undefined, {
                                    //                                             minimumFractionDigits: 2
                                    //                                         }) + '</td>';
                                    //                                     total = parseFloat(total) + parseFloat(value2.discount);
                                    next_row = next_row + '<td>' + value2.discount.toFixed(2) +
                                        '</td>';
                                    total = total + value2.discount;
                                }

                            });
                        }
                    }
                });
                discountTotal = 0;
                discountTotal = '<td>' + parseFloat(total).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discountTotal.replace(/\,/g, '');
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_discount").append('</tbody>');

            });
            sum_data('rhi_report_discount');

        }

        function discount_percentage(arr, dates, kitchens) {
            $('#rhi_report_discount_percent').find("tr").remove();
            //***************************discount percent  table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_discount_percent").append('<thead>' + t_row + '</thead>');

            //***************************discount percent table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            //$("#rhi_report_discount_percent").append('<tfoot>' + t_row_foot + '</tfoot>');

            //***************************discount percent table body*********************//
            $("#rhi_report_discount_percent").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.discount_percentage +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2
                                        .discount_percentage);
                                }

                            });
                        }
                    }
                });
                discount_percentageTotal = 0;
                discount_percentageTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                var n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discount_percentageTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount_percent").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.discount_percentage +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2
                                        .discount_percentage);
                                }

                            });
                        }
                    }
                });
                discount_percentageTotal = 0;
                discount_percentageTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discount_percentageTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount_percent").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    next_row = next_row + '<td>' + value2.discount_percentage +
                                        '</td>';
                                    total = parseFloat(total) + parseFloat(value2
                                        .discount_percentage);
                                }

                            });
                        }
                    }
                });
                discount_percentageTotal = 0;
                discount_percentageTotal = '<td>' + parseFloat(total / dates.length).toLocaleString(undefined, {
                    minimumFractionDigits: 2
                }) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + discount_percentageTotal;
                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_discount_percent").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_discount_percent").append('</tbody>');

            });
            sum_data('rhi_report_discount_percent');
        }

        function kpt() {
            $('#rhi_report_kpt').find("tr").remove();
            var data = {};
            data['kitchen_id'] = $("#kitchen").val();
            data['from_date'] = $("#from_date").val();
            data['to_date'] = $("#to_date").val();
            //data['brand_id'] = $("#brand").val();
            data['aggrator'] = $("#aggrator").val();
            data['_token'] = "{{ csrf_token() }}";
            data['kpt'] = "1";
            $.ajax({
                url: "{{ url('get_rhi_report') }}",
                type: "POST",
                data: data,
                success: function(data) {
                    var obj = '';
                    obj = jQuery.parseJSON(data);
                    var data = '';
                    var dates = '';
                    var kitchens = '';
                    data = obj['data'];
                    dates = obj['dates'];
                    kitchens = obj['kitchens'];
                    kpt_report(data, dates, kitchens);
                }
            });
        }

        function kpt_report(arr, dates, kitchens) {
            $('#rhi_report_kpt').find("tr").remove();
            //***************************kpt table header*********************//
            var t_row = '<th>Kitchen</th><th>Aggregator</th>';
            $.each(dates, function(key, value1) {
                t_row = t_row + '<th>' + value1.date + ' ' + value1.day + '</th>';


            });

            t_row = t_row + '<th>MTD Grand Total</th>';
            $("#rhi_report_kpt").append('<thead>' + t_row + '</thead>');

            //***************************kpt table footer*********************//
            var t_row_foot = '<th>--</th><th>--</th>';
            $.each(dates, function(key, value1) {
                t_row_foot = t_row_foot + '<th>--</th>';


            });

            t_row_foot = t_row_foot + '<th>--</th>';
            // $("#rhi_report_kpt").append('<tfoot>' + t_row_foot + '</tfoot>');

            //***************************kpt table body*********************//
            $("#rhi_report_kpt").append('<tbody>');
            $.each(kitchens, function(key, value1) {
                var next_row = '';
                var next_row_kitchen = '';
                var next_row_type = '';
                var next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                var total = parseFloat(0);
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'swiggy') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {

                                // console.log(value2.date);
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.kpt + '</td>';
                                    //console.log(Date.parse(value2.kpt));
                                    var time = value2.kpt;
                                    //console.log(time);
                                    var convertion =Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time.split(":")[2]) * 1000;

                                    var milliseconds = Number(convertion);
                                    //console.log(milliseconds);
                                    total = Number(total) + Number(milliseconds);
                                    //console.log(total);
                                }

                            });
                        }
                    }
                });
                kptTotal = 0;
                kptTotal = '<td>' + msToTime(Number(total / dates.length)) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + kptTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_kpt").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'zomato') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.kpt + '</td>';
                                    //console.log(Date.parse(value2.kpt));
                                    var time = value2.kpt;
                                    //console.log(time);
                                    var convertion =Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time.split(":")[2]) * 1000;

                                    var milliseconds = Number(convertion);
                                    //console.log(milliseconds);
                                    total = Number(total) + Number(milliseconds);
                                    //console.log(total);
                                }


                            });
                        }
                    }
                });

                //console.log(msToTime(Number(total / dates.length)));
                //  console.log(Number(total / dates.length));
                kptTotal = 0;
                kptTotal = '<td>' + msToTime(Number(total / dates.length)) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + kptTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_kpt").append('<tr>' + n_row + '</tr>');
                }



                next_row = '';
                next_row_kitchen = '';
                next_row_type = '';
                next_row_kitchen = '<td>' + value1.kitchen + '</td>';
                total = 0;
                $.each(arr, function(key, value2) {
                    //console.log(value2);return false;
                    if (value2.kitchen == value1.kitchen) {
                        if (value2.aggregator == 'take away') {
                            next_row_type = '<td>' + value2.aggregator + '</td>';
                            $.each(dates, function(key, value3) {
                                if (value3.date == value2.date) {
                                    //console.log(value2.revenue);
                                    next_row = next_row + '<td>' + value2.kpt + '</td>';
                                    //console.log(Date.parse(value2.kpt));
                                    var time = value2.kpt;
                                    //console.log(time);
                                    var convertion =Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time.split(":")[2]) * 1000;

                                    var milliseconds = Number(convertion);
                                    //console.log(milliseconds);
                                    total = Number(total) + Number(milliseconds);
                                    //console.log(total);
                                }

                            });
                        }
                    }
                });
                kptTotal = 0;
                kptTotal = '<td>' + msToTime(Number(total / dates.length)) + '</td>';
                n_row = '';
                n_row = next_row_kitchen + next_row_type + next_row + kptTotal;

                //console.log(n_row); return false;
                if (next_row == '') {

                } else {
                    $("#rhi_report_kpt").append('<tr>' + n_row + '</tr>');
                }
                $("#rhi_report_kpt").append('</tbody>');

            });
            sum_kot('rhi_report_kpt');
        }

          function sum_kot(id) {

            var totalRow = '',
                 columnNo = $('#' + id + ' th').length;
                var rowNo = $('#' + id + ' tr').length - 1;
                //console.log(rowNo)
            for (var index = 0; index < columnNo; index++) {
                var total = 0;

                $('#' + id + ' tr').each(function() {
                    var time = $('td', this).eq(index).text(); //+ will convert string to number
                    console.log(time);
                    //time=time.toString();
                    if (time == 0 || time == NaN || time == '') {
                        total = Number(total) + 0;
                        //console.log('hi');
                      
                    }else{
                       //if(time.split(":")[2]){
                        var convertion =Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time.split(":")[2]) * 1000;
                      // }else{
                     //   var convertion = Number(time.split(".")[0]) * 60000 ;
                      // }
                      

                        var milliseconds = Number(convertion);
                        //console.log(milliseconds);
                        total = total + milliseconds;
                       // console.log(total);
                    }

                });
                if (isNaN(total)) {
                    totalRow += '<td></td>';
                } else {
                    totalRow += '<td>' + msToTime(Number(total/rowNo)) + '</td>';
                }
            }

            $('#' + id).append('<tr>' + totalRow + '</tr>');
        }

        
        function sum_data(id) {

            var totalRow = '',
                columnNo = $('#' + id + ' th').length;
            for (var index = 0; index < columnNo; index++) {
                var total = 0;

                $('#' + id + ' tr').each(function() {
                    total += +$('td', this).eq(index).text(); //+ will convert string to number

                });
                if (isNaN(total)) {
                    totalRow += '<td></td>';
                } else {
                    totalRow += '<td>' + total.toFixed(0) + '</td>';
                }
            }
            $('#' + id).append('<tr>' + totalRow + '</tr>');
        }

           function msToTime(s) {

            // Pad to 2 or 3 digits, default is 2
            function pad(n, z) {
                z = z || 2;
                return ('00' + n).slice(-z);
            }

            var ms = s % 1000;
            s = (s - ms) / 1000;
            var secs = s % 60;
            s = (s - secs) / 60;
            var mins = s % 60;
            var hrs = (s - mins) / 60;

            return pad(hrs) + ':' + pad(mins) + ':' + pad(secs);
        }
    </script>
</body>

</html>