========================2025-07-15 15:24:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmllc1004-1752560592 LGD_BUYER = 유기열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250715152312 LGD_HASHDATA = da4a785bf68899bde50cff4202b804b5 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 = 2025071515284171941D3A3E1568F04FC8552FEC28439502E3BCAF Mname = 유기열 Mcompany = 미래로메딕스 유한회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mmllc1004 LGD_ESCROW_USEYN = N ========================2025-07-15 15:24:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250715152842 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mmediphil@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834881 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55320800****248* LGD_FINANCEAUTHNUM = 60093107 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 56699ab967d25b56da3db5364849448b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250715152843 LGD_PCANCELSTR = 0 LGD_BUYER = 유기열 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250715152842UVDl7 LGD_BUYERID = LGD_OID = Direct-mmllc1004-1752560592 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5152842UmZJ5 ========================2025-07-15 15:24:10======================== insert into mBoard_order set rOrdNo = 'Direct-mmllc1004-1752560592', AuthTy = 'card', memberId = 'mmllc1004', OrdNm ='유기열', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '미래로메딕스 유한회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55320800****248*', rApprNo = 'mjsof20250715152842UVDl7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-15 15:24:10', InvoiceNum = '결제성공:Direct-mmllc1004-1752560592/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-15 15:24:10' ========================2025-07-15 15:24:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250715152842UVDl7' 0 = 1 cnt = 1 ========================2025-07-15 15:24:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmllc1004' 0 = mmllc1004 Mid = mmllc1004 1 = 미래로메딕스 유한회사 Mcompany = 미래로메딕스 유한회사 2 = 410-86-91148 companyNum = 410-86-91148 3 = 010-9458-0115 Mtel1 = 010-9458-0115 4 = 010-9458-0115 Mhp = 010-9458-0115 ========================2025-07-15 15:24:11======================== select * from customers where id = 'mmllc1004' ========================2025-07-15 15:24:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmllc1004','2025-07-15 15:24:10','52500','55000','온라인','0') ========================2025-07-15 17:48:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gstile7200-1752569110 LGD_BUYER = 최병달 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250715174510 LGD_HASHDATA = 47ab26463defd88217b62c095dfe503d 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 = 20250715175308AF2C18F1594F16DEFD966E3C09B4640B79740222 Mname = 최병달 Mcompany = (주)한현 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = gstile7200 LGD_ESCROW_USEYN = N ========================2025-07-15 17:48:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250715175308 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = t7211023@naver.com 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 = 41400307****690* LGD_FINANCEAUTHNUM = 61083833 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a392630652f8169f6f453455014a61b2 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250715175309 LGD_PCANCELSTR = 0 LGD_BUYER = 최병달 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202507151753080Sxs0 LGD_BUYERID = LGD_OID = Direct-gstile7200-1752569110 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 517530806Jn7 ========================2025-07-15 17:48:36======================== insert into mBoard_order set rOrdNo = 'Direct-gstile7200-1752569110', AuthTy = 'card', memberId = 'gstile7200', OrdNm ='최병달', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한현', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****690*', rApprNo = 'mjsof202507151753080Sxs0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-15 17:48:36', InvoiceNum = '결제성공:Direct-gstile7200-1752569110/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-15 17:48:36' ========================2025-07-15 17:48:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202507151753080Sxs0' 0 = 1 cnt = 1 ========================2025-07-15 17:48:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gstile7200' 0 = gstile7200 Mid = gstile7200 1 = (주)한현 Mcompany = (주)한현 2 = 6978601864 companyNum = 6978601864 3 = 010-4623-7970 Mtel1 = 010-4623-7970 4 = 010-4623-7970 Mhp = 010-4623-7970 ========================2025-07-15 17:48:36======================== select * from customers where id = 'gstile7200' ========================2025-07-15 17:48:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gstile7200','2025-07-15 17:48:36','52500','55000','온라인','0')