aravindvnair99/hall-management-system

A Hall Management System made originally for Amrita University based on HTML5, CSS3 + Materialize, JS, Node.js, MySQL

🏢 Hall Management System

A Hall Management System made originally for Amrita University based on HTML5, CSS3 + Materialize, JS, Node.js, MySQL

💻 How to contribute?

All contributions are welcome! Code, documentation, graphics or even design suggestions are welcome; use GitHub to its fullest. Submit pull requests, contribute tutorials or other wiki content -- whatever you have to offer, it would be appreciated!

Please read CONTRIBUTING.md for details on contributing.

📜 License

This project is licensed under the GNU General Public License v3.0 - see the LICENSE file for details.

👪 Team

• Rajesh Madathil - Mentor
• Sreevidya Balakrishnan - Mentor
• Renzil DSouza - Mentor - renzil
• Ashwini Nayak - Base HTML, CSS - Frontend - Ashnayak
• Abhishek Sai - Main HTML, CSS and JS - Frontend - Abhishek-Sai
• Aravind V. Nair - Frontend, Backend, Database, refactoring, bug fixes and security - AravindVNair99

See the full list of contributors who participated in this project and statistics.

❗ Prerequisites aka requirements

Please read Prerequisite file for details.

🔖 Releases

View all versions here.

📜 Changelog

Check the changelog here.

📝 I found some bugs or issues. Where do I report?

Report here in detail answering these questions:

• What steps did you take to make the bug appear?
• How can the bug be fixed? (In case you know)
• Which OS and which all packages / softwares / dependencies are you using?
• Have you tried any troubleshooting steps such as a reboot for example?
• Have you followed the prescribed prerequisites?

✉️ How do I contact the team?

Check here for the list of contributors. Contact one of them through their profiles.

📖 Faculty role:

• Print individual request.
• Should be able to send request for booking a hall.
• Should be able to cancel the request.
• Should be able to modify the request.

📖 Dean role:

• Should be able to accept the request.
• Should be able to reject the request.
• Should be able to view all the requests.
• Should be able to modify the request.
• Print all requests.

📖 Facility Department role:

• View all the requests.
• Print all requests.

hall-management-system's Issues

Update base

Update packages and frameworks

[DepShield] (CVSS 6.5) Vulnerability due to usage of mysql:2.18.1

Vulnerabilities

DepShield reports that this application's usage of mysql:2.18.1 results in the following vulnerability(s):

• (CVSS 6.5) CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

_{This is an automated GitHub Issue created by Sonatype DepShield. Details on managing GitHub Apps, including DepShield, are available for personal and organization accounts. Please submit questions or feedback about DepShield to the Sonatype DepShield Community.}

Update logo

Amrita new logo needs to be added.

[DepShield] (CVSS 7.5) Vulnerability due to usage of debug:2.6.9

Vulnerabilities

DepShield reports that this application's usage of debug:2.6.9 results in the following vulnerability(s):

• (CVSS 7.5) CWE-400: Uncontrolled Resource Consumption ('Resource Exhaustion')

---

Occurrences

debug:2.6.9 is a transitive dependency introduced by the following direct dependency(s):

• body-parser:1.19.0
        └─ debug:2.6.9

• cookie-session:1.3.3
        └─ debug:2.6.9

• express:4.17.1
        └─ debug:2.6.9
        └─ finalhandler:1.1.2
              └─ debug:2.6.9
        └─ send:0.17.1
              └─ debug:2.6.9

• morgan:1.9.1
        └─ debug:2.6.9

_{This is an automated GitHub Issue created by Sonatype DepShield. Details on managing GitHub Apps, including DepShield, are available for personal and organization accounts. Please submit questions or feedback about DepShield to the Sonatype DepShield Community.}

[DepShield] (CVSS 7.5) Vulnerability due to usage of express:4.17.1

Vulnerabilities

DepShield reports that this application's usage of express:4.17.1 results in the following vulnerability(s):

• (CVSS 7.5) CWE-22: Improper Limitation of a Pathname to a Restricted Directory ('Path Traversal')

_{This is an automated GitHub Issue created by Sonatype DepShield. Details on managing GitHub Apps, including DepShield, are available for personal and organization accounts. Please submit questions or feedback about DepShield to the Sonatype DepShield Community.}

Favicon

404 error

Responsive website

Adjust CSS for responsiveness.

Name instead of user ID in dean dashboard

Dean dashboard shows user ID instead of teacher name.

Accept and Reject button not working

Dependabot couldn't find a package.json for this project

Dependabot couldn't find a package.json for this project.

Dependabot requires a package.json to evaluate your project's current JavaScript dependencies. It had expected to find one at the path: /functions/package.json.

If this isn't a JavaScript project, or if it is a library, you may wish to disable updates for it in the .dependabot/config.yml file in this repo.

[DepShield] (CVSS 6.5) Vulnerability due to usage of mysql:2.17.1

Vulnerabilities

DepShield reports that this application's usage of mysql:2.17.1 results in the following vulnerability(s):

• (CVSS 6.5) CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

_{This is an automated GitHub Issue created by Sonatype DepShield. Details on managing GitHub Apps, including DepShield, are available for personal and organization accounts. Please submit questions or feedback about DepShield to the Sonatype DepShield Community.}

Separate page for halls

Use drop down menu.

SQL Injection

• Switch to parameterized query

Duplicate enteries

Need to set constraints for hall ID and time slot.

Facility table details missing

Need to add function to fetch details as well.