@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'>
<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/excel_datatable/buttons.dataTables.min.css" />
<script src="assets/vendor/excel_datatable/jszip.min.js"></script>
<script src="assets/vendor/excel_datatable/buttons.html5.min.js"></script>
<script src="assets/vendor/excel_datatable/dataTables.buttons.min.js"></script> --}}

<script type="text/javascript" src="https://cdn.datatables.net/1.10.23/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.23/css/jquery.dataTables.min.css" />



<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.5/css/buttons.dataTables.min.css" />
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.6.5/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/1.6.5/js/buttons.html5.min.js"></script>

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


<style>
    /*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: 0px;
        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%;
    }

    .ui-datepicker-calendar {
        display: none !important;
    }




    .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;
    }

    /* table,
    th,
    td {
        border: 1px solid black;
    } */


    .table_head {
        font-weight: bold;
    }

    .dt-buttons {
        display: none !important;
    }
</style>

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

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


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

        <div class="card">
            <div class="card-body">
                <h5 class="card-title">HOB Summary Report</h5>
                <button id="export" class="export" onclick="ExportToExcel()" 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">

                                <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>
                                        <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">Select Month</span></label>
                                                <p id="projectIDSelectError1" style="color:red"></p>
                                            </div>
                                        </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="card" id="refresh">
            <div class="card-body">


                <!-- Bordered Tabs -->
                <ul class="nav nav-tabs nav-tabs-bordered" id="borderedTab" role="tablist">

                    <li class="nav-item" role="presentation">
                        <button class="nav-link active" id="summery-tab" data-bs-toggle="tab"
                            data-bs-target="#summery-justified" type="button" role="tab"
                            aria-controls="summery" aria-selected="true">Summary</button>
                    </li>
                    <li class="nav-item" role="presentation">
                        <button class="nav-link" id="overall-tab" data-bs-toggle="tab"
                            data-bs-target="#overall-justified" type="button" role="tab"
                            aria-controls="overall" aria-selected="false">Over All</button>
                    </li>
                    <li class="nav-item" role="presentation">
                        <button class="nav-link" id="zomato-tab" data-bs-toggle="tab"
                            data-bs-target="#zomato-justified" type="button" role="tab" aria-controls="zomato"
                            aria-selected="false">Zomato</button>
                    </li>
                    <li class="nav-item" role="presentation">
                        <button class="nav-link" id="swiggy-tab" data-bs-toggle="tab"
                            data-bs-target="#swiggy-justified" type="button" role="tab" aria-controls="swiggy"
                            aria-selected="false">Swiggy</button>
                    </li>
                    <li class="nav-item" role="presentation">
                        <button class="nav-link" id="takeaway-tab" data-bs-toggle="tab"
                            data-bs-target="#takeaway-justified" type="button" role="tab"
                            aria-controls="takeaway" aria-selected="false">Take Away</button>
                    </li>
                    <li class="nav-item flex-fill" role="presentation">
                        <button class="nav-link" id="dotpe-tab" data-bs-toggle="tab"
                            data-bs-target="#dotpe-justified" type="button" role="tab" aria-controls="dotpe"
                            aria-selected="false">Dot Pe</button>
                    </li>
                </ul>
              
                <div class="tab-content pt-1" id="myTabjustifiedContent">
                    <div class="tab-pane fade show active" id="summery-justified" role="tabpanel"
                        aria-labelledby="summery-tab">
                        <div class="col-lg-12" id="reset_tables">
                            <div class="card">


                                <div class="card">

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


                                        <table id="rhi_report_all" class='display dataTable nowrap'
                                            data-rowonetitle="Summery" data-sheetname="Summery">


                                        </table>


                                    </div>
                                </div>


                            </div>

                        </div>
                    </div>

                    <div class="tab-pane fade " id="overall-justified" role="tabpanel"
                        aria-labelledby="overall-tab">
                        <div class="col-lg-12" id="reset_tables1">
                            <div class="card">


                                <div class="card-body" id="tcp_table2" style="overflow-x:auto;">


                                    <table id="rhi_report_overall" class='display dataTable  nowrap'
                                        data-rowonetitle="Overall" data-sheetname="Overall">


                                    </table>


                                </div>

                            </div>

                        </div>
                    </div>

                    <div class="tab-pane fade " id="zomato-justified" role="tabpanel" aria-labelledby="zomato-tab">
                        <div class="col-lg-12" id="reset_tables1">
                            <div class="card">


                                <div class="card-body" id="tcp_table3" style="overflow-x:auto;">


                                    <table id="rhi_report_zomato" class='display dataTable  nowrap'
                                        data-rowonetitle="Zomato" data-sheetname="Zomato">


                                    </table>


                                </div>

                            </div>

                        </div>
                    </div>

                    <div class="tab-pane fade " id="swiggy-justified" role="tabpanel" aria-labelledby="swiggy-tab">
                        <div class="col-lg-12" id="reset_tables1">



                            <div class="card">

                                <div class="card-body" id="tcp_table4" style="overflow-x:auto;">


                                    <table id="rhi_report_swiggy" class='display dataTable  nowrap'
                                        data-rowonetitle="Swiggy" data-sheetname="Swiggy">


                                    </table>




                                </div>
                            </div>

                        </div>
                    </div>

                    <div class="tab-pane fade " id="takeaway-justified" role="tabpanel"
                        aria-labelledby="takeaway-tab">
                        <div class="col-lg-12" id="reset_tables1">
                            <div class="card">


                                <div class="card-body" id="tcp_table5" style="overflow-x:auto;">


                                    <table id="rhi_report_takeaway" class='display dataTable  nowrap'
                                        data-rowonetitle="Take Away" data-sheetname="Take Away">


                                    </table>


                                </div>

                            </div>

                        </div>
                    </div>

                    <div class="tab-pane fade " id="dotpe-justified" role="tabpanel" aria-labelledby="dotpe-tab">
                        <div class="col-lg-12" id="reset_tables1">
                            <div class="card">

                                <div class="card-body" id="tcp_table6" style="overflow-x:auto;">

                                    <table id="rhi_report_dotpe" class='display dataTable  nowrap'
                                        data-rowonetitle="DotPe" data-sheetname="DotPe">


                                    </table>


                                </div>
                            </div>

                        </div>
                    </div>

                </div>
            </div>

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

    </main>

    @include('layouts.footer');

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


        $(document).ready(function() {

            // $('#rhi_report_all').DataTable().destroy();
            // $('#rhi_report_overall').DataTable().destroy();
            // $('#rhi_report_zomato').DataTable().destroy();
            // $('#rhi_report_swiggy').DataTable().destroy();
            // $('#rhi_report_takeaway').DataTable().destroy();
            // $('#rhi_report_dotpe').DataTable().destroy();


            $("#rhi_report_all").find("tr").remove();
            $("#rhi_report_overall").find("tr").remove();
            $("#rhi_report_zomato").find("tr").remove();
            $("#rhi_report_swiggy").find("tr").remove();
            $("#rhi_report_takeaway").find("tr").remove();
            $("#rhi_report_dotpe").find("tr").remove();
            $("#rhi_report_all").find("tbody").remove();
            $("#rhi_report_overall").find("tbody").remove();
            $("#rhi_report_zomato").find("tbody").remove();
            $("#rhi_report_swiggy").find("tbody").remove();
            $("#rhi_report_takeaway").find("tbody").remove();
            $("#rhi_report_dotpe").find("tbody").remove();
            $("#rhi_report_all").find("thead").remove();
            $("#rhi_report_overall").find("thead").remove();
            $("#rhi_report_zomato").find("thead").remove();
            $("#rhi_report_swiggy").find("thead").remove();
            $("#rhi_report_takeaway").find("thead").remove();
            $("#rhi_report_dotpe").find("thead").remove();

            $(function() {
                var dateObj = new Date();
                var month = dateObj.getUTCMonth() + 1; //months from 1-12
                var day = dateObj.getUTCDate();
                var year = dateObj.getUTCFullYear();
                if (month < 10) {
                    month = '0' + month;
                }
                newdate = year + "-" + month;
                $('#from_date').val(newdate)
                $("#from_date").datepicker({
                    changeMonth: true,
                    changeYear: true,
                    showButtonPanel: true,
                    dateFormat: 'yy-mm',
                    onClose: function(dateText, inst) {
                        var month = $("#ui-datepicker-div .ui-datepicker-month :selected")
                            .val();
                        var year = $("#ui-datepicker-div .ui-datepicker-year :selected").val();
                        $(this).datepicker('setDate', new Date(year, month, 1));
                    }



                });



            });

            $('#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_all').children('thead:not(:last)').remove();
                $('#rhi_report_zomato').children('thead:not(:last)').remove();
                $('#rhi_report_swiggy').children('thead:not(:last)').remove();
                $('#rhi_report_take_away').children('thead:not(:last)').remove();
                $('#rhi_report_dot_pe').children('thead:not(:last)').remove();
                $('#rhi_report_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_orders_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_aov_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_order_growth_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_revenue_growth_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_discount_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_discount_percent_overall').children('thead:not(:last)').remove();
                // $('#rhi_report_kpt_overall').children('thead:not(:last)').remove();

            }, 100);




        });


        function ExportToExcel() {
            $(".buttons-html5").click();
           setTimeout(()=> {
                       location.reload();
            }
           ,2000);
        }

        function getHeaderNames(table) {
            // Gets header names.
            //params:
            //  table: table ID.
            //Returns:
            //  Array of column header names.

            var header = $(table).DataTable().columns().header().toArray();

            var names = [];
            header.forEach(function(th) {
                names.push($(th).html());
            });

            return names;
        }

        function buildCols(data) {
            // Builds cols XML.
            //To do: define widths for each column.
            //Params:
            //  data: row data.
            //Returns:
            //  String of XML formatted column widths.

            var cols = '<cols>';

            for (i = 0; i < data.length; i++) {
                colNum = i + 1;
                cols += '<col min="' + colNum + '" max="' + colNum + '" width="20" customWidth="1"/>';
            }

            cols += '</cols>';

            return cols;
        }

        function buildRow(data, rowNum, styleNum) {
            // Builds row XML.
            //Params:
            //  data: Row data.
            //  rowNum: Excel row number.
            //  styleNum: style number or empty string for no style.
            //Returns:
            //  String of XML formatted row.

            var style = styleNum ? ' s="' + styleNum + '"' : '';

            var row = '<row r="' + rowNum + '">';

            for (i = 0; i < data.length; i++) {
                colNum = (i + 10).toString(36).toUpperCase(); // Convert to alpha

                var cr = colNum + rowNum;

                row += '<c t="inlineStr" r="' + cr + '"' + style + '>' +
                    '<is>' +
                    '<t>' + data[i] + '</t>' +
                    '</is>' +
                    '</c>';
            }

            row += '</row>';

            return row;
        }

        function getTableData(table, title) {
// console.log(title);
            if(title==null){
                title='Summery';
            }
            //console.log(title);
            // Processes Datatable row data to build sheet.
            //Params:
            //  table: table ID.
            //  title: Title displayed at top of SS or empty str for no title.
            //Returns:
            //  String of XML formatted worksheet.

            var header = getHeaderNames(table);
            var table = $(table).DataTable();
            var rowNum = 1;
            var mergeCells = '';
            var ws = '';

            ws += buildCols(header);
            ws += '<sheetData>';

            if (title.length > 0) {
                ws += buildRow([title], rowNum, 51);
                rowNum++;

                mergeCol = ((header.length - 1) + 10).toString(36).toUpperCase();

                mergeCells = '<mergeCells count="1">' +
                    '<mergeCell ref="A1:' + mergeCol + '1"/>' +
                    '</mergeCells>';
            }

            ws += buildRow(header, rowNum, 2);
            rowNum++;

            // Loop through each row to append to sheet.    
            table.rows().every(function(rowIdx, tableLoop, rowLoop) {
                var data = this.data();

                // If data is object based, then it needs to be converted 
                // to an array before sending to buildRow()
                ws += buildRow(data, rowNum, '');

                rowNum++;
            });

            ws += '</sheetData>' + mergeCells;

            return ws;

        }

        function setSheetName(xlsx, name) {
            // Changes tab title for sheet.
            //Params:
            //  xlsx: xlxs worksheet object.
            //  name: name for sheet.

            if (name.length > 0) {
                var source = xlsx.xl['workbook.xml'].getElementsByTagName('sheet')[0];
                source.setAttribute('name', name);
            }
        }

        function addSheet(xlsx, table, title, name, sheetId) {
            //Clones sheet from Sheet1 to build new sheet.
            //Params:
            //  xlsx: xlsx object.
            //  table: table ID.
            //  title: Title for top row or blank if no title.
            //  name: Name of new sheet.
            //  sheetId: string containing sheetId for new sheet.
            //Returns:
            //  Updated sheet object.

            //Add sheet2 to [Content_Types].xml => <Types>
            //============================================
            var source = xlsx['[Content_Types].xml'].getElementsByTagName('Override')[1];
            var clone = source.cloneNode(true);
            clone.setAttribute('PartName', '/xl/worksheets/sheet' + sheetId + '.xml');
            xlsx['[Content_Types].xml'].getElementsByTagName('Types')[0].appendChild(clone);

            //Add sheet relationship to xl/_rels/workbook.xml.rels => Relationships
            //=====================================================================
            var source = xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationship')[0];
            var clone = source.cloneNode(true);
            clone.setAttribute('Id', 'rId' + sheetId + 1);
            clone.setAttribute('Target', 'worksheets/sheet' + sheetId + '.xml');
            xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationships')[0].appendChild(clone);

            //Add second sheet to xl/workbook.xml => <workbook><sheets>
            //=========================================================
            var source = xlsx.xl['workbook.xml'].getElementsByTagName('sheet')[0];
            var clone = source.cloneNode(true);
            clone.setAttribute('name', name);
            clone.setAttribute('sheetId', sheetId);
            clone.setAttribute('r:id', 'rId' + sheetId + 1);
            xlsx.xl['workbook.xml'].getElementsByTagName('sheets')[0].appendChild(clone);

            //Add sheet2.xml to xl/worksheets
            //===============================
            var newSheet = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' +
                '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">' +
                getTableData(table, title) +

                '</worksheet>';

            xlsx.xl.worksheets['sheet' + sheetId + '.xml'] = $.parseXML(newSheet);

        }

        // $('#rhi_report_all').DataTable().destroy();




        function exportData(xlsx) {


            var table = $('#rhi_report_all').DataTable({
                "destroy": true,
                dom: 'Bftrip',
                buttons: [

                    {
                        extend: 'excelHtml5',
                        text: 'Excel',
                        customize: function(xlsx) {
                            setSheetName(xlsx, 'Summery');

                            // process additional DataTables in the web page:
                            $('table').each(function(index) {
                                if (index > 0) {
                                    var tableID = '#' + $(this).attr('id');
                                    var rowOneTitle = $(this).attr('data-rowonetitle');
                                    var sheetName = $(this).attr('data-sheetname');
                                    var sheetID = index + 1;
                                    // console.log(xlsx);
                                    // console.log(tableID);
                                    // console.log(rowOneTitle);
                                    // console.log(sheetName);
                                    // console.log(sheetID);
                                    addSheet(xlsx, tableID, rowOneTitle, sheetName,sheetID);
                                }
                            });

                        }
                    },

                ],
                "searching": false,
                "paging": false,
                "order": []



            });

            //$('#rhi_report_all').DataTable();
            $('#rhi_report_overall').DataTable({
                "destroy": true,
                "searching": false,
                "paging": false,
                "order": []
            });

            $('#rhi_report_zomato').DataTable({
                "destroy": true,
                "searching": false,
                "paging": false,
                "order": []
            });

            $('#rhi_report_swiggy').DataTable({
                "destroy": true,
                "searching": false,
                "paging": false,
                "order": []
            });

            $('#rhi_report_takeaway').DataTable({
                "destroy": true,
                "searching": false,
                "paging": false,
                "order": []
            });

            $('#rhi_report_dotpe').DataTable({
                "destroy": true,
                "searching": false,
                "paging": false,
                "order": []
            });

			//var zm = $('#rhi_report_zomato').DataTable();
			//hide the second and third columns
			//zm.columns(1).visible(false);
            
          //  var sw = $('#rhi_report_swiggy').DataTable();
			//hide the second and third columns
			//sw.columns(1).visible(false);

        }



        function get_rhi() {
           // $("#tcp_table1").load(location.href + " #tcp_table1");
            // $("#tcp_table2").load(location.href + " #tcp_table2");
            // $("#tcp_table3").load(location.href + " #tcp_table3");
            // $("#tcp_table4").load(location.href + " #tcp_table4");
            // $("#tcp_table5").load(location.href + " #tcp_table5");
            // $("#tcp_table6").load(location.href + " #tcp_table6");

            if ($("#cancel_report").valid()) {
            
             
                data['from_date'] = $("#from_date").val();

                data['_token'] = "{{ csrf_token() }}";
                var i = 0;
                $("#pageloader").fadeIn();
                $.ajax({
                    url: "{{ url('get_hob_summery_over_all') }}",
                    type: "POST",
                    data: data,

                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data1 = '';
                        var dates = '';
                        var kitchens = '';
                        data1 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        //kitchens = obj['kitchens'];
                        load_table_over_all(data1, dates, total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")
                        // $('#rhi_report_all').DataTable().destroy();
                       // i++;
                       //call_export(i);


                    },
                    complete: function (data1) {
                                 swiggy_summery(data); 
                    },
                    error: function() {}

                });

    
            }

        }

        function zomato_summery(data){
            $.ajax({
                    url: "{{ url('get_hob_summery_zomato') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data1 = '';
                        var dates = '';
                        var kitchens = '';
                        data1 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        //kitchens = obj['kitchens'];
                        load_table_zomato(data1, dates, total);



                        // $(".export").css("display", "block")
                       // i++;
                       // call_export(i);

                    },
                    complete: function (data1) {
                                 takeaway_summery(data); 
                    },
                    error: function() {}

                });
        }


        function swiggy_summery(data){
            $.ajax({
                    url: "{{ url('get_hob_summery_swiggy') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data2 = '';
                        var dates = '';
                        var kitchens = '';
                        data2 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        //kitchens = obj['kitchens'];
                        load_table_swiggy(data2, dates, total);



                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")
                      //  i++;
                      //  call_export(i);
                    },
                    complete: function (data1) {
                                 zomato_summery(data); 
                    },
                    error: function() {}

                });
        }

        function takeaway_summery(data){
            $.ajax({
                    url: "{{ url('get_hob_summery_take_away') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data3 = '';
                        var dates = '';
                        var kitchens = '';
                        data3 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        //kitchens = obj['kitchens'];
                        load_table_take_away(data3, dates, total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")
                       // i++;
                       // call_export(i);
                    },
                    complete: function (data1) {
                                 dotpe_summery(data); 
                    },
                    error: function() {}

                });

        }

        function dotpe_summery(data){

            $.ajax({
                    url: "{{ url('get_hob_summery_dot_pe') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data3 = '';
                        var dates = '';
                        var kitchens = '';
                        data3 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        //kitchens = obj['kitchens'];
                        load_table_dot_pe(data3, dates, total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")
                        //i++;
                        //call_export(i);
                    },
                    complete: function (data1) {
                                 overall_report(data); 
                    },
                    error: function() {}

                });

        }

        function overall_report(data){
            $.ajax({
                    url: "{{ url('get_hob_report_overall') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data4 = '';
                        var dates = '';
                        var kitchens = '';
                        data4 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        kitchens = obj['kitchens'];
                        day_total = obj['day_wise_total'];
                        day_all_total = obj['month_Total'];
                        // load_table_dot_pe(data4, dates, total);
                        var table_id = 'rhi_report_overall';
                        load_table(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        orders_data(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        aov(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        order_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        revenue_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount_percentage(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        kpt(table_id, data4, dates, total, kitchens, day_total, day_all_total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")
                        // $('#rhi_report_overall').DataTable().destroy();
                       // i++;
                       // call_export(i);
                    },
                    complete: function (data1) {
                                 zomato_report(data); 
                    },
                    error: function() {}

                });
        }

        function zomato_report(data){
            $.ajax({
                    url: "{{ url('get_hob_report_zomato') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data4 = '';
                        var dates = '';
                        var kitchens = '';
                        data4 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        kitchens = obj['kitchens'];
                        day_total = obj['day_wise_total'];
                        day_all_total = obj['month_Total'];
                        // load_table_dot_pe(data4, dates, total);
                        var table_id = 'rhi_report_zomato';
                        load_table(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        orders_data(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        aov(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        order_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        revenue_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount_percentage(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        kpt(table_id, data4, dates, total, kitchens, day_total, day_all_total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")

                        // $('#rhi_report_zomato').DataTable().destroy();
                       // i++;
                       // call_export(i);
                    },
                    complete: function (data1) {
                                 swiggy_report(data); 
                    },
                    error: function() {}

                });
        }

        function swiggy_report(data){
            $.ajax({
                    url: "{{ url('get_hob_report_swiggy') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data4 = '';
                        var dates = '';
                        var kitchens = '';
                        data4 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        kitchens = obj['kitchens'];
                        day_total = obj['day_wise_total'];
                        day_all_total = obj['month_Total'];
                        // load_table_dot_pe(data4, dates, total);
                        var table_id = 'rhi_report_swiggy';
                        load_table(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        orders_data(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        aov(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        order_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        revenue_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount_percentage(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        kpt(table_id, data4, dates, total, kitchens, day_total, day_all_total);



                        //i++;
                       // call_export(i);
                    },
                    complete: function (data1) {
                                 takeaway_report(data); 
                    },
                    error: function() {}

                });
        }

        function takeaway_report(data){
            $.ajax({
                    url: "{{ url('get_hob_report_takeaway') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data4 = '';
                        var dates = '';
                        var kitchens = '';
                        data4 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        kitchens = obj['kitchens'];
                        day_total = obj['day_wise_total'];
                        day_all_total = obj['month_Total'];
                        // load_table_dot_pe(data4, dates, total);
                        var table_id = 'rhi_report_takeaway';
                        load_table(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        orders_data(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        aov(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        order_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        revenue_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount_percentage(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        //kpt(table_id, data4, dates, total, kitchens, day_total, day_all_total);



                       // i++;
                       // call_export(i);
                    },
                    complete: function (data1) {
                                 dotpe_report(data); 
                    },
                    error: function() {}

                });
        }

        function dotpe_report(data){
            $.ajax({
                    url: "{{ url('get_hob_report_dotpe') }}",
                    type: "POST",
                    data: data,
                    success: function(data) {
                        var obj = '';
                        obj = jQuery.parseJSON(data);
                        var data4 = '';
                        var dates = '';
                        var kitchens = '';
                        data4 = obj['data'];
                        dates = obj['dates'];
                        total = obj['total'];
                        kitchens = obj['kitchens'];
                        day_total = obj['day_wise_total'];
                        day_all_total = obj['month_Total'];
                        // load_table_dot_pe(data4, dates, total);
                        var table_id = 'rhi_report_dotpe';
                        load_table(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        orders_data(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        aov(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        order_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        revenue_growth(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        discount_percentage(table_id, data4, dates, total, kitchens, day_total, day_all_total);
                        kpt(table_id, data4, dates, total, kitchens, day_total, day_all_total);


                        // $("#pageloader").fadeOut();
                        // $(".export").css("display", "block")

                        // $('#rhi_report_dotpe').DataTable().destroy();
                       
                        call_export();
                    },
                    error: function() {}

                });
        }

        function call_export() {
            
            // if (id == 10) {
                exportData();
                $("#pageloader").hide();
                $(".export").css("display", "block")
            //}
        }

        function load_table_over_all(arr, dates, total) {


            $('#rhi_report_all').find("tr").remove();
            $('#rhi_report_all').find("thead").remove();
            $('#rhi_report_all').find("tbody").remove();

            //***************************zomato table header*********************//
            var t_row = '<th>Over All</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_all").append('<thead><tr>' + t_row + '</tr></thead>');




            //***************************zomato table body*********************//
            $("#rhi_report_all").append('<tbody >');
            var revenue = '<td>Revenue</td>';
            var orders = '<td>Orders</td>';
            var aov = '<td>AOV</td>';
            var order_growth = '<td>WOW order Growth %</td>';
            var revenue_growth = '<td>WOW Revenue Growth %</td>';
            var discount = '<td>Discount(Z+S+T+D)</td>';
            var discount_percent = '<td>Discount % (Z+S)</td>';
            var kpt = '<td>KPT (Z+S)</td>';
            var total_revenue = 0;
            var total_orders = 0;
            var total_aov = 0;
            var total_order_growth = 0;
            var total_revenue_growth = 0;
            var total_discount = 0;
            var total_discount_percent = 0;
            var total_kpt = 0;

            $.each(arr, function(key, value1) {

                revenue += '<td>' + parseFloat(value1.revenue).toFixed(2) + '</td>';
                total_revenue += parseFloat(value1.revenue);

                orders += '<td>' + value1.order_count + '</td>';
                total_orders += parseInt(value1.order_count);

                aov += '<td>' + parseFloat(value1.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value1.order_growth).toFixed(2) + '</td>';
                total_order_growth += parseFloat(value1.order_growth);

                revenue_growth += '<td>' + parseFloat(value1.revenue_growth).toFixed(2) + '</td>';
                total_revenue_growth += parseFloat(value1.revenue_growth);

                discount += '<td>' + parseFloat(value1.discount).toFixed(2) + '</td>';
                total_discount += parseFloat(value1.discount);

                discount_percent += '<td>' + parseFloat(value1.discount_percentage).toFixed(2) + '</td>';
                total_discount_percent += parseFloat(value1.discount_percentage);

                kpt += '<td>' + value1.kpt + '</td>';
                var time = String(value1.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;



            });
            $.each(total, function(key, value2) {
                revenue += '<td>' + parseFloat(value2.revenue).toFixed(2) + '</td>';


                orders += '<td>' + value2.order_count + '</td>';


                aov += '<td>' + parseFloat(value2.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value2.order_growth).toFixed(2) + '</td>';


                revenue_growth += '<td>' + parseFloat(value2.revenue_growth).toFixed(2) + '</td>';


                discount += '<td>' + parseFloat(value2.discount).toFixed(2) + '</td>';


                discount_percent += '<td>' + parseFloat(value2.discount_percentage).toFixed(2) + '</td>';


                kpt += '<td>' + value2.kpt + '</td>';
                var time = String(value2.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;

            });




            $('#rhi_report_all').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_all').append('<tr>' + orders + '</tr>');
            $('#rhi_report_all').append('<tr>' + aov + '</tr>');
            $('#rhi_report_all').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_all').append('<tr>' + kpt + '</tr>');

            //***************************zomato table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#rhi_report_all").append('<tr>' + tfoot + '</tr>');



        }

        function load_table_zomato(arr, dates, total) {
            // $('#rhi_report_zomato').find("tr").remove();

            // $('#rhi_report_zomato').find("thead").remove();
            // $('#rhi_report_zomato').find("tbody").remove();
            //***************************zomato table header*********************//
            var t_row = '<th>Zomato</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_all").append('<tr>' + t_row + '</tr>');




            //***************************zomato table body*********************//
            //$("#rhi_report_zomato").append('<tbody>');
            var revenue = '<td>Revenue</td>';
            var orders = '<td>Orders</td>';
            var aov = '<td>AOV</td>';
            var order_growth = '<td>WOW order Growth %</td>';
            var revenue_growth = '<td>WOW Revenue Growth %</td>';
            var discount = '<td>Discount</td>';
            var discount_percent = '<td>Discount %</td>';
            var kpt = '<td>KPT</td>';
            var total_revenue = 0;
            var total_orders = 0;
            var total_aov = 0;
            var total_order_growth = 0;
            var total_revenue_growth = 0;
            var total_discount = 0;
            var total_discount_percent = 0;
            var total_kpt = 0;

            $.each(arr, function(key, value1) {

                revenue += '<td>' + parseFloat(value1.revenue).toFixed(2) + '</td>';
                total_revenue += parseFloat(value1.revenue);

                orders += '<td>' + value1.order_count + '</td>';
                total_orders += parseInt(value1.order_count);

                aov += '<td>' + parseFloat(value1.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value1.order_growth).toFixed(2) + '</td>';
                total_order_growth += parseFloat(value1.order_growth);

                revenue_growth += '<td>' + parseFloat(value1.revenue_growth).toFixed(2) + '</td>';
                total_revenue_growth += parseFloat(value1.revenue_growth);

                discount += '<td>' + parseFloat(value1.discount).toFixed(2) + '</td>';
                total_discount += parseFloat(value1.discount);

                discount_percent += '<td>' + parseFloat(value1.discount_percentage).toFixed(2) + '</td>';
                total_discount_percent += parseFloat(value1.discount_percentage);

                kpt += '<td>' + value1.kpt + '</td>';
                var time = String(value1.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;



            });

            $.each(total, function(key, value2) {
                revenue += '<td>' + parseFloat(value2.revenue).toFixed(2) + '</td>';


                orders += '<td>' + value2.order_count + '</td>';


                aov += '<td>' + parseFloat(value2.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value2.order_growth).toFixed(2) + '</td>';


                revenue_growth += '<td>' + parseFloat(value2.revenue_growth).toFixed(2) + '</td>';


                discount += '<td>' + parseFloat(value2.discount).toFixed(2) + '</td>';


                discount_percent += '<td>' + parseFloat(value2.discount_percentage).toFixed(2) + '</td>';


                kpt += '<td>' + value2.kpt + '</td>';
                var time = String(value2.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;

            });



            $('#rhi_report_all').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_all').append('<tr>' + orders + '</tr>');
            $('#rhi_report_all').append('<tr>' + aov + '</tr>');
            $('#rhi_report_all').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_all').append('<tr>' + kpt + '</tr>');

            //***************************zomato table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#rhi_report_all").append('<tr>' + tfoot + '</tr>');


        }

        function load_table_swiggy(arr, dates, total) {

            // $('#rhi_report_swiggy').find("tr").remove();
            // $('#rhi_report_swiggy').find("thead").remove();
            // $('#rhi_report_swiggy').find("tbody").remove();
            //***************************zomato table header*********************//
            var t_row = '<th>Swiggy</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_all").append('<tr>' + t_row + '</tr>');




            //***************************zomato table body*********************//
            //$("#rhi_report_swiggy").append('<tbody>');
            var revenue = '<td>Revenue</td>';
            var orders = '<td>Orders</td>';
            var aov = '<td>AOV</td>';
            var order_growth = '<td>WOW order Growth %</td>';
            var revenue_growth = '<td>WOW Revenue Growth %</td>';
            var discount = '<td>Discount</td>';
            var discount_percent = '<td>Discount %</td>';
            var kpt = '<td>KPT</td>';
            var total_revenue = 0;
            var total_orders = 0;
            var total_aov = 0;
            var total_order_growth = 0;
            var total_revenue_growth = 0;
            var total_discount = 0;
            var total_discount_percent = 0;
            var total_kpt = 0;

            $.each(arr, function(key, value1, total) {

                revenue += '<td>' + parseFloat(value1.revenue).toFixed(2) + '</td>';
                total_revenue += parseFloat(value1.revenue);

                orders += '<td>' + value1.order_count + '</td>';
                total_orders += parseInt(value1.order_count);

                aov += '<td>' + parseFloat(value1.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value1.order_growth).toFixed(2) + '</td>';
                total_order_growth += parseFloat(value1.order_growth);

                revenue_growth += '<td>' + parseFloat(value1.revenue_growth).toFixed(2) + '</td>';
                total_revenue_growth += parseFloat(value1.revenue_growth);

                discount += '<td>' + parseFloat(value1.discount).toFixed(2) + '</td>';
                total_discount += parseFloat(value1.discount);

                discount_percent += '<td>' + parseFloat(value1.discount_percentage).toFixed(2) + '</td>';
                total_discount_percent += parseFloat(value1.discount_percentage);

                kpt += '<td>' + value1.kpt + '</td>';
                var time = String(value1.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;



            });

            $.each(total, function(key, value2) {
                revenue += '<td>' + parseFloat(value2.revenue).toFixed(2) + '</td>';


                orders += '<td>' + value2.order_count + '</td>';


                aov += '<td>' + parseFloat(value2.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value2.order_growth).toFixed(2) + '</td>';


                revenue_growth += '<td>' + parseFloat(value2.revenue_growth).toFixed(2) + '</td>';


                discount += '<td>' + parseFloat(value2.discount).toFixed(2) + '</td>';


                discount_percent += '<td>' + parseFloat(value2.discount_percentage).toFixed(2) + '</td>';


                kpt += '<td>' + value2.kpt + '</td>';
                var time = String(value2.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;

            });


            $('#rhi_report_all').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_all').append('<tr>' + orders + '</tr>');
            $('#rhi_report_all').append('<tr>' + aov + '</tr>');
            $('#rhi_report_all').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_all').append('<tr>' + kpt + '</tr>');


            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#rhi_report_all").append('<tr>' + tfoot + '</tr>');


        }

        function load_table_take_away(arr, dates, total) {

            // $('#rhi_report_take_away').find("tr").remove();
            // $('#rhi_report_take_away').find("thead").remove();
            // $('#rhi_report_take_away').find("tbody").remove();
            //***************************Take away  table header*********************//
            var t_row = '<th>Take away</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_all").append('<tr>' + t_row + '</tr>');




            //***************************Take away table body*********************//
            // $("#rhi_report_take_away").append('<tbody>');
            var revenue = '<td>Revenue</td>';
            var orders = '<td>Orders</td>';
            var aov = '<td>AOV</td>';
            var order_growth = '<td>WOW order Growth %</td>';
            var revenue_growth = '<td>WOW Revenue Growth %</td>';
            var discount = '<td>Discount</td>';
            var discount_percent = '<td>Discount %</td>';
            var kpt = '<td>KPT</td>';
            var total_revenue = 0;
            var total_orders = 0;
            var total_aov = 0;
            var total_order_growth = 0;
            var total_revenue_growth = 0;
            var total_discount = 0;
            var total_discount_percent = 0;
            var total_kpt = 0;

            $.each(arr, function(key, value1) {

                revenue += '<td>' + parseFloat(value1.revenue).toFixed(2) + '</td>';
                total_revenue += parseFloat(value1.revenue);

                orders += '<td>' + value1.order_count + '</td>';
                total_orders += parseInt(value1.order_count);

                aov += '<td>' + parseFloat(value1.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value1.order_growth).toFixed(2) + '</td>';
                total_order_growth += parseFloat(value1.order_growth);

                revenue_growth += '<td>' + parseFloat(value1.revenue_growth).toFixed(2) + '</td>';
                total_revenue_growth += parseFloat(value1.revenue_growth);

                discount += '<td>' + parseFloat(value1.discount).toFixed(2) + '</td>';
                total_discount += parseFloat(value1.discount);

                discount_percent += '<td>' + parseFloat(value1.discount_percentage).toFixed(2) + '</td>';
                total_discount_percent += parseFloat(value1.discount_percentage);

                kpt += '<td>' + value1.kpt + '</td>';
                var time = String(value1.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;



            });

            $.each(total, function(key, value2) {
                revenue += '<td>' + parseFloat(value2.revenue).toFixed(2) + '</td>';


                orders += '<td>' + value2.order_count + '</td>';


                aov += '<td>' + parseFloat(value2.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value2.order_growth).toFixed(2) + '</td>';


                revenue_growth += '<td>' + parseFloat(value2.revenue_growth).toFixed(2) + '</td>';


                discount += '<td>' + parseFloat(value2.discount).toFixed(2) + '</td>';


                discount_percent += '<td>' + parseFloat(value2.discount_percentage).toFixed(2) + '</td>';


                kpt += '<td>' + value2.kpt + '</td>';
                var time = String(value2.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;

            });


            $('#rhi_report_all').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_all').append('<tr>' + orders + '</tr>');
            $('#rhi_report_all').append('<tr>' + aov + '</tr>');
            $('#rhi_report_all').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_all').append('<tr>' + kpt + '</tr>');

            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#rhi_report_all").append('<tr>' + tfoot + '</tr>');



        }


        function load_table_dot_pe(arr, dates, total) {

            // $('#rhi_report_dot_pe').find("tr").remove();
            // $('#rhi_report_dot_pe').find("thead").remove();
            // $('#rhi_report_dot_pe').find("tbody").remove();
            //***************************Take away  table header*********************//
            var t_row = '<th>Dot Pe</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_all").append('<tr>' + t_row + '</tr>');




            //***************************Take away table body*********************//
            //   $("#rhi_report_dot_pe").append('<tbody>');
            var revenue = '<td>Revenue</td>';
            var orders = '<td>Orders</td>';
            var aov = '<td>AOV</td>';
            var order_growth = '<td>WOW order Growth %</td>';
            var revenue_growth = '<td>WOW Revenue Growth %</td>';
            var discount = '<td>Discount</td>';
            var discount_percent = '<td>Discount %</td>';
            var kpt = '<td>KPT</td>';
            var total_revenue = 0;
            var total_orders = 0;
            var total_aov = 0;
            var total_order_growth = 0;
            var total_revenue_growth = 0;
            var total_discount = 0;
            var total_discount_percent = 0;
            var total_kpt = 0;

            $.each(arr, function(key, value1) {

                revenue += '<td>' + parseFloat(value1.revenue).toFixed(2) + '</td>';
                total_revenue += parseFloat(value1.revenue);

                orders += '<td>' + value1.order_count + '</td>';
                total_orders += parseInt(value1.order_count);

                aov += '<td>' + parseFloat(value1.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value1.order_growth).toFixed(2) + '</td>';
                total_order_growth += parseFloat(value1.order_growth);

                revenue_growth += '<td>' + parseFloat(value1.revenue_growth).toFixed(2) + '</td>';
                total_revenue_growth += parseFloat(value1.revenue_growth);

                discount += '<td>' + parseFloat(value1.discount).toFixed(2) + '</td>';
                total_discount += parseFloat(value1.discount);

                discount_percent += '<td>' + parseFloat(value1.discount_percentage).toFixed(2) + '</td>';
                total_discount_percent += parseFloat(value1.discount_percentage);

                kpt += '<td>' + value1.kpt + '</td>';
                var time = String(value1.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;



            });

            $.each(total, function(key, value2) {
                revenue += '<td>' + parseFloat(value2.revenue).toFixed(2) + '</td>';


                orders += '<td>' + value2.order_count + '</td>';


                aov += '<td>' + parseFloat(value2.avg).toFixed(2) + '</td>';


                order_growth += '<td>' + parseFloat(value2.order_growth).toFixed(2) + '</td>';


                revenue_growth += '<td>' + parseFloat(value2.revenue_growth).toFixed(2) + '</td>';


                discount += '<td>' + parseFloat(value2.discount).toFixed(2) + '</td>';


                discount_percent += '<td>' + parseFloat(value2.discount_percentage).toFixed(2) + '</td>';


                kpt += '<td>' + value2.kpt + '</td>';
                var time = String(value2.kpt);
                // console.log(time);
                total_kpt += Number(time.split(":")[0]) * 3600000 + Number(time.split(":")[1]) * 60000 + Number(time
                    .split(":")[2]) * 1000;;

            });


            $('#rhi_report_all').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_all').append('<tr>' + orders + '</tr>');
            $('#rhi_report_all').append('<tr>' + aov + '</tr>');
            $('#rhi_report_all').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount + '</tr>');
            $('#rhi_report_all').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_all').append('<tr>' + kpt + '</tr>');

            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#rhi_report_all").append('<tr>' + tfoot + '</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);
        }



        function load_table(table_id, arr, dates, total, kitchens, day_total, day_all_total) {
		
            $("#" + table_id + "").find("tr").remove();
            $("#" + table_id + "").find("thead").remove();
            $("#" + table_id + "").find("tbody").remove();

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Revenue</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<thead><tr class="table_head">' + tfoot + '</tr></thead>');


            //***************************revenue table header*********************//
            $("#" + table_id + "").append('<tbody>');
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//

            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.revenue);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.revenue);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.revenue);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.revenue);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');


            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');

        }



        function orders_data(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Orders</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');

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

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.order_count);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.order_count);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');


            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</th>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.order_count);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.order_count);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');




        }

        function aov(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>AOV</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.avg);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.avg);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.avg);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.avg);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');


            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');


        }


        function order_growth(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Order Growth %</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.order_growth);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.order_growth);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.order_growth);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.order_growth);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');




            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');
        }



        function revenue_growth(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Revenue Growth %</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.revenue_growth);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.revenue_growth);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.revenue_growth);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.revenue_growth);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');



        }



        function discount(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Discount</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.discount);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.discount);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.discount);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.discount);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');


        }


        function discount_percentage(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>Discount Percentage %</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head">' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value1.discount_percentage);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = parseFloat(value2.discount_percentage);
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue.toFixed(2) + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = parseFloat(value1.discount_percentage);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = parseFloat(value2.discount_percentage);
                t_row_foot = t_row_foot + '<td>' + revenue.toFixed(2) + '</td>';
            });


            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');



        }


        function kpt(table_id, arr, dates, total, kitchens, day_total, day_all_total) {

            // $('#rhi_report_overall').find("tr").remove();
            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            tfoot = '<td>KPT</td>'
            for (i = 1; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr class="table_head">' + tfoot + '</tr>');
            //***************************revenue table header*********************//
            var t_row = '<td>Kitchen</td>';
            // console.log(t_row);return false;
            $.each(dates, function(key, value1) {
                t_row = t_row + '<td>' + value1.date + ' ' + value1.day + '</td>';
            });

            t_row = t_row + '<td>MTD Grand Total</td>';
            $("#" + table_id + "").append('<tr class="table_head"> ' + t_row + '</tr>');




            //***************************revenue table body*********************//
            //  $("#rhi_report_overall").append('<tbody>');
            var next_row_kitchen = '';
            $.each(kitchens, function(key, value) {
                next_row_kitchen = '<td>' + value.kitchen_name + '</td>';

                // $("#rhi_report_overall").append('<tbody>');
                $.each(arr, function(key, value1) {
                    if (value.kitchen == value1.kitchen_id) {
                        var revenue = 0;
                        revenue = value1.kpt;
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue + '</td>';
                    }
                });
                $.each(total, function(key, value2) {
                    if (value.kitchen == value2.kitchen_id) {
                        var revenue = 0;
                        revenue = value2.kpt;
                        next_row_kitchen = next_row_kitchen + '<td>' + revenue + '</td>';
                    }
                });

                $("#" + table_id + "").append('<tr>' + next_row_kitchen + '</tr>');

            });

            //***************************revenue table footer*********************//
            // $("#rhi_report_overall").append('<tfoot>');
            var t_row_foot = '<td>--</td>';
            $.each(day_total, function(key, value1) {
                var revenue = 0;
                revenue = value1.kpt;
                t_row_foot = t_row_foot + '<td>' + revenue + '</td>';
            });
            $.each(day_all_total, function(key, value2) {
                var revenue = 0;
                revenue = value2.kpt;
                t_row_foot = t_row_foot + '<td>' + revenue + '</td>';
            });
            $("#" + table_id + "").append('<tr class="table_head">' + t_row_foot + '</tr>');

            var cols = dates.length + 2;
            //console.log(cols);
            var tfoot = '';
            for (i = 0; i < cols; i++) {
                tfoot = tfoot + '<td>-</td>'
            }

            $("#" + table_id + "").append('<tr>' + tfoot + '</tr>');



        }
    </script>
</body>

</html>