========================2025-04-30 09:28:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sknba-1745972836 LGD_BUYER = 신수진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430092716 LGD_HASHDATA = 2e534aab6e049c2a28cbad8c124751dc 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 = 20250430093152BA73C271018B85CC438335B1705D8862AAA07463 Mname = 신수진 Mcompany = 서광엔비에이(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sknba LGD_ESCROW_USEYN = N ========================2025-04-30 09:28:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430093153 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = sknba@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****689* LGD_FINANCEAUTHNUM = 30139916 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e2a66eebb9a65010eb5be4c7c2119343 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250430093153 LGD_PCANCELSTR = 0 LGD_BUYER = 신수진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430093152KMM86 LGD_BUYERID = LGD_OID = Direct-sknba-1745972836 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0093152KyoA0 ========================2025-04-30 09:28:48======================== insert into mBoard_order set rOrdNo = 'Direct-sknba-1745972836', AuthTy = 'card', memberId = 'sknba', OrdNm ='신수진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서광엔비에이(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****689*', rApprNo = 'mjsof20250430093152KMM86', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 09:28:48', InvoiceNum = '결제성공:Direct-sknba-1745972836/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 09:28:48' ========================2025-04-30 09:28:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430093152KMM86' 0 = 1 cnt = 1 ========================2025-04-30 09:28:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sknba' 0 = sknba Mid = sknba 1 = 서광엔비에이(주) Mcompany = 서광엔비에이(주) 2 = 1138134090 companyNum = 1138134090 3 = 02-2631-0112 Mtel1 = 02-2631-0112 4 = 010-4142-9515 Mhp = 010-4142-9515 ========================2025-04-30 09:28:48======================== select * from customers where id = 'sknba' ========================2025-04-30 09:28:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sknba','2025-04-30 09:28:48','108000','110000','온라인','0') ========================2025-04-30 09:56:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nowfix-1745974503 LGD_BUYER = 임경섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430095503 LGD_HASHDATA = 72bfac66a58fd053a6f8b92506406d5d 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 = 20250430095909A46CAF46DFA4B2AD59B667BE85A4730C07BAE801 Mname = 임경섭 Mcompany = (주)나우픽스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = nowfix LGD_ESCROW_USEYN = N ========================2025-04-30 09:56:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430095910 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = nowfix@nowfix.co.kr 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 = 40791672****919* LGD_FINANCEAUTHNUM = 65721534 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 38101db9eae8f7a95ddd602911614e5c LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250430095911 LGD_PCANCELSTR = 0 LGD_BUYER = 임경섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430095910KPzx7 LGD_BUYERID = LGD_OID = Direct-nowfix-1745974503 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-30 09:56:05======================== insert into mBoard_order set rOrdNo = 'Direct-nowfix-1745974503', AuthTy = 'card', memberId = 'nowfix', OrdNm ='임경섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)나우픽스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH VISA 40791672****919*', rApprNo = 'mjsof20250430095910KPzx7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 09:56:05', InvoiceNum = '결제성공:Direct-nowfix-1745974503/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 09:56:05' ========================2025-04-30 09:56:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430095910KPzx7' 0 = 1 cnt = 1 ========================2025-04-30 09:56:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nowfix' 0 = nowfix Mid = nowfix 1 = (주)나우픽스 Mcompany = (주)나우픽스 2 = 1688100038 companyNum = 1688100038 3 = 043-218-3002 Mtel1 = 043-218-3002 4 = 010-3453-9496 Mhp = 010-3453-9496 ========================2025-04-30 09:56:05======================== select * from customers where id = 'nowfix' ========================2025-04-30 09:56:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nowfix','2025-04-30 09:56:05','220000','220000','온라인','0') ========================2025-04-30 10:00:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-aria1635-1745974732 LGD_BUYER = 최상철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430095852 LGD_HASHDATA = ecaea3591a3992a48a8c6741e0673aca 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 = 20250430100322784FFD2556E3920C419CE5C7BC32A43E5639C37B Mname = 최상철 Mcompany = 주식회사 아리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = aria1635 LGD_ESCROW_USEYN = N ========================2025-04-30 10:00:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430100322 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 = 49029841****489* LGD_FINANCEAUTHNUM = 30283246 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9e367c6f47e8ca3c30df0aa641d65a33 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250430100323 LGD_PCANCELSTR = 0 LGD_BUYER = 최상철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430100322F5zA6 LGD_BUYERID = LGD_OID = Direct-aria1635-1745974732 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-30 10:00:18======================== insert into mBoard_order set rOrdNo = 'Direct-aria1635-1745974732', AuthTy = 'card', memberId = 'aria1635', OrdNm ='최상철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 아리아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****489*', rApprNo = 'mjsof20250430100322F5zA6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 10:00:18', InvoiceNum = '결제성공:Direct-aria1635-1745974732/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 10:00:18' ========================2025-04-30 10:00:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430100322F5zA6' 0 = 1 cnt = 1 ========================2025-04-30 10:00:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'aria1635' 0 = aria1635 Mid = aria1635 1 = 주식회사 아리아 Mcompany = 주식회사 아리아 2 = 8808600526 companyNum = 8808600526 3 = 031-764-8822 Mtel1 = 031-764-8822 4 = 010-3428-6749 Mhp = 010-3428-6749 ========================2025-04-30 10:00:18======================== select * from customers where id = 'aria1635' ========================2025-04-30 10:00:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('aria1635','2025-04-30 10:00:18','52500','55000','온라인','0') ========================2025-04-30 12:45:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-airtrack3-1745984705 LGD_BUYER = 김양준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430124505 LGD_HASHDATA = 35ec7442fe951929e02d011250322f12 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 = 2025043012490062BAFA260B58D3BD855A81725EE0D5EAF067E41D Mname = 김양준 Mcompany = 진영유압 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = airtrack3 LGD_ESCROW_USEYN = N ========================2025-04-30 12:45:55======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250430124900 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = airtracktid@naver.com 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 = 40457701****111* LGD_FINANCEAUTHNUM = 00070798 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c9b11cf135134cb8b4742af094cb6bd0 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250430124900 LGD_PCANCELSTR = 0 LGD_BUYER = 김양준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430124852DKvx9 LGD_BUYERID = LGD_OID = Direct-airtrack3-1745984705 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-30 12:45:55======================== insert into mBoard_order set rOrdNo = 'Direct-airtrack3-1745984705', AuthTy = 'card', memberId = 'airtrack3', OrdNm ='김양준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '진영유압', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 40457701****111*', rApprNo = 'mjsof20250430124852DKvx9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 12:45:55', InvoiceNum = '결제성공:Direct-airtrack3-1745984705/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 12:45:55' ========================2025-04-30 12:45:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430124852DKvx9' 0 = 1 cnt = 1 ========================2025-04-30 12:45:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'airtrack3' 0 = airtrack3 Mid = airtrack3 1 = 진영유압 Mcompany = 진영유압 2 = 726-15-02327 companyNum = 726-15-02327 3 = 010-4939-9899 Mtel1 = 010-4939-9899 4 = 010-4939-9899 Mhp = 010-4939-9899 ========================2025-04-30 12:45:55======================== select * from customers where id = 'airtrack3' ========================2025-04-30 12:45:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('airtrack3','2025-04-30 12:45:55','30900','33000','온라인','0') ========================2025-04-30 14:07:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-leeoosk-1745989579 LGD_BUYER = 이수경 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430140619 LGD_HASHDATA = db0ef0e2a1e82aef6ec556c901ee902c 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 = 202504301410465037779BE90921951C89E1D412709D8A408AE281 Mname = 이수경 Mcompany = 대륙상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = leeoosk LGD_ESCROW_USEYN = N ========================2025-04-30 14:07:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430141046 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BAEARL LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35629746****729* LGD_FINANCEAUTHNUM = 34516555 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e60f5aa61e497eeecf367ed4798f9663 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250430141046 LGD_PCANCELSTR = 0 LGD_BUYER = 이수경 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430141046JhNs4 LGD_BUYERID = LGD_OID = Direct-leeoosk-1745989579 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-30 14:07:41======================== insert into mBoard_order set rOrdNo = 'Direct-leeoosk-1745989579', AuthTy = 'card', memberId = 'leeoosk', OrdNm ='이수경', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대륙상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한JCB 35629746****729*', rApprNo = 'mjsof20250430141046JhNs4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 14:07:41', InvoiceNum = '결제성공:Direct-leeoosk-1745989579/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 14:07:41' ========================2025-04-30 14:07:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430141046JhNs4' 0 = 1 cnt = 1 ========================2025-04-30 14:07:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'leeoosk' 0 = leeoosk Mid = leeoosk 1 = 대륙상사 Mcompany = 대륙상사 2 = 307-07-31121 companyNum = 307-07-31121 3 = 041-866-6650 Mtel1 = 041-866-6650 4 = 010-2707-9530 Mhp = 010-2707-9530 ========================2025-04-30 14:07:41======================== select * from customers where id = 'leeoosk' ========================2025-04-30 14:07:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('leeoosk','2025-04-30 14:07:41','108000','110000','온라인','0') ========================2025-04-30 16:25:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1745997850 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430162410 LGD_HASHDATA = 0340d3f91a01e8a00aec8dc628464961 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 = 202504301628507E9E7A7130DF9EA49330DCE2FEDE88251C73FF63 Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2025-04-30 16:25:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430162850 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 = 37029923****53* LGD_FINANCEAUTHNUM = 00583199 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea8e714a2c4f5cdd1078c0c44bac5e4f LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250430162851 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430162850Suix9 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1745997850 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-30 16:25:45======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1745997850', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029923****53*', rApprNo = 'mjsof20250430162850Suix9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 16:25:45', InvoiceNum = '결제성공:Direct-ksm03172002-1745997850/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 16:25:45' ========================2025-04-30 16:25:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430162850Suix9' 0 = 1 cnt = 1 ========================2025-04-30 16:25:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2025-04-30 16:25:45======================== select * from customers where id = 'ksm03172002' ========================2025-04-30 16:25:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2025-04-30 16:25:45','30900','33000','온라인','0') ========================2025-04-30 16:58:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1745999863 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250430165743 LGD_HASHDATA = 7f4a267459f743851c6ebab520f754c5 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 = 20250430170123626D8A4F49AE85FF268B25C42437E9B0EE251AC7 Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2025-04-30 16:58:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250430170124 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****454* LGD_FINANCEAUTHNUM = 46785489 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ecd572935f0e1d537a1498d52d9c4e38 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250430170124 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250430170123Nm5Y8 LGD_BUYERID = LGD_OID = Direct-ltweenn-1745999863 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0170123NcQU8 ========================2025-04-30 16:58:18======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1745999863', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20250430170123Nm5Y8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-30 16:58:18', InvoiceNum = '결제성공:Direct-ltweenn-1745999863/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-30 16:58:18' ========================2025-04-30 16:58:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250430170123Nm5Y8' 0 = 1 cnt = 1 ========================2025-04-30 16:58:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2025-04-30 16:58:19======================== select * from customers where id = 'ltweenn' ========================2025-04-30 16:58:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2025-04-30 16:58:18','220000','220000','온라인','0')