<Cfsetting requestTimeout = 500>

<Cfparam name="dater" default="#datetimeformat(currentdatetime,'yyyy-mm-dd')#">
         <cfinclude template="header.cfm">
     <link href="../plugins/bower_components/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />

<link href="https://cdn.datatables.net/buttons/1.2.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />

  <div id="page-wrapper">
    <div class="container-fluid">
      <div class="row bg-title">
        <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
          <h4 class="page-title">Calendar Stats</h4>
          <cfif parameterexists(url.1) or parameterexists(form.dater)>
              &nbsp;<a href="data-table.cfm">Reset Search</a>
              </cfif>
        </div>
    
        <!-- /.col-lg-12 -->
      </div>
      <!-- /row -->
      <div class="row">
                <div class="col-sm-12">
          <div class="white-box">


<!---            <p class="text-muted m-b-30">Export data to Copy, CSV, Excel, PDF & Print</p>
    --->         <div class="table-responsive">

	            <link href="../plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.css" rel="stylesheet" type="text/css" />



<Cfset newdatetime = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfset newdatetime = #dateadd('d',-7,today)#>

<Cfset newdatetime = #dateformat(newdatetime,'yyyy-mm-dd')#>

<cfset today = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfset tomorrow = #dateadd('d',1,today)#>
<cfset tomorrow = #dateformat(tomorrow,'yyyy-mm-dd')#>


<form action="data-table2.cfm?1=1<cfif parameterexists(url.neighborhood)><cfoutput>&neighborhood=#url.neighborhood#</cfoutput></cfif><cfif parameterexists(url.catid)><cfoutput>?catid=#url.catid#</cfoutput></cfif>" method="post" name="calme"  enctype="multipart/form-data">

<Table><tr><td>
Viewed From:
<cfif parameterexists(url.dater)>
    <cfset form.dater = '#url.dater#'>
    </cfif>
<cfif parameterexists(url.daterend)>
    <cfset form.daterend = '#url.daterend#'>
    </cfif>
<input class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" name="dater" label="Block out starts" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.daterend)>value="<cfoutput>#dateformat(dater,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>#dateformat(newdatetime,'yyyy-mm-dd')#</cfoutput>"</Cfif>>
</Td><td>
To:
<input name="daterend" class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.daterend)>value="<cfoutput>#dateformat(daterend,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>#dateformat(tomorrow,'yyyy-mm-dd')#</cfoutput>"</Cfif>>
 </td>
 
 
 
 <td>
Entered From:

<cfif parameterexists(url.dateadded)>
    <cfset form.dateadded = '#url.dateadded#'>
    </cfif>
    <cfif parameterexists(url.dateaddedend)>
    <cfset form.dateaddedend = '#url.dateaddedend#'>
    </cfif>
<input class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" name="dateadded" label="Block out starts" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.dateadded)>value="<cfoutput>#dateformat(dateadded,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>2020-01-01</cfoutput>"</Cfif>>
</Td><td>
To:
<input name="dateaddedend" class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.dateaddedend)>value="<cfoutput>#dateformat(dateaddedend,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>#dateformat(tomorrow,'yyyy-mm-dd')#</cfoutput>"</Cfif>>
 </td>
 
 
 <Td style="padding-top: 14px;">
<button class="btn btn-success btn-mini">SEARCH <i class="icon-save"></i></button>
 </Td>
 
 
 </tr></table>
</form>

             


     <!--- SECOND --->


             <div class="col-sm-12">
          <div class="white-box">
            <h3 class="box-title m-b-0">CATEGORIES</h3>
            <div class="table-responsive">
                <table id="example234" class="display nowrap" cellspacing="0" width="100%">
                    <thead>
                        <tr>
                            <th>Master Category</th>
                            <th>Sub Category</th>
                                                     <th>Count</th>
   <th>Views</th>
                            <th>Clicks</th>
     <th>Buy</th>
     <th>Intend to Go</th>

                        </tr>
                    </thead>
                    <tfoot>
                        <tr>
                               <th>Master Category</th>
                            <th>Sub Category</th>
                                                        <th>Count</th>

                            <th>Views</th>       
                                 <th>Clicks</th>
     <th>Buy</th>
     <th>Intend to Go</th>
                            </tr>
                    </tfoot>
                    <tbody>


          <Cfquery name="Geter" dataSource="#ds#">

select CatActivityPlanner.Cat, ActivityPlanner.catid,CatActivityPlanner.mastercat, count(newmastertrackeventscg.id) as views
from newmastertrackeventscg inner join ActivityPlanner on newmastertrackeventscg.idnumber = ActivityPlanner.id inner join CatActivityPlanner on ActivityPlanner.catid = CatActivityPlanner.catid

<cfif parameterexists(url.neighborhood)>
	inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip
</cfif>



where 1 = 1


<cfif parameterexists(url.catid)>
	and ActivityPlanner.catid = #url.catid#
</cfif>




<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>


<cfif parameterexists(form.dater)>
and (newmastertrackeventscg.datetime >= '#dater# 00:00:00' AND newmastertrackeventscg.datetime <= '#daterend# 23:59:59')
and datestart  >= '#dater# 00:00:00' 

<cfelse>
and newmastertrackeventscg.datetime > '#newdatetime#'
</cfif>
<cfif parameterexists(url.neighborhood)>
	and Neighborhood.Neighborhood = '#url.neighborhood#'
</cfif>

and cat <> ''
group by CatActivityPlanner.Cat
order by views desc

</cfquery>

                     <Cfoutput query="geter">
                         
                         
	                        <tr>
                            <td style="border-width: 1px;border-style: solid;padding:4px;">#mastercat#</td>
                            <td style="border-width: 1px;border-style: solid;padding:4px;"><a href="data-table.cfm?catid=#catid#<cfif parameterexists(form.dater)>&dater=#form.dater#</cfif><cfif parameterexists(form.daterend)>&daterend=#form.daterend#</cfif><cfif parameterexists(form.dateadded)>&dateadded=#form.dateadded#</cfif><cfif parameterexists(form.dateaddedend)>&dateaddedend=#form.dateaddedend#</cfif>">#cat#</a></td>                     
                            
                            
<Cfquery name="getclcc" dataSource="#ds#">
	                                select count(distinct(ActivityPlanner.id)) as counter
		                           from newmastertrackeventscg inner join ActivityPlanner on newmastertrackeventscg.idnumber = ActivityPlanner.id 
		                           where 1 = 1
		                           and ActivityPlanner.catid = #catid#
		       
and datestart > '#dater# 00:00:00'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>


<cfif parameterexists(form.dater)>
and (newmastertrackeventscg.datetime >= '#dater# 00:00:00' AND newmastertrackeventscg.datetime <= '#daterend# 23:59:59')
and datestart  >= '#dater# 00:00:00' 

<cfelse>
and newmastertrackeventscg.datetime > '#newdatetime#'
</cfif>
<!---
group by ActivityPlanner.id--->
</cfquery>


                            <td style="border-width: 1px;border-style: solid;padding:4px;">
                                
                            
                                #getclcc.counter#</td>

                            <td style="border-width: 1px;border-style: solid;padding:4px;">#views#</td>
                            
                            
                         <td style="border-width: 1px;border-style: solid;padding:4px;">
	                            <Cfquery name="getclc" dataSource="#ds#">select sum(CalendarLinkStats.views) as clicks
		                            from CalendarLinkStats inner join ActivityPlanner on ActivityPlanner.id = CalendarLinkStats.showid where ActivityPlanner.catid = #catid#
		       
and datestart > '#dater# 00:00:00'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>                   
		                           
<cfif parameterexists(form.dater)>
and (showdate >= '#dater# 00:00:00' AND showdate <= '#daterend# 23:59:59')
and showdate  >= '#dater# 00:00:00' 

<cfelse>
and showdate > '#newdatetime#'
</cfif>

</cfquery>


#getclc.clicks#

</td>
     <td style="border-width: 1px;border-style: solid;padding:4px;">

                         <Cfquery name="getclcb" dataSource="#ds#">
                         	select sum(CalendarLinkStatsBuy.views) as clicks
		                            from CalendarLinkStatsBuy inner join ActivityPlanner on ActivityPlanner.id = CalendarLinkStatsBuy.showid where ActivityPlanner.catid = #catid#
		                          
		                           and datestart > '#dater# 00:00:00'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>


<cfif parameterexists(form.dater)>
and (showdate >= '#dater# 00:00:00' AND showdate <= '#daterend# 23:59:59')
and showdate  >= '#dater# 00:00:00' 

<cfelse>
and showdate > '#newdatetime#'
</cfif>
                         	
                        
</cfquery>
#getclcb.clicks#

</td>

     <td style="border-width: 1px;border-style: solid;padding:4px;">
    <Cfquery name="Getratecount1" datasource="#ds#">
select count(ActivityPlannerRatings.id) as counter 
from ActivityPlannerRatings
inner join ActivityPlanner on ActivityPlanner.id = ActivityPlannerRatings.calendarid 

where  ActivityPlanner.catid = #catid#
and datestart > '#dater# 00:00:00'

<cfif parameterexists(form.dater)>
and (datetime >= '#dater# 00:00:00' AND datetime <= '#daterend# 23:59:59')
and datetime  >= '#dater# 00:00:00' 

<cfelse>
and datetime > '#newdatetime#'
</cfif>

and rating = 1
</Cfquery>


#getratecount1.counter#
</td>

                            
                            
                        </tr>
                                         </Cfoutput>

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


     <!--- SECOND --->



     <!--- THIRD --->


             <div class="col-sm-12">
          <div class="white-box">
            <h3 class="box-title m-b-0">NEIGHBORHOOD</h3>
            <div class="table-responsive">
                <table id="example235" class="display nowrap" cellspacing="0" width="100%">
                    <thead>
                        <tr>
                            <th>Neighborhood</th>                                                                                    <th>Count</th>

                            <th>Views</th>

                              <th>Clicks</th>
     <th>Buy</th>
     <th>Intend to Go</th>
                        </tr>
                    </thead>
                    <tfoot>
                        <tr>
                            <th>Neighborhood</th>
                                                                                    <th>Count</th>

                            <th>Views</th>        
                              <th>Clicks</th>
     <th>Buy</th>
     <th>Intend to Go</th>
     </tr>
                    </tfoot>
                    <tbody>


          <Cfquery name="Geter" dataSource="#ds#">

select Neighborhood.Neighborhood, count(newmastertrackeventscg.id) as views
from newmastertrackeventscg inner join ActivityPlanner on newmastertrackeventscg.idnumber = ActivityPlanner.id
inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip
where 1 = 1





<cfif parameterexists(form.dater)>
and (newmastertrackeventscg.datetime >= '#dater# 00:00:00' AND newmastertrackeventscg.datetime <= '#daterend# 23:59:59')

and datestart >= '#dater# 00:00:00' 
<cfelse>
and newmastertrackeventscg.datetime > '#newdatetime#'
</cfif>
group by Neighborhood
order by views desc

</cfquery>

                     <Cfoutput query="geter">
	                        <tr>
                            <td style="border-width: 1px;border-style: solid;padding:4px;"><a href="data-table.cfm?neighborhood=#neighborhood#<cfif parameterexists(form.dater)>&dater=#form.dater#</cfif><cfif parameterexists(form.daterend)>&daterend=#form.daterend#</cfif><cfif parameterexists(form.dateadded)>&dateadded=#form.dateadded#</cfif><cfif parameterexists(form.dateaddedend)>&dateaddedend=#form.dateaddedend#</cfif>">#Neighborhood#</a></td>
                            
                            
                            
                            
	                            <Cfquery name="getclcc" dataSource="#ds#">
	                                select count(distinct(ActivityPlanner.id)) as counter
		                         from newmastertrackeventscg inner join ActivityPlanner on newmastertrackeventscg.idnumber = ActivityPlanner.id
inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip
		                           
		                           where 1 = 1
		       
and datestart > '#dater# 00:00:00'
and Neighborhood.neighborhood = '#Neighborhood#'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>


<cfif parameterexists(form.dater)>
and (newmastertrackeventscg.datetime >= '#dater# 00:00:00' AND newmastertrackeventscg.datetime <= '#daterend# 23:59:59')
and datestart  >= '#dater# 00:00:00' 

<cfelse>
and newmastertrackeventscg.datetime > '#newdatetime#'
</cfif>

</cfquery>
                            <td style="border-width: 1px;border-style: solid;padding:4px;">
                                
                                #getclcc.counter#</td>
                            
                            <td style="border-width: 1px;border-style: solid;padding:4px;">#views#</td>
                            
                            
                            
                            
                            
                            
                               <td style="border-width: 1px;border-style: solid;padding:4px;">
	                            <Cfquery name="getclc" dataSource="#ds#">select sum(CalendarLinkStats.views) as clicks
		                            from CalendarLinkStats inner join ActivityPlanner on ActivityPlanner.id = CalendarLinkStats.showid 
		                            
		                            inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip

		                            where  datestart > '#dater# 00:00:00'
and Neighborhood.neighborhood = '#Neighborhood#'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>                   
		                           
<cfif parameterexists(form.dater)>
and (showdate >= '#dater# 00:00:00' AND showdate <= '#daterend# 23:59:59')
and showdate  >= '#dater# 00:00:00' 

<cfelse>
and showdate > '#newdatetime#'
</cfif>

</cfquery>

<cfif not isnumeric(getclc.clicks)>0<cfelse>#getclc.clicks#</cfif>


</td>
     <td style="border-width: 1px;border-style: solid;padding:4px;">

                         <Cfquery name="getclcb" dataSource="#ds#">
                         	select sum(CalendarLinkStatsBuy.views) as clicks
		                            from CalendarLinkStatsBuy inner join ActivityPlanner on ActivityPlanner.id = CalendarLinkStatsBuy.showid 
		                            inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip

		                            where  Neighborhood.neighborhood = '#Neighborhood#'


		                           and datestart > '#dater# 00:00:00'

<cfif parameterexists(form.dateadded)>
and (dtentered >= '#dateadded# 00:00:00' AND dtentered <= '#dateaddedend# 23:59:59')


</cfif>


<cfif parameterexists(form.dater)>
and (showdate >= '#dater# 00:00:00' AND showdate <= '#daterend# 23:59:59')
and showdate  >= '#dater# 00:00:00' 

<cfelse>
and showdate > '#newdatetime#'
</cfif>
                         	
                        
</cfquery>
<cfif not isnumeric(getclcb.clicks)>0<cfelse>#getclcb.clicks#</cfif>

</td>

     <td style="border-width: 1px;border-style: solid;padding:4px;">
    <Cfquery name="Getratecount1" datasource="#ds#">
select count(ActivityPlannerRatings.id) as counter 
from ActivityPlannerRatings
inner join ActivityPlanner on ActivityPlanner.id = ActivityPlannerRatings.calendarid 
inner join Neighborhood on ActivityPlanner.zip = Neighborhood.zip

where  datestart > '#dater# 00:00:00'
and Neighborhood.neighborhood = '#Neighborhood#'

<cfif parameterexists(form.dater)>
and (datetime >= '#dater# 00:00:00' AND datetime <= '#daterend# 23:59:59')
and datetime  >= '#dater# 00:00:00' 

<cfelse>
and datetime > '#newdatetime#'
</cfif>

and rating = 1
</Cfquery>


#getratecount1.counter#
</td>

                            
                            
                        </tr>
                                         </Cfoutput>

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


     <!--- THIRD --->


      <!-- /.row -->

     <cfinclude template="footer.cfm">

<script src="../plugins/bower_components/datatables/jquery.dataTables.min.js"></script>

<!-- start - This is for export functionality only -->
<script src="https://cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>
<!-- end - This is for export functionality only -->
<!-- end - This is for export functionality only -->

<script>
$('#example234').DataTable({
    dom: 'Bfrtip',
    buttons: [
        'copy', 'csv', 'excel', 'pdf', 'print'
    ],
    paging: false, // Disable pagination
    "footerCallback": function(row, data, start, end, display) {
        var api = this.api();

        // Loop through each column you want to sum. Here, the column indexes are examples
        [2, 3, 4, 5, 6].forEach(function(colIndex) {
            var total = api
                .column(colIndex)
                .data()
                .reduce(function(a, b) {
                    return parseInt(a) + parseInt(b);
                }, 0);
            
            // Update footer
            $(api.column(colIndex).footer()).html(total);
        });
    }
});

$('#example235').DataTable({
    dom: 'Bfrtip',
    buttons: [
        'copy', 'csv', 'excel', 'pdf', 'print'
    ],
    paging: false, // Disable pagination
    "footerCallback": function(row, data, start, end, display) {
        var api = this.api();

        // Similar loop for this table. Adjust column indexes as necessary.
        [1, 2, 3, 4, 5].forEach(function(colIndex) {
            var total = api
                .column(colIndex)
                .data()
                .reduce(function(a, b) {
                    return parseInt(a) + parseInt(b);
                }, 0);
            
            // Update footer
            $(api.column(colIndex).footer()).html(total);
        });
    }
});
</script>

<!-- jQuery -->
<script src="../plugins/bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Menu Plugin JavaScript -->
<script src="../plugins/bower_components/sidebar-nav/dist/sidebar-nav.min.js"></script>

<!--slimscroll JavaScript -->
<script src="js/jquery.slimscroll.js"></script>
<!--Wave Effects -->
<script src="js/waves.js"></script>
<!-- Custom Theme JavaScript -->
<script src="js/custom.min.js"></script>
<!-- Plugin JavaScript -->
<script src="../plugins/bower_components/moment/moment.js"></script>
<!-- Clock Plugin JavaScript -->
<script src="../plugins/bower_components/clockpicker/dist/jquery-clockpicker.min.js"></script>
<!-- Color Picker Plugin JavaScript -->
<script src="../plugins/bower_components/jquery-asColorPicker-master/libs/jquery-asColor.js"></script>
<script src="../plugins/bower_components/jquery-asColorPicker-master/libs/jquery-asGradient.js"></script>
<script src="../plugins/bower_components/jquery-asColorPicker-master/dist/jquery-asColorPicker.min.js"></script>
<!-- Date Picker Plugin JavaScript -->
<script src="../plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
<!-- Date range Plugin JavaScript -->
<script src="../plugins/bower_components/timepicker/bootstrap-timepicker.min.js"></script>
<script src="../plugins/bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<script>
// Clock pickers
$('#single-input').clockpicker({
  placement: 'bottom',
  align: 'left',
  autoclose: true,
  'default': 'now'

});

$('.clockpicker').clockpicker({
    donetext: 'Done',

})
  .find('input').change(function(){
    console.log(this.value);
});

$('#check-minutes').click(function(e){
  // Have to stop propagation here
  e.stopPropagation();
  input.clockpicker('show')
      .clockpicker('toggleView', 'minutes');
});
if (/mobile/i.test(navigator.userAgent)) {
  $('input').prop('readOnly', true);
}
// Colorpicker

$(".colorpicker").asColorPicker();
$(".complex-colorpicker").asColorPicker({
    mode: 'complex'
});
$(".gradient-colorpicker").asColorPicker({
    mode: 'gradient'
});
// Date Picker
    jQuery('.mydatepicker, #datepicker').datepicker();
    jQuery('#datepicker-autoclose').datepicker({
        autoclose: true,
        todayHighlight: true
      });

    jQuery('#date-range').datepicker({
        toggleActive: true
      });
    jQuery('#datepicker-inline').datepicker({

        todayHighlight: true
      });

// Daterange picker

$('.input-daterange-datepicker').daterangepicker({
          buttonClasses: ['btn', 'btn-sm'],
                applyClass: 'btn-danger',
                cancelClass: 'btn-inverse'
        });
            $('.input-daterange-timepicker').daterangepicker({
                timePicker: true,
                format: 'MM/DD/YYYY h:mm A',
                timePickerIncrement: 30,
                timePicker12Hour: true,
                timePickerSeconds: false,
                buttonClasses: ['btn', 'btn-sm'],
                applyClass: 'btn-danger',
                cancelClass: 'btn-inverse'
            });
            $('.input-limit-datepicker').daterangepicker({
                format: 'MM/DD/YYYY',
                minDate: '06/01/2015',
                maxDate: '06/30/2015',
                buttonClasses: ['btn', 'btn-sm'],
                applyClass: 'btn-danger',
                cancelClass: 'btn-inverse',
                dateLimit: {
                    days: 6
                }
            });
</script>


<!--Style Switcher -->
<script src="../plugins/bower_components/styleswitcher/jQuery.style.switcher.js"></script>
</body>
</html>