========================2021-11-10 11:11:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1636510203 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110111003 LGD_HASHDATA = 5b07d28ad51a417dd853dde5aebac05e 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 = 20211110111354D92F8C29BFA648D0A9E876A2D2337EDBGOQH5JIT Mname = 박재호 Mcompany = 주식회사 극광 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2021-11-10 11:11:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110111355 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 522971******6859 LGD_FINANCEAUTHNUM = 30027461 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 124fadd7a4c9be670490a211ce2c71a6 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20211110111355 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110111354TdYs0 LGD_BUYERID = LGD_OID = Direct-parkco6338-1636510203 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0111354TkuR3 ========================2021-11-10 11:11:07======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1636510203', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 극광', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 522971******6859', rApprNo = 'mjsof20211110111354TdYs0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 11:11:07', InvoiceNum = '결제성공:Direct-parkco6338-1636510203/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 11:11:07' ========================2021-11-10 11:11:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110111354TdYs0' 0 = 1 cnt = 1 ========================2021-11-10 11:11:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = 주식회사 극광 Mcompany = 주식회사 극광 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2021-11-10 11:11:07======================== select * from customers where id = 'parkco6338' ========================2021-11-10 11:11:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2021-11-10 11:11:07','220000','220000','온라인','0') ========================2021-11-10 12:41:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ts5ttogi-1636515571 LGD_BUYER = 김건우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110123931 LGD_HASHDATA = de38a683d87fa13e5b62c1fe8e388874 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 = 202111101244111F326DBBDB7E4C8E9DD99764ED7E18B3QJKPDULC Mname = 김건우 Mcompany = (주)태신종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ts5ttogi LGD_ESCROW_USEYN = N ========================2021-11-10 12:41:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110124411 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******9386 LGD_FINANCEAUTHNUM = 62123252 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f63153f73504461906d1b8b5ac97fdde LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211110124412 LGD_PCANCELSTR = 0 LGD_BUYER = 김건우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110124411USnx5 LGD_BUYERID = LGD_OID = Direct-ts5ttogi-1636515571 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0124411UmFj9 ========================2021-11-10 12:41:24======================== insert into mBoard_order set rOrdNo = 'Direct-ts5ttogi-1636515571', AuthTy = 'card', memberId = 'ts5ttogi', OrdNm ='김건우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태신종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 910003******9386', rApprNo = 'mjsof20211110124411USnx5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 12:41:24', InvoiceNum = '결제성공:Direct-ts5ttogi-1636515571/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 12:41:24' ========================2021-11-10 12:41:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110124411USnx5' 0 = 1 cnt = 1 ========================2021-11-10 12:41:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ts5ttogi' 0 = ts5ttogi Mid = ts5ttogi 1 = (주)태신종합물류 Mcompany = (주)태신종합물류 2 = 6918600886 companyNum = 6918600886 3 = 010-4841-6383 Mtel1 = 010-4841-6383 4 = 010-3350-6383 Mhp = 010-3350-6383 ========================2021-11-10 12:41:24======================== select * from customers where id = 'ts5ttogi' ========================2021-11-10 12:41:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ts5ttogi','2021-11-10 12:41:24','220000','220000','온라인','0') ========================2021-11-10 15:02:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ts5ttogi-1636524031 LGD_BUYER = 김건우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110150031 LGD_HASHDATA = aaf6857eb37d9b775814a934b8483a9d 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 = 2021111015044800A10AC99DDB461286C5467B87246BFBZTDUNCKU Mname = 김건우 Mcompany = (주)태신종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ts5ttogi LGD_ESCROW_USEYN = N ========================2021-11-10 15:02:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110150448 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******9386 LGD_FINANCEAUTHNUM = 64322606 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f93225cf192ee6938c0d09f4a5c1f63f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211110150449 LGD_PCANCELSTR = 0 LGD_BUYER = 김건우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110150448UX1c0 LGD_BUYERID = LGD_OID = Direct-ts5ttogi-1636524031 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0150448Up306 ========================2021-11-10 15:02:01======================== insert into mBoard_order set rOrdNo = 'Direct-ts5ttogi-1636524031', AuthTy = 'card', memberId = 'ts5ttogi', OrdNm ='김건우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태신종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 910003******9386', rApprNo = 'mjsof20211110150448UX1c0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 15:02:01', InvoiceNum = '결제성공:Direct-ts5ttogi-1636524031/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 15:02:01' ========================2021-11-10 15:02:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110150448UX1c0' 0 = 1 cnt = 1 ========================2021-11-10 15:02:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ts5ttogi' 0 = ts5ttogi Mid = ts5ttogi 1 = (주)태신종합물류 Mcompany = (주)태신종합물류 2 = 6918600886 companyNum = 6918600886 3 = 010-4841-6383 Mtel1 = 010-4841-6383 4 = 010-3350-6383 Mhp = 010-3350-6383 ========================2021-11-10 15:02:01======================== select * from customers where id = 'ts5ttogi' ========================2021-11-10 15:02:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ts5ttogi','2021-11-10 15:02:01','220000','220000','온라인','0') ========================2021-11-10 16:32:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sali-1636529474 LGD_BUYER = 유재일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110163114 LGD_HASHDATA = 90895d3b7b038946b00c506635bc4ddb 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 = 20211110163539BF431FC74C9147A9979C0A2CFEDF382DMLXWAUNC Mname = 유재일 Mcompany = 참살이 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sali LGD_ESCROW_USEYN = N ========================2021-11-10 16:32:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110163540 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******3962 LGD_FINANCEAUTHNUM = 65025684 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1a9d33a6ecb4a2df22232e1880e47605 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211110163541 LGD_PCANCELSTR = 0 LGD_BUYER = 유재일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110163540r3fg8 LGD_BUYERID = LGD_OID = Direct-sali-1636529474 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0163540r2Z00 ========================2021-11-10 16:36:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sali-1636529760 LGD_BUYER = 유재일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110163600 LGD_HASHDATA = 240bb5c14b7697f2e9c7e120e16a3a07 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 = 202111101639457649C667FE3B4E13BB042BFD3A7D0194Y3E1AVZH Mname = 유재일 Mcompany = 참살이 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sali LGD_ESCROW_USEYN = N ========================2021-11-10 16:36:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110163945 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******7995 LGD_FINANCEAUTHNUM = 65060147 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e73fdf33469dfa47a4f91224cff33088 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211110163946 LGD_PCANCELSTR = 0 LGD_BUYER = 유재일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110163945seNA0 LGD_BUYERID = LGD_OID = Direct-sali-1636529760 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0163945s4t48 ========================2021-11-10 16:39:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sali-1636529950 LGD_BUYER = 유재일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110163910 LGD_HASHDATA = 1a151753e4b0681644f3c89eff3c6696 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 = 20211110164243F9A0F3399D954B1E9A8D4AF1A555ACC78UKSOO60 Mname = 유재일 Mcompany = 참살이 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sali LGD_ESCROW_USEYN = N ========================2021-11-10 16:39:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110164243 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******3962 LGD_FINANCEAUTHNUM = 65080968 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a0d4e6a0c634eec0f5d141e4eb521e2d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211110164244 LGD_PCANCELSTR = 0 LGD_BUYER = 유재일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110164243vFPk6 LGD_BUYERID = LGD_OID = Direct-sali-1636529950 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0164243viJv3 ========================2021-11-10 16:39:56======================== insert into mBoard_order set rOrdNo = 'Direct-sali-1636529950', AuthTy = 'card', memberId = 'sali', OrdNm ='유재일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '참살이', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******3962', rApprNo = 'mjsof20211110164243vFPk6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 16:39:56', InvoiceNum = '결제성공:Direct-sali-1636529950/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 16:39:56' ========================2021-11-10 16:39:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110164243vFPk6' 0 = 1 cnt = 1 ========================2021-11-10 16:39:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sali' 0 = sali Mid = sali 1 = 참살이 Mcompany = 참살이 2 = 138-98-05549 companyNum = 138-98-05549 3 = 070-4632-3188 Mtel1 = 070-4632-3188 4 = 010-3137-3188 Mhp = 010-3137-3188 ========================2021-11-10 16:39:56======================== select * from customers where id = 'sali' ========================2021-11-10 16:39:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sali','2021-11-10 16:39:56','108000','110000','온라인','0') ========================2021-11-10 17:21:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1636532418 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110172018 LGD_HASHDATA = 69b643027551d9186a27981032f81e63 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 = 20211110172421BDD2C870F7F643A5B980DED76F67AB9A4TVUWLKC Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2021-11-10 17:21:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110172421 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******4667 LGD_FINANCEAUTHNUM = 30047806 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0de0e97a8011722ad34c27c74e9b3f28 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20211110172421 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110172421vH3K4 LGD_BUYERID = LGD_OID = Direct-davis747-1636532418 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0172421vjmH3 ========================2021-11-10 17:21:33======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1636532418', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 426586******4667', rApprNo = 'mjsof20211110172421vH3K4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 17:21:33', InvoiceNum = '결제성공:Direct-davis747-1636532418/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 17:21:33' ========================2021-11-10 17:21:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110172421vH3K4' 0 = 1 cnt = 1 ========================2021-11-10 17:21:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2021-11-10 17:21:33======================== select * from customers where id = 'davis747' ========================2021-11-10 17:21:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2021-11-10 17:21:33','108000','110000','온라인','0') ========================2021-11-10 23:05:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nowonbb-1636552700 LGD_BUYER = 정병하 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211110225820 LGD_HASHDATA = 428deeb3383daf0a12c2e19c2c689446 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 = 2021111023080361B39B6171384792A28F0530150AC3395ZEQPVKN Mname = 정병하 Mcompany = 굿라이스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nowonbb LGD_ESCROW_USEYN = N ========================2021-11-10 23:05:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211110230804 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 = 512635******9621 LGD_FINANCEAUTHNUM = 39421046 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ff6087f1f31cc4151a71309bfe03bc7b LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20211110230804 LGD_PCANCELSTR = 0 LGD_BUYER = 정병하 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211110230804soQa0 LGD_BUYERID = LGD_OID = Direct-nowonbb-1636552700 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-10 23:05:16======================== insert into mBoard_order set rOrdNo = 'Direct-nowonbb-1636552700', AuthTy = 'card', memberId = 'nowonbb', OrdNm ='정병하', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '굿라이스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데MASTER 512635******9621', rApprNo = 'mjsof20211110230804soQa0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-10 23:05:16', InvoiceNum = '결제성공:Direct-nowonbb-1636552700/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-10 23:05:16' ========================2021-11-10 23:05:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211110230804soQa0' 0 = 1 cnt = 1 ========================2021-11-10 23:05:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nowonbb' 0 = nowonbb Mid = nowonbb 1 = 굿라이스 Mcompany = 굿라이스 2 = 3260300811 companyNum = 3260300811 3 = 010-9782-3337 Mtel1 = 010-9782-3337 4 = 010-9782-3337 Mhp = 010-9782-3337 ========================2021-11-10 23:05:16======================== select * from customers where id = 'nowonbb' ========================2021-11-10 23:05:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nowonbb','2021-11-10 23:05:16','52500','55000','온라인','0')