========================2025-02-04 09:20:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1738628401 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204092001 LGD_HASHDATA = 06da406c7ce8675e597ef4432c411866 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 = 20250204092222E5F7F7C5EF0D380CB7200D216758E441048CECD5 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-02-04 09:20:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204092223 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 = 59244392 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c988a6426571a488d605f65f0f3d39b6 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250204092224 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204092223gFum6 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1738628401 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-04 09:20:54======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1738628401', 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 = 'mjsof20250204092223gFum6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 09:20:54', InvoiceNum = '결제성공:Direct-goodssal5707-1738628401/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 09:20:54' ========================2025-02-04 09:20:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204092223gFum6' 0 = 1 cnt = 1 ========================2025-02-04 09:20:54======================== 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-02-04 09:20:54======================== select * from customers where id = 'goodssal5707' ========================2025-02-04 09:20:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-02-04 09:20:54','220000','220000','온라인','0') ========================2025-02-04 09:40:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1738629599 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204093959 LGD_HASHDATA = a25439e076007a4c2428a98d68ac48e9 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 = 202502040942202969DE63FAC6643054C150080D3023A5C0F3C034 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-02-04 09:40:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204094221 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 = 59382595 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c1cf38213f1b2c416635be8e275bf94d LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250204094221 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204094221rHdm0 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1738629599 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-04 09:40:52======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1738629599', 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 = 'mjsof20250204094221rHdm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 09:40:52', InvoiceNum = '결제성공:Direct-goodssal5707-1738629599/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 09:40:52' ========================2025-02-04 09:40:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204094221rHdm0' 0 = 1 cnt = 1 ========================2025-02-04 09:40:52======================== 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-02-04 09:40:52======================== select * from customers where id = 'goodssal5707' ========================2025-02-04 09:40:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-02-04 09:40:52','108000','110000','온라인','0') ========================2025-02-04 10:15:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-babobong76-1738631611 LGD_BUYER = 신광섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204101331 LGD_HASHDATA = fc025ae10597ed2a0d0bd3330ccf8dbd 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 = 20250204101719160ECF760ECC698E5F560C042CBAA95D4F04B1D3 Mname = 신광섭 Mcompany = 주식회사풍성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = babobong76 LGD_ESCROW_USEYN = N ========================2025-02-04 10:15:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204101720 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 = 94901926****703* LGD_FINANCEAUTHNUM = 00284114 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6973aec68aec9f95540b27e49a5b8d7e LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250204101720 LGD_PCANCELSTR = 0 LGD_BUYER = 신광섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204101719i7Un3 LGD_BUYERID = LGD_OID = Direct-babobong76-1738631611 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-04 10:15:50======================== insert into mBoard_order set rOrdNo = 'Direct-babobong76-1738631611', AuthTy = 'card', memberId = 'babobong76', OrdNm ='신광섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사풍성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대 94901926****703*', rApprNo = 'mjsof20250204101719i7Un3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 10:15:50', InvoiceNum = '결제성공:Direct-babobong76-1738631611/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 10:15:50' ========================2025-02-04 10:15:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204101719i7Un3' 0 = 1 cnt = 1 ========================2025-02-04 10:15:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'babobong76' 0 = babobong76 Mid = babobong76 1 = 주식회사풍성유통 Mcompany = 주식회사풍성유통 2 = 8078802713 companyNum = 8078802713 3 = 070-5017-5882 Mtel1 = 070-5017-5882 4 = 010-4798-0526 Mhp = 010-4798-0526 ========================2025-02-04 10:15:50======================== select * from customers where id = 'babobong76' ========================2025-02-04 10:15:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('babobong76','2025-02-04 10:15:50','108000','110000','온라인','0') ========================2025-02-04 10:59:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-todamls-1738634299 LGD_BUYER = 유대웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204105819 LGD_HASHDATA = 033cc8390270ef539064cf403e62e2b4 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 = 20250204110034AFA88F513AE7917FCF34190E0C1B31F48926D607 Mname = 유대웅 Mcompany = (주)토담유통상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = todamls LGD_ESCROW_USEYN = N ========================2025-02-04 10:59:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204110034 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 = 28268446 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 127ab076b5b58a919c01cd58e46fa4b4 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250204110035 LGD_PCANCELSTR = 0 LGD_BUYER = 유대웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20250204110034mdAw6 LGD_BUYERID = LGD_OID = Direct-todamls-1738634299 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 041100624460 ========================2025-02-04 10:59:05======================== insert into mBoard_order set rOrdNo = 'Direct-todamls-1738634299', AuthTy = 'card', memberId = 'todamls', OrdNm ='유대웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토담유통상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 51107002****015*', rApprNo = 'mjsof20250204110034mdAw6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 10:59:05', InvoiceNum = '결제성공:Direct-todamls-1738634299/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 10:59:05' ========================2025-02-04 10:59:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204110034mdAw6' 0 = 1 cnt = 1 ========================2025-02-04 10:59:05======================== 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-02-04 10:59:05======================== select * from customers where id = 'todamls' ========================2025-02-04 10:59:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('todamls','2025-02-04 10:59:05','52500','55000','온라인','0') ========================2025-02-04 11:14:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-arum7014-1738634978 LGD_BUYER = 길호종 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204110938 LGD_HASHDATA = 78dae918819673c43550d2e84b0346ee 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 = 20250204111530335202A311DF074F6356666F1F3618673CB7B0EF Mname = 길호종 Mcompany = 아름기획 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = arum7014 LGD_ESCROW_USEYN = N ========================2025-02-04 11:14:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204111531 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009200 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94455281****705* LGD_FINANCEAUTHNUM = 30141897 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bf4e28c93df7113d71d22c8184f5167e LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250204111531 LGD_PCANCELSTR = 0 LGD_BUYER = 길호종 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204111531idGx9 LGD_BUYERID = LGD_OID = Direct-arum7014-1738634978 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-04 11:14:01======================== insert into mBoard_order set rOrdNo = 'Direct-arum7014-1738634978', AuthTy = 'card', memberId = 'arum7014', OrdNm ='길호종', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '아름기획', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민 94455281****705*', rApprNo = 'mjsof20250204111531idGx9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 11:14:01', InvoiceNum = '결제성공:Direct-arum7014-1738634978/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 11:14:01' ========================2025-02-04 11:14:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204111531idGx9' 0 = 1 cnt = 1 ========================2025-02-04 11:14:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'arum7014' 0 = arum7014 Mid = arum7014 1 = 아름기획 Mcompany = 아름기획 2 = 2243900630 companyNum = 2243900630 3 = 010-3412-7014 Mtel1 = 010-3412-7014 4 = 010-3412-7014 Mhp = 010-3412-7014 ========================2025-02-04 11:14:02======================== select * from customers where id = 'arum7014' ========================2025-02-04 11:14:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('arum7014','2025-02-04 11:14:01','52500','55000','온라인','0') ========================2025-02-04 11:18:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sjc01-1738635407 LGD_BUYER = 박정순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204111647 LGD_HASHDATA = 48272f58fed72d36abc8a5271887e827 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 = 2025020411193422D8FD1D3EB1C4BF21D561218DD9510D9B53FC5C Mname = 박정순 Mcompany = 한국주얼리센터1 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = sjc01 LGD_ESCROW_USEYN = N ========================2025-02-04 11:18:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204111935 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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****086* LGD_FINANCEAUTHNUM = 30011300 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eeb7443828b725936e0490b52f6d2bed LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250204111935 LGD_PCANCELSTR = 0 LGD_BUYER = 박정순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204111935mhb99 LGD_BUYERID = LGD_OID = Direct-sjc01-1738635407 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4111935mP0N3 ========================2025-02-04 11:18:05======================== insert into mBoard_order set rOrdNo = 'Direct-sjc01-1738635407', AuthTy = 'card', memberId = 'sjc01', OrdNm ='박정순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한국주얼리센터1', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****086*', rApprNo = 'mjsof20250204111935mhb99', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 11:18:05', InvoiceNum = '결제성공:Direct-sjc01-1738635407/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 11:18:05' ========================2025-02-04 11:18:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204111935mhb99' 0 = 1 cnt = 1 ========================2025-02-04 11:18:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sjc01' 0 = sjc01 Mid = sjc01 1 = 한국주얼리센터1 Mcompany = 한국주얼리센터1 2 = 6191077919 companyNum = 6191077919 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-5477-6018 Mhp = 010-5477-6018 ========================2025-02-04 11:18:05======================== select * from customers where id = 'sjc01' ========================2025-02-04 11:18:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sjc01','2025-02-04 11:18:05','52500','55000','온라인','0') ========================2025-02-04 12:24:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1738639299 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204122139 LGD_HASHDATA = f7825f0126fe339988fcf97d71c495dd 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 = 202502041225310B9E2EF1DCAD9AF656C1D99ED9C3B08BB64FAFD9 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2025-02-04 12:24:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204122531 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 = 51818500****839* LGD_FINANCEAUTHNUM = 25302202 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c46d33ee3b6931582af5f67c036ec465 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250204122532 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204122531h63a0 LGD_BUYERID = LGD_OID = Direct-mail2020-1738639299 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-02-04 12:24:02======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1738639299', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 51818500****839*', rApprNo = 'mjsof20250204122531h63a0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 12:24:02', InvoiceNum = '결제성공:Direct-mail2020-1738639299/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 12:24:02' ========================2025-02-04 12:24:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204122531h63a0' 0 = 1 cnt = 1 ========================2025-02-04 12:24:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2025-02-04 12:24:02======================== select * from customers where id = 'mail2020' ========================2025-02-04 12:24:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2025-02-04 12:24:02','10000','11000','온라인','0') ========================2025-02-04 12:32:33======================== res_start ========================2025-02-04 12:32:33======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. ========================2025-02-04 15:13:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-youngwoohn-1738649489 LGD_BUYER = 김동호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204151129 LGD_HASHDATA = 7c359f75a34b3ba2ef977a7ba716df6c 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 = 202502041515012C73A275F2375AAF125BCEEF16F4CA648149EA2B Mname = 김동호 Mcompany = (주)영우루브캠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = youngwoohn LGD_ESCROW_USEYN = N ========================2025-02-04 15:13:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204151502 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****698* LGD_FINANCEAUTHNUM = 51556272 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 029b7be9c2702d02737a3fcd3924d4d8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250204151503 LGD_PCANCELSTR = 0 LGD_BUYER = 김동호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204151502jWtB7 LGD_BUYERID = LGD_OID = Direct-youngwoohn-1738649489 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4151502jknS0 ========================2025-02-04 15:13:33======================== insert into mBoard_order set rOrdNo = 'Direct-youngwoohn-1738649489', AuthTy = 'card', memberId = 'youngwoohn', OrdNm ='김동호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)영우루브캠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62641507****698*', rApprNo = 'mjsof20250204151502jWtB7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 15:13:33', InvoiceNum = '결제성공:Direct-youngwoohn-1738649489/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 15:13:33' ========================2025-02-04 15:13:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204151502jWtB7' 0 = 1 cnt = 1 ========================2025-02-04 15:13:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'youngwoohn' 0 = youngwoohn Mid = youngwoohn 1 = (주)영우유화 호남지사 Mcompany = (주)영우유화 호남지사 2 = 416-81-44987 companyNum = 416-81-44987 3 = 010-3626-2090 Mtel1 = 010-3626-2090 4 = 010-3626-2090 Mhp = 010-3626-2090 ========================2025-02-04 15:13:33======================== select * from customers where id = 'youngwoohn' ========================2025-02-04 15:13:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('youngwoohn','2025-02-04 15:13:33','108000','110000','온라인','0') ========================2025-02-04 15:38:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bangchun-1738651011 LGD_BUYER = 이진석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204153651 LGD_HASHDATA = dea71e0c8e9f9c66569330dc3c3412c4 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 = 20250204153957CE88745FFA9D655A1C61506D1A6FB83A541CD7DB Mname = 이진석 Mcompany = 한반도 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bangchun LGD_ESCROW_USEYN = N ========================2025-02-04 15:38:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204153958 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 = 031118 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****190* LGD_FINANCEAUTHNUM = 51697523 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f0857d4a5a626ec212d4ea49808ff9de LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250204153959 LGD_PCANCELSTR = 0 LGD_BUYER = 이진석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204153958hxsn1 LGD_BUYERID = LGD_OID = Direct-bangchun-1738651011 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4153958h7Id9 ========================2025-02-04 15:38:29======================== insert into mBoard_order set rOrdNo = 'Direct-bangchun-1738651011', AuthTy = 'card', memberId = 'bangchun', OrdNm ='이진석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한반도', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****190*', rApprNo = 'mjsof20250204153958hxsn1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 15:38:29', InvoiceNum = '결제성공:Direct-bangchun-1738651011/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 15:38:29' ========================2025-02-04 15:38:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204153958hxsn1' 0 = 1 cnt = 1 ========================2025-02-04 15:38:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bangchun' 0 = bangchun Mid = bangchun 1 = 한반도 Mcompany = 한반도 2 = 504-15-52891 companyNum = 504-15-52891 3 = 053-356-8787 Mtel1 = 053-356-8787 4 = 010-4768-8787 Mhp = 010-4768-8787 ========================2025-02-04 15:38:29======================== select * from customers where id = 'bangchun' ========================2025-02-04 15:38:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bangchun','2025-02-04 15:38:29','220000','220000','온라인','0') ========================2025-02-04 16:58:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1738655900 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204165820 LGD_HASHDATA = 9c18d2a8e52c2cc3265893a94b43b782 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 = 20250204170022124C52E8362FB12624733165FDC6B9EF65595AF3 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-02-04 16:58:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204170023 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 = 52183305 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 893e197fd0e1d4ef5b409a10cdeee0ce LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250204170024 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204170023rjsh9 LGD_BUYERID = LGD_OID = Direct-ltweenn-1738655900 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4170023rauU6 ========================2025-02-04 16:58:54======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1738655900', 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 = 'mjsof20250204170023rjsh9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 16:58:54', InvoiceNum = '결제성공:Direct-ltweenn-1738655900/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 16:58:54' ========================2025-02-04 16:58:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204170023rjsh9' 0 = 1 cnt = 1 ========================2025-02-04 16:58:54======================== 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-02-04 16:58:54======================== select * from customers where id = 'ltweenn' ========================2025-02-04 16:58:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2025-02-04 16:58:54','220000','220000','온라인','0') ========================2025-02-04 17:40:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-daesanpnf-1738658326 LGD_BUYER = 원근배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250204173846 LGD_HASHDATA = f1edb4840390961ad199b029fda8064f 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 = 202502041742203D3E66F18B4CD3526F6B6DE989C90A501FA5C795 Mname = 원근배 Mcompany = 대산피앤에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = daesanpnf LGD_ESCROW_USEYN = N ========================2025-02-04 17:40:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250204174221 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 393322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37934912****30* LGD_FINANCEAUTHNUM = 52440853 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e0b6273e78b17d4e11d8e8ef2d3e6874 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250204174221 LGD_PCANCELSTR = 0 LGD_BUYER = 원근배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250204174220rmV24 LGD_BUYERID = LGD_OID = Direct-daesanpnf-1738658326 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4174220rbuS8 ========================2025-02-04 17:40:51======================== insert into mBoard_order set rOrdNo = 'Direct-daesanpnf-1738658326', AuthTy = 'card', memberId = 'daesanpnf', OrdNm ='원근배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대산피앤에프', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨AMEX 37934912****30*', rApprNo = 'mjsof20250204174220rmV24', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-02-04 17:40:51', InvoiceNum = '결제성공:Direct-daesanpnf-1738658326/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-02-04 17:40:51' ========================2025-02-04 17:40:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250204174220rmV24' 0 = 1 cnt = 1 ========================2025-02-04 17:40:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'daesanpnf' 0 = daesanpnf Mid = daesanpnf 1 = 대산피앤에프 Mcompany = 대산피앤에프 2 = 3061864697 companyNum = 3061864697 3 = 010-4174-8904 Mtel1 = 010-4174-8904 4 = 010-9360-8904 Mhp = 010-9360-8904 ========================2025-02-04 17:40:51======================== select * from customers where id = 'daesanpnf' ========================2025-02-04 17:40:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('daesanpnf','2025-02-04 17:40:51','52500','55000','온라인','0')