========================2022-06-01 11:27:31======================== noteurl_start LGD_BUYER = 문정민 LGD_PRODUCTINFO = [바로결제] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = mjsof20220601112810iBgt9 LGD_MID = mjsoft007 LGD_OID = Direct-h00327-1654049753 LGD_AMOUNT = 220000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20220601112810 LGD_RESPCODE = 0000 LGD_RESPMSG = 26: LGD_FINANCECODE = 088 LGD_FINANCENAME = 신한 LGD_ACCOUNTNUM = 63790131533470 LGD_PAYER = 현대비아이디 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = LGD_TIMESTAMP = 20220601112810 LGD_HASHDATA = fdecdab1ed2618eeb4775cba5096ff4e CST_MID = mjsoft007 CST_PLATFORM = service Madd = Mcompany = (주)현대비아이디 Memail = Mname = 문정민 SendItem = UserId = h00327 f_point = 220000 f_price = 220000 hp1 = hp2 = hp3 = post1 = post2 = tel1 = tel2 = tel3 = ========================2022-06-01 11:27:31======================== insert into mBoard_order set rOrdNo = 'Direct-h00327-1654049753', AuthTy = 'virtual', memberId = 'h00327', OrdNm ='문정민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)현대비아이디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'i', rCardNm = '신한 ', rApprNo = 'mjsof20220601112810iBgt9', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '63790131533470', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = '', reg_date = '2022-06-01 11:27:31', InvoiceNum = '26: :Direct-h00327-1654049753/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-06-01 11:27:31' ========================2022-06-01 11:31:31======================== noteurl_start LGD_BUYER = 문정민 LGD_PRODUCTINFO = [바로결제] LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = LGD_BUYEREMAIL = LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = mjsof20220601112810iBgt9 LGD_MID = mjsoft007 LGD_OID = Direct-h00327-1654049753 LGD_AMOUNT = 220000 LGD_CASTAMOUNT = 220000 LGD_CASCAMOUNT = 220000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20220601113210 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 088 LGD_FINANCENAME = 신한 LGD_ACCOUNTNUM = 63790131533470 LGD_PAYER = (주)현대비아이 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = 160232558 LGD_CASHRECEIPTKIND = 1 LGD_CASHRECEIPTSELFYN = N LGD_TIMESTAMP = 20220601113210 LGD_PCANCELCNT = LGD_HASHDATA = 517ebee4c576de03c168e69dd3dc1170 LGD_CASHASHDATA = 517ebee4c576de03c168e69dd3dc1170 ========================2022-06-01 11:31:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'h00327' 0 = h00327 Mid = h00327 1 = (주)현대비아이디 Mcompany = (주)현대비아이디 2 = 6868100327 companyNum = 6868100327 3 = 032-426-3907 Mtel1 = 032-426-3907 4 = 010-6389-2099 Mhp = 010-6389-2099 ========================2022-06-01 11:31:32======================== select post_json from xpay_log where tid = 'mjsof20220601112810iBgt9' and p_type = 'note_url_R' 0 = post_json = ========================2022-06-01 11:31:32======================== select count(*) as cnt from customers where id = 'h00327' ========================2022-06-01 11:31:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('h00327','2022-06-01 11:31:31','','','온라인','0')