Crime File Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Crime File Management System

Crime File Management System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Crime,Complaints,Charge Sheet,Presioner,Criminals. Admin user can manage all the operations of Presioner,Criminals,Crime,FIR,Complaints and their details. Admin can create different type of reports of Crime,Complaints,Charge Sheet,Presioner,Criminals according to their choise and filters. You can Download PHP and MySQL Project Crime File Management System with source code and database from this site. We also provide Project Report of Crime File Management System.

Functionalities and their descriptions of Crime File Management System are as follows:

  • You can search records on various criterias. Such as Crime, Charge Sheet, Presioner, Criminals
  • Create, read, update and delete (CRUD) application has been implemented on Crime,Complaints,Charge Sheet,Presioner,Criminals
  • Keep the track logs of Complaints, FIR, Presioner ect
  • Advance search has been implemented on Complaints,FIR, Presioner
  • You can see all the details of the Crime, Charge Sheet, FIR, Presioner
  • All the modules FIR, Presioner, Complaints,Criminals, Crime are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Presioner.
  • All the Complaints,FIR, Presioner modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Crime data.

Modules of Crime File Management System and their descriptions:

  • Crime Module : Manage all the operations of Crime
  • Complaints Module : Manage all the operations of Complaints
  • FIR Module : Manage all the operations of FIR
  • Charge Sheet Module : Manage all the operations of Charge Sheet
  • Presioner Module : Manage all the operations of Presioner
  • Criminals Module : Manage all the operations of Criminals

Classes and their methods of Crime File Management System:

  • Crime Methods : addCrime(), editCrime(), deleteCrime(), updateCrime(), saveCrime(), searchCrime()
  • Complaints Methods : addComplaints(), editComplaints(), deleteComplaints(), updateComplaints(), saveComplaints(), searchComplaints()
  • FIR Methods : addFIR(), editFIR(), deleteFIR(), updateFIR(), saveFIR(), searchFIR()
  • Charge Sheet Methods : addCharge Sheet(), editCharge Sheet(), deleteCharge Sheet(), updateCharge Sheet(), saveCharge Sheet(), searchCharge Sheet()
  • Presioner Methods : addPresioner(), editPresioner(), deletePresioner(), updatePresioner(), savePresioner(), searchPresioner()
  • Criminals Methods : addCriminals(), editCriminals(), deleteCriminals(), updateCriminals(), saveCriminals(), searchCriminals()

Database tables and attributes of the Crime File Management System:

  • Crime Entity : Attributes of Crime are crime_id, crime_criminal_id, crime_name, crime_type, crime_description
  • Complaints Entity : Attributes of Complaints are complain_id, complain_name, complain_type, complain_description
  • FIR Entity : Attributes of FIR are FIR_id, FIR_name, FIR_type, FIR_description
  • Charge Sheet Entity : Attributes of Charge Sheet are charger_sheet__id, charger_sheet__fine, charger_sheet__type, charger_sheet__description
  • Presioner Entity : Attributes of Presioner are prisoner_id, prisoner_crime_id, prisoner_name, prisoner_mobile, prisoner_email, prisoner_username, prisoner_password, prisoner_address
  • Criminals Entity : Attributes of Criminals are criminal_id, criminal_crime_id, criminal_name, criminal_mobile, criminal_email, criminal_username, criminal_password, criminal_address

Database definition of Crime File Management System:

  • The details of Crime is store into the Crime tables respective with all tables
  • Each entity (Criminals, FIR, Presioner, Complaints, Crime) contains primary key and unique keys.
  • The entity FIR, Presioner has binded with Crime, Complaints entities with foreign key
  • There is one-to-one and one-to-many relationships available between Presioner, Charge Sheet, Criminals, Crime
  • All the entities Crime, Presioner, FIR, Criminals are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Crime File Management System tables for fast query execution.

Super admin functionality of Crime File Management System:

  • Admin can add, edit, delete and view the records of Crime, Presioner, FIR, Criminals
  • Admin can manage all the details of Complaints, FIR, Charge Sheet, Presioner
  • Admin can also generate reports of Crime, Complaints, FIR, Charge Sheet
  • Admin can search the details of Crime, Presioner, FIR, Criminals
  • Admin can apply different level of filters on report of Crime, FIR, Criminals
  • Admin can tracks the detailed information of Presioner, Criminals, Crime, Complaints

Report of Crime File Management System:

  • Generates the report on FIR,Charge Sheet,Crime,Complaints,Presioner,Criminals,
  • Charge Sheet,Presioner,Criminals has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Charge Sheet,Presioner,Criminals
  • Excel Sheet report has also been integrated for Complaints,Charge Sheet,Criminals
  • You can create the CSV reports for Crime,Presioner,FIR

Limitation of Crime File Management System

  • Run time report generation is not available in Crime File Management System.
  • We have not implemented the dynamic report for Crime,Charge Sheet,Presioner,Complaints,FIR,Criminals
  • This project Crime File Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Crime, Charge Sheet, Criminals cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Crime File Management System

  • We have added all the validations for input value on the modules Crime,Complaints,FIR
  • Charge Sheet,Presioner,Criminals can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Crime,FIR,Criminals
  • CSRF token has also been implemented on Charge Sheet,Complaints,Crime, Presioner,Criminals
  • All the Crime,Charge Sheet,Presioner,Complaints,FIR,Criminals has integrated with captcha for spam protections
  • Access level validation has been implemented on Criminals,Presioner,Charge Sheet
  • Number and character validation has also been implemented on FIR,Presioner,Crime

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database