PHP Applikation

Kort beskrivning av applikationen PHP application for displaying incident information and field agent operation counts from the B25MAREM database.

Requirements

• A field agent can read all incidents.

• It must be possible to calculate the total number of operations a field agent has participated in.

• An incident can have one or more operations connected to it.

• A field agent should be able to search for information in the database.

• A field agent should be able to access incidents and their resulting operations.

• A Field Agent can have several favorite equipment items, and the same equipment item can be a favorite equipment item for several Field Agents.

• Assumption: A Field Agent can add, remove and change their own favorite equipment.

Implementation

• The application displays all rows from the INCIDENT table.

• The application uses GETFIELDAGENTOPERATIONCOUNT to show the total number of operations for a field agent.

• The application uses a JOIN between INCIDENT and OPERATION and displays the connected operations in a nested HTML table using row layout.

• The application allows the user to search for incidents by name using a self-referencing form and a prepared statement with LIKE.

• The application uses a dropdown to select an incident and display the operations connected to the selected incident.

• The application allows a Field Agent to add favorite equipment using an INSERT.

• The application allows a Field Agent to remove favorite equipment using a DELETE.

• The application uses the CHANGEFAVORITEEQUIPMENT procedure to change favorite equipment.

• The current favorite equipment is displayed in the application.