========================2016-06-20 18:06:23======================== noteurl_start LGD_BUYER = 박성원 LGD_PRODUCTINFO = [바로결제] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = ryunen@naver.com LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = tquee2016062018062579578 LGD_MID = tqueensmet LGD_OID = Direct-ryunen-1466413559 LGD_AMOUNT = 11000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20160620180625 LGD_RESPCODE = 0000 LGD_RESPMSG = 31: LGD_FINANCECODE = 031 LGD_FINANCENAME = 대구 LGD_ACCOUNTNUM = X24396149522308 LGD_PAYER = 박성원 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = LGD_TIMESTAMP = 20160620180625 LGD_HASHDATA = ab84792d657b8949a61b5b0e7d9f9b74 CST_MID = queensmet CST_PLATFORM = test Madd = 대구 수성구 동대구로 331 (범어동, 청효정빌딩) Mcompany = MJSOFT Memail = ryunen@naver.com Mname = 박성원 SendItem = UserId = ryunen f_point = 10000 f_price = 11000 hp1 = 010 hp2 = 9357 hp3 = 0525 post1 = 42019 post2 = tel1 = 053 tel2 = 743 tel3 = 5122 ========================2016-06-20 18:06:23======================== insert into mBoard_order set rOrdNo = 'Direct-ryunen-1466413559', AuthTy = 'virtual', memberId = 'ryunen', OrdNm ='박성원', OrdPhone = '053-743-5122', OrdPhone2 = '010-9357-0525', UserEmail = 'ryunen@naver.com', DlvAddr = '대구 수성구 동대구로 331 (범어동, 청효정빌딩) ', DlvPost = '42019', OrdComp = 'MJSOFT', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'i', rCardNm = '대구 ', rApprNo = 'tquee2016062018062579578', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = 'X24396149522308', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = '', reg_date = '2016-06-20 18:06:23', InvoiceNum = '31: :Direct-ryunen-1466413559/0000', Deliver = '', senditem = '', salestopvalue = '' ========================2016-06-20 18:06:45======================== noteurl_start LGD_BUYER = 박성원 LGD_PRODUCTINFO = [바로결제] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = ryunen@naver.com LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = tquee2016062018062579578 LGD_MID = tqueensmet LGD_OID = Direct-ryunen-1466413559 LGD_AMOUNT = 11000 LGD_CASTAMOUNT = 11000 LGD_CASCAMOUNT = 11000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20160620180648 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 004 LGD_FINANCENAME = 국민 LGD_ACCOUNTNUM = X24396149522308 LGD_PAYER = 무통장테스트 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = 158100443 LGD_CASHRECEIPTKIND = 0 LGD_CASHRECEIPTSELFYN = N LGD_TIMESTAMP = 20160620180648 LGD_PCANCELCNT = LGD_HASHDATA = fc167c76558634023a973d0e980d7a55 LGD_CASHASHDATA = fc167c76558634023a973d0e980d7a55 ========================2016-06-20 18:06:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ryunen' 0 = ryunen Mid = ryunen 1 = MJSOFT Mcompany = MJSOFT 2 = 5021894746 companyNum = 5021894746 3 = 053-743-5122 Mtel1 = 053-743-5122 4 = 010-9357-0525 Mhp = 010-9357-0525 ========================2016-06-20 18:06:45======================== select post_json from xpay_log where tid = 'tquee2016062018062579578' and p_type = 'note_url_R' 0 = {"LGD_BUYER":null,"LGD_PRODUCTINFO":null,"LGD_BUYERID":" ","LGD_BUYERADDRESS":" ","LGD_BUYERPHONE":" ","LGD_BUYEREMAIL":"ryunen@naver.com","LGD_BUYERSSN":" ","LGD_PRODUCTCODE":" ","LGD_RECEIVER":" ","LGD_RECEIVERPHONE":" ","LGD_DELIVERYINFO":" ","LGD_CLOSEDATE":" ","LGD_TID":"tquee2016062018062579578","LGD_MID":"tqueensmet","LGD_OID":"Direct-ryunen-1466413559","LGD_AMOUNT":"11000","LGD_CASTAMOUNT":"0","LGD_CASCAMOUNT":"0","LGD_PAYTYPE":"SC0040","LGD_PAYDATE":"20160620180625","LGD_RESPCODE":"0000","LGD_RESPMSG":"31: ","LGD_FINANCECODE":"031","LGD_FINANCENAME":null,"LGD_ACCOUNTNUM":"X24396149522308","LGD_PAYER":null,"LGD_CASSEQNO":"000","LGD_CASFLAG":"R","LGD_ESCROWYN":" ","LGD_TIMESTAMP":"20160620180625","LGD_HASHDATA":"ab84792d657b8949a61b5b0e7d9f9b74","CST_MID":"queensmet","CST_PLATFORM":"test","Madd":null,"Mcompany":"MJSOFT","Memail":"ryunen@naver.com","Mname":null,"SendItem":"","UserId":"ryunen","f_point":"10000","f_price":"11000","hp1":"010","hp2":"9357","hp3":"0525","post1":"42019","post2":"","tel1":"053","tel2":"743","tel3":"5122"} post_json = {"LGD_BUYER":null,"LGD_PRODUCTINFO":null,"LGD_BUYERID":" ","LGD_BUYERADDRESS":" ","LGD_BUYERPHONE":" ","LGD_BUYEREMAIL":"ryunen@naver.com","LGD_BUYERSSN":" ","LGD_PRODUCTCODE":" ","LGD_RECEIVER":" ","LGD_RECEIVERPHONE":" ","LGD_DELIVERYINFO":" ","LGD_CLOSEDATE":" ","LGD_TID":"tquee2016062018062579578","LGD_MID":"tqueensmet","LGD_OID":"Direct-ryunen-1466413559","LGD_AMOUNT":"11000","LGD_CASTAMOUNT":"0","LGD_CASCAMOUNT":"0","LGD_PAYTYPE":"SC0040","LGD_PAYDATE":"20160620180625","LGD_RESPCODE":"0000","LGD_RESPMSG":"31: ","LGD_FINANCECODE":"031","LGD_FINANCENAME":null,"LGD_ACCOUNTNUM":"X24396149522308","LGD_PAYER":null,"LGD_CASSEQNO":"000","LGD_CASFLAG":"R","LGD_ESCROWYN":" ","LGD_TIMESTAMP":"20160620180625","LGD_HASHDATA":"ab84792d657b8949a61b5b0e7d9f9b74","CST_MID":"queensmet","CST_PLATFORM":"test","Madd":null,"Mcompany":"MJSOFT","Memail":"ryunen@naver.com","Mname":null,"SendItem":"","UserId":"ryunen","f_point":"10000","f_price":"11000","hp1":"010","hp2":"9357","hp3":"0525","post1":"42019","post2":"","tel1":"053","tel2":"743","tel3":"5122"} ========================2016-06-20 18:06:45======================== select count(*) as cnt from customers where id = 'ryunen' ========================2016-06-20 18:06:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ryunen','2016-06-20 18:06:45','10000','11000','온라인','0')