========================2023-03-09 10:02:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tndbs12-1678323608 LGD_BUYER = 김수윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309100008 LGD_HASHDATA = 342e681e38c316c885db0bf0a8b8fdea 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 = 202303091008103D8532FAFE90BCA3F224010DAA57B7EB9147EF0A Mname = 김수윤 Mcompany = 수복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = tndbs12 LGD_ESCROW_USEYN = N ========================2023-03-09 10:02:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309100810 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009216 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35641524****504* LGD_FINANCEAUTHNUM = 30071790 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e7926d23d5d5f6d2388a48351178e381 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230309100811 LGD_PCANCELSTR = 0 LGD_BUYER = 김수윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230309100810BdDc2 LGD_BUYERID = LGD_OID = Direct-tndbs12-1678323608 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-09 10:07:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tndbs12-1678323784 LGD_BUYER = 김수윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309100304 LGD_HASHDATA = 7501ecbd751dadb2e48bc40119bc5e50 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 = 202303091013179A5BA4A0390F13340914FE4112E12B29B8FB3932 Mname = 김수윤 Mcompany = 수복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = tndbs12 LGD_ESCROW_USEYN = N ========================2023-03-09 10:07:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309101317 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009216 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35641571****503* LGD_FINANCEAUTHNUM = 30071802 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d02442c8158954f7ed0b0628ef2194c4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230309101317 LGD_PCANCELSTR = 0 LGD_BUYER = 김수윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230309101317GkOB7 LGD_BUYERID = LGD_OID = Direct-tndbs12-1678323784 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-09 10:07:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tndbs12-1678323784 LGD_BUYER = 김수윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309100304 LGD_HASHDATA = 7501ecbd751dadb2e48bc40119bc5e50 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 = 202303091013179A5BA4A0390F13340914FE4112E12B29B8FB3932 Mname = 김수윤 Mcompany = 수복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = tndbs12 LGD_ESCROW_USEYN = N ========================2023-03-09 10:07:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309101323 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009216 LGD_RESPMSG = 요청하신 거래[주문번호:Direct-tndbs12-1678323784]는 2023/03/09 10:13:17 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = LGD_FINANCEAUTHNUM = 30071802 LGD_ESCROWYN = N LGD_TRANSAMOUNT = LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = cdfe56e10b62cf7c53b47f36254c4268 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20230309101323 LGD_PCANCELSTR = 0 LGD_BUYER = 김수윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20230309101317GkOB7 LGD_BUYERID = LGD_OID = Direct-tndbs12-1678323784 LGD_RESPCODE = S007 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 ========================2023-03-09 10:08:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1678323918 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309100518 LGD_HASHDATA = 6c7b1f6156ccadea9d22565961c06981 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 = 20230309101355864910F95634E85B557C81721E55E39260F236BD 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-03-09 10:08:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309101356 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****392* LGD_FINANCEAUTHNUM = 31372493 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 440a1b5821332725483f0064d62bf1d3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230309101357 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230309101356JuxH9 LGD_BUYERID = LGD_OID = Direct-yhk8100-1678323918 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9101356JG6r7 ========================2023-03-09 10:08:06======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1678323918', 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 = 'mjsof20230309101356JuxH9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-09 10:08:06', InvoiceNum = '결제성공:Direct-yhk8100-1678323918/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-09 10:08:06' ========================2023-03-09 10:08:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230309101356JuxH9' 0 = 1 cnt = 1 ========================2023-03-09 10:08:06======================== 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-03-09 10:08:06======================== select * from customers where id = 'yhk8100' ========================2023-03-09 10:08:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2023-03-09 10:08:06','52500','55000','온라인','0') ========================2023-03-09 15:18:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1678342613 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309151653 LGD_HASHDATA = f35bd670381dae9f364a16e2f6ef2081 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 = 202303091524053B463ED7CD8391BCF9DC35011A18CBD2E931C7A6 Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2023-03-09 15:18:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309152406 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401145****204* LGD_FINANCEAUTHNUM = 33832136 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ad310cbb96c09f8e90a677718c04504f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230309152407 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230309152406I25G0 LGD_BUYERID = LGD_OID = Direct-woorimart-1678342613 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9152406IdMw0 ========================2023-03-09 15:18:16======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1678342613', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41401145****204*', rApprNo = 'mjsof20230309152406I25G0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-09 15:18:16', InvoiceNum = '결제성공:Direct-woorimart-1678342613/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-09 15:18:16' ========================2023-03-09 15:18:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230309152406I25G0' 0 = 1 cnt = 1 ========================2023-03-09 15:18:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2023-03-09 15:18:16======================== select * from customers where id = 'woorimart' ========================2023-03-09 15:18:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2023-03-09 15:18:16','220000','220000','온라인','0') ========================2023-03-09 22:43:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dajoeng-1678369288 LGD_BUYER = 문은지 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230309224128 LGD_HASHDATA = 79c00e439f305f78915db426e2b032f0 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 = 20230309224858856CC59CE1CAE0DE5DDDE0F16C32BB07FCC972C9 Mname = 문은지 Mcompany = 다정 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dajoeng LGD_ESCROW_USEYN = N ========================2023-03-09 22:43:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230309224859 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 = 48901681****811* LGD_FINANCEAUTHNUM = 00600210 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ac3a398f9adc229b828cb164fbc86035 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230309224900 LGD_PCANCELSTR = 0 LGD_BUYER = 문은지 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202303092248590xVS0 LGD_BUYERID = LGD_OID = Direct-dajoeng-1678369288 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-09 22:43:09======================== insert into mBoard_order set rOrdNo = 'Direct-dajoeng-1678369288', AuthTy = 'card', memberId = 'dajoeng', OrdNm ='문은지', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다정', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 48901681****811*', rApprNo = 'mjsof202303092248590xVS0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-09 22:43:09', InvoiceNum = '결제성공:Direct-dajoeng-1678369288/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-09 22:43:09' ========================2023-03-09 22:43:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202303092248590xVS0' 0 = 1 cnt = 1 ========================2023-03-09 22:43:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dajoeng' 0 = dajoeng Mid = dajoeng 1 = 다정 Mcompany = 다정 2 = 760-06-01739 companyNum = 760-06-01739 3 = 031-372-4432 Mtel1 = 031-372-4432 4 = 010-5640-4432 Mhp = 010-5640-4432 ========================2023-03-09 22:43:09======================== select * from customers where id = 'dajoeng' ========================2023-03-09 22:43:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dajoeng','2023-03-09 22:43:09','108000','110000','온라인','0')