========================2024-02-29 11:00:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1709171926 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240229105846 LGD_HASHDATA = efb8a87241e435cb6ceb07b1e87c0159 LGD_RETURNURL = https://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2024022911053997DDA41DFD069BF937E30393B8AFE4C742F5AA34 Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2024-02-29 11:00:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240229110539 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kyg30000@daum.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353104****161* LGD_FINANCEAUTHNUM = 28273904 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8592d93e6abe8e0bfd44f903ba731503 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240229110540 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240229110539XdvC2 LGD_BUYERID = LGD_OID = Direct-kyg2031-1709171926 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 291105291299 ========================2024-02-29 11:00:36======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1709171926', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '전북MASTER 55353104****161*', rApprNo = 'mjsof20240229110539XdvC2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-29 11:00:36', InvoiceNum = '결제성공:Direct-kyg2031-1709171926/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-29 11:00:36' ========================2024-02-29 11:00:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240229110539XdvC2' 0 = 1 cnt = 1 ========================2024-02-29 11:00:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-6796-1030 Mhp = 010-6796-1030 ========================2024-02-29 11:00:36======================== select * from customers where id = 'kyg2031' ========================2024-02-29 11:00:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2024-02-29 11:00:36','108000','110000','온라인','0') ========================2024-02-29 11:21:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-thanks018-1709173201 LGD_BUYER = 강동훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240229112001 LGD_HASHDATA = 8bf1cc6b3b3d1cfc80d7028e15493ae0 LGD_RETURNURL = https://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202402291126105D1A35EEC463C4DC1341AF3CB847794E66E185FA Mname = 강동훈 Mcompany = (주)비전정보전산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = thanks018 LGD_ESCROW_USEYN = N ========================2024-02-29 11:21:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240229112611 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55317203****507* LGD_FINANCEAUTHNUM = 67257241 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 44b39057eb95521728f130e65a7031c2 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240229112611 LGD_PCANCELSTR = 0 LGD_BUYER = 강동훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240229112611TXD26 LGD_BUYERID = LGD_OID = Direct-thanks018-1709173201 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-29 11:21:07======================== insert into mBoard_order set rOrdNo = 'Direct-thanks018-1709173201', AuthTy = 'card', memberId = 'thanks018', OrdNm ='강동훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비전정보전산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317203****507*', rApprNo = 'mjsof20240229112611TXD26', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-29 11:21:07', InvoiceNum = '결제성공:Direct-thanks018-1709173201/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-29 11:21:07' ========================2024-02-29 11:21:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240229112611TXD26' 0 = 1 cnt = 1 ========================2024-02-29 11:21:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'thanks018' 0 = thanks018 Mid = thanks018 1 = (주)비전정보전산 Mcompany = (주)비전정보전산 2 = 418-81-36163 companyNum = 418-81-36163 3 = 063-214-1911 Mtel1 = 063-214-1911 4 = 018-281-5525 Mhp = 018-281-5525 ========================2024-02-29 11:21:07======================== select * from customers where id = 'thanks018' ========================2024-02-29 11:21:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('thanks018','2024-02-29 11:21:07','220000','220000','온라인','0') ========================2024-02-29 12:18:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nodazi90-1709176570 LGD_BUYER = 정희우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240229121610 LGD_HASHDATA = 3c18f329cfe033eb141048b4b9cc44e9 LGD_RETURNURL = https://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240229122337AB7B6646FF0F0B3BBB30C1E370508943B0DCDEF7 Mname = 정희우 Mcompany = 노다지(NODAZI) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nodazi90 LGD_ESCROW_USEYN = N ========================2024-02-29 12:18:34======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20240229122338 LGD_BUYEREMAIL = 01088336574@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 557042********** LGD_FINANCEAUTHNUM = 30107290 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7d3a14e7de6e4d9d5cea2ee5a1e45f61 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240229122338 LGD_PCANCELSTR = 0 LGD_BUYER = 정희우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20240229122316nF8F3 LGD_BUYERID = LGD_OID = Direct-nodazi90-1709176570 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-29 12:18:34======================== insert into mBoard_order set rOrdNo = 'Direct-nodazi90-1709176570', AuthTy = 'card', memberId = 'nodazi90', OrdNm ='정희우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '노다지(NODAZI)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민 557042**********', rApprNo = 'mjsof20240229122316nF8F3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-29 12:18:34', InvoiceNum = '결제성공:Direct-nodazi90-1709176570/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-29 12:18:34' ========================2024-02-29 12:18:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240229122316nF8F3' 0 = 1 cnt = 1 ========================2024-02-29 12:18:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nodazi90' 0 = nodazi90 Mid = nodazi90 1 = 노다지(NODAZI) Mcompany = 노다지(NODAZI) 2 = 5590601973 companyNum = 5590601973 3 = 010-8833-6574 Mtel1 = 010-8833-6574 4 = 010-8833-6574 Mhp = 010-8833-6574 ========================2024-02-29 12:18:34======================== select * from customers where id = 'nodazi90' ========================2024-02-29 12:18:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nodazi90','2024-02-29 12:18:34','108000','110000','온라인','0') ========================2024-02-29 15:24:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1709187776 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240229152256 LGD_HASHDATA = d5cac45a29a8b7e597ca1450e50b94d1 LGD_RETURNURL = https://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240229152912302D2173B6C89DFD20FE51BD21EA509CCE6F42CB Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2024-02-29 15:24:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240229152913 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 53279300****761* LGD_FINANCEAUTHNUM = 00213499 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 587dc2660b61b199ae698c0fa8174b49 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240229152913 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240229152912ZFo02 LGD_BUYERID = LGD_OID = Direct-ds2avq-1709187776 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-29 15:24:08======================== insert into mBoard_order set rOrdNo = 'Direct-ds2avq-1709187776', AuthTy = 'card', memberId = 'ds2avq', OrdNm ='김기철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '화일정보산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 53279300****761*', rApprNo = 'mjsof20240229152912ZFo02', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-29 15:24:08', InvoiceNum = '결제성공:Direct-ds2avq-1709187776/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-29 15:24:08' ========================2024-02-29 15:24:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240229152912ZFo02' 0 = 1 cnt = 1 ========================2024-02-29 15:24:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ds2avq' 0 = ds2avq Mid = ds2avq 1 = 화일정보산업 Mcompany = 화일정보산업 2 = 1341391987 companyNum = 1341391987 3 = 031-439-2800 Mtel1 = 031-439-2800 4 = 010-7707-6519 Mhp = 010-7707-6519 ========================2024-02-29 15:24:08======================== select * from customers where id = 'ds2avq' ========================2024-02-29 15:24:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ds2avq','2024-02-29 15:24:08','108000','110000','온라인','0') ========================2024-02-29 20:35:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1709206457 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240229203417 LGD_HASHDATA = fd397281081eaf7db914c3b40ba8b9f4 LGD_RETURNURL = https://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202402292040496022B36A888068824DDAB9D45EB9CD0A0594CE62 Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2024-02-29 20:35:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240229204050 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37029923****52* LGD_FINANCEAUTHNUM = 00168373 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1a9e367d616896f3594a4eacb6519fc3 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240229204050 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240229204050Xiwj5 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1709206457 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-02-29 20:35:45======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1709206457', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029923****52*', rApprNo = 'mjsof20240229204050Xiwj5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-02-29 20:35:45', InvoiceNum = '결제성공:Direct-ksm03172002-1709206457/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-02-29 20:35:45' ========================2024-02-29 20:35:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240229204050Xiwj5' 0 = 1 cnt = 1 ========================2024-02-29 20:35:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2024-02-29 20:35:45======================== select * from customers where id = 'ksm03172002' ========================2024-02-29 20:35:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2024-02-29 20:35:45','30900','33000','온라인','0')