Author: T-bao

TABLE OF CONTENTS

ABOUT THE SYSTEM II
SYSTEM REQUIREMENTS III
Landing Page 2
Login & Register 3
USER
Home 4
Guidelines 5
Services 6
ADMIN
Dashboard 16
Services Requests 17
Sales Report 25
Settings 29
MIS
Logs 32
Create User 33
Users 34
Developers 35

I

ABOUT SYSTEM

CNSC Auxiliary/IGP Web-Based System is designed for the IGP / Auxiliary Services of Camarines Norte State College. It focuses on the improvement of the Auxiliary Services’ transactions which will be converted to a web-based system. It can be accessed by public users, students, employees, other government agencies, IGP staff and other stakeholders. This web-based system is designed to monitor the reports and check the availability of all the services of the CNSC Auxiliary/IGP. It will also notify the administrator if a student or a public user wants to rent a room at the College Dormitory, Amphitheater, Pavilion, and/or the two mini buses. This system will also notify clients on the availability of their requested service and billing statement will be sent for dorm occupancy.

II

SYSTEM REQUIREMENTS

Minimum Software / Requirements
Windows-based and / or Linux-based Operating System
Stable Internet Connection
MySQL
XAMPP
Web browser

Minimum Hardware / Requirements
At least 2GB RAM
1TB ROM
Speed: 2.2 GHz
32 or 64 bit Operating System

III

When accessing the CNSC Auxiliary/IGP Web-Based System, open a web browser

Type this URL or link in the address bard of your web browser:
site.cnsc-auxiliaryigp.com

1

LANDING PAGE
The CNSC Auxiliary/IGP Web-Based System has a website. In this page, it shows different services of Auxiliary/IGP such as renting of minibus, amphitheater, hostel, dormitory, stall, catering and printing. It also shows the mission and vision of CNSC.

2

Register an Account
Before accessing the main page, users must register for the CNSC Auxiliary/IGP Web-based System by filling out the following required information: Name, E-mail Address, Password, and Confirm .Password. Then, select “Register” to access the Registration page.

LOGIN PAGE
Users who have previously registered for the CNSC Auxiliary/IGP Web-based System may login by entering the registered e-mail address and password. Select “Login” to begin using the web application. You can click the Remember Me checkbox to save the e-mail address and password when you access the website. This is also the login form used by admin and MIS when logging in to the system.

3

HOME PAGE
In this homepage, it will show the guidelines, services, and about the Auxiliary/IGP. If you click the home button, it will show the different services of the Auxiliary/IGP office. It also shows the price of their services.

4

GUIDELINES PAGE
Guidelines button - it will show the policy guidelines where you can read the different policies of the Auxiliary/IGP office. It includes the policy guidelines on the use and rental of college facilities. The following are the policy guidelines that shall be adopted to regulate the use of college property and facilities by students, faculty and personnel, affiliated and affiliated organizations or groups. Part of the regulation is the renting out of the college property and facilities as an income generating activity of the College.

5

SUBMIT REQUEST
This page shows the confirmation message before submitting the request form. If you click “Yes,” the request form will be sent directly to the Auxiliary/IGP office. If you click the “No” button, it will go back to the fill out form.

CANCEL REQUEST
If you click “Yes”, your request form that you filled out will be cancel. If ‘you click ’No”, it will go back to the request form .

6

AMPHITHEATER REQUEST FORM
In this page, if you click the Services button, you can choose any services to request for the services. For example, if you click Amphitheater. You need to fill out the required information to be able to submit the request form. Select the service that you want to avail, fill out the required information in the request form. Then, select “Submit” button, it will be directly received by admin which is the Director of the CNSC Auxiliary/IGP.

7

HOSTEL REQUEST FORM
In this page, there are two types of room of Hostel. It displays the Standard Rooms and Deluxe Rooms wherein it shows the details and rates.

8

HOSTEL REQUEST FORM
In this page, if you click Book Now button, you can choose between Standard and Deluxe Rooms. Select the service you want to avail, fill out the required information in the request form. Then, click the “Submit” button.

9

DORMITORY REQUEST FORM
If you click Dormitory button, you need to fill out the required information to be able to submit the request form. Select the service you want to avail, fill out the required information in the request form, then, click “Submit”.

10

CATERING REQUEST FORM
Select the service you want to avail, fill out the required information in the request form. If you click Catering button, you need to fill out the required information to be able to submit the request form. then, click “Submit” and it will be received by the admin which is the Director of the CNSC Auxiliary/IGP.

11

The user can add another set of food, just click the ( + ) button.

The user can remove another set of food, just click the ( - ) button.

In Catering section, you can view the total payment of your selected food, just click the Compute button.

12

PRINTING REQUEST FORM
In this page, you can choose any service to request from the services. If you click Printing button , you need to fill out the required information to be able to submit the request form. If you click the submit button, it will be received by admin which is the Director of the CNSC Auxiliary/IGP.

13

The user can select Colored Photocopy, Layout, Offset Printing, Risograph, Bookbinding, Laser Printing and any other type of printing services

After selecting the type of print, you can now fill out the required information. The user can add another type of printing, just click the (+)button and it will add another tab and fill out the required information.

The user can also delete - button if it is accidentally click.

14

If the user completed requesting the services, it can Logout anytime, just click the Logout button. If the user click the “Cancel” button, it will go back to the page where you left.

15

DASHBOARD PAGE
This page is the admin side wherein it view the latest report of the every service. The admin side include the dashboard, request of every service, calendar, reports of every service, and settings. In the Dashboard section, it will show the latest reports of different services in the Auxiliary/IGP office.

This is the notification of every pending request. If you click any type of services, it will go directly to that particular service.

16

REQUESTS
This is the request of every public user wherein the admin can approve or disapprove the request based on the schedule on the CNSC Calendar.

17

1

2

3

4

1. This button is used to limit the view of records of requests in the table.

2. This is used to sort the records numerically and alphabetically.

3. The admin can also search a particular request and it can show the records of requests.

4. Pagination, use to view the other list of request that cannot view in the table.

18

If you click the view button, admin will approve or disapprove the request form to add in the schedule if it is available. If the schedule is unavailable, the admin will send message to check their e-mail. The e-mail contains a notice of information wherein it will message the user if it is available or not.

19

NOTICE OF INFORMATION
If you click the notice of information, this will view. If the schedule is unavailable, the admin will send message to check their e-mail. The e-mail contains a notice of information wherein it will message the user if it is available or not.

20

CNSC CALENDAR
The CNSC Calendar can show the different schedule of every service/s. It can also view and cancel the schedule of every service/s. It can also view the name of person/s who reserved the particular schedule.

21

ADD EVENTS
If you click the blue button at the upper left of the page, it will show the add events window where the admin has to fill out the required information to schedule an event. Admin can add or save a schedule and it will show the schedule to the CNSC calendar.

22

If you click the red button at the upper left of the page, it will show the add events window where the admin has to fill out the required information to schedule an event. Admin can add or save a schedule and it will add to the CNSC calendar.

23

On the CNSC Calendar, It will show the schedule of the event on every service.

If you click the blue button on the particular date in the CNSC Calendar, it will go to this page wherein you can “Cancel Activities”.

24

Sales Report
If you click the Sales Report button, this page shows the sales reports of every service. The admin can select and view the particular sales reports based on the services.

25

Sales Report
This page shows the sales reports of every service. Sales reports include date, name of occupants, particulars, quantity, unit, unit price, total amount or number, and remarks. Admin can select and view the sales report based on the selected month and year. It can also generate report wherein it will view a PDF form and can be downloaded.

26

After clicking the Generate Report button, the admin can view the sales report on the previous year and month, just select what month and year and it will go directly to that particular month and year wherein it will show a report in a PDF format and it can be downloaded.

27

GENERATED REPORT PAGE
This page generates the sales report of the services you want to view. Sales reports are in PDF that can be downloaded or printed by the admin. It will show the sales reports of every services in the Auxiliary/IGP.

28

SETTINGS
If you click Settings, it will view the setting of every service wherein you can update the data in the system. You can also update the price and capacity of minibus, hostel, dorm and other facilities.

29

1

2

3

1. If there’s another room, the admin can add the details to update the system. Click + button and fill out the Room Type and Rate per Month. After that, click the Add button and it will update the system.

30

2. The admin can also update the details to the system. Click View button and fill out the Room Type and Rate per Month. After that, click the Update button and it will update the system.

3. The admin can delete details to the system. Click Delete button and after that, click “Yes” if you want to delete, it will update the web-based system and “No” if not.

31

MIS LOGS
If you click the Logs button, it will show the system logs (username, date, time, and activity). If the currently selected task allows searching for records, a search box is located in the upper right corner above the main content area. Enter a key term to start searching for records.

32

CREATE USER
In this page, MIS will fill out the required information to create users and set user-level. If creating an account is finished, the user can now access the system depending on the user-level that MIS created.

33

USERS
If you click the Users tab, it will show the list of users, including their email, name, date created, and time. MIS can access the logs including the user that access/request in the system. It will also show the list of users that log into the system and MIS can create a user for admin side.

If you click the Backup button, all the database tables will be save to your device.

34

DEVELOPERS

CYRINE V. DIPASUPIL
TECHNICAL WRITER
09075611194
dipasupilcyrine1435@gmail.com
Purok-2, Barangay Angas, Basud, Camarines Norte

HONEY JOY D. GAMER
BACKEND DEVELOPER
09497523712
hanee.gamer@gmail.com
Purok-7, Brgy. Batobalani, Paracale, Camarines Norte

MARVIN JAY I. MORESCA
FRONTEND DEVELOPER
09305827291
marvinmoresca@gmail.com
Purok-2, Brgy. Camambugan, Daet, Camarines Norte

RAYMOND Q. ZARATAR
ADVISER
09178115308
raymond_zaratar@yahoo.com

EVELYN M. BAESA
SP MODERATOR
09175602726
Vyneel_baesa@yahoo.com

AUTHORS:
CYRINE V. DIPASUPIL
HONEY JOY D. GAMER
MARVIN JAY I. MORESCA
CO-AUTHORS
EVELYN M. BAESA, MIT
RAYMOND Q. ZARATAR