<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">


<cfif parameterexists(form.skipbutton)>

<cfquery name="updater" datasource="cityguide">
update ActivityPlannerHold
set statusnum = 1
where id = #form.id#
</cfquery>

<cflocation url="approvecalendar.cfm" addtoken="no">
</cfif>


<cfif parameterexists(form.delbutton)>

<cfquery name="updater" datasource="cityguide">
delete from ActivityPlannerHold
where id = #form.id#
</cfquery>

<cflocation url="approvecalendar.cfm" addtoken="no">
</cfif>

 <cfif IsDate(FORM.datestart) and isdate(form.dateend)>





<cfparam name="form.cg" default="">
<cfparam name="form.ml" default="">
<cfparam name="form.pk" default="">
<cfparam name="form.pkb" default="">
<cfparam name="form.pkq" default="">
<cfparam name="form.pkw" default=""><cfparam name="form.pkf" default="">

<cfparam name="form.pkn" default="">
<cfparam name="form.pks" default="">
<cfparam name="form.nympregion" default="">

<cfparam name="form.photo" default="">
<cfparam name="form.thumbnail" default="">

<cfparam name="form.nympprintcat" default="0">
<cfparam name="form.phonex" default="">
<cfparam name="form.HOTTICKETREGION" default="">
<cfparam name="form.catid" default="0">
<cfparam name="form.catid2" default="0">

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

<cfparam name="form.pkr" default="">
<cfparam name="form.age6" default="">
<cfparam name="form.editorlove" default="">
<cfparam name="form.catid" default="0">
<cfparam name="form.isweekend" default="0">


<Cfif #form.catid# eq ''>
	<cfset form.catid = 0>
</Cfif>

<cfif form.catid3 eq 0 or form.nympregion eq ''>
	
Error, you must pick a category and an online region. 
<p>
	<button onclick="goBack()">Go Back</button>

<cfabort>
</cfif>	
<cfparam name="form.nympregion" default="">
<cfparam name="form.onlineonly" default="">
<cfparam name="form.registrationrequired" default="">
<cfparam name="form.daysofweek" default="">
<cfparam name="form.covid" default="">

<cfset datestart=#DateFormat(form.datestart,"yyyy-mm-dd")#>
<cfset dateend=#DateFormat(form.dateend,"yyyy-mm-dd")#>
<cfif parameterexists(form.addbutton)>


<cfquery name=addphoto datasource="#ds#">
INSERT INTO ActivityPlanner(name,catid,datestart,dateend,address,city,state,description,zip,phone,website,address2,contactfirst,contactlast,contactitle,contactphone,contactemail,hours,dtentered,activityname,ages,price,catid2,cg,ml,pk,pkb,pkq,pkw,ActivityPlannerVenueID,shortdescription,pkr,nympregion,pkn,pkf,pks,catid3,catid4,age6,updatedby,updatedon,nympprintcat,photo,thumbnail,usepicprint,hotticketregion,editorlove,approvedby,approvedon,phonex,isweekend,onlineonly,daysofweek,registrationrequired,covid)

VALUES	('#form.name#',#form.catid#,'#datestart#','#dateend#','#form.address#','#form.city#','#form.state#','#form.descriptiona#','#form.zip#','#form.phone#','#form.website#','#form.address2#','#form.contactfirst#','#form.contactlast#','#form.contactitle#','#form.contactphone#','#form.contactemail#','#form.hours#',#currentdatetime#,'#form.activityname#','#form.ages#','#form.price#',#form.catid2#,'#form.cg#','#form.ml#','#form.pk#','#form.pkb#','#form.pkq#','#form.pkw#',#form.ActivityPlannerVenueID#,'#form.shortdescription#','#form.pkr#','#form.nympregion#','#form.pkn#','#form.pkf#','#form.pks#',#form.catid3#,#form.catid4#,'#form.age6#','#getuser.member#',#currentdatetime#,#form.nympprintcat#,'#form.photo#','#form.thumbnail#',#form.usepicprint#,'#form.hotticketregion#','#form.editorlove#','#getuser.member#',#currentdatetime#,'#form.phonex#',#form.isweekend#,'#form.onlineonly#','#form.daysofweek#','#form.registrationrequired#','#form.covid#')
</cfquery>


<cfquery name="updater" datasource="cityguide">
update ActivityPlannerHold
set statusnum = 2
where id = #form.id#
</cfquery>


<cfquery name="getseo" datasource="#ds#">
select id, name,datestart,dateend
from ActivityPlanner
where (seo_friendly is null or seo_friendly = '')
and id <> 9939 and id <> 171250 and id <> 174319 and id <> 116527 and name <> ''
</cfquery>

<cfoutput query="getseo">
<cfset seodate = '#dateformat(datestart,"yyyy-mm-dd")#-#dateformat(datestart,"yyyy-mm-dd")#'>
<cfset moveurl = reReplace(name, "([^[: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>

<cfset moveurl = '#moveurl#-#seodate#'>

<Cfquery name="checkmove" datasource="#ds#">
select id from ActivityPlanner where seo_friendly = '#moveurl#'
</cfquery>

<Cfif #checkmove.recordcount# gt 0>
<cfset moveurl = '#moveurl#-#dateformat(currentdatetime,'mmdd-ss')#'>
</cfif>

<Cfquery name="upds" datasource="#ds#">
update ActivityPlanner
set seo_friendly = '#moveurl#'
where id = #id#
</cfquery>

</cfoutput>

<a href="/approvecalendarlist.cfm">Back to Approve Calendar</a>
<cfquery name="Getcat" datasource="#ds#">
select id,nympregion
from ActivityPlanner
order by id desc
limit 0,1
</cfquery>



<Cfif #getcat.nympregion# is not ''>
    
    <cfquery name="Getsales" datasource="#ds#">
        select email from davlersales
        where region = '#getcat.nympregion#'
    </cfquery>
    <cfset myList = ValueList(Getsales.email,",")>

<CFMAIL
TO="#form.contactemail#"
cc ="#mylist#"

SUBJECT="Your event has been approved for the NYMetroParents Calendar"

        FROM="NYMP <#session.email#>"
SERVER="us-smtp-outbound-1.mimecast.com"
type="html">

Congratulations! Your event has been approved in our calendar section. To see your event listing, go to: <a href="https://www.nymetroparents.com/2015neweventinfo.cfm?id=#getcat.id#">https://www.nymetroparents.com/2015neweventinfo.cfm?id=#getcat.id#</a>
<p>
You're definitely in our online calendar, and if you made the deadline, your event may also be included in one of our print calendars. Didn't know we had print calendars? We're not mad...but you might want to <a href="https://www.nymetroparents.com/article/About-NY-Metro-Parents-Publications">get acquainted with our publications</a>.</p>
<p>Now start spreading the word about your great event! We recommend posting the link above to your <a href="http://www.facebook.com">Facebook</a> and <a href="http://www.twitter.com">Twitter</a> pages. Not a fan of social media? Go ahead and send out an email to your clients and friends (you probably need to catch up anyway, right?).</p>
<p>By the way, if your event is really terrific, we might just select it for our weekly activities newsletter, where we highlight the best family events happening each weekend in the NYC area. Keep tabs on it by <a href="https://www.nymetroparents.com/newsletter.cfm">signing up</a> (it's free!).</p>
Want to submit more events? Head back to <a href="http://www.nymetroparents.com/submitevent">http://www.nymetroparents.com/submitevent</a>.
<p>
Questions? <a href="https://www.nymetroparents.com/contact/">Contact us</a>.
<p>
Thanks!<br />
The NYMetroParents Editorial Team
<p>

---------------------------------------------<br>
<a href="https://nymetroparents.com/">nymetroparents.com</a>
</cfmail>
</Cfif>

<br /><FORM action="dupecalendar.cfm" method="post">
<cfoutput><input type="hidden" name="id" value="#getcat.id#"></cfoutput>
<font face=verdana size=-1>Enter Number of Times to Duplicate Entry <input NAME="dupenum" SIZE="5">
<input type="submit" Value="Dupe">
</FORM>
<p>
<a href="/activityplanneredit.cfm?mag=5">Back to Calendar Admin</a>...

</cfif>




<cfelse>
<Table width=800><Tr><Td></Td></Tr></Table>
<p>
<font face=verdana size=+1><center>
<strong>Invalid Date Format,<br /> <a href="javascript: history.go(-1)">Click Here to Go Back and Edit</a></strong>
</center>

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

<cfinclude template="footer.cfm">