swift php functions

1. create 8 tables in mysql 2. create 8 classes in php 3. create 16 php functions 4. about 3-5 functions create simple forms, rest do simple database checks and cookie manipulation See deliverables and attached files for further information.

## Deliverables

1. Create 8 Tables - use exact names and types - make sure you use correct constraints and types for foreign and primary keys 2. Create 8 PHP classes 2. Implement following functions: swift_accounts - isPasswordValid(request) Takes a request and returns whether or not the password and user account name entered is valid - changePassword(request) Takes a request and changes the password given a user account name, the old password, and two new passwords which are identitical - addAcount(request) Takes a request and adds the account info, given a user name, two passwords which are identical, and an email address swift_users - displayUsers(account_id) display an HTML table of users and current swifts - changeUserPassword(request) changes the password of the user given a account name, the old password, and two new passwords which are the same - addUser(request, swiftAccountId) adds a user, given the account id, a user name, and two passwords which are the same swifts - deleteSwift(swiftId) sets the swift to deleted in in the db - addSwift(request) adds a swift with the following info: swift_quantity, swift_number, swift_value, swift_group_id, swift_time, swift_user_id PageController - displaySwiftListTable(account_id) - display a table with all of the info in the following order: swift_id, swift_user_name, swift_name, swift_time, swift_value, swift_current_value, swift_quantity, swift_expriy, swift_status_name, swift_locale_name, swift_currency_name, swift_type_name, swift_owner, swift_group_name, swift_number. Make sure you do the appropiate joins to get the name values. - displayAddUserForm() - displays a form for the add user function above: note that this form must work with above function - displayAddAccountForm() - display a form for the addacount function above : note that this form must work with above function - displayAddSwiftForm(account_id) - display a form for the add swift function above : note that this form must work with above function - note that there should be drop downs for the following, tied to the currenct account: groups, users, dependency (list of non expired, no deleted swifts, by name) - login(request) validates password and sets account_id in cookie - logout() erases cookie - displayLoginForm() displays form to work with function above - getAccountIdFromCookies() gets cookie val 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Monday Aug 7, 2006 8:59:27 AM:

Please ignore text below "ideas for a user interface". Those are just random notes for un related projects :)

## Platform

php / mysql

Ingegneria MySQL PHP Architettura Software Testare Software

Rif. progetto: #3702103

Info sul progetto