Limited reservation visibility
Users needed to understand when equipment was already reserved before submitting a new request, reducing conflicting or duplicate applications.
Business System
Internal Request System
An internal PHP and MySQL application developed to digitize equipment requests, reservation visibility, approvals, status tracking, asset administration, and operational reporting.
Overview
Replacing a fragmented manual process with a structured digital workflow.
The system was created to make equipment requests easier to submit, review, approve, and track while giving users better visibility into existing reservations and application status.
I handled the project from requirements planning and workflow definition through interface design, PHP and MySQL development, validation, testing, administrative functions, documentation, and operational preparation.
The Challenge
Making requests easier for users while giving administrators clear control.
Manual approval handling
Administrators required a centralized way to review applications, update statuses, record notes, and manage approvals and rejections.
Operational handover
The application needed clear user and administrator manuals so non-technical staff could operate the system without depending on the developer.
My Responsibilities
Full ownership from requirements to operational readiness.
I designed both the user-facing request experience and the administrative workflow needed to review, manage, and report on applications.
Requirements and workflow planning
Defined the request flow, user roles, administrator actions, status transitions, reservation logic, and required data.
Database and application design
Planned the data structure for users, equipment records, requests, statuses, dates, notes, and administrative management.
User request experience
Developed request forms, confirmation screens, submission handling, validation, status history, and reservation visibility.
Administrator functions
Built interfaces for reviewing requests, approving, rejecting, cancelling, adding notes, managing users, and maintaining equipment records.
Reporting and output
Added CSV export, print-ready request details, filtering, and status visibility to support practical administration and recordkeeping.
Testing and documentation
Tested validation, permissions, request status behavior, date handling, and error conditions, then prepared user and administrator manuals.
Solution
A role-based system supporting both applicants and administrators.
Request Workflow
Structured submission and confirmation
Users select equipment, enter the requested period and purpose, review the information, and submit through a clear multi-step flow.
Reservation Visibility
Existing bookings shown before submission
Upcoming reservations are displayed for the selected equipment so users can avoid conflicting request periods.
Administrative Control
Centralized status and record management
Administrators can review request details, update statuses, record notes, manage assets, and maintain user accounts.
Documentation
Clear instructions for daily operation
Separate user and administrator manuals explain submission, review, approval, management, and common operating procedures.
Process
From operational problem to tested internal application.
-
01
Identify the operational problem
Reviewed the existing request process, user needs, administrative tasks, equipment management requirements, and common sources of confusion.
-
02
Define roles and workflow
Mapped user and administrator responsibilities, request states, approval paths, reservation checks, and required system actions.
-
03
Design and develop the application
Implemented the database, request forms, confirmation flow, status pages, administrator interface, and management tools.
-
04
Test and refine
Tested duplicate periods, date validation, permissions, error handling, status updates, exports, and management functions.
-
05
Prepare for operation
Removed test data, prepared user and administrator manuals, documented the workflow, and supported operational review before launch.
Outcome
A clearer and more manageable internal request process.
The system provides a single digital workflow for submitting, reviewing, managing, and tracking equipment requests.
- Centralized request submission
- Reservation visibility by equipment
- Approval, rejection, cancellation, and status tracking
- User and administrator role separation
- Equipment and user administration
- CSV export and print-ready request details
- User and administrator documentation
Skills Demonstrated
- Requirements Planning
- Workflow Design
- PHP
- MySQL
- JavaScript
- Form Validation
- Administrative UI
- Testing
- Operational Documentation
Internal URLs, user records, equipment identifiers, database credentials, production data, security settings, and source code are not displayed. Certain workflow and implementation details have been generalized.