<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">Article 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" />

<cfif parameterexists(url.delete)>
  <cfquery name="updas" datasource="#ds#">
    delete from holidaycontest
    where id = #url.delete#
  </cfquery>
</cfif>  
  	
<cfif parameterexists(url.status)>
  <cfquery name="updas" datasource="#ds#">
    update holidaycontest
    set approved = #url.status#
    where id = #url.id#
  </cfquery>
  
  <Cfif #url.status# eq 1>
  <Cfquery name="getapp" datasource="#ds#">
    select * from holidaycontest
        where id = #url.id#

</Cfquery>
  
  <CFMAIL TO="#getapp.EMail#"
        SUBJECT="Your pumpkin contest submission is approved!"
        FROM="NYMP <[email protected]>"
          SERVER="us-smtp-outbound-1.mimecast.com"
timeout="5"
type="html"
>
  Hello!
  <p></p>

Your submission to the Pumpkin Carving & Design Contest sponsored by Palisades Center has been approved! It looks great! 

  <p></p>

Now you should share your entry with your family and friends and ask them to vote for your pumpkin. The Fan Favorite (the pumpkin with the most votes) will automatically win a fun Family Day at the Palisades Center, with a $50 gift card to Dick's Sporting Goods, a $20 gift card to Wendy's, and 2 complimentary passes to Palisades Climb Adventure!

  <p></p>

Share this link via text, email, Facebook, Instagram, What'sApp, Marco Polo...you get the idea :-)

  <p></p>

<a href="https://www.nymetroparents.com/pumpkin/#getapp.seo_friendly#">https://www.nymetroparents.com/pumpkin/#getapp.seo_friendly#</a>
<p></p>
Good luck!  

  <p></p>

-NYMetroParents Editorial Team and the Palisades Center



  </cfmail>
  </Cfif>
  
</cfif>  

<Cfquery name="getvoters" datasource="#ds#">
    select * from holidaycontest order by id desc
</Cfquery>

                <table id="example23" class="display nowrap" cellspacing="0" width="100%">
                    <thead>
                        <tr>                                                        <th>Approved</th>

                            <th>Name</th>
                            <th>Email</th>
                                                        <th>Instagram</th>
                                                        <th>Facebook</th>
                                                        <th>Zip</th>
                                                        <th>Photo</th>
                                                        <th>Caption</th>
                                                        <th>Link</th>
                                                        <th>Votes</th>
                                                        <th>Newsletter</th>
                                                        <th>Delete</th>

                        </tr>
                    </thead>
                   
                    <tbody>


<Cfoutput query="getvoters">          

	              <tr>
	                 <td>
                                                          <cfif approved eq 0>
                                                       <a href="holiday.cfm?id=#id#&status=1">   No</a>  
                                                            <cfelse>
                                                       <a href="holiday.cfm?id=#id#&status=0">     Yes</a>  
                                                            
                                                          </cfif>
                                                          </td>
         
                     <td>#Name#</td>
                            <td>#Email#</td>
                                                        <td>#Instagram#</td>
                                                        <td>#Facebook#</td>
                                                        <td>#Zip#</td>
                                                        <td><a href="https://www.nymetroparents.com/eventpic/#photo#"><img src="https://www.nymetroparents.com/eventpic/150#photo#"></a></td>
                                                        <td>#Caption#</td>
                                                        <td><a href="https://www.nymetroparents.com/pumpkin/#seo_friendly#">#seo_friendly#</a></td>
                                                        <td>#Votes#</td>
                                                                                                        <td>#newsletter#</td>
       
                        
                                                  <td>                            <a href="holiday.cfm?delete=#id#&status=0" onclick="return confirm('Are you sure?');">     delete</a>  </td> 

                        </tr>

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






      <!-- /.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>