update,

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,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/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

@@ -19,8 +19,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 3 --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\"",
@@ -43,6 +45,7 @@
     "@next-auth/prisma-adapter": "^1.0.7",
     "@prisma/adapter-pg": "^6.8.2",
     "@prisma/client": "^5.6.0",
+    "@types/bcrypt": "^5.0.2",
     "bcrypt": "^5.1.1",
     "date-fns": "^4.1.0",
     "dayjs": "^1.11.13",

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
+  gender         String[]
-  totalReviews   Int
+  images         String[]
   inventoryType  String
-  subDescription String
+  name           String
-  priceSale      Float?
   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 {
@@ -1144,6 +1144,7 @@ model EventReview {
   eventItemId String?
 }
 
+// NOTE: need to consider with Event
 // mapped to IEventItem
 model EventItem {
   id             String        @id @default(uuid())

03_source/cms_backend/scripts/00_dev.sh

@@ -0,0 +1,18 @@
+#!/usr/bin/env bash
+
+yarn --dev
+
+clear
+
+while true; do
+  yarn db:push
+
+  yarn seed
+
+  yarn db:studio &
+
+  yarn dev
+
+  echo "restarting..."
+  sleep 1
+done

03_source/cms_backend/scripts/10_build.sh

@@ -0,0 +1,18 @@
+#!/usr/bin/env bash
+
+set -x
+
+rm -rf ./**/*Zone.Identifier
+
+# yarn db:push
+# npx nodemon --ext ts,tsx --exec "yarn tsc"
+
+set -ex
+
+yarn fm:fix
+
+yarn tsc
+
+yarn build
+
+echo "done"

03_source/cms_backend/scripts/20_prod.sh

@@ -0,0 +1,5 @@
+#!/usr/bin/env bash
+
+set -x
+
+npm run start

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:
+    status: ([0, 1, 6, 12].includes(index) && 'online') || ([3, 8, 14].includes(index) && 'offline') || ([4, 10, 16].includes(index) && 'busy') || 'always',
-      ([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 = () =>
+const generateAttachments = () => Array.from({ length: 20 }, (_, index) => _mock.image.cover(index));
-  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:
+    priority: ([1, 3].includes(index) && PRIORITY_LEVEL.hight) || ([2, 4].includes(index) && PRIORITY_LEVEL.medium) || PRIORITY_LEVEL.low,
-      ([1, 3].includes(index) && PRIORITY_LEVEL.hight) ||
+    attachments: (index === 1 && attachmentList.slice(11, 15)) || (index === 5 && attachmentList.slice(4, 9)) || [],
-      ([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]: [
+  [COLUMN_IDS.id1]: [createTask(1, COLUMN_NAMES.name1), createTask(2, COLUMN_NAMES.name1), createTask(3, COLUMN_NAMES.name1)],
-    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 =
+    const attachments = (index === 1 && files.slice(0, 2)) || (index === 2 && files.slice(0, 4)) || (index === 5 && files.slice(4, 10)) || [];
-      (index === 1 && files.slice(0, 2)) ||
-      (index === 2 && files.slice(0, 4)) ||
-      (index === 5 && files.slice(4, 10)) ||
-      [];
 
-    const folder =
+    const folder = ([1, 2].includes(index) && 'spam') || ([3, 4].includes(index) && 'sent') || 'inbox';
-      ([1, 2].includes(index) && 'spam') || ([3, 4].includes(index) && 'sent') || 'inbox';
 
-    const labelIds =
+    const labelIds = (index === 1 && ['promotions', 'forums']) || (index === 2 && ['forums']) || (index === 5 && ['social']) || [];
-      (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) =>
+    company: (index: number) => `${CONFIG.basePath}/assets/images/company/company-${index + 1}.webp`,
-      `${CONFIG.basePath}/assets/images/company/company-${index + 1}.webp`,
+    product: (index: number) => `${CONFIG.basePath}/assets/images/m-product/product-${index + 1}.webp`,
-    product: (index: number) =>
+    portrait: (index: number) => `${CONFIG.basePath}/assets/images/portrait/portrait-${index + 1}.webp`,
-      `${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 = [
+const COLORS = ['#FF4842', '#1890FF', '#FFC0CB', '#00AB55', '#FFC107', '#7F00FF', '#000000', '#FFFFFF'];
-  '#FF4842',
-  '#1890FF',
-  '#FFC0CB',
-  '#00AB55',
-  '#FFC107',
-  '#7F00FF',
-  '#000000',
-  '#FFFFFF',
-];
 
 const DESCRIPTION = `
 <h6>Specifications</h6>
@@ -93,8 +84,7 @@ const DESCRIPTION = `
 
 `;
 
-const generateAttachments = () =>
+const generateAttachments = () => Array.from({ length: 20 }, (_, index) => _mock.image.product(index));
-  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:
+    attachments: (index === 1 && attachments.slice(0, 1)) || (index === 3 && attachments.slice(2, 4)) || (index === 5 && attachments.slice(5, 8)) || [],
-      (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:
+      subDescription: 'Featuring the original ripple design inspired by Japanese bullet trains, the Nike Air Max 97 lets you push your style full-speed ahead.',
-        '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(
+export const _id = Array.from({ length: 40 }, (_, index) => `e99f09a7-dd88-49d5-b1c8-1daf80c2d7b${index + 1}`);
-  { 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,
+  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,
-  60.62, 79.81, 93.68, 47.44, 76.24, 92.87, 72.91, 20.54, 94.25, 37.51,
+  94.25, 37.51,
 ];
 
-export const _ratings = [
+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];
-  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 = [
+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];
-  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,
+  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,
-  52.0, 6.8, 95.3, 26.6, 69.9, 92.1, 46.2, 85.6,
 ];
 
-export const _nativeS = [
+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];
-  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 = [
+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];
-  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,
+  9911, 1947, 9124, 6984, 8488, 2034, 3364, 8401, 8996, 5271, 8478, 1139, 8061, 3035, 6733, 3952, 2405, 3127, 6843, 4672, 6995, 6053, 5192, 9686,
-  2405, 3127, 6843, 4672, 6995, 6053, 5192, 9686,
 ];
 
 export const _fullAddress = [

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

@@ -10,7 +10,8 @@ import type { NextRequest } from 'next/server';
 
 import { STATUS, response, handleError } from 'src/utils/response';
 
-import { AccessLogService } from '../../../../modules/AccessLog/AccessLog.service';
+// import { AccessLogService } from '../../../../modules/AccessLog/AccessLog.service';
+import { getAccessLogById } from 'src/app/services/access-log.service';
 
 // ----------------------------------------------------------------------
 
@@ -27,7 +28,7 @@ export async function GET(req: NextRequest) {
     const accessLogId = searchParams.get('accessLogId');
     if (!accessLogId) return response({ message: 'accessLogId is required!' }, STATUS.BAD_REQUEST);
 
-    const accessLog = await AccessLogService.findById(accessLogId);
+    const accessLog = await getAccessLogById(accessLogId);
 
     if (!accessLog) return response({ message: 'AccessLog not found!' }, STATUS.NOT_FOUND);
 

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, updateAppLog, createNewAppLog } from 'src/app/services/AppLog.service';
+import { listAppLogs, deleteAppLog, createNewAppLog } from 'src/app/services/app-log.service';
 
 // import prisma from '../../lib/prisma';
 
@@ -34,28 +34,29 @@ export async function POST(req: NextRequest) {
   }
 }
 
-/**
+// TODO: delete `update AppLog`
- ***************************************
+// /**
- * PUT - update AppLog
+//  ***************************************
- ***************************************
+//  * PUT - update AppLog
- */
+//  ***************************************
-export async function PUT(req: NextRequest) {
+//  */
-  const { searchParams } = req.nextUrl;
+// export async function PUT(req: NextRequest) {
-  const appLogId = searchParams.get('appLogId');
+//   const { searchParams } = req.nextUrl;
+//   const appLogId = searchParams.get('appLogId');
 
-  const { data } = await req.json();
+//   const { data } = await req.json();
 
-  try {
+//   try {
-    if (!appLogId) throw new Error('appLogId cannot null');
+//     if (!appLogId) throw new Error('appLogId cannot null');
-    const id: number = parseInt(appLogId);
+//     const id: number = parseInt(appLogId);
 
-    const updateResult = await updateAppLog(id, data);
+//     const updateResult = await updateAppLog(id, data);
 
-    return response(updateResult, STATUS.OK);
+//     return response(updateResult, STATUS.OK);
-  } catch (error) {
+//   } catch (error) {
-    return handleError('AppLog - Update', error);
+//     return handleError('AppLog - Update', error);
-  }
+//   }
-}
+// }
 
 /**
  ***************************************
@@ -72,7 +73,7 @@ export async function DELETE(req: NextRequest) {
     if (!appLogId) throw new Error('appLogId cannot null');
     const id: number = parseInt(appLogId);
 
-    const deleteResult = await deleteAppLog(id);
+    const deleteResult = await deleteAppLog(id.toString());
 
     return response(deleteResult, STATUS.OK);
   } catch (error) {

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/event/search/route.ts

@@ -7,29 +7,28 @@ import { _events } from 'src/_mock/_event';
 
 // ----------------------------------------------------------------------
 
-export const runtime = 'edge';
+// export const runtime = 'edge';
 
 /** **************************************
  * GET - Search events
  *************************************** */
 export async function GET(req: NextRequest) {
-  try {
+  // try {
-    const { searchParams } = req.nextUrl;
+  //
-    const query = searchParams.get('query')?.trim().toLowerCase();
+  // TODO: implement search events
+  //
+  // const { searchParams } = req.nextUrl;
+  // const query = searchParams.get('query')?.trim().toLowerCase();
+  // if (!query) {
+  //   return response({ results: [] }, STATUS.OK);
+  // }
+  // const events = _events();
+  // // Accept search by name or sku
+  // const results = events.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
+  // logger('[Event] search-results', results.length);
+  // return response({ results }, STATUS.OK);
 
-    if (!query) {
+  // } catch (error) {
-      return response({ results: [] }, STATUS.OK);
+  return handleError('Event - Get search not implemented', {});
-    }
+  // }
-
-    const events = _events();
-
-    // Accept search by name or sku
-    const results = events.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-
-    logger('[Event] search-results', results.length);
-
-    return response({ results }, STATUS.OK);
-  } catch (error) {
-    return handleError('Event - Get search', error);
-  }
 }

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(
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-      ({ 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(
+  const columnsWithTasks = boardData.columns.map((col) => `${col.name} (${boardData.tasks[col.id].length} tasks)`);
-    (col) => `${col.name} (${boardData.tasks[col.id].length} tasks)`
+  logger('[Kanban] get-board', `columns (${boardData.columns.length}): ${JSON.stringify(columnsWithTasks, null, 2)}`);
-  );
-  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) =>
+    columns: boardData.columns.map((col) => (col.id === columnId ? { ...col, name: columnName } : 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) =>
+      [columnId]: boardData.tasks[columnId].map((task) => (task.id === taskData.id ? { ...task, ...taskData } : 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 =
+    const filteredMails = label.type === 'custom' ? mails.filter((mail) => mail.labelIds.includes(labelId!)) : filterMailsByLabelId(mails, labelId);
-      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/route.ts

@@ -28,7 +28,7 @@ export async function POST(req: NextRequest) {
 
   try {
     const order = await createOrder(data);
-    return response(order, STATUS.CREATED);
+    return response(order, STATUS.OK);
   } catch (error) {
     return handleError('Order - Create', error);
   }
@@ -48,7 +48,7 @@ export async function PUT(req: NextRequest) {
     if (!orderId) throw new Error('orderId cannot be null');
     const id: number = parseInt(orderId);
 
-    const updatedOrder = await updateOrder(id, data);
+    const updatedOrder = await updateOrder(id.toString(), data);
     return response(updatedOrder, STATUS.OK);
   } catch (error) {
     return handleError('Order - Update', error);
@@ -68,7 +68,7 @@ export async function DELETE(req: NextRequest) {
     if (!orderId) throw new Error('orderId cannot be null');
     const id: number = parseInt(orderId);
 
-    await deleteOrder(id);
+    await deleteOrder(id.toString());
     return response({ success: true }, STATUS.OK);
   } catch (error) {
     return handleError('Order - Delete', error);

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(
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-      ({ 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(
+        categoryOptions: Array.from(new Set(_products.map(({ category: c_category }) => c_category))), // Remove duplicate categories
-          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
+    const matchesSearch = searchQuery ? id.includes(searchQuery) || name.toLowerCase().includes(searchQuery) : true;
-      ? id.includes(searchQuery) || name.toLowerCase().includes(searchQuery)
-      : true;
     const matchesCategory = category ? prodCategory === category : true;
 
     return matchesSearch && matchesCategory;

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(
+    const results = posts.filter(({ title, description }) => title.toLowerCase().includes(query) || description?.toLowerCase().includes(query));
-      ({ 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/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/route.ts

@@ -24,13 +24,14 @@ export async function GET(req: NextRequest, res: NextResponse) {
  ***************************************
  */
 export async function POST(req: NextRequest) {
+  const OPERATION = 'Product - Create';
   const { data } = await req.json();
 
   try {
     const product = await createProduct(data);
-    return response(product, STATUS.CREATED);
+    return response(OPERATION, STATUS.OK);
   } catch (error) {
-    return handleError('Product - Create', error);
+    return handleError(OPERATION, 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
+    logger('[Product] search-results', results?.length);
-    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-
-    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,
+        name: productData.name,
-        sku: data.sku,
+        sku: productData.sku,
-        code: data.code,
+        code: productData.code,
-        price: data.price,
+        price: productData.price,
-        taxes: data.taxes,
+        taxes: productData.taxes,
-        tags: data.tags,
+        tags: productData.tags,
-        sizes: data.sizes,
+        sizes: productData.sizes,
-        publish: data.publish,
+        publish: productData.publish,
-        gender: data.gender,
+        gender: productData.gender,
-        coverUrl: data.coverUrl,
+        coverUrl: productData.coverUrl,
-        images: data.images,
+        images: productData.images,
-        colors: data.colors,
+        colors: productData.colors,
-        quantity: data.quantity,
+        quantity: productData.quantity,
-        category: data.category,
+        category: productData.category,
-        available: data.available,
+        available: productData.available,
-        totalSold: data.totalSold,
+        totalSold: productData.totalSold,
-        description: data.description,
+        description: productData.description,
-        totalRatings: data.totalRatings,
+        totalRatings: productData.totalRatings,
-        totalReviews: data.totalReviews,
+        totalReviews: productData.totalReviews,
-        inventoryType: data.inventoryType,
+        inventoryType: productData.inventoryType,
-        subDescription: data.subDescription,
+        subDescription: productData.subDescription,
-        priceSale: data.priceSale,
+        priceSale: productData.priceSale,
         //
         newLabel: {
-          content: data.newLabel?.content || '',
+          content: productData.newLabel?.content || '',
-          enabled: data.newLabel?.enabled ?? false,
+          enabled: productData.newLabel?.enabled ?? false,
         },
         saleLabel: {
-          content: data.saleLabel?.content || '',
+          content: productData.saleLabel?.content || '',
-          enabled: data.saleLabel?.enabled ?? false,
+          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/student/route.ts

@@ -1,6 +1,7 @@
-import prisma from '@/lib/prisma';
 import { NextResponse } from 'next/server';
 
+import prisma from 'src/app/lib/prisma';
+
 // GET: 获取所有学生
 export async function GET() {
   try {

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';
 
@@ -14,8 +14,8 @@ export async function GET(req: NextRequest, res: NextResponse) {
     if (!userId) throw new Error('userId cannot be null');
     const result = await isAdmin(userId);
 
-    return response(result, STATUS.OK);
+    return response(result ? 'true' : 'false', STATUS.OK);
   } catch (error) {
-    return handleError('Post - Get latest', error);
+    return handleError('GET - checkAdmin', error);
   }
 }

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';
 
@@ -14,8 +14,8 @@ export async function GET(req: NextRequest, res: NextResponse) {
     if (!userId) throw new Error('userId cannot be null');
     const result = await isAdmin(userId);
 
-    return response(result, STATUS.OK);
+    return response('GET - helloworld', STATUS.OK);
   } catch (error) {
-    return handleError('Post - Get latest', error);
+    return handleError('GET - helloworld', error);
   }
 }

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';
 
@@ -22,14 +22,17 @@ export async function GET(req: NextRequest, res: NextResponse) {
  ***************************************
  */
 export async function POST(req: NextRequest) {
+  const OPERATION = 'User - Create';
   const { data } = await req.json();
 
   try {
-    const createResult = await createNewUser(data);
+    // TODO: temporary ignore output from function due to `createNewUser` is still a dummy
+    // const createResult = await createNewUser(data);
+    await createNewUser(data);
 
-    return response(createResult, STATUS.OK);
+    return response(OPERATION, STATUS.OK);
   } catch (error) {
-    return handleError('User - Create', error);
+    return handleError(OPERATION, error);
   }
 }
 
@@ -48,7 +51,7 @@ export async function PUT(req: NextRequest) {
     if (!userId) throw new Error('userId cannot null');
     const id: number = parseInt(userId);
 
-    const updateResult = await updateUser(id, data);
+    const updateResult = await updateUser(id.toString(), data);
 
     return response(updateResult, STATUS.OK);
   } catch (error) {
@@ -71,10 +74,10 @@ export async function DELETE(req: NextRequest) {
     if (!userId) throw new Error('userId cannot null');
     const id: number = parseInt(userId);
 
-    const deleteResult = await deleteUser(id);
+    await deleteUser(id);
 
-    return response(deleteResult, STATUS.OK);
+    return response('User - Delete', STATUS.OK);
   } catch (error) {
-    return handleError('User - Update', error);
+    return handleError('User - Delete', error);
   }
 }

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(
+    const results = products.filter(({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query));
-      ({ name, sku }) => name.toLowerCase().includes(query) || sku?.toLowerCase().includes(query)
-    );
 
     logger('[Product] search-results', results.length);
 

03_source/cms_backend/src/app/services/access-log.service.ts

@@ -30,10 +30,15 @@ async function listAccessLogs(): Promise<AccessLog[]> {
   });
 }
 
+// TODO: obsoleted getAccessLog, use getAccessLogById instead
 async function getAccessLog(id: string): Promise<AccessLog | null> {
   return prisma.accessLog.findUnique({ where: { id } });
 }
 
+async function getAccessLogById(id: string): Promise<AccessLog | null> {
+  return prisma.accessLog.findUnique({ where: { id } });
+}
+
 async function createAccessLog(userId?: string, message?: string, metadata?: Record<string, any>): Promise<AccessLog> {
   return prisma.accessLog.create({
     data: {
@@ -44,6 +49,10 @@ async function createAccessLog(userId?: string, message?: string, metadata?: Rec
   });
 }
 
+function helloworld(): string {
+  return 'helloworld';
+}
+
 // async function update(id: string, data: UpdateAccessLog): Promise<AccessLog> {
 //   return prisma.accessLog.update({
 //     where: { id },
@@ -63,4 +72,7 @@ export {
   getAccessLog,
   listAccessLogs,
   createAccessLog,
+  getAccessLogById,
+  //
+  helloworld,
 };

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

@@ -6,11 +6,14 @@
 // RULES:
 // - Follows same pattern as helloworld.service.ts
 //
+import type { Event } from '@prisma/client';
+
+import prisma from '../lib/prisma';
 
 type CreateEvent = {
-  eventDate: DateTime;
+  eventDate: Date;
   title: string;
-  joinMembers?: Json[];
+  joinMembers?: JSON[];
   price: number;
   currency: string;
   duration_m: number;
@@ -22,9 +25,9 @@ type CreateEvent = {
 };
 
 type UpdateEvent = {
-  eventDate?: DateTime;
+  eventDate?: Date;
   title?: string;
-  joinMembers?: Json[];
+  joinMembers?: JSON[];
   price?: number;
   currency?: string;
   duration_m?: number;
@@ -35,9 +38,9 @@ type UpdateEvent = {
   memberId?: number;
 };
 
-// async function listEvents(): Promise<Event[]> {
+async function listEvents(): Promise<Event[]> {
-//   return prisma.event.findMany();
+  return prisma.event.findMany();
-// }
+}
 
 // async function getEvent(eventId: number) {
 //   return prisma.event.findFirst({ where: { id: eventId } });

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

@@ -12,9 +12,9 @@ import type { EventItem } from '@prisma/client';
 import prisma from '../lib/prisma';
 
 type CreateEvent = {
-  eventDate: DateTime;
+  eventDate: Date;
   title: string;
-  joinMembers?: Json[];
+  joinMembers?: JSON[];
   price: number;
   currency: string;
   duration_m: number;
@@ -26,9 +26,9 @@ type CreateEvent = {
 };
 
 type UpdateEvent = {
-  eventDate?: DateTime;
+  eventDate?: Date;
   title?: string;
-  joinMembers?: Json[];
+  joinMembers?: JSON[];
   price?: number;
   currency?: string;
   duration_m?: number;

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

@@ -11,9 +11,24 @@ import type { OrderItem } from '@prisma/client';
 import prisma from '../lib/prisma';
 
 type CreateOrderItem = {
-  orderNumber?: string;
+  // orderNumber?: string;
   // status?: string;
   // eventIds?: number[];
+
+  taxes: number;
+  status: string;
+  shipping: number;
+  discount: number;
+  subtotal: number;
+  orderNumber: string;
+  totalAmount: number;
+  totalQuantity: number;
+  history: Record<string, any>;
+  payment: Record<string, any>;
+  customer: Record<string, any>;
+  delivery: Record<string, any>;
+  items: Record<string, any>[];
+  shippingAddress: Record<string, any>;
 };
 
 type UpdateOrderItem = {

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) {
+async function getProductBySkuOrName(searchText: string): Promise<ProductItem[] | null> {
-  //   return prisma.productItem.create({
+  return prisma.productItem.findMany({
-  //     data: {
+    where: { OR: [{ sku: { contains: searchText, mode: 'insensitive' } }, { name: { contains: searchText, mode: 'insensitive' } }] },
-  //       ...createForm,
+    include: { reviews: true },
-  //       code: createForm.code || '',
+    //
-  //       taxes: createForm.taxes || 0,
+  });
-  //       tags: createForm.tags || [],
+}
-  //       sizes: createForm.sizes || [],
+
-  //       gender: createForm.gender || [],
+async function createProduct(productData: any) {
-  //       colors: createForm.colors || [],
+  return await prisma.productItem.create({ data: productData });
-  //       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 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 };

03_source/cms_backend/src/app/services/user-item.service.ts

@@ -38,7 +38,7 @@ async function getUserItem(userId: string): Promise<UserItem | null> {
   return prisma.userItem.findFirst({ where: { id: userId } });
 }
 
-async function updateUser(userId: string, updateForm: UpdateUser): Promise<User> {
+async function updateUser(userId: string, updateForm: UpdateUser): Promise<UserItem> {
   return prisma.userItem.update({
     where: { id: userId },
     data: updateForm,
@@ -82,7 +82,7 @@ async function changeToUser(userIdToPromote: string, userIdOfApplicant: string)
   return promoteResult;
 }
 
-async function getUserById1(id: string): Promise<UserItem | null> {
+async function getUserById(id: string): Promise<UserItem | null> {
   return prisma.userItem.findFirst({ where: { id } });
 }
 

03_source/cms_backend/src/constants.ts

@@ -1,7 +1,9 @@
+const isDev = process.env.NODE_ENV === 'development';
+
 const L_ERROR = 0;
 const L_WARN = 1;
 const L_INFO = 2;
 const L_DEBUG = 3;
 const L_TRACE = 4;
 
-export { L_WARN, L_INFO, L_ERROR, L_DEBUG, L_TRACE };
+export { L_WARN, L_INFO, L_ERROR, L_DEBUG, L_TRACE, isDev };

03_source/cms_backend/src/global-config.ts

@@ -13,8 +13,7 @@ type ConfigType = {
 
 export const CONFIG: ConfigType = {
   appVersion: packageJson.version,
-  basePath:
+  basePath: process.env.NODE_ENV === 'production' ? process.env.PRODUCTION_API : process.env.DEV_API,
-    process.env.NODE_ENV === 'production' ? process.env.PRODUCTION_API : process.env.DEV_API,
   cors: {
     /**
      * [] = allow all origins

03_source/cms_backend/src/utils/hash.ts

@@ -2,7 +2,6 @@ import bcrypt from 'bcrypt';
 
 const generateHash = async (password: string) => bcrypt.hash(password, await bcrypt.genSalt(10));
 
-const validatePassword = async (password: string, hash: string) =>
+const validatePassword = async (password: string, hash: string) => bcrypt.compare(password, hash as string);
-  bcrypt.compare(password, hash as string);
 
 export { generateHash, validatePassword };

03_source/cms_backend/src/utils/logger.ts

@@ -40,11 +40,7 @@ export function logger(label: string, value: unknown, breakLine: boolean = false
     if (value === null || value === undefined) {
       formattedValue = String(value);
     } else if (type === 'object') {
-      formattedValue = JSON.stringify(
+      formattedValue = JSON.stringify(value, null, breakLine || JSON.stringify(value).length > 50 ? 2 : 0);
-        value,
-        null,
-        breakLine || JSON.stringify(value).length > 50 ? 2 : 0
-      );
     } else {
       formattedValue = String(value);
     }

03_source/cms_backend/src/utils/set-date.ts

@@ -15,10 +15,8 @@ export function setDate(now: Date, options: { days?: number; hours?: number; min
   return new Date(`${year}-${month}-${days ?? today} ${hours}:${minutes}`).toJSON();
 }
 
-export const subHours = (
+export const subHours = (value: number, option: 'years' | 'months' | 'days' | 'hours' | 'minutes' | 'seconds' | 'milliseconds') =>
-  value: number,
+  dayjs().subtract(value, option).format();
-  option: 'years' | 'months' | 'days' | 'hours' | 'minutes' | 'seconds' | 'milliseconds'
-) => dayjs().subtract(value, option).format();
 
 // years,
 // months,
@@ -38,15 +36,7 @@ export type DurationProps = {
   milliseconds?: number;
 };
 
-export function fSub({
+export function fSub({ years = 0, months = 0, days = 0, hours = 0, minutes = 0, seconds = 0, milliseconds = 0 }: DurationProps) {
-  years = 0,
-  months = 0,
-  days = 0,
-  hours = 0,
-  minutes = 0,
-  seconds = 0,
-  milliseconds = 0,
-}: DurationProps) {
   const result = dayjs()
     .subtract(
       dayjs.duration({
@@ -64,15 +54,7 @@ export function fSub({
   return result;
 }
 
-export function fAdd({
+export function fAdd({ years = 0, months = 0, days = 0, hours = 0, minutes = 0, seconds = 0, milliseconds = 0 }: DurationProps) {
-  years = 0,
-  months = 0,
-  days = 0,
-  hours = 0,
-  minutes = 0,
-  seconds = 0,
-  milliseconds = 0,
-}: DurationProps) {
   const result = dayjs()
     .add(
       dayjs.duration({

03_source/cms_backend/tsconfig.json

@@ -34,16 +34,16 @@
     "node_modules",
     ".next",
     //
-    "**/* copy *.tsx",
+    "**/* copy *.*",
-    "**/* copy.tsx",
+    "**/* copy.*",
-    "**/*.bak",
     "**/*.bak",
     "**/*.bug",
     "**/*.del",
     "**/*.draft",
     "**/*.log",
     "**/*.tmp",
-    "**/*del"
+    "**/*del",
+    "prisma/*"
   ],
   "include": [
     "next-env.d.ts",

03_source/cms_backend/yarn.lock

@@ -770,6 +770,13 @@
   dependencies:
     tslib "^2.4.0"
 
+"@types/bcrypt@^5.0.2":
+  version "5.0.2"
+  resolved "https://registry.yarnpkg.com/@types/bcrypt/-/bcrypt-5.0.2.tgz#22fddc11945ea4fbc3655b3e8b8847cc9f811477"
+  integrity sha512-6atioO8Y75fNcbmj0G7UjI9lXN2pQ/IGJ2FWT4a/btd0Lk9lQalHLKhkgKVZ3r+spnmWUKfbMi1GEe9wyHQfNQ==
+  dependencies:
+    "@types/node" "*"
+
 "@types/estree@^1.0.6":
   version "1.0.7"
   resolved "https://registry.npmjs.org/@types/estree/-/estree-1.0.7.tgz"
@@ -790,6 +797,13 @@
   resolved "https://registry.yarnpkg.com/@types/lodash/-/lodash-4.17.17.tgz#fb85a04f47e9e4da888384feead0de05f7070355"
   integrity sha512-RRVJ+J3J+WmyOTqnz3PiBLA501eKwXl2noseKOrNo/6+XEHjTAxO4xHvxQB6QuNm+s4WRbn6rSiap8+EA+ykFQ==
 
+"@types/node@*":
+  version "24.0.1"
+  resolved "https://registry.yarnpkg.com/@types/node/-/node-24.0.1.tgz#e9bfcb1c35547437c294403b7bec497772a88b0a"
+  integrity sha512-MX4Zioh39chHlDJbKmEgydJDS3tspMP/lnQC67G3SWsTnb9NeYVWOjkxpOSy4oMfPs4StcWHwBrvUb4ybfnuaw==
+  dependencies:
+    undici-types "~7.8.0"
+
 "@types/node@^22.13.13":
   version "22.13.13"
   resolved "https://registry.npmjs.org/@types/node/-/node-22.13.13.tgz"
@@ -3486,6 +3500,11 @@ undici-types@~6.20.0:
   resolved "https://registry.npmjs.org/undici-types/-/undici-types-6.20.0.tgz"
   integrity sha512-Ny6QZ2Nju20vw1SRHe3d9jVu6gJ+4e3+MMpqu7pqE5HT6WsTSlce++GQmK5UXS8mzV8DSYHrQH+Xrf2jVcuKNg==
 
+undici-types@~7.8.0:
+  version "7.8.0"
+  resolved "https://registry.yarnpkg.com/undici-types/-/undici-types-7.8.0.tgz#de00b85b710c54122e44fbfd911f8d70174cd294"
+  integrity sha512-9UJ2xGDvQ43tYyVMpuHlsgApydB8ZKfVYTsLDhXkFL/6gfkp+U8xTGdh8pMJv1SpZna0zxG1DwsKZsreLbXBxw==
+
 unique-names-generator@^4.7.1:
   version "4.7.1"
   resolved "https://registry.yarnpkg.com/unique-names-generator/-/unique-names-generator-4.7.1.tgz#966407b12ba97f618928f77322cfac8c80df5597"

03_source/docker/docker-compose.dev.yml

@@ -1,14 +1,23 @@
+#
+# REQ0180 service port schedule
+#
 services:
   frontend:
-    command: 'sleep infinity'
+    command: "sleep infinity"
+    ports:
+      - 8080:8080
 
   mobile:
-    command: 'sleep infinity'
+    command: "sleep infinity"
+    ports:
+      - 8081:3000
 
   cms_backend:
-    command: 'sleep infinity'
+    command: "sleep infinity"
+    ports:
+      - 7272:7272
+      - 5555:5555
 
   postgres:
-    # container_name: postgres
     ports:
-      - '5432:5432'
+      - 5432:5432

03_source/docker/docker-compose.yml

@@ -1,3 +1,6 @@
+#
+# REQ0180 service port schedule
+#
 volumes:
   db:
     driver: local
@@ -11,8 +14,8 @@ services:
       - 10001:8080
     volumes:
       - ../frontend:/app
-    working_dir: '/app'
+    working_dir: "/app"
-    command: './dev.sh'
+    command: "./scripts/20_prod.sh"
 
   mobile:
     image: 192.168.10.61:5000/hksingleparty_mobile
@@ -22,8 +25,8 @@ services:
       - 10004:3000
     volumes:
       - ../mobile:/app
-    working_dir: '/app'
+    working_dir: "/app"
-    command: './dev.sh'
+    command: "./scripts/20_prod.sh"
 
   cms_backend:
     image: 192.168.10.61:5000/demo_minimal_kit_backend
@@ -36,8 +39,8 @@ services:
       - 10003:5555
     volumes:
       - ../cms_backend:/app
-    working_dir: '/app'
+    working_dir: "/app"
-    command: './dev.sh'
+    command: "./scripts/20_prod.sh"
 
   postgres:
     image: postgres:14.1-alpine
@@ -45,6 +48,6 @@ services:
     env_file:
       - .env
     expose:
-      - '5432'
+      - "5432"
     volumes:
       - db:/var/lib/postgresql/data

03_source/frontend/.gitignore

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

03_source/frontend/eslint.config.mjs

@@ -92,6 +92,8 @@ const sortImportsRules = () => {
   };
 
   return {
+    'perfectionist/sort-named-imports': [1, { type: 'line-length', order: 'asc' }],
+    'perfectionist/sort-named-exports': [1, { type: 'line-length', order: 'asc' }],
     'perfectionist/sort-exports': [
       1,
       {
@@ -100,8 +102,6 @@ const sortImportsRules = () => {
         groupKind: 'values-first',
       },
     ],
-    'perfectionist/sort-named-imports': [1, { type: 'line-length', order: 'asc' }],
-    'perfectionist/sort-named-exports': [1, { type: 'line-length', order: 'asc' }],
     'perfectionist/sort-imports': [
       2,
       {

03_source/frontend/package.json

@@ -21,8 +21,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:print": "npx tsc --showConfig",
+    "tsc:w": "npx nodemon --delay 3 --ext ts,tsx --exec \"yarn tsc\"",
     "tsc:watch": "tsc --noEmit --watch",
-    "tsc:print": "npx tsc --showConfig"
+    "tsc": "tsc --noEmit"
   },
   "engines": {
     "node": ">=20"
@@ -43,6 +45,7 @@
     "@fontsource-variable/noto-sans-sc": "^5.2.5",
     "@fontsource-variable/noto-sans-tc": "^5.2.5",
     "@fontsource-variable/nunito-sans": "^5.2.5",
+    "@fontsource-variable/public-sans": "^5.2.5",
     "@fontsource/barlow": "^5.2.5",
     "@fullcalendar/core": "^6.1.15",
     "@fullcalendar/daygrid": "^6.1.15",
@@ -52,7 +55,7 @@
     "@fullcalendar/timegrid": "^6.1.15",
     "@fullcalendar/timeline": "^6.1.15",
     "@hookform/resolvers": "^4.1.3",
-    "@ianvs/prettier-plugin-sort-imports": "^4.4.1",
+    "@ianvs/prettier-plugin-sort-imports": "^4.4.2",
     "@iconify/react": "^5.2.0",
     "@mui/lab": "^7.0.0-beta.10",
     "@mui/material": "^7.0.1",

03_source/frontend/prettier.config.mjs

@@ -12,7 +12,7 @@ const config = {
   trailingComma: 'es5',
   plugins: [
     //
-    // '@ianvs/prettier-plugin-sort-imports',
+    '@ianvs/prettier-plugin-sort-imports',
   ],
 };
 

03_source/frontend/scripts/00_dev.sh

@@ -2,8 +2,9 @@
 
 yarn --dev
 
-while true; do
+clear
 
+while true; do
   # yarn tsc:print
   yarn lint:print
 

03_source/frontend/scripts/10_build.sh

@@ -0,0 +1,15 @@
+#!/usr/bin/env bash
+
+set -x
+
+rm -rf ./**/*Zone.Identifier
+
+set -ex
+
+yarn fm:fix
+
+yarn tsc
+
+yarn build
+
+echo "done"

03_source/frontend/scripts/20_prod.sh

@@ -1,8 +1,9 @@
 #!/usr/bin/env bash
 
+yarn build
+
 while true; do
-  yarn --dev
+  yarn start
-  yarn dev
 
   echo "restarting..."
   sleep 1

03_source/frontend/src/_mock/_calendar.ts

@@ -1,4 +1,4 @@
-import { info, error, primary, success, warning, secondary } from 'src/theme/core';
+import { error, info, primary, secondary, success, warning } from 'src/theme/core';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/_mock/_files.ts

@@ -1,5 +1,5 @@
 import { _mock } from './_mock';
-import { _tags, _fileNames } from './assets';
+import { _fileNames, _tags } from './assets';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/_mock/_invoice.ts

@@ -1,8 +1,7 @@
-import { fSub, fAdd } from 'src/utils/format-time';
+import { fAdd, fSub } from 'src/utils/format-time';
-
 import { _mock } from './_mock';
-import { _tags } from './assets';
 import { _addressBooks } from './_others';
+import { _tags } from './assets';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/_mock/_mock.ts

@@ -1,36 +1,34 @@
-import { fSub } from 'src/utils/format-time';
-
 import { CONFIG } from 'src/global-config';
-
+import { fSub } from 'src/utils/format-time';
 import {
-  _id,
   _ages,
-  _roles,
-  _prices,
-  _emails,
-  _ratings,
-  _nativeS,
-  _nativeM,
-  _nativeL,
-  _percents,
   _booleans,
-  _sentences,
-  _lastNames,
-  _fullNames,
-  _tourNames,
-  _jobTitles,
-  _taskNames,
-  _fileNames,
-  _postTitles,
-  _firstNames,
-  _eventNames,
-  _courseNames,
-  _fullAddress,
   _companyNames,
-  _productNames,
-  _descriptions,
-  _phoneNumbers,
   _countryNames,
+  _courseNames,
+  _descriptions,
+  _emails,
+  _eventNames,
+  _fileNames,
+  _firstNames,
+  _fullAddress,
+  _fullNames,
+  _id,
+  _jobTitles,
+  _lastNames,
+  _nativeL,
+  _nativeM,
+  _nativeS,
+  _percents,
+  _phoneNumbers,
+  _postTitles,
+  _prices,
+  _productNames,
+  _ratings,
+  _roles,
+  _sentences,
+  _taskNames,
+  _tourNames,
 } from './assets';
 
 // ----------------------------------------------------------------------

03_source/frontend/src/_mock/_overview.ts

@@ -1,7 +1,5 @@
-import { today } from 'src/utils/format-time';
-
 import { CONFIG } from 'src/global-config';
-
+import { today } from 'src/utils/format-time';
 import { _mock } from './_mock';
 
 // APP

03_source/frontend/src/actions/blog.ts

@@ -1,10 +1,8 @@
-import type { SWRConfiguration } from 'swr';
-import type { IPostItem } from 'src/types/blog';
-
-import useSWR from 'swr';
 import { useMemo } from 'react';
-
+import { endpoints, fetcher } from 'src/lib/axios';
-import { fetcher, endpoints } from 'src/lib/axios';
+import type { IPostItem } from 'src/types/blog';
+import type { SWRConfiguration } from 'swr';
+import useSWR from 'swr';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/actions/calendar.ts

@@ -1,11 +1,9 @@
-import type { SWRConfiguration } from 'swr';
-import type { ICalendarEvent } from 'src/types/calendar';
-
 import { useMemo } from 'react';
+import axios, { endpoints, fetcher } from 'src/lib/axios';
+import type { ICalendarEvent } from 'src/types/calendar';
+import type { SWRConfiguration } from 'swr';
 import useSWR, { mutate } from 'swr';
 
-import axios, { fetcher, endpoints } from 'src/lib/axios';
-
 // ----------------------------------------------------------------------
 
 const enableServer = false;

03_source/frontend/src/actions/chat.ts

@@ -1,12 +1,10 @@
-import type { SWRConfiguration } from 'swr';
-import type { IChatMessage, IChatParticipant, IChatConversation } from 'src/types/chat';
-
-import { useMemo } from 'react';
 import { keyBy } from 'es-toolkit';
+import { useMemo } from 'react';
+import axios, { endpoints, fetcher } from 'src/lib/axios';
+import type { IChatConversation, IChatMessage, IChatParticipant } from 'src/types/chat';
+import type { SWRConfiguration } from 'swr';
 import useSWR, { mutate } from 'swr';
 
-import axios, { fetcher, endpoints } from 'src/lib/axios';
-
 // ----------------------------------------------------------------------
 
 const enableServer = false;

03_source/frontend/src/actions/kanban.ts

@@ -1,11 +1,9 @@
-import type { SWRConfiguration } from 'swr';
 import type { UniqueIdentifier } from '@dnd-kit/core';
-import type { IKanban, IKanbanTask, IKanbanColumn } from 'src/types/kanban';
+import { startTransition, useMemo } from 'react';
-
+import axios, { endpoints, fetcher } from 'src/lib/axios';
+import type { IKanban, IKanbanColumn, IKanbanTask } from 'src/types/kanban';
+import type { SWRConfiguration } from 'swr';
 import useSWR, { mutate } from 'swr';
-import { useMemo, startTransition } from 'react';
-
-import axios, { fetcher, endpoints } from 'src/lib/axios';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/actions/mail.ts

@@ -1,11 +1,9 @@
-import type { SWRConfiguration } from 'swr';
-import type { IMail, IMailLabel } from 'src/types/mail';
-
-import useSWR from 'swr';
-import { useMemo } from 'react';
 import { keyBy } from 'es-toolkit';
-
+import { useMemo } from 'react';
-import { fetcher, endpoints } from 'src/lib/axios';
+import { endpoints, fetcher } from 'src/lib/axios';
+import type { IMail, IMailLabel } from 'src/types/mail';
+import type { SWRConfiguration } from 'swr';
+import useSWR from 'swr';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/actions/order.ts

@@ -1,8 +1,8 @@
 // src/actions/order.ts
 import { useMemo } from 'react';
 import axiosInstance, { endpoints, fetcher } from 'src/lib/axios';
-import type { IProductItem } from 'src/types/product';
 import type { IOrderItem } from 'src/types/order';
+import type { IProductItem } from 'src/types/product';
 import type { SWRConfiguration } from 'swr';
 import useSWR from 'swr';
 

03_source/frontend/src/actions/product.ts

@@ -1,9 +1,10 @@
 // src/actions/product.ts
+//
 import { useMemo } from 'react';
 import axiosInstance, { endpoints, fetcher } from 'src/lib/axios';
 import type { IProductItem } from 'src/types/product';
 import type { SWRConfiguration } from 'swr';
-import useSWR from 'swr';
+import useSWR, { mutate } from 'swr';
 
 // ----------------------------------------------------------------------
 
@@ -22,11 +23,7 @@ type ProductsData = {
 export function useGetProducts() {
   const url = endpoints.product.list;
 
-  const { data, isLoading, error, isValidating, mutate } = useSWR<ProductsData>(
+  const { data, isLoading, error, isValidating } = useSWR<ProductsData>(url, fetcher, swrOptions);
-    url,
-    fetcher,
-    swrOptions
-  );
 
   const memoizedValue = useMemo(
     () => ({
@@ -35,9 +32,8 @@ export function useGetProducts() {
       productsError: error,
       productsValidating: isValidating,
       productsEmpty: !isLoading && !isValidating && !data?.products.length,
-      mutate,
     }),
-    [data?.products, error, isLoading, isValidating, mutate]
+    [data?.products, error, isLoading, isValidating]
   );
 
   return memoizedValue;
@@ -56,10 +52,11 @@ export function useGetProduct(productId: string) {
 
   const memoizedValue = useMemo(
     () => ({
-      currentProduct: data?.product,
+      product: data?.product,
       productLoading: isLoading,
       productError: error,
       productValidating: isValidating,
+      mutate,
     }),
     [data?.product, error, isLoading, isValidating]
   );
@@ -97,140 +94,82 @@ export function useSearchProducts(query: string) {
 
 // ----------------------------------------------------------------------
 
-type SaveProductData = {
+export async function createProduct(productData: IProductItem) {
-  // id: string;
+  /**
+   * Work on server
+   */
+  const data = { productData };
+  const {
+    data: { id },
+  } = await axiosInstance.post(endpoints.product.create, data);
 
-  sku: string;
+  /**
-  name: string;
+   * Work in local
-  code: string;
+   */
-  price: number | null;
+  mutate(
-  taxes: number | null;
+    endpoints.product.list,
-  tags: string[];
+    (currentData: any) => {
-  sizes: string[];
+      const currentProducts: IProductItem[] = currentData?.products;
-  // publish: string;
-  gender: string[];
-  // coverUrl: string;
-  images: (string | File)[];
-  colors: string[];
-  quantity: number | null;
-  category: string;
-  // available: number;
-  // totalSold: number;
-  description: string;
-  // totalRatings: number;
-  // totalReviews: number;
-  // inventoryType: string;
-  subDescription: string;
-  priceSale: number | null;
-  newLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  saleLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  // ratings: {
-  //   name: string;
-  //   starCount: number;
-  //   reviewCount: number;
-  // }[];
-};
 
-export async function saveProduct(productId: string, saveProductData: SaveProductData) {
+      const products = [...currentProducts, { ...productData, id }];
-  console.log('save product ?');
-  // const url = productId ? [endpoints.product.details, { params: { productId } }] : '';
 
-  const res = await axiosInstance.post('http://localhost:7272/api/product/saveProduct', {
+      return { ...currentData, products };
-    data: saveProductData,
+    },
-  });
+    false
-
+  );
-  return res;
-}
-
-export async function uploadProductImage(saveProductData: SaveProductData) {
-  console.log('save product ?');
-  // const url = productId ? [endpoints.product.details, { params: { productId } }] : '';
-
-  const res = await axiosInstance.get('http://localhost:7272/api/product/helloworld');
-
-  return res;
 }
 
 // ----------------------------------------------------------------------
 
-type CreateProductData = {
+export async function updateProduct(productData: Partial<IProductItem>) {
-  // id: string;
+  /**
-  sku: string;
+   * Work on server
-  name: string;
+   */
-  code: string;
+  const data = { productData };
-  price: number | null;
+  await axiosInstance.put(endpoints.product.update, data);
-  taxes: number | null;
-  tags: string[];
-  sizes: string[];
-  publish: string;
-  gender: string[];
-  coverUrl: string;
-  images: (string | File)[];
-  colors: string[];
-  quantity: number | null;
-  category: string;
-  available: number;
-  totalSold: number;
-  description: string;
-  totalRatings: number;
-  totalReviews: number;
-  inventoryType: string;
-  subDescription: string;
-  priceSale: number | null;
-  newLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  saleLabel: {
-    content: string;
-    enabled: boolean;
-  };
-  // ratings: {
-  //   name: string;
-  //   starCount: number;
-  //   reviewCount: number;
-  // }[];
-};
 
-export async function createProduct(createProductData: CreateProductData) {
+  /**
-  console.log('create product ?');
+   * Work in local
-  // const url = productId ? [endpoints.product.details, { params: { productId } }] : '';
+   */
 
-  const res = await axiosInstance.post('http://localhost:7272/api/product/createProduct', {
+  mutate(
-    data: createProductData,
+    endpoints.product.list,
-  });
+    (currentData: any) => {
+      const currentProducts: IProductItem[] = currentData?.products;
 
-  return res;
+      const products = currentProducts.map((product) =>
+        product.id === productData.id ? { ...product, ...productData } : product
+      );
+
+      return { ...currentData, products };
+    },
+    false
+  );
 }
 
 // ----------------------------------------------------------------------
 
-type DeleteProductResponse = {
+export async function deleteProduct(productId: string) {
-  success: boolean;
+  /**
-  message?: string;
+   * Work on server
-};
+   */
+  const data = { productId };
+  await axiosInstance.patch(endpoints.product.delete, data);
 
-export async function deleteProduct(productId: string): Promise<DeleteProductResponse> {
+  /**
-  const url = `http://localhost:7272/api/product/deleteProduct?productId=${productId}`;
+   * Work in local
+   */
 
-  try {
+  mutate(
-    const res = await axiosInstance.delete(url);
+    endpoints.product.list,
-    console.log({ res });
+    (currentData: any) => {
+      console.log({ currentData });
+      const currentProducts: IProductItem[] = currentData?.products;
 
-    return {
+      const products = currentProducts.filter((product) => product.id !== productId);
-      success: true,
+
-      message: 'Product deleted successfully',
+      return { ...currentData, products };
-    };
+    },
-  } catch (error) {
+    false
-    return {
+  );
-      success: false,
-      message: error instanceof Error ? error.message : 'Failed to delete product',
-    };
-  }
 }

03_source/frontend/src/assets/icons/email-inbox-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/new-password-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/password-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/plan-free-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/plan-premium-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/plan-starter-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/icons/sent-icon.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------
 

03_source/frontend/src/assets/illustrations/avatar-shape.tsx

@@ -1,8 +1,6 @@
 import type { SvgIconProps } from '@mui/material/SvgIcon';
-
-import { memo } from 'react';
-
 import SvgIcon from '@mui/material/SvgIcon';
+import { memo } from 'react';
 
 // ----------------------------------------------------------------------