💰 MotorPH Payroll System (Group 8)

📖 Overview

MotorPH Payroll System is a Java-based payroll management system designed to automate employee salary calculations, deductions, attendance tracking, and leave management. The project follows Advanced Object-Oriented Programming (AOOP) principles and integrates with PostgreSQL 16 using JDK 23 to securely store and manage payroll data.

---

👥 Development Team

• Shekinah Jabez Florentino
• Lenie Joice Mendoza
• Maricar Punzalan
• Mary Jullianne Maycacayan
• Nicolas Lugtu
• Paulo Martin Molina

Under the guidance of: Sir Glenn Baluyot

---

🔧 Prerequisites

Before running this project, ensure you have installed:

• Java Development Kit (JDK 23) → Download JDK 23
• PostgreSQL 16 → Download PostgreSQL 16
• Apache NetBeans (Recommended IDE) → Download NetBeans

---

🛠 Database Setup: Restoring motorph_db.dump

Step 1: Download motorph_db.dump

Download the database dump file via the following link:
📥 Download motorph_db.dump

Do not move the file from your Downloads directory.

---

Step 2: Open PowerShell as Administrator (Windows Users Only)

1. Click on the Start Menu
2. Type PowerShell
3. Right-click on Windows PowerShell and select Run as Administrator
4. Confirm the User Account Control (UAC) prompt

⚠️ Note: Running PowerShell as Administrator is required to avoid permission issues when restoring the database.

---

Step 3: Navigate to the Downloads Folder

In PowerShell, run:

cd $HOME\Downloads

---

Step 4: Restore Database Using PowerShell

Run the following command to restore the database:

& "C:\Program Files\PostgreSQL\16\bin\pg_restore.exe" -U postgres -d postgres "motorph_db.dump"

💡 Notes:

• This assumes that PostgreSQL is installed in the default location (C:\Program Files\PostgreSQL\16\).
• If prompted, enter your PostgreSQL password.
• The database will be restored under the name "motorph_db" (you can modify this if needed).
• This assumes that the admin role is set up in PostgreSQL, as shown in pgAdmin under Login/Group Roles.
  • If the admin role does not exist, create it manually in pgAdmin:
    1. Open pgAdmin.
    2. In the left panel, expand your server.
    3. Connect to PostgreSQL 16.
    4. Scroll down, then right-click on Login/Group Roles.
    5. Select Create → Login/Group Role.
    6. In the Name field, enter:

       admin
       

    7. Click Save.

---

Alternative Database Setup (For Existing PostgreSQL Users)

If you already have PostgreSQL installed and prefer to use its built-in Query Tool:

1. Download the SQL file from the following link: 📥 Download motorph_db.sql

2. Open pgAdmin (or your preferred PostgreSQL client).

3. Connect to your PostgreSQL 16 server.

4. Right-click on Databases and select Create → Database.... Name the new database motorph_db.

5. Right-click on the newly created motorph_db and select Query Tool.

6. In the Query Tool window:

   • Click on the "Open file" icon (usually looks like an open folder) in the toolbar.
   • Navigate to your Downloads folder (or wherever you saved motorph_db.sql).
   • Select the motorph_db.sql file and click "Open". The SQL commands will now appear in the Query Editor pane.
   • To execute the contents, click on the "Execute/Refresh" icon (usually a lightning bolt or play button). This will run all the SQL commands in the file, creating the necessary tables and inserting data into your motorph_db database.

🔧 Configure the db.properties File

In NetBeans, navigate to:

MotorPH_AOOP> Other Sources > src/main/resources > config

Ensure your db.properties file matches your PostgreSQL setup:

db.url=jdbc:postgresql://localhost:5432/motorph_db
db.username=postgres
db.password=[yourpassword]

---

📁 Project Documentation

🧾 Homework 3 – Unified Plan for MotorPH Payroll System Expansion

This document outlines the strategic roadmap for scaling the MotorPH Payroll System. It includes proposed infrastructure changes, resource allocation, and branch-level coordination to ensure a seamless rollout.

---

🧪 Homework 7 – Unit Testing

This document contains detailed unit test cases used to validate key modules in the MotorPH Payroll System. It ensures that all components perform correctly and catch errors early during the development cycle.

---

📄 Expanded MotorPH Payroll System – Software Requirements Specification (SRS)

This document serves as the official Software Requirements Specification (SRS) for the expanded MotorPH Payroll System. It includes purpose, scope, user needs, features, non-functional requirements, and diagrams.