<Cfif parameterexists(url.add)>
    <cfquery name=addphoto datasource="#ds#">
INSERT INTO cgdirectorycoupons(companyname,couponcode,alloweduses,used)
VALUES	('','',0,0)
</cfquery>

<Cfquery name="Geter" dataSource="#ds#">
    select id from cgdirectorycoupons order by id desc limit 0,1
</Cfquery>

<cflocation url="cg-directory-coupon-edit.cfm?id=#geter.id#" addtoken="no" statuscode="301">
</cfif>    

<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">





<cfparam name="getsubq.subcatid" default="0">

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#><cfif session.email eq ''><cfset Session.email = -1></cfif><cfif IsDefined("Cookie.email")><cfset Session.email = Cookie.email></cfif>
<cfinclude template="header.cfm">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>


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

<cfparam name="form.ccainfo" default="">
<cfparam name="form.ccadesc" default="">
<cfparam name="form.trackingpixel" default="">
<CFQUERY datasource="#ds#">
	UPDATE cgdirectorycoupons
	SET
	companyname = '#form.companyname#',
	couponcode = '#form.couponcode#',
	alloweduses = #form.alloweduses#,
	address = '#form.address#',
	city = '#form.city#',
	state = '#form.state#',
	zip = '#form.zip#',
	used = #form.used#,
	ticketprice = #form.ticketprice#,
	allowedtickets = #form.allowedtickets#,
	usedtickets = #form.usedtickets#

	WHERE ID = #form.id#
</CFQUERY>
done

<Cflocation addtoken="no" url="cg-directory-coupon.cfm">


<cfelse>


<cfquery name="getrecord" datasource="#ds#">
select *
from cgdirectorycoupons
where id = #url.id#
</cfquery>

<cfoutput><FORM action="cg-directory-coupon-edit.cfm?edit=on&id=#url.id#" method="post" enctype="multipart/form-data"> </cfoutput>
<cfoutput><input NAME="id"  MAXLENGTH="200" TYPE="hidden" value="#url.id#">
<table>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Company Name:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="companyname" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.companyname#"></td>
</tr>


<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Coupon Code:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="couponcode" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.couponcode#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Directory Allowed Uses:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="alloweduses" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.alloweduses#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Directory Used:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="used" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.used#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Event Ticket Price:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP>
    <select name="ticketprice">
        <option value="#getrecord.ticketprice#">#getrecord.ticketprice#</option>
        <option value="0">0</option>    
        <option value="100">100</option>    
        
        </select>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Event Ticket Allowed Uses:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="allowedtickets" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.allowedtickets#"></td>
</tr>
<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Event Ticket Used:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="usedtickets" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.usedtickets#"></td>
</tr>



<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Address:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Address" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.address#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">City:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="city" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.city#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">State:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="State" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.state#"></td>
</tr>

<tr>
<td style="padding:5px;"  VALIGN=TOP><b><font face="Arial" size="+0">Zip:</font></b></td>
<td style="padding:5px;"  VALIGN=TOP><input NAME="Zip" MAXLENGTH="200" TYPE="text" SIZE="30" value="#getrecord.Zip#"></td>
</tr>



</cfoutput>

</table>


<!-- /tinyMCE -->

</td>
</tr>

</table>

</table>
<p><input type="submit" value="Submit the form">

</form></center>


</cfif>
<p>
         </div>
          </div>
        </div>
      </div>






      <!-- /.row -->

     <cfinclude template="footer.cfm">