@extends('layouts.app')

@section('appjs')
<script type="application/javascript" src="{{ asset('js/app.js') }}"></script>
<script>
    window.placements = @json($placements);
</script>
@endsection
@section('content')
@section('page_title')
Whistle Feed Publisher Report
@endsection
<style>
    .dropdown-item:hover,
    .dropdown-item:focus {
        background-color: #e8ebed;
    }

    .btn-light,
    .btn-light:hover,
    .btn-light:focus,
    .btn-light:not(:disabled):not(.disabled):active,
    .btn-light:not(:disabled):not(.disabled).active,
    .show>.btn-light.dropdown-toggle {
        background-color: #fff;
        border-color: #ced4da;
    }

    .bootstrap-select>.dropdown-toggle.bs-placeholder,
    .bootstrap-select>.dropdown-toggle.bs-placeholder:hover {
        color: #495057 !important;
    }

    .bootstrap-select .dropdown-menu {
        min-width: 100% !important;
    }

    .dataTables_scroll {
        overflow: auto;
    }
    #report-main-table_filter{
        margin-right: 0px;
        margin-top: -25px;
        margin-bottom: 0px !important;
    }
    .small{
        float: left;
        margin-top: -15px;
    }
    .pencil-input{
        width: 100% !important
    }
    .pubSelectedOption{
        margin-top : 15px;
        min-width  : 10px;
    }
    input:read-only{
        cursor      : pointer;
        margin-top  : 13px;
        margin-left : 0px;
    }
    .checkboxLabel{
       font-size : 15px;
       width     : 150px;
       margin-left:10px;
    }
    .col-2{
        max-width: 15% !important;
    }
    .marTop{
        margin-top: 15px;
    }
    .export-feedpublishersourcingurlreport{
        height: 27px;
    }
    .pubFeedReport{
        height       : 27px;
        float        : right;
        margin-left  : -20px;
        margin-right : 10px;
    }
    .hourly_datatable, .dataTables_wrapper, .hourly_based_Publisher_child_table, .bottom {
       margin-top: 0 !important;
       background-color:#fff;
    }
</style>
@php
    $websiteIds = explode(',', env('PUBLISHER_PLACEMENT_WEBSITE_IDS'));
@endphp

<div class="container-fluid">
    <div class="card">
        <div class="row ml-0 mr-0 mt-4 d-flex align-items-start">
            <div class="form-group col-md-3">@include('whistle_feed.menu_dropdown.report')</div>
            <div class="form-group flex m-auto">
            <!-- count section start-->
                <div class="btn-outline-success active count-div" id="countfilter0" data-toggle="tooltip">
                    <label> Total:</label>
                <small id="total_count0"></small>
                </div>
                <div class="count-div" id="countfilter1" data-toggle="tooltip">
                    <label>Active: </label>
                    <small id="active_count1"></small>
                </div>
                <div class="count-div" id="countfilter2" data-toggle="tooltip">
                    <label>In-Active: </label>
                    <small id="inactive_count2"></small>
                </div>
            </div>
            <!-- count section end -->
            @canany(['isSuperAdmin','isAdmin','isFeed','isFeedSupport'])
                @php
                    $hourly_column = 1;
                @endphp
            @endcanany
            @can('hasExcelPermission')
            @php $hourly_download = 1; @endphp
            <div class="col-md-4">
                <div class="pull-right mr-3" id="publisherReportForm">
                    {{-- @csrf --}}
                    <button type="submit" class="export-feedreport btn excel-btn btn-sm border-0 border-radius-0"><i class="fa fa-download"></i> Export</button>
                    {{-- <input type="hidden" name="fromdate" id="from_date_hidden" />
                    <input type="hidden" name="todate" id="to_date_hidden" />
                    <input type="hidden" name="websiteid" id="website_id_hidden" />
                    <input type="hidden" name="revenuetype" id="revenue_type_hidden" />
                    <input type="hidden" name="languageid" id="language_filter_val_hidden" />
                    <input type="hidden" name="clientid" id="client_filter_val_hidden" />
                    <input type="hidden" name="publisher_state" id="publisher_state_val_hidden" />
                    <input type="hidden" name="inventory_filter" id="inventory_filter_hidden"/>
                    <input type="hidden" name="oemId_filter" id="oemId_filter_hidden"/>
                    <input type="hidden" name="channelType_filter" id="channelType_filter_hidden"/>
                    <input type="hidden" name="currency_filter" id="currency_filter_hidden"/>
                    <input type="hidden" name="time_zone_filter" id="time_zone_filter_hidden"/>
                    <input type="hidden" name="optionalFilter" id="optionalFilter_hidden"/>
                    <input type="hidden" name="placementFilter" id="placement_hidden"/>
                    <input type="hidden" name="subPlacementFilter" id="subPlacement_hidden"/> --}}
                </div>
                <form class="pull-right mr-3" id="publisher_sourcing_url_report" action="{{ url('exportPublisherSourcingUrlReport') }}">
                    @csrf
                    <button type="submit" class="export-feedpublishersourcingurlreport btn excel-btn btn-sm border-radius-0"><i class="fa fa-download"></i> Export For Sourcing URL</button>
                    <input type="hidden" name="sourcingfromdate" id="sourcing_from_date_hidden" />
                    <input type="hidden" name="sourcingtodate" id="sourcing_to_date_hidden" />
                    <input type="hidden" name="sourcingwebsiteid" id="sourcing_website_id_hidden" />
                    <input type="hidden" name="clientid" id="sourcing_client_filter_hidden" />
                </form>
                <form class="pull-right mr-3" id="hourly_based_form" action="{{ url('exportPublisherReportHourly') }}">
                    @csrf
                    <input type="hidden" name="from_date_hourly"  id="from_date_hidden_hourly" />
                    <input type="hidden" name="to_date_hourly"    id="to_date_hidden_hourly" />
                    <input type="hidden" name="website_id_hourly" id="website_id_hidden_hourly" />
                    <input type="hidden" name="client_filter_hourly" id="client_filter_hidden_hourly" />
                    <input type="hidden" name="inventory_type_hourly" id="inventory_type_hidden_hourly" />
                    <input type="hidden" name="placement_id_hourly" id="placement_id_hidden_hourly" />
                    <input type="hidden" name="time_zone_hourly" id="time_zone_hidden_hourly" />
                    <input type="submit" value="" class="d-none" id="hitme">
                </form>
            </div>
            @endcan
            <button type="submit" id="runReport" class="pubFeedReport btn btn-sm border-0 excel-btn border-radius-0"> Run Report</button>
        </div>

        <div class="card-body table-responsive">
            <form>
                <div class="d-flex flex-wrap">
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="period_filter">Choose Time Period</label>
                        <select id="period_filter" class="form-control">
                            <option value=''>Select</option>
                            <option value="1" selected>Today</option>
                            <option value="2">Yesterday</option>
                            <option value="3">This Month</option>
                            <option value="4">Last Month</option>
                            <option value="5">Last 6 Months</option>
                            <option value="6">This Year</option>
                            <option value="7">Last Year</option>
                        </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="start_date">From Date</label>
                        <input type="text" class="form-control" id="start_date" name="start_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="end_date">To Date</label>
                        <input type="text" class="form-control" id="end_date" name="end_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label>Website ID</label>
                        <div class="form-group prepend">
                            <span class="prefix">WFP -</span>
                            <input type="text" class="form-control pencil-input" id="website_id" name="website_id" placeholder="Search Website ID" autocomplete="off" onkeypress="return validateInput(event)">
                        </div>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="start_date">Publisher ID</label><br>
                        <select class="form-control" name="client_filter" multiple id="client_filter"></select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="language_filter">Language Filter</label>
                        <select id="language_filter"  name="language_filter[]" class="form-control" data-live-search="true" multiple>
                                                    </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="revenue_filter">Revenue Type</label>
                        <select id="revenue_filter" name="revenue_filter[]" class="form-control" data-live-search="true" multiple>
                            <option value='1'>CPM</option>
                            <option value='0'>CPC</option>
                            <option value='2'>CPI</option>
                            <option value='3'>RTB</option>
                        </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label class="labelText">Publisher Type</label>
                        <select id="channelTypeFilter" class="form-control cform-control divs input-size">
                            <option value="" selected>All</option>
                            <option value="1">OEM</option>
                            <option value="0">Ad Network</option>
                        </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3 oem_div">
                        <label class="labelText">OEM Channel</label>
                            <select id="oemIdFilter" class="form-control cform-control divs input-size" multiple> </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3 inv_div">                        <label for="inventory_filter">Inventory Type</label>
                            <select class="form-control" name="inventory_filter[]" multiple id="inventory_filter"> </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="currency_filter">Currency</label>
                        <select id="currency_filter" class="form-control">
                            <option value='1' selected>INR</option>
                            <option value='2'>USD</option>
                        </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label for="time_zone_filter">Time Zone</label>
                        <select id="time_zone_filter" class="form-control">
                            <option value='1' selected>IST</option>
                            <option value='2'>UTC</option>
                            <option value='3'>CST</option>
                        </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3 placement_div">
                        <label for="">Placement</label><br>
                        <select class="form-control" name="placement_filter[]" id="placement_filter" multiple> </select>
            
                    </div>
                    <div class="form-group col-2 pl-0 mr-3 sub_placement_div">
                        <label>Sub Placement</label><br>
                        <select class="form-control" name="sub_placement_filter[]" id="sub_placement_filter" multiple> </select>
                    </div>
                    <div class="form-group col-2 pl-0 mr-3">
                        <label>Optional Filter</label>
                        <label class="checkboxLabel"><input type="checkbox" class="pubSelectedOption" data-column="11" data-column-name="current_hour"> Hour-Wise</label>
                    </div>
                </div>
            </form>
            <div class="col-2 pl-0 mr-3 custom-z-index">
                @include('whistle_feed.feed_reports.clearFilter')
            </div>
            <table class="table-bordered table-hover text-center" id="report-main-table">
                <thead>
                    <tr>
                        <th rowspan="2">Hourly Based</th>
                        <th rowspan="2">Sl.No</th>
                        <th rowspan="2">Website Category</th>
                        <th rowspan="2">Language</th>
                        <th rowspan="2">Publisher ID</th>
                        <th rowspan="2">Publisher</th>
                        <th rowspan="2">User Name</th>
                        <th rowspan="2">Email</th>
                        <th rowspan="2">Mobile Number</th>
                        <th rowspan="2">On-Boarded Date</th>
                        <th rowspan="2">Impression Date</th>
                        <th rowspan="2">Hour</th>
                        <th rowspan="2">Website ID</th>
                        <th rowspan="2">Placement Name</th>
                        <th rowspan="2">Sub Placement Name</th>
                        <th rowspan="2">Placement ID</th>
                        <th rowspan="2">Inventory Type</th>
                        <th rowspan="2">Platfrom</th>
                        <th rowspan="2">Website/App</th>
                        <th rowspan="2">Ad Request</th>
                        <th rowspan="2">Exceeded QPS</th>
                        <th rowspan="2">Filled Request</th>
                        <th rowspan="2">Fill Rate % <span data-toggle="tooltip" title="(Filled Request / Ad Request) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">Bids Won</th>
                        <th rowspan="2">Bids Won Percentage % <span data-toggle="tooltip" title="(Bids Won / Ads Request) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">Bids Lost</th>
                        <th rowspan="2">Billable Bids</th>
                        <th rowspan="2">Viewable Impressions</th>
                        <th rowspan="2">Paused Impressions</th>
                        <th rowspan="2">View Rate % <span data-toggle="tooltip" title="(Viewable Impressions / Bids Won) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">View Through Request % <span data-toggle="tooltip" title="(Viewable Impressions / Ad Request) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">Clicks</th>
                        <th rowspan="2">Conversions</th>
                        <th rowspan="2" class="video-header">Video Viewability % <span data-toggle="tooltip" title="(First Quartile * 25 + Mid Piont * 50 + Third Quartile * 75 + Complete * 100) / (First Quartile + Mid Piont + Third Quartile + Complete)"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th colspan="9" class="video-header">Video Events</th>
                        <th rowspan="2">Likes</th>
                        <th rowspan="2">Shares</th>
                        <th rowspan="2">Clicks From Shares</th>
                        <th rowspan="2">Conversions From Shares</th>
                        <th rowspan="2">Revenue Type</th>
                        <th rowspan="2">Publisher Revenue</th>
                        <th rowspan="2">Feed Revenue</th>
                        <th rowspan="2">CTR % <span data-toggle="tooltip" title="(Clicks / Impressions) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">CR % <span data-toggle="tooltip" title="(Conversions / Clicks) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">eCpm <span data-toggle="tooltip" title="(Revenue / Impressions) x 1000"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">eCpc <span data-toggle="tooltip" title="Revenue / Clicks"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">CPA <span data-toggle="tooltip" title="Revenue / Conversions"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                        <th rowspan="2">Entry Type</th>
                    </tr>
                    <tr class="video-header-col">
                        <th>Start</th>
                        <th>25 % Viewed</th>
                        <th>50 % Viewed</th>
                        <th>75 % Viewed</th>
                        <th>100 % Viewed</th>
                        <th>Rewind</th>
                        <th>Full Screen</th>
                        <th>Mute</th>
                        <th>Skip</th>
                    </tr>
                </thead>
                <tfoot>
                    <tr>
                        <th>Total</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th class="video-footer">NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                        <th>NA</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    <link rel="stylesheet" href="{{asset('css/jquery-ui.css')}}" />
    <script type="application/javascript" src="{{ asset('js/jquery-ui.js') }}"></script>
    <script type="application/javascript">
        var publisher_state = 0;
        var url_regex = /^(http|https)/;
        const numberFormatter = Intl.NumberFormat('en-IN');
        $(document).ready(function() {
            var web_id = lang_id = client_id = revenue_type = inventory_filter = oemId_filter = channelType_filter = currency_filter = '';
            /* call function while DOM get ready to get all records.*/
            feedReportList();
            getInventories();
            getOEMIds();
            getAllClients();
            getPlacementTypes(1,0);
            $(".oem_div").hide();
            // clear all filter script
            $('.clear_filter').on('click',function(){
                $('#website_id').val('');
                $('#client_filter input[type="checkbox"]').prop('checked', false);
                $('#client_filter option:selected').prop('selected', false);
                $('#client_filter').multiselect('refresh');
                $("#language_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $("#revenue_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $("#inventory_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $("#oemIdFilter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $('#channelTypeFilter   option:eq(1)').prop('selected',true);
                $('#period_filter   option:eq(1)').prop('selected',true);
                $('#placement_filter').val('').prop('selected', true);
                $("#placement_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $('#sub_placement_filter').val('').prop('selected', true);
                $("#sub_placement_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $('.pubSelectedOption').prop('checked', false);
                var start_date = new Date().toJSON().slice(0, 10);
                var end_date = new Date().toJSON().slice(0, 10);
                $('.count-div').removeClass('btn-outline-success active');
                $('#'+$('.count-div').eq(0).prop('id')).addClass('btn-outline-success active');
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                feedReportList();
            });
            get_publisher_count();/*call function to display Total, Active and In-Active Count*/

            //Count Filter
            $('.count-div').click(function (e) {
                e.preventDefault();
                publisher_state = parseInt(this.id.slice(-1));
                web_id = $('#website_id').val()
                client_id = $('#client_filter').val();
                lang_id = $('#language_filter').val()
                revenue_type = $('#revenue_filter').val()
                inventory_filter = $('#inventory_filter').val();
                channelType_filter = $('#channelTypeFilter').val();
                oemId_filter = $('#oemIdFilter').val();
                currency_filter = $('#currency_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name,oemId_filter,channelType_filter);
                $('.count-div').removeClass('btn-outline-success active');
                $(this).addClass('btn-outline-success active');
            });
            /*return start and end date for  excel export*/
            $(document).on('click',".export-feedreport",function(e) {
                e.preventDefault()
                var start_date = $('#start_date').val();
                var end_date = $('#end_date').val();
                web_id = $('#website_id').val();
                client_id = $('#client_filter').val().toString();
                revenue_type = $('#revenue_filter').val()
                lang_id = $('#language_filter').val();
                inventory_filter = $('#inventory_filter').val();
                channelType_filter= $('#channelTypeFilter').val();
                oemId_filter      = $('#oemIdFilter').val();
                currency_filter = $('#currency_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                search            = $('#report-main-table_filter input[type="search"]').val();
                // $('#from_date_hidden').val(start_date);
                // $('#to_date_hidden').val(end_date);
                // $('#website_id_hidden').val(web_id);
                // $('#client_filter_val_hidden').val(client_id);
                // $('#language_filter_val_hidden').val(lang_id);
                // $('#revenue_type_hidden').val(revenue_type);
                // $('#publisher_state_val_hidden').val(publisher_state);
                // $('#inventory_filter_hidden').val(inventory_filter);
                // $('#currency_filter_hidden').val(currency_filter);
                // $('#time_zone_filter_hidden').val(time_zone_filter);
                // $('#optionalFilter_hidden').val(optionalFilter);
                // $('#placement_hidden').val(placement_name);
                // $('#subPlacement_hidden').val(subplacement_name);
                // if date is todays date then normal form will be submitted if its not the we are using the ajax to enter the data in the tbl_export_dat table
                if(false){
                    $('#publisherReportForm').submit();
                }else{
                    let page_name = $("#report_dropdown option:selected").text();
                    $('.export-feedreport').attr('disabled','disabled');
                    $('.export-feedreport').addClass('bg-secondary');
                    $.ajax({
                        "url" : "{{ url('exportpublisherReport') }}",
                        "type": "GET",
                        "data": {
                            fromdate         : start_date,
                            todate           : end_date,
                            websiteid        : web_id,
                            revenuetype      : revenue_type,
                            clientid         : client_id,
                            languageid       : lang_id,
                            publisher_state  : publisher_state,
                            page_name        : page_name,
                            inventory_filter : inventory_filter,
                            currency_filter  : currency_filter,
                            optionalFilter   : optionalFilter,
                            placementFilter   : placement_name,
                            subPlacementFilter: subplacement_name,
                            search            : search,
                            oemId_filter      : oemId_filter,
                            channelType_filter: channelType_filter,
                            time_zone_filter  : time_zone_filter
                            },
                        "dataType": "json",
                        success: function(response) {
                            if(response){
                                toastr.success('File Will Be Sent To Your Registered Email Id');
                            }else{
                                toastr.error('Something Went Wrong or File Is Already Being Created');
                            }
                        }
                    });
                }
            });

            $(".export-feedpublishersourcingurlreport").click(function(e) {
                e.preventDefault();
                var start_date = $('#start_date').val();
                var end_date = $('#end_date').val();
                web_id = $('#website_id').val();
                client_id = $('#client_filter').val();
                $('#sourcing_from_date_hidden').val(start_date);
                $('#sourcing_to_date_hidden').val(end_date);
                $('#sourcing_website_id_hidden').val(web_id);
                let page_name = $("#report_dropdown option:selected").text() == 'Publisher Report' ? 'Publisher Sourcing Url Report' : $("#report_dropdown option:selected").text();
                if(start_date == '2026-02-24'){
                    page_name+='_Today'
                }
                $('.export-feedpublishersourcingurlreport').attr('disabled','disabled');
                $('.export-feedpublishersourcingurlreport').addClass('bg-secondary');
                $.ajax({
                    "url" : "{{ url('exportPublisherSourcingUrlReport') }}",
                    "type": "GET",
                    "data": {
                        sourcingfromdate  : start_date,
                        sourcingtodate    : end_date,
                        sourcingwebsiteid : web_id,
                        page_name         : page_name
                    },
                    "dataType": "json",
                    success: function(response) {
                        if(response){
                            toastr.success('File Will Be Sent To Your Registered Email Id');
                        }else{
                            toastr.error('Something Went Wrong or File Is Already Being Created');
                        }
                    }
                });
            });

            $("body").on("click", "#runReport", function() {
                lang_id = $('#language_filter').val()
                web_id = $('#website_id').val()
                client_id = $('#client_filter').val();
                revenue_type = $('#revenue_filter').val()
                inventory_filter = $('#inventory_filter').val();
                channelType_filter = $('#channelTypeFilter').val();
                oemId_filter = $('#oemIdFilter').val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter, time_zone_filter, optionalFilter,placement_name,subplacement_name,oemId_filter,channelType_filter);
            });

            /*Language filter on change*/
            $("body").on("change", "#language_filter", function() {
                lang_id = $(this).val()
                web_id = $('#website_id').val()
                client_id = $('#client_filter').val();
                revenue_type = $('#revenue_filter').val()
                inventory_filter = $('#inventory_filter').val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter, time_zone_filter, optionalFilter,placement_name,subplacement_name);
            });
             /*Client filter on change*/
             $("body").on("change", "#client_filter", function() {
                client_id = $(this).val();
                web_id = $('#website_id').val();
                lang_id = $('#language_filter').val();
                revenue_type = $('#revenue_filter').val();
                inventory_filter = $('#inventory_filter').val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter, time_zone_filter, optionalFilter,placement_name,subplacement_name);
            });
            /*Revenue filter on change*/
            $("body").on("change", "#revenue_filter", function() {
                revenue_type = $(this).val()
                web_id = $('#website_id').val();
                client_id = $('#client_filter').val();
                lang_id = $('#language_filter').val();
                inventory_filter = $('#inventory_filter').val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter, time_zone_filter, optionalFilter,placement_name,subplacement_name);
            });
            /*Website Id filter*/
            $("#website_id").keyup(function() {
                web_id = $(this).val();
                revenue_type = $('#revenue_filter').val()
                client_id = $('#client_filter').val();
                lang_id = $('#language_filter').val();
                inventory_filter = $('#inventory_filter').val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter, time_zone_filter, optionalFilter,placement_name,subplacement_name);
            });
            /*Inventory Type*/
            $("body").on("change", "#inventory_filter", function(){
                revenue_type = $('#revenue_filter').val()
                client_id = $('#client_filter').val();
                lang_id = $('#language_filter').val();
                web_id = $('#website_id').val();
                inventory_filter = $(this).val();
                currency_filter  = $('#currency_filte').val();
                time_zone_filter = $('#time_zone_filter').val();
                optionalFilter   = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                $('#oemIdFilter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
                $('#placement_filter').val('').prop('selected', true);
                $("#placement_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                $('#sub_placement_filter').val('').prop('selected', true);
                $("#sub_placement_filter").multiselect("clearSelection").multiselect("refresh").multiselect("rebuild");
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
            });
            /*Currency Filter*/
            $("body").on("change", "#currency_filter", function(){
                currency_filter   = $(this).val();
                revenue_type      = $('#revenue_filter').val()
                client_id         = $('#client_filter').val();
                lang_id           = $('#language_filter').val();
                web_id            = $('#website_id').val();
                inventory_filter  = $('#inventory_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                placement_name    = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
            });

            /*Time Zone Filter*/
            $("body").on("change", "#time_zone_filter", function(){
                time_zone_filter   = $(this).val();
                revenue_type      = $('#revenue_filter').val()
                client_id         = $('#client_filter').val();
                lang_id           = $('#language_filter').val();
                web_id            = $('#website_id').val();
                inventory_filter  = $('#inventory_filter').val();
                currency_filter   = $('#currency_filter').val();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                placement_name    = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
            });

            /*Placement filter on change*/
            $("body").on("change", "#placement_filter", function() {
                placement_name    = $(this).val();
                time_zone_filter  = $('#time_zone_filter').val();
                revenue_type      = $('#revenue_filter').val()
                client_id         = $('#client_filter').val();
                lang_id           = $('#language_filter').val();
                web_id            = $('#website_id').val();
                inventory_filter  = $('#inventory_filter').val();
                currency_filter   = $('#currency_filter').val();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                subplacement_name = $('#sub_placement_filter').val();
                placement_name    = placement_name.length ? placement_name : 0;
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
            });
        
            /*Sub Placement filter on change*/
            $("body").on("change", "#sub_placement_filter", function() {
                revenue_type     = $('#revenue_filter').val()
                client_id        = $('#client_filter').val();
                lang_id          = $('#language_filter').val();
                web_id           = $('#website_id').val();
                inventory_filter = $('#inventory_filter').val();
                optionalFilter   = $('.pubSelectedOption:checked').length;
                currency_filter   = $('#currency_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                subplacement_name= $(this).val();
                placement_name   = $('#placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter, currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
            });


            //multi select for users
            $('#client_filter').multiselect({
                enableFiltering: true,
                selectAllJustVisible: false,
                includeSelectAllOption: true,
                allSelectedText: 'All Selected',
                nonSelectedText: 'Select Publisher Id',
                selectAllValue: 'All',
                selectAllText: 'Select All',
                unselectAllText: 'Unselect All',
                buttonWidth: '100%',
                templates: {
                    filterClearBtn: '<span class="input-group-btn"><button class="btn btn-default multiselect-clear-filter border-radius-0" type="button">Clear</button></span>',
                },
                enableCaseInsensitiveFiltering: true
            });

            $('#placement_filter').multiselect({
                nonSelectedText                : 'Select Placement',
                allSelectedText                : 'Selected All',
                unselectAllText                : 'Unselect all',
                selectAllJustVisible           : false,
                enableFiltering                : true,
                includeFilterClearBtn          : true,
                buttonWidth                    : '100%',
                enableHTML                     : true,
                enableCaseInsensitiveFiltering : true,
                selectAllJustVisible           : false,
                includeSelectAllOption         : true,
                templates : {
                    filterClearBtn : '<span class="input-group-btn"><button class="btn btn-default multiselect-clear-filter border-radius-0" type="button"><i class="fa fa-close"></i></button></span>',
                }
            });

            $('#sub_placement_filter').multiselect({
                nonSelectedText                : 'Select Sub Placement',
                allSelectedText                : 'Selected All',
                unselectAllText                : 'Unselect all',
                selectAllJustVisible           : false,
                enableFiltering                : true,
                includeFilterClearBtn          : true,
                buttonWidth                    : '100%',
                enableHTML                     : true,
                enableCaseInsensitiveFiltering : true,
                selectAllJustVisible           : false,
                includeSelectAllOption         : true,
                templates : {
                    filterClearBtn : '<span class="input-group-btn"><button class="btn btn-default multiselect-clear-filter border-radius-0" type="button"><i class="fa fa-close"></i></button></span>',
                }
            });

            $('#inventory_filter').multiselect({
                nonSelectedText        : 'Select Inventory',
                allSelectedText        : 'Selected All',
                selectAllJustVisible   : false,
                includeSelectAllOption : true,
                selectAllValue         : 'all',
                selectAllText          : 'Select all',
                unselectAllText        : 'Unselect all',
            });

            $('#oemIdFilter').multiselect({
                includeSelectAllOption : true,
                allSelectedText        : 'All Selected',
                nonSelectedText        : 'Select OEM',
                selectAllText          : 'Select All',
                unselectAllText        : 'UnSelect All',
                selectAllValue         : 'all',
                selectAllJustVisible   : false,
                numberDisplayed        : 1
            });

            $('#revenue_filter').multiselect({
                nonSelectedText        : 'Select Revenue',
                allSelectedText        : 'Selected All',
                selectAllJustVisible   : false,
                includeSelectAllOption : true,
                selectAllValue         : 'all',
                selectAllText          : 'Select all',
                unselectAllText        : 'Unselect all',
            });

            $('#language_filter').multiselect({
                nonSelectedText        : 'Select Language',
                allSelectedText        : 'Selected All',
                selectAllJustVisible   : false,
                includeSelectAllOption : true,
                selectAllValue         : 'all',
                selectAllText          : 'Select all',
                unselectAllText        : 'Unselect all',
            });

            /**select from date here***/
            $("#start_date").datepicker({
                dateFormat: 'yy-mm-dd',
                maxDate: 0,
                autoclose: true,
                todayHighlight: true,
                endDate: 'today',
                onSelect: function(selectedDate) {
                    web_id = $('#website_id').val();
                    revenue_type = $('#revenue_filter').val()
                    lang_id = $('#language_filter').val();
                    client_id = $('#client_filter').val();
                    var startDate = $('#start_date').datepicker('getDate');
                    var inventory_filter = $('#inventory_filter').val();
                    var currency_filter = $('#currency_filter').val();
                    var time_zone_filter = $('#time_zone_filter').val();
                    var optionalFilter    = $('.pubSelectedOption:checked').length;
                    var placement_name   = $('#placement_filter').val();
                    var subplacement_name = $('#sub_placement_filter').val();
                    var todaysDate = new Date();
                    let year = startDate.getFullYear();
                    let month = startDate.getMonth();
                    let daysInMonth = new Date(year, month + 1, 0).getDate();
                    let currentMonth = new Date().getMonth();
                    let currentDate = new Date();
                    let timeDifference = currentDate-startDate
                    let daysDifferent = Math.floor(timeDifference / (1000 * 60 * 60 * 24));
                     var maxdaycount;
                    if(startDate){
                        maxdaycount = new Date(startDate);
                        maxdaycount.setDate(maxdaycount.getDate() + daysInMonth-1);
                    }
                    if (todaysDate.setHours(0,0,0,0) == startDate.setHours(0,0,0,0)) {
                        $('#end_date').datepicker('option', 'maxDate', startDate);
                    } 
                    else if((month==currentMonth)|| (daysDifferent<=daysInMonth)){
                        let today = new Date()
                        let formattedDate = today.getFullYear() + '-' + String(today.getMonth() + 1).padStart(2, '0') + '-' + String(today.getDate()).padStart(2, '0');
                        $('#end_date').datepicker('option', 'maxDate', formattedDate);
                    }
                    else {
                        $('#end_date').datepicker('option', 'maxDate', maxdaycount);
                    }
                    $('#end_date').datepicker('option', 'minDate', startDate);
                    $('#end_date').datepicker('setDate', startDate);
                    // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    $('#period_filter').val('');
                }
            });
            /**select to date here***/
            $("#end_date").datepicker({
                dateFormat: 'yy-mm-dd',
                // minDate: $("#start_date").datepicker("getDate"),
                maxDate: 0,
                autoclose: true,
                todayHighlight: true,
                onClose: function() {
                    web_id = $('#website_id').val();
                    client_id = $('#client_filter').val();
                    revenue_type = $('#revenue_filter').val()
                    lang_id = $('#language_filter').val();
                    var startDate = $('#start_date').datepicker('getDate');
                    var endDate = $('#end_date').datepicker('getDate');
                    var inventory_filter = $('#inventory_filter').val();
                    var currency_filter = $('#currency_filter').val();
                    var time_zone_filter = $('#time_zone_filter').val();
                    var optionalFilter   = $('.pubSelectedOption:checked').length;
                    var placement_name   = $('#placement_filter').val();
                    var subplacement_name = $('#sub_placement_filter').val();
                    if (startDate == null) {
                        $('#start_date').datepicker('setDate', endDate);
                    }
                    if (endDate < startDate) {
                        var minDate = $('#end_date').datepicker('option', 'minDate', startDate);
                        $('#end_date').datepicker('setDate', minDate);
                    }
                    // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                },
                onSelect: function() {
                    $('#period_filter').val('');
                }
            });

            $("body").on("change", "#period_filter", function() {
                var periodValue = $(this).val();
                inventory_filter = $('#inventory_filter').val();
                web_id = $('#website_id').val();
                revenue_type = $('#revenue_filter').val();
                client_id = $('#client_filter').val();
                lang_id = $('#language_filter').val();
                currency_filter = $('#currency_filter').val();
                time_zone_filter = $('#time_zone_filter').val();
                var optionalFilter   = $('.pubSelectedOption:checked').length;
                var placement_name   = $('#placement_filter').val();
                var subplacement_name = $('#sub_placement_filter').val();
                $("#start_date").val('');
                $("#end_date").val('');
                if (periodValue != '') {
                    //filter by today
                    if (periodValue == '1') {
                        var start_date = new Date().toJSON().slice(0, 10);
                        var end_date = new Date().toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'maxDate', start_date);
                        $('#end_date').datepicker('setDate', end_date);
                        // feedReportList(web_id,client_id,lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }

                    //filter by yesterday
                    else if (periodValue == '2') {
                        var start_date = new Date(Date.now() - 864e5).toJSON().slice(0, 10);
                        var end_date = new Date(Date.now() - 864e5).toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'maxDate', start_date);
                        $('#end_date').datepicker('setDate', end_date);
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }

                    //filter by this month
                    else if (periodValue == '3') {
                        var start_date = new Date();
                        var end_date = new Date();
                        end_date =   end_date.setDate(end_date.getDate());
                        end_date = new Date(end_date).toJSON().slice(0, 10);
                        start_date = new Date(start_date.setMonth(start_date.getMonth()));
                        start_date = new Date(start_date.setDate(1));
                        start_date = start_date.toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'minDate', start_date);
                        $('#end_date').datepicker('option', 'maxDate', end_date); // Set maxDate to today
                        $('#end_date').datepicker('setDate', end_date);
                        $('#end_date').val(end_date); // Ensure end date is set in the input field
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }

                    //filter by last month
                    else if (periodValue == '4') {
                        var start_date = new Date();
                        var end_date = new Date();
                        start_date = new Date(start_date.setDate(1));
                        start_date = new Date(start_date.setMonth(start_date.getMonth() - 1));
                        start_date = start_date.toJSON().slice(0, 10);
                        end_date = new Date(end_date.setDate(1) - 864e5);
                        end_date = end_date.toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'minDate', start_date);
                        $('#end_date').datepicker('setDate', end_date);
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }

                    //filter by last 6 month
                    else if (periodValue == '5') {
                        var start_date = new Date();
                        var end_date = new Date();
                        end_date = new Date(end_date.setDate(1) - 864e5);
                        end_date = end_date.toJSON().slice(0, 10);
                        start_date = new Date(start_date.setDate(1));
                        start_date = new Date(start_date.setMonth(start_date.getMonth() - 6));
                        start_date = start_date.toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'minDate', start_date);
                        $('#end_date').datepicker('setDate', end_date);
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }

                    //filter by this year
                    else if (periodValue == '6') {
                        var end_date = new Date().toJSON().slice(0, 10);
                        var makeDate = new Date(end_date);
                        var start_date = new Date(makeDate.setMonth(0));
                        start_date = new Date(makeDate.setDate(1));
                        start_date = start_date.toJSON().slice(0, 10);
                        end_date = new Date();
                        end_date =   end_date.setDate(end_date.getDate());
                        end_date = new Date(end_date).toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'minDate', start_date);
                        $('#end_date').datepicker('option', 'maxDate', end_date); // Set maxDate to today
                        $('#end_date').datepicker('setDate', end_date);
                        $('#end_date').val(end_date); // Ensure end date is set in the input field
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }
                    //filter by previous year
                    else if (periodValue == '7') {
                        var end_date = new Date();
                        var start_date = new Date();
                        end_date = new Date(end_date.setMonth(0));
                        end_date = new Date(end_date.setDate(1) - 864e5).toJSON().slice(0, 10);
                        start_date = new Date(start_date.setMonth(start_date.getMonth() - 12));
                        start_date = new Date(start_date.setMonth(0));
                        start_date = new Date(start_date.setDate(1)).toJSON().slice(0, 10);
                        $('#start_date').val(start_date);
                        $('#end_date').datepicker('option', 'minDate', start_date);
                        $('#end_date').datepicker('setDate', end_date);
                        // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name);
                    }
                }
            });

            // selecting each optional columns 
            $('.pubSelectedOption').on('click', function (e) {
                revenue_type     = $('#revenue_filter').val()
                client_id        = $('#client_filter').val();
                lang_id          = $('#language_filter').val();
                web_id           = $('#website_id').val();
                inventory_filter = $('#inventory_filter').val();
                channelType_filter= $('#channelTypeFilter').val();
                oemId_filter     = $('#oemIdFilter').val();
                currency_filter  = $('#currency_filter').val();
                time_zone_filter = $('#time_zone_filter').val();
                optionalFilter   = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                // feedReportList(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,currency_filter,time_zone_filter,optionalFilter,placement_name,subplacement_name,oemId_filter,channelType_filter);
                // Get the column API object
                var column =  $("#report-main-table").DataTable().column($(this).attr('data-column'));
                // Toggle the visibility of the column
                column.visible(column.visible());
            });

        });

        // Getting Report Publisher Count
        function get_publisher_count(){
            $.ajax({
                "url": "{{ url('get_publisher_count') }}",
                "type": "POST",
                "data": {
                        _token: "{{csrf_token()}}",
                        "flag":2
                    },
                    "dataType": "json",
                success: function(response) {
                    $("#total_count0").html(response[0].total);
                    $("#active_count1").html(response[0].active);
                    $("#inactive_count2").html(response[0].inactive);
                }
            });
        }
        //all records displaying here
        function feedReportList(website_id = null,client_id =null, language_id = null, revenue_type = null,publisher_state=null,inventory_filter=null,currency_filter = null,time_zone_filter = null, optionalFilter = null,placement_name=null,subplacement_name=null,oemId_filter=null,channelType_filter=null) {
            // enabling the publisher report export button here
            $('.export-feedreport').removeAttr('disabled');
            $('.export-feedreport').removeClass('bg-secondary');
            // enabling the sourcing url report export button here
            $('.export-feedpublishersourcingurlreport').removeAttr('disabled');
            $('.export-feedpublishersourcingurlreport').removeClass('bg-secondary');
            var start_date = $('#start_date').val();
            var end_date = $('#end_date').val();
            currency_filter = $('#currency_filter').val();
            var hourly_column = {{isset($hourly_column) ? $hourly_column : 0}}
            var hasExcel      = {{isset($hourly_download) && $hourly_download ==1 ? 1 : 0}}
            var websiteIds = {!! json_encode($websiteIds) !!};
            $("#report-main-table").DataTable().clear().destroy();
            $('#report-main-table').DataTable({
                "processing": true,
                "serverSide": true,
                "paging": true,
                "searching": true,
                "pageLength": 50,
                "scrollX": true,
                "ordering": true,
                "lengthChange": false,
                "scrollY":  400,
                "scrollCollapse": true,
                "fixedHeader":{ header: true},
                language: {
                    search: '',
                    searchPlaceholder: "Search..."
                },
                "order": [
                    [19, "desc"]
                ],
                "ajax": {
                    "url": "{{ url('getPublisherReport') }}",
                    "type": "POST",
                    "data": {
                        _token: "{{csrf_token()}}",
                        "start_date": start_date,
                        "end_date": end_date,
                        "website_id": website_id,
                        "client_id" :client_id,
                        "language_id": language_id,
                        "revenue_type": revenue_type,
                        "publisher_state":publisher_state,
                        "inventory_filter" : inventory_filter,
                        "oemId_filter"     : oemId_filter,
                        "channelType_filter": channelType_filter,
                        "currency_filter"  : currency_filter,
                        "time_zone_filter" : time_zone_filter,
                        "optionalFilter"   : optionalFilter,
                        "placement_name"    : placement_name,
                        "subplacement_name" : subplacement_name
                    },
                    "dataType": "json",
                },
                "columnDefs": [{
                    orderable: false,
                    targets  : [0,1],
                    visible:hourly_column
                }],
                "columns": [
                    {
                        "defaultContent": '<a href="#!"> <i class="fa fa-plus-circle greenIcon" aria-hidden="true"> </i> </a> <a href"#!> Download hour</a>',
                        render: function(data, type, row, meta) {
                            var website_id = row.Website_Id;
                            var entry_type= (row.Entry_Type);
                                var inventory_type = row.Inventory_Type == 'Text' ? '1' : (row.Inventory_Type == 'Tile' ? '2' : (row.Inventory_Type == 'Tile Ads' ? '3' : (row.Inventory_Type == 'OEM-Text' ? '4' : (row.Inventory_Type == 'Video Ads' ? '5' : (row.Inventory_Type == 'Banner Ads' ? '6' : '7')))));
                            if(hasExcel){
                                return '<span class="dt-hourly-based m-2"> <a href="#!"> <i class="fa fa-plus-circle greenIcon"   data-date="'+row.Impression_Date+'" data-website-id="'+website_id+'" data-entry-type="'+entry_type+'" data-placement-id="'+row.Placement_Id+'" data-inventory_type="'+inventory_type+'" data-time_zone_filter="'+time_zone_filter+'" data-id="'+meta.row +'" aria-hidden="true"> </i> </a> </span> <span class="m-2"> <a  href="#!" title="Download Hourly Based Report" class="export_hourly_publisher_report" data-date="'+row.Impression_Date+'" data-website-id="'+website_id+'" data-placement-id="'+row.Placement_Id+'" data-inventory_type="'+inventory_type+'" data-time_zone_filter="'+time_zone_filter+'" data-id="'+meta.row +'"> <i class="fa fa-cloud-download text-primary" aria-hidden="true"> </i> </a> </span>';
                            }else{
                                return '<span class="dt-hourly-based m-2"> <a href="#!"> <i class="fa fa-plus-circle greenIcon"   data-date="'+row.Impression_Date+'" data-website-id="'+website_id+'" data-placement-id="'+row.Placement_Id+'" data-inventory_type="'+inventory_type+'" data-time_zone_filter="'+time_zone_filter+'" data-id="'+meta.row +'" aria-hidden="true"> </i> </a> </span>';

                            }
                        }
                    },
                    {
                        data: "Account_Id",
                        render: function(data, type, row, meta) {
                            return meta.row + meta.settings._iDisplayStart + 1;
                        }
                    },
                    {
                        data: "Website_Category",
                        render: function(data, type, row, meta) {
                            return ((row.Website_Category) ? row.Website_Category : "NA")
                        }
                    },
                    {
                        data: "Language",
                        render: function(data, type, row, meta) {
                            return ((row.Language) ? row.Language : "NA")
                        }
                    },
                    {
                        data: "Publisher_ID",
                        render: function(data, type, row, meta) {
                            return ((row.Publisher_ID) ? row.Publisher_ID : "NA")
                        }
                    },
                    {
                        data: "Publisher",
                        render: function(data, type, row, meta) {
                            return ((row.Publisher) ? row.Publisher : "NA")
                        }
                    },
                    {
                        data: "Username",
                        render: function(data, type, row, meta) {
                            return ((row.Username) ? row.Username : "NA")
                        }
                    },
                    {
                        data: "Email",
                        render: function(data, type, row, meta) {
                            return ((row.Email) ? row.Email : "NA")
                        }
                    },
                    {
                        data: "Mobile_Number",
                        render: function(data, type, row, meta) {
                            return ((row.Mobile_Number) ? row.Mobile_Number : "NA")
                        }
                    },
                    {
                        data: "On_Boarded_Date",
                        render: function(data, type, row, meta) {
                            return ((row.On_Boarded_Date) ? row.On_Boarded_Date : "NA");
                        }
                    },
                    {
                        data: "Impression_Date",
                        render: function(data, type, row, meta) {
                            return ((row.Impression_Date) ? row.Impression_Date : "NA");
                        }
                    },
                    { 
                        data: "Current_Hour",
                        render: function(data, type, row, meta){
                         return ((row.Current_Hour)  ? row.Current_Hour :  "0")
                        }
                    },
                    {
                        data: "Website_Id",
                        render: function(data, type, row, meta) {
                            var website_id = row.Website_Id;
                            url  = "getSourcingUrlHourly/" + website_id + '/' + start_date + '/' + end_date;
                            return data = '<a href = "'+url+'" target="_blank"> WFP' + website_id + ' </a>';
                        }
                    },
                    {   
                        data: "Placement_Name",
                        render: function(data, type, row, meta){
                            return (row.Placement_Name ? row.Placement_Name : '')
                        }
                    },
                    {
                        data: "Sub_Placement_Name",
                        render: function(data, type, row, meta){
                            return (row.Sub_Placement_Name ? row.Sub_Placement_Name : '')
                        }
                    },
                    {
                        data: "Placement_Id",
                        render: function(data, type, row, meta) {
                            if (row.Inventory_Type != 1 || row.Inventory_Type != 2) {
                                return row.Placement_Id ? row.Placement_Id : "";
                            } else {
                                return "";
                            }
                        }
                    },
                    {
                        data: "Inventory_Type",
                        render:function(data, type, row, meta){
                            return ((row.Inventory_Type) ? row.Inventory_Type : "NA");
                        // data = row.inventory_type == 1 ? 'Text' : (row.inventory_type == 2 ? 'Tile' : (row.inventory_type == 3 ? 'OEM' : (row.inventory_type == 4 ? "OEM-Text" : (row.inventory_type == 5 ? "Text-Expanded" : (row.inventory_type == 6 ? "Banner Ads" : "Interstitial")))));
                        // return data;
                        }
                    },
                    {
                        data: "Platform",
                        render: function(data, type, row, meta) {
                            if (row.Platform == 'Website') {
                                data = `<span style="font-size:13px;font-weight:600;">Website</span>`
                            } else {
                                data = `<span style="font-size:13px;font-weight:600;">Mobile App</span>`
                            }
                            return data;
                        }
                    },
                    {
                        data: "Domain",
                        render: function(data, type, row, meta) {
                            if (row.Platform == 'Website') {
                                let url = url_regex.test(String(row.Domain).toLowerCase()) == true ? row.Domain : 'https://'+row.Domain;
                                data = '<a href = ' + url + ' target="_blank"> ' + row.Domain + ' </a>';
                            } else {
                                data = '<a href = https://play.google.com/store/apps/details?id=' + row.Domain + ' target="_blank">' + row.Domain + ' </a>';
                            }
                            return data;
                        }
                    },
                    {
                        data: "Ad_Request",
                        render: function(data, type, row, meta) {
                            var adRequest = row.Ad_Request ? row.Ad_Request : "0";
                            var color = row.is_oem === 1 ? 'red' : 'black';
                            return '<span style="color: ' + color + ';">' + numberFormatter.format(adRequest) + '</span>';
                        }
                    },
                    {
                        data: "Otr_Request",
                        render: function(data, type, row, meta) {
                            return ((row.Otr_Request) ? numberFormatter.format(row.Otr_Request) : "0")
                        }
                    },
                    {
                        data: "Filled_Request",
                        render: function(data, type, row, meta) {
                            return ((row.Filled_Request) ? numberFormatter.format(row.Filled_Request) : "0")
                        }
                    },
                    {
                        data: "Fill_Rate",
                        render: function(data, type, row, meta) {
                            return ((row.Fill_Rate) ? numberFormatter.format(row.Fill_Rate) + ' %' : "0.00 %")
                        }
                    },
                    {
                        data: "Bids_Won",
                        render: function(data, type, row, meta) {
                            return ((row.Bids_Won) ? numberFormatter.format(row.Bids_Won) : "0")
                        }
                    },
                    {
                        data: "Win_Rate",
                        render: function(data, type, row, meta) {
                            return ((row.Win_Rate) ? row.Win_Rate + '%' : "0.00%")
                        }
                    },
                    {
                        data: "Bids_Lost",
                        render: function(data, type, row, meta) {
                            return ((row.Bids_Lost) ? numberFormatter.format(row.Bids_Lost) : "0")
                        }
                    },
                    {
                        data: "Billable_Bids",
                        render: function(data, type, row, meta) {
                            return ((row.Billable_Bids) ? numberFormatter.format(row.Billable_Bids) : "0")
                        }
                    },
                    {
                        data: "Viewable_Impressions",
                        render: function(data, type, row, meta) {
                            return ((row.Viewable_Impressions) ? numberFormatter.format(row.Viewable_Impressions) : "0")
                        }
                    },
                    {
                        data: "Paused_Impressions",
                        render: function(data, type, row, meta) {
                            return ((row.Paused_Impressions) ? numberFormatter.format(row.Paused_Impressions) : "0")
                        }
                    },
                    {
                        data: "View_Rate",
                        render: function(data, type, row, meta) {
                            return ((row.View_Rate) ? row.View_Rate+ '%' : "0.00%")
                        }
                    },
                    {
                        data: "Vtr",
                        render: function(data, type, row, meta) {
                            return ((row.Vtr) ? row.Vtr + '%' : "0.00%")
                        }
                    },
                    {
                        data: "Clicks",
                        render: function(data, type, row, meta) {
                            return ((row.Clicks) ? numberFormatter.format(row.Clicks) : "0")
                        }
                    },
                    {
                        data: "Conversions",
                        render: function(data, type, row, meta) {
                            return ((row.Conversions) ? numberFormatter.format(row.Conversions) : "0")
                        }
                    },
                    {
                        data: "Video_Viewability",
                        render: function(data, type, row, meta) {
                            return ((row.Video_Viewability) ? row.Video_Viewability + ' %' : "0.00 %")
                        }
                    },
                    { 
                        data: "Video_Start",
                        render: function(data, type, row, meta){
                            return ((row.Video_Start) ? row.Video_Start :"0")
                        }
                    },
                    { 
                        data: "25_Viewed",
                        render: function(data, type, row, meta){
                            return ((row['25_Viewed']) ? row['25_Viewed'] :"0")
                        }
                    },
                    { 
                        data: "50_Viewed",
                        render: function(data, type, row, meta){
                            return ((row['50_Viewed']) ? row['50_Viewed'] :"0")
                        }
                    },
                    { 
                        data: "75_Viewed",
                        render: function(data, type, row, meta){
                            return ((row['75_Viewed']) ? row['75_Viewed'] :"0")
                        }
                    },
                    { 
                        data: "100_Viewed",
                        render: function(data, type, row, meta){
                            return ((row['100_Viewed']) ? row['100_Viewed'] :"0")
                        }
                    },
                    { 
                        data: "Video_Rewind",
                        render: function(data, type, row, meta){
                            return ((row.Video_Rewind) ? row.Video_Rewind :"0")
                        }
                    },
                    { 
                        data: "Video_Full_Screen",
                        render: function(data, type, row, meta){
                            return ((row.Video_Full_Screen) ? row.Video_Full_Screen :"0")
                        }
                    },
                    { 
                        data: "Video_Mute",
                        render: function(data, type, row, meta){
                            return ((row.Video_Mute) ? row.Video_Mute :"0")
                        }
                    },
                    { 
                        data: "Video_Skip",
                        render: function(data, type, row, meta){
                            return ((row.Video_Skip) ? row.Video_Skip :"0")
                        }
                    },
                    {
                        data: "Likes",
                        render: function(data, type, row, meta) {
                            return ((row.Likes) ? numberFormatter.format(row.Likes) : "0")
                        }
                    },
                    {
                        data: "Shares",
                        render: function(data, type, row, meta) {
                            return ((row.Shares) ? numberFormatter.format(row.Shares) : "0")
                        }
                    },
                    {
                        data: "Clicks_From_Shares",
                        render: function(data, type, row, meta) {
                            return numberFormatter.format(row.Clicks_From_Shares)
                        }
                    },
                    {
                        data: "Conversions_From_Shares",
                        render: function(data, type, row, meta) {
                            return numberFormatter.format(row.Conversions_From_Shares)
                        }
                    },
                    {
                        data: "Revenue_Type",
                        render: function(data, type, row, meta) {
                            return ((row.Revenue_Type) ? row.Revenue_Type : "NA");
                            // return ((row.revenue_type == 1 && row.variable_floor_price == 1) ? 'VCPM' : (row.revenue_type == 1 ? 'CPM' : (row.revenue_type == 0 ? 'CPC' : (row.revenue_type == 2 ? 'CPI' : 'RTB'))));
                        }
                    },
                    {
                        data: "Publisher_Revenue",
                        render: function(data, type, row, meta) {
                            return ((row.Publisher_Revenue) ? numberFormatter.format(row.Publisher_Revenue) : "0")
                        }
                    },
                    {
                        data: "Feed_Revenue",
                        render: function(data, type, row, meta) {
                            return ((row.Feed_Revenue) ? numberFormatter.format(row.Feed_Revenue) : "0")
                        }
                    },
                    {
                        data: "CTR",
                        render: function(data, type, row, meta) {
                            return ((row.CTR) ? row.CTR + '%' : "0.00%")
                        }
                    },
                    {
                        data: "CR",
                        render: function(data, type, row, meta) {
                            return ((row.CR) ? row.CR + '%' : "0.00%")
                        }
                    },
                    {
                        data: "CPM",
                        render: function(data, type, row, meta) {
                            return (row.CPM ? row.CPM : "0.00")
                        }
                    },
                    {
                        data: "CPC",
                        render: function(data, type, row, meta) {
                            return ((row.CPC) ? row.CPC : "0.00")
                        }
                    },
                    {
                        data: "CPA",
                        render: function(data, type, row, meta) {
                            return ((row.CPA) ? row.CPA : "0.00")
                        }
                    },
                    {
                        data: "Entry_Type",
                        render: function(data, type, row, meta) {
                            return ((row.Entry_Type) ? row.Entry_Type : "NA")
                        }
                    }
                ],
                fnRowCallback: function(nRow, aData) {
                    return nRow;
                },
                fnDrawCallback: function( settings ) {
                    $('.paginate_button').click(function(){
                    $('.dataTables_scrollBody').scrollTop(0);
                    })
                },
                footerCallback: function(row, start, end, display) {
                    var row = this.api();
                    var api = this.api().ajax.json().footer_total[0];
                if (api && typeof api === 'object') {
                $( row.column(19).footer() ).html(api['ad_request'] ? numberFormatter.format(api['ad_request']) : 0);
                $( row.column(20).footer() ).html(api['otr_request'] ? numberFormatter.format(api['otr_request']) : 0);
                $( row.column(21).footer() ).html(api['non_viewable_impressions'] ? numberFormatter.format(api['non_viewable_impressions']) : 0);
                $( row.column(22).footer() ).html(api['non_viewable_impressions']*100/api['ad_request']    ? (api['non_viewable_impressions']*100/api['ad_request']).toFixed(2)   : 0);
                $( row.column(23).footer() ).html(api['bidsWonTotal'] ? numberFormatter.format(api['bidsWonTotal']) : 0);
                $( row.column(24).footer() ).html(api['bidsWonTotal'] > 0  && api['ad_request'] > 0 ? (100*api['bidsWonTotal']/api['ad_request']).toFixed(2) : 0);
                $( row.column(25).footer() ).html(api['bidsLostTotal'] ? numberFormatter.format(api['bidsLostTotal']) : 0);
                $( row.column(26).footer() ).html(api['billableBidsTotal'] ? numberFormatter.format(api['billableBidsTotal']) : 0);
                $( row.column(27).footer() ).html(api['impressionsTotal'] ? numberFormatter.format(api['impressionsTotal']) : 0);
                $( row.column(28).footer() ).html(api['pausedImpressionsTotal'] ? numberFormatter.format(api['pausedImpressionsTotal']) : 0);
                $( row.column(29).footer() ).html(api['impressionsTotal'] > 0 && api['bidsWonTotal'] > 0 ? (100*api['impressionsTotal']/api['bidsWonTotal']).toFixed(2) : 0);
                $( row.column(30).footer() ).html(api['impressionsTotal'] > 0 && api['ad_request'] > 0  ? (100*api['impressionsTotal']/api['ad_request']).toFixed(2) : 0);
                $( row.column(31).footer() ).html(api['clicksTotal']      ? numberFormatter.format(api['clicksTotal'])      : 0);
                $( row.column(32).footer() ).html(api['conversionsTotal'] ? numberFormatter.format(api['conversionsTotal']) : 0);
                $( row.column(34).footer() ).html(api['video_start_total'] ? api['video_start_total'] : 0);
                $( row.column(35).footer() ).html(api['video_first_quartile_total'] ? api['video_first_quartile_total'] : 0);
                $( row.column(36).footer() ).html(api['video_midpoint_total'] ? api['video_midpoint_total'] : 0);
                $( row.column(37).footer() ).html(api['video_third_quartile_total'] ? api['video_third_quartile_total'] : 0);
                $( row.column(38).footer() ).html(api['video_complete_total'] ? api['video_complete_total'] : 0);
                $( row.column(39).footer() ).html(api['video_rewind_total'] ? api['video_rewind_total'] : 0);
                $( row.column(40).footer() ).html(api['video_full_screen_total'] ? api['video_full_screen_total'] : 0);
                $( row.column(41).footer() ).html(api['video_mute_total'] ? api['video_mute_total'] : 0);
                $( row.column(42).footer() ).html(api['video_skip_total'] ? api['video_skip_total'] : 0);
                $( row.column(43).footer() ).html(api['sumLikes'] ? numberFormatter.format(api['sumLikes']) : 0);
                $( row.column(44).footer() ).html(api['sumShares'] ? numberFormatter.format(api['sumShares']) : 0);
                $( row.column(45).footer() ).html(api['sumSharedClicks'] ? numberFormatter.format(api['sumSharedClicks']) : 0);
                $( row.column(46).footer() ).html(api['sumSharedConversions'] ? numberFormatter.format(api['sumSharedConversions']) : 0);
                $( row.column(48).footer() ).html(api['publisher_revenue_total'] ? numberFormatter.format(api['publisher_revenue_total']) : 0);
                $( row.column(49).footer() ).html(api['feed_revenue']     ? numberFormatter.format(api['feed_revenue']) : 0);
                $( row.column(50).footer() ).html(api['impressionsTotal'] > 0 ? (api['clicksTotal']*100/api['impressionsTotal']).toFixed(2) + '%' : '0.00%');
                $( row.column(51).footer() ).html(api['clicksTotal']      > 0 ? (api['conversionsTotal']*100/api['clicksTotal']).toFixed(2) + '%' : '0.00%');
                $( row.column(52).footer() ).html(api['impressionsTotal'] > 0 ? (api['publisher_revenue_total']/api['impressionsTotal']*1000).toFixed(2) : '0.00');
                $( row.column(53).footer() ).html(api['clicksTotal']      > 0 ? (api['finalRevenueTotal']/api['clicksTotal']).toFixed(2)                 : '0.00');
                $( row.column(54).footer() ).html(api['conversionsTotal'] > 0 && !isNaN(api['finalRevenueTotal']) ? (api['finalRevenueTotal']/api['conversionsTotal']).toFixed(2) : '0.00');
                }
                }
            });
            var table = $("#report-main-table").DataTable();
            if (inventory_filter != null && inventory_filter.length === 1 && inventory_filter.includes('5') ) {
                table.columns([33, 34, 35, 36, 37, 38, 39, 40, 41, 42]).visible(true);
                $('.video-footer, .video-header-col, .video-header').show();
            }else{
                table.columns([33, 34, 35, 36, 37, 38, 39, 40, 41, 42]).visible(false);
                $('.video-footer, .video-header-col, .video-header').hide();
            }
            $('.pubSelectedOption').each(function() {
                if($(this).is(':checked')){
                    $("#report-main-table").DataTable().column( $(this).data('column') ).visible(  true );
                }else{
                    $("#report-main-table").DataTable().column( $(this).data('column') ).visible(  false );
                }
            });
        }
        $('body').on('click', '.dt-hourly-based', function() {
            var start_date = $("#start_date").val();
            var end_date = $("#end_date").val();
            var table = $("#report-main-table").DataTable();
            var tr = $(this).closest('tr');
            var row = table.row(tr);
            var website_id = $(this).find('i').data('website-id');
            var unique_id  = $(this).find('i').data('id');
            var inventory_filter  = $(this).find('i').data('inventory_type');
            var placement_id  = $(this).find('i').data('placement-id');
            var entry_type  = $(this).find('i').data('entry-type');
            var time_zone_filter  = $(this).find('i').data('time_zone_filter');
            time_zone_filter = $('#time_zone_filter').val();
            var impression_date = $(this).find('i').data('date');
            if (row.child.isShown()) {
                // This row is already open - close it
                row.child.hide();
                tr.removeClass('shown');
                $("i", this).toggleClass("fa fa-minus-circle redIcon fa fa-plus-circle greenIcon");
            } else {
                // Open this row
                row.child('<div id="hourly_datatable"><table class="table table-small-font table-bordered hourly_based_Publisher_child_table text-center" id="childtable-hourly-based-'+website_id+unique_id+'" width="50%" ></table></div>').show();
                tr.addClass('shown');
                $("i", this).toggleClass("fa fa-plus-circle greenIcon  fa fa-minus-circle redIcon");
            }
            if(!row.child.isShown()) return;
            $.ajax({
                type: 'POST',
                url: "{{url('getPublisherReportHourly')}}",
                dataType: "json",
                data: {
                    _token: "{{csrf_token()}}",
                    "start_date": start_date,
                    "end_date": end_date,
                    "website_id": website_id,
                    "inventory_filter": inventory_filter,
                    "placement_id"    : placement_id,
                    "time_zone_filter": time_zone_filter,
                    "entry_type" :entry_type,
                    "impression_date" :impression_date
                },
                success: function(detailsData) {
                $('#childtable-hourly-based-'+website_id+unique_id).DataTable({
                        data: detailsData,
                        paging: false,
                        deferRender: true,
                        lengthChange: false,
                        bSort: false,
                        bInfo: false,
                        searching: false,
                        bAutoWidth: false,
                        order: [],
                        columns: [
                            {
                                title: 'S.no',
                                data:  "id",
                                render: function(data, type, row, meta) {
                                    return meta.row + meta.settings._iDisplayStart + 1;
                                }
                            },
                            {
                                title: 'Hours',
                                data: 'current_hour',
                                render: function(data, type, row, meta) {
                                    let hours = '';
                                    if(row.current_hour < 10){
                                        hours = '0'+row.current_hour+':00'
                                    }else{
                                        hours = row.current_hour+':00'
                                    }
                                    return ((hours)  ? hours :  "0")
                                }
                            },
                            {
                                title: 'Ad Request',
                                data: 'hourly_based_ad_request',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_ad_request) ? numberFormatter.format(row.hourly_based_ad_request) : "0")
                                }
                            },
                            {
                                title: 'Exceeded QPS',
                                data: 'hourly_based_otr_request',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_otr_request) ? numberFormatter.format(row.hourly_based_otr_request) : "0")
                                }
                            },
                            {
                                title: 'Filled Request',
                                data: 'hourly_based_total_impressions',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_total_impressions) ? numberFormatter.format(row.hourly_based_total_impressions) : "0")
                                }
                            },
                            {
                                title: 'Fill Rate % <span data-toggle="tooltip" title="(Filled Request / Ad Request) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'Fill_Rate',
                                render: function(data, type, row, meta) {
                                    return ((row.Fill_Rate) ? row.Fill_Rate + ' %' : "0.00 %");
                                }
                            },
                            {
                                title: 'Bids Won',
                                data: 'Bids_Won',
                                render: function(data, type, row, meta) {
                                    return row.Bids_Won || "0";
                                }
                            },
                            {
                                title: 'Bids Won Percentage % <span data-toggle="tooltip" title="(Bids Won / Ads Request) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'Bids_Won_Percentage',
                                render: function(data, type, row, meta) {
                                    return ((row.Bids_Won_Percentage) ? row.Bids_Won_Percentage + ' %' : "0.00 %");
                                }
                            },
                            {
                                title: 'Bids Lost',
                                data: 'Bids_Lost',
                                render: function(data, type, row, meta) {
                                    return row.Bids_Lost || "0";
                                }
                            },
                            {
                                title: 'Billable Bids',
                                data: 'Billable_Bids',
                                render: function(data, type, row, meta) {
                                    return row.Billable_Bids || "0";
                                }
                            },
                            {
                                title: 'Viewable Impressions',
                                data: 'hourly_based_viewable_impressions',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_viewable_impressions) ? numberFormatter.format(row.hourly_based_viewable_impressions) : "0")
                                }
                            },
                            {
                                title: 'Clicks',
                                data: 'hourly_based_clicks',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_clicks) ? numberFormatter.format(row.hourly_based_clicks) : "0")
                                }
                            },
                            {
                                title: 'Conversions',
                                data: 'hourly_based_conversions',
                                render: function(data, type, row, meta) {
                                    return ((row.hourly_based_conversions) ? numberFormatter.format(row.hourly_based_conversions) : "0")
                                }
                            },
                            {
                                title: 'CTR % <span data-toggle="tooltip" title="(Clicks / Impressions) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'CTR',
                                render: function(data, type, row, meta) {
                                    return ((row.CTR) ? row.CTR + ' %' : "0.00 %")
                                }
                            },
                            {
                                title: 'CR % <span data-toggle="tooltip" title="(Conversions / Clicks) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'CR',
                                render: function(data, type, row, meta) {
                                return ((row.CR) ? row.CR + ' %' : "0.00 %");
                                }
                            },
                            {
                                title: 'eCpm <span data-toggle="tooltip" title="(Revenue / Impressions) x 1000"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'eCpm',
                                render: function(data, type, row, meta) {
                                return ((row.eCpm) ? parseFloat(row.eCpm) : "0.00");
                                }
                            },
                            {
                                title: 'eCpc <span data-toggle="tooltip" title="Revenue / Clicks"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'eCpc',
                                render: function(data, type, row, meta) {
                                return ((row.eCpc) ? row.eCpc + parseFloat(row.eCpc) : "0.00");
                                }
                            },
                            {
                                title: 'CPA <span data-toggle="tooltip" title="Revenue / Conversions"><i class="fa fa-info-circle" aria-hidden="true"></i></span>',
                                data: 'CPA',
                                render: function(data, type, row, meta) {
                                return ((row.CPA) ? row.CPA + parseFloat(row.CPA) : "0.00");
                                }
                            },
                            {
                                title: 'Entry Type',
                                data: 'Entry_Type',
                                render: function(data, type, row, meta) {
                                return row.Entry_Type || "N/A";
                                }
                            }

                        ]
                    });
                }
            });
        });
        $(document).on('click','.export_hourly_publisher_report',function(e) {
                var start_date = $("#start_date").val();
                var end_date = $("#end_date").val();
                web_id = $(this).data('website-id');
                var inventory_filter  = $(this).data('inventory_type');
                var channelType_filter = $('#channelTypeFilter').val();
                var oemId_filter = $('#oemIdFilter').val();
                var placement_id  = $(this).data('placement-id');
                var time_zone     = $(this).data('time_zone_filter');
                $('#from_date_hidden_hourly').val(start_date);
                $('#to_date_hidden_hourly').val(end_date);
                $('#website_id_hidden_hourly').val(web_id);
                $('#inventory_type_hidden_hourly').val(inventory_filter);
                $('#oemId_hidden_hourly').val(inventory_filter);
                $('#channel_type_hidden_hourly').val(inventory_filter);
                $('#placement_id_hidden_hourly').val(placement_id);
                $('#time_zone_hidden_hourly').val(time_zone);
                $('#hourly_based_form').submit();
            });
// calling the download function and and after downloading deleting the file from bucket and row from the table
function deleteFileFroms3(e){
    // file link saved in data attribute
    var link = e.target.getAttribute('data-link');
    setTimeout(function(){
        $.ajax({
            "url": "{{ url('deleteFileFroms3') }}",
            "type": "GET",
            "data": {
                    path: link
                },
            "dataType": "json",
            success: function(response) {
            }
        });
    }, 5000);
    // changing the html of the button so that we dont need to refresh the page for the first time
    setTimeout(function(){
        $('.changeHtmlForExport').html('<button type="submit" class="export-feedreport btn excel-btn btn-sm border-radius-0"><i class="fa fa-download"></i> Export</button>');
    }, 500);
}
function getSubPlacement(flag){
  $.ajax({
    "url"      : "{{ url('getSubPlacementNames') }}/" + flag,
    "type"     : 'GET',
    "dataType" : 'json',
    success: function(response) {
      $("#sub_placement_filter").empty();
      var subPlacementList = '';
      response.forEach(function(data){
          subPlacementList +=`<option value="${data.id}">${data.sub_placement_name}</option>`;
      });
      $("#sub_placement_filter").html(subPlacementList);
      $('#sub_placement_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    }
  });
}

// Load Inventory Types
function getPlacementTypes(campaign_type,sub_type = 1) {
  if(campaign_type){
    if(campaign_type == 1){ //for OEM Campaign
      $.ajax({
        "url"      : "{{ url('get_placement_names') }}",
        "type"     : 'GET',
        "dataType" : 'json',
        success: function(response) {
          $("#placement_filter").empty()
          var placementList = '';
          response.forEach(function(data){
            if (data.website_id) {
              placementList +=`<option value="${data.id}" data-id="${data.id}" data-inventory="${data.inventory_type}">${data.placement_name}</option>`;
            }
          });
          if($('#channelTypeFilter').val() != 1 ){
            placementList +=`<option value="1">Standard Inventory</option>`;
            placementList +=`<option value="2">Expanded Inventory</option>`;
            placementList +=`<option value="3">Selected Inventory</option>`;
          }
          $("#placement_filter").html(placementList);
          $('#placement_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
        }
      });
     getSubPlacement(sub_type);
    }
  }
}

function getPlacementByOEMId(oem_id){
  $.ajax({
    "url"      : "{{ url('getPlacementsByOEMId') }}",
    "type"     : 'POST',
    "dataType" : 'json',
    "data": {
                _token: "{{csrf_token()}}",
                "oem_id" : oem_id,
                "flag":1
            },    
    success: function(response) {
      $("#placement_filter").empty();
      var subPlacementList = '';
      response.forEach(function(data){
          subPlacementList +=`<option value="${data.id}">${data.placement_name}</option>`;
      });
      $("#placement_filter").html(subPlacementList);
      $('#placement_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
      getSubPlacementByOEMId(oem_id);
    }
  });
}

// Load Sub-Placement Types
function getSubPlacementTypes(id,inventory_type) {
    $.ajax({
    "url"      : "{{ url('getSubplacementById') }}",
    "type"     : 'POST',
    "dataType" : 'json',    
    "data" :{
                _token: "{{csrf_token()}}",
                "id" : id, 
                "inventory_type" : inventory_type
            },
    success: function(response) {
        $("#sub_placement_filter").empty()
        var subPlacementList = '';
        response.forEach(function(data){
            subPlacementList +=`<option value="${data.id}">${data.sub_placement_name}</option>`;
        });
        $("#sub_placement_filter").html(subPlacementList);
        $('#sub_placement_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    }
    });
}
function getSubPlacementByOEMId(oem_id){
  $.ajax({
    "url"      : "{{ url('getPlacementsByOEMId') }}",
    "type"     : 'POST',
    "dataType" : 'json',    
    "data": {
                _token: "{{csrf_token()}}",
                "oem_id" : oem_id,
                "flag":0
            },    
    success: function(response) {
      $("#sub_placement_filter").empty();
      var subPlacementList = '';
      response.forEach(function(data){
          subPlacementList +=`<option value="${data.id}">${data.placement_name}</option>`;
      });
      $("#sub_placement_filter").html(subPlacementList);
      $('#sub_placement_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    }
  });
}
function getInventories (){
    var website_id = $('.campaignId-slot-WebsiteID').text();
    var campaignId = $('#blockedCampaignId').val();
    $.ajax({
        url      : "{{ url('get_inventory_types') }}",
        type     : 'GET',
        dataType : 'json',
        success: function(data) {
            $('#inventory_filter').empty();
            $.each(data, function(key, value) {
            if(value.id != 8 && value.id != 9){
                $('#inventory_filter').append($('<option>', {
                    value : value.id,
                    text  : value.inventory_name
                }));
            }
            });
            $('#inventory_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
        }
    });
}

function getOEMIds() {
    $.ajax({
        url: "{{ url('getAllOEMIds') }}",
        type: "GET",
        dataType: "json",
        success: function(response) {
            $("#oemIdFilter").empty();
            var oemList = '';
            response.forEach(function(data){
                let oem_name = data.oem_name ? ' ('+data.oem_name+')' : '';
                oemList +="<option value='"+data.id+"'>OEM - "+data.id + oem_name+"</option>";
            });
            $("#oemIdFilter").html(oemList);
            $('#oemIdFilter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
        }
    });
}

function getAllClients() {
    $.ajax({
        url: "{{ url('getAllClients') }}",
        type: "POST",
        dataType: "json",
        data: {
            _token: "{{csrf_token()}}"
        },
        success: function(response) {
            $("#client_filter").empty();
            var clientList = '';
            response.forEach(function(data){
                clientList +="<option value='"+data.id+"'>"+data.account_name+"-("+data.id+")</option>";
            });
            $("#client_filter").html(clientList);
            $('#client_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
        }
    });
}
$('#channelTypeFilter').on('change', function() {
    var campaign_type     = $(this).val();
    $('#oemIdFilter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    $('#inventory_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    if(campaign_type.length > 0){
        if(campaign_type == 1) {
           $(".oem_div, .sub_placement_div, .placement_div").show()
           $(".inv_div").hide();
           getPlacementTypes(campaign_type);
        }else if(campaign_type == 0){
           $(".inv_div").show();
           $(".oem_div,.sub_placement_div, .placement_div").hide();
        }
    }else{
        getPlacementTypes(1,0);
        $(".oem_div").hide();
        $(" .inv_div, .sub_placement_div, .placement_div").show();
    }
});

$('#oemIdFilter').on('change',function() {
    $('#inventory_filter').multiselect('rebuild').multiselect('refresh').multiselect('clearSelection');
    var oem_id     = $(this).val();
    getPlacementByOEMId(oem_id);
});

$("body").on("change", "#placement_filter", function() {
    var inventoryTypeFilter  = $('#inventory_filter').val();
    var placementValue = $(this).val();// Ensure placementValue is an array
    getSubPlacementTypes(placementValue,inventoryTypeFilter);
});
function validateInput(event) {
    var inputValue = event.key;
    if (inputValue === '0' && event.target.value === '') {
        // If '0' is the first character and the input is empty, prevent entering '0'
        event.preventDefault();
        return false;
    }
    return event.charCode >= 48 && event.charCode <= 57; // Allow only digits (0-9)
}
    </script>
    @endsection