pears.SoftWizardController

CREATE FUNCTION "pears"."SoftWizardController"( 
  IN "pWizardID" CHAR(20),IN "pPageID" CHAR(50),IN "pItem" CHAR(20) ) 
RETURNS CHAR(250)
deterministic
BEGIN
  DECLARE "rv" CHAR(250);
  CASE "pWizardID"
  WHEN 'DEFAULT' THEN
    CASE "pItem"
    WHEN 'nextPageID' THEN
      CASE "pPageID"
      WHEN NULL THEN
        SET "rv" = 'pageText_registration_tos'
      WHEN 'pageText_registration_tos' THEN
        SET "rv" = 'EmailCheck'
      WHEN 'EmailCheck' THEN
        SET "rv" = 'Details'
      WHEN 'Details' THEN
        SET "rv" = ':Division'
      WHEN 'Division' THEN
        SET "rv" = ':Department'
      WHEN 'Department' THEN
        SET "rv" = ':Terms'
      WHEN 'Terms' THEN
        SET "rv" = ':BANKDETAILS'
      WHEN 'BANKDETAILS' THEN
        SET "rv" = 'Quest_P'
      WHEN 'Quest_P' THEN
        SET "rv" = ':Quest_A$'
      WHEN 'Quest_A$' THEN
        SET "rv" = ':VIDEO'
      WHEN 'VIDEO' THEN
        SET "rv" = ':REFERENCES'
      WHEN 'REFERENCES' THEN
        SET "rv" = ':CVANDPHOTO'
      WHEN 'CVANDPHOTO' THEN
        SET "rv" = ':DOCUMENTS'
      WHEN 'DOCUMENTS' THEN
        SET "rv" = ':pageText_registration_complete:'
      END CASE
    WHEN 'pageCaption' THEN
      CASE "pPageID"
      WHEN 'pageText_registration_tos' THEN
        SET "rv" = 'Please read carefully...'
      WHEN 'EmailCheck' THEN
        SET "rv" = 'Email check...'
      WHEN 'Details' THEN
        SET "rv" = 'Please enter your details...'
      WHEN 'Quest_A$' THEN
        SET "rv" = 'Please supply the following information'
      WHEN 'Quest_P' THEN
        SET "rv" = 'Please supply the following information'
      END CASE
    WHEN 'pageFooter' THEN
      CASE "pPageID"
      WHEN 'pageText_registration_tos' THEN
        SET "rv" = '!I accept the terms and conditions'
      END CASE
    WHEN 'pageNumber' THEN
      CASE "pPageID"
      WHEN 'pageText_registration_tos' THEN
        SET "rv" = 0 /* Don't display progress yet */
      WHEN 'EmailCheck' THEN
        SET "rv" = 1
      WHEN 'Details' THEN
        SET "rv" = 2
      WHEN 'Division' THEN
        SET "rv" = 3
      WHEN 'Department' THEN
        SET "rv" = 4
      WHEN 'Terms' THEN
        SET "rv" = 5
      WHEN 'BANKDETAILS' THEN
        SET "rv" = 6
      WHEN 'Quest_P' THEN
        SET "rv" = 7
      WHEN 'Quest_A$' THEN
        SET "rv" = 8
      WHEN 'VIDEO' THEN
        SET "rv" = 9
      WHEN 'REFERENCES' THEN
        SET "rv" = 10
      WHEN 'CVandPHOTO' THEN
        SET "rv" = 11
      WHEN 'DOCUMENTS' THEN
        SET "rv" = 12
      WHEN 'pageText_registration_complete' THEN
        SET "rv" = 13
      END CASE
    WHEN 'totalPageCount' THEN
      SET "rv" = 13
    END CASE
  END CASE;
  RETURN "rv"
END