<cfset requesttimeout=5000>     <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">NYMP Camp Bracket</h4>
          <a href="campbracket-voters.cfm">View Voters</a>
        </div>
        <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
         
        </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=addphoto datasource="#ds#">
    	    delete from campbracket where id = #url.id#
</cfquery>
    <cflocation url="campbracket.cfm" addtoken="no">

</cfif>
<cfif parameterexists(url.add)>
    
    
<cfset moveurl = reReplace(form.campname, "([^[:alnum:]|[:blank:]]) ", "", "all")>
<cfset moveurl = #reReplaceNoCase(moveurl, "[^a-z0-9]", "-", "all")#>
<Cfset moveurl = rereplace(moveurl," ","-","ALL")>
<cfset moveurl = rereplace(moveurl,"'","-","ALL")>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)# eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>
<cfset xxx = len(moveurl)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl,1)#	eq '-'>
<cfset moveurl = '#right(moveurl,xxx2)#'>
</cfif>

<cfparam name="form.region" default="">

    	<cfquery name=addphoto datasource="#ds#">
INSERT INTO campbracket(campname,roundnum,votes,region,seo_friendly,campemail,bracket)
VALUES	('#form.campname#',#form.roundnum#,#form.votes#,'#form.region#','#moveurl#','#form.campemail#',#form.bracket#)
</cfquery>

<cfif parameterexists(form.crop)> 
<Cfquery name="getid" dataSource="#ds#">
    select id from campbracket
    order by id desc 
    limit 0,1
</Cfquery>
<cfset topid = #getid.id#>
		<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/cblogos/">
  <cffile action="upload"
accept="image/jpeg,image/pjpeg,image/png"
	      nameconflict="makeunique"
			  filefield="crop"
			  destination="#imagepath#/a#topid#.jpg">

 <cffile
   action = "rename"
   source = "#imagepath#/a#topid#.jpg"
   destination = "#imagepath#/#topid#.jpg"
   mode = "644">
   
   <cfquery name="upds" dataSource="#ds#">
       update campbracket 
       set logo = '#topid#.jpg'
       where id = #getid.id#
   </cfquery>
   
</cfif>

</cfif>

     <!--- SECOND --->
<cfif parameterexists(url.id)>
    
    <cfif parameterexists(url.save)>
        
    <cfquery name="udps" dataSource="#ds#">
        update campbracket 
        set campname = '#form.campname#',
        roundnum = #form.roundnum#,
        bracket  = #form.bracket#,
        votes = #form.votes#,
        bracketorder = #form.bracketorder#,
        campemail = '#form.campemail#',
        seo_friendly = '#form.seo_friendly#',
        region = '#form.region#'
        where id = #url.id#
    </cfquery>     
    
    <cfif parameterexists(form.crop) and #form.crop# is not ''>
    
    		<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/cblogos/">
  <cffile action="upload"
accept="image/jpeg,image/pjpeg,image/png"
	      nameconflict="overwrite"
			  filefield="crop"
			  destination="#imagepath#/a#url.id#.jpg">

 <cffile
   action = "rename"
   source = "#imagepath#/a#url.id#.jpg"
   destination = "#imagepath#/c#url.id#.jpg"
   mode = "644">
   
   <cfquery name="upds" dataSource="#ds#">
       update campbracket 
       set logo = 'c#url.id#.jpg'
       where id = #url.id#
   </cfquery>
   </cfif>
   
    <cflocation url="campbracket.cfm" addtoken="no">
    </cfif>
    
    
    <cfFORM name="validate" ACTION="campbracket.cfm?save=on&id=#url.id#" METHOD="post"  enctype="multipart/form-data">
        <cfoutput>
<a href="campbracket.cfm?delete=on&id=#url.id#" onclick="return confirm('Are you sure?');">Delete Entry</a></cfoutput>
<cfquery name="getcamp" datasource="#ds#">
    select * from campbracket where id = #url.id#
</cfquery>
<table border="0" cellpadding="0" cellspacing="2" >
<Tr>
    
    <td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Camp: </strong></td><td style="padding:4px;"> <input name="campname"   value="<cfoutput>#getcamp.campname#</cfoutput>"><br /></td>
</tr>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>URL: </strong></td><td style="padding:4px;"> <input name="seo_friendly"   value="<cfoutput>#getcamp.seo_friendly#</cfoutput>"><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Email: </strong></td><td style="padding:4px;"> <input name="campEmail"   value="<cfoutput>#getcamp.campemail#</cfoutput>"><br /></td>
</tR>
<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Votes: </strong></td><td style="padding:4px;"> <input name="votes"   value="<cfoutput>#getcamp.votes#</cfoutput>"><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Order Num: </strong></td><td style="padding:4px;"> <input name="bracketorder"   value="<cfoutput>#getcamp.bracketorder#</cfoutput>"><br /></td>
</tR>


<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Roundnum: </strong></td><td style="padding:4px;"> <input name="Roundnum"   value="<cfoutput>#getcamp.Roundnum#</cfoutput>"><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Region: </strong></td><td style="padding:4px;"> 
<select name="region">
    <option value=""></option>

</select>

<tr>
    
    <td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>
<b>Logo</b>
</td><td style="padding:4px;"> 
    <input type=file name="crop">
</td>

</tr>


</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Bracket: </strong></td><td style="padding:4px;"> 
<select name="bracket">
        <option value="<cfoutput>#getcamp.bracket#">#getcamp.bracket#</cfoutput></option>

    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>

</select>

</tR>


</tr></table>

<br>
<div align="center"><input type="submit" Value="Save"></div>
</cfFORM>
</form>
    
<cfelse>    
             <div class="col-sm-12">
          <div class="white-box">
            <div class="table-responsive">
                <table id="example23" class="display nowrap" cellspacing="0" width="100%">
                    <thead>
                        <tr>
                            <th>Edit</th>
                            <th>Camp </th>
                            <th>Round</th>
                                                                                    <th>Bracket</th>

                            <th>Votes</th>
                                                        <th>Confirmed</th>

                            <th>Region</th>
                 

                        </tr>
                    </thead>
                    <tfoot>
                        <tr>
                                                                <th>Edit</th>
                     <th>Camp </th>
                            <th>Round</th>
                                                        <th>Bracket</th>

                            <th>Votes</th>
                                                                                    <th>Confirmed</th>

                            <th>Region</th>
</tr>
                    </tfoot>
                    <tbody>


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

 SELECT * from campbracket

</cfquery>

                     <Cfoutput query="geter">
	                        <tr>
	                                                        <td style="border-width: 1px;border-style: solid;padding:4px;"><a href="campbracket.cfm?id=#id#">edit</a></td>

                            <td style="border-width: 1px;border-style: solid;padding:4px;">#campname#</a></td>
                            <td style="border-width: 1px;border-style: solid;padding:4px;">#roundnum#</td>
                            <td style="border-width: 1px;border-style: solid;padding:4px;">#bracket#</td>

                            <td style="border-width: 1px;border-style: solid;padding:4px;">#votes#</td>
                            <td style="border-width: 1px;border-style: solid;padding:4px;"><cfquery name="Getc" datasource="#ds#">select count(id) as counter from campbracketvote where confirmed = 1 and campid = #id# and roundnum = #roundnum# </cfquery>#getc.counter#</td>
                            
                            <td style="border-width: 1px;border-style: solid;padding:4px;">#region#</td>

                        </tr>
                                         </Cfoutput>

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

     <!--- SECOND --->
<cfif not parameterexists(url.id)>
<h2>Add Camp</h2>
    
    <cfFORM name="validate" ACTION="campbracket.cfm?add=on" METHOD="post"  enctype="multipart/form-data">

<table border="0" cellpadding="0" cellspacing="2" >
<Tr>
    
    <td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Camp: </strong></td><td style="padding:4px;"> <input name="campname" ><br /></td>
</tr><tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Votes: </strong></td><td style="padding:4px;"> <input name="votes" value="0"><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Email: </strong></td><td style="padding:4px;"> <input name="campemail" ><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Round: </strong></td><td style="padding:4px;"> <input name="Roundnum" value="3" ><br /></td>
</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Region: </strong></td><td style="padding:4px;"> 
<select name="region">
    <option value=""></option>
  

</select>

</tR>

<tR>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>

<strong>Bracket: </strong></td><td style="padding:4px;"> 
<select name="bracket">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>

</select>

</tR>

<tr>
    
    <td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-1>
<b>Logo</b>
</td><td style="padding:4px;"> 
    <input type=file name="crop">
</td>

</tr>

</tr></table>

<br>
<div align="center"><input type="submit" Value="Save"></div>
</cfFORM>
</form>
 </cfif>

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