| Server IP : 172.67.201.108 / Your IP : 216.73.216.11 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/nympadmin/ |
Upload File : |
<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">Newsletter Registration Stats</h4>
</div>
<div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
<ol class="breadcrumb">
<li><a href="#">Dashboard</a></li>
<li><a href="#">Calendar</a></li> <li class="active">Today</li>
</ol>
</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 newdatetime = '2018-05-10'>
<cfset today = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfset tomorrow = #dateadd('d',1,today)#>
<cfset tomorrow = #dateformat(tomorrow,'yyyy-mm-dd')#>
<form action="data-tablearticlesnympreg.cfm" method="post" name="calme" enctype="multipart/form-data">
<Table><tr><td style="padding:4px;">
From:
<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 style="padding:4px;">
To:
<input name="daterend" class="form-control" id="datepicker-autoclose2" 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 style="padding-top: 14px;">
<button class="btn btn-success btn-mini">SEARCH <i class="icon-save"></i></button>
</Td></tr></table>
</form>
<!--- THIRD --->
<div class="col-sm-12">
<div class="white-box">
<table><Tr><Td valign="top">
<h3 class="box-title m-b-0">BY TYPE</h3>
<div class="table-responsive">
<table id="example234" class="display nowrap" cellspacing="0" >
<thead>
<tr>
<th>Type</th>
<th>Count</th>
</tr>
</thead>
<tbody>
<cfquery name="Geter" datasource="#ds#">
select count(distinct(email)) as counter, registeredon, website,zip,fname,lname,id
from starusers
where mag = 5 and
registeredon > '2018-05-10'
<cfif parameterexists(form.dater)>
and (registeredon BETWEEN '#dater#' AND '#daterend#')
</cfif>
and id not in(165096,
165099,
165097,
165100,
165098,
165102,
165101,
165104,
165103,
165105,
165109,
165106,
165110,
165118,
165117,
165121,
165120,
165119,
165123,
165122,
165127,
165126,
165125,
165130,
165128,
165134,
165133,
165132,
165131,
165135,
165136,
165137,
165139,
165141,
165140,
165138,
165144,
165143,
165142,
165149,
165147,
165146,
165148,
165153,
165152,
165151,
165150,
165156,
165157,
165158,
165160,
165159,
165164,
165163,
165162,
165161,
165167,
165166,
165165,
165168,
165170,
165169,
165174,
165171,
165176,
165175,
165178,
165177,
165181,
165182,
165180,
165179,
165185,
165184,
165186,
165183,
165187,
165189,
165192,
165191,
165190,
165196,
165195,
165194,
165193,
165200,
165197,
165198,
165201,
165203,
165205,
165204,
165202,
165209,
165208,
165207,
165206,
165212,
165211,
165210,
165215,
165214,
165213,
165216,
165220,
165219,
165218,
165217,
165255,
165221,
165223,
165222,
165224,
165227,
165226,
165225,
165230,
165229,
165228,
165235,
165234,
165233,
165232,
165231,
165240,
165239,
165238,
165237,
165236,
165245,
165242,
165241,
165248,
165247,
165246,
165250,
165251,
165249,
165253)
and website <> ''
group by website
order by counter desc
limit 0,1000
</cfquery>
<C
<Cfoutput query="geter">
<tr>
<td style="border-width: 1px;border-style: solid;padding:4px;">#website#</td>
<td style="border-width: 1px;border-style: solid;padding:4px;">#round(counter)#</td>
</tr>
</Cfoutput>
</tbody>
</table>
</div>
</div>
</td>
<Td valign="top" style="vertical-align: top;padding-left:20px;">
<font face="verdana" size="-1"><b>By Week</b> </font>
<Cfquery name="Geter" dataSource="#ds#">
SELECT
WEEK(registeredon) weeks,
count(email) as counter,registeredon
FROM starusers
WHERE registeredon > DATE_SUB(NOW(), INTERVAL 53 WEEK)
and mag = 5
and email like '%@%'
and id not in(165096,
165099,
165097,
165100,
165098,
165102,
165101,
165104,
165103,
165105,
165109,
165106,
165110,
165118,
165117,
165121,
165120,
165119,
165123,
165122,
165127,
165126,
165125,
165130,
165128,
165134,
165133,
165132,
165131,
165135,
165136,
165137,
165139,
165141,
165140,
165138,
165144,
165143,
165142,
165149,
165147,
165146,
165148,
165153,
165152,
165151,
165150,
165156,
165157,
165158,
165160,
165159,
165164,
165163,
165162,
165161,
165167,
165166,
165165,
165168,
165170,
165169,
165174,
165171,
165176,
165175,
165178,
165177,
165181,
165182,
165180,
165179,
165185,
165184,
165186,
165183,
165187,
165189,
165192,
165191,
165190,
165196,
165195,
165194,
165193,
165200,
165197,
165198,
165201,
165203,
165205,
165204,
165202,
165209,
165208,
165207,
165206,
165212,
165211,
165210,
165215,
165214,
165213,
165216,
165220,
165219,
165218,
165217,
165255,
165221,
165223,
165222,
165224,
165227,
165226,
165225,
165230,
165229,
165228,
165235,
165234,
165233,
165232,
165231,
165240,
165239,
165238,
165237,
165236,
165245,
165242,
165241,
165248,
165247,
165246,
165250,
165251,
165249,
165253)
GROUP BY WEEK(registeredon)
ORDER BY registeredon desc
</cfquery>
<table>
<Cfoutput query="geter">
<Tr><td style="padding:4px;border-width:1px;border-style:solid;">
Week of #dateformat(registeredon, 'm/d/yy')#</td><td style="padding:4px;border-width:1px;border-style:solid;"> #counter#</Td></Tr>
</Cfoutput>
</table>
</Td>
</td>
<td style="padding:4px;"> </Td>
<Td valign="top">
<font face="verdana" size="-1"><b>By Month</b> </font>
<table border="1" cellpadding="4" cellspacing="0">
<Cfloop from="1" to="12" index="i">
<tr><td style="padding:4px;">
<cfoutput>#i#/2017</cfoutput>
<Cfquery name="geter" dataSource="#ds#" cachedwithin="#createtimespan(1,0,3,30)#">
select count(distinct(email)) as counter
from starusers
where mag = 5
and month(registeredon) = #i#
and year(registeredon) = 2017
and email like '%@%'
</cfquery>
</td>
<cfoutput><td style="padding:4px;">#geter.counter#</td></cfoutput>
</tr>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<tr><td style="padding:4px;">
<cfoutput>#i#/2018</cfoutput>
<Cfquery name="geter" dataSource="#ds#">
select count(distinct(email)) as counter
from starusers
where mag = 5
and month(registeredon) = #i#
and year(registeredon) = 2018
and email like '%@%'
</cfquery>
</td>
<cfoutput><td style="padding:4px;">#geter.counter#</td></cfoutput>
</tr>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<tr><td style="padding:4px;">
<cfoutput>#i#/2019</cfoutput>
<Cfquery name="geter" dataSource="#ds#">
select count(distinct(email)) as counter
from starusers
where mag = 5
and month(registeredon) = #i#
and year(registeredon) = 2019
and email like '%@%'
</cfquery>
</td>
<cfoutput><td style="padding:4px;">#geter.counter#</td></cfoutput>
</tr>
</Cfloop>
<Cfloop from="1" to="12" index="i">
<tr><td style="padding:4px;">
<cfoutput>#i#/2020</cfoutput>
<Cfquery name="geter" dataSource="#ds#">
select count(distinct(email)) as counter
from starusers
where mag = 5
and month(registeredon) = #i#
and year(registeredon) = 2020
and email like '%@%'
</cfquery>
</td>
<cfoutput><td style="padding:4px;">#geter.counter#</td></cfoutput>
</tr>
</Cfloop>
</table>
</Td>
<td style="padding:4px;"> </Td>
<Td valign="top">
<font face="verdana" size="-1">
<b>By Day</b> </font>
<cfquery name="Gets" datasource="#ds#">
select id,email, registeredon, website,zip,fname,lname,id
from starusers
where mag = 5
and id > 164635
<cfif parameterexists(form.dater)>
and (registeredon BETWEEN '#dater#' AND '#daterend#')
</cfif>
group by email
order by id desc
limit 0,1000
</cfquery>
<Table border="1" cellpadding="4" cellspacing="0">
<Cfoutput query="Gets">
<cfif isValid("email", #email#) >
<Tr>
<td style="padding:4px;">#id#</td>
<td style="padding:4px;">#email#</td>
<td style="padding:4px;"><Cfif #registeredon# is not ''>#dateformat(registeredon,'mm/dd/yy')# @ #timeformat(registeredon,'hh:mm TT')#<cfelse>2012-01-21</Cfif></td>
<td style="padding:4px;"><Cfif #website# is not 'm'>#website#</Cfif></td>
<!---
<td style="padding:4px;"><Cfquery name="chece" datasource="#ds#">select * from nympsimpleemail where email ='#email#'</Cfquery> <Cfif #chece.recordcount# eq 0>REG<cfelse>BOX</Cfif>
</td>
--->
<td style="padding:4px;">#zip#</td>
<td style="padding:4px;">
<Cfif #zip# is not ''>
<cfquery name="checkregion" dataSource="#ds#">
select county from
Zip_code_table
where zip = #zip#
</cfquery>
<Cfif #checkregion.county# eq 'Bergen' or #checkregion.county# eq 'Essex'><cfset regme = 'New Jersey'>New Jersey
<cfelseif checkregion.county eq 'Richmond'><cfset regme = 'Staten Island'>Staten Island
<cfelseif checkregion.county eq 'Orange'><cfset regme = 'Rockland'>Rockland
<Cfelse><cfset regme = '#checkregion.county#'>
#checkregion.county#</Cfif>
</Td> </Cfif>
</tr></Cfif>
</cfoutput>
</table>
</Td>
</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>
$(document).ready(function(){
$('#myTable').DataTable();
$(document).ready(function() {
var table = $('#example').DataTable({
"columnDefs": [
{ "visible": false, "targets": 2 }
],
"order": [[ 2, 'asc' ]],
"displayLength": 25,
"drawCallback": function ( settings ) {
var api = this.api();
var rows = api.rows( {page:'current'} ).nodes();
var last=null;
api.column(2, {page:'current'} ).data().each( function ( group, i ) {
if ( last !== group ) {
$(rows).eq( i ).before(
'<tr class="group"><td colspan="5">'+group+'</td></tr>'
);
last = group;
}
} );
}
} );
// Order by the grouping
$('#example tbody').on( 'click', 'tr.group', function () {
var currentOrder = table.order()[0];
if ( currentOrder[0] === 2 && currentOrder[1] === 'asc' ) {
table.order( [ 2, 'desc' ] ).draw();
}
else {
table.order( [ 2, 'asc' ] ).draw();
}
});
});
});
$('#example23').DataTable( {
dom: 'Bfrtip',
buttons: [
'copy', 'csv', 'excel', 'pdf', 'print'
]
});
</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('#datepicker-autoclose2').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>