ProductReview Example: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
No edit summary
m (Changed from Web Programming to Web Applications category)
 
(57 intermediate revisions by one other user not shown)
Line 1: Line 1:
{{underconst}}
= Introduction =


== Functionality ==
This page contains a description of an example project that can be used to study different implementation techniques using VDF as a backend.
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.


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:
To accomplish this, then users should be able to:


*login
*login
*choose an item from a list (use a [[SelectionList]] )
*choose an item from a list
*enter information about a known item  
*enter information about a known item  
**supply information about the place where an item was bought.
*supply information about the place where an item was bought.
*supply a rating of an item  
*supply a review of an item  
*Overview supplied ratings from other users
*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]] ==
= [[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.


=== Table layout ===
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")
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 .
==User==
*UserId (Numeric) 
*LoginName (Ascii)
*FirstName (Ascii)
*LastName (Ascii)
*Password (Ascii)
*EmailAddress (Ascii)
*Rights (Ascii)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


The following data dictionaries  should now be available:
==Token==
*UserId (Numeric)
*TokenValue (Ascii)
*LastAccessed (Date)


*Item_DataDictionary
==Shop==
*Place_DataDictionary
*ShopId (Numeric)
*Purchase_DataDictionary
*Name (Ascii)
*Rating_DataDictionary
*Type (Numeric)
*UserInfo_DataDictionary
*Description (Ascii)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


== Application design  [[Using the AJAX Library]] ==
==Product==
*ProductId (Numeric)
*Name (Ascii)
*Type (Numeric)
*Description (Ascii)
*ShopId (Numeric)
*Price (Numeric)


==== [[AJAX WebService Object]]  ====
==Review==
Create a [[AJAX WebService Object]] to call from the clientside VDF Ajax lib. This webservice will be responsible for handling the serverside calls.
*ReviewId (Numeric)
*ItemId (Numeric)
*UserId (Numeric)
*Rating (Numeric)
*Comment (Ascii)


this is the point of entry on the serverside (where information will be extracted from)
= Implementation =


==== [[AJAX Session management]] ====
[[ProductReview VDF AJAX implementation]]


*UserLogin: checking if the supplied password is correct. Use UserInfo_DD
[[Category: Web Applications]]
*HasRights: does the logged in user have the rights to perform the chosen function. Use UserInfo_DD
[[Category: Data Dictionaries]]
 
==== [[Using AJAX Web Browser Objects]] ====
*item.wo : handling information about items.
*userinfo.wo : handling information about users
*place.wo: handling info about places
*purchase.wo: handle information about places
*rating.wo: handle information about ratings
 
The Web Object should use the corresponding data dictionaries
 
==== Creating the asp pages ====
The web markup should be designed around forms, that evolve around the web objects.
 
 
*Item.asp: a list to choose items from
*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 ==
 
== Coding the logic ==
*Doing a Login page
*Listing items
**Items
**Places
**Users
*Supply ratings for an item
 
[[Category: Web Programming]]

Latest revision as of 15:14, 8 April 2020

Introduction

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
  • choose an item from a list
  • enter information about a known item
  • supply information about the place where an item was bought.
  • supply a review of an item
  • Overview supplied reviews from other users


The workspace is available here https://github.com/jacobandresen/ProductReview

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.

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")

User

  • UserId (Numeric)
  • LoginName (Ascii)
  • FirstName (Ascii)
  • LastName (Ascii)
  • Password (Ascii)
  • EmailAddress (Ascii)
  • Rights (Ascii)
  • StreetAddress (Ascii)
  • City (Ascii)
  • ZIPCode (Ascii)
  • Country (Ascii)

Token

  • UserId (Numeric)
  • TokenValue (Ascii)
  • LastAccessed (Date)

Shop

  • ShopId (Numeric)
  • Name (Ascii)
  • Type (Numeric)
  • Description (Ascii)
  • StreetAddress (Ascii)
  • City (Ascii)
  • ZIPCode (Ascii)
  • Country (Ascii)

Product

  • ProductId (Numeric)
  • Name (Ascii)
  • Type (Numeric)
  • Description (Ascii)
  • ShopId (Numeric)
  • Price (Numeric)

Review

  • ReviewId (Numeric)
  • ItemId (Numeric)
  • UserId (Numeric)
  • Rating (Numeric)
  • Comment (Ascii)

Implementation

ProductReview VDF AJAX implementation

Retrieved from "https://dataflex.wiki/index.php?title=ProductReview_Example&oldid=3284"