Links

CJ올리브네트웍스 연동

준비 및 설정

사전 준비 사항

핑거푸시 Agent와 CJAgent 연동 전에 각각 개별 에이전트가 정상 동작됨을 확인 후에 연동을 해야 합니다.

푸시 환경 설정 파일에서 CJAgent 연결 설정

  • 설치 경로/bin/ agentDistServerConfig.xml 파일 내의 config.database값이 mariadb인 경우 agentDistServerConfig_mariadb.xml파일에서 설정하면 됩니다.
  • 설치 경로/bin/ agentDistServerConfig_{database}.xml 파일에서, CJAgent의 데이타 베이스 설정 <{database}_sms1><{database}_kakao1>블록이 CJAgent 설정하는 부분입니다.
<database>
<kindofdb> {database} </kindofdb><!—oracle, mssql, mysql, mariadb중 하나 -->
<{database}_sms1><!-- 문자 발송 -->
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
<dbname>dbname</dbname>
<url>jdbc:sqlserver://ip:port;databaseName=dbname;</url>
<minidle>5</minidle>
<maxactive>30</maxactive>
<username>username</username>
<password>password</password>
<poolname>fpagents</poolname>
<validationQuery>select 1 </validationQuery>
<transforTosms>
<mode>CAMP, STOS,STOE </mode>
<queuetable sms-msg="SMS_MSG " mms-msg="MMS_MSG"/>
</transforTosms>
</{database}_sms1>
<{database}_kakao1><!-- 카카오 발송(알림톡, 친구톡) -->
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
<dbname>dbname</dbname>
<url>jdbc:sqlserver://ip:port;databaseName=dbname;</url>
<minidle>5</minidle>
<maxactive>30</maxactive>
<username>username</username>
<password>password</password>
<poolname>fpagents</poolname>
<validationQuery>select 1 </validationQuery>
<transforTokakao>
<mode>CAMP, STOS,STOE </mode>
<queuetable kko-msg="KKO_MSG" kkf-msg="KKF_MSG "/>
</transforTokakao>
</{database}_kakao1>
</database>

알림톡, 문자 전환 발송 환경 설정

설치 경로/bin/ agentDistServerConfig.xml 파일 내 config.push.transfertotext, config.push.transfertokakao 항목을 아래와 같이 설정(기본 셋팅)합니다.
만일 전환 발송을 중단하려면, activity를 false 처리하고 에이전트를 재시작하면 푸시 발송은 유지하고 전환 발송만 중단됩니다.
설정 완료 후 푸시 에이전트를 재시작합니다.
<?xml version= "1.0" encoding= "UTF-8" ?>
<config>
<push>
<transfertotext
id="cj"
activity="true"
transfer_code="2404,2403,2402,2401" />
<transfertokakao
id="cj"
activity="true"
transfer_code="2404,2403,2402,2401" />
</push>
</config>

푸시 실패 후 전환 발송 프로세스

1) 푸시 에이전트 - 푸시 발송(단말기로 푸시 발송) – kk로 시작하는 컬럼에 데이터 입력
2) 푸시 에이전트 - 푸시 실패한 단말기의 데이터(queue테이블에서 kk로 시작하는 컬럼)를 CJ의 msg 테이블에 insert
3) CJ에이전트 - 친구톡/알림톡 발송
4) CJ에이전트 - 친구톡/알림톡 실패한 단말기의 데이터를 CJ의 sms_msg, mms_msg테이블에 insert
  • failedtype – 푸시 발송 후 실패 시 전환되는 메시지 값(kko, kkf, sms, lms, mms)
  • kko_failed_type – 알림톡 또는 친구톡 실패 시 전환되는 메시지 값(sms, lms, mms)
  • 위 두 컬럼을 조건에 맞게 설정해야 전환 발송이 가능합니다.

테스트 샘플

푸시⇨SMS 전환 발송 테스트 샘플

Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’,캠페인코드,’수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지)
Oracle
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL , ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx , appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지”)
Mssql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’,캠페인코드,’수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ‘Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP, ‘푸시->SMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_AUTOQUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP, ‘푸시->SMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘SMS’, ‘SMS메시지’)

푸시⇨LMS/MMS 전환 발송 테스트 샘플

Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키 ‘, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->LMS/MMS ‘, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ’랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
Oracle
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL , ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’. ‘LMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx , appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE, ‘푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘MMS’, ‘메시지제목’, ‘전환메시지’)
Mssql
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시-> 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMS메시지제목’, ‘LMS메시지’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->문자전환’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMs메시지제목’, ‘LMS메시지’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->LMS/MMS’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘LMS’, ‘LMs메시지제목’, ‘LMs메시지’)

푸시⇨친구톡 전환 발송 테스트 샘플

failedtype=KKF로 설정되면 푸시 실패 시 친구톡으로 전환됩니다.
Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
Oracle
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
MSSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= getdate() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(), ‘푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’)

푸시⇨친구톡⇨SMS/LMS/MMS 전환 발송 테스트 샘플

failedtype=KKF, kko_failed_type=SMS/LMS/MMS로 설정되면 푸시 실패⇨친구톡 실패⇨문자메시지로 전환됩니다.
Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
Oracle failedtype=KKF, kko_failed_type=SMS/LMS/MMS로 설정되면 푸시실패⇨친구톡실패⇨문자메시지로 전환됨
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
MSSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->친구톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= getdate() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(), ‘푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->친구톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->친구톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKF’, ‘친구톡메시지’, ‘프로파일키’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)

푸시⇨알림톡 전환 발송 테스트 샘플

failedtype=KKO로 설정되면 푸시 실패 시 알림톡으로 전환됩니다.
Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’, ‘알림톡템플릿코드’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
Oracle
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
MSSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=getdate() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘친구톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)

푸시⇨알림톡⇨SMS/LMS/MMS 전환 발송 테스트 샘플

failedtype=KKO, kko_failed_type=SMS/LMS/MMS로 설정되면
푸시 실패⇨알림톡 실패⇨문자메시지로 전환됩니다.
Mysql, Mariadb
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,now(),now(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’, ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=now() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, now(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
Oracle failedtype=KKO, kko_failed_type=SMS/LMS/MMS로 설정되면 푸시실패⇨알림톡실패⇨문자메시지로 전환됨
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,SYSDATE, SYSDATE,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date= SYSDATE WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(AGPUSH_QUEUE_SEQ.NEXTVAL, ‘앱키’, ‘앱시크릿’, ‘푸시제목’, SYSDATE,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
MSSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡 ‘,’CAMP’, ‘R’,getdate(),getdate(),’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=getdate() WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE(appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(‘앱키’, ‘앱시크릿’, ‘푸시제목’, getdate(),’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘ 알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
PostgreSQL
-- CAMP
INSERT INTO AGPUSH_MASTER(serialnum,camptitle,pmode,step,rstart_date,wdate,isios,isandroid) values(캠페인코드,’푸시->알림톡’, ‘CAMP’, ‘R’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP,’Y’, ‘Y’)
INSERT INTO AGPUSH_QUEUE(queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, serialnum, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code , kko_failed_type, kko_failed_subject, kko_failed_msg) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’ 푸시->LMS/MMS’, ‘식별자’, ‘CAMP’, ‘이미지URL’, ‘랜딩URL’, ‘R’, 캠페인코드, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘친구톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’ , ‘LMS’, ‘LMS제목’, ‘LMS 내용’)
UPDATE AGPUSH_MASTER SET step=‘T’,rend_date=CURRENT_TIMESTAMP WHERE serialnum = 캠페인코드
-- STOS
INSERT INTO AGPUSH_QUEUE (queueidx, appkey, appsecret, msgtitle, senddate, msgcontents, identify, pmode, fname, plink, step, phone, callback, failedtype, kko_msg, kko_profiled_key, kko_template_code) values(nextval(‘AGPUSH_QUEUE_SEQ’), ‘앱키’, ‘앱시크릿’, ‘푸시제목’, CURRENT_TIMESTAMP,’푸시->알림톡’, ‘식별자’, ‘STOS’, ‘이미지URL’, ‘랜딩URL’, ‘R’, ‘수신자번호’, ‘발신자번호’, ‘KKO’, ‘알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)