Help with Shopping Cart

shawntbanks · Dec 1, 2003

I am trying to develop a shopping cart for a classified ad site, I know now that it is going to be different than a regular retail site, because I am selling I full description and not just a item. I want to be able to have a person enter all the information about a product including 4 pictures. then I want the customer to be able to view the ad and add more if they want to before they check out. Any help would be appricated

csteinhilber · Dec 4, 2003

As for the old images still existing on your server... yes, this is to be expected (since you're using the MAKEUNIQUE attribute of your CFFILE tag... none of the old files are going to be overwritten).

You'd need to create a process manually that scans your database table and creates a list of all the images that are currently being used, then scans the images directory and deletes any files that aren't in that "used" list.

Something like:

Code:

<CFQUERY name=&quot;getImages&quot; ...>
   SELECT picture1, picture2, picture3, picture4
     FROM ...
</CFQUERY>

<CFSET lstUsedPictures = ValueList(getImages.picture1)>
<CFSET lstUsedPictures = ListAppend(&quot;#lstUsedPictures#&quot;,ValueList(getImages.picture2)>
<CFSET lstUsedPictures = ListAppend(&quot;#lstUsedPictures#&quot;,ValueList(getImages.picture3)>
<CFSET lstUsedPictures = ListAppend(&quot;#lstUsedPictures#&quot;,ValueList(getImages.picture4)>

<CFDIRECTORY action=&quot;list&quot; name=&quot;directoryFiles&quot; directory=&quot;/whateverdirectory/&quot; ...>

<CFLOOP query=&quot;directoryFiles&quot;>
   <CFIF ListFind(&quot;#lstUsedPictures#&quot;,directoryFiles.name) LTE 0>
      <CFFILE action=&quot;delete&quot; file=&quot;/whateverdirectory/#directoryFiles.name#&quot; ...>
   </CFIF>
</CFLOOP>

and then you can set up your CF scheduler to fire the process every hour or whatever and it'll clean out the directory.

-Carl

shawntbanks · Dec 8, 2003

Thanks for the reply, I have been a little tied up with some other things. I looked over the code that you have given me, and tried to make sence of it and I think that I definetly understand it a little more, still a little hairy in some places, but not bad. I incorporated my code into it and made a few adjustments, and it seems to be going good, I can't thank you enough for the help that you are giving me. when it comes to deleting and modifying an item I am starting to tackle. I put the links in to do so, but not sure on the approach to take. Here are the 3 new pages.

--------------------------------------------------------------------------------------------------

Page1.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>

<cfset today = #now()# + 1>
<cfset Todays_Date = #dateformat(today, "mm/dd/yyyy&quot

#>

<cfquery name="get_Communities" datasource="Market">
SELECT *
FROM Communities
order by location
</cfquery>

<cfquery name="get_SubCategories" datasource="Market">
SELECT Category, categoryid, subcategory, subcategoryid
FROM subandcat
</cfquery>
<cfinclude template="../Templates/Header_&_Sidebar_for_Place_Ad_Folder_Subcat_Select.cfm">
<td width="600" rowspan="2" valign="top" bgcolor="#FFFFFF">

<cfform action="Page2.cfm" method="post" enctype="multipart/form-data">
<cfoutput><input type="hidden" name="submitID" value="#createUUID()#"></cfoutput>
<input type="hidden" value="#form.select_Ad_Subcategory#" name="subcategoryid">
<input type="hidden" value="#categoryids" name="CategoryID">
<table align="center" border="0">
<tr>
<td colspan="5" class="FormHeaders"><div align="center"><font size="4" face="Georgia, Times New Roman, Times, serif">
Details</font></div></td>
</tr>
<tr bgcolor="#EDECE0"><td><font face="Georgia, Times New Roman, Times, serif">Category:</font></td>
<td valign="top" colspan="4">
<select name="select_Ad_Subcategory" onchange="whichLocal(this.form)" size="1">
<option>- Select Category-</option>

<cfoutput query="get_SubCategories" group="Category">
<option value="#Categoryid#">#Category#</option>
</cfoutput>
</select></td></tr>
<tr><td><font face="Georgia, Times New Roman, Times, serif">Subcategory:</font></td>
<td colspan="4"> <select name="selectLocal" onChange="whichLocal(this.form)" size="1">
<option>- Select SubCategory -</option>
<option></option>
<option></option>
<option></option>
<option></option>
<option></option>
<option></option>
</select></td>
</tr>

<tr bgcolor="#EDECE0">
<td><font face="Georgia, Times New Roman, Times, serif">Community:</font></td>
<td colspan="4"><font face="Georgia, Times New Roman, Times, serif">
<select name="Community_List">

<option></option>
<cfoutput query="Get_Communities">
<option value="#location#">#location#</option>
</cfoutput>
</select>
</font></td>
</tr>
<tr>
<td width="109" ><font face="Georgia, Times New Roman, Times, serif">Item
Name:</font></td>
<td colspan="4"> <font face="Georgia, Times New Roman, Times, serif">

<CFinput name="Itemname" type="text" required="no" message="Item Name Required">
</font></td>
</tr>
<tr bgcolor="#EDECE0">
<td valign="top" ><font face="Georgia, Times New Roman, Times, serif">Short
Description:</font></td>
<td colspan="4">
<textarea name="Short_description" cols="30" rows="5" wrap="hard" onChange="if (this.value.length > 100) {alert('The Short Description Cannot Be Greater Than 100 Chars.')};">Text entered here will be entered in the listings page</textarea>

</td>
</tr>
<tr>
<td valign="top" ><font face="Georgia, Times New Roman, Times, serif">Long
Description:</font></td>
<td colspan="4"><textarea name="Long_description" cols="30" rows="5">Text entered here will show up on your details page</textarea>

</td>
</tr>
<tr bgcolor="#EDECE0">
<td><font face="Georgia, Times New Roman, Times, serif">Asking
Price:</font></td>
<td colspan="4"><CFinput name="itemprice" value="" type="text" id="itemprice" required="no" message="Asking Price Required" size="20" maxlength="9">

</td>
</tr>
<tr>
<td valign="top"><font face="Georgia, Times New Roman, Times, serif"><span >Featured
Item</span><font color="#FF0000">*</font></font></td>
<td colspan="4"> <CFinput name="featured" type="radio" id="featured" value="1" checked="yes">
<font size="-2" face="Georgia, Times New Roman, Times, serif">Yes</font> </td>
<tr><td> </td><td colspan="4"><CFinput name="featured" type="radio" id="featured" value="0">
<font size="-2" face="Georgia, Times New Roman, Times, serif">No</font> </td></tr>
</tr>
<tr bgcolor="#EDECE0">
<td><font face="Georgia, Times New Roman, Times, serif">Start
Date Of Ad:</font></td>
<td colspan="4"><cfinput name="begindate" type="text" validate="date" value="#Todays_Date#">
</td>
</tr>
<tr>
<td valign="top"><font face="Georgia, Times New Roman, Times, serif">Length
Of Ad:</font></td>
<td><CFinput name="Enddate" type="radio" value="7" checked="yes"></td>
<td><font face="Georgia, Times New Roman, Times, serif">7
Days</font></td>
<tr bgcolor="#EDECE0">
<td><font face="Georgia, Times New Roman, Times, serif"> </font></td>
<td><CFinput name="Enddate" type="radio" value="30"></td>
<td><font face="Georgia, Times New Roman, Times, serif">30 Days
</font></td>
</tr></table>

<table align="center">
<tr><td colspan="5"><BR><BR><div align="center"><strong>Up to 4 pictures
can be submited with your ad</strong></div></td>
</tr>
<tr>
<td><strong>1:</strong></td>

<td colspan="4"><INPUT type="file" name="picture1" accept="image/gif,image/jpeg"></td>

</tr>
<tr>
<td><strong>2:</strong></td>
<td colspan="4"><INPUT type="file" name="picture2" accept="image/gif,image/jpeg"></td>
</tr>
<tr>
<td><strong>3:</strong></td>
<td colspan="4"><INPUT type="file" name="picture3" accept="image/gif,image/jpeg"></td>
</tr>
<tr>
<td><strong>4:</strong></td>
<td colspan="4"><INPUT type="file" name="picture4" accept="image/gif,image/jpeg"></td>
</tr></tr>
<tr bgcolor="#FFFFFF">
<td colspan="5"><div align="center">
<input type="submit" value="Continue >>">
</div></td>
</tr>
</table>

</cfform>

<tr>
<td background="../images/top_space2.gif"><img src="../images/top_space2.gif"></td>
</tr>
</table>
</td></tr>
</table>

</body>
</html>

page2.cfm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>Confirm Ad</title>

<cfquery name="Sort_categories" datasource="market">
select *
from subandcat
Where subcategoryid = #form.selectLocal#
</cfquery>
<cfinclude template="../Templates/Header_&_Sidebar_for_Place_Ad_Folder.cfm">

<td width="605" rowspan="2" valign="top" bgcolor="#FFFFFF">

<CFIF IsDefined("FORM&quot

AND IsStruct(FORM) AND NOT StructIsEmpty(FORM) AND IsDefined("FORM.submitid&quot

>


<CFSET bValidSubmit = true>

<CFLOCK timeout="30" throwontimeout="No" type="READONLY" scope="SESSION">
<CFIF IsDefined("session.submittedIDs&quot

AND ListFind("#session.submittedIDs#",FORM.submitID) GT 0>
<CFSET bValidSubmit = false>
</CFIF>
</CFLOCK>


<CFIF bValidSubmit>

<CFSET webRootDirectory = "C:\Inetpub\

http://wwwroot\website">

<CFSET pictureDirectory = "\marketingedgeinc\sale_item_Images\">
<CFSET picture1filename = "">
<CFSET picture2filename = "">
<CFSET picture3filename = "">
<CFSET picture4filename = "">


<CFIF Len(Trim(FORM.picture1)) GT 0>
<CFFILE action="UPLOAD" nameconflict="makeunique" filefield="picture1" accept="image/*" destination="#webRootDirectory##pictureDirectory#">
<CFSET picture1filename = GetFileFromPath(CFFILE.serverfile)>
</CFIF>
<CFIF Len(Trim(FORM.picture2)) GT 0>
<CFFILE action="UPLOAD" nameconflict="makeunique" filefield="picture2" accept="image/*" destination="#webRootDirectory##pictureDirectory#">
<CFSET picture2filename = GetFileFromPath(CFFILE.serverfile)>
</CFIF>
<CFIF Len(Trim(FORM.picture3)) GT 0>
<CFFILE action="UPLOAD" nameconflict="makeunique" filefield="picture2" accept="image/*" destination="#webRootDirectory##pictureDirectory#">
<CFSET picture3filename = GetFileFromPath(CFFILE.serverfile)>
</CFIF>
<CFIF Len(Trim(FORM.picture4)) GT 0>
<CFFILE action="UPLOAD" nameconflict="makeunique" filefield="picture2" accept="image/*" destination="#webRootDirectory##pictureDirectory#">
<CFSET picture4filename = GetFileFromPath(CFFILE.serverfile)>
</CFIF>

<form action="page3.cfm" method="post">

<table border="0">
<tr>
<td colspan="2"><div align="center"> <div align="center"> Here's
the ad you've submitted: </div></td>
</tr>
<tr>
<td colspan="2"><HR>
<BR>
<BR></td>
</tr>
<tr>
<td valign="bottom"><cfoutput> <input type="hidden" name="Short_Description" value="#form.Short_Description#">
<div align="left"><font face="Georgia, Times New Roman, Times, serif">Information
On </font><font size="4" face="Georgia, Times New Roman, Times, serif">#FORM.Itemname#</font></div>
<input type="hidden" name="itemname" value="#FORM.itemname#">

</cfoutput></td>
</tr>
<tr>
<td>
<tr>
<td><table border="0">
<tr>
<CFIF Len(Trim(picture1filename)) GT 0>
<td width="106">
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture1filename#" width="100" height="70" border="0">
<input type="hidden" name="picture1filename" value="#picture1filename#">
</CFOUTPUT> </td>
</cfif>
<CFIF Len(Trim(picture2filename)) GT 0>
<td width="106">
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture2filename#" width="100" height="70" border="0">
<input type="hidden" name="picture2filename" value="#picture2filename#">
</CFOUTPUT> </td>
</cfif>
<CFIF Len(Trim(picture3filename)) GT 0>
<td width="106">
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture3filename#" width="100" height="70" border="0">
<input type="hidden" name="picture3filename" value="#picture3filename#">
</CFOUTPUT> </td>
</cfif>
<CFIF Len(Trim(picture4filename)) GT 0>
<td width="106">
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture4filename#" width="100" height="70" border="0">
<input type="hidden" name="picture4filename" value="#picture4filename#">
</CFOUTPUT> </td>
</cfif>
</tr>
</table></td>
</tr>
<tr>
<td > <table>
<tr>
<td width="269" bgcolor="#339900"><strong><font size="3" face="Georgia, Times New Roman, Times, serif">Price</font></strong></td>
<td width="310" bgcolor="#339900" colspan="4"><div align="center"><font size="3" face="Georgia, Times New Roman, Times, serif"><strong>Location</strong></font></div></td>
</tr>
<cfoutput>
<tr>
<td class="FormText"><strong>#Dollarformat(form.itemPrice)#</strong></td>
<input type="hidden" name="itemprice" value="#FORM.itemprice#">
<td colspan="4"> <div align="center">#form.Community_List#</div></td>
<input type="hidden" name="location" value="#FORM.Community_List#">
</tr>
</cfoutput></table></td>
</tr>
<tr>
<td><table>
<tr><cfoutput>
<td width="361" bgcolor="EDECE0" class="LongDesc">#form.Long_description#</td>
<input type="hidden" name="long_description" value="#FORM.Long_description#">
</cfoutput>

<td width="212"><div align="center">
<p class="LongDesc">For more information, contact:<br>
<strong>

</strong></p>
</div></td>

</tr>
</table></td>
</tr>
<tr>
<TD><hr></TD>
<td></td>
</tr>
<tr>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Your
ad will run from <cfoutput><strong><u>#dateformat(form.begindate, "mm/dd/yyyy&quot

#</u> </strong> to <strong><u>#dateformat(form.begindate + form.Enddate, "mm/dd/yyyy&quot

#</u></strong></font> <input type="hidden" name="begindate" value="#form.begindate#">
<input type="hidden" name="enddate" value="#form.enddate#"></cfoutput>
</td>
</tr>
<tr>
<td><font size="2" face="Georgia, Times New Roman, Times, serif"><cfoutput>and
be placed in subcategory <strong>(#Sort_categories.Subcategory#)</strong> within category <strong>(#Sort_categories.category#)</strong>
<input type="hidden" name="select_Ad_Subcategory" value="#FORM.select_Ad_Subcategory#">
<input type="hidden" name="selectLocal" value="#FORM.selectLocal#">
<input type="hidden" name="SUB" value="#Sort_categories.Subcategory#">
</cfoutput></font></td></tr>
<tr>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Featured?
<cfif form.featured EQ 1>
<strong>Yes</strong>
<cfelse>
<strong>No </strong>
</cfif>
</font></td>
</tr>
<tr> <cfoutput>
<input type="hidden" name="featured" value="#form.featured#">
</cfoutput>
<td colspan="2"><BR>
<BR>
<HR></td>
</tr>
<CFOUTPUT>
<input type="hidden" name="submitid" value="#FORM.submitid#">
</CFOUTPUT>
<tr>
<td colspan="2" class="LongDesc"><div align="center">
<input type="submit" name="submit" value="Add to cart">
</div></td>
<CFELSE>

<table><tr><td>You've already submitted this ad. <a href="page3.cfm">Click
here</a> to view your cart.</td></tr></table> </CFIF> <CFELSE>

<CFLOCATION url="page1.cfm"> </CFIF>
</tr>
</table>

</form>

</tr>
<tr>
<td background="../images/top_space2.gif"><img src="../images/top_space2.gif"></td>
</tr>
</table>
</td></tr>
</table>

</body>
</html>


Here's the ad you've submitted:

<form action="page3.cfm" method="post">

<p>Item Name: <CFOUTPUT>#FORM.itemname#<input type="hidden" name="itemname" value="#FORM.itemname#"></CFOUTPUT></p>

<p>Category: <CFOUTPUT>#FORM.category#<input type="hidden" name="category" value="#FORM.category#"></CFOUTPUT></p>

<p>Images:<br />
<CFIF Len(Trim(picture1filename)) GT 0>
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture1filename#" width="100" height="70" border="0"><input type="hidden" name="picture1filename" value="#picture1filename#"></CFOUTPUT><br />
</CFIF>
<CFIF Len(Trim(picture2filename)) GT 0>
<CFOUTPUT><img alt="Click on picture to enlarge" src="../sale_item_Images/#picture2filename#" width="100" height="70" border="0"><input type="hidden" name="picture2filename" value="#picture2filename#"></CFOUTPUT><br />
</CFIF>
</p>

<CFOUTPUT><input type="hidden" name="submitid" value="#FORM.submitid#"></CFOUTPUT>

<input type="submit" name="submit" value="Add to cart">

</form>
<CFELSE>

You've already submitted this ad. <a href="page3.cfm">Click here</a> to view your cart.

</CFIF>
<CFELSE>

<CFLOCATION url="page1.cfm">
</CFIF>

</body>
</html>

page3.cfm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>View Shopping Cart</title>
<cfquery name="get_SubCategories" datasource="Market">
SELECT Category, categoryid, subcategory, subcategoryid
FROM subandcat
</cfquery>
<cfquery name="Fees" datasource="market">
select *
from Private_Prices
Where category_ID = #form.select_Ad_Subcategory#
</cfquery>
<cfquery name="GST" datasource="market">
select *
from taxes
Where tax = 'gst'
</cfquery>
<cfquery name="PST" datasource="market">
select *
from taxes
Where tax = 'pst'
</cfquery>
<cfset WF = 5>
<cfset MF = 10>
<cfinclude template="../Templates/Header_&_Sidebar_for_Place_Ad_Folder_Subcat_Select.cfm">
<td width="600" rowspan="2" valign="top" bgcolor="#FFFFFF">
<table align="center">

<CFIF IsDefined("FORM&quot

AND IsStruct(FORM) AND NOT StructIsEmpty(FORM) AND IsDefined("FORM.submitid&quot

>
<CFSET bValidSubmit = true>

<CFLOCK timeout="30" throwontimeout="No" type="READONLY" scope="SESSION">
<CFIF IsDefined("session.submittedIDs&quot

AND ListFind("#session.submittedIDs#",FORM.submitID) GT 0>
<CFSET bValidSubmit = false>
</CFIF>
</CFLOCK>
<CFIF bValidSubmit>
<cfquery name="Fees" datasource="market">
select * from Private_Prices Where category_ID = #form.select_Ad_Subcategory#
</cfquery>
<cfset WF = 5>
<cfset MF = 10>

<CFSET strTempItem = StructNew()>

<cfset strtempitem.listing_Fee = #fees.price#>
<cfif form.featured EQ 1 and form.Enddate EQ 7>
<cfset strtempitem.Featured_Fee = #WF#>
<cfelseif form.featured EQ 1 and form.Enddate EQ 30>
<cfset strtempitem.Featured_Fee = #MF#>
<cfelse>
<cfset strtempitem.Featured_Fee = 0>
</cfif>
<cfset strtempitem.categoryid = #form.select_Ad_Subcategory#>
<cfset strtempitem.subcategoryid = #form.selectLocal#>
<cfset strtempitem.subcategory = #form.sub#>
<cfset strtempitem.location = #form.location#>
<cfset strtempitem.itemname = #form.Itemname#>
<cfset strtempitem.Short_Description = #form.Short_Description#>
<cfset strtempitem.long_description = #form.long_description#>
<cfset strtempitem.itemprice = #form.itemprice#>
<cfset strtempitem.featured = #form.featured#>
<cfset strtempitem.begindate = #dateformat(form.begindate, "mm/dd/yyyy&quot

#>
<cfset strtempitem.Enddate = #dateformat(form.begindate + form.Enddate, "mm/dd/yyyy&quot

#>
<CFSET strTempItem.picture1 = "">
<CFSET strTempItem.picture2 = "">
<CFSET strTempItem.picture3 = "">
<CFSET strTempItem.picture4 = "">
<CFIF IsDefined("FORM.picture1filename&quot

AND Len(Trim(FORM.picture1filename)) GT 0>
<CFSET strTempItem.picture1 = FORM.picture1filename>
</CFIF>
<CFIF IsDefined("FORM.picture2filename&quot

AND Len(Trim(FORM.picture2filename)) GT 0>
<CFSET strTempItem.picture2 = FORM.picture2filename>
</CFIF>
<CFIF IsDefined("FORM.picture3filename&quot

AND Len(Trim(FORM.picture3filename)) GT 0>
<CFSET strTempItem.picture3 = FORM.picture3filename>
</CFIF>
<CFIF IsDefined("FORM.picture4filename&quot

AND Len(Trim(FORM.picture4filename)) GT 0>
<CFSET strTempItem.picture4 = FORM.picture4filename>
</CFIF>

<CFLOCK timeout="30" throwontimeout="No" type="EXCLUSIVE" scope="SESSION">
<CFIF NOT IsDefined("session.auth&quot

or NOT IsArray(session.auth)>
<CFSET session.auth = arraynew(1)>
</CFIF>
<CFSET ArrayAppend(session.auth,strTempItem)>
<CFIF NOT IsDefined("session.submittedIDs&quot

>
<CFSET session.submittedIDs = "">
</CFIF>
<CFSET session.submittedIDs = ListAppend("#session.submittedIDs#",FORM.submitID)>
</CFLOCK>
<CFELSE>

<tr>
<td><font color="#FF0000" size="2" face="Georgia, Times New Roman, Times, serif">You've
already added this item to your cart.</font></td>
</tr>
</CFIF>
</CFIF>

<tr>
<td><div align="center"><font size="2" face="Georgia, Times New Roman, Times, serif">Here's
your shopping cart:</font></div></td>
</tr>
<CFSET aryLocalArray = ArrayNew(1)>

<CFLOCK timeout="30" throwontimeout="No" type="READONLY" scope="SESSION">
<CFIF IsDefined("session.auth&quot

AND IsArray(session.auth)>
<CFSET aryLocalArray = session.auth>
</CFIF>
</CFLOCK>
</table>

<table border="0" cellpadding="5" align="center">
<tr bgcolor="#009933" style="color: #FFFFFF;">
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Item
#</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Item
Name</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Category</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Listing
Fee</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">Featured</font></td>
</tr>
<CFIF ArrayLen(aryLocalArray) GT 0>
<cfset variables.totalListing_fee = 0>
<cfset variables.totalFeatured_fee = 0>
<CFLOOP from="1" to="#ArrayLen(aryLocalArray)#" index="whichItem">
<CFOUTPUT>
<tr>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">#whichItem#</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">#aryLocalArray[whichItem].itemname#</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">#aryLocalArray[whichItem].subcategoryid#</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">#dollarformat(aryLocalArray[whichItem].Listing_fee)#</font></td>
<td><font size="2" face="Georgia, Times New Roman, Times, serif">#dollarformat(aryLocalArray[whichItem].Featured_Fee)#</font></td>
<TD><a href="modify.cfm"><font size="2" face="Georgia, Times New Roman, Times, serif">|Modify|</font></a>  <a href="Delete.cfm"><font size="2" face="Georgia, Times New Roman, Times, serif">|Delete|</font></a></TD>
</tr>
<cfset totalListing_fee = totalListing_fee + (aryLocalArray[whichItem].Listing_fee)>
<cfset totalFeatured_fee = totalFeatured_fee + (aryLocalArray[whichItem].Featured_Fee)>
</CFOUTPUT>
</CFLOOP>
<cfset Grand_Subtotal = totalListing_fee + totalFeatured_fee>
<cfset Total_GST = Grand_Subtotal * #gst.amount#>
<cfset Total_PST = (Grand_Subtotal + Total_GST) * #PST.amount#>
<cfset Total_taxes = Total_GST + Total_PST>
<cfset Grand_Total = Total_taxes + Grand_Subtotal>
<tr>
<td colspan="5"><hr></td>
</tr>
<tr>
<td></td>
<td></td>
<td><font face="Georgia, Times New Roman, Times, serif">SubTotal
Listing Fees</font></td>
<td><font face="Georgia, Times New Roman, Times, serif"><cfoutput>#Dollarformat(totalListing_fee)#</cfoutput> </font></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td><font face="Georgia, Times New Roman, Times, serif">SubTotal
Featured</font></td>
<td><font face="Georgia, Times New Roman, Times, serif"><u><cfoutput>#Dollarformat(totalFeatured_fee)#</cfoutput>     </u> </font></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td><font face="Georgia, Times New Roman, Times, serif">Grand
SubTotal </font></td>
<td><font face="Georgia, Times New Roman, Times, serif"><cfoutput>#Dollarformat(Grand_Subtotal)#</cfoutput> </font></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td><font face="Georgia, Times New Roman, Times, serif">Taxes</font></td>
<td><font face="Georgia, Times New Roman, Times, serif"><u><cfoutput>#Dollarformat(Total_Taxes)#</cfoutput>     </u> </font></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td><font face="Georgia, Times New Roman, Times, serif">Total</font></td>
<td><font face="Georgia, Times New Roman, Times, serif"><strong><cfoutput>#Dollarformat(Grand_total)#</cfoutput></strong> </font></td>
<td></td>
</tr>
<CFELSE>
<tr>
<td colspan="3">No items currently in cart</td>
</tr>
</CFIF>
</table>
<table align="center">
<tr>
<td><font size="2" face="Georgia, Times New Roman, Times, serif"><a href="page1.cfm">Click
here</a> to add a new item</font></td>
</tr>
</table>

<tr>
<td background="../images/top_space2.gif"><img src="../images/top_space2.gif"></td>
</tr>
</table>
</td></tr>
</table>

</body>
</html>

csteinhilber · Dec 8, 2003

It looks like your code was truncated... so we're not seeing the complete page 3. And, unfortunately, that's where you'd probably be implementing your edit and delete functionality.

Basically... the model is fairly straight-forward. As you're looping through the output of the cart items, you'd build links for each item... borrowing from my example above, you'd do something like:

Code:

<table border=&quot;1&quot; cellpadding=&quot;5&quot;>
<tr bgcolor=&quot;#000000&quot; style=&quot;color: #FFFFFF;&quot;><td>Item #</td><td>Item Name</td><td>Category</td><td></td><td></td></tr>
<CFIF ArrayLen(aryLocalArray) GT 0>
<CFLOOP from=&quot;1&quot; to=&quot;#ArrayLen(aryLocalArray)#&quot; index=&quot;whichItem&quot;>
    <CFOUTPUT><tr><td>#whichItem#</td><td>#aryLocalArray[whichItem].itemname#</td><td>#aryLocalArray[whichItem].category#</td>

Code:

<td><a href="edit_item.cfm?itemnum=#whichItem#">edit</a></td><td><a href="delete_item.cfm?itemnum=#whichItem#">delete</a></td>

Code:

</tr></CFOUTPUT>
</CFLOOP>
<CFELSE>
    <tr><td colspan=&quot;3&quot;>No items currently in cart</td></tr>
</CFIF>
</table>

Then, edit_item.cfm would simply populate a form that allows the user to edit the item:

Code:

<CFIF IsDefined(&quot;FORM.edititemnum&quot;)>
  <CFLOCK timeout=&quot;30&quot;    
        throwontimeout=&quot;no&quot;
        type=&quot;exclusive&quot;
        scope=&quot;session&quot;>
     <CFSET SESSION.auth2[#FORM.edititemnum#].itemname = FORM.itemname>
     <CFSET SESSION.auth2[#FORM.edititemnum#].category= FORM.category>
        :
        etc.
        :
  </CFLOCK>
  <!--- maybe to a CFLOCATION back to page3 here, if you want --->
<CFELSE>

  <CFSET strEditItem = StructNew()>  
  <CFLOCK timeout=&quot;30&quot;    
        throwontimeout=&quot;no&quot;
        type=&quot;readonly&quot;
        scope=&quot;session&quot;>
     <CFSET strEditItem = SESSION.auth2[#URL.itemnum#]>
  </CFLOCK>

  <form action=&quot;edit_item.cfm&quot; method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;>
   
  <p><CFOUTPUT>Item name: <input name=&quot;itemname&quot; type=&quot;text&quot; value=&quot;#strEditItem.itemname#&quot;></CFOUTPUT></p>

  <p>Category: 
  <select name=&quot;category&quot;>
  <option value=&quot;&quot;> - SELECT A CATEGORY - </option>
  <CFIF CompareNoCase(strEditItem.category,&quot;1&quot;) EQ 0>
     <option value=&quot;1&quot; SELECTED>
  <CFELSE>
     <option value=&quot;1&quot;>
  </CFIF>Category 1</option>
  <CFIF CompareNoCase(strEditItem.category,&quot;2&quot;) EQ 0>
     <option value=&quot;2&quot; SELECTED>
  <CFELSE>
     <option value=&quot;2&quot;>
  </CFIF>Category 2</option></select>
  </p>
     :
     :
  <CFOUTPUT><input type=&quot;hidden&quot; name=&quot;edititemnum&quot; value=&quot;#URL.itemnum#&quot;></CFOUTPUT>

  <input type=&quot;submit&quot;>
  </form>
</CFIF>

and the delete page would be even easier:

Code:

<CFIF IsDefined(&quot;FORM.edititemnum&quot;)>
  <CFLOCK timeout=&quot;30&quot;    
        throwontimeout=&quot;no&quot;
        type=&quot;exclusive&quot;
        scope=&quot;session&quot;>
     <CFSET ArrayDeleteAt(SESSION.auth2,FORM.edititemnum)>
  </CFLOCK>
  <!--- maybe to a CFLOCATION back to page3 here, if you want --->
<CFELSE>

  <CFSET strEditItem = StructNew()>  
  <CFLOCK timeout=&quot;30&quot;    
        throwontimeout=&quot;no&quot;
        type=&quot;readonly&quot;
        scope=&quot;session&quot;>
     <CFSET strEditItem = SESSION.auth2[#URL.itemnum#]>
  </CFLOCK>

  <form action=&quot;edit_item.cfm&quot; method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;>
  <p>Do you really want to delete the item
<CFOUTPUT>#strEditItem.itemname#</CFOUTPUT>?</p>

  <CFOUTPUT><input type=&quot;hidden&quot; name=&quot;edititemnum&quot; value=&quot;#URL.itemnum#&quot;></CFOUTPUT>

  <input type=&quot;submit&quot; value=&quot;Yes&quot;>
  </form>
</CFIF>

I just can't emphasize enough that you should really buy (and thoroughly read) a ColdFusion book (Web Application Construction Kit, for example, details building several different types of shopping carts). The fact that the code we're discussing is still "a little hairy" to you is a clear warning signal that you're probably not prepared enough to move forward. While you might be able to get away with cut-and-paste solutions with something like javascript, you really need to know your CFML inside and out in order to build, and more importantly customize, revise and maintain it in the future.

-Carl

shawntbanks · Dec 8, 2003

Carl,

Thanks again. I just finished school and I took computers (a+, MCP, Networking and computer applications). The company that I started working for is affiliated with the school, hench partly why I got the job. During my OJT I designed a database for the staff to track students, any thing that they needed to know about the students. It was done with Coldfusion and SQL. It impressed the manager. Now he wants an online classified ads site developed and it is entirley my project. I love everything about computers, and they know that, but in the 5-6 years that I had one (stupid me never looked at a piece of code, never made a page or anything). Well here it is about four months into my job and I am coding, I did get a couple of books (Teach Yourself Coldfusion in 24 days, Coldfuaion Bible, Web Application Construction Kit, and Core Coldfusion). As you can see no shortage of reading material. The problem being that the project that I am working on, he wants done by christmas and he thinks that after the student database, I should know all there is to know about Coldfusion (as yoiu can see, not the case). I am finding it hard to fit in studing. So as you can see the predicument that i am in, i really do appriciate the help you have given me so far. I do know a little coldfusion but not enough.

Maybe we could comunicate through email, that may be easier and that way I can send you the pages instead of cutting and pasting.

sbanks@northstarpei.com

If there is anything that I can do for you, let me know. I am proficiant in Microsoft Office and Adobe PhotoShop, and I have a coworker that knows quite a lot about computers aswell. thanks

csteinhilber · Dec 8, 2003

Thanks Shawn. I'm pretty proficient on the computer already, but I'll keep you in mind.

If you already have Web Application Construction Kit, might I turn your attention to pages 807-827. Literally 20 whole pages that talk about the considerations for designing a shopping cart, and how to build one. The included CD-ROM has a couple of examples (CF_MX_WACK:\ows\27\), and even contains the ShoppingCart CFC component that they discuss (which, alone, is probably worth 10x the price of the book... it contains functions to add, update and delete items... all the things we've been talking about here).

We've all been where you are now... faced with ridiculous deadlines on a project that's somewhat foreign in scope... but, trust me, diving straight into the code is not the way to get it done. A tight deadline is no excuse for short-cutting the design process... quite the contrary; the tighter the deadline, the more festidious you have to be with your upfront design roadmap... and the more researched your design decisions have got to be.

We could communicate via email, sending pages back and forth until you have something that's completely working (maybe even before your deadline). But I'm not really looking to be the one who writes all your code for you or solves all your problems. I'm a huge proponent of teaching someone to fish, rather than handing them a plateful of salmon. And so far, I'm really only seeing you polishing your plater, and not casting your line (okay... Carl's Late-night Case #62 of "Carrying a metaphor too far&quot

.

-Carl

shawntbanks · Dec 8, 2003

I looked in my web application construction kit and come to find out I must have a different version, I have "The Macromedia Coldfusion 5 - Web Application Construction Kit", in there i did read over the shopping cart application, and I found it no use. It seems to me that all shopping carts that I have seen deal with a store selling merchandise, so you browes the categories and hit add to cart. I find with my application I have alot of variable that have to be put into the shopping cart and I need it to do special things like 2 drop downs that are linked to one another, and adding pictures to a database(folder)and so on. I understand where you are comming from, I have been taking a lot of handouts from you. I really could use your help. If you would rather not thats ok.

csteinhilber · Dec 8, 2003

Are you running CF 5.0, or MX? The WACK I have is, indeed, ColdFusion MX. If you're running MX, I'd definitely recommend you update the book... because a great deal has changed.

If you're running CF 5.0, then, obviously, the new version of the book won't help you all that much.

While your shopping cart is storing information that, more than likely, an example will not show, example shopping carts do store information. And extending them to store the information you require is simply a matter of analyzing how they store the data they do store, and adding your own data in it's place.

Whether the subject matter is merchandise, or classified ads, it's really the same model underneath. We've already talked about how to store all the information you need in your cart (the array of structures... pretty much the same as if I were trying to store merchandise), and how to add images (or, at least filenames... it's generally a bad idea to add the actual images) to your database.

One of the things you need to understand is degrees of "separation" (or, perhaps, "abstraction&quot

. You really want to build ColdFusion apps modularly... if not for your sanity's sake, then for the sake of porting those modules to future projects. The "shopping cart" module, for example, should only be concerned with adding and maintaining data about a user's order (which is why the CFC in the MX WACK is so great... but it only works under MX). It shouldn't really care about what data you're storing to it... it should just care about indexing it, and making sure it can get at it when you tell it to edit that data.

The 2 dropdowns that are linked to one another... that's not really a function of the "shopping cart". That would be a different component of your application (say, the "user interface" module). And, in order to accomplish that, you'd want to use a combination of a query (to grab the possible values of each dropdown) and javascript (to dynamically switch out valid values based on whatever criteria). As an example of abstraction, we actually built a custom tag called "CF_LINKEDLISTS" which generically builds any number of dropdowns based on a query that I pass in as an attribute, all linked so that, when you select a value in one, it populates the correct items in the next. So, when we need a linked list, the code in that tag is abstracted enough (it doesn't care about the context) that it can be called from wherever.

I'm happy to answer whatever questions you have, or help with any errors you're getting... but, like I said, I don't think I'm keen on writing the whole thing for you.

To that end, as I said, we've already discussed how your shopping cart adds and stores items, as well as how to edit and delete items. At this point, it's a little unclear as what further issues are on the table.
Are you getting errors? Or ... ??

-Carl

shawntbanks · Dec 9, 2003

Hi Carl,

I think that I have completed most of the cart now execpt the checkout process. I was wondering if you might take a moment and look over the code and see if there are any problems.

Page 1, and page 2 have not changed.

Page3.cfm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>View Shopping Cart</title>
<cfquery name="get_SubCategories" datasource="Market">
SELECT Category, categoryid, subcategory, subcategoryid
FROM subandcat
</cfquery>
<cfparam name="form.select_Ad_Subcategory" default="1">
<cfquery name="Fees" datasource="market">
select *
from Private_Prices
Where category_ID = #form.select_Ad_Subcategory#
</cfquery>
<cfquery name="GST" datasource="market">
select *
from taxes
Where tax = 'gst'
</cfquery>
<cfquery name="PST" datasource="market">
select *
from taxes
Where tax = 'pst'
</cfquery>
<cfset WF = 5>
<cfset MF = 10>
<cfinclude template="../Templates/Header_&_Sidebar_for_Place_Ad_Folder_Subcat_Select.cfm">
<td width="600" rowspan="2" valign="top" bgcolor="#FFFFFF">
<table align="center">

<CFIF IsDefined("FORM&quot

AND IsStruct(FORM) AND NOT StructIsEmpty(FORM) AND IsDefined("FORM.submitid&quot

>
<CFSET bValidSubmit = true>

<CFLOCK timeout="30" throwontimeout="No" type="READONLY" scope="SESSION">
<CFIF IsDefined("session.submittedIDs&quot

AND ListFind("#session.submittedIDs#",FORM.submitID) GT 0>
<CFSET bValidSubmit = false>
</CFIF>
</CFLOCK>
<CFIF bValidSubmit>
<cfquery name="Fees" datasource="market">
select * from Private_Prices Where category_ID = #form.select_Ad_Subcategory#
</cfquery>
<cfset WF = 5>
<cfset MF = 10>

<CFSET strTempItem = StructNew()>

<cfset strtempitem.submitID = form.submitID>
<cfset strtempitem.categoryid = #form.select_Ad_Subcategory#>
<cfset strtempitem.subcategoryid = #form.selectLocal#>
<cfset strtempitem.subcategory = #form.sub#>
<cfset strtempitem.location = #form.location#>
<cfset strtempitem.itemname = #form.Itemname#>
<cfset strtempitem.Short_Description = #form.Short_Description#>
<cfset strtempitem.long_description = #form.long_description#>
<cfset strtempitem.itemprice = #form.itemprice#>
<cfset strtempitem.featured = #form.featured#>
<cfset strtempitem.begindate = #dateformat(form.begindate, "mm/dd/yyyy&quot