Team (SR-33) Members:

1)Siddharth Dighe (D11-13)
2)Sagar Pandey (D11-36)
3)Gauraang Prabhudesai (D11-60)

Chosen Problem Statement:

SR-PS-01--Crime management

Approach followed:

We used HTML, and PHP to design webpages which were designed with some CSS.
An Apache server and MySQL database were set up using xampp.
The user can be either a common citizen or a police officer who will open the Landing page[Fig 1]. Here the user has 3 options to choose from

1. Login for police officer
   2)File an FIR
   3)Send Feedback
   If the user is a police officer he/she will be redirected to the login page[Fig 2] and will be asked to enter their badge id as well as password to login. Successful logins will result in redirection to the police officer version of the web page[Fig 3] while unsuccessful logins will result in remaining on the same page.
   After successfully logging in the officer can choose from either viewing the filed FIRs[Fig 4] or the sent feedbacks[Fig 5].
   If the user is a common citizen then he/she wants to view information on the Mumbai Police or file a fir[Fig 6] or send feedback[Fig 7].
   Bootstrap is the modern CSS framework way of handling the site's user interface, it makes the site look responsive and makes the user experience nice. It is highly adaptable to the contents of the internet and functions smoothly. It makes it possible for a web page or app to detect the visitor's screen size and orientation and automatically adapt the display accordingly.

Features with UI Screenshots:

Drive link:https://drive.google.com/file/d/1gKF6NfPE-cnQWnnBLXhlg7gtH4P5Kysg/view?usp=share_link

Fig 1:Homepage

Fig 2:Login page

Fig3:Police Office landing page

Fig4: Viewing FIRs

Fig5: Viewing Feedbacks

Fig6: File FIRs

Fig7: Send Feedback

Any other screenshots/snippets/future descriptions:

Table Structure for Police Officer Login

Table Structure for Feedback

Table Structure for FIRs

The highlight of the website is real-time response and online FIR. Currently, the FIR has to be filed in the police station under whose the crime has been committed. But when the FIR can be filed online it is not necessary to visit the police station. The citizens can file it from the crime spot as well. So that they can get help much faster and the process would be fast-tracked. The website is user-friendly both for police officers and as well as citizens. The citizens don't need to log in to the platform to file the FIR. This is the major advantage for the citizens as they don't need to remember the user id and password.

Conclusion:
A fast and real-time response FIR has been made using html, php and xampp. The feedback form has also been introduced on the website