ProductReview Example: Difference between revisions

← Older edit

ProductReview Example (view source)

Revision as of 15:14, 8 April 2020

734 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 will implemented  as a web application, [[Using the AJAX Library]] and having a datamodel [[Using DataDictionaries]] .
+The workspace is available here https://github.com/jacobandresen/ProductReview
-== Data model [[Using DataDictionaries]] ==
-=== 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
-== Application design  [[Using the AJAX Library]] ==
-==== Webservice ====
+= [[DataDictionary|Data Dictionaries]] =
-Create a AJAX WebService to call from the clientside VDF Ajax lib. This webservice will be responsible for handling the serverside calls.
+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.
-this is the point of entry on the serverside (where information will be extracted from)
+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")
-==== Session management ====
+==User==
+*UserId (Numeric)
+*LoginName (Ascii)
+*FirstName (Ascii)
+*LastName (Ascii)
+*Password (Ascii)
+*EmailAddress (Ascii)
+*Rights (Ascii)
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-*UserLogin: checking if the supplied password is correct. Use UserInfo_DD
+==Token==
-*HasRights: does the logged in user have the rights to perform the chosen function. Use UserInfo_DD
+*UserId (Numeric)
+*TokenValue (Ascii)
+*LastAccessed (Date)
-==== [[Using AJAX Web Browser Objects]] ====
+==Shop==
-*item.wo : handling information about items.
+*ShopId (Numeric)
-*userinfo.wo : handling information about users
+*Name (Ascii)
-*place.wo: handling info about places
+*Type (Numeric)
-*purchase.wo: handle information about places
+*Description (Ascii)
-*rating.wo: handle information about ratings
+*StreetAddress (Ascii)
+*City (Ascii)
+*ZIPCode (Ascii)
+*Country (Ascii)
-The Web Object should use the corresponding data dictionaries
+==Product==
+*ProductId (Numeric)
+*Name (Ascii)
+*Type (Numeric)
+*Description (Ascii)
+*ShopId (Numeric)
+*Price (Numeric)
-==== Creating the web markup ====
+==Review==
-The web markup should be designed around forms, that evolve around the web objects.
+*ReviewId (Numeric)
+*ItemId (Numeric)
+*UserId (Numeric)
+*Rating (Numeric)
+*Comment (Ascii)
-*Item.asp: a list to choose items from
+= Implementation =
-*Rating.asp: a list of items with detailed ratings. show details about related users and items.
-*Place.asp: information about a place where items can be bought.
-*RateItem.asp: a form to supply rating information about a particular item.
-*Purchase.asp: information about what items users has bought at what place
-== Implementation ==
+[[ProductReview VDF AJAX implementation]]
-== Coding the logic ==
+[[Category: Web Applications]]
-*Doing a Login page
+[[Category: Data Dictionaries]]
-*Listing items
-**Items
-**Places
-**Users
-*Supply ratings for an item