========================2024-01-08 22:07:33======================== noteurl_start LGD_BUYER = 노승한 LGD_PRODUCTINFO = 카메이트Lite[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01053479698 LGD_BUYEREMAIL = tmdgks3698@naver.com LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = mjsof20240108221140nmZR3 LGD_MID = mjsoft007 LGD_OID = Direct-GUEST-1704719112 LGD_AMOUNT = 165000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240108221140 LGD_RESPCODE = 0000 LGD_RESPMSG = 11: LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79015838645877 LGD_PAYER = 노승한 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = Y LGD_TIMESTAMP = 20240108221140 LGD_HASHDATA = 9f7f4f160edf657bc01a14f91df3d53a CST_MID = mjsoft007 CST_PLATFORM = service Madd = 강원특별자치도 평창군 진부면 송정택지1길 37 (송정리, 평창성원아파트) 1동 1004호 Mcompany = Memail = Mname = 노승한 ProductCode = 010307071 SendItem = UserId = GUEST category_code = 010307 f_price = 165000 hp1 = 010 hp2 = 5347 hp3 = 9698 mode = 1 post1 = 25331 post2 = routed-from = xpay tel1 = 010 tel2 = 5347 tel3 = 9698 x-tosspayments-global-trace-id = a240108342c1731b97c475fbde230ab321015b0 ========================2024-01-08 22:07:33======================== 1: insert into mBoard_order set rOrdNo = 'Direct-GUEST-1704719112', AuthTy = 'virtual', memberId = 'GUEST', OrdNm ='노승한', OrdPhone = '010-5347-9698', OrdPhone2 = '010-5347-9698', UserEmail = '', DlvAddr = '강원특별자치도 평창군 진부면 송정택지1길 37 (송정리, 평창성원아파트) 1동 1004호 ', DlvPost = '25331', OrdComp = '', ProductCode = '010307071', rProdNm = '카메이트Lite[1人用] 옵션:', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '165000', rSuccYn = 'i', rCardNm = '농협 ', rApprNo = 'mjsof20240108221140nmZR3', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '79015838645877', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = 'Y', reg_date = '2024-01-08 22:07:33', InvoiceNum = '11: :Direct-GUEST-1704719112/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-08 22:07:33' ========================2024-01-08 22:07:33======================== 2:OK ========================2024-01-08 22:08:43======================== noteurl_start LGD_BUYER = 노승한 LGD_PRODUCTINFO = 카메이트Lite[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01053479698 LGD_BUYEREMAIL = tmdgks3698@naver.com LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = mjsof20240108221140nmZR3 LGD_MID = mjsoft007 LGD_OID = Direct-GUEST-1704719112 LGD_AMOUNT = 165000 LGD_CASTAMOUNT = 165000 LGD_CASCAMOUNT = 165000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240108221249 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79015838645877 LGD_PAYER = 노승한 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = LGD_CASHRECEIPTKIND = LGD_CASHRECEIPTSELFYN = LGD_TIMESTAMP = 20240108221249 LGD_PCANCELCNT = LGD_HASHDATA = 614121f4bc67b2ea7526a804dc16811d LGD_CASHASHDATA = 614121f4bc67b2ea7526a804dc16811d ========================2024-01-08 22:08:43======================== update mBoard_order set rSuccYn = 'y', ICHE_OUTBANKNAME = ' / /', bank = 'I', ICHE_AMOUNT = '165000/20240108221249' , mod_date = '2024-01-08 22:08:43' where rOrdNo = 'Direct-GUEST-1704719112' ========================2024-01-08 22:08:43======================== select post_json from xpay_log where tid = 'mjsof20240108221140nmZR3' and p_type = 'note_url_R' 0 = post_json = ========================2024-01-08 22:08:43======================== select certi_num from certinumManage WHERE category_code = '' ========================2024-01-08 22:08:43======================== update member set Certi_num ='', End_day ='', Start_day='',Mdiv='2',Mup='1',Msw1='',Mper='1' where Mid ='' ========================2024-01-08 22:08:43======================== 2:OK ========================2024-01-08 22:22:16======================== noteurl_start LGD_BUYER = 노승한 LGD_PRODUCTINFO = 카메이트Lite[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01053479698 LGD_BUYEREMAIL = tmdgks3698@naver.com LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = mjsof20240108222622vdiV5 LGD_MID = mjsoft007 LGD_OID = Direct-tmdgks3698-1704720053 LGD_AMOUNT = 165000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240108222622 LGD_RESPCODE = 0000 LGD_RESPMSG = 11: LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79018621801932 LGD_PAYER = 노승한 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = Y LGD_TIMESTAMP = 20240108222622 LGD_HASHDATA = 413c4d694260a08d25125a942abafba7 CST_MID = mjsoft007 CST_PLATFORM = service Madd = 강원특별자치도 평창군 진부면 송정택지1길 37 (송정리, 평창성원아파트) 1동 1004호 Mcompany = Memail = tmdgks3698@naver.com Mname = 노승한 ProductCode = 010307071 SendItem = UserId = tmdgks3698 category_code = 010307 f_price = 165000 hp1 = hp2 = hp3 = mode = 1 post1 = 25331 post2 = routed-from = xpay tel1 = 010 tel2 = 5347 tel3 = 9698 x-tosspayments-global-trace-id = a240108c96396fe3a464ea6b599912c2aae01c4 ========================2024-01-08 22:22:16======================== 1: insert into mBoard_order set rOrdNo = 'Direct-tmdgks3698-1704720053', AuthTy = 'virtual', memberId = 'tmdgks3698', OrdNm ='노승한', OrdPhone = '010-5347-9698', OrdPhone2 = '--', UserEmail = 'tmdgks3698@naver.com', DlvAddr = '강원특별자치도 평창군 진부면 송정택지1길 37 (송정리, 평창성원아파트) 1동 1004호', DlvPost = '25331', OrdComp = '', ProductCode = '010307071', rProdNm = '카메이트Lite[1人用] 옵션:', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '165000', rSuccYn = 'i', rCardNm = '농협 ', rApprNo = 'mjsof20240108222622vdiV5', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '79018621801932', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = 'Y', reg_date = '2024-01-08 22:22:16', InvoiceNum = '11: :Direct-tmdgks3698-1704720053/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-08 22:22:16' ========================2024-01-08 22:22:16======================== 2:OK ========================2024-01-08 22:23:16======================== noteurl_start LGD_BUYER = 노승한 LGD_PRODUCTINFO = 카메이트Lite[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01053479698 LGD_BUYEREMAIL = tmdgks3698@naver.com LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = mjsof20240108222622vdiV5 LGD_MID = mjsoft007 LGD_OID = Direct-tmdgks3698-1704720053 LGD_AMOUNT = 165000 LGD_CASTAMOUNT = 165000 LGD_CASCAMOUNT = 165000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240108222722 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79018621801932 LGD_PAYER = 노승한 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = LGD_CASHRECEIPTKIND = LGD_CASHRECEIPTSELFYN = LGD_TIMESTAMP = 20240108222723 LGD_PCANCELCNT = LGD_HASHDATA = 2bbe0def28d656b2f39912f49f4c2240 LGD_CASHASHDATA = 2bbe0def28d656b2f39912f49f4c2240 ========================2024-01-08 22:23:16======================== update mBoard_order set rSuccYn = 'y', ICHE_OUTBANKNAME = ' / /', bank = 'I', ICHE_AMOUNT = '165000/20240108222722' , mod_date = '2024-01-08 22:23:16' where rOrdNo = 'Direct-tmdgks3698-1704720053' ========================2024-01-08 22:23:16======================== select post_json from xpay_log where tid = 'mjsof20240108222622vdiV5' and p_type = 'note_url_R' 0 = post_json = ========================2024-01-08 22:23:16======================== select certi_num from certinumManage WHERE category_code = '' ========================2024-01-08 22:23:16======================== update member set Certi_num ='', End_day ='', Start_day='',Mdiv='2',Mup='1',Msw1='',Mper='1' where Mid ='' ========================2024-01-08 22:23:16======================== 2:OK