Food Pilferage Management Page

Overview

The Food Pilferage Management System serves as the administrative hub for tracking incidents related to food pilferage. It provides key metrics and visual representations of incident data, enabling administrators to monitor and manage the system effectively.

Features

Sidebar Navigation

1. Admin Menu: The sidebar includes links to various sections:
   1. Statistics Dashboard: Displays key metrics and charts (current page).
   2. Reports: Access detailed reports.
   3. View Incidents: List and manage all incidents.
   4. Items: Add and manage items in the database.
   5. Use Items: Record item usage.
   6. Contact Us: Contact system support.
   7. Add Employee: Add new employee records to the system.
2. Logout Button: A red button at the bottom of the sidebar to securely log out.

Dashboard Content

Metrics Overview

1. Total Incidents: Displays the total number of reported incidents.
2. Resolved Incidents: Shows the count of incidents marked as resolved.
3. Pending Incidents: Indicates the number of unresolved incidents.

Pie Chart

Visual representation of Incident Status Distribution, dividing incidents into "Resolved" and "Pending" categories.

Additional Charts (Planned/Expandable)

1. Incident trends by category, time, or other variables.

Footer

Includes a copyright message and system branding.

Implementation Details

Backend

• Session Management:
  • Ensures only logged-in users can access the dashboard.
  • Redirects unauthorized users to the login page.
• Database Integration:
  • Uses MySQL queries to fetch metrics (total incidents, resolved, and pending).
  • Joins tables to gather item-specific incident data for visualization.

Frontend

• HTML/CSS:
  • Responsive design using a combination of Bootstrap and custom CSS.
  • Sidebar remains fixed for easy navigation.
• Charts:
  • Powered by Chart.js for rendering dynamic pie charts.
  • Data for charts is fetched from the database and rendered via PHP.

Workflow

Login

1. The admin logs into the system via the loginpage.php.
2. Upon successful login, the session is validated, and the admin is redirected to the Statistics Dashboard.

Navigation

Admin navigates through different sections using the sidebar menu.

Logout

Admin clicks the Logout button to securely log out, destroying the session and redirecting to the login page.

Data Flow

1. Incident Metrics:

   Queries in db_connect.php are used to fetch counts of incidents based on their status (Resolved, Pending, etc.).

2. Charts:

   Pie charts dynamically pull data and labels from the database using PHP and encode them into JSON for Chart.js.

Contact

If you need any assistance or have questions, don't hesitate to reach out to us:

• Email: Legokenyap.ulgasan@gmail.com
• Phone: 09277085596