This project was part of a course project that manages student grant proposal for research journal/conference on a national and international level.
This project was developed with PHP using MariaDB RDBMS (MySQL database) and Apache2 webserver (in XAMPP).
-
Admin User
-
Manager User
-
Engineer User
Any finished maintenances are archived in the maintenance history section.
The project consist of the following sections based on the user role's POV:
- Homepage
All authenticated users can see a button to apply for their unpublished research/journals.
- Application Form
Users can apply for grant proposal using this form.
- Grant List
Users can view their own grant proposals and track which reviewer stage they are in, or requested for change or denied.
- Grant Applicants
Reviewers can view the grant applicants in a table according to the status of the grant.
The stages of grant proposal review can be seen as follows.
- First Reviewer
This stage of the review is done by the Head of Study Program for this publication level.
- Second Reviewer
This stage of the review is done by the Student and Alumni Affairs (SAA) for this publication level.
- Third Reviewer
This stage of the review is done by the Deputy Rector IV for this publication level.
- First Reviewer
This stage of the review is done by the Head of Study Program for this publication level.
- Second Reviewer
This stage of the review is done by the Central for Research and Support (CRCS) for this publication level.
- Third Reviewer
This stage of the review is done by the Deputy Rector IV for this publication level.
- Grant Progress
Users can track the progress of a single grant proposal from this page.
Considering the relatively small size of the project and tight deadline, testing were performed manually that tests the common workflow of the web-application used by each user roles.
- ❌ Organize the project structure using MVC principles.
- ❌ Add pagination, show/hide columns, and sortable column functionalities to the table.
- ❌ Perform proper testing using PHPUnit.
The third-party library used was only Bootstrap to quickly stylize elements and use web components with ease.
External Source
- Bootstrap ( 5.2.3 )
A dummy database has been provided in .sql format to test out the web-app. The following are the credentials of the dummy users:
- Student User
Email: [email protected] (FET Student)
Pass = brandon
Email: [email protected] (FOE Student)
Pass = lolieh
- Faculty Member User/Head of Study Program
Email: [email protected] (Faculty Member for FET)
Pass: chen
Email: [email protected] (Faculty Member for FOE)
Pass: stephen
Email: [email protected] (HoSP for FET)
Pass: john
Email: [email protected] (HoSP for FOE)
Pass: david
- CRCS (Center for Research and Scholarship)
Email: [email protected] (CRCS)
Pass: ethan
- SAA (Student Affairs and Administration)
Email: [email protected] (SAA)
Pass: liam
Email: [email protected] (ViceRectorIV)
Pass: marco [3829486b93ec44395f0b980424bae9b6fb07b7bc]