@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-top: -25px;
        margin-bottom: 0px !important;
    }
    .small{
        float: left;
        margin-top: -15px;
    }
    .pencil-input{
        width : 100% !important;
    }
    .pubSelectedOption{
        margin-top : 15px;
        min-width  : 20px;
    }
    input:read-only{
        cursor      : pointer;
        margin-top  : 13px;
        margin-left : -6px;
    }
    .checkboxLabel{
       font-size : 15px;
       width     : 150px;
    }
    .pubFeedSubReport{
        height       : 27px;
        float        : right;
        margin-left  : -20px;
        margin-right : 10px;
    }
    .export-feedpublishersourcingurlreport{
        height: 27px;
    }
    .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.sub_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">
                <form class="pull-right mr-3" id="publisherReportForm" action="{{ url('exportpublisherSubReport') }}">
                    @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="oemId_filter" id="oemId_filter_hidden"/>
                    <input type="hidden" name="channelType_filter" id="channelType_filter_hidden"/>
                    <input type="hidden" name="inventory_filter" id="inventory_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"/>
                </form>
                <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" class="pubFeedSubReport btn excel-btn btn-sm border-0 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">
                        <label for="period_filter">Choose Time Period</label>
                        <select id="period_filter" class="form-control">
                            <option value='' disabled>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">
                        <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">
                        <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">
                        <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">
                        <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">
                        <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">
                        <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-md-2 pl-0">
                        <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-md-2 pl-0 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 inv_div">
                        <label for="inventory_filter">Inventory Type</label>
                            <select class="form-control" name="inventory_filter[]" id="inventory_filter" multiple> </select>
                    </div>
                    <div class="form-group col-2 pl-0 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 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">
                        <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 time_zone">
                        <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">
                        <label>Optional Filter</label>
                        <label class="checkboxLabel"><input type="checkbox" class="pubSelectedOption" data-column="7" data-column-name="current_hour">Hour-Wise</label>
                    </div>
                </div>
            </form>
            <div class="col-8 pl-0 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">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">Inventory Type</th>
                        <th rowspan="2">Platfrom</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 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 = time_zone_filter = currency_filter = '';
            /* call function while DOM get ready to get all records.*/
            feedPublisherSubReport();
            getInventories();
            getOEMIds();
            getAllClients();
            getPlacementTypes(1,0);
            $(".oem_div").hide();
            //all records displaying here
            function feedPublisherSubReport(website_id = null,client_id =null, language_id = null, revenue_type = null,publisher_state=null,inventory_filter=null,optionalFilter=null,placement_name=null,subplacement_name=null,oemId_filter=null,channelType_filter=null, time_zone_filter=null, currency_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();
                time_zone_filter = $('#time_zone_filter').val();
                currency_filter = $('#currency_filter').val();
                var end_date = $('#end_date').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('getPublisherSubReport') }}",
                        "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,
                            "channelType_filter":channelType_filter,
                            "oemId_filter":oemId_filter,
                            "inventory_filter":inventory_filter,
                            "optionalFilter"  : optionalFilter,
                            "placement_name"    : placement_name,
                            "subplacement_name" : subplacement_name,
                            "time_zone_filter"  : time_zone_filter,
                            "currency_filter"   : currency_filter
                        },
                        "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-id="'+meta.row +'" aria-hidden="true"> </i> </a> </span> <span class="m-2"> <a  href="#!" title="Download Hourly Based Report" class="export_hourly_publisher_sub_report" data-date="'+row.Impression_Date+'" data-website-id="'+website_id+'" data-placement-id="'+row.Placement_Id+'" data-inventory_type="'+inventory_type+'" 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-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: "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: "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: "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(13).footer() ).html(api['ad_request'] ? numberFormatter.format(api['ad_request']) : 0);
                    $( row.column(14).footer() ).html(api['otr_request'] ? numberFormatter.format(api['otr_request']) : 0);
                    $( row.column(15).footer() ).html(api['non_viewable_impressions'] ? numberFormatter.format(api['non_viewable_impressions']) : 0);
                    $( row.column(16).footer() ).html(api['non_viewable_impressions']*100/api['ad_request']    ? (api['non_viewable_impressions']*100/api['ad_request']).toFixed(2)   : 0);
                    $( row.column(17).footer() ).html(api['bidsWonTotal'] ? numberFormatter.format(api['bidsWonTotal']) : 0);
                    $( row.column(18).footer() ).html(api['ad_request'] > 0 && api['bidsWonTotal'] > 0 ? (100*api['bidsWonTotal']/api['ad_request']).toFixed(2) : 0);
                    $( row.column(19).footer() ).html(api['bidsLostTotal'] ? numberFormatter.format(api['bidsLostTotal']) : 0);
                    $( row.column(20).footer() ).html(api['billableBidsTotal'] ? numberFormatter.format(api['billableBidsTotal']) : 0);
                    $( row.column(21).footer() ).html(api['impressionsTotal'] ? numberFormatter.format(api['impressionsTotal']) : 0);
                    $( row.column(22).footer() ).html(api['pausedImpressionsTotal'] ? numberFormatter.format(api['pausedImpressionsTotal']) : 0);
                    $( row.column(23).footer() ).html(api['impressionsTotal'] > 0 && api['bidsWonTotal'] > 0 ? (100*api['impressionsTotal']/api['bidsWonTotal']).toFixed(2) : 0);
                    $( row.column(24).footer() ).html(api['impressionsTotal'] > 0 && api['ad_request'] > 0 ? (100*api['impressionsTotal']/api['ad_request']).toFixed(2) : 0);
                    $( row.column(25).footer() ).html(api['clicksTotal']      ? numberFormatter.format(api['clicksTotal'])      : 0);
                    $( row.column(26).footer() ).html(api['conversionsTotal'] ? numberFormatter.format(api['conversionsTotal']) : 0);
                    $( row.column(28).footer() ).html(api['video_start_total'] ? api['video_start_total'] : 0);
                    $( row.column(29).footer() ).html(api['video_first_quartile_total'] ? api['video_first_quartile_total'] : 0);
                    $( row.column(30).footer() ).html(api['video_midpoint_total'] ? api['video_midpoint_total'] : 0);
                    $( row.column(31).footer() ).html(api['video_third_quartile_total'] ? api['video_third_quartile_total'] : 0);
                    $( row.column(32).footer() ).html(api['video_complete_total'] ? api['video_complete_total'] : 0);
                    $( row.column(33).footer() ).html(api['video_rewind_total'] ? api['video_rewind_total'] : 0);
                    $( row.column(34).footer() ).html(api['video_full_screen_total'] ? api['video_full_screen_total'] : 0);
                    $( row.column(35).footer() ).html(api['video_mute_total'] ? api['video_mute_total'] : 0);
                    $( row.column(36).footer() ).html(api['video_skip_total'] ? api['video_skip_total'] : 0);
                    $( row.column(37).footer() ).html(api['sumLikes'] ? numberFormatter.format(api['sumLikes']) : 0);
                    $( row.column(38).footer() ).html(api['sumShares'] ? numberFormatter.format(api['sumShares']) : 0);
                    $( row.column(39).footer() ).html(api['sumSharedClicks'] ? numberFormatter.format(api['sumSharedClicks']) : 0);
                    $( row.column(40).footer() ).html(api['sumSharedConversions'] ? numberFormatter.format(api['sumSharedConversions']) : 0);
                    $( row.column(42).footer() ).html(api['publisher_revenue_total'] ? numberFormatter.format(api['publisher_revenue_total']) : 0);
                    $( row.column(43).footer() ).html(api['feed_revenue']     ? numberFormatter.format(api['feed_revenue']) : 0);
                    $( row.column(44).footer() ).html(api['impressionsTotal'] > 0 ? (api['clicksTotal']*100/api['impressionsTotal']).toFixed(2) +'%' : '0%');
                    $( row.column(45).footer() ).html(api['clicksTotal']      > 0 ? (api['conversionsTotal']*100/api['clicksTotal']).toFixed(2) +'%' : '0%');
                    $( row.column(46).footer() ).html(api['impressionsTotal'] > 0 ? (api['publisher_revenue_total']/api['impressionsTotal']*1000).toFixed(2) : 0);
                    $( row.column(47).footer() ).html(api['clicksTotal']      > 0 ? (api['finalRevenueTotal']/api['clicksTotal']).toFixed(2)           : 0);
                    $( row.column(48).footer() ).html(api['conversionsTotal'] > 0 && !isNaN(api['finalRevenueTotal']) ? (api['finalRevenueTotal']/api['conversionsTotal']).toFixed(2) : 0);
                    }
                    }
                });
                var table = $("#report-main-table").DataTable();
                if (inventory_filter != null && inventory_filter.length === 1 && inventory_filter.includes('5') ) {
                    table.columns([27, 28, 29, 30, 31, 32, 33, 34, 35, 36]).visible(true);
                    $('.video-footer, .video-header-col, .video-header').show();
                }else{
                    table.columns([27, 28, 29, 30, 31, 32, 33, 34, 35, 36]).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 );
                    }
                });
            }

            // clear all filter script
            $('.clear_filter').on('click',function(){
                $('#website_id').val('');
                $('.pubSelectedOption').val('');
                $('.pubSelectedOption').prop('checked', false);
                $('#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");
                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);
                feedPublisherSubReport();
            });
            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()
                channelType_filter = $('#channelTypeFilter').val();
                oemId_filter = $('#oemIdFilter').val();
                inventory_filter = $('#inventory_filter').val();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name   = $('#placement_filter').val();
                subplacement_name= $('#sub_placement_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                currency_filter = $('#currency_filter').val();
                feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,optionalFilter,placement_name,subplacement_name,oemId_filter,channelType_filter,time_zone_filter,currency_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();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                placement_name    = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                currency_filter   = $('#currency_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);
                // $('#optionalFilter_hidden').val(optionalFilter);
                // $('#placement_hidden').val(placement_name);
                // $('#subPlacement_hidden').val(subplacement_name);
                    let page_name = 'Sub ' + $("#sub_report_dropdown option:selected").text();
                    $('.export-feedreport').attr('disabled','disabled');
                    $('.export-feedreport').addClass('bg-secondary');
                    $.ajax({
                        "url"  : "{{ url('exportPublisherSubReports') }}",
                        "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,
                            optionalFilter    : optionalFilter,
                            placementFilter   : placement_name,
                            subPlacementFilter: subplacement_name,
                            search            : search,
                            oemId_filter      : oemId_filter,
                            channelType_filter: channelType_filter,
                            time_zone_filter  : time_zone_filter,
                            currency_filter   : currency_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');
                        }
                    }
                });
            });

            $(".pubFeedSubReport").click(function(e) {
                e.preventDefault();
                web_id            = $('#website_id').val()
                lang_id           = $('#language_filter').val()
                client_id         = $('#client_filter').val();
                revenue_type      = $('#revenue_filter').val()
                inventory_filter  = $('#inventory_filter').val();
                channelType_filter= $('#channelTypeFilter').val();
                oemId_filter      = $('#oemIdFilter').val();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                placement_name    = $('#placement_filter').val();
                subplacement_name = $('#sub_placement_filter').val();
                time_zone_filter  = $('#time_zone_filter').val();
                currency_filter   = $('#currency_filte').val();
                feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,optionalFilter,placement_name,subplacement_name,oemId_filter,channelType_filter,time_zone_filter,currency_filter);
                var column =  $("#report-main-table").DataTable().column($('.pubSelectedOption').attr('data-column'));
                // Toggle the visibility of the column
                column.visible(column.visible());
            });
            /*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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,optionalFilter,placement_name,subplacement_name);

            // /*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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
            //     optionalFilter   = $('.pubSelectedOption:checked').length;
            //     placement_name    = $('#placement_filter').val();
            //     subplacement_name = $('#sub_placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,optionalFilter,placement_name,subplacement_name);
            //     // 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());
            // });
                
            /*Placement filter on change*/
            $("body").on("change", "#placement_filter", function() {
                placement_name    = $(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();
                optionalFilter    = $('.pubSelectedOption:checked').length;
                subplacement_name = $('#sub_placement_filter').val();
                placement_name    = placement_name.length ? placement_name : 0;
                // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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;
            //     subplacement_name= $(this).val();
            //     placement_name   = $('#placement_filter').val();
            //     feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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>',
                }
            });

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

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

            $('#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();
                    optionalFilter = $('.pubSelectedOption:checked').length;
                    placement_name    = $('#placement_filter').val();
                    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);
                    // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
                    optionalFilter = $('.pubSelectedOption:checked').length;
                    placement_name    = $('#placement_filter').val();
                    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);
                    }
                    // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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();
                optionalFilter = $('.pubSelectedOption:checked').length;
                placement_name    = $('#placement_filter').val();
                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);
                        // feedPublisherSubReport(web_id,client_id,lang_id, revenue_type,publisher_state,inventory_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);
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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);
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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);
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_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);
                        // feedPublisherSubReport(web_id,client_id, lang_id, revenue_type,publisher_state,inventory_filter,optionalFilter,placement_name,subplacement_name);
                    }
                }
            });

        });

        // 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);
                }
            });
        }
        
        $('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 time_zone_filter  = $(this).find('i').data('time_zone_filter');
            time_zone_filter = $('#time_zone_filter').val();
            var entry_type  = $(this).find('i').data('entry-type');
            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_sub_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 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);
                $('#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", "#inventory_filter", function(){
    $('#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");
});
$("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