<cfinclude template="header.cfm">
<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<script language="javascript">
function pickbooka() {
if (document.bookforma.books.value != '0' )
{
document.location = document.bookforma.books.value;
} else {
alert('Please select a Show')
}
}
</script>

<script language="javascript">
function pickbookab() {
if (document.bookformab.books.value != '0' )
{
document.location = document.bookformab.books.value;
} else {
alert('Please select a Show')
}
}
</script>
<SCRIPT LANGUAGE="JavaScript">

<!-- This script and many more are available free online at -->
<!-- The JavaScript Source!! http://javascript.internet.com -->
<!-- Original:  Roman Feldblum ([email protected]) -->

<!-- Begin
var n;
var p;
var p1;
function ValidatePhone(){
p=p1.value
if(p.length==3){
	//d10=p.indexOf('(')
	pp=p;
	d4=p.indexOf('(')
	d5=p.indexOf(')')
	if(d4==-1){
		pp="("+pp;
	}
	if(d5==-1){
		pp=pp+")";
	}
	//pp="("+pp+")";
	document.frmPhone.txtphone.value="";
	document.frmPhone.txtphone.value=pp;
}
if(p.length>3){
	d1=p.indexOf('(')
	d2=p.indexOf(')')
	if (d2==-1){
		l30=p.length;
		p30=p.substring(0,4);
		//alert(p30);
		p30=p30+")"
		p31=p.substring(4,l30);
		pp=p30+p31;
		//alert(p31);
		document.frmPhone.txtphone.value="";
		document.frmPhone.txtphone.value=pp;
	}
	}
if(p.length>5){
	p11=p.substring(d1+1,d2);
	if(p11.length>3){
	p12=p11;
	l12=p12.length;
	l15=p.length
	//l12=l12-3
	p13=p11.substring(0,3);
	p14=p11.substring(3,l12);
	p15=p.substring(d2+1,l15);
	document.frmPhone.txtphone.value="";
	pp="("+p13+")"+p14+p15;
	document.frmPhone.txtphone.value=pp;
	//obj1.value="";
	//obj1.value=pp;
	}
	l16=p.length;
	p16=p.substring(d2+1,l16);
	l17=p16.length;
	if(l17>3&&p16.indexOf('-')==-1){
		p17=p.substring(d2+1,d2+4);
		p18=p.substring(d2+4,l16);
		p19=p.substring(0,d2+1);
		//alert(p19);
	pp=p19+p17+"-"+p18;
	document.frmPhone.txtphone.value="";
	document.frmPhone.txtphone.value=pp;
	//obj1.value="";
	//obj1.value=pp;
	}
}
//}
setTimeout(ValidatePhone,100)
}
function getIt(m){
n=m.name;
//p1=document.forms[0].elements[n]
p1=m
ValidatePhone()
}
function testphone(obj1){
p=obj1.value
//alert(p)
p=p.replace("(","")
p=p.replace(")","")
p=p.replace("-","")
p=p.replace("-","")
//alert(isNaN(p))
if (isNaN(p)==true){
alert("Check phone");
return false;
}
}
//  End -->
</script>


<cfif parameterexists(getuser.id)>


<cfquery name="Getcat" datasource="cg22">
SELECT cat,catid,mastercat
FROM CatActivityPlanner
where mag = 1
                    and hide <> 1
                    and catid > 150
                    <!---and mastercat = '' --->
and cat <> ''
order by mastercat,cat

</cfquery>


<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Add to Calendar</strong></font>
<p>

<cfquery name="getpullcat" datasource="cg22">
SELECT *
FROM _SubCat
order by SubCatName
</cfquery>

<table width=100%><tr>
<td width=33%>
<font face=verdana size=-2>To auto-fill address information, and to associate a calendar entry with a listing, please first select a category and listing to the right:
</td>
<td width=33%>
<form name="bookforma" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<SELECT size=1 onchange="javascript:pickbooka();" name="books" >
<cfoutput><cfif parameterexists(url.tablename)><option value="addcalendarupwork.cfm?tablename=#url.tablename#">#url.tablename#</option></cfif></cfoutput>
<option value=''>Select Category

<option value="addcalendarupwork.cfm?tablename=ActivityPlannerVenues">From Venues</option>
<option value="addcalendarupwork.cfm?tablename=ActivityPlanner">From Activity Planner - All</option>
<option value="addcalendarupwork.cfm?tablename=ActivityPlanner&limit=CG">From Activity Planner - CG</option>
<cfoutput query="getpullcat">
<option value="addcalendarupwork.cfm?tablename=#SubCatTableName#">#subcatname#</option>
</cfoutput>
</select>
</form>
		</td>

		<td width=33%>
		<cfif parameterexists(url.tablename)>

<Cfif #url.tablename# eq 'ActivityPlannerVenues'>

<cfquery name="getpullcat2" datasource="cg22"     cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
SELECT distinct venuename,id
FROM #url.tablename#
order by venuename
</cfquery>


<form name="bookformab" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<SELECT size=1 onchange="javascript:pickbookab();" name="books" class="books" WIDTH="300" STYLE="width: 300px">
<option value=''>Select Entry
<cfoutput query="getpullcat2">
<option value="addcalendarupwork.cfm?tablename=#url.tablename#&id=#getpullcat2.id#">#getpullcat2.venuename#</option>
</cfoutput>
</select>
</form>

<cfelseif #url.tablename# eq 'ActivityPlanner'>

<cfquery name="getpullcat2" datasource="cg22"    cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">

SELECT distinct name,id
FROM #url.tablename# <cfif parameterexists(url.limit)><cfif #url.limit# eq 'CG'>where catid < 19</cfif><cfif #url.limit# eq 'PK'>where (catid3 > 18 or catid4 > 18)</cfif></cfif>
order by name
</cfquery>


<form name="bookformab" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<SELECT size=1 onchange="javascript:pickbookab();" name="books" class="books"  WIDTH="300" STYLE="width: 300px">
<option value=''>Select Entry
<cfoutput query="getpullcat2">
<Cfif #getpullcat2.name# is not '#getpullcat2.name[currentrow-1]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-2]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-3]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-4]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-5]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-6]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-7]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-8]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-9]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-10]#'>
<option value="addcalendarupwork.cfm?tablename=#url.tablename#&id=#getpullcat2.id#">#getpullcat2.name#</option>
</Cfif>
</cfoutput>
</select>
</form>


<Cfelse>





<cfquery name="getpullcat2" datasource="cg22"    cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#">
SELECT id,name
FROM #url.tablename# <cfif parameterexists(url.limit)><cfif #url.limit# eq 'CG'>where catid < 19</cfif><cfif #url.limit# eq 'PK'>where (catid3 > 18 or catid4 > 18)</cfif></cfif>
order by name
</cfquery>


<form name="bookformab" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0">
<SELECT size=1 onchange="javascript:pickbookab();" name="books" class="books"  WIDTH="300" STYLE="width: 300px">
<option value=''>Select Entry
<cftry>
<cfquery name="alsoget" dataSource="#ds#">
	select venuename as name,id from acttemp
	where mastercat = '#url.tablename#'
	order by name
</cfquery>
<cfoutput query="alsoget">
<option value="addcalendarupwork.cfm?tablename=#url.tablename#&id=#alsoget.id#&alsoget=on">#alsoget.name#</option>
</cfoutput>
<cfcatch></cfcatch>
</cftry>

<cfoutput query="getpullcat2"><Cfif #getpullcat2.name# is not '#getpullcat2.name[currentrow-1]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-2]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-3]#' and #getpullcat2.name# is not '#getpullcat2.name[currentrow-4]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-5]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-6]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-7]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-8]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-9]#'  and #getpullcat2.name# is not '#getpullcat2.name[currentrow-10]#'>
<option value="addcalendarupwork.cfm?tablename=#url.tablename#&id=#getpullcat2.id#">#getpullcat2.name#</option></Cfif>
</cfoutput>

</select>
</form>
		</cfif>
		</cfif>


		</td>
		</tr></table>




<p>
<FORM action="addcalendarpreview.cfm?fromupwork=on" method="post"  enctype="multipart/form-data" name="MyForm">
<cfif parameterexists(url.tablename) and parameterexists(url.id)>

<cfif #url.tablename# eq 'ActivityPlannerVenues'>

<cfquery name="getlisting" datasource="cg22">
select *
FROM #url.tablename#
where id = #url.id#
</cfquery>
<cfoutput>
  <input NAME="tablename" SIZE="65" type="hidden" value="#url.tablename#">
  <input NAME="itemid" SIZE="65" type="hidden" value="#url.id#">
</cfoutput>


<cfelse>

<cfif parameterexists(url.alsoget)>
<cfquery name="getlisting" datasource="cg22">
select *,venuename as name
FROM acttemp
where id = #url.id#
</cfquery>
<cfoutput>
  <input NAME="tablename" SIZE="65" type="hidden" value="#url.tablename#">
  <input NAME="itemid" SIZE="65" type="hidden" value="#url.id#">
</cfoutput>

<cfelse>
<cfquery name="getlisting" datasource="cg22">
select *
FROM #url.tablename#
where id = #url.id#
</cfquery>
<cfoutput>
  <input NAME="tablename" SIZE="65" type="hidden" value="#url.tablename#">
  <input NAME="itemid" SIZE="65" type="hidden" value="#url.id#">
</cfoutput>
</cfif>
</cfif>
</cfif>


<input name="cg" type="hidden" value="on">


  <br>
   <table cellspacing=0 cellpadding=5 border=1>


  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>
  </td><td>

<cfif parameterexists(url.tablename) and #url.tablename# eq 'ActivityPlannerVenues'>

	  <input NAME="name" SIZE="65" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.venuename#"</cfoutput></cfif>>

<Cfelse>

	  <input NAME="name" SIZE="65" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.name#"</cfoutput></cfif>>

</cfif>
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Event Name:</font></b>
  </td><td>
	  <input required NAME="activityname" SIZE="65" <!---<cfif parameterexists(url.tablename) and parameterexists(url.id) and parameterexists(getlisting.activityname)><cfoutput>value="#getlisting.activityname#"</cfoutput></cfif>--->>
  </td></tr>



    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Address:</font></b>
  </td><td>
	  <input NAME="address" SIZE="65" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.address#"</cfoutput></cfif>>
  </td></tr>


    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">City:</font></b>
  </td><td>
	  <input NAME="City" SIZE="65" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.city#"</cfoutput></cfif>>
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">State:</font></b>
  </td><td>
	  <input NAME="state" SIZE="3" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.state#"</cfoutput></cfif>>
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Zip:</font></b>
  </td><td>
	  <input NAME="zip" SIZE="5" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.zip#"</cfoutput></cfif>>
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Phone:</font></b>
  </td><td>


	  <input name=txtphone maxlength="12" SIZE="12" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.phone#"</cfoutput></cfif>>
  </td></tr>



    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Web Site:</font></b>
  </td><td>
	  <input NAME="website" SIZE="40" <cfif parameterexists(url.tablename) and parameterexists(url.id)><cfoutput>value="#getlisting.website#"</cfoutput></cfif>>
  </td></tr>


    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Purchase Tickets:</font></b>
  </td><td>
	  <input NAME="buytickets" SIZE="40">
  </td></tr>


  <tr>
  <td>
  <b><font SIZE="-1" FACE="verdana" >Start Date:</font></b>
  </td><td>

    <cf_calendar form="MyForm" name="datestart" calendardir="." FORMAT="DD-MMM-YY" required>
  </td></tr>


  <tr>
  <td>
  <b><font SIZE="-1" FACE="verdana" >End Date:</font></b>
  </td><td>

  <cf_calendar form="MyForm" name="dateend" calendardir="." FORMAT="DD-MMM-YY" required>
  </td></tr>


<!---
   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Hours:</font></b>
  </td><td><cfoutput>
  Start Time: <select name="starthours"><cfloop from="0" to="12" index="i"><option value="#i#">#i#</cfloop></select>
  <select name="startminutes"><cfloop from="00" to="59" index="i"><option value="#i#">#i#</cfloop></select>
  <select name="starttt"><option value="am">am<option value="pm">pm</select>
</cfoutput>
  </td></tr>
  --->
   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Time:</font></b>
  </td><td>
	  <input NAME="hours" SIZE="65">
  </td></tr>



  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Price:</font></b>
  </td><td>

<Table>

<tr><Td></td><td>Free <input NAME="age6" SIZE="10" type="checkbox">
	<p>
	or
	<p>

		  <input NAME="Price" SIZE="65">
		  <br><small>
		  Follow this format: $12; $10 seniors; $8 children ages 2-12; free for children younger than 2

</td><td> </td></tr>

<!---
<tr><Td>Children</td><td><input NAME="age1" SIZE="10"></td><td> $<input NAME="price1" SIZE="10"></td></tr>
<tr><Td>Students</td><td><input NAME="age2" SIZE="10"></td><td> $<input NAME="price2" SIZE="10"></td></tr>
<tr><Td>Adults</td><td><input NAME="age3" SIZE="10"></td><td> $<input NAME="price3" SIZE="10"></td></tr>
<tr><Td>Seniors</td><td><input NAME="age4" SIZE="10" ></td><td> $<input NAME="price4" SIZE="10" ></td></tr>
<tr><Td>All Ages</td><td><input NAME="age5" SIZE="10"></td><td> $<input NAME="price5" SIZE="10" ></td></tr>
--->
  </table></td></tr>

   <tr>
	  <td>
	  <b><font SIZE="-1" FACE="verdana" >Categories:</font></b>
	  </td>
	  <td>

	    <select NAME="catid" size="1">  <option value="0">Category 1</option>
	  <cfoutput query="getcat">
        <option value="#catid#">#Cat#</option>
					</cfoutput>


		</select>
  <select NAME="catid2" size="1">
		     <option value="0">None</option>
	  <cfoutput query="getcat">
        <option value="#catid#">#Cat#</option>
					</cfoutput>


		</select>
	  </td>
  </tr>



	    <tr>
      <td colspan=2 align="left" valign="top">
<font SIZE="-1" FACE="verdana" ><b>Full Description for the Online Calendar:</b></font><br>
        <textarea name="description" cols="65" rows="10"  wrap="VIRTUAL"></textarea>
      </td>
    </tr>



 </table><br>
<center><input type="submit" Value="Preview Entry"></center>
</form></td></tr></table>

</cfif>