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


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


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

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


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


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


    /*fixed column datatable css*/

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

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

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

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

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

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

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

        }
    }



    /*excel export*/



    div.dt-buttons {

        float: right;
        top: -60px;
    }

    .dataTables_wrapper .dataTables_filter {

        margin-right: -45px;
    }

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

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

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

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

    }

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

    button:hover {
        background-color: white;
    }

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

    .filter {
        width: 165px;
    }

    .ui-datepicker {
        width: 300px;
        height: 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;
    }
</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 Summery Report</h5>
                <button id="export" class="export" onclick="ExportToExcel('xlsx')" type="button"><i
                        class="fas fa-file-excel" title="Download Excel"></i></button>

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


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

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


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


                                                </select>
                                                <label for="floatingName">Select Sub Brand</span></label>
                                                </div>
                                            </div>-->
                                        <!-- <div class="col-md-3"></div> -->

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

                                            </div>
                                        </div> --}}




                                    </div>

                                    <div class="row">

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


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


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

                </div>

            </div>
        </div>


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

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

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

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


                        </table>


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

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

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


                        </table>


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

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

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


                        </table>


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

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

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


                        </table>


                    </div>
                </div>

                <div class="card">

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

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


                        </table>


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

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

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


                        </table>


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

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

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


                        </table>


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

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

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


                        </table>


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

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

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


                        </table>


                    </div>
                </div> --}}
            </div>

        </div>

    </main>

    @include('layouts.footer');

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

        // $(function() {

        //     var start = moment().startOf('month');
        //     var end = moment();

        //     function cb(start, end) {
        //         $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
        //         change_input(start.format('Y-M-D'), end.format('Y-M-D'));
        //     }

        //     $('#reportrange').daterangepicker({
        //         startDate: start,
        //         endDate: end,
        //         minDate: '01/01/2022',
        //         maxDate: moment(),
        //         ranges: {
        //             'Today': [moment(), moment()],
        //             'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
        //             'Last 7 Days': [moment().subtract(6, 'days'), moment()],
        //             'Last 30 Days': [moment().subtract(29, 'days'), moment()],
        //             'This Month': [moment().startOf('month'), moment().endOf('month')],
        //             'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
        //                 'month').endOf('month')]
        //         }
        //     }, cb);

        //     cb(start, end);

        // });

        $(document).ready(function() {
            $("#rhi_report_all tr").remove();
            $("#rhi_report_zomato tr").remove();
            $("#rhi_report_swiggy tr").remove();
            $("#rhi_report_take_away tr").remove();
            $("#rhi_report_dot_pe tr").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));
                    }



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

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

                // });


            });

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

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

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

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

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

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


            setInterval(function() {

                $('#rhi_report_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_revenue_growth').children('thead:not(:last)').remove();
                // $('#rhi_report_order_growth').children('thead:not(:last)').remove();
                // $('#rhi_report_discount').children('thead:not(:last)').remove();
                // $('#rhi_report_discount_percent').children('thead:not(:last)').remove();
                // $('#rhi_report_kpt').children('thead:not(:last)').remove();
            }, 100);



        });

        function ExportToExcel(type, fn, dl) {

            var elt = [];
            elt.push('rhi_report_all');
            elt.push('rhi_report_zomato');
            elt.push('rhi_report_swiggy');
            elt.push('rhi_report_take_away');
            elt.push('rhi_report_dot_pe');
            // elt.push('rhi_report_order_growth');
            // elt.push('rhi_report_discount');
            // elt.push('rhi_report_discount_percent');
            // elt.push('rhi_report_kpt');
            var htmltable = '';
            elt.forEach(myFunction);

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

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

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

                    htmltable = htmltable + tableHTML;

                }

                if (item == 'rhi_report_zomato') {

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

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_swiggy') {

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

                    htmltable = htmltable + tableHTML;

                }
                if (item == 'rhi_report_take_away') {

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

                    htmltable = htmltable + tableHTML;

                }

                if (item == 'rhi_report_dot_pe') {

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

                    htmltable = htmltable + tableHTML;

                }


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



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

                htmltable = htmltable + tableHTML;

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

            // console.log(htmltable);return false;


            var a = document.createElement('a');

            let currentDate = new Date().toJSON().slice(0, 10);
            var fileName = 'HOB_' + currentDate + '.xls';

            a.href = 'data:application/vnd.ms-excel,' + htmltable;
            a.setAttribute('download', fileName);
            document.body.appendChild(a);
            a.click();
            document.body.removeChild(a);
            //location.reload();


        }


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

                $("#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")
                    },
                    error: function() {}

                });

                $.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")
                    },
                    error: function() {}

                });

                $.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);



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

                });

                $.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);


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

                });


                $.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);


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

                });


            }

        }

        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>' + value1.avg + '</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>' + value2.avg + '</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);
            $("#rhi_report_all").append('<tr> <td colspan="' + cols + '"></td></tr>');
            $("#rhi_report_all").append('<tr> <td colspan="' + cols + '"></td></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_zomato").append('<thead><tr>' + t_row + '</tr></thead>');




            //***************************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>' + value1.avg + '</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>' + value2.avg + '</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_zomato').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + orders + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + aov + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + discount + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_zomato').append('<tr>' + kpt + '</tr>');

            //***************************zomato table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            $("#rhi_report_zomato").append('<tr> <td colspan="' + cols + '"></td></tr>');
            $("#rhi_report_zomato").append('<tr> <td colspan="' + cols + '"></td></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_swiggy").append('<thead><tr>' + t_row + '</tr></thead>');




            //***************************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>' + value1.avg + '</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>' + value2.avg + '</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_swiggy').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + orders + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + aov + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + discount + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_swiggy').append('<tr>' + kpt + '</tr>');


            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            $("#rhi_report_swiggy").append('<tr> <td colspan="' + cols + '"></td></tr>');
            $("#rhi_report_swiggy").append('<tr> <td colspan="' + cols + '"></td></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_take_away").append('<thead><tr>' + t_row + '</tr></thead>');




            //***************************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>' + value1.avg + '</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>' + value2.avg + '</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_take_away').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + orders + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + aov + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + discount + '</tr>');
            $('#rhi_report_take_away').append('<tr>' + discount_percent + '</tr>');
           // $('#rhi_report_take_away').append('<tr>' + kpt + '</tr>');

            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            $("#rhi_report_take_away").append('<tr> <td colspan="' + cols + '"></td></tr>');
            $("#rhi_report_take_away").append('<tr> <td colspan="' + cols + '"></td></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_dot_pe").append('<thead><tr>' + t_row + '</tr></thead>');




            //***************************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>' + value1.avg + '</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>' + value2.avg + '</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_dot_pe').append('<tr>' + revenue + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + orders + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + aov + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + order_growth + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + revenue_growth + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + discount + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + discount_percent + '</tr>');
            $('#rhi_report_dot_pe').append('<tr>' + kpt + '</tr>');

            //***************************swiggy table footer*********************//
            var cols = dates.length + 2;
            //console.log(cols);
            $("#rhi_report_dot_pe").append('<tr> <td colspan="' + cols + '"></td></tr>');
            $("#rhi_report_dot_pe").append('<tr> <td colspan="' + cols + '"></td></tr>');


        }


        function msToTime(s) {

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

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

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

</html>