Encerrado

Project-Personel-Managment DB

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

## Deliverables

PHASE ONE

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,

etc…

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

PHASE 2

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)

Habilidades: Engenharia, MySQL, Perl, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: yahoo work home jobs, work home job listing, work home online fees, work home management jobs, work home jobs list, work home email manager, work close home, work home software jobs, work home jobs phone, work home jobs fees, work home email jobs, web php developer jobs, web developer personal page, web developer online jobs, web developer jobs online, web developer fees, web based jobs home, web app developer jobs, user group manager, text jobs home, system developer jobs, software jobs home, software developer online jobs, software developer jobs online, software developer jobs home

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #3041373

1 freelancer está ofertando em média $553 para este trabalho

luvlyIn

See private message.

$552.5 USD in 14 dias
(28 Comentários)
4.8