Compare commits
2 Commits
| Author | SHA1 | Date | |
|---|---|---|---|
| 01998b3413 | |||
| 4750390368 |
@@ -0,0 +1,37 @@
|
|||||||
|
/*
|
||||||
|
Warnings:
|
||||||
|
|
||||||
|
- You are about to drop the `HealthCheckCategory` table. If the table is not empty, all the data it contains will be lost.
|
||||||
|
- You are about to drop the `HealthPackage` table. If the table is not empty, all the data it contains will be lost.
|
||||||
|
- You are about to drop the `HealthPackageInquiry` table. If the table is not empty, all the data it contains will be lost.
|
||||||
|
|
||||||
|
*/
|
||||||
|
-- DropForeignKey
|
||||||
|
ALTER TABLE "HealthPackage" DROP CONSTRAINT "HealthPackage_categoryId_fkey";
|
||||||
|
|
||||||
|
-- DropForeignKey
|
||||||
|
ALTER TABLE "HealthPackageInquiry" DROP CONSTRAINT "HealthPackageInquiry_packageId_fkey";
|
||||||
|
|
||||||
|
-- DropTable
|
||||||
|
DROP TABLE "HealthCheckCategory";
|
||||||
|
|
||||||
|
-- DropTable
|
||||||
|
DROP TABLE "HealthPackage";
|
||||||
|
|
||||||
|
-- DropTable
|
||||||
|
DROP TABLE "HealthPackageInquiry";
|
||||||
|
|
||||||
|
-- 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")
|
||||||
|
);
|
||||||
|
|
||||||
|
-- AddForeignKey
|
||||||
|
ALTER TABLE "DoctorSpecialization" ADD CONSTRAINT "DoctorSpecialization_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
||||||
@@ -0,0 +1,2 @@
|
|||||||
|
-- AlterTable
|
||||||
|
ALTER TABLE "Doctor" ADD COLUMN "professionalSummary" TEXT;
|
||||||
@@ -0,0 +1,7 @@
|
|||||||
|
-- AlterTable
|
||||||
|
ALTER TABLE "Doctor" ADD COLUMN "experience" INTEGER,
|
||||||
|
ADD COLUMN "focusKeyphrase" TEXT,
|
||||||
|
ADD COLUMN "metaDescription" TEXT,
|
||||||
|
ADD COLUMN "seoTitle" TEXT,
|
||||||
|
ADD COLUMN "slug" TEXT,
|
||||||
|
ADD COLUMN "tags" TEXT[];
|
||||||
@@ -0,0 +1,4 @@
|
|||||||
|
-- AlterTable
|
||||||
|
ALTER TABLE "Doctor" ADD COLUMN "ogDescription" TEXT,
|
||||||
|
ADD COLUMN "ogImage" TEXT,
|
||||||
|
ADD COLUMN "ogTitle" TEXT;
|
||||||
@@ -0,0 +1,19 @@
|
|||||||
|
-- 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");
|
||||||
@@ -0,0 +1,30 @@
|
|||||||
|
/*
|
||||||
|
Warnings:
|
||||||
|
|
||||||
|
- You are about to drop the column `focusKeyphrase` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `metaDescription` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `ogDescription` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `ogImage` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `ogTitle` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `seoTitle` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `slug` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- You are about to drop the column `tags` on the `Doctor` table. All the data in the column will be lost.
|
||||||
|
- 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" DROP COLUMN "focusKeyphrase",
|
||||||
|
DROP COLUMN "metaDescription",
|
||||||
|
DROP COLUMN "ogDescription",
|
||||||
|
DROP COLUMN "ogImage",
|
||||||
|
DROP COLUMN "ogTitle",
|
||||||
|
DROP COLUMN "seoTitle",
|
||||||
|
DROP COLUMN "slug",
|
||||||
|
DROP COLUMN "tags",
|
||||||
|
ADD COLUMN "seoId" INTEGER;
|
||||||
|
|
||||||
|
-- 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;
|
||||||
@@ -0,0 +1,66 @@
|
|||||||
|
-- CreateTable
|
||||||
|
CREATE TABLE "HealthCheckCategory" (
|
||||||
|
"id" SERIAL NOT NULL,
|
||||||
|
"name" TEXT NOT NULL,
|
||||||
|
"slug" TEXT,
|
||||||
|
"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),
|
||||||
|
"image" TEXT,
|
||||||
|
"discountedPrice" DECIMAL(10,2),
|
||||||
|
"inclusions" JSONB NOT NULL DEFAULT '{}',
|
||||||
|
"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,
|
||||||
|
"age" INTEGER,
|
||||||
|
"gender" 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;
|
||||||
@@ -1,50 +0,0 @@
|
|||||||
/*
|
|
||||||
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;
|
|
||||||
@@ -1,2 +0,0 @@
|
|||||||
-- AlterTable
|
|
||||||
ALTER TABLE "Doctor" ADD COLUMN "experience" INTEGER;
|
|
||||||
@@ -28,13 +28,12 @@ model Doctor {
|
|||||||
qualification String?
|
qualification String?
|
||||||
isActive Boolean @default(true)
|
isActive Boolean @default(true)
|
||||||
globalSortOrder Int @default(1000)
|
globalSortOrder Int @default(1000)
|
||||||
|
departments DoctorDepartment[]
|
||||||
|
appointments Appointment[]
|
||||||
specializations DoctorSpecialization[]
|
specializations DoctorSpecialization[]
|
||||||
professionalSummary String? @db.Text
|
professionalSummary String? @db.Text
|
||||||
seoId Int? @unique
|
seoId Int? @unique
|
||||||
seo Seo? @relation(fields: [seoId], references: [id])
|
seo Seo? @relation(fields: [seoId], references: [id])
|
||||||
departments DoctorDepartment[]
|
|
||||||
appointments Appointment[]
|
|
||||||
|
|
||||||
createdAt DateTime @default(now())
|
createdAt DateTime @default(now())
|
||||||
updatedAt DateTime @updatedAt
|
updatedAt DateTime @updatedAt
|
||||||
}
|
}
|
||||||
@@ -224,7 +223,6 @@ model NewsImage {
|
|||||||
|
|
||||||
createdAt DateTime @default(now())
|
createdAt DateTime @default(now())
|
||||||
}
|
}
|
||||||
|
|
||||||
model HealthCheckCategory {
|
model HealthCheckCategory {
|
||||||
id Int @id @default(autoincrement())
|
id Int @id @default(autoincrement())
|
||||||
name String @unique
|
name String @unique
|
||||||
@@ -280,8 +278,6 @@ model HealthPackageInquiry {
|
|||||||
createdAt DateTime @default(now())
|
createdAt DateTime @default(now())
|
||||||
updatedAt DateTime @updatedAt
|
updatedAt DateTime @updatedAt
|
||||||
}
|
}
|
||||||
|
|
||||||
|
|
||||||
model DoctorSpecialization {
|
model DoctorSpecialization {
|
||||||
id Int @id @default(autoincrement())
|
id Int @id @default(autoincrement())
|
||||||
name String
|
name String
|
||||||
|
|||||||
@@ -240,22 +240,6 @@ export const createDoctor = async (req, res) => {
|
|||||||
ogDescription,
|
ogDescription,
|
||||||
ogImage,
|
ogImage,
|
||||||
} = req.body;
|
} = 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({
|
const seo = await prisma.seo.create({
|
||||||
data: {
|
data: {
|
||||||
seoTitle,
|
seoTitle,
|
||||||
@@ -340,7 +324,7 @@ export const createDoctor = async (req, res) => {
|
|||||||
//update doctors
|
//update doctors
|
||||||
export const updateDoctor = async (req, res) => {
|
export const updateDoctor = async (req, res) => {
|
||||||
try {
|
try {
|
||||||
const {doctorId, action} = req.params;
|
const {doctorId} = req.params;
|
||||||
const {
|
const {
|
||||||
name,
|
name,
|
||||||
designation,
|
designation,
|
||||||
@@ -359,49 +343,12 @@ export const updateDoctor = async (req, res) => {
|
|||||||
tags,
|
tags,
|
||||||
specializations,
|
specializations,
|
||||||
} = req.body;
|
} = req.body;
|
||||||
if (!doctorId) {
|
|
||||||
return res.status(400).json({
|
|
||||||
success: false,
|
|
||||||
message: "Doctor ID is required",
|
|
||||||
});
|
|
||||||
}
|
|
||||||
const doctor = await prisma.doctor.findUnique({where: {doctorId}});
|
const doctor = await prisma.doctor.findUnique({where: {doctorId}});
|
||||||
if (!doctor)
|
if (!doctor)
|
||||||
return res
|
return res
|
||||||
.status(404)
|
.status(404)
|
||||||
.json({success: false, message: "Doctor not found"});
|
.json({success: false, message: "Doctor not found"});
|
||||||
if (action === "toggleStatus") {
|
|
||||||
await prisma.doctor.update({
|
|
||||||
where: {id: doctor.id},
|
|
||||||
data: {
|
|
||||||
isActive: !doctor.isActive,
|
|
||||||
},
|
|
||||||
});
|
|
||||||
|
|
||||||
return res.status(200).json({
|
|
||||||
success: true,
|
|
||||||
message: `Doctor has been ${
|
|
||||||
doctor.isActive ? "deactivated" : "activated"
|
|
||||||
} successfully`,
|
|
||||||
});
|
|
||||||
}
|
|
||||||
|
|
||||||
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({
|
await prisma.doctor.update({
|
||||||
where: {id: doctor.id},
|
where: {id: doctor.id},
|
||||||
@@ -418,7 +365,6 @@ export const updateDoctor = async (req, res) => {
|
|||||||
globalSortOrder !== undefined ? Number(globalSortOrder) : undefined,
|
globalSortOrder !== undefined ? Number(globalSortOrder) : undefined,
|
||||||
},
|
},
|
||||||
});
|
});
|
||||||
|
|
||||||
if (doctor.seoId) {
|
if (doctor.seoId) {
|
||||||
await prisma.seo.update({
|
await prisma.seo.update({
|
||||||
where: {
|
where: {
|
||||||
@@ -453,66 +399,9 @@ export const updateDoctor = async (req, res) => {
|
|||||||
});
|
});
|
||||||
}
|
}
|
||||||
|
|
||||||
// Update Departments & Timings
|
const hasTimingData = departments?.some(
|
||||||
if (Array.isArray(departments)) {
|
(dep) => dep.timing && Object.keys(dep.timing).length > 0,
|
||||||
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
|
// Update Specializations
|
||||||
if (Array.isArray(specializations)) {
|
if (Array.isArray(specializations)) {
|
||||||
@@ -535,6 +424,45 @@ export const updateDoctor = async (req, res) => {
|
|||||||
}
|
}
|
||||||
}
|
}
|
||||||
|
|
||||||
|
if (departments && Array.isArray(departments) && hasTimingData) {
|
||||||
|
const oldRelations = await prisma.doctorDepartment.findMany({
|
||||||
|
where: {doctorId: doctor.id},
|
||||||
|
});
|
||||||
|
|
||||||
|
for (const rel of oldRelations) {
|
||||||
|
await prisma.doctorTiming.deleteMany({
|
||||||
|
where: {doctorDepartmentId: rel.id},
|
||||||
|
});
|
||||||
|
}
|
||||||
|
|
||||||
|
await prisma.doctorDepartment.deleteMany({
|
||||||
|
where: {doctorId: doctor.id},
|
||||||
|
});
|
||||||
|
|
||||||
|
for (const dep of departments) {
|
||||||
|
const targetDept = await prisma.department.findUnique({
|
||||||
|
where: {departmentId: dep.departmentId},
|
||||||
|
});
|
||||||
|
if (!targetDept) continue;
|
||||||
|
|
||||||
|
const newDD = await prisma.doctorDepartment.create({
|
||||||
|
data: {
|
||||||
|
doctorId: doctor.id,
|
||||||
|
departmentId: targetDept.id,
|
||||||
|
sortOrder: dep.sortOrder !== undefined ? Number(dep.sortOrder) : 0,
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
if (dep.timing) {
|
||||||
|
const {id, doctorDepartmentId, createdAt, updatedAt, ...cleanTiming} =
|
||||||
|
dep.timing;
|
||||||
|
await prisma.doctorTiming.create({
|
||||||
|
data: {doctorDepartmentId: newDD.id, ...cleanTiming},
|
||||||
|
});
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
res
|
res
|
||||||
.status(200)
|
.status(200)
|
||||||
.json({success: true, message: "Doctor updated successfully"});
|
.json({success: true, message: "Doctor updated successfully"});
|
||||||
|
|||||||
@@ -21,7 +21,7 @@ router.get("/getTimings/:doctorId", getDoctorTimingById);
|
|||||||
router.get("/:doctorId", getDoctorByDoctorId);
|
router.get("/:doctorId", getDoctorByDoctorId);
|
||||||
|
|
||||||
router.post("/", jwtAuthMiddleware, createDoctor);
|
router.post("/", jwtAuthMiddleware, createDoctor);
|
||||||
router.patch("/:doctorId/:action", jwtAuthMiddleware, updateDoctor);
|
router.patch("/:doctorId", jwtAuthMiddleware, updateDoctor);
|
||||||
router.delete("/:doctorId", jwtAuthMiddleware, deleteDoctor);
|
router.delete("/:doctorId", jwtAuthMiddleware, deleteDoctor);
|
||||||
|
|
||||||
export default router;
|
export default router;
|
||||||
|
|||||||
@@ -4,8 +4,10 @@ set -e # Exit immediately if a command exits with a non-zero status
|
|||||||
echo "Generating Prisma Client..."
|
echo "Generating Prisma Client..."
|
||||||
npx prisma generate
|
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: $@"
|
echo "Executing command: $@"
|
||||||
exec "$@"
|
exec "$@"
|
||||||
|
|||||||
@@ -53,10 +53,9 @@ export const createDoctorApi = async (data: Doctor) => {
|
|||||||
export const updateDoctorApi = async (
|
export const updateDoctorApi = async (
|
||||||
doctorId: string,
|
doctorId: string,
|
||||||
data: Partial<Doctor>,
|
data: Partial<Doctor>,
|
||||||
action: "toggleStatus" | "updateDetails" = "updateDetails",
|
|
||||||
) => {
|
) => {
|
||||||
try {
|
try {
|
||||||
const res = await apiClient.patch(`/doctors/${doctorId}/${action}`, data);
|
const res = await apiClient.patch(`/doctors/${doctorId}`, data);
|
||||||
|
|
||||||
toast.success("Doctor updated successfully");
|
toast.success("Doctor updated successfully");
|
||||||
|
|
||||||
|
|||||||
@@ -167,16 +167,8 @@ export default function DoctorPage() {
|
|||||||
const currentItems = filteredDoctors.slice(indexOfFirstItem, indexOfLastItem);
|
const currentItems = filteredDoctors.slice(indexOfFirstItem, indexOfLastItem);
|
||||||
|
|
||||||
function handleChange(e: any) {
|
function handleChange(e: any) {
|
||||||
let value =
|
const value =
|
||||||
e.target.type === "number" ? Number(e.target.value) : e.target.value;
|
e.target.type === "number" ? Number(e.target.value) : e.target.value;
|
||||||
if (e.target.name === "slug") {
|
|
||||||
value = value
|
|
||||||
.toLowerCase()
|
|
||||||
.replace(/\s+/g, "-") // replace spaces with -
|
|
||||||
.replace(/[^\w-]+/g, "") // remove special chars
|
|
||||||
.replace(/--+/g, "-"); // remove duplicate -
|
|
||||||
}
|
|
||||||
|
|
||||||
setForm({ ...form, [e.target.name]: value });
|
setForm({ ...form, [e.target.name]: value });
|
||||||
}
|
}
|
||||||
|
|
||||||
@@ -188,7 +180,7 @@ export default function DoctorPage() {
|
|||||||
isActive: newStatus,
|
isActive: newStatus,
|
||||||
};
|
};
|
||||||
|
|
||||||
await updateDoctorApi(doc.doctorId, payload, "toggleStatus");
|
await updateDoctorApi(doc.doctorId, payload);
|
||||||
|
|
||||||
fetchAll();
|
fetchAll();
|
||||||
} catch (err) {
|
} catch (err) {
|
||||||
|
|||||||
@@ -1,5 +1,4 @@
|
|||||||
import { useState, useEffect, useCallback, useMemo } from "react";
|
import { useState, useEffect, useCallback, useMemo } from "react";
|
||||||
import toast from "react-hot-toast";
|
|
||||||
import { AxiosError } from "axios";
|
import { AxiosError } from "axios";
|
||||||
import { BytescaleUploader } from "@/components/BytescaleUploader/BytescaleUploader";
|
import { BytescaleUploader } from "@/components/BytescaleUploader/BytescaleUploader";
|
||||||
|
|
||||||
@@ -165,11 +164,9 @@ export default function HealthPackagePage() {
|
|||||||
if (!pkg.id) return;
|
if (!pkg.id) return;
|
||||||
try {
|
try {
|
||||||
await updateHealthPackageApi(pkg.id, { isActive: !pkg.isActive });
|
await updateHealthPackageApi(pkg.id, { isActive: !pkg.isActive });
|
||||||
toast.success(`Package ${pkg.isActive ? "hidden" : "activated"}`);
|
|
||||||
fetchData();
|
fetchData();
|
||||||
} catch (err) {
|
} catch (err) {
|
||||||
console.error("Failed to update status", err);
|
console.error("Failed to update status", err);
|
||||||
toast.error("Failed to update status");
|
|
||||||
}
|
}
|
||||||
};
|
};
|
||||||
const handleToggleCategoryStatus = async (cat: HealthCategory) => {
|
const handleToggleCategoryStatus = async (cat: HealthCategory) => {
|
||||||
@@ -183,21 +180,13 @@ export default function HealthPackagePage() {
|
|||||||
}
|
}
|
||||||
|
|
||||||
await updateCategoryApi(cat.id, { isActive: !cat.isActive });
|
await updateCategoryApi(cat.id, { isActive: !cat.isActive });
|
||||||
toast.success(`Category ${cat.isActive ? "hidden" : "activated"}`);
|
|
||||||
fetchData();
|
fetchData();
|
||||||
} catch (err) {
|
} catch (err) {
|
||||||
console.error("Failed to update category status", err);
|
console.error("Failed to update category status", err);
|
||||||
toast.error("Failed to update category status");
|
|
||||||
}
|
}
|
||||||
};
|
};
|
||||||
|
|
||||||
const openAddPackage = () => {
|
const openAddPackage = () => {
|
||||||
if (categories.length === 0) {
|
|
||||||
toast.error(
|
|
||||||
"Please create at least one category before attempting to add a health package.",
|
|
||||||
);
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
setEditingPackage(null);
|
setEditingPackage(null);
|
||||||
setPkgForm({
|
setPkgForm({
|
||||||
name: "",
|
name: "",
|
||||||
@@ -265,27 +254,6 @@ export default function HealthPackagePage() {
|
|||||||
};
|
};
|
||||||
|
|
||||||
const savePackage = async () => {
|
const savePackage = async () => {
|
||||||
if (!pkgForm.image) return toast.error("Package image is required.");
|
|
||||||
if (!pkgForm.name?.trim()) return toast.error("Package Name is required.");
|
|
||||||
if (!pkgForm.slug?.trim()) return toast.error("URL Slug is required.");
|
|
||||||
if (!pkgForm.categoryId)
|
|
||||||
return toast.error("Please select a valid category.");
|
|
||||||
if (pkgForm.price === undefined || pkgForm.price <= 0)
|
|
||||||
return toast.error(
|
|
||||||
"Regular Price must be a valid amount greater than 0.",
|
|
||||||
);
|
|
||||||
if (!pkgForm.description?.trim())
|
|
||||||
return toast.error("Description is required.");
|
|
||||||
|
|
||||||
const structureFilled = inclusionsList.some(
|
|
||||||
(item) => item.category.trim() !== "" && item.items.trim() !== "",
|
|
||||||
);
|
|
||||||
if (!structureFilled) {
|
|
||||||
return toast.error(
|
|
||||||
"Please provide at least one valid Category Group with tests inside it.",
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
try {
|
try {
|
||||||
// Convert the dynamic array back into the required JSON object format
|
// Convert the dynamic array back into the required JSON object format
|
||||||
const parsedInclusions: Record<string, string[]> = {};
|
const parsedInclusions: Record<string, string[]> = {};
|
||||||
@@ -321,25 +289,18 @@ export default function HealthPackagePage() {
|
|||||||
}
|
}
|
||||||
|
|
||||||
await updateHealthPackageApi(editingPackage.id, changedFields);
|
await updateHealthPackageApi(editingPackage.id, changedFields);
|
||||||
toast.success("Package updated successfully!");
|
|
||||||
} else {
|
} else {
|
||||||
await createHealthPackageApi(finalData);
|
await createHealthPackageApi(finalData);
|
||||||
toast.success("Package created successfully!");
|
|
||||||
}
|
}
|
||||||
|
|
||||||
setPackageModal(false);
|
setPackageModal(false);
|
||||||
fetchData();
|
fetchData();
|
||||||
} catch (err) {
|
} catch (err) {
|
||||||
console.error(err);
|
console.error(err);
|
||||||
toast.error(
|
|
||||||
"An unexpected system error occurred while trying to save the package.",
|
|
||||||
);
|
|
||||||
}
|
}
|
||||||
};
|
};
|
||||||
|
|
||||||
const saveCategory = async () => {
|
const saveCategory = async () => {
|
||||||
if (!catForm.name?.trim()) return toast.error("Category Name is required.");
|
|
||||||
|
|
||||||
try {
|
try {
|
||||||
if (editingCategory?.id) {
|
if (editingCategory?.id) {
|
||||||
const changedFields: Record<string, any> = {};
|
const changedFields: Record<string, any> = {};
|
||||||
@@ -363,30 +324,21 @@ export default function HealthPackagePage() {
|
|||||||
editingCategory.id,
|
editingCategory.id,
|
||||||
changedFields as Partial<HealthCategory>,
|
changedFields as Partial<HealthCategory>,
|
||||||
);
|
);
|
||||||
toast.success("Category updated successfully!");
|
|
||||||
} else {
|
} else {
|
||||||
await createCategoryApi(catForm as any);
|
await createCategoryApi(catForm as any);
|
||||||
toast.success("Category created successfully!");
|
|
||||||
}
|
}
|
||||||
|
|
||||||
setCategoryModal(false);
|
setCategoryModal(false);
|
||||||
fetchData();
|
fetchData();
|
||||||
} catch (err) {
|
} catch (err) {
|
||||||
console.error(err);
|
console.error(err);
|
||||||
toast.error("An error occurred while saving the category.");
|
|
||||||
}
|
}
|
||||||
};
|
};
|
||||||
|
|
||||||
const deleteCategory = async (id: number) => {
|
const deleteCategory = async (id: number) => {
|
||||||
if (confirm("Delete this category? Ensure no packages are linked to it.")) {
|
if (confirm("Delete this category? Ensure no packages are linked to it.")) {
|
||||||
try {
|
|
||||||
await deleteCategoryApi(id);
|
await deleteCategoryApi(id);
|
||||||
toast.success("Category deleted successfully!");
|
|
||||||
fetchData();
|
fetchData();
|
||||||
} catch (err) {
|
|
||||||
console.error(err);
|
|
||||||
toast.error("Failed to delete category.");
|
|
||||||
}
|
|
||||||
}
|
}
|
||||||
};
|
};
|
||||||
|
|
||||||
@@ -737,7 +689,7 @@ export default function HealthPackagePage() {
|
|||||||
<div className="space-y-4">
|
<div className="space-y-4">
|
||||||
<div className="space-y-2">
|
<div className="space-y-2">
|
||||||
<Label className="text-sm font-semibold">
|
<Label className="text-sm font-semibold">
|
||||||
Package Image(Dimensions: 650w x 250h)
|
Package Image
|
||||||
</Label>
|
</Label>
|
||||||
|
|
||||||
<BytescaleUploader
|
<BytescaleUploader
|
||||||
@@ -997,6 +949,16 @@ export default function HealthPackagePage() {
|
|||||||
className="text-base"
|
className="text-base"
|
||||||
/>
|
/>
|
||||||
</div>
|
</div>
|
||||||
|
{/* <div className="space-y-1">
|
||||||
|
<Label className="text-sm font-semibold">URL Slug</Label>
|
||||||
|
<Input
|
||||||
|
value={catForm.slug}
|
||||||
|
onChange={(e) =>
|
||||||
|
setCatForm({ ...catForm, slug: e.target.value })
|
||||||
|
}
|
||||||
|
className="text-base"
|
||||||
|
/>
|
||||||
|
</div> */}
|
||||||
|
|
||||||
<div className="space-y-1">
|
<div className="space-y-1">
|
||||||
<Label className="text-sm font-semibold">Sort Order</Label>
|
<Label className="text-sm font-semibold">Sort Order</Label>
|
||||||
|
|||||||
Reference in New Issue
Block a user