feat: facility and google review crud

Reviewed-on: #50

.gitignore

@@ -1 +1,2 @@
 .env
+node_modules

.prettierignore

@@ -0,0 +1,14 @@
+node_modules
+dist
+build
+coverage
+.next
+out
+*.log
+
+backend/node_modules
+backend/dist
+
+frontend/node_modules
+frontend/build
+frontend/dist

.prettierrc

@@ -0,0 +1,13 @@
+{
+	"printWidth": 120,
+	"useTabs": true,
+	"tabWidth": 2,
+	"trailingComma": "es5",
+	"semi": true,
+	"singleQuote": true,
+	"bracketSpacing": true,
+	"arrowParens": "always",
+	"jsxSingleQuote": false,
+	"bracketSameLine": false,
+	"endOfLine": "lf"
+}

.vscode/settings.json

@@ -0,0 +1,4 @@
+{
+	"editor.defaultFormatter": "esbenp.prettier-vscode",
+	"editor.formatOnSave": true
+}

CLAUDE.md

@@ -35,6 +35,7 @@ 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>
 ```
@@ -86,6 +87,7 @@ Note the natural-key relations: `Appointment.doctorId` references `Doctor.doctor
 ## Environment variables
 
 `backend/.env`:
+
 ```
 DATABASE_URL=postgresql://user:password@db:5432/mydb
 PORT=5008
@@ -97,6 +99,7 @@ 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>
+"""
+}

backend/prisma.config.js

@@ -1,14 +1,14 @@
 // This file was generated by Prisma, and assumes you have installed the following:
 // npm install --save-dev prisma dotenv
-import "dotenv/config";
+import 'dotenv/config';
-import {defineConfig} from "prisma/config";
+import { defineConfig } from 'prisma/config';
 
 export default defineConfig({
-	schema: "prisma/schema.prisma",
+	schema: 'prisma/schema.prisma',
 	migrations: {
-		path: "prisma/migrations",
+		path: 'prisma/migrations',
 	},
 	datasource: {
-		url: process.env["DATABASE_URL"],
+		url: process.env['DATABASE_URL'],
 	},
 });

backend/prisma/migrations/20260510161939_sort_inactive_fields/migration.sql

@@ -0,0 +1,14 @@
+-- AlterTable
+ALTER TABLE "Career" ADD COLUMN     "isActive" BOOLEAN NOT NULL DEFAULT true,
+ADD COLUMN     "sortOrder" INTEGER NOT NULL DEFAULT 0;
+
+-- AlterTable
+ALTER TABLE "Department" ADD COLUMN     "isActive" BOOLEAN NOT NULL DEFAULT true,
+ADD COLUMN     "sortOrder" INTEGER NOT NULL DEFAULT 0;
+
+-- AlterTable
+ALTER TABLE "Doctor" ADD COLUMN     "globalSortOrder" INTEGER NOT NULL DEFAULT 0,
+ADD COLUMN     "isActive" BOOLEAN NOT NULL DEFAULT true;
+
+-- AlterTable
+ALTER TABLE "DoctorDepartment" ADD COLUMN     "sortOrder" INTEGER NOT NULL DEFAULT 0;

backend/prisma/migrations/20260510171736_sort_order_default1000/migration.sql

@@ -0,0 +1,11 @@
+-- AlterTable
+ALTER TABLE "Career" ALTER COLUMN "sortOrder" SET DEFAULT 1000;
+
+-- AlterTable
+ALTER TABLE "Department" ALTER COLUMN "sortOrder" SET DEFAULT 1000;
+
+-- AlterTable
+ALTER TABLE "Doctor" ALTER COLUMN "globalSortOrder" SET DEFAULT 1000;
+
+-- AlterTable
+ALTER TABLE "DoctorDepartment" ALTER COLUMN "sortOrder" SET DEFAULT 1000;

backend/prisma/migrations/20260513114221_healthcheck_api/migration.sql

@@ -0,0 +1,63 @@
+-- CreateTable
+CREATE TABLE "HealthCheckCategory" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "slug" TEXT NOT NULL,
+    "description" TEXT,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "HealthCheckCategory_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "HealthPackage" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "slug" TEXT NOT NULL,
+    "description" TEXT,
+    "price" DECIMAL(10,2),
+    "discountedPrice" DECIMAL(10,2),
+    "inclusions" JSONB NOT NULL,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "isFeatured" BOOLEAN NOT NULL DEFAULT false,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "categoryId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "HealthPackage_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "HealthPackageInquiry" (
+    "id" SERIAL NOT NULL,
+    "fullName" TEXT NOT NULL,
+    "mobileNumber" TEXT NOT NULL,
+    "email" TEXT,
+    "preferredDate" TIMESTAMP(3),
+    "message" TEXT,
+    "packageId" INTEGER NOT NULL,
+    "status" TEXT NOT NULL DEFAULT 'pending',
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "HealthPackageInquiry_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "HealthCheckCategory_name_key" ON "HealthCheckCategory"("name");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "HealthCheckCategory_slug_key" ON "HealthCheckCategory"("slug");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "HealthPackage_slug_key" ON "HealthPackage"("slug");
+
+-- AddForeignKey
+ALTER TABLE "HealthPackage" ADD CONSTRAINT "HealthPackage_categoryId_fkey" FOREIGN KEY ("categoryId") REFERENCES "HealthCheckCategory"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "HealthPackageInquiry" ADD CONSTRAINT "HealthPackageInquiry_packageId_fkey" FOREIGN KEY ("packageId") REFERENCES "HealthPackage"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

backend/prisma/migrations/20260514100534_add_gender_and_age_field/migration.sql

@@ -0,0 +1,3 @@
+-- AlterTable
+ALTER TABLE "HealthPackageInquiry" ADD COLUMN     "age" INTEGER,
+ADD COLUMN     "gender" TEXT;

backend/prisma/migrations/20260514110339_default_inclusion/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "HealthPackage" ALTER COLUMN "inclusions" SET DEFAULT '{}';

backend/prisma/migrations/20260518051754_make_slug_optional/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "HealthCheckCategory" ALTER COLUMN "slug" DROP NOT NULL;

backend/prisma/migrations/20260518055117_health_checkup_optional_image_field/migration.sql

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

backend/prisma/migrations/20260520043835_add_seo/migration.sql

@@ -0,0 +1,50 @@
+/*
+  Warnings:
+
+  - A unique constraint covering the columns `[seoId]` on the table `Doctor` will be added. If there are existing duplicate values, this will fail.
+
+*/
+-- AlterTable
+ALTER TABLE "Doctor" ADD COLUMN     "professionalSummary" TEXT,
+ADD COLUMN     "seoId" INTEGER;
+
+-- CreateTable
+CREATE TABLE "DoctorSpecialization" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "description" TEXT,
+    "doctorId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "DoctorSpecialization_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "Seo" (
+    "id" SERIAL NOT NULL,
+    "seoTitle" TEXT,
+    "metaDescription" TEXT,
+    "focusKeyphrase" TEXT,
+    "slug" TEXT,
+    "tags" TEXT[],
+    "ogTitle" TEXT,
+    "ogDescription" TEXT,
+    "ogImage" TEXT,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Seo_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Seo_slug_key" ON "Seo"("slug");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Doctor_seoId_key" ON "Doctor"("seoId");
+
+-- AddForeignKey
+ALTER TABLE "Doctor" ADD CONSTRAINT "Doctor_seoId_fkey" FOREIGN KEY ("seoId") REFERENCES "Seo"("id") ON DELETE SET NULL ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "DoctorSpecialization" ADD CONSTRAINT "DoctorSpecialization_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("id") ON DELETE CASCADE ON UPDATE CASCADE;

backend/prisma/migrations/20260520044321_add_exp/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "Doctor" ADD COLUMN     "experience" INTEGER;

backend/prisma/migrations/20260525122431_health_check_seo/migration.sql

@@ -0,0 +1,14 @@
+/*
+  Warnings:
+
+  - A unique constraint covering the columns `[seoId]` on the table `HealthPackage` will be added. If there are existing duplicate values, this will fail.
+
+*/
+-- AlterTable
+ALTER TABLE "HealthPackage" ADD COLUMN     "seoId" INTEGER;
+
+-- CreateIndex
+CREATE UNIQUE INDEX "HealthPackage_seoId_key" ON "HealthPackage"("seoId");
+
+-- AddForeignKey
+ALTER TABLE "HealthPackage" ADD CONSTRAINT "HealthPackage_seoId_fkey" FOREIGN KEY ("seoId") REFERENCES "Seo"("id") ON DELETE SET NULL ON UPDATE CASCADE;

backend/prisma/migrations/20260611055958_home_page_banner/migration.sql

@@ -0,0 +1,22 @@
+-- CreateEnum
+CREATE TYPE "BannerMediaType" AS ENUM ('IMAGE', 'VIDEO');
+
+-- CreateTable
+CREATE TABLE "HomepageBanner" (
+    "id" SERIAL NOT NULL,
+    "title" TEXT,
+    "subtitle" TEXT,
+    "mediaType" "BannerMediaType" NOT NULL,
+    "desktopMediaUrl" TEXT NOT NULL,
+    "mobileMediaUrl" TEXT,
+    "buttonText" TEXT,
+    "buttonLink" TEXT,
+    "openInNewTab" BOOLEAN NOT NULL DEFAULT false,
+    "textAlignment" TEXT DEFAULT 'left',
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "HomepageBanner_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260617053419_add_insurance_partner/migration.sql

@@ -0,0 +1,13 @@
+-- CreateTable
+CREATE TABLE "InsurancePartner" (
+    "id" SERIAL NOT NULL,
+    "name" TEXT NOT NULL,
+    "logo" TEXT NOT NULL,
+    "websiteUrl" TEXT,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "InsurancePartner_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260622101915_accreditation/migration.sql

@@ -0,0 +1,18 @@
+-- CreateEnum
+CREATE TYPE "AccreditationType" AS ENUM ('ACCREDITATION', 'CERTIFICATION');
+
+-- CreateTable
+CREATE TABLE "Accreditation" (
+    "id" SERIAL NOT NULL,
+    "title" TEXT NOT NULL,
+    "type" "AccreditationType" NOT NULL,
+    "logo" TEXT,
+    "image" TEXT,
+    "description" TEXT,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Accreditation_pkey" PRIMARY KEY ("id")
+);

backend/prisma/migrations/20260623120651_featured_field_for_doctor/migration.sql

@@ -0,0 +1,2 @@
+-- AlterTable
+ALTER TABLE "Doctor" ADD COLUMN     "isFeatured" BOOLEAN NOT NULL DEFAULT false;

backend/prisma/migrations/20260624123200_facilities/migration.sql

@@ -0,0 +1,49 @@
+-- CreateTable
+CREATE TABLE "Facility" (
+    "id" SERIAL NOT NULL,
+    "facilityId" TEXT NOT NULL,
+    "name" TEXT NOT NULL,
+    "slug" TEXT NOT NULL,
+    "shortDescription" TEXT,
+    "description" TEXT,
+    "videoUrl" TEXT,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "isFeatured" BOOLEAN NOT NULL DEFAULT false,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "departmentId" INTEGER,
+    "seoId" INTEGER,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "Facility_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "FacilityImage" (
+    "id" SERIAL NOT NULL,
+    "url" TEXT NOT NULL,
+    "altText" TEXT,
+    "description" TEXT,
+    "facilityId" INTEGER NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+    CONSTRAINT "FacilityImage_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Facility_facilityId_key" ON "Facility"("facilityId");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Facility_slug_key" ON "Facility"("slug");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Facility_seoId_key" ON "Facility"("seoId");
+
+-- AddForeignKey
+ALTER TABLE "Facility" ADD CONSTRAINT "Facility_departmentId_fkey" FOREIGN KEY ("departmentId") REFERENCES "Department"("id") ON DELETE SET NULL ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "Facility" ADD CONSTRAINT "Facility_seoId_fkey" FOREIGN KEY ("seoId") REFERENCES "Seo"("id") ON DELETE SET NULL ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "FacilityImage" ADD CONSTRAINT "FacilityImage_facilityId_fkey" FOREIGN KEY ("facilityId") REFERENCES "Facility"("id") ON DELETE CASCADE ON UPDATE CASCADE;

backend/prisma/migrations/20260625051712_google_review/migration.sql

@@ -0,0 +1,17 @@
+-- CreateTable
+CREATE TABLE "GoogleReview" (
+    "id" SERIAL NOT NULL,
+    "reviewerName" TEXT NOT NULL,
+    "reviewerImage" TEXT,
+    "rating" INTEGER NOT NULL,
+    "review" TEXT NOT NULL,
+    "reviewDate" TIMESTAMP(3),
+    "googleReviewUrl" TEXT,
+    "isFeatured" BOOLEAN NOT NULL DEFAULT false,
+    "isActive" BOOLEAN NOT NULL DEFAULT true,
+    "sortOrder" INTEGER NOT NULL DEFAULT 1000,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "GoogleReview_pkey" PRIMARY KEY ("id")
+);

backend/prisma/schema.prisma

@@ -23,9 +23,16 @@ model Doctor {
   name          String
   image         String?
   designation   String?
+  experience       Int?
   workingStatus String?
   qualification String?
-
+  isActive      Boolean  @default(true)
+  isFeatured   Boolean   @default(false)
+  globalSortOrder Int    @default(1000)
+  specializations DoctorSpecialization[]
+  professionalSummary String? @db.Text
+  seoId Int? @unique
+  seo   Seo? @relation(fields: [seoId], references: [id])
   departments  DoctorDepartment[]
   appointments Appointment[]
 
@@ -39,12 +46,15 @@ model Department {
   name         String
   image        String?
 
-
   para1      String?
   para2      String?
   para3      String?
   facilities String?
   services   String?
+  facilitiesList Facility[] 
+
+  isActive     Boolean  @default(true)
+  sortOrder    Int      @default(1000)
 
   doctors      DoctorDepartment[]
   appointments Appointment[]
@@ -61,7 +71,7 @@ model DoctorDepartment {
 
   doctor     Doctor     @relation(fields: [doctorId], references: [id])
   department Department @relation(fields: [departmentId], references: [id])
-
+  sortOrder  Int        @default(1000)
   timing DoctorTiming?
 
   createdAt DateTime @default(now())
@@ -111,7 +121,8 @@ model Career {
   email          String?
   number         String?
   status         String  @default("new")
-
+  isActive       Boolean @default(true)
+  sortOrder      Int     @default(1000)
   candidates Candidate[]
 
   createdAt DateTime @default(now())
@@ -214,3 +225,215 @@ model NewsImage {
 
   createdAt   DateTime  @default(now())
 }
+
+model HealthCheckCategory {
+  id          Int             @id @default(autoincrement())
+  name        String          @unique 
+  slug        String?          @unique
+  description String?
+  isActive    Boolean         @default(true)
+  sortOrder   Int             @default(1000)
+  
+  packages    HealthPackage[]
+
+  createdAt   DateTime        @default(now())
+  updatedAt   DateTime        @updatedAt
+}
+
+model HealthPackage {
+  id           Int                 @id @default(autoincrement())
+  name         String
+  slug         String              @unique
+  description  String?
+  price        Decimal?            @db.Decimal(10, 2)
+  image        String?
+  discountedPrice Decimal?         @db.Decimal(10, 2)
+  
+  inclusions   Json                @default("{}") 
+  
+  isActive     Boolean             @default(true)
+  isFeatured   Boolean             @default(false)
+  sortOrder    Int                 @default(1000)
+
+  categoryId   Int
+  category     HealthCheckCategory @relation(fields: [categoryId], references: [id])
+  
+  inquiries    HealthPackageInquiry[]
+
+  seoId            Int?                @unique
+  seo              Seo?                @relation(fields: [seoId], references: [id])
+
+  createdAt    DateTime            @default(now())
+  updatedAt    DateTime            @updatedAt
+}
+
+model HealthPackageInquiry {
+  id              Int           @id @default(autoincrement())
+  fullName        String
+  mobileNumber    String
+  email           String?
+  age             Int?          
+  gender          String?       
+  preferredDate   DateTime?
+  message         String?
+  
+  packageId       Int
+  healthPackage   HealthPackage @relation(fields: [packageId], references: [id])
+
+  status          String        @default("pending") 
+  createdAt       DateTime      @default(now())
+  updatedAt       DateTime      @updatedAt
+}
+
+
+model DoctorSpecialization {
+  id          Int     @id @default(autoincrement())
+  name        String
+  description String? @db.Text
+  doctorId    Int
+  doctor      Doctor @relation(fields: [doctorId],references: [id],onDelete: Cascade)
+  createdAt   DateTime @default(now())
+  updatedAt   DateTime @updatedAt
+}
+
+model Seo {
+  id                Int      @id @default(autoincrement())
+  doctor            Doctor?
+  healthPackage     HealthPackage?
+  facility          Facility? 
+
+
+  seoTitle          String?
+  metaDescription   String?   @db.Text
+  focusKeyphrase    String?
+  slug              String?   @unique
+  tags              String[]
+
+  ogTitle           String?
+  ogDescription     String?   @db.Text
+  ogImage           String?
+
+  createdAt         DateTime @default(now())
+  updatedAt         DateTime @updatedAt
+}
+
+model HomepageBanner {
+  id Int @id @default(autoincrement())
+
+  title    String?
+  subtitle String?
+
+  mediaType BannerMediaType
+
+  desktopMediaUrl String
+  mobileMediaUrl  String?
+
+  buttonText String?
+  buttonLink String?
+
+  openInNewTab Boolean @default(false)
+
+  textAlignment String? @default("left")
+
+  sortOrder Int @default(1000)
+  isActive  Boolean @default(true)
+
+  createdAt DateTime @default(now())
+  updatedAt DateTime @updatedAt
+}
+
+enum BannerMediaType {
+  IMAGE
+  VIDEO
+}
+
+model InsurancePartner {
+  id          Int      @id @default(autoincrement())
+  
+  name        String
+  logo        String
+  websiteUrl  String?
+  sortOrder   Int      @default(1000)
+  isActive    Boolean  @default(true)
+
+  createdAt   DateTime @default(now())
+  updatedAt   DateTime @updatedAt
+}
+
+model Accreditation {
+  id          Int      @id @default(autoincrement())
+
+  title       String
+  type        AccreditationType
+  logo        String?
+  image       String?
+  description String? @db.Text
+
+  sortOrder   Int      @default(1000)
+  isActive    Boolean  @default(true)
+
+  createdAt   DateTime @default(now())
+  updatedAt   DateTime @updatedAt
+}
+
+enum AccreditationType {
+  ACCREDITATION
+  CERTIFICATION
+}
+
+model Facility {
+  id              Int            @id @default(autoincrement())
+  facilityId      String         @unique 
+  name            String         
+  slug            String         @unique 
+  
+  shortDescription String?       @db.Text 
+  description     String?        @db.Text
+  videoUrl        String?     
+  
+  isActive        Boolean        @default(true)
+  isFeatured      Boolean        @default(false) 
+  sortOrder       Int            @default(1000)
+
+  images          FacilityImage[]
+
+  departmentId    Int?
+  department      Department?    @relation(fields: [departmentId], references: [id], onDelete: SetNull)
+
+  seoId           Int?           @unique
+  seo             Seo?           @relation(fields: [seoId], references: [id], onDelete: SetNull)
+
+  createdAt       DateTime       @default(now())
+  updatedAt       DateTime       @updatedAt
+}
+
+model FacilityImage {
+  id          Int      @id @default(autoincrement())
+  url         String   
+  altText     String?  
+  description String?  
+  
+  facilityId  Int
+  facility    Facility @relation(fields: [facilityId], references: [id], onDelete: Cascade)
+
+  createdAt   DateTime @default(now())
+}
+
+model GoogleReview {
+  id                Int       @id @default(autoincrement())
+
+  reviewerName      String
+  reviewerImage     String?
+  rating            Int      
+  review            String    @db.Text
+  reviewDate        DateTime?
+  googleReviewUrl   String?   
+
+  isFeatured        Boolean   @default(false)
+  isActive          Boolean   @default(true)
+
+  sortOrder         Int       @default(1000)
+
+  createdAt         DateTime  @default(now())
+  updatedAt         DateTime  @updatedAt
+}

backend/src/app.js

@@ -1,60 +1,72 @@
-import express from "express";
+import express from 'express';
-import dotenv from "dotenv";
+import dotenv from 'dotenv';
-import cors from "cors";
+import cors from 'cors';
 
-import departmentRoutes from "./routes/department.routes.js";
+import departmentRoutes from './routes/department.routes.js';
-import authRoutes from "./routes/auth.routes.js";
+import authRoutes from './routes/auth.routes.js';
-import blogRoutes from "./routes/blog.routes.js";
+import blogRoutes from './routes/blog.routes.js';
-import uploadRoutes from "./routes/upload.routes.js";
+import uploadRoutes from './routes/upload.routes.js';
-import doctorRoutes from "./routes/doctor.routes.js";
+import doctorRoutes from './routes/doctor.routes.js';
-import careerRoutes from "./routes/career.routes.js";
+import careerRoutes from './routes/career.routes.js';
-import candidateRoutes from "./routes/candidate.routes.js";
+import candidateRoutes from './routes/candidate.routes.js';
-import appointmentRoutes from "./routes/appointment.routes.js";
+import appointmentRoutes from './routes/appointment.routes.js';
-import inquiryRoutes from "./routes/inquiry.routes.js";
+import inquiryRoutes from './routes/inquiry.routes.js';
-import academicsResearchRoutes from "./routes/academicsResearch.routes.js";
+import academicsResearchRoutes from './routes/academicsResearch.routes.js';
-import emailConfigRoutes from "./routes/emailConfig.routes.js";
+import emailConfigRoutes from './routes/emailConfig.routes.js';
-import newsMediaRoutes from "./routes/newsMedia.routes.js";
+import newsMediaRoutes from './routes/newsMedia.routes.js';
-import importRoutes from "./routes/importRoutes.js";
+import importRoutes from './routes/importRoutes.js';
+import healthCheckRoutes from './routes/healthCheck.route.js';
+import homepageBannerRoutes from './routes/homepageBanner.routes.js';
+import insurancePartnerRoutes from './routes/insurancePartner.routes.js';
+import accreditationRoutes from './routes/accreditation.routes.js';
+import facilityRoutes from './routes/facility.routes.js';
+import gReviewRoutes from './routes/googleReview.routes.js';
 
 dotenv.config();
 
 const app = express();
 
-app.use(express.json({ limit: "50mb" }));
+app.use(express.json({ limit: '50mb' }));
-app.use(express.urlencoded({ limit: "50mb", extended: true }));
+app.use(express.urlencoded({ limit: '50mb', extended: true }));
 
 const allowedOrigins = process.env.CORS_ALLOWED_ORIGINS
-	? process.env.CORS_ALLOWED_ORIGINS.split(" ")
+	? process.env.CORS_ALLOWED_ORIGINS.split(' ')
-	: ["http://localhost:3001"];
+	: ['http://localhost:3001'];
 
 const corsOptions = {
 	origin: function (origin, callback) {
 		if (!origin || allowedOrigins.includes(origin)) {
 			callback(null, true);
 		} else {
-			callback(new Error("Not allowed by CORS"));
+			callback(new Error('Not allowed by CORS'));
 		}
 	},
-	methods: ["GET", "POST", "PUT", "DELETE", "PATCH"],
+	methods: ['GET', 'POST', 'PUT', 'DELETE', 'PATCH'],
-	allowedHeaders: "*",
+	allowedHeaders: '*',
 };
 
 app.use(cors(corsOptions));
 
-app.use("/api/departments", departmentRoutes);
+app.use('/api/departments', departmentRoutes);
-app.use("/api/auth", authRoutes);
+app.use('/api/auth', authRoutes);
-app.use("/api/blogs", blogRoutes);
+app.use('/api/blogs', blogRoutes);
-app.use("/uploads", express.static("uploads"));
+app.use('/uploads', express.static('uploads'));
-app.use("/api/upload", uploadRoutes);
+app.use('/api/upload', uploadRoutes);
-app.use("/api/doctors", doctorRoutes);
+app.use('/api/doctors', doctorRoutes);
-app.use("/api/careers", careerRoutes);
+app.use('/api/careers', careerRoutes);
-app.use("/api/candidates", candidateRoutes);
+app.use('/api/candidates', candidateRoutes);
-app.use("/api/appointments", appointmentRoutes);
+app.use('/api/appointments', appointmentRoutes);
-app.use("/api/inquiry", inquiryRoutes);
+app.use('/api/inquiry', inquiryRoutes);
-app.use("/api/academics", academicsResearchRoutes);
+app.use('/api/academics', academicsResearchRoutes);
-app.use("/api/email", emailConfigRoutes);
+app.use('/api/email', emailConfigRoutes);
-app.use("/api/newsMedia", newsMediaRoutes);
+app.use('/api/newsMedia', newsMediaRoutes);
-app.use("/api/import", importRoutes);
+app.use('/api/import', importRoutes);
+app.use('/api/health-check', healthCheckRoutes);
+app.use('/api/homepage-banners', homepageBannerRoutes);
+app.use('/api/insurance-partners', insurancePartnerRoutes);
+app.use('/api/accreditation', accreditationRoutes);
+app.use('/api/facilities', facilityRoutes);
+app.use('/api/google-reviews', gReviewRoutes);
 
 const PORT = process.env.PORT || 5008;
 app.listen(PORT, () => {

backend/src/controllers/academicsResearch.controller.js

@@ -1,18 +1,17 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
-import { sendEmail } from "../utils/sendEmail.js";
+import { sendEmail } from '../utils/sendEmail.js';
-import { getEmailsByType } from "../utils/getEmailByTypes.js";
+import { getEmailsByType } from '../utils/getEmailByTypes.js';
 
 // CREATE ACADEMICS & RESEARCH
 
 export const createAcademicsResearch = async (req, res) => {
 	try {
-		const { fullName, number, emailId, subject, courseName, message } =
+		const { fullName, number, emailId, subject, courseName, message } = req.body;
-			req.body;
 
 		if (!fullName || !number) {
 			return res.status(400).json({
 				success: false,
-				message: "Full name and number are required",
+				message: 'Full name and number are required',
 			});
 		}
 
@@ -28,42 +27,97 @@ export const createAcademicsResearch = async (req, res) => {
 		});
 
 		try {
-			const emailList = await getEmailsByType("ACADEMICS");
+			const emailList = await getEmailsByType('ACADEMICS');
 
 			if (emailList && emailList.length > 0) {
 				await sendEmail({
 					to: emailList,
-					subject: "New Academics & Research Inquiry",
+					subject: 'New Academics & Research Inquiry',
 					html: `
-						<h2>New Academics & Research Inquiry</h2>
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
 		  
-						<p><b>Name:</b> ${fullName}</p>
+		  <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);">
-						<p><b>Phone:</b> ${number}</p>
-						<p><b>Email:</b> ${emailId || "-"}</p>
 		    
-						<p><b>Course:</b> ${courseName || "-"}</p>
+		    <!-- Header -->
-						<p><b>Subject:</b> ${subject || "-"}</p>
+		    <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>
 
-						<p><b>Message:</b></p>
+		    <!-- Body -->
-						<p>${message || "-"}</p>
+		    <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);
+			console.error('Academics email failed:', err);
 		}
 
 		res.status(200).json({
 			success: true,
 			status: 200,
 			data,
-			message: "Academics & Research added successfully",
+			message: 'Academics & Research added successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to add Academics & Research inquiry",
+			message: 'Failed to add Academics & Research inquiry',
 		});
 	}
 };
@@ -74,7 +128,7 @@ export const getAcademicsResearch = async (req, res) => {
 	try {
 		const data = await prisma.academicsResearch.findMany({
 			orderBy: {
-				createdAt: "desc",
+				createdAt: 'desc',
 			},
 		});
 
@@ -85,7 +139,7 @@ export const getAcademicsResearch = async (req, res) => {
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch records",
+			message: 'Failed to fetch records',
 		});
 	}
 };
@@ -105,7 +159,7 @@ export const getSingleAcademicsResearch = async (req, res) => {
 		if (!data) {
 			return res.status(404).json({
 				success: false,
-				message: "Record not found",
+				message: 'Record not found',
 			});
 		}
 
@@ -116,7 +170,7 @@ export const getSingleAcademicsResearch = async (req, res) => {
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch record",
+			message: 'Failed to fetch record',
 		});
 	}
 };
@@ -135,12 +189,12 @@ export const deleteAcademicsResearch = async (req, res) => {
 
 		res.json({
 			success: true,
-			message: "Record deleted successfully",
+			message: 'Record deleted successfully',
 		});
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete record",
+			message: 'Failed to delete record',
 		});
 	}
 };

backend/src/controllers/accreditation.controller.js

@@ -0,0 +1,189 @@
+import prisma from '../prisma/client.js';
+
+export const createAccreditation = async (req, res) => {
+	try {
+		const { title, type, logo, image, description, sortOrder, isActive } = req.body;
+
+		if (!title || !type) {
+			return res.status(400).json({
+				success: false,
+				message: 'Title and type are required',
+			});
+		}
+
+		const accreditation = await prisma.accreditation.create({
+			data: {
+				title,
+				type,
+				logo,
+				image,
+				description,
+				sortOrder: sortOrder ? Number(sortOrder) : 1000,
+				isActive: isActive ?? true,
+			},
+		});
+
+		res.status(201).json({
+			success: true,
+			data: accreditation,
+			message: 'Accreditation created successfully',
+		});
+	} catch (error) {
+		console.error('PRISMA TRANSACTION ERROR:', error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to create accreditation',
+		});
+	}
+};
+
+export const getAccreditations = async (req, res) => {
+	try {
+		const { type } = req.query;
+
+		const accreditations = await prisma.accreditation.findMany({
+			where: type
+				? {
+						type,
+					}
+				: undefined,
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: accreditations,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch accreditations',
+		});
+	}
+};
+
+export const getActiveAccreditations = async (req, res) => {
+	try {
+		const { type } = req.query;
+
+		const accreditations = await prisma.accreditation.findMany({
+			where: {
+				isActive: true,
+				...(type && { type }),
+			},
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: accreditations,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch accreditations',
+		});
+	}
+};
+
+export const getAccreditation = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const accreditation = await prisma.accreditation.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!accreditation) {
+			return res.status(404).json({
+				success: false,
+				message: 'Accreditation not found',
+			});
+		}
+
+		res.json({
+			success: true,
+			data: accreditation,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch accreditation',
+		});
+	}
+};
+
+export const updateAccreditation = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const { title, type, logo, image, description, sortOrder, isActive } = req.body;
+
+		const updateData = {};
+
+		if (title !== undefined) updateData.title = title;
+		if (type !== undefined) updateData.type = type;
+		if (logo !== undefined) updateData.logo = logo;
+		if (image !== undefined) updateData.image = image;
+		if (description !== undefined) updateData.description = description;
+		if (sortOrder !== undefined) updateData.sortOrder = Number(sortOrder);
+		if (isActive !== undefined) updateData.isActive = isActive;
+
+		const accreditation = await prisma.accreditation.update({
+			where: {
+				id: Number(id),
+			},
+			data: updateData,
+		});
+
+		res.json({
+			success: true,
+			data: accreditation,
+			message: 'Accreditation updated successfully',
+		});
+	} catch (error) {
+		console.error('PRISMA TRANSACTION ERROR:', error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to update accreditation',
+		});
+	}
+};
+
+export const deleteAccreditation = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.accreditation.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.json({
+			success: true,
+			message: 'Accreditation deleted successfully',
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to delete accreditation',
+		});
+	}
+};

backend/src/controllers/appointment.controller.js

@@ -1,16 +1,15 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
-import { sendEmail } from "../utils/sendEmail.js";
+import { sendEmail } from '../utils/sendEmail.js';
-import { getEmailsByType } from "../utils/getEmailByTypes.js";
+import { getEmailsByType } from '../utils/getEmailByTypes.js';
 
 export const createAppointment = async (req, res) => {
 	try {
-		const { name, mobileNumber, email, message, date, doctorId, departmentId } =
+		const { name, mobileNumber, email, message, date, doctorId, departmentId } = req.body;
-			req.body;
 
 		if (!name || !mobileNumber || !doctorId || !departmentId || !date) {
 			return res.status(400).json({
 				success: false,
-				message: "Required fields missing",
+				message: 'Required fields missing',
 			});
 		}
 
@@ -31,38 +30,111 @@ export const createAppointment = async (req, res) => {
 		});
 
 		try {
-			const emailList = await getEmailsByType("APPOINTMENT");
+			const emailList = await getEmailsByType('APPOINTMENT');
 
 			if (emailList) {
 				await sendEmail({
 					to: emailList,
-					subject: "New Appointment Booked",
+					subject: 'New Appointment Booked',
 					html: `
-						<h2>New Appointment Booked</h2>
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
-						<p><b>Name:</b> ${name}</p>
+		  
-						<p><b>Phone:</b> ${mobileNumber}</p>
+		  <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);">
-						<p><b>Email:</b> ${email || "-"}</p>
+		    
-						<p><b>Doctor:</b> ${appointment.doctor?.name}</p>
+		    <!-- Header -->
-						<p><b>Department:</b> ${appointment.department?.name}</p>
+		    <div style="background-color: #0d6efd; color: #ffffff; padding: 20px;">
-						<p><b>Date:</b> ${new Date(date).toLocaleDateString()}</p>
+		      <h2 style="margin: 0;">GG Hospital</h2>
-						<p><b>Message:</b> ${message || "-"}</p>
+		      <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('en-GB', {
+						day: '2-digit',
+						month: 'long',
+						year: 'numeric',
+					})}
+					</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);
+			console.error('Email failed:', err);
 		}
 
 		res.status(201).json({
 			success: true,
-			message: "Appointment booked successfully",
+			message: 'Appointment booked successfully',
 			data: appointment,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to create appointment",
+			message: 'Failed to create appointment',
 		});
 	}
 };
@@ -74,46 +146,92 @@ export const getAppointments = async (req, res) => {
 		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 { date, startDate, endDate, search } = req.query;
 
 		const where = {};
 
-		if (date) {
+		const hasSingleDate = date && date.trim() !== '';
+
+		const hasRange = (startDate && startDate.trim() !== '') || (endDate && endDate.trim() !== '');
+
+		if (hasSingleDate) {
 			const start = new Date(date);
+			start.setHours(0, 0, 0, 0);
+
 			const end = new Date(date);
-			end.setDate(end.getDate() + 1);
+			end.setHours(23, 59, 59, 999);
-			where.date = { gte: start, lt: end };
+
+			where.date = {
+				gte: start,
+				lte: end,
+			};
 		}
 
-		if (search) {
+		if (!hasSingleDate && hasRange) {
+			const dateFilter = {};
+
+			if (startDate && startDate.trim() !== '') {
+				const start = new Date(startDate);
+				start.setHours(0, 0, 0, 0);
+
+				dateFilter.gte = start;
+			}
+
+			if (endDate && endDate.trim() !== '') {
+				const end = new Date(endDate);
+				end.setHours(23, 59, 59, 999);
+
+				dateFilter.lte = end;
+			}
+
+			where.date = dateFilter;
+		}
+
+		if (search && search.trim() !== '') {
 			where.OR = [
-				{ name: { contains: search, mode: "insensitive" } },
+				{ name: { contains: search, mode: 'insensitive' } },
 				{ mobileNumber: { contains: search } },
-				{ email: { contains: search, mode: "insensitive" } },
+				{ email: { contains: search, mode: 'insensitive' } },
 			];
 		}
 
 		const [appointments, total] = await Promise.all([
 			prisma.appointment.findMany({
 				where,
-				include: { doctor: true, department: true },
+				include: {
-				orderBy: { createdAt: "desc" },
+					doctor: true,
+					department: true,
+				},
+				orderBy: {
+					createdAt: 'desc',
+				},
 				skip,
 				take: limit,
 			}),
-			prisma.appointment.count({ where }),
+
+			prisma.appointment.count({
+				where,
+			}),
 		]);
 
 		res.status(200).json({
 			success: true,
 			data: appointments,
-			pagination: { total, page, limit, totalPages: Math.ceil(total / limit) },
+			pagination: {
+				total,
+				page,
+				limit,
+				totalPages: Math.ceil(total / limit),
+			},
 		});
 	} catch (error) {
 		console.error(error);
-		res
+
-			.status(500)
+		res.status(500).json({
-			.json({ success: false, message: "Failed to fetch appointments" });
+			success: false,
+			message: 'Failed to fetch appointments',
+		});
 	}
 };
 
@@ -136,7 +254,7 @@ export const getAppointment = async (req, res) => {
 		if (!appointment) {
 			return res.status(404).json({
 				success: false,
-				message: "Appointment not found",
+				message: 'Appointment not found',
 			});
 		}
 
@@ -148,7 +266,7 @@ export const getAppointment = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch appointment",
+			message: 'Failed to fetch appointment',
 		});
 	}
 };
@@ -168,7 +286,7 @@ export const getAppointmentsByDoctor = async (req, res) => {
 				department: true,
 			},
 			orderBy: {
-				date: "asc",
+				date: 'asc',
 			},
 		});
 
@@ -180,7 +298,7 @@ export const getAppointmentsByDoctor = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctor appointments",
+			message: 'Failed to fetch doctor appointments',
 		});
 	}
 };
@@ -209,7 +327,7 @@ export const getAppointmentsByDepartment = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch department appointments",
+			message: 'Failed to fetch department appointments',
 		});
 	}
 };
@@ -233,14 +351,14 @@ export const updateAppointment = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Appointment updated successfully",
+			message: 'Appointment updated successfully',
 			data: appointment,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to update appointment",
+			message: 'Failed to update appointment',
 		});
 	}
 };
@@ -259,13 +377,13 @@ export const deleteAppointment = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Appointment deleted successfully",
+			message: 'Appointment deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete appointment",
+			message: 'Failed to delete appointment',
 		});
 	}
 };

backend/src/controllers/auth.controller.js

@@ -1,24 +1,24 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
-import {generateToken} from "../utils/jwt.js";
+import { generateToken } from '../utils/jwt.js';
-import {hashPassword, comparePassword} from "../utils/password.js";
+import { hashPassword, comparePassword } from '../utils/password.js';
 
 /**
  * REGISTER
  * POST /api/auth/register
  */
 export async function register(req, res) {
-	const {username, password, role} = req.body;
+	const { username, password, role } = req.body;
 
 	if (!username || !password) {
-		return res.status(400).json({error: "Username and password required"});
+		return res.status(400).json({ error: 'Username and password required' });
 	}
 
 	const existingUser = await prisma.user.findUnique({
-		where: {username},
+		where: { username },
 	});
 
 	if (existingUser) {
-		return res.status(409).json({error: "Username already exists"});
+		return res.status(409).json({ error: 'Username already exists' });
 	}
 
 	const hashedPassword = await hashPassword(password);
@@ -27,12 +27,12 @@ export async function register(req, res) {
 		data: {
 			username,
 			password: hashedPassword,
-			role: role || "admin",
+			role: role || 'admin',
 		},
 	});
 
 	res.status(201).json({
-		message: "User registered successfully",
+		message: 'User registered successfully',
 		user: {
 			id: user.id,
 			username: user.username,
@@ -46,24 +46,24 @@ export async function register(req, res) {
  * POST /api/auth/login
  */
 export async function login(req, res) {
-	const {username, password} = req.body;
+	const { username, password } = req.body;
 
 	if (!username || !password) {
-		return res.status(400).json({error: "Username and password required"});
+		return res.status(400).json({ error: 'Username and password required' });
 	}
 
 	const user = await prisma.user.findUnique({
-		where: {username},
+		where: { username },
 	});
 
 	if (!user) {
-		return res.status(401).json({error: "Invalid credentials"});
+		return res.status(401).json({ error: 'Invalid credentials' });
 	}
 
 	const isValid = await comparePassword(password, user.password);
 
 	if (!isValid) {
-		return res.status(401).json({error: "Invalid credentials"});
+		return res.status(401).json({ error: 'Invalid credentials' });
 	}
 
 	const token = generateToken({
@@ -72,5 +72,5 @@ export async function login(req, res) {
 		role: user.role,
 	});
 
-	res.json({token});
+	res.json({ token });
 }

backend/src/controllers/blog.controller.js

@@ -1,10 +1,10 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
-import slugify from "slugify";
+import slugify from 'slugify';
 
 /* CREATE BLOG */
 
 export async function createBlog(req, res) {
-	const {title, writer, image, content, isActive} = req.body;
+	const { title, writer, image, content, isActive } = req.body;
 
 	try {
 		const blog = await prisma.blog.create({
@@ -20,7 +20,7 @@ export async function createBlog(req, res) {
 
 		res.json(blog);
 	} catch (error) {
-		res.status(500).json({error: "Blog creation failed"});
+		res.status(500).json({ error: 'Blog creation failed' });
 	}
 }
 
@@ -29,13 +29,13 @@ export async function createBlog(req, res) {
 export async function getBlogs(req, res) {
 	try {
 		const blogs = await prisma.blog.findMany({
-			where: {isActive: true},
+			where: { isActive: true },
-			orderBy: {createdAt: "desc"},
+			orderBy: { createdAt: 'desc' },
 		});
 
 		res.json(blogs);
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }
 
@@ -44,12 +44,12 @@ export async function getBlogs(req, res) {
 export async function getAllBlogs(req, res) {
 	try {
 		const blogs = await prisma.blog.findMany({
-			orderBy: {createdAt: "desc"},
+			orderBy: { createdAt: 'desc' },
 		});
 
 		res.json(blogs);
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }
 
@@ -60,16 +60,16 @@ export async function getBlog(req, res) {
 		const slug = req.params.slug;
 
 		const blog = await prisma.blog.findUnique({
-			where: {slug},
+			where: { slug },
 		});
 
 		if (!blog) {
-			return res.status(404).json({error: "Blog not found"});
+			return res.status(404).json({ error: 'Blog not found' });
 		}
 
 		res.json(blog);
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }
 
@@ -80,16 +80,16 @@ export async function getBlogForAdmin(req, res) {
 		const id = Number(req.params.id);
 
 		const blog = await prisma.blog.findUnique({
-			where: {id},
+			where: { id },
 		});
 
 		if (!blog) {
-			return res.status(404).json({error: "Blog not found"});
+			return res.status(404).json({ error: 'Blog not found' });
 		}
 
 		res.json(blog);
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }
 
@@ -97,10 +97,10 @@ export async function getBlogForAdmin(req, res) {
 
 export async function updateBlog(req, res) {
 	try {
-		const {title, writer, image, content} = req.body;
+		const { title, writer, image, content } = req.body;
 
 		const blog = await prisma.blog.update({
-			where: {id: Number(req.params.id)},
+			where: { id: Number(req.params.id) },
 			data: {
 				title,
 				writer,
@@ -111,7 +111,7 @@ export async function updateBlog(req, res) {
 
 		res.json(blog);
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }
 
@@ -122,11 +122,11 @@ export async function deleteBlog(req, res) {
 		const id = Number(req.params.id);
 
 		await prisma.blog.delete({
-			where: {id},
+			where: { id },
 		});
 
-		res.json({message: "Blog deleted successfully"});
+		res.json({ message: 'Blog deleted successfully' });
 	} catch (error) {
-		res.status(500).json({error: error.message});
+		res.status(500).json({ error: error.message });
 	}
 }

backend/src/controllers/candidate.controller.js

@@ -1,19 +1,18 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
-import { sendEmail } from "../utils/sendEmail.js";
+import { sendEmail } from '../utils/sendEmail.js';
-import { getEmailsByType } from "../utils/getEmailByTypes.js";
+import { getEmailsByType } from '../utils/getEmailByTypes.js';
 
 // CREATE CANDIDATE
 
 export const createCandidate = async (req, res) => {
 	try {
-		const { fullName, mobile, email, subject, coverLetter, careerId } =
+		const { fullName, mobile, email, subject, coverLetter, careerId } = req.body;
-			req.body;
 
 		if (!fullName || !mobile || !email || !careerId) {
 			return res.status(400).json({
 				success: false,
-				message: "Required fields missing",
+				message: 'Required fields missing',
 			});
 		}
 
@@ -32,42 +31,105 @@ export const createCandidate = async (req, res) => {
 		});
 
 		try {
-			const emailList = await getEmailsByType("CANDIDATE");
+			const emailList = await getEmailsByType('CANDIDATE');
 
 			if (emailList && emailList.length > 0) {
 				await sendEmail({
 					to: emailList,
-					subject: "New Job Application Received",
+					subject: 'New Job Application Received',
 					html: `
-						<h2>New Candidate Application</h2>
+		<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
 		  
-						<p><b>Name:</b> ${fullName}</p>
+		  <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);">
-						<p><b>Phone:</b> ${mobile}</p>
-						<p><b>Email:</b> ${email}</p>
 		    
-						<p><b>Applied For:</b> ${candidate.career?.post || "-"}</p>
+		    <!-- Header -->
-						<p><b>Designation:</b> ${candidate.career?.designation || "-"}</p>
+		    <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>
 
-						<p><b>Subject:</b> ${subject || "-"}</p>
+		    <!-- Body -->
-						<p><b>Cover Letter:</b></p>
+		    <div style="padding: 20px; color: #333;">
-						<p>${coverLetter || "-"}</p>
+		      
-					`,
+		      <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);
+			console.error('Candidate email failed:', err);
 		}
 
 		res.status(201).json({
 			success: true,
-			message: "Application submitted successfully",
+			message: 'Application submitted successfully',
 			data: candidate,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to create candidate",
+			message: 'Failed to create candidate',
 		});
 	}
 };
@@ -81,7 +143,7 @@ export const getCandidates = async (req, res) => {
 				career: true,
 			},
 			orderBy: {
-				createdAt: "desc",
+				createdAt: 'desc',
 			},
 		});
 
@@ -93,7 +155,7 @@ export const getCandidates = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch candidates",
+			message: 'Failed to fetch candidates',
 		});
 	}
 };
@@ -116,7 +178,7 @@ export const getCandidate = async (req, res) => {
 		if (!candidate) {
 			return res.status(404).json({
 				success: false,
-				message: "Candidate not found",
+				message: 'Candidate not found',
 			});
 		}
 
@@ -128,7 +190,7 @@ export const getCandidate = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch candidate",
+			message: 'Failed to fetch candidate',
 		});
 	}
 };
@@ -147,7 +209,7 @@ export const getCandidatesByCareer = async (req, res) => {
 				career: true,
 			},
 			orderBy: {
-				createdAt: "desc",
+				createdAt: 'desc',
 			},
 		});
 
@@ -159,7 +221,7 @@ export const getCandidatesByCareer = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch candidates",
+			message: 'Failed to fetch candidates',
 		});
 	}
 };
@@ -179,14 +241,14 @@ export const updateCandidate = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Candidate updated successfully",
+			message: 'Candidate updated successfully',
 			data: candidate,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to update candidate",
+			message: 'Failed to update candidate',
 		});
 	}
 };
@@ -205,13 +267,13 @@ export const deleteCandidate = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Candidate deleted successfully",
+			message: 'Candidate deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete candidate",
+			message: 'Failed to delete candidate',
 		});
 	}
 };

backend/src/controllers/career.controller.js

@@ -1,11 +1,14 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 // GET ALL CAREERS
 
 export const getAllCareers = async (req, res) => {
 	try {
+		const { admin } = req.query;
+
 		const careers = await prisma.career.findMany({
-			orderBy: {createdAt: "desc"},
+			where: admin === 'true' ? {} : { isActive: true },
+			orderBy: [{ sortOrder: 'asc' }, { createdAt: 'desc' }],
 		});
 
 		const response = careers.map((c) => ({
@@ -17,6 +20,8 @@ export const getAllCareers = async (req, res) => {
 			email: c.email,
 			number: c.number,
 			status: c.status,
+			isActive: c.isActive,
+			sortOrder: c.sortOrder,
 		}));
 
 		return res.status(200).json({
@@ -27,7 +32,7 @@ export const getAllCareers = async (req, res) => {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to fetch careers",
+			message: 'Failed to fetch careers',
 		});
 	}
 };
@@ -36,20 +41,12 @@ export const getAllCareers = async (req, res) => {
 
 export const createCareer = async (req, res) => {
 	try {
-		const {
+		const { post, designation, qualification, experienceNeed, email, number, status, isActive, sortOrder } = req.body;
-			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",
+				message: 'Post and designation are required',
 			});
 		}
 
@@ -62,19 +59,21 @@ export const createCareer = async (req, res) => {
 				email,
 				number,
 				status,
+				isActive: isActive !== undefined ? isActive : true,
+				sortOrder: sortOrder !== undefined ? Number(sortOrder) : 0,
 			},
 		});
 
 		return res.status(201).json({
 			success: true,
-			message: "Career created successfully",
+			message: 'Career created successfully',
 			data: career,
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to create career",
+			message: 'Failed to create career',
 		});
 	}
 };
@@ -83,23 +82,28 @@ export const createCareer = async (req, res) => {
 
 export const updateCareer = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
+		const updateData = { ...req.body };
+
+		if (updateData.sortOrder !== undefined) {
+			updateData.sortOrder = Number(updateData.sortOrder);
+		}
 
 		const career = await prisma.career.update({
-			where: {id: Number(id)},
+			where: { id: Number(id) },
-			data: req.body,
+			data: updateData,
 		});
 
 		return res.status(200).json({
 			success: true,
-			message: "Career updated successfully",
+			message: 'Career updated successfully',
 			data: career,
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to update career",
+			message: 'Failed to update career',
 		});
 	}
 };
@@ -108,21 +112,21 @@ export const updateCareer = async (req, res) => {
 
 export const deleteCareer = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		await prisma.career.delete({
-			where: {id: Number(id)},
+			where: { id: Number(id) },
 		});
 
 		return res.status(200).json({
 			success: true,
-			message: "Career deleted successfully",
+			message: 'Career deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to delete career",
+			message: 'Failed to delete career',
 		});
 	}
 };

backend/src/controllers/department.controller.js

@@ -1,20 +1,25 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 export const getAllDepartments = async (req, res) => {
 	try {
+		const { admin } = req.query;
+
 		const departments = await prisma.department.findMany({
-			orderBy: {name: "asc"},
+			where: admin === 'true' ? {} : { isActive: true },
+			orderBy: [{ sortOrder: 'asc' }, { name: 'asc' }],
 		});
 
 		const response = departments.map((dep) => ({
 			departmentId: dep.departmentId,
 			name: dep.name,
-			image: dep.image ?? "",
+			image: dep.image ?? '',
-			para1: dep.para1 ?? "",
+			para1: dep.para1 ?? '',
-			para2: dep.para2 ?? "",
+			para2: dep.para2 ?? '',
-			para3: dep.para3 ?? "",
+			para3: dep.para3 ?? '',
-			facilities: dep.facilities ?? "",
+			facilities: dep.facilities ?? '',
-			services: dep.services ?? "",
+			services: dep.services ?? '',
+			isActive: dep.isActive,
+			sortOrder: dep.sortOrder,
 		}));
 
 		return res.status(200).json({
@@ -25,44 +30,47 @@ export const getAllDepartments = async (req, res) => {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to fetch departments",
+			message: 'Failed to fetch departments',
 		});
 	}
 };
 
 export const getDepartmentByName = async (req, res) => {
 	try {
-		const {name} = req.query;
+		const { name } = req.query;
 
 		if (!name) {
 			return res.status(400).json({
 				success: false,
-				message: "Department name is required",
+				message: 'Department name is required',
 			});
 		}
 
 		const department = await prisma.department.findFirst({
 			where: {
 				name: name,
+				isActive: true,
 			},
 		});
 
 		if (!department) {
 			return res.status(404).json({
 				success: false,
-				message: "Department not found",
+				message: 'Department not found or inactive',
 			});
 		}
 
 		const response = {
 			departmentId: department.departmentId,
 			name: department.name,
-			image: department.image ?? "",
+			image: department.image ?? '',
-			para1: department.para1 ?? "",
+			para1: department.para1 ?? '',
-			para2: department.para2 ?? "",
+			para2: department.para2 ?? '',
-			para3: department.para3 ?? "",
+			para3: department.para3 ?? '',
-			facilities: department.facilities ?? "",
+			facilities: department.facilities ?? '',
-			services: department.services ?? "",
+			services: department.services ?? '',
+			isActive: department.isActive,
+			sortOrder: department.sortOrder,
 		};
 
 		return res.status(200).json({
@@ -73,28 +81,17 @@ export const getDepartmentByName = async (req, res) => {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to fetch department",
+			message: 'Failed to fetch department',
 		});
 	}
 };
 
 export async function createDepartment(req, res) {
 	try {
-		const {
+		const { departmentId, name, image, para1, para2, para3, facilities, services, isActive, sortOrder } = req.body;
-			departmentId,
-			name,
-			image,
-			para1,
-			para2,
-			para3,
-			facilities,
-			services,
-		} = req.body;
 
 		if (!departmentId || !name) {
-			return res
+			return res.status(400).json({ error: 'departmentId and name are required' });
-				.status(400)
-				.json({error: "departmentId and name are required"});
 		}
 
 		const department = await prisma.department.create({
@@ -107,72 +104,69 @@ export async function createDepartment(req, res) {
 				para3,
 				facilities,
 				services,
+				isActive: isActive !== undefined ? isActive : true,
+				sortOrder: sortOrder !== undefined ? Number(sortOrder) : 0,
 			},
 		});
 
 		res.status(201).json({
-			message: "Department created successfully",
+			message: 'Department created successfully',
 			data: department,
 		});
 	} catch (error) {
-		if (error.code === "P2002") {
+		if (error.code === 'P2002') {
-			return res.status(409).json({error: "Department already exists"});
+			return res.status(409).json({ error: 'Department already exists' });
 		}
-
+		console.error(error);
-		res.status(500).json({error: "Failed to create department"});
+		res.status(500).json({ error: 'Failed to create department' });
 	}
 }
 
 export const updateDepartment = async (req, res) => {
 	try {
-		const {departmentId} = req.params;
+		const { departmentId } = req.params;
+		const updateData = { ...req.body };
 
-		const {name, image, para1, para2, para3, facilities, services} = req.body;
+		if (updateData.sortOrder !== undefined) {
+			updateData.sortOrder = Number(updateData.sortOrder);
+		}
 
 		const department = await prisma.department.update({
-			where: {departmentId},
+			where: { departmentId },
-			data: {
+			data: updateData,
-				name,
-				image,
-				para1,
-				para2,
-				para3,
-				facilities,
-				services,
-			},
 		});
 
 		return res.status(200).json({
 			success: true,
-			message: "Department updated successfully",
+			message: 'Department updated successfully',
 			data: department,
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to update department",
+			message: 'Failed to update department',
 		});
 	}
 };
 
 export const deleteDepartment = async (req, res) => {
 	try {
-		const {departmentId} = req.params;
+		const { departmentId } = req.params;
 
 		await prisma.department.delete({
-			where: {departmentId},
+			where: { departmentId },
 		});
 
 		return res.status(200).json({
 			success: true,
-			message: "Department deleted successfully",
+			message: 'Department deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to delete department",
+			message: 'Failed to delete department',
 		});
 	}
 };

backend/src/controllers/doctor.controller.js

@@ -1,33 +1,61 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 // get doctors
 
 export const getAllDoctors = async (req, res) => {
 	try {
+		const { admin } = req.query;
+
 		const doctors = await prisma.doctor.findMany({
+			where: admin === 'true' ? {} : { isActive: true },
 			include: {
+				seo: true,
 				departments: {
 					include: {
 						department: true,
 						timing: true,
 					},
 				},
+				specializations: {
+					orderBy: {
+						createdAt: 'asc',
+					},
+				},
 			},
-			orderBy: {name: "asc"},
+			orderBy: [{ globalSortOrder: 'asc' }, { name: 'asc' }],
 		});
 
 		const formatted = doctors.map((doc, index) => ({
 			SL_NO: String(index + 1),
 			doctorId: doc.doctorId,
 			name: doc.name,
-			image: doc.image ?? "",
+			image: doc.image ?? '',
 			designation: doc.designation,
 			workingStatus: doc.workingStatus,
 			qualification: doc.qualification,
+			isActive: doc.isActive,
+			isFeatured: doc.isFeatured,
+			experience: doc.experience,
+			professionalSummary: doc.professionalSummary,
+			globalSortOrder: doc.globalSortOrder,
+			specializations: doc.specializations.map((item) => ({
+				id: item.id,
+				name: item.name,
+				description: item.description,
+			})),
+			seo: {
+				seoTitle: doc.seo?.seoTitle ?? '',
+				metaDescription: doc.seo?.metaDescription ?? '',
+				focusKeyphrase: doc.seo?.focusKeyphrase ?? '',
+				slug: doc.seo?.slug ?? '',
+				tags: doc.seo?.tags ?? [],
 
+				ogTitle: doc.seo?.ogTitle ?? '',
+				ogDescription: doc.seo?.ogDescription ?? '',
+				ogImage: doc.seo?.ogImage ?? '',
+			},
 			departments: doc.departments.map((d) => {
 				const t = d.timing || {};
-
 				const timingArray = [
 					t.monday && `Monday ${t.monday}`,
 					t.tuesday && `Tuesday ${t.tuesday}`,
@@ -42,7 +70,8 @@ export const getAllDoctors = async (req, res) => {
 				return {
 					departmentId: d.department.departmentId,
 					departmentName: d.department.name,
-					timing: timingArray.join(" & "),
+					timing: timingArray.join(' & '),
+					deptSortOrder: d.sortOrder,
 				};
 			}),
 		}));
@@ -55,7 +84,7 @@ export const getAllDoctors = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctors",
+			message: 'Failed to fetch doctors',
 		});
 	}
 };
@@ -64,11 +93,17 @@ export const getAllDoctors = async (req, res) => {
 
 export const getDoctorByDoctorId = async (req, res) => {
 	try {
-		const {doctorId} = req.params;
+		const { doctorId } = req.params;
+		const { admin } = req.query;
 
-		const doctor = await prisma.doctor.findUnique({
+		const doctor = await prisma.doctor.findFirst({
-			where: {doctorId},
+			where: {
+				doctorId,
+				...(admin === 'true' ? {} : { isActive: true }),
+			},
 			include: {
+				seo: true,
+				specializations: true,
 				departments: {
 					include: {
 						department: true,
@@ -81,17 +116,37 @@ export const getDoctorByDoctorId = async (req, res) => {
 		if (!doctor) {
 			return res.status(404).json({
 				success: false,
-				message: "Doctor not found",
+				message: 'Doctor not found',
 			});
 		}
 
 		const response = {
 			doctorId: doctor.doctorId,
 			name: doctor.name,
-			image: doctor.image ?? "",
+			image: doctor.image ?? '',
 			designation: doctor.designation,
 			workingStatus: doctor.workingStatus,
 			qualification: doctor.qualification,
+			experience: doctor.experience,
+			professionalSummary: doctor.professionalSummary,
+			isActive: doctor.isActive,
+			isFeatured: doctor.isFeatured,
+			seo: {
+				seoTitle: doctor.seo?.seoTitle ?? '',
+				metaDescription: doctor.seo?.metaDescription ?? '',
+				focusKeyphrase: doctor.seo?.focusKeyphrase ?? '',
+				slug: doctor.seo?.slug ?? '',
+				tags: doctor.seo?.tags ?? [],
+				ogTitle: doctor.seo?.ogTitle ?? '',
+				ogDescription: doctor.seo?.ogDescription ?? '',
+				ogImage: doctor.seo?.ogImage ?? '',
+			},
+			specializations:
+				doctor.specializations?.map((item) => ({
+					id: item.id,
+					name: item.name,
+					description: item.description,
+				})) ?? [],
 			departments: doctor.departments.map((d) => ({
 				departmentId: d.department.departmentId,
 				departmentName: d.department.name,
@@ -107,7 +162,7 @@ export const getDoctorByDoctorId = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctor",
+			message: 'Failed to fetch doctor',
 		});
 	}
 };
@@ -115,37 +170,52 @@ export const getDoctorByDoctorId = async (req, res) => {
 // get doctors by department
 export const getDoctorsByDepartmentId = async (req, res) => {
 	try {
-		const {Department_ID} = req.query;
+		const { Department_ID } = req.query;
 
 		if (!Department_ID) {
 			return res.status(400).json({
 				success: false,
-				message: "Department_ID is required",
+				message: 'Department_ID is required',
 			});
 		}
 
 		const department = await prisma.department.findUnique({
-			where: {departmentId: Department_ID},
+			where: { departmentId: Department_ID },
 		});
 
 		if (!department) {
 			return res.status(404).json({
 				success: false,
-				message: "Department not found",
+				message: 'Department not found',
 			});
 		}
 
-		const doctors = await prisma.doctorDepartment.findMany({
+		const doctorsInDept = await prisma.doctorDepartment.findMany({
-			where: {departmentId: department.id},
+			where: {
-			include: {
+				departmentId: department.id,
-				doctor: true,
+				doctor: { isActive: true },
 			},
+			include: {
+				doctor: {
+					include: {
+						seo: {
+							select: {
+								slug: true,
+							},
+						},
+					},
+				},
+			},
+			orderBy: { sortOrder: 'asc' },
 		});
 
-		const result = doctors.map((d) => ({
+		const result = doctorsInDept.map((d) => ({
 			GG_ID: d.doctor.doctorId,
 			Name: d.doctor.name,
-			image: d.doctor.image ?? "",
+			image: d.doctor.image ?? '',
+			designation: d.doctor.designation,
+			hierarchyOrder: d.sortOrder,
+			slug: d.doctor.seo?.slug ?? '',
 		}));
 
 		res.status(200).json({
@@ -156,7 +226,7 @@ export const getDoctorsByDepartmentId = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctors",
+			message: 'Failed to fetch doctors',
 		});
 	}
 };
@@ -171,8 +241,52 @@ export const createDoctor = async (req, res) => {
 			designation,
 			workingStatus,
 			qualification,
+			isActive,
+			isFeatured,
+			globalSortOrder,
 			departments,
+			experience,
+			professionalSummary,
+			seoTitle,
+			metaDescription,
+			focusKeyphrase,
+			slug,
+			tags,
+			specializations,
+			ogTitle,
+			ogDescription,
+			ogImage,
 		} = req.body;
+		const messages = [];
+
+		if (!doctorId) messages.push('Doctor ID is required');
+		if (!name?.trim()) messages.push('Doctor name is required');
+		if (!designation?.trim()) messages.push('Designation is required');
+		if (!qualification?.trim()) messages.push('Qualification is required');
+		if (!departments || departments.length === 0) {
+			messages.push('At least one department is required');
+		}
+
+		if (messages.length > 0) {
+			return res.status(400).json({
+				success: false,
+				message: messages.join(', '),
+			});
+		}
+		const seo = await prisma.seo.create({
+			data: {
+				seoTitle,
+				metaDescription,
+				focusKeyphrase,
+				slug: slug ? slug : null,
+				tags: tags || [],
+
+				// Open Graph
+				ogTitle,
+				ogDescription,
+				ogImage,
+			},
+		});
 
 		const doctor = await prisma.doctor.create({
 			data: {
@@ -182,12 +296,18 @@ export const createDoctor = async (req, res) => {
 				designation,
 				workingStatus,
 				qualification,
+				experience: experience ? Number(experience) : null,
+				professionalSummary,
+				seoId: seo.id,
+				isActive: isActive !== undefined ? isActive : true,
+				isFeatured: isFeatured !== undefined ? isFeatured : false,
+				globalSortOrder: globalSortOrder !== undefined ? Number(globalSortOrder) : 0,
 			},
 		});
 
 		for (const dep of departments) {
 			const department = await prisma.department.findUnique({
-				where: {departmentId: dep.departmentId},
+				where: { departmentId: dep.departmentId },
 			});
 
 			if (!department) continue;
@@ -196,6 +316,7 @@ export const createDoctor = async (req, res) => {
 				data: {
 					doctorId: doctor.id,
 					departmentId: department.id,
+					sortOrder: dep.sortOrder !== undefined ? Number(dep.sortOrder) : 0,
 				},
 			});
 
@@ -208,16 +329,27 @@ export const createDoctor = async (req, res) => {
 				});
 			}
 		}
+		if (specializations?.length) {
+			await prisma.doctorSpecialization.createMany({
+				data: specializations
+					.filter((item) => item.name?.trim())
+					.map((item) => ({
+						name: item.name.trim(),
+						description: item.description?.trim() || null,
+						doctorId: doctor.id,
+					})),
+			});
+		}
 
 		res.status(201).json({
 			success: true,
-			message: "Doctor created successfully",
+			message: 'Doctor created successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to create doctor",
+			message: 'Failed to create doctor',
 		});
 	}
 };
@@ -225,124 +357,269 @@ export const createDoctor = async (req, res) => {
 //update doctors
 export const updateDoctor = async (req, res) => {
 	try {
-		const {doctorId} = req.params;
+		const { doctorId, action } = req.params;
 		const {
 			name,
 			designation,
 			image,
 			workingStatus,
 			qualification,
+			isActive,
+			isFeatured,
+			globalSortOrder,
 			departments,
+			experience,
+			professionalSummary,
+			seoTitle,
+			metaDescription,
+			ogTitle,
+			ogDescription,
+			focusKeyphrase,
+			slug,
+			tags,
+			ogImage,
+			specializations,
 		} = req.body;
 
-		const doctor = await prisma.doctor.findUnique({
+		if (!doctorId) {
-			where: {doctorId},
+			return res.status(400).json({
-		});
+				success: false,
-
+				message: 'Doctor ID is required',
-		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},
 			});
 		}
-
+		const doctor = await prisma.doctor.findUnique({ where: { doctorId } });
-		await prisma.doctorDepartment.deleteMany({
+		if (!doctor) return res.status(404).json({ success: false, message: 'Doctor not found' });
-			where: {doctorId: doctor.id},
+		if (action === 'toggleStatus') {
-		});
+			await prisma.doctor.update({
-
+				where: { id: 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,
+					isActive: !doctor.isActive,
-					departmentId: department.id,
 				},
 			});
 
-			if (dep.timing) {
+			return res.status(200).json({
-				const {id, doctorDepartmentId, createdAt, updatedAt, ...cleanTiming} =
+				success: true,
-					dep.timing;
+				message: `Doctor has been ${doctor.isActive ? 'deactivated' : 'activated'} successfully`,
+			});
+		}
+		if (action === 'toggleFeatured') {
+			await prisma.doctor.update({
+				where: { id: doctor.id },
+				data: {
+					isFeatured: !doctor.isFeatured,
+				},
+			});
 
-				await prisma.doctorTiming.create({
+			return res.status(200).json({
-					data: {
+				success: true,
-						doctorDepartmentId: doctorDepartment.id,
+				message: `Doctor has been ${doctor.isFeatured ? 'removed from featured' : 'marked as featured'} successfully`,
-						...cleanTiming,
+			});
+		}
+
+		const messages = [];
+		if (!doctorId) messages.push('Doctor ID is required');
+		if (!name?.trim()) messages.push('Doctor name is required');
+		if (!qualification?.trim()) messages.push('Qualification is required');
+		if (!designation?.trim()) messages.push('Designation is required');
+
+		if (!departments || departments.length === 0) {
+			messages.push('At least one department is required');
+		}
+
+		if (messages.length > 0) {
+			return res.status(400).json({
+				success: false,
+				message: messages.join(', '),
+			});
+		}
+
+		await prisma.doctor.update({
+			where: { id: doctor.id },
+			data: {
+				name,
+				designation,
+				image,
+				workingStatus,
+				qualification,
+				isActive: isActive !== undefined ? isActive : undefined,
+				isFeatured: isFeatured !== undefined ? isFeatured : undefined,
+				experience: experience ? Number(experience) : null,
+				professionalSummary,
+				globalSortOrder: globalSortOrder !== undefined ? Number(globalSortOrder) : undefined,
+			},
+		});
+
+		if (doctor.seoId) {
+			await prisma.seo.update({
+				where: {
+					id: doctor.seoId,
+				},
+				data: {
+					seoTitle,
+					metaDescription,
+					ogTitle,
+					ogDescription,
+					ogImage,
+					focusKeyphrase,
+					slug: slug ? slug : null,
+					tags: tags || [],
+				},
+			});
+		} else {
+			const seo = await prisma.seo.create({
+				data: {
+					ogImage,
+					metaDescription,
+					seoTitle,
+					ogDescription,
+					ogTitle,
+					focusKeyphrase,
+					slug: slug ? slug : null,
+					tags: tags || [],
+				},
+			});
+
+			await prisma.doctor.update({
+				where: {
+					id: doctor.id,
+				},
+				data: {
+					seoId: seo.id,
+				},
+			});
+		}
+
+		// Update Departments & Timings
+		if (Array.isArray(departments)) {
+			const oldRelations = await prisma.doctorDepartment.findMany({
+				where: {
+					doctorId: doctor.id,
+				},
+				include: {
+					timing: true,
+				},
+			});
+
+			// Delete old timings
+			for (const rel of oldRelations) {
+				if (rel.timing) {
+					await prisma.doctorTiming.deleteMany({
+						where: {
+							doctorDepartmentId: rel.id,
+						},
+					});
+				}
+			}
+
+			// Delete old departments
+			await prisma.doctorDepartment.deleteMany({
+				where: {
+					doctorId: doctor.id,
+				},
+			});
+
+			// Recreate departments + timings
+			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,
+						sortOrder: dep.sortOrder !== undefined ? Number(dep.sortOrder) : 0,
+					},
+				});
+
+				if (dep.timing && Object.keys(dep.timing).length > 0) {
+					const { id, doctorDepartmentId, createdAt, updatedAt, ...cleanTiming } = dep.timing;
+
+					await prisma.doctorTiming.create({
+						data: {
+							doctorDepartmentId: doctorDepartment.id,
+							...cleanTiming,
+						},
+					});
+				}
+			}
+		}
+
+		// Update Specializations
+		if (Array.isArray(specializations)) {
+			await prisma.doctorSpecialization.deleteMany({
+				where: {
+					doctorId: doctor.id,
+				},
+			});
+
+			if (specializations.length) {
+				await prisma.doctorSpecialization.createMany({
+					data: specializations
+						.filter((item) => item.name?.trim())
+						.map((item) => ({
+							name: item.name.trim(),
+							description: item.description?.trim() || null,
+							doctorId: doctor.id,
+						})),
+				});
 			}
 		}
 
-		res
+		res.status(200).json({ success: true, message: 'Doctor updated successfully' });
-			.status(200)
-			.json({success: true, message: "Doctor updated successfully"});
 	} catch (error) {
-		console.error("Update Error:", error);
+		console.error('Update Error:', error);
-		res.status(500).json({success: false, message: "Failed to update doctor"});
+		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 { doctorId } = req.params;
 
 		const doctor = await prisma.doctor.findUnique({
-			where: {doctorId},
+			where: { doctorId },
 		});
 
 		if (!doctor) {
 			return res.status(404).json({
 				success: false,
-				message: "Doctor not found",
+				message: 'Doctor not found',
 			});
 		}
 
 		const doctorDepartments = await prisma.doctorDepartment.findMany({
-			where: {doctorId: doctor.id},
+			where: { doctorId: doctor.id },
 		});
 
 		for (const dd of doctorDepartments) {
 			await prisma.doctorTiming.deleteMany({
-				where: {doctorDepartmentId: dd.id},
+				where: { doctorDepartmentId: dd.id },
 			});
 		}
 
 		await prisma.doctorDepartment.deleteMany({
-			where: {doctorId: doctor.id},
+			where: { doctorId: doctor.id },
 		});
 
 		await prisma.doctor.delete({
-			where: {id: doctor.id},
+			where: { id: doctor.id },
 		});
 
 		res.status(200).json({
 			success: true,
-			message: "Doctor deleted successfully",
+			message: 'Doctor deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete doctor",
+			message: 'Failed to delete doctor',
 		});
 	}
 };
@@ -367,14 +644,14 @@ export const getDoctorTimings = async (req, res) => {
 			return {
 				Doctor_ID: doc.doctorId,
 				Doctor: doc.name,
-				Monday: timing.monday || "",
+				Monday: timing.monday || '',
-				Tuesday: timing.tuesday || "",
+				Tuesday: timing.tuesday || '',
-				Wednesday: timing.wednesday || "",
+				Wednesday: timing.wednesday || '',
-				Thursday: timing.thursday || "",
+				Thursday: timing.thursday || '',
-				Friday: timing.friday || "",
+				Friday: timing.friday || '',
-				Saturday: timing.saturday || "",
+				Saturday: timing.saturday || '',
-				Sunday: timing.sunday || "",
+				Sunday: timing.sunday || '',
-				Additional: timing.additional || "",
+				Additional: timing.additional || '',
 			};
 		});
 
@@ -386,7 +663,7 @@ export const getDoctorTimings = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctor timings",
+			message: 'Failed to fetch doctor timings',
 		});
 	}
 };
@@ -394,10 +671,14 @@ export const getDoctorTimings = async (req, res) => {
 
 export const getDoctorTimingById = async (req, res) => {
 	try {
-		const {doctorId} = req.params;
+		const { doctorId } = req.params;
+		const { admin } = req.query;
 
-		const doctor = await prisma.doctor.findUnique({
+		const doctor = await prisma.doctor.findFirst({
-			where: {doctorId},
+			where: {
+				doctorId,
+				...(admin === 'true' ? {} : { isActive: true }),
+			},
 			include: {
 				departments: {
 					include: {
@@ -411,7 +692,7 @@ export const getDoctorTimingById = async (req, res) => {
 		if (!doctor) {
 			return res.status(404).json({
 				success: false,
-				message: "Doctor not found",
+				message: 'Doctor not found',
 			});
 		}
 
@@ -421,6 +702,7 @@ export const getDoctorTimingById = async (req, res) => {
 			departments: doctor.departments.map((d) => ({
 				departmentId: d.department.departmentId,
 				departmentName: d.department.name,
+				deptSortOrder: d.sortOrder,
 				timing: d.timing || {},
 			})),
 		};
@@ -433,7 +715,56 @@ export const getDoctorTimingById = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch doctor timing",
+			message: 'Failed to fetch doctor timing',
+		});
+	}
+};
+
+export const getFeaturedDoctors = async (req, res) => {
+	try {
+		const doctors = await prisma.doctor.findMany({
+			where: {
+				isActive: true,
+				isFeatured: true,
+			},
+			include: {
+				seo: {
+					select: {
+						slug: true,
+					},
+				},
+				departments: {
+					include: {
+						department: true,
+					},
+				},
+			},
+			orderBy: [{ globalSortOrder: 'asc' }, { name: 'asc' }],
+		});
+
+		const data = doctors.map((doc) => ({
+			doctorId: doc.doctorId,
+			name: doc.name,
+			image: doc.image ?? '',
+			designation: doc.designation,
+			qualification: doc.qualification,
+			experience: doc.experience,
+			slug: doc.seo?.slug ?? '',
+			departments: doc.departments.map((d) => ({
+				departmentId: d.department.departmentId,
+				departmentName: d.department.name,
+			})),
+		}));
+
+		res.status(200).json({
+			success: true,
+			data,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch featured doctors',
 		});
 	}
 };

backend/src/controllers/emailConfig.controller.js

@@ -1,14 +1,14 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 // CREATE
 export const createEmailConfig = async (req, res) => {
 	try {
-		const {name, email, type, isActive} = req.body;
+		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",
+				message: 'Name, Email and Type are required',
 			});
 		}
 
@@ -23,14 +23,14 @@ export const createEmailConfig = async (req, res) => {
 
 		res.status(201).json({
 			success: true,
-			message: "Email config created",
+			message: 'Email config created',
 			data: newEmail,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to create email config",
+			message: 'Failed to create email config',
 		});
 	}
 };
@@ -40,7 +40,7 @@ export const getEmailConfigs = async (req, res) => {
 	try {
 		const emails = await prisma.emailConfig.findMany({
 			orderBy: {
-				createdAt: "desc",
+				createdAt: 'desc',
 			},
 		});
 
@@ -52,7 +52,7 @@ export const getEmailConfigs = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch email configs",
+			message: 'Failed to fetch email configs',
 		});
 	}
 };
@@ -60,7 +60,7 @@ export const getEmailConfigs = async (req, res) => {
 // GET SINGLE
 export const getEmailConfig = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		const email = await prisma.emailConfig.findUnique({
 			where: {
@@ -71,7 +71,7 @@ export const getEmailConfig = async (req, res) => {
 		if (!email) {
 			return res.status(404).json({
 				success: false,
-				message: "Email config not found",
+				message: 'Email config not found',
 			});
 		}
 
@@ -83,7 +83,7 @@ export const getEmailConfig = async (req, res) => {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch email config",
+			message: 'Failed to fetch email config',
 		});
 	}
 };
@@ -91,7 +91,7 @@ export const getEmailConfig = async (req, res) => {
 // UPDATE
 export const updateEmailConfig = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		const updated = await prisma.emailConfig.update({
 			where: {
@@ -102,14 +102,14 @@ export const updateEmailConfig = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Email config updated",
+			message: 'Email config updated',
 			data: updated,
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to update email config",
+			message: 'Failed to update email config',
 		});
 	}
 };
@@ -117,7 +117,7 @@ export const updateEmailConfig = async (req, res) => {
 // DELETE
 export const deleteEmailConfig = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		await prisma.emailConfig.delete({
 			where: {
@@ -127,13 +127,13 @@ export const deleteEmailConfig = async (req, res) => {
 
 		res.status(200).json({
 			success: true,
-			message: "Email config deleted",
+			message: 'Email config deleted',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete email config",
+			message: 'Failed to delete email config',
 		});
 	}
 };

backend/src/controllers/facility.controller.js

@@ -0,0 +1,421 @@
+import prisma from '../prisma/client.js';
+
+export const getAllFacilities = async (req, res) => {
+	try {
+		const { admin } = req.query;
+
+		const facilities = await prisma.facility.findMany({
+			where: admin === 'true' ? {} : { isActive: true },
+			include: {
+				seo: true,
+				department: true,
+				images: true,
+			},
+			orderBy: [{ sortOrder: 'asc' }, { name: 'asc' }],
+		});
+
+		const formatted = facilities.map((fac, index) => ({
+			SL_NO: String(index + 1),
+			id: fac.id,
+			facilityId: fac.facilityId,
+			name: fac.name,
+			slug: fac.slug,
+			shortDescription: fac.shortDescription,
+			description: fac.description,
+			videoUrl: fac.videoUrl ?? '',
+			isActive: fac.isActive,
+			isFeatured: fac.isFeatured,
+			sortOrder: fac.sortOrder,
+			department: fac.department
+				? {
+						id: fac.department.id,
+						departmentId: fac.department.departmentId,
+						name: fac.department.name,
+					}
+				: null,
+			images: fac.images.map((img) => ({
+				id: img.id,
+				url: img.url,
+				altText: img.altText ?? '',
+				description: img.description ?? '',
+			})),
+			seo: {
+				seoTitle: fac.seo?.seoTitle ?? '',
+				metaDescription: fac.seo?.metaDescription ?? '',
+				focusKeyphrase: fac.seo?.focusKeyphrase ?? '',
+				slug: fac.seo?.slug ?? '',
+				tags: fac.seo?.tags ?? [],
+				ogTitle: fac.seo?.ogTitle ?? '',
+				ogDescription: fac.seo?.ogDescription ?? '',
+				ogImage: fac.seo?.ogImage ?? '',
+			},
+		}));
+
+		res.status(200).json({
+			success: true,
+			data: formatted,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch facilities',
+		});
+	}
+};
+
+export const getFacilityByFacilityId = async (req, res) => {
+	try {
+		const { facilityId } = req.params;
+		const { admin } = req.query;
+
+		const facility = await prisma.facility.findFirst({
+			where: {
+				facilityId,
+				...(admin === 'true' ? {} : { isActive: true }),
+			},
+			include: {
+				seo: true,
+				department: true,
+				images: true,
+			},
+		});
+
+		if (!facility) {
+			return res.status(404).json({
+				success: false,
+				message: 'Facility not found',
+			});
+		}
+
+		const response = {
+			facilityId: facility.facilityId,
+			name: facility.name,
+			slug: facility.slug,
+			shortDescription: facility.shortDescription,
+			description: facility.description,
+			videoUrl: facility.videoUrl ?? '',
+			isActive: facility.isActive,
+			isFeatured: facility.isFeatured,
+			sortOrder: facility.sortOrder,
+			department: facility.department
+				? {
+						departmentId: facility.department.departmentId,
+						name: facility.department.name,
+					}
+				: null,
+			images: facility.images.map((img) => ({
+				id: img.id,
+				url: img.url,
+				altText: img.altText ?? '',
+				description: img.description ?? '',
+			})),
+			seo: {
+				seoTitle: facility.seo?.seoTitle ?? '',
+				metaDescription: facility.seo?.metaDescription ?? '',
+				focusKeyphrase: facility.seo?.focusKeyphrase ?? '',
+				slug: facility.seo?.slug ?? '',
+				tags: facility.seo?.tags ?? [],
+				ogTitle: facility.seo?.ogTitle ?? '',
+				ogDescription: facility.seo?.ogDescription ?? '',
+				ogImage: facility.seo?.ogImage ?? '',
+			},
+		};
+
+		res.status(200).json({
+			success: true,
+			data: response,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch facility',
+		});
+	}
+};
+
+export const createFacility = async (req, res) => {
+	try {
+		const {
+			facilityId,
+			name,
+			slug,
+			shortDescription,
+			description,
+			videoUrl,
+			isActive,
+			isFeatured,
+			sortOrder,
+			departmentId,
+			images,
+			seoTitle,
+			metaDescription,
+			focusKeyphrase,
+			tags,
+			ogTitle,
+			ogDescription,
+			ogImage,
+		} = req.body;
+
+		const messages = [];
+		if (!facilityId) messages.push('Facility ID is required');
+		if (!name?.trim()) messages.push('Facility name is required');
+		if (!slug?.trim()) messages.push('Slug is required');
+
+		if (messages.length > 0) {
+			return res.status(400).json({
+				success: false,
+				message: messages.join(', '),
+			});
+		}
+
+		let dbDepartmentId = null;
+		if (departmentId) {
+			const targetDept = await prisma.department.findUnique({
+				where: { departmentId: departmentId },
+			});
+			if (targetDept) {
+				dbDepartmentId = targetDept.id;
+			}
+		}
+
+		const seo = await prisma.seo.create({
+			data: {
+				seoTitle,
+				metaDescription,
+				focusKeyphrase,
+				slug: slug ? slug : null,
+				tags: tags || [],
+				ogTitle,
+				ogDescription,
+				ogImage,
+			},
+		});
+
+		const facility = await prisma.facility.create({
+			data: {
+				facilityId,
+				name,
+				slug,
+				shortDescription,
+				description,
+				videoUrl,
+				isActive: isActive !== undefined ? isActive : true,
+				isFeatured: isFeatured !== undefined ? isFeatured : false,
+				sortOrder: sortOrder !== undefined ? Number(sortOrder) : 1000,
+				departmentId: dbDepartmentId,
+				seoId: seo.id,
+			},
+		});
+
+		if (images && images.length > 0) {
+			await prisma.facilityImage.createMany({
+				data: images.map((img) => ({
+					url: img.url,
+					altText: img.altText || null,
+					description: img.description || null,
+					facilityId: facility.id,
+				})),
+			});
+		}
+
+		res.status(201).json({
+			success: true,
+			message: 'Facility created successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to create facility',
+		});
+	}
+};
+
+export const updateFacility = async (req, res) => {
+	try {
+		const { facilityId, action } = req.params;
+		const {
+			name,
+			slug,
+			shortDescription,
+			description,
+			videoUrl,
+			isActive,
+			isFeatured,
+			sortOrder,
+			departmentId,
+			images,
+			seoTitle,
+			metaDescription,
+			focusKeyphrase,
+			tags,
+			ogTitle,
+			ogDescription,
+			ogImage,
+		} = req.body;
+
+		if (!facilityId) {
+			return res.status(400).json({ success: false, message: 'Facility ID is required' });
+		}
+
+		const facility = await prisma.facility.findUnique({ where: { facilityId } });
+		if (!facility) return res.status(404).json({ success: false, message: 'Facility not found' });
+
+		if (action === 'toggleStatus') {
+			await prisma.facility.update({
+				where: { id: facility.id },
+				data: { isActive: !facility.isActive },
+			});
+			return res.status(200).json({
+				success: true,
+				message: `Facility has been ${facility.isActive ? 'deactivated' : 'activated'} successfully`,
+			});
+		}
+
+		if (action === 'toggleFeatured') {
+			await prisma.facility.update({
+				where: { id: facility.id },
+				data: { isFeatured: !facility.isFeatured },
+			});
+			return res.status(200).json({
+				success: true,
+				message: `Facility has been ${facility.isFeatured ? 'removed from featured' : 'marked as featured'} successfully`,
+			});
+		}
+
+		const messages = [];
+		if (!name?.trim()) messages.push('Facility name is required');
+		if (!slug?.trim()) messages.push('Slug is required');
+
+		if (messages.length > 0) {
+			return res.status(400).json({ success: false, message: messages.join(', ') });
+		}
+
+		let dbDepartmentId = undefined;
+		if (departmentId !== undefined) {
+			if (departmentId) {
+				const targetDept = await prisma.department.findUnique({
+					where: { departmentId: departmentId },
+				});
+				dbDepartmentId = targetDept ? targetDept.id : null;
+			} else {
+				dbDepartmentId = null;
+			}
+		}
+
+		await prisma.facility.update({
+			where: { id: facility.id },
+			data: {
+				name,
+				slug,
+				shortDescription,
+				description,
+				videoUrl,
+				isActive: isActive !== undefined ? isActive : undefined,
+				isFeatured: isFeatured !== undefined ? isFeatured : undefined,
+				sortOrder: sortOrder !== undefined ? Number(sortOrder) : undefined,
+				departmentId: dbDepartmentId,
+			},
+		});
+
+		if (facility.seoId) {
+			await prisma.seo.update({
+				where: { id: facility.seoId },
+				data: {
+					seoTitle,
+					metaDescription,
+					focusKeyphrase,
+					slug: slug ? slug : null,
+					tags: tags || [],
+					ogTitle,
+					ogDescription,
+					ogImage,
+				},
+			});
+		} else {
+			const seo = await prisma.seo.create({
+				data: {
+					seoTitle,
+					metaDescription,
+					focusKeyphrase,
+					slug: slug ? slug : null,
+					tags: tags || [],
+					ogTitle,
+					ogDescription,
+					ogImage,
+				},
+			});
+			await prisma.facility.update({ where: { id: facility.id }, data: { seoId: seo.id } });
+		}
+
+		if (Array.isArray(images)) {
+			await prisma.facilityImage.deleteMany({ where: { facilityId: facility.id } });
+			if (images.length > 0) {
+				await prisma.facilityImage.createMany({
+					data: images.map((img) => ({
+						url: img.url,
+						altText: img.altText || null,
+						description: img.description || null,
+						facilityId: facility.id,
+					})),
+				});
+			}
+		}
+
+		res.status(200).json({ success: true, message: 'Facility updated successfully' });
+	} catch (error) {
+		console.error('Update Error:', error);
+		res.status(500).json({ success: false, message: 'Failed to update facility' });
+	}
+};
+
+export const deleteFacility = async (req, res) => {
+	try {
+		const { facilityId } = req.params;
+
+		const facility = await prisma.facility.findUnique({ where: { facilityId } });
+		if (!facility) {
+			return res.status(404).json({ success: false, message: 'Facility not found' });
+		}
+
+		await prisma.facilityImage.deleteMany({ where: { facilityId: facility.id } });
+		await prisma.facility.delete({ where: { id: facility.id } });
+
+		res.status(200).json({
+			success: true,
+			message: 'Facility deleted successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({ success: false, message: 'Failed to delete facility' });
+	}
+};
+
+export const getFeaturedFacilities = async (req, res) => {
+	try {
+		const facilities = await prisma.facility.findMany({
+			where: { isActive: true, isFeatured: true },
+			include: {
+				images: true,
+				department: true,
+			},
+			orderBy: [{ sortOrder: 'asc' }, { name: 'asc' }],
+		});
+
+		const data = facilities.map((fac) => ({
+			facilityId: fac.facilityId,
+			name: fac.name,
+			slug: fac.slug,
+			shortDescription: fac.shortDescription,
+			image: fac.images[0]?.url ?? '',
+			departmentName: fac.department?.name ?? '',
+		}));
+
+		res.status(200).json({ success: true, data });
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({ success: false, message: 'Failed to fetch featured facilities' });
+	}
+};

backend/src/controllers/googleReview.controller.js

@@ -0,0 +1,224 @@
+import prisma from '../prisma/client.js';
+
+export const getFeaturedGoogleReviews = async (req, res) => {
+	try {
+		const reviews = await prisma.googleReview.findMany({
+			where: {
+				isActive: true,
+				isFeatured: true,
+			},
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: reviews,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch featured Google reviews',
+		});
+	}
+};
+
+export const createGoogleReview = async (req, res) => {
+	try {
+		const {
+			reviewerName,
+			reviewerImage,
+			rating,
+			review,
+			reviewDate,
+			googleReviewUrl,
+			isFeatured,
+			isActive,
+			sortOrder,
+		} = req.body;
+
+		if (!reviewerName || !rating || !review) {
+			return res.status(400).json({
+				success: false,
+				message: 'Reviewer name, rating and review are required.',
+			});
+		}
+
+		const googleReview = await prisma.googleReview.create({
+			data: {
+				reviewerName,
+				reviewerImage,
+				rating: Number(rating),
+				review,
+				reviewDate: reviewDate ? new Date(reviewDate) : null,
+				googleReviewUrl,
+				isFeatured,
+				isActive,
+				sortOrder,
+			},
+		});
+
+		res.status(201).json({
+			success: true,
+			data: googleReview,
+			message: 'Google review created successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to create Google review',
+		});
+	}
+};
+
+export const getGoogleReviews = async (req, res) => {
+	try {
+		const reviews = await prisma.googleReview.findMany({
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: reviews,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch Google reviews',
+		});
+	}
+};
+
+export const getActiveGoogleReviews = async (req, res) => {
+	try {
+		const reviews = await prisma.googleReview.findMany({
+			where: {
+				isActive: true,
+			},
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: reviews,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch active Google reviews',
+		});
+	}
+};
+
+export const getGoogleReview = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const review = await prisma.googleReview.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!review) {
+			return res.status(404).json({
+				success: false,
+				message: 'Google review not found',
+			});
+		}
+
+		res.json({
+			success: true,
+			data: review,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch Google review',
+		});
+	}
+};
+
+export const updateGoogleReview = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const {
+			reviewerName,
+			reviewerImage,
+			rating,
+			review,
+			reviewDate,
+			googleReviewUrl,
+			isFeatured,
+			isActive,
+			sortOrder,
+		} = req.body;
+
+		const dataToUpdate = {};
+
+		if (reviewerName !== undefined) dataToUpdate.reviewerName = reviewerName;
+		if (reviewerImage !== undefined) dataToUpdate.reviewerImage = reviewerImage;
+		if (rating !== undefined) dataToUpdate.rating = Number(rating);
+		if (review !== undefined) dataToUpdate.review = review;
+		if (reviewDate !== undefined) {
+			dataToUpdate.reviewDate = reviewDate ? new Date(reviewDate) : null;
+		}
+		if (googleReviewUrl !== undefined) dataToUpdate.googleReviewUrl = googleReviewUrl;
+		if (isFeatured !== undefined) dataToUpdate.isFeatured = isFeatured;
+		if (isActive !== undefined) dataToUpdate.isActive = isActive;
+		if (sortOrder !== undefined) dataToUpdate.sortOrder = sortOrder;
+
+		const googleReview = await prisma.googleReview.update({
+			where: {
+				id: Number(id),
+			},
+			data: dataToUpdate,
+		});
+
+		res.json({
+			success: true,
+			data: googleReview,
+			message: 'Google review updated successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to update Google review',
+		});
+	}
+};
+
+export const deleteGoogleReview = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.googleReview.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.json({
+			success: true,
+			message: 'Google review deleted successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to delete Google review',
+		});
+	}
+};

backend/src/controllers/healthCheck.controller.js

@@ -0,0 +1,518 @@
+import prisma from '../prisma/client.js';
+import { sendEmail } from '../utils/sendEmail.js';
+import { getEmailsByType } from '../utils/getEmailByTypes.js';
+
+export const getAllCategories = async (req, res) => {
+	try {
+		const { admin } = req.query;
+
+		const categories = await prisma.healthCheckCategory.findMany({
+			where: admin === 'true' ? {} : { isActive: true },
+			orderBy: { sortOrder: 'asc' },
+			include: {
+				_count: { select: { packages: true } },
+			},
+		});
+		return res.status(200).json({ success: true, data: categories });
+	} catch (error) {
+		return res.status(500).json({ success: false, message: 'Failed to fetch categories' });
+	}
+};
+
+export const createCategory = async (req, res) => {
+	try {
+		const { name, slug, description, isActive, sortOrder } = req.body;
+
+		const category = await prisma.healthCheckCategory.create({
+			data: {
+				name,
+				slug: slug || null,
+				description,
+				isActive: isActive ?? true,
+				sortOrder: sortOrder ? Number(sortOrder) : 1000,
+			},
+		});
+
+		return res.status(201).json({ success: true, message: 'Category created', data: category });
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to create category' });
+	}
+};
+
+export const updateCategory = async (req, res) => {
+	try {
+		const { id } = req.params;
+		const data = { ...req.body };
+
+		delete data.id;
+		delete data._count;
+		delete data.createdAt;
+		delete data.updatedAt;
+
+		if (data.sortOrder !== undefined) data.sortOrder = Number(data.sortOrder);
+
+		if (data.slug === '') data.slug = null;
+
+		const updatedCategory = await prisma.$transaction(async (tx) => {
+			const category = await tx.healthCheckCategory.update({
+				where: { id: Number(id) },
+				data,
+			});
+
+			if (data.isActive === false) {
+				await tx.healthPackage.updateMany({
+					where: { categoryId: Number(id) },
+					data: { isActive: false },
+				});
+			}
+
+			return category;
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: 'Category updated',
+			data: updatedCategory,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to update category' });
+	}
+};
+
+export const deleteCategory = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.healthCheckCategory.delete({
+			where: { id: Number(id) },
+		});
+
+		return res.status(200).json({ success: true, message: 'Category deleted successfully' });
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: 'Failed to delete category. Ensure no packages are linked to it.',
+		});
+	}
+};
+
+export const getAllPackages = async (req, res) => {
+	try {
+		const { admin, categorySlug } = req.query;
+
+		const packages = await prisma.healthPackage.findMany({
+			where: {
+				AND: [admin === 'true' ? {} : { isActive: true }, categorySlug ? { category: { slug: categorySlug } } : {}],
+			},
+			include: {
+				category: true,
+				seo: true,
+			},
+			orderBy: [{ sortOrder: 'asc' }, { createdAt: 'desc' }],
+		});
+
+		return res.status(200).json({ success: true, data: packages });
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to fetch packages' });
+	}
+};
+
+export const createPackage = async (req, res) => {
+	try {
+		const {
+			name,
+			slug,
+			description,
+			price,
+			image,
+			discountedPrice,
+			inclusions,
+			categoryId,
+			isActive,
+			isFeatured,
+			sortOrder,
+			seo,
+		} = req.body;
+
+		const healthPackage = await prisma.healthPackage.create({
+			data: {
+				name,
+				slug,
+				description,
+				price,
+				image,
+				discountedPrice,
+				inclusions,
+				categoryId: Number(categoryId),
+				isActive: isActive ?? true,
+				isFeatured: isFeatured ?? false,
+				sortOrder: sortOrder ? Number(sortOrder) : 1000,
+
+				...(seo && {
+					seo: {
+						create: {
+							seoTitle: seo.seoTitle,
+							metaDescription: seo.metaDescription,
+							focusKeyphrase: seo.focusKeyphrase,
+							slug: slug,
+							tags: seo.tags || [],
+							ogTitle: seo.ogTitle,
+							ogDescription: seo.ogDescription,
+							ogImage: seo.ogImage,
+						},
+					},
+				}),
+			},
+			include: {
+				category: true,
+				seo: true,
+			},
+		});
+
+		return res.status(201).json({ success: true, message: 'Package created', data: healthPackage });
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to create package' });
+	}
+};
+
+export const updatePackage = async (req, res) => {
+	try {
+		const { id } = req.params;
+		const data = { ...req.body };
+		delete data.id;
+		delete data.category;
+		delete data.createdAt;
+		delete data.updatedAt;
+		delete data.seoId;
+
+		if (data.categoryId) data.categoryId = Number(data.categoryId);
+		if (data.sortOrder) data.sortOrder = Number(data.sortOrder);
+
+		const existingPackage = await prisma.healthPackage.findUnique({
+			where: { id: Number(id) },
+			select: { slug: true },
+		});
+		const seoSlug = data.slug || existingPackage.slug;
+
+		const updated = await prisma.healthPackage.update({
+			where: { id: Number(id) },
+
+			data: {
+				...data,
+
+				seo: data.seo
+					? {
+							upsert: {
+								create: {
+									seoTitle: data.seo.seoTitle,
+									metaDescription: data.seo.metaDescription,
+									focusKeyphrase: data.seo.focusKeyphrase,
+									slug: seoSlug,
+									tags: data.seo.tags || [],
+									ogTitle: data.seo.ogTitle,
+									ogDescription: data.seo.ogDescription,
+									ogImage: data.seo.ogImage,
+								},
+
+								update: {
+									seoTitle: data.seo.seoTitle,
+									metaDescription: data.seo.metaDescription,
+									focusKeyphrase: data.seo.focusKeyphrase,
+									slug: seoSlug,
+									tags: data.seo.tags || [],
+									ogTitle: data.seo.ogTitle,
+									ogDescription: data.seo.ogDescription,
+									ogImage: data.seo.ogImage,
+								},
+							},
+						}
+					: undefined,
+			},
+
+			include: {
+				category: true,
+				seo: true,
+			},
+		});
+
+		return res.status(200).json({ success: true, message: 'Package updated', data: updated });
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Update failed' });
+	}
+};
+
+export const deletePackage = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.healthPackage.delete({
+			where: { id: Number(id) },
+		});
+
+		return res.status(200).json({
+			success: true,
+			message: 'Package deleted',
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: 'Delete failed',
+		});
+	}
+};
+
+export const createPackageInquiry = async (req, res) => {
+	try {
+		const { fullName, mobileNumber, email, age, gender, preferredDate, packageId, message } = req.body;
+
+		const inquiry = await prisma.healthPackageInquiry.create({
+			data: {
+				fullName,
+				mobileNumber,
+				email,
+				age: age ? Number(age) : null,
+				gender,
+				preferredDate: preferredDate ? new Date(preferredDate) : null,
+				message,
+				packageId: Number(packageId),
+			},
+			include: {
+				healthPackage: true,
+			},
+		});
+
+		try {
+			const emailList = await getEmailsByType('HCINQUIRY');
+
+			if (emailList) {
+				await sendEmail({
+					to: emailList,
+					subject: 'New Health Checkup Package 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 Health Checkup Package Inquiry
+              </p>
+            </div>
+
+            <!-- Body -->
+            <div style="padding: 20px; color: #333;">
+              
+              <h3 style="margin-top: 0;">Inquirer Details</h3>
+              
+              <table style="width: 100%; border-collapse: collapse;">
+                <tr>
+                  <td style="padding: 8px 0; width: 35%;"><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;">${mobileNumber}</td>
+                </tr>
+                <tr>
+                  <td style="padding: 8px 0;"><b>Email:</b></td>
+                  <td style="padding: 8px 0;">${email || '-'}</td>
+                </tr>
+                <tr>
+                  <td style="padding: 8px 0;"><b>Age:</b></td>
+                  <td style="padding: 8px 0;">${age || '-'}</td>
+                </tr>
+                <tr>
+                  <td style="padding: 8px 0;"><b>Gender:</b></td>
+                  <td style="padding: 8px 0;">${gender || '-'}</td>
+                </tr>
+              </table>
+
+              <h3 style="margin-top: 20px;">Package Details</h3>
+
+              <table style="width: 100%; border-collapse: collapse;">
+                <tr>
+                  <td style="padding: 8px 0; width: 35%;"><b>Package Name:</b></td>
+                  <td style="padding: 8px 0;">${inquiry.healthPackage?.name || 'Unknown Package'}</td>
+                </tr>
+                <tr>
+                  <td style="padding: 8px 0;"><b>Preferred Date:</b></td>
+                  <td style="padding: 8px 0;">
+                    ${
+											preferredDate
+												? new Date(preferredDate).toLocaleDateString('en-GB', {
+														day: '2-digit',
+														month: 'long',
+														year: 'numeric',
+													})
+												: 'Not specified'
+										}
+                  </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 inquiry was submitted via the GG Hospital website.
+            </div>
+
+          </div>
+
+        </div>
+        `,
+				});
+			}
+		} catch (err) {
+			console.error('Email failed:', err);
+		}
+
+		return res.status(201).json({
+			success: true,
+			message: 'Booking inquiry sent successfully',
+			data: inquiry,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to submit inquiry' });
+	}
+};
+
+export const getPackageBySlug = async (req, res) => {
+	try {
+		const { slug } = req.params;
+		const healthPackage = await prisma.healthPackage.findFirst({
+			where: { slug, isActive: true },
+
+			include: {
+				category: true,
+				seo: true,
+			},
+		});
+
+		if (!healthPackage) {
+			return res.status(404).json({ success: false, message: 'Package not found' });
+		}
+
+		return res.status(200).json({
+			success: true,
+			data: healthPackage,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to fetch package' });
+	}
+};
+
+export const getAllInquiries = async (req, res) => {
+	try {
+		const { page = 1, limit = 10, filterDate, startDate, endDate } = req.query;
+
+		const queryPage = parseInt(page);
+		const queryLimit = parseInt(limit);
+		const skip = (queryPage - 1) * queryLimit;
+
+		let where = {};
+
+		if (filterDate) {
+			where.preferredDate = {
+				gte: new Date(`${filterDate}T00:00:00.000Z`),
+				lte: new Date(`${filterDate}T23:59:59.999Z`),
+			};
+		} else if (startDate || endDate) {
+			where.preferredDate = {};
+			if (startDate) {
+				where.preferredDate.gte = new Date(`${startDate}T00:00:00.000Z`);
+			}
+			if (endDate) {
+				where.preferredDate.lte = new Date(`${endDate}T23:59:59.999Z`);
+			}
+		}
+
+		const [total, inquiries] = await prisma.$transaction([
+			prisma.healthPackageInquiry.count({ where }),
+			prisma.healthPackageInquiry.findMany({
+				where,
+				skip,
+				take: queryLimit,
+				include: {
+					healthPackage: {
+						include: {
+							category: true,
+						},
+					},
+				},
+				orderBy: { createdAt: 'desc' },
+			}),
+		]);
+
+		return res.status(200).json({
+			success: true,
+			data: inquiries,
+			pagination: {
+				total,
+				page: queryPage,
+				limit: queryLimit,
+				totalPages: Math.ceil(total / queryLimit),
+			},
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({ success: false, message: 'Failed to fetch inquiries' });
+	}
+};
+
+export const getFeaturedPackages = async (req, res) => {
+	try {
+		const packages = await prisma.healthPackage.findMany({
+			where: {
+				isActive: true,
+				isFeatured: true,
+				category: {
+					isActive: true,
+				},
+			},
+			include: {
+				category: true,
+				seo: true,
+			},
+			orderBy: [{ sortOrder: 'asc' }, { createdAt: 'desc' }],
+		});
+
+		return res.status(200).json({
+			success: true,
+			data: packages,
+		});
+	} catch (error) {
+		console.error(error);
+		return res.status(500).json({
+			success: false,
+			message: 'Failed to fetch featured packages',
+		});
+	}
+};

backend/src/controllers/homepageBanner.controller.js

@@ -0,0 +1,203 @@
+import prisma from '../prisma/client.js';
+
+export const createHomepageBanner = async (req, res) => {
+	try {
+		const {
+			title,
+			subtitle,
+			mediaType,
+			desktopMediaUrl,
+			mobileMediaUrl,
+			buttonText,
+			buttonLink,
+			openInNewTab,
+			textAlignment,
+			sortOrder,
+			isActive,
+		} = req.body;
+
+		if (!mediaType || !desktopMediaUrl) {
+			return res.status(400).json({
+				success: false,
+				message: 'Media type and desktop media URL are required',
+			});
+		}
+
+		const banner = await prisma.homepageBanner.create({
+			data: {
+				title,
+				subtitle,
+				mediaType,
+				desktopMediaUrl,
+				mobileMediaUrl,
+				buttonText,
+				buttonLink,
+				openInNewTab,
+				textAlignment,
+				sortOrder,
+				isActive,
+			},
+		});
+
+		res.status(201).json({
+			success: true,
+			data: banner,
+			message: 'Homepage banner created successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to create homepage banner',
+		});
+	}
+};
+
+export const getHomepageBanners = async (req, res) => {
+	try {
+		const banners = await prisma.homepageBanner.findMany({
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: banners,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch homepage banners',
+		});
+	}
+};
+
+export const getActiveHomepageBanners = async (req, res) => {
+	try {
+		const banners = await prisma.homepageBanner.findMany({
+			where: {
+				isActive: true,
+			},
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: banners,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch active homepage banners',
+		});
+	}
+};
+
+export const getHomepageBanner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const banner = await prisma.homepageBanner.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!banner) {
+			return res.status(404).json({
+				success: false,
+				message: 'Homepage banner not found',
+			});
+		}
+
+		res.json({
+			success: true,
+			data: banner,
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch homepage banner',
+		});
+	}
+};
+
+export const updateHomepageBanner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const {
+			title,
+			subtitle,
+			mediaType,
+			desktopMediaUrl,
+			mobileMediaUrl,
+			buttonText,
+			buttonLink,
+			openInNewTab,
+			textAlignment,
+			sortOrder,
+			isActive,
+		} = req.body;
+
+		const banner = await prisma.homepageBanner.update({
+			where: {
+				id: Number(id),
+			},
+			data: {
+				title,
+				subtitle,
+				mediaType,
+				desktopMediaUrl,
+				mobileMediaUrl,
+				buttonText,
+				buttonLink,
+				openInNewTab,
+				textAlignment,
+				sortOrder,
+				isActive,
+			},
+		});
+
+		res.json({
+			success: true,
+			data: banner,
+			message: 'Homepage banner updated successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to update homepage banner',
+		});
+	}
+};
+
+export const deleteHomepageBanner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.homepageBanner.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.json({
+			success: true,
+			message: 'Homepage banner deleted successfully',
+		});
+	} catch (error) {
+		console.error(error);
+		res.status(500).json({
+			success: false,
+			message: 'Failed to delete homepage banner',
+		});
+	}
+};

backend/src/controllers/importController.js

@@ -1,22 +1,12 @@
-import { PrismaClient } from "@prisma/client";
+import { PrismaClient } from '@prisma/client';
 
 const prisma = new PrismaClient();
 
 export const bulkImportExcelData = async (req, res) => {
 	try {
-		const {
+		const { departments, doctors, timings, careers, inquiries, academics, appointments, candidates, news } = req.body;
-			departments,
-			doctors,
-			timings,
-			careers,
-			inquiries,
-			academics,
-			appointments,
-			candidates,
-			news,
-		} = req.body;
 
-		console.log("🚀 Starting Robust Data Import...");
+		console.log('🚀 Starting Robust Data Import...');
 
 		// 1. DEPARTMENTS
 		if (departments) {
@@ -54,14 +44,14 @@ export const bulkImportExcelData = async (req, res) => {
 					update: {
 						name: row.Name?.toString(),
 						designation: row.Designation?.toString() || null,
-						workingStatus: row["Working Status"]?.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,
+						workingStatus: row['Working Status']?.toString() || null,
 						qualification: row.Qualification?.toString() || null,
 					},
 				});
@@ -100,8 +90,8 @@ export const bulkImportExcelData = async (req, res) => {
 
 				if (doctor && doctor.departments.length > 0) {
 					const doctorDeptId = doctor.departments[0].id;
-					const rawAdd = row.Additional?.toString() || "";
+					const rawAdd = row.Additional?.toString() || '';
-					const rawMon = row.Monday?.toString() || "";
+					const rawMon = row.Monday?.toString() || '';
 					const isAppt = (val) => /appointment|basis|on call/i.test(val);
 
 					let finalAdd = rawAdd;
@@ -147,7 +137,7 @@ export const bulkImportExcelData = async (req, res) => {
 					experienceNeed: row.ExperienceNeed?.toString() || null,
 					email: row.HiringEmail?.toString() || null,
 					number: row.Number?.toString() || null,
-					status: row.Status?.toString() || "new",
+					status: row.Status?.toString() || 'new',
 				};
 				if (cId) {
 					await prisma.career.upsert({
@@ -168,7 +158,7 @@ export const bulkImportExcelData = async (req, res) => {
 				await prisma.inquiry.create({
 					data: {
 						fullName: row.FullName.toString(),
-						number: row.Number?.toString() || "",
+						number: row.Number?.toString() || '',
 						emailId: row.EmailId?.toString() || null,
 						subject: row.Subject?.toString() || null,
 						message: row.Message?.toString() || null,
@@ -185,10 +175,10 @@ export const bulkImportExcelData = async (req, res) => {
 				await prisma.academicsResearch.create({
 					data: {
 						fullName: row.FullName.toString(),
-						number: row.Number?.toString() || "",
+						number: row.Number?.toString() || '',
 						emailId: row.EmailId?.toString() || null,
 						subject: row.Subject?.toString() || null, // Force String
-						courseName: row["Course Name"]?.toString() || null,
+						courseName: row['Course Name']?.toString() || null,
 						message: row.Message?.toString() || null,
 						createdAt: row.Date ? new Date(row.Date) : new Date(),
 					},
@@ -201,7 +191,7 @@ export const bulkImportExcelData = async (req, res) => {
 			for (const row of appointments) {
 				if (!row.FullName) continue;
 				const doctorName = row.Doctor?.toString();
-				const departmentName = row["Department Id"]?.toString();
+				const departmentName = row['Department Id']?.toString();
 
 				const doctor = await prisma.doctor.findFirst({
 					where: { name: doctorName },
@@ -214,11 +204,11 @@ export const bulkImportExcelData = async (req, res) => {
 					if (!value) return new Date();
 
 					// Excel numeric date
-					if (typeof value === "number") {
+					if (typeof value === 'number') {
 						return new Date((value - 25569) * 86400 * 1000);
 					}
 
-					if (typeof value === "string") {
+					if (typeof value === 'string') {
 						const v = value.trim();
 
 						// Handle DD/MM/YYYY
@@ -238,15 +228,15 @@ export const bulkImportExcelData = async (req, res) => {
 						}
 					}
 
-					console.warn("⚠️ Invalid date, using current date:", value);
+					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() || "",
+							mobileNumber: row.Number?.toString() || '',
-							email: row["Email Id"]?.toString() || null,
+							email: row['Email Id']?.toString() || null,
 							message: row.Message?.toString() || null,
 							date: parseDate(row.Date),
 							doctorId: doctor.doctorId,
@@ -265,10 +255,10 @@ export const bulkImportExcelData = async (req, res) => {
 					.create({
 						data: {
 							fullName: row.FullName.toString(),
-							mobile: row.Number?.toString() || "",
+							mobile: row.Number?.toString() || '',
-							email: row.EmailId?.toString() || "",
+							email: row.EmailId?.toString() || '',
-							subject: row.Subject?.toString() || "",
+							subject: row.Subject?.toString() || '',
-							coverLetter: row["Cover Letter"]?.toString() || "",
+							coverLetter: row['Cover Letter']?.toString() || '',
 							careerId: parseInt(row.CareerId),
 							createdAt: row.Date ? new Date(row.Date) : new Date(),
 						},
@@ -294,11 +284,9 @@ export const bulkImportExcelData = async (req, res) => {
 			}
 		}
 
-		res
+		res.status(200).json({ success: true, message: '✅ Import completed successfully!' });
-			.status(200)
-			.json({ success: true, message: "✅ Import completed successfully!" });
 	} catch (error) {
-		console.error("❌ Bulk Import Error:", error);
+		console.error('❌ Bulk Import Error:', error);
 		res.status(500).json({ success: false, error: error.message });
 	}
 };

backend/src/controllers/inquiry.controller.js

@@ -1,17 +1,17 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
-import {sendEmail} from "../utils/sendEmail.js";
+import { sendEmail } from '../utils/sendEmail.js';
-import {getEmailsByType} from "../utils/getEmailByTypes.js";
+import { getEmailsByType } from '../utils/getEmailByTypes.js';
 
 /* CREATE INQUIRY */
 export const createInquiry = async (req, res) => {
 	try {
-		const {fullName, number, emailId, subject, message} = req.body;
+		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",
+				message: 'Full name and number are required',
 			});
 		}
 
@@ -25,39 +25,91 @@ export const createInquiry = async (req, res) => {
 			},
 		});
 		try {
-			const emailList = await getEmailsByType("INQUIRY");
+			const emailList = await getEmailsByType('INQUIRY');
 
 			if (emailList && emailList.length > 0) {
 				await sendEmail({
 					to: emailList,
-					subject: "New Inquiry Received",
+					subject: 'New Inquiry Received',
 					html: `
-						<h2>New Inquiry</h2>
+					<div style="font-family: Arial, sans-serif; background-color: #f4f6f8; padding: 20px;">
 					
-						<p><b>Name:</b> ${fullName}</p>
+					<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);">
-						<p><b>Phone:</b> ${number}</p>
-						<p><b>Email:</b> ${emailId}</p>
 						
-						<p><b>Subject:</b> ${subject}</p>
+						<!-- Header -->
-					<p><b>Message:</b> ${message}</p>
+						<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);
+			console.error('Inquiry email failed:', err);
 		}
 
 		res.status(200).json({
 			success: true,
 			status: 200,
 			data: inquiry,
-			message: "Inquiry added successfully",
+			message: 'Inquiry added successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		res.status(500).json({
 			success: false,
-			message: "Failed to add inquiry",
+			message: 'Failed to add inquiry',
 		});
 	}
 };
@@ -67,7 +119,7 @@ export const getInquiries = async (req, res) => {
 	try {
 		const inquiries = await prisma.inquiry.findMany({
 			orderBy: {
-				createdAt: "desc",
+				createdAt: 'desc',
 			},
 		});
 
@@ -78,7 +130,7 @@ export const getInquiries = async (req, res) => {
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch inquiries",
+			message: 'Failed to fetch inquiries',
 		});
 	}
 };
@@ -86,16 +138,16 @@ export const getInquiries = async (req, res) => {
 /* GET SINGLE */
 export const getInquiry = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		const inquiry = await prisma.inquiry.findUnique({
-			where: {id: Number(id)},
+			where: { id: Number(id) },
 		});
 
 		if (!inquiry) {
 			return res.status(404).json({
 				success: false,
-				message: "Inquiry not found",
+				message: 'Inquiry not found',
 			});
 		}
 
@@ -106,7 +158,7 @@ export const getInquiry = async (req, res) => {
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to fetch inquiry",
+			message: 'Failed to fetch inquiry',
 		});
 	}
 };
@@ -114,20 +166,20 @@ export const getInquiry = async (req, res) => {
 /* DELETE */
 export const deleteInquiry = async (req, res) => {
 	try {
-		const {id} = req.params;
+		const { id } = req.params;
 
 		await prisma.inquiry.delete({
-			where: {id: Number(id)},
+			where: { id: Number(id) },
 		});
 
 		res.json({
 			success: true,
-			message: "Inquiry deleted successfully",
+			message: 'Inquiry deleted successfully',
 		});
 	} catch (error) {
 		res.status(500).json({
 			success: false,
-			message: "Failed to delete inquiry",
+			message: 'Failed to delete inquiry',
 		});
 	}
 };

backend/src/controllers/insurancePartner.controller.js

@@ -0,0 +1,173 @@
+import prisma from '../prisma/client.js';
+
+export const createInsurancePartner = async (req, res) => {
+	try {
+		const { name, logo, websiteUrl, sortOrder, isActive } = req.body;
+
+		if (!name || !logo) {
+			return res.status(400).json({
+				success: false,
+				message: 'Name and logo are required',
+			});
+		}
+
+		const partner = await prisma.insurancePartner.create({
+			data: {
+				name,
+				logo,
+				websiteUrl,
+				sortOrder,
+				isActive,
+			},
+		});
+
+		res.status(201).json({
+			success: true,
+			data: partner,
+			message: 'Insurance partner created successfully',
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to create insurance partner',
+		});
+	}
+};
+
+export const getInsurancePartners = async (req, res) => {
+	try {
+		const partners = await prisma.insurancePartner.findMany({
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: partners,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch insurance partners',
+		});
+	}
+};
+
+export const getActiveInsurancePartners = async (req, res) => {
+	try {
+		const partners = await prisma.insurancePartner.findMany({
+			where: {
+				isActive: true,
+			},
+			orderBy: {
+				sortOrder: 'asc',
+			},
+		});
+
+		res.json({
+			success: true,
+			data: partners,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch insurance partners',
+		});
+	}
+};
+
+export const getInsurancePartner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const partner = await prisma.insurancePartner.findUnique({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		if (!partner) {
+			return res.status(404).json({
+				success: false,
+				message: 'Insurance partner not found',
+			});
+		}
+
+		res.json({
+			success: true,
+			data: partner,
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to fetch insurance partner',
+		});
+	}
+};
+
+export const updateInsurancePartner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		const { name, logo, websiteUrl, sortOrder, isActive } = req.body;
+
+		const partner = await prisma.insurancePartner.update({
+			where: {
+				id: Number(id),
+			},
+			data: {
+				name,
+				logo,
+				websiteUrl,
+				sortOrder,
+				isActive,
+			},
+		});
+
+		res.json({
+			success: true,
+			data: partner,
+			message: 'Insurance partner updated successfully',
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to update insurance partner',
+		});
+	}
+};
+
+export const deleteInsurancePartner = async (req, res) => {
+	try {
+		const { id } = req.params;
+
+		await prisma.insurancePartner.delete({
+			where: {
+				id: Number(id),
+			},
+		});
+
+		res.json({
+			success: true,
+			message: 'Insurance partner deleted successfully',
+		});
+	} catch (error) {
+		console.error(error);
+
+		res.status(500).json({
+			success: false,
+			message: 'Failed to delete insurance partner',
+		});
+	}
+};

backend/src/controllers/newsMedia.controller.js

@@ -1,56 +1,44 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 // GET ALL NEWS
 
 export const getAllNews = async (req, res) => {
 	try {
-		const page = parseInt(req.query.page);
+		const page = req.query.page ? parseInt(req.query.page) : null;
-		const limit = parseInt(req.query.limit);
+		const limit = req.query.limit ? parseInt(req.query.limit) : null;
+		const search = req.query.search?.trim() || '';
 
 		const includeImages = {
 			images: true,
 		};
 
-		if (!page && !limit) {
+		const searchFilter = search
-			const news = await prisma.newsMedia.findMany({
+			? {
-				include: includeImages,
+					headline: {
-				orderBy: { createdAt: "desc" },
+						contains: search,
-			});
+						mode: 'insensitive',
+					},
+				}
+			: {};
 
-			const response = news.map((n) => ({
+		const whereCondition = {
-				Id: n.id.toString(),
+			...searchFilter,
-				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({
+		const skip = page && limit ? (page - 1) * limit : undefined;
-				success: true,
+		const take = limit ? limit : undefined;
-				data: response,
-				meta: null,
-			});
-		}
-
-		const currentPage = page || 1;
-		const currentLimit = limit || 10;
-
-		const skip = (currentPage - 1) * currentLimit;
 
 		const [news, total] = await Promise.all([
 			prisma.newsMedia.findMany({
+				where: whereCondition,
 				include: includeImages,
-				orderBy: { createdAt: "desc" },
+				orderBy: { createdAt: 'desc' },
 				skip,
-				take: currentLimit,
+				take,
+			}),
+			prisma.newsMedia.count({
+				where: whereCondition,
 			}),
-			prisma.newsMedia.count(),
 		]);
 
 		const response = news.map((n) => ({
@@ -72,20 +60,19 @@ export const getAllNews = async (req, res) => {
 			data: response,
 			meta: {
 				total,
-				page: currentPage,
+				page: page || 1,
-				limit: currentLimit,
+				limit: limit || total,
-				totalPages: Math.ceil(total / currentLimit),
+				totalPages: limit ? Math.ceil(total / limit) : 1,
 			},
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to fetch news",
+			message: 'Failed to fetch news',
 		});
 	}
 };
-
 // GET NEWS BY ID
 
 export const getNewsById = async (req, res) => {
@@ -100,7 +87,7 @@ export const getNewsById = async (req, res) => {
 		if (!n) {
 			return res.status(404).json({
 				success: false,
-				message: "News not found",
+				message: 'News not found',
 			});
 		}
 
@@ -126,7 +113,7 @@ export const getNewsById = async (req, res) => {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to fetch news",
+			message: 'Failed to fetch news',
 		});
 	}
 };
@@ -135,20 +122,12 @@ export const getNewsById = async (req, res) => {
 
 export const createNews = async (req, res) => {
 	try {
-		const {
+		const { headline, content, firstPara, secondPara, date, author, imageUrls } = req.body;
-			headline,
-			content,
-			firstPara,
-			secondPara,
-			date,
-			author,
-			imageUrls,
-		} = req.body;
 
 		if (!headline) {
 			return res.status(400).json({
 				success: false,
-				message: "Headline is required",
+				message: 'Headline is required',
 			});
 		}
 
@@ -171,14 +150,14 @@ export const createNews = async (req, res) => {
 
 		return res.status(201).json({
 			success: true,
-			message: "News created successfully",
+			message: 'News created successfully',
 			data: news,
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to create news",
+			message: 'Failed to create news',
 		});
 	}
 };
@@ -207,14 +186,14 @@ export const updateNews = async (req, res) => {
 
 		return res.status(200).json({
 			success: true,
-			message: "News updated successfully",
+			message: 'News updated successfully',
 			data: news,
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to update news",
+			message: 'Failed to update news',
 		});
 	}
 };
@@ -231,13 +210,13 @@ export const deleteNews = async (req, res) => {
 
 		return res.status(200).json({
 			success: true,
-			message: "News deleted successfully",
+			message: 'News deleted successfully',
 		});
 	} catch (error) {
 		console.error(error);
 		return res.status(500).json({
 			success: false,
-			message: "Failed to delete news",
+			message: 'Failed to delete news',
 		});
 	}
 };

backend/src/controllers/upload.controller.js

@@ -1,9 +1,9 @@
-import multer from "multer";
+import multer from 'multer';
-import path from "path";
+import path from 'path';
 
 const storage = multer.diskStorage({
 	destination: function (req, file, cb) {
-		cb(null, "uploads/blog");
+		cb(null, 'uploads/blog');
 	},
 
 	filename: function (req, file, cb) {
@@ -12,4 +12,4 @@ const storage = multer.diskStorage({
 	},
 });
 
-export const upload = multer({storage});
+export const upload = multer({ storage });

backend/src/middleware/auth.js

@@ -1,19 +1,19 @@
-import {verifyToken} from "../utils/jwt.js";
+import { verifyToken } from '../utils/jwt.js';
 
 export default function jwtAuthMiddleware(req, res, next) {
 	const authHeader = req.headers.authorization;
 
-	if (!authHeader || !authHeader.startsWith("Bearer ")) {
+	if (!authHeader || !authHeader.startsWith('Bearer ')) {
-		return res.status(401).json({error: "No token provided"});
+		return res.status(401).json({ error: 'No token provided' });
 	}
 
-	const token = authHeader.split(" ")[1];
+	const token = authHeader.split(' ')[1];
 
 	try {
 		const user = verifyToken(token);
 		req.user = user;
 		next();
 	} catch (err) {
-		return res.status(401).json({error: "Invalid or expired token"});
+		return res.status(401).json({ error: 'Invalid or expired token' });
 	}
 }

backend/src/prisma/client.js

@@ -1,4 +1,4 @@
-import {PrismaClient} from "@prisma/client";
+import { PrismaClient } from '@prisma/client';
 
 const prisma = new PrismaClient();
 

backend/src/routes/academicsResearch.routes.js

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

backend/src/routes/accreditation.routes.js

@@ -0,0 +1,24 @@
+import express from 'express';
+
+import {
+	createAccreditation,
+	getAccreditations,
+	getActiveAccreditations,
+	getAccreditation,
+	updateAccreditation,
+	deleteAccreditation,
+} from '../controllers/accreditation.controller.js';
+
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+const router = express.Router();
+
+router.get('/active', getActiveAccreditations);
+
+router.post('/', jwtAuthMiddleware, createAccreditation);
+router.get('/getAll', jwtAuthMiddleware, getAccreditations);
+router.get('/:id', jwtAuthMiddleware, getAccreditation);
+router.put('/:id', jwtAuthMiddleware, updateAccreditation);
+router.delete('/:id', jwtAuthMiddleware, deleteAccreditation);
+
+export default router;

backend/src/routes/appointment.routes.js

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

backend/src/routes/auth.routes.js

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

backend/src/routes/blog.routes.js

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

backend/src/routes/candidate.routes.js

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

backend/src/routes/career.routes.js

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

backend/src/routes/department.routes.js

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

backend/src/routes/doctor.routes.js

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

backend/src/routes/emailConfig.routes.js

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

backend/src/routes/facility.routes.js

@@ -0,0 +1,23 @@
+import express from 'express';
+import {
+	getAllFacilities,
+	getFacilityByFacilityId,
+	createFacility,
+	updateFacility,
+	deleteFacility,
+	getFeaturedFacilities,
+} from '../controllers/facility.controller.js';
+
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+const router = express.Router();
+
+router.get('/getAll', getAllFacilities);
+router.get('/featured', getFeaturedFacilities);
+router.get('/:facilityId', getFacilityByFacilityId);
+
+router.post('/', jwtAuthMiddleware, createFacility);
+router.patch('/:facilityId/:action', jwtAuthMiddleware, updateFacility);
+router.delete('/:facilityId', jwtAuthMiddleware, deleteFacility);
+
+export default router;

backend/src/routes/googleReview.routes.js

@@ -0,0 +1,25 @@
+import express from 'express';
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+import {
+	createGoogleReview,
+	getGoogleReviews,
+	getActiveGoogleReviews,
+	getFeaturedGoogleReviews,
+	getGoogleReview,
+	updateGoogleReview,
+	deleteGoogleReview,
+} from '../controllers/googleReview.controller.js';
+
+const router = express.Router();
+
+router.get('/active', getActiveGoogleReviews);
+router.get('/featured', getFeaturedGoogleReviews);
+
+router.post('/', jwtAuthMiddleware, createGoogleReview);
+router.get('/getAll', jwtAuthMiddleware, getGoogleReviews);
+router.get('/:id', jwtAuthMiddleware, getGoogleReview);
+router.put('/:id', jwtAuthMiddleware, updateGoogleReview);
+router.delete('/:id', jwtAuthMiddleware, deleteGoogleReview);
+
+export default router;

backend/src/routes/healthCheck.route.js

@@ -0,0 +1,41 @@
+import express from 'express';
+import {
+	// Categories
+	getAllCategories,
+	getPackageBySlug,
+	createCategory,
+	updateCategory,
+	deleteCategory,
+
+	// Packages
+	getAllPackages,
+	createPackage,
+	updatePackage,
+	deletePackage,
+	getFeaturedPackages,
+
+	// Inquiries
+	createPackageInquiry,
+	getAllInquiries,
+} from '../controllers/healthCheck.controller.js';
+
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+const router = express.Router();
+
+router.get('/packages', getAllPackages);
+router.get('/packages/:slug', getPackageBySlug);
+router.get('/categories', getAllCategories);
+router.post('/inquiry', createPackageInquiry);
+router.get('/featured', getFeaturedPackages);
+
+router.get('/inquiries', jwtAuthMiddleware, getAllInquiries);
+router.post('/', jwtAuthMiddleware, createPackage);
+router.patch('/:id', jwtAuthMiddleware, updatePackage);
+router.delete('/:id', jwtAuthMiddleware, deletePackage);
+
+router.post('/categories', jwtAuthMiddleware, createCategory);
+router.patch('/categories/:id', jwtAuthMiddleware, updateCategory);
+router.delete('/categories/:id', jwtAuthMiddleware, deleteCategory);
+
+export default router;

backend/src/routes/homepageBanner.routes.js

@@ -0,0 +1,27 @@
+import express from 'express';
+
+import {
+	createHomepageBanner,
+	getHomepageBanners,
+	getActiveHomepageBanners,
+	getHomepageBanner,
+	updateHomepageBanner,
+	deleteHomepageBanner,
+} from '../controllers/homepageBanner.controller.js';
+
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+const router = express.Router();
+
+router.get('/active', getActiveHomepageBanners);
+
+router.post('/', jwtAuthMiddleware, createHomepageBanner);
+
+router.get('/getAll', jwtAuthMiddleware, getHomepageBanners);
+router.get('/:id', jwtAuthMiddleware, getHomepageBanner);
+
+router.put('/:id', jwtAuthMiddleware, updateHomepageBanner);
+
+router.delete('/:id', jwtAuthMiddleware, deleteHomepageBanner);
+
+export default router;

backend/src/routes/importRoutes.js

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

backend/src/routes/inquiry.routes.js

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

backend/src/routes/insurancePartner.routes.js

@@ -0,0 +1,28 @@
+import express from 'express';
+
+import {
+	createInsurancePartner,
+	getInsurancePartners,
+	getActiveInsurancePartners,
+	getInsurancePartner,
+	updateInsurancePartner,
+	deleteInsurancePartner,
+} from '../controllers/insurancePartner.controller.js';
+
+import jwtAuthMiddleware from '../middleware/auth.js';
+
+const router = express.Router();
+
+router.get('/active', getActiveInsurancePartners);
+
+router.post('/', jwtAuthMiddleware, createInsurancePartner);
+
+router.get('/getAll', jwtAuthMiddleware, getInsurancePartners);
+
+router.get('/:id', jwtAuthMiddleware, getInsurancePartner);
+
+router.put('/:id', jwtAuthMiddleware, updateInsurancePartner);
+
+router.delete('/:id', jwtAuthMiddleware, deleteInsurancePartner);
+
+export default router;

backend/src/routes/newsMedia.routes.js

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

backend/src/routes/upload.routes.js

@@ -1,6 +1,6 @@
-import express from "express";
+import express from 'express';
-import * as Bytescale from "@bytescale/sdk";
+import * as Bytescale from '@bytescale/sdk';
-import multer from "multer";
+import multer from 'multer';
 
 const router = express.Router();
 
@@ -9,26 +9,26 @@ const uploadManager = new Bytescale.UploadManager({
 });
 
 const storage = multer.memoryStorage();
-const upload = multer({storage});
+const upload = multer({ storage });
 
-router.post("/", upload.single("file"), async (req, res) => {
+router.post('/', upload.single('file'), async (req, res) => {
 	try {
 		const file = req.file;
-		const {folderPath} = req.body;
+		const { folderPath } = req.body;
 
 		const result = await uploadManager.upload({
 			data: file.buffer,
 			name: file.originalname,
 			mime: file.mimetype,
 			path: {
-				folderPath: folderPath || "/general",
+				folderPath: folderPath || '/general',
 			},
 		});
 
-		res.json({fileUrl: result.fileUrl});
+		res.json({ fileUrl: result.fileUrl });
 	} catch (error) {
 		console.error(error);
-		res.status(500).json({error: "Upload failed"});
+		res.status(500).json({ error: 'Upload failed' });
 	}
 });
 

backend/src/utils/createUser.js

@@ -1,14 +1,12 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
-import { hashPassword } from "./password.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";
+	const role = process.argv[4] || 'admin';
 
 	if (!username || !password) {
-		console.log(
+		console.log('Usage: node scripts/createUser.js <username> <password> [role]');
-			"Usage: node scripts/createUser.js <username> <password> [role]",
-		);
 		process.exit(1);
 	}
 
@@ -17,7 +15,7 @@ async function main() {
 	});
 
 	if (existingUser) {
-		console.log("User already exists");
+		console.log('User already exists');
 		process.exit(1);
 	}
 
@@ -31,7 +29,7 @@ async function main() {
 		},
 	});
 
-	console.log("User created:", {
+	console.log('User created:', {
 		id: user.id,
 		username: user.username,
 		role: user.role,

backend/src/utils/getEmailByTypes.js

@@ -1,4 +1,4 @@
-import prisma from "../prisma/client.js";
+import prisma from '../prisma/client.js';
 
 export const getEmailsByType = async (type) => {
 	try {
@@ -9,9 +9,9 @@ export const getEmailsByType = async (type) => {
 			},
 		});
 
-		return emails.map((e) => e.email).join(",");
+		return emails.map((e) => e.email).join(',');
 	} catch (error) {
-		console.error("Fetch email config error:", error);
+		console.error('Fetch email config error:', error);
-		return "";
+		return '';
 	}
 };

backend/src/utils/jwt.js

@@ -1,10 +1,10 @@
-import jwt from "jsonwebtoken";
+import jwt from 'jsonwebtoken';
-import "dotenv/config";
+import 'dotenv/config';
 
 const SECRET = process.env.JWT_SECRET;
 
 export function generateToken(payload) {
-	return jwt.sign(payload, SECRET, {expiresIn: "24h"});
+	return jwt.sign(payload, SECRET, { expiresIn: '24h' });
 }
 
 export function verifyToken(token) {

backend/src/utils/password.js

@@ -1,4 +1,4 @@
-import bcrypt from "bcryptjs";
+import bcrypt from 'bcryptjs';
 
 export async function hashPassword(password) {
 	return bcrypt.hash(password, 10);

backend/src/utils/sendEmail.js

@@ -1,18 +1,18 @@
-import postmark from "postmark";
+import postmark from 'postmark';
 
 const client = new postmark.ServerClient(process.env.POSTMARK_API_KEY);
 
-export const sendEmail = async ({to, subject, html, text}) => {
+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 || "",
+			TextBody: text || '',
-			MessageStream: "outbound",
+			MessageStream: 'outbound',
 		});
 	} catch (error) {
-		console.error("Email send error:", error);
+		console.error('Email send error:', error);
 	}
 };

docker-compose.dev.yml

@@ -1,44 +1,45 @@
-version: "3.8"
+version: '3.8'
 
 services:
- backend:
+  backend:
-  build:
+    build:
-   context: .
+      context: .
-   dockerfile: docker/dev/Dockerfile.main
+      dockerfile: docker/dev/Dockerfile.main
-  ports:
+    ports:
-   - "127.0.0.1:5008:5008"
+      - '127.0.0.1:5008:5008'
-  env_file:
+    env_file:
-   - ./backend/.env
+      - ./backend/.env
-  depends_on:
+    depends_on:
-   db:
+      db:
-    condition: service_healthy
+        condition: service_healthy
-  restart: unless-stopped
+    restart: unless-stopped
 
- frontend:
+  frontend:
-  build:
+    build:
-   context: .
+      context: .
-   dockerfile: docker/dev/Dockerfile.frontend
+      dockerfile: docker/dev/Dockerfile.frontend
-  ports:
+    ports:
-   - "127.0.0.1:3008:3000"
+      - '127.0.0.1:3008:3000'
-  env_file:
+    env_file:
-   - ./frontend/.env
+      - ./frontend/.env
-  restart: unless-stopped
+    restart: unless-stopped
 
- db:
+  db:
-  image: postgres:16-alpine
+    image: postgres:16-alpine
-  container_name: postgres_db
+    environment:
-  environment:
+      - POSTGRES_USER=${POSTGRES_USER}
-   - POSTGRES_USER=${POSTGRES_USER}
+      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
-   - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
+      - POSTGRES_DB=${POSTGRES_DB}
-   - POSTGRES_DB=${POSTGRES_DB}
+    volumes:
-  volumes:
+      - postgres_data:/var/lib/postgresql/data
-   - postgres_data:/var/lib/postgresql/data
+    healthcheck:
-  healthcheck:
+      test: ['CMD-SHELL', 'pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB']
-   test: ["CMD-SHELL", "pg_isready -U $$POSTGRES_USER -d $$POSTGRES_DB"]
+      interval: 5s
-   interval: 5s
+      timeout: 5s
-   timeout: 5s
+      retries: 5
-   retries: 5
+    restart: unless-stopped
-  restart: unless-stopped
 
 volumes:
- postgres_data:
+  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/entrypoint.sh

@@ -4,10 +4,8 @@ set -e  # Exit immediately if a command exits with a non-zero status
 echo "Generating Prisma Client..."
 npx prisma generate
 
-# echo "Running migrate..."
+echo "Running migrate..."
-# npx prisma migrate deploy
+npx prisma migrate deploy
-echo "Running PUSH..."
-npx prisma db push
 
 echo "Executing command: $@"
 exec "$@"

frontend/components.json

@@ -1,25 +1,25 @@
 {
-  "$schema": "https://ui.shadcn.com/schema.json",
+	"$schema": "https://ui.shadcn.com/schema.json",
-  "style": "radix-nova",
+	"style": "radix-nova",
-  "rsc": false,
+	"rsc": false,
-  "tsx": true,
+	"tsx": true,
-  "tailwind": {
+	"tailwind": {
-    "config": "tailwind.config.js",
+		"config": "tailwind.config.js",
-    "css": "src/index.css",
+		"css": "src/index.css",
-    "baseColor": "neutral",
+		"baseColor": "neutral",
-    "cssVariables": true,
+		"cssVariables": true,
-    "prefix": ""
+		"prefix": ""
-  },
+	},
-  "iconLibrary": "lucide",
+	"iconLibrary": "lucide",
-  "rtl": false,
+	"rtl": false,
-  "aliases": {
+	"aliases": {
-    "components": "@/components",
+		"components": "@/components",
-    "utils": "@/lib/utils",
+		"utils": "@/lib/utils",
-    "ui": "@/components/ui",
+		"ui": "@/components/ui",
-    "lib": "@/lib",
+		"lib": "@/lib",
-    "hooks": "@/hooks"
+		"hooks": "@/hooks"
-  },
+	},
-  "menuColor": "default",
+	"menuColor": "default",
-  "menuAccent": "subtle",
+	"menuAccent": "subtle",
-  "registries": {}
+	"registries": {}
 }

frontend/eslint.config.js

@@ -1,23 +1,23 @@
-import js from '@eslint/js'
+import js from '@eslint/js';
-import globals from 'globals'
+import globals from 'globals';
-import reactHooks from 'eslint-plugin-react-hooks'
+import reactHooks from 'eslint-plugin-react-hooks';
-import reactRefresh from 'eslint-plugin-react-refresh'
+import reactRefresh from 'eslint-plugin-react-refresh';
-import tseslint from 'typescript-eslint'
+import tseslint from 'typescript-eslint';
-import { defineConfig, globalIgnores } from 'eslint/config'
+import { defineConfig, globalIgnores } from 'eslint/config';
 
 export default defineConfig([
-  globalIgnores(['dist']),
+	globalIgnores(['dist']),
-  {
+	{
-    files: ['**/*.{ts,tsx}'],
+		files: ['**/*.{ts,tsx}'],
-    extends: [
+		extends: [
-      js.configs.recommended,
+			js.configs.recommended,
-      tseslint.configs.recommended,
+			tseslint.configs.recommended,
-      reactHooks.configs.flat.recommended,
+			reactHooks.configs.flat.recommended,
-      reactRefresh.configs.vite,
+			reactRefresh.configs.vite,
-    ],
+		],
-    languageOptions: {
+		languageOptions: {
-      ecmaVersion: 2020,
+			ecmaVersion: 2020,
-      globals: globals.browser,
+			globals: globals.browser,
-    },
+		},
-  },
+	},
-])
+]);

frontend/package.json

@@ -1,58 +1,59 @@
 {
-  "name": "frontend",
+	"name": "frontend",
-  "private": true,
+	"private": true,
-  "version": "0.0.0",
+	"version": "0.0.0",
-  "type": "module",
+	"type": "module",
-  "scripts": {
+	"scripts": {
-    "dev": "vite",
+		"dev": "vite",
-    "build": "tsc -b && vite build",
+		"build": "tsc -b && vite build",
-    "lint": "eslint .",
+		"lint": "eslint .",
-    "preview": "vite preview"
+		"preview": "vite preview"
-  },
+	},
-  "dependencies": {
+	"dependencies": {
-    "@editorjs/code": "^2.9.4",
+		"@editorjs/code": "^2.9.4",
-    "@editorjs/delimiter": "^1.4.2",
+		"@editorjs/delimiter": "^1.4.2",
-    "@editorjs/editorjs": "^2.31.5",
+		"@editorjs/editorjs": "^2.31.5",
-    "@editorjs/embed": "^2.8.0",
+		"@editorjs/embed": "^2.8.0",
-    "@editorjs/header": "^2.8.8",
+		"@editorjs/header": "^2.8.8",
-    "@editorjs/image": "^2.10.3",
+		"@editorjs/image": "^2.10.3",
-    "@editorjs/list": "^2.0.9",
+		"@editorjs/list": "^2.0.9",
-    "@editorjs/quote": "^2.7.6",
+		"@editorjs/quote": "^2.7.6",
-    "@editorjs/table": "^2.4.5",
+		"@editorjs/table": "^2.4.5",
-    "@fontsource-variable/geist": "^5.2.8",
+		"@fontsource-variable/geist": "^5.2.8",
-    "@tailwindcss/postcss": "^4.2.1",
+		"@tailwindcss/postcss": "^4.2.1",
-    "axios": "^1.13.6",
+		"axios": "^1.13.6",
-    "class-variance-authority": "^0.7.1",
+		"class-variance-authority": "^0.7.1",
-    "clsx": "^2.1.1",
+		"clsx": "^2.1.1",
-    "cmdk": "^1.1.1",
+		"cmdk": "^1.1.1",
-    "file-saver": "^2.0.5",
+		"file-saver": "^2.0.5",
-    "lucide-react": "^0.577.0",
+		"lucide-react": "^0.577.0",
-    "radix-ui": "^1.4.3",
+		"radix-ui": "^1.4.3",
-    "react": "^19.2.0",
+		"react": "^19.2.0",
-    "react-dom": "^19.2.0",
+		"react-dom": "^19.2.0",
-    "react-router-dom": "^7.13.1",
+		"react-hot-toast": "^2.6.0",
-    "shadcn": "^4.0.5",
+		"react-router-dom": "^7.13.1",
-    "tailwind-merge": "^3.5.0",
+		"shadcn": "^4.0.5",
-    "tailwindcss": "^4.2.1",
+		"tailwind-merge": "^3.5.0",
-    "tailwindcss-animate": "^1.0.7",
+		"tailwindcss": "^4.2.1",
-    "tw-animate-css": "^1.4.0",
+		"tailwindcss-animate": "^1.0.7",
-    "xlsx": "^0.18.5"
+		"tw-animate-css": "^1.4.0",
-  },
+		"xlsx": "^0.18.5"
-  "devDependencies": {
+	},
-    "@eslint/js": "^9.39.1",
+	"devDependencies": {
-    "@types/estree": "^1.0.8",
+		"@eslint/js": "^9.39.1",
-    "@types/json-schema": "^7.0.15",
+		"@types/estree": "^1.0.8",
-    "@types/node": "^24.12.0",
+		"@types/json-schema": "^7.0.15",
-    "@types/react": "^19.2.7",
+		"@types/node": "^24.12.0",
-    "@types/react-dom": "^19.2.3",
+		"@types/react": "^19.2.7",
-    "@vitejs/plugin-react": "^5.1.4",
+		"@types/react-dom": "^19.2.3",
-    "eslint": "^9.39.1",
+		"@vitejs/plugin-react": "^5.1.4",
-    "eslint-plugin-react-hooks": "^7.0.1",
+		"eslint": "^9.39.1",
-    "eslint-plugin-react-refresh": "^0.4.24",
+		"eslint-plugin-react-hooks": "^7.0.1",
-    "globals": "^16.5.0",
+		"eslint-plugin-react-refresh": "^0.4.24",
-    "postcss": "^8.5.8",
+		"globals": "^16.5.0",
-    "typescript": "~5.9.3",
+		"postcss": "^8.5.8",
-    "typescript-eslint": "^8.48.0",
+		"typescript": "~5.9.3",
-    "vite": "^7.3.1"
+		"typescript-eslint": "^8.48.0",
-  }
+		"vite": "^7.3.1"
+	}
 }

frontend/postcss.config.js

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

frontend/src/App.tsx

@@ -1,31 +1,40 @@
-import { BrowserRouter, Routes, Route, Navigate } from "react-router-dom";
+import { BrowserRouter, Routes, Route, Navigate } from 'react-router-dom';
+import { Toaster } from 'react-hot-toast';
 
-import Login from "@/pages/Login";
+import Login from '@/pages/Login';
 
-import DashboardLayout from "./layouts/DashboardLayout";
+import DashboardLayout from './layouts/DashboardLayout';
 
 // import ProtectedRoute from "./components/ProtectedRoutes/ProtectedRoutes";
 
-import ProtectedRoute from "./auth/ProtectedRoute";
+import ProtectedRoute from './auth/ProtectedRoute';
-import PublicRoute from "./auth/PublicRoute";
+import PublicRoute from './auth/PublicRoute';
-import { AuthProvider } from "./context/AuthContext";
+import { AuthProvider } from './context/AuthContext';
-import Department from "./pages/Department";
+import Department from './pages/Department';
-import Doctor from "./pages/Doctor";
+import Doctor from './pages/Doctor';
-import Blog from "./pages/Blog";
+import Blog from './pages/Blog';
-import BlogEditorPage from "./pages/BlogEditor";
+import BlogEditorPage from './pages/BlogEditor';
-import Appointment from "./pages/Appointment";
+import Appointment from './pages/Appointment';
-import EmailPage from "./pages/email";
+import EmailPage from './pages/email';
-import CareerPage from "./pages/Career";
+import CareerPage from './pages/Career';
-import CandidatePage from "./pages/candidates";
+import CandidatePage from './pages/candidates';
-import InquiryPage from "./pages/inquiry";
+import InquiryPage from './pages/inquiry';
-import AcademicsPage from "./pages/Academics";
+import AcademicsPage from './pages/Academics';
-import NewsPage from "./pages/newsMedia";
+import NewsPage from './pages/newsMedia';
-import BlogDetail from "./pages/BlogDetails";
+import BlogDetail from './pages/BlogDetails';
-import ImportData from "./pages/ImportData";
+import ImportData from './pages/ImportData';
+import HealthPackagePage from './pages/HealthPackagePage';
+import HomepageBanner from './pages/HomepageBannerPage';
+import InsurancePartnerPage from './pages/InsurancePartner';
+import AccreditationPage from './pages/Accreditation';
+import FacilityPage from './pages/FacilityPage';
+import GoogleReviewPage from './pages/GoogleReviewPage';
 
 export default function App() {
 	return (
 		<BrowserRouter>
+			<Toaster position="top-right" />
+
 			<AuthProvider>
 				<Routes>
 					<Route element={<PublicRoute />}>
@@ -48,6 +57,12 @@ export default function App() {
 							<Route path="/academics" element={<AcademicsPage />} />
 							<Route path="/news" element={<NewsPage />} />
 							<Route path="/import" element={<ImportData />} />
+							<Route path="/health-check" element={<HealthPackagePage />} />
+							<Route path="/homepage-banner" element={<HomepageBanner />} />
+							<Route path="/insurance-partner" element={<InsurancePartnerPage />} />
+							<Route path="/accreditation" element={<AccreditationPage />} />
+							<Route path="/facility" element={<FacilityPage />} />
+							<Route path="/reviews" element={<GoogleReviewPage />} />
 						</Route>
 					</Route>
 

frontend/src/api/academics.ts

@@ -1,7 +1,7 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export const getAcademicsApi = async () => {
-	const res = await apiClient.get("/academics/getAll");
+	const res = await apiClient.get('/academics/getAll');
 	return res.data;
 };
 

frontend/src/api/accreditation.ts

@@ -0,0 +1,85 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export type AccreditationType = 'ACCREDITATION' | 'CERTIFICATION';
+
+export interface Accreditation {
+	id?: number;
+
+	title: string;
+
+	type: AccreditationType;
+
+	logo?: string;
+	image?: string;
+
+	description?: string;
+
+	sortOrder: number;
+	isActive: boolean;
+
+	createdAt?: string;
+	updatedAt?: string;
+}
+
+export const getAccreditationsApi = async (type?: AccreditationType) => {
+	const query = type ? `?type=${type}` : '';
+	const res = await apiClient.get(`/accreditation/getAll${query}`);
+
+	return res.data;
+};
+
+export const getAccreditationApi = async (id: number) => {
+	const res = await apiClient.get(`/accreditation/${id}`);
+
+	return res.data;
+};
+
+export const getActiveAccreditationsApi = async (type?: AccreditationType) => {
+	const query = type ? `?type=${type}` : '';
+	const res = await apiClient.get(`/accreditation/active${query}`);
+
+	return res.data;
+};
+
+export const createAccreditationApi = async (data: Partial<Accreditation>) => {
+	try {
+		const res = await apiClient.post('/accreditation', data);
+
+		toast.success('Accreditation created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create accreditation');
+
+		throw error;
+	}
+};
+
+export const updateAccreditationApi = async (id: number, data: Partial<Accreditation>) => {
+	try {
+		const res = await apiClient.put(`/accreditation/${id}`, data);
+
+		toast.success('Accreditation updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update accreditation');
+
+		throw error;
+	}
+};
+
+export const deleteAccreditationApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/accreditation/${id}`);
+
+		toast.success('Accreditation deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete accreditation');
+
+		throw error;
+	}
+};

frontend/src/api/appointment.ts

@@ -1,15 +1,19 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export const getAppointmentsApi = async (
 	page = 1,
 	limit = 10,
-	date = "",
+	date = '',
-	search = "",
+	startDate = '',
+	endDate = '',
+	search = ''
 ) => {
 	const params = new URLSearchParams({
 		page: String(page),
 		limit: String(limit),
 		...(date && { date }),
+		...(startDate && { startDate }),
+		...(endDate && { endDate }),
 		...(search && { search }),
 	});
 	const res = await apiClient.get(`/appointments/getall?${params}`);

frontend/src/api/auth.ts

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

frontend/src/api/blog.ts

@@ -1,4 +1,4 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export interface Blog {
 	id?: number;
@@ -9,7 +9,7 @@ export interface Blog {
 }
 
 export const getAllBlogsApi = async () => {
-	const res = await apiClient.get("/blogs");
+	const res = await apiClient.get('/blogs');
 	return res.data;
 };
 
@@ -19,7 +19,7 @@ export const getBlogByIdApi = async (id: number) => {
 };
 
 export const createBlogApi = async (data: Blog) => {
-	const res = await apiClient.post("/blogs", data);
+	const res = await apiClient.post('/blogs', data);
 	return res.data;
 };
 
@@ -36,11 +36,11 @@ export const deleteBlogApi = async (id: number) => {
 /* IMAGE UPLOAD */
 export const uploadImageApi = async (file: File) => {
 	const formData = new FormData();
-	formData.append("image", file);
+	formData.append('image', file);
 
-	const res = await apiClient.post("/upload/image", formData, {
+	const res = await apiClient.post('/upload/image', formData, {
 		headers: {
-			"Content-Type": "multipart/form-data",
+			'Content-Type': 'multipart/form-data',
 		},
 	});
 

frontend/src/api/candidates.ts

@@ -1,7 +1,7 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export const getCandidatesApi = async () => {
-	const res = await apiClient.get("/candidates/getAll");
+	const res = await apiClient.get('/candidates/getAll');
 	return res.data;
 };
 

frontend/src/api/career.ts

@@ -1,11 +1,49 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
 
 export const getCareersApi = async () => {
-	const res = await apiClient.get("/careers/getAll");
+	const res = await apiClient.get('/careers/getAll?admin=true');
 	return res.data;
 };
 
+export const createCareerApi = async (data: any) => {
+	try {
+		const res = await apiClient.post('/careers', data);
+
+		toast.success('Career created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create career');
+
+		throw error;
+	}
+};
+
+export const updateCareerApi = async (id: number, data: any) => {
+	try {
+		const res = await apiClient.patch(`/careers/${id}`, data);
+
+		toast.success('Career updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update career');
+
+		throw error;
+	}
+};
+
 export const deleteCareerApi = async (id: number) => {
-	const res = await apiClient.delete(`/careers/${id}`);
+	try {
-	return res.data;
+		const res = await apiClient.delete(`/careers/${id}`);
+
+		toast.success('Career deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete career');
+
+		throw error;
+	}
 };

frontend/src/api/client.ts

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

frontend/src/api/department.ts

@@ -1,4 +1,5 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
 
 export interface Department {
 	departmentId: string;
@@ -9,10 +10,12 @@ export interface Department {
 	para3: string;
 	facilities: string;
 	services: string;
+	isActive?: boolean;
+	sortOrder?: number;
 }
 
 export const getDepartmentsApi = async () => {
-	const res = await apiClient.get("/departments/getAll");
+	const res = await apiClient.get('/departments/getAll?admin=true');
 	return res.data;
 };
 
@@ -25,8 +28,17 @@ export const createDepartmentApi = async (data: {
 	facilities?: string;
 	services?: string;
 }) => {
-	const res = await apiClient.post("/departments", data);
+	try {
-	return res.data;
+		const res = await apiClient.post('/departments', data);
+
+		toast.success('Department created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create department');
+
+		throw error;
+	}
 };
 
 export const updateDepartmentApi = async (
@@ -38,13 +50,31 @@ export const updateDepartmentApi = async (
 		para3?: string;
 		facilities?: string;
 		services?: string;
-	},
+	}
 ) => {
-	const res = await apiClient.put(`/departments/${departmentId}`, data);
+	try {
-	return res.data;
+		const res = await apiClient.put(`/departments/${departmentId}`, data);
+
+		toast.success('Department updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update department');
+
+		throw error;
+	}
 };
 
 export const deleteDepartmentApi = async (departmentId: string) => {
-	const res = await apiClient.delete(`/departments/${departmentId}`);
+	try {
-	return res.data;
+		const res = await apiClient.delete(`/departments/${departmentId}`);
+
+		toast.success('Department deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete department');
+
+		throw error;
+	}
 };

frontend/src/api/doctor.ts

@@ -1,4 +1,5 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
 
 export interface Doctor {
 	doctorId: string;
@@ -7,8 +8,11 @@ export interface Doctor {
 	designation?: string;
 	workingStatus?: string;
 	qualification?: string;
+	isActive: boolean;
+	isFeatured: boolean;
+	globalSortOrder: number;
 
-	departments: {
+	departments?: {
 		departmentId: string;
 		timing?: {
 			monday?: string;
@@ -24,7 +28,7 @@ export interface Doctor {
 }
 
 export const getDoctorsApi = async () => {
-	const res = await apiClient.get("/doctors/getAll");
+	const res = await apiClient.get('/doctors/getAll?admin=true');
 	return res.data;
 };
 
@@ -34,21 +38,49 @@ export const getDoctorByIdApi = async (doctorId: string) => {
 };
 
 export const createDoctorApi = async (data: Doctor) => {
-	const res = await apiClient.post("/doctors", data);
+	try {
-	return res.data;
+		const res = await apiClient.post('/doctors', data);
+
+		toast.success('Doctor created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create doctor');
+
+		throw error;
+	}
 };
 
 export const updateDoctorApi = async (
 	doctorId: string,
 	data: Partial<Doctor>,
+	action: 'toggleStatus' | 'toggleFeatured' | 'updateDetails' = 'updateDetails'
 ) => {
-	const res = await apiClient.patch(`/doctors/${doctorId}`, data);
+	try {
-	return res.data;
+		const res = await apiClient.patch(`/doctors/${doctorId}/${action}`, data);
+
+		toast.success('Doctor updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update doctor');
+
+		throw error;
+	}
 };
 
 export const deleteDoctorApi = async (doctorId: string) => {
-	const res = await apiClient.delete(`/doctors/${doctorId}`);
+	try {
-	return res.data;
+		const res = await apiClient.delete(`/doctors/${doctorId}`);
+
+		toast.success('Doctor deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete doctor');
+
+		throw error;
+	}
 };
 
 export const getDoctorTimingApi = async (doctorId: string) => {

frontend/src/api/email.ts

@@ -1,4 +1,4 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export interface EmailConfig {
 	id?: number;
@@ -10,21 +10,18 @@ export interface EmailConfig {
 
 // GET ALL
 export const getEmailConfigsApi = async () => {
-	const res = await apiClient.get("/email/getAll");
+	const res = await apiClient.get('/email/getAll');
 	return res.data;
 };
 
 // CREATE
 export const createEmailConfigApi = async (data: EmailConfig) => {
-	const res = await apiClient.post("/email", data);
+	const res = await apiClient.post('/email', data);
 	return res.data;
 };
 
 // UPDATE
-export const updateEmailConfigApi = async (
+export const updateEmailConfigApi = async (id: number, data: Partial<EmailConfig>) => {
-	id: number,
-	data: Partial<EmailConfig>,
-) => {
 	const res = await apiClient.patch(`/email/${id}`, data);
 	return res.data;
 };

frontend/src/api/facility.ts

@@ -0,0 +1,93 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export interface SeoData {
+	seoTitle?: string;
+	metaDescription?: string;
+	focusKeyphrase?: string;
+	slug?: string;
+	tags?: string[];
+	ogTitle?: string;
+	ogDescription?: string;
+	ogImage?: string;
+}
+
+export interface FacilityImage {
+	id?: number;
+	url: string;
+	altText?: string;
+	description?: string;
+}
+
+export interface Facility {
+	id?: number;
+	facilityId: string;
+	name: string;
+	slug: string;
+	shortDescription?: string;
+	description?: string;
+	videoUrl?: string;
+	isActive: boolean;
+	isFeatured: boolean;
+	sortOrder: number;
+	departmentId?: number | null;
+	department?: {
+		id: number;
+		departmentId: string;
+		name: string;
+	} | null;
+	images?: FacilityImage[];
+	seo?: SeoData | null;
+}
+
+export const getAllFacilitiesApi = async () => {
+	const res = await apiClient.get('/facilities/getAll?admin=true');
+	return res.data;
+};
+
+export const getFacilityByIdApi = async (facilityId: string) => {
+	const res = await apiClient.get(`/facilities/${facilityId}`);
+	return res.data;
+};
+
+export const getFeaturedFacilitiesApi = async () => {
+	const res = await apiClient.get('/facilities/featured');
+	return res.data;
+};
+
+export const createFacilityApi = async (data: Partial<Facility> & SeoData) => {
+	try {
+		const res = await apiClient.post('/facilities', data);
+		toast.success('Facility created successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create facility');
+		throw error;
+	}
+};
+
+export const updateFacilityApi = async (
+	facilityId: string,
+	data: Partial<Facility> & SeoData,
+	action: 'toggleStatus' | 'toggleFeatured' | 'updateDetails' = 'updateDetails'
+) => {
+	try {
+		const res = await apiClient.patch(`/facilities/${facilityId}/${action}`, data);
+		toast.success('Facility updated successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update facility');
+		throw error;
+	}
+};
+
+export const deleteFacilityApi = async (facilityId: string) => {
+	try {
+		const res = await apiClient.delete(`/facilities/${facilityId}`);
+		toast.success('Facility deleted successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete facility');
+		throw error;
+	}
+};

frontend/src/api/googleReview.ts

@@ -0,0 +1,58 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export interface GoogleReview {
+	id?: number;
+	reviewerName: string;
+	reviewerImage?: string;
+	rating: number;
+	review: string;
+	reviewDate?: string | null;
+	googleReviewUrl?: string;
+	isFeatured: boolean;
+	isActive: boolean;
+	sortOrder: number;
+}
+
+export const getGoogleReviewsApi = async () => {
+	const res = await apiClient.get('/google-reviews/getAll');
+	return res.data;
+};
+
+export const getActiveGoogleReviewsApi = async () => {
+	const res = await apiClient.get('/google-reviews/active');
+	return res.data;
+};
+
+export const createGoogleReviewApi = async (data: GoogleReview) => {
+	try {
+		const res = await apiClient.post('/google-reviews', data);
+		toast.success('Google review created successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create review');
+		throw error;
+	}
+};
+
+export const updateGoogleReviewApi = async (id: number, data: Partial<GoogleReview>) => {
+	try {
+		const res = await apiClient.put(`/google-reviews/${id}`, data);
+		toast.success('Google review updated successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update review');
+		throw error;
+	}
+};
+
+export const deleteGoogleReviewApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/google-reviews/${id}`);
+		toast.success('Google review deleted successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete review');
+		throw error;
+	}
+};

frontend/src/api/healthCheck.ts

@@ -0,0 +1,155 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export interface SeoData {
+	seoTitle?: string;
+	metaDescription?: string;
+	focusKeyphrase?: string;
+	tags?: string[];
+	ogTitle?: string;
+	ogDescription?: string;
+	ogImage?: string;
+}
+export interface HealthPackage {
+	id?: number;
+	name: string;
+	slug: string;
+	description?: string;
+	price?: number;
+	image?: string;
+	discountedPrice?: number;
+	inclusions: Record<string, string[]>;
+	categoryId: number;
+	isActive: boolean;
+	isFeatured: boolean;
+	sortOrder: number;
+	seo?: SeoData | null;
+	category?: {
+		name: string;
+	};
+}
+
+export interface HealthCategory {
+	id: number;
+	name: string;
+	slug: string;
+	sortOrder: number;
+	isActive: boolean;
+}
+
+export interface HealthInquiry {
+	id: number;
+	fullName: string;
+	mobileNumber: string;
+	email?: string;
+	age: string;
+	gender: string;
+	preferredDate: string;
+	message?: string;
+	createdAt: string;
+	healthPackage?: {
+		name: string;
+		category?: {
+			name: string;
+		};
+	};
+}
+
+export const getHealthCategoriesApi = async () => {
+	const res = await apiClient.get('/health-check/categories?admin=true');
+	return res.data;
+};
+
+export const getHealthPackagesApi = async () => {
+	const res = await apiClient.get('/health-check/packages?admin=true');
+	return res.data;
+};
+
+export const createHealthPackageApi = async (data: Partial<HealthPackage>) => {
+	try {
+		const res = await apiClient.post('/health-check', data);
+		toast.success('Package created successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create package');
+		throw error;
+	}
+};
+
+export const updateHealthPackageApi = async (id: number, data: Partial<HealthPackage>) => {
+	try {
+		const res = await apiClient.patch(`/health-check/${id}`, data);
+		toast.success('Package updated successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update package');
+		throw error;
+	}
+};
+
+export const deleteHealthPackageApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/health-check/${id}`);
+		toast.success('Package deleted successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete package');
+		throw error;
+	}
+};
+
+export const createCategoryApi = async (data: { name: string; slug: string; sortOrder: number }) => {
+	try {
+		const res = await apiClient.post('/health-check/categories', data);
+
+		toast.success('Category created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create category');
+
+		throw error;
+	}
+};
+
+export const updateCategoryApi = async (id: number, data: any) => {
+	try {
+		const res = await apiClient.patch(`/health-check/categories/${id}`, data);
+
+		toast.success('Category updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update category');
+
+		throw error;
+	}
+};
+
+export const deleteCategoryApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/health-check/categories/${id}`);
+
+		toast.success('Category deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete category');
+
+		throw error;
+	}
+};
+
+export const getAllInquiriesApi = async (page = 1, limit = 10, filterDate = '', startDate = '', endDate = '') => {
+	const params = new URLSearchParams({
+		page: page.toString(),
+		limit: limit.toString(),
+	});
+
+	if (filterDate) params.append('filterDate', filterDate);
+	if (startDate) params.append('startDate', startDate);
+	if (endDate) params.append('endDate', endDate);
+
+	const res = await apiClient.get(`/health-check/inquiries?${params.toString()}`);
+	return res.data;
+};

frontend/src/api/homepageBanner.ts

@@ -0,0 +1,83 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export type BannerMediaType = 'IMAGE' | 'VIDEO';
+
+export interface HomepageBanner {
+	id?: number;
+
+	title?: string;
+	subtitle?: string;
+
+	mediaType: BannerMediaType;
+
+	desktopMediaUrl: string;
+	mobileMediaUrl?: string;
+
+	buttonText?: string;
+	buttonLink?: string;
+
+	openInNewTab: boolean;
+
+	textAlignment?: 'left' | 'center' | 'right';
+
+	sortOrder: number;
+	isActive: boolean;
+
+	createdAt?: string;
+	updatedAt?: string;
+}
+
+export const getHomepageBannersApi = async () => {
+	const res = await apiClient.get('/homepage-banners/getAll');
+	return res.data;
+};
+
+export const getHomepageBannerApi = async (id: number) => {
+	const res = await apiClient.get(`/homepage-banners/${id}`);
+	return res.data;
+};
+
+export const getActiveHomepageBannersApi = async () => {
+	const res = await apiClient.get('/homepage-banners/active');
+	return res.data;
+};
+
+export const createHomepageBannerApi = async (data: Partial<HomepageBanner>) => {
+	try {
+		const res = await apiClient.post('/homepage-banners', data);
+
+		toast.success('Banner created successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create banner');
+		throw error;
+	}
+};
+
+export const updateHomepageBannerApi = async (id: number, data: Partial<HomepageBanner>) => {
+	try {
+		const res = await apiClient.put(`/homepage-banners/${id}`, data);
+
+		toast.success('Banner updated successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update banner');
+		throw error;
+	}
+};
+
+export const deleteHomepageBannerApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/homepage-banners/${id}`);
+
+		toast.success('Banner deleted successfully');
+
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete banner');
+		throw error;
+	}
+};

frontend/src/api/inquiry.ts

@@ -1,7 +1,7 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
 export const getInquiriesApi = async () => {
-	const res = await apiClient.get("/inquiry/getAll");
+	const res = await apiClient.get('/inquiry/getAll');
 	return res.data;
 };
 

frontend/src/api/insurancePartner.ts

@@ -0,0 +1,61 @@
+import apiClient from '@/api/client';
+import toast from 'react-hot-toast';
+
+export interface InsurancePartner {
+	id?: number;
+	name: string;
+	logo: string;
+	websiteUrl?: string;
+	sortOrder: number;
+	isActive: boolean;
+	createdAt?: string;
+	updatedAt?: string;
+}
+
+export const getInsurancePartnersApi = async () => {
+	const res = await apiClient.get('/insurance-partners/getAll');
+	return res.data;
+};
+
+export const getInsurancePartnerApi = async (id: number) => {
+	const res = await apiClient.get(`/insurance-partners/${id}`);
+	return res.data;
+};
+
+export const getActiveInsurancePartnersApi = async () => {
+	const res = await apiClient.get('/insurance-partners/active');
+	return res.data;
+};
+
+export const createInsurancePartnerApi = async (data: Partial<InsurancePartner>) => {
+	try {
+		const res = await apiClient.post('/insurance-partners', data);
+		toast.success('Insurance partner created successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to create insurance partner');
+		throw error;
+	}
+};
+
+export const updateInsurancePartnerApi = async (id: number, data: Partial<InsurancePartner>) => {
+	try {
+		const res = await apiClient.put(`/insurance-partners/${id}`, data);
+		toast.success('Insurance partner updated successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to update insurance partner');
+		throw error;
+	}
+};
+
+export const deleteInsurancePartnerApi = async (id: number) => {
+	try {
+		const res = await apiClient.delete(`/insurance-partners/${id}`);
+		toast.success('Insurance partner deleted successfully');
+		return res.data;
+	} catch (error: any) {
+		toast.error(error?.response?.data?.message || 'Failed to delete insurance partner');
+		throw error;
+	}
+};

frontend/src/api/newsMedia.ts

@@ -1,14 +1,12 @@
-import apiClient from "@/api/client";
+import apiClient from '@/api/client';
 
-export const getNewsApi = async (page = 1, limit = 10) => {
+export const getNewsApi = async (page = 1, limit = 10, search = '') => {
-	const res = await apiClient.get(
+	const res = await apiClient.get(`/newsMedia/getAll?page=${page}&limit=${limit}&search=${search}`);
-		`/newsMedia/getAll?page=${page}&limit=${limit}`,
-	);
 	return res.data;
 };
 
 export const createNewsApi = async (data: any) => {
-	const res = await apiClient.post("/newsMedia", data);
+	const res = await apiClient.post('/newsMedia', data);
 	return res.data;
 };
 

frontend/src/auth/ProtectedRoute.tsx

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

frontend/src/auth/PublicRoute.tsx

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