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’, ‘알림톡메시지’, ‘프로파일키’ , ‘알림톡템플릿코드’)