⚖️ Lawbase Database Website

This website serves as a comprehensive platform for managing legal cases, clients, courts, documents, lawyers, and users.

🛠️ Tool Used

💻 How to Install

Download the zip file and open the file "Connecty.py". Before running the code, you should modify this part to match your computer's MySQL server environment, including host, user, and password. If you use Window, uncomment 6-13 lines and comment 16-23 lines.

Once the program is up and running, you can access the website through the provided link.

🌈 Features

1. Main Page

Upon entering the website, you'll find six primary buttons: View Data, Insert Data, Update Data, Delete Data, More Options, and Exit. These buttons facilitate easy navigation and access to various functionalities of the website.

2. View Data

you'll discover a list of tables including Cases, Clients, Courts, Documents, Lawyers, and Users. Each table provides valuable insights into different aspects of legal management.

i.g.) View Cases

3. Insert Data

You can insert a new data to each table.

For example, you can add a new case by filling out the required attributes. Once submitted, the data will be successfully added to the Cases table.

4. Update Data

There's the option to update existing data.

For instatnce, updating data in the Cases table requires selecting the existing CaseID and ClientID for updating, and filling out the other necessary fields. Upon submission, you'll see the updated data.

5. Delete Data

you can easily remove unwanted records from the database.

6. More Options

This website offers a range of advanced features accessible through the More Options button.

6-1. Active Cases

By clicking on Active Cases option, yoou'll be presented with a list of clients who currently have active cases.

6-2. Find Lawyers

You can choose from a variety of departments to find lawyers based on their department specialization.

6-3. Multiple Client Cases

you'll discover which clients have more than one active case, providing insights into workload distribution and client management.

6-4. Case Statistics

You can view current statistics such as department-wise total cases and average cases per lawyer, aiding in strategic decision-making and resource allocation.

6-5. Search Documents

With the Search Documents functionality, you can easily find relevant documents using keywords.

6-6. Department Statistics

The 'Department Statistics' option provides detailed insights into each department's performance, including the total number of cases handled. This data is invaluable for assessing departmental efficiency and effectiveness.