44950 Improve user manager/db

Completado Publicado Sep 29, 2005 Pagado a la entrega
Completado Pagado a la entrega

Make numerous improvements to a working user manager. See attached image for screenshots of how the user manager works. All features are currently fully operational. The tasks are: Dealing with user input: (1) Allow option for enumerated fields. That is, fields which are drop-down menus on the CARD view. E.g, "Gender" with two options "Male" and "Female". The options should be stored in the XML configuration file. (2) Provide hooks for filtering input. For example, a "cleanNumber()" or "formatName()" option. These functions would be associated with certain fields, and if invoked, will modify the field right before it is saved. (3) Allow "Smart Groups", which are listed under "GROUPS", which are based on the current search critera, and are essentially just saved search queries. Maintenance: (4) Reconfigure code into more logically organized include files. Perhaps divide into 2-5 logical files in addition to the undo-redo code. (5) Add more documentation to the code. Managing the DB: (6) Further revise how fields are dealt with so that user can re-sequence fields immediately, without rebuilding database. Perhaps the XML file defines the field order, so that the table is only changed if the fields are renamed, added, or removed. Making mass edits: (7) Add search-replace feature which can act on specific fields, or all fields. It operates on the current search view. For example, to replace all occurrences of "Smith" with "Jones." (8) Allow more than one card to be edited at once. An "edit multiple" feature from the BROWSE dropdown menu. This is how it works: For the selected/all, allow user edit all the fields. Display a standard card view, with message "Edit fields for ALL of the selected cards." On "Update Cards", Anything empty stays the same. Anything filled will be edited for all of the selected cards. Ease of use: (9) Can we add small "Next and previous" arrows to card, which go to next or previous card for the currently remembered search. Integration: (10) Convert from direct SQLite calls to using adodblite.sourceforge.net. (11) Write some functions which can be called from other pages: getUserInfo($fieldname, $value) # returns an enumerated array of info for a user (we will have to discuss exactly how this might work) getDBFields () # returns array of fields, to be used for a stand-alone form addNewUser ( $hash ) # attempts to add a new user And make me a new page, [url removed, login to view], which uses the above fuctions. ---------- Must work in Mac Safari, as well as all major browsers. You can often test Safari using Konqueror on linux. Must work for all modern browsers: * IE 5.5+ (Windows) * Firefox 0.8+ (Windows, Mac, Linux) * Safari 1.2.4+ (Mac) * Netscape 7.1+ (Windows, Mac, Linux)* Mozilla 1.4+ (Windows, Mac, Linux) * Opera 7.5+ (Windows, Mac, Linux) You must have a robust understanding of SQL, including triggers. the db is SQLite.

JavaScript Odd Jobs PHP XML

Nº del proyecto: #1794304

Sobre el proyecto

1 propuesta Proyecto remoto Activo Jul 11, 2012

Adjudicado a:

dvinsl

The task will be completed in the terms stated above. Thank you, Dmitry.

$240 USD en 15 días
(0 comentarios)
0.0