<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">CG WIT  - Sponsors Edit</h4>
        </div>
      
        <!-- /.col-lg-12 -->
      </div>
      <!-- /row -->
      <div class="row">
                <div class="col-sm-12">
          <div class="white-box">


<Cfif parameterexists(url.process)>
  
  
  
  
  <cfquery name=addphoto datasource="cityguide">


update witsponsor 

set company = '#form.company#',
submitter = '#form.submitter#',
submitteremail = '#form.submitteremail#',
submittercell = '#form.submittercell#',
ticket1 = '#form.ticket1#',
ticket2= '#form.ticket2#',
ticket3= '#form.ticket3#',
ticket4= '#form.ticket4#',
ticket5= '#form.ticket5#', 
ticket6= '#form.ticket6#', 
ticket7= '#form.ticket7#', 
ticket8= '#form.ticket8#', 
ticket9= '#form.ticket9#', 
ticket10= '#form.ticket10#', 

companydesc= '#form.companydesc#',
honoree = '#form.honoree#',
honoreewriteup = '#form.honoreewriteup#',
submitterlast = '#form.submitterlast#'
where id = #url.id#
		</cfquery>





<cfset imagepath="/home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic">
	<cfset thumbpath="home/home2/domains/parentsknow.com/public_html/newsite2018/2020/eventpic">
	<cfset imagedir="http://www.cityguideny.com/columnpic">
	<cfset thumbdir="http://www.cityguideny.com/columnpic">


<Cfif parameterexists(form.logo) and #form.logo# is not ''>
<cffile action="upload"
	        nameconflict="makeunique"
filefield="logo"
accept="image/jpeg,image/pjpeg,image/png,application/pdf"
 destination="#imagepath#/#robpic#.jpg"
 mode="644">

<cfset #file.serverfile# = '#robpic#.jpg'>
	<cfset photo = "#File.ServerFile#">

<cfquery name="upds" datasource="#ds#">
    update witsponsor
    set logo = 'https://www.cityguideny.com/eventpic/#photo#'
    where id = #url.id#
</cfquery>

</cfif>




<Cfif parameterexists(form.sponsorad) and #form.sponsorad# is not ''>
<cffile action="upload"
	        nameconflict="makeunique"
filefield="sponsorad"
accept="image/jpeg,image/pjpeg,image/png,application/pdf"
 destination="#imagepath#/#robpic#.pdf"
 mode="644">

<cfset #file.serverfile# = '#robpic#.pdf'>
	<cfset photo = "#File.ServerFile#">

<cfquery name="upds" datasource="#ds#">
    update witsponsor
    set adupload = 'https://www.cityguideny.com/eventpic/#photo#'
    where id = #url.id#
</cfquery>

</cfif>


<Cfif parameterexists(form.honoreephoto) and #form.honoreephoto# is not ''>
<cffile action="upload"
	        nameconflict="makeunique"
filefield="honoreephoto"
accept="image/jpeg,image/pjpeg,image/png,application/pdf"
 destination="#imagepath#/#robpic#.jpg"
 mode="644">

<cfset #file.serverfile# = '#robpic#.jpg'>
	<cfset photo = "#File.ServerFile#">

<cfquery name="upds" datasource="#ds#">
    update celebrwitsponsorate40sponsor
    set honoreephoto = 'https://www.cityguideny.com/eventpic/#photo#'
    where id = #url.id#
</cfquery>

</cfif>
  
  <Cflocation url="cg-40th-sponsors.cfm" addtoken="no" >
  
<cfelse>  

<Cfquery name="getorder" datasource="#ds#">
select * from witsponsor
where id = #url.id#
</cfquery>

<cfform name="autoSumForm" action="cg-wit-sponsors-edit.cfm?process=on&id=#url.id#" method="post"  enctype="multipart/form-data">
    
 

<table>
       <tr><Td>

         <label>Company</label>
                    </td><td>
  	  <cfinput NAME="company" class="span5" required="Yes" message="You must provide your company"  value="#getorder.company#">

                                        </Td></tr>  
                 
                   <tr><Td>

         <label>Submitter First Name</label>
                    </td><td>
  	  <cfinput NAME="submitter" class="span5" required="Yes" message="You must provide your name"   value="#getorder.submitter#" >

                                        </Td></tr>       
                                        
                                                   
                   <tr><Td>

         <label>Submitter Last Name</label>
                    </td><td>
  	  <cfinput NAME="submitterlast" class="span5" required="Yes" message="You must provide your name"   value="#getorder.submitterlast#" >

                                        </Td></tr>       
                                        
                   
                   <tr><Td>

         <label>Submitter Email</label>
                    </td><td>
  	  <cfinput NAME="submitteremail" class="span5" required="Yes" message="You must provide your email"   value="#getorder.submitteremail#" >

                                        </Td></tr>                         
                                                        
    
                   <tr><Td>

         <label>Submitter Cell</label>
                    </td><td>
  	  <cfinput NAME="submittercell" class="span5" required="Yes" message="You must provide your name"   value="#getorder.submittercell#" >

                                        </Td></tr>                         
                                        
                 
                    
                   <tr><Td>

         <label>Ticket Holder Name #1</label>
                    </td><td>
  	  <cfinput NAME="ticket1" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket1#">

                                        </Td></tr>                
                                        
                                              <tr><Td>

         <label>Ticket Holder Name #2</label>
                    </td><td>
  	  <cfinput NAME="ticket2" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket2#">

                                        </Td></tr>                
                              
                              
                                    <tr><Td>

         <label>Ticket Holder Name #3</label>
                    </td><td>
  	  <cfinput NAME="ticket3" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket3#">

                                        </Td></tr>                           
              <tr><Td>

         <label>Ticket Holder Name #4</label>
                    </td><td>
  	  <cfinput NAME="ticket4" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket4#">

                                        </Td></tr>        
                                        
                                              <tr><Td>

         <label>Ticket Holder Name #5</label>
                    </td><td>
  	  <cfinput NAME="ticket5" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket5#">

                                        </Td></tr>                
                    
                    
                                                             <tr><Td>

         <label>Ticket Holder Name #6</label>
                    </td><td>
  	  <cfinput NAME="ticket6" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket6#">

                                        </Td></tr>                
                        
                        
                                                                     <tr><Td>

         <label>Ticket Holder Name #7</label>
                    </td><td>
  	  <cfinput NAME="ticket7" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket7#">

                                        </Td></tr>                
                                                                 <tr><Td>

         <label>Ticket Holder Name #8</label>
                    </td><td>
  	  <cfinput NAME="ticket8" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket8#">

                                        </Td></tr>                
                                        
                                                                                     <tr><Td>

         <label>Ticket Holder Name #9</label>
                    </td><td>
  	  <cfinput NAME="ticket9" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket9#">

                                        </Td></tr>                
                    
                                                                <tr><Td>

         <label>Ticket Holder Name #10</label>
                    </td><td>
  	  <cfinput NAME="ticket10" class="span5" required="Yes" message="You must provide names for all ticket holders"   value="#getorder.ticket10#">

                                        </Td></tr>                
                     
                        
    
          <tr><Td>

         <label>Company Logo (JPG/PNG)</label>
                    </td><td>
 <input type=file name=logo>    
                                        </Td></tr>     
                                        
                                             <tr><Td>

         <label>Company Description for the Journal (Max 100 Words)</label>
                    </td><td>
<Textarea name="companydesc" style="width:300px;height:100px;"><Cfoutput>#getorder.companydesc#</Cfoutput></Textarea>  
                                        </Td></tr>         
           </table>
        
        <hr>
           
                   <Cfquery name="Gettop" dataSource="#ds#">
            select copy from columntable where id = 157177
        </Cfquery>
        <Cfoutput>#gettop.copy#</Cfoutput>
        
        
        
                    <legend>Ad Upload</legend><br><Br>


<Table>
        <tr><Td>         <label>Sponsor Ad (PDF)</label></td><Td>
      <input type=file name=sponsorad>                    
                                        </Td></tr> 
                                        
        
           <tr><Td>

         <label>Honoree</label>
                    </td><td>
  	  <cfinput NAME="honoree" class="span5" required="Yes" message="You must provide an honoree's name"   value="#getorder.honoree#">

                                        </Td></tr>       
          
                          <tr><Td>

         <label>Honoree Write-up (Max 100 Words)</label>
                    </td><td>
<Textarea name="honoreewriteup" style="width:300px;height:100px;"><Cfoutput>#getorder.honoreewriteup#</Cfoutput></Textarea>  
                                        </Td></tr>         
                    
        <tr><Td>         <label>Honoree Photo (JPG)</label></td><Td>
      <input type=file name=honoreephoto>                    
                                        </Td></tr> 
         
         </table>                               
           <input type="submit" class="btn btn-primary btn-block btn-large span6" style="color:white;background-color:black;" value="Submit "><br><center>
</cfform>
            </div>
        </div>
        <div class="gap"></div>
        
  </cfif>       


            </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('#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>