========================2019-05-21 17:19:30======================== noteurl_start LGD_BUYER = 김소현 LGD_PRODUCTINFO = 조이렌트[1人用] 옵션: 스캐너/바코드 라벨지/ LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01094067925 LGD_BUYEREMAIL = 002apple@naver.conm LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = mjsof2019052117193450213 LGD_MID = mjsoft007 LGD_OID = PRO-A-sangsang7925-010411089-1558414771 LGD_AMOUNT = 313500 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20190521171934 LGD_RESPCODE = 0000 LGD_RESPMSG = 11: LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79012769579176 LGD_PAYER = 김소현 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = Y LGD_TIMESTAMP = 20190521171934 LGD_HASHDATA = ac39e73361200235f63a603e00c2fc50 CST_MID = mjsoft007 CST_PLATFORM = service Madd = 경기 안산시 단원구 광덕1로 61 (초지동, 신명프라자) 201호 Mcompany = 상상팩토리학원 Memail = 002apple@naver.conm Mname = 김소현 ProductCode = 010411089 SendItem = UserId = sangsang7925 category_code = 010411 f_price = 313500 hp1 = 010 hp2 = 4221 hp3 = 7925 mode = 1 post1 = 15445 post2 = tel1 = 010 tel2 = 9406 tel3 = 7925 ========================2019-05-21 17:19:30======================== 1: insert into mBoard_order set rOrdNo = 'PRO-A-sangsang7925-010411089-1558414771', AuthTy = 'virtual', memberId = 'sangsang7925', OrdNm ='김소현', OrdPhone = '010-9406-7925', OrdPhone2 = '010-4221-7925', UserEmail = '002apple@naver.conm', DlvAddr = '경기 안산시 단원구 광덕1로 61 (초지동, 신명프라자) 201호', DlvPost = '15445', OrdComp = '상상팩토리학원', ProductCode = '010411089', rProdNm = '조이렌트[1人用] 옵션: 스캐너/바코드 라벨지/', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '313500', rSuccYn = 'i', rCardNm = '농협 ', rApprNo = 'mjsof2019052117193450213', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '79012769579176', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = 'Y', reg_date = '2019-05-21 17:19:30', InvoiceNum = '11: :PRO-A-sangsang7925-010411089-1558414771/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2019-05-21 17:19:30' ========================2019-05-21 17:19:30======================== 2:OK ========================2019-05-21 17:21:17======================== noteurl_start LGD_BUYER = 김소현 LGD_PRODUCTINFO = 조이렌트[1人用] 옵션: 스캐너/바코드 라벨지/ LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01094067925 LGD_BUYEREMAIL = 002apple@naver.conm LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = mjsof2019052117193450213 LGD_MID = mjsoft007 LGD_OID = PRO-A-sangsang7925-010411089-1558414771 LGD_AMOUNT = 313500 LGD_CASTAMOUNT = 313500 LGD_CASCAMOUNT = 313500 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20190521172121 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79012769579176 LGD_PAYER = 김소현 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = G30448397 LGD_CASHRECEIPTKIND = 1 LGD_CASHRECEIPTSELFYN = N LGD_TIMESTAMP = 20190521172121 LGD_PCANCELCNT = LGD_HASHDATA = 6a902b227da6711606ec926c7756e779 LGD_CASHASHDATA = 6a902b227da6711606ec926c7756e779 ========================2019-05-21 17:21:17======================== update mBoard_order set rSuccYn = 'y', ICHE_OUTBANKNAME = 'G30448397/N/吏�異쒖쬆鍮�', bank = 'I', ICHE_AMOUNT = '313500/20190521172121' , mod_date = '2019-05-21 17:21:17' where rOrdNo = 'PRO-A-sangsang7925-010411089-1558414771' ========================2019-05-21 17:21:17======================== select post_json from xpay_log where tid = 'mjsof2019052117193450213' and p_type = 'note_url_R' 0 = {"LGD_BUYER":null,"LGD_PRODUCTINFO":null,"LGD_BUYERID":" ","LGD_BUYERADDRESS":" ","LGD_BUYERPHONE":"01094067925","LGD_BUYEREMAIL":"002apple@naver.conm","LGD_BUYERSSN":" ","LGD_PRODUCTCODE":" ","LGD_RECEIVER":" ","LGD_RECEIVERPHONE":" ","LGD_DELIVERYINFO":" ","LGD_CLOSEDATE":" ","LGD_TID":"mjsof2019052117193450213","LGD_MID":"mjsoft007","LGD_OID":"PRO-A-sangsang7925-010411089-1558414771","LGD_AMOUNT":"313500","LGD_CASTAMOUNT":"0","LGD_CASCAMOUNT":"0","LGD_PAYTYPE":"SC0040","LGD_PAYDATE":"20190521171934","LGD_RESPCODE":"0000","LGD_RESPMSG":"11: ","LGD_FINANCECODE":"011","LGD_FINANCENAME":null,"LGD_ACCOUNTNUM":"79012769579176","LGD_PAYER":null,"LGD_CASSEQNO":"000","LGD_CASFLAG":"R","LGD_ESCROWYN":"Y","LGD_TIMESTAMP":"20190521171934","LGD_HASHDATA":"ac39e73361200235f63a603e00c2fc50","CST_MID":"mjsoft007","CST_PLATFORM":"service","Madd":null,"Mcompany":null,"Memail":"002apple@naver.conm","Mname":null,"ProductCode":"010411089","SendItem":"","UserId":"sangsang7925","category_code":"010411","f_price":"313500","hp1":"010","hp2":"4221","hp3":"7925","mode":"1","post1":"15445","post2":"","tel1":"010","tel2":"9406","tel3":"7925"} post_json = {"LGD_BUYER":null,"LGD_PRODUCTINFO":null,"LGD_BUYERID":" ","LGD_BUYERADDRESS":" ","LGD_BUYERPHONE":"01094067925","LGD_BUYEREMAIL":"002apple@naver.conm","LGD_BUYERSSN":" ","LGD_PRODUCTCODE":" ","LGD_RECEIVER":" ","LGD_RECEIVERPHONE":" ","LGD_DELIVERYINFO":" ","LGD_CLOSEDATE":" ","LGD_TID":"mjsof2019052117193450213","LGD_MID":"mjsoft007","LGD_OID":"PRO-A-sangsang7925-010411089-1558414771","LGD_AMOUNT":"313500","LGD_CASTAMOUNT":"0","LGD_CASCAMOUNT":"0","LGD_PAYTYPE":"SC0040","LGD_PAYDATE":"20190521171934","LGD_RESPCODE":"0000","LGD_RESPMSG":"11: ","LGD_FINANCECODE":"011","LGD_FINANCENAME":null,"LGD_ACCOUNTNUM":"79012769579176","LGD_PAYER":null,"LGD_CASSEQNO":"000","LGD_CASFLAG":"R","LGD_ESCROWYN":"Y","LGD_TIMESTAMP":"20190521171934","LGD_HASHDATA":"ac39e73361200235f63a603e00c2fc50","CST_MID":"mjsoft007","CST_PLATFORM":"service","Madd":null,"Mcompany":null,"Memail":"002apple@naver.conm","Mname":null,"ProductCode":"010411089","SendItem":"","UserId":"sangsang7925","category_code":"010411","f_price":"313500","hp1":"010","hp2":"4221","hp3":"7925","mode":"1","post1":"15445","post2":"","tel1":"010","tel2":"9406","tel3":"7925"} ========================2019-05-21 17:21:17======================== 2:OK