fix: edit form fields and update form submission logic

Reviewed-on: #18

.dockerignore

@@ -0,0 +1,34 @@
+# Include any files or directories that you don't want to be copied to your
+# container here (e.g., local build artifacts, temporary files, etc.).
+#
+# For more help, visit the .dockerignore file reference guide at
+# https://docs.docker.com/go/build-context-dockerignore/
+
+**/.classpath
+**/.dockerignore
+# **/.env
+**/.git
+**/.gitignore
+**/.project
+**/.settings
+**/.toolstarget
+**/.vs
+**/.vscode
+**/.next
+**/.cache
+**/*.*proj.user
+**/*.dbmdl
+**/*.jfm
+**/charts
+**/docker-compose*
+**/compose.y*ml
+**/Dockerfile*
+**/node_modules
+**/npm-debug.log
+**/obj
+**/secrets.dev.yaml
+**/values.dev.yaml
+**/build
+**/dist
+LICENSE
+README.md

.gitignore

@@ -0,0 +1 @@
+.env

CLAUDE.md

@@ -0,0 +1,102 @@
+# CLAUDE.md
+
+This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.
+
+## Repository layout
+
+Monorepo with two independent npm packages plus a shared Docker dev stack:
+
+- `backend/` — Node.js + Express 5 (ESM) API, Prisma ORM over PostgreSQL.
+- `frontend/` — React 19 + Vite + TypeScript admin dashboard, styled with Tailwind 4 + shadcn/ui.
+- `docker/` — Dev Dockerfiles + `entrypoint.sh` (used by `docker-compose.dev.yml` at repo root).
+
+There is no root-level package script — run npm commands inside `backend/` or `frontend/`.
+
+## Common commands
+
+### Docker (full stack)
+
+```bash
+docker compose -f docker-compose.dev.yml up --build   # backend :5008, frontend :3008, postgres :5432 (internal)
+docker compose -f docker-compose.dev.yml down
+```
+
+The backend container's `entrypoint.sh` runs `prisma generate` then `prisma db push` (NOT `migrate deploy`) on every start — schema changes propagate without a migration step in the Docker dev flow.
+
+### Backend (`cd backend`)
+
+```bash
+npm run dev          # nodemon src/app.js
+npm start            # node src/app.js
+npm run migrate      # npx prisma migrate dev (use this locally; Docker uses db push)
+npm run generate     # npx prisma generate
+npx prisma studio    # GUI for the DB
+npm run create-user <username> <password> [role]   # role defaults to "admin"
+```
+
+In Docker, create an admin via:
+```bash
+docker exec -it gg-backend-api-backend-1 node src/utils/createUser.js <name> <password> <role>
+```
+
+### Frontend (`cd frontend`)
+
+```bash
+npm run dev      # Vite dev server
+npm run build    # tsc -b && vite build
+npm run lint     # eslint .
+npm run preview
+```
+
+There is no test runner configured in either package.
+
+## Architecture
+
+### Backend
+
+Single Express app assembled in `backend/src/app.js`. Each domain follows the same triplet:
+
+- `src/routes/<domain>.routes.js` — declares the Express router, applies `jwtAuthMiddleware` per-route (mixed public/protected within the same router; see `blog.routes.js` for the pattern: list/detail public, admin endpoints + writes protected).
+- `src/controllers/<domain>.controller.js` — handler logic; uses Prisma directly.
+- Mounted at `/api/<domain>` in `app.js`.
+
+Domains: `departments`, `auth`, `blogs`, `upload`, `doctors`, `careers`, `candidates`, `appointments`, `inquiry`, `academics`, `email`, `newsMedia`, `import`. Static `uploads/` is served at `/uploads`.
+
+Cross-cutting pieces:
+
+- **Prisma client** — `src/prisma/client.js` exports a singleton. Always import from there rather than instantiating `new PrismaClient()` (the import controller currently instantiates its own — match the singleton pattern when adding new code).
+- **Auth** — `src/middleware/auth.js` expects `Authorization: Bearer <jwt>`, attaches the decoded payload to `req.user`. Tokens are issued by `src/utils/jwt.js` using `JWT_SECRET`. Passwords hashed via `src/utils/password.js` (bcrypt).
+- **Email** — `src/utils/sendEmail.js` wraps Postmark with `EMAIL_FROM` as sender. Recipient lists are looked up by category via `getEmailsByType(type)` against the `EmailConfig` table — controllers call this to fan out notifications (e.g. on new appointments/inquiries).
+- **CORS** — `CORS_ALLOWED_ORIGINS` is a **space-separated** list (not comma-separated). Requests with no `Origin` header are allowed.
+- **Body limits** — JSON/urlencoded bodies are capped at 50mb to support image-laden Editor.js payloads and bulk Excel imports.
+
+### Data model (Prisma — `backend/prisma/schema.prisma`)
+
+Note the natural-key relations: `Appointment.doctorId` references `Doctor.doctorId` (the string business ID), not `Doctor.id`. Same for `Department`. The `SL_NO` / `GG_ID` columns from imports become these business IDs. `Doctor` ↔ `Department` is many-to-many through `DoctorDepartment`, which has a 1:1 `DoctorTiming` for weekday schedules. `NewsMedia` has cascading `NewsImage` children.
+
+### Frontend
+
+- Routing in `src/App.tsx`: `PublicRoute` wraps `/` (Login); everything else is wrapped by `ProtectedRoute` → `DashboardLayout`. Unknown paths redirect to `/department`.
+- `src/context/AuthContext.tsx` is the auth source of truth; `src/services/api.ts` is the shared Axios instance that auto-injects `Authorization: Bearer <token>` from `localStorage.getItem("token")`.
+- `src/api/<domain>.ts` files are thin wrappers around that axios client, one per backend domain — keep this pattern when adding endpoints.
+- Path alias `@/*` → `src/*` (configured in both `vite.config.ts` and `tsconfig`).
+- File uploads go through Bytescale (`src/components/BytescaleUploader`) — server only stores the resulting URL.
+- The `/import` page parses Excel via `xlsx` and POSTs structured payloads to `/api/import`, where `importController.js` upserts across multiple tables. When changing import behavior, the frontend's column names (`SL_NO`, `GG_ID`, `Department`, `Working Status`, etc.) and the controller's destructured keys (`departments`, `doctors`, `timings`, …) must stay in sync.
+
+## Environment variables
+
+`backend/.env`:
+```
+DATABASE_URL=postgresql://user:password@db:5432/mydb
+PORT=5008
+JWT_SECRET=...
+CORS_ALLOWED_ORIGINS=http://localhost:5173      # space-separated for multiple
+BYTESCALE_SECRET_API_KEY=...
+POSTMARK_API_KEY=...
+EMAIL_FROM=admin@example.com
+```
+
+`frontend/.env`:
+```
+VITE_API_URL=http://localhost:5008/api
+```

Jenkinsfile

@@ -0,0 +1,221 @@
+// Single source of truth for env injection.
+// Adding/removing a variable means editing one `keys` list — nothing else.
+// `path` is the Vault KV path; `file` is the output path relative to ${WORKSPACE}.
+def ENV_LAYOUT = [
+    [path: 'ggh-dev/root', file: '.env', keys: [
+        'POSTGRES_DB', 'POSTGRES_PASSWORD', 'POSTGRES_USER',
+    ]],
+    [path: 'ggh-dev/backend', file: 'backend/.env', keys: [
+        'BYTESCALE_SECRET_API_KEY',
+        'CORS_ALLOWED_ORIGINS',
+        'DATABASE_URL',
+        'EMAIL_FROM',
+        'JWT_SECRET',
+        'PORT',
+        'POSTMARK_API_KEY',
+    ]],
+    [path: 'ggh-dev/dashboard-frontend', file: 'frontend/.env', keys: [
+        'VITE_API_URL',
+    ]],
+]
+
+pipeline {
+    agent { label 'jagent06' }
+
+    options {
+        disableConcurrentBuilds()
+    }
+
+    triggers {
+        GenericTrigger(
+            causeString: 'Triggered by Gitea webhook',
+            tokenCredentialId: 'ggh-dev',
+            printContributedVariables: true,
+            printPostContent: true
+        )
+    }
+
+    environment {
+        DOCKER_COMPOSE_FILE = "${WORKSPACE}/docker-compose.dev.yml"
+        DOCKER_BUILDKIT = '1'
+        COMPOSE_DOCKER_CLI_BUILD = '1'
+    }
+
+    stages {
+        stage('Checkout Code') {
+            steps {
+                checkout([
+                    $class: 'GitSCM',
+                    branches: [[name: '*/dev']],
+                    userRemoteConfigs: [[
+                        url: 'https://gt.mgsigma.net/GGH/gg-backend.git',
+                        credentialsId: 'SYS_BOT_PAT'
+                    ]]
+                ])
+            }
+        }
+
+        stage('Inject .env from Vault') {
+            steps {
+                script {
+                    def vaultSecrets = ENV_LAYOUT.collect { layer ->
+                        [
+                            path: layer.path,
+                            engineVersion: 2,
+                            secretValues: layer.keys.collect { k ->
+                                [vaultKey: k, envVar: k]
+                            }
+                        ]
+                    }
+
+                    def writtenFiles = ENV_LAYOUT.collect { it.file }.join(', ')
+
+                    withVault(
+                        configuration: [
+                            vaultUrl: 'https://vault.mgsigma.net',
+                            vaultCredentialId: 'vault-cicd-01'
+                        ],
+                        vaultSecrets: vaultSecrets
+                    ) {
+                        // Single-quoted sh + withEnv keeps secret names out of the
+                        // Groovy GString. Values are read at shell runtime via
+                        // `printenv`, so Jenkins's static analyzer has nothing to flag.
+                        ENV_LAYOUT.each { layer ->
+                            withEnv([
+                                "ENV_FILE=${layer.file}",
+                                "ENV_KEYS=${layer.keys.join(' ')}"
+                            ]) {
+                                sh '''
+                                    set +x
+                                    umask 077
+                                    mkdir -p "$(dirname "$WORKSPACE/$ENV_FILE")"
+                                    : > "$WORKSPACE/$ENV_FILE"
+                                    for k in $ENV_KEYS; do
+                                        printf '%s=%s\n' "$k" "$(printenv "$k")" >> "$WORKSPACE/$ENV_FILE"
+                                    done
+                                '''
+                            }
+                        }
+                        echo "[INFO] env files written: ${writtenFiles}"
+                    }
+                }
+            }
+        }
+
+        stage('Deploy') {
+            steps {
+                script {
+                    if (!fileExists(env.DOCKER_COMPOSE_FILE)) {
+                        error "docker-compose.dev.yml not found at ${env.DOCKER_COMPOSE_FILE}"
+                    }
+                }
+                sh '''
+                    set -e
+
+                    if [ -n "$(docker compose -f docker-compose.dev.yml ps -q 2>/dev/null)" ]; then
+                        echo "[INFO] Stopping existing containers..."
+                        docker compose -f docker-compose.dev.yml down --remove-orphans
+                    else
+                        echo "[INFO] No running containers — skipping stop."
+                    fi
+
+                    # Dangling-only prune — keeps tagged images and BuildKit cache so
+                    # subsequent builds reuse layers. Do NOT use `docker system prune -af`.
+                    docker image prune -f >/dev/null 2>&1 || true
+
+                    echo "[INFO] Building and starting services..."
+                    docker compose -f docker-compose.dev.yml up -d --build --remove-orphans
+                '''
+            }
+        }
+    }
+
+    post {
+        always {
+            script {
+                env.BUILD_INFO_HASH = sh(
+                    script: "git rev-parse --short HEAD 2>/dev/null || echo N/A",
+                    returnStdout: true
+                ).trim()
+                env.BUILD_INFO_AUTHOR = sh(
+                    script: "git log -1 --pretty=format:'%an' 2>/dev/null || echo N/A",
+                    returnStdout: true
+                ).trim()
+                env.BUILD_INFO_MESSAGE = sh(
+                    script: "git log -1 --pretty=format:'%s' 2>/dev/null || echo 'No commit message found'",
+                    returnStdout: true
+                ).trim()
+
+                def cause = currentBuild.getBuildCauses()?.getAt(0)?.shortDescription ?: 'Unknown'
+                env.BUILD_INFO_TRIGGER = cause.contains('Started by user') ? 'Manual trigger' : cause
+            }
+        }
+        success {
+            script {
+                emailext(
+                    subject: "[DEV] ${env.JOB_NAME} #${env.BUILD_NUMBER} succeeded",
+                    body: renderEmail('Build succeeded', '#16a34a', buildInfo()),
+                    mimeType: 'text/html',
+                    to: 'admin@msigmagokulam.com, ashir@mgsigma.net, kailasdevdas@msigmagokulam.com'
+                )
+            }
+        }
+        failure {
+            script {
+                emailext(
+                    subject: "[DEV] ${env.JOB_NAME} #${env.BUILD_NUMBER} failed",
+                    body: renderEmail('Build failed', '#dc2626', buildInfo()),
+                    mimeType: 'text/html',
+                    to: 'admin@msigmagokulam.com, ashir@mgsigma.net, kailasdevdas@msigmagokulam.com'
+                )
+            }
+        }
+    }
+}
+
+def buildInfo() {
+    return [
+        hash:     env.BUILD_INFO_HASH ?: 'N/A',
+        author:   env.BUILD_INFO_AUTHOR ?: 'N/A',
+        message:  env.BUILD_INFO_MESSAGE ?: 'N/A',
+        trigger:  env.BUILD_INFO_TRIGGER ?: 'Unknown',
+        duration: currentBuild.durationString.replace(' and counting', '')
+    ]
+}
+
+def renderEmail(String label, String accent, Map info) {
+    return """\
+<!DOCTYPE html>
+<html>
+<body style="margin:0; padding:0; background-color:#f6f7f9;">
+<table role="presentation" cellpadding="0" cellspacing="0" border="0" width="100%" style="background-color:#f6f7f9; padding:40px 16px;">
+  <tr><td align="center">
+    <table role="presentation" cellpadding="0" cellspacing="0" border="0" width="560" style="max-width:560px; background:#ffffff; border-radius:12px; overflow:hidden; box-shadow:0 1px 3px rgba(15,23,42,0.08); font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,Helvetica,Arial,sans-serif;">
+      <tr><td style="height:3px; background:${accent};"></td></tr>
+      <tr><td style="padding:32px 40px 0 40px;">
+        <div style="font-size:12px; font-weight:600; color:${accent}; letter-spacing:0.8px; text-transform:uppercase; margin-bottom:6px;">${label} · development</div>
+        <div style="font-size:20px; font-weight:600; color:#0f172a; line-height:1.35;">${env.JOB_NAME}<span style="color:#94a3b8; font-weight:400;"> &middot; #${env.BUILD_NUMBER}</span></div>
+      </td></tr>
+      <tr><td style="padding:20px 40px 8px 40px;">
+        <table role="presentation" cellpadding="0" cellspacing="0" border="0" width="100%" style="font-size:14px; color:#0f172a;">
+          <tr><td width="110" style="padding:7px 0; color:#64748b;">Commit</td><td style="padding:7px 0; font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace; font-size:13px;">${info.hash}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Author</td><td style="padding:7px 0;">${info.author}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b; vertical-align:top;">Message</td><td style="padding:7px 0;">${info.message}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Triggered by</td><td style="padding:7px 0;">${info.trigger}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Duration</td><td style="padding:7px 0;">${info.duration}</td></tr>
+        </table>
+      </td></tr>
+      <tr><td style="padding:20px 40px 32px 40px;">
+        <a href="${env.BUILD_URL}" style="display:inline-block; padding:10px 18px; background:#0f172a; color:#ffffff; text-decoration:none; border-radius:8px; font-size:14px; font-weight:500;">View build</a>
+        <a href="${env.BUILD_URL}console" style="display:inline-block; padding:10px 14px; color:#475569; text-decoration:none; font-size:14px; font-weight:500;">Console output &rarr;</a>
+      </td></tr>
+      <tr><td style="padding:14px 40px; background:#f8fafc; border-top:1px solid #e2e8f0; font-size:12px; color:#94a3b8;">
+        Automated notification from Jenkins
+      </td></tr>
+    </table>
+  </td></tr>
+</table>
+</body>
+</html>
+"""
+}

Jenkinsfile.prod

@@ -0,0 +1,224 @@
+// Single source of truth for env injection.
+// Adding/removing a variable means editing one `keys` list — nothing else.
+// `path` is the Vault KV path; `file` is the output path relative to ${WORKSPACE}.
+def ENV_LAYOUT = [
+    [path: 'ggh-prod/root', file: '.env', keys: [
+        'POSTGRES_DB', 'POSTGRES_PASSWORD', 'POSTGRES_USER',
+    ]],
+    [path: 'ggh-prod/backend', file: 'backend/.env', keys: [
+        'BYTESCALE_SECRET_API_KEY',
+        'CORS_ALLOWED_ORIGINS',
+        'DATABASE_URL',
+        'EMAIL_FROM',
+        'JWT_SECRET',
+        'PORT',
+        'POSTMARK_API_KEY',
+    ]],
+    [path: 'ggh-prod/dashboard-frontend', file: 'frontend/.env', keys: [
+        'VITE_API_URL',
+    ]],
+]
+
+pipeline {
+    agent {
+        label 'jagent06'
+    }
+
+    options {
+        disableConcurrentBuilds()
+    }
+
+    environment {
+        REMOTE_HOST       = "root@170.187.237.83"
+        REMOTE_DEPLOY_DIR = "/root/gg-backend"
+        SSH_CREDENTIALS_ID = "ssh_id_ed25519"
+        COMPOSE_FILE      = "docker-compose.prod.yml"
+    }
+
+    stages {
+        stage('Checkout Code') {
+            steps {
+                git credentialsId: 'SYS_BOT_PAT', url: 'https://gt.mgsigma.net/GGH/gg-backend.git', branch: 'main'
+            }
+        }
+
+        stage('Inject .env from Vault') {
+            steps {
+                script {
+                    def vaultSecrets = ENV_LAYOUT.collect { layer ->
+                        [
+                            path: layer.path,
+                            engineVersion: 2,
+                            secretValues: layer.keys.collect { k ->
+                                [vaultKey: k, envVar: k]
+                            }
+                        ]
+                    }
+
+                    def writtenFiles = ENV_LAYOUT.collect { it.file }.join(', ')
+
+                    withVault(
+                        configuration: [
+                            vaultUrl: 'https://vault.mgsigma.net',
+                            vaultCredentialId: 'vault-cicd-01'
+                        ],
+                        vaultSecrets: vaultSecrets
+                    ) {
+                        // Single-quoted sh + withEnv keeps secret names out of the
+                        // Groovy GString. Values are read at shell runtime via
+                        // `printenv`, so Jenkins's static analyzer has nothing to flag.
+                        ENV_LAYOUT.each { layer ->
+                            withEnv([
+                                "ENV_FILE=${layer.file}",
+                                "ENV_KEYS=${layer.keys.join(' ')}"
+                            ]) {
+                                sh '''
+                                    set +x
+                                    umask 077
+                                    mkdir -p "$(dirname "$WORKSPACE/$ENV_FILE")"
+                                    : > "$WORKSPACE/$ENV_FILE"
+                                    for k in $ENV_KEYS; do
+                                        printf '%s=%s\n' "$k" "$(printenv "$k")" >> "$WORKSPACE/$ENV_FILE"
+                                    done
+                                '''
+                            }
+                        }
+                        echo "[INFO] env files written: ${writtenFiles}"
+                    }
+                }
+            }
+        }
+
+        stage('Sync sources to prod VPS') {
+            steps {
+                sshagent (credentials: ["${env.SSH_CREDENTIALS_ID}"]) {
+                    sh """
+                        ssh -o StrictHostKeyChecking=no $REMOTE_HOST 'mkdir -p $REMOTE_DEPLOY_DIR'
+                        rsync -az --delete \\
+                            --exclude='.git/' \\
+                            --exclude='node_modules/' \\
+                            --exclude='backend/node_modules/' \\
+                            --exclude='frontend/node_modules/' \\
+                            --exclude='frontend/dist/' \\
+                            -e "ssh -o StrictHostKeyChecking=no" \\
+                            ./ $REMOTE_HOST:$REMOTE_DEPLOY_DIR/
+                    """
+                }
+            }
+        }
+
+        stage('Deploy on prod VPS') {
+            steps {
+                sshagent (credentials: ["${env.SSH_CREDENTIALS_ID}"]) {
+                    sh """
+                        ssh -o StrictHostKeyChecking=no $REMOTE_HOST '
+                            set -e
+                            cd $REMOTE_DEPLOY_DIR
+
+                            if [ -n "\$(docker compose -f $COMPOSE_FILE ps -q 2>/dev/null)" ]; then
+                                echo "[INFO] Stopping existing containers..."
+                                docker compose -f $COMPOSE_FILE down --remove-orphans
+                            else
+                                echo "[INFO] No running containers — skipping stop."
+                            fi
+
+                            docker image prune -f >/dev/null 2>&1 || true
+
+                            echo "[INFO] Building and starting services..."
+                            docker compose -f $COMPOSE_FILE up -d --build --remove-orphans
+                        '
+                    """
+                }
+            }
+        }
+    }
+
+    post {
+        always {
+            script {
+                env.BUILD_INFO_HASH = sh(
+                    script: "git rev-parse --short HEAD 2>/dev/null || echo N/A",
+                    returnStdout: true
+                ).trim()
+                env.BUILD_INFO_AUTHOR = sh(
+                    script: "git log -1 --pretty=format:'%an' 2>/dev/null || echo N/A",
+                    returnStdout: true
+                ).trim()
+                env.BUILD_INFO_MESSAGE = sh(
+                    script: "git log -1 --pretty=format:'%s' 2>/dev/null || echo 'No commit message found'",
+                    returnStdout: true
+                ).trim()
+
+                def cause = currentBuild.getBuildCauses()?.getAt(0)?.shortDescription ?: 'Unknown'
+                env.BUILD_INFO_TRIGGER = cause.contains('Started by user') ? 'Manual trigger' : cause
+            }
+        }
+        success {
+            script {
+                emailext(
+                    subject: "[PROD] ${env.JOB_NAME} #${env.BUILD_NUMBER} succeeded",
+                    body: renderEmail('Build succeeded', '#16a34a', buildInfo()),
+                    mimeType: 'text/html',
+                    to: 'admin@msigmagokulam.com, ashir@mgsigma.net, kailasdevdas@msigmagokulam.com'
+                )
+            }
+        }
+        failure {
+            script {
+                emailext(
+                    subject: "[PROD] ${env.JOB_NAME} #${env.BUILD_NUMBER} failed",
+                    body: renderEmail('Build failed', '#dc2626', buildInfo()),
+                    mimeType: 'text/html',
+                    to: 'admin@msigmagokulam.com, ashir@mgsigma.net, kailasdevdas@msigmagokulam.com'
+                )
+            }
+        }
+    }
+}
+
+def buildInfo() {
+    return [
+        hash:     env.BUILD_INFO_HASH ?: 'N/A',
+        author:   env.BUILD_INFO_AUTHOR ?: 'N/A',
+        message:  env.BUILD_INFO_MESSAGE ?: 'N/A',
+        trigger:  env.BUILD_INFO_TRIGGER ?: 'Unknown',
+        duration: currentBuild.durationString.replace(' and counting', '')
+    ]
+}
+
+def renderEmail(String label, String accent, Map info) {
+    return """\
+<!DOCTYPE html>
+<html>
+<body style="margin:0; padding:0; background-color:#f6f7f9;">
+<table role="presentation" cellpadding="0" cellspacing="0" border="0" width="100%" style="background-color:#f6f7f9; padding:40px 16px;">
+  <tr><td align="center">
+    <table role="presentation" cellpadding="0" cellspacing="0" border="0" width="560" style="max-width:560px; background:#ffffff; border-radius:12px; overflow:hidden; box-shadow:0 1px 3px rgba(15,23,42,0.08); font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',Roboto,Helvetica,Arial,sans-serif;">
+      <tr><td style="height:3px; background:${accent};"></td></tr>
+      <tr><td style="padding:32px 40px 0 40px;">
+        <div style="font-size:12px; font-weight:600; color:${accent}; letter-spacing:0.8px; text-transform:uppercase; margin-bottom:6px;">${label} · production</div>
+        <div style="font-size:20px; font-weight:600; color:#0f172a; line-height:1.35;">${env.JOB_NAME}<span style="color:#94a3b8; font-weight:400;"> &middot; #${env.BUILD_NUMBER}</span></div>
+      </td></tr>
+      <tr><td style="padding:20px 40px 8px 40px;">
+        <table role="presentation" cellpadding="0" cellspacing="0" border="0" width="100%" style="font-size:14px; color:#0f172a;">
+          <tr><td width="110" style="padding:7px 0; color:#64748b;">Commit</td><td style="padding:7px 0; font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace; font-size:13px;">${info.hash}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Author</td><td style="padding:7px 0;">${info.author}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b; vertical-align:top;">Message</td><td style="padding:7px 0;">${info.message}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Triggered by</td><td style="padding:7px 0;">${info.trigger}</td></tr>
+          <tr><td style="padding:7px 0; color:#64748b;">Duration</td><td style="padding:7px 0;">${info.duration}</td></tr>
+        </table>
+      </td></tr>
+      <tr><td style="padding:20px 40px 32px 40px;">
+        <a href="${env.BUILD_URL}" style="display:inline-block; padding:10px 18px; background:#0f172a; color:#ffffff; text-decoration:none; border-radius:8px; font-size:14px; font-weight:500;">View build</a>
+        <a href="${env.BUILD_URL}console" style="display:inline-block; padding:10px 14px; color:#475569; text-decoration:none; font-size:14px; font-weight:500;">Console output &rarr;</a>
+      </td></tr>
+      <tr><td style="padding:14px 40px; background:#f8fafc; border-top:1px solid #e2e8f0; font-size:12px; color:#94a3b8;">
+        Automated notification from Jenkins
+      </td></tr>
+    </table>
+  </td></tr>
+</table>
+</body>
+</html>
+"""
+}

README.md

@@ -0,0 +1,94 @@
+# Docker Setup (Backend + Frontend + PostgreSQL)
+
+This project provides a complete development environment using **Docker Compose** for:
+
+- Backend (Node.js / Express / Prisma)
+- Frontend (Vite / React)
+- PostgreSQL Database
+
+---
+
+## Project Structure
+
+```
+.
+├── backend/
+├── frontend/
+├── docker/
+│   └── dev/
+│       ├── Dockerfile.main
+│       └── Dockerfile.frontend
+├── docker-compose.dev.yml
+```
+
+---
+
+## Prerequisites
+
+Make sure you have installed:
+
+- Docker
+- Docker Compose
+
+---
+
+## Environment Variables
+
+### Backend (`backend/.env`)
+
+```env
+DATABASE_URL=postgresql://user:password@db:5432/mydb
+PORT=5008
+JWT_SECRET=your_secret_here
+
+CORS_ALLOWED_ORIGINS=http://localhost:5173
+
+BYTESCALE_SECRET_API_KEY=your_key
+POSTMARK_API_KEY=your_key
+EMAIL_FROM=admin@example.com
+```
+
+### Frontend (`frontend/.env`)
+
+```env
+VITE_API_URL=http://localhost:5008/api
+```
+
+---
+
+## Running the Project
+
+### Start containers
+
+```bash
+docker compose -f docker-compose.dev.yml up --build
+```
+
+## Create User
+
+```bash
+docker exec -it gg-backend-api-backend-1 node src/utils/createUser.js <name> <password> <role>
+
+```
+
+---
+
+### Stop containers
+
+```bash
+docker compose -f docker-compose.dev.yml down
+```
+
+---
+
+## Database (PostgreSQL)
+
+- User: `user`
+- Password: `password`
+- DB: `mydb`
+
+Data is persisted using Docker volume:
+
+```
+postgres_data
+```

backend/.gitignore

@@ -1,5 +1,5 @@
 node_modules
 # Keep environment variables out of version control
-.env
+.env*
 
 /src/generated/prisma

backend/README.md

@@ -0,0 +1,59 @@
+**GG-Node-Backend**
+
+## Tech Stack
+
+Runtime: Node.js (ES Modules)
+Framework: Express.js (v5.x)
+ORM: Prisma (PostgreSQL)
+Storage: Bytescale (Image uploads)
+Auth: JSON Web Tokens (JWT) & Bcrypt
+Email: Postmark
+
+## Project Structure
+
+backend/
+├── prisma/
+│ └── schema.prisma  
+├──── src/
+│ ├── app.js  
+│ ├── controllers/  
+│ ├── middlewares/  
+│ ├── routes/  
+│ ├── prisma/  
+│ └── utils/  
+├── .env  
+└── package.json
+
+## Installation & Setup
+
+**1. Prerequisites**
+Node.js (v18+)
+PostgreSQL Database
+
+**2. Environment Variables**
+DATABASE_URL=""
+PORT=5008
+JWT_SECRET=""
+CORS_ALLOWED_ORIGINS=http://localhost:3001 http://localhost:3003 http://localhost:5174 http://localhost:5173
+BYTESCALE_SECRET_API_KEY=""
+POSTMARK_API_KEY=""
+
+**3. Install Dependencies**
+npm install
+
+**4. Database Initialization**
+
+# Generate Prisma Client
+
+npm run generate
+
+# Run migrations to create database tables
+
+npm run migrate
+
+## Scripts
+
+1. npm start: Runs the server in production mode.
+2. npm run migrate: Syncs your local database with the current Prisma schema.
+3. npm run generate: Regenerates the Prisma Client (run this after schema changes).
+4. npx prisma studio: Opens a visual editor to view and manage your database data.

backend/package.json

@@ -8,13 +8,15 @@
 		"start": "node src/app.js",
 		"prisma": "prisma",
 		"migrate": "npx prisma migrate dev",
-		"generate": "npx prisma generate"
+		"generate": "npx prisma generate",
+		"create-user": "node src/utils/createUser.js"
 	},
 	"keywords": [],
 	"author": "",
 	"license": "ISC",
 	"type": "module",
 	"dependencies": {
+		"@bytescale/sdk": "^3.53.0",
 		"@editorjs/editorjs": "^2.31.4",
 		"@editorjs/header": "^2.8.8",
 		"@editorjs/list": "^2.0.9",
@@ -27,7 +29,10 @@
 		"express-session": "^1.19.0",
 		"jsonwebtoken": "^9.0.3",
 		"multer": "^2.1.1",
-		"prisma": "^6.19.2"
+		"node-fetch": "^3.3.2",
+		"postmark": "^4.0.7",
+		"prisma": "^6.19.2",
+		"slugify": "^1.6.9"
 	},
 	"devDependencies": {
 		"nodemon": "^3.1.11"

backend/prisma/migrations/20260313085241_career/migration.sql

@@ -0,0 +1,15 @@
+-- CreateTable
+CREATE TABLE "Career" (
+    "id" SERIAL NOT NULL,
+    "post" TEXT NOT NULL,
+    "designation" TEXT,
+    "qualification" TEXT,
+    "experienceNeed" TEXT,
+    "email" TEXT,
+    "number" TEXT,
+    "status" TEXT NOT NULL DEFAULT 'new',
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Career_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260313093706_create_candidate/migration.sql

@@ -0,0 +1,17 @@
+-- CreateTable
+CREATE TABLE "Candidate" (
+    "id" SERIAL NOT NULL,
+    "fullName" TEXT NOT NULL,
+    "mobile" TEXT NOT NULL,
+    "email" TEXT NOT NULL,
+    "subject" TEXT NOT NULL,
+    "coverLetter" TEXT NOT NULL,
+    "careerId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Candidate_pkey" PRIMARY KEY ("id")
+);
+
+-- AddForeignKey
+ALTER TABLE "Candidate" ADD CONSTRAINT "Candidate_careerId_fkey" FOREIGN KEY ("careerId") REFERENCES "Career"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

backend/prisma/migrations/20260313101753_appointment/migration.sql

@@ -0,0 +1,21 @@
+-- CreateTable
+CREATE TABLE "Appointment" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "mobileNumber" TEXT NOT NULL,
+    "email" TEXT,
+    "message" TEXT,
+    "date" TIMESTAMP(3) NOT NULL,
+    "doctorId" INTEGER NOT NULL,
+    "departmentId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Appointment_pkey" PRIMARY KEY ("id")
+);
+
+-- AddForeignKey
+ALTER TABLE "Appointment" ADD CONSTRAINT "Appointment_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "Appointment" ADD CONSTRAINT "Appointment_departmentId_fkey" FOREIGN KEY ("departmentId") REFERENCES "Department"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

backend/prisma/migrations/20260313110806_appointment_relation_fix/migration.sql

@@ -0,0 +1,15 @@
+-- DropForeignKey
+ALTER TABLE "Appointment" DROP CONSTRAINT "Appointment_departmentId_fkey";
+
+-- DropForeignKey
+ALTER TABLE "Appointment" DROP CONSTRAINT "Appointment_doctorId_fkey";
+
+-- AlterTable
+ALTER TABLE "Appointment" ALTER COLUMN "doctorId" SET DATA TYPE TEXT,
+ALTER COLUMN "departmentId" SET DATA TYPE TEXT;
+
+-- AddForeignKey
+ALTER TABLE "Appointment" ADD CONSTRAINT "Appointment_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("doctorId") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "Appointment" ADD CONSTRAINT "Appointment_departmentId_fkey" FOREIGN KEY ("departmentId") REFERENCES "Department"("departmentId") ON DELETE RESTRICT ON UPDATE CASCADE;

backend/prisma/migrations/20260316053147_inquiry_schema/migration.sql

@@ -0,0 +1,13 @@
+-- CreateTable
+CREATE TABLE "Inquiry" (
+    "id" SERIAL NOT NULL,
+    "fullName" TEXT NOT NULL,
+    "number" TEXT NOT NULL,
+    "emailId" TEXT,
+    "subject" TEXT,
+    "message" TEXT,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Inquiry_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260316062726_create_academics_research/migration.sql

@@ -0,0 +1,14 @@
+-- CreateTable
+CREATE TABLE "AcademicsResearch" (
+    "id" SERIAL NOT NULL,
+    "fullName" TEXT NOT NULL,
+    "number" TEXT NOT NULL,
+    "emailId" TEXT,
+    "subject" TEXT,
+    "courseName" TEXT,
+    "message" TEXT,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "AcademicsResearch_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260319060901_add_email_config/migration.sql

@@ -0,0 +1,12 @@
+-- CreateTable
+CREATE TABLE "EmailConfig" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "email" TEXT NOT NULL,
+    "type" TEXT NOT NULL,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "EmailConfig_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260325110104_add_news_media/migration.sql

@@ -0,0 +1,15 @@
+-- CreateTable
+CREATE TABLE "NewsMedia" (
+    "id" SERIAL NOT NULL,
+    "headline" TEXT NOT NULL,
+    "content" TEXT,
+    "firstPara" TEXT,
+    "secondPara" TEXT,
+    "author" TEXT,
+    "date" TIMESTAMP(3),
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "NewsMedia_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260414074145_doctor_image_field/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "Doctor" ADD COLUMN     "image" TEXT;

backend/prisma/migrations/20260414083619_added_slug/migration.sql

@@ -0,0 +1,8 @@
+/*
+  Warnings:
+
+  - Added the required column `slug` to the `Blog` table without a default value. This is not possible if the table is not empty.
+
+*/
+-- AlterTable
+ALTER TABLE "Blog" ADD COLUMN     "slug" TEXT NOT NULL;

backend/prisma/migrations/20260414091055/migration.sql

@@ -0,0 +1,8 @@
+/*
+  Warnings:
+
+  - A unique constraint covering the columns `[slug]` on the table `Blog` will be added. If there are existing duplicate values, this will fail.
+
+*/
+-- CreateIndex
+CREATE UNIQUE INDEX "Blog_slug_key" ON "Blog"("slug");

backend/prisma/migrations/20260414102430_department_image/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "Department" ADD COLUMN     "image" TEXT;

backend/prisma/migrations/20260414105925_news_media/migration.sql

@@ -0,0 +1,12 @@
+-- CreateTable
+CREATE TABLE "NewsImage" (
+    "id" SERIAL NOT NULL,
+    "url" TEXT NOT NULL,
+    "newsMediaId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+    CONSTRAINT "NewsImage_pkey" PRIMARY KEY ("id")
+);
+
+-- AddForeignKey
+ALTER TABLE "NewsImage" ADD CONSTRAINT "NewsImage_newsMediaId_fkey" FOREIGN KEY ("newsMediaId") REFERENCES "NewsMedia"("id") ON DELETE CASCADE ON UPDATE CASCADE;

backend/prisma/schema.prisma

@@ -1,4 +1,3 @@
-
 generator client {
   provider = "prisma-client-js"
 }
@@ -22,21 +21,24 @@ model Doctor {
   id            Int     @id @default(autoincrement())
   doctorId      String  @unique
   name          String
+  image         String?
   designation   String?
   workingStatus String?
   qualification String?
 
   departments  DoctorDepartment[]
+  appointments Appointment[]
 
   createdAt DateTime @default(now())
   updatedAt DateTime @updatedAt
 }
 
-
 model Department {
   id           Int    @id @default(autoincrement())
   departmentId String @unique
   name         String
+  image        String?
+
 
   para1      String?
   para2      String?
@@ -45,6 +47,7 @@ model Department {
   services   String?
 
   doctors      DoctorDepartment[]
+  appointments Appointment[]
 
   createdAt DateTime @default(now())
   updatedAt DateTime @updatedAt
@@ -86,7 +89,6 @@ model DoctorTiming {
   updatedAt DateTime @updatedAt
 }
 
-
 model Blog {
   id       Int     @id @default(autoincrement())
   title    String
@@ -94,7 +96,121 @@ model Blog {
   image    String?
   content  Json
   isActive Boolean @default(true)
+  slug     String @unique
 
   createdAt DateTime @default(now())
   updatedAt DateTime @updatedAt
 }
+
+model Career {
+  id             Int     @id @default(autoincrement())
+  post           String
+  designation    String?
+  qualification  String?
+  experienceNeed String?
+  email          String?
+  number         String?
+  status         String  @default("new")
+
+  candidates Candidate[]
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model Candidate {
+  id          Int    @id @default(autoincrement())
+  fullName    String
+  mobile      String
+  email       String
+  subject     String
+  coverLetter String
+  careerId    Int
+
+  career Career @relation(fields: [careerId], references: [id])
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model Appointment {
+  id Int @id @default(autoincrement())
+
+  name         String
+  mobileNumber String
+  email        String?
+  message      String?
+  date         DateTime
+
+  doctorId     String
+  departmentId String
+
+  doctor     Doctor     @relation(fields: [doctorId], references: [doctorId])
+  department Department @relation(fields: [departmentId], references: [departmentId])
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model Inquiry {
+  id Int @id @default(autoincrement())
+
+  fullName String
+  number   String
+  emailId  String?
+  subject  String?
+  message  String?
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model AcademicsResearch {
+  id Int @id @default(autoincrement())
+
+  fullName   String
+  number     String
+  emailId    String?
+  subject    String?
+  courseName String?
+  message    String?
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model EmailConfig {
+  id       Int     @id @default(autoincrement())
+  name     String
+  email    String
+  type     String
+  isActive Boolean @default(true)
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+model NewsMedia {
+  id Int @id @default(autoincrement())
+
+  headline   String
+  content    String?
+  firstPara  String?
+  secondPara String?
+  author     String?
+  date       DateTime?
+  images     NewsImage[] 
+
+  isActive   Boolean  @default(true)
+  createdAt  DateTime    @default(now())
+  updatedAt  DateTime    @updatedAt
+}
+
+model NewsImage {
+  id          Int       @id @default(autoincrement())
+  url         String    
+  newsMediaId Int
+  newsMedia   NewsMedia @relation(fields: [newsMediaId], references: [id], onDelete: Cascade)
+
+  createdAt   DateTime  @default(now())
+}

backend/src/app.js

@@ -6,11 +6,23 @@ import departmentRoutes from "./routes/department.routes.js";
 import authRoutes from "./routes/auth.routes.js";
 import blogRoutes from "./routes/blog.routes.js";
 import uploadRoutes from "./routes/upload.routes.js";
+import doctorRoutes from "./routes/doctor.routes.js";
+import careerRoutes from "./routes/career.routes.js";
+import candidateRoutes from "./routes/candidate.routes.js";
+import appointmentRoutes from "./routes/appointment.routes.js";
+import inquiryRoutes from "./routes/inquiry.routes.js";
+import academicsResearchRoutes from "./routes/academicsResearch.routes.js";
+import emailConfigRoutes from "./routes/emailConfig.routes.js";
+import newsMediaRoutes from "./routes/newsMedia.routes.js";
+import importRoutes from "./routes/importRoutes.js";
 
 dotenv.config();
 
 const app = express();
 
+app.use(express.json({ limit: "50mb" }));
+app.use(express.urlencoded({ limit: "50mb", extended: true }));
+
 const allowedOrigins = process.env.CORS_ALLOWED_ORIGINS
 	? process.env.CORS_ALLOWED_ORIGINS.split(" ")
 	: ["http://localhost:3001"];
@@ -27,7 +39,6 @@ const corsOptions = {
 	allowedHeaders: "*",
 };
 
-app.use(express.json());
 app.use(cors(corsOptions));
 
 app.use("/api/departments", departmentRoutes);
@@ -35,8 +46,17 @@ app.use("/api/auth", authRoutes);
 app.use("/api/blogs", blogRoutes);
 app.use("/uploads", express.static("uploads"));
 app.use("/api/upload", uploadRoutes);
+app.use("/api/doctors", doctorRoutes);
+app.use("/api/careers", careerRoutes);
+app.use("/api/candidates", candidateRoutes);
+app.use("/api/appointments", appointmentRoutes);
+app.use("/api/inquiry", inquiryRoutes);
+app.use("/api/academics", academicsResearchRoutes);
+app.use("/api/email", emailConfigRoutes);
+app.use("/api/newsMedia", newsMediaRoutes);
+app.use("/api/import", importRoutes);
 
-const PORT = process.env.PORT || 3000;
+const PORT = process.env.PORT || 5008;
 app.listen(PORT, () => {
 	console.log(`Server running on port ${PORT}`);
 });

backend/src/controllers/academicsResearch.controller.js

@@ -0,0 +1,201 @@
+import prisma from "../prisma/client.js";
+import { sendEmail } from "../utils/sendEmail.js";
+import { getEmailsByType } from "../utils/getEmailByTypes.js";
+
+// CREATE ACADEMICS & RESEARCH
+
+export const createAcademicsResearch = async (req, res) => {
+	try {
+		const { fullName, number, emailId, subject, courseName, message } =
+			req.body;
+
+		if (!fullName || !number) {
+			return res.status(400).json({
+				success: false,
+				message: "Full name and number are required",
+			});
+		}
+
+		const data = await prisma.academicsResearch.create({
+			data: {
+				fullName,
+				number,
+				emailId,
+				subject,
+				courseName,
+				message,
+			},
+		});
+
+		try {
+			const emailList = await getEmailsByType("ACADEMICS");
+
+			if (emailList && emailList.length > 0) {
+				await sendEmail({
+					to: emailList,
+					subject: "New Academics & Research Inquiry",
+					html: `
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
+		  
+		  <div style="max-width: 600px; margin: auto; background: #ffffff; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 10px rgba(0,0,0,0.05);">
+		    
+		    <!-- Header -->
+		    <div style="background-color: #0d6efd; color: #ffffff; padding: 20px;">
+		      <h2 style="margin: 0;">GG Hospital</h2>
+		      <p style="margin: 5px 0 0; font-size: 14px;">
+		        New Academics & Research Inquiry
+		      </p>
+		    </div>
+
+		    <!-- Body -->
+		    <div style="padding: 20px; color: #333;">
+		      
+		      <h3 style="margin-top: 0;">Contact Details</h3>
+		      
+		      <table style="width: 100%; border-collapse: collapse;">
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Name:</b></td>
+		          <td style="padding: 8px 0;">${fullName}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Phone:</b></td>
+		          <td style="padding: 8px 0;">${number}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Email:</b></td>
+		          <td style="padding: 8px 0;">${emailId || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Course:</b></td>
+		          <td style="padding: 8px 0;">${courseName || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Subject:</b></td>
+		          <td style="padding: 8px 0;">${subject || "-"}</td>
+		        </tr>
+		      </table>
+
+		      <!-- Message Box -->
+		     <div style="margin-top: 20px;">
+				<h3>Message</h3>
+				<div style="
+					background: #f8f9fa;
+					padding: 15px;
+					border-radius: 6px;
+					line-height: 1.6;
+					white-space: pre-wrap;
+					word-break: break-word;
+					overflow-wrap: anywhere;
+				">
+					${message ? message.replace(/\n/g, "<br/>") : "-"}
+				</div>
+				</div>
+
+		    </div>
+
+		    <!-- Footer -->
+		    <div style="background: #f1f1f1; padding: 15px; text-align: center; font-size: 12px; color: #666;">
+		      This message was sent from the GG Hospital website (Academics & Research Inquiry).
+		    </div>
+
+		  </div>
+
+		</div>
+		`,
+				});
+			}
+		} catch (err) {
+			console.error("Academics email failed:", err);
+		}
+
+		res.status(200).json({
+			success: true,
+			status: 200,
+			data,
+			message: "Academics & Research added successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to add Academics & Research inquiry",
+		});
+	}
+};
+
+// GET ALL
+
+export const getAcademicsResearch = async (req, res) => {
+	try {
+		const data = await prisma.academicsResearch.findMany({
+			orderBy: {
+				createdAt: "desc",
+			},
+		});
+
+		res.json({
+			success: true,
+			data,
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch records",
+		});
+	}
+};
+
+// GET SINGLE
+
+export const getSingleAcademicsResearch = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const data = await prisma.academicsResearch.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!data) {
+			return res.status(404).json({
+				success: false,
+				message: "Record not found",
+			});
+		}
+
+		res.json({
+			success: true,
+			data,
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch record",
+		});
+	}
+};
+
+// DELETE
+
+export const deleteAcademicsResearch = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.academicsResearch.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.json({
+			success: true,
+			message: "Record deleted successfully",
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete record",
+		});
+	}
+};

backend/src/controllers/appointment.controller.js

@@ -0,0 +1,340 @@
+import prisma from "../prisma/client.js";
+import { sendEmail } from "../utils/sendEmail.js";
+import { getEmailsByType } from "../utils/getEmailByTypes.js";
+
+export const createAppointment = async (req, res) => {
+	try {
+		const { name, mobileNumber, email, message, date, doctorId, departmentId } =
+			req.body;
+
+		if (!name || !mobileNumber || !doctorId || !departmentId || !date) {
+			return res.status(400).json({
+				success: false,
+				message: "Required fields missing",
+			});
+		}
+
+		const appointment = await prisma.appointment.create({
+			data: {
+				name,
+				mobileNumber,
+				email,
+				message,
+				date: new Date(date),
+				doctorId,
+				departmentId,
+			},
+			include: {
+				doctor: true,
+				department: true,
+			},
+		});
+
+		try {
+			const emailList = await getEmailsByType("APPOINTMENT");
+
+			if (emailList) {
+				await sendEmail({
+					to: emailList,
+					subject: "New Appointment Booked",
+					html: `
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
+		  
+		  <div style="max-width: 600px; margin: auto; background: #ffffff; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 10px rgba(0,0,0,0.05);">
+		    
+		    <!-- Header -->
+		    <div style="background-color: #0d6efd; color: #ffffff; padding: 20px;">
+		      <h2 style="margin: 0;">GG Hospital</h2>
+		      <p style="margin: 5px 0 0; font-size: 14px;">
+		        New Appointment Booked
+		      </p>
+		    </div>
+
+		    <!-- Body -->
+		    <div style="padding: 20px; color: #333;">
+		      
+		      <h3 style="margin-top: 0;">Patient Details</h3>
+		      
+		      <table style="width: 100%; border-collapse: collapse;">
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Name:</b></td>
+		          <td style="padding: 8px 0;">${name}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Phone:</b></td>
+		          <td style="padding: 8px 0;">${mobileNumber}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Email:</b></td>
+		          <td style="padding: 8px 0;">${email || "-"}</td>
+		        </tr>
+		      </table>
+
+		      <h3 style="margin-top: 20px;">Appointment Details</h3>
+
+		      <table style="width: 100%; border-collapse: collapse;">
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Doctor:</b></td>
+		          <td style="padding: 8px 0;">${appointment.doctor?.name || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Department:</b></td>
+		          <td style="padding: 8px 0;">${appointment.department?.name || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Date:</b></td>
+		          <td style="padding: 8px 0;">
+		            ${new Date(date).toLocaleDateString()}
+		          </td>
+		        </tr>
+		      </table>
+
+		      <!-- Message Box -->
+		      <div style="margin-top: 20px;">
+		        <h3>Message</h3>
+		       <div style="
+					background: #f8f9fa;
+					padding: 15px;
+					border-radius: 6px;
+					line-height: 1.6;
+					white-space: pre-wrap;
+					word-break: break-word;
+					overflow-wrap: anywhere;
+				">
+					${message ? message.replace(/\n/g, "<br/>") : "-"}
+				</div>
+		      </div>
+
+		    </div>
+
+		    <!-- Footer -->
+		    <div style="background: #f1f1f1; padding: 15px; text-align: center; font-size: 12px; color: #666;">
+		      This appointment was booked via the GG Hospital website.
+		    </div>
+
+		  </div>
+
+		</div>
+		`,
+				});
+			}
+		} catch (err) {
+			console.error("Email failed:", err);
+		}
+
+		res.status(201).json({
+			success: true,
+			message: "Appointment booked successfully",
+			data: appointment,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to create appointment",
+		});
+	}
+};
+
+// GET ALL APPOINTMENTS
+
+export const getAppointments = async (req, res) => {
+	try {
+		const page = parseInt(req.query.page) || 1;
+		const limit = parseInt(req.query.limit) || 10;
+		const skip = (page - 1) * limit;
+		const { date, search } = req.query;
+
+		const where = {};
+
+		if (date) {
+			const start = new Date(date);
+			const end = new Date(date);
+			end.setDate(end.getDate() + 1);
+			where.date = { gte: start, lt: end };
+		}
+
+		if (search) {
+			where.OR = [
+				{ name: { contains: search, mode: "insensitive" } },
+				{ mobileNumber: { contains: search } },
+				{ email: { contains: search, mode: "insensitive" } },
+			];
+		}
+
+		const [appointments, total] = await Promise.all([
+			prisma.appointment.findMany({
+				where,
+				include: { doctor: true, department: true },
+				orderBy: { createdAt: "desc" },
+				skip,
+				take: limit,
+			}),
+			prisma.appointment.count({ where }),
+		]);
+
+		res.status(200).json({
+			success: true,
+			data: appointments,
+			pagination: { total, page, limit, totalPages: Math.ceil(total / limit) },
+		});
+	} catch (error) {
+		console.error(error);
+		res
+			.status(500)
+			.json({ success: false, message: "Failed to fetch appointments" });
+	}
+};
+
+// GET SINGLE APPOINTMENT
+
+export const getAppointment = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const appointment = await prisma.appointment.findUnique({
+			where: {
+				id: Number(id),
+			},
+			include: {
+				doctor: true,
+				department: true,
+			},
+		});
+
+		if (!appointment) {
+			return res.status(404).json({
+				success: false,
+				message: "Appointment not found",
+			});
+		}
+
+		res.status(200).json({
+			success: true,
+			data: appointment,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch appointment",
+		});
+	}
+};
+
+// GET APPOINTMENTS BY DOCTOR
+
+export const getAppointmentsByDoctor = async (req, res) => {
+	try {
+		const { doctorId } = req.params;
+
+		const appointments = await prisma.appointment.findMany({
+			where: {
+				doctorId,
+			},
+			include: {
+				doctor: true,
+				department: true,
+			},
+			orderBy: {
+				date: "asc",
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			data: appointments,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctor appointments",
+		});
+	}
+};
+
+// GET APPOINTMENTS BY DEPARTMENT
+
+export const getAppointmentsByDepartment = async (req, res) => {
+	try {
+		const { departmentId } = req.params;
+
+		const appointments = await prisma.appointment.findMany({
+			where: {
+				departmentId,
+			},
+			include: {
+				doctor: true,
+				department: true,
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			data: appointments,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch department appointments",
+		});
+	}
+};
+
+// UPDATE APPOINTMENT
+
+export const updateAppointment = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const appointment = await prisma.appointment.update({
+			where: {
+				id: Number(id),
+			},
+			data: req.body,
+			include: {
+				doctor: true,
+				department: true,
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Appointment updated successfully",
+			data: appointment,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to update appointment",
+		});
+	}
+};
+
+//DELETE APPOINTMENT
+
+export const deleteAppointment = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.appointment.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Appointment deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete appointment",
+		});
+	}
+};

backend/src/controllers/blog.controller.js

@@ -1,4 +1,5 @@
 import prisma from "../prisma/client.js";
+import slugify from "slugify";
 
 /* CREATE BLOG */
 
@@ -13,6 +14,7 @@ export async function createBlog(req, res) {
 				image,
 				content,
 				isActive,
+				slug: slugify(title),
 			},
 		});
 
@@ -54,6 +56,26 @@ export async function getAllBlogs(req, res) {
 /* GET SINGLE BLOG */
 
 export async function getBlog(req, res) {
+	try {
+		const slug = req.params.slug;
+
+		const blog = await prisma.blog.findUnique({
+			where: {slug},
+		});
+
+		if (!blog) {
+			return res.status(404).json({error: "Blog not found"});
+		}
+
+		res.json(blog);
+	} catch (error) {
+		res.status(500).json({error: error.message});
+	}
+}
+
+/* GET SINGLE BLOG (ADMIN)*/
+
+export async function getBlogForAdmin(req, res) {
 	try {
 		const id = Number(req.params.id);
 

backend/src/controllers/candidate.controller.js

@@ -0,0 +1,280 @@
+import prisma from "../prisma/client.js";
+
+import { sendEmail } from "../utils/sendEmail.js";
+import { getEmailsByType } from "../utils/getEmailByTypes.js";
+
+// CREATE CANDIDATE
+
+export const createCandidate = async (req, res) => {
+	try {
+		const { fullName, mobile, email, subject, coverLetter, careerId } =
+			req.body;
+
+		if (!fullName || !mobile || !email || !careerId) {
+			return res.status(400).json({
+				success: false,
+				message: "Required fields missing",
+			});
+		}
+
+		const candidate = await prisma.candidate.create({
+			data: {
+				fullName,
+				mobile,
+				email,
+				subject,
+				coverLetter,
+				careerId: Number(careerId),
+			},
+			include: {
+				career: true,
+			},
+		});
+
+		try {
+			const emailList = await getEmailsByType("CANDIDATE");
+
+			if (emailList && emailList.length > 0) {
+				await sendEmail({
+					to: emailList,
+					subject: "New Job Application Received",
+					html: `
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
+		  
+		  <div style="max-width: 600px; margin: auto; background: #ffffff; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 10px rgba(0,0,0,0.05);">
+		    
+		    <!-- Header -->
+		    <div style="background-color: #0d6efd; color: #ffffff; padding: 20px;">
+		      <h2 style="margin: 0;">GG Hospital</h2>
+		      <p style="margin: 5px 0 0; font-size: 14px;">
+		        New Job Application Received
+		      </p>
+		    </div>
+
+		    <!-- Body -->
+		    <div style="padding: 20px; color: #333;">
+		      
+		      <h3 style="margin-top: 0;">Candidate Details</h3>
+		      
+		      <table style="width: 100%; border-collapse: collapse;">
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Name:</b></td>
+		          <td style="padding: 8px 0;">${fullName}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Phone:</b></td>
+		          <td style="padding: 8px 0;">${mobile}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Email:</b></td>
+		          <td style="padding: 8px 0;">${email}</td>
+		        </tr>
+		      </table>
+
+		      <h3 style="margin-top: 20px;">Application Details</h3>
+
+		      <table style="width: 100%; border-collapse: collapse;">
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Applied For:</b></td>
+		          <td style="padding: 8px 0;">${candidate.career?.post || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Designation:</b></td>
+		          <td style="padding: 8px 0;">${candidate.career?.designation || "-"}</td>
+		        </tr>
+		        <tr>
+		          <td style="padding: 8px 0;"><b>Subject:</b></td>
+		          <td style="padding: 8px 0;">${subject || "-"}</td>
+		        </tr>
+		      </table>
+
+		      <!-- Cover Letter -->
+		      <div style="margin-top: 20px;">
+		        <h3>Cover Letter</h3>
+				<div style="
+					background: #f8f9fa;
+					padding: 15px;
+					border-radius: 6px;
+					line-height: 1.6;
+					white-space: pre-wrap;
+					word-break: break-word;
+					overflow-wrap: anywhere;
+				">
+					${coverLetter ? coverLetter.replace(/\n/g, "<br/>") : "-"}
+				</div>
+		      </div>
+
+		    </div>
+
+		    <!-- Footer -->
+		    <div style="background: #f1f1f1; padding: 15px; text-align: center; font-size: 12px; color: #666;">
+		      This application was submitted via the GG Hospital careers page.
+		    </div>
+
+		  </div>
+
+		</div>
+		`,
+				});
+			}
+		} catch (err) {
+			console.error("Candidate email failed:", err);
+		}
+
+		res.status(201).json({
+			success: true,
+			message: "Application submitted successfully",
+			data: candidate,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to create candidate",
+		});
+	}
+};
+
+// GET ALL CANDIDATES
+
+export const getCandidates = async (req, res) => {
+	try {
+		const candidates = await prisma.candidate.findMany({
+			include: {
+				career: true,
+			},
+			orderBy: {
+				createdAt: "desc",
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			data: candidates,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch candidates",
+		});
+	}
+};
+
+// GET SINGLE CANDIDATE
+
+export const getCandidate = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const candidate = await prisma.candidate.findUnique({
+			where: {
+				id: Number(id),
+			},
+			include: {
+				career: true,
+			},
+		});
+
+		if (!candidate) {
+			return res.status(404).json({
+				success: false,
+				message: "Candidate not found",
+			});
+		}
+
+		res.status(200).json({
+			success: true,
+			data: candidate,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch candidate",
+		});
+	}
+};
+
+// GET CANDIDATES BY CAREER
+
+export const getCandidatesByCareer = async (req, res) => {
+	try {
+		const { careerId } = req.params;
+
+		const candidates = await prisma.candidate.findMany({
+			where: {
+				careerId: Number(careerId),
+			},
+			include: {
+				career: true,
+			},
+			orderBy: {
+				createdAt: "desc",
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			data: candidates,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch candidates",
+		});
+	}
+};
+
+// UPDATE CANDIDATE
+
+export const updateCandidate = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const candidate = await prisma.candidate.update({
+			where: {
+				id: Number(id),
+			},
+			data: req.body,
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Candidate updated successfully",
+			data: candidate,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to update candidate",
+		});
+	}
+};
+
+// DELETE CANDIDATE
+
+export const deleteCandidate = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.candidate.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Candidate deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete candidate",
+		});
+	}
+};

backend/src/controllers/career.controller.js

@@ -0,0 +1,128 @@
+import prisma from "../prisma/client.js";
+
+// GET ALL CAREERS
+
+export const getAllCareers = async (req, res) => {
+	try {
+		const careers = await prisma.career.findMany({
+			orderBy: {createdAt: "desc"},
+		});
+
+		const response = careers.map((c) => ({
+			id: c.id,
+			post: c.post,
+			designation: c.designation,
+			qualification: c.qualification,
+			experienceNeed: c.experienceNeed,
+			email: c.email,
+			number: c.number,
+			status: c.status,
+		}));
+
+		return res.status(200).json({
+			success: true,
+			data: response,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to fetch careers",
+		});
+	}
+};
+
+// CREATE CAREER
+
+export const createCareer = async (req, res) => {
+	try {
+		const {
+			post,
+			designation,
+			qualification,
+			experienceNeed,
+			email,
+			number,
+			status,
+		} = req.body;
+
+		if (!post || !designation) {
+			return res.status(400).json({
+				success: false,
+				message: "Post and designation are required",
+			});
+		}
+
+		const career = await prisma.career.create({
+			data: {
+				post,
+				designation,
+				qualification,
+				experienceNeed,
+				email,
+				number,
+				status,
+			},
+		});
+
+		return res.status(201).json({
+			success: true,
+			message: "Career created successfully",
+			data: career,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to create career",
+		});
+	}
+};
+
+// UPDATE CAREER (PATCH)
+
+export const updateCareer = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		const career = await prisma.career.update({
+			where: {id: Number(id)},
+			data: req.body,
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "Career updated successfully",
+			data: career,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to update career",
+		});
+	}
+};
+
+// DELETE CAREER
+
+export const deleteCareer = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		await prisma.career.delete({
+			where: {id: Number(id)},
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "Career deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to delete career",
+		});
+	}
+};

backend/src/controllers/department.controller.js

@@ -8,7 +8,8 @@ export const getAllDepartments = async (req, res) => {
 
 		const response = departments.map((dep) => ({
 			departmentId: dep.departmentId,
-			Department: dep.name,
+			name: dep.name,
+			image: dep.image ?? "",
 			para1: dep.para1 ?? "",
 			para2: dep.para2 ?? "",
 			para3: dep.para3 ?? "",
@@ -29,10 +30,66 @@ export const getAllDepartments = async (req, res) => {
 	}
 };
 
+export const getDepartmentByName = async (req, res) => {
+	try {
+		const {name} = req.query;
+
+		if (!name) {
+			return res.status(400).json({
+				success: false,
+				message: "Department name is required",
+			});
+		}
+
+		const department = await prisma.department.findFirst({
+			where: {
+				name: name,
+			},
+		});
+
+		if (!department) {
+			return res.status(404).json({
+				success: false,
+				message: "Department not found",
+			});
+		}
+
+		const response = {
+			departmentId: department.departmentId,
+			name: department.name,
+			image: department.image ?? "",
+			para1: department.para1 ?? "",
+			para2: department.para2 ?? "",
+			para3: department.para3 ?? "",
+			facilities: department.facilities ?? "",
+			services: department.services ?? "",
+		};
+
+		return res.status(200).json({
+			success: true,
+			data: [response],
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to fetch department",
+		});
+	}
+};
+
 export async function createDepartment(req, res) {
 	try {
-		const {departmentId, name, para1, para2, para3, facilities, services} =
-			req.body;
+		const {
+			departmentId,
+			name,
+			image,
+			para1,
+			para2,
+			para3,
+			facilities,
+			services,
+		} = req.body;
 
 		if (!departmentId || !name) {
 			return res
@@ -44,6 +101,7 @@ export async function createDepartment(req, res) {
 			data: {
 				departmentId,
 				name,
+				image,
 				para1,
 				para2,
 				para3,
@@ -64,3 +122,57 @@ export async function createDepartment(req, res) {
 		res.status(500).json({error: "Failed to create department"});
 	}
 }
+
+export const updateDepartment = async (req, res) => {
+	try {
+		const {departmentId} = req.params;
+
+		const {name, image, para1, para2, para3, facilities, services} = req.body;
+
+		const department = await prisma.department.update({
+			where: {departmentId},
+			data: {
+				name,
+				image,
+				para1,
+				para2,
+				para3,
+				facilities,
+				services,
+			},
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "Department updated successfully",
+			data: department,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to update department",
+		});
+	}
+};
+
+export const deleteDepartment = async (req, res) => {
+	try {
+		const {departmentId} = req.params;
+
+		await prisma.department.delete({
+			where: {departmentId},
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "Department deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to delete department",
+		});
+	}
+};

backend/src/controllers/doctor.controller.js

@@ -0,0 +1,439 @@
+import prisma from "../prisma/client.js";
+
+// get doctors
+
+export const getAllDoctors = async (req, res) => {
+	try {
+		const doctors = await prisma.doctor.findMany({
+			include: {
+				departments: {
+					include: {
+						department: true,
+						timing: true,
+					},
+				},
+			},
+			orderBy: {name: "asc"},
+		});
+
+		const formatted = doctors.map((doc, index) => ({
+			SL_NO: String(index + 1),
+			doctorId: doc.doctorId,
+			name: doc.name,
+			image: doc.image ?? "",
+			designation: doc.designation,
+			workingStatus: doc.workingStatus,
+			qualification: doc.qualification,
+
+			departments: doc.departments.map((d) => {
+				const t = d.timing || {};
+
+				const timingArray = [
+					t.monday && `Monday ${t.monday}`,
+					t.tuesday && `Tuesday ${t.tuesday}`,
+					t.wednesday && `Wednesday ${t.wednesday}`,
+					t.thursday && `Thursday ${t.thursday}`,
+					t.friday && `Friday ${t.friday}`,
+					t.saturday && `Saturday ${t.saturday}`,
+					t.sunday && `Sunday ${t.sunday}`,
+					t.additional && t.additional,
+				].filter(Boolean);
+
+				return {
+					departmentId: d.department.departmentId,
+					departmentName: d.department.name,
+					timing: timingArray.join(" & "),
+				};
+			}),
+		}));
+
+		res.status(200).json({
+			success: true,
+			data: formatted,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctors",
+		});
+	}
+};
+
+// get doctor by id
+
+export const getDoctorByDoctorId = async (req, res) => {
+	try {
+		const {doctorId} = req.params;
+
+		const doctor = await prisma.doctor.findUnique({
+			where: {doctorId},
+			include: {
+				departments: {
+					include: {
+						department: true,
+						timing: true,
+					},
+				},
+			},
+		});
+
+		if (!doctor) {
+			return res.status(404).json({
+				success: false,
+				message: "Doctor not found",
+			});
+		}
+
+		const response = {
+			doctorId: doctor.doctorId,
+			name: doctor.name,
+			image: doctor.image ?? "",
+			designation: doctor.designation,
+			workingStatus: doctor.workingStatus,
+			qualification: doctor.qualification,
+			departments: doctor.departments.map((d) => ({
+				departmentId: d.department.departmentId,
+				departmentName: d.department.name,
+				timing: d.timing || {},
+			})),
+		};
+
+		res.status(200).json({
+			success: true,
+			data: response,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctor",
+		});
+	}
+};
+
+// get doctors by department
+export const getDoctorsByDepartmentId = async (req, res) => {
+	try {
+		const {Department_ID} = req.query;
+
+		if (!Department_ID) {
+			return res.status(400).json({
+				success: false,
+				message: "Department_ID is required",
+			});
+		}
+
+		const department = await prisma.department.findUnique({
+			where: {departmentId: Department_ID},
+		});
+
+		if (!department) {
+			return res.status(404).json({
+				success: false,
+				message: "Department not found",
+			});
+		}
+
+		const doctors = await prisma.doctorDepartment.findMany({
+			where: {departmentId: department.id},
+			include: {
+				doctor: true,
+			},
+		});
+
+		const result = doctors.map((d) => ({
+			GG_ID: d.doctor.doctorId,
+			Name: d.doctor.name,
+			image: d.doctor.image ?? "",
+		}));
+
+		res.status(200).json({
+			success: true,
+			data: result,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctors",
+		});
+	}
+};
+
+// add doctors
+export const createDoctor = async (req, res) => {
+	try {
+		const {
+			doctorId,
+			name,
+			image,
+			designation,
+			workingStatus,
+			qualification,
+			departments,
+		} = req.body;
+
+		const doctor = await prisma.doctor.create({
+			data: {
+				doctorId,
+				name,
+				image,
+				designation,
+				workingStatus,
+				qualification,
+			},
+		});
+
+		for (const dep of departments) {
+			const department = await prisma.department.findUnique({
+				where: {departmentId: dep.departmentId},
+			});
+
+			if (!department) continue;
+
+			const doctorDepartment = await prisma.doctorDepartment.create({
+				data: {
+					doctorId: doctor.id,
+					departmentId: department.id,
+				},
+			});
+
+			if (dep.timing) {
+				await prisma.doctorTiming.create({
+					data: {
+						doctorDepartmentId: doctorDepartment.id,
+						...dep.timing,
+					},
+				});
+			}
+		}
+
+		res.status(201).json({
+			success: true,
+			message: "Doctor created successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to create doctor",
+		});
+	}
+};
+
+//update doctors
+export const updateDoctor = async (req, res) => {
+	try {
+		const {doctorId} = req.params;
+		const {
+			name,
+			designation,
+			image,
+			workingStatus,
+			qualification,
+			departments,
+		} = req.body;
+
+		const doctor = await prisma.doctor.findUnique({
+			where: {doctorId},
+		});
+
+		if (!doctor) {
+			return res
+				.status(404)
+				.json({success: false, message: "Doctor not found"});
+		}
+
+		await prisma.doctor.update({
+			where: {id: doctor.id},
+			data: {name, designation, image, workingStatus, qualification},
+		});
+
+		const oldRelations = await prisma.doctorDepartment.findMany({
+			where: {doctorId: doctor.id},
+		});
+
+		for (const rel of oldRelations) {
+			await prisma.doctorTiming.deleteMany({
+				where: {doctorDepartmentId: rel.id},
+			});
+		}
+
+		await prisma.doctorDepartment.deleteMany({
+			where: {doctorId: doctor.id},
+		});
+
+		for (const dep of departments) {
+			const department = await prisma.department.findUnique({
+				where: {departmentId: dep.departmentId},
+			});
+
+			if (!department) continue;
+
+			const doctorDepartment = await prisma.doctorDepartment.create({
+				data: {
+					doctorId: doctor.id,
+					departmentId: department.id,
+				},
+			});
+
+			if (dep.timing) {
+				const {id, doctorDepartmentId, createdAt, updatedAt, ...cleanTiming} =
+					dep.timing;
+
+				await prisma.doctorTiming.create({
+					data: {
+						doctorDepartmentId: doctorDepartment.id,
+						...cleanTiming,
+					},
+				});
+			}
+		}
+
+		res
+			.status(200)
+			.json({success: true, message: "Doctor updated successfully"});
+	} catch (error) {
+		console.error("Update Error:", error);
+		res.status(500).json({success: false, message: "Failed to update doctor"});
+	}
+};
+//delete doctor
+
+export const deleteDoctor = async (req, res) => {
+	try {
+		const {doctorId} = req.params;
+
+		const doctor = await prisma.doctor.findUnique({
+			where: {doctorId},
+		});
+
+		if (!doctor) {
+			return res.status(404).json({
+				success: false,
+				message: "Doctor not found",
+			});
+		}
+
+		const doctorDepartments = await prisma.doctorDepartment.findMany({
+			where: {doctorId: doctor.id},
+		});
+
+		for (const dd of doctorDepartments) {
+			await prisma.doctorTiming.deleteMany({
+				where: {doctorDepartmentId: dd.id},
+			});
+		}
+
+		await prisma.doctorDepartment.deleteMany({
+			where: {doctorId: doctor.id},
+		});
+
+		await prisma.doctor.delete({
+			where: {id: doctor.id},
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Doctor deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete doctor",
+		});
+	}
+};
+
+// get doctor timings
+
+export const getDoctorTimings = async (req, res) => {
+	try {
+		const doctors = await prisma.doctor.findMany({
+			include: {
+				departments: {
+					include: {
+						timing: true,
+					},
+				},
+			},
+		});
+
+		const result = doctors.map((doc) => {
+			const timing = doc.departments[0]?.timing || {};
+
+			return {
+				Doctor_ID: doc.doctorId,
+				Doctor: doc.name,
+				Monday: timing.monday || "",
+				Tuesday: timing.tuesday || "",
+				Wednesday: timing.wednesday || "",
+				Thursday: timing.thursday || "",
+				Friday: timing.friday || "",
+				Saturday: timing.saturday || "",
+				Sunday: timing.sunday || "",
+				Additional: timing.additional || "",
+			};
+		});
+
+		res.status(200).json({
+			success: true,
+			data: result,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctor timings",
+		});
+	}
+};
+// get doctor timings by id
+
+export const getDoctorTimingById = async (req, res) => {
+	try {
+		const {doctorId} = req.params;
+
+		const doctor = await prisma.doctor.findUnique({
+			where: {doctorId},
+			include: {
+				departments: {
+					include: {
+						department: true,
+						timing: true,
+					},
+				},
+			},
+		});
+
+		if (!doctor) {
+			return res.status(404).json({
+				success: false,
+				message: "Doctor not found",
+			});
+		}
+
+		const result = {
+			doctorId: doctor.doctorId,
+			doctorName: doctor.name,
+			departments: doctor.departments.map((d) => ({
+				departmentId: d.department.departmentId,
+				departmentName: d.department.name,
+				timing: d.timing || {},
+			})),
+		};
+
+		res.status(200).json({
+			success: true,
+			data: result,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch doctor timing",
+		});
+	}
+};

backend/src/controllers/emailConfig.controller.js

@@ -0,0 +1,139 @@
+import prisma from "../prisma/client.js";
+
+// CREATE
+export const createEmailConfig = async (req, res) => {
+	try {
+		const {name, email, type, isActive} = req.body;
+
+		if (!name || !email || !type) {
+			return res.status(400).json({
+				success: false,
+				message: "Name, Email and Type are required",
+			});
+		}
+
+		const newEmail = await prisma.emailConfig.create({
+			data: {
+				name,
+				email,
+				type,
+				isActive: isActive ?? true,
+			},
+		});
+
+		res.status(201).json({
+			success: true,
+			message: "Email config created",
+			data: newEmail,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to create email config",
+		});
+	}
+};
+
+//GET ALL
+export const getEmailConfigs = async (req, res) => {
+	try {
+		const emails = await prisma.emailConfig.findMany({
+			orderBy: {
+				createdAt: "desc",
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			data: emails,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch email configs",
+		});
+	}
+};
+
+// GET SINGLE
+export const getEmailConfig = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		const email = await prisma.emailConfig.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!email) {
+			return res.status(404).json({
+				success: false,
+				message: "Email config not found",
+			});
+		}
+
+		res.status(200).json({
+			success: true,
+			data: email,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch email config",
+		});
+	}
+};
+
+// UPDATE
+export const updateEmailConfig = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		const updated = await prisma.emailConfig.update({
+			where: {
+				id: Number(id),
+			},
+			data: req.body,
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Email config updated",
+			data: updated,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to update email config",
+		});
+	}
+};
+
+// DELETE
+export const deleteEmailConfig = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		await prisma.emailConfig.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.status(200).json({
+			success: true,
+			message: "Email config deleted",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete email config",
+		});
+	}
+};

backend/src/controllers/importController.js

@@ -0,0 +1,304 @@
+import { PrismaClient } from "@prisma/client";
+
+const prisma = new PrismaClient();
+
+export const bulkImportExcelData = async (req, res) => {
+	try {
+		const {
+			departments,
+			doctors,
+			timings,
+			careers,
+			inquiries,
+			academics,
+			appointments,
+			candidates,
+			news,
+		} = req.body;
+
+		console.log("🚀 Starting Robust Data Import...");
+
+		// 1. DEPARTMENTS
+		if (departments) {
+			for (const row of departments) {
+				if (!row.SL_NO) continue;
+				await prisma.department.upsert({
+					where: { departmentId: row.SL_NO.toString() },
+					update: {
+						name: row.Department?.toString(),
+						para1: row.para1?.toString() || null,
+						para2: row.para2?.toString() || null,
+						para3: row.para3?.toString() || null,
+						facilities: row.facilities?.toString() || null,
+						services: row.services?.toString() || null,
+					},
+					create: {
+						departmentId: row.SL_NO.toString(),
+						name: row.Department?.toString(),
+						para1: row.para1?.toString() || null,
+						para2: row.para2?.toString() || null,
+						para3: row.para3?.toString() || null,
+						facilities: row.facilities?.toString() || null,
+						services: row.services?.toString() || null,
+					},
+				});
+			}
+		}
+
+		// 2. DOCTORS
+		if (doctors) {
+			for (const row of doctors) {
+				if (!row.GG_ID) continue;
+				const doctor = await prisma.doctor.upsert({
+					where: { doctorId: row.GG_ID.toString() },
+					update: {
+						name: row.Name?.toString(),
+						designation: row.Designation?.toString() || null,
+						workingStatus: row["Working Status"]?.toString() || null,
+						qualification: row.Qualification?.toString() || null,
+					},
+					create: {
+						doctorId: row.GG_ID.toString(),
+						name: row.Name?.toString(),
+						designation: row.Designation?.toString() || null,
+						workingStatus: row["Working Status"]?.toString() || null,
+						qualification: row.Qualification?.toString() || null,
+					},
+				});
+
+				if (row.Department_ID) {
+					const dept = await prisma.department.findUnique({
+						where: { departmentId: row.Department_ID.toString() },
+					});
+					if (dept) {
+						await prisma.doctorDepartment.upsert({
+							where: {
+								doctorId_departmentId: {
+									doctorId: doctor.id,
+									departmentId: dept.id,
+								},
+							},
+							update: {},
+							create: {
+								doctorId: doctor.id,
+								departmentId: dept.id,
+							},
+						});
+					}
+				}
+			}
+		}
+
+		// 3. TIMINGS
+		if (timings) {
+			for (const row of timings) {
+				if (!row.GG_ID) continue;
+				const doctor = await prisma.doctor.findUnique({
+					where: { doctorId: row.GG_ID.toString() },
+					include: { departments: true },
+				});
+
+				if (doctor && doctor.departments.length > 0) {
+					const doctorDeptId = doctor.departments[0].id;
+					const rawAdd = row.Additional?.toString() || "";
+					const rawMon = row.Monday?.toString() || "";
+					const isAppt = (val) => /appointment|basis|on call/i.test(val);
+
+					let finalAdd = rawAdd;
+					if (!finalAdd && isAppt(rawMon)) finalAdd = rawMon;
+
+					await prisma.doctorTiming.upsert({
+						where: { doctorDepartmentId: doctorDeptId },
+						update: {
+							monday: isAppt(rawMon) ? null : row.Monday?.toString() || null,
+							tuesday: row.Tuesday?.toString() || null,
+							wednesday: row.Wednesday?.toString() || null,
+							thursday: row.Thursday?.toString() || null,
+							friday: row.Friday?.toString() || null,
+							saturday: row.Saturday?.toString() || null,
+							sunday: row.Sunday?.toString() || null,
+							additional: finalAdd || null,
+						},
+						create: {
+							doctorDepartmentId: doctorDeptId,
+							monday: isAppt(rawMon) ? null : row.Monday?.toString() || null,
+							tuesday: row.Tuesday?.toString() || null,
+							wednesday: row.Wednesday || null,
+							thursday: row.Thursday || null,
+							friday: row.Friday || null,
+							saturday: row.Saturday || null,
+							sunday: row.Sunday || null,
+							additional: finalAdd || null,
+						},
+					});
+				}
+			}
+		}
+
+		// 4. CAREERS
+		if (careers) {
+			for (const row of careers) {
+				if (!row.Post) continue;
+				const cId = row.Id ? parseInt(row.Id) : undefined;
+				const data = {
+					post: row.Post?.toString(),
+					designation: row.Designation?.toString() || null,
+					qualification: row.Qualification?.toString() || null,
+					experienceNeed: row.ExperienceNeed?.toString() || null,
+					email: row.HiringEmail?.toString() || null,
+					number: row.Number?.toString() || null,
+					status: row.Status?.toString() || "new",
+				};
+				if (cId) {
+					await prisma.career.upsert({
+						where: { id: cId },
+						update: data,
+						create: { ...data, id: cId },
+					});
+				} else {
+					await prisma.career.create({ data });
+				}
+			}
+		}
+
+		// 5. INQUIRIES
+		if (inquiries) {
+			for (const row of inquiries) {
+				if (!row.FullName) continue;
+				await prisma.inquiry.create({
+					data: {
+						fullName: row.FullName.toString(),
+						number: row.Number?.toString() || "",
+						emailId: row.EmailId?.toString() || null,
+						subject: row.Subject?.toString() || null,
+						message: row.Message?.toString() || null,
+						createdAt: row.Date ? new Date(row.Date) : new Date(),
+					},
+				});
+			}
+		}
+
+		// 6. ACADEMICS & RESEARCH (FIXED HERE)
+		if (academics) {
+			for (const row of academics) {
+				if (!row.FullName) continue;
+				await prisma.academicsResearch.create({
+					data: {
+						fullName: row.FullName.toString(),
+						number: row.Number?.toString() || "",
+						emailId: row.EmailId?.toString() || null,
+						subject: row.Subject?.toString() || null, // Force String
+						courseName: row["Course Name"]?.toString() || null,
+						message: row.Message?.toString() || null,
+						createdAt: row.Date ? new Date(row.Date) : new Date(),
+					},
+				});
+			}
+		}
+
+		// 7. APPOINTMENTS
+		if (appointments) {
+			for (const row of appointments) {
+				if (!row.FullName) continue;
+				const doctorName = row.Doctor?.toString();
+				const departmentName = row["Department Id"]?.toString();
+
+				const doctor = await prisma.doctor.findFirst({
+					where: { name: doctorName },
+				});
+
+				const department = await prisma.department.findFirst({
+					where: { name: departmentName },
+				});
+				const parseDate = (value) => {
+					if (!value) return new Date();
+
+					// Excel numeric date
+					if (typeof value === "number") {
+						return new Date((value - 25569) * 86400 * 1000);
+					}
+
+					if (typeof value === "string") {
+						const v = value.trim();
+
+						// Handle DD/MM/YYYY
+						const ddmmyyyy = /^(\d{2})\/(\d{2})\/(\d{4})$/;
+						const match = v.match(ddmmyyyy);
+
+						if (match) {
+							const [_, dd, mm, yyyy] = match;
+							return new Date(`${yyyy}-${mm}-${dd}`);
+						}
+
+						// Fallback (ISO or other valid formats)
+						const d = new Date(v);
+
+						if (!isNaN(d.getTime()) && d.getFullYear() < 2100) {
+							return d;
+						}
+					}
+
+					console.warn("⚠️ Invalid date, using current date:", value);
+					return new Date();
+				};
+				if (doctor && department) {
+					await prisma.appointment.create({
+						data: {
+							name: row.FullName.toString(),
+							mobileNumber: row.Number?.toString() || "",
+							email: row["Email Id"]?.toString() || null,
+							message: row.Message?.toString() || null,
+							date: parseDate(row.Date),
+							doctorId: doctor.doctorId,
+							departmentId: department.departmentId,
+						},
+					});
+				}
+			}
+		}
+
+		// 8. CANDIDATES
+		if (candidates) {
+			for (const row of candidates) {
+				if (!row.FullName || !row.CareerId) continue;
+				await prisma.candidate
+					.create({
+						data: {
+							fullName: row.FullName.toString(),
+							mobile: row.Number?.toString() || "",
+							email: row.EmailId?.toString() || "",
+							subject: row.Subject?.toString() || "",
+							coverLetter: row["Cover Letter"]?.toString() || "",
+							careerId: parseInt(row.CareerId),
+							createdAt: row.Date ? new Date(row.Date) : new Date(),
+						},
+					})
+					.catch(() => {});
+			}
+		}
+
+		// 9. NEWS & MEDIA
+		if (news) {
+			for (const row of news) {
+				if (!row.Headline) continue;
+				await prisma.newsMedia.create({
+					data: {
+						headline: row.Headline.toString(),
+						content: row.Content?.toString() || null,
+						firstPara: row.FirstPara?.toString() || null,
+						secondPara: row.SecondPara?.toString() || null,
+						author: row.Author?.toString() || null,
+						date: row.Date ? new Date(row.Date) : null,
+					},
+				});
+			}
+		}
+
+		res
+			.status(200)
+			.json({ success: true, message: "✅ Import completed successfully!" });
+	} catch (error) {
+		console.error("❌ Bulk Import Error:", error);
+		res.status(500).json({ success: false, error: error.message });
+	}
+};

backend/src/controllers/inquiry.controller.js

@@ -0,0 +1,185 @@
+import prisma from "../prisma/client.js";
+
+import {sendEmail} from "../utils/sendEmail.js";
+import {getEmailsByType} from "../utils/getEmailByTypes.js";
+
+/* CREATE INQUIRY */
+export const createInquiry = async (req, res) => {
+	try {
+		const {fullName, number, emailId, subject, message} = req.body;
+
+		if (!fullName || !number) {
+			return res.status(400).json({
+				success: false,
+				message: "Full name and number are required",
+			});
+		}
+
+		const inquiry = await prisma.inquiry.create({
+			data: {
+				fullName,
+				number,
+				emailId,
+				subject,
+				message,
+			},
+		});
+		try {
+			const emailList = await getEmailsByType("INQUIRY");
+
+			if (emailList && emailList.length > 0) {
+				await sendEmail({
+					to: emailList,
+					subject: "New Inquiry Received",
+					html: `
+					<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
+					
+					<div style="max-width: 600px; margin: auto; background: #ffffff; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 10px rgba(0,0,0,0.05);">
+						
+						<!-- Header -->
+						<div style="background-color: #0d6efd; color: #ffffff; padding: 20px;">
+						<h2 style="margin: 0;">GG Hospital</h2>
+						<p style="margin: 5px 0 0; font-size: 14px;">New Inquiry Received</p>
+						</div>
+
+						<!-- Body -->
+						<div style="padding: 20px; color: #333;">
+						
+						<h3 style="margin-top: 0;">Contact Details</h3>
+						
+						<table style="width: 100%; border-collapse: collapse;">
+							<tr>
+							<td style="padding: 8px 0;"><b>Name:</b></td>
+							<td style="padding: 8px 0;">${fullName}</td>
+							</tr>
+							<tr>
+							<td style="padding: 8px 0;"><b>Phone:</b></td>
+							<td style="padding: 8px 0;">${number}</td>
+							</tr>
+							<tr>
+							<td style="padding: 8px 0;"><b>Email:</b></td>
+							<td style="padding: 8px 0;">${emailId}</td>
+							</tr>
+							<tr>
+							<td style="padding: 8px 0;"><b>Subject:</b></td>
+							<td style="padding: 8px 0;">${subject}</td>
+							</tr>
+						</table>
+
+						<!-- Message Box -->
+						<div style="margin-top: 20px;">
+							<h3>Message</h3>
+							<div style="
+										background: #f8f9fa;
+										padding: 15px;
+										border-radius: 6px;
+										line-height: 1.6;
+										white-space: pre-wrap;
+										word-break: break-word;
+										overflow-wrap: anywhere;
+									">
+										${message ? message.replace(/\n/g, "<br/>") : "-"}
+							</div>
+						</div>
+
+						</div>
+
+						<!-- Footer -->
+						<div style="background: #f1f1f1; padding: 15px; text-align: center; font-size: 12px; color: #666;">
+						This message was sent from the GG Hospital website contact form.
+						</div>
+
+					</div>
+
+					</div>
+					`,
+				});
+			}
+		} catch (err) {
+			console.error("Inquiry email failed:", err);
+		}
+
+		res.status(200).json({
+			success: true,
+			status: 200,
+			data: inquiry,
+			message: "Inquiry added successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: "Failed to add inquiry",
+		});
+	}
+};
+
+/* GET ALL */
+export const getInquiries = async (req, res) => {
+	try {
+		const inquiries = await prisma.inquiry.findMany({
+			orderBy: {
+				createdAt: "desc",
+			},
+		});
+
+		res.json({
+			success: true,
+			data: inquiries,
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch inquiries",
+		});
+	}
+};
+
+/* GET SINGLE */
+export const getInquiry = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		const inquiry = await prisma.inquiry.findUnique({
+			where: {id: Number(id)},
+		});
+
+		if (!inquiry) {
+			return res.status(404).json({
+				success: false,
+				message: "Inquiry not found",
+			});
+		}
+
+		res.json({
+			success: true,
+			data: inquiry,
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to fetch inquiry",
+		});
+	}
+};
+
+/* DELETE */
+export const deleteInquiry = async (req, res) => {
+	try {
+		const {id} = req.params;
+
+		await prisma.inquiry.delete({
+			where: {id: Number(id)},
+		});
+
+		res.json({
+			success: true,
+			message: "Inquiry deleted successfully",
+		});
+	} catch (error) {
+		res.status(500).json({
+			success: false,
+			message: "Failed to delete inquiry",
+		});
+	}
+};

backend/src/controllers/newsMedia.controller.js

@@ -0,0 +1,230 @@
+import prisma from "../prisma/client.js";
+
+// GET ALL NEWS
+
+export const getAllNews = async (req, res) => {
+	try {
+		const page = req.query.page ? parseInt(req.query.page) : null;
+		const limit = req.query.limit ? parseInt(req.query.limit) : null;
+		const search = req.query.search?.trim() || "";
+
+		const includeImages = {
+			images: true,
+		};
+
+		const searchFilter = search
+			? {
+					headline: {
+						contains: search,
+						mode: "insensitive",
+					},
+				}
+			: {};
+
+		const whereCondition = {
+			...searchFilter,
+		};
+
+		const skip = page && limit ? (page - 1) * limit : undefined;
+		const take = limit ? limit : undefined;
+
+		const [news, total] = await Promise.all([
+			prisma.newsMedia.findMany({
+				where: whereCondition,
+				include: includeImages,
+				orderBy: { createdAt: "desc" },
+				skip,
+				take,
+			}),
+			prisma.newsMedia.count({
+				where: whereCondition,
+			}),
+		]);
+
+		const response = news.map((n) => ({
+			Id: n.id.toString(),
+			Headline: n.headline,
+			Content: n.content,
+			FirstPara: n.firstPara,
+			SecondPara: n.secondPara,
+			Date: n.date,
+			Author: n.author,
+			Images: n.images.map((img) => ({
+				id: img.id,
+				image: img.url,
+			})),
+		}));
+
+		return res.status(200).json({
+			success: true,
+			data: response,
+			meta: {
+				total,
+				page: page || 1,
+				limit: limit || total,
+				totalPages: limit ? Math.ceil(total / limit) : 1,
+			},
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to fetch news",
+		});
+	}
+};
+// GET NEWS BY ID
+
+export const getNewsById = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const n = await prisma.newsMedia.findUnique({
+			where: { id: Number(id) },
+			include: { images: true },
+		});
+
+		if (!n) {
+			return res.status(404).json({
+				success: false,
+				message: "News not found",
+			});
+		}
+
+		const response = {
+			Id: n.id.toString(),
+			Headline: n.headline,
+			Content: n.content,
+			FirstPara: n.firstPara,
+			SecondPara: n.secondPara,
+			Date: n.date,
+			Author: n.author,
+			Images: n.images.map((img) => ({
+				id: img.id,
+				image: img.url,
+			})),
+		};
+
+		return res.status(200).json({
+			success: true,
+			data: response,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to fetch news",
+		});
+	}
+};
+
+// CREATE NEWS
+
+export const createNews = async (req, res) => {
+	try {
+		const {
+			headline,
+			content,
+			firstPara,
+			secondPara,
+			date,
+			author,
+			imageUrls,
+		} = req.body;
+
+		if (!headline) {
+			return res.status(400).json({
+				success: false,
+				message: "Headline is required",
+			});
+		}
+
+		const news = await prisma.newsMedia.create({
+			data: {
+				headline,
+				content,
+				firstPara,
+				secondPara,
+				date: date ? new Date(date) : null,
+				author,
+				images: imageUrls
+					? {
+							create: imageUrls.map((url) => ({ url })),
+						}
+					: undefined,
+			},
+			include: { images: true },
+		});
+
+		return res.status(201).json({
+			success: true,
+			message: "News created successfully",
+			data: news,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to create news",
+		});
+	}
+};
+
+// UPDATE NEWS
+
+export const updateNews = async (req, res) => {
+	try {
+		const { id } = req.params;
+		const { imageUrls, ...otherData } = req.body;
+
+		const news = await prisma.newsMedia.update({
+			where: { id: Number(id) },
+			data: {
+				...otherData,
+				date: req.body.date ? new Date(req.body.date) : undefined,
+				images: imageUrls
+					? {
+							deleteMany: {},
+							create: imageUrls.map((url) => ({ url })),
+						}
+					: undefined,
+			},
+			include: { images: true },
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "News updated successfully",
+			data: news,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to update news",
+		});
+	}
+};
+
+// DELETE NEWS
+
+export const deleteNews = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.newsMedia.delete({
+			where: { id: Number(id) },
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: "News deleted successfully",
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: "Failed to delete news",
+		});
+	}
+};

backend/src/routes/academicsResearch.routes.js

@@ -0,0 +1,18 @@
+import express from "express";
+import {
+	createAcademicsResearch,
+	getAcademicsResearch,
+	getSingleAcademicsResearch,
+	deleteAcademicsResearch,
+} from "../controllers/academicsResearch.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.post("/", createAcademicsResearch);
+router.get("/getAll", jwtAuthMiddleware, getAcademicsResearch);
+router.get("/:id", jwtAuthMiddleware, getSingleAcademicsResearch);
+router.delete("/:id", jwtAuthMiddleware, deleteAcademicsResearch);
+
+export default router;

backend/src/routes/appointment.routes.js

@@ -0,0 +1,23 @@
+import express from "express";
+import {
+	createAppointment,
+	getAppointments,
+	getAppointment,
+	updateAppointment,
+	deleteAppointment,
+} from "../controllers/appointment.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+/* PUBLIC */
+
+router.get("/getall", jwtAuthMiddleware, getAppointments);
+router.post("/", createAppointment);
+
+router.get("/:id", jwtAuthMiddleware, getAppointment);
+router.patch("/:id", jwtAuthMiddleware, updateAppointment);
+router.delete("/:id", jwtAuthMiddleware, deleteAppointment);
+
+export default router;

backend/src/routes/auth.routes.js

@@ -1,9 +1,8 @@
 import express from "express";
-import {register, login} from "../controllers/auth.controller.js";
+import { login } from "../controllers/auth.controller.js";
 
 const router = express.Router();
 
-router.post("/register", register);
 router.post("/login", login);
 
 export default router;

backend/src/routes/blog.routes.js

@@ -6,6 +6,7 @@ import {
 	updateBlog,
 	deleteBlog,
 	getAllBlogs,
+	getBlogForAdmin,
 } from "../controllers/blog.controller.js";
 
 import jwtAuthMiddleware from "../middleware/auth.js";
@@ -15,11 +16,14 @@ const router = express.Router();
 /* PUBLIC */
 
 router.get("/", getBlogs);
-router.get("/:id", getBlog);
+router.get("/:slug", getBlog);
 
 // Protected
 
 router.get("/admin/all", jwtAuthMiddleware, getAllBlogs);
+
+router.get("/admin/:id", jwtAuthMiddleware, getBlogForAdmin);
+
 router.post("/", jwtAuthMiddleware, createBlog);
 router.put("/:id", jwtAuthMiddleware, updateBlog);
 router.delete("/:id", jwtAuthMiddleware, deleteBlog);

backend/src/routes/candidate.routes.js

@@ -0,0 +1,25 @@
+import express from "express";
+import {
+	createCandidate,
+	getCandidates,
+	getCandidate,
+	getCandidatesByCareer,
+	updateCandidate,
+	deleteCandidate,
+} from "../controllers/candidate.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+/* PUBLIC */
+router.post("/", createCandidate);
+
+router.get("/getAll", jwtAuthMiddleware, getCandidates);
+router.get("/:id", jwtAuthMiddleware, getCandidate);
+router.get("/career/:careerId", jwtAuthMiddleware, getCandidatesByCareer);
+
+router.patch("/:id", jwtAuthMiddleware, updateCandidate);
+router.delete("/:id", jwtAuthMiddleware, deleteCandidate);
+
+export default router;

backend/src/routes/career.routes.js

@@ -0,0 +1,19 @@
+import express from "express";
+import {
+	getAllCareers,
+	createCareer,
+	updateCareer,
+	deleteCareer,
+} from "../controllers/career.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.get("/getAll", getAllCareers);
+
+router.post("/", jwtAuthMiddleware, createCareer);
+router.patch("/:id", jwtAuthMiddleware, updateCareer);
+router.delete("/:id", jwtAuthMiddleware, deleteCareer);
+
+export default router;

backend/src/routes/department.routes.js

@@ -1,7 +1,10 @@
 import express from "express";
 import {
 	getAllDepartments,
+	getDepartmentByName,
 	createDepartment,
+	updateDepartment,
+	deleteDepartment,
 } from "../controllers/department.controller.js";
 import jwtAuthMiddleware from "../middleware/auth.js";
 
@@ -9,8 +12,11 @@ const router = express.Router();
 
 // Public
 router.get("/getAll", getAllDepartments);
+router.get("/search", getDepartmentByName);
 
 // Protected
 router.post("/", jwtAuthMiddleware, createDepartment);
+router.put("/:departmentId", jwtAuthMiddleware, updateDepartment);
+router.delete("/:departmentId", jwtAuthMiddleware, deleteDepartment);
 
 export default router;

backend/src/routes/doctor.routes.js

@@ -0,0 +1,27 @@
+import express from "express";
+import {
+	getAllDoctors,
+	createDoctor,
+	updateDoctor,
+	deleteDoctor,
+	getDoctorTimings,
+	getDoctorTimingById,
+	getDoctorByDoctorId,
+	getDoctorsByDepartmentId,
+} from "../controllers/doctor.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.get("/getAll", getAllDoctors);
+router.get("/search", getDoctorsByDepartmentId);
+router.get("/getTimings", getDoctorTimings);
+router.get("/getTimings/:doctorId", getDoctorTimingById);
+router.get("/:doctorId", getDoctorByDoctorId);
+
+router.post("/", jwtAuthMiddleware, createDoctor);
+router.patch("/:doctorId", jwtAuthMiddleware, updateDoctor);
+router.delete("/:doctorId", jwtAuthMiddleware, deleteDoctor);
+
+export default router;

backend/src/routes/emailConfig.routes.js

@@ -0,0 +1,19 @@
+import express from "express";
+import {
+	getEmailConfigs,
+	createEmailConfig,
+	updateEmailConfig,
+	deleteEmailConfig,
+} from "../controllers/emailConfig.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.get("/getAll", getEmailConfigs);
+
+router.post("/", jwtAuthMiddleware, createEmailConfig);
+router.patch("/:id", jwtAuthMiddleware, updateEmailConfig);
+router.delete("/:id", jwtAuthMiddleware, deleteEmailConfig);
+
+export default router;

backend/src/routes/importRoutes.js

@@ -0,0 +1,9 @@
+import express from "express";
+import { bulkImportExcelData } from "../controllers/importController.js";
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.post("/bulk", jwtAuthMiddleware, bulkImportExcelData);
+
+export default router;

backend/src/routes/inquiry.routes.js

@@ -0,0 +1,19 @@
+import express from "express";
+import {
+	createInquiry,
+	getInquiries,
+	getInquiry,
+	deleteInquiry,
+} from "../controllers/inquiry.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+router.post("/", createInquiry);
+
+router.get("/getAll", jwtAuthMiddleware, getInquiries);
+router.get("/:id", jwtAuthMiddleware, getInquiry);
+router.delete("/:id", jwtAuthMiddleware, deleteInquiry);
+
+export default router;

backend/src/routes/newsMedia.routes.js

@@ -0,0 +1,23 @@
+import express from "express";
+import {
+	createNews,
+	getAllNews,
+	getNewsById,
+	updateNews,
+	deleteNews,
+} from "../controllers/newsMedia.controller.js";
+
+import jwtAuthMiddleware from "../middleware/auth.js";
+
+const router = express.Router();
+
+// PUBLIC ROUTES
+router.get("/getAll", getAllNews);
+router.get("/:id", getNewsById);
+
+// PROTECTED ROUTES
+router.post("/", jwtAuthMiddleware, createNews);
+router.patch("/:id", jwtAuthMiddleware, updateNews);
+router.delete("/:id", jwtAuthMiddleware, deleteNews);
+
+export default router;

backend/src/routes/upload.routes.js

@@ -1,15 +1,35 @@
 import express from "express";
-import {upload} from "../controllers/upload.controller.js";
+import * as Bytescale from "@bytescale/sdk";
+import multer from "multer";
 
 const router = express.Router();
 
-router.post("/image", upload.single("image"), (req, res) => {
-	res.json({
-		success: 1,
-		file: {
-			url: `http://localhost:3000/uploads/blog/${req.file.filename}`,
+const uploadManager = new Bytescale.UploadManager({
+	apiKey: process.env.BYTESCALE_SECRET_API_KEY,
+});
+
+const storage = multer.memoryStorage();
+const upload = multer({storage});
+
+router.post("/", upload.single("file"), async (req, res) => {
+	try {
+		const file = req.file;
+		const {folderPath} = req.body;
+
+		const result = await uploadManager.upload({
+			data: file.buffer,
+			name: file.originalname,
+			mime: file.mimetype,
+			path: {
+				folderPath: folderPath || "/general",
 			},
 		});
+
+		res.json({fileUrl: result.fileUrl});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({error: "Upload failed"});
+	}
 });
 
 export default router;

backend/src/utils/createUser.js

@@ -0,0 +1,47 @@
+import prisma from "../prisma/client.js";
+import { hashPassword } from "./password.js";
+async function main() {
+	const username = process.argv[2];
+	const password = process.argv[3];
+	const role = process.argv[4] || "admin";
+
+	if (!username || !password) {
+		console.log(
+			"Usage: node scripts/createUser.js <username> <password> [role]",
+		);
+		process.exit(1);
+	}
+
+	const existingUser = await prisma.user.findUnique({
+		where: { username },
+	});
+
+	if (existingUser) {
+		console.log("User already exists");
+		process.exit(1);
+	}
+
+	const hashedPassword = await hashPassword(password);
+
+	const user = await prisma.user.create({
+		data: {
+			username,
+			password: hashedPassword,
+			role,
+		},
+	});
+
+	console.log("User created:", {
+		id: user.id,
+		username: user.username,
+		role: user.role,
+	});
+}
+
+main()
+	.catch((e) => {
+		console.error(e);
+	})
+	.finally(async () => {
+		await prisma.$disconnect();
+	});

backend/src/utils/getEmailByTypes.js

@@ -0,0 +1,17 @@
+import prisma from "../prisma/client.js";
+
+export const getEmailsByType = async (type) => {
+	try {
+		const emails = await prisma.emailConfig.findMany({
+			where: {
+				type,
+				isActive: true,
+			},
+		});
+
+		return emails.map((e) => e.email).join(",");
+	} catch (error) {
+		console.error("Fetch email config error:", error);
+		return "";
+	}
+};

backend/src/utils/sendEmail.js

@@ -0,0 +1,18 @@
+import postmark from "postmark";
+
+const client = new postmark.ServerClient(process.env.POSTMARK_API_KEY);
+
+export const sendEmail = async ({to, subject, html, text}) => {
+	try {
+		await client.sendEmail({
+			From: process.env.EMAIL_FROM,
+			To: to,
+			Subject: subject,
+			HtmlBody: html,
+			TextBody: text || "",
+			MessageStream: "outbound",
+		});
+	} catch (error) {
+		console.error("Email send error:", error);
+	}
+};

docker-compose.dev.yml

@@ -0,0 +1,45 @@
+version: "3.8"
+
+services:
+ backend:
+  build:
+   context: .
+   dockerfile: docker/dev/Dockerfile.main
+  ports:
+   - "127.0.0.1:5008:5008"
+  env_file:
+   - ./backend/.env
+  depends_on:
+   db:
+    condition: service_healthy
+  restart: unless-stopped
+
+ frontend:
+  build:
+   context: .
+   dockerfile: docker/dev/Dockerfile.frontend
+  ports:
+   - "127.0.0.1:3008:3000"
+  env_file:
+   - ./frontend/.env
+  restart: unless-stopped
+
+ db:
+  image: postgres:16-alpine
+  environment:
+   - POSTGRES_USER=${POSTGRES_USER}
+   - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
+   - POSTGRES_DB=${POSTGRES_DB}
+  volumes:
+   - postgres_data:/var/lib/postgresql/data
+  healthcheck:
+   test: ["CMD-SHELL", "pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB"]
+   interval: 5s
+   timeout: 5s
+   retries: 5
+  restart: unless-stopped
+
+volumes:
+ postgres_data:
+  external: true
+  name: gg-backend_postgres_data

docker-compose.prod.yml

@@ -0,0 +1,41 @@
+services:
+ backend:
+  build:
+   context: .
+   dockerfile: docker/dev/Dockerfile.main
+  ports:
+   - "127.0.0.1:5008:5008"
+  env_file:
+   - ./backend/.env
+  depends_on:
+   db:
+    condition: service_healthy
+  restart: always
+
+ frontend:
+  build:
+   context: .
+   dockerfile: docker/dev/Dockerfile.frontend
+  ports:
+   - "127.0.0.1:3008:3000"
+  env_file:
+   - ./frontend/.env
+  restart: always
+
+ db:
+  image: postgres:16-alpine
+  environment:
+   - POSTGRES_USER=${POSTGRES_USER}
+   - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
+   - POSTGRES_DB=${POSTGRES_DB}
+  volumes:
+   - postgres_data:/var/lib/postgresql/data
+  healthcheck:
+   test: ["CMD-SHELL", "pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB"]
+   interval: 5s
+   timeout: 5s
+   retries: 5
+  restart: always
+
+volumes:
+ postgres_data:

docker/dev/Dockerfile.frontend

@@ -0,0 +1,19 @@
+ARG NODE_VERSION=24.15.0
+FROM node:${NODE_VERSION}-alpine
+
+WORKDIR /usr/src/app
+
+COPY ./frontend/package*.json ./
+RUN npm ci
+
+COPY ./frontend .
+
+# Build the app
+RUN npm run build
+
+RUN npm install -g serve
+
+EXPOSE 3000
+
+# Serve built app
+CMD ["serve", "-s", "dist"]

docker/dev/Dockerfile.main

@@ -0,0 +1,24 @@
+ARG NODE_VERSION=24.15.0
+FROM node:${NODE_VERSION}-alpine
+
+WORKDIR /usr/src/app
+
+# Use cache mounts for faster installs
+RUN --mount=type=bind,source=backend/package.json,target=package.json \
+    --mount=type=bind,source=backend/package-lock.json,target=package-lock.json \
+    --mount=type=cache,target=/root/.npm \
+    npm ci
+
+# Copy the backend source
+COPY ./backend .
+
+# Copy and setup entrypoint
+COPY ./docker/entrypoint.sh /usr/local/bin/entrypoint.sh
+RUN chmod +x /usr/local/bin/entrypoint.sh
+
+EXPOSE 5008
+
+ENTRYPOINT [ "entrypoint.sh" ]
+
+# This '$@' will be replaced by the CMD
+CMD ["npm", "start"]

docker/entrypoint.sh

@@ -0,0 +1,14 @@
+#!/bin/sh
+set -e  # Exit immediately if a command exits with a non-zero status
+
+echo "Generating Prisma Client..."
+npx prisma generate
+
+# echo "Running migrate..."
+# npx prisma migrate deploy
+echo "Running PUSH..."
+npx prisma db push
+
+echo "Executing command: $@"
+exec "$@"
+

frontend/.gitignore

@@ -22,3 +22,8 @@ dist-ssr
 *.njsproj
 *.sln
 *.sw?
+
+#env files
+.env*
+.env.*.local
+

frontend/README.md

@@ -1,73 +1,47 @@
-# React + TypeScript + Vite
+**GG-Dashboard**
 
-This template provides a minimal setup to get React working in Vite with HMR and some ESLint rules.
+## Tech Stack
 
-Currently, two official plugins are available:
+Framework: React 19
+Build Tool: Vite + TypeScript
+Styling: Tailwind CSS 4 + shadcn/ui
+Rich Text: Editor.js
+State/Fetch: Axios + React Hooks
+Export: XLSX + File-saver
 
-- [@vitejs/plugin-react](https://github.com/vitejs/vite-plugin-react/blob/main/packages/plugin-react) uses [Babel](https://babeljs.io/) (or [oxc](https://oxc.rs) when used in [rolldown-vite](https://vite.dev/guide/rolldown)) for Fast Refresh
-- [@vitejs/plugin-react-swc](https://github.com/vitejs/vite-plugin-react/blob/main/packages/plugin-react-swc) uses [SWC](https://swc.rs/) for Fast Refresh
+## Project Structure
 
-## React Compiler
+frontend/
+├── src/
+│ ├── api/  
+│ ├── assets/  
+│ ├── components/  
+│ ├── context/  
+│ ├── lib/  
+│ ├── layout/  
+│ ├── pages/  
+│ ├── services/  
+│ ├── utils/  
+│ └── App.tsx  
+├── .env  
+├── index.html
+└── package.json
 
-The React Compiler is not enabled on this template because of its impact on dev & build performances. To add it, see [this documentation](https://react.dev/learn/react-compiler/installation).
+## Installation & Setup
 
-## Expanding the ESLint configuration
+**1. Prerequisites**
+Node.js (v20+)
 
-If you are developing a production application, we recommend updating the configuration to enable type-aware lint rules:
+**2. Environment Variables**
+VITE_API_URL="http://localhost:5008/api"
 
-```js
-export default defineConfig([
-  globalIgnores(['dist']),
-  {
-    files: ['**/*.{ts,tsx}'],
-    extends: [
-      // Other configs...
+**3. Install Dependencies**
+npm install
 
-      // Remove tseslint.configs.recommended and replace with this
-      tseslint.configs.recommendedTypeChecked,
-      // Alternatively, use this for stricter rules
-      tseslint.configs.strictTypeChecked,
-      // Optionally, add this for stylistic rules
-      tseslint.configs.stylisticTypeChecked,
+**4. Development**
+npm run dev
 
-      // Other configs...
-    ],
-    languageOptions: {
-      parserOptions: {
-        project: ['./tsconfig.node.json', './tsconfig.app.json'],
-        tsconfigRootDir: import.meta.dirname,
-      },
-      // other options...
-    },
-  },
-])
-```
+## Scripts
 
-You can also install [eslint-plugin-react-x](https://github.com/Rel1cx/eslint-react/tree/main/packages/plugins/eslint-plugin-react-x) and [eslint-plugin-react-dom](https://github.com/Rel1cx/eslint-react/tree/main/packages/plugins/eslint-plugin-react-dom) for React-specific lint rules:
-
-```js
-// eslint.config.js
-import reactX from 'eslint-plugin-react-x'
-import reactDom from 'eslint-plugin-react-dom'
-
-export default defineConfig([
-  globalIgnores(['dist']),
-  {
-    files: ['**/*.{ts,tsx}'],
-    extends: [
-      // Other configs...
-      // Enable lint rules for React
-      reactX.configs['recommended-typescript'],
-      // Enable lint rules for React DOM
-      reactDom.configs.recommended,
-    ],
-    languageOptions: {
-      parserOptions: {
-        project: ['./tsconfig.node.json', './tsconfig.app.json'],
-        tsconfigRootDir: import.meta.dirname,
-      },
-      // other options...
-    },
-  },
-])
-```
+npm run dev: Starts the Vite development server with Hot Module Replacement.
+npm run build: Compiles TypeScript and builds the production-ready assets.

frontend/index.html

@@ -2,9 +2,9 @@
 <html lang="en">
 	<head>
 		<meta charset="UTF-8" />
-    <link rel="icon" type="image/svg+xml" href="/vite.svg" />
+		<link rel="icon" type="image/svg+xml" href="/favicon.ico" />
 		<meta name="viewport" content="width=device-width, initial-scale=1.0" />
-    <title>frontend</title>
+		<title>GG Admin Dashboard</title>
 	</head>
 	<body>
 		<div id="root"></div>

frontend/package.json

@@ -10,10 +10,22 @@
     "preview": "vite preview"
   },
   "dependencies": {
+    "@editorjs/code": "^2.9.4",
+    "@editorjs/delimiter": "^1.4.2",
+    "@editorjs/editorjs": "^2.31.5",
+    "@editorjs/embed": "^2.8.0",
+    "@editorjs/header": "^2.8.8",
+    "@editorjs/image": "^2.10.3",
+    "@editorjs/list": "^2.0.9",
+    "@editorjs/quote": "^2.7.6",
+    "@editorjs/table": "^2.4.5",
     "@fontsource-variable/geist": "^5.2.8",
+    "@tailwindcss/postcss": "^4.2.1",
     "axios": "^1.13.6",
     "class-variance-authority": "^0.7.1",
     "clsx": "^2.1.1",
+    "cmdk": "^1.1.1",
+    "file-saver": "^2.0.5",
     "lucide-react": "^0.577.0",
     "radix-ui": "^1.4.3",
     "react": "^19.2.0",
@@ -21,21 +33,24 @@
     "react-router-dom": "^7.13.1",
     "shadcn": "^4.0.5",
     "tailwind-merge": "^3.5.0",
-    "tw-animate-css": "^1.4.0"
+    "tailwindcss": "^4.2.1",
+    "tailwindcss-animate": "^1.0.7",
+    "tw-animate-css": "^1.4.0",
+    "xlsx": "^0.18.5"
   },
   "devDependencies": {
     "@eslint/js": "^9.39.1",
+    "@types/estree": "^1.0.8",
+    "@types/json-schema": "^7.0.15",
     "@types/node": "^24.12.0",
     "@types/react": "^19.2.7",
     "@types/react-dom": "^19.2.3",
     "@vitejs/plugin-react": "^5.1.4",
-    "autoprefixer": "^10.4.27",
     "eslint": "^9.39.1",
     "eslint-plugin-react-hooks": "^7.0.1",
     "eslint-plugin-react-refresh": "^0.4.24",
     "globals": "^16.5.0",
     "postcss": "^8.5.8",
-    "tailwindcss": "^3.4.19",
     "typescript": "~5.9.3",
     "typescript-eslint": "^8.48.0",
     "vite": "^7.3.1"

frontend/postcss.config.js

@@ -1,6 +1,5 @@
 export default {
 	plugins: {
-    tailwindcss: {},
-    autoprefixer: {},
+		"@tailwindcss/postcss": {},
 	},
-}
+};

frontend/public/vite.svg

@@ -1 +0,0 @@
-<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" aria-hidden="true" role="img" class="iconify iconify--logos" width="31.88" height="32" preserveAspectRatio="xMidYMid meet" viewBox="0 0 256 257"><defs><linearGradient id="IconifyId1813088fe1fbc01fb466" x1="-.828%" x2="57.636%" y1="7.652%" y2="78.411%"><stop offset="0%" stop-color="#41D1FF"></stop><stop offset="100%" stop-color="#BD34FE"></stop></linearGradient><linearGradient id="IconifyId1813088fe1fbc01fb467" x1="43.376%" x2="50.316%" y1="2.242%" y2="89.03%"><stop offset="0%" stop-color="#FFEA83"></stop><stop offset="8.333%" stop-color="#FFDD35"></stop><stop offset="100%" stop-color="#FFA800"></stop></linearGradient></defs><path fill="url(#IconifyId1813088fe1fbc01fb466)" d="M255.153 37.938L134.897 252.976c-2.483 4.44-8.862 4.466-11.382.048L.875 37.958c-2.746-4.814 1.371-10.646 6.827-9.67l120.385 21.517a6.537 6.537 0 0 0 2.322-.004l117.867-21.483c5.438-.991 9.574 4.796 6.877 9.62Z"></path><path fill="url(#IconifyId1813088fe1fbc01fb467)" d="M185.432.063L96.44 17.501a3.268 3.268 0 0 0-2.634 3.014l-5.474 92.456a3.268 3.268 0 0 0 3.997 3.378l24.777-5.718c2.318-.535 4.413 1.507 3.936 3.838l-7.361 36.047c-.495 2.426 1.782 4.5 4.151 3.78l15.304-4.649c2.372-.72 4.652 1.36 4.15 3.788l-11.698 56.621c-.732 3.542 3.979 5.473 5.943 2.437l1.313-2.028l72.516-144.72c1.215-2.423-.88-5.186-3.54-4.672l-25.505 4.922c-2.396.462-4.435-1.77-3.759-4.114l16.646-57.705c.677-2.35-1.37-4.583-3.769-4.113Z"></path></svg>

frontend/src/App.tsx

@@ -1,45 +1,59 @@
-import {BrowserRouter, Routes, Route} from "react-router-dom";
+import { BrowserRouter, Routes, Route, Navigate } from "react-router-dom";
 
 import Login from "@/pages/Login";
-import Dashboard from "@/pages/Dashboard";
-import Blog from "@/pages/Blog";
-import Department from "@/pages/Department";
 
-import ProtectedRoute from "./components/ProtectedRoutes/ProtectedRoutes";
+import DashboardLayout from "./layouts/DashboardLayout";
+
+// import ProtectedRoute from "./components/ProtectedRoutes/ProtectedRoutes";
+
+import ProtectedRoute from "./auth/ProtectedRoute";
+import PublicRoute from "./auth/PublicRoute";
+import { AuthProvider } from "./context/AuthContext";
+import Department from "./pages/Department";
+import Doctor from "./pages/Doctor";
+import Blog from "./pages/Blog";
+import BlogEditorPage from "./pages/BlogEditor";
+import Appointment from "./pages/Appointment";
+import EmailPage from "./pages/email";
+import CareerPage from "./pages/Career";
+import CandidatePage from "./pages/candidates";
+import InquiryPage from "./pages/inquiry";
+import AcademicsPage from "./pages/Academics";
+import NewsPage from "./pages/newsMedia";
+import BlogDetail from "./pages/BlogDetails";
+import ImportData from "./pages/ImportData";
 
 export default function App() {
 	return (
 		<BrowserRouter>
+			<AuthProvider>
 				<Routes>
+					<Route element={<PublicRoute />}>
 						<Route path="/" element={<Login />} />
+					</Route>
 
-				<Route
-					path="/dashboard"
-					element={
-						<ProtectedRoute>
-							<Dashboard />
-						</ProtectedRoute>
-					}
-				/>
+					<Route element={<ProtectedRoute />}>
+						<Route element={<DashboardLayout />}>
+							<Route path="/department" element={<Department />} />
+							<Route path="/doctor" element={<Doctor />} />
+							<Route path="/blog" element={<Blog />} />
+							<Route path="/blog/:id" element={<BlogDetail />} />
+							<Route path="/blog/create" element={<BlogEditorPage />} />
+							<Route path="/blog/edit/:id" element={<BlogEditorPage />} />
+							<Route path="/appointment" element={<Appointment />} />
+							<Route path="/email" element={<EmailPage />} />
+							<Route path="/career" element={<CareerPage />} />
+							<Route path="/candidate" element={<CandidatePage />} />
+							<Route path="/inquiry" element={<InquiryPage />} />
+							<Route path="/academics" element={<AcademicsPage />} />
+							<Route path="/news" element={<NewsPage />} />
+							<Route path="/import" element={<ImportData />} />
+						</Route>
+					</Route>
 
-				<Route
-					path="/blog"
-					element={
-						<ProtectedRoute>
-							<Blog />
-						</ProtectedRoute>
-					}
-				/>
-
-				<Route
-					path="/department"
-					element={
-						<ProtectedRoute>
-							<Department />
-						</ProtectedRoute>
-					}
-				/>
+					<Route path="*" element={<Navigate to="/department" replace />} />
 				</Routes>
+			</AuthProvider>
 		</BrowserRouter>
 	);
 }

frontend/src/api/academics.ts

@@ -0,0 +1,11 @@
+import apiClient from "@/api/client";
+
+export const getAcademicsApi = async () => {
+	const res = await apiClient.get("/academics/getAll");
+	return res.data;
+};
+
+export const deleteAcademicsApi = async (id: number) => {
+	const res = await apiClient.delete(`/academics/${id}`);
+	return res.data;
+};

frontend/src/api/appointment.ts

@@ -0,0 +1,22 @@
+import apiClient from "@/api/client";
+
+export const getAppointmentsApi = async (
+	page = 1,
+	limit = 10,
+	date = "",
+	search = "",
+) => {
+	const params = new URLSearchParams({
+		page: String(page),
+		limit: String(limit),
+		...(date && { date }),
+		...(search && { search }),
+	});
+	const res = await apiClient.get(`/appointments/getall?${params}`);
+	return res.data;
+};
+
+export const deleteAppointmentApi = async (id: number) => {
+	const res = await apiClient.delete(`/appointments/${id}`);
+	return res.data;
+};

frontend/src/api/auth.ts

@@ -0,0 +1,12 @@
+import apiClient from "./client";
+
+export const loginApi = async (
+	username: string,
+	password: string,
+): Promise<any> => {
+	const response = await apiClient.post("/auth/login/", {
+		username,
+		password,
+	});
+	return response.data;
+};

frontend/src/api/blog.ts

@@ -0,0 +1,48 @@
+import apiClient from "@/api/client";
+
+export interface Blog {
+	id?: number;
+	title: string;
+	writer: string;
+	image?: string;
+	content: any;
+}
+
+export const getAllBlogsApi = async () => {
+	const res = await apiClient.get("/blogs");
+	return res.data;
+};
+
+export const getBlogByIdApi = async (id: number) => {
+	const res = await apiClient.get(`/blogs/admin/${id}`);
+	return res.data;
+};
+
+export const createBlogApi = async (data: Blog) => {
+	const res = await apiClient.post("/blogs", data);
+	return res.data;
+};
+
+export const updateBlogApi = async (id: number, data: Blog) => {
+	const res = await apiClient.put(`/blogs/${id}`, data);
+	return res.data;
+};
+
+export const deleteBlogApi = async (id: number) => {
+	const res = await apiClient.delete(`/blogs/${id}`);
+	return res.data;
+};
+
+/* IMAGE UPLOAD */
+export const uploadImageApi = async (file: File) => {
+	const formData = new FormData();
+	formData.append("image", file);
+
+	const res = await apiClient.post("/upload/image", formData, {
+		headers: {
+			"Content-Type": "multipart/form-data",
+		},
+	});
+
+	return res.data;
+};

frontend/src/api/candidates.ts

@@ -0,0 +1,11 @@
+import apiClient from "@/api/client";
+
+export const getCandidatesApi = async () => {
+	const res = await apiClient.get("/candidates/getAll");
+	return res.data;
+};
+
+export const deleteCandidateApi = async (id: number) => {
+	const res = await apiClient.delete(`/candidates/${id}`);
+	return res.data;
+};

frontend/src/api/career.ts

@@ -0,0 +1,11 @@
+import apiClient from "@/api/client";
+
+export const getCareersApi = async () => {
+	const res = await apiClient.get("/careers/getAll");
+	return res.data;
+};
+
+export const deleteCareerApi = async (id: number) => {
+	const res = await apiClient.delete(`/careers/${id}`);
+	return res.data;
+};

frontend/src/api/client.ts

@@ -0,0 +1,48 @@
+import axios from "axios";
+import type {InternalAxiosRequestConfig} from "axios";
+
+const baseURL: string = import.meta.env.VITE_API_URL;
+
+const apiClient = axios.create({
+	baseURL: baseURL,
+	headers: {
+		"Content-Type": "application/json",
+	},
+});
+
+export const setAxiosAuthToken = (token: string | null): void => {
+	if (token) {
+		apiClient.defaults.headers.common["Authorization"] = `Bearer ${token}`;
+	} else {
+		delete apiClient.defaults.headers.common["Authorization"];
+	}
+};
+
+apiClient.interceptors.request.use(
+	(config: InternalAxiosRequestConfig) => {
+		const token = localStorage.getItem("token");
+
+		if (token && config.headers) {
+			config.headers["Authorization"] = `Bearer ${token}`;
+		}
+
+		return config;
+	},
+	(error: any) => Promise.reject(error),
+);
+
+apiClient.interceptors.response.use(
+	(response) => response,
+	async (error) => {
+		if (error.response?.status === 401) {
+			console.error("Unauthorized - token missing or invalid");
+
+			localStorage.removeItem("token");
+			window.location.href = "/login";
+		}
+
+		return Promise.reject(error);
+	},
+);
+
+export default apiClient;

frontend/src/api/department.ts

@@ -0,0 +1,50 @@
+import apiClient from "@/api/client";
+
+export interface Department {
+	departmentId: string;
+	name: string;
+	image?: string;
+	para1: string;
+	para2: string;
+	para3: string;
+	facilities: string;
+	services: string;
+}
+
+export const getDepartmentsApi = async () => {
+	const res = await apiClient.get("/departments/getAll");
+	return res.data;
+};
+
+export const createDepartmentApi = async (data: {
+	departmentId: string;
+	name: string;
+	para1?: string;
+	para2?: string;
+	para3?: string;
+	facilities?: string;
+	services?: string;
+}) => {
+	const res = await apiClient.post("/departments", data);
+	return res.data;
+};
+
+export const updateDepartmentApi = async (
+	departmentId: string,
+	data: {
+		name?: string;
+		para1?: string;
+		para2?: string;
+		para3?: string;
+		facilities?: string;
+		services?: string;
+	},
+) => {
+	const res = await apiClient.put(`/departments/${departmentId}`, data);
+	return res.data;
+};
+
+export const deleteDepartmentApi = async (departmentId: string) => {
+	const res = await apiClient.delete(`/departments/${departmentId}`);
+	return res.data;
+};

frontend/src/api/doctor.ts

@@ -0,0 +1,57 @@
+import apiClient from "@/api/client";
+
+export interface Doctor {
+	doctorId: string;
+	name: string;
+	image?: string;
+	designation?: string;
+	workingStatus?: string;
+	qualification?: string;
+
+	departments: {
+		departmentId: string;
+		timing?: {
+			monday?: string;
+			tuesday?: string;
+			wednesday?: string;
+			thursday?: string;
+			friday?: string;
+			saturday?: string;
+			sunday?: string;
+			additional?: string;
+		};
+	}[];
+}
+
+export const getDoctorsApi = async () => {
+	const res = await apiClient.get("/doctors/getAll");
+	return res.data;
+};
+
+export const getDoctorByIdApi = async (doctorId: string) => {
+	const res = await apiClient.get(`/doctors/${doctorId}`);
+	return res.data;
+};
+
+export const createDoctorApi = async (data: Doctor) => {
+	const res = await apiClient.post("/doctors", data);
+	return res.data;
+};
+
+export const updateDoctorApi = async (
+	doctorId: string,
+	data: Partial<Doctor>,
+) => {
+	const res = await apiClient.patch(`/doctors/${doctorId}`, data);
+	return res.data;
+};
+
+export const deleteDoctorApi = async (doctorId: string) => {
+	const res = await apiClient.delete(`/doctors/${doctorId}`);
+	return res.data;
+};
+
+export const getDoctorTimingApi = async (doctorId: string) => {
+	const res = await apiClient.get(`/doctors/getTimings/${doctorId}`);
+	return res.data;
+};

frontend/src/api/email.ts

@@ -0,0 +1,36 @@
+import apiClient from "@/api/client";
+
+export interface EmailConfig {
+	id?: number;
+	name: string;
+	email: string;
+	type: string;
+	isActive?: boolean;
+}
+
+// GET ALL
+export const getEmailConfigsApi = async () => {
+	const res = await apiClient.get("/email/getAll");
+	return res.data;
+};
+
+// CREATE
+export const createEmailConfigApi = async (data: EmailConfig) => {
+	const res = await apiClient.post("/email", data);
+	return res.data;
+};
+
+// UPDATE
+export const updateEmailConfigApi = async (
+	id: number,
+	data: Partial<EmailConfig>,
+) => {
+	const res = await apiClient.patch(`/email/${id}`, data);
+	return res.data;
+};
+
+// DELETE
+export const deleteEmailConfigApi = async (id: number) => {
+	const res = await apiClient.delete(`/email/${id}`);
+	return res.data;
+};

frontend/src/api/inquiry.ts

@@ -0,0 +1,11 @@
+import apiClient from "@/api/client";
+
+export const getInquiriesApi = async () => {
+	const res = await apiClient.get("/inquiry/getAll");
+	return res.data;
+};
+
+export const deleteInquiryApi = async (id: number) => {
+	const res = await apiClient.delete(`/inquiry/${id}`);
+	return res.data;
+};

frontend/src/api/newsMedia.ts

@@ -0,0 +1,23 @@
+import apiClient from "@/api/client";
+
+export const getNewsApi = async (page = 1, limit = 10, search = "") => {
+	const res = await apiClient.get(
+		`/newsMedia/getAll?page=${page}&limit=${limit}&search=${search}`,
+	);
+	return res.data;
+};
+
+export const createNewsApi = async (data: any) => {
+	const res = await apiClient.post("/newsMedia", data);
+	return res.data;
+};
+
+export const updateNewsApi = async (id: number, data: any) => {
+	const res = await apiClient.patch(`/newsMedia/${id}`, data);
+	return res.data;
+};
+
+export const deleteNewsApi = async (id: number) => {
+	const res = await apiClient.delete(`/newsMedia/${id}`);
+	return res.data;
+};

frontend/src/auth/ProtectedRoute.tsx

@@ -0,0 +1,7 @@
+import {Navigate, Outlet} from "react-router-dom";
+import {useAuth} from "@/context/AuthContext";
+
+export default function ProtectedRoute() {
+	const {token} = useAuth();
+	return token ? <Outlet /> : <Navigate to="/" replace />;
+}

frontend/src/auth/PublicRoute.tsx

@@ -0,0 +1,7 @@
+import {Navigate, Outlet} from "react-router-dom";
+import {useAuth} from "@/context/AuthContext";
+
+export default function PublicRoute() {
+	const {token} = useAuth();
+	return token ? <Navigate to="/dashboard" replace /> : <Outlet />;
+}

frontend/src/components/BytescaleUploader/BytescaleUploader.tsx

@@ -0,0 +1,122 @@
+import {useState, useRef} from "react";
+import {Button} from "@/components/ui/button";
+import {User, X, Loader2} from "lucide-react";
+import axios from "axios";
+
+interface BytescaleUploaderProps {
+	value: string;
+	onChange: (url: string) => void;
+	folderPath: "/doctors" | "/departments" | "/news" | "/blog";
+}
+
+export function BytescaleUploader({
+	value,
+	onChange,
+	folderPath,
+}: BytescaleUploaderProps) {
+	const baseURL = import.meta.env.VITE_API_URL;
+	const [isUploading, setIsUploading] = useState(false);
+	const fileInputRef = useRef<HTMLInputElement>(null);
+
+	const onFileSelected = async (event: React.ChangeEvent<HTMLInputElement>) => {
+		const file = event.target.files?.[0];
+		if (!file) return;
+
+		if (file.size > 5 * 1024 * 1024) {
+			alert("File is too large (Max 5MB)");
+			return;
+		}
+
+		setIsUploading(true);
+
+		const formData = new FormData();
+		formData.append("file", file);
+		formData.append("folderPath", folderPath);
+
+		try {
+			const response = await axios.post(`${baseURL}/upload`, formData, {
+				headers: {
+					"Content-Type": "multipart/form-data",
+				},
+			});
+
+			const {fileUrl} = response.data;
+			onChange(fileUrl);
+		} catch (e: any) {
+			console.error("Upload Error:", e);
+			const errorMessage =
+				e.response?.data?.error || e.message || "Upload failed";
+			alert(`Upload Error: ${errorMessage}`);
+		} finally {
+			setIsUploading(false);
+			if (fileInputRef.current) fileInputRef.current.value = "";
+		}
+	};
+
+	return (
+		<div className="flex flex-col gap-2 p-3 border rounded-md bg-muted/5">
+			<div className="flex items-center gap-4">
+				<div className="relative">
+					{value ? (
+						<>
+							<img
+								src={value}
+								className="w-16 h-16 rounded-full object-cover border-2 border-primary/20"
+								alt="Preview"
+							/>
+							<button
+								type="button"
+								onClick={() => onChange("")}
+								className="absolute -top-1 -right-1 bg-destructive text-white rounded-full p-0.5 shadow-sm hover:scale-110 transition-transform"
+							>
+								<X className="w-3 h-3" />
+							</button>
+						</>
+					) : (
+						<div className="w-16 h-16 rounded-full bg-muted flex items-center justify-center">
+							{isUploading ? (
+								<Loader2 className="w-8 h-8 animate-spin text-primary" />
+							) : (
+								<User className="w-8 h-8 text-muted-foreground" />
+							)}
+						</div>
+					)}
+				</div>
+
+				<input
+					type="file"
+					ref={fileInputRef}
+					onChange={onFileSelected}
+					accept="image/jpeg,image/png,image/webp"
+					className="hidden"
+				/>
+
+				<Button
+					type="button"
+					variant="outline"
+					size="sm"
+					disabled={isUploading}
+					onClick={() => fileInputRef.current?.click()}
+				>
+					{isUploading ? (
+						<>
+							<Loader2 className="mr-2 h-4 w-4 animate-spin" />
+							Uploading...
+						</>
+					) : value ? (
+						"Change Photo"
+					) : (
+						"Upload Photo"
+					)}
+				</Button>
+			</div>
+
+			{value && (
+				<p className="text-xs text-amber-600 pl-[72px]">
+					⚠️ Make sure to save the changes by clicking the "Save Changes"
+					button.
+				</p>
+			)}
+		</div>
+	);
+}

frontend/src/components/layout/DashboardLayout.tsx

@@ -1,20 +0,0 @@
-import Sidebar from "./Sidebar"
-
-export default function DashboardLayout({children}:{children:React.ReactNode}){
-
-  return(
-
-    <div className="flex">
-
-      <Sidebar/>
-
-      <div className="flex-1 p-6 bg-slate-50 min-h-screen">
-
-        {children}
-
-      </div>
-
-    </div>
-
-  )
-}

frontend/src/components/layout/Header.tsx

@@ -0,0 +1,35 @@
+import {useState, useEffect} from "react";
+import {useAuth} from "@/context/AuthContext";
+import {Button} from "@/components/ui/button";
+import {Switch} from "@/components/ui/switch";
+import {log} from "console";
+
+export default function Header() {
+	const {user, logout} = useAuth();
+	const [darkMode, setDarkMode] = useState<boolean>(false);
+
+	useEffect(() => {
+		if (darkMode) document.documentElement.classList.add("dark");
+		else document.documentElement.classList.remove("dark");
+	}, [darkMode]);
+
+	return (
+		<header className="border-b bg-card">
+			<div className="flex items-center justify-between px-6 h-16">
+				<div>
+					<p className="text-sm text-muted-foreground">Welcome back</p>
+					<p className="font-semibold">{user?.username}</p>
+				</div>
+				<div className="flex items-center gap-4">
+					<div className="flex items-center gap-2">
+						<span className="text-sm">Dark</span>
+						<Switch checked={darkMode} onCheckedChange={setDarkMode} />
+					</div>
+					<Button variant="destructive" onClick={logout}>
+						Logout
+					</Button>
+				</div>
+			</div>
+		</header>
+	);
+}

frontend/src/components/layout/Sidebar.tsx

@@ -1,17 +1,77 @@
-import {Link} from "react-router-dom";
+import { Link, useLocation } from "react-router-dom";
+
+import { Button } from "@/components/ui/button";
+import { Separator } from "@/components/ui/separator";
 
 export default function Sidebar() {
+	const location = useLocation();
+
+	const navItems = [
+		{
+			name: "Department",
+			path: "/department",
+		},
+		{
+			name: "Doctor",
+			path: "/doctor",
+		},
+		{
+			name: "Appointments",
+			path: "/appointment",
+		},
+		{
+			name: "Career",
+			path: "/career",
+		},
+		{
+			name: "Candidates",
+			path: "/candidate",
+		},
+		{
+			name: "Inquiry",
+			path: "/inquiry",
+		},
+		{
+			name: "Academics & Research",
+			path: "/academics",
+		},
+		{
+			name: "News & Media",
+			path: "/news",
+		},
+		{
+			name: "Email",
+			path: "/email",
+		},
+		{
+			name: "Blog",
+			path: "/blog",
+		},
+	];
+
 	return (
-		<div className="w-[220px] h-screen border-r bg-white p-4">
-			<h2 className="text-lg font-semibold mb-6">Admin</h2>
-
-			<div className="space-y-3">
-				<Link to="/dashboard">Dashboard</Link>
-
-				<Link to="/blog">Blog</Link>
-
-				<Link to="/department">Department</Link>
+		<div className="w-64 border-r bg-card">
+			<div className="p-6">
+				<h2 className="text-xl font-bold">GG Dashboard</h2>
 			</div>
+
+			<Separator />
+
+			<nav className="p-4 space-y-2">
+				{navItems.map((item) => {
+					const active = location.pathname === item.path;
+
+					return (
+						<Link key={item.path} to={item.path}>
+							<Button
+								variant={active ? "secondary" : "ghost"}
+								className="w-full justify-start">
+								{item.name}
+							</Button>
+						</Link>
+					);
+				})}
+			</nav>
 		</div>
 	);
 }

frontend/src/components/ui/badge.tsx

@@ -0,0 +1,49 @@
+import * as React from "react"
+import { cva, type VariantProps } from "class-variance-authority"
+import { Slot } from "radix-ui"
+
+import { cn } from "@/lib/utils"
+
+const badgeVariants = cva(
+  "group/badge inline-flex h-5 w-fit shrink-0 items-center justify-center gap-1 overflow-hidden rounded-4xl border border-transparent px-2 py-0.5 text-xs font-medium whitespace-nowrap transition-all focus-visible:border-ring focus-visible:ring-[3px] focus-visible:ring-ring/50 has-data-[icon=inline-end]:pr-1.5 has-data-[icon=inline-start]:pl-1.5 aria-invalid:border-destructive aria-invalid:ring-destructive/20 dark:aria-invalid:ring-destructive/40 [&>svg]:pointer-events-none [&>svg]:size-3!",
+  {
+    variants: {
+      variant: {
+        default: "bg-primary text-primary-foreground [a]:hover:bg-primary/80",
+        secondary:
+          "bg-secondary text-secondary-foreground [a]:hover:bg-secondary/80",
+        destructive:
+          "bg-destructive/10 text-destructive focus-visible:ring-destructive/20 dark:bg-destructive/20 dark:focus-visible:ring-destructive/40 [a]:hover:bg-destructive/20",
+        outline:
+          "border-border text-foreground [a]:hover:bg-muted [a]:hover:text-muted-foreground",
+        ghost:
+          "hover:bg-muted hover:text-muted-foreground dark:hover:bg-muted/50",
+        link: "text-primary underline-offset-4 hover:underline",
+      },
+    },
+    defaultVariants: {
+      variant: "default",
+    },
+  }
+)
+
+function Badge({
+  className,
+  variant = "default",
+  asChild = false,
+  ...props
+}: React.ComponentProps<"span"> &
+  VariantProps<typeof badgeVariants> & { asChild?: boolean }) {
+  const Comp = asChild ? Slot.Root : "span"
+
+  return (
+    <Comp
+      data-slot="badge"
+      data-variant={variant}
+      className={cn(badgeVariants({ variant }), className)}
+      {...props}
+    />
+  )
+}
+
+export { Badge, badgeVariants }

frontend/src/components/ui/command.tsx

@@ -0,0 +1,193 @@
+import * as React from "react"
+import { Command as CommandPrimitive } from "cmdk"
+
+import { cn } from "@/lib/utils"
+import {
+  Dialog,
+  DialogContent,
+  DialogDescription,
+  DialogHeader,
+  DialogTitle,
+} from "@/components/ui/dialog"
+import {
+  InputGroup,
+  InputGroupAddon,
+} from "@/components/ui/input-group"
+import { SearchIcon, CheckIcon } from "lucide-react"
+
+function Command({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive>) {
+  return (
+    <CommandPrimitive
+      data-slot="command"
+      className={cn(
+        "flex size-full flex-col overflow-hidden rounded-xl! bg-popover p-1 text-popover-foreground",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function CommandDialog({
+  title = "Command Palette",
+  description = "Search for a command to run...",
+  children,
+  className,
+  showCloseButton = false,
+  ...props
+}: React.ComponentProps<typeof Dialog> & {
+  title?: string
+  description?: string
+  className?: string
+  showCloseButton?: boolean
+}) {
+  return (
+    <Dialog {...props}>
+      <DialogHeader className="sr-only">
+        <DialogTitle>{title}</DialogTitle>
+        <DialogDescription>{description}</DialogDescription>
+      </DialogHeader>
+      <DialogContent
+        className={cn(
+          "top-1/3 translate-y-0 overflow-hidden rounded-xl! p-0",
+          className
+        )}
+        showCloseButton={showCloseButton}
+      >
+        {children}
+      </DialogContent>
+    </Dialog>
+  )
+}
+
+function CommandInput({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.Input>) {
+  return (
+    <div data-slot="command-input-wrapper" className="p-1 pb-0">
+      <InputGroup className="h-8! rounded-lg! border-input/30 bg-input/30 shadow-none! *:data-[slot=input-group-addon]:pl-2!">
+        <CommandPrimitive.Input
+          data-slot="command-input"
+          className={cn(
+            "w-full text-sm outline-hidden disabled:cursor-not-allowed disabled:opacity-50",
+            className
+          )}
+          {...props}
+        />
+        <InputGroupAddon>
+          <SearchIcon className="size-4 shrink-0 opacity-50" />
+        </InputGroupAddon>
+      </InputGroup>
+    </div>
+  )
+}
+
+function CommandList({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.List>) {
+  return (
+    <CommandPrimitive.List
+      data-slot="command-list"
+      className={cn(
+        "no-scrollbar max-h-72 scroll-py-1 overflow-x-hidden overflow-y-auto outline-none",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function CommandEmpty({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.Empty>) {
+  return (
+    <CommandPrimitive.Empty
+      data-slot="command-empty"
+      className={cn("py-6 text-center text-sm", className)}
+      {...props}
+    />
+  )
+}
+
+function CommandGroup({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.Group>) {
+  return (
+    <CommandPrimitive.Group
+      data-slot="command-group"
+      className={cn(
+        "overflow-hidden p-1 text-foreground **:[[cmdk-group-heading]]:px-2 **:[[cmdk-group-heading]]:py-1.5 **:[[cmdk-group-heading]]:text-xs **:[[cmdk-group-heading]]:font-medium **:[[cmdk-group-heading]]:text-muted-foreground",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function CommandSeparator({
+  className,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.Separator>) {
+  return (
+    <CommandPrimitive.Separator
+      data-slot="command-separator"
+      className={cn("-mx-1 h-px bg-border", className)}
+      {...props}
+    />
+  )
+}
+
+function CommandItem({
+  className,
+  children,
+  ...props
+}: React.ComponentProps<typeof CommandPrimitive.Item>) {
+  return (
+    <CommandPrimitive.Item
+      data-slot="command-item"
+      className={cn(
+        "group/command-item relative flex cursor-default items-center gap-2 rounded-sm px-2 py-1.5 text-sm outline-hidden select-none in-data-[slot=dialog-content]:rounded-lg! data-[disabled=true]:pointer-events-none data-[disabled=true]:opacity-50 data-selected:bg-muted data-selected:text-foreground [&_svg]:pointer-events-none [&_svg]:shrink-0 [&_svg:not([class*='size-'])]:size-4 data-selected:*:[svg]:text-foreground",
+        className
+      )}
+      {...props}
+    >
+      {children}
+      <CheckIcon className="ml-auto opacity-0 group-has-data-[slot=command-shortcut]/command-item:hidden group-data-[checked=true]/command-item:opacity-100" />
+    </CommandPrimitive.Item>
+  )
+}
+
+function CommandShortcut({
+  className,
+  ...props
+}: React.ComponentProps<"span">) {
+  return (
+    <span
+      data-slot="command-shortcut"
+      className={cn(
+        "ml-auto text-xs tracking-widest text-muted-foreground group-data-selected/command-item:text-foreground",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+export {
+  Command,
+  CommandDialog,
+  CommandInput,
+  CommandList,
+  CommandEmpty,
+  CommandGroup,
+  CommandItem,
+  CommandShortcut,
+  CommandSeparator,
+}

frontend/src/components/ui/dialog.tsx

@@ -0,0 +1,163 @@
+import * as React from "react"
+import { Dialog as DialogPrimitive } from "radix-ui"
+
+import { cn } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import { XIcon } from "lucide-react"
+
+function Dialog({
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Root>) {
+  return <DialogPrimitive.Root data-slot="dialog" {...props} />
+}
+
+function DialogTrigger({
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Trigger>) {
+  return <DialogPrimitive.Trigger data-slot="dialog-trigger" {...props} />
+}
+
+function DialogPortal({
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Portal>) {
+  return <DialogPrimitive.Portal data-slot="dialog-portal" {...props} />
+}
+
+function DialogClose({
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Close>) {
+  return <DialogPrimitive.Close data-slot="dialog-close" {...props} />
+}
+
+function DialogOverlay({
+  className,
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Overlay>) {
+  return (
+    <DialogPrimitive.Overlay
+      data-slot="dialog-overlay"
+      className={cn(
+        "fixed inset-0 isolate z-50 bg-black/10 duration-100 supports-backdrop-filter:backdrop-blur-xs data-open:animate-in data-open:fade-in-0 data-closed:animate-out data-closed:fade-out-0",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function DialogContent({
+  className,
+  children,
+  showCloseButton = true,
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Content> & {
+  showCloseButton?: boolean
+}) {
+  return (
+    <DialogPortal>
+      <DialogOverlay />
+      <DialogPrimitive.Content
+        data-slot="dialog-content"
+        className={cn(
+          "fixed top-1/2 left-1/2 z-50 grid w-full max-w-[calc(100%-2rem)] -translate-x-1/2 -translate-y-1/2 gap-4 rounded-xl bg-background p-4 text-sm ring-1 ring-foreground/10 duration-100 outline-none sm:max-w-sm data-open:animate-in data-open:fade-in-0 data-open:zoom-in-95 data-closed:animate-out data-closed:fade-out-0 data-closed:zoom-out-95",
+          className
+        )}
+        {...props}
+      >
+        {children}
+        {showCloseButton && (
+          <DialogPrimitive.Close data-slot="dialog-close" asChild>
+            <Button
+              variant="ghost"
+              className="absolute top-2 right-2"
+              size="icon-sm"
+            >
+              <XIcon
+              />
+              <span className="sr-only">Close</span>
+            </Button>
+          </DialogPrimitive.Close>
+        )}
+      </DialogPrimitive.Content>
+    </DialogPortal>
+  )
+}
+
+function DialogHeader({ className, ...props }: React.ComponentProps<"div">) {
+  return (
+    <div
+      data-slot="dialog-header"
+      className={cn("flex flex-col gap-2", className)}
+      {...props}
+    />
+  )
+}
+
+function DialogFooter({
+  className,
+  showCloseButton = false,
+  children,
+  ...props
+}: React.ComponentProps<"div"> & {
+  showCloseButton?: boolean
+}) {
+  return (
+    <div
+      data-slot="dialog-footer"
+      className={cn(
+        "-mx-4 -mb-4 flex flex-col-reverse gap-2 rounded-b-xl border-t bg-muted/50 p-4 sm:flex-row sm:justify-end",
+        className
+      )}
+      {...props}
+    >
+      {children}
+      {showCloseButton && (
+        <DialogPrimitive.Close asChild>
+          <Button variant="outline">Close</Button>
+        </DialogPrimitive.Close>
+      )}
+    </div>
+  )
+}
+
+function DialogTitle({
+  className,
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Title>) {
+  return (
+    <DialogPrimitive.Title
+      data-slot="dialog-title"
+      className={cn("text-base leading-none font-medium", className)}
+      {...props}
+    />
+  )
+}
+
+function DialogDescription({
+  className,
+  ...props
+}: React.ComponentProps<typeof DialogPrimitive.Description>) {
+  return (
+    <DialogPrimitive.Description
+      data-slot="dialog-description"
+      className={cn(
+        "text-sm text-muted-foreground *:[a]:underline *:[a]:underline-offset-3 *:[a]:hover:text-foreground",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+export {
+  Dialog,
+  DialogClose,
+  DialogContent,
+  DialogDescription,
+  DialogFooter,
+  DialogHeader,
+  DialogOverlay,
+  DialogPortal,
+  DialogTitle,
+  DialogTrigger,
+}

frontend/src/components/ui/input-group.tsx

@@ -0,0 +1,156 @@
+"use client"
+
+import * as React from "react"
+import { cva, type VariantProps } from "class-variance-authority"
+
+import { cn } from "@/lib/utils"
+import { Button } from "@/components/ui/button"
+import { Input } from "@/components/ui/input"
+import { Textarea } from "@/components/ui/textarea"
+
+function InputGroup({ className, ...props }: React.ComponentProps<"div">) {
+  return (
+    <div
+      data-slot="input-group"
+      role="group"
+      className={cn(
+        "group/input-group relative flex h-8 w-full min-w-0 items-center rounded-lg border border-input transition-colors outline-none in-data-[slot=combobox-content]:focus-within:border-inherit in-data-[slot=combobox-content]:focus-within:ring-0 has-disabled:bg-input/50 has-disabled:opacity-50 has-[[data-slot=input-group-control]:focus-visible]:border-ring has-[[data-slot=input-group-control]:focus-visible]:ring-3 has-[[data-slot=input-group-control]:focus-visible]:ring-ring/50 has-[[data-slot][aria-invalid=true]]:border-destructive has-[[data-slot][aria-invalid=true]]:ring-3 has-[[data-slot][aria-invalid=true]]:ring-destructive/20 has-[>[data-align=block-end]]:h-auto has-[>[data-align=block-end]]:flex-col has-[>[data-align=block-start]]:h-auto has-[>[data-align=block-start]]:flex-col has-[>textarea]:h-auto dark:bg-input/30 dark:has-disabled:bg-input/80 dark:has-[[data-slot][aria-invalid=true]]:ring-destructive/40 has-[>[data-align=block-end]]:[&>input]:pt-3 has-[>[data-align=block-start]]:[&>input]:pb-3 has-[>[data-align=inline-end]]:[&>input]:pr-1.5 has-[>[data-align=inline-start]]:[&>input]:pl-1.5",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+const inputGroupAddonVariants = cva(
+  "flex h-auto cursor-text items-center justify-center gap-2 py-1.5 text-sm font-medium text-muted-foreground select-none group-data-[disabled=true]/input-group:opacity-50 [&>kbd]:rounded-[calc(var(--radius)-5px)] [&>svg:not([class*='size-'])]:size-4",
+  {
+    variants: {
+      align: {
+        "inline-start":
+          "order-first pl-2 has-[>button]:ml-[-0.3rem] has-[>kbd]:ml-[-0.15rem]",
+        "inline-end":
+          "order-last pr-2 has-[>button]:mr-[-0.3rem] has-[>kbd]:mr-[-0.15rem]",
+        "block-start":
+          "order-first w-full justify-start px-2.5 pt-2 group-has-[>input]/input-group:pt-2 [.border-b]:pb-2",
+        "block-end":
+          "order-last w-full justify-start px-2.5 pb-2 group-has-[>input]/input-group:pb-2 [.border-t]:pt-2",
+      },
+    },
+    defaultVariants: {
+      align: "inline-start",
+    },
+  }
+)
+
+function InputGroupAddon({
+  className,
+  align = "inline-start",
+  ...props
+}: React.ComponentProps<"div"> & VariantProps<typeof inputGroupAddonVariants>) {
+  return (
+    <div
+      role="group"
+      data-slot="input-group-addon"
+      data-align={align}
+      className={cn(inputGroupAddonVariants({ align }), className)}
+      onClick={(e) => {
+        if ((e.target as HTMLElement).closest("button")) {
+          return
+        }
+        e.currentTarget.parentElement?.querySelector("input")?.focus()
+      }}
+      {...props}
+    />
+  )
+}
+
+const inputGroupButtonVariants = cva(
+  "flex items-center gap-2 text-sm shadow-none",
+  {
+    variants: {
+      size: {
+        xs: "h-6 gap-1 rounded-[calc(var(--radius)-3px)] px-1.5 [&>svg:not([class*='size-'])]:size-3.5",
+        sm: "",
+        "icon-xs":
+          "size-6 rounded-[calc(var(--radius)-3px)] p-0 has-[>svg]:p-0",
+        "icon-sm": "size-8 p-0 has-[>svg]:p-0",
+      },
+    },
+    defaultVariants: {
+      size: "xs",
+    },
+  }
+)
+
+function InputGroupButton({
+  className,
+  type = "button",
+  variant = "ghost",
+  size = "xs",
+  ...props
+}: Omit<React.ComponentProps<typeof Button>, "size"> &
+  VariantProps<typeof inputGroupButtonVariants>) {
+  return (
+    <Button
+      type={type}
+      data-size={size}
+      variant={variant}
+      className={cn(inputGroupButtonVariants({ size }), className)}
+      {...props}
+    />
+  )
+}
+
+function InputGroupText({ className, ...props }: React.ComponentProps<"span">) {
+  return (
+    <span
+      className={cn(
+        "flex items-center gap-2 text-sm text-muted-foreground [&_svg]:pointer-events-none [&_svg:not([class*='size-'])]:size-4",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function InputGroupInput({
+  className,
+  ...props
+}: React.ComponentProps<"input">) {
+  return (
+    <Input
+      data-slot="input-group-control"
+      className={cn(
+        "flex-1 rounded-none border-0 bg-transparent shadow-none ring-0 focus-visible:ring-0 disabled:bg-transparent aria-invalid:ring-0 dark:bg-transparent dark:disabled:bg-transparent",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function InputGroupTextarea({
+  className,
+  ...props
+}: React.ComponentProps<"textarea">) {
+  return (
+    <Textarea
+      data-slot="input-group-control"
+      className={cn(
+        "flex-1 resize-none rounded-none border-0 bg-transparent py-2 shadow-none ring-0 focus-visible:ring-0 disabled:bg-transparent aria-invalid:ring-0 dark:bg-transparent dark:disabled:bg-transparent",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+export {
+  InputGroup,
+  InputGroupAddon,
+  InputGroupButton,
+  InputGroupText,
+  InputGroupInput,
+  InputGroupTextarea,
+}

frontend/src/components/ui/popover.tsx

@@ -0,0 +1,87 @@
+import * as React from "react"
+import { Popover as PopoverPrimitive } from "radix-ui"
+
+import { cn } from "@/lib/utils"
+
+function Popover({
+  ...props
+}: React.ComponentProps<typeof PopoverPrimitive.Root>) {
+  return <PopoverPrimitive.Root data-slot="popover" {...props} />
+}
+
+function PopoverTrigger({
+  ...props
+}: React.ComponentProps<typeof PopoverPrimitive.Trigger>) {
+  return <PopoverPrimitive.Trigger data-slot="popover-trigger" {...props} />
+}
+
+function PopoverContent({
+  className,
+  align = "center",
+  sideOffset = 4,
+  ...props
+}: React.ComponentProps<typeof PopoverPrimitive.Content>) {
+  return (
+    <PopoverPrimitive.Portal>
+      <PopoverPrimitive.Content
+        data-slot="popover-content"
+        align={align}
+        sideOffset={sideOffset}
+        className={cn(
+          "z-50 flex w-72 origin-(--radix-popover-content-transform-origin) flex-col gap-2.5 rounded-lg bg-popover p-2.5 text-sm text-popover-foreground shadow-md ring-1 ring-foreground/10 outline-hidden duration-100 data-[side=bottom]:slide-in-from-top-2 data-[side=left]:slide-in-from-right-2 data-[side=right]:slide-in-from-left-2 data-[side=top]:slide-in-from-bottom-2 data-open:animate-in data-open:fade-in-0 data-open:zoom-in-95 data-closed:animate-out data-closed:fade-out-0 data-closed:zoom-out-95",
+          className
+        )}
+        {...props}
+      />
+    </PopoverPrimitive.Portal>
+  )
+}
+
+function PopoverAnchor({
+  ...props
+}: React.ComponentProps<typeof PopoverPrimitive.Anchor>) {
+  return <PopoverPrimitive.Anchor data-slot="popover-anchor" {...props} />
+}
+
+function PopoverHeader({ className, ...props }: React.ComponentProps<"div">) {
+  return (
+    <div
+      data-slot="popover-header"
+      className={cn("flex flex-col gap-0.5 text-sm", className)}
+      {...props}
+    />
+  )
+}
+
+function PopoverTitle({ className, ...props }: React.ComponentProps<"h2">) {
+  return (
+    <div
+      data-slot="popover-title"
+      className={cn("font-medium", className)}
+      {...props}
+    />
+  )
+}
+
+function PopoverDescription({
+  className,
+  ...props
+}: React.ComponentProps<"p">) {
+  return (
+    <p
+      data-slot="popover-description"
+      className={cn("text-muted-foreground", className)}
+      {...props}
+    />
+  )
+}
+
+export {
+  Popover,
+  PopoverAnchor,
+  PopoverContent,
+  PopoverDescription,
+  PopoverHeader,
+  PopoverTitle,
+  PopoverTrigger,
+}

frontend/src/components/ui/scroll-area.tsx

@@ -0,0 +1,53 @@
+import * as React from "react"
+import { ScrollArea as ScrollAreaPrimitive } from "radix-ui"
+
+import { cn } from "@/lib/utils"
+
+function ScrollArea({
+  className,
+  children,
+  ...props
+}: React.ComponentProps<typeof ScrollAreaPrimitive.Root>) {
+  return (
+    <ScrollAreaPrimitive.Root
+      data-slot="scroll-area"
+      className={cn("relative", className)}
+      {...props}
+    >
+      <ScrollAreaPrimitive.Viewport
+        data-slot="scroll-area-viewport"
+        className="size-full rounded-[inherit] transition-[color,box-shadow] outline-none focus-visible:ring-[3px] focus-visible:ring-ring/50 focus-visible:outline-1"
+      >
+        {children}
+      </ScrollAreaPrimitive.Viewport>
+      <ScrollBar />
+      <ScrollAreaPrimitive.Corner />
+    </ScrollAreaPrimitive.Root>
+  )
+}
+
+function ScrollBar({
+  className,
+  orientation = "vertical",
+  ...props
+}: React.ComponentProps<typeof ScrollAreaPrimitive.ScrollAreaScrollbar>) {
+  return (
+    <ScrollAreaPrimitive.ScrollAreaScrollbar
+      data-slot="scroll-area-scrollbar"
+      data-orientation={orientation}
+      orientation={orientation}
+      className={cn(
+        "flex touch-none p-px transition-colors select-none data-horizontal:h-2.5 data-horizontal:flex-col data-horizontal:border-t data-horizontal:border-t-transparent data-vertical:h-full data-vertical:w-2.5 data-vertical:border-l data-vertical:border-l-transparent",
+        className
+      )}
+      {...props}
+    >
+      <ScrollAreaPrimitive.ScrollAreaThumb
+        data-slot="scroll-area-thumb"
+        className="relative flex-1 rounded-full bg-border"
+      />
+    </ScrollAreaPrimitive.ScrollAreaScrollbar>
+  )
+}
+
+export { ScrollArea, ScrollBar }

frontend/src/components/ui/switch.tsx

@@ -0,0 +1,31 @@
+import * as React from "react";
+import {Switch as SwitchPrimitive} from "radix-ui";
+
+import {cn} from "@/lib/utils";
+
+function Switch({
+	className,
+	size = "default",
+	...props
+}: React.ComponentProps<typeof SwitchPrimitive.Root> & {
+	size?: "sm" | "default";
+}) {
+	return (
+		<SwitchPrimitive.Root
+			data-slot="switch"
+			data-size={size}
+			className={cn(
+				"peer group/switch relative inline-flex shrink-0 items-center rounded-full border border-transparent transition-all outline-none after:absolute after:-inset-x-3 after:-inset-y-2 focus-visible:border-ring focus-visible:ring-3 focus-visible:ring-ring/50 aria-invalid:border-destructive aria-invalid:ring-3 aria-invalid:ring-destructive/20 data-[size=default]:h-[18.4px] data-[size=default]:w-[32px] data-[size=sm]:h-[14px] data-[size=sm]:w-[24px] dark:aria-invalid:border-destructive/50 dark:aria-invalid:ring-destructive/40 data-checked:bg-primary data-unchecked:bg-input dark:data-unchecked:bg-input/80 data-disabled:cursor-not-allowed data-disabled:opacity-50",
+				className,
+			)}
+			{...props}
+		>
+			<SwitchPrimitive.Thumb
+				data-slot="switch-thumb"
+				className="pointer-events-none block rounded-full bg-background ring-0 transition-transform group-data-[size=default]/switch:size-4 group-data-[size=sm]/switch:size-3 group-data-[size=default]/switch:data-checked:translate-x-[calc(100%-2px)] group-data-[size=sm]/switch:data-checked:translate-x-[calc(100%-2px)] dark:data-checked:bg-primary-foreground group-data-[size=default]/switch:data-unchecked:translate-x-0 group-data-[size=sm]/switch:data-unchecked:translate-x-0 dark:data-unchecked:bg-foreground"
+			/>
+		</SwitchPrimitive.Root>
+	);
+}
+
+export {Switch};

frontend/src/components/ui/table.tsx

@@ -0,0 +1,114 @@
+import * as React from "react"
+
+import { cn } from "@/lib/utils"
+
+function Table({ className, ...props }: React.ComponentProps<"table">) {
+  return (
+    <div
+      data-slot="table-container"
+      className="relative w-full overflow-x-auto"
+    >
+      <table
+        data-slot="table"
+        className={cn("w-full caption-bottom text-sm", className)}
+        {...props}
+      />
+    </div>
+  )
+}
+
+function TableHeader({ className, ...props }: React.ComponentProps<"thead">) {
+  return (
+    <thead
+      data-slot="table-header"
+      className={cn("[&_tr]:border-b", className)}
+      {...props}
+    />
+  )
+}
+
+function TableBody({ className, ...props }: React.ComponentProps<"tbody">) {
+  return (
+    <tbody
+      data-slot="table-body"
+      className={cn("[&_tr:last-child]:border-0", className)}
+      {...props}
+    />
+  )
+}
+
+function TableFooter({ className, ...props }: React.ComponentProps<"tfoot">) {
+  return (
+    <tfoot
+      data-slot="table-footer"
+      className={cn(
+        "border-t bg-muted/50 font-medium [&>tr]:last:border-b-0",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function TableRow({ className, ...props }: React.ComponentProps<"tr">) {
+  return (
+    <tr
+      data-slot="table-row"
+      className={cn(
+        "border-b transition-colors hover:bg-muted/50 data-[state=selected]:bg-muted",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function TableHead({ className, ...props }: React.ComponentProps<"th">) {
+  return (
+    <th
+      data-slot="table-head"
+      className={cn(
+        "h-10 px-2 text-left align-middle font-medium whitespace-nowrap text-foreground [&:has([role=checkbox])]:pr-0",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function TableCell({ className, ...props }: React.ComponentProps<"td">) {
+  return (
+    <td
+      data-slot="table-cell"
+      className={cn(
+        "p-2 align-middle whitespace-nowrap [&:has([role=checkbox])]:pr-0",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+function TableCaption({
+  className,
+  ...props
+}: React.ComponentProps<"caption">) {
+  return (
+    <caption
+      data-slot="table-caption"
+      className={cn("mt-4 text-sm text-muted-foreground", className)}
+      {...props}
+    />
+  )
+}
+
+export {
+  Table,
+  TableHeader,
+  TableBody,
+  TableFooter,
+  TableHead,
+  TableRow,
+  TableCell,
+  TableCaption,
+}

frontend/src/components/ui/textarea.tsx

@@ -0,0 +1,18 @@
+import * as React from "react"
+
+import { cn } from "@/lib/utils"
+
+function Textarea({ className, ...props }: React.ComponentProps<"textarea">) {
+  return (
+    <textarea
+      data-slot="textarea"
+      className={cn(
+        "flex field-sizing-content min-h-16 w-full rounded-lg border border-input bg-transparent px-2.5 py-2 text-base transition-colors outline-none placeholder:text-muted-foreground focus-visible:border-ring focus-visible:ring-3 focus-visible:ring-ring/50 disabled:cursor-not-allowed disabled:bg-input/50 disabled:opacity-50 aria-invalid:border-destructive aria-invalid:ring-3 aria-invalid:ring-destructive/20 md:text-sm dark:bg-input/30 dark:disabled:bg-input/80 dark:aria-invalid:border-destructive/50 dark:aria-invalid:ring-destructive/40",
+        className
+      )}
+      {...props}
+    />
+  )
+}
+
+export { Textarea }

frontend/src/index.css

@@ -1,3 +1,124 @@
-@tailwind base;
-@tailwind components;
-@tailwind utilities;
+@import "tailwindcss";
+@import "tw-animate-css";
+@import "shadcn/tailwind.css";
+
+@custom-variant dark (&:is(.dark *));
+
+@theme inline {
+	--radius-sm: calc(var(--radius) - 4px);
+	--radius-md: calc(var(--radius) - 2px);
+	--radius-lg: var(--radius);
+	--radius-xl: calc(var(--radius) + 4px);
+	--radius-2xl: calc(var(--radius) + 8px);
+	--radius-3xl: calc(var(--radius) + 12px);
+	--radius-4xl: calc(var(--radius) + 16px);
+	--color-background: var(--background);
+	--color-foreground: var(--foreground);
+	--color-card: var(--card);
+	--color-card-foreground: var(--card-foreground);
+	--color-popover: var(--popover);
+	--color-popover-foreground: var(--popover-foreground);
+	--color-primary: var(--primary);
+	--color-primary-foreground: var(--primary-foreground);
+	--color-secondary: var(--secondary);
+	--color-secondary-foreground: var(--secondary-foreground);
+	--color-muted: var(--muted);
+	--color-muted-foreground: var(--muted-foreground);
+	--color-accent: var(--accent);
+	--color-accent-foreground: var(--accent-foreground);
+	--color-destructive: var(--destructive);
+	--color-border: var(--border);
+	--color-input: var(--input);
+	--color-ring: var(--ring);
+	--color-chart-1: var(--chart-1);
+	--color-chart-2: var(--chart-2);
+	--color-chart-3: var(--chart-3);
+	--color-chart-4: var(--chart-4);
+	--color-chart-5: var(--chart-5);
+	--color-sidebar: var(--sidebar);
+	--color-sidebar-foreground: var(--sidebar-foreground);
+	--color-sidebar-primary: var(--sidebar-primary);
+	--color-sidebar-primary-foreground: var(--sidebar-primary-foreground);
+	--color-sidebar-accent: var(--sidebar-accent);
+	--color-sidebar-accent-foreground: var(--sidebar-accent-foreground);
+	--color-sidebar-border: var(--sidebar-border);
+	--color-sidebar-ring: var(--sidebar-ring);
+}
+
+:root {
+	--radius: 0.625rem;
+	--background: oklch(1 0 0);
+	--foreground: oklch(0.141 0.005 285.823);
+	--card: oklch(1 0 0);
+	--card-foreground: oklch(0.141 0.005 285.823);
+	--popover: oklch(1 0 0);
+	--popover-foreground: oklch(0.141 0.005 285.823);
+	--primary: oklch(0.21 0.006 285.885);
+	--primary-foreground: oklch(0.985 0 0);
+	--secondary: oklch(0.967 0.001 286.375);
+	--secondary-foreground: oklch(0.21 0.006 285.885);
+	--muted: oklch(0.967 0.001 286.375);
+	--muted-foreground: oklch(0.552 0.016 285.938);
+	--accent: oklch(0.967 0.001 286.375);
+	--accent-foreground: oklch(0.21 0.006 285.885);
+	--destructive: oklch(0.577 0.245 27.325);
+	--border: oklch(0.92 0.004 286.32);
+	--input: oklch(0.92 0.004 286.32);
+	--ring: oklch(0.705 0.015 286.067);
+	--chart-1: oklch(0.646 0.222 41.116);
+	--chart-2: oklch(0.6 0.118 184.704);
+	--chart-3: oklch(0.398 0.07 227.392);
+	--chart-4: oklch(0.828 0.189 84.429);
+	--chart-5: oklch(0.769 0.188 70.08);
+	--sidebar: oklch(0.985 0 0);
+	--sidebar-foreground: oklch(0.141 0.005 285.823);
+	--sidebar-primary: oklch(0.21 0.006 285.885);
+	--sidebar-primary-foreground: oklch(0.985 0 0);
+	--sidebar-accent: oklch(0.967 0.001 286.375);
+	--sidebar-accent-foreground: oklch(0.21 0.006 285.885);
+	--sidebar-border: oklch(0.92 0.004 286.32);
+	--sidebar-ring: oklch(0.705 0.015 286.067);
+}
+
+.dark {
+	--background: oklch(0.141 0.005 285.823);
+	--foreground: oklch(0.985 0 0);
+	--card: oklch(0.21 0.006 285.885);
+	--card-foreground: oklch(0.985 0 0);
+	--popover: oklch(0.21 0.006 285.885);
+	--popover-foreground: oklch(0.985 0 0);
+	--primary: oklch(0.92 0.004 286.32);
+	--primary-foreground: oklch(0.21 0.006 285.885);
+	--secondary: oklch(0.274 0.006 286.033);
+	--secondary-foreground: oklch(0.985 0 0);
+	--muted: oklch(0.274 0.006 286.033);
+	--muted-foreground: oklch(0.705 0.015 286.067);
+	--accent: oklch(0.274 0.006 286.033);
+	--accent-foreground: oklch(0.985 0 0);
+	--destructive: oklch(0.704 0.191 22.216);
+	--border: oklch(1 0 0 / 10%);
+	--input: oklch(1 0 0 / 15%);
+	--ring: oklch(0.552 0.016 285.938);
+	--chart-1: oklch(0.488 0.243 264.376);
+	--chart-2: oklch(0.696 0.17 162.48);
+	--chart-3: oklch(0.769 0.188 70.08);
+	--chart-4: oklch(0.627 0.265 303.9);
+	--chart-5: oklch(0.645 0.246 16.439);
+	--sidebar: oklch(0.21 0.006 285.885);
+	--sidebar-foreground: oklch(0.985 0 0);
+	--sidebar-primary: oklch(0.488 0.243 264.376);
+	--sidebar-primary-foreground: oklch(0.985 0 0);
+	--sidebar-accent: oklch(0.274 0.006 286.033);
+	--sidebar-accent-foreground: oklch(0.985 0 0);
+	--sidebar-border: oklch(1 0 0 / 10%);
+	--sidebar-ring: oklch(0.552 0.016 285.938);
+}
+
+@layer base {
+	* {
+		@apply border-border outline-ring/50;
+	}
+	body {
+		@apply bg-background text-foreground;
+	}
+}

frontend/src/layouts/DashboardLayout.tsx

@@ -0,0 +1,18 @@
+import {Outlet} from "react-router-dom";
+
+import Sidebar from "@/components/layout/Sidebar";
+import Header from "@/components/layout/Header";
+
+export default function DashboardLayout() {
+	return (
+		<div className="flex min-h-screen bg-background">
+			<Sidebar />
+			<div className="flex flex-col flex-1">
+				<Header />
+				<main className="flex-1 p-6">
+					<Outlet />
+				</main>
+			</div>
+		</div>
+	);
+}

frontend/src/pages/Academics.tsx

@@ -0,0 +1,364 @@
+import { useState, useEffect, useCallback } from "react";
+
+import { getAcademicsApi, deleteAcademicsApi } from "@/api/academics";
+import { exportToExcel } from "@/utils/exportToExcel";
+
+import {
+	Table,
+	TableBody,
+	TableCell,
+	TableHead,
+	TableHeader,
+	TableRow,
+} from "@/components/ui/table";
+
+import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card";
+import { Button } from "@/components/ui/button";
+import { Input } from "@/components/ui/input";
+import {
+	Dialog,
+	DialogContent,
+	DialogHeader,
+	DialogTitle,
+	DialogFooter,
+} from "@/components/ui/dialog";
+
+import {
+	Loader2,
+	Trash,
+	RefreshCw,
+	Download,
+	ChevronLeft,
+	ChevronRight,
+	Eye,
+	BookOpen,
+} from "lucide-react";
+
+export default function AcademicsPage() {
+	const [records, setRecords] = useState<any[]>([]);
+	const [loading, setLoading] = useState(true);
+
+	const [searchText, setSearchText] = useState("");
+
+	const [viewOpen, setViewOpen] = useState(false);
+	const [viewData, setViewData] = useState<any>(null);
+
+	const [currentPage, setCurrentPage] = useState(1);
+	const itemsPerPage = 10;
+
+	const fetchAll = useCallback(async () => {
+		setLoading(true);
+		try {
+			const res = await getAcademicsApi();
+			setRecords(res?.data || []);
+		} catch (err) {
+			console.error(err);
+		} finally {
+			setLoading(false);
+		}
+	}, []);
+
+	useEffect(() => {
+		fetchAll();
+	}, [fetchAll]);
+
+	const filteredRecords = records.filter((item) => {
+		return (
+			item.fullName?.toLowerCase().includes(searchText.toLowerCase()) ||
+			item.number?.includes(searchText) ||
+			item.emailId?.toLowerCase().includes(searchText.toLowerCase()) ||
+			item.subject?.toLowerCase().includes(searchText.toLowerCase()) ||
+			item.courseName?.toLowerCase().includes(searchText.toLowerCase())
+		);
+	});
+
+	useEffect(() => {
+		setCurrentPage(1);
+	}, [searchText]);
+
+	const totalPages = Math.ceil(filteredRecords.length / itemsPerPage);
+	const indexOfLastItem = currentPage * itemsPerPage;
+	const indexOfFirstItem = indexOfLastItem - itemsPerPage;
+	const currentItems = filteredRecords.slice(indexOfFirstItem, indexOfLastItem);
+
+	function openView(item: any) {
+		setViewData(item);
+		setViewOpen(true);
+	}
+
+	async function handleDelete(id: number) {
+		if (!confirm("Delete record?")) return;
+		await deleteAcademicsApi(id);
+		fetchAll();
+	}
+
+	const handleExport = () => {
+		const exportData = filteredRecords.map((item) => ({
+			ID: item.id,
+			Name: item.fullName,
+			Phone: item.number,
+			Email: item.emailId,
+			Course: item.courseName,
+			Subject: item.subject,
+			Message: item.message,
+			Date: new Date(item.createdAt).toLocaleDateString(),
+		}));
+
+		exportToExcel(exportData, "academics");
+	};
+
+	return (
+		<div className="p-6 space-y-6">
+			<div className="flex flex-col md:flex-row md:justify-between md:items-center gap-4">
+				<h1 className="text-3xl font-bold">Academics & Research</h1>
+
+				<div className="flex flex-wrap gap-3">
+					<Input
+						placeholder="Search name / course / email..."
+						value={searchText}
+						onChange={(e) => setSearchText(e.target.value)}
+						className="w-[280px] text-base"
+					/>
+
+					<Button
+						variant="outline"
+						onClick={fetchAll}
+						disabled={loading}
+						className="text-base"
+					>
+						<RefreshCw className="mr-2 h-5 w-5" />
+						Refresh
+					</Button>
+
+					<Button onClick={handleExport} className="text-base">
+						<Download className="mr-2 h-5 w-5" />
+						Export
+					</Button>
+				</div>
+			</div>
+
+			<Card>
+				<CardHeader>
+					<CardTitle className="text-xl">Academic Records</CardTitle>
+				</CardHeader>
+
+				<CardContent className="p-0 sm:p-6 space-y-4">
+					<div className="rounded-md border overflow-x-auto overflow-y-auto max-h-[650px] relative">
+						<Table className="w-full min-w-[1100px] table-fixed border-separate border-spacing-0">
+							<TableHeader className="sticky top-0 z-20 bg-background shadow-sm">
+								<TableRow>
+									<TableHead className="w-[60px] bg-background font-bold text-sm">
+										ID
+									</TableHead>
+									<TableHead className="w-[220px] bg-background font-bold text-sm">
+										Full Name
+									</TableHead>
+									<TableHead className="w-[180px] bg-background font-bold text-sm">
+										Course
+									</TableHead>
+									<TableHead className="w-[180px] bg-background font-bold text-sm">
+										Subject
+									</TableHead>
+									<TableHead className="w-[140px] bg-background font-bold text-sm">
+										Applied Date
+									</TableHead>
+									<TableHead className="w-[220px] bg-background font-bold text-sm">
+										Message
+									</TableHead>
+									<TableHead className="w-[120px] bg-background font-bold text-right text-sm">
+										Actions
+									</TableHead>
+								</TableRow>
+							</TableHeader>
+
+							<TableBody>
+								{loading ? (
+									<TableRow>
+										<TableCell colSpan={7} className="text-center py-10">
+											<Loader2 className="h-8 w-8 animate-spin mx-auto" />
+										</TableCell>
+									</TableRow>
+								) : currentItems.length === 0 ? (
+									<TableRow>
+										<TableCell
+											colSpan={7}
+											className="text-center text-muted-foreground py-10 text-base"
+										>
+											No records found
+										</TableCell>
+									</TableRow>
+								) : (
+									currentItems.map((item) => (
+										<TableRow key={item.id} className="hover:bg-muted/50">
+											<TableCell className="font-mono text-xs">
+												{item.id}
+											</TableCell>
+											<TableCell>
+												<div className="font-semibold text-base truncate">
+													{item.fullName}
+												</div>
+												<div className="text-xs text-muted-foreground truncate">
+													{item.emailId}
+												</div>
+												<div className="text-[11px] font-medium">
+													{item.number}
+												</div>
+											</TableCell>
+											<TableCell>
+												<div className="text-sm font-medium line-clamp-2">
+													{item.courseName || "-"}
+												</div>
+											</TableCell>
+											<TableCell>
+												<div className="text-sm line-clamp-2">
+													{item.subject || "-"}
+												</div>
+											</TableCell>
+											<TableCell className="text-sm">
+												{new Date(item.createdAt).toLocaleDateString()}
+											</TableCell>
+											<TableCell>
+												<div className="text-sm line-clamp-2 text-muted-foreground italic">
+													{item.message || "-"}
+												</div>
+											</TableCell>
+											<TableCell className="text-right">
+												<div className="flex justify-end gap-2">
+													<Button
+														size="icon"
+														variant="ghost"
+														className="h-9 w-9"
+														onClick={() => openView(item)}
+													>
+														<Eye className="h-4 w-4" />
+													</Button>
+													<Button
+														size="icon"
+														variant="ghost"
+														className="h-9 w-9 text-destructive hover:text-destructive hover:bg-destructive/10"
+														onClick={() => handleDelete(item.id)}
+													>
+														<Trash className="h-4 w-4" />
+													</Button>
+												</div>
+											</TableCell>
+										</TableRow>
+									))
+								)}
+							</TableBody>
+						</Table>
+					</div>
+
+					{!loading && filteredRecords.length > 0 && (
+						<div className="flex items-center justify-between px-2 py-6 border-t">
+							<div className="text-base text-muted-foreground">
+								Showing{" "}
+								<span className="font-semibold">{indexOfFirstItem + 1}</span> to{" "}
+								<span className="font-semibold">
+									{Math.min(indexOfLastItem, filteredRecords.length)}
+								</span>{" "}
+								of{" "}
+								<span className="font-semibold">{filteredRecords.length}</span>{" "}
+								records
+							</div>
+							<div className="flex items-center gap-6">
+								<div className="text-base font-semibold">
+									Page {currentPage} of {totalPages}
+								</div>
+								<div className="flex gap-2">
+									<Button
+										variant="outline"
+										size="icon"
+										className="h-10 w-10"
+										onClick={() =>
+											setCurrentPage((prev) => Math.max(prev - 1, 1))
+										}
+										disabled={currentPage === 1}
+									>
+										<ChevronLeft className="h-5 w-5" />
+									</Button>
+									<Button
+										variant="outline"
+										size="icon"
+										className="h-10 w-10"
+										onClick={() =>
+											setCurrentPage((prev) => Math.min(prev + 1, totalPages))
+										}
+										disabled={currentPage === totalPages || totalPages === 0}
+									>
+										<ChevronRight className="h-5 w-5" />
+									</Button>
+								</div>
+							</div>
+						</div>
+					)}
+				</CardContent>
+			</Card>
+
+			<Dialog open={viewOpen} onOpenChange={setViewOpen}>
+				<DialogContent className="w-full !max-w-3xl max-h-[85vh] overflow-y-auto">
+					<DialogHeader>
+						<DialogTitle className="text-2xl border-b pb-2 flex items-center gap-2">
+							<BookOpen className="h-6 w-6" /> Academic Detail View
+						</DialogTitle>
+					</DialogHeader>
+					{viewData && (
+						<div className="space-y-6 py-4">
+							<div className="grid grid-cols-1 md:grid-cols-2 gap-6">
+								<div className="space-y-4">
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Applicant Information
+										</p>
+										<p className="text-lg font-bold text-primary">
+											{viewData.fullName}
+										</p>
+										<p className="text-sm font-medium">{viewData.emailId}</p>
+										<p className="text-sm">{viewData.number}</p>
+									</div>
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Course & Subject
+										</p>
+										<p className="text-base font-semibold">
+											{viewData.courseName || "N/A"}
+										</p>
+										<p className="text-sm text-muted-foreground">
+											{viewData.subject}
+										</p>
+									</div>
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Submission Date
+										</p>
+										<p className="text-sm">
+											{new Date(viewData.createdAt).toLocaleString()}
+										</p>
+									</div>
+								</div>
+								<div className="space-y-4">
+									<div className="p-4 bg-muted/30 rounded-lg border">
+										<p className="text-xs uppercase font-bold text-muted-foreground mb-2">
+											Message / Research Inquiry
+										</p>
+										<p className="text-sm leading-relaxed whitespace-pre-wrap italic">
+											{viewData.message || "No message content provided."}
+										</p>
+									</div>
+								</div>
+							</div>
+						</div>
+					)}
+					<DialogFooter>
+						<Button
+							onClick={() => setViewOpen(false)}
+							className="w-full md:w-auto"
+						>
+							Close
+						</Button>
+					</DialogFooter>
+				</DialogContent>
+			</Dialog>
+		</div>
+	);
+}

frontend/src/pages/Appointment.tsx

@@ -0,0 +1,391 @@
+import { useState, useEffect, useCallback } from "react";
+
+import { getAppointmentsApi, deleteAppointmentApi } from "@/api/appointment";
+import { exportToExcel } from "@/utils/exportToExcel";
+
+import {
+	Table,
+	TableBody,
+	TableCell,
+	TableHead,
+	TableHeader,
+	TableRow,
+} from "@/components/ui/table";
+
+import { Card, CardContent, CardHeader, CardTitle } from "@/components/ui/card";
+import { Button } from "@/components/ui/button";
+import { Input } from "@/components/ui/input";
+import {
+	Dialog,
+	DialogContent,
+	DialogHeader,
+	DialogTitle,
+	DialogFooter,
+} from "@/components/ui/dialog";
+
+import {
+	Loader2,
+	Trash,
+	RefreshCw,
+	Download,
+	ChevronLeft,
+	ChevronRight,
+	Eye,
+} from "lucide-react";
+
+export default function AppointmentPage() {
+	const [appointments, setAppointments] = useState<any[]>([]);
+	const [loading, setLoading] = useState(true);
+
+	const [searchText, setSearchText] = useState("");
+	const [filterDoctor, setFilterDoctor] = useState("");
+	const [filterDate, setFilterDate] = useState("");
+
+	const [viewOpen, setViewOpen] = useState(false);
+	const [viewData, setViewData] = useState<any>(null);
+
+	const [currentPage, setCurrentPage] = useState(1);
+	const [totalPages, setTotalPages] = useState(1);
+	const [totalItems, setTotalItems] = useState(0);
+	const [itemsPerPage, setItemsPerPage] = useState(10);
+
+	const fetchAll = useCallback(async () => {
+		setLoading(true);
+		try {
+			const res = await getAppointmentsApi(
+				currentPage,
+				itemsPerPage,
+				filterDate,
+				searchText,
+			);
+			setAppointments(res?.data || []);
+			setTotalPages(res?.pagination?.totalPages || 1);
+			setTotalItems(res?.pagination?.total || 0);
+		} catch (err) {
+			console.error(err);
+		} finally {
+			setLoading(false);
+		}
+	}, [currentPage, itemsPerPage, filterDate, searchText]);
+
+	useEffect(() => {
+		fetchAll();
+	}, [fetchAll]);
+
+	const filteredAppointments = appointments.filter((item) => {
+		const matchesDoctor = filterDoctor
+			? item.doctor?.name?.toLowerCase().includes(filterDoctor.toLowerCase())
+			: true;
+
+		return matchesDoctor;
+	});
+
+	useEffect(() => {
+		setCurrentPage(1);
+	}, [searchText, filterDoctor, filterDate]);
+
+	const indexOfFirstItem = (currentPage - 1) * itemsPerPage;
+
+	function openView(item: any) {
+		setViewData(item);
+		setViewOpen(true);
+	}
+
+	async function handleDelete(id: number) {
+		if (!confirm("Delete appointment?")) return;
+		await deleteAppointmentApi(id);
+		fetchAll();
+	}
+
+	const handleExport = () => {
+		const exportData = filteredAppointments.map((item) => ({
+			ID: item.id,
+			Name: item.name,
+			Phone: item.mobileNumber,
+			Email: item.email,
+			Doctor: item.doctor?.name,
+			Department: item.department?.name,
+			Date: new Date(item.date).toLocaleDateString(),
+			Message: item.message,
+		}));
+		exportToExcel(exportData, "appointments");
+	};
+
+	return (
+		<div className="p-6 space-y-6">
+			<div className="flex flex-col md:flex-row md:justify-between md:items-center gap-4">
+				<h1 className="text-3xl font-bold">Appointments</h1>
+
+				<div className="flex flex-wrap gap-3">
+					<Input
+						placeholder="Search name / phone..."
+						value={searchText}
+						onChange={(e) => {
+							setSearchText(e.target.value);
+							setCurrentPage(1);
+						}}
+						className="w-[220px] text-base"
+					/>
+
+					<Input
+						type="date"
+						value={filterDate}
+						onChange={(e) => {
+							setFilterDate(e.target.value);
+							setCurrentPage(1);
+						}}
+						className="w-[160px] text-base"
+					/>
+
+					<select
+						value={itemsPerPage}
+						onChange={(e) => {
+							setItemsPerPage(Number(e.target.value));
+							setCurrentPage(1);
+						}}
+						className="flex h-10 rounded-md border border-input bg-background px-3 py-2 text-sm focus:ring-2 focus:ring-primary"
+					>
+						<option value={5}>5 / page</option>
+						<option value={10}>10 / page</option>
+						<option value={20}>20 / page</option>
+					</select>
+
+					<Button
+						variant="outline"
+						onClick={fetchAll}
+						disabled={loading}
+						className="text-base"
+					>
+						<RefreshCw className="mr-2 h-5 w-5" />
+						Refresh
+					</Button>
+
+					<Button onClick={handleExport} className="text-base">
+						<Download className="mr-2 h-5 w-5" />
+						Export
+					</Button>
+				</div>
+			</div>
+
+			<Card>
+				<CardHeader>
+					<CardTitle className="text-xl">Appointment List</CardTitle>
+				</CardHeader>
+
+				<CardContent className="p-0 sm:p-6 space-y-4">
+					<div className="rounded-md border overflow-x-auto overflow-y-auto max-h-[650px] relative">
+						<Table className="w-full min-w-[1000px] table-fixed border-separate border-spacing-0">
+							<TableHeader className="sticky top-0 z-20 bg-background shadow-sm">
+								<TableRow>
+									<TableHead className="w-[60px] bg-background font-bold text-sm">
+										ID
+									</TableHead>
+									<TableHead className="w-[200px] bg-background font-bold text-sm">
+										Patient
+									</TableHead>
+									<TableHead className="w-[180px] bg-background font-bold text-sm">
+										Doctor
+									</TableHead>
+									<TableHead className="w-[150px] bg-background font-bold text-sm">
+										Date
+									</TableHead>
+									<TableHead className="w-[250px] bg-background font-bold text-sm">
+										Message
+									</TableHead>
+									<TableHead className="w-[120px] bg-background font-bold text-right text-sm">
+										Actions
+									</TableHead>
+								</TableRow>
+							</TableHeader>
+
+							<TableBody>
+								{loading ? (
+									<TableRow>
+										<TableCell colSpan={6} className="text-center py-10">
+											<Loader2 className="h-8 w-8 animate-spin mx-auto" />
+										</TableCell>
+									</TableRow>
+								) : filteredAppointments.length === 0 ? (
+									<TableRow>
+										<TableCell
+											colSpan={6}
+											className="text-center text-muted-foreground py-10 text-base"
+										>
+											No appointments found
+										</TableCell>
+									</TableRow>
+								) : (
+									filteredAppointments.map((item) => (
+										<TableRow key={item.id} className="hover:bg-muted/50">
+											<TableCell className="font-mono text-xs">
+												{item.id}
+											</TableCell>
+											<TableCell>
+												<div className="font-semibold text-base truncate">
+													{item.name}
+												</div>
+												<div className="text-xs text-muted-foreground">
+													{item.mobileNumber}
+												</div>
+											</TableCell>
+											<TableCell>
+												<div className="text-sm font-medium">
+													{item.doctor?.name || "-"}
+												</div>
+												<div className="text-[10px] text-muted-foreground truncate">
+													{item.department?.name}
+												</div>
+											</TableCell>
+											<TableCell>
+												<div className="text-sm">
+													{new Date(item.date).toLocaleDateString()}
+												</div>
+											</TableCell>
+											<TableCell>
+												<div className="text-sm line-clamp-2 text-muted-foreground italic">
+													{item.message || "-"}
+												</div>
+											</TableCell>
+											<TableCell className="text-right">
+												<div className="flex justify-end gap-2">
+													<Button
+														size="icon"
+														variant="ghost"
+														className="h-9 w-9"
+														onClick={() => openView(item)}
+													>
+														<Eye className="h-4 w-4" />
+													</Button>
+													<Button
+														size="icon"
+														variant="ghost"
+														className="h-9 w-9 text-destructive hover:text-destructive hover:bg-destructive/10"
+														onClick={() => handleDelete(item.id)}
+													>
+														<Trash className="h-4 w-4" />
+													</Button>
+												</div>
+											</TableCell>
+										</TableRow>
+									))
+								)}
+							</TableBody>
+						</Table>
+					</div>
+
+					{!loading && totalItems > 0 && (
+						<div className="flex items-center justify-between px-2 py-6 border-t">
+							<div className="text-base text-muted-foreground">
+								Showing{" "}
+								<span className="font-semibold">{indexOfFirstItem + 1}</span> to{" "}
+								<span className="font-semibold">
+									{Math.min(currentPage * itemsPerPage, totalItems)}
+								</span>{" "}
+								of <span className="font-semibold">{totalItems}</span>
+							</div>
+							<div className="flex items-center gap-6">
+								<div className="text-base font-semibold">
+									Page {currentPage} of {totalPages}
+								</div>
+								<div className="flex gap-2">
+									<Button
+										variant="outline"
+										size="icon"
+										className="h-10 w-10"
+										onClick={() =>
+											setCurrentPage((prev) => Math.max(prev - 1, 1))
+										}
+										disabled={currentPage === 1}
+									>
+										<ChevronLeft className="h-5 w-5" />
+									</Button>
+									<Button
+										variant="outline"
+										size="icon"
+										className="h-10 w-10"
+										onClick={() =>
+											setCurrentPage((prev) => Math.min(prev + 1, totalPages))
+										}
+										disabled={currentPage === totalPages || totalPages === 0}
+									>
+										<ChevronRight className="h-5 w-5" />
+									</Button>
+								</div>
+							</div>
+						</div>
+					)}
+				</CardContent>
+			</Card>
+
+			<Dialog open={viewOpen} onOpenChange={setViewOpen}>
+				<DialogContent className="w-full !max-w-3xl max-h-[85vh] overflow-y-auto">
+					<DialogHeader>
+						<DialogTitle className="text-2xl border-b pb-2">
+							Appointment Details
+						</DialogTitle>
+					</DialogHeader>
+					{viewData && (
+						<div className="space-y-6 py-4">
+							<div className="grid grid-cols-1 md:grid-cols-2 gap-6">
+								<div className="space-y-4">
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Patient Information
+										</p>
+										<p className="text-lg font-bold text-primary">
+											{viewData.name}
+										</p>
+										<p className="text-sm">{viewData.mobileNumber}</p>
+										<p className="text-sm">
+											{viewData.email || "No email provided"}
+										</p>
+									</div>
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Appointment Date
+										</p>
+										<p className="text-base font-semibold">
+											{new Date(viewData.date).toLocaleDateString()}
+										</p>
+										<p className="text-[10px] text-muted-foreground">
+											Booked on: {new Date(viewData.createdAt).toLocaleString()}
+										</p>
+									</div>
+								</div>
+								<div className="space-y-4">
+									<div>
+										<p className="text-xs uppercase font-bold text-muted-foreground">
+											Doctor / Department
+										</p>
+										<p className="text-base font-bold">
+											{viewData.doctor?.name || "Not Assigned"}
+										</p>
+										<p className="text-sm text-muted-foreground">
+											{viewData.department?.name || "General"}
+										</p>
+									</div>
+									<div className="p-4 bg-muted/30 rounded-lg">
+										<p className="text-xs uppercase font-bold text-muted-foreground mb-2">
+											Message from Patient
+										</p>
+										<p className="text-sm italic leading-relaxed whitespace-pre-wrap">
+											{viewData.message || "No message provided."}
+										</p>
+									</div>
+								</div>
+							</div>
+						</div>
+					)}
+					<DialogFooter>
+						<Button
+							onClick={() => setViewOpen(false)}
+							className="w-full md:w-auto"
+						>
+							Close
+						</Button>
+					</DialogFooter>
+				</DialogContent>
+			</Dialog>
+		</div>
+	);
+}