ProductReview Example: Difference between revisions

← Older edit

ProductReview Example (view source)

Revision as of 15:14, 8 April 2020

58 bytes removed , 8 April 2020

m

Changed from Web Programming to Web Applications category

Hsymington

Administrators

280

edits

@@ Line 1: / Line 1: @@
-== Functionality ==
+= Introduction =
-The overall goal is to be able to see what users think about a particular item . As an added benefit - users can also share information about where to buy the particular items.
+This page contains a description of an example project that can be used to study different implementation techniques using VDF as a backend.
+In this example the overall goal is to be able to see what users think about a particular item . As an added benefit - users can also share information about where to buy the particular items.
 To accomplish this, then users should be able to:
 *login
-*create a user account
 *choose an item from a list
 *enter information about a known item
-*supply a rating of an item
 *supply information about the place where an item was bought.
+*supply a review of an item
+*Overview supplied reviews from other users
-The system should be implemented  as a web application, [[Using the AJAX Library]] .
+The workspace is available here https://github.com/jacobandresen/ProductReview
-==Application design ==
-=== Table layout  ===
-We want to store information about users, places, purchases and known items. A user should be either a normal user or an administrator. The other tables should hold sufficient information about the items purchased and how the users liked them.
-Create these tables in the database builder and create the associated data dictionaries.
-The following data dictionaries  should now be available:
-*Item_DataDictionary
-*Place_DataDictionary
-*Purchase_DataDictionary
-*Rating_DataDictionary
-*UserInfo_DataDictionary
-TODO: insert a [[VDFStructureViewer]] image when done
+= [[DataDictionary|Data Dictionaries]] =
+We want to store information about users, places and known items. The other tables should hold sufficient information about the items and how the users liked them.
-=== Creating the webapp ===
+The following data dictionaries  should now be available (Note that attributes like "UserId" in Token implies a index  on UserId on Token and a relation to the table "User")
-==== Webservice ====
-Create a AJAX WebService to call from the clientside VDF Ajax lib. This webservice will be responsible for handling the serverside calls.
+==User==
+*UserId (Numeric)
+*LoginName (Ascii)
+*FirstName (Ascii)
+*LastName (Ascii)
+*Password (Ascii)
+*EmailAddress (Ascii)
+*Rights (Ascii)
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-==== Session management ====
+==Token==
-extending the following in cAjaxSessionManager:
+*UserId (Numeric)
+*TokenValue (Ascii)
+*LastAccessed (Date)
+==Shop==
+*ShopId (Numeric)
+*Name (Ascii)
+*Type (Numeric)
+*Description (Ascii)
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-*UserLogin: checking if the supplied password is correct
+==Product==
-*HasRights: does the logged in user have the rights to perform the chosen function?
+*ProductId (Numeric)
+*Name (Ascii)
+*Type (Numeric)
+*Description (Ascii)
+*ShopId (Numeric)
+*Price (Numeric)
-==== Creating the Web Objects ====
+==Review==
+*ReviewId (Numeric)
+*ItemId (Numeric)
+*UserId (Numeric)
+*Rating (Numeric)
+*Comment (Ascii)
-*item.wo : handling information about items
+= Implementation =
-*userinfo.wo : handling information about users
-*place.wo: handling info about places
-==== Creating the web markup ====
+[[ProductReview VDF AJAX implementation]]
-*ItemList: a list to choose items from
+[[Category: Web Applications]]
-*Ratings.asp: a list of items with detailed ratings.
+[[Category: Data Dictionaries]]
-*RateItem.asp: a form to supply rating information about a particular item.