Need a secure online mysql database app with user managment system close in function to a typical forum.
Database used to track work done by users at customers jobs.
Also used for forman to track work ensuring quality controll is requirements are current for each user. managment able to run reports listing various information monthly, or quartly
Need a small relational MYSQL db (already hashed out) with 4 tables fine tuned for User Forman, Management and God access to certain functions.
Database tables very close to below;
User tbl- id, company, phone, last update, user level, etc
Customer tbl- id, name, address, phone, etc
Job tbl- address, job specifics, customer
Work tbl- date work started, milestone 2, milestone 3, File1, file2 etc
Would like to be able to integrate this into any site, with clean, uncluttered look and feel Googleish, not Yahoo ! Possibly having any text or styles in a template page or two.
Need a PHP developer to create secure web pages with forms that allow basic functions;
Management or God must add user or approve users registration, once user is added or approved the user has access to update limited personal info (phone, fax, email etc)
Management can make users Forman allowing them to run reports, or make Forman only users
User is able to add customers, but form should be smart enough to see if customer already listed and if is listed require user to use existing information.
User can add job, but form would be able to red alert Management / Forman if a customer’s job already being handled by another user.
Management / Forman should also know if customer has 2 users on separate jobs
User can add work info, dates for milestones met, requiring uploaded files to be allowed to update the next milestone. This table should have a time stamp.
Users be able to run queries that would list own work within last month/quarter/year-
Show work only started
What jobs reached milestone2,
What jobs reached milestone3,
What jobs were completed,
Management and Forman could get same info on a global or singular scale.
Forman could query the db to see when users have not accessed db in x days/months
Forman could query the db to see if users have last X amount of jobs uninspected
Forman can update user’s jobs as inspected
Be able to export results in common formats, txt, csv, tsv ect.
Be able to print reports as pdf from the web or downloadable reports.
Software able to phone home, with GOD able to restrict use by Management, Forman or users individually or as a group or by host.
PHASE 3 (Future)
User payment system based on jobs (Users pay Managers.)
Manager payment system ( Managers pay Forman)
Licensing fees (Hosts pay GOD for use)