========================2020-02-28 11:53:38======================== noteurl_start LGD_BUYER = 박성훈 LGD_PRODUCTINFO = 조이렌트[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01063614316 LGD_BUYEREMAIL = piagetkidsacademy@naver.com LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_CLOSEDATE = LGD_TID = mjsof2020022811534660223 LGD_MID = mjsoft007 LGD_OID = PRO-A-GUEST-010411089-1582858088 LGD_AMOUNT = 220000 LGD_CASTAMOUNT = 0 LGD_CASCAMOUNT = 0 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20200228115346 LGD_RESPCODE = 0000 LGD_RESPMSG = 03: LGD_FINANCECODE = 003 LGD_FINANCENAME = 기업 LGD_ACCOUNTNUM = 06501242597154 LGD_PAYER = 에이치피씨지 LGD_CASSEQNO = 000 LGD_CASFLAG = R LGD_ESCROWYN = Y LGD_TIMESTAMP = 20200228115346 LGD_HASHDATA = ae2b11dd6f6952450bf63fe1fdcd0f9e CST_MID = mjsoft007 CST_PLATFORM = service Madd = 서울 강동구 고덕로83길 154 (고덕동) 1층 Mcompany = 피아제키즈아카데미 Memail = Mname = 박성훈 ProductCode = 010411089 SendItem = UserId = GUEST category_code = 010411 f_price = 220000 hp1 = hp2 = hp3 = mode = 1 post1 = 05221 post2 = tel1 = 02 tel2 = 442 tel3 = 7008 ========================2020-02-28 11:53:38======================== 1: insert into mBoard_order set rOrdNo = 'PRO-A-GUEST-010411089-1582858088', AuthTy = 'virtual', memberId = 'GUEST', OrdNm ='박성훈', OrdPhone = '02-442-7008', OrdPhone2 = '--', UserEmail = '', DlvAddr = '서울 강동구 고덕로83길 154 (고덕동) 1층', DlvPost = '05221', OrdComp = '피아제키즈아카데미', ProductCode = '010411089', rProdNm = '조이렌트[1人用] 옵션:', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'i', rCardNm = '기업 ', rApprNo = 'mjsof2020022811534660223', ICHE_OUTBANKNAME = '//', ICHE_OUTACCTNO = '06501242597154', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = 'R', Pcnt = 'Y', reg_date = '2020-02-28 11:53:38', InvoiceNum = '03: :PRO-A-GUEST-010411089-1582858088/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2020-02-28 11:53:38' ========================2020-02-28 11:53:38======================== 2:OK ========================2020-02-28 12:15:22======================== noteurl_start LGD_BUYER = 박성훈 LGD_PRODUCTINFO = 조이렌트[1人用] 옵션: LGD_BUYERID = LGD_BUYERADDRESS = LGD_BUYERPHONE = 01063614316 LGD_BUYEREMAIL = piagetkidsacademy@naver.com LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_RECEIVER = LGD_RECEIVERPHONE = LGD_DELIVERYINFO = LGD_TID = mjsof2020022811534660223 LGD_MID = mjsoft007 LGD_OID = PRO-A-GUEST-010411089-1582858088 LGD_AMOUNT = 220000 LGD_CASTAMOUNT = 220000 LGD_CASCAMOUNT = 220000 LGD_PAYTYPE = SC0040 LGD_PAYDATE = 20200228121530 LGD_RESPCODE = 0000 LGD_RESPMSG = LGD_FINANCECODE = 003 LGD_FINANCENAME = 기업 LGD_ACCOUNTNUM = 06501242597154 LGD_PAYER = （주）에이치 LGD_CASSEQNO = 001 LGD_CASFLAG = I LGD_CASHRECEIPTNUM = 158859104 LGD_CASHRECEIPTKIND = 1 LGD_CASHRECEIPTSELFYN = N LGD_TIMESTAMP = 20200228121530 LGD_PCANCELCNT = LGD_HASHDATA = 7d54bff0b2b9ccd252e8338f8dbdde99 LGD_CASHASHDATA = 7d54bff0b2b9ccd252e8338f8dbdde99 ========================2020-02-28 12:15:22======================== update mBoard_order set rSuccYn = 'y', ICHE_OUTBANKNAME = '158859104/N/吏�異쒖쬆鍮�', bank = 'I', ICHE_AMOUNT = '220000/20200228121530' , mod_date = '2020-02-28 12:15:22' where rOrdNo = 'PRO-A-GUEST-010411089-1582858088' ========================2020-02-28 12:15:23======================== select post_json from xpay_log where tid = 'mjsof2020022811534660223' and p_type = 'note_url_R' 0 = post_json = ========================2020-02-28 12:15:23======================== select certi_num from certinumManage WHERE category_code = '' ========================2020-02-28 12:15:23======================== update member set Certi_num ='', End_day ='', Start_day='',Mdiv='2',Mup='1',Msw1='',Mper='1' where Mid ='' ========================2020-02-28 12:15:23======================== 2:OK