LoyaltyProgram

# Skeleton created by `sysforge import-excel` (SPEC §13) for SYS-045.
# Core modules: • โมดูลสมาชิก/สะสมแต้ม • โมดูลข้อมูลหลัก (Master Data) • โมดูล Workflow/อนุมัติ
# TODO(sysforge): replace the default fields below with the real fields of each entity.
#                 Every field shown in a form needs a default or a placeholder (R-UI-1). Then run: sysforge validate

system:
  code: SYS-045
  name: LoyaltyProgram
  title: { th: "ระบบสมาชิกและแต้ม", en: "Loyalty program" }
  description: { th: "ระบบสมาชิกและแต้ม" }
  domain: Enterprise & Business
  package: com.sysforge.loyaltyprogram
  version: 1.0.0
  locale: { default: th }
  timezone: Asia/Bangkok

database:
  targets: [sqlserver, oracle, mysql, postgresql]
  default: postgresql
  tablePrefix: lo_

theme: {}

roles:
  - code: ADMIN
    title: { th: ผู้ดูแลระบบ, en: Administrator }
    permissions: ["*"]
  - code: STAFF
    title: { th: เจ้าหน้าที่, en: Staff }
    permissions:
      - "Member:create"
      - "Member:read"
      - "Member:update"
      - "Member:export"
      - "Tier:create"
      - "Tier:read"
      - "Tier:update"
      - "Tier:export"
      - "PointTxn:create"
      - "PointTxn:read"
      - "PointTxn:update"
      - "PointTxn:export"
      - "Reward:create"
      - "Reward:read"
      - "Reward:update"
      - "Reward:export"
      - "Coupon:create"
      - "Coupon:read"
      - "Coupon:update"
      - "Coupon:export"
      - "WorkflowDefinition:create"
      - "WorkflowDefinition:read"
      - "WorkflowDefinition:update"
      - "WorkflowDefinition:export"
      - "WorkflowInstance:create"
      - "WorkflowInstance:read"
      - "WorkflowInstance:update"
      - "WorkflowInstance:export"
      - "ApprovalStep:create"
      - "ApprovalStep:read"
      - "ApprovalStep:update"
      - "ApprovalStep:export"
      - "Delegation:create"
      - "Delegation:read"
      - "Delegation:update"
      - "Delegation:export"

enums:
  - name: MemberStage
    values:
      - { code: NEW,         th: ใหม่,         en: New,         color: info }
      - { code: IN_PROGRESS, th: กำลังดำเนินการ, en: In progress, color: warning }
      - { code: DONE,        th: เสร็จสิ้น,      en: Done,        color: success }

entities:
  - name: Member
    title: { th: "Member", en: "Member" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น ME-0001", en: "e.g. ME-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น Member", en: "e.g. Member name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
      - { name: stage, type: enum, enum: MemberStage, required: true, default: NEW, searchable: true, label: { th: ขั้นตอน, en: Stage } }
    # TODO(sysforge): ระบุ field เฉพาะของ Member
  - name: Tier
    title: { th: "Tier", en: "Tier" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น TI-0001", en: "e.g. TI-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น Tier", en: "e.g. Tier name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ Tier
  - name: PointTxn
    title: { th: "Point txn", en: "Point txn" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น PT-0001", en: "e.g. PT-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น PointTxn", en: "e.g. Point txn name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ PointTxn
  - name: Reward
    title: { th: "Reward", en: "Reward" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น RE-0001", en: "e.g. RE-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น Reward", en: "e.g. Reward name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ Reward
  - name: Coupon
    title: { th: "Coupon", en: "Coupon" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น CO-0001", en: "e.g. CO-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น Coupon", en: "e.g. Coupon name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ Coupon
  - name: WorkflowDefinition
    title: { th: "Workflow definition", en: "Workflow definition" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น WD-0001", en: "e.g. WD-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น WorkflowDefinition", en: "e.g. Workflow definition name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ WorkflowDefinition
  - name: WorkflowInstance
    title: { th: "Workflow instance", en: "Workflow instance" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น WI-0001", en: "e.g. WI-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น WorkflowInstance", en: "e.g. Workflow instance name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ WorkflowInstance
  - name: ApprovalStep
    title: { th: "Approval step", en: "Approval step" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น AS-0001", en: "e.g. AS-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น ApprovalStep", en: "e.g. Approval step name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ ApprovalStep
  - name: Delegation
    title: { th: "Delegation", en: "Delegation" }
    display: name
    fields:
      - { name: code, type: string, length: 30, required: true, unique: true, searchable: true, label: { th: รหัส, en: Code }, placeholder: { th: "เช่น DE-0001", en: "e.g. DE-0001" } }
      - { name: name, type: string, length: 200, required: true, searchable: true, label: { th: ชื่อ, en: Name }, placeholder: { th: "เช่น Delegation", en: "e.g. Delegation name" } }
      - { name: description, type: text, label: { th: รายละเอียด, en: Description }, placeholder: { th: "รายละเอียดเพิ่มเติม", en: "Additional details" } }
      - { name: active, type: boolean, default: true, searchable: true, label: { th: ใช้งาน, en: Active } }
    # TODO(sysforge): ระบุ field เฉพาะของ Delegation

screens:
  - { id: home, type: kpi-dashboard, title: { th: ภาพรวม, en: Overview } }
  - { id: members, type: crud, entity: Member, title: { th: "Member", en: "Member" }, defaultSort: { field: code, dir: asc } }
  - { id: tiers, type: crud, entity: Tier, title: { th: "Tier", en: "Tier" }, defaultSort: { field: code, dir: asc } }
  - { id: point-txns, type: crud, entity: PointTxn, title: { th: "Point txn", en: "Point txn" }, defaultSort: { field: code, dir: asc } }
  - { id: rewards, type: crud, entity: Reward, title: { th: "Reward", en: "Reward" }, defaultSort: { field: code, dir: asc } }
  - { id: coupons, type: crud, entity: Coupon, title: { th: "Coupon", en: "Coupon" }, defaultSort: { field: code, dir: asc } }
  - { id: workflow-definitions, type: crud, entity: WorkflowDefinition, title: { th: "Workflow definition", en: "Workflow definition" }, defaultSort: { field: code, dir: asc } }
  - { id: workflow-instances, type: crud, entity: WorkflowInstance, title: { th: "Workflow instance", en: "Workflow instance" }, defaultSort: { field: code, dir: asc } }
  - { id: approval-steps, type: crud, entity: ApprovalStep, title: { th: "Approval step", en: "Approval step" }, defaultSort: { field: code, dir: asc } }
  - { id: delegations, type: crud, entity: Delegation, title: { th: "Delegation", en: "Delegation" }, defaultSort: { field: code, dir: asc } }
  - { id: members-board, type: kanban, entity: Member, title: { th: "บอร์ดMember", en: "Member board" }, options: { statusField: stage, cardTitle: name, cardSubtitle: code, allowDrag: true } }