========================2025-04-02 09:42:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1743554494 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402094134 LGD_HASHDATA = 5f879f74d5a28d158e55662b6add1726 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 = 20250402094456E10C250821699C819BC75D2B4D53F4B1E2F31E4F Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-04-02 09:42:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402094457 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 = 94301703****448* LGD_FINANCEAUTHNUM = 56781756 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4ed0e8f0efb44450b3cb462ff62218c1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250402094457 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402094456j2xY4 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1743554494 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 09:42:24======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1743554494', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20250402094456j2xY4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 09:42:24', InvoiceNum = '결제성공:Direct-goodssal5707-1743554494/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 09:42:24' ========================2025-04-02 09:42:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402094456j2xY4' 0 = 1 cnt = 1 ========================2025-04-02 09:42:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-04-02 09:42:24======================== select * from customers where id = 'goodssal5707' ========================2025-04-02 09:42:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-04-02 09:42:24','220000','220000','온라인','0') ========================2025-04-02 09:43:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1743554553 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402094233 LGD_HASHDATA = 9695a826f4a39bbaf1350b5013e62fc4 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 = 202504020945458FDEB7B60163F77518363EBDB4278655C1D38257 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-04-02 09:43:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402094545 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 = 94301703****448* LGD_FINANCEAUTHNUM = 56788873 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e068276fa70fe63f2fdf4bd467ecc254 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250402094546 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402094545rTlK8 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1743554553 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 09:43:12======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1743554553', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20250402094545rTlK8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 09:43:12', InvoiceNum = '결제성공:Direct-goodssal5707-1743554553/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 09:43:12' ========================2025-04-02 09:43:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402094545rTlK8' 0 = 1 cnt = 1 ========================2025-04-02 09:43:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-04-02 09:43:13======================== select * from customers where id = 'goodssal5707' ========================2025-04-02 09:43:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-04-02 09:43:12','108000','110000','온라인','0') ========================2025-04-02 09:45:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodfood2023-1743554644 LGD_BUYER = 최상용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402094404 LGD_HASHDATA = cc963e2b6dcc66bdd4d426cc39d1ce5c 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 = 20250402094804F4F5E36C74371B32116DA65ACBF59ABD96EA5419 Mname = 최상용 Mcompany = 좋은푸드컬리주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = goodfood2023 LGD_ESCROW_USEYN = N ========================2025-04-02 09:45:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402094805 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****697* LGD_FINANCEAUTHNUM = 32462019 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7f6903e5d06e3ab8f4b83017895cd717 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250402094806 LGD_PCANCELSTR = 0 LGD_BUYER = 최상용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402094805h04I2 LGD_BUYERID = LGD_OID = Direct-goodfood2023-1743554644 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2094805hMDZ1 ========================2025-04-02 09:45:32======================== insert into mBoard_order set rOrdNo = 'Direct-goodfood2023-1743554644', AuthTy = 'card', memberId = 'goodfood2023', OrdNm ='최상용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '좋은푸드컬리주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****697*', rApprNo = 'mjsof20250402094805h04I2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 09:45:32', InvoiceNum = '결제성공:Direct-goodfood2023-1743554644/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 09:45:32' ========================2025-04-02 09:45:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402094805h04I2' 0 = 1 cnt = 1 ========================2025-04-02 09:45:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodfood2023' 0 = goodfood2023 Mid = goodfood2023 1 = 좋은푸드컬리주식회사 Mcompany = 좋은푸드컬리주식회사 2 = 112-86-02741 companyNum = 112-86-02741 3 = 010-8880-9146 Mtel1 = 010-8880-9146 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-04-02 09:45:32======================== select * from customers where id = 'goodfood2023' ========================2025-04-02 09:45:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodfood2023','2025-04-02 09:45:32','30900','33000','온라인','0') ========================2025-04-02 10:21:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanakk-1743556767 LGD_BUYER = 이성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402101927 LGD_HASHDATA = 31f410e1648ab1043e926a6a1f819ff4 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 = 20250402102338358CCB60C45F3F75E9D4412ADE7D200960D721C5 Mname = 이성희 Mcompany = (주)하나계기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hanakk LGD_ESCROW_USEYN = N ========================2025-04-02 10:21:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402102338 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****370* LGD_FINANCEAUTHNUM = 32677921 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cf08ec2e2fe6feb989c6107d0617b15e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250402102339 LGD_PCANCELSTR = 0 LGD_BUYER = 이성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402102338cyFH1 LGD_BUYERID = LGD_OID = Direct-hanakk-1743556767 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2102338cVJe2 ========================2025-04-02 10:21:05======================== insert into mBoard_order set rOrdNo = 'Direct-hanakk-1743556767', AuthTy = 'card', memberId = 'hanakk', OrdNm ='이성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)하나계기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****370*', rApprNo = 'mjsof20250402102338cyFH1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 10:21:05', InvoiceNum = '결제성공:Direct-hanakk-1743556767/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 10:21:05' ========================2025-04-02 10:21:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402102338cyFH1' 0 = 1 cnt = 1 ========================2025-04-02 10:21:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanakk' 0 = hanakk Mid = hanakk 1 = (주)하나계기 Mcompany = (주)하나계기 2 = 504-81-59526 companyNum = 504-81-59526 3 = 053-254-0101 Mtel1 = 053-254-0101 4 = 010-4934-2791 Mhp = 010-4934-2791 ========================2025-04-02 10:21:05======================== select * from customers where id = 'hanakk' ========================2025-04-02 10:21:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanakk','2025-04-02 10:21:05','108000','110000','온라인','0') ========================2025-04-02 11:16:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin1-1743560134 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402111534 LGD_HASHDATA = 63cf14fac6db6b854d66dcab4ebf9461 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 = 20250402111901D9738A522ACEBA39CD5D856CF9E0473572BBA11F Mname = 김다영 Mcompany = 금진포장 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = 금진포장으로 계산서발행 UserId = gumjin1 LGD_ESCROW_USEYN = N ========================2025-04-02 11:16:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402111902 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 425d8115ed34a3e4daa125b90dd7846f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250402111902 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202504021119027dJP3 LGD_BUYERID = LGD_OID = Direct-gumjin1-1743560134 LGD_RESPCODE = 3000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 11:18:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin1-1743560269 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402111749 LGD_HASHDATA = 5744d4ade24a50f46b6cadacb1f1f5f5 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 = 20250402112053D508281D0B42DC1138CF279683F9379EE6DD215E Mname = 김다영 Mcompany = 금진포장 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = 금진포장으로 계산서발행 UserId = gumjin1 LGD_ESCROW_USEYN = N ========================2025-04-02 11:18:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402112053 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = 09940278 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c5b65b83d6b58fef90050d2d2bc40844 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250402112054 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202504021120539PzR7 LGD_BUYERID = LGD_OID = Direct-gumjin1-1743560269 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 11:18:20======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin1-1743560269', AuthTy = 'card', memberId = 'gumjin1', OrdNm ='김다영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금진포장', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof202504021120539PzR7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 11:18:20', InvoiceNum = '결제성공:Direct-gumjin1-1743560269/0000', Deliver = '', senditem = '금진포장으로 계산서발행', salestopvalue = '', mod_date = '2025-04-02 11:18:20' ========================2025-04-02 11:18:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202504021120539PzR7' 0 = 1 cnt = 1 ========================2025-04-02 11:18:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin1' 0 = gumjin1 Mid = gumjin1 1 = 금진윤활유 Mcompany = 금진윤활유 2 = 1261585310 companyNum = 1261585310 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2025-04-02 11:18:21======================== select * from customers where id = 'gumjin1' ========================2025-04-02 11:18:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin1','2025-04-02 11:18:20','108000','110000','온라인','0') ========================2025-04-02 12:42:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-todamls-1743565296 LGD_BUYER = 유대웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402124136 LGD_HASHDATA = c673428edeba5e4d54121e0655f5121c 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 = 20250402124459B75B9885C9F68D77F98CB57695207E218EB4148B Mname = 유대웅 Mcompany = (주)토담유통상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = todamls LGD_ESCROW_USEYN = N ========================2025-04-02 12:42:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402124500 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 51107002****015* LGD_FINANCEAUTHNUM = 20269025 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a59610c29220124895f3239e9c7d30bf LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250402124500 LGD_PCANCELSTR = 0 LGD_BUYER = 유대웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2025040212450047TZ9 LGD_BUYERID = LGD_OID = Direct-todamls-1743565296 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 021245625809 ========================2025-04-02 12:42:27======================== insert into mBoard_order set rOrdNo = 'Direct-todamls-1743565296', AuthTy = 'card', memberId = 'todamls', OrdNm ='유대웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토담유통상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '전북MASTER 51107002****015*', rApprNo = 'mjsof2025040212450047TZ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 12:42:27', InvoiceNum = '결제성공:Direct-todamls-1743565296/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 12:42:27' ========================2025-04-02 12:42:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025040212450047TZ9' 0 = 1 cnt = 1 ========================2025-04-02 12:42:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'todamls' 0 = todamls Mid = todamls 1 = (주)토담유통상사 Mcompany = (주)토담유통상사 2 = 403-81-36254 companyNum = 403-81-36254 3 = 063-837-7799 Mtel1 = 063-837-7799 4 = 010-9626-7293 Mhp = 010-9626-7293 ========================2025-04-02 12:42:27======================== select * from customers where id = 'todamls' ========================2025-04-02 12:42:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('todamls','2025-04-02 12:42:27','30900','33000','온라인','0') ========================2025-04-02 13:35:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-familyfood24-1743567373 LGD_BUYER = LI ROMAN LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402131613 LGD_HASHDATA = 107ca845b257ba0de1572169f8236c4d 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 = 20250402133756D3B763FEC4E8B613926083BEC395B27486597318 Mname = LI ROMAN Mcompany = 주식회사 패밀리푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = familyfood24 LGD_ESCROW_USEYN = N ========================2025-04-02 13:35:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402133757 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = familyfood82@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 = 53390900****614* LGD_FINANCEAUTHNUM = 82400703 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = W1200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 274d4b7ec5080ea92b37230e41956d39 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = W1 LGD_DEVICE = LGD_TIMESTAMP = 20250402133758 LGD_PCANCELSTR = 0 LGD_BUYER = LI ROMAN LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402133757MaPA8 LGD_BUYERID = LGD_OID = Direct-familyfood24-1743567373 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 13:35:24======================== insert into mBoard_order set rOrdNo = 'Direct-familyfood24-1743567373', AuthTy = 'card', memberId = 'familyfood24', OrdNm ='LI ROMAN', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 패밀리푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 53390900****614*', rApprNo = 'mjsof20250402133757MaPA8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 13:35:24', InvoiceNum = '결제성공:Direct-familyfood24-1743567373/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 13:35:24' ========================2025-04-02 13:35:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402133757MaPA8' 0 = 1 cnt = 1 ========================2025-04-02 13:35:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'familyfood24' 0 = familyfood24 Mid = familyfood24 1 = 주식회사 패밀리푸드 Mcompany = 주식회사 패밀리푸드 2 = 1558603067 companyNum = 1558603067 3 = 010-7652-2982 Mtel1 = 010-7652-2982 4 = 010-7652-2982 Mhp = 010-7652-2982 ========================2025-04-02 13:35:24======================== select * from customers where id = 'familyfood24' ========================2025-04-02 13:35:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('familyfood24','2025-04-02 13:35:24','220000','220000','온라인','0') ========================2025-04-02 14:09:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1743570504 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402140824 LGD_HASHDATA = 7245946ab99beff61dfbf7de25aa4a4e 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 = 20250402141147636234E5F56D5A80081268348F12A48D0E49EB3A Mname = 박재호 Mcompany = (주)극광사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2025-04-02 14:09:15======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250402141148 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91002003****975* LGD_FINANCEAUTHNUM = 34698835 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ecd95a33e91e947ee155745f0d5cf7ad LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250402141148 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402141133yQdy8 LGD_BUYERID = LGD_OID = Direct-parkco6338-1743570504 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 14:09:15======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1743570504', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)극광사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨 91002003****975*', rApprNo = 'mjsof20250402141133yQdy8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 14:09:15', InvoiceNum = '결제성공:Direct-parkco6338-1743570504/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 14:09:15' ========================2025-04-02 14:09:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402141133yQdy8' 0 = 1 cnt = 1 ========================2025-04-02 14:09:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = (주)극광사 Mcompany = (주)극광사 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2025-04-02 14:09:15======================== select * from customers where id = 'parkco6338' ========================2025-04-02 14:09:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2025-04-02 14:09:15','220000','220000','온라인','0') ========================2025-04-02 15:57:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ss9699-1743576887 LGD_BUYER = 이재경 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250402155447 LGD_HASHDATA = c8171cbad51f9e78c4c9926e1271dc11 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 = 20250402155941B73A51C02E5EC37A0D1BFA91594404C1268EC706 Mname = 이재경 Mcompany = 주식회사성원스토어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ss9699 LGD_ESCROW_USEYN = N ========================2025-04-02 15:57:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250402155941 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 = 55892098****200* LGD_FINANCEAUTHNUM = 35797083 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2e902da4be9e464d27eff69746b680b3 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250402155942 LGD_PCANCELSTR = 0 LGD_BUYER = 이재경 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250402155941wckm0 LGD_BUYERID = LGD_OID = Direct-ss9699-1743576887 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-02 15:57:08======================== insert into mBoard_order set rOrdNo = 'Direct-ss9699-1743576887', AuthTy = 'card', memberId = 'ss9699', OrdNm ='이재경', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사성원스토어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****200*', rApprNo = 'mjsof20250402155941wckm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-02 15:57:08', InvoiceNum = '결제성공:Direct-ss9699-1743576887/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-02 15:57:08' ========================2025-04-02 15:57:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250402155941wckm0' 0 = 1 cnt = 1 ========================2025-04-02 15:57:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ss9699' 0 = ss9699 Mid = ss9699 1 = 주식회사성원스토어 Mcompany = 주식회사성원스토어 2 = 7208600660 companyNum = 7208600660 3 = 010-6456-9699 Mtel1 = 010-6456-9699 4 = 010-6455-9699 Mhp = 010-6455-9699 ========================2025-04-02 15:57:08======================== select * from customers where id = 'ss9699' ========================2025-04-02 15:57:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ss9699','2025-04-02 15:57:08','108000','110000','온라인','0') ========================2025-04-02 23:13:28======================== res_start ========================2025-04-02 23:13:28======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다.