DOLE-X HUMAN RESOURCE INFORMATION SYSTEM

1. Welcome to DOLE-X HRIS

DOLE-X Human Resource Information System (HRIS) is an ongoing-development application which aim to cater operations in Human Resource. The system aims to provide as a data storage for employee records which is essential in filling up of Personal Data Sheet (PDS). Thru DOLEX-HRIS, employees can fill up and update employee records and upload important user documents in the system. Since the updating of data is centralized, employees and HR Unit can view and update employee records real-time. 

 

As of the current version release, DOLEX-HRIS has the following functional modules:

  • Employee Registration
  • Employee Profile Updating
  • Uploading of Personal Documents
  • User Management (Admin)
  • Reports Generation (Admin)

 

The following modules are developed but not yet deployed (for further clarification of requirements)

  • Service Record Management module
  • Leave Management module

 

IT Unit aims to futher extend the functions and modules of the system in compliance to PRIME-HRM

 

2. Server Details

2.1. Offline Server (Development Stage)

System was developed locally through XAMPP, 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.

 

XAMPP Version : 7.3.11
Control Panel Version : 3.2.4
PHP Version: 7.3.11 (VC15 X86 64bit thread safe) + PEAR
phpMyAdmin Version : 4.9.1
OpenSSL Version : 1.1.0g

2.2. Live Server

DOLE-X HRIS is deployed through shared hosting provided by inMotion Hosting (Purchased last April 2022)

Above: System Architecture

3. System Details

3.1. System Process Flowchart

Above: DOLE-X HRIS Process Flowchart

3.2. Use Case Diagram

Above: DOLE-X HRIS Use Case Diagram

As of version 1, DOLEX-X HRIS has 3 main users for the system. 

  1. Employee
  2. HR Admin
  3. System Admin

 

System Admin -  Oversees the operation of the system. System Admin's primary role is to generate report. 

 

Human Resource (HR) Admin - HR Admin mainly is in charge of managing the employee records that are encoded or profiled in to the system. HR Admin account can create user account, update employee records (such as profile and service records), upload supporting documents,generate PDS and reports. Primarily, HR Admin is the one in charge of user creation, thus, this account can access all accounts and employee records in the system.

 

Employee - Main functions of an Employee account is updating of employee records. This account can update the profile and upload supporting documents. An employee account can ONLY update its own record. An employee account cannot update other employees' account

3.3. Database Structure Diagram

In the figure above, tbl_employee is the main table which is the also the table to be queried during login. tbl_employee extends its data by reference other tables through the foreign key EMPID. This database is structure in phpmyadmin thru InnoDB engine with utf8mb4_general_ci collation.

Current database name used in the web server (inMotion Hosting) is dolexp5_hris_db

Database User credentials in order to use the database:

 

Username : dolexp5_hrisadmin

 

Password : dolexp5_hrisadmin

3.4. File Structure Diagram

The main file to access is the admin.php file, which is located in the main directory of the dolex-hris project folder. The common file structure of the modules are as follows:

 

a. Module Page file - This document contains the HTML tags and overall layout of the page. Example of this files are the following - viewEmployee.php, serviceRecord.php, employee_detail.php

 

b. Javascript Function File - This file contains the javascript functions of the html page. All events such as button action and click function, including DataTable function, are called in this file. This file acts as function call to call API that will perform data functions to the database. Example of this file are - viewEmployee.js , serviceRecord.js

 

c. PHP API Action File - This file handles the S_POST Request sent by Javascript Function File through JQuery Plugin. This file is in charge of performing SQL Queries to the database. Majority of the queried data are called using this action files. Example of this file are - viewEmployee_action.php, serviceRecord_action.php, employee_detail_action.php

4. User Guide

User guide can be downloaded through the link provided. This user guide contains the broad steps in filling up of details in the system. The guide shows the logging in to the system, updating employee records and uploading of supporting documents. 

HRIS USER GUIDE 1667825619_14906.pptx 4MB

Default admin account for the system is: 

 

Username : admin

Password : 1234

Please do not share admin acount to anyone, only authorized personnel are allowed to use the admin account

 
powered by tomehost