POS & REPAIR SERVICES TRACKING FOR LIFEZONE ELECTRONICS

A Proposal

presented to the faculty of the

College of Information and Communication Technology,

Northwestern Mindanao State College

of Science and Technology

In Partial Fulfillment of the Requirements

for the degree Bachelor of Science in Information Technology

By:

Capa, Allan L.

Araneta, Jillie O.

Lacida, Edrian C.

Jimenez, Louwyji P.

G-AR T. DELOSA

Adviser

2024
 Chapter I

INTRODUCTION

1.1 Project Context

In our present society, technology has become a daily part of life. With today’s sophisticated
technology, everything is instantly connected to your fingertips. It has brought many possibilities
that were mere ideas and transformed them into practical applications for entertainment and
utility. The wide range of business services in the industry has continued to grow over the past
decade. Companies and shops do rely on technology to do faster and more efficient work.
Consequently, point-of-sale and tracking services are not left behind by the advancement of
technology. As the advancement of technology has already emerged, tracking service status is
significant and efficient.
The POS (point-of-sale) was a modern version of cash registers that calculated the purchase
amount of the customer's combination of hardware and software and payment services to make
sales in a business. According to Oktafianto (2021), the transaction recording system still uses
manual recording in books, which often causes various problems in managing purchase
transaction data, sales transactions, which are often inaccurate, service becomes slow, with a lot
of stock, the possibility of loss will not be caught immediately, and sometimes there is an
accumulation of stock. Moreover, the manual process has many weaknesses, including human
error, long data management, weak supervision, and low data integrity (Winarto, 2023). This
makes it difficult to cater, especially for large establishments. The web-based POS and inventory
systems do help in improving transaction recording, inventory management, and reporting in
various foreign businesses. And in terms of monitoring services, specifically monitoring repair
services, tracking systems can assist in efficient asset management by monitoring the status of
valuable equipment or resources. According to Jr. (2021), developing a tracking system optimized
for SMS data transmission could be useful for inland fleet management because of the
importance of service quality in the country's emerging market, particularly for small and medium
enterprises. A web-based repair service tracking system, like the J&T tracking system, was used
to track the status and update it in real-time, providing an efficient and assured view of the
customer's item status. A system that was developed can enable users or customers to look up
status updates. Wherever your location is, the customer can check and track you through the
tracking system.
 The Lifezone Electronics shop uses traditional methods or manual reporting that takes a lot of
time. Furthermore, the customer will fail to know if the repair status is already done, which
makes it a waste of time for the customer to go to get the items repaired that’s not done. The
problem faced by the establishment relies on outdated or manual methods, such as paper-based
systems or basic spreadsheets, which are prone to errors and inaccuracies and are time-
consuming. The customers won't receive timely updates on the status of their repairs, and there is
no accurate time they can see if the item is ready to pick up or will update the status of the item
repaired.
Although there is several existing system, however there are still gaps between the existing
and the proposed system. The existing system consists of point-of-sales (POS) and inventory, but
do not have a repair services tracking system. Some existing system uses SMS or barcode to track
the items. While the proposed system, involves point-of-sales (POS) and repair services tracking
system.
Upon analysing the situation, the proponents came up with the idea to design and develop a
web-based point-of-sales (POS) and repair service tracking system tailored for Lifezone
Electronics. The admin can manage user accounts, monitor daily sales, monitor sales availability,
manage repair services, record purchased sales, generate tracking numbers for repaired items, and
print sales and repair items reports. Additionally, customers can track the status of their repaired
items through a tracking number via public viewing.

1.2 Purpose and Description

The purpose of this capstone project is to design and develop a web-based point-of-sales
(POS) and repair services tracking system for Lifezone Electronics. The system includes various
functionalities such as managing user accounts, monitoring daily sales, monitoring sales
availability, managing repair services, recording purchased sales, generating tracking numbers for
repaired items, and printing sales and repair item reports. Additionally, customers can track the
status of their repaired items through a tracking number via public viewing.

1.1 Objectives of the Study

1.3.1 General Objective
The main objective is to designed and developed a Web-Based Point-of-Sales and Repair
Services Tracking Process System for Lifezone Electronics, located at Public Mall, Ozamis
 City. The System aims to automate the Point-of-Sale Transactions and provide a tracking
service of the repaired items from the different customers.

1.3.2Specific Objectives
Specifically, this project features the following:

1. Collect and gather data related to POS and repair services.

2. Develop a Web-Based Point-of-Sale and repair services tracking system with the
following functionalities.
Admin:
 Manage user accounts.
 Manage repair services.
 Manage items that are available in their shop.
 Record the purchased items.
 Monitor the daily sales.
 Update the status of the repaired items.
 Generate a tracking number or the repaired item.
 Generate sales and repaired items report

Customer:

 Track the status of the repaired items through tracking number.

1.4 Scope and Limitation of the Project

The scope of this capstone project focuses only on point-of-sale and repair service
tracking at Lifezone Electronics. The system designed to help the admin manage user accounts,
manage repair services, manage items that are available in the shop, record the purchased items,
monitor daily sales, update the status of the repaired items, generate a tracking number for the
repaired items, and also generate a sales and repaired item report. Moreover, the customer can
track the status of the repaired items through a tracking number.
On the other hand the system does not accept online payments, reservations,
appointments, and inventory transactions.
1.5 Conceptual Framework

INPUT PROCESS OUTPUT

Agile Methodology
Interview the owner of the
POS & Repair Services
Lifezone Electronics shop
 Plan Tracking For Lifezone
regarding the management
 Design Electronics
of the point-of-sales
 Develop
transaction and customer
 Test
repair tracking services.
 Deploy
 Review
 Launch

Figure 1: Input Process Output (IPO)

The input stage begins with an interview conducted by the proponents to the owner of
Lifezone Electronics. During this interview, information is gathered regarding point-of-sales
transactions and customer repair tracking services. The insights obtained serve as the foundation
for subsequent steps. We adopt the Agile Methodology, this dynamic approach involves several
iterative cycles; Plan, Design, Develop, Test, Deploy, Review, Launch. In the output stage, the
efforts culminate in two key deliverables; Manual System Software, this software manages point-
of-sales services efficiently and Repair System Tracking System, customers can access this
system publicly to track their repair requests.
1.2 Definition of Terms
 POS System (Point of Sale System) - A software and hardware solution used by retail
businesses to process transactions, manage sales, and track inventory in real-time.
 Service tracking - is the process of monitoring and managing the status of service
requests or repairs initiated by customers, typically through an online platform or system.
 User Interface (UI) - The visual elements and controls through which users interact with a
software application or system, designed to be intuitive and user-friendly for effective
navigation and operation.

 Agile Methodology - A software development approach that emphasizes flexibility,

collaboration, and iterative development. It focuses on delivering small, incremental
releases and welcomes changes in requirements throughout the development process.

 SDLC (System Development Life Cycle) - A process of creating or altering

information systems, and the models and methodologies that people use to develop these
systems.
 Chapter II

REVIEW OF RELATED LITERATURE

2.1 Foreign Literature

According to Oktafianto (2021), Aska Outdoor is a business that sells sports and outdoor
equipment in the Tangerang area. The transaction recording system at Aska Outdoor currently
still uses manual recording in books, which often causes various problems in managing purchase
transaction data, sales transactions, and inventory of goods, such as inventory data, which is often
inaccurate, service becomes slow, goods are sold online through a marketplace, there are only a
few a few items with a lot of stock, the possibility of loss will not be caught immediately, and
sometimes there is an accumulation of stock. To solve this problem, it is necessary to create a
web-based point-of-sale (POS) information application that can improve and simplify the
performance of employees at Aska Outdoor stores so that they can produce reports that are faster,
more precise, and more accurate. The system design stages that will be proposed use UML
diagrams. The application is made using the PHP programming language and the MySQL
database. With the creation of "Designing a Web-Based Point of Sale (POS) Information System
at Aska Outdoor Tangerang Stores," it is hoped that it can assist sales administrators (cashiers and
online marketing) and warehouse administrators in managing inventory data properly, such as
goods data, purchase transaction data, sales transaction data, supplier data, and customer data.
Meanwhile, leaders can find out and get information about purchase transactions, sales
transactions, and inventory of goods in the form of reports quickly, precisely, and accurately.
According to Winarto (2023), cosmetics have become a daily necessity for women, men,
and children. The cosmetics in question are not just make-up cosmetics such as powder or blush.
Products such as shampoo and soap are also included as cosmetics that fall into the skincare
category. Various phenomena or trends that enter Indonesia affect cosmetic sales. Rita Kosmetik
Store has been running since 2004, and until now, Rita Kosmetik Store is still running its business
manually, using paper media. The manual process has many weaknesses, including human error,
long data management, weak supervision, and low data integrity. The author then designed a web-
based point-of-sale system using Laravel with a MySQL database based on these problems. The
resulting point-of-sale system helps Rita Kosmetik Store owners and employees in recording,
collecting, and managing business transactions; inventory is properly tracked; and the resulting
reports do not take much time and are more accurate.
 According to Rahman (2022) The development of internet technology in Indonesia,
especially in the use of computer technology for data processing, is also a concern in the business
world. Through computerized data processing, all items that have been sold can be quickly
identified, along with their advantages. Toko Afridah Cake is a business that sells various types of
cakes and snacks in Tembilahan which still with an offline transaction system. Therefore, it is
necessary to build a point-of-sale information system at the Afridah Cake store so that it makes it
easier to develop a business. Researchers use the SDLC (System Development Life Cycle)
system development method and use pieces analysis. The system is designed using three levels of
users, namely admin, cashier, and consumer. The system can be used to exist at Toko Afridah
Cake because it has passed the blackbox testing stage without any errors. This web-based point of
sale system makes it easier for store owners, especially to monitor the transaction process in the
store without having to come to the store because the system is web-based so that it can be
accessed anywhere while still being able to connect to the internet.

2.2 Local Literature

According to Jr. (2021), consumer-grade tracking systems exist but are not optimally
designed for low-cost operation in the Philippine setting. Tracking devices typically use Global
Positioning System (GPS) and Global System for Mobile Communications (GSM) technologies.
Commonly, for device management and real-time tracking, data is transmitted via General Packet
Radio Service (GPRS) to a proprietary or third-party cloud service. This method is costly in the
Philippine context as well as power-consuming. This study designed a tracking system optimized
for the short messaging service (SMS) mode of data transmission. This study covered the design
of a tracking device using consumer-grade hardware components, the development of a system
interface to enable remote operation using commands sent as short messages, the development of
a simple desktop client monitoring service, and actual field-testing using land and water vehicles.
The test results showed 100% tracking data delivery efficiency and a small difference between
mean absolute error (MAE) and root mean square error (RMSE) for each route, indicating that
there is a small variance in distance errors. The tracking device also performed well on a sea
route, which is comparable to a commercial standard GPS data logger. Test results also showed
that the device can be used for tracking applications, i.e., vehicle security, inland fleet
management, monitoring of tourist boats, and research or field surveys where GPS and GSM are
available.
According to Mendoza (2019), a point-of-sale system is an enterprise solution primarily
based on software programs used to tune sales time and inventory simultaneously. Manufacturers
and outlets can both benefit from a comprehensive answer, where single transaction entry records,
essential client details, purchased products, rates, and dates are also updated. The gadget would
be of awesome assistance due to the fact that it serves as many customers as possible at a speedy
tempo and helps to screen all kinds of data faster and more conveniently. The inventory point-of-
sale system may be a computer and more dependable than a physical one. The machine can
minimize upgrading botches and can be gotten to effortlessly.
According to Kambivi (2020), the development of the business world encourages
companies to always try to improve the quality of their products and services for consumers. The
implementation of these business solutions is a commitment to increasing the competitive
advantage of corporate customers in terms of efficiency, effectiveness, performance, and business
development. This research is to analyze and design a point-of-sale (POS) management
application to support the purchasing service system and stock of goods that can help small and
medium entrepreneurs in data management. The making of this POS application starts with
collecting all the data needed using observation and interview methods, designing an application
model with an object-based diagram approach with application design tools in the form of
flowcharts and Unified Modeling Language (UML), and then implementing this POS application.
The application of the point of sale (POS) application can help with the tasks of related parties or
all stakeholders related to the POS application.

2.3 Related System

2.3.1 PC Repair Tracker, Computer Repair and Tracking Services System

Figure 2. PC Repair Tracker, Computer Repair and Tracking Services System

 This system application will help you diagnose computer interfaces easily with a PC
repair tracker and automatically set computer specs and scan history. The staff will give the
customer a claim ticket and print an asset label to attach the customer item. With the use of this
system, you can keep track of every action performed on the repair job. It can add billable
charges and create invoices, and with one click, it will send them to the point of sale to process
the sale.

2.3.2 J&T Tracking System

Figure 3. J&T Tracking System

This system helps to track parcel location information and update the status of the
parcel. Through this system this will help to provide an efficient and assurance of the
parcel's whereabouts. J&T facilitates express services for customers. A management
system that will develop and enable the users or customer to look up the status updates.
Wherever you are, you can always check and track through this tracking system.
2.3.3 Giga Trak Tool Tracking System Software

Figure 4. Giga Trak

This system helps track and organize tools both in the warehouse and in the field. It
improves tool visibility through inventory management software. This system is easy to
implement with a simple user interface. Tracking equipment through barcodes provides a quick,
effortless way to document and track items that are moved around. Since it is not easy to locate
tools, GigaTrak offers an easy-to-use, workable solution for users. It helps maintain industrial
tools easily and simply.

2.4 Synthesis
The proponents discovered the same procedures of POS of both related systems and the
proposed systems. However, there are still differences found in terms of tracking the items. The
existing system uses SMS and barcode while the proposed system uses tracking number to track
the repaired item.
2.5 Technical Background

Table 1

TECHNOLOGIES USED IN THE PROJECT

Tool Description/Function

PHP 8.2 PHP (recursive acronym for PHP: Hypertext

Preprocessor) is a widely used open-source
general-purpose scripting language that is
especially suited for web development and can be
embedded into HTML.

POSTGRESQL 10 PostgreSQL is an advanced, enterprise-class, and

open-source relational database system.
PostgreSQL supports both SQL (relational) and
JSON (non-relational) querying.

CSS3 Also known as Cascading Style Sheets, is a style

sheet language used for describing the
presentation of a document written in a markup
language such as HTML or XML. CSS is a
cornerstone technology of the World Wide Web,
alongside HTML and JavaScript.

Bootstrap 5.2 Bootstrap is a free and open-source CSS

framework directed at responsive, mobile-first
front-end web development. It contains HTML,
CSS and JavaScript-based design templates for
typography, forms, buttons, navigation, and other
interface components.

HTML 5 The HyperText Markup Language or HTML is

the standard markup language for documents
designed to be displayed in a web browser.
XAMPP 8.2.4 XAMPP is a free and open-source cross-platform
web server solution stack package developed by
 Apache Friends, consisting mainly of the Apache
HTTP Server, MariaDB database, and interpreters
for scripts written in the PHP and Perl
programming languages.
JavaScript ES10 A scripting language largely used on the Web is
called JavaScript (JS). It is frequently found
integrated in HTML code and is used to improve
HTML pages. An interpreted language is
JavaScript.
jQuery 3.7.0 An open-sourced JavaScript library called jQuery,
makes it easier to build and use web applications.
 Chapter III

METHODOLOGY

1.1 Requirement Analysis

3.1.1 Project Design

The project will be developed using the Agile methodology to assess the developer's
ability to develop exceptional results that will meet the needs of the POS and repair services. As a
way to provide a positive experience for its users when it comes to tracking repair items and
owners to easily get sales reports. Agile methodology is a project management approach, also
known as the lifecycle model, that places a high emphasis on iterative development. This
framework is well-suited for this project due to its flexibility and user-centered design, which
consists of seven processes starting with planning, designing, development, testing, deployment,
and review.

Figure 5: Agile Method

Plan. Interview with the Lifezone Electronics owner for gathering data regarding the process of
sales and repair services and the problems encountered.
Design. The UI design and database structure are designed to help users and administrators
manage sales report, and repair services tracking.

Develop. To create the web-based system, use the software and hardware requirements. Any
necessary adjustment must be made immediately after considering results.

Test. The proposal respondents use the system to observe if it is surely reliable, efficient, and
effective in terms of its functions, as in contrast to their manual scheme. Testing the proposed
system is serious because it allows the association to regulate whether the system is fully
successful and can make the respondents’ work easier and faster.

Deploy. We can establish the system with the client if it is 100% secure and free of errors. The
client helps the system get better by giving feedback after its establishment.

Review. The system needs review to determine if there are necessary adjustments to be made and
if the necessary data is correctly monitored and assessed.

Launch. In final phase, after the proponents do testing and review the system to address the bugs
and issue based on the feedback collected, the system will be ready to launch and can be used by
the client.

3.1.2 Current Technical Situation

 Figure 6: Current Technical Situation

This is the current sales monitoring process of Lifezone Electronics: when a customer
walks into the shop, they either purchase an item or request a repair for their item. After making
the payment at the cashier, the owner manually records the transaction in the record notebook.

3.1 Requirement Documentations

3.2.1 Software and Hardware Requirements

 Table 2

SOFTWARE REQUIREMENT

Component Description

POSTGRES It is an advanced, open-source relational

database management system (RDBMS) known
for its robust feature set, extensibility, and
adherence to SQL standards. It supports a wide
range of SQL features and provides ACID
(Atomicity, Consistency, Isolation, Durability)
compliance, making it suitable for handling
complex and high-volume data workloads.

XAMPP 8.2.4 Users can set up a local web server environment

on their computer by using the software package
known as XAMPP Server, which consists of the
Apache web server, POSTGRE database, PHP,
and Perl. Before deploying web applications to
a live server, it offers a simple and practical
method for developing and testing them locally.

Visual Studio Code 2022 Microsoft created Visual Studio Code, an

efficient and functional source code editor. It
offers a simple user interface along with strong
tools for editing and debugging code in several
programming languages.

PHP 8.0 The server-side programming language PHP

(Hypertext Preprocessor), which was created for
web development, is very popular. To create
responsive websites, it is executed on the web
server and integrated within HTML

code.

BOOTSTRAP 5.1 A common front-end framework called

Bootstrap is used to create websites and web
 applications that are mobile- first and
responsive. It offers a selection of pre-built
JavaScript features, responsive layout templates,
and CSS styles to make it simpler to produce
eye-catching and combined designs.

HTML 5 The common markup language used to create

and specify the structure of web pages is called
HTML (Hypertext Markup Language). It is
made up of a collection of tags and components
that specify the structure and content of a
webpage.

CSS3 Is a rule-based language, where you indicate the

groups of styles that should be used on
components or groups of elements on your web
page to establish the rules.

JavaScript ES10 A scripting language largely used on the Web is

called JavaScript (JS). It is frequently found
integrated in HTML code and is used to
improve HTML pages. An interpreted language
is JavaScript.

jQuery 3.7.0 An open-sourced JavaScript library called

jQuery, makes it easier to build and use web
applications.

Google Chrome The free Google Chrome web browser can be

used to access the internet and operate web-
based programs.

Table 3

HARDWARE REQUIREMENTS

Component Specification
 Processor: Intel Core i3 (4th Generation) or AMD
equivalent
Laptop/Computer
RAM: 4 GB

Storage: 10 GB free space (for browser cache and

temporary files) HHD /SSD

Graphics: Integrated graphics

Display: 1366x768 resolution

3.1.2 Functional and Non-Functional Requirements

3.1.2.1 Functional Requirements

 Point-of-sales management :
- Can monitor daily and process sales transactions.
 Repair Services Tracking:
- Can trace repair services status of the customer’s repaired item.
- Can generate a tracking number for all repaired items.
 Data Backup and Security:
- Implements regular data backups to ensure the safety and integrity of
collected information.
 Customer Page :
- Can track the status of the repaired items using the tracking number
provided by the system .
3.2.2 Non-Functional Requirement

 Efficiency:
- The system’s user interface should be simple to use, intuitive, and navigable.
 Performance:
 - The system ought to be receptive and offer prompt user interaction response
times. The repair service tracking integration should load and display the repaired
status.
 Reliability:
- Backup data processes should be in place to prevent data loss.

3.2 Design of Software, System, and Processes

3.2.1 System Architecture

Figure 7. System Architecture

The diagram illustrates how information flows between client and server components in
networked applications

3.3.2 Context Diagram

Context Diagram for Point-of-Sale (POS) and Repair Service Tracking for Lifezone
Electronics
 Figure 8. Context Diagram

3.3.3 Data Flow Diagram

Figure 9.DFD for Admin/Staff Login

Narrative: It shows two users: the system administrator (a staff member of Lifezone Electronics)
and the customers. The Lifezone Electronics staff adds information to the system for POS and
Repair Service Tracking, and customer can track the status of the repaired item.
 Figure 10. DFD for Customer Login

In this diagram, the users can login by using any type of cellphone or computer with an
internet connection in order to view repaired status of the item on the system that has been stored
in a database. Once the user already has a tracking number, they can login to the system anytime
and anywhere at any location to access the website.

Figure 11.DFD for Administrator/Staff Login

In this diagram, the admin and staff can login and can update the repaired status on the
system that has been stored in a database. Once the admin/staff already register the customer the
system can automatically generate tracking number this will store at the services storage
database.
3.3.4 Functional Decomposition Diagram

Figure 11. Functional Decomposition Diagram

3.3.5 Entity Relationship Diagram

Figure 12. Entity Relationship Diagram

 3.3.6 Data Dictionary

Table 4

DATA DICTIONARY

Entity name Field name Field type Length Key Description

keyctr Character 30 PK To serve as a
Varying unique
number
user_tbl employee_id Character 30 FK To serve as
Varying an ID
number of
the employee
username Character 30 Not The
Varying Null username of
the employee
password Character 50 Not Password of
Varying Null the employee
customer_id Bigint PK To serve as a
customer ID
of the
customer
Customer_tbl firstname Character 30 Not First Name
Varying null of the
customer
lastname Character 30 Not Last Name
Varying Null of the
customer
Email Character 50 Not Email
Varying Null account of
the customer
phone_number Character 13 Not Phone
Varying Null number of
 the customer
city Character 50 Not City address
Varying Null of the
customer
province Character 50 Not Province
Varying Null where the
customer
lived
trail Character 100 Not To serve as a
Varying null history of the
customer
register
account
employee_id Character 30 PK To serve as
Varying an ID
number of
Employee_tbl the employee
firstname Character 30 Not Serve as a
Varying Null Firstname of
the employee
lastname Character 30 Not Serve as the
Varying Null lastname of
the employee
emp_position Character 50 Not To identify
Varying Null the position
of the
employee in
the shop
phone_number Character 13 Not Serve as a
Varying Null contact
account of
the employee
trail Character 100 Not To serve as
Varying Null the history
 input
tracking_id Bigint PK To serve as
an tracking
ID number
sales_service_main of the
customer
customer_id Bigint FK To serve as
an ID
number of
the customer
employee_id Character 30 FK To serve as a
Varying ID number
of the
employee
status_code Integer Not To identify
Null the repaired
status of the
customer
date_started Date Not Serve as
Null indication of
the repaired
item date
started
date_expectation Date Not Serve as
Null indication of
the repaired
item date
expected to
be done
total_price Double Not To identify
precision Null the total
price of the
repaired
sales item
 description Description 100 Not To serve as
null the sales
service
description
trail Character 100 Not To serve as
Varying Null an sales
service
description
keyctr Bigint not To serve as
a unique
null
number
tracking_id Integer Not To serve as
sales_service_details_tbl Null an tracking
Id of the
item
serv_code Integer Not To identify
Null the code of
the service
description Character 100 Not To serve as
Varying Null an sale
description
price Double Not To identify
Precision null the price of
the item
qty Integer Not To identify
null the quantity
of the item
total_price Double Not The total
precision null price of the
item
Date_actual_done Date Date To identify
the actual
date of the
item repaired
done
 trail Character 100 Not Serve as a
varying Null history of the
repaired item
item_code Integer PK To serve as
an code
item_tbl number of
the item
item_description Character 100 Not To serve as
varying Null an item
description
item_price Double Not To identify
precision Null the price of
the item
trail Character 100 Not
varying Null
sales_item_id Bigint Not To serve as
null an ID
sales_item_main_tbl number of
the sales
item
date_sale Bigint Not To serve as
null an date of
the sale
total_price Double Not To serve as
precision null an total price
of the item
sales
trail Character 100 Not To serve as
varying null the history
status_code Integer Not To serve as
status_tbl null an code of
the repaired
status
status_descriptio Character 100 Not To serve as
 n varying null an status
description
of the
repaired item
trail Character 100 Not To serve as
varying null an history of
the status
input
serv_code Integer Not To serve as
services_tbl Null an service
code
serv_description Character 100 Not Serve as the
Varying Null service
description
serv_price Double Not Serve as the
precision null service price
of the
repaired item
trail Character 100 Not To serve as
varying null an history of
the services
input
sales_item_details_tbl keyctr bigint Not To serve a
null unique
number
sales_item_id Integer Not To serve as
null an ID of the
sales item
item_code Integer Not To serve as
null an the code
of the item
price Double Not To serve as a
precision null price of the
item
 qty Integer Not To serve as a
null quantity of
the item
total_price Double Not To identify
precision null as a total
price of the
item
trail Character 100 Not To serve as
varying null the history of
the sales
item details

3.2 Development and Testing

3.4.1 Development
The proponent must complete the following procedures before developing POS
and Repair Services Tracking for Lifezone Electronics.
 First, the proponents will conduct an interview where we will ask questions,
get explanations, and confirm details about how our proposed system would
be managed for.
 Second, proponents gather relevant and helpful information for the
development of POS and Repair Services Tracking for Lifezone Electronics.
 Lastly, the proponents begin to plan the system’s design and flow.

3.4.2 Testing
3.4.2.1 Alpha Testing
The modules of activities and tests to be executed in the system are shown in the
table below.

Table 4
ALPHA TESTING

Module Activities Duration

 Administra  Can log in
 5 minutes
tor  Can manage  1 hour
 20 – 30
accounts
minutes
 Can update
repaired status

Customer  Can enter the tracking  5 minutes

number  10 minutes
 Can search item  1 hour
through tracking
number
 Can view repaired
status

3.4.2.2 Beta Testing

Initiated by programmers for users, beta testing is a test that is particularly helpful in
identifying whether the system's needs and objectives have been reached. Purposive sampling is
used to choose the test subjects after determining that each respondent possesses the skills and
credentials required to evaluate the system. The designers also kept a record of all comments and
ideas to help them in the revision process.

3.3 Implementation Plan

Table 5

IMPLEMENTATION PLAN

STRATEGY ACTIVITIES PERSONS INVOLVED DURATION RESULTS

Plan Interview and  Owner of Lifezone 1-3 days
gathering data. Electronics shop.
 Developers
Design UI and database 4 weeks
structure design with  Developers
software systems.
Develop Software system, use 3-4 weeks
the software and  Developers
hardware
requirements.
Test System testing.  Developers 2 weeks
Deploy System deployment to  Owner of Lifezone 3 weeks
the client. Electronics shop.
 Developers
Review System review.  Owner of Lifezone 2 weeks
Electronics shop.
Launch  Owner of Lifezone 2 weeks
Electronics shop,

3.4 Screen Layout

Figure 13. Administrator and Staff Login of the System

 This module is intended for login administrator and staff for POS and Repair Services
Tracking for Lifezone Electronics, which requires the usage of a username and password by a
admin or staff in order to access the system.

Figure 14. Administrator and Staff Dashboard Page

Lifezone Electronics offers a user-friendly interface with two distinct options: staff
members can either navigate to the repair section by clicking the blue ‘Repair Items’ button or
access the purchase section via the green ‘Purchase Items’ button.

Figure 15. Item Management

This module is intended for item management for the item available Tracking for
Lifezone Electronics.
 Figure 16. POS Sales Transaction

This module is intended to easily navigate and ensures that customers can quickly track
the repaired item.

Figure 17: Purchace Items Feature

 The purchase items feature displays a list of items available for purchase, including their

categories, prices, and actions to manage each item.

Figure 18. Repair Services Management Dashboard

This dashboard provides a comprehensive view of the repair services management system,
listing service codes, descriptions, and prices, with options to edit and delete service entries.

Figure 19: Repair Services Transactions

The repair items module allows tracking of individual repair cases, detailing the item, issue
and status
 Figure 19: Repair Services Transactions

This interface presents the transactions for repair services, including details such as date,
item, issue, status, and actions to manage each transaction

Figure 20: Customer View page

The customer for view page for Lifezone Electronics enables users to enter and confirm their
tracking number to access their service transactions.

Figure 21. Services Transactions Dashboard

This section provides a summary of service transactions, listing items, issues, and status to
help users keep track of their service history.
 Figure 22. Lifezone Electronics Staff Management

This figure displays the staff members of Lifezone Electronics, showcasing their various
positions within the company. It emphasizes the team's diverse roles and responsibilities, which
contribute to the effective management and operation of the business

Figure 24.Sales and Repair Reports

This figure illustrates the sales and repair reports dashboard of Lifezone Electronics. It
provides a visual summary of total sales, and total repairs, helping the company track
performance and manage operations efficiently.
 Figure 24. Sales Report Dashboard

The final figure illustrates an analytics dashboard for Lifezone Electronics, summarizing total
sales, total repairs, and recent activities with corresponding charts for better business insights.

REFERENCES

Oktafianto, & Ismail. (2021). PERANCANGAN SISTEM INFORMASI POINT OF SALE

(POS). Semantic Scholar. Retrieved from
https://www.semanticscholar.org/paper/PERANCANGAN-SISTEM-INFORMASI-POINT-OF-
SALE-(POS)-Oktafianto-Ismail/d31569e12318075304238d9f551f7fc9f30e2b27

Winarto, A., & Romindo, D. (2023). Sosialisasi Sistem Point of Sale Berbasis Web pada Toko
Roti Nia Bakery. Semantic Scholar. Retrieved from
https://www.semanticscholar.org/paper/Sosialisasi-Sistem-Point-of-Sale-Berbasis-Web-pada-
Winarto-Romindo/47ebfec38929de811a46274453656ceb64b4dc6d

Rahman, A., & Abdullah. (2022). Sistem Informasi Point of Sale Berbasis Web pada Toko Roti
Bukit Raya. Semantic Scholar. Retrieved from https://www.semanticscholar.org/paper/Sistem-
Informasi-Point-of-Sale-Berbasis-Web-pada-Rahman-Abdullah/
2dd5ed85f30470112ee9b33e3fd016aee03b612f

Omar, D. M. Jr. (2021). SMS optimized consumer-grade tracking system for logistic applications.
ASEAN Engineering Journal. Retrieved from https://www.semanticscholar.org/paper/SMS-
OPTIMIZED-CONSUMER-GRADE-TRACKING-SYSTEM-FOR-Omar/
bb525e24118c7fc1c16cb780d9e86951a2be12df

Kambivi, H., Junirianto, E., & Fadhliyah, N. R. (2020). Development of inventory management
application: Case of TEP1AN. Semanticscholar. Retrieved from
https://www.semanticscholar.org/paper/Development-of-Inventory-Management-Application-Of-
Kambivi-Junirianto/a450fb7f6a1119df9a669ae7887f78a0618c3e20

Mendoza, A. R. (n.d.). POINT OF SALE SYSTEM WITH INVENTORY FOR ARM’S FOOD
CORNER. *International Journal of Advanced Research in Computer Science. Retrieved from
https://www.semanticscholar.org/paper/POINT-OF-SALE-SYSTEM-WITH-INVENTORY-FOR-
ARM%E2%80%99S-FOOD-Mendoza/6e6135a812e1293b9f23bd4631c7160e5b8b95fb