I need a web-based system for storing and displaying problem reports in a database. The application should be written in PHP, and store the entries in a MySQL database. NO graphic design or "pretty" webpages are required - all I need are simple functional pages and I will handle the formatting and styles later.
This should be an easy project for someone with strong MySQL/php skills.
Key functions of the system and database entries/fields:
- Maintain a list of users via password control
- For each user store:
- First name
- Last name
- Email
- Phone
- User type
- Maintain a list of problem reports
- For each report the following fields are populated at the time it is created (all text):
- Record number (auto generate)
- Open date
- Closed date
- Last edit date
- Report creator username (populate automatically with logged-in username)
- Location code
- Project #
- Customer name
- Part number
- Serial number
- Work order #
- Work order line #
- Item description
- Problem status (open/closed)
- Problem description:
- Type
- Description
- Problem author username (auto populate w/ logged in user)
- Over time, each report will be updated with multiple additional "dispositions", each with the following fields:
- Disposition # (auto generate)
- Disposition type
- Disposition text
- Disposition author username (auto populate w/ logged in user)
- Disposition approver username
- File attachments (if any)
- Also over time the following additional sections will be filled out:
- Corrective action
-Corrective action author username (auto populate w/ logged in user)
-Corrective action approver username
- Root cause
-Severity
-Description
-Rating
-Type
-Author username (auto populate w/ logged in user)
-Approver username
Records are created/editted via php pages. The following pages are required:
Login page:
- Require users to log in (the purpose of log in is so that their username can be recorded in the "username" fields listed above)
Main page:
- Display summary list of all records (by Work order #)
- "Open" records should be sorted to top of table
- Display "View" link for each record
"Create" page:
- Allows creation of a new problem report
- Fields for poplating all of the fields listed above to be populated at the time of creation
- **Emails** the list of users when the new report is created
View page:
- Displays a record, including all fields, and gives links to download disposition attachments
- Allows the creation of new dispositions in the report
- Allows the corrective action and root cause fields (and sub fields) to be filled in
- Note: previously entered dispositions are NOT to be edittable
- **Emails** the list of users when a new disposition is entered
Report page:
- Allows text search in any/all fields
- Displays results
User list page:
- Allows maintenance of the user list
- Add/delete/edit all fields in the user list
Hello sir/madam,
we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better...
Thanks & Regards,
Softtechsurat
Hello Sir,
We are an Indian development company here.
we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it.
Thanks