ProductReview Example: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
mNo edit summary
mNo edit summary
Line 3: Line 3:
= Introduction =
= Introduction =


This is an example of how to create a [[AJAX]] solution using [[Visual DataFlex]].
This page describes a thought example 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.
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 10:


*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 rating of an item  

Revision as of 10:14, 15 May 2011

ProductReview Example page under construction

Introduction

This page describes a thought example 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 rating of an item
  • Overview supplied ratings from other users

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:

Address

  • Place_id
  • Name
  • StreetAddress
  • City
  • ZIPCode
  • Longitude
  • latitude

User

  • User_id
  • LoginName
  • FirstName
  • LastName
  • EmailAddress
  • Address_id
  • Rights (system user?)

Shop

  • Shop_id
  • Name
  • Type (Beer , pizza ... )
  • Description
  • Address_id

Item

  • Item_id
  • Name
  • Type (Beer, pizza, ...)
  • Description
  • Manufacturer
  • Price

Rating

  • Item_Id
  • User_id
  • Rating
  • Comment

Implementation

ProductReview VDF AJAX implementation