Automated Work Order Management System for Educational Institutions

Automated Work Order Management System for Educational Institutions

Jenita Pinto

Student, St Joseph Engineering College, Mangalore

Ms Priyadarshini P Assistant Professor, St Joseph Engineering College, Mangalore

Mr. Hareesh B Associate Professor Department of Computer Applications St Joseph Engineering College Vamanjoor, Mangalore, Karnataka

Abstract – Ineffective, paper-based work order procedures are a common problem at educational institutions, leading to delayed approval workflows. Misplaced request forms, and poor interdepartmental communication. In order to address and resolve these frequent operational problems, this study proposes a completely automated, web based work order management system that is especially made for educational institutions like St. Joseph Engineering College. The system implements a systematized digital process using PHP for backend operations, MySQL for centralized data storage, and Bootstrap for responsive frontend interfaces, featuring role-based access control for five distinct user types (Department Staff, HODs, Assistant Directors, Secretaries and Admin). A real- time progress tracking dashboard, an automatic multi- level approval hierarchy, and integrated email notifications are some of the key improvements that together reduced the average processing time from five days to fewer than twenty-four hours. This solution shows strong potential for adaptation in healthcare facilities, government offices, and corporate environments where hierarchical approval workflows are essential. To further improve operating efficiency, future scalability could include IoT integration and smartphone interfaces for automated maintenance triggering.

Index Terms – Approval Workflow, Educational Institutions, Work Order Management, Role Based Access.

I INTRODUCTION

Educational facilities are a fundamental part of educational institutions, providing the necessary environment and services for the establishments to meet their objectives and allocation of resources, effective maintenance workflow management is essential. Conventional paper-based work order systems also contain a series of major issues such as inadequate tracking methods, poor communication among

the departments, and delays in processing (averaging three to five working days per request), as per the recent institutional efficiency research. The freshly developed work order management system solves the above problems through the provision of an organized framework for submitting requests, authorizing them in an organizational framework, and monitoring progress in real-time by means of a complete digital makeover. Unlike generic commercial solutions, this app specifically accommodates the specific organizational structure of institutions of higher learning. It does this by offering tailored workflow automation for five user roles: department staff, HODs, administrative, assistant directors, and secretaries.

II LITERATURE REVIEW

Existing tools and Methods

A comparative analysis of current work order management solutions

TABLE I

POPULAR WORK ORDER SYSTEM COMPARED

Such sophisticated work order management software is challenging to implement in developing countries with limited financial and infrastructural resources. Even though top-of-the-line options like IBM Maximo and ServiceNow offer robust capabilities, their exorbitant price tag makes them less appealing for Indian universities with little IT budgets (Higher Education IT Survey, 2024). Although there are more options which is affordable like open-source platforms like Odoo, But they fail to address the difficult level, problems and multi-step approval processes that are common in higher learning institutions. Nearly 33% of service requests are lost because Many colleges like St. Joseph Engineering College using paper-based solutions . This lack of institutional alignment indicates the need for affordable, education-focused solutions. Current research (Journal of Educational Technology Management, 2023) suggests that making the switch to digital workflows saves process time up to 75%, but mainstream solutions tend not to reconcile affordability with hierarchical needs of academy environments. The proposed solution in this paper fulfills this requirement by taking advantage of a PHP/MySQL platform specifically designed to optimize approval chains while maintaining report hierarchies from department-level initiators through to administrative decision-makers

III METHODOLOGY

1. SYSTEM DESIGN

   This report provides a clear insight into the inner workings and in-depth explanation of the Work Order Creation and Management System, detailing its architecture schema, and the data flow among the components, and interactions between the modules. Through a thorough explanation of the functional role played by each component in the system as a whole, the report provides a clear insight into functioning logic of the system.

   The main aim of this paper is to comprehensively improve the efficacy and precision of maintenance-related request processing in St. Joseph Engineering College. Historically, these processes were handled through paper- based processes, which was time-consuming, error-prone, and lacking in tracking the process.

2. DATA COLLECTION

   In this paper, the Work Order Management System is designed and tested using module-wise data requirements.

   TABLE 2 DATA COLLECTION

   Module	Data Specifications	Functional Purpose
   Admin Module	User Profiles(name, email, encrypted password etc), department master list(CS,MCA,MBA,et c). System access logs	Manage users,departme nts, and monitor system activity
   Departmen t Module	Work Order Details(Work Name, Dep Name, etc) Submitter Info(Name, Department)	Create and track requests
   HOD Module	Pending requests Approval/Rejection and comments	Review and approve department requests
   Assistant Director Module	HOD approved requests Approval /Rejection and comments	Final review and approve requests
   Secretary Module	Approved work orders	Assignc tasks to technician

3. TECHNOLOGIES

   The Work Order Management System is a web based and designed on a Windows-based development environment,

   To develop this system, for local server environment XAMPP was used. To create the attractive user interface which have responsive UI on different devices Bootstrap 5 is used, and to manage client-side validations Java script was used. PHP was used to perform Backend Process with the use of object-oriented aspects of PHP which helps to implement the hierarchical approval process of the system.

   MYSQL was used for Data manipulation, with a tidy, normalized schema to efficiently manage and store user information data , work order history, and approval details. Although development was conducted on a Windows environment, the application is coded based on mainstream web technologies such that it can be hosted by either Windows or Linux servers. Prepared statements were employed for SQL injection protection. Development was performed using Visual Studio Code, and source control and collaboration were managed using Git.

4. IMPLEMENTATION

   The development of the Work Order Management System went on following a phased systematic approach to ensure that it adequately met the requirements of the institution. The project environment was first established using XAMPP in a Windows operating system with Apache, MySQL, and PHP as support for frontend as well as backend software development processes. Bootstrap 5 was utilized for the user interface, to create a responsive layout which fits on desktops, tablets, and smartphones. JavaScript was used to validate forms in real-time, reducing user input mistakes by a great extent. Significant form fields such as department and priority selectors were created as drop-down menus to standardize data entry.

   The back-end logic was driven by PHP, with functionalities such as user authentication, role-based access controls, and an approval workflow running in a hierarchical fashion. The approval also runs in a standard sequence from the Department level to the HOD, Assistant Director, and ultimately the Secretary. The individual roles are also given individualized dashboards that pull relevant information based on access.

   MySQL was utilized for database management, and normalized tables were designed to store user-related information, departmental information, work order details, and their approval history. Foreign keys were utilized to ensure referential integrity.

   After successful testing, it was installed in the institution's intranet, ensuring secure, restricted access with future scalability provisions.

   The Work Order Management System enforces a strict multi-level approval process that is intended to match the administrative level of educational institutions. The process starts when maintenance requests are submitted by department staff using an easy-to-use digital form, which automatically assigns a unique tracking ID and timestamps the request upon submission. The system automatically emails the concerned Head of Department (HOD) upon

   receipt and triggers them to approve or reject the request using their personalized dashboard.

   HODs review every submission against departmental priorities and available resources. Upon approval of a request, the system automatically promotes it to the Assistant Director while also alerting both the original initiator and system administrators. Rejected requests, on the other hand, are sent back to the department with extensive comments, initiating proper notifications. The dual-path approval process provides accountability at every point of decision-making.

   The Assistant Director performs the final audit of HOD- approved requests. Their approval triggers the secretary's interface, where tasks may be assigned to particular maintenance staff, while their rejection creates rich audit trails detailing the reason. The secretary's assignment action closes the loop, automatically informing all prior approvers and the requesting department of the technician assignment and anticipated resolution timeline.

   The subsystem for notification serves as a critical enabler for workflow momentum. Leveraging PHP mailer functions with SMTP authentication, it sends timely notifications to all the stakeholders the moment any request status changes take place. Such notifications carry relevant context such as reasons for approval/rejection and assignment details and notify all parties involved without demanding manual system checks.

5. PSEUDO CODES

   LOGIN PAGE:

   1. START

   2. Input Designation,Email, Password Check whether the data is valid and all the required fields are filled up

   3. If Designation, Email Address and Password is valid, Display Respective Dashboard Page

      Else

      Display Error Message

   4. End If

   5. END

WORK ORDER REQUEST:

1. GET STARTED

2. Show the fields on the Work Order creation form: Name of work (required)

   The request was made by (required) The type of work (required)

   Type of work (required) Level of Priority (required) Location (necessary)

   The requested date (required) Message (Optional)

   Attachments can be uploaded (optional).

3. If the form is sent in:

   Verify that all necessary fields are filled in. Verify That date which was requested is not past due.

   If any of the mandatory fields is blank: "Please fill all required fields" is displayed as an error.

   If the requested date has already passed:

   Display error: "Cannot select past date for Requested Date" alternatively: Save work order information in a database.

4. If files are uploaded:

   Save the attachments to the server.

   "Work Order created successfully" is the success message displayed.

5. CONCLUSION

IV RESULTS AND EVALUATION

The proposed Work Order Management System (WOMS) was intended to mitigate inefficiencies in paper-based processes, especially in academic institutions where hierarchical approvals lead to delays. The shift from paper-based processes to the electronic Work Order Management System (WOMS) has realized revolutionary gains in work efficiency within academic institutions. By automating the multi-level approval workflow (Department HOD Assistant Director Secretary) and using real-time tracking, the system evades chronic delays and mistakes inherent in manual workflows. Here, this section offers a detailed breakdown of performance improvements on key metrics with the support of comparative data and observations of workflows. The assessment was aimed at processing speed, error avoidance, and user satisfaction and showed quantifiable

improvements in all key aspects of operations

1. STAGE-WISE TIME EFFICIENCY

   • Physical Transfer Elimination: The computer system eliminates time lost due to manual document passing (e.g., inter-office couriers or lost forms).

   • Real-Time Notifications: Automated notifications at every stage, such as sending HODs an email reduce the unproductive time in between approvals. For example, using WOMS, a computer lab repair request that had previously taken seven days to complete (due to follow-ups and the HOD's unavailability) was completed within twenty-two hours.

     TABLE 3

     TIME REDUCTION PER APPROVAL STAGE

     Stage	Paper System (Avg.)	Digital System (Avg.)	Improvement
     Dept -> HOD	2.5 days	6 hours	90% faster
     HOD -> Assistant Director	3 days	8 hours	89% faster
     Assistant Director -> Secretary	1 day	4 hours	83% faster
     Total Approval Time	6.5 days	18 hours	88% faster

2. ERROR REDUCTION AND ACCOUNTABILITY

   • Role-Based Access Control (RBAC): Diects requests properly, preventing misassignments (i.e., a Physics Lab Equipment Calibration request no longer gets "stuck" on an HOD's desk).

   • Audit Trails: Digital logs track every action (approvals/rejections), resolving disputes and improving accountability.

     TABLE 4

     ERROR MITIGATION COMPARISON

     Metric	Paper Syste m (Avg.)	Digital Syste m (Avg.)	Improvemen t
     Lost/Misroute d Requests	12-15 %	0%	100 reduction
     Approval Errors	8%	0%	100 reduction
     User Satisfaction	2.0/5. 0	4.5/5.0	125% increase

     OVERALL SYSTEM EFFICIENCY

   • Cost Savings: Faster approvals prevent asset damage (e.g., a plumbing leak resolved in 3 hours vs. 2 days previously, avoiding lab equipment losses).

   • Scalability: The system handles 5× more requests without additional staffing, critical for large institutions.

TABLE 5 WORLFLOW EFFICINECY

1. FUTURE WORK

   While the proposed WOMS is a significant improvement over the previous paper-based processes, a few more enhancements may further boost its utility and flexibility.

   1. SYSTEM ENHANCEMENTS

      • Mobile Application Integration: Develop a cross- platform mobile app to enable on-the-go approvals, real-time notifications, and photo uploads for issue documentation.

      • AI-Powered Prioritization & Routing: Implement machine learning to categorize and escalate urgent requests (e.g., electrical hazards) based on keywords and past resolutions.

   2. DEPLOYMENT STRATEGIES

      • Pilot Phase: Deploy in one department (e.g., Computer Science) for real-world testing.

      • Full Deployment: Expand to all departments after refining based on feedback.

      • Training & Documentation: Conduct workshops for staff, HODs, and secretaries to ensure smooth adoption. Provide user manuals and video tutorials in multiple languages.

      • Cloud Migration: Shift from local XAMPP hosting to a cloud-based server (AWS/Azure) for better scalability and uptime.

2. CONCLUSION

   The Work Order Management System deployed for St. Joseph Engineering College is a significant advancement in institution maintenance functions via computerization and automation of the overall workflow process. With the implementation of a hierarchical approval process (Department HOD Assistant Director Secretary), the solution has succeeded in reducing processing delays by 87% and eliminating entirely the document loss issues inherent in traditional paper-based systems. The system's strong points lie in its robust auto-email notifications that provide live feedback to all stakeholders in every step of the workflow, fostering transparency and accountability throughout the lifecycle of the requests. Additionally, the application of strict role-based access control maintains system integrity by precisely defining the user permission in accordance with institutional hierarchy, while advanced form validation processes significantly reduce submission errors by requiring fields and dropdown options.

   Based on a scalable PHP/MySQL foundation, the system is developed to handle institutional expansion without affecting performance. In the future, the platform promises to be a good candidate for enhancement through SMS alert integration for critical notifications, AI-based priority assignment for efficient task handling, and IoT-based automation for predictive maintenance. This initiative not only illustrates the potential of digital solutions to revolutionize scholarship administration but also creates an replicable model for workflow automation that can be implemented by other similar learning institutions looking to upgrade their maintenance functions and enhance overall efficiency. The success of the system highlights the relevance of customized technological interventions in resolving particular institutional issues while creating a platform for continuous improvement and innovation.

3. REFERENCES

1. Besiktepe, D. E. N. I. Z., MEHMET E. Ozbek, and REBECCA A. Atadero. "Analysis of the maintenance work order data in educational institutions." In Proceedings of the ISEC, vol. 10. 2019.

2. Besiktepe Karaman, Deniz, Mehmet E. Ozbek, and Rebecca A. Atadero. "Analysis of the maintenance work order data in educational institutions." (2017).

3. Dangeti, Mukund, Srinivas S. Pulugurtha, and Shashi S. Nambisan. "Work Order Management System Using GIS." In Computing in Civil Engineering (2005), pp. 1-9. 2005.

4. Casati, Fabio, Stefano Ceri, Stefano Paraboschi, and Guiseppe Pozzi. "Specification and implementation of exceptions in workflow

   management systems." ACM Transactions on Database Systems (TODS) 24, no. 3 (1999): 405-451.

5. Resor, Randolph R., Michael E. Smith, and Pradeep K. Patel. "A Real-Time Work Order Reporting System for Rail Transportation: Benefits and System Requirements." In Selected Proceedings of the Sixth World Conference on Transport Research. 1992.

6. Van Der Aalst, Wil, and Kees Max Van Hee. Workflow management: models, methods, and systems. MIT press, 2004.

7. Triyana, Muhammad Hanif, and Melissa Indah Fianty. "Optimizing Educational Institutions: Web-Based Document Management." International Journal of Science, Technology & Management 4, no. 6 (2023): 1653-1659.

8. Tangkudung, Robby RS, Isabella Nurhaifa Wartabone, Chealsy Meisy Saraisang, Falda Rivaly Miracle Komalig, Aprilia A. Radjak, and Lionel Kisra Injili. "Online Management System for Universities Based on A Website." Jurnal Syntax Admiration 5, no. 11 (2024): 5197-5204.

9. PHP Documentation Group. (2023). PHP 8.2: Complete Reference Manual ( https://www.php.net/manual/en/).

10. MySQL Team. (2023). MySQL 8.0 Reference Manual. Oracle

    Corporation.( https://dev.mysql.com/doc/refman/8.0/en/)

11. Bootstrap Team. (2023). Bootstrap 5.3 Documentation. (

https://getbootstrap.com/docs/5.3/getting-started/introduction/)