ProductReview Example: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
← Older edit
Jka (talk | contribs)
1,134 edits
m Changed from Web Programming to Web Applications category
 
(27 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.
 
This is yet another example of how to create a [[AJAX]] solution using [[Visual DataFlex]].


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.
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.
Line 10: Line 8:


*login
*login
*choose an item from a list (use a [[AJAX Lookup List]] )
*choose an item from a list
*enter information about a known item ( [[AJAX Form]] )
*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
*Find out where to buy the requested item


= [[DataDictionary|Data Dictionaries]] =
We want to store information about users, places, purchases and known items. 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 workspace is available here https://github.com/jacobandresen/ProductReview


The following data dictionaries  should now be available:
= [[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.
==UserInfo==
*User_id
*FirstName
*LastName
*StreetAddress
*City
*ZIPCode
*EmailAddress
 
==Place==
*Place_id
*StoreName
*StreetAddress
*City
*ZIPCode
*Administrator (identify if the user is administrator)
 
==Item==
*Item_id
*Name
*Manufacturer
*Price
 
==Purchase==
*Item_id
*Place_Id
*User_id
*DateTime
*Price
 
==Rating==
*Item_Id
*User_id
*Place_Id
*Rating
 
= VDF Ajax implementation =
The implementation will be split up into Data Dictionaries, Web Service Objects  and web markup . All of these should be familiar to you if you have taken the time to look at the other examples in the VDF Ajax library
 
== [[Web Service objects]] ==
Create a [[AJAX WebService Object]] to call from the clientside VDF Ajax lib. This webservice will be responsible for handling the serverside calls.
 
The Web Service object should provide the following functionality for session management.
*UserLogin: checking if the supplied password is correct. Use UserInfo_DD
*HasRights: does the logged in user have the rights to perform the chosen function. Use UserInfo_DD
 
The HasRights function should identify whether the user is administrator or not.


== [[Using AJAX Web Browser Objects|Web Browser Objects]] ==
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")
*SessionManager.wo: Handle session related information
*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
==User==
*UserId (Numeric) 
*LoginName (Ascii)
*FirstName (Ascii)
*LastName (Ascii)
*Password (Ascii)
*EmailAddress (Ascii)
*Rights (Ascii)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


=== Access restrictions ===
==Token==
"ordinary" users should only be allowed to alter information about themselves - e.g "Joe" should not be allowed to alter the address of "Bob".
*UserId (Numeric)
only "Administrators" should be allowed to add new products and places to the database. E.g "Joe" should not be able to add all his favourite places and products to the list. "Ordinary" users should only be able to rate an item allready in the system .
*TokenValue (Ascii)
*LastAccessed (Date)


== [[How to develop ASP pages|Web markup]] ==
==Shop==
The web markup should be designed around forms, that evolve around the web objects.
*ShopId (Numeric)
*Name (Ascii)
*Type (Numeric)
*Description (Ascii)
*StreetAddress (Ascii)
*City (Ascii)
*ZIPCode (Ascii)
*Country (Ascii)


Version 1.1 of the AJAX Library has wizards to create most of this functionality.
==Product==
*ProductId (Numeric)
*Name (Ascii)
*Type (Numeric)
*Description (Ascii)
*ShopId (Numeric)
*Price (Numeric)


*login.asp: a page showing a login box
==Review==
*frontpage.asp:  display a greeting after a successfull login
*ReviewId (Numeric)
*Rating.asp: a list of items with detailed ratings. show details about related users and items.
*ItemId (Numeric)
**Should use a [[AJAX Lookup list]] to choose the item to supply a rating for
*UserId (Numeric)
**Should use a [[AJAX Form]] to supply details about the rating
*Rating (Numeric)
*RateItem.asp: a form to supply rating information about a particular item ( [[AJAX Form]] )
*Comment (Ascii)
*Item.asp: Information about an item
*Place.asp: information about a place where items can be bought ( [[AJAX Form]] )
*EditItem.asp: edit info about an item
*EditPlace.asp: edit info about a place
*EditUser.asp: edit info about a user


=== UI specifics ===
= Implementation =
*"Administrators" have a different ui than "ordinary" users.


[[ProductReview VDF AJAX implementation]]


[[Category: Web Programming]]
[[Category: Web Applications]]
[[Category: Data Dictionaries]]

Latest revision as of 14: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"