<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;"><cfif parameterexists(Session.email) and (Session.email IS NOT -1)>
<cfif (#getuser.accesslevel# eq 100)>

<Cfparam name="url.letter" default="a">
<Cfparam name="form.alist" default="Only A-List">
<Cfparam name="form.region" default="All">

 
<cfif parameterexists(url.region)>

	<cfset form.region = '#url.region#'>
</cfif>
<table width=100%><tr><td>
<div align="center"><font face=verdana size=+1><strong>Manage Venues</strong></font>
 <font face=verdana size=-1><Br />
  <A href="addvenue.cfm">Venue Admin</A> |

 <A href="#add">Add Venue</A>
<p>
<p>

<strong>Jump to:<br /></strong> <small> <FORM action="addvenue.cfm" method="post"  enctype="multipart/form-data">

<select name="region">
	<cfif parameterexists(form.region)><cfoutput><option value="#form.region#">#form.region#</option></cfoutput></cfif>
	<option value="All">All</option>

<cfquery name="getregions" dataSource="#ds#">
	select region from ActivityPlannerVenuesupwork
	where region <> ''
		group by region

	order by region
</cfquery>
<Cfoutput query="getregions">
	<option value="#region#">#region#</option>
</Cfoutput>

</select>

<select name="alist">
<cfif parameterexists(form.alist)><cfoutput><option value="#form.alist#">#form.alist#</option></cfoutput></cfif>
<option value="All">All</option>
<option value="Only A-List">Only A-List</option>
<option value="Only Non-A-List">Only Non-A-List</option>
</select>


<select name="description">
<cfif parameterexists(form.description)><cfoutput><option value="#form.description#">#form.description#</option></cfoutput></cfif>
<option value="All">All</option>
<option value="Only With Description">Only With Description</option>
<option value="Needs Description">Needs Description</option>
</select>

Search: <input NAME="searchterm" SIZE="10" <cfif parameterexists(form.searchterm)><cfoutput>value="#form.searchterm#"</cfoutput></cfif>
> <input type="submit" Value="Go"></Center>
</form>
</FORM>
</small>

</center></div>

<FORM action="addvenue2upwork.cfm" method="post"  enctype="multipart/form-data">



<font face=verdana size=-1>
<cfquery name="getsites" datasource="#ds#">
select *
from ActivityPlannerVenuesupwork
where 1 =1
and venuename <> ''
<Cfif parameterexists(form.searchterm) and #form.searchterm# is not ''>
and venuename like '%#form.searchterm#%'
</Cfif>
<cfif parameterexists(form.region) and #form.region# is not 'All'>
and region = '#form.region#'
</cfif>

<cfif parameterexists(form.description) and #form.description# is not 'All'>
<cfif form.description eq 'Only With Description'>
	and description <> '' 
<cfelse>
 and (description = '' or description is null)
</cfif>	

</cfif>


<cfif parameterexists(form.alist) and #form.alist# is not 'All'>

<Cfif #form.region# eq 'Manhattan'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistmanhattan = 1
	<cfelse>
       and alistmanhattan = 0
	</Cfif>
</Cfif>

	<Cfif #form.region# eq 'Brooklyn'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistbrooklyn = 1
	<cfelse>
       and alistbrooklyn = 0
	</Cfif>
</Cfif>

	<Cfif #form.region# eq 'Queens'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistqueens = 1
	<cfelse>
       and alistqueens = 0
	</Cfif>
</Cfif>

<Cfif #form.region# eq 'Westchester'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistwestchester = 1
	<cfelse>
       and alistwestchester = 0
	</Cfif>
</Cfif>

	<Cfif #form.region# eq 'Rockland'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistrockland = 1
	<cfelse>
       and alistrockland = 0
	</Cfif>
</Cfif>


	<Cfif #form.region# eq 'Bronx'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistbronx = 1
	<cfelse>
       and alistbronx = 0
	</Cfif>
</Cfif>


<Cfif #form.region# eq 'Staten Island'>
	<Cfif #form.alist# eq 'Only A-List'>
		and aliststatenisland = 1
	<cfelse>
       and aliststatenisland = 0
	</Cfif>
</Cfif>


	<Cfif #form.region# eq 'Essex'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistessex = 1
	<cfelse>
       and alistessex = 0
	</Cfif>
</Cfif>
	<Cfif #form.region# eq 'Fairfield'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistfairfield = 1
	<cfelse>
       and alistfairfield = 0
	</Cfif>
</Cfif>
	<Cfif #form.region# eq 'Bergen'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistbergen = 1
	<cfelse>
       and alistbergen = 0
	</Cfif>
</Cfif>
	<Cfif #form.region# eq 'Nassau'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistnassau = 1
	<cfelse>
       and alistnassau = 0
	</Cfif>
</Cfif>
	<Cfif #form.region# eq 'Suffolk'>
	<Cfif #form.alist# eq 'Only A-List'>
		and alistsuffolk = 1
	<cfelse>
       and alistsuffolk = 0
	</Cfif>
</Cfif>








</cfif>


order by venuename
</cfquery>

<Cfoutput>#getsites.recordcount# Found</Cfoutput>

</div>

<table class="table color-table inverse-table table-hover table-striped">
<tr bgcolor="black">
<!---<td><font face=verdana size=-1 color=white><b>ID</td>--->
<td style="background-color: black;"><font face=verdana size=-1 color=white><b>NAME</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><center><b>ADD<br>EVENT</td>

<td style="background-color: black;"><font face=verdana size=-1 color=white><center><b>EDIT<Br>VENUE</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><center><b>DELETE<br>VENUE</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><b><center>APPVD</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><b><center>PEND</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><b><center>LAST ENTERED</td>
<td style="background-color: black;"><font face=verdana size=-1 color=white><b><center>LAST UPDATED</td>

</tr>
<cfoutput query="getsites">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
<!---<td><font face=verdana size=-1><b>#id#</a></b></td>--->
<td><font face=verdana size=-1><b>#venuename#</a></b></td>
<!---

<td><center><font face=verdana size=-1><A href="http://www.nymetroparents.com/naddcalendartest.cfm?regioncal=#form.region#&id=#id#"><b>add</a></b></td>
	---->


<Td></Td>
<td><center><font face=verdana size=-1><a href="editvenueupwork.cfm?id=#id#" target="_new">edit</a></td>
<Td></Td>
</tr>

</cfoutput>
</table>

<p>
<table><a name="add">
  <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Venue Name:</font></b>
  </td><td>
	  <input NAME="rule2venue" SIZE="65">
  </td></tr>

    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Website:</font></b>
  </td><td>
	  <input NAME="website" SIZE="65">
  </td></tr>

	    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Address:</font></b>
  </td><td>
	  <input NAME="Address" SIZE="65">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">City:</font></b>
  </td><td>
	  <input NAME="City" SIZE="65">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">State:</font></b>
  </td><td>
	  <input NAME="State" SIZE="65">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Zip:</font></b>
  </td><td>
	  <input NAME="Zip" SIZE="65">
  </td></tr>
    <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Phone:</font></b>
  </td><td>
	  <input NAME="Phone" SIZE="65">
  </td></tr>

   <tr><td>
	  <b><font SIZE="-1" FACE="verdana">Region:</font></b>
  </td><td colspan="8">
<SELECT  name="region" >
<option value="Westchester">Westchester County / Bronx</option>
<option value="Rockland">Rockland County</option>
<option value="Bergen">Bergen County</option>
<option value="Brooklyn">Brooklyn</option>
<option value="Staten Island">Staten Island</option>
<option value="Queens">Queens</option>
<option value="Fairfield">Fairfield</option>

<option value="Manhattan">Manhattan</option>
<option value="Nassau">Nassau County</option>
<option value="Suffolk">Suffolk County</option>
 </select>  </td></tr>

 </table><br>
<input type="submit" Value="Add Venue"></center>
</form>

<p>
	
	<table style="background-color: #efefef;border-width: 1px;border-style: solid;"><tr><Td style="padding:5px;">
	<p><font face=verdana size="-1">
<strong>Merge Venues: Will Merge One Venues's Records into Another, and will delete the empty venue.</strong>
<p>
<FORM action="cleanvenue.cfm?cleantype=mergeperson" method="post"  enctype="multipart/form-data">

  <b><font SIZE="-2" FACE="verdana">Venue to Kill:</font></b><input NAME="oldname" SIZE="15">
    <b><font SIZE="-2" FACE="verdana">Venue to Merge Into:</font></b><input NAME="newname" SIZE="15"> <input type="submit" Value="Go">
</form> </Td></tr></table>


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




</cfif>
</cfif>

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

<cfinclude template="footer.cfm">