========================2022-09-06 10:51:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-serin3114-1662428991 LGD_BUYER = 용예림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220906104951 LGD_HASHDATA = 911b5495c9f4d13dca3b4098ea494757 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220906105341F62099602F5F1B5A8A7F8E52ECA98C89AB710503 Mname = 용예림 Mcompany = 세린축산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = serin3114 LGD_ESCROW_USEYN = N ========================2022-09-06 10:51:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220906105342 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55317104****509* LGD_FINANCEAUTHNUM = 53118471 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 604faf945f0c9730df5aeb031c94dab8 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220906105343 LGD_PCANCELSTR = 0 LGD_BUYER = 용예림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220906105342QBg00 LGD_BUYERID = LGD_OID = Direct-serin3114-1662428991 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-06 10:51:16======================== insert into mBoard_order set rOrdNo = 'Direct-serin3114-1662428991', AuthTy = 'card', memberId = 'serin3114', OrdNm ='용예림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세린축산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317104****509*', rApprNo = 'mjsof20220906105342QBg00', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-06 10:51:16', InvoiceNum = '결제성공:Direct-serin3114-1662428991/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-06 10:51:16' ========================2022-09-06 10:51:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220906105342QBg00' 0 = 1 cnt = 1 ========================2022-09-06 10:51:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'serin3114' 0 = serin3114 Mid = serin3114 1 = 세린축산 Mcompany = 세린축산 2 = 437-22-01182 companyNum = 437-22-01182 3 = 010-3114-4559 Mtel1 = 010-3114-4559 4 = 010-5624-8318 Mhp = 010-5624-8318 ========================2022-09-06 10:51:16======================== select * from customers where id = 'serin3114' ========================2022-09-06 10:51:16======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('serin3114','세린축산','4372201182','010-3114-4559','010-5624-8318','2022-09-06 10:51:16','온라인') ========================2022-09-06 10:51:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('serin3114','2022-09-06 10:51:16','52500','55000','온라인','0') ========================2022-09-06 12:52:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1662436260 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220906125101 LGD_HASHDATA = c095d46395bbaecae90b9597229203b2 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202209061254315C1319FA5FC8DF22D9C7C7E4489BF2A033706469 Mname = 이정훈 Mcompany = (주)신협상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yhk8100 LGD_ESCROW_USEYN = N ========================2022-09-06 12:52:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220906125432 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****392* LGD_FINANCEAUTHNUM = 52399825 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8ef3a2f537720d8aaff6e90a98d7e354 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220906125432 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220906125431jDpK2 LGD_BUYERID = LGD_OID = Direct-yhk8100-1662436260 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6125431j7gr7 ========================2022-09-06 12:52:05======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1662436260', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300306****392*', rApprNo = 'mjsof20220906125431jDpK2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-06 12:52:05', InvoiceNum = '결제성공:Direct-yhk8100-1662436260/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-06 12:52:05' ========================2022-09-06 12:52:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220906125431jDpK2' 0 = 1 cnt = 1 ========================2022-09-06 12:52:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yhk8100' 0 = yhk8100 Mid = yhk8100 1 = (주)신협상사 Mcompany = (주)신협상사 2 = 1288158323 companyNum = 1288158323 3 = 02-381-8100 Mtel1 = 02-381-8100 4 = 011-9834-3324 Mhp = 011-9834-3324 ========================2022-09-06 12:52:05======================== select * from customers where id = 'yhk8100' ========================2022-09-06 12:52:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2022-09-06 12:52:05','52500','55000','온라인','0') ========================2022-09-06 13:39:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjw1439-1662439092 LGD_BUYER = 박흥수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220906133812 LGD_HASHDATA = 2b5e5bc79f17b0bdd02e1308632c624a LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220906134131A908F1A0289419FD79990E523D407F9C75EDC481 Mname = 박흥수 Mcompany = (주)모닝에프디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = pjw1439 LGD_ESCROW_USEYN = N ========================2022-09-06 13:39:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220906134131 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42890993****202* LGD_FINANCEAUTHNUM = 31754148 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d7b6b2db7ce4afba3f922ff1b784c606 LGD_BUYERADDRESS = LGD_FINANCENAME = 외환VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20220906134131 LGD_PCANCELSTR = 0 LGD_BUYER = 박흥수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220906134131jJq68 LGD_BUYERID = LGD_OID = Direct-pjw1439-1662439092 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-06 13:39:04======================== insert into mBoard_order set rOrdNo = 'Direct-pjw1439-1662439092', AuthTy = 'card', memberId = 'pjw1439', OrdNm ='박흥수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)모닝에프디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '외환VISA 42890993****202*', rApprNo = 'mjsof20220906134131jJq68', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-06 13:39:04', InvoiceNum = '결제성공:Direct-pjw1439-1662439092/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-06 13:39:04' ========================2022-09-06 13:39:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220906134131jJq68' 0 = 1 cnt = 1 ========================2022-09-06 13:39:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pjw1439' 0 = pjw1439 Mid = pjw1439 1 = (주)모닝에프디 Mcompany = (주)모닝에프디 2 = 4328800262 companyNum = 4328800262 3 = 010-4820-4572 Mtel1 = 010-4820-4572 4 = 010-2545-9942 Mhp = 010-2545-9942 ========================2022-09-06 13:39:04======================== select * from customers where id = 'pjw1439' ========================2022-09-06 13:39:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pjw1439','2022-09-06 13:39:04','52500','55000','온라인','0') ========================2022-09-06 17:53:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dream1admin-1662454344 LGD_BUYER = 김영석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220906175224 LGD_HASHDATA = 9152ec764c54e3dc16bf990e9e5f2eb8 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022090617554718E4E105831377F0D9C8F55A91E498574DB707FD Mname = 김영석 Mcompany = 드림엠앤에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dream1admin LGD_ESCROW_USEYN = N ========================2022-09-06 17:53:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220906175548 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****124* LGD_FINANCEAUTHNUM = 12561785 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 942a8ab9973c7f9b368165ffb19368f6 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220906175549 LGD_PCANCELSTR = 0 LGD_BUYER = 김영석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220906175548iMEc4 LGD_BUYERID = LGD_OID = Direct-dream1admin-1662454344 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-06 17:53:21======================== insert into mBoard_order set rOrdNo = 'Direct-dream1admin-1662454344', AuthTy = 'card', memberId = 'dream1admin', OrdNm ='김영석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '드림엠앤에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****124*', rApprNo = 'mjsof20220906175548iMEc4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-06 17:53:21', InvoiceNum = '결제성공:Direct-dream1admin-1662454344/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-06 17:53:21' ========================2022-09-06 17:53:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220906175548iMEc4' 0 = 1 cnt = 1 ========================2022-09-06 17:53:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dream1admin' 0 = dream1admin Mid = dream1admin 1 = 드림엠앤에스 Mcompany = 드림엠앤에스 2 = 2638100288 companyNum = 2638100288 3 = 010-9095-8778 Mtel1 = 010-9095-8778 4 = 010-8814-6666 Mhp = 010-8814-6666 ========================2022-09-06 17:53:22======================== select * from customers where id = 'dream1admin' ========================2022-09-06 17:53:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dream1admin','2022-09-06 17:53:21','108000','110000','온라인','0') ========================2022-09-06 20:58:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-vnem103-1662465254 LGD_BUYER = 엄형섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220906205414 LGD_HASHDATA = deccc7947671db3947ab926ba1111bd4 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022090621004923DF064305D08E3AD75258F93E772686E7F92BB1 Mname = 엄형섭 Mcompany = 청아푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = vnem103 LGD_ESCROW_USEYN = N ========================2022-09-06 20:58:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220906210050 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94100900****751* LGD_FINANCEAUTHNUM = 20626879 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5ebbd1802dd1c122c12b8b27df1ec35d LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20220906210050 LGD_PCANCELSTR = 0 LGD_BUYER = 엄형섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220906210050hjRG4 LGD_BUYERID = LGD_OID = Direct-vnem103-1662465254 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-09-06 20:58:23======================== insert into mBoard_order set rOrdNo = 'Direct-vnem103-1662465254', AuthTy = 'card', memberId = 'vnem103', OrdNm ='엄형섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '청아푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성 94100900****751*', rApprNo = 'mjsof20220906210050hjRG4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-09-06 20:58:23', InvoiceNum = '결제성공:Direct-vnem103-1662465254/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-09-06 20:58:23' ========================2022-09-06 20:58:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220906210050hjRG4' 0 = 1 cnt = 1 ========================2022-09-06 20:58:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'vnem103' 0 = vnem103 Mid = vnem103 1 = 청아푸드 Mcompany = 청아푸드 2 = 4491101928 companyNum = 4491101928 3 = 010-6577-1022 Mtel1 = 010-6577-1022 4 = 010-6577-1022 Mhp = 010-6577-1022 ========================2022-09-06 20:58:23======================== select * from customers where id = 'vnem103' ========================2022-09-06 20:58:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('vnem103','2022-09-06 20:58:23','52500','55000','온라인','0')