========================2025-02-06 02:25:11======================== res_start ========================2025-02-06 02:25:11======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. ========================2025-02-06 08:58:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanbandosalt-1738799864 LGD_BUYER = 이진석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250206085744 LGD_HASHDATA = 2937060951cbcb5a0cf7db468d635b1e 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 = 20250206090027307145E12581D42942CA8DAD9931C1DE6E708923 Mname = 이진석 Mcompany = 한반도소금산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hanbandosalt LGD_ESCROW_USEYN = N ========================2025-02-06 08:58:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250206090027 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = admin@hanbandosalt.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 738987 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****096* LGD_FINANCEAUTHNUM = 62265869 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4ef430624a5618bd4dc179281144abc3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250206090028 LGD_PCANCELSTR = 0 LGD_BUYER = 이진석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250206090027nCt11 LGD_BUYERID = LGD_OID = Direct-hanbandosalt-1738799864 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6090027n3sm0 ========================2025-02-06 08:58:56======================== insert into mBoard_order set rOrdNo = 'Direct-hanbandosalt-1738799864', AuthTy = 'card', memberId = 'hanbandosalt', OrdNm ='이진석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한반도소금산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300306****096*', rApprNo = 'mjsof20250206090027nCt11', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-06 08:58:56', InvoiceNum = '결제성공:Direct-hanbandosalt-1738799864/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-06 08:58:56' ========================2025-02-06 08:58:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250206090027nCt11' 0 = 1 cnt = 1 ========================2025-02-06 08:58:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanbandosalt' 0 = hanbandosalt Mid = hanbandosalt 1 = 한반도소금산업 Mcompany = 한반도소금산업 2 = 610-23-72620 companyNum = 610-23-72620 3 = 052-257-0057 Mtel1 = 052-257-0057 4 = 010-4768-8787 Mhp = 010-4768-8787 ========================2025-02-06 08:58:56======================== select * from customers where id = 'hanbandosalt' ========================2025-02-06 08:58:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanbandosalt','2025-02-06 08:58:56','220000','220000','온라인','0') ========================2025-02-06 10:40:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmi2008-1738805979 LGD_BUYER = 김상원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250206103939 LGD_HASHDATA = 304ebe8a8017fd2205fcf4d9c072f15f 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 = 202502061042102EEDE28BAB438595F1053E62535CEF4D752252EA Mname = 김상원 Mcompany = 주식회사푸드미 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = foodmi2008 LGD_ESCROW_USEYN = N ========================2025-02-06 10:40:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250206104210 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400319****793* LGD_FINANCEAUTHNUM = 62859993 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1ca5f59a861103b157e9f7f851cc32f4 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250206104211 LGD_PCANCELSTR = 0 LGD_BUYER = 김상원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250206104210l4xj1 LGD_BUYERID = LGD_OID = Direct-foodmi2008-1738805979 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6104210lAHJ5 ========================2025-02-06 10:40:39======================== insert into mBoard_order set rOrdNo = 'Direct-foodmi2008-1738805979', AuthTy = 'card', memberId = 'foodmi2008', OrdNm ='김상원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사푸드미', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400319****793*', rApprNo = 'mjsof20250206104210l4xj1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-06 10:40:39', InvoiceNum = '결제성공:Direct-foodmi2008-1738805979/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-06 10:40:39' ========================2025-02-06 10:40:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250206104210l4xj1' 0 = 1 cnt = 1 ========================2025-02-06 10:40:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmi2008' 0 = foodmi2008 Mid = foodmi2008 1 = 주식회사푸드미 Mcompany = 주식회사푸드미 2 = 1408130951 companyNum = 1408130951 3 = 031-765-1917 Mtel1 = 031-765-1917 4 = 010-7413-0998 Mhp = 010-7413-0998 ========================2025-02-06 10:40:39======================== select * from customers where id = 'foodmi2008' ========================2025-02-06 10:40:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmi2008','2025-02-06 10:40:39','52500','55000','온라인','0') ========================2025-02-06 16:52:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1738828282 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250206165122 LGD_HASHDATA = cfa71017f7331f48962b7d185cd24071 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 = 2025020616542360142BA68E816BAE7F21CFAB7C68DC3F0AE0B037 Mname = 박현석 Mcompany = 마니푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = anbinnakdo LGD_ESCROW_USEYN = N ========================2025-02-06 16:52:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250206165424 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = phso519@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797330****809* LGD_FINANCEAUTHNUM = 30043230 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f03032791271a63d94662b82b0cfc22b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250206165424 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250206165424g6dL7 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1738828282 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-06 16:52:52======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1738828282', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797330****809*', rApprNo = 'mjsof20250206165424g6dL7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-06 16:52:52', InvoiceNum = '결제성공:Direct-anbinnakdo-1738828282/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-06 16:52:52' ========================2025-02-06 16:52:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250206165424g6dL7' 0 = 1 cnt = 1 ========================2025-02-06 16:52:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'anbinnakdo' 0 = anbinnakdo Mid = anbinnakdo 1 = 마니푸드 Mcompany = 마니푸드 2 = 121-20-60884 companyNum = 121-20-60884 3 = 070-4082-2105 Mtel1 = 070-4082-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2025-02-06 16:52:52======================== select * from customers where id = 'anbinnakdo' ========================2025-02-06 16:52:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2025-02-06 16:52:52','52500','55000','온라인','0') ========================2025-02-06 18:24:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1738833821 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250206182341 LGD_HASHDATA = a614ddaa73d4005a4587b5bc83440378 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 = 202502061826165934F76518C82FDB1FE1400ABF8EE15543FA5F9E Mname = 강성기 Mcompany = (주)예당식품(지점) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yedangfood2 LGD_ESCROW_USEYN = N ========================2025-02-06 18:24:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250206182617 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55314600****487* LGD_FINANCEAUTHNUM = 07748501 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0f7876f09f8641305b9d368570c5e2eb LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250206182617 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250206182617giKc6 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1738833821 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-06 18:24:45======================== insert into mBoard_order set rOrdNo = 'Direct-yedangfood2-1738833821', AuthTy = 'card', memberId = 'yedangfood2', OrdNm ='강성기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)예당식품(지점)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한MASTER 55314600****487*', rApprNo = 'mjsof20250206182617giKc6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-06 18:24:45', InvoiceNum = '결제성공:Direct-yedangfood2-1738833821/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-06 18:24:45' ========================2025-02-06 18:24:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250206182617giKc6' 0 = 1 cnt = 1 ========================2025-02-06 18:24:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yedangfood2' 0 = yedangfood2 Mid = yedangfood2 1 = (주)예당식품(지점) Mcompany = (주)예당식품(지점) 2 = 1318555107 companyNum = 1318555107 3 = 032-465-2174 Mtel1 = 032-465-2174 4 = 010-4806-0245 Mhp = 010-4806-0245 ========================2025-02-06 18:24:45======================== select * from customers where id = 'yedangfood2' ========================2025-02-06 18:24:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yedangfood2','2025-02-06 18:24:45','220000','220000','온라인','0') ========================2025-02-06 21:26:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brothers-1738844714 LGD_BUYER = 조만식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250206212514 LGD_HASHDATA = bab8a628718afc1d238cc0a8e72902c0 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 = 20250206212749C9B27240DD14AB499CF86A310CFF9335F71768FB Mname = 조만식 Mcompany = 주식회사 브라더 리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = brothers LGD_ESCROW_USEYN = N ========================2025-02-06 21:26:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250206212750 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 = 94100500****321* LGD_FINANCEAUTHNUM = 04703701 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4e66fd9fdf68a347b3f1713ac4ded9cf LGD_BUYERADDRESS = LGD_FINANCENAME = 하나 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250206212750 LGD_PCANCELSTR = 0 LGD_BUYER = 조만식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250206212750nEqP3 LGD_BUYERID = LGD_OID = Direct-brothers-1738844714 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-06 21:26:18======================== insert into mBoard_order set rOrdNo = 'Direct-brothers-1738844714', AuthTy = 'card', memberId = 'brothers', OrdNm ='조만식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 브라더 리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '하나 94100500****321*', rApprNo = 'mjsof20250206212750nEqP3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-06 21:26:18', InvoiceNum = '결제성공:Direct-brothers-1738844714/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-06 21:26:18' ========================2025-02-06 21:26:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250206212750nEqP3' 0 = 1 cnt = 1 ========================2025-02-06 21:26:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'brothers' 0 = brothers Mid = brothers 1 = 주식회사 브라더 리테일 Mcompany = 주식회사 브라더 리테일 2 = 889-81-02638 companyNum = 889-81-02638 3 = 010-2662-7377 Mtel1 = 010-2662-7377 4 = 010-9444-7213 Mhp = 010-9444-7213 ========================2025-02-06 21:26:18======================== select * from customers where id = 'brothers' ========================2025-02-06 21:26:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brothers','2025-02-06 21:26:18','52500','55000','온라인','0')