Online Crime Investigation

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Online Crime Investigation

Online Crime Investigation 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 Case,Criminal,Department,Police,FIR. Admin user can manage all the operations of Police,FIR,Case,Crime,Criminal and their details. Admin can create different type of reports of Case,Criminal,Department,Police,FIR according to their choise and filters. You can Download PHP and MySQL Project Online Crime Investigation with source code and database from this site. We also provide Project Report of Online Crime Investigation.

Functionalities and their descriptions of Online Crime Investigation are as follows:

  • You can search records on various criterias. Such as Case, Department, Police, FIR
  • Create, read, update and delete (CRUD) application has been implemented on Case,Criminal,Department,Police,FIR
  • Keep the track logs of Criminal, Crime, Police ect
  • Advance search has been implemented on Criminal,Crime, Police
  • You can see all the details of the Case, Department, Crime, Police
  • All the modules Crime, Police, Criminal,FIR, Case are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Police.
  • All the Criminal,Crime, Police 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 Case data.

Modules of Online Crime Investigation and their descriptions:

  • Case Module : Manage all the operations of Case
  • Criminal Module : Manage all the operations of Criminal
  • Crime Module : Manage all the operations of Crime
  • Department Module : Manage all the operations of Department
  • Police Module : Manage all the operations of Police
  • FIR Module : Manage all the operations of FIR

Classes and their methods of Online Crime Investigation:

  • Case Methods : addCase(), editCase(), deleteCase(), updateCase(), saveCase(), searchCase()
  • Criminal Methods : addCriminal(), editCriminal(), deleteCriminal(), updateCriminal(), saveCriminal(), searchCriminal()
  • Crime Methods : addCrime(), editCrime(), deleteCrime(), updateCrime(), saveCrime(), searchCrime()
  • Department Methods : addDepartment(), editDepartment(), deleteDepartment(), updateDepartment(), saveDepartment(), searchDepartment()
  • Police Methods : addPolice(), editPolice(), deletePolice(), updatePolice(), savePolice(), searchPolice()
  • FIR Methods : addFIR(), editFIR(), deleteFIR(), updateFIR(), saveFIR(), searchFIR()

Database tables and attributes of the Online Crime Investigation:

  • Case Entity : Attributes of Case are case_id, case_crime_id, case_criminal_id, case_name, case_type, case_description
  • Criminal Entity : Attributes of Criminal are criminal_id, criminal_crime_id, criminal_name, criminal_mobile, criminal_email, criminal_username, criminal_password, criminal_address
  • Crime Entity : Attributes of Crime are crime_id, crime_criminal_id, crime_name, crime_type, crime_description
  • Department Entity : Attributes of Department are department_id, department_name, department_place, department_type, department_description
  • Police Entity : Attributes of Police are police_id, police_department_id, police_name, police_mobile, police_email, police_username, police_password, police_address
  • FIR Entity : Attributes of FIR are FIR_id, FIR_name, FIR_type, FIR_description

Database definition of Online Crime Investigation:

  • The details of Case is store into the Case tables respective with all tables
  • Each entity (FIR, Crime, Police, Criminal, Case) contains primary key and unique keys.
  • The entity Crime, Police has binded with Case, Criminal entities with foreign key
  • There is one-to-one and one-to-many relationships available between Police, Department, FIR, Case
  • All the entities Case, Police, Crime, FIR are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Online Crime Investigation tables for fast query execution.

Super admin functionality of Online Crime Investigation:

  • Admin can add, edit, delete and view the records of Case, Police, Crime, FIR
  • Admin can manage all the details of Criminal, Crime, Department, Police
  • Admin can also generate reports of Case, Criminal, Crime, Department
  • Admin can search the details of Case, Police, Crime, FIR
  • Admin can apply different level of filters on report of Case, Crime, FIR
  • Admin can tracks the detailed information of Police, FIR, Case, Criminal

Report of Online Crime Investigation:

  • Generates the report on Crime,Department,Case,Criminal,Police,FIR,
  • Department,Police,FIR 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 Department,Police,FIR
  • Excel Sheet report has also been integrated for Criminal,Department,FIR
  • You can create the CSV reports for Case,Police,Crime

Limitation of Online Crime Investigation

  • Run time report generation is not available in Online Crime Investigation.
  • We have not implemented the dynamic report for Case,Department,Police,Criminal,Crime,FIR
  • This project Online Crime Investigation has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Case, Department, FIR cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Online Crime Investigation

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

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database