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 from home jobs, work home job listing, work from home with no fees, work from home web developer jobs, work from home software jobs, work from home project manager jobs, work from home project management jobs, work from home php mysql developer jobs, work from home phone jobs, work from home online no fees, work from home management jobs, work from home jobs with no fees, work from home jobs online no fees, work from home jobs no fees, work from home jobs list, work from home email to manager, work close to home, work at home with no fees, work at home web developer jobs, work at home software jobs, work at home software developer, work at home online jobs with no fees, work at home no fees, work at home jobs with no fees, work at home jobs no phone

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