Voting Tool

This site contains a short overview of the JSUG Voting tool hosted at googlecode. Its frontend is realized with Adobe Flex, whereas the complete backend is written in PHP.

Hard Facts

Whole communication is done via sending/parsing simple XML.

Flex Frontend

• Flex SDK 3.2
• FlexBuilder 3.0.2
• Cairngorm

PHP Backend

• PHP5
• Simple XML for parsing communication data
• FrontController
• PDO
• MySQL and SQLite implementations

Sources

You can check out the full source code by:

 # Non-members may check out a read-only working copy anonymously over HTTP.
svn checkout http://jsugvoting.googlecode.com/svn/jsugvoting-read-only 

Or just browse it via the url: http://code.google.com/p/jsugvoting/source/browse/

Data Model

+====================================================+
| user                                               |
+====================================================+
| *) user_id: INTEGER, PRIMARY KEY                   |
| *) username: VARCHAR(80)                           |
| *) password: VARCHAR(80)                           |
+----------------------------------------------------+

+====================================================+
| category                                           |
+====================================================+
|                                                    |
| *) category_id: INTEGER, PRIMARY KEY               |
| *) title: VARCHAR(255)                             |
|                                                    |
+----------------------------------------------------+

+====================================================+
| topic                                              |
+====================================================+
| *) topic_id: INTEGER, PRIMARY KEY                  |
| *) title: VARCHAR(255)                             |
+----------------------------------------------------+

+====================================================+
| offered_topic                                      |
+====================================================+
| *) offered_topic_id: INTEGER, PRIMARY KEY          |
| *) topic_id: INTEGER, REF(topic.topic_id)          |
| *) user_id: INTEGER, REF(user.user_id)             |
+----------------------------------------------------+

+====================================================+
| needed_topic                                       |
+====================================================+
| *) needed_topic_id: INTEGER, PRIMARY KEY           |
| *) topic_id: INTEGER, REF(topic.topic_id)          |
| *) category_id: INTEGER, REF(category.category_id) |
+----------------------------------------------------+

+====================================================+
| vote                                               |
+====================================================+
| *) user_id: INTEGER, REF(user.user_id)             |
| *) topic_id: INTEGER, REF(topic.topic_id)          |
+----------------------------------------------------+

Requirements

Important

• Login/Logout
• View topics + details
• Add topic
• Submit vote

Luxury

• Search ... with continuous filtering
• Use already existing wiki-users instead of separate User database table