IT Equipment Maintenance & Tracking System

Abstract

Ceylon Petroleum Storage Terminals Limited (CPSTL) is the common user facility company established to facilitate the petroleum storage & distribution activities in Sri Lanka. CPSTL serve around one thousand retail outlets island-wide owned by Ceylon Petroleum Corporation and Lanka Indian Oil Corporation PLC to meet the energy demand of the retail consumers in the country and the large number of bulk consumers in various industrial sectors involved in the economic development process. Two main installations supported by 11 bulk depots, which are involved in the storage and distribution network, with around 3000 employees actively participating in various activities of the company. CPSTL use more than 500 personal computers, laptop, printers and scanners to smoothly run their process. Information Systems (IS) function is responsible for purchasing and maintaining IT equipment for CPSTL. IS function keeps all details (item location details, complain details, maintenance details, etc.) about IT equipment in physical files, Therefore they cannot give accurate reports about IT equipment using those physical files and takes more time to prepare it. The key objective of designing and developing IT based system for IT equipment maintenance was to reduce the effort for report generation and increase accuracy of reports and also monitoring complaint and item status online. This system has been designed as a web based application. Therefore all functions of CPSTL could access through local area network and wide area network. This system uses PHP and MySQL database for implement functionalities and HTML5, JavaScript, jQuery, Ajax and Bootstrap framework for the frontend development. Morris chart and google chart use to develop MIS reports. This system has gone through the testing phase including user acceptance testing. These testing part used positive and negative test scenarios for ensure functionalities of the system working correctly. The user evaluation helps to ensure that proposed system met the all requirements and objectives of the client.