Electricity and Water Billing System for Shops: A Case Study of Shops in Rong Chang, Prince of Songkla University

Abstract

The purposes of this research were 1) to analyze, design, and develop an electricity and water billing system for shops, with a case study of shops in Rong Chang, Prince of Songkla University; and 2) to evaluate user satisfaction with the developed system. The system was implemented as a web application with an API. The frontend was developed using Vue.js, while the backend utilized the Spring Boot framework connected to a MySQL database.

The research findings showed that the electricity and water billing system for shops consists of two main components. The first component allows store tenants to view their latest monthly utility bill and print it as an invoice. The second component implements role-based access control, including: meter readers, who can record and edit current water and electricity meter readings; financial officers, who can view all utility reports for the latest month and update payment statuses; officers of the Division of Physical Systems and Environment, who can access all utility reports for the latest month; and system administrators, who can manage user accounts, shop information, and utility rates. In addition, all users can update their personal information and passwords. User satisfaction was evaluated from a sample of 23 users, using descriptive statistics (mean and standard deviation). The results indicated that overall satisfaction with the system was at a high level (  = 4.37, S.D. = 0.63).