========================2023-12-08 08:44:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hiki187-1701992539 LGD_BUYER = 박승완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231208084219 LGD_HASHDATA = da299fedd597a8d0e17e740bb6f523c0 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 = 202312080848227CC68D070CA71EC8EBA05EA540E1D5146BD2C715 Mname = 박승완 Mcompany = 주식회사 하이키 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = hiki187 LGD_ESCROW_USEYN = N ========================2023-12-08 08:44:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231208084823 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = DAA67I LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****486* LGD_FINANCEAUTHNUM = 00953976 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eea560cd4c3aacf48176be64b37d9e33 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231208084823 LGD_PCANCELSTR = 0 LGD_BUYER = 박승완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231208084823q5dm8 LGD_BUYERID = LGD_OID = Direct-hiki187-1701992539 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-08 08:44:52======================== insert into mBoard_order set rOrdNo = 'Direct-hiki187-1701992539', AuthTy = 'card', memberId = 'hiki187', OrdNm ='박승완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하이키', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****486*', rApprNo = 'mjsof20231208084823q5dm8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-08 08:44:52', InvoiceNum = '결제성공:Direct-hiki187-1701992539/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-08 08:44:52' ========================2023-12-08 08:44:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231208084823q5dm8' 0 = 1 cnt = 1 ========================2023-12-08 08:44:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hiki187' 0 = hiki187 Mid = hiki187 1 = 주식회사 하이키 Mcompany = 주식회사 하이키 2 = 1148639017 companyNum = 1148639017 3 = 02-3477-1129 Mtel1 = 02-3477-1129 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2023-12-08 08:44:52======================== select * from customers where id = 'hiki187' ========================2023-12-08 08:44:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hiki187','2023-12-08 08:44:52','30900','33000','온라인','0') ========================2023-12-08 11:20:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tkfkaemf-1702001840 LGD_BUYER = 유귀형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231208111720 LGD_HASHDATA = f6a2de75a90851b6633eb390333225ff 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 = 202312081124020B073214EA32D22177737288DD38F7CEA667A253 Mname = 유귀형 Mcompany = (주)행복한사람들 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = tkfkaemf LGD_ESCROW_USEYN = N ========================2023-12-08 11:20:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231208112402 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = gfood6532@naver.com 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 = 94301671****530* LGD_FINANCEAUTHNUM = 45950736 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d103ee6c556c8a5ff9bbb41096bc895f LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231208112402 LGD_PCANCELSTR = 0 LGD_BUYER = 유귀형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231208112402GtzX5 LGD_BUYERID = LGD_OID = Direct-tkfkaemf-1702001840 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-08 11:20:31======================== insert into mBoard_order set rOrdNo = 'Direct-tkfkaemf-1702001840', AuthTy = 'card', memberId = 'tkfkaemf', OrdNm ='유귀형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)행복한사람들', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301671****530*', rApprNo = 'mjsof20231208112402GtzX5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-08 11:20:31', InvoiceNum = '결제성공:Direct-tkfkaemf-1702001840/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-08 11:20:31' ========================2023-12-08 11:20:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231208112402GtzX5' 0 = 1 cnt = 1 ========================2023-12-08 11:20:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tkfkaemf' 0 = tkfkaemf Mid = tkfkaemf 1 = (주)행복한사람들 Mcompany = (주)행복한사람들 2 = 1308705554 companyNum = 1308705554 3 = 070-4610-6532 Mtel1 = 070-4610-6532 4 = 010-3715-0304 Mhp = 010-3715-0304 ========================2023-12-08 11:20:31======================== select * from customers where id = 'tkfkaemf' ========================2023-12-08 11:20:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tkfkaemf','2023-12-08 11:20:31','108000','110000','온라인','0') ========================2023-12-08 17:10:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ts5ttogi-1702022929 LGD_BUYER = 김건우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231208170849 LGD_HASHDATA = f3f087d807b1e23afad32f51bbfe8562 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 = 2023120817135580B4D0809380C4361E0928CD5491B724E69FC75A Mname = 김건우 Mcompany = (주)태신종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ts5ttogi LGD_ESCROW_USEYN = N ========================2023-12-08 17:10:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231208171356 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****938* LGD_FINANCEAUTHNUM = 48606215 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a3429a704bae78edecca329b1eea01ce LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231208171357 LGD_PCANCELSTR = 0 LGD_BUYER = 김건우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231208171356eDE84 LGD_BUYERID = LGD_OID = Direct-ts5ttogi-1702022929 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8171356eQFC8 ========================2023-12-08 17:10:25======================== insert into mBoard_order set rOrdNo = 'Direct-ts5ttogi-1702022929', AuthTy = 'card', memberId = 'ts5ttogi', OrdNm ='김건우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태신종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****938*', rApprNo = 'mjsof20231208171356eDE84', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-08 17:10:25', InvoiceNum = '결제성공:Direct-ts5ttogi-1702022929/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-08 17:10:25' ========================2023-12-08 17:10:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231208171356eDE84' 0 = 1 cnt = 1 ========================2023-12-08 17:10:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ts5ttogi' 0 = ts5ttogi Mid = ts5ttogi 1 = (주)태신종합물류 Mcompany = (주)태신종합물류 2 = 6918600886 companyNum = 6918600886 3 = 010-4841-6383 Mtel1 = 010-4841-6383 4 = 010-3350-6383 Mhp = 010-3350-6383 ========================2023-12-08 17:10:25======================== select * from customers where id = 'ts5ttogi' ========================2023-12-08 17:10:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ts5ttogi','2023-12-08 17:10:25','220000','220000','온라인','0') ========================2023-12-08 17:18:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1702023380 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231208171620 LGD_HASHDATA = afb8ca9dc9833e19bc1506042ebdb6cb 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 = 202312081722018E22833535E16137EF81030D18DDBCD453298410 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 ========================2023-12-08 17:18:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231208172201 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****392* LGD_FINANCEAUTHNUM = 48664880 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d23ec27f5a3642b777def873189becd6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231208172202 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231208172201eEs84 LGD_BUYERID = LGD_OID = Direct-yhk8100-1702023380 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8172201eQUT5 ========================2023-12-08 17:18:30======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1702023380', 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 = 'mjsof20231208172201eEs84', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-08 17:18:30', InvoiceNum = '결제성공:Direct-yhk8100-1702023380/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-08 17:18:30' ========================2023-12-08 17:18:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231208172201eEs84' 0 = 1 cnt = 1 ========================2023-12-08 17:18:30======================== 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 ========================2023-12-08 17:18:30======================== select * from customers where id = 'yhk8100' ========================2023-12-08 17:18:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2023-12-08 17:18:30','52500','55000','온라인','0') ========================2023-12-08 17:26:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hara-1702023934 LGD_BUYER = 박태진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231208172534 LGD_HASHDATA = c5256aa541ff99c4f7b6bb2dcb23d6ae 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 = 2023120817300460135E278A951EA4438BF075714C740A972756E4 Mname = 박태진 Mcompany = 주식회사 하라 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hara LGD_ESCROW_USEYN = N ========================2023-12-08 17:26:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231208173004 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hara5002@gmail.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 496C0C LGD_AFFILIATECODE = 755342 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400309****791* LGD_FINANCEAUTHNUM = 48731062 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f3239072e6c8a9bff306e0e6c1345ebb LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231208173005 LGD_PCANCELSTR = 0 LGD_BUYER = 박태진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231208173004dyeZ5 LGD_BUYERID = LGD_OID = Direct-hara-1702023934 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8173004dE2B1 ========================2023-12-08 17:26:33======================== insert into mBoard_order set rOrdNo = 'Direct-hara-1702023934', AuthTy = 'card', memberId = 'hara', OrdNm ='박태진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하라', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400309****791*', rApprNo = 'mjsof20231208173004dyeZ5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-08 17:26:33', InvoiceNum = '결제성공:Direct-hara-1702023934/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-08 17:26:33' ========================2023-12-08 17:26:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231208173004dyeZ5' 0 = 1 cnt = 1 ========================2023-12-08 17:26:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hara' 0 = hara Mid = hara 1 = 주식회사 하라 Mcompany = 주식회사 하라 2 = 6248700715 companyNum = 6248700715 3 = 061-278-5144 Mtel1 = 061-278-5144 4 = 010-8700-5002 Mhp = 010-8700-5002 ========================2023-12-08 17:26:33======================== select * from customers where id = 'hara' ========================2023-12-08 17:26:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hara','2023-12-08 17:26:33','220000','220000','온라인','0')