1.1 다중 자동 발송 (지능형 메시지 전송)

1.1.1 지능형 메시지

• Push → 알림톡 → 문자

  INSERT INTO ag_tran_cont (file_cnt, subject, kao_sender_key, kao_template_code, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('0', '[메시지제목]', '[발신프로필키]', '[템플릿코드]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_type3, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '1', now(), '[동적메시지값]', '0', '0', '03', '04', '01', [CONT_SEQ], '[문자종류코드]');
  

1.1.2 첨부파일

• Push → 알림톡 → 문자

  INSERT INTO ag_tran_cont (file_cnt, subject, file_name1, kao_sender_key, kao_template_code, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('1', '[메시지제목]', '/home/enigma/enigma_agent/test.jpg', '[발신프로필키]', '[템플릿코드]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_type3, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '1', now(), '[동적메시지값]', '0', '0', '03', '04', '01', [CONT_SEQ], '[문자종류코드]');
  

1.2 다중선택발송

1.2.1 정적메시지

• Push → 문자

  INSERT INTO ag_tran_cont (file_cnt, subject, body)
  VALUES ('0', '[템플릿코드]','[메시지내용]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '0', '0', '03', '01', [CONT_SEQ], '[문자종류코드]');
  

1.2.2 동적메시지

• Push → 알림톡

  INSERT INTO ag_tran_cont (file_cnt, subject, kao_sender_key, kao_template_code, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('0', '[메시지제목]', '[발신프로필키]', '[템플릿코드]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '[동적메시지값]', '0', '0', '03', '04', [CONT_SEQ], '[문자종류코드]');
  

• Push → 문자

  INSERT INTO ag_tran_cont (file_cnt, subject, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('0', '[메시지제목]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '[동적메시지값]', '0', '0', '03', '01', [CONT_SEQ], '[문자종류코드]');
  

• 알림톡 → Push

  INSERT INTO ag_tran_cont (file_cnt, subject, kao_sender_key, kao_template_code, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('0', '[메시지제목]', '[발신프로필키]', '[템플릿코드]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '[동적메시지값]', '0', '0', '04', '03', [CONT_SEQ], '[문자종류코드]');
  

• 알림톡 → 문자

  INSERT INTO ag_tran_cont (file_cnt, subject, kao_sender_key, kao_template_code, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('0', '[메시지제목]', '[발신프로필키]', '[템플릿코드]', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '[동적메시지값]', '0', '0', '04', '01', [CONT_SEQ], '[문자종류코드]');
  

1.2.3 첨부파일

• 정적메시지(Push → 문자)

  INSERT INTO ag_tran_cont (file_cnt, subject, body, file_name1)
  VALUES ('1', '[메시지제목]','[메시지내용]', '/home/enigma/enigma_agent/test.jpg');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '0', '0', '03', '01', [CONT_SEQ], '[문자종류코드]');
  

• 동적메시지(Push → 문자)

  INSERT INTO ag_tran_cont ( file_cnt, subject, file_name1, dynamic_msg_nm, dynamic_msg_cont_fmt)
  VALUES ('1', '[메시지제목]', '/home/enigma/enigma_agent/test.jpg', '[동적메시지명]', '[동적메시지포맷]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, dynamic_msg_val, send_type_cd, tran_status, tran_type1, tran_type2, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '2', now(), '[동적메시지값]', '0', '0', '03', '01' [CONT_SEQ], '[문자종류코드]');
  

1.3 단일 선택발송

1.3.1 정적메시지

• Push

  INSERT INTO ag_tran_cont (file_cnt, subject, body)
  VALUES ('0', '[메시지제목]','[메시지내용]');
  
  INSERT INTO ag_tran (tran_phone, tran_callback, tran_grp_nm, tran_way, tran_date, send_type_cd, tran_status, tran_type1, tran_etc4, send_msg_type_cd)
  VALUES ('[수신번호]', '[발신번호]', '[메시지그룹명]', '3', now(), '0', '0', '03', [CONT_SEQ], '[문자종류코드]');