========================2024-03-05 15:34:59======================== 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 = mjsof202403051540093XiF3 LGD_MID = mjsoft007 LGD_OID = Direct-ds7098-1709620433 LGD_AMOUNT = 55000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240305154009 LGD_RESPCODE = 0000 LGD_RESPMSG = 11: LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79019634306674 LGD_PAYER = 곽회출(덕수상사) LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = LGD_TIMESTAMP = 20240305154009 LGD_HASHDATA = 8d019bb258c598d3e59076918dfa271c CST_MID = mjsoft007 CST_PLATFORM = service Madd = Mcompany = 덕수상사 Memail = Mname = 곽회출 SendItem = UserId = ds7098 f_point = 52500 f_price = 55000 hp1 = hp2 = hp3 = post1 = post2 = routed-from = xpay tel1 = tel2 = tel3 = x-tosspayments-global-trace-id = a240305a66eecdba4df466c8d2a95a512138b6f ========================2024-03-05 15:34:59======================== insert into mBoard_order set rOrdNo = 'Direct-ds7098-1709620433', AuthTy = 'virtual', memberId = 'ds7098', OrdNm ='곽회출', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '덕수상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'i', rCardNm = '농협 ', rApprNo = 'mjsof202403051540093XiF3', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '79019634306674', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = '', reg_date = '2024-03-05 15:34:59', InvoiceNum = '11: :Direct-ds7098-1709620433/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-05 15:34:59' ========================2024-03-05 15:43:38======================== 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 = mjsof202403051540093XiF3 LGD_MID = mjsoft007 LGD_OID = Direct-ds7098-1709620433 LGD_AMOUNT = 55000 LGD_CASTAMOUNT = 55000 LGD_CASCAMOUNT = 55000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20240305154848 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 011 LGD_FINANCENAME = 농협 LGD_ACCOUNTNUM = 79019634306674 LGD_PAYER = 덕수상사) LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = 160496315 LGD_CASHRECEIPTKIND = 1 LGD_CASHRECEIPTSELFYN = N LGD_TIMESTAMP = 20240305154849 LGD_PCANCELCNT = LGD_HASHDATA = 987240374dbfe210cde45684733141f1 LGD_CASHASHDATA = 987240374dbfe210cde45684733141f1 ========================2024-03-05 15:43:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ds7098' 0 = ds7098 Mid = ds7098 1 = 덕수상사 Mcompany = 덕수상사 2 = 412-03-63742 companyNum = 412-03-63742 3 = 061-333-7098 Mtel1 = 061-333-7098 4 = 010-3640-7098 Mhp = 010-3640-7098 ========================2024-03-05 15:43:39======================== select post_json from xpay_log where tid = 'mjsof202403051540093XiF3' and p_type = 'note_url_R' 0 = post_json = ========================2024-03-05 15:43:39======================== select count(*) as cnt from customers where id = 'ds7098' ========================2024-03-05 15:43:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ds7098','2024-03-05 15:43:38','','','온라인','0')