========================2020-01-29 11:54:37======================== noteurl_start LGD_BUYER = 박성원 LGD_PRODUCTINFO = 천년경영3 [1人用] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = ryunen@naver.com1 LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = tmjso2020012911544190111 LGD_MID = tmjsoft007 LGD_OID = PRO-A-ryunen-010181361-1580266440 LGD_AMOUNT = 330000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20200129115442 LGD_RESPCODE = 0000 LGD_RESPMSG = 06: LGD_FINANCECODE = 004 LGD_FINANCENAME = 국민 LGD_ACCOUNTNUM = X65659014003178 LGD_PAYER = 테스트 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = LGD_TIMESTAMP = 20200129115442 LGD_HASHDATA = 6b100a372689ada8d341157dabc3f6b2 CST_MID = mjsoft007 CST_PLATFORM = test Madd = 대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1 Mcompany = MJSOFT1 Memail = ryunen@naver.com1 Mname = 박성원 ProductCode = 010181361 SendItem = UserId = ryunen category_code = 010181 f_price = 330000 hp1 = 010 hp2 = 9357 hp3 = 0525 mode = 1 post1 = 42019 post2 = tel1 = 053 tel2 = 743 tel3 = 5122 ========================2020-01-29 11:54:37======================== 1: insert into mBoard_order set rOrdNo = 'PRO-A-ryunen-010181361-1580266440', AuthTy = 'virtual', memberId = 'ryunen', OrdNm ='박성원', OrdPhone = '053-743-5122', OrdPhone2 = '010-9357-0525', UserEmail = 'ryunen@naver.com1', DlvAddr = '대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1', DlvPost = '42019', OrdComp = 'MJSOFT1', ProductCode = '010181361', rProdNm = '천년경영3 [1人用]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '330000', rSuccYn = 'i', rCardNm = '국민 ', rApprNo = 'tmjso2020012911544190111', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = 'X65659014003178', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = '', reg_date = '2020-01-29 11:54:37', InvoiceNum = '06: :PRO-A-ryunen-010181361-1580266440/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2020-01-29 11:54:37' ========================2020-01-29 11:54:37======================== 2:OK ========================2020-01-29 11:55:26======================== noteurl_start LGD_BUYER = 박성원 LGD_PRODUCTINFO = 천년경영3 C/S[동시접속 1人] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = ryunen@naver.com1 LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = tmjso2020012911553190112 LGD_MID = tmjsoft007 LGD_OID = PRO-A-ryunen-010182351-1580266509 LGD_AMOUNT = 253000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20200129115531 LGD_RESPCODE = 0000 LGD_RESPMSG = 26: LGD_FINANCECODE = 088 LGD_FINANCENAME = 신한 LGD_ACCOUNTNUM = X3790127673763 LGD_PAYER = 박성원 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = LGD_TIMESTAMP = 20200129115531 LGD_HASHDATA = e5cb51cb5e1f27792edff2422d7e3c1d CST_MID = mjsoft007 CST_PLATFORM = test Madd = 대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1 Mcompany = MJSOFT1 Memail = ryunen@naver.com1 Mname = 박성원 ProductCode = 010182351 SendItem = UserId = ryunen category_code = 010182 f_price = 253000 hp1 = 010 hp2 = 9357 hp3 = 0525 mode = 1 post1 = 42019 post2 = tel1 = 053 tel2 = 743 tel3 = 5122 ========================2020-01-29 11:55:26======================== 1: insert into mBoard_order set rOrdNo = 'PRO-A-ryunen-010182351-1580266509', AuthTy = 'virtual', memberId = 'ryunen', OrdNm ='박성원', OrdPhone = '053-743-5122', OrdPhone2 = '010-9357-0525', UserEmail = 'ryunen@naver.com1', DlvAddr = '대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1', DlvPost = '42019', OrdComp = 'MJSOFT1', ProductCode = '010182351', rProdNm = '천년경영3 C/S[동시접속 1人]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '253000', rSuccYn = 'i', rCardNm = '신한 ', rApprNo = 'tmjso2020012911553190112', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = 'X3790127673763', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = '', reg_date = '2020-01-29 11:55:26', InvoiceNum = '26: :PRO-A-ryunen-010182351-1580266509/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2020-01-29 11:55:26' ========================2020-01-29 11:55:27======================== 2:OK ========================2020-01-29 11:56:24======================== noteurl_start LGD_BUYER = 박성원 LGD_PRODUCTINFO = 천년경영3 C/S[동시접속 1人] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = ryunen@naver.com1 LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = tmjso2020012911553190112 LGD_MID = tmjsoft007 LGD_OID = PRO-A-ryunen-010182351-1580266509 LGD_AMOUNT = 253000 LGD_CASTAMOUNT = 253000 LGD_CASCAMOUNT = 253000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20200129115628 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 088 LGD_FINANCENAME = 신한 LGD_ACCOUNTNUM = X3790127673763 LGD_PAYER = 무통장테스트 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = LGD_CASHRECEIPTKIND = LGD_CASHRECEIPTSELFYN = LGD_TIMESTAMP = 20200129115629 LGD_PCANCELCNT = LGD_HASHDATA = 4e3e1256157e57083053d8611f6053aa LGD_CASHASHDATA = 4e3e1256157e57083053d8611f6053aa ========================2020-01-29 11:56:24======================== update mBoard_order set rSuccYn = 'y', ICHE_OUTBANKNAME = ' / /', bank = 'I', ICHE_AMOUNT = '253000/20200129115628' , mod_date = '2020-01-29 11:56:24' where rOrdNo = 'PRO-A-ryunen-010182351-1580266509' ========================2020-01-29 11:56:24======================== select post_json from xpay_log where tid = 'tmjso2020012911553190112' and p_type = 'note_url_R' 0 = post_json = ========================2020-01-29 11:56:24======================== select certi_num from certinumManage WHERE category_code = '' ========================2020-01-29 11:56:24======================== update member set Certi_num ='', End_day ='', Start_day='',Mdiv='2',Mup='1',Msw1='',Mper='1' where Mid ='' ========================2020-01-29 11:56:24======================== 2:OK