========================2021-01-27 13:41:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1611722449 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210127134049 LGD_HASHDATA = 87aa840223884300051b4b2aee021619 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 = 202101271341453B242879EE5B05B42A0D05CEA1B4554EC62829E2 Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2021-01-27 13:41:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210127134145 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 = 625003******2941 LGD_FINANCEAUTHNUM = 39889066 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 299e0a64cd904f2237bab30135e3f52f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210127134146 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021012713414561180 LGD_BUYERID = LGD_OID = Direct-neotool-1611722449 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 713414561102 ========================2021-01-27 13:41:40======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1611722449', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 625003******2941', rApprNo = 'mjsof2021012713414561180', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-27 13:41:40', InvoiceNum = '결제성공:Direct-neotool-1611722449/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-27 13:41:40' ========================2021-01-27 13:41:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021012713414561180' 0 = 1 cnt = 1 ========================2021-01-27 13:41:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2021-01-27 13:41:41======================== select * from customers where id = 'neotool' ========================2021-01-27 13:41:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-01-27 13:41:40','108000','110000','온라인','0') ========================2021-01-27 16:50:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyj1201-1611733764 LGD_BUYER = 김윤재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210127164924 LGD_HASHDATA = b34b59bf740c283a79103fa9def4c0e7 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 = 2021012716503590A5E7B5DECAA8BEAF406A2D04E263534A1F2EA7 Mname = 김윤재 Mcompany = (주)신화유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kyj1201 LGD_ESCROW_USEYN = N ========================2021-01-27 16:50:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210127165035 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 = 543333******7601 LGD_FINANCEAUTHNUM = 00404651 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b25016d6545dd10deb8e78e6a98a85bb LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210127165036 LGD_PCANCELSTR = 0 LGD_BUYER = 김윤재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021012716503514284 LGD_BUYERID = LGD_OID = Direct-kyj1201-1611733764 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-27 16:50:30======================== insert into mBoard_order set rOrdNo = 'Direct-kyj1201-1611733764', AuthTy = 'card', memberId = 'kyj1201', OrdNm ='김윤재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신화유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대MASTER 543333******7601', rApprNo = 'mjsof2021012716503514284', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-27 16:50:30', InvoiceNum = '결제성공:Direct-kyj1201-1611733764/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-27 16:50:30' ========================2021-01-27 16:50:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021012716503514284' 0 = 1 cnt = 1 ========================2021-01-27 16:50:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyj1201' 0 = kyj1201 Mid = kyj1201 1 = (주)신화유통 Mcompany = (주)신화유통 2 = 1498600672 companyNum = 1498600672 3 = 010-2124-1126 Mtel1 = 010-2124-1126 4 = 010-2124-1126 Mhp = 010-2124-1126 ========================2021-01-27 16:50:30======================== select * from customers where id = 'kyj1201' ========================2021-01-27 16:50:30======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('kyj1201','(주)신화유통','1498600672','010-2124-1126','010-2124-1126','2021-01-27 16:50:30','온라인') ========================2021-01-27 16:50:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyj1201','2021-01-27 16:50:30','10000','11000','온라인','0')