========================2021-02-10 10:01:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harry0111-1612918824 LGD_BUYER = 최규윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210100024 LGD_HASHDATA = 88dc084d9dfc9506f643326df919db2b LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102101001380318167BD6C50DD186585F2CD3DC6C750024D2E0 Mname = 최규윤 Mcompany = (주)한국종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = harry0111 LGD_ESCROW_USEYN = N ========================2021-02-10 10:01:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210100139 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 654132******8993 LGD_FINANCEAUTHNUM = 51953517 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3be92c2fa06b347806bf59d7160734c8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210210100139 LGD_PCANCELSTR = 0 LGD_BUYER = 최규윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021010013860078 LGD_BUYERID = LGD_OID = Direct-harry0111-1612918824 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 010013860085 ========================2021-02-10 10:01:34======================== insert into mBoard_order set rOrdNo = 'Direct-harry0111-1612918824', AuthTy = 'card', memberId = 'harry0111', OrdNm ='최규윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한국종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 654132******8993', rApprNo = 'mjsof2021021010013860078', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-10 10:01:34', InvoiceNum = '결제성공:Direct-harry0111-1612918824/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-10 10:01:34' ========================2021-02-10 10:01:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021021010013860078' 0 = 1 cnt = 1 ========================2021-02-10 10:01:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harry0111' 0 = harry0111 Mid = harry0111 1 = (주)한국종합물류 Mcompany = (주)한국종합물류 2 = 5448801472 companyNum = 5448801472 3 = 010-4331-0111 Mtel1 = 010-4331-0111 4 = 010-4331-0111 Mhp = 010-4331-0111 ========================2021-02-10 10:01:34======================== select * from customers where id = 'harry0111' ========================2021-02-10 10:01:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harry0111','2021-02-10 10:01:34','108000','110000','온라인','0') ========================2021-02-10 16:18:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bf5957-1612941451 LGD_BUYER = 윤성필 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210161731 LGD_HASHDATA = 9509157f6d75cac79f4b0fb8d26bab27 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102101618197DDDD1B58C78B1C0C42F6CCCE28BCF29506E82F9 Mname = 윤성필 Mcompany = 비엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = bf5957 LGD_ESCROW_USEYN = N ========================2021-02-10 16:18:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210161821 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(1회사용한도초과) LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = b35fce6dd443c616ab4c9f8141989be9 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210210161821 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 윤성필 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021016182061032 LGD_BUYERID = LGD_OID = Direct-bf5957-1612941451 LGD_RESPCODE = 0016 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-02-10 16:20:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bf5957-1612941579 LGD_BUYER = 윤성필 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210161939 LGD_HASHDATA = 2a5507eb283887ae351735871a85ddde LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210210162015B56D63FEE8B94E63E026C9A8DF125D26172C7914 Mname = 윤성필 Mcompany = 비엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = bf5957 LGD_ESCROW_USEYN = N ========================2021-02-10 16:20:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210162016 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(1회사용한도초과) LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = af9759ea0d87c237fa91ae97947e6ddf LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210210162016 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 윤성필 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021016201661277 LGD_BUYERID = LGD_OID = Direct-bf5957-1612941579 LGD_RESPCODE = 0016 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-02-10 16:21:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bf5957-1612941632 LGD_BUYER = 윤성필 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210162032 LGD_HASHDATA = b41eaddd5025ce586ba07f437e6ca9d6 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102101621064DD7B7315110E13CD0631665171BA749671B69E3 Mname = 윤성필 Mcompany = 비엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = bf5957 LGD_ESCROW_USEYN = N ========================2021-02-10 16:21:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210162107 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 533014******5579 LGD_FINANCEAUTHNUM = 57847497 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c84b1abcc385097cf2dc6db224b8ea79 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210210162107 LGD_PCANCELSTR = 0 LGD_BUYER = 윤성필 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021021016210660165 LGD_BUYERID = LGD_OID = Direct-bf5957-1612941632 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 101621666322 ========================2021-02-10 16:21:02======================== insert into mBoard_order set rOrdNo = 'Direct-bf5957-1612941632', AuthTy = 'card', memberId = 'bf5957', OrdNm ='윤성필', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '비엔에프', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '광주Master 533014******5579', rApprNo = 'mjsof2021021016210660165', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-10 16:21:02', InvoiceNum = '결제성공:Direct-bf5957-1612941632/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-10 16:21:02' ========================2021-02-10 16:21:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021021016210660165' 0 = 1 cnt = 1 ========================2021-02-10 16:21:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bf5957' 0 = bf5957 Mid = bf5957 1 = 비엔에프 Mcompany = 비엔에프 2 = 4578101034 companyNum = 4578101034 3 = 062-515-5957 Mtel1 = 062-515-5957 4 = 010-5610-3711 Mhp = 010-5610-3711 ========================2021-02-10 16:21:02======================== select * from customers where id = 'bf5957' ========================2021-02-10 16:21:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bf5957','2021-02-10 16:21:02','30900','33000','온라인','0') ========================2021-02-10 17:12:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1612944724 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210171204 LGD_HASHDATA = c636e0ab05c3f4d6ede6246b1c26c2bc LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210210171302B519584554E36350A739DE48DCAD6295AD5C5E6D Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2021-02-10 17:12:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210171302 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yk4546@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 949089******2201 LGD_FINANCEAUTHNUM = 00568570 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 350c711a57e22c50857638b97581b1c1 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210210171303 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021017130261165 LGD_BUYERID = LGD_OID = Direct-jupiter-1612944724 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-10 17:12:57======================== insert into mBoard_order set rOrdNo = 'Direct-jupiter-1612944724', AuthTy = 'card', memberId = 'jupiter', OrdNm ='이영기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '목성데코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대 949089******2201', rApprNo = 'mjsof2021021017130261165', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-10 17:12:57', InvoiceNum = '결제성공:Direct-jupiter-1612944724/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-10 17:12:57' ========================2021-02-10 17:12:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021021017130261165' 0 = 1 cnt = 1 ========================2021-02-10 17:12:57======================== 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 ========================2021-02-10 17:12:57======================== select * from customers where id = 'jupiter' ========================2021-02-10 17:12:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jupiter','2021-02-10 17:12:57','108000','110000','온라인','0') ========================2021-02-10 17:21:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-eastasia-1612945173 LGD_BUYER = 홍보표 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210171933 LGD_HASHDATA = 5f270abb8380daccf0fe9fb7a5c918db LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210210172120071CDB15580EC38CD698A67D2E73554CB5ABD1DF Mname = 홍보표 Mcompany = 동아시아네트워크(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = eastasia LGD_ESCROW_USEYN = N ========================2021-02-10 17:21:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210172120 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hbp0216@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 = 407916******4594 LGD_FINANCEAUTHNUM = 57237496 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a253ec5dad57e6cb063e50dae55ec156 LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210210172121 LGD_PCANCELSTR = 0 LGD_BUYER = 홍보표 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021017212060119 LGD_BUYERID = LGD_OID = Direct-eastasia-1612945173 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-10 17:21:15======================== insert into mBoard_order set rOrdNo = 'Direct-eastasia-1612945173', AuthTy = 'card', memberId = 'eastasia', OrdNm ='홍보표', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동아시아네트워크(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH VISA 407916******4594', rApprNo = 'mjsof2021021017212060119', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-10 17:21:15', InvoiceNum = '결제성공:Direct-eastasia-1612945173/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-10 17:21:15' ========================2021-02-10 17:21:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021021017212060119' 0 = 1 cnt = 1 ========================2021-02-10 17:21:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'eastasia' 0 = eastasia Mid = eastasia 1 = 동아시아네트워크(주) Mcompany = 동아시아네트워크(주) 2 = 1058736181 companyNum = 1058736181 3 = -- Mtel1 = -- 4 = 010-8788-9363 Mhp = 010-8788-9363 ========================2021-02-10 17:21:15======================== select * from customers where id = 'eastasia' ========================2021-02-10 17:21:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('eastasia','2021-02-10 17:21:15','52500','55000','온라인','0') ========================2021-02-10 23:02:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1612965702 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210210230142 LGD_HASHDATA = a838921be42e7282375890056bd6e997 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102102302183F6495EC208DEDA1C818CCC57AF2FB6AD7CA9AFD Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2021-02-10 23:02:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210210230218 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 404933******4019 LGD_FINANCEAUTHNUM = 00067197 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 71f84dace33bd31ca2b84d60f2a2718d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210210230219 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021021023021861176 LGD_BUYERID = LGD_OID = Direct-we32-1612965702 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-10 23:02:13======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1612965702', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 404933******4019', rApprNo = 'mjsof2021021023021861176', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-10 23:02:13', InvoiceNum = '결제성공:Direct-we32-1612965702/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-10 23:02:13' ========================2021-02-10 23:02:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021021023021861176' 0 = 1 cnt = 1 ========================2021-02-10 23:02:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2021-02-10 23:02:13======================== select * from customers where id = 'we32' ========================2021-02-10 23:02:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2021-02-10 23:02:13','108000','110000','온라인','0')