Process Flow Integration

export interface FormDTO {
  processId: string;
  step: number;
  processState: ProcessInstanceDTO.StatusEnum;
  question?: string;
  questionType?: string;
  required?: boolean;
  options?: string[];
  people?: Set<FormPersonDTO>;
  paymentUrl?: string;
}

export interface FormPersonDTO {
  id?: number;
  firstName?: string;
  lastName?: string;
  dateOfBirth?: string;
  answer?: string;
  hide?: boolean;
  selected?: boolean;
  canSelect?: boolean;
  status?: string;
  paymentUrl?: string;
}

export enum ProcessState {
  NONE = 'NONE',           // No process started
  RUNNING = 'RUNNING',     // Process executing
  RESUME = 'RESUME',       // Resuming from suspended
  SUSPENDED = 'SUSPENDED', // Paused (browser closed)
  DONE = 'DONE',          // Questions complete
  PENDING_PAYMENT = 'PENDING_PAYMENT',
  COMPLETED = 'COMPLETED', // Fully complete
  CANCELLED = 'CANCELLED', // User cancelled
  FAILED = 'FAILED'        // Error occurred
}

this.formService.getFormMembership(this.membershipPeriodId, this.userKey)
  .subscribe(formState => {
    this.formDTO = formState;
    this.linkedPersons = Array.from(formState.people || []);
    this.processId = formState.processId;

    if (formState.processState === ProcessInstanceDTO.StatusEnum.Running ||
        formState.processState === ProcessInstanceDTO.StatusEnum.Resume) {
      this.showProcessDialog(); // Ask to resume or start fresh
    }
  });

{
  "processId": "proc-12345",
  "step": 0,
  "processState": "NONE",
  "people": [
    {
      "id": 1,
      "firstName": "John",
      "lastName": "Smith",
      "selected": false,
      "canSelect": true,
      "status": "Available"
    },
    {
      "id": 3,
      "firstName": "Billy",
      "lastName": "Smith",
      "selected": false,
      "canSelect": true,
      "status": "Available"
    }
  ]
}

this.formService.next({
  processId: this.processId,
  step: this.formDTO.step,
  people: [
    { id: 1 },
    { id: 3 }
  ]
}).subscribe(response => {
  this.formDTO = response;
  this.showQuestionBox = true;
});

{
  "processId": "proc-12345",
  "step": 0,
  "people": [
    { "id": 1 },
    { "id": 3 }
  ]
}

{
  "processId": "proc-12345",
  "step": 1,
  "processState": "RUNNING",
  "question": "Does anyone have any medical conditions?",
  "questionType": "BCB",
  "required": true,
  "people": [
    {
      "id": 1,
      "firstName": "John",
      "lastName": "Smith",
      "answer": null,
      "hide": false
    },
    {
      "id": 3,
      "firstName": "Billy",
      "lastName": "Smith",
      "answer": null,
      "hide": false
    }
  ]
}

// Question 1: Medical conditions
next({
  processId: "proc-12345",
  step: 1,
  people: [
    { id: 1, answer: "0" },  // John: No
    { id: 3, answer: "1" }   // Billy: Yes
  ]
})

// Question 2: Emergency contact (shown because step 1 answered)
next({
  processId: "proc-12345",
  step: 2,
  people: [
    { id: 1, answer: "0821234567" },
    { id: 3, answer: "0821234567" }
  ]
})

// Question 3: Terms and conditions
next({
  processId: "proc-12345",
  step: 3,
  people: [
    { id: 1, answer: "1" },  // Accepted
    { id: 3, answer: "1" }   // Accepted
  ]
})

{
  "processId": "proc-12345",
  "step": 3,
  "processState": "DONE",
  "people": [
    {
      "id": 1,
      "firstName": "John",
      "lastName": "Smith",
      "status": "Pending Payment",
      "paymentUrl": null
    },
    {
      "id": 3,
      "firstName": "Billy",
      "lastName": "Smith",
      "status": "Pending Payment",
      "paymentUrl": null
    }
  ],
  "paymentUrl": "https://payment.gateway.com/pay?reference=ORD-892&amount=800.00"
}

if (this.questionData.paymentUrl) {
  this.messageService.add({
    severity: 'info',
    summary: 'Payment Portal',
    detail: 'Redirecting to payment portal...',
    life: 5000
  });

  setTimeout(() => {
    window.location.href = this.questionData.paymentUrl;
  }, 5000);
}

this.formService.reset(this.formDTO.processId)
  .subscribe(_formDTO => {
    if (_formDTO.processState === ProcessInstanceDTO.StatusEnum.Running) {
      this.updateFormWithData(_formDTO);
    }
  });

this.formService.resume(this.formDTO.processId)
  .subscribe(_formDTO => {
    if (_formDTO.processState === ProcessInstanceDTO.StatusEnum.Running) {
      this.updateFormWithData(_formDTO);
      this.showQuestionBox = true; // Jump to questions
    }
  });

INSERT INTO process_data (instance_id, step_id, person_id, data_key, data_value)
VALUES
  (12345, 1, 1, 'answer', '0'),
  (12345, 1, 3, 'answer', '1');

INSERT INTO process_data (instance_id, step_id, person_id, data_key, data_value)
VALUES
  (12345, 2, 1, 'answer', '0821234567'),
  (12345, 2, 3, 'answer', '0821234567');

SELECT
  ps.name AS step_name,
  ps.question_text,
  p.first_name || ' ' || p.last_name AS person_name,
  pd.data_value AS answer
FROM process_data pd
JOIN process_step ps ON pd.step_id = ps.id
JOIN person p ON pd.person_id = p.id
WHERE pd.instance_id = 12345
ORDER BY ps.order_index, p.id;

step_name              | question_text                        | person_name  | answer
-----------------------|--------------------------------------|--------------|------------
Medical Condition      | Does anyone have medical conditions? | John Smith   | 0
Medical Condition      | Does anyone have medical conditions? | Billy Smith  | 1
Emergency Contact      | Emergency contact number?            | John Smith   | 0821234567
Emergency Contact      | Emergency contact number?            | Billy Smith  | 0821234567

{
  "id": 42,
  "name": "Standard Membership Application",
  "category": "MEMBERSHIP",
  "version": 1,
  "active": true,
  "organisationId": 8
}

[
  {
    "id": 1,
    "definitionId": 42,
    "orderIndex": 1,
    "name": "Medical Conditions",
    "questionText": "Does anyone have any medical conditions?",
    "questionType": "BCB",
    "required": false
  },
  {
    "id": 2,
    "definitionId": 42,
    "orderIndex": 2,
    "name": "Emergency Contact",
    "questionText": "What is your emergency contact number?",
    "questionType": "TXT",
    "required": true
  },
  {
    "id": 3,
    "definitionId": 42,
    "orderIndex": 3,
    "name": "Primary Contact",
    "questionText": "Who will be the primary contact person?",
    "questionType": "ONE",
    "required": true
  },
  {
    "id": 4,
    "definitionId": 42,
    "orderIndex": 4,
    "name": "Terms and Conditions",
    "questionText": "I accept the terms and conditions of membership",
    "questionType": "ITC",
    "required": true
  }
]

Step 1: "Does anyone have medical conditions?"
  Answer = "0" (No) → Skip to Step 3
  Answer = "1" (Yes) → Continue to Step 2

Step 2: "Please describe medical conditions"
  Type: TXT
  Required: true

Step 3: "Emergency contact number"
  ...

@Injectable({ providedIn: 'root' })
export class FormService {
  /**
   * Get initial form state for membership
   */
  getFormMembership(membershipPeriodId: number, userKey: string):
    Observable<FormDTO>

  /**
   * Submit current step and get next
   */
  next(data: { processId: string, step: number, people: any[] }):
    Observable<FormDTO>

  /**
   * Reset process to beginning
   */
  reset(processId: string): Observable<FormDTO>

  /**
   * Resume suspended process
   */
  resume(processId: string): Observable<FormDTO>
}

{
  "timestamp": "2024-01-31T10:15:30Z",
  "status": 422,
  "error": "Unprocessable Entity",
  "message": "Validation failed for question answers",
  "path": "/api/forms/next",
  "errors": [
    {
      "field": "people[0].answer",
      "message": "Emergency contact number is required"
    },
    {
      "field": "people[1].answer",
      "message": "Phone number must be 10 digits"
    }
  ]
}

{
  "processId": "proc-12345",
  "step": 2,
  "processState": "ERROR",
  "message": "Invalid answer format for emergency contact",
  "errors": {
    "people": [
      {
        "id": 1,
        "error": "Phone number must be 10 digits"
      }
    ]
  }
}

-- Load current step with answer data
SELECT ps.*, pd.data_value
FROM process_step ps
LEFT JOIN process_data pd ON ps.id = pd.step_id
  AND pd.instance_id = ?
WHERE ps.id = (
  SELECT current_step_id FROM process_instance WHERE id = ?
);