SONA COMSTAR – Competency & Credit Points Management System
🏢 Project Title

SONA COMSTAR – Competency Matrix & Credit Points Web Application

📌 Project Overview

I have an existing Excel-based Competency Matrix system. It is difficult to manage and maintain.

I need a Professional Web-Based Application for SONA COMSTAR to:

Manage employee competency data

Assign and distribute credit points department-wise

Track employee performance

Allow Admin control over entire system

Provide user-specific dashboards

Support CSV Import/Export

Maintain feedback records

⚠ Important:
The final production database will be provided by the company later.
So the system must be:

Database configurable

Clean MVC architecture

Not tightly coupled to schema

Easily mappable to a new database

🛠 Technology Stack

Backend: PHP (OOP + MVC Pattern)

Database (Development): MySQL (sample schema)

Connection: PDO (prepared statements)

Frontend: HTML5, CSS3, Bootstrap 5

Charts: Chart.js

Runs on XAMPP

Responsive Design

Secure Authentication

🔐 AUTHENTICATION SYSTEM
Main Login Page

Two login types:

Admin Login

User Login

Admin Capabilities

Only Admin can create:

User ID

Password

Role-based session control

Secure password hashing

Logout functionality

👤 USER ROLES
1️⃣ Admin

Full Access:

Dashboard (overview)

All users

All departments

Credit points portal

Reports

CSV import/export

Search users

View any user profile

Add feedback for users

Edit credit points

View performance analytics

2️⃣ User (Employee)

Limited Access:

View own dashboard

View own credit points

View department performance

View feedback

Cannot edit credit points

Cannot access other users

📊 ADMIN DASHBOARD (Professional Design for SONA COMSTAR)

The Admin dashboard must include:

Company branding: SONA COMSTAR

Total Users

Department-wise distribution

Total Credit Points

Performance graph

Skill Gap analysis

User performance summary

Admin Profile section

Charts:

Department Credit Distribution (Bar Chart)

Performance Comparison (Pie Chart)

💳 CREDIT POINTS PORTAL

Based on the Excel Sheet columns:

The system must:

Create dynamic columns matching Excel structure

Allow Admin to distribute credit points department-wise

Store:

Employee Name

Employee Code

Department

Skill Category

Credit Points

Performance Score

Remarks

🔽 User Dashboard View

After login, user should see:

Personal profile

Department

Total credit points

Skill-wise breakdown

Performance summary

Feedback section (added by Admin)

🔍 ADMIN SEARCH FUNCTION

Admin must be able to:

Search user by:

Name

Employee Code

Department

View full user profile

View complete credit history

Edit credit values

💬 FEEDBACK SYSTEM

Below each user’s credit points table:

Add:

Feedback Section:

Admin can write feedback

Store:

Feedback message

Date

Admin name

Users can only view (not edit)

📤 CSV EXPORT FEATURE

Admin must be able to:

Export entire credit portal data

Export department-wise data

Export individual user report

Download as CSV file

📥 CSV IMPORT FEATURE

Add file upload box:

Admin can:

Upload previous CSV

System should:

Validate format

Match columns

Insert/update data

Show success/failure report

🗄 DATABASE STRUCTURE (Development Only)

Provide normalized schema for:

admins

users

departments

credit_points

feedback

performance_records

⚠ Must use:

Foreign keys

Prepared statements

Configurable DB file

Clean separation of logic

Database credentials must be stored in:

app/config/config.php
📈 REPORTING MODULE

Admin can:

Generate department summary

Generate employee performance report

View credit comparison

Export reports

🎨 UI REQUIREMENTS

Professional Corporate Design

SONA COMSTAR Branding

Clean navigation sidebar

Dashboard widgets

Modern card layout

Responsive

Mobile friendly

Professional color theme

🔒 SECURITY REQUIREMENTS

Password hashing

Session timeout

CSRF protection

Input validation

XSS prevention

Secure file upload validation

📂 PROJECT STRUCTURE

Must follow MVC:

app/
controllers/
models/
views/
config/
public/
assets/
🎯 FINAL EXPECTED OUTPUT

Generate:

Complete project folder structure

Sample SQL schema

Full authentication system

Admin dashboard

User dashboard

Credit points portal

Feedback module

CSV import/export module

Setup instructions for XAMPP

Fully commented clean code

🚀 SYSTEM MUST BE

Scalable

Professional

Production-ready

Clean architecture

Easy to integrate with company database later

This system should look like a real enterprise HR portal for SONA COMSTAR and not like a basic student project.