========================2022-03-03 10:54:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lim8813-1646272303 LGD_BUYER = 임길재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303105143 LGD_HASHDATA = e7733613e44b6fdf09107c30330b834a LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022030310590319965A6FA1F544519D4812BE7BB399E1JZIEL0BN Mname = 임길재 Mcompany = 서진아이엔디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = lim8813 LGD_ESCROW_USEYN = N ========================2022-03-03 10:54:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303105904 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******8677 LGD_FINANCEAUTHNUM = 50281265 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c83517ca63eb80b19c63f24db418af7f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220303105904 LGD_PCANCELSTR = 0 LGD_BUYER = 임길재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303105904p2UA6 LGD_BUYERID = LGD_OID = Direct-lim8813-1646272303 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3105904pjIq0 ========================2022-03-03 10:54:14======================== insert into mBoard_order set rOrdNo = 'Direct-lim8813-1646272303', AuthTy = 'card', memberId = 'lim8813', OrdNm ='임길재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서진아이엔디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 910003******8677', rApprNo = 'mjsof20220303105904p2UA6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 10:54:14', InvoiceNum = '결제성공:Direct-lim8813-1646272303/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 10:54:14' ========================2022-03-03 10:54:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303105904p2UA6' 0 = 1 cnt = 1 ========================2022-03-03 10:54:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lim8813' 0 = lim8813 Mid = lim8813 1 = 서진아이엔디 Mcompany = 서진아이엔디 2 = 4598600337 companyNum = 4598600337 3 = 010-8259-8813 Mtel1 = 010-8259-8813 4 = 010-8259-8813 Mhp = 010-8259-8813 ========================2022-03-03 10:54:14======================== select * from customers where id = 'lim8813' ========================2022-03-03 10:54:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lim8813','2022-03-03 10:54:14','220000','220000','온라인','0') ========================2022-03-03 10:55:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lim8813-1646272469 LGD_BUYER = 임길재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303105429 LGD_HASHDATA = 1a71219e153cdf5820f2ca24f21b04ca LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202203031100444FEC01E7DBFF4356AF7EE3A3A649825CSPON6IRA Mname = 임길재 Mcompany = 서진아이엔디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = lim8813 LGD_ESCROW_USEYN = N ========================2022-03-03 10:55:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303110045 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******8677 LGD_FINANCEAUTHNUM = 50286431 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f4d6ccb5d87f3c964d41ec592e1497b8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220303110045 LGD_PCANCELSTR = 0 LGD_BUYER = 임길재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303110045tHTD1 LGD_BUYERID = LGD_OID = Direct-lim8813-1646272469 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3110045tTJL7 ========================2022-03-03 10:55:55======================== insert into mBoard_order set rOrdNo = 'Direct-lim8813-1646272469', AuthTy = 'card', memberId = 'lim8813', OrdNm ='임길재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서진아이엔디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 910003******8677', rApprNo = 'mjsof20220303110045tHTD1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 10:55:55', InvoiceNum = '결제성공:Direct-lim8813-1646272469/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 10:55:55' ========================2022-03-03 10:55:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303110045tHTD1' 0 = 1 cnt = 1 ========================2022-03-03 10:55:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lim8813' 0 = lim8813 Mid = lim8813 1 = 서진아이엔디 Mcompany = 서진아이엔디 2 = 4598600337 companyNum = 4598600337 3 = 010-8259-8813 Mtel1 = 010-8259-8813 4 = 010-8259-8813 Mhp = 010-8259-8813 ========================2022-03-03 10:55:55======================== select * from customers where id = 'lim8813' ========================2022-03-03 10:55:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lim8813','2022-03-03 10:55:55','220000','220000','온라인','0') ========================2022-03-03 11:18:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lmkorea-1646273796 LGD_BUYER = 최광열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303111636 LGD_HASHDATA = 82fdb0afe40e8aeaeb8bd034f7042b6d LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220303112322B2B8ECED872E487BAFA33F980AB3D1A5ZH9N7ZIE Mname = 최광열 Mcompany = 엘엠코리아(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = lmkorea LGD_ESCROW_USEYN = N ========================2022-03-03 11:18:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303112323 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = lmkcokr@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 543617******0707 LGD_FINANCEAUTHNUM = 33724363 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 188d657c6cf5bd8a076d1b69e757a3be LGD_BUYERADDRESS = LGD_FINANCENAME = 외환MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20220303112323 LGD_PCANCELSTR = 0 LGD_BUYER = 최광열 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303112323zKmq4 LGD_BUYERID = LGD_OID = Direct-lmkorea-1646273796 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-03 11:18:32======================== insert into mBoard_order set rOrdNo = 'Direct-lmkorea-1646273796', AuthTy = 'card', memberId = 'lmkorea', OrdNm ='최광열', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엘엠코리아(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '외환MASTER 543617******0707', rApprNo = 'mjsof20220303112323zKmq4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 11:18:32', InvoiceNum = '결제성공:Direct-lmkorea-1646273796/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 11:18:32' ========================2022-03-03 11:18:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303112323zKmq4' 0 = 1 cnt = 1 ========================2022-03-03 11:18:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lmkorea' 0 = lmkorea Mid = lmkorea 1 = 엘엠코리아(주) Mcompany = 엘엠코리아(주) 2 = 1198630573 companyNum = 1198630573 3 = 070-7017-0841 Mtel1 = 070-7017-0841 4 = 010-6395-2327 Mhp = 010-6395-2327 ========================2022-03-03 11:18:33======================== select * from customers where id = 'lmkorea' ========================2022-03-03 11:18:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lmkorea','2022-03-03 11:18:32','220000','220000','온라인','0') ========================2022-03-03 11:48:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1646275275 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303114115 LGD_HASHDATA = 66c638b9ee12dd55d108d38df2918d0d LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220303115334E2F25B5AF49E45ADA376393D8CF99E5CK0ISQFIA Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-03-03 11:48:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303115334 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 002080 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 457972******3072 LGD_FINANCEAUTHNUM = 30104900 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec27b0739f12c09273375df8b8cd0513 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220303115335 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20220303115334s0xv7 LGD_BUYERID = LGD_OID = Direct-jupiter-1646275275 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 031153628843 ========================2022-03-03 11:56:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1646276111 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303115511 LGD_HASHDATA = a1c78c648ad8d8d872da6cc1c6d646db LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022030312011353337FF64288479CBA600F865449E16EAY4E0XPC Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-03-03 11:56:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303120113 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 949089******2201 LGD_FINANCEAUTHNUM = 00736962 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6bdc19062876cc68748d1a5ca859dc6c LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220303120114 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303120113uxQC4 LGD_BUYERID = LGD_OID = Direct-jupiter-1646276111 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-03 11:56:23======================== insert into mBoard_order set rOrdNo = 'Direct-jupiter-1646276111', AuthTy = 'card', memberId = 'jupiter', OrdNm ='이영기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '목성데코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대 949089******2201', rApprNo = 'mjsof20220303120113uxQC4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 11:56:23', InvoiceNum = '결제성공:Direct-jupiter-1646276111/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 11:56:23' ========================2022-03-03 11:56:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303120113uxQC4' 0 = 1 cnt = 1 ========================2022-03-03 11:56:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jupiter' 0 = jupiter Mid = jupiter 1 = 목성데코 Mcompany = 목성데코 2 = 120-08-30823 companyNum = 120-08-30823 3 = 02-516-8336 Mtel1 = 02-516-8336 4 = 010-5269-4546 Mhp = 010-5269-4546 ========================2022-03-03 11:56:23======================== select * from customers where id = 'jupiter' ========================2022-03-03 11:56:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jupiter','2022-03-03 11:56:23','220000','220000','온라인','0') ========================2022-03-03 15:35:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-moa5185-1646289260 LGD_BUYER = 견경수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303153420 LGD_HASHDATA = 25e3cb40bcf9fc194c23f70bd9838164 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220303154025E4EA037443B043E1A5F3047B01F623C6LTWH3GUB Mname = 견경수 Mcompany = 모아나눔사회적협동조합 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = moa5185 LGD_ESCROW_USEYN = N ========================2022-03-03 15:35:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303154026 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 463235******1907 LGD_FINANCEAUTHNUM = 30027831 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = dd4166aa64319ebea01baa159573ece8 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220303154026 LGD_PCANCELSTR = 0 LGD_BUYER = 견경수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303154025zUVu8 LGD_BUYERID = LGD_OID = Direct-moa5185-1646289260 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3154025z3dL5 ========================2022-03-03 15:35:35======================== insert into mBoard_order set rOrdNo = 'Direct-moa5185-1646289260', AuthTy = 'card', memberId = 'moa5185', OrdNm ='견경수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '모아나눔사회적협동조합', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 463235******1907', rApprNo = 'mjsof20220303154025zUVu8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 15:35:35', InvoiceNum = '결제성공:Direct-moa5185-1646289260/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 15:35:35' ========================2022-03-03 15:35:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303154025zUVu8' 0 = 1 cnt = 1 ========================2022-03-03 15:35:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'moa5185' 0 = moa5185 Mid = moa5185 1 = 모아나눔사회적협동조합 Mcompany = 모아나눔사회적협동조합 2 = 1098642000 companyNum = 1098642000 3 = 02-1644-5205 Mtel1 = 02-1644-5205 4 = 010-8200-8060 Mhp = 010-8200-8060 ========================2022-03-03 15:35:35======================== select * from customers where id = 'moa5185' ========================2022-03-03 15:35:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('moa5185','2022-03-03 15:35:35','220000','220000','온라인','0') ========================2022-03-03 18:45:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hobbycenter-1646300673 LGD_BUYER = 조형준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220303184433 LGD_HASHDATA = 300b42949dc8a904d2a035a52b25584b LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220303185034C59B1313B0D54174853F6C2F067DACEAYAXBQESV Mname = 조형준 Mcompany = HOBBY CENTER post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hobbycenter LGD_ESCROW_USEYN = N ========================2022-03-03 18:45:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220303185034 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 543017******9605 LGD_FINANCEAUTHNUM = 63534338 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 466130e4b85c2e3df7caa6a756ff29a9 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220303185035 LGD_PCANCELSTR = 0 LGD_BUYER = 조형준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220303185034z14Q4 LGD_BUYERID = LGD_OID = Direct-hobbycenter-1646300673 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-03 18:45:43======================== insert into mBoard_order set rOrdNo = 'Direct-hobbycenter-1646300673', AuthTy = 'card', memberId = 'hobbycenter', OrdNm ='조형준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'HOBBY CENTER', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH MASTER 543017******9605', rApprNo = 'mjsof20220303185034z14Q4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-03 18:45:43', InvoiceNum = '결제성공:Direct-hobbycenter-1646300673/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-03 18:45:43' ========================2022-03-03 18:45:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220303185034z14Q4' 0 = 1 cnt = 1 ========================2022-03-03 18:45:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hobbycenter' 0 = hobbycenter Mid = hobbycenter 1 = HOBBY CENTER Mcompany = HOBBY CENTER 2 = 105-12-99437 companyNum = 105-12-99437 3 = 032-681-1624 Mtel1 = 032-681-1624 4 = 010-8989-1624 Mhp = 010-8989-1624 ========================2022-03-03 18:45:44======================== select * from customers where id = 'hobbycenter' ========================2022-03-03 18:45:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hobbycenter','2022-03-03 18:45:43','52500','55000','온라인','0')