========================2025-06-07 10:33:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ks0516ks-1749259240 LGD_BUYER = 김광수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250607102040 LGD_HASHDATA = 1a18ac33a4fe6f1e070bc3d4df6b9c9d 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 = 20250607103659AB7A27B60AC94D6FD4B7CD39B6A0AF6FE5EC6415 Mname = 김광수 Mcompany = (주)미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ks0516ks LGD_ESCROW_USEYN = N ========================2025-06-07 10:33:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250607103700 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = k0516ks@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 = 40791604****208* LGD_FINANCEAUTHNUM = 63592013 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 54fcb80e31c9ae8e8005eb2c753faf55 LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250607103700 LGD_PCANCELSTR = 0 LGD_BUYER = 김광수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250607103659bf8r3 LGD_BUYERID = LGD_OID = Direct-ks0516ks-1749259240 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-07 10:33:12======================== insert into mBoard_order set rOrdNo = 'Direct-ks0516ks-1749259240', AuthTy = 'card', memberId = 'ks0516ks', OrdNm ='김광수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH VISA 40791604****208*', rApprNo = 'mjsof20250607103659bf8r3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-07 10:33:12', InvoiceNum = '결제성공:Direct-ks0516ks-1749259240/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-07 10:33:12' ========================2025-06-07 10:33:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250607103659bf8r3' 0 = 1 cnt = 1 ========================2025-06-07 10:33:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ks0516ks' 0 = ks0516ks Mid = ks0516ks 1 = (주)미래식품 Mcompany = (주)미래식품 2 = 338-88-00596 companyNum = 338-88-00596 3 = 010-3212-6971 Mtel1 = 010-3212-6971 4 = 010-2837-7370 Mhp = 010-2837-7370 ========================2025-06-07 10:33:12======================== select * from customers where id = 'ks0516ks' ========================2025-06-07 10:33:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ks0516ks','2025-06-07 10:33:12','108000','110000','온라인','0') ========================2025-06-07 19:56:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1749293728 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250607195528 LGD_HASHDATA = 83bdadee37f0a6d604db531a8ade1134 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 = 2025060720002166792CCD511E3105198AE51510874D360E1E354A Mname = 김태우 Mcompany = 태산식자재유통센터 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2025-06-07 19:56:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250607200022 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 = 94091511****271* LGD_FINANCEAUTHNUM = 41188030 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 988805fe0a9e91ef670830e4d8829234 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20250607200022 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506072000215EK79 LGD_BUYERID = LGD_OID = Direct-antwin77-1749293728 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-07 19:56:33======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1749293728', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태산식자재유통센터', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****271*', rApprNo = 'mjsof202506072000215EK79', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-07 19:56:33', InvoiceNum = '결제성공:Direct-antwin77-1749293728/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-07 19:56:33' ========================2025-06-07 19:56:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506072000215EK79' 0 = 1 cnt = 1 ========================2025-06-07 19:56:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 태산식자재유통센터 Mcompany = 태산식자재유통센터 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2025-06-07 19:56:33======================== select * from customers where id = 'antwin77' ========================2025-06-07 19:56:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2025-06-07 19:56:33','52500','55000','온라인','0')