# RCSSMS 기본형 + BUTTONS 1개

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     AGENCY_ID,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘kakaoenterprise’,
      ‘01012345678’,
      ‘1544-0000’,
      ‘SS000000’,                  # 메시지 템플릿 코드
      ‘RCSSMS’,                       # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                    # 0 : 정보성, 1 : 광고성
      ‘080-0000-0000’,        # 광고성인 경우 필수 입력
      true,
      ‘{ "title": "","description":"일반 RCSSMS 메시지입니다.\\n" }’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# RCSLMS 기본형 + BUTTONS 1개

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     AGENCY_ID,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘kakaoenterprise’,
      ‘01012345678’,
      ‘1544-0000’,
      ‘SL000000’,                  # 메시지 템플릿 코드
      ‘RCSLMS’,                       # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                    # 0 : 정보성, 1 : 광고성
      ‘080-0000-0000’,        # 광고성인 경우 필수 입력
      true,
      ‘{"title": "RCSLMS 타이틀","description":"일반 RCSLMS  메시지입니다." }’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# RCSMMS 기본형 + 첨부 파일 1개 + BUTTONS 1개

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/test.jpg’,
    ‘image/jpg’,
    ‘ 이미지 업로드’
);

INSERT INTO RCS_MESSAGE (
     MSG_SEQNO,
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     MMS_TITLE1,
     MMS_MSG1,
     MMG_IMG_URL1
     BUTTONS
) VALUES (
      ‘2022010100001’,
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SM000000’,                     # 메시지 템플릿 코드
      ‘RCSMMS’,                           # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                       # 0 : 정보성, 1 : 광고성
      ‘080-0000-0000’,           # 광고성인 경우 필수 입력
      true,
      ‘20220608000001’,
      ‘1’,
      ‘MMS 타이틀’,
      ‘일반 RCSMMS  메시지입니다.’,
      ‘maapfile://testImgUrl’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }
        ]’
);

# 캐로셀은 5장까지 가능하며, 캐로셀 당 버튼은 2개까지 삽입 가능

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_001.jpg’,
    ‘image/jpg’,
    ‘ 이미지 업로드1’
);

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_002.jpg’,
    ‘image/jpg’,
    ‘ 이미지 업로드2’
);

INSERT INTO RCS_MESSAGE_CONTENTS(
     REG_DATE,
     IMG_FILE_PATH,
     IMG_MIME_TYPE,
     IMG_DESCRIPTION
) VALUES (
    now(),
    ‘/files/caousel_003.jpg’,
    ‘image/jpg’,
    ‘ 이미지 업로드3’
);

INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     IMG_GROUP_CODE,
     IMG_CNT,
     MMS_TITLE1,
     MMS_MSG1,
     MMG_IMG_URL1,
     MMS_TITLE2,
     MMS_MSG2,
     MMG_IMG_URL2,
     MMS_TITLE3,
     MMS_MSG3,
     MMG_IMG_URL3,
     BUTTONS
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SMwMgM0300’,                   # 메시지 템플릿 코드
      ‘RCSMMS’                              # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                          # 0 : 정보성, 1 : 광고성
      ‘080-0000-0000’,              # 광고성인 경우 필수 입력
      true,
      ‘20220608000001’,
      ‘1’,
      ‘MMS 타이틀1’,
      ‘첫번째 Carousel 메시지’’,
      ‘maapfile://testImgUrl_001’,
      ‘MMS 타이틀2’,
      ‘두번째 Carousel 메시지’’,
      ‘maapfile://testImgUrl_002’,
      ‘MMS 타이틀3’,
      ‘세번째 Carousel 메시지’’,
      ‘maapfile://testImgUrl_003’,
      ‘[
            {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            },    #첫번째 Crousel 의 버튼 (1개)
           {},   #두번째 Crousel 의 버튼 (0개)
           {
                "suggestions":[{
                    "action":{
                        "urlAction": {
                            "openUrl": {
                                "url": "https://www.google.com"
                            }
                        },
                        "displayText": "Open Url",
                        "postback": {
                                "data": "set_by_open_url"
                        }
                    }
                }]
            }    #세번째 Crousel 의 버튼 (1개)
        ]’
);

# RCSTMPL
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     BODY
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘RCS_TMPL001’,            # 메시지 템플릿 코드
      ‘RCSTMPL’,                       # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      true,
      ‘{"description":"안녕하세요? 홍길동님으로부터 1,000 원이 입금되었습니다."}’  #템플릿 가변부 입력
  );

# RCSTMPL
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     BODY
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘RCS_TMPL001’,           # 메시지 템플릿 코드
      ‘RCSTMPL’,                      # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      true,
      ‘{
         "변수명1”:”변수값”,
         “변수명2”:”변수값”
      }’
  );

– RCSSMS + 부달발송
INSERT INTO RCS_MESSAGE (
     RESERVE_DATE,
     PHONE_NO,
     CALLBACK,
     MESSAGE_BASE_ID,
     SERVICE_TYPE,
     HEADER,
     FOOTER,
     COPY_ALLOWED,
     BODY,
     FALLBACK_YN,
     FALLBACK_TYPE,
     FALLBACK_CALLBACK,
     FALLBACK_SUBJECT,
     FALLBACK_MESSAGE
) VALUES (
      now(),
      ‘01012345678’,
      ‘1544-0000’,
      ‘SS000000’,
      ‘RCSSMS’                            # [RCSSMS, RCSLMS, RCSMMS, RCSTMPL]
      ‘1’,                                        # 0 : 정보성, 1 : 광고성
      ‘080-0000-0000’,            # 광고성인 경우 필수 입력
      true,
      ‘{ "title": "","description":"일반 RCSSMS  메시지입니다." }’,
      true,
      ‘SM’,                       # [SM, LM]
     ‘1544-0000’,
     ‘’,
     ‘부달 발송 메시지.’
);