@extends('layouts.app')

@section('appjs')
    <script type="application/javascript" src="{{ asset('js/app.js') }}"></script>
@endsection
<style>
    .main-analytics{
        white-space: pre;
    }
    #gateway-wise-table_filter, #gateway-type-wise-table_filter, #campaign-type-wise-table_filter{
        margin-top: -60px;
    }
    .table thead, .table tbody{
        font-size: 0.9em;
    }
</style>
@section('content')

@section('page_title') Analytics @endsection
<div class="container-fluid">
	<div class="card">
		<div class="card-header">
            <h4> <b>Analytics</b>
        @can('hasExcelPermission')
        <form class="pull-right mb-0" method="post" action="{{ url('exportanalytics') }}">
                @csrf
                <button type="submit" class="export-analytics-excel btn excel-btn border-radius-0"><i class="fa fa-download"></i> Export</button>
            </form>
            @endcan
            </h4>
        </div>
		<div class="card-body">
			<div class="table-responsive">
				<table class="table table-bordered table-hover main-analytics">
					<thead>
					    <tr>
					    <th scope="col"><b>Category</b></th>
					    <th scope="col"><b>Accounts</b></th>
					    <th scope="col"><b>Pushed</b></th>
					    <th scope="col"><b>Submission</b></th>
					    <th scope="col"><b>Total SMS Units</b></th>
					    <th scope="col"><b>Total Clicks</b></th>
					    <th scope="col"><b>Unique Clicks</b></th>
					    <th scope="col"><b>New Accounts</b></th>
					    </tr>
					</thead>
					<tbody>

							@foreach($analytics as $analyticle_details)
                            <tr>
								<td><b>{{$analyticle_details->record_of ?? 0 }}</b></td>
								<td>{{$analyticle_details->account_used ?? 0 }}</td>

								<td>{{$analyticle_details->pushed ?? 0 }}</td>

								<td>{{$analyticle_details->submission ?? 0 }}</td>
								<td>{{$analyticle_details->total_sms_units ?? 0 }}</td>
								<td>{{$analyticle_details->total_clicks ?? 0 }}</td>

								<td>{{$analyticle_details->unique_clicks ?? 0 }}</td>

								<td>{{$analyticle_details->new_accounts ?? 0 }}</td>
                                </tr>
                            @endforeach

					</tbody>
				</table>
			</div>
		</div>
	</div>

<!-- gateway wise analytics report start-->
	<div class="card mt-4">
        <div class="card-header"><h4> <b>Gateway Wise Analytics</b>
        @can('hasExcelPermission')
        <form class="pull-right mb-0" action="{{ url('exportgatewaywiseanalytics') }}" method="POST">
                @csrf
                <button type="submit" class="export-gatewaywise-excel btn excel-btn border-radius-0"><i class="fa fa-download"></i> Export</button>
                <input type="hidden" name="start_date" id="from_date_gatewaywise_hidden" />
                <input type="hidden" name="end_date" id="to_date_gatewaywise_hidden"/>
            </form>
            @endcan
            </h4>
        </div>
        <div class="card-body table-responsive" >
        <form class="flex">
                <div class="form-group col-md-2">
                            <label for="filter_gateway_wise">Choose Time Period</label>
                            <select id="filter_gateway_wise" class="form-control">
                                <option value=''>Select</option>
                                <option value="1" selected>Today</option>
                                <option value="2">Yesterday</option>
                                <option value="3">This Month</option>
                                <option value="4">Last Month</option>
                                <option value="5">Last 6 Months</option>
                                <option value="6">This Year</option>
                                <option value="7">Last Year</option>
                            </select>
                        </div>
                <div class="form-group col-md-2">
                    <label for="start_date_gateway_wise">From Date</label>
                    <input type="text" class="form-control" id="start_date_gateway_wise" name="start_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
                </div>

                <div class="form-group col-md-2">
                    <label for="end_date_gateway_wise">To Date</label>
                    <input type="text" class="form-control" id="end_date_gateway_wise" name="end_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
                </div>
        </form>
                    <table class="table table-bordered table-hover" id="gateway-wise-table">
                        <thead>
                            <tr>
                            <th scope="col">Server Name</th>
                            <th scope="col">Total SMS Pushed</th>
                            <th scope="col">SMS Submitted</th>
                            <th scope="col">Clicks</th>
                            <th scope="col">Unique Clicks</th>
                            <th scope="col">Whistle Actions</th>
                            <th scope="col">Spends</th>
                            <th scope="col">Bot Clicks</th>
                            <th scope="col">Total Clicks <span data-toggle="tooltip" title="Clicks + Bot Clicks"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                            <th scope="col">Actual CTR  <span data-toggle="tooltip" title="(Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                            <th scope="col">Bot CTR <span data-toggle="tooltip" title="(Bot Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                            <th scope="col">Total CTR  <span data-toggle="tooltip" title="((clicks + bot Clicks)/SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
                            </tr>
                        </thead>
                    </table>
                </div>
	</div>

<!-- gateway type analytics report start-->
<div class="card mt-4">
    <div class="card-header"><h4><b> Gateway Type Analytics</b>
    @can('hasExcelPermission')
    <form class="pull-right mb-0" action="{{ url('exportgatewaytypeanalytics') }}" method="POST">
                @csrf
                <button type="submit" class="export-gatewaytype-excel btn excel-btn border-radius-0"><i class="fa fa-download"></i> Export</button>
                <input type="hidden" name="start_date" id="from_date_gatewaytype_hidden" />
                <input type="hidden" name="end_date" id="to_date_gatewaytype_hidden"/>
            </form>
            @endcan
        </h4></div>
    <div class="card-body table-responsive">
    <form class="flex">
            <div class="form-group col-md-2">
                        <label for="period_filter">Choose Time Period</label>
                        <select id="period_filter" class="form-control">
                            <option value=''>Select</option>
                            <option value="1" selected>Today</option>
                            <option value="2">Yesterday</option>
                            <option value="3">This Month</option>
                            <option value="4">Last Month</option>
                            <option value="5">Last 6 Months</option>
                            <option value="6">This Year</option>
                            <option value="7">Last Year</option>
                        </select>
                    </div>
            <div class="form-group col-md-2">
                <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-md-2">
                <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>
    </form>
        <table class="table table-bordered table-hover" id="gateway-type-wise-table">
        <thead>
		<th scope="col">Gateway Type</th>
		<th scope="col">Total SMS Pushed</th>
        <th scope="col">SMS Submitted</th>
		<th scope="col">Clicks</th>
		<th scope="col">Unique Clicks</th>
		<th scope="col">Whistle Actions</th>
		<th scope="col">Spends</th>
		<th scope="col">Bot Clicks</th>
		<th scope="col">Total Clicks <span data-toggle="tooltip" title="Clicks + Bot Clicks"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Actual CTR  <span data-toggle="tooltip" title="(Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Bot CTR <span data-toggle="tooltip" title="(Bot Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Total CTR  <span data-toggle="tooltip" title="((clicks + bot Clicks)/SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
        </thead>
    </table>
    </div>
</div>

<!--campaign type analytics report start-->
<div class="card mt-4">
    <div class="card-header"><h4><b> Campaign Type Analytics</b>
    @can('hasExcelPermission')
    <form class="pull-right mb-0" action="{{ url('exportcampaigntypeanalytics') }}" method="POST">
                @csrf
                <button type="submit" class="export-camptype-excel btn excel-btn border-radius-0"><i class="fa fa-download"></i> Export</button>
                <input type="hidden" name="start_date" id="from_date_camptype_hidden" />
                <input type="hidden" name="end_date" id="to_date_camptype_hidden"/>
            </form>
            @endcan
        </h4></div>
    <div class="card-body table-responsive">
    <form class="flex">
            <div class="form-group col-md-2">
                        <label for="filter_camp_type">Choose Time Period</label>
                        <select id="filter_camp_type" class="form-control">
                            <option value=''>Select</option>
                            <option value="1" selected>Today</option>
                            <option value="2">Yesterday</option>
                            <option value="3">This Month</option>
                            <option value="4">Last Month</option>
                            <option value="5">Last 6 Months</option>
                            <option value="6">This Year</option>
                            <option value="7">Last Year</option>
                        </select>
                    </div>
            <div class="form-group col-md-2">
                <label for="start_date_camp_type">From Date</label>
                <input type="text" class="form-control" id="start_date_camp_type" name="start_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
            </div>

            <div class="form-group col-md-2">
                <label for="end_date_camp_type">To Date</label>
                <input type="text" class="form-control" id="end_date_camp_type" name="end_date" placeholder="Select Date" value="{{date('Y-m-d')}}">
            </div>
    </form>
        <table class="table table-bordered table-hover table-sm" id="campaign-type-wise-table">
        <thead>
		<th scope="col">Campaign Type</th>
		<th scope="col">Total SMS Pushed</th>
        <th scope="col">SMS Submitted</th>
		<th scope="col">Clicks</th>
		<th scope="col">Unique Clicks</th>
		<th scope="col">Whistle Actions</th>
		<th scope="col">Spends</th>
		<th scope="col">Bot Clicks</th>       
		<th scope="col">Total Clicks <span data-toggle="tooltip" title="Clicks + Bot Clicks"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Actual CTR  <span data-toggle="tooltip" title="(Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Bot CTR <span data-toggle="tooltip" title="(Bot Clicks / SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
		<th scope="col">Total CTR  <span data-toggle="tooltip" title="((clicks + bot Clicks)/SMS Submitted) x 100"><i class="fa fa-info-circle" aria-hidden="true"></i></span></th>
        </thead>
    </table>
    </div>
</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">

$(document).ready(function() {
    /* call function while DOM get ready to get all records.*/
    getGatwaytypeReport();
	getGatwaywiseReport();
	getCampaignTypeReport();
  /**select from date here***/

    // export Analytics report
    $(".export-analytics-excel").click(function(){
        $(this).submit();
    });


    $("#start_date").datepicker({
        dateFormat: 'yy-mm-dd',
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        endDate: 'today',
        onSelect: function (selectedDate) {
            var startDate = $('#start_date').datepicker('getDate');
            $('#end_date').datepicker('option', 'minDate', startDate);
            $('#end_date').datepicker('setDate', startDate);
            getGatwaytypeReport();
            $('#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() {
            var startDate = $('#start_date').datepicker('getDate');
            var endDate = $('#end_date').datepicker('getDate');
            if(startDate==null){
                $('#start_date').datepicker('setDate', endDate);
            }
            if (endDate < startDate) {
                var minDate = $('#end_date').datepicker('option', 'minDate', startDate);
                $('#end_date').datepicker('setDate', minDate);
            }
            getGatwaytypeReport();
        },
        onSelect: function() {
            $('#period_filter').val('');
        }
    });

    $("body").on("change", "#period_filter", function(){
            var periodValue = $(this).val();
            $("#start_date").val('');
            $("#end_date").val('');
            if(periodValue==''){
                getGatwaytypeReport();
            }
            //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', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                getGatwayReportList();
            }

            //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', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                getGatwaytypeReport();
            }

            //filter by this month
            else if(periodValue=='3'){
                var start_date = new Date();
                var end_date = new 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('setDate', end_date);
                getGatwaytypeReport();
            }

            //filter by last month
            else if(periodValue=='4'){
                var start_date = new Date();
                var end_date = new Date();
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 1));
                start_date = new Date(start_date.setDate(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);
                getGatwaytypeReport();
            }

            //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);
                getGatwaytypeReport();
            }

            //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);
                $('#start_date').val(start_date);
                $('#end_date').datepicker('option', 'minDate', start_date);
                $('#end_date').datepicker('setDate', end_date);
                getGatwaytypeReport();
            }
            //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);
                getGatwaytypeReport();
            }
        });

         // export gateway type report
         $(".export-gatewaytype-excel").click(function(){
        let start_date = $('#start_date').val();
        let end_date = $('#end_date').val();
        $('#from_date_gatewaytype_hidden').val(start_date);
        $('#to_date_gatewaytype_hidden').val(end_date);
        $(this).submit();
    });
});


function getGatwaytypeReport(){
        var start_date = $('#start_date').val();
        var end_date = $('#end_date').val();
        $.ajax({
            type: "POST",
            url: 'gatewaytype_analytics',
            data: {
                "_token"     : "{{ csrf_token() }}",
                "start_date" : start_date,
                "end_date"   : end_date,
            },
            success: function(data) {
                var gatewaydata = data['gatewaytypewise'];
                $("#gateway-type-wise-table").DataTable().clear().destroy();
                $('#gateway-type-wise-table').DataTable({
                    data: gatewaydata,
                    "bLengthChange": false,
                    "bPaginate": false,
                    "scrollX" : true,
                    "order": [[ 11, "desc" ]],
                    "language": { search: '', searchPlaceholder: "Search..." },
                aoColumns: [
                    { data: "sms_type",
                         render: function(data, type, row, meta) {
                            return ((row.sms_type)  ? row.sms_type :  "NA")
                          }
                    },
                    { data: "sms_pushed",
                         render: function(data, type, row, meta) {
                            return ((row.sms_pushed)  ? row.sms_pushed :  "0")
                          }
                    },
                    { data: "volume_count",
                         render: function(data, type, row, meta) {
                            return ((row.volume_count)  ? row.volume_count :  "0")
                          }
                    },
                    { data: "clicks",
                         render: function(data, type, row, meta) {
                            return ((row.clicks)  ? row.clicks :  "0")
                          }
                    },
                    { data: "unique_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.unique_clicks)  ? row.unique_clicks :  "0")
                          }
                    },
                    { data: "actions",
                         render: function(data, type, row, meta) {
                            return ((row.actions)  ? row.actions :  "0")
                          }
                    },
                    { data: "spends",
                         render: function(data, type, row, meta) {
                            return ((row.spends)  ? row.spends :  "0")
                          }
                    },
					{ data: "bot_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.bot_clicks)  ? row.bot_clicks :  "0")
                          }
                    },
					{ data: "total_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.total_clicks)  ? row.total_clicks :  "0")
                          }
                    },
					{ data: "actual_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.actual_CTR)  ? row.actual_CTR :  "0")
                          }
                    },
					{ data: "bot_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.bot_CTR)  ? row.bot_CTR :  "0")
                          }
                    },
					{ data: "total_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.total_CTR)  ? row.total_CTR :  "0")
                          }
                    }
                ]
                });// gatewaytype wise report end
            }
        });
    }

// gatewaywise report jquery start
	$("#start_date_gateway_wise").datepicker({
        dateFormat: 'yy-mm-dd',
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        endDate: 'today',
        onSelect: function (selectedDate) {
            var startDate = $('#start_date_gateway_wise').datepicker('getDate');
            $('#end_date_gateway_wise').datepicker('option', 'minDate', startDate);
            $('#end_date_gateway_wise').datepicker('setDate', startDate);
            getGatwaywiseReport();
            $('#filter_gateway_wise').val('');
        }
    });


	  /**select  to date here***/
	  $("#end_date_gateway_wise").datepicker({
        dateFormat: 'yy-mm-dd',
        minDate: $("#start_date_gateway_wise").datepicker("getDate"),
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        onClose: function() {
            var startDate = $('#start_date_gateway_wise').datepicker('getDate');
            var endDate = $('#end_date_gateway_wise').datepicker('getDate');
            if(startDate==null){
                $('#start_date_gateway_wise').datepicker('setDate', endDate);
            }
            if (endDate < startDate) {
                var minDate = $('#end_date_gateway_wise').datepicker('option', 'minDate', startDate);
                $('#end_date_gateway_wise').datepicker('setDate', minDate);
            }
            getGatwaywiseReport();
        },
        onSelect: function() {
            $('#filter_gateway_wise').val('');
        }
    });

	$("body").on("change", "#filter_gateway_wise", function(){
            var periodValue = $(this).val();
            $("#start_date_gateway_wise").val('');
            $("#end_date_gateway_wise").val('');
            if(periodValue==''){
                getGatwaywiseReport();
            }
            //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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }

            //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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }

            //filter by this month
            else if(periodValue=='3'){
                var start_date = new Date();
                var end_date = new 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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }

            //filter by last month
            else if(periodValue=='4'){
                var start_date = new Date();
                var end_date = new Date();
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 1));
                start_date = new Date(start_date.setDate(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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }

            //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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }

            //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);
                $('#start_date_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }
            //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_gateway_wise').val(start_date);
                $('#end_date_gateway_wise').datepicker('option', 'minDate', start_date);
                $('#end_date_gateway_wise').datepicker('setDate', end_date);
                getGatwaywiseReport();
            }
        });
        // export gateway wise report
        $(".export-gatewaywise-excel").click(function(){
        let start_date = $('#start_date_gateway_wise').val();
        let end_date = $('#end_date_gateway_wise').val();
        $('#from_date_gatewaywise_hidden').val(start_date);
        $('#to_date_gatewaywise_hidden').val(end_date);
        $(this).submit();
    });

	function getGatwaywiseReport(){
        var start_date = $('#start_date_gateway_wise').val();
        var end_date = $('#end_date_gateway_wise').val();
        $.ajax({
            type: "POST",
            url: 'gatewaywise_analytics',
            data: {
                "_token"     : "{{ csrf_token() }}",
                "start_date" : start_date,
                "end_date"   : end_date,
            },
            success: function(data) {
                var gatewaydata = data['gatewaywise'];
                $("#gateway-wise-table").DataTable().clear().destroy();
                $('#gateway-wise-table').DataTable({
                    data: gatewaydata,
                    "bLengthChange": false,
                    "bPaginate": false,
                    "scrollX" : true,
                    "order": [[ 11, "desc" ]],
                    "language": { search: '', searchPlaceholder: "Search..." },
                aoColumns: [
                    { data: "alias_server_name",
                         render: function(data, type, row, meta) {
                            return ((row.alias_server_name)  ? row.alias_server_name :  "NA")
                          }
                    },
                    { data: "sms_pushed",
                         render: function(data, type, row, meta) {
                            return ((row.sms_pushed)  ? row.sms_pushed :  "0")
                          }
                    },
                    { data: "volume_count",
                         render: function(data, type, row, meta) {
                            return ((row.volume_count)  ? row.volume_count :  "0")
                          }
                    },
                    { data: "clicks",
                         render: function(data, type, row, meta) {
                            return ((row.clicks)  ? row.clicks :  "0")
                          }
                    },
                    { data: "unique_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.unique_clicks)  ? row.unique_clicks :  "0")
                          }
                    },
                    { data: "actions",
                         render: function(data, type, row, meta) {
                            return ((row.actions)  ? row.actions :  "0")
                          }
                    },
                    { data: "spends",
                         render: function(data, type, row, meta) {
                            return ((row.spends)  ? row.spends :  "0")
                          }
                    },
					{ data: "bot_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.bot_clicks)  ? row.bot_clicks :  "0")
                          }
                    },
					{ data: "total_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.total_clicks)  ? row.total_clicks :  "0")
                          }
                    },
					{ data: "actual_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.actual_CTR)  ? row.actual_CTR :  "0")
                          }
                    },
					{ data: "bot_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.bot_CTR)  ? row.bot_CTR :  "0")
                          }
                    },
					{ data: "total_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.total_CTR)  ? row.total_CTR :  "0")
                          }
                    }
                ]
                });// gatewaywise wise report end
            }
        });
    }
    // gatewaywise report jquery end


// Campaign-type report jquery start
	$("#start_date_camp_type").datepicker({
        dateFormat: 'yy-mm-dd',
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        endDate: 'today',
        onSelect: function (selectedDate) {
            var startDate = $('#start_date_camp_type').datepicker('getDate');
            $('#start_date_camp_type').datepicker('option', 'minDate', startDate);
            $('#end_date_camp_type').datepicker('setDate', startDate);
            getCampaignTypeReport();
            $('#filter_camp_type').val('');
        }
    });


	  /**select  to date here***/
	  $("#end_date_camp_type").datepicker({
        dateFormat: 'yy-mm-dd',
        minDate: $("#start_date_camp_type").datepicker("getDate"),
        maxDate : 0,
        autoclose: true,
        todayHighlight: true,
        onClose: function() {
            var startDate = $('#start_date_camp_type').datepicker('getDate');
            var endDate = $('#end_date_camp_type').datepicker('getDate');
            if(startDate==null){
                $('#start_date_camp_type').datepicker('setDate', endDate);
            }
            if (endDate < startDate) {
                var minDate = $('#end_date_camp_type').datepicker('option', 'minDate', startDate);
                $('#end_date_camp_type').datepicker('setDate', minDate);
            }
            getCampaignTypeReport();
        },
        onSelect: function() {
            $('#filter_camp_type').val('');
        }
    });

	$("body").on("change", "#filter_camp_type", function(){
            var periodValue = $(this).val();
            $("#start_date_camp_type").val('');
            $("#end_date_camp_type").val('');
            if(periodValue==''){
                getCampaignTypeReport();
            }
            //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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }

            //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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }

            //filter by this month
            else if(periodValue=='3'){
                var start_date = new Date();
                var end_date = new 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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }

            //filter by last month
            else if(periodValue=='4'){
                var start_date = new Date();
                var end_date = new Date();
                start_date = new Date(start_date.setMonth(start_date.getMonth() - 1));
                start_date = new Date(start_date.setDate(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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }

            //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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }

            //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);
                $('#start_date_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }
            //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_camp_type').val(start_date);
                $('#end_date_camp_type').datepicker('option', 'minDate', start_date);
                $('#end_date_camp_type').datepicker('setDate', end_date);
                getCampaignTypeReport();
            }
        });

    // export campaign type report
    $(".export-camptype-excel").click(function(){
        let start_date = $('#start_date_camp_type').val();
        let end_date = $('#end_date_camp_type').val();
        $('#from_date_camptype_hidden').val(start_date);
        $('#to_date_camptype_hidden').val(end_date);
        $(this).submit();
    });

	function getCampaignTypeReport(){
        var start_date = $('#start_date_camp_type').val();
        var end_date = $('#end_date_camp_type').val();
        $.ajax({
            type: "POST",
            url: 'campaigntype_analytics',
            data: {
                "_token"     : "{{ csrf_token() }}",
                "start_date" : start_date,
                "end_date"   : end_date,
            },
            success: function(data) {
                var campaigntypedata = data
                $("#campaign-type-wise-table").DataTable().clear().destroy();
                $('#campaign-type-wise-table').DataTable({
                    data: campaigntypedata,
                    "bLengthChange": false,
                    "bPaginate": false,
                    "scrollX" : true,
                    "order": [[ 11, "desc" ]],
                    "language": { search: '', searchPlaceholder: "Search..." },
                aoColumns: [
                    { data: "campaign_type",
                         render: function(data, type, row, meta) {
                            return ((row.campaign_type)  ? row.campaign_type :  "NA")
                          }
                    },
                    { data: "sms_pushed",
                         render: function(data, type, row, meta) {
                            return ((row.sms_pushed)  ? row.sms_pushed :  "0")
                          }
                    },
                    { data: "volume_count",
                         render: function(data, type, row, meta) {
                            return ((row.volume_count)  ? row.volume_count :  "0")
                          }
                    },
                    { data: "clicks",
                         render: function(data, type, row, meta) {
                            return ((row.clicks)  ? row.clicks :  "0")
                          }
                    },
                    { data: "unique_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.unique_clicks)  ? row.unique_clicks :  "0")
                          }
                    },
                    { data: "actions",
                         render: function(data, type, row, meta) {
                            return ((row.actions)  ? row.actions :  "0")
                          }
                    },
                    { data: "spends",
                         render: function(data, type, row, meta) {
                            return ((row.spends)  ? row.spends :  "0")
                          }
                    },
					{ data: "bot_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.bot_clicks)  ? row.bot_clicks :  "0")
                          }
                    },
					{ data: "total_clicks",
                         render: function(data, type, row, meta) {
                            return ((row.total_clicks)  ? row.total_clicks :  "0")
                          }
                    },
					{ data: "actual_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.actual_CTR)  ? row.actual_CTR :  "0")
                          }
                    },
					{ data: "bot_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.bot_CTR)  ? row.bot_CTR :  "0")
                          }
                    },
					{ data: "total_CTR",
                         render: function(data, type, row, meta) {
                            return ((row.total_CTR)  ? row.total_CTR :  "0")
                          }
                    }
                ]
                });// campaign type report end
            }
        });
    }
    // campaign type report jquery end
</script>
@endsection