feat: update REQ0187 requirements with TODO items for nav bar cleanup and status change implementation

01_Requirements/REQ0181/index.md

@@ -0,0 +1,9 @@
+---
+tags: frontend, side-menu
+---
+
+# REQ0181 frontend side menu configuration
+
+## sources
+
+`src/layouts/nav-config-dashboard.tsx`

01_Requirements/REQ0182/index.md

@@ -0,0 +1,11 @@
+---
+tags: frontend, product, details
+---
+
+# REQ0182 frontend product details
+
+frontend page to display product details
+
+## sources
+
+T.B.A.

01_Requirements/REQ0183/index.md

@@ -0,0 +1,15 @@
+---
+tags: frontend, product, new
+---
+
+# REQ0183 frontend product new
+
+frontend page to create new product
+
+## sources
+
+T.B.A.
+
+## branch
+
+develop/requirements/REQ0183

01_Requirements/REQ0184/index.md

@@ -0,0 +1,17 @@
+---
+tags: frontend, product, delete
+---
+
+# REQ0184 frontend product delete
+
+frontend page to delete product
+
+list page
+
+## sources
+
+T.B.A.
+
+## branch
+
+develop/requirements/REQ0184

01_Requirements/REQ0185/index.md

@@ -0,0 +1,18 @@
+---
+tags: frontend, party-event
+---
+
+# REQ0185 frontend party-event
+
+frontend page to handle party-event (CRUD)
+
+edit page T.B.A.
+
+## sources
+
+T.B.A.
+
+## branch
+
+develop/frontend/party-event/trunk
+develop/requirements/REQ0185

01_Requirements/REQ0186/index.md

@@ -0,0 +1,17 @@
+---
+tags: frontend, product, update
+---
+
+# REQ0185 frontend product update
+
+frontend page to update product
+
+edit page T.B.A.
+
+## sources
+
+T.B.A.
+
+## branch
+
+develop/requirements/REQ0185

01_Requirements/REQ0187/index.md

@@ -0,0 +1,23 @@
+---
+tags: frontend, party-order
+---
+
+# REQ0185 frontend party-order
+
+frontend page to handle party-order (CRUD)
+
+edit page T.B.A.
+
+## TODO
+
+- remove detail in left nav bar
+- implement `changeStatus`
+
+## sources
+
+T.B.A.
+
+## branch
+
+develop/frontend/party-order/trunk
+develop/requirements/REQ0187

01_Requirements/index.md

@@ -158,3 +158,8 @@
 - [REQ0169: DemoStorageExample](./REQ0169/index.md)
 - [REQ0170: DemoWeatherAppUi](./REQ0170/index.md)
 - [REQ0180: REQ0180 service port schedule](./REQ0180/index.md)
+- [REQ0181: REQ0181 frontend side menu configuration](./REQ0181/index.md)
+- [REQ0182: REQ0182 frontend product details](./REQ0182/index.md)
+- [REQ0183: REQ0183 frontend product new](./REQ0183/index.md)
+- [REQ0184: REQ0184 frontend product delete](./REQ0184/index.md)
+- [REQ0185: REQ0185 frontend product update](./REQ0185/index.md)

03_source/cms_backend/.gitignore

@@ -1,3 +1,7 @@
+**/*del
+**/*bak
+**/*copy*
+
 # Logs
 logs
 *.log

03_source/cms_backend/package.json

@@ -5,6 +5,7 @@
   "description": "Mock server & assets",
   "private": true,
   "scripts": {
+    "dev:check": "yarn tsc:w",
     "dev": "next dev -p 7272 -H 0.0.0.0",
     "start": "next start -p 7272 -H 0.0.0.0",
     "build": "next build",
@@ -19,8 +20,10 @@
     "re:build": "yarn clean && yarn install && yarn build",
     "re:build-npm": "npm run clean && npm install && npm run build",
     "tsc:dev": "yarn dev & yarn tsc:watch",
-    "tsc:watch": "tsc --noEmit --watch",
     "tsc:print": "npx tsc --showConfig",
+    "tsc:w": "npx nodemon --delay 1 --ext ts,tsx --exec \"yarn tsc\"",
+    "tsc:watch": "tsc --noEmit --watch",
+    "tsc": "tsc --noEmit",
     "migrate": "npx prisma migrate dev --skip-seed",
     "seed": "tsx ./prisma/seed.ts",
     "seed:w": "npx nodemon --ext \"ts,tsx,json\" -w prisma --exec \"yarn seed\"",
@@ -29,7 +32,9 @@
     "db:push": "prisma db push --force-reset",
     "db:push:w": "npx nodemon --delay 1 --watch prisma --ext \"ts,tsx,prisma\" --exec \"yarn db:push && yarn seed\"",
     "db:studio": "prisma studio",
-    "db:studio:w": "npx nodemon --delay 1 --watch prisma --ext \"prisma\" --exec \"yarn db:studio\""
+    "db:studio:w": "npx nodemon --delay 1 --watch prisma --ext \"prisma\" --exec \"yarn db:studio\"",
+    "db:dev": "yarn db:push && yarn seed && yarn dev",
+    "db:dev:w": "npx nodemon --delay 3  --ext \"ts,tsx,prisma\" --exec \"yarn db:dev\""
   },
   "engines": {
     "node": ">=20"
@@ -66,6 +71,7 @@
     "@types/react": "^18.3.20",
     "@types/react-dom": "^18.3.5",
     "@typescript-eslint/parser": "^8.28.0",
+    "concurrently": "^9.1.2",
     "eslint": "^9.23.0",
     "eslint-import-resolver-typescript": "^4.2.2",
     "eslint-plugin-import": "^2.31.0",

03_source/cms_backend/prisma/schema.prisma

@@ -195,32 +195,32 @@ model ProductItem {
   createdAt      DateTime        @default(now())
   updatedAt      DateTime        @updatedAt
   //
-  sku            String
-  name           String
-  code           String
-  price          Float
-  taxes          Float
-  tags           String[]
-  sizes          String[]
-  publish        String
-  gender         String[]
-  coverUrl       String
-  images         String[]
-  colors         String[]
-  quantity       Int
-  category       String
   available      Int
-  totalSold      Int
+  category       String
+  code           String
+  colors         String[]
+  coverUrl       String
   description    String
-  totalRatings   Float
-  totalReviews   Int
+  gender         String[]
+  images         String[]
   inventoryType  String
-  subDescription String
-  priceSale      Float?
+  name           String
   newLabel       Json
-  saleLabel      Json
+  price          Float
+  priceSale      Float?
+  publish        String
+  quantity       Int
   ratings        Json[]
   reviews        ProductReview[]
+  saleLabel      Json
+  sizes          String[]
+  sku            String
+  subDescription String
+  tags           String[]
+  taxes          Float
+  totalRatings   Float
+  totalReviews   Int
+  totalSold      Int
 }
 
 model MailSender {
@@ -1146,48 +1146,60 @@ model EventReview {
 
 // NOTE: need to consider with Event
 // mapped to IEventItem
+// a.k.a. PartyEvent party-event
 model EventItem {
-  id             String        @id @default(uuid())
-  createdAt      DateTime      @default(now())
-  updatedAt      DateTime      @updatedAt
+  id                   String        @id @default(uuid())
+  createdAt            DateTime      @default(now())
+  updatedAt            DateTime      @updatedAt
   //
-  sku            String
-  name           String
-  code           String
-  price          Float
-  taxes          Float
-  tags           String[]
-  sizes          String[]
-  publish        String
-  gender         String[]
-  coverUrl       String
-  images         String[]
-  colors         String[]
-  quantity       Int
-  category       String
-  available      Int
-  totalSold      Int
-  description    String
-  totalRatings   Float
-  totalReviews   Int
-  inventoryType  String
-  subDescription String
-  priceSale      Float?
-  newLabel       Json
-  saleLabel      Json
-  ratings        Json[]
+  available            Int           @default(99)
+  category             String
+  code                 String        @default("")
+  colors               String[]
+  coverUrl             String
+  description          String
+  gender               String[]
+  images               String[]
+  inventoryType        String        @default("")
+  name                 String        @default("")
+  newLabel             Json          @default("{}")
+  price                Float         @default(999.9)
+  priceSale            Float?        @default(111.1)
+  publish              String        @default("")
+  quantity             Int           @default(99)
+  ratings              Json[]
+  saleLabel            Json          @default("{}")
+  sizes                String[]      @default([""])
+  sku                  String        @default("")
+  subDescription       String        @default("")
+  tags                 String[]      @default([""])
+  taxes                Float         @default(5.0)
+  totalRatings         Float         @default(5.0)
+  totalReviews         Int           @default(10)
+  totalSold            Int           @default(10)
   //
-  eventDate      DateTime      @default(now())
-  joinMembers    Json[]
-  title          String
-  currency       String
-  duration_m     Float
-  ageBottom      Float
-  ageTop         Float
-  location       String
-  avatar         String[]
+  ageBottom            Float         @default(-1)
+  ageTop               Float         @default(-1)
+  avatar               String[]      @default([""])
+  currency             String        @default("HKD")
+  capacity             Int           @default(10)
+  duration_m           Float         @default(180)
+  endDate              String?       @default("")
+  eventDate            DateTime      @default(now())
+  isFeatured           Boolean       @default(false)
+  joinMembers          Json[]        @default([])
+  location             String        @default("HK")
+  organizer            String        @default("")
+  registrationDeadline String        @default("")
+  requirements         String        @default("")
+  schedule             String        @default("")
+  speakers             String[]      @default([])
+  sponsors             String[]      @default([])
+  startDate            String?       @default("")
+  status               String?       @default("")
+  title                String        @default("")
   //
-  reviews        EventReview[]
+  reviews              EventReview[]
 }
 
 model AppLog {
@@ -1218,3 +1230,30 @@ model AccessLog {
   @@index([timestamp])
   @@index([userId])
 }
+
+model PartyOrderItem {
+  id              String   @id @default(uuid())
+  createdAt       DateTime @default(now())
+  updatedAt       DateTime @updatedAt
+  //
+  taxes           Float
+  status          String
+  shipping        Float
+  discount        Float
+  subtotal        Float
+  orderNumber     String
+  totalAmount     Float
+  totalQuantity   Float
+  history         Json
+  payment         Json
+  customer        Json
+  delivery        Json
+  items           Json[]
+  shippingAddress Json
+  // OrderProductItem     OrderProductItem[]
+  // OrderHistory         OrderHistory[]
+  // OrderDelivery        OrderDelivery[]
+  // OrderCustomer        OrderCustomer[]
+  // OrderPayment         OrderPayment[]
+  // OrderShippingAddress OrderShippingAddress[]
+}

03_source/cms_backend/prisma/seed.ts

@@ -31,6 +31,7 @@ import { EventReviewSeed } from './seeds/eventReview';
 import { appLogSeed } from './seeds/AppLog';
 import { accessLogSeed } from './seeds/AccessLog';
 import { userMetaSeed } from './seeds/userMeta';
+import { partyOrderItemSeed } from './seeds/partyOrderItem';
 
 //
 // import { Blog } from './seeds/blog';
@@ -60,6 +61,8 @@ import { userMetaSeed } from './seeds/userMeta';
   await appLogSeed;
   await accessLogSeed;
 
+  await partyOrderItemSeed;
+
   // await Blog;
   // await Mail;
   // await File;

03_source/cms_backend/prisma/seeds/eventItem.ts

@@ -125,7 +125,7 @@ const generateRatings = () =>
 const generateImages = () => Array.from({ length: 8 }, (_, index) => _mock.image.event(index));
 
 const _events = () =>
-  Array.from({ length: 2 }, (_, index) => {
+  Array.from({ length: 5 }, (_, index) => {
     const reviews = generateReviews();
     const images = generateImages();
     const ratings = generateRatings();

03_source/cms_backend/prisma/seeds/partyOrderItem.ts

@@ -0,0 +1,94 @@
+import { PrismaClient } from '@prisma/client';
+import { _mock } from './_mock';
+
+const prisma = new PrismaClient();
+
+const ITEMS = Array.from({ length: 3 }, (_, index) => ({
+  id: _mock.id(index),
+  sku: `16H9UR${index}`,
+  quantity: index + 1,
+  name: _mock.productName(index),
+  coverUrl: _mock.image.product(index),
+  price: _mock.number.price(index),
+}));
+
+async function partyOrderItem() {
+  await prisma.partyOrderItem.deleteMany({});
+
+  for (let index = 1; index < 20 + 1; index++) {
+    const shipping = 10;
+    const discount = 10;
+    const taxes = 10;
+    const items = (index % 2 && ITEMS.slice(0, 1)) || (index % 3 && ITEMS.slice(1, 3)) || ITEMS;
+    const totalQuantity = items.reduce((accumulator, item) => accumulator + item.quantity, 0);
+    const subtotal = items.reduce((accumulator, item) => accumulator + item.price * item.quantity, 0);
+    const totalAmount = subtotal - shipping - discount + taxes;
+
+    const customer = {
+      id: _mock.id(index),
+      name: _mock.fullName(index),
+      email: _mock.email(index),
+      avatarUrl: _mock.image.avatar(index),
+      ipAddress: '192.158.1.38',
+    };
+
+    const delivery = { shipBy: 'DHL', speedy: 'Standard', trackingNumber: 'SPX037739199373' };
+
+    const history = {
+      orderTime: _mock.time(1),
+      paymentTime: _mock.time(2),
+      deliveryTime: _mock.time(3),
+      completionTime: _mock.time(4),
+      timeline: [
+        { title: 'Delivery successful', time: _mock.time(1) },
+        { title: 'Transporting to [2]', time: _mock.time(2) },
+        { title: 'Transporting to [1]', time: _mock.time(3) },
+        { title: 'The shipping unit has picked up the goods', time: _mock.time(4) },
+        { title: 'Order has been created', time: _mock.time(5) },
+      ],
+    };
+
+    const temp = await prisma.partyOrderItem.upsert({
+      where: { id: index.toString() },
+      update: {},
+      create: {
+        id: _mock.id(index),
+        orderNumber: `#601${index}`,
+        taxes,
+        items,
+        history,
+        subtotal: items.reduce((accumulator, item) => accumulator + item.price * item.quantity, 0),
+        shipping,
+        discount,
+        customer,
+        delivery,
+        totalAmount,
+        totalQuantity,
+        shippingAddress: {
+          fullAddress: '19034 Verna Unions Apt. 164 - Honolulu, RI / 87535',
+          phoneNumber: '365-374-4961',
+        },
+        payment: {
+          //
+          cardType: 'mastercard',
+          cardNumber: '4111 1111 1111 1111',
+        },
+        status: (index % 2 && 'completed') || (index % 3 && 'pending') || (index % 4 && 'cancelled') || 'refunded',
+      },
+    });
+  }
+
+  console.log('seed partyOrderItemSeed done');
+}
+
+const partyOrderItemSeed = partyOrderItem()
+  .then(async () => {
+    await prisma.$disconnect();
+  })
+  .catch(async (e) => {
+    console.error(e);
+    await prisma.$disconnect();
+    process.exit(1);
+  });
+
+export { partyOrderItemSeed };

03_source/cms_backend/scripts/00_dev.sh

@@ -1,8 +1,14 @@
 #!/usr/bin/env bash
 
+yarn --dev
+
+clear
+
 while true; do
-  yarn --dev
-  yarn dev
+  yarn db:studio &
+
+  npx nodemon --ext ts,tsx,prisma --exec "yarn db:push && yarn seed && yarn dev"
+  # yarn dev
 
   echo "restarting..."
   sleep 1

03_source/cms_backend/scripts/01_db_push.sh

@@ -0,0 +1,11 @@
+#!/usr/bin/env bash
+
+yarn --dev
+
+clear
+
+while true; do
+  npx nodemon --ext prisma --exec "yarn db:push && yarn seed"
+  echo "restarting..."
+  sleep 1
+done

03_source/cms_backend/scripts/10_build.sh

@@ -2,11 +2,17 @@
 
 set -x
 
-yarn db:push
+rm -rf ./**/*Zone.Identifier
 
-npx nodemon --ext ts,tsx --exec "yarn tsc"
+# yarn db:push
+# npx nodemon --ext ts,tsx --exec "yarn tsc"
 
+set -ex
 
+yarn fm:fix
 
-# yarn build
+yarn tsc
 
+yarn build
+
+echo "done"

03_source/cms_backend/src/_mock/_chat.ts

@@ -16,11 +16,7 @@ export const _contacts = () =>
     address: _mock.fullAddress(index),
     avatarUrl: _mock.image.avatar(index),
     phoneNumber: _mock.phoneNumber(index),
-    status:
-      ([0, 1, 6, 12].includes(index) && 'online') ||
-      ([3, 8, 14].includes(index) && 'offline') ||
-      ([4, 10, 16].includes(index) && 'busy') ||
-      'always',
+    status: ([0, 1, 6, 12].includes(index) && 'online') || ([3, 8, 14].includes(index) && 'offline') || ([4, 10, 16].includes(index) && 'busy') || 'always',
   }));
 
 export const _conversations = () => {

03_source/cms_backend/src/_mock/_kanban.ts

@@ -6,8 +6,7 @@ import { _tags } from './assets';
 
 // ----------------------------------------------------------------------
 
-const generateAttachments = () =>
-  Array.from({ length: 20 }, (_, index) => _mock.image.cover(index));
+const generateAttachments = () => Array.from({ length: 20 }, (_, index) => _mock.image.cover(index));
 
 const generateAssignees = () =>
   Array.from({ length: 20 }, (_, index) => ({
@@ -68,24 +67,14 @@ const createTask = (index: number, status: string) => {
     assignee: assignedUser.slice(0, index),
     description: _mock.description(index),
     due: [fAdd({ days: index + 1 }), fAdd({ days: index + 2 })],
-    priority:
-      ([1, 3].includes(index) && PRIORITY_LEVEL.hight) ||
-      ([2, 4].includes(index) && PRIORITY_LEVEL.medium) ||
-      PRIORITY_LEVEL.low,
-    attachments:
-      (index === 1 && attachmentList.slice(11, 15)) ||
-      (index === 5 && attachmentList.slice(4, 9)) ||
-      [],
+    priority: ([1, 3].includes(index) && PRIORITY_LEVEL.hight) || ([2, 4].includes(index) && PRIORITY_LEVEL.medium) || PRIORITY_LEVEL.low,
+    attachments: (index === 1 && attachmentList.slice(11, 15)) || (index === 5 && attachmentList.slice(4, 9)) || [],
     status,
   };
 };
 
 const tasks = () => ({
-  [COLUMN_IDS.id1]: [
-    createTask(1, COLUMN_NAMES.name1),
-    createTask(2, COLUMN_NAMES.name1),
-    createTask(3, COLUMN_NAMES.name1),
-  ],
+  [COLUMN_IDS.id1]: [createTask(1, COLUMN_NAMES.name1), createTask(2, COLUMN_NAMES.name1), createTask(3, COLUMN_NAMES.name1)],
   [COLUMN_IDS.id2]: [createTask(4, COLUMN_NAMES.name2), createTask(5, COLUMN_NAMES.name2)],
   [COLUMN_IDS.id3]: [],
   [COLUMN_IDS.id4]: [createTask(6, COLUMN_NAMES.name4)],

03_source/cms_backend/src/_mock/_mail.ts

@@ -28,20 +28,11 @@ export const _mails = () =>
   Array.from({ length: 9 }, (_, index) => {
     const files = _files();
 
-    const attachments =
-      (index === 1 && files.slice(0, 2)) ||
-      (index === 2 && files.slice(0, 4)) ||
-      (index === 5 && files.slice(4, 10)) ||
-      [];
+    const attachments = (index === 1 && files.slice(0, 2)) || (index === 2 && files.slice(0, 4)) || (index === 5 && files.slice(4, 10)) || [];
 
-    const folder =
-      ([1, 2].includes(index) && 'spam') || ([3, 4].includes(index) && 'sent') || 'inbox';
+    const folder = ([1, 2].includes(index) && 'spam') || ([3, 4].includes(index) && 'sent') || 'inbox';
 
-    const labelIds =
-      (index === 1 && ['promotions', 'forums']) ||
-      (index === 2 && ['forums']) ||
-      (index === 5 && ['social']) ||
-      [];
+    const labelIds = (index === 1 && ['promotions', 'forums']) || (index === 2 && ['forums']) || (index === 5 && ['social']) || [];
 
     const from = {
       name: _mock.fullName(index),

03_source/cms_backend/src/_mock/_mock.ts

@@ -78,11 +78,8 @@ export const _mock = {
     avatar: (index: number) => `${CONFIG.basePath}/assets/images/avatar/avatar-${index + 1}.webp`,
     travel: (index: number) => `${CONFIG.basePath}/assets/images/travel/travel-${index + 1}.webp`,
     course: (index: number) => `${CONFIG.basePath}/assets/images/course/course-${index + 1}.webp`,
-    company: (index: number) =>
-      `${CONFIG.basePath}/assets/images/company/company-${index + 1}.webp`,
-    product: (index: number) =>
-      `${CONFIG.basePath}/assets/images/m-product/product-${index + 1}.webp`,
-    portrait: (index: number) =>
-      `${CONFIG.basePath}/assets/images/portrait/portrait-${index + 1}.webp`,
+    company: (index: number) => `${CONFIG.basePath}/assets/images/company/company-${index + 1}.webp`,
+    product: (index: number) => `${CONFIG.basePath}/assets/images/m-product/product-${index + 1}.webp`,
+    portrait: (index: number) => `${CONFIG.basePath}/assets/images/portrait/portrait-${index + 1}.webp`,
   },
 };

03_source/cms_backend/src/_mock/_product.ts

@@ -3,16 +3,7 @@ import { _tags } from './assets';
 
 // ----------------------------------------------------------------------
 
-const COLORS = [
-  '#FF4842',
-  '#1890FF',
-  '#FFC0CB',
-  '#00AB55',
-  '#FFC107',
-  '#7F00FF',
-  '#000000',
-  '#FFFFFF',
-];
+const COLORS = ['#FF4842', '#1890FF', '#FFC0CB', '#00AB55', '#FFC107', '#7F00FF', '#000000', '#FFFFFF'];
 
 const DESCRIPTION = `
 <h6>Specifications</h6>
@@ -93,8 +84,7 @@ const DESCRIPTION = `
 
 `;
 
-const generateAttachments = () =>
-  Array.from({ length: 20 }, (_, index) => _mock.image.product(index));
+const generateAttachments = () => Array.from({ length: 20 }, (_, index) => _mock.image.product(index));
 
 const generateReviews = () => {
   const attachments = generateAttachments();
@@ -108,11 +98,7 @@ const generateReviews = () => {
     rating: _mock.number.rating(index),
     avatarUrl: _mock.image.avatar(index),
     helpful: _mock.number.nativeL(index),
-    attachments:
-      (index === 1 && attachments.slice(0, 1)) ||
-      (index === 3 && attachments.slice(2, 4)) ||
-      (index === 5 && attachments.slice(5, 8)) ||
-      [],
+    attachments: (index === 1 && attachments.slice(0, 1)) || (index === 3 && attachments.slice(2, 4)) || (index === 5 && attachments.slice(5, 8)) || [],
   }));
 };
 
@@ -192,7 +178,6 @@ export const _products = () =>
       newLabel: { enabled: [1, 2, 3].includes(index), content: 'NEW' },
       saleLabel: { enabled: [4, 5].includes(index), content: 'SALE' },
       sizes: ['6', '7', '8', '8.5', '9', '9.5', '10', '10.5', '11', '11.5', '12', '13'],
-      subDescription:
-        'Featuring the original ripple design inspired by Japanese bullet trains, the Nike Air Max 97 lets you push your style full-speed ahead.',
+      subDescription: 'Featuring the original ripple design inspired by Japanese bullet trains, the Nike Air Max 97 lets you push your style full-speed ahead.',
     };
   });

03_source/cms_backend/src/_mock/assets.ts

@@ -1,9 +1,6 @@
 // ----------------------------------------------------------------------
 
-export const _id = Array.from(
-  { length: 40 },
-  (_, index) => `e99f09a7-dd88-49d5-b1c8-1daf80c2d7b${index + 1}`
-);
+export const _id = Array.from({ length: 40 }, (_, index) => `e99f09a7-dd88-49d5-b1c8-1daf80c2d7b${index + 1}`);
 
 // ----------------------------------------------------------------------
 
@@ -37,36 +34,24 @@ export const _booleans = [
 // ----------------------------------------------------------------------
 
 export const _prices = [
-  83.74, 97.14, 68.71, 85.21, 52.17, 25.18, 43.84, 60.98, 98.42, 53.37, 72.75, 56.61, 64.55, 77.32,
-  60.62, 79.81, 93.68, 47.44, 76.24, 92.87, 72.91, 20.54, 94.25, 37.51,
+  83.74, 97.14, 68.71, 85.21, 52.17, 25.18, 43.84, 60.98, 98.42, 53.37, 72.75, 56.61, 64.55, 77.32, 60.62, 79.81, 93.68, 47.44, 76.24, 92.87, 72.91, 20.54,
+  94.25, 37.51,
 ];
 
-export const _ratings = [
-  4.2, 3.7, 4.5, 3.5, 0.5, 3.0, 2.5, 2.8, 4.9, 3.6, 2.5, 1.7, 3.9, 2.8, 4.1, 4.5, 2.2, 3.2, 0.6,
-  1.3, 3.8, 3.8, 3.8, 2.0,
-];
+export const _ratings = [4.2, 3.7, 4.5, 3.5, 0.5, 3.0, 2.5, 2.8, 4.9, 3.6, 2.5, 1.7, 3.9, 2.8, 4.1, 4.5, 2.2, 3.2, 0.6, 1.3, 3.8, 3.8, 3.8, 2.0];
 
-export const _ages = [
-  30, 26, 59, 47, 29, 46, 18, 56, 39, 19, 45, 18, 46, 56, 38, 41, 44, 48, 32, 45, 42, 60, 33, 57,
-];
+export const _ages = [30, 26, 59, 47, 29, 46, 18, 56, 39, 19, 45, 18, 46, 56, 38, 41, 44, 48, 32, 45, 42, 60, 33, 57];
 
 export const _percents = [
-  10.1, 13.6, 28.2, 42.1, 37.2, 18.5, 40.1, 94.8, 91.4, 53.0, 25.4, 62.9, 86.6, 62.4, 35.4, 17.6,
-  52.0, 6.8, 95.3, 26.6, 69.9, 92.1, 46.2, 85.6,
+  10.1, 13.6, 28.2, 42.1, 37.2, 18.5, 40.1, 94.8, 91.4, 53.0, 25.4, 62.9, 86.6, 62.4, 35.4, 17.6, 52.0, 6.8, 95.3, 26.6, 69.9, 92.1, 46.2, 85.6,
 ];
 
-export const _nativeS = [
-  11, 10, 7, 10, 12, 5, 10, 1, 8, 8, 10, 11, 12, 8, 4, 11, 8, 9, 4, 9, 2, 6, 3, 7,
-];
+export const _nativeS = [11, 10, 7, 10, 12, 5, 10, 1, 8, 8, 10, 11, 12, 8, 4, 11, 8, 9, 4, 9, 2, 6, 3, 7];
 
-export const _nativeM = [
-  497, 763, 684, 451, 433, 463, 951, 194, 425, 435, 807, 521, 538, 839, 394, 269, 453, 821, 364,
-  849, 804, 776, 263, 239,
-];
+export const _nativeM = [497, 763, 684, 451, 433, 463, 951, 194, 425, 435, 807, 521, 538, 839, 394, 269, 453, 821, 364, 849, 804, 776, 263, 239];
 
 export const _nativeL = [
-  9911, 1947, 9124, 6984, 8488, 2034, 3364, 8401, 8996, 5271, 8478, 1139, 8061, 3035, 6733, 3952,
-  2405, 3127, 6843, 4672, 6995, 6053, 5192, 9686,
+  9911, 1947, 9124, 6984, 8488, 2034, 3364, 8401, 8996, 5271, 8478, 1139, 8061, 3035, 6733, 3952, 2405, 3127, 6843, 4672, 6995, 6053, 5192, 9686,
 ];
 
 export const _fullAddress = [

03_source/cms_backend/src/app/api/AccessLog/detail/route.ts

@@ -11,7 +11,7 @@ import type { NextRequest } from 'next/server';
 import { STATUS, response, handleError } from 'src/utils/response';
 
 // import { AccessLogService } from '../../../../modules/AccessLog/AccessLog.service';
-import { getAccessLogById } from 'src/app/services/AccessLog.service';
+import { getAccessLogById } from 'src/app/services/access-log.service';
 
 // ----------------------------------------------------------------------
 

03_source/cms_backend/src/app/api/AccessLog/route.ts

@@ -2,7 +2,7 @@ import type { NextRequest, NextResponse } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { listAccessLogs } from 'src/app/services/AccessLog.service';
+import { listAccessLogs } from 'src/app/services/access-log.service';
 
 // import prisma from '../../lib/prisma';
 

03_source/cms_backend/src/app/api/AppLog/route.ts

@@ -2,7 +2,7 @@ import type { NextRequest, NextResponse } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { listAppLogs, deleteAppLog, createNewAppLog } from 'src/app/services/AppLog.service';
+import { listAppLogs, deleteAppLog, createNewAppLog } from 'src/app/services/app-log.service';
 
 // import prisma from '../../lib/prisma';
 

03_source/cms_backend/src/app/api/_PROMPTS/clone_srevice.md

@@ -0,0 +1,14 @@
+Hi,
+
+i copied from
+`03_source/cms_backend/src/app/api/party-event`
+to
+`03_source/cms_backend/src/app/api/party-order`
+
+with knowledge in `schema.prisma` file, and take a look into the sibling files in the same directory.
+
+i want you to update `03_source/cms_backend/src/app/api/party-order` content to handle `party-order` (the purchase order of the party)
+`party-order.service.ts` is already prepared and you can use it
+please maintain same format and level of detail when you edit.
+
+thanks.

03_source/cms_backend/src/app/api/auth/me/route.ts

@@ -8,7 +8,7 @@ import { STATUS, response, handleError } from 'src/utils/response';
 
 import { JWT_SECRET } from 'src/_mock/_auth';
 import { getUserById } from 'src/app/services/user.service';
-import { createAccessLog } from 'src/app/services/AccessLog.service';
+import { createAccessLog } from 'src/app/services/access-log.service';
 
 import { flattenNextjsRequest } from '../sign-in/flattenNextjsRequest';
 

03_source/cms_backend/src/app/api/auth/sign-in/route.ts

@@ -4,7 +4,7 @@ import { sign } from 'src/utils/jwt';
 import { STATUS, response, handleError } from 'src/utils/response';
 
 import { JWT_SECRET, JWT_EXPIRES_IN } from 'src/_mock/_auth';
-import { createAccessLog } from 'src/app/services/AccessLog.service';
+import { createAccessLog } from 'src/app/services/access-log.service';
 
 import prisma from '../../../lib/prisma';
 import { flattenNextjsRequest } from './flattenNextjsRequest';

03_source/cms_backend/src/app/api/event/details/route.ts

@@ -12,7 +12,7 @@ import { STATUS, response, handleError } from 'src/utils/response';
 
 import { L_INFO, L_ERROR } from 'src/constants';
 import { getEvent } from 'src/app/services/eventItem.service';
-import { createAppLog } from 'src/app/services/AppLog.service';
+import { createAppLog } from 'src/app/services/app-log.service';
 
 // ----------------------------------------------------------------------
 

03_source/cms_backend/src/app/api/helloworld/detail/route.ts

@@ -11,7 +11,7 @@ import type { NextRequest } from 'next/server';
 import { STATUS, response, handleError } from 'src/utils/response';
 
 import { L_INFO, L_ERROR } from 'src/constants';
-import { createAppLog } from 'src/app/services/AppLog.service';
+import { createAppLog } from 'src/app/services/app-log.service';
 
 import prisma from '../../../lib/prisma';
 import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';

03_source/cms_backend/src/app/api/invoice/search/route.ts

@@ -24,9 +24,7 @@ export async function GET(req: NextRequest) {
     const products = _products();
 
     // Accept search by name or sku
-    const results = products.filter(
-      ({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query)
-    );
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
 
     logger('[Product] search-results', results.length);
 

03_source/cms_backend/src/app/api/kanban/route.ts

@@ -25,13 +25,8 @@ const ENDPOINTS = {
 };
 
 function loggerData(action?: string, value?: unknown) {
-  const columnsWithTasks = boardData.columns.map(
-    (col) => `${col.name} (${boardData.tasks[col.id].length} tasks)`
-  );
-  logger(
-    '[Kanban] get-board',
-    `columns (${boardData.columns.length}): ${JSON.stringify(columnsWithTasks, null, 2)}`
-  );
+  const columnsWithTasks = boardData.columns.map((col) => `${col.name} (${boardData.tasks[col.id].length} tasks)`);
+  logger('[Kanban] get-board', `columns (${boardData.columns.length}): ${JSON.stringify(columnsWithTasks, null, 2)}`);
   if (value || action) {
     logger(`[Kanban] ${action}`, value);
   }
@@ -126,9 +121,7 @@ async function updateColumn(req: NextRequest) {
 
   // Find and update the specified column.
   updateBoardData({
-    columns: boardData.columns.map((col) =>
-      col.id === columnId ? { ...col, name: columnName } : col
-    ),
+    columns: boardData.columns.map((col) => (col.id === columnId ? { ...col, name: columnName } : col)),
   });
 
   loggerData('updated-column', columnName);
@@ -222,9 +215,7 @@ async function updateTask(req: NextRequest) {
   updateBoardData({
     tasks: {
       ...boardData.tasks,
-      [columnId]: boardData.tasks[columnId].map((task) =>
-        task.id === taskData.id ? { ...task, ...taskData } : task
-      ),
+      [columnId]: boardData.tasks[columnId].map((task) => (task.id === taskData.id ? { ...task, ...taskData } : task)),
     },
   });
 

03_source/cms_backend/src/app/api/mail/list/route.ts

@@ -31,10 +31,7 @@ export async function GET(req: NextRequest) {
     }
 
     // Get filtered mails
-    const filteredMails =
-      label.type === 'custom'
-        ? mails.filter((mail) => mail.labelIds.includes(labelId!))
-        : filterMailsByLabelId(mails, labelId);
+    const filteredMails = label.type === 'custom' ? mails.filter((mail) => mail.labelIds.includes(labelId!)) : filterMailsByLabelId(mails, labelId);
 
     logger(`[Mail] label-[${labelId}]`, filteredMails.length);
 

03_source/cms_backend/src/app/api/order/search/route.ts

@@ -24,9 +24,7 @@ export async function GET(req: NextRequest) {
     const products = _products();
 
     // Accept search by name or sku
-    const results = products.filter(
-      ({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query)
-    );
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
 
     logger('[Product] search-results', results.length);
 

03_source/cms_backend/src/app/api/pagination/route.ts

@@ -47,9 +47,7 @@ export async function GET(req: NextRequest) {
         products: paginatedProducts,
         totalPages,
         totalItems,
-        categoryOptions: Array.from(
-          new Set(_products.map(({ category: c_category }) => c_category))
-        ), // Remove duplicate categories
+        categoryOptions: Array.from(new Set(_products.map(({ category: c_category }) => c_category))), // Remove duplicate categories
       },
       STATUS.OK
     );
@@ -70,9 +68,7 @@ function paginateProducts(products: Products, page: number, perPage: number) {
 function filterProducts(products: Products, searchQuery: string, category: string) {
   return products.filter(({ id, name, category: prodCategory }) => {
     // Accept search by id or name
-    const matchesSearch = searchQuery
-      ? id.includes(searchQuery) || name.toLowerCase().includes(searchQuery)
-      : true;
+    const matchesSearch = searchQuery ? id.includes(searchQuery) || name.toLowerCase().includes(searchQuery) : true;
     const matchesCategory = category ? prodCategory === category : true;
 
     return matchesSearch && matchesCategory;

03_source/cms_backend/src/app/api/party-event/_GUIDELINES.md

@@ -0,0 +1,35 @@
+<!-- AI: please maintain same format and level of detail when edit this file -->
+
+# GUIDELINE
+
+- Party Event API endpoint for managing party events
+- Handles CRUD operations for party events
+- Follows single file for single db table/collection pattern
+
+## `route.ts`
+
+Handles HTTP methods:
+
+- `GET` - Retrieve party events
+- `POST` - Create new party event
+- `PUT` - Update existing party event
+- `DELETE` - Remove party event
+
+## `test.http`
+
+Contains test requests for:
+
+- Listing all party events
+- Creating new party event
+- Updating existing party event
+- Deleting party event
+
+## `../../services/party-event.service.ts`
+
+Party Event CRUD operations:
+
+`listPartyEvents` - List all party events with optional filters
+`getPartyEvent` - Get single party event by ID
+`createNewPartyEvent` - Create new party event record
+`updatePartyEvent` - Update existing party event by ID
+`deletePartyEvent` - Delete party event by ID

03_source/cms_backend/src/app/api/party-event/create/route.ts

@@ -0,0 +1,40 @@
+// src/app/api/party-event/create/route.ts
+//
+// PURPOSE:
+// Create new party event in db
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { isDev } from 'src/constants';
+import { createEvent } from 'src/app/services/party-event.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * POST - Create PartyEvent
+ *************************************** */
+export async function POST(req: NextRequest) {
+  const { partyEventData } = await req.json();
+
+  try {
+    if (isDev) {
+      console.log({ partyEventData });
+    }
+
+    const created = await createEvent(partyEventData);
+
+    if (isDev) {
+      console.log('Event created successfully');
+    }
+
+    return response(created, STATUS.OK);
+  } catch (error) {
+    console.error('Error creating event:', { partyEventData });
+    return handleError('PartyEvent - Create', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/create/test.http

@@ -0,0 +1,34 @@
+###
+
+POST http://localhost:7272/api/party-event/create
+Content-Type: application/json
+
+{
+  "partyEventData": {
+    "title": "Summer Music Festival",
+    "description": "Annual summer music festival featuring local bands and artists",
+    "startDate": "2024-07-15T18:00:00Z",
+    "endDate": "2024-07-15T23:00:00Z",
+    "location": "Central Park, Hong Kong",
+    "coverUrl": "",
+    "images": [
+        "data:image/png;base64,C",
+        "data:image/png;base64,C"
+    ],
+    "tags": [
+        "Music",
+        "Festival"
+    ],
+    "status": "upcoming",
+    "capacity": 500,
+    "price": 150.00,
+    "organizer": "HK Music Society",
+    "category": "Music",
+    "isFeatured": true,
+    "registrationDeadline": "2024-07-10T00:00:00Z",
+    "requirements": "Age 18+",
+    "schedule": "18:00 Doors open\n19:00 First performance\n21:00 Main act",
+    "speakers": ["DJ Lee", "Band XYZ"],
+    "sponsors": ["HK Radio", "Music Magazine"]
+  }
+}

03_source/cms_backend/src/app/api/party-event/delete/route.ts

@@ -0,0 +1,22 @@
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { deleteEvent } from 'src/app/services/party-event.service';
+
+/** **************************************
+ * PATCH - Delete PartyEvent
+ *************************************** */
+export async function PATCH(req: NextRequest) {
+  try {
+    const { partyEventId } = await req.json();
+
+    if (!partyEventId) throw new Error('partyEventId cannot be null');
+
+    await deleteEvent(partyEventId);
+
+    return response({ partyEventId }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Delete', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/delete/test.http

@@ -0,0 +1,8 @@
+###
+
+PATCH http://localhost:7272/api/party-event/delete
+Content-Type: application/json
+
+{
+  "partyEventId": "e99f09a7-dd88-49d5-b1c8-1daf80c2d7b01"
+}

03_source/cms_backend/src/app/api/party-event/details/route.ts

@@ -0,0 +1,56 @@
+// src/app/api/party-event/details/route.ts
+//
+// PURPOSE:
+// Get party event from db by id
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { logger } from 'src/utils/logger';
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { L_INFO, L_ERROR } from 'src/constants';
+import { getEvent } from 'src/app/services/party-event.service';
+import { createAppLog } from 'src/app/services/app-log.service';
+
+import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';
+
+// ----------------------------------------------------------------------
+
+/**
+ **************************************
+ * GET PartyEvent detail
+ ***************************************
+ */
+export async function GET(req: NextRequest) {
+  const debug = { 'req.headers': flattenNextjsRequest(req) };
+
+  try {
+    const { searchParams } = req.nextUrl;
+
+    // RULES: eventId must exist
+    const partyEventId = searchParams.get('partyEventId');
+    if (!partyEventId) {
+      return response({ message: 'PartyEvent ID is required!' }, STATUS.BAD_REQUEST);
+    }
+
+    // NOTE: eventId confirmed exist, run below
+    const partyEvent = await getEvent(partyEventId);
+
+    if (!partyEvent) {
+      return response({ message: 'PartyEvent not found!' }, STATUS.NOT_FOUND);
+    }
+
+    logger('[PartyEvent] details', partyEvent.id);
+
+    createAppLog(L_INFO, 'Get event detail OK', debug);
+
+    return response({ partyEvent }, STATUS.OK);
+  } catch (error) {
+    createAppLog(L_ERROR, 'event detail error', debug);
+
+    return handleError('PartyEvent - Get details', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/details/test.http

@@ -0,0 +1,9 @@
+###
+
+# Get details for a specific party event
+GET http://localhost:7272/api/party-event/details?partyEventId=e99f09a7-dd88-49d5-b1c8-1daf80c2d7b01
+
+###
+
+# Alternative format with different ID
+GET http://localhost:7272/api/party-event/details?eventId=evt_987654321

03_source/cms_backend/src/app/api/party-event/helloworld/route.ts

@@ -0,0 +1,16 @@
+import type { NextRequest, NextResponse } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+/**
+ ***************************************
+ * GET - helloworld
+ ***************************************
+ */
+export async function GET(req: NextRequest, res: NextResponse) {
+  try {
+    return response({ helloworld: 'party-event' }, STATUS.OK);
+  } catch (error) {
+    return handleError('Helloworld - Get all', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/helloworld/test.http

@@ -0,0 +1,4 @@
+###
+GET /api/party-event/helloworld HTTP/1.1
+Host: localhost:7272
+

03_source/cms_backend/src/app/api/party-event/list/route.ts

@@ -0,0 +1,38 @@
+// src/app/api/party-event/list/route.ts
+//
+// PURPOSE:
+// List all party events from db
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { L_INFO, L_ERROR } from 'src/constants';
+import { createAppLog } from 'src/app/services/app-log.service';
+import { listEvents } from 'src/app/services/party-event.service';
+
+import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * GET - PartyEvents list
+ *************************************** */
+export async function GET(req: NextRequest) {
+  const debug = { 'req.headers': flattenNextjsRequest(req) };
+
+  try {
+    const partyEvents = await listEvents();
+
+    createAppLog(L_INFO, 'party-event list ok', {});
+
+    return response({ partyEvents }, STATUS.OK);
+  } catch (error) {
+    createAppLog(L_ERROR, 'party-event list error', debug);
+
+    return handleError('PartyEvent - Get list', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/list/test.http

@@ -0,0 +1,14 @@
+###
+
+# Basic list all party events
+GET http://localhost:7272/api/party-event/list
+
+###
+
+# List upcoming party events
+GET http://localhost:7272/api/party-event/list?status=upcoming
+
+###
+
+# List featured party events
+GET http://localhost:7272/api/party-event/list?isFeatured=true

03_source/cms_backend/src/app/api/party-event/route.ts

@@ -0,0 +1,75 @@
+import type { NextRequest, NextResponse } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { listEvents, deleteEvent, updateEvent, createEvent } from 'src/app/services/party-event.service';
+
+/**
+ **************************************
+ * GET - PartyEvent
+ ***************************************
+ */
+export async function GET(req: NextRequest, res: NextResponse) {
+  try {
+    const events = await listEvents();
+    return response(events, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Get list', error);
+  }
+}
+
+/**
+ ***************************************
+ * POST - Create PartyEvent
+ ***************************************
+ */
+export async function POST(req: NextRequest) {
+  const OPERATION = 'PartyEvent - Create';
+  const { data } = await req.json();
+
+  try {
+    const event = await createEvent(data);
+    return response(OPERATION, STATUS.OK);
+  } catch (error) {
+    return handleError(OPERATION, error);
+  }
+}
+
+/**
+ ***************************************
+ * PUT - Update PartyEvent
+ ***************************************
+ */
+export async function PUT(req: NextRequest) {
+  const { searchParams } = req.nextUrl;
+  const eventId = searchParams.get('eventId');
+  const { data } = await req.json();
+
+  try {
+    if (!eventId) throw new Error('eventId cannot be null');
+
+    const result = await updateEvent(eventId, data);
+    return response(result, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Update', error);
+  }
+}
+
+/**
+ ***************************************
+ * DELETE - Delete PartyEvent
+ ***************************************
+ */
+export async function DELETE(req: NextRequest) {
+  const { searchParams } = req.nextUrl;
+  const eventId = searchParams.get('eventId');
+
+  try {
+    if (!eventId) throw new Error('eventId cannot be null');
+
+    await deleteEvent(eventId);
+    return response({ success: true }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Delete', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/search/route.ts

@@ -0,0 +1,34 @@
+import type { NextRequest } from 'next/server';
+
+import { logger } from 'src/utils/logger';
+import { STATUS, response, handleError } from 'src/utils/response';
+import { IEventItem } from '../update/route';
+
+// import { searchEvents } from 'src/app/services/party-event.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * GET - Search PartyEvents
+ *************************************** */
+export async function GET(req: NextRequest) {
+  try {
+    const { searchParams } = req.nextUrl;
+    const query = searchParams.get('query')?.trim().toLowerCase();
+
+    if (!query) {
+      return response({ results: [] }, STATUS.OK);
+    }
+
+    const results: IEventItem[] = [];
+    // TODO: search party event not implemented
+    console.log('search party event not implemented');
+    // const results = await searchEvents(query);
+
+    logger('[PartyEvent] search-results', results?.length);
+
+    return response({ results }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Get search', error);
+  }
+}

03_source/cms_backend/src/app/api/party-event/search/test.http

@@ -0,0 +1,24 @@
+###
+
+# Search party events by title
+GET http://localhost:7272/api/party-event/search?query=Music
+
+###
+
+# Search party events by location
+GET http://localhost:7272/api/party-event/search?query=Central+Park
+
+###
+
+# Search party events by tag
+GET http://localhost:7272/api/party-event/search?query=Festival
+
+###
+
+# Combined search with multiple parameters
+GET http://localhost:7272/api/party-event/search?query=Summer&location=Hong+Kong&category=Music
+
+###
+
+# No results expected
+GET http://localhost:7272/api/party-event/search?query=zzzzzz

03_source/cms_backend/src/app/api/party-event/update/route.ts

@@ -0,0 +1,57 @@
+// src/app/api/party-event/update/route.ts
+//
+// PURPOSE:
+// Update party event in db by id
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { updateEvent } from 'src/app/services/party-event.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * PUT - Update PartyEvent
+ *************************************** */
+export async function PUT(req: NextRequest) {
+  const { partyEventData } = await req.json();
+  const { id } = partyEventData;
+
+  if (!id) return response({ message: 'id not found' }, STATUS.ERROR);
+
+  try {
+    const result = await updateEvent(id, partyEventData);
+
+    return response({ result }, STATUS.OK);
+  } catch (error) {
+    console.error('Error updating event:', { partyEventData });
+    return handleError('PartyEvent - Update', error);
+  }
+}
+
+export type IEventItem = {
+  id: string;
+  title: string;
+  description: string;
+  startDate: Date;
+  endDate: Date;
+  location: string;
+  coverUrl: string;
+  images: string[];
+  tags: string[];
+  status: string;
+  capacity: number;
+  price: number;
+  organizer: string;
+  category: string;
+  isFeatured: boolean;
+  registrationDeadline: Date;
+  requirements: string[];
+  schedule: string;
+  speakers: string[];
+  sponsors: string[];
+};

03_source/cms_backend/src/app/api/party-event/update/test.http

@@ -0,0 +1,31 @@
+###
+
+PUT http://localhost:7272/api/party-event/update
+Content-Type: application/json
+
+{
+  "partyEventData": {
+    "id":"e99f09a7-dd88-49d5-b1c8-1daf80c2d7b01",
+    "title": "Summer Music Festival 111",
+    "name": "Summer Music Festival 111",
+    "description": "Annual summer music festival featuring local bands and artists",
+    "startDate": "2024-07-15T18:00:00Z",
+    "endDate": "2024-07-15T23:00:00Z",
+    "location": "Central Park, Hong Kong",
+    "coverUrl": "",
+    "images": [        "data:image/png;base64,C",        "data:image/png;base64,C"    ],
+    "tags": [        "Music",        "Festival"    ],
+    "status": "upcoming",
+    "capacity": 500,
+    "price": 150.00,
+    "organizer": "HK Music Society",
+    "category": "Music",
+    "isFeatured": true,
+    "registrationDeadline": "2024-07-10T00:00:00Z",
+    "requirements": "Age 18+",
+    "schedule": "18:00 Doors open\n19:00 First performance\n21:00 Main act",
+    "speakers": ["DJ Lee", "Band XYZ"],
+    "sponsors": ["HK Radio", "Music Magazine"],
+    "reviews":[]
+  }
+}

03_source/cms_backend/src/app/api/party-order/_GUIDELINES.md

@@ -0,0 +1,35 @@
+<!-- AI: please maintain same format and level of detail when edit this file -->
+
+# GUIDELINE
+
+- Party Order API endpoint for managing party orders
+- Handles CRUD operations for party orders
+- Follows single file for single db table/collection pattern
+
+## `route.ts`
+
+Handles HTTP methods:
+
+- `GET` - Retrieve party orders
+- `POST` - Create new party order
+- `PUT` - Update existing party order
+- `DELETE` - Remove party order
+
+## `test.http`
+
+Contains test requests for:
+
+- Listing all party orders
+- Creating new party order
+- Updating existing party order
+- Deleting party order
+
+## `../../services/party-order.service.ts`
+
+Party Order CRUD operations:
+
+`listPartyOrders` - List all party orders with optional filters
+`getPartyOrder` - Get single party order by ID
+`createNewPartyOrder` - Create new party order record
+`updatePartyOrder` - Update existing party order by ID
+`deletePartyOrder` - Delete party order by ID

03_source/cms_backend/src/app/api/party-order/create/route.ts

@@ -0,0 +1,40 @@
+// src/app/api/party-order/create/route.ts
+//
+// PURPOSE:
+// Create new party order in db
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { isDev } from 'src/constants';
+import { createOrder } from 'src/app/services/party-order.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * POST - Create PartyOrder
+ *************************************** */
+export async function POST(req: NextRequest) {
+  const { partyOrderData } = await req.json();
+
+  try {
+    if (isDev) {
+      console.log({ partyOrderData });
+    }
+
+    const created = await createOrder(partyOrderData);
+
+    if (isDev) {
+      console.log('Order created successfully');
+    }
+
+    return response(created, STATUS.OK);
+  } catch (error) {
+    console.error('Error creating order:', { partyOrderData });
+    return handleError('PartyOrder - Create', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/create/test.http

@@ -0,0 +1,31 @@
+###
+
+POST http://localhost:7272/api/party-order/create
+Content-Type: application/json
+
+{
+  "partyOrderData": {
+  "taxes": 15.00,
+  "status": "pending",
+  "shipping": 10.00,
+  "discount": 20.00,
+  "subtotal": 290.00,
+  "orderNumber": "ORD_20231115001",
+  "totalAmount": 300.00,
+  "totalQuantity": 2.0,
+  "history": "{\"actions\":[{\"timestamp\":\"2023-11-15T10:00:00Z\",\"action\":\"order_created\"}]}",
+  "payment": "{\"method\":\"credit_card\",\"status\":\"unpaid\",\"transaction_id\":\"txn_123456\"}",
+  "customer": "{\"name\":\"John Doe\",\"email\":\"john.doe@example.com\",\"phone\":\"+1234567890\"}",
+  "delivery": "{\"method\":\"courier\",\"estimated_delivery\":\"2023-11-18\"}",
+  "items": [
+    {
+      "id": "ticket_001",
+      "name": "General Admission",
+      "quantity": 2,
+      "price": 150.00
+    }
+  ],
+  "shippingAddress": "{\"street\":\"123 Main St\",\"city\":\"New York\",\"state\":\"NY\",\"zip\":\"10001\",\"country\":\"USA\"}"
+
+  }
+}

03_source/cms_backend/src/app/api/party-order/delete/route.ts

@@ -0,0 +1,22 @@
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { deleteOrder } from 'src/app/services/party-order.service';
+
+/** **************************************
+ * PATCH - Delete PartyOrder
+ *************************************** */
+export async function PATCH(req: NextRequest) {
+  try {
+    const { partyOrderId } = await req.json();
+
+    if (!partyOrderId) throw new Error('orderId cannot be null');
+
+    await deleteOrder(partyOrderId);
+
+    return response({ partyOrderId }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyOrder - Delete', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/delete/test.http

@@ -0,0 +1,8 @@
+###
+
+PATCH http://localhost:7272/api/party-order/delete
+Content-Type: application/json
+
+{
+  "partyOrderId": "e99f09a7-dd88-49d5-b1c8-1daf80c2d7b02"
+}

03_source/cms_backend/src/app/api/party-order/details/route.ts

@@ -0,0 +1,56 @@
+// src/app/api/party-order/details/route.ts
+//
+// PURPOSE:
+// Get party order from db by id
+//
+// RULES:
+// Do not modify the format and level of details thanks.
+
+import type { NextRequest } from 'next/server';
+
+import { logger } from 'src/utils/logger';
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { L_INFO, L_ERROR } from 'src/constants';
+import { getOrder } from 'src/app/services/party-order.service';
+import { createAppLog } from 'src/app/services/app-log.service';
+
+import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';
+
+// ----------------------------------------------------------------------
+
+/**
+ **************************************
+ * GET PartyOrder detail
+ ***************************************
+ */
+export async function GET(req: NextRequest) {
+  const debug = { 'req.headers': flattenNextjsRequest(req) };
+
+  try {
+    const { searchParams } = req.nextUrl;
+
+    // RULES: partyOrderId must exist
+    const partyOrderId = searchParams.get('partyOrderId');
+    if (!partyOrderId) {
+      return response({ message: 'Order ID is required!' }, STATUS.BAD_REQUEST);
+    }
+
+    // NOTE: partyOrderId confirmed exist, run below
+    const partyOrder = await getOrder(partyOrderId);
+
+    if (!partyOrder) {
+      return response({ message: 'Order not found!' }, STATUS.NOT_FOUND);
+    }
+
+    logger('[PartyOrder] details', partyOrder.id);
+
+    createAppLog(L_INFO, 'Get order detail OK', debug);
+
+    return response({ partyOrder }, STATUS.OK);
+  } catch (error) {
+    createAppLog(L_ERROR, 'order detail error', debug);
+
+    return handleError('PartyOrder - Get details', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/details/test.http

@@ -0,0 +1,9 @@
+###
+
+# Get details for a specific party order
+GET http://localhost:7272/api/party-order/details?partyOrderId=e99f09a7-dd88-49d5-b1c8-1daf80c2d7b13
+
+###
+
+# Alternative format with different ID
+GET http://localhost:7272/api/party-order/details?id=ord_987654321

03_source/cms_backend/src/app/api/party-order/helloworld/route.ts

@@ -0,0 +1,16 @@
+import type { NextRequest, NextResponse } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+/**
+ ***************************************
+ * GET - helloworld
+ ***************************************
+ */
+export async function GET(req: NextRequest, res: NextResponse) {
+  try {
+    return response({ helloworld: 'party-order' }, STATUS.OK);
+  } catch (error) {
+    return handleError('Helloworld - Get all', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/helloworld/test.http

@@ -0,0 +1,2 @@
+###
+GET http://localhost:7272/api/party-order/helloworld

03_source/cms_backend/src/app/api/party-order/list/route.ts

@@ -0,0 +1,38 @@
+// src/app/api/party-order/list/route.ts
+//
+// PURPOSE:
+// List all party orders from db
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { L_INFO, L_ERROR } from 'src/constants';
+import { createAppLog } from 'src/app/services/app-log.service';
+import { listPartyOrders } from 'src/app/services/party-order.service';
+
+import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * GET - PartyOrders list
+ *************************************** */
+export async function GET(req: NextRequest) {
+  const debug = { 'req.headers': flattenNextjsRequest(req) };
+
+  try {
+    const partyOrders = await listPartyOrders();
+
+    createAppLog(L_INFO, 'party-order list ok', {});
+
+    return response({ partyOrders }, STATUS.OK);
+  } catch (error) {
+    createAppLog(L_ERROR, 'party-order list error', debug);
+
+    return handleError('PartyOrder - Get list', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/list/test.http

@@ -0,0 +1,19 @@
+###
+
+# Basic list all orders
+GET http://localhost:7272/api/party-order/list
+
+###
+
+# List orders by status
+GET http://localhost:7272/api/party-order/list?status=completed
+
+###
+
+# List orders by user
+GET http://localhost:7272/api/party-order/list?userId=usr_987654321
+
+###
+
+# List orders by payment status
+GET http://localhost:7272/api/party-order/list?paymentStatus=paid

03_source/cms_backend/src/app/api/party-order/route.ts

@@ -0,0 +1,75 @@
+import type { NextRequest, NextResponse } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { listPartyOrders, deleteOrder, updateOrder, createOrder } from 'src/app/services/party-order.service';
+
+/**
+ **************************************
+ * GET - PartyOrder
+ ***************************************
+ */
+export async function GET(req: NextRequest, res: NextResponse) {
+  try {
+    const orders = await listPartyOrders();
+    return response(orders, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyOrder - Get list', error);
+  }
+}
+
+/**
+ ***************************************
+ * POST - Create PartyOrder
+ ***************************************
+ */
+export async function POST(req: NextRequest) {
+  const OPERATION = 'PartyOrder - Create';
+  const { data } = await req.json();
+
+  try {
+    const order = await createOrder(data);
+    return response(OPERATION, STATUS.OK);
+  } catch (error) {
+    return handleError(OPERATION, error);
+  }
+}
+
+/**
+ ***************************************
+ * PUT - Update PartyOrder
+ ***************************************
+ */
+export async function PUT(req: NextRequest) {
+  const { searchParams } = req.nextUrl;
+  const orderId = searchParams.get('orderId');
+  const { data } = await req.json();
+
+  try {
+    if (!orderId) throw new Error('orderId cannot be null');
+
+    const result = await updateOrder(orderId, data);
+    return response(result, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyOrder - Update', error);
+  }
+}
+
+/**
+ ***************************************
+ * DELETE - Delete PartyOrder
+ ***************************************
+ */
+export async function DELETE(req: NextRequest) {
+  const { searchParams } = req.nextUrl;
+  const orderId = searchParams.get('orderId');
+
+  try {
+    if (!orderId) throw new Error('orderId cannot be null');
+
+    await deleteOrder(orderId);
+    return response({ success: true }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyOrder - Delete', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/search/route.ts

@@ -0,0 +1,35 @@
+import type { NextRequest } from 'next/server';
+
+import { logger } from 'src/utils/logger';
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import type { IOrderItem } from '../update/route';
+
+// import { searchEvents } from 'src/app/services/party-event.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * GET - Search PartyEvents
+ *************************************** */
+export async function GET(req: NextRequest) {
+  try {
+    const { searchParams } = req.nextUrl;
+    const query = searchParams.get('query')?.trim().toLowerCase();
+
+    if (!query) {
+      return response({ results: [] }, STATUS.OK);
+    }
+
+    const results: IOrderItem[] = [];
+    // TODO: search party event not implemented
+    console.log('search party event not implemented');
+    // const results = await searchEvents(query);
+
+    logger('[PartyEvent] search-results', results?.length);
+
+    return response({ results }, STATUS.OK);
+  } catch (error) {
+    return handleError('PartyEvent - Get search', error);
+  }
+}

03_source/cms_backend/src/app/api/party-order/search/test.http

@@ -0,0 +1,24 @@
+###
+
+# Search party events by title
+GET http://localhost:7272/api/party-event/search?query=Music
+
+###
+
+# Search party events by location
+GET http://localhost:7272/api/party-event/search?query=Central+Park
+
+###
+
+# Search party events by tag
+GET http://localhost:7272/api/party-event/search?query=Festival
+
+###
+
+# Combined search with multiple parameters
+GET http://localhost:7272/api/party-event/search?query=Summer&location=Hong+Kong&category=Music
+
+###
+
+# No results expected
+GET http://localhost:7272/api/party-event/search?query=zzzzzz

03_source/cms_backend/src/app/api/party-order/update/route.ts

@@ -0,0 +1,51 @@
+// src/app/api/party-order/update/route.ts
+//
+// PURPOSE:
+// Update party order in db by id
+//
+// RULES:
+// T.B.A.
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { updateOrder } from 'src/app/services/party-order.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * PUT - Update PartyOrder
+ *************************************** */
+export async function PUT(req: NextRequest) {
+  const { orderData } = await req.json();
+  const { id } = orderData;
+
+  if (!id) return response({ message: 'id not found' }, STATUS.ERROR);
+
+  try {
+    const result = await updateOrder(id, orderData);
+
+    return response({ result }, STATUS.OK);
+  } catch (error) {
+    console.error('Error updating order:', { orderData });
+    return handleError('PartyOrder - Update', error);
+  }
+}
+
+export type IOrderItem = {
+  id: string;
+  eventId: string;
+  userId: string;
+  status: string;
+  paymentStatus: string;
+  totalAmount: number;
+  items: {
+    id: string;
+    name: string;
+    quantity: number;
+    price: number;
+  }[];
+  createdAt: Date;
+  updatedAt: Date;
+};

03_source/cms_backend/src/app/api/party-order/update/test.http

@@ -0,0 +1,51 @@
+###
+
+PUT http://localhost:7272/api/party-order/update
+Content-Type: application/json
+
+{
+  "orderData": {
+    "id":"e99f09a7-dd88-49d5-b1c8-1daf80c2d7b02",
+    "taxes": 10.50,
+    "status": "completed",
+    "shipping": 5.00,
+    "discount": 20.00,
+    "subtotal": 290.00,
+    "orderNumber": "ORD-2023-001",
+    "totalAmount": 300.00,
+    "totalQuantity": 2,
+    "history": {
+      "payment": "2023-01-01",
+      "status_changes": [
+        "pending",
+        "paid"
+      ]
+    },
+    "payment": {
+      "method": "credit_card",
+      "card_last4": "4321"
+    },
+    "customer": {
+      "name": "John Doe",
+      "email": "john@example.com"
+    },
+    "delivery": {
+      "method": "express",
+      "tracking_number": "TRK123456"
+    },
+    "items": [
+      {
+        "id": "ticket_001",
+        "name": "General Admission",
+        "quantity": 2,
+        "price": 150.00,
+        "status": "used"
+      }
+    ],
+    "shippingAddress": {
+      "street": "123 Main St",
+      "city": "New York",
+      "zip": "10001"
+    }
+  }
+}

03_source/cms_backend/src/app/api/post/search/route.ts

@@ -24,10 +24,7 @@ export async function GET(req: NextRequest) {
     const posts = _posts();
 
     // Accept search by title or description
-    const results = posts.filter(
-      ({ title, description }) =>
-        title.toLowerCase().includes(query) || description?.toLowerCase().includes(query)
-    );
+    const results = posts.filter(({ title, description }) => title.toLowerCase().includes(query) || description?.toLowerCase().includes(query));
 
     logger('[Post] search-results', results.length);
 

03_source/cms_backend/src/app/api/product/create/route.ts

@@ -0,0 +1,46 @@
+// src/app/api/product/createProduct/route.ts
+// REQ0183 frontend product new
+//
+// PURPOSE:
+// create product to db
+//
+// RULES:
+// T.B.A.
+//
+
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { isDev } from 'src/constants';
+
+import prisma from '../../../lib/prisma';
+import { createProduct } from 'src/app/services/product.service';
+// import { createProduct } from 'src/app/services/product.service';
+
+// ----------------------------------------------------------------------
+
+/** **************************************
+ * POST - Products
+ *************************************** */
+export async function POST(req: NextRequest) {
+  const { productData } = await req.json();
+
+  try {
+    if (isDev) {
+      console.log({ productData });
+    }
+
+    const created = await createProduct(productData);
+    // const created = await prisma.productItem.create({ data: productData });
+
+    if (isDev) {
+      console.log('create done');
+    }
+
+    return response(created, STATUS.OK);
+  } catch (error) {
+    console.log({ hello: 'world', productData });
+    return handleError('Product - Create', error);
+  }
+}

03_source/cms_backend/src/app/api/product/create/test.http

@@ -0,0 +1,51 @@
+###
+
+POST http://localhost:7272/api/product/create
+Content-Type: application/json
+
+{
+    "productData": {
+        "available": 99,
+        "category": "T-shirts",
+        "code": "PD-12345",
+        "colors": [
+            "Red"
+        ],
+        "coverUrl": "",
+        "description": "this is description, 会員管理機能は、単なるデータ管理ツール以上の価値を持ちます。 企業は顧客の情報や動向を深く理解し、長期的な顧客関係の構築やロイヤルティの確立、そして迅速な市場変動への対応に直結します。 会員管理機能は、現代のビジネスにおいて企業の競争力を高める基盤として欠かせないものとなっています。",
+        "gender": [
+            "Men"
+        ],
+        "images": [
+            "data:image/png;base64,C",
+            "data:image/png;base64,C"
+        ],
+        "inventoryType": "test",
+        "name": "hello product",
+        "newLabel": {
+            "enabled": false,
+            "content": ""
+        },
+        "price": 99.99,
+        "priceSale": null,
+        "publish": "yes",
+        "quantity": 99,
+        "saleLabel": {
+            "enabled": false,
+            "content": ""
+        },
+        "sizes": [
+            "7"
+        ],
+        "sku": "SK-122345",
+        "subDescription": "this is test sub-description",
+        "tags": [
+            "Travel",
+            "Finance"
+        ],
+        "taxes": 0,
+        "totalRatings": 1,
+        "totalReviews": 1,
+        "totalSold": 1
+    }
+}

03_source/cms_backend/src/app/api/product/createProduct/route.ts

@@ -1,75 +0,0 @@
-// src/app/api/product/createProduct/route.ts
-//
-// PURPOSE:
-// create product to db
-//
-// RULES:
-// T.B.A.
-//
-
-import type { NextRequest } from 'next/server';
-
-import { STATUS, response, handleError } from 'src/utils/response';
-
-import prisma from '../../../lib/prisma';
-
-// ----------------------------------------------------------------------
-
-/** **************************************
- * POST - Products
- *************************************** */
-export async function POST(req: NextRequest) {
-  // logger('[Product] list', products.length);
-  const { data } = await req.json();
-  const createForm: CreateProductData = data as unknown as CreateProductData;
-
-  console.log({ createForm });
-
-  try {
-    console.log({ data });
-    await prisma.productItem.create({ data: createForm });
-    return response({ hello: 'world' }, STATUS.OK);
-  } catch (error) {
-    console.log({ hello: 'world', data });
-    return handleError('Product - Create', error);
-  }
-}
-
-type CreateProductData = {
-  // id: string;
-  sku: string;
-  name: string;
-  code: string;
-  price: number;
-  taxes: number;
-  tags: string[];
-  sizes: string[];
-  publish: string;
-  gender: string[];
-  coverUrl: string;
-  images: string[];
-  colors: string[];
-  quantity: number;
-  category: string;
-  available: number;
-  totalSold: number;
-  description: string;
-  totalRatings: number;
-  totalReviews: number;
-  inventoryType: string;
-  subDescription: string;
-  priceSale: number;
-  newLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  saleLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  // ratings: {
-  //   name: string;
-  //   starCount: number;
-  //   reviewCount: number;
-  // }[];
-};

03_source/cms_backend/src/app/api/product/delete/route.ts

@@ -0,0 +1,22 @@
+import type { NextRequest } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+import { deleteProduct } from 'src/app/services/product.service';
+
+/** **************************************
+ * PATCH - Delete product
+ *************************************** */
+export async function PATCH(req: NextRequest) {
+  try {
+    const { productId } = await req.json();
+
+    if (!productId) throw new Error('productId cannot be null');
+
+    await deleteProduct(productId);
+
+    return response({ productId }, STATUS.OK);
+  } catch (error) {
+    return handleError('Product - Delete', error);
+  }
+}

03_source/cms_backend/src/app/api/product/delete/test.http

@@ -0,0 +1,8 @@
+###
+
+PATCH http://localhost:7272/api/product/delete
+Content-Type: application/json
+
+{
+  "productId" :"e99f09a7-dd88-49d5-b1c8-1daf80c2d7b06"
+}

03_source/cms_backend/src/app/api/product/deleteProduct/route.ts

@@ -1,44 +0,0 @@
-// src/app/api/product/deleteProduct/route.ts
-//
-// PURPOSE:
-// delete product from db by id
-//
-// RULES:
-// T.B.A.
-
-import type { NextRequest } from 'next/server';
-
-import { logger } from 'src/utils/logger';
-import { STATUS, response, handleError } from 'src/utils/response';
-
-import prisma from '../../../lib/prisma';
-
-// ----------------------------------------------------------------------
-
-/** **************************************
- * handle Delete Products
- *************************************** */
-export async function DELETE(req: NextRequest) {
-  try {
-    const { searchParams } = req.nextUrl;
-
-    // RULES: productId must exist
-    const productId = searchParams.get('productId');
-    if (!productId) {
-      return response({ message: 'Product ID is required!' }, STATUS.BAD_REQUEST);
-    }
-
-    // NOTE: productId confirmed exist, run below
-    const product = await prisma.productItem.delete({ where: { id: productId } });
-
-    if (!product) {
-      return response({ message: 'Product not found!' }, STATUS.NOT_FOUND);
-    }
-
-    logger('[Product] details', product.id);
-
-    return response({ product }, STATUS.OK);
-  } catch (error) {
-    return handleError('Product - Get details', error);
-  }
-}

03_source/cms_backend/src/app/api/product/deleteProduct/test.http

@@ -1,3 +0,0 @@
-###
-
-DELETE http://localhost:7272/api/product/deleteProduct?productId=e99f09a7-dd88-49d5-b1c8-1daf80c2d7b06

03_source/cms_backend/src/app/api/product/details/route.ts

@@ -1,5 +1,7 @@
 // src/app/api/product/details/route.ts
 //
+// REQ0182 frontend product details
+//
 // PURPOSE:
 // get product from db by id
 //
@@ -13,7 +15,7 @@ import { STATUS, response, handleError } from 'src/utils/response';
 
 import { L_INFO, L_ERROR } from 'src/constants';
 import { getProduct } from 'src/app/services/product.service';
-import { createAppLog } from 'src/app/services/AppLog.service';
+import { createAppLog } from 'src/app/services/app-log.service';
 
 import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';
 

03_source/cms_backend/src/app/api/product/details/test.http

@@ -1,3 +1,5 @@
 ###
-
+GET http://localhost:7272/api/product/details?productId=e99f09a7-dd88-49d5-b1c8-1daf80c2d7b01
+
+###
 GET http://localhost:7272/api/product/details?productId=e99f09a7-dd88-49d5-b1c8-1daf80c2d7b01

03_source/cms_backend/src/app/api/product/helloworld/route.ts

@@ -0,0 +1,16 @@
+import type { NextRequest, NextResponse } from 'next/server';
+
+import { STATUS, response, handleError } from 'src/utils/response';
+
+/**
+ ***************************************
+ * GET - helloworld
+ ***************************************
+ */
+export async function GET(req: NextRequest, res: NextResponse) {
+  try {
+    return response({ helloworld: 'product' }, STATUS.OK);
+  } catch (error) {
+    return handleError('Helloworld - Get all', error);
+  }
+}

03_source/cms_backend/src/app/api/product/helloworld/test.http

@@ -0,0 +1,4 @@
+###
+GET /api/product/helloworld HTTP/1.1
+Host: localhost:7272
+

03_source/cms_backend/src/app/api/product/image/upload/route.ts

@@ -1,30 +0,0 @@
-// src/app/api/product/image/upload/route.ts
-//
-// PURPOSE:
-// handle upload product image
-//
-// RULES:
-// T.B.A.
-
-import type { NextRequest } from 'next/server';
-
-import { STATUS, response, handleError } from 'src/utils/response';
-
-// import prisma from '../../../lib/prisma';
-
-// ----------------------------------------------------------------------
-
-/** **************************************
- * GET - Products
- *************************************** */
-export async function POST(req: NextRequest) {
-  try {
-    const { data } = await req.json();
-    console.log('helloworld');
-
-    return response({ hello: 'world' }, STATUS.OK);
-  } catch (error) {
-    console.log({ hello: 'world' });
-    return handleError('Product - store product image', error);
-  }
-}

03_source/cms_backend/src/app/api/product/list/route.ts

@@ -11,7 +11,7 @@ import type { NextRequest } from 'next/server';
 import { STATUS, response, handleError } from 'src/utils/response';
 
 import { L_INFO, L_ERROR } from 'src/constants';
-import { createAppLog } from 'src/app/services/AppLog.service';
+import { createAppLog } from 'src/app/services/app-log.service';
 import { listProducts } from 'src/app/services/product.service';
 
 import { flattenNextjsRequest } from '../../auth/sign-in/flattenNextjsRequest';

03_source/cms_backend/src/app/api/product/list/route.ts.bak

@@ -1,23 +0,0 @@
-import { logger } from 'src/utils/logger';
-import { STATUS, response, handleError } from 'src/utils/response';
-
-import { _products } from 'src/_mock/_product';
-
-// ----------------------------------------------------------------------
-
-export const runtime = 'edge';
-
-/** **************************************
- * GET - Products
- *************************************** */
-export async function GET() {
-  try {
-    const products = _products();
-
-    logger('[Product] list', products.length);
-
-    return response({ products }, STATUS.OK);
-  } catch (error) {
-    return handleError('Product - Get list', error);
-  }
-}

03_source/cms_backend/src/app/api/product/search/route.ts

@@ -3,11 +3,11 @@ import type { NextRequest } from 'next/server';
 import { logger } from 'src/utils/logger';
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { _products } from 'src/_mock/_product';
+import { getProductBySkuOrName } from 'src/app/services/product.service';
 
 // ----------------------------------------------------------------------
 
-export const runtime = 'edge';
+// export const runtime = 'edge';
 
 /** **************************************
  * GET - Search products
@@ -21,12 +21,9 @@ export async function GET(req: NextRequest) {
       return response({ results: [] }, STATUS.OK);
     }
 
-    const products = _products();
+    const results = await getProductBySkuOrName(query);
 
-    // Accept search by name or sku
-    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-
-    logger('[Product] search-results', results.length);
+    logger('[Product] search-results', results?.length);
 
     return response({ results }, STATUS.OK);
   } catch (error) {

03_source/cms_backend/src/app/api/product/search/test.http

@@ -0,0 +1,8 @@
+###
+GET http://localhost:7272/api/product/search?query=B
+
+###
+GET http://localhost:7272/api/product/search?query=Classic
+
+###
+GET http://localhost:7272/api/product/search?query=zzzzzz

03_source/cms_backend/src/app/api/product/update/route.ts

@@ -17,58 +17,58 @@ import prisma from '../../../lib/prisma';
 /** **************************************
  * GET - Products
  *************************************** */
-export async function POST(req: NextRequest) {
+export async function PUT(req: NextRequest) {
   // logger('[Product] list', products.length);
-  const { data } = await req.json();
+  const { productData } = await req.json();
 
   try {
     const products = await prisma.productItem.updateMany({
       data: {
-        name: data.name,
-        sku: data.sku,
-        code: data.code,
-        price: data.price,
-        taxes: data.taxes,
-        tags: data.tags,
-        sizes: data.sizes,
-        publish: data.publish,
-        gender: data.gender,
-        coverUrl: data.coverUrl,
-        images: data.images,
-        colors: data.colors,
-        quantity: data.quantity,
-        category: data.category,
-        available: data.available,
-        totalSold: data.totalSold,
-        description: data.description,
-        totalRatings: data.totalRatings,
-        totalReviews: data.totalReviews,
-        inventoryType: data.inventoryType,
-        subDescription: data.subDescription,
-        priceSale: data.priceSale,
+        name: productData.name,
+        sku: productData.sku,
+        code: productData.code,
+        price: productData.price,
+        taxes: productData.taxes,
+        tags: productData.tags,
+        sizes: productData.sizes,
+        publish: productData.publish,
+        gender: productData.gender,
+        coverUrl: productData.coverUrl,
+        images: productData.images,
+        colors: productData.colors,
+        quantity: productData.quantity,
+        category: productData.category,
+        available: productData.available,
+        totalSold: productData.totalSold,
+        description: productData.description,
+        totalRatings: productData.totalRatings,
+        totalReviews: productData.totalReviews,
+        inventoryType: productData.inventoryType,
+        subDescription: productData.subDescription,
+        priceSale: productData.priceSale,
         //
         newLabel: {
-          content: data.newLabel?.content || '',
-          enabled: data.newLabel?.enabled ?? false,
+          content: productData.newLabel?.content || '',
+          enabled: productData.newLabel?.enabled ?? false,
         },
         saleLabel: {
-          content: data.saleLabel?.content || '',
-          enabled: data.saleLabel?.enabled ?? false,
+          content: productData.saleLabel?.content || '',
+          enabled: productData.saleLabel?.enabled ?? false,
         },
         ratings: {
-          set: data.ratings.map((rating: { name: string; starCount: number; reviewCount: number }) => ({
+          set: productData.ratings.map((rating: { name: string; starCount: number; reviewCount: number }) => ({
             name: rating.name,
             starCount: rating.starCount,
             reviewCount: rating.reviewCount,
           })),
         },
       },
-      where: { id: data.id },
+      where: { id: productData.id },
     });
 
-    return response({ data }, STATUS.OK);
+    return response({ data: productData }, STATUS.OK);
   } catch (error) {
-    console.log({ data });
+    console.log({ data: productData });
     return handleError('Product - Get list', error);
   }
 }

03_source/cms_backend/src/app/api/product/update/test.http

@@ -0,0 +1,52 @@
+###
+
+PUT  http://localhost:7272/api/product/update
+Content-Type: application/json
+
+{
+    "productData": {
+        "available": 99,
+        "category": "T-shirts",
+        "code": "PD-12345",
+        "colors": [
+            "Red"
+        ],
+        "coverUrl": "",
+        "description": "this is description, 会員管理機能は、単なるデータ管理ツール以上の価値を持ちます。 企業は顧客の情報や動向を深く理解し、長期的な顧客関係の構築やロイヤルティの確立、そして迅速な市場変動への対応に直結します。 会員管理機能は、現代のビジネスにおいて企業の競争力を高める基盤として欠かせないものとなっています。",
+        "gender": [
+            "Men"
+        ],
+        "images": [
+            "data:image/png;base64,C",
+            "data:image/png;base64,C"
+        ],
+        "inventoryType": "test",
+        "name": "hello product",
+        "newLabel": {
+            "enabled": false,
+            "content": ""
+        },
+        "price": 99.99,
+        "priceSale": null,
+        "publish": "yes",
+        "quantity": 99,
+        "ratings":[],
+        "saleLabel": {
+            "enabled": false,
+            "content": ""
+        },
+        "sizes": [
+            "7"
+        ],
+        "sku": "SK-122345",
+        "subDescription": "this is test sub-description",
+        "tags": [
+            "Travel",
+            "Finance"
+        ],
+        "taxes": 0,
+        "totalRatings": 1,
+        "totalReviews": 1,
+        "totalSold": 1
+    }
+}

03_source/cms_backend/src/app/api/user/changeToAdmin/route.ts

@@ -4,7 +4,7 @@ import type { NextRequest } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { changeToAdmin } from 'src/app/services/userItem.service';
+import { changeToAdmin } from 'src/app/services/user-item.service';
 
 /**
  ***************************************

03_source/cms_backend/src/app/api/user/changeToUser/route.ts

@@ -4,7 +4,7 @@ import type { NextRequest } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { changeToUser } from 'src/app/services/userItem.service';
+import { changeToUser } from 'src/app/services/user-item.service';
 
 /**
  ***************************************

03_source/cms_backend/src/app/api/user/checkAdmin/route.ts

@@ -2,7 +2,7 @@ import type { NextRequest, NextResponse } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { isAdmin } from 'src/app/services/userItem.service';
+import { isAdmin } from 'src/app/services/user-item.service';
 
 // import prisma from '../../lib/prisma';
 

03_source/cms_backend/src/app/api/user/helloworld/route.ts

@@ -2,7 +2,7 @@ import type { NextRequest, NextResponse } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { isAdmin } from 'src/app/services/userItem.service';
+import { isAdmin } from 'src/app/services/user-item.service';
 
 // import prisma from '../../lib/prisma';
 

03_source/cms_backend/src/app/api/user/list/route.ts

@@ -3,7 +3,7 @@
 import { logger } from 'src/utils/logger';
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { listUsers } from 'src/app/services/userItem.service';
+import { listUsers } from 'src/app/services/user-item.service';
 
 // ----------------------------------------------------------------------
 

03_source/cms_backend/src/app/api/user/route.ts

@@ -2,7 +2,7 @@ import type { NextRequest, NextResponse } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { listUsers, deleteUser, updateUser, createNewUser } from 'src/app/services/userItem.service';
+import { listUsers, deleteUser, updateUser, createNewUser } from 'src/app/services/user-item.service';
 
 // import prisma from '../../lib/prisma';
 

03_source/cms_backend/src/app/api/user/search/route.ts

@@ -24,9 +24,7 @@ export async function GET(req: NextRequest) {
     const products = _products();
 
     // Accept search by name or sku
-    const results = products.filter(
-      ({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query)
-    );
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
 
     logger('[Product] search-results', results.length);
 

03_source/cms_backend/src/app/services/_PROMPTS/clone_srevice.md

@@ -1,7 +1,13 @@
-with knowledge in schema.prisma file,
-please refer the below helloworld example `helloworld.service.ts`
-and create `user.service.ts` to cover user record
+Hi,
 
-thanks
+i copied from
+`03_source/cms_backend/src/app/services/party-event.service.ts`
+to
+`03_source/cms_backend/src/app/services/party-order.service.ts`
 
-`/home/logic/_wsl_workspace/001_github_ws/HKSingleParty-ws/HKSingleParty/03_source/cms_backend/src/app/services/helloworld.service.ts`
+with knowledge in `schema.prisma` file, and reference to the sibling files in same folder
+
+i want you to update `party-order.service.ts` content to handle party order (the purchase order of the party)
+please use the model `PartyOrderItem` to handle it.
+
+thanks.

03_source/cms_backend/src/app/services/party-event.service.ts

@@ -0,0 +1,139 @@
+// src/app/services/party-event.service.ts
+//
+// PURPOSE:
+// - Service for handling EventItem (PartyEvent) Record
+//
+
+import type { EventItem } from '@prisma/client';
+
+import prisma from '../lib/prisma';
+
+type CreateEvent = {
+  name: string;
+  title: string;
+  eventDate: Date;
+  location: string;
+  duration_m: number;
+  ageBottom?: number;
+  ageTop?: number;
+  currency?: string;
+  price?: number;
+  priceSale?: number;
+  coverUrl?: string;
+  images?: string[];
+  description?: string;
+  subDescription?: string;
+  publish?: string;
+  category?: string;
+  tags?: string[];
+  joinMembers?: any[];
+};
+
+type UpdateEvent = {
+  name?: string;
+  title?: string;
+  eventDate?: Date;
+  location?: string;
+  duration_m?: number;
+  ageBottom?: number;
+  ageTop?: number;
+  currency?: string;
+  price?: number;
+  priceSale?: number;
+  coverUrl?: string;
+  images?: string[];
+  description?: string;
+  subDescription?: string;
+  publish?: string;
+  category?: string;
+  tags?: string[];
+  joinMembers?: any[];
+};
+
+async function listEvents(): Promise<EventItem[]> {
+  return prisma.eventItem.findMany({
+    include: { reviews: true },
+  });
+}
+
+async function getEvent(eventId: string): Promise<EventItem | null> {
+  return prisma.eventItem.findUnique({
+    where: { id: eventId },
+    include: { reviews: true },
+  });
+}
+
+async function getEventByNameOrTitle(searchText: string): Promise<EventItem[] | null> {
+  return prisma.eventItem.findMany({
+    where: {
+      OR: [{ name: { contains: searchText, mode: 'insensitive' } }, { title: { contains: searchText, mode: 'insensitive' } }],
+    },
+    include: { reviews: true },
+  });
+}
+
+async function createEvent(eventData: any) {
+  return await prisma.eventItem.create({ data: eventData });
+}
+
+async function updateEvent(eventId: string, updateForm: any) {
+  return prisma.eventItem.update({
+    where: { id: eventId },
+    data: {
+      available: updateForm.available,
+      category: updateForm.category,
+      code: updateForm.code,
+      colors: updateForm.colors,
+      coverUrl: updateForm.coverUrl,
+      description: updateForm.description,
+      gender: updateForm.gender,
+      images: updateForm.images,
+      inventoryType: updateForm.inventoryType,
+      name: updateForm.name,
+      newLabel: updateForm.newLabel,
+      price: updateForm.price,
+      priceSale: updateForm.priceSale,
+      publish: updateForm.publish,
+      quantity: updateForm.quantity,
+      ratings: updateForm.ratings,
+      saleLabel: updateForm.saleLabel,
+      sizes: updateForm.sizes,
+      sku: updateForm.sku,
+      subDescription: updateForm.subDescription,
+      tags: updateForm.tags,
+      taxes: updateForm.taxes,
+      totalRatings: updateForm.totalRatings,
+      totalReviews: updateForm.totalReviews,
+      totalSold: updateForm.totalSold,
+      //
+      ageBottom: updateForm.ageBottom,
+      ageTop: updateForm.ageTop,
+      avatar: updateForm.avatar,
+      currency: updateForm.currency,
+      capacity: updateForm.capacity,
+      duration_m: updateForm.duration_m,
+      endDate: updateForm.endDate,
+      eventDate: updateForm.eventDate,
+      isFeatured: updateForm.isFeatured,
+      joinMembers: updateForm.joinMembers,
+      location: updateForm.location,
+      organizer: updateForm.organizer,
+      registrationDeadline: updateForm.registrationDeadline,
+      requirements: updateForm.requirements,
+      schedule: updateForm.schedule,
+      speakers: updateForm.speakers,
+      sponsors: updateForm.sponsors,
+      startDate: updateForm.startDate,
+      status: updateForm.status,
+      title: updateForm.title,
+    },
+  });
+}
+
+async function deleteEvent(eventId: string) {
+  return prisma.eventItem.delete({
+    where: { id: eventId },
+  });
+}
+
+export { getEvent, listEvents, createEvent, updateEvent, deleteEvent, getEventByNameOrTitle, type CreateEvent, type UpdateEvent };

03_source/cms_backend/src/app/services/party-order.service.ts

@@ -0,0 +1,66 @@
+// src/app/services/party-order.service.ts
+//
+// PURPOSE:
+// - Service for handling PartyOrderItem Record
+//
+
+import type { PartyOrderItem } from '@prisma/client';
+
+import prisma from '../lib/prisma';
+
+type CreateOrder = {
+  status: string;
+  taxes: number;
+  shipping: number;
+  discount: number;
+  items: any[];
+  customer: any;
+  payment: any;
+  delivery: any;
+  shippingAddress: any;
+  billingAddress: any;
+};
+
+type UpdateOrder = {
+  status?: string;
+  taxes?: number;
+  shipping?: number;
+  discount?: number;
+  items?: any[];
+  customer?: any;
+  payment?: any;
+  delivery?: any;
+  shippingAddress?: any;
+  billingAddress?: any;
+};
+
+async function listPartyOrders(): Promise<PartyOrderItem[]> {
+  return prisma.partyOrderItem.findMany();
+}
+
+async function getPartyOrder(partyOrderId: string): Promise<PartyOrderItem | null> {
+  return prisma.partyOrderItem.findUnique({
+    where: { id: partyOrderId },
+  });
+}
+
+async function createOrder(orderData: any) {
+  return prisma.partyOrderItem.create({
+    data: orderData,
+  });
+}
+
+async function updateOrder(orderId: string, updateData: UpdateOrder) {
+  return prisma.partyOrderItem.update({
+    where: { id: orderId },
+    data: updateData,
+  });
+}
+
+async function deleteOrder(orderId: string) {
+  return prisma.partyOrderItem.delete({
+    where: { id: orderId },
+  });
+}
+
+export { getPartyOrder as getOrder, createOrder, updateOrder, deleteOrder, listPartyOrders, type CreateOrder, type UpdateOrder };

03_source/cms_backend/src/app/services/product.service.ts

@@ -1,5 +1,7 @@
 // src/app/services/product.service.ts
 //
+// REQ0182 frontend product details
+//
 // PURPOSE:
 // - Service for handling ProductItem Record
 //
@@ -65,39 +67,29 @@ type UpdateProduct = {
 };
 
 async function listProducts(): Promise<ProductItem[]> {
-  return prisma.productItem.findMany();
+  return prisma.productItem.findMany({
+    include: { reviews: true },
+  });
 }
 
 async function getProduct(productId: string): Promise<ProductItem | null> {
-  return prisma.productItem.findUnique({ where: { id: productId } });
+  return prisma.productItem.findUnique({
+    where: { id: productId },
+    include: { reviews: true },
+    //
+  });
 }
 
-async function createProduct(createForm: CreateProduct) {
-  //   return prisma.productItem.create({
-  //     data: {
-  //       ...createForm,
-  //       code: createForm.code || '',
-  //       taxes: createForm.taxes || 0,
-  //       tags: createForm.tags || [],
-  //       sizes: createForm.sizes || [],
-  //       gender: createForm.gender || [],
-  //       colors: createForm.colors || [],
-  //       category: createForm.category || '',
-  //       quantity: createForm.quantity || 0,
-  //       available: createForm.available || 0,
-  //       coverUrl: createForm.coverUrl || '',
-  //       images: createForm.images || [],
-  //       description: createForm.description || '',
-  //       subDescription: createForm.subDescription || '',
-  //       publish: createForm.publish || 'published',
-  //       totalSold: createForm.totalSold || 0,
-  //       totalRatings: createForm.totalRatings || 0,
-  //       totalReviews: createForm.totalReviews || 0,
-  //       inventoryType: createForm.inventoryType || '',
-  //       ratings: createForm.ratings || [],
-  //       reviews: createForm.reviews || [],
-  //     },
-  //   });
+async function getProductBySkuOrName(searchText: string): Promise<ProductItem[] | null> {
+  return prisma.productItem.findMany({
+    where: { OR: [{ sku: { contains: searchText, mode: 'insensitive' } }, { name: { contains: searchText, mode: 'insensitive' } }] },
+    include: { reviews: true },
+    //
+  });
+}
+
+async function createProduct(productData: any) {
+  return await prisma.productItem.create({ data: productData });
 }
 
 async function updateProduct(productId: string, updateForm: UpdateProduct) {
@@ -111,4 +103,4 @@ async function deleteProduct(productId: string) {
   return prisma.productItem.delete({ where: { id: productId } });
 }
 
-export { getProduct, listProducts, createProduct, updateProduct, deleteProduct, type CreateProduct, type UpdateProduct };
+export { getProduct, listProducts, createProduct, updateProduct, deleteProduct, getProductBySkuOrName, type CreateProduct, type UpdateProduct };