알림통 전송


[18:09:23.607] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT CONF_CODE_ID AS confCodeId ,CONF_CODE AS confCode ,CONF_CODE_NM AS confCodeNm ,FRST_REGISTER_ID AS frstRegisterId ,FRST_REGIST_PNTTM AS frstRegistPnttm ,LAST_UPDUSR_ID AS lastUpdusrId ,LAST_UPDT_PNTTM AS lastUpdtPnttm FROM MJ_CONF
         WHERE CONF_CODE_ID = 'CONF01'

[18:09:23.617] I jdbc.sqlonly sqlOccured 66 | SQL:
        INSERT INTO LETTNADMINLOG ( ADMINLOG_ID , CONECT_ID , CONECT_IP , CREAT_DT , PROGRM_FILE_NM , MENU_NM , APPRO_NM , URL ) SELECT 'ADMINLOG_0000000008972179' , 'USRCNFRM_00000003540' , '127.0.0.1' , now(), 'selectMjonMsgUseConfAjax', MENU_NM , APPRO_NM , '/web/mjon/conf/selectMjonMsgUseConfAjax.do' FROM LETTNADMINMETHOD
         WHERE METHOD_NM = 'selectMjonMsgUseConfAjax'
           AND PARAM = 'N' LIMIT 1




alert -- 알림톡을 발송하시겠습니까 ?




[18:09:55.280] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT MBER_STTUS AS mberSttus FROM LETTNGNRLMBER
         WHERE MBER_ID = 'dudgusw'

[18:09:55.288] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT USER_MONEY AS befCash FROM LETTNGNRLMBER
         WHERE MBER_ID = 'dudgusw'

[18:09:55.296] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT USER_POINT AS befPoint FROM LETTNGNRLMBER
         WHERE MBER_ID = 'dudgusw'

[18:09:55.303] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT SHORT_PRICE AS shortPrice , LONG_PRICE AS longPrice , PICTURE_PRICE AS picturePrice , PICTURE2_PRICE AS picture2Price , PICTURE3_PRICE AS picture3Price , CUSTOM_SAMPLE_PRICE AS customSamplePrice , CUSTOM_EDIT_PRICE AS customEditPrice , CUSTOM_EDIT3_PRICE AS customEdit3Price , CUSTOM_TEXT_PRICE AS customTextPrice , POINT_PER AS pointPer , KAKAO_AT_PRICE AS kakaoAtPrice , FAX_PRICE AS faxPrice FROM MJ_MBER_SETTING

[18:09:55.311] I jdbc.sqlonly sqlOccured 66 | SQL:
        /* mjonMsgDAO.selectMberManageInfo */ SELECT MBER_ID AS mberId , MBER_NM AS mberNm , SHORT_PRICE AS shortPrice , LONG_PRICE AS longPrice , PICTURE_PRICE AS picturePrice , PICTURE2_PRICE AS picture2Price , PICTURE3_PRICE AS picture3Price , KAKAO_AT_PRICE AS kakaoAtPrice , KAKAO_FT_PRICE AS kakaoFtPrice , FAX_PRICE AS faxPrice , USER_MONEY AS userMoney , USER_POINT AS userPoint , DEPT AS dept , MBTLNUM AS moblphonNo , MANAGER_NM AS managerNm , EXCEPT_SPAM_YN AS exceptSpamYn , HOTLINE_AGENT_CODE AS hotlineAgentCode , BLINE_CODE AS blineCode , AT_SMISHING_YN AS atSmishingYn , PRE_PAYMENT_YN AS prePaymentYn FROM LETTNGNRLMBER
         WHERE MBER_ID = 'dudgusw'

[18:09:55.598] I jdbc.sqlonly sqlOccured 66 | SQL:
        INSERT INTO MJ_MSG_DATA ( MSG_ID , MSG_GROUP_ID , USER_ID , AGENT_CODE , CUR_STATE , MSG_NOTICETALK_SENDER_KEY , MSG_NOTICETALK_TMP_KEY , CALL_TO , CALL_FROM , MSG_TYPE , SMS_TXT , BIZ_KAKAO_TITLE , BIZ_KAKAO_RESEND_YN , BIZ_KAKAO_RESEND_DATA , BIZ_KAKAO_RESEND_TYPE , BIZ_KAKAO_JSON_FILE , REQ_DATE )VALUES ( 'MSGID_00000031437533' , 'MSGGID_0000000325913' , 'dudgusw' , '04' , 0 , '669143473b1af459628b8bdf2f48da090c8895de' , 'bizp_2023030812542932272373810' , '01083584250' , '01093414986' , '8' , '테스트[test] [아이티앤] 주문완료안내 □ 주문번호 : 01000111 □ 배송지 : 강남구 자곡동 □ 배송예정일 : 11월17 □ 결제금액 : 100,000원' , '문자온 가입을 진심으로 환영합니다.§§회원가입 안내' , 'N' , '' , '' , '/usr/local/tomcat/file/kakao/dudgusw/20240417/AT/180955_01083584250.json' , '2024/04/17 18:39:55' )

[18:09:55.622] I jdbc.sqlonly sqlOccured 66 | SQL:
        INSERT INTO MJ_CASH ( USER_ID, CASH, FRST_REGISTER_ID, FRST_REGIST_PNTTM, MEMO, ORDER_ID, MSG_GROUP_ID )VALUES ( 'dudgusw', -5.0, 'dudgusw', now(), '카카오 알림톡 총 1건 중 1건 발송', NULL, 'MSGGID_0000000325913' )

[18:09:55.638] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT NVL(B.CASH , 0) AS cash FROM LETTNGNRLMBER A LEFT JOIN ( SELECT SUM(CASH) AS cash , USER_ID FROM MJ_CASH A
         GROUP BY A.USER_ID , A.DEL_FLAG HAVING USER_ID = 'dudgusw'
           AND A.DEL_FLAG = 'N' ) B ON A.MBER_ID = B.USER_ID
         WHERE A.MBER_ID = 'dudgusw'

[18:09:55.916] I jdbc.sqlonly sqlOccured 66 | SQL:
        UPDATE LETTNGNRLMBER SET USER_MONEY = '209380.00'
         WHERE MBER_ID = 'dudgusw'

[18:09:55.919] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT NVL(B.CASH , 0) AS cash FROM LETTNGNRLMBER A LEFT JOIN ( SELECT SUM(CASH) AS cash , USER_ID FROM MJ_CASH A
         GROUP BY A.USER_ID , A.DEL_FLAG HAVING USER_ID = 'dudgusw'
           AND A.DEL_FLAG = 'N' ) B ON A.MBER_ID = B.USER_ID
         WHERE A.MBER_ID = 'dudgusw'

[18:09:55.925] I jdbc.sqlonly sqlOccured 66 | SQL:
        UPDATE LETTNGNRLMBER SET USER_MONEY = '209380.00'
         WHERE MBER_ID = 'dudgusw'

[18:09:55.927] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT COUNT(MSG_GROUP_ID) FROM MJ_MSG_GROUP_DATA
         WHERE USER_ID = 'dudgusw'
           AND MSG_GROUP_ID = 'MSGGID_0000000325913'

[18:09:55.930] I jdbc.sqlonly sqlOccured 66 | SQL:
        INSERT INTO MJ_MSG_GROUP_DATA ( MSG_GROUP_ID, USER_ID, CALL_FROM, SMS_TXT, SUBJECT, REQ_DATE, MSG_GROUP_CNT, CONECT_MTHD, MSG_TYPE, MSG_KIND, AGENT_CODE, EACH_PRICE, RESERVE_YN, BEF_CASH, BEF_POINT, RECOMM_ID, FILE_CNT, TOT_PRICE, EVENT_YN, DELAY_YN, AT_DELAY_YN, BIZ_KAKAO_RESEND_ORGNL_TXT ) VALUES ( 'MSGGID_0000000325913', 'dudgusw', '01093414986', '테스트[test] [#{회사명}] 주문완료안내 □ 주문번호 : #{주문번호} □ 배송지 : #{구/면} #{동/리} □ 배송예정일 : #{월일} □ 결제금액 : #{결제금액}원', NULL, '2024/04/17 18:39:55', '1', NULL, '8', NULL, '04', '5.0', 'N', '209385.00', '2415', NULL, '1', '5.0', NULL, NULL, 'Y', '' )

[18:09:55.933] I jdbc.sqlonly sqlOccured 66 | SQL:
        INSERT INTO BIZ_KAKAO_PRICE ( MSG_GROUP_ID , BIZ_KAKAO_AT_PRICE , BIZ_KAKAO_FT_PRICE , BIZ_KAKAO_FT_IMG_PRICE , BIZ_KAKAO_FT_WIDE_IMG_PRICE , BIZ_SMS_PRICE , BIZ_MMS_PRICE ) VALUES ( 'MSGGID_0000000325913' ,5.0 ,0.0 ,0.0 ,0.0 ,10.0 ,20.0 )

[18:09:55.970] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT ADMIN_SMS_NOTICE_YN AS adminSmsNoticeYn ,PRE_PAYMENT_YN AS prePaymentYn ,SMISHING_YN AS smishingYn ,AUTO_CASH AS autoCash ,IFNULL(BLINE_CODE, 'N') AS blineCode ,IFNULL(RECOMMEND_ID, '') AS recommendId FROM LETTNGNRLMBER
         WHERE MBER_ID = 'dudgusw'

[18:09:55.978] I jdbc.sqlonly sqlOccured 66 | SQL:
        SELECT IFNULL(SMS_NOTI, 'N') AS smsNoti, IFNULL(EMAIL_NOTI, 'N') AS emailNoti, IFNULL(SLACK_NOTI, 'N') AS slackNoti, IFNULL(SMISHING_NOTI, 'N') AS smishingNoti, LAST_UPDUSR_ID AS lasUpdusrId, LAST_UPDT_PNTTM AS lastUpdtPnttm FROM MJ_MBER_SETTING LIMIT 1