ERP-System-WayToCode

🏢 ERP System - WayToCode

This is a full-featured Enterprise Resource Planning (ERP) System developed using Java Servlets, JSP, MySQL, and JDBC. It provides modules for employee management, leave tracking, project assignments, admin approvals, and report generation.

📽️ Live Demo

▶️ Click here to watch the live demo

This video walkthrough demonstrates user signup/login, leave requests, admin approval, project assignments, and real-time reporting.

🚀 Features

👤 User Authentication: Signup and Login with session management
📝 Leave Management: Application with auto summary updates
👨‍💼 Admin Dashboard: Centralized approval system and reporting
📊 Reporting: Monthly & yearly reports with visual graphs
🏗️ Project Tracking: Assignment and progress monitoring
🖼️ User Profiles: Picture upload and management
🔐 Access Control: Role-based permissions (Admin/User)

📂 Project Structure

WayToCodeERPSystem/
├── src/                          # Java Servlets, DAO, Bean files
├── web/                          # JSPs, CSS, JS, images
├── database/erp\_system.sql       # SQL database dump
├── nbproject/                    # NetBeans IDE configuration
└── README.md                     # Project documentation

🔧 Tech Stack

Frontend: HTML5, CSS3, JSP
Backend: Java Servlets, JDBC
Database: MySQL 8.0+
Server: Apache Tomcat 9+
Development: NetBeans IDE 12+

⚙️ Setup Guide

Clone the Repository

git clone https://github.com/vandan2931/ERP-System-WayToCode.git

Database Setup

Create a new database:
```
CREATE DATABASE erp_system;
```

Import the schema:

mysql -u root -p erp_system < database/erp_system.sql

Configure Database Connection

Update the credentials in:

// src/your/package/DBConnection.java
String url = "jdbc:mysql://localhost:3306/erp_system";
String user = "root";
String pass = "";

Run in NetBeans
- Open the project folder in NetBeans
- Deploy to Tomcat server
- Access via: http://localhost:8080/WayToCodeERPSystem

📘 Core Modules

Module	Description
Authentication	Secure login/logout for all users
Leave	Apply/view leave requests (Admin approval)
Projects	Task assignment and progress tracking
Admin Console	User management and system configuration
Reporting	Generate PDF/Excel reports with analytics

👨‍💻 Developer Information

Name: Vandan Shah
Location: Ahmedabad, Gujarat, India
Role: Full Stack Java Developer
GitHub: @vandan2931

📜 License

This project is licensed for educational use. You may:

Use for learning purposes
Modify for personal projects
Adapt for internal organizational use

Note: Commercial use requires explicit permission from the developer.

🤝 Contributing

We welcome contributions! Here’s how to get started:

Fork the repository
Create your feature branch
```
git checkout -b feature/your-feature
```
Commit your changes
```
git commit -m 'Add some feature'
```
Push the changes
```
git push origin feature/your-feature
```
Open a Pull Request

For major changes, please open an issue first to discuss the improvements.

💡 Built for academic, personal, and portfolio use to demonstrate a complete Java Full Stack ERP system with real-time leave and project management.