<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">
<cfif parameterexists(getuser.id)>


<Cfif parameterexists(url.delete)>
		<cfquery name="del" datasource="#ds#">
delete from nympsafetysubmit
where id = #url.delete#
</cfquery>

</Cfif>

<cfif parameterexists(url.updater)>

<cfparam name="form.msid" default="0">
<cfquery name="upds" datasource="#ds#">
	update nympsafetysubmit
	
set businessname = '#form.businessname#',
Address  =  '#form.address#',
Zip = '#form.zip#',
Phone = '#form.phonenumber#',
Website = '#form.website#',
nympregion = '#form.nympregion#',
contactperson ='#form.contactperson#',
Email = '#form.email#',
safety = '#form.answer#'

where id = #url.updater#
</cfquery>
</cfif>

<cfif parameterexists(url.edit)>
	<cfquery name="gets" datasource="#ds#">
select * from nympsafetysubmit
where id = #url.edit#
</cfquery>


	</cfif>

<cfif parameterexists(url.post)>test
	<cfquery name="gets" datasource="#ds#">
select * from nympsafetysubmit
where id = #url.post#
</cfquery>

<cfsavecontent variable="copy">
<cfoutput>
	
#paragraphformat(gets.safety)#
<p>
#gets.businessname#<br>
#gets.address#<br>
<Cfif #gets.phone# is not ''>
	<cfset newphone = rereplace(gets.phone,'\(','','all')>
		<cfset newphone = rereplace(newphone,'\) ','-','all')>

	#newphone#<br></Cfif>
<Cfif #gets.email# is not ''><a href="mailto:#gets.email#"><br></Cfif>

<Cfif #gets.website# is not ''><a href="<cfif left(gets.website,4) is not 'http'>https://</cfif>#gets.website#" target="_new">#gets.website#</a></Cfif>
</cfoutput>
<p>


</cfsavecontent>

<Cfoutput>#copy#</Cfoutput>


<CFQUERY NAME="Insert" datasource="#ds#">
  INSERT INTO columntable
  (title,Columnnum,blurb,copy,DateSubmitted,mag,keywords,postedby,hottopic)
  VALUES ('#gets.headline#',2105,'#gets.safety#','#copy#',#CurrentDateTime#,5,'','#getuser.member#',0)
</CFQUERY>


<cfquery name="gettop" datasource="#ds#">
select *
from columntable
order by id desc
limit 0,1
</cfquery>


<cfquery name=addphoto datasource="#ds#">
INSERT INTO regionstable (colid,regionsid)
VALUES	(#gettop.id#,307)
</cfquery>

<cflocation url="editcol3335.cfm?id=#gettop.id#&mag=5&topr=999999" addToken="no">

	</cfif>

		<cfif parameterexists(url.edit)>
<div align="center"><font face=verdana size=+1><strong></strong></font>
<cfFORM action="addsafety.cfm?updater=#url.edit#" method="post"  enctype="multipart/form-data">

   <table width=100% cellspacing=5 cellpadding=5 border=1>





    <tr><td style="padding:4px;">
	  <b><font SIZE="-2" FACE="verdana">MICROSITE ID (optional)
  </td><td style="padding:4px;">
	  <cfinput NAME="msid" SIZE="20" required="no" value="#gets.msid#">

  </td></tr>



   <tr>
      <td style="padding:4px;" colspan=2 align="left" valign="top">
<font SIZE="-2" FACE="verdana" ><b>HEADLINE*:
</b></font><br>
        <textarea name="headline" cols="55" rows="2"  wrap="VIRTUAL"></textarea>
      </td>
    </tr>
    
   

   <tr>
      <td style="padding:4px;" colspan=2 align="left" valign="top">
<font SIZE="-2" FACE="verdana" ><b>STORY*:
</b></font><br>
        <textarea name="answer" cols="55" rows="10"  wrap="VIRTUAL"><cfoutput>#gets.safety#</cfoutput></textarea>
      </td>
    </tr>


    <form class="lst-submit experts-form1"  action="/safety/index.cfm?submit=on" method="POST" enctype="multipart/form-data" style="width:100%;">

      <div class="control-text-sw">

        <label class="control-label" for="expert-full-name">Name of Business:</label><br>
        <input type="text" class="form-control" id="expert-full-name" value="<cfoutput>#gets.businessname#</cfoutput>" name="businessname" placeholder="" required /><br>

               <label class="control-label" for="expert-contact-email">Address (street, city/neighborhood):</label>
        <input NAME="address" type="text" value="<cfoutput>#gets.address#</cfoutput>"  class="form-control"  placeholder="" required>

<br>
               <label class="control-label" for="expert-contact-email">Zip:</label><Br>
        <input NAME="zip" type="text" value="<cfoutput>#gets.zip#</cfoutput>"  class="form-control"  placeholder="" required>

<br>



        <label class="control-label" for="expert-contact-phone">Phone Number:</label><Br>
        <input  NAME="phonenumber" value="<cfoutput>#gets.phone#</cfoutput>"  type="text" class="form-control" id="expert-contact-phone" placeholder="xxx-xxx-xxxx" required>

<br>

        <label class="control-label" for="expert-contact-email">Website:</label><br>
        <input NAME="website" value="<cfoutput>#gets.website#</cfoutput>"  type="text" class="form-control" placeholder="" required><br>

    <label class="control-label" for="expert-question" style="margin-top:10px; padding-bottom:3px;">Your Region:</label><br>

<input  type="radio" name="nympregion" value="Brooklyn" <Cfif #gets.nympregion# eq 'Brooklyn'>checked</cfif>> Brooklyn<br>
<input type="radio" name="nympregion" value="Manhattan"<Cfif #gets.nympregion# eq 'Manhattan'>checked</cfif>> Manhattan<br>
<input  type="radio" name="nympregion" value="Nassau"<Cfif #gets.nympregion# eq 'Nassau'>checked</cfif>> Nassau<br>
<input  type="radio" name="nympregion" value="Queens"<Cfif #gets.nympregion# eq 'Queens'>checked</cfif>> Queens<br>
<input  type="radio" name="nympregion" value="Rockland &middot; Bergen" <Cfif #gets.nympregion# contains 'Rockland'>checked</cfif>> Rockland &middot; Bergen<br>
<input  type="radio" name="nympregion" value="Suffolk"<Cfif #gets.nympregion# eq 'Suffokl'>checked</cfif>> Suffolk<br>
<input  type="radio" name="nympregion" value="Westchester"<Cfif #gets.nympregion# eq 'Westchester'>checked</cfif>> Westchester<br>
<input  type="radio" name="nympregion" value="Staten Island"<Cfif #gets.nympregion# eq 'Staten Island'>checked</cfif>> Staten Island<br>


                           <label class="control-label" for="expert-contact-email">Contact Person:</label><br>
        <input NAME="contactperson" value="<cfoutput>#gets.contactperson#</cfoutput>"  type="text" class="form-control" placeholder="" required><br>
        
                           <label class="control-label" for="expert-contact-email">Email:</label><br>
        <input NAME="email" type="text" value="<cfoutput>#gets.email#</cfoutput>"  class="form-control" placeholder="" required><br>


   <tr><td style="padding:4px;">
	  <b><font SIZE="-2" FACE="verdana">Mark as Posted:</font></b>
  </td><td style="padding:4px;">
	  <Select name="posted">
		  <cfif #gets.posted# eq 0>			 <option value="0">No</option>

	  <option value="1">Yes</option>
	  <cfelse>	  <option value="1">Yes</option>

	  			 <option value="0">No</option>

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



 </table><br>
<center><input type="submit" Value="Update News"></center>
</cfform>

	</cfif>

<br>
<cfif parameterexists(url.posted)>
	<a href="addsafety.cfm">Show Unposted News</a><p>

	<cfelse>
<a href="addsafety.cfm?posted=1">Show Posted News</a><p>
</cfif><br>

<cfquery name="getlastquiz" datasource="#ds#" >
select *
from nympsafetysubmit
<Cfif parameterexists(url.posted)>
	where posted = 1
	<Cfelse>
where posted = 0
	</cfif>
order by id  desc
</cfquery>

<table with="653" border="1" cellpadding="4" cellspacing="0">
	<tr bgcolor="#efefef">
	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>
id</td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>

date</td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>businessname</td>

<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-2><B>address</td>
<td style="padding:4px;"><font face="Verdana, Geneva, sans-serif" size=-2><B>zip</td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>phone</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>website</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>contact</td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>email</td>
	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>
post</td>

	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2><B>
delete</td>


</tr>

<cfoutput query="Getlastquiz">
<tr>
	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
<a href="addsafety.cfm?edit=#id#">edit</a></td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
#dateformat(datetime,'m/d')#</td>

<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#businessname#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#address#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#zip#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#phone#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#website#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#contactperson#</td>
<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>#email#</td>

	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
<a href="addsafety.cfm?post=#id#">post</a></td>

	<td style="padding:4px;">
<font face="Verdana, Geneva, sans-serif" size=-2>
<a href="addsafety.cfm?delete=#id#" onclick="return confirm('Are you sure you want to delete this item?');">delete</a></td>


</tr>
</cfoutput>

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

</cfif>


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

<cfinclude template="footer.cfm">