🏢 Company Management & Analytics 🏢 System

A complete system combining MySQL, Python Data Visualization, and Web Interface for company analytics.

---

A complete project that combines a MySQL database, Python data visualization, and a Web interface (HTML/CSS/PHP) to manage and analyze data for a bakery business.

---

📂 Project Structure

project2/
│── python_diagramm_sql.py         # Python script for data visualization
│── companyDB.sql                  # MySQL database dump
│
└── html_folder/
    │── index.html                 # Homepage
    │── charts.html                # Charts & visualizations
    │── insights.html              # Insights & analytics
    │── contact.html               # Contact form
    │ 
    ├── css_folder/                
    │   └── style.css              # Main stylesheet
    │
    ├── images/                    # Images assets (logos, photos, etc.)
    │
    └── php_folder/                
        └── index.php              # PHP backend for contact form

---

⚙️ Features

• MySQL Database: includes tables for branches, suppliers, customers, employees, products, and sales.
• Python Data Visualization: generate interactive and insightful charts (e.g., average salary by position, sales by product, etc.).
• Web Interface: user-friendly front-end with HTML/CSS and backend integration via PHP.
• Responsive Design with clean structure and organized codebase.

---

Screenshots 📸

Screenshots

🛠️ Technologies

• Backend: PHP 8, MySQL 8.0
• Frontend: HTML5, CSS3
• Data Analysis: Python 3, Matplotlib
• Server Tools: XAMPP / MAMP (for local development)

---

🚀 Installation Guide

1. Clone the repository:

   git clone https://github.com/teogenitsaridis/project2.git
   cd project2
   

2. Create the database in MySQL:

CREATE DATABASE companyDB; USE companyDB; SOURCE companyDB.sql;

3. Run the Python script to generate charts:

python python_diagramm_sql.py

4. Open index.html via XAMPP/MAMP to view the web interface.

📊 Example Visualizations

Average salary by employee position

Sales per product

Total sales per branch

Supplier distribution and product quantities

👤 Author

Created by Thodoris 📍 Athens University of Economics and Business

📜 License

This project is open-source and available under the MIT License.