Users database manager

Users database manager is project number 214730 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Cancelled by the Site Administrator)
Selected Providers:	-
Budget:	$100-300
Created:	01/17/2008 at 9:20 EST
Bidding Ends:	01/24/2008 at 9:20 EST
Project Creator:	charles1234   Buyer Rating: (3 reviews)
Description:	The main goal of this project is to provide an easy to use interface for our support staff to search for members and update their records. When bidding please message code samples. Skills needed: php,mysql,ajax,smarty templates The data The user table consists of id,email,first name, last name and status Bellow is sample data, note the duplication of email,first,last name. id,email,first_name,last_name,status,site_id,opt_in 1,email1 at email com,john,doe,0,1,1 2,email2 at email com,mary,doe,1,1,1 3,email1 at email com,john,doe,1,1,1 4,email1 at email com,john,doe,0,1,1 5,email3 at email com,bob,doe,0,1,1 6,email4 at email com,joe,doe,5,1,1 Record with status greater then 1 are to be ignored Interfaces needed 1. Basic Search a) A sub string search (first,last,email columns) and show only results with (status in (0,1) and site_id = $_SESSION['site_id'] ) b) Results only shows one combination of email,first,last giving priority to members and then to most recent. For example in a query for email1 at email com above only record id 3 would show. c) Table with have 500 000 + records so all select mush have a limit d) unsubscribe link - when clicked on - changes status from 0 to 5 - if status = 1, that is not changed - sets additional column named opt_in to 0 - when clicked user is prompted with a dialog "Click yes to unsubscribe email at email com" - uses ajax (script.aculo.us AJAX class) to update record and replaces link with (unsubscribed) e) make member link to show when user is non member - sets only current record status to 1 - uses ajax (script.aculo.us AJAX class) to update record and replaces link with link to make non member f) make non member link to show when user is member - sets current record status to 0 - uses ajax (script.aculo.us AJAX class) to update record and replaces link with link to make member g) make columns sort able using jquery table sort h) limit results to 10 and if more show pagination i) edit link which links to edit form in # 2 j) search results will be limited by a site_id column which site_id is contained in ($_SESSION['site_id'] ) k) have alternating row colors to make easy to read 2. Edit interface - simple html form to edit first name,last name,email,opt_in (checkbox) status ( radio non member,member,unsubscribed) - after save redirect back to search results 3. Advanced search - shows like results in basic - does exact search for first,last,email if entered in form 4. unsubscribe form - takes email address only for public use to unsubscribe users - site_id is contained in ($_SESSION['site_id'] ) which limits records to that site_id - validates email being entered (function can be provided if needed) Construction methods All html is to be smarty template based A connection manager for mysql will be provided which has standard, connect / query / fetch features, a database table will be provided with sample data.
Job Type:	Linux PHP
Database:	MySQL
Operating system:	Linux
Bid count:	7
Average bid:	$ 226