API tools faq
paste
Guest User

Untitled

a guest
Aug 23rd, 2017
38
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 51.29 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <link href="styles.css" rel="stylesheet" type="text/css">
  3. <cfinclude template="tooltip.cfm">
  4.  
  5.  
  6. <style type="text/css">
  7. body {
  8. background-color: #FFF;
  9. }
  10. </style>
  11.  
  12. <link href="cal/calendar.css" rel="stylesheet" type="text/css" />
  13.  
  14. <script type="text/javascript" src="cal/jquery-1.3.2.min.js"></script>
  15. <script type="text/javascript" src="cal/calscript.js"></script>
  16.  
  17. <script type="text/javascript">
  18.  
  19. jQuery(document).ready(function () {
  20.  
  21. $('input.one').simpleDatepicker();
  22. $('input.two').simpleDatepicker({ startdate: 2011, enddate: 2015 });
  23. $('input.three').simpleDatepicker({ chosendate: '9/9/2010', startdate: '6/10/2008', enddate: '7/20/2011' });
  24. $('input.four').simpleDatepicker({ x: 45, y: 3 });
  25. });
  26. </script>
  27.  
  28.  
  29. <cfoutput>
  30.  
  31. <cfparam name="reskey" default="#RAND()*100000000#">
  32.  
  33. <CFIF IsDefined("Modify") AND Modify EQ "FINALIZE RENTAL">
  34.  
  35. <CFIF NOT IsDefined("location_state") OR Len(location_state) EQ 0>
  36. <CFSET message = "You have not selected a state. Please choose a state for your rental.">
  37. <CFSET skip = "yes">
  38. <CFELSEIF NOT IsDefined("locationid") OR Len(locationid) EQ 0>
  39. <CFSET message = "You have not selected a lake location. Please choose a lake location for your rental.">
  40. <CFSET skip = "yes">
  41. <CFELSEIF NOT IsDefined("rental_reservedate") OR Len(rental_reservedate) EQ 0>
  42. <CFSET message = "You have not selected a rental date. Please choose a date for your rental.">
  43. <CFSET skip = "yes">
  44. <CFELSEIF NOT IsDefined("craftid") OR Len(craftid) EQ 0>
  45. <CFSET message = "You have not selected a watercraft. Please choose an available watercraft from one of the time slots.">
  46. <CFSET skip = "yes">
  47. <CFELSEIF NOT IsDefined("rental_endtime") OR Len(rental_endtime) EQ 0>
  48. <CFSET message = "You have not selected an END-TIME for your reservation. Please choose an available END-TIME.">
  49. <CFSET skip = "yes">
  50. <CFELSEIF (IsDefined("rental_starttime") AND IsDefined("rental_endtime") AND IsDefined("var.tframe")) AND (var.tframe EQ 4 AND (rental_starttime NEQ "2:00 PM" AND rental_starttime NEQ "9:00 AM"))>
  51. <CFSET message = "Half-Day Rentals (4 hr. rentals) may only start at 9am or 2pm. Please revise your rental time.">
  52. <CFSET skip = "yes">
  53. <CFELSEIF NOT IsDefined("rental_renter_first") OR Len(rental_renter_first) EQ 0 OR Len(rental_renter_last) EQ 0 OR Len(rental_renter_address) EQ 0 OR Len(rental_renter_state) EQ 0 OR Len(rental_renter_city) EQ 0 OR Len(rental_renter_zip) EQ 0 OR Len(rental_renter_email) EQ 0 OR Len(rental_renter_phone) EQ 0>
  54. <CFSET message = "You missed a field marked with a RED Astrick (*) in the Customer Section. Please complete the Customer Section ENTIRELY.">
  55. <CFSET skip = "yes">
  56. <CFELSEIF Len(renterid) EQ 0 AND (Len(rental_renter_login) EQ 0 OR Len(rental_renter_password) EQ 0)>
  57. <CFSET message = "You did not enter a username or password in the Customer Section. Please complete this information.">
  58. <CFSET skip = "yes">
  59. <CFELSEIF IsDefined("cardid") AND Len(cardid) EQ 0 AND Len(card_number) EQ 0>
  60. <CFSET message = "Please enter your credit card number, or, if available, select a credit card from the list.">
  61. <CFSET skip = "yes">
  62. <CFELSEIF NOT IsDefined("cardid") AND Len(card_number) EQ 0>
  63. <CFSET message = "Please enter your credit card number.">
  64. <CFSET skip = "yes">
  65. <CFELSEIF NOT IsDefined("cardid") AND Len(card_exp) EQ 0>
  66. <CFSET message = "Please enter your credit card expiration date.">
  67. <CFSET skip = "yes">
  68. <CFELSEIF NOT IsDefined("cardid") AND Len(card_cvv) EQ 0>
  69. <CFSET message = "Please enter your credit card security code.">
  70. <CFSET skip = "yes">
  71. </CFIF>
  72.  
  73. <CFIF Len(renterid) EQ 0 AND NOT IsDefined("skip")>
  74. <cfquery name="finddup" datasource="#dsn#" >
  75. SELECT *
  76. FROM renter
  77. WHERE renter_login = '#rental_renter_login#'
  78. </cfquery>
  79. <CFIF finddup.recordcount GT 0>
  80. <CFSET message = "Unfortunately, this username is already in use. Please choose another username.">
  81. <CFSET skip = "yes">
  82. </CFIF>
  83. </CFIF>
  84. <CFIF NOT IsDefined("skip")>
  85. <cfquery name="setcoid" datasource="#dsn#" >
  86. SELECT *
  87. FROM Craft
  88. WHERE craftid = '#craftid#' AND (craft_status = 'Active' OR craft_status IS NULL)
  89. </cfquery>
  90. <cfquery name="chksched" datasource="#dsn#" >
  91. SELECT *
  92. FROM Rental
  93. WHERE craftid = '#craftid#' AND rental_reservedate <= '#rental_reservedate#' AND rental_reservedate >= '#rental_reservedate#' AND rental_canceldate IS NULL AND rental_starttime = '#rental_starttime#'
  94. </cfquery>
  95. <CFIF chksched.recordcount GT 0>
  96. <CFSET message = "Unfortunately, this craft was reserved by another customer before you were able to complete your reservation. Please choose another time available.">
  97. <CFSET availcraft = "View Other Times">
  98. <CFELSE>
  99. <CFIF (IsDefined("cardid") AND Len(cardid) GT 0 AND trans_amount GT 0)>
  100. <cfinclude template="office/payment.cfm">
  101. <CFELSEIF Len(card_number) GT 0>
  102. <CFSET ccencrypt = "#Encrypt(card_number,variable.ekey)#">
  103. <cfquery name="dupcc" datasource="#DSN#" >
  104. SELECT *
  105. FROM RenterCC
  106. WHERE card_number = '#ccencrypt#'
  107. </cfquery>
  108. <CFIF dupcc.recordcount EQ 1>
  109. <CFSET form.cardid = "#dupcc.cardid#">
  110. <CFIF dupcc.card_exp NEQ form.card_exp>
  111. <cfupdate tablename="RenterCC" datasource="#DSN#" formfields="cardid,card_exp">
  112. </CFIF>
  113. <CFIF dupcc.card_cvv NEQ form.card_cvv>
  114. <CFSET form.card_cvv = "#Encrypt(card_cvv,variable.ekey)#">
  115. <cfupdate tablename="RenterCC" datasource="#DSN#" formfields="cardid,card_cvv">
  116. </CFIF>
  117. <cfinclude template="office/payment.cfm">
  118. <CFELSE>
  119. <CFIF Left(card_number,1) EQ 3>
  120. <CFSET form.card_type = "AmEx">
  121. <CFELSEIF Left(card_number,1) EQ 4>
  122. <CFSET form.card_type = "Visa">
  123. <CFELSEIF Left(card_number,1) EQ 5>
  124. <CFSET form.card_type = "MC">
  125. <CFELSEIF Left(card_number,1) EQ 6>
  126. <CFSET form.card_type = "Disc">
  127. </CFIF>
  128. <CFSET form.card_number = "#Encrypt(card_number,variable.ekey)#">
  129. <CFSET form.card_cvv = "#Encrypt(card_cvv,variable.ekey)#">
  130. <cfinsert tablename="RenterCC" datasource="#DSN#" formfields="renterid,card_number,card_exp,card_cvv,card_bill_address,card_bill_zip,card_type,reskey">
  131. <cfinsert tablename="RenterCCold" datasource="#DSN#" formfields="renterid,card_number,card_exp,card_cvv,card_bill_address,card_bill_zip,card_type,reskey">
  132. <cfquery name="lastccid" datasource="#DSN#" >
  133. SELECT @@identity AS CardID
  134. FROM RenterCC
  135. </cfquery>
  136. <CFSET cardid = "#lastccid.cardid#">
  137. <cfinclude template="office/payment.cfm">
  138. </CFIF>
  139. </CFIF>
  140. <CFIF (IsDefined("cardid") AND Len(cardid) GT 0 AND trans_amount GT 0) AND (IsDefined("trans_status") AND (trans_status EQ "Declined" OR trans_status EQ "Error"))>
  141. <CFELSE>
  142. <CFIF Len(renterid) EQ 0>
  143. <CFSET form.renter_first = "#rental_renter_first#">
  144. <CFSET form.renter_last = "#rental_renter_last#">
  145. <CFSET form.renter_email = "#rental_renter_email#">
  146. <CFSET form.renter_phone = "#rental_renter_phone#">
  147. <CFSET form.renter_address = "#rental_renter_address#">
  148. <CFSET form.renter_city = "#rental_renter_city#">
  149. <CFSET form.renter_state = "#rental_renter_state#">
  150. <CFSET form.renter_zip = "#rental_renter_zip#">
  151. <CFSET form.companyid = "#setcoid.companyid#">
  152. <CFSET form.renter_login = "#rental_renter_login#">
  153. <CFSET form.renter_password = "#rental_renter_password#">
  154. <cfinsert tablename="Renter" datasource="#DSN#" formfields="companyid,renter_first,renter_last,renter_email,renter_phone,renter_address,renter_city,renter_state,renter_zip,renter_login,renter_password">
  155. <cfquery name="lastrenterid" datasource="#DSN#" >
  156. SELECT @@identity AS RenterID
  157. FROM Renter
  158. </cfquery>
  159. <CFSET form.renterid = "#lastrenterid.renterid#">
  160. <CFSET sendlogin = "">
  161. <cfquery name="updatecard" datasource="#DSN#" >
  162. UPDATE RenterCC
  163. SET renterid = '#form.renterid#', reskey = ''
  164. WHERE reskey = '#reskey#'
  165. </cfquery>
  166. </CFIF>
  167. <CFSET form.companyid = "#setcoid.companyid#">
  168. <cfinsert tablename="Rental" datasource="#DSN#" formfields="companyid,renterid,craftid,locationid,rental_bookdate,rental_reservedate,rental_starttime,rental_endtime,rental_notes,rental_last_mod,rental_renter_first,rental_renter_last,rental_renter_email,rental_renter_phone,rental_renter_address,rental_renter_city,rental_renter_state,rental_renter_zip,rental_rate,rental_tframe">
  169. <cfquery name="lastid" datasource="#DSN#" >
  170. SELECT @@identity AS Rentalid
  171. FROM Rental
  172. </cfquery>
  173. <CFIF IsDefined("transid") AND Len(transid) GT 0>
  174. <CFSET form.transid = "#transid#">
  175. <CFSET form.rentalid = "#lastid.rentalid#">
  176. <cfupdate tablename="trans" datasource="#dsn#"
  177. formfields="transid,rentalid">
  178. </CFIF>
  179.  
  180. <CFSET Rentalid = "#lastid.Rentalid#">
  181. <CFSET search = "">
  182. <CFSET modtype = "Update">
  183. <CFSET message = "Reservation has been added.">
  184.  
  185. <CFSET sendconfirmation = "">
  186.  
  187. <cfinclude template="email.cfm">
  188. >
  189. <cflocation url="confirmation.cfm?rentalid=#rentalid#&rental_reservedate=#rental_reservedate#&renterid=#renterid#&location_state=#location_state#&locationid=#locationid#">
  190. </CFIF>
  191. </CFIF>
  192. </CFIF>
  193. </CFIF>
  194.  
  195.  
  196. <cfform name="modify" method="post" action="#cgi.SCRIPT_NAME#?page=Reserve##reservetop" onsubmit="return ray.ajax()">
  197. <table width="750" border="0" align="center" cellspacing="0">
  198.  
  199. <CFSET colname = "renterid,locationid,craftid,craft_type,location_state,rental_starttime,rental_endtime,rental_reservedate_opt,prevrenterid,rental_comp">
  200.  
  201. <CFLOOP list="#colname#" index="c">
  202. <cfparam name="form.#c#" default="">
  203. </CFLOOP>
  204.  
  205. <cfparam name="form.rental_reservedate" default="#DateFormat(Now(),"mm/dd/yyyy")#">
  206.  
  207. <cfparam name="watercraftcount" default="">
  208.  
  209. <CFIF DateFormat(form.rental_reservedate,"m/d/yy") LT DateFormat(Now(),"m/d/yy")>
  210. <CFSET message="The rental date can not be prior to today's date.">
  211. <CFSET form.rental_reservedate = "#DateFormat(Now(),"m/d/yy")#">
  212. </CFIF>
  213.  
  214. <cfquery name="states" datasource="#dsn#" >
  215. SELECT DISTINCT location_state
  216. FROM Location
  217. WHERE companyid = '#session.companyid#'
  218. </cfquery>
  219.  
  220. <cfquery name="selco" datasource="#dsn#" >
  221. SELECT *
  222. FROM Company
  223. WHERE companyid = '#session.companyid#'
  224. </cfquery>
  225.  
  226.  
  227.  
  228.  
  229. <cfquery name="locs" datasource="#dsn#" >
  230. SELECT *
  231. FROM Location
  232. WHERE locationid > 0 AND (location_status = 'Active' OR location_status IS NULL) AND companyid = '#session.companyid#' AND location_state = '#location_state#'
  233. </cfquery>
  234.  
  235. <cfquery name="loc" datasource="#dsn#" >
  236. SELECT *
  237. FROM Location
  238. </cfquery>
  239.  
  240. <cfquery name="ctypes" datasource="#dsn#" >
  241. SELECT DISTINCT craft_type
  242. FROM Craft
  243. WHERE companyid = '#session.companyid#' AND (craft_status = 'Active' OR craft_status IS NULL)
  244. </cfquery>
  245.  
  246. <cfquery name="othercrafts" datasource="#dsn#" >
  247. SELECT *
  248. FROM Craft
  249. WHERE companyid = '#session.companyid#' AND (craft_status = 'Active' OR craft_status IS NULL)
  250. ORDER BY craft_type,craft_name
  251. </cfquery>
  252.  
  253. <cfquery name="craft" datasource="#dsn#" >
  254. SELECT *
  255. FROM Craft
  256. WHERE <CFIF IsDefined("othercraftid")>craftid = '#othercraftid#'<CFELSE>craftid = '#craftid#'</CFIF> AND (craft_status = 'Active' OR craft_status IS NULL)
  257. </cfquery>
  258.  
  259. <CFSET var.companyid = "#craft.companyid#">
  260.  
  261. <CFLOOP from="9" to="16" index="t">
  262. <cfparam name="craftid#t#" default="">
  263. </CFLOOP>
  264.  
  265. <CFIF Len(craftid) EQ 0>
  266. <CFLOOP from="9" to="16" index="t">
  267. <CFSET selcraftid = "#Evaluate("craftid" & t)#">
  268. <CFIF Len(selcraftid) GT 0>
  269. <CFSET craftid = "#selcraftid#">
  270. <CFSET rental_starttime = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  271. </CFIF>
  272. </CFLOOP>
  273. <CFELSEIF IsDefined("availcraft")>
  274. <CFSET form.craftid = "">
  275. <CFSET form.rental_starttime = "">
  276. </CFIF>
  277.  
  278.  
  279. <!---
  280. EXCEED DIGITAL ADDED THIS ON 6-27-11
  281. Find out if the date is a premium date or not --->
  282. <cfquery name="holiday" datasource="#dsn#" >
  283. SELECT *
  284. FROM holiday
  285. WHERE companyid = '#session.companyid#'
  286. </cfquery>
  287. <CFSET dateIsAHoliday = "no">
  288. <CFSET holidaydates = "">
  289. <CFLOOP query="holiday">
  290. <CFLOOP list="#holiday_dates#" index="d">
  291. <CFSET holidaydates = ListAppend(holidaydates,d)>
  292. </CFLOOP>
  293. </CFLOOP>
  294.  
  295. <CFIF ListContains(holidaydates,DateFormat(rental_reservedate,"mm/dd/yyyy"))>
  296. <CFSET dateIsAHoliday = "yes">
  297. </CFIF>
  298.  
  299. <CFSET dateIsAWeekend = "no">
  300. <CFIF dayofweek(rental_reservedate) eq 7 or dayofweek(rental_reservedate) eq 1>
  301. <CFSET dateIsAWeekend = "yes">
  302. </CFIF>
  303.  
  304. <CFIF dateIsAHoliday eq "yes" OR dateIsAWeekend eq "yes">
  305. <CFSET dateIsPremium = "yes">
  306. <CFELSE>
  307. <CFSET dateIsPremium = "no">
  308. </CFIF>
  309. <!--- End Find out if the date is a premium date or not --->
  310.  
  311. <tr>
  312. <td valign="top">
  313. <table width="750" border="0" align="center" cellpadding="0" cellspacing="4" class="style3">
  314. <tr>
  315. <td align="center" class="style7">
  316. <a name="reservetop"></a>
  317. <b>
  318. <u>Make A Reservation with <cfoutput>#selco.company#</cfoutput></u>
  319. </b></td>
  320. </tr>
  321. <CFIF IsDefined("message")>
  322. <tr>
  323. <td align="center" valign="top" style="padding:6px; border:thin solid red; background-color:yellow" class="style2" colspan="2"><strong>#message#</strong></td>
  324. </tr>
  325. </CFIF>
  326. <CFIF IsDefined("trans_message")>
  327. <tr>
  328. <td align="center" valign="top" style="padding:6px; border:thin solid #trans_bg#" class="style2" colspan="2"><strong>#trans_message#</strong>
  329. <br>
  330. #trans_response#</td>
  331. </tr>
  332. </CFIF>
  333.  
  334.  
  335.  
  336.  
  337.  
  338. <!--- start step 1 --->
  339.  
  340. <cfquery name="getenabletoggle" datasource="#dsn#">
  341. select co_enable_reservations
  342. from company
  343. where companyid = 2
  344. </cfquery>
  345.  
  346. <cfif cgi.remote_addr eq "100.37.136.208">
  347. <cfset getenabletoggle.co_enable_reservations = 1>
  348. </cfif>
  349.  
  350. <cfif getenabletoggle.co_enable_reservations eq 1>
  351. <tr>
  352. <td align="left" class="style2">
  353. <table width="100%" border="0" cellpadding="4" cellspacing="0" class="style2" style="border:thin solid green">
  354. <tr>
  355. <td colspan="2" valign="top">
  356. <div align="left"><a href="##" data-tooltip="step1">How To Use This Section?</a></div>
  357. <strong><u><img src="/images/steps-01.jpg" width="44" height="46" align="absmiddle" />FIND YOUR WATERCRAFT</u></strong>
  358. </td>
  359. <td width="47%" align="right" valign="top">
  360.  
  361. <CFIF locationid neq "">
  362. <!--- <strong><u><a href="##" data-tooltip="sticky" onclick="window.open('rentalrates.cfm?locationid=#locationid#','add element','width=500,height=600,location=no,menubar=no,status=no,titlebar=no,toolbar=no,scrollbars=yes')">Watercraft Rental Prices<img src="images/icon_price.png" alt="" border="0" align="absmiddle" /></a></u></strong>--->
  363.  
  364. <strong><u><a href="##" data-tooltip="sticky">Watercraft Rental Prices<img src="images/icon_price.png" alt="" border="0" align="absmiddle" /></a></u></strong>
  365.  
  366. </CFIF>
  367.  
  368. </td>
  369. </tr>
  370. <tr>
  371. <td width="13%" valign="top"><strong>State:</strong></td>
  372. <td colspan="2" valign="top"><strong>
  373. <cfselect name="location_state" class="style3" id="location_state" onChange="javascript: submit();return ray.ajax()">
  374. <CFIF Len(location_state) GT 0>
  375. <option value="#location_state#">#ListGetAt(statename,ListFind(statecode,location_state))#</option>
  376. <CFELSE>
  377. <option value="">Select State...</option>
  378. </CFIF>
  379. <CFLOOP query="states">
  380. <CFIF location_state NEQ form.location_state>
  381. <option value="#location_state#">#ListGetAt(statename,ListFind(statecode,location_state))#</option>
  382. </CFIF>
  383. </CFLOOP>
  384. </cfselect>
  385. </strong></td>
  386. </tr>
  387. <tr>
  388. <td valign="top"><strong>Lake Location:</strong></td>
  389. <td colspan="2" valign="top"><strong>
  390. <cfselect name="locationid" class="style3" id="locationid" onChange="javascript: submit();return ray.ajax()">
  391. <CFIF Len(locationid) EQ 0>
  392. <option value="">Select Location...</option>
  393. </CFIF>
  394. <CFLOOP query="locs">
  395. <CFIF locationid NEQ form.locationid>
  396. <option value="#locationid#">#location_name#</option>
  397. <CFELSE>
  398. <option value="#locationid#" SELECTED>#loc.location_name#</option>
  399. </CFIF>
  400. </CFLOOP>
  401. </cfselect>
  402. </strong></td>
  403. </tr>
  404. <tr>
  405. <td valign="top"><strong>Rental Date:</strong></td>
  406. <td colspan="2" valign="top">
  407. <cfinput type="text" name="rental_reservedate" class="one" style="font-size:14px" id="rental_reservedate" value="#form.rental_reservedate#" size="15" onChange="javascript: submit();return ray.ajax()">
  408. <cfinput type="submit" name="seldate" class="style3" value="Select">
  409. <span style="padding:4px; color:red"><--- BE SURE TO CLICK "SELECT" AFTER CHOOSING A DATE.</span></td>
  410. </tr>
  411. <CFIF DateFormat(CreateODBCDate(form.rental_reservedate),"m/d/yy") GTE DateFormat(CreateODBCDate(Now()),"m/d/yy")>
  412. <tr>
  413. <td valign="top"><strong>Want To Rent:</strong></td>
  414. <td colspan="2" style="color:red"><strong>
  415. <cfselect name="craft_type" class="style3" id="craft_type" onChange="javascript: submit();return ray.ajax()">
  416. <CFIF Len(craft_type) GT 0>
  417. <option value="">ANY</option>
  418. <option value="#craft_type#" selected>#craft_type#</option>
  419. <CFELSE>
  420. <option value="">Select Type of Craft...</option>
  421. </CFIF>
  422. <CFLOOP query="ctypes">
  423. <CFIF craft_type NEQ form.craft_type>
  424. <option value="#craft_type#">#craft_type#</option>
  425. </CFIF>
  426. </CFLOOP>
  427. </cfselect>
  428. </strong>
  429. <strong> Pontoon boats and Ski boats are not available for 2-hour rentals on weekends and holidays.</strong>
  430. </td>
  431. </tr>
  432. <CFIF Len(location_state) EQ 0 OR Len(locationid) EQ 0>
  433. <tr>
  434. <td valign="top"> </td>
  435. <td colspan="2" valign="top" style="color:red">State, Location, and Date ABOVE must Be selected prior to viewing available watercraft.</td>
  436. </tr>
  437. <CFSET statetime = "#curtime#">
  438. <CFELSE>
  439. <cfquery name="state" datasource="#dsn#" >
  440. SELECT *
  441. FROM state
  442. WHERE state_abrev = '#location_state#'
  443. </cfquery>
  444. <CFIF state.state_timezone EQ "HST">
  445. <CFSET statetime = TimeFormat(DateAdd("h",-5,curtime),"h:mm tt")>
  446. <CFELSEIF state.state_timezone EQ "AST">
  447. <CFSET statetime = TimeFormat(DateAdd("h",-4,curtime),"h:mm tt")>
  448. <CFELSEIF state.state_timezone EQ "PST">
  449. <CFSET statetime = TimeFormat(DateAdd("h",-3,curtime),"h:mm tt")>
  450. <CFELSEIF state.state_timezone EQ "MST">
  451. <CFSET statetime = TimeFormat(DateAdd("h",-2,curtime),"h:mm tt")>
  452. <CFELSEIF state.state_timezone EQ "CST">
  453. <CFSET statetime = TimeFormat(DateAdd("h",-1,curtime),"h:mm tt")>
  454. <CFELSEIF state.state_timezone EQ "EST">
  455. <CFSET statetime = "#curtime#">
  456. </CFIF>
  457. <tr>
  458. <td valign="top"><strong>Watercraft: </strong>
  459. <br></td>
  460. <td colspan="2" valign="top">
  461. <CFIF Len(craftid) GT 0>
  462. <cfquery name="craft" datasource="#dsn#" >
  463. SELECT *
  464. FROM Craft
  465. WHERE companyid = '#session.companyid#' AND craftid = '#craftid#' AND (craft_status = 'Active' OR craft_status IS NULL)
  466. </cfquery>
  467.  
  468.  
  469.  
  470. <CFSET var.companyid = "#craft.companyid#">
  471. #UCase(craft.craft_type)#: #craft.craft_name#
  472. <cfinput type="hidden" name="craftid" id="craftid" value="#craftid#" />
  473. <cfinput type="hidden" name="rental_starttime" id="rental_starttime" value="#rental_starttime#" />
  474. <cfquery name="sched" datasource="#dsn#" >
  475. SELECT *
  476. FROM Rental r
  477. LEFT JOIN craft c
  478. ON r.craftid = c.craftid
  479. WHERE r.companyid = '#session.companyid#' AND r.craftid = '#craft.craftid#' AND (r.rental_reservedate >= #CreateODBCDateTime(rental_reservedate)# AND r.rental_reservedate <= #CreateODBCDateTime(rental_reservedate)#) AND rental_canceldate IS NULL
  480. ORDER BY r.rental_starttime
  481. </cfquery>
  482.  
  483. <CFSET startschedtime = "">
  484. <CFSET endschedtime = "">
  485. <CFLOOP query="sched">
  486. <CFLOOP from="#TimeFormat(rental_starttime,"H")#" to="#TimeFormat(DateAdd("H",-1,rental_endtime),"H")#" index="tt">
  487. <CFSET startschedtime = ListAppend(startschedtime,tt)>
  488. </CFLOOP>
  489. <CFLOOP from="#TimeFormat(DateAdd("H",1,rental_starttime),"H")#" to="#TimeFormat(rental_endtime,"H")#" index="ttt">
  490. <CFSET endschedtime = ListAppend(endschedtime,ttt)>
  491. </CFLOOP>
  492. </CFLOOP>
  493.  
  494. <CFSET notavail = "">
  495. <CFIF Len(rental_reservedate_opt) GT 0>
  496. <CFSET form.rental_reservedate = "#rental_reservedate_opt#">
  497. </CFIF>
  498.  
  499. <CFIF ListContains(startschedtime,t)>
  500. <CFSET startslotavail = "Reserved">
  501. <CFELSE>
  502. <CFSET startslotavail = "Open">
  503. </CFIF>
  504. <CFSET endtimeslot = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  505. <CFIF ListContains(endschedtime,t)>
  506. <CFSET endslotavail = "Reserved">
  507. <CFELSE>
  508. <CFSET endslotavail = "Open">
  509. </CFIF>
  510. <cfinput type="submit" name="availcraft" class="style3" id="availcraft" value="View Other Times">
  511. <CFELSE>
  512. <table width="100%" border="0" cellpadding="2" cellspacing="0" class="style2">
  513. <tr>
  514. <td width="10%"><strong>Start Time</strong></td>
  515. <td width="90%"><strong>Watercraft Available</strong></td>
  516. </tr>
  517. <CFSET watercraftcount = 0>
  518.  
  519. <CFLOOP from="9" to="16" index="t">
  520. <CFSET starttimeslot = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  521. <!--- ---><CFIF (CreateODBCDate(Now()) LT CreateODBCDate(rental_reservedate)) OR (DateFormat(Now(),"yymmdd") EQ DateFormat(rental_reservedate,"yymmdd") AND TimeFormat(statetime) LTE TimeFormat(starttimeslot))>
  522. <tr>
  523. <td valign="top">#starttimeslot#</td>
  524. <td valign="top">
  525.  
  526. <cfquery name="crafts" datasource="#dsn#" >
  527. SELECT *
  528. FROM Craft
  529. WHERE companyid = '#session.companyid#' AND locationid = '#locationid#' <CFIF Len(craft_type) GT 0>AND craft_type = '#craft_type#'</CFIF> AND (craft_status = 'Active' OR craft_status IS NULL)
  530. ORDER BY craft_type,craft_name
  531. </cfquery>
  532.  
  533.  
  534.  
  535. <cfselect name="craftid#t#" class="style2" id="craftid-#t#" onChange="javascript: submit();return ray.ajax()">
  536. <option value="">Choose...</option>
  537. <CFLOOP query="crafts">
  538. <cfquery name="sched" datasource="#dsn#" >
  539. SELECT *
  540. FROM Rental r
  541. LEFT JOIN craft c
  542. ON r.craftid = c.craftid
  543. WHERE r.companyid = '#session.companyid#' AND r.craftid = '#craftid#' AND (r.rental_reservedate >= #CreateODBCDateTime(rental_reservedate)# AND r.rental_reservedate <= #CreateODBCDateTime(rental_reservedate)#) AND rental_canceldate IS NULL
  544. ORDER BY r.rental_starttime
  545. </cfquery>
  546.  
  547.  
  548.  
  549.  
  550. <CFSET startschedtime = "">
  551. <CFSET endschedtime = "">
  552.  
  553. <CFLOOP query="sched">
  554. <CFLOOP from="#TimeFormat(rental_starttime,"H")#" to="#TimeFormat(DateAdd("H",-1,rental_endtime),"H")#" index="tt">
  555. <CFSET startschedtime = ListAppend(startschedtime,tt)>
  556. </CFLOOP>
  557.  
  558. <CFLOOP from="#TimeFormat(DateAdd("H",1,rental_starttime),"H")#" to="#TimeFormat(rental_endtime,"H")#" index="ttt">
  559. <CFSET endschedtime = ListAppend(endschedtime,ttt)>
  560. </CFLOOP>
  561. </CFLOOP>
  562.  
  563. <CFSET notavail = "">
  564. <CFIF Len(rental_reservedate_opt) GT 0>
  565. <CFSET form.rental_reservedate = "#rental_reservedate_opt#">
  566. </CFIF>
  567.  
  568. <CFIF ListContains(startschedtime,t)>
  569. <CFSET startslotavail = "Reserved">
  570. <CFELSE>
  571. <CFSET startslotavail = "Open">
  572. </CFIF>
  573.  
  574. <CFSET endtimeslot = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  575. <CFIF ListContains(endschedtime,t)>
  576. <CFSET endslotavail = "Reserved">
  577. <CFELSE>
  578. <CFSET endslotavail = "Open">
  579. </CFIF>
  580.  
  581.  
  582.  
  583.  
  584. <!--- This extra code is to fix the double bookings on all day rentals overlapping with 2 hour rentals --->
  585.  
  586.  
  587.  
  588.  
  589. <!---
  590. EXCEED DIGITAL ADDED THIS ON 6-27-11
  591. START HARD CODED EXCEPTION FOR PONTOON RENTAL TIMES MINIMUM 4 HOURS ON WEEKENDS AND HOLIDAYS --->
  592. <!--- This was added to hard code the pontoons to not be available after 2:00 PM since the feature doesn't exist in the backend --->
  593. <CFIF crafts.craft_type does not contain "Pontoon Boat">
  594.  
  595.  
  596. <CFIF startslotavail NEQ "Reserved" AND starttimeslot NEQ "5:00 pm" AND starttimeslot NEQ "6:00 pm" AND NOT ListContains(endschedtime,TimeFormat(starttimeslot,"H")+2)>
  597. <CFSET watercraftcount = watercraftcount + 1>
  598. <option value="#crafts.craftid#">#UCase(crafts.craft_type)#: #crafts.craft_name# (###crafts.craft_reg#)</option>
  599. </CFIF>
  600.  
  601. <CFELSE>
  602.  
  603. <CFIF dateIsPremium eq "yes" AND t LTE 14>
  604.  
  605.  
  606. <!--- This is where the "4" is hard coded for pontoon timeslots on the weekend or holidays so that they don't show up in the start times--->
  607. <CFIF startslotavail NEQ "Reserved" AND starttimeslot NEQ "5:00 pm" AND starttimeslot NEQ "6:00 pm" AND NOT ListContains(endschedtime,TimeFormat(starttimeslot,"H")+4)>
  608. <CFSET watercraftcount = watercraftcount + 1>
  609. <option value="#crafts.craftid#">#UCase(crafts.craft_type)#: #crafts.craft_name# (###crafts.craft_reg#)</option>
  610. </CFIF>
  611.  
  612.  
  613. <CFELSEIF dateIsPremium eq "no">
  614.  
  615.  
  616. <CFIF startslotavail NEQ "Reserved" AND starttimeslot NEQ "5:00 pm" AND starttimeslot NEQ "6:00 pm" AND NOT ListContains(endschedtime,TimeFormat(starttimeslot,"H")+2)>
  617. <CFSET watercraftcount = watercraftcount + 1>
  618. <option value="#crafts.craftid#">#UCase(crafts.craft_type)#: #crafts.craft_name# (###crafts.craft_reg#)</option>
  619. </CFIF>
  620.  
  621.  
  622. </CFIF>
  623.  
  624. </CFIF>
  625. <!--- END HARD CODED EXCEPTION FOR PONTOON RENTAL TIMES MINIMUM 4 HOURS ON WEEKENDS AND HOLIDAYS --->
  626.  
  627.  
  628.  
  629.  
  630.  
  631.  
  632. </CFLOOP>
  633. </cfselect>
  634. </td>
  635. </tr>
  636. <!------> </CFIF>
  637. </CFLOOP>
  638. </table>
  639. </CFIF>
  640. </td>
  641. </tr>
  642. </CFIF>
  643. <CFIF watercraftcount EQ 0 AND Len(craftid) EQ 0>
  644. <tr>
  645. <td valign="top"> </td>
  646. <td colspan="2" valign="top" style="color:red">No watercraft is available. Try changing your date.</td>
  647. </tr>
  648. </CFIF>
  649. <CFIF Len(craftid) GT 0>
  650. <tr>
  651. <td valign="top"><span style="padding:4px"><strong>Available Times:</strong></span></td>
  652. <td width="40%" valign="top"><table width="94%" border="0" align="center" class="style2">
  653. <tr>
  654. <td align="center"><strong>Start Time</strong></td>
  655. <td align="center"><strong style="color:RED">End Time</strong></td>
  656. </tr>
  657. <tr>
  658. <td align="center">#rental_starttime#
  659. </td>
  660. <td align="center">
  661.  
  662.  
  663. <CFIF Len(rental_starttime) GT 0>
  664.  
  665. <cfselect name="rental_endtime" class="style3" id="rental_endtime" onChange="javascript: submit();return ray.ajax()">
  666. <CFIF Len(rental_endtime) EQ 0>
  667. <option value="" selected>Select...</option>
  668. </CFIF>
  669. <CFLOOP from="9" to="18" index="t">
  670. <CFSET starttimeslot = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  671.  
  672. <CFIF ListContains(startschedtime,t)>
  673. <CFSET startslotavail = "Reserved">
  674. <CFELSE>
  675. <CFSET startslotavail = "Open">
  676. </CFIF>
  677.  
  678. <CFSET endtimeslot = "#TimeFormat(CreateTime(t,00,00),"h:mm tt")#">
  679.  
  680. <CFIF ListContains(endschedtime,t)>
  681. <CFSET endslotavail = "Reserved">
  682. <CFELSE>
  683. <CFSET endslotavail = "Open">
  684. </CFIF>
  685.  
  686.  
  687.  
  688.  
  689. <!--- This extra code is to fix the double bookings on all day rentals overlapping with 2 hour rentals only that start at 11,12,1,2 - RG 7-6-15 --->
  690. <cfif sched.recordcount GT 0>
  691. <cfif sched.craft_reg eq craft.craft_reg>
  692. <CFIF (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H")) MOD 8 IS 0>
  693. <CFSET endslotavail = "Reserved">
  694. </CFIF>
  695. </cfif>
  696. </cfif>
  697. <!--- end extra code to fix double bookings --->
  698.  
  699.  
  700.  
  701.  
  702. <CFIF endslotavail NEQ "Reserved" AND TimeFormat(endtimeslot,"H") GTE TimeFormat(rental_starttime,"H")+2
  703. AND
  704. (
  705. (
  706. (
  707. (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H"))
  708. MOD 2 IS 0
  709. )
  710. AND
  711. (
  712. (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H"))
  713. MOD 6 IS NOT 0
  714. )
  715. ) OR (TimeFormat(rental_starttime,"H") EQ 9 AND (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H"))
  716. MOD 9 IS 0)
  717. )>
  718.  
  719. <CFIF (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H")) MOD 9 IS 0>
  720. <CFSET tframe = "All Day">
  721. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H")) MOD 8 IS 0>
  722. <CFSET tframe = "8hr">
  723. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H")) MOD 4 IS 0>
  724. <CFSET tframe = "4hr">
  725. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(endtimeslot,"H")) MOD 2 IS 0>
  726. <CFSET tframe = "2hr">
  727. </CFIF>
  728. <CFIF tframe NEQ "All Day">
  729.  
  730.  
  731.  
  732.  
  733. <!---
  734. EXCEED DIGITAL ADDED THIS ON 6-27-11
  735. This is added to hard code the weekend for pontoon boats only 4 hours. No 2 hour option --->
  736. <CFIF (craft.craft_type contains "Pontoon Boat" OR craft.craft_type contains "Ski Boat") and dateIsPremium eq "yes" and tframe eq "2hr">
  737.  
  738. <!--- Do nothing --->
  739. <CFELSE>
  740. <option value="#endtimeslot#" <cfif rental_endtime eq endtimeslot>selected="selected"</cfif>>#endtimeslot# (#tframe#)</option>
  741. </CFIF>
  742.  
  743.  
  744.  
  745.  
  746.  
  747. </CFIF>
  748. </CFIF>
  749. </CFLOOP>
  750. </cfselect>
  751.  
  752. </CFIF>
  753. </td>
  754. </tr>
  755. </table></td>
  756. <td valign="top"> </td>
  757. </tr>
  758. </CFIF>
  759. </CFIF>
  760. </table></td>
  761. </tr>
  762. <tr>
  763. <td align="left" class="style2"><hr noshade size="1"></td>
  764. </tr>
  765.  
  766.  
  767. <CFELSE>
  768.  
  769. <tr>
  770. <td align="left" class="style2">
  771. <table width="100%" border="0" cellpadding="4" cellspacing="0" class="style2" style="border:thin solid green">
  772. <tr>
  773. <td colspan="2" valign="top">
  774. <div align="left"><a href="##" data-tooltip="step1">How To Use This Section?</a></div>
  775. <strong><u><img src="/images/steps-01.jpg" width="44" height="46" align="absmiddle" />FIND YOUR WATERCRAFT</u></strong>
  776. </td>
  777. <td align="right" valign="top">
  778.  
  779. </td>
  780. </tr>
  781. <tr>
  782. <td><h1 style="color:red;">Due to overwhelming demand, please call 877-312-7195 to find out availability</h1></td>
  783. </tr>
  784. </table>
  785.  
  786. </cfif>
  787.  
  788. <!--- end step 1 --->
  789.  
  790.  
  791.  
  792.  
  793. <CFIF Len(craftid) GT 0 AND Len(rental_reservedate) GT 0 AND Len(rental_endtime) GT 0>
  794. <CFIF (TimeFormat(rental_starttime,"H")-TimeFormat(rental_endtime,"H")) MOD 9 IS 0>
  795. <CFSET tframe = "All Day">
  796. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(rental_endtime,"H")) MOD 8 IS 0>
  797. <CFSET tframe = "8">
  798. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(rental_endtime,"H")) MOD 4 IS 0>
  799. <CFSET tframe = "4">
  800. <CFELSEIF (TimeFormat(rental_starttime,"H")-TimeFormat(rental_endtime,"H")) MOD 2 IS 0>
  801. <CFSET tframe = "2">
  802. </CFIF>
  803. <cfquery name="rate" datasource="#dsn#" >
  804. SELECT *
  805. FROM Rate
  806. WHERE craftid = '#craftid#' AND rate_hour = '#tframe#'
  807. </cfquery>
  808. <cfquery name="holiday" datasource="#dsn#" >
  809. SELECT *
  810. FROM holiday
  811. WHERE companyid = '#craft.companyid#'
  812. </cfquery>
  813. <CFSET holidaydates = "">
  814. <CFLOOP query="holiday">
  815. <CFLOOP list="#holiday_dates#" index="d">
  816. <CFSET holidaydates = ListAppend(holidaydates,d)>
  817. </CFLOOP>
  818. </CFLOOP>
  819. <CFSET rentalday = DayofWeek(rental_reservedate)>
  820. <CFIF ListContains(holidaydates,DateFormat(rental_reservedate,"mm/dd/yyyy")) AND Len(rate.rate_holiday) GT 0>
  821. <CFSET rental_rate = rate.rate_holiday>
  822. <CFELSEIF rentalday EQ 7 or rentalday EQ 1>
  823. <CFSET rental_rate = rate.rate_weekend>
  824. <CFELSE>
  825. <CFSET rental_rate = rate.rate_weekday>
  826. </CFIF>
  827. <cfinput type="hidden" name="rental_rate" id="rental_rate" value="#rental_rate#" />
  828. <cfinput type="hidden" name="rental_tframe" id="rental_tframe" value="#tframe#" />
  829. <CFELSE>
  830. <CFSET rental_rate = "">
  831. <CFSET tframe = "">
  832. </CFIF>
  833. <cfquery name="craft" datasource="#dsn#" >
  834. SELECT * FROM Craft WHERE craftid = '#craftid#' AND (craft_status = 'Active' OR craft_status IS NULL)
  835. </cfquery>
  836. <cfquery name="loc" datasource="#dsn#" >
  837. SELECT * FROM Location WHERE locationid = '#locationid#'
  838. </cfquery>
  839. <cfquery name="rtr" datasource="#dsn#" >
  840. SELECT * FROM Renter WHERE <CFIF IsDefined("form.renter_login")>renter_login = '#renter_login#' AND renter_password = '#renter_password#'<CFELSEIF Len(renterid) GT 0>renterid = '#renterid#'<CFELSE>renterid = ''</CFIF>
  841. </cfquery>
  842. <cfquery name="rentercard" datasource="#dsn#" >
  843. SELECT * FROM RenterCC WHERE renterid = '#renterid#' AND card_default = 'Yes'
  844. </cfquery>
  845.  
  846. <cfparam name="form.rental_notes" default="">
  847. <CFIF (IsDefined("renterid") AND Len(renterid) GT 0) OR rtr.recordcount EQ 1>
  848. <CFSET form.rental_renter_first = "#rtr.renter_first#">
  849. <CFSET form.rental_renter_last = "#rtr.renter_last#">
  850. <CFSET form.rental_renter_email = "#rtr.renter_email#">
  851. <CFSET form.rental_renter_phone = "#rtr.renter_phone#">
  852. <CFSET form.rental_renter_address = "#rtr.renter_address#">
  853. <CFSET form.rental_renter_city = "#rtr.renter_city#">
  854. <CFSET form.rental_renter_state = "#rtr.renter_state#">
  855. <CFSET form.rental_renter_zip = "#rtr.renter_zip#">
  856. <CFSET form.cardid = "">
  857. <CFSET form.renterid = "#rtr.renterid#">
  858. <CFELSE>
  859. <cfparam name="form.rental_renter_first" default="">
  860. <cfparam name="form.rental_renter_last" default="">
  861. <cfparam name="form.rental_renter_email" default="">
  862. <cfparam name="form.rental_renter_phone" default="">
  863. <cfparam name="form.rental_renter_address" default="">
  864. <cfparam name="form.rental_renter_city" default="">
  865. <cfparam name="form.rental_renter_state" default="">
  866. <cfparam name="form.rental_renter_zip" default="">
  867. <cfparam name="form.cardid" default="#rentercard.cardid#">
  868. </CFIF>
  869. <cfparam name="form.trans_amount" default="50.00">
  870. <cfparam name="form.renter_login" default="">
  871. <cfparam name="form.renter_password" default="">
  872. <cfparam name="form.rental_renter_login" default="">
  873. <cfparam name="form.rental_renter_password" default="">
  874. <cfparam name="form.card_number" default="">
  875. <cfparam name="form.card_exp" default="">
  876. <cfparam name="form.card_cvv" default="">
  877.  
  878. <cfquery name="cards" datasource="#dsn#" >
  879. SELECT * FROM RenterCC WHERE <CFIF Len(renterid) GT 0>renterid = '#renterid#'<CFELSE>reskey = '#reskey#'</CFIF>
  880. </cfquery>
  881.  
  882.  
  883. <cfquery name="cc" datasource="#dsn#" >
  884. SELECT * FROM RenterCC WHERE cardid = '#cardid#'
  885. </cfquery>
  886. <tr>
  887. <td align="left" class="style2">
  888. <table width="100%" border="0" cellpadding="4" cellspacing="0" class="style2" style="td {padding:8px}; border:thin solid blue">
  889. <tr>
  890. <td style="padding:4px">
  891. <div align="left"><a href="##" data-tooltip="step2">How To Use This Section?</a></div>
  892. <strong>
  893. <u><strong><u><strong><u><img src="images/steps-02.jpg" alt="" width="44" height="46" align="absmiddle" /></u></strong></u></strong>CUSTOMER DETAILS</u>
  894. </strong></td>
  895. <td colspan="2" align="right" style="padding:4px"><span style="color:red"><em>*</em></span><em> Required Field</em></td>
  896. </tr>
  897. <CFIF Len(renterid) EQ 0 AND NOT IsDefined("NewCust")>
  898. <tr>
  899. <td colspan="3" align="center" style="padding:4px"><strong>Returning Customer:</strong></td>
  900. </tr>
  901. <CFIF Len(renter_login) GT 0 AND rtr.recordcount EQ 0>
  902. <tr>
  903. <td colspan="3" align="center" style="padding:4px; color:red">Username/Password is incorrect. Please try again.</td>
  904. </tr>
  905. </CFIF>
  906. <tr>
  907. <td colspan="3" align="center" style="padding:4px">Username:
  908. <cfinput type="text" name="renter_login" class="style3" id="renter_login" value="#form.renter_login#" size="15">
  909. Password:
  910. <cfinput type="password" name="renter_password" class="style3" id="renter_password" value="#form.renter_password#" size="15">
  911. <cfinput type="submit" name="Login" class="style3" value="Login" onClick="return ray.ajax()"></td>
  912. </tr>
  913. <tr>
  914. <td colspan="3" align="center" style="padding:4px"><em><a href="##" onclick="window.open('servicewindow.cfm?service=Forgot','addelement','width=350,height=200,location=no,menubar=no,status=no,titlebar=no,toolbar=no')">Forgot Username or Password?</a></em></td>
  915. </tr>
  916. <tr>
  917. <td colspan="3" style="padding:4px"><hr noshade size="1"></td>
  918. </tr>
  919. <tr>
  920. <td colspan="3" align="center" style="padding:4px"><cfinput type="submit" name="NewCust" class="style3" value="I'm A New Customer"></td>
  921. </tr>
  922. <tr>
  923. <td colspan="3" style="padding:4px"><hr noshade size="1"></td>
  924. </tr>
  925. </CFIF>
  926. <CFIF Len(renterid) GT 0 OR IsDefined("NewCust")>
  927. <tr>
  928. <td colspan="3" style="padding:4px"><b>Renter Name:</b><span style="color:red">*</span></td>
  929. </tr>
  930. <tr>
  931. <td colspan="3" style="padding:4px"><cfinput type="text" name="rental_renter_first" message="Please enter a first name." required="yes" class="style3" id="rental_renter_first2" value="#form.rental_renter_first#" size="15">
  932. <cfinput type="text" name="rental_renter_last" message="Please enter a last name." required="yes" class="style3" id="rental_renter_last2" value="#form.rental_renter_last#" size="25"></td>
  933. </tr>
  934. <tr>
  935. <td style="padding:4px"><b>Address:</b><span style="color:red">*</span></td>
  936. <td colspan="2" style="padding:4px"><b>City / State / Zip:</b><span style="color:red">*</span></td>
  937. </tr>
  938. <tr>
  939. <td style="padding:4px"><b>
  940. <cfinput type="text" name="rental_renter_address" message="Please enter an address." required="yes" class="style3" id="rental_renter_address2" value="#form.rental_renter_address#" size="35">
  941. </b></td>
  942. <td colspan="2" style="padding:4px"><b>
  943. <cfinput type="text" name="rental_renter_city" message="Please enter a city." required="yes" class="style3" id="rental_renter_city2" value="#form.rental_renter_city#" size="18">
  944. ,
  945. <cfinput type="text" name="rental_renter_state" message="Please enter a state." required="yes" class="style3" id="rental_renter_state2" value="#form.rental_renter_state#" size="4">
  946. <cfinput type="text" name="rental_renter_zip" message="Please enter a zipcode." required="yes" class="style3" id="rental_renter_zip2" value="#form.rental_renter_zip#" size="10">
  947. </b></td>
  948. </tr>
  949. <tr>
  950. <td style="padding:4px"><b>Email:</b><span style="color:red">*</span></td>
  951. <td colspan="2" style="padding:4px"><b>Confirm Email:</b><span style="color:red">*</span></td>
  952. </tr>
  953. <tr>
  954. <td style="padding:4px"><b>
  955. <cfinput type="text" name="rental_renter_email" message="Please enter a valid email address." validate="email" class="style3" id="rental_renter_email" value="#form.rental_renter_email#" size="50">
  956. </b></td>
  957. <td colspan="2" style="padding:4px"><b>
  958. <cfinput type="text" name="rental_renter_confirm_email" message="Please enter a valid email address." validate="email" class="style3" id="rental_renter_confirm_email" value="#form.rental_renter_email#" size="50">
  959. </b></td>
  960. </tr>
  961. <tr>
  962. <td colspan="3" style="padding:4px"><b>Phone:</b><span style="color:red">*</span></td>
  963. </tr>
  964. <tr>
  965. <td colspan="3" style="padding:4px"><cfinput type="text" name="rental_renter_phone" message="Please enter a valid customer phone." validate="telephone" required="yes" class="style3" id="rental_renter_phone" value="#form.rental_renter_phone#" size="20"></td>
  966. </tr>
  967. <CFIF Len(renterid) EQ 0>
  968. <tr>
  969. <td colspan="3" style="padding:4px"><strong>Create Login Information:</strong><span style="color:red">*</span></td>
  970. </tr>
  971. <tr>
  972. <td colspan="3" style="padding:4px">Username:
  973. <cfinput type="text" name="rental_renter_login" class="style3" id="rental_renter_login" value="#form.rental_renter_login#" size="25" maxlength="25">
  974. Password:
  975. <cfinput type="text" name="rental_renter_password" class="style3" id="rental_renter_password" value="#form.rental_renter_password#" size="15" maxlength="10"></td>
  976. </tr>
  977. </CFIF>
  978. <CFIF NOT IsDefined("NewCust") AND cards.recordcount GT 0>
  979. <tr>
  980. <td colspan="3" style="padding:4px"><strong>Select Credit Card To Bill:</strong></td>
  981. </tr>
  982. <tr>
  983. <td colspan="3" style="padding:4px"><cfselect name="cardid" class="style3">
  984. <CFIF Len(cc.card_number) GT 0>
  985. <option value="#cc.cardid#" selected>#cc.card_type#: *-#Right(Decrypt(cc.card_number,variable.ekey),4)# (Exp. #cc.card_exp#)</option>
  986. <CFELSE>
  987. <option value="" selected>Select One...</option>
  988. </CFIF>
  989. <CFLOOP query="cards">
  990. <CFIF cc.cardid NEQ cardid>
  991. <option value="#cardid#">#card_type#: *-#Right(Decrypt(card_number,variable.ekey),4)# (Exp. #card_exp#)</option>
  992. </CFIF>
  993. </CFLOOP>
  994. </cfselect></td>
  995. </tr>
  996. </CFIF>
  997. <tr>
  998. <td colspan="3" style="padding:4px"><hr noshade size="1"></td>
  999. </tr>
  1000. <tr>
  1001. <td colspan="3" style="padding:4px"><strong>Add New Credit Card Information:</strong></td>
  1002. </tr>
  1003. <tr>
  1004. <td width="43%"><strong>Credit Card Number:</strong></td>
  1005. <td width="28%"><strong>Exp. Date: (MMYY)</strong></td>
  1006. <td width="29%"><strong>CVV Code:</strong></td>
  1007. </tr>
  1008. <tr>
  1009. <td><strong>
  1010. <cfinput type="text" name="card_number" class="style3" id="card_number" value="#form.card_number#" size="25" validate="creditcard" message="The credit card number entered is not valid.">
  1011. </strong></td>
  1012. <td><strong>
  1013. <!--- <cfinput type="text" name="card_exp" class="style3" id="card_exp" value="#form.card_exp#" size="10" validate="regular_expression" pattern="^((0[1-9])|(1[0-2]))[\/\.\-]*((1[1-9]))$" message="Your expiration date is not valid. Please verify and correct."> --->
  1014. <cfinput type="text" name="card_exp" class="style3" id="card_exp" value="#form.card_exp#" size="10">
  1015. </strong></td>
  1016. <td><strong>
  1017. <cfinput type="text" name="card_cvv" class="style3" id="card_cvv" value="#form.card_cvv#" size="5" validate="regular_expression" pattern="^([0-9]{3,4})$" message="Your security code must be 3 digits for MC,Visa,Disc - OR - 4 digits for AmEx.">
  1018. </strong></td>
  1019. </tr>
  1020. <tr>
  1021. <td colspan="3"> </td>
  1022. </tr>
  1023. </CFIF>
  1024. </table>
  1025. </td>
  1026. </tr>
  1027. <tr>
  1028. <td align="left" class="style2"><hr noshade size="1"></td>
  1029. </tr>
  1030. <tr>
  1031. <td align="left" class="style2">
  1032. <table width="100%" border="0" cellpadding="4" cellspacing="0" class="style2" style="border:thin solid red">
  1033. <tr>
  1034. <td colspan="2" style="padding:4px">
  1035. <div align="left"><a href="##" data-tooltip="step3">How To Use This Section?</a></div>
  1036. <strong><u><img src="images/steps-03.jpg" alt="" width="44" height="46" align="absmiddle" />RESERVATION CONFIRMATION DETAILS</u></strong></td>
  1037. </tr>
  1038. <tr>
  1039. <td width="34%" style="padding:4px"><b>Reservation Date:</b></td>
  1040. <td width="66%" style="padding:4px"><b>Reservation Time:</b></td>
  1041. </tr>
  1042. <tr>
  1043. <td style="padding:4px">#DateFormat(Rental_reservedate,"m/d/yy")#</td>
  1044. <td style="padding:4px">#rental_starttime# to #rental_endtime#</td>
  1045. </tr>
  1046. <tr>
  1047. <td colspan="2" style="padding:4px"><b>Location:</b></td>
  1048. </tr>
  1049. <tr>
  1050. <td colspan="2" style="padding:4px"> #loc.location_name#<span style="padding:4px; color:red">
  1051. <cfinput type="hidden" name="var.location_name" id="var.location_name" value="#loc.location_name#">
  1052. <cfinput type="hidden" name="var.location_address1" id="var.location_address1" value="#loc.location_address1#">
  1053. <cfinput type="hidden" name="var.location_address2" id="var.location_address2" value="#loc.location_address2#">
  1054. <cfinput type="hidden" name="var.location_city" id="var.location_city" value="#loc.location_city#">
  1055. <cfinput type="hidden" name="var.location_state" id="var.location_state" value="#loc.location_state#">
  1056. <cfinput type="hidden" name="var.location_zip" id="var.location_zip" value="#loc.location_zip#">
  1057. </td>
  1058. </tr>
  1059. <tr>
  1060. <td colspan="2" style="padding:4px"><b>Equipment To Rent:</b></td>
  1061. </tr>
  1062. <tr>
  1063. <td colspan="2" style="padding:4px">#craft.craft_name#
  1064. <cfinput type="hidden" name="var.craft_name" id="var.craft_name" value="#craft.craft_name#">
  1065. <cfinput type="hidden" name="var.craft_type" id="var.craft_type" value="#craft.craft_type#"></td>
  1066. </tr>
  1067. <tr>
  1068. <td colspan="2" style="padding:4px"><strong>Date Booked:</strong> #DateFormat(Now(),"m/d/yy")#</td>
  1069. </tr>
  1070. <tr>
  1071. <td colspan="2" style="padding:4px; color:red"><strong>Total Rental Rate:</strong> #rental_rate# (#tframe# Hours)
  1072. <cfinput type="hidden" name="var.tframe" id="var.tframe" value="#tframe#"></td>
  1073. </tr>
  1074. <tr>
  1075. <td colspan="2" style="padding:4px"><strong> Deposit Amount To Charge:</strong></td>
  1076. </tr>
  1077. <tr>
  1078. <td colspan="2" style="padding:4px"><b>$</b>#form.trans_amount#
  1079. <cfinput type="hidden" name="trans_amount" class="style2" id="trans_amount" value="#form.trans_amount#" size="10" readonly="true">
  1080. <cfinput type="hidden" name="trans_type" id="trans_type" value="AUTH_CAPTURE">
  1081. </b></td>
  1082. </tr>
  1083. <tr>
  1084. <td colspan="2" style="padding:4px"><b>Reservation Notes:</b></td>
  1085. </tr>
  1086. <tr>
  1087. <td colspan="2" style="padding:4px"><cftextarea name="rental_notes" cols="60" rows="3" wrap="soft" class="style3">#form.rental_notes#</cftextarea></td>
  1088. </tr>
  1089. </table>
  1090. </td>
  1091. </tr>
  1092.  
  1093. <tr>
  1094. <td align="left" class="style2"><hr noshade size="1"></td>
  1095. </tr>
  1096.  
  1097. <tr valign="top">
  1098. <td align="center">
  1099.  
  1100. <br><img src="images/steps-04.jpg" width="45" height="46" align="absmiddle" />
  1101. <br>
  1102. <cfinput type="submit" name="Modify" class="style8" style="color:blue" value="FINALIZE RENTAL">
  1103. </td>
  1104. </tr>
  1105. <tr valign="top">
  1106. <td align="left">
  1107. <cfinput type="hidden" name="companyid" id="companyid" value="#session.companyid#">
  1108. <cfinput type="hidden" name="var.co_conf_email" id="var.co_conf_email" value="#selco.co_conf_email#">
  1109. <cfinput type="hidden" name="var.company" id="var.company" value="#selco.company#">
  1110. <cfinput type="hidden" name="Rental_last_mod" id="Rental_last_mod" value="#CreateODBCDateTime(Now())#">
  1111. <cfinput type="hidden" name="Rental_bookdate" id="Rental_bookdate" value="#CreateODBCDateTime(Now())#">
  1112. <cfinput type="hidden" name="reskey" id="reskey" value="#reskey#">
  1113. <CFIF Len(renterid) GT 0>
  1114. <cfinput type="hidden" name="renterid" id="renterid" value="#renterid#">
  1115. <CFELSE>
  1116. <cfinput type="hidden" name="renterid" id="renterid" value="">
  1117. </CFIF>
  1118. <CFIF IsDefined("NewCust") AND Len(renterid) EQ 0>
  1119. <cfinput type="hidden" name="NewCust" id="NewCust" value="">
  1120. </CFIF>
  1121. </td>
  1122. </tr>
  1123. </table>
  1124. </td>
  1125. </tr>
  1126. </table>
  1127. </CFFORM>
  1128.  
  1129.  
  1130. <CFIF isdefined('crafts')>
  1131. <cfinclude template="rentalrates.cfm">
  1132. </CFIF>
  1133. </cfoutput>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!