<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header"   style="margin-left:250px;">

    <h2>&nbsp;Calendar Ads Admin</h2>
  </div>
  <div class="container-fluid" style="margin-left:220px;">

      <Br>
          
         
     
     <Cfif parameterexists(url.delete)>
         <cfquery name="is" dataSource="#ds#" result="result">

         delete from ActivityPlannerAds 
         where id = #url.delete#
        </cfquery> 
     </cfif>
<Cfif parameterexists(url.add)>
    <cfparam name="form.cats" default="">
<cfquery name="is" dataSource="#ds#" result="result">
INSERT INTO ActivityPlannerAds(cats,name,content,image,address,phone,urllink,startdate,enddate	)
VALUES
('#form.cats#','#form.name#','#form.content#','','#form.address#','#form.phone#','#form.urllink#','#form.startdate#','#form.enddate#')
</cfquery>


<cfif parameterexists(form.photo) and #form.photo# is not ''>
<cfset robpic = #createUUID()#>

<cfset ds='cityguide'>
	<cfset imagepath="/home/home2/cgny/public_html/2019/eventpic">
	<cfset thumbpath="/home/home2/cgny/public_html/2019/eventpic">
	<cfset imagedir="https://www.cityguideny.com/columnpic">
	<cfset thumbdir="https://www.cityguideny.com/columnpic">


<cffile action="upload"
	        nameconflict="makeunique"
filefield="photo"
accept="image/jpeg,image/pjpeg,image/png"
 destination="#imagepath#/#robpic#.jpg"
 mode="644">

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



<cfquery name="ups" dataSource="#ds#">
    update ActivityPlannerAds
    set image = '#photo#'
    where id = #result.generatedkey#
</cfquery>
</cfif>
<cflocation url="calendarads.cfm" addtoken="no">
</cfif>

    <cfif parameterexists(url.editsave)>    <cfparam name="form.cats" default="">

    
    <cfquery name="upds" dataSource="#ds#">
        update ActivityPlannerAds 
        set name = '#form.name#',
        cats = '#form.cats#',
        content = '#form.content#',
        address = '#form.address#',
        phone = '#form.phone#',
        urllink = '#form.urllink#',
        startdate = '#dateformat(form.startdate,'yyyy-mm-dd')#',
        enddate = '#dateformat(form.enddate,'yyyy-mm-dd')#'
        where id = #url.editsave#
    </cfquery>
    
    <cfif parameterexists(form.photo) and #form.photo# is not ''>
<cfset robpic = #createUUID()#>

<cfset ds='cityguide'>


<cffile action="upload"
	        nameconflict="makeunique"
filefield="photo"
accept="image/jpeg,image/pjpeg,image/png"
 destination="/home/home2/cgny/public_html/2019/eventpic/#robpic#.jpg"
 mode="644">

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

<cfquery name="ups" dataSource="#ds#">
    update ActivityPlannerAds
    set image = '#photo#'
    where id = #url.editsave#
</cfquery>
</cfif>

<Cflocation url="calendarads.cfm?saved" addtoken="no">    
    <cfelseif parameterexists(url.edit)>
    
    <cfquery name="geter" dataSource="#ds#">
        select * from ActivityPlannerAds where id = #Url.edit#
    </cfquery>
<cfoutput>
    
    <a href="calendarads.cfm?delete=#url.edit#">Delete Entry</a>
    <p></p>
<FORM action="calendarads.cfm?editsave=#url.edit#" method="post"  enctype="multipart/form-data">

<cfif geter.image is not ''>
     <img src="https://www.cityguideny.com/eventpic/#geter.image#" style="max-width:300px">

</cfif>
<table >
 


<tr><Td><b style="font-weight:900">Name</b></td><td>

<input name="name" type="text" class="form-control"  required value="#geter.name#">
</td></tr>

 
<tr><Td><b style="font-weight:900">Start Date (yyyy-mm-dd)</b></td><td>

<input name="startdate" type="text" class="form-control"  required value="#geter.startdate#">
</td></tr>

<tr><Td><b style="font-weight:900">End Date (yyyy-mm-dd)</b></td><td>

<input name="enddate" type="text" class="form-control"  required value="#geter.enddate#">
</td></tr>


<tr><Td><b style="font-weight:900">Image</b></td><td>

<input type=file name=photo>
</td></tr>

<tr><Td><b style="font-weight:900">Address</b></td><td>

<input name="address" type="text" class="form-control"   value="#geter.address#">
</td></tr>
<tr><Td><b style="font-weight:900">Phone</b></td><td>

<input name="phone" type="text" class="form-control"   value="#geter.phone#">
</td></tr>

<tr><Td><b style="font-weight:900">Link</b></td><td>

<input name="urllink" type="text" class="form-control"  required value="#geter.urllink#">
</td></tr>

 <tr><Td><b style="font-weight:900">Content</b></td><td>
<textarea name="content" style="width:100%;height:300px;">#geter.content#</textarea>
</td></tr>

 <cfquery name="getsites" datasource="#ds#">
select *
from CatActivityPlanner
where mag = 1
and cat <> ''
and CatActivityPlanner.hide = 0
and catid> 150

order by mastercat,cat
</cfquery>

 <tr><Td><b style="font-weight:900">Cats</b></td><td>
     <input name="cats" type="checkbox" value="0" <cfif #geter.cats# eq '0' or geter.cats contains '0,'>checked</cfif>> CALENDAR HOME<br> 
     <Cfoutput query="getsites"><input name="cats" type="checkbox" value="#getsites.catid#" <cfif #geter.cats# contains '#getsites.catid#'>checked</cfif>> #cat#<br></Cfoutput>
</td></tr>



</Cfoutput>
</table>



<br>
<input type="submit" Value="Save" name="buttadminman" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">
</div>

</form>

<cfelse>     

<Cfif parameterexists(url.updated)>
    Saved!<p></p></cfif>
    
    </div>


<cfquery name="getdel" dataSource="#ds#">
	select * from ActivityPlannerAds
order by id</cfquery>	 

<table id="example23" class="display nowrap table table-hover table-striped table-bordered" cellspacing="0" width="p0-100%" style="margin-left:250px;">
<thead>
<th>Edit</th>
<th>Cats</th>

<th>Dates</th>
<th>Clicks</th>

</th>
</thead>

<cfoutput query="getdel">
	<tr>

<td style="max-width: 50px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; "><a href="calendarads.cfm?edit=#id#" >#name#</a></td>	

<td style="max-width: 100px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; ">
    <cfquery name="getcatsme" dataSource="#ds#">
        select cat from CatActivityPlanner
        where catid in (#cats#)
    </cfquery>
    <small><cfif #cats# eq '0' or cats contains '0,'>HOME, </cfif><cfloop from="1" to="#getcatsme.recordcount#" index='i'>#getcatsme.cat[i]#,  </cfloop></small></td>	

<td style="max-width: 50px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; " data-sort="#dateformat(startdate,'yyyy-mm-dd')#"><small>#dateformat(startdate,'yyyy-mm-dd')# -> #dateformat(enddate,'yyyy-mm-dd')#</small></td>
    
    <td style="max-width: 50px;white-space: -o-pre-wrap; 

    word-wrap: break-word;
    white-space: pre-wrap; 
    white-space: -moz-pre-wrap; 
    white-space: -pre-wrap; "><small>#clicks#</small></td>	
    
	</tr>	
		
</cfoutput>

	</TAble>
	
	
    <FORM action="calendarads.cfm?add=on" method="post"  enctype="multipart/form-data" style="margin-left:250px;">


<table >
 


<tr><Td><b style="font-weight:900">Name</b></td><td>

<input name="name" type="text" class="form-control"  required>
</td></tr>

 
<tr><Td><b style="font-weight:900">Start Date (yyyy-mm-dd)</b></td><td>

<input name="startdate" type="text" class="form-control"  required >
</td></tr>

<tr><Td><b style="font-weight:900">End Date (yyyy-mm-dd)</b></td><td>

<input name="enddate" type="text" class="form-control"  required>
</td></tr>


<tr><Td><b style="font-weight:900">Image</b></td><td>

<input type=file name=photo>
</td></tr>

<tr><Td><b style="font-weight:900">Address</b></td><td>

<input name="address" type="text" class="form-control"   >
</td></tr>
<tr><Td><b style="font-weight:900">Phone</b></td><td>

<input name="phone" type="text" class="form-control" >
</td></tr>

<tr><Td><b style="font-weight:900">Link</b></td><td>

<input name="urllink" type="text" class="form-control"  required>
</td></tr>

 <tr><Td><b style="font-weight:900">Content</b></td><td>
<textarea name="content" style="width:100%;height:300px;"></textarea>
</td></tr>
 
 
 <cfquery name="getsites" datasource="#ds#">
select *
from CatActivityPlanner
where mag = 1
and cat <> ''
and CatActivityPlanner.hide = 0
and catid> 150

order by mastercat,cat
</cfquery>

 <tr><Td><b style="font-weight:900">Cats</b></td><td>
     <input name="cats" type="checkbox" value="0"> CALENDAR HOME<br> 
     <Cfoutput query="getsites"><input name="cats" type="checkbox" value="#getsites.catid#"> #cat#<br></Cfoutput>
</td></tr>

</table>



<br>
<input type="submit" Value="Add" name="buttadminman" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">
</div>

</form>
	
</cfif>


   </div>
<!--Footer-part-->
<br><br><br><br>

    <script src="/theme/assets/plugins/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://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/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
    <!-- end - This is for export functionality only -->
    <script>
  $(document).ready(function() {
    $('#example').DataTable( {
        "paging":   false,
        "ordering": false,
        "info":     false
    } );
} );

      $('#example23').DataTable({
        dom: 'Bfrtip',
             order: [[3, 'desc']],
        buttons: [
           
        ]
             ,   "paging":   false,

    });

    </script>



   </div>
<!--Footer-part-->
<br><br><br><br>

<cfinclude template="footer.cfm">