Incident Report - CRUD Screens + Listing(repost)
$100-350 USD
Pago na entrega
PHP forms to create, read, update and delete items from database. Summary report with dynamic filtering and sorting. Some formatting of data. Integrate code pieces into rest of application.
Please see attached for a sample view of a EDIT and LIST screen. We'll also need read (which looks like edit, but without text boxes) screen. Delete can be handled from LIST screen as in other screens in app.
## Deliverables
**Incident Summary Report**
**Requirements:
**
* Set meta-refresh tag to 60 seconds so page automatically reloads
* A search function that searches incident description fields
* The background color cell of the incident is determined by the priority. 1=light yellow 3=yellow 4=orange 5=red.
* The background color cell of the status field in the form is either red or green. If the issue is still open it goes red. If issue closed, green.
* All columns must be sortable in bi-directional fashion (ASC and DESC).
* $25 bonus, if you can have the column heading row (ID #, Open / Resolved, etc....) remain visible as the user scrolls down in the form, it would be ultra useful. Also, we want to still sort on those links.
**Filters:
**
* Region
* County
* Priority
* Status
* Scope
**Incident Create / Update Forms
**
Requirements:
* Code should follow fashion on rest of dev enviornment
* Code should plug into existing configuration files
* Incident table is primary to this feature set
* incident/[url removed, login to view] - handles both insert and update of incident record
**Incident View Form**
Requirements:
* Views data from a single incident row. Retrieve lookup values for dependant tables.
**Incident Delete**
Requirements:
* On the listing, show edit/delete
ID do Projeto: #3882594