========================2021-08-31 10:31:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dynasty76-1630373446 LGD_BUYER = 김송암 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831103046 LGD_HASHDATA = b48bee14335f82585bb9e64314e0c221 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 = 20210831103312FCCD08B9742647C5B6B7FF58734BB475BPBHD6SE Mname = 김송암 Mcompany = 태현루브리컨츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dynasty76 LGD_ESCROW_USEYN = N ========================2021-08-31 10:31:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831103312 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 004246 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 356415******7090 LGD_FINANCEAUTHNUM = 30029102 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1fbb56c0b1b6a51f51c166f4a62973f7 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831103312 LGD_PCANCELSTR = 0 LGD_BUYER = 김송암 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083110331261294 LGD_BUYERID = LGD_OID = Direct-dynasty76-1630373446 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 110331261207 ========================2021-08-31 10:31:44======================== insert into mBoard_order set rOrdNo = 'Direct-dynasty76-1630373446', AuthTy = 'card', memberId = 'dynasty76', OrdNm ='김송암', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태현루브리컨츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민JCB 356415******7090', rApprNo = 'mjsof2021083110331261294', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 10:31:44', InvoiceNum = '결제성공:Direct-dynasty76-1630373446/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 10:31:44' ========================2021-08-31 10:31:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083110331261294' 0 = 1 cnt = 1 ========================2021-08-31 10:31:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dynasty76' 0 = dynasty76 Mid = dynasty76 1 = 태현루브리컨츠 Mcompany = 태현루브리컨츠 2 = 125-24-40758 companyNum = 125-24-40758 3 = 031-682-8951 Mtel1 = 031-682-8951 4 = 010-3333-5189 Mhp = 010-3333-5189 ========================2021-08-31 10:31:44======================== select * from customers where id = 'dynasty76' ========================2021-08-31 10:31:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dynasty76','2021-08-31 10:31:44','52500','55000','온라인','0') ========================2021-08-31 11:14:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1630375559 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831110559 LGD_HASHDATA = 0b0193688e4b5aa2c5e6b10bccb32eb6 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 = 20210831111532180817F7601B4B14BBF2D0D1A49D88A1I0TSRU1E Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2021-08-31 11:14:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831111532 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 = 532793******7611 LGD_FINANCEAUTHNUM = 00879781 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 392d37e9faf0ecd93576c7a93394562a LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210831111532 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083111153261026 LGD_BUYERID = LGD_OID = Direct-ds2avq-1630375559 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 11:19:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1630376286 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831111806 LGD_HASHDATA = 84d84b31caa879c069ba9a31ae9641c2 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 = 20210831112121F1F241200FA04452BE5CC6BBDB25304DB0R2YRB6 Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2021-08-31 11:19:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831112121 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 = 532793******7611 LGD_FINANCEAUTHNUM = 00488611 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 97de69c3acc45f38509ee5a974fe1fcf LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210831112121 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083111212161184 LGD_BUYERID = LGD_OID = Direct-ds2avq-1630376286 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 11:25:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1630376635 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831112355 LGD_HASHDATA = a4da49f60dd866f72ce14c903778baad 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 = 20210831112651A6931FB3E5E94F1EA28BDF712B6ECFBADHCWK3XT Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2021-08-31 11:25:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831112651 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 = 532793******7611 LGD_FINANCEAUTHNUM = 00800254 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 279a9a5634fde1dbba0f37090e5002a9 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210831112651 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083111265161079 LGD_BUYERID = LGD_OID = Direct-ds2avq-1630376635 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 11:28:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1630376822 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831112702 LGD_HASHDATA = c8fcd5b66b0fab93fbfe320c1f7a3b24 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 = 20210831112936278F828C2A234E28A86518C77EB645AANEXQQSOY Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2021-08-31 11:28:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831112936 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 = 532793******7611 LGD_FINANCEAUTHNUM = 00238100 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = df1c254830f52f0f5c7f5d7e04d68b10 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210831112936 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083111293661063 LGD_BUYERID = LGD_OID = Direct-ds2avq-1630376822 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 11:28:07======================== insert into mBoard_order set rOrdNo = 'Direct-ds2avq-1630376822', AuthTy = 'card', memberId = 'ds2avq', OrdNm ='김기철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '화일정보산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 532793******7611', rApprNo = 'mjsof2021083111293661063', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 11:28:07', InvoiceNum = '결제성공:Direct-ds2avq-1630376822/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 11:28:07' ========================2021-08-31 11:28:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083111293661063' 0 = 1 cnt = 1 ========================2021-08-31 11:28:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ds2avq' 0 = ds2avq Mid = ds2avq 1 = 화일정보산업 Mcompany = 화일정보산업 2 = 1341391987 companyNum = 1341391987 3 = 031-439-2800 Mtel1 = 031-439-2800 4 = 010-7707-6519 Mhp = 010-7707-6519 ========================2021-08-31 11:28:07======================== select * from customers where id = 'ds2avq' ========================2021-08-31 11:28:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ds2avq','2021-08-31 11:28:07','108000','110000','온라인','0') ========================2021-08-31 13:38:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1630383687 LGD_BUYER = 이경원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831132127 LGD_HASHDATA = 93a47314cb2b4a2443394f7f045c2c64 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 = 20210831133957BC9BC3D3310B4EEA805B9C3373FB1090BZRLKWIA Mname = 이경원 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2021-08-31 13:38:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831133958 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******6845 LGD_FINANCEAUTHNUM = 30076268 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8d78ad789981f3d48bcc5db43480573a LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831133958 LGD_PCANCELSTR = 0 LGD_BUYER = 이경원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083113395760178 LGD_BUYERID = LGD_OID = Direct-uksung1966-1630383687 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 113395760192 ========================2021-08-31 13:43:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1630384993 LGD_BUYER = 이경원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831134313 LGD_HASHDATA = 42a553956e11562392050c9a5140e545 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 = 20210831134519D140DC5F64BE4AD5BB7481DDF6278FE0PHB9BSJT Mname = 이경원 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2021-08-31 13:43:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831134520 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******6845 LGD_FINANCEAUTHNUM = 30076279 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1bd04ea21bd2b3c4f42229a238e403f5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831134520 LGD_PCANCELSTR = 0 LGD_BUYER = 이경원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083113452061236 LGD_BUYERID = LGD_OID = Direct-uksung1966-1630384993 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 113452061273 ========================2021-08-31 13:45:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1630385099 LGD_BUYER = 이성춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831134459 LGD_HASHDATA = dcd350d59886050bdea6e4c24b608923 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 = 20210831134710279B351F6366401E9A8645EB4E451631PDLIXASF Mname = 이성춘 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2021-08-31 13:45:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831134711 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******6845 LGD_FINANCEAUTHNUM = 30076280 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 550a186e57432524f60230cad8ed5d2b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831134711 LGD_PCANCELSTR = 0 LGD_BUYER = 이성춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083113471161147 LGD_BUYERID = LGD_OID = Direct-uksung1966-1630385099 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 113471161161 ========================2021-08-31 13:45:42======================== insert into mBoard_order set rOrdNo = 'Direct-uksung1966-1630385099', AuthTy = 'card', memberId = 'uksung1966', OrdNm ='이성춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '욱성화학공업사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******6845', rApprNo = 'mjsof2021083113471161147', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 13:45:42', InvoiceNum = '결제성공:Direct-uksung1966-1630385099/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 13:45:42' ========================2021-08-31 13:45:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083113471161147' 0 = 1 cnt = 1 ========================2021-08-31 13:45:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'uksung1966' 0 = uksung1966 Mid = uksung1966 1 = 욱성화학공업사 Mcompany = 욱성화학공업사 2 = 113-05-62312 companyNum = 113-05-62312 3 = 031-949-4516 Mtel1 = 031-949-4516 4 = 010-4749-2036 Mhp = 010-4749-2036 ========================2021-08-31 13:45:42======================== select * from customers where id = 'uksung1966' ========================2021-08-31 13:45:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('uksung1966','2021-08-31 13:45:42','108000','110000','온라인','0') ========================2021-08-31 15:06:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dayone-1630389902 LGD_BUYER = 김용구 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831150502 LGD_HASHDATA = d54fe3c7132ef17a73e8efee0cc2d49d 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 = 20210831150731F825EEF4BB7C415F9B9E50BD8222C0D6ZFNTEJU8 Mname = 김용구 Mcompany = (주)데이원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = dayone LGD_ESCROW_USEYN = N ========================2021-08-31 15:06:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831150731 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dayone5@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******8838 LGD_FINANCEAUTHNUM = 30019203 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 02d91955924118652c39a7bfc5b97db3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831150731 LGD_PCANCELSTR = 0 LGD_BUYER = 김용구 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083115073161017 LGD_BUYERID = LGD_OID = Direct-dayone-1630389902 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 115073161061 ========================2021-08-31 15:06:02======================== insert into mBoard_order set rOrdNo = 'Direct-dayone-1630389902', AuthTy = 'card', memberId = 'dayone', OrdNm ='김용구', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)데이원', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******8838', rApprNo = 'mjsof2021083115073161017', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 15:06:02', InvoiceNum = '결제성공:Direct-dayone-1630389902/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 15:06:02' ========================2021-08-31 15:06:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083115073161017' 0 = 1 cnt = 1 ========================2021-08-31 15:06:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dayone' 0 = dayone Mid = dayone 1 = (주)데이원 Mcompany = (주)데이원 2 = 4378700862 companyNum = 4378700862 3 = 010-9580-6207 Mtel1 = 010-9580-6207 4 = 010-9580-6207 Mhp = 010-9580-6207 ========================2021-08-31 15:06:03======================== select * from customers where id = 'dayone' ========================2021-08-31 15:06:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dayone','2021-08-31 15:06:02','30900','33000','온라인','0') ========================2021-08-31 15:27:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimhando-1630391076 LGD_BUYER = 김한도 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831152436 LGD_HASHDATA = bb55bc1383de82babd48e4ca432aee97 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 = 202108311528409DD15A722F194D8A9AFFD1E55DE9F9A8ALXDLJBX Mname = 김한도 Mcompany = 주식회사종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kimhando LGD_ESCROW_USEYN = N ========================2021-08-31 15:27:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831152840 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = daehanmobil1@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373I7C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553172******9491 LGD_FINANCEAUTHNUM = 54277663 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d09bf3d0289063743e78ee54b8291c7f LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210831152840 LGD_PCANCELSTR = 0 LGD_BUYER = 김한도 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083115284061134 LGD_BUYERID = LGD_OID = Direct-kimhando-1630391076 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 15:27:12======================== insert into mBoard_order set rOrdNo = 'Direct-kimhando-1630391076', AuthTy = 'card', memberId = 'kimhando', OrdNm ='김한도', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH MASTER 553172******9491', rApprNo = 'mjsof2021083115284061134', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 15:27:12', InvoiceNum = '결제성공:Direct-kimhando-1630391076/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 15:27:12' ========================2021-08-31 15:27:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083115284061134' 0 = 1 cnt = 1 ========================2021-08-31 15:27:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimhando' 0 = kimhando Mid = kimhando 1 = 주식회사 종합유통 Mcompany = 주식회사 종합유통 2 = 3648100688 companyNum = 3648100688 3 = 044-553-9203 Mtel1 = 044-553-9203 4 = 010-8774-8951 Mhp = 010-8774-8951 ========================2021-08-31 15:27:12======================== select * from customers where id = 'kimhando' ========================2021-08-31 15:27:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimhando','2021-08-31 15:27:12','30900','33000','온라인','0') ========================2021-08-31 16:25:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-feinstyle-1630394712 LGD_BUYER = 최대영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831162512 LGD_HASHDATA = 403bfdb6e6c9892e09a4725995484534 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 = 20210831162724EF00EC3E1F27446381E868EB942D413ALGGRKJLZ Mname = 최대영 Mcompany = 더바이스산업공구상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = feinstyle LGD_ESCROW_USEYN = N ========================2021-08-31 16:25:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831162725 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 473867******3997 LGD_FINANCEAUTHNUM = 44356603 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d4dc19d08a4e89d09b4e5fe16bf089f1 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210831162725 LGD_PCANCELSTR = 0 LGD_BUYER = 최대영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083116272561230 LGD_BUYERID = LGD_OID = Direct-feinstyle-1630394712 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-31 16:25:56======================== insert into mBoard_order set rOrdNo = 'Direct-feinstyle-1630394712', AuthTy = 'card', memberId = 'feinstyle', OrdNm ='최대영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '더바이스산업공구상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 473867******3997', rApprNo = 'mjsof2021083116272561230', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 16:25:56', InvoiceNum = '결제성공:Direct-feinstyle-1630394712/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 16:25:56' ========================2021-08-31 16:25:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083116272561230' 0 = 1 cnt = 1 ========================2021-08-31 16:25:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'feinstyle' 0 = feinstyle Mid = feinstyle 1 = 더바이스산업공구상사 Mcompany = 더바이스산업공구상사 2 = 621-21-51072 companyNum = 621-21-51072 3 = 070-4127-0909 Mtel1 = 070-4127-0909 4 = 010-4437-6515 Mhp = 010-4437-6515 ========================2021-08-31 16:25:56======================== select * from customers where id = 'feinstyle' ========================2021-08-31 16:25:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('feinstyle','2021-08-31 16:25:56','10000','11000','온라인','0') ========================2021-08-31 16:26:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1630394725 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831162525 LGD_HASHDATA = c49327b43297239106fe4a3052bb6023 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 = 20210831162805772A995DB08649B8BC68EDAA2E985A78XY2LMLQG Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2021-08-31 16:26:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831162806 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 0000V0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553531******0117 LGD_FINANCEAUTHNUM = 59672976 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 93212733934dffc56b34aade96a1a663 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831162806 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021083116280561246 LGD_BUYERID = LGD_OID = Direct-kyg2031-1630394725 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 311628231824 ========================2021-08-31 16:26:37======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1630394725', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 553531******0117', rApprNo = 'mjsof2021083116280561246', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 16:26:37', InvoiceNum = '결제성공:Direct-kyg2031-1630394725/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 16:26:37' ========================2021-08-31 16:26:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083116280561246' 0 = 1 cnt = 1 ========================2021-08-31 16:26:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-9875-4995 Mhp = 010-9875-4995 ========================2021-08-31 16:26:37======================== select * from customers where id = 'kyg2031' ========================2021-08-31 16:26:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2021-08-31 16:26:37','52500','55000','온라인','0') ========================2021-08-31 16:37:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jaesu5277-1630395366 LGD_BUYER = 김재수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831163606 LGD_HASHDATA = 29cf6c85d13faafbb0dd36a9656004a3 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 = 2021083116383471BE767E6B6F49B9A8111AD6EC42CFF8QUKLQJPZ Mname = 김재수 Mcompany = (주)제이에스전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jaesu5277 LGD_ESCROW_USEYN = N ========================2021-08-31 16:37:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831163835 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******9989 LGD_FINANCEAUTHNUM = 59736221 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c5c80fb941039ff8c5a62db01e4cbea1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831163835 LGD_PCANCELSTR = 0 LGD_BUYER = 김재수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof2021083116383460192 LGD_BUYERID = LGD_OID = Direct-jaesu5277-1630395366 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116383460107 ========================2021-08-31 16:38:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jaesu5277-1630395453 LGD_BUYER = 김재수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831163733 LGD_HASHDATA = 5fd9655be52e0cc3f0ed53fd63693edf 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 = 20210831163948B3CD7805A5B7404DB12640BD94F8B72FI73HK0HQ Mname = 김재수 Mcompany = (주)제이에스전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jaesu5277 LGD_ESCROW_USEYN = N ========================2021-08-31 16:38:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831163949 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = idda1224@nate.com 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******9989 LGD_FINANCEAUTHNUM = 59750097 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 42db26a89f2cf340243fd4b793f5e9de LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831163949 LGD_PCANCELSTR = 0 LGD_BUYER = 김재수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083116394860086 LGD_BUYERID = LGD_OID = Direct-jaesu5277-1630395453 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116394860018 ========================2021-08-31 16:40:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jaesu5277-1630395504 LGD_BUYER = 김재수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831163824 LGD_HASHDATA = 4f0a1e5a109c83259d9d2a450a49b267 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 = 20210831164206F42EAA6959BD4C5F9A28D66493027F70ANJDDPEY Mname = 김재수 Mcompany = (주)제이에스전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jaesu5277 LGD_ESCROW_USEYN = N ========================2021-08-31 16:40:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831164206 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = idda1224@nate.com 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******9989 LGD_FINANCEAUTHNUM = 59757174 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6a869e542ef3aa80996a95987e8d114c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831164207 LGD_PCANCELSTR = 0 LGD_BUYER = 김재수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083116420660150 LGD_BUYERID = LGD_OID = Direct-jaesu5277-1630395504 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116420660152 ========================2021-08-31 16:54:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jaesu5277-1630396358 LGD_BUYER = 김재수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831165238 LGD_HASHDATA = eaec62686a9a51bf8d47a7453d353329 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 = 20210831165533569D450FE3F6414A9CA97B380AFBAABEETLMMNQS Mname = 김재수 Mcompany = (주)제이에스전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jaesu5277 LGD_ESCROW_USEYN = N ========================2021-08-31 16:54:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831165533 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******9989 LGD_FINANCEAUTHNUM = 59843645 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9471fad09615553a8325515c14a2ac49 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831165534 LGD_PCANCELSTR = 0 LGD_BUYER = 김재수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083116553360136 LGD_BUYERID = LGD_OID = Direct-jaesu5277-1630396358 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 116553360100 ========================2021-08-31 16:54:05======================== insert into mBoard_order set rOrdNo = 'Direct-jaesu5277-1630396358', AuthTy = 'card', memberId = 'jaesu5277', OrdNm ='김재수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)제이에스전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 625003******9989', rApprNo = 'mjsof2021083116553360136', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 16:54:05', InvoiceNum = '결제성공:Direct-jaesu5277-1630396358/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 16:54:05' ========================2021-08-31 16:54:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083116553360136' 0 = 1 cnt = 1 ========================2021-08-31 16:54:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jaesu5277' 0 = jaesu5277 Mid = jaesu5277 1 = (주)제이에스전기 Mcompany = (주)제이에스전기 2 = 3018619105 companyNum = 3018619105 3 = 043-838-8471 Mtel1 = 043-838-8471 4 = 010-7492-0609 Mhp = 010-7492-0609 ========================2021-08-31 16:54:05======================== select * from customers where id = 'jaesu5277' ========================2021-08-31 16:54:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jaesu5277','2021-08-31 16:54:05','108000','110000','온라인','0') ========================2021-08-31 16:58:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-euungut-1630396589 LGD_BUYER = 임수미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831165629 LGD_HASHDATA = 1c4e2fd85133193d8364a3ae8146e3a6 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 = 20210831170007AD3CBB27EFE846E28F3CAA192BF28F9DTR7ERZQZ Mname = 임수미 Mcompany = (주)이찌마루로꾸일공육에이앤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = euungut LGD_ESCROW_USEYN = N ========================2021-08-31 16:58:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831170008 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******2882 LGD_FINANCEAUTHNUM = 30116811 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a25f32f963b45fc214882be7ae292803 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831170008 LGD_PCANCELSTR = 0 LGD_BUYER = 임수미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083117000760147 LGD_BUYERID = LGD_OID = Direct-euungut-1630396589 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 117000760197 ========================2021-08-31 16:58:39======================== insert into mBoard_order set rOrdNo = 'Direct-euungut-1630396589', AuthTy = 'card', memberId = 'euungut', OrdNm ='임수미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)이찌마루로꾸일공육에이앤', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2882', rApprNo = 'mjsof2021083117000760147', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 16:58:39', InvoiceNum = '결제성공:Direct-euungut-1630396589/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 16:58:39' ========================2021-08-31 16:58:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083117000760147' 0 = 1 cnt = 1 ========================2021-08-31 16:58:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'euungut' 0 = euungut Mid = euungut 1 = (주)이찌마루로꾸일공육에이앤 Mcompany = (주)이찌마루로꾸일공육에이앤 2 = 211-88-77785 companyNum = 211-88-77785 3 = 02-3445-0813 Mtel1 = 02-3445-0813 4 = 010-7122-3588 Mhp = 010-7122-3588 ========================2021-08-31 16:58:39======================== select * from customers where id = 'euungut' ========================2021-08-31 16:58:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('euungut','2021-08-31 16:58:39','108000','110000','온라인','0') ========================2021-08-31 17:20:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-damiki-1630397955 LGD_BUYER = 박영옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831171915 LGD_HASHDATA = 4fa6c1892bf9439030e17d8dad825be3 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 = 20210831172206FE5647B8FDF7451B9B7F66B0CD0E4C252AP42NWW Mname = 박영옥 Mcompany = 다미끼크라프트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = damiki LGD_ESCROW_USEYN = N ========================2021-08-31 17:20:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831172207 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******0974 LGD_FINANCEAUTHNUM = 60032129 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f9c08529cad3cabbe5885faa12765cfe LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210831172207 LGD_PCANCELSTR = 0 LGD_BUYER = 박영옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083117220760268 LGD_BUYERID = LGD_OID = Direct-damiki-1630397955 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 117220760209 ========================2021-08-31 17:20:38======================== insert into mBoard_order set rOrdNo = 'Direct-damiki-1630397955', AuthTy = 'card', memberId = 'damiki', OrdNm ='박영옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다미끼크라프트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******0974', rApprNo = 'mjsof2021083117220760268', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 17:20:38', InvoiceNum = '결제성공:Direct-damiki-1630397955/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 17:20:38' ========================2021-08-31 17:20:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083117220760268' 0 = 1 cnt = 1 ========================2021-08-31 17:20:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'damiki' 0 = damiki Mid = damiki 1 = 다미끼크라프트 Mcompany = 다미끼크라프트 2 = 138-03-73658 companyNum = 138-03-73658 3 = 031-348-9201 Mtel1 = 031-348-9201 4 = 010-2658-0429 Mhp = 010-2658-0429 ========================2021-08-31 17:20:39======================== select * from customers where id = 'damiki' ========================2021-08-31 17:20:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('damiki','2021-08-31 17:20:38','220000','220000','온라인','0') ========================2021-08-31 20:00:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mibaek-1630407332 LGD_BUYER = 임준범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210831195532 LGD_HASHDATA = 42d14edc021fdbef19f5e71380be9a5e 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 = 20210831200206B8F99CF25E224AB7BDF1842E263391EFAXTKVMMX Mname = 임준범 Mcompany = (주)미백 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mibaek LGD_ESCROW_USEYN = N ========================2021-08-31 20:00:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210831200206 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******6860 LGD_FINANCEAUTHNUM = 30052720 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 68a19d3458c65c74a6e0b6eadb7e6cad LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210831200207 LGD_PCANCELSTR = 0 LGD_BUYER = 임준범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021083120020660030 LGD_BUYERID = LGD_OID = Direct-mibaek-1630407332 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 120020660027 ========================2021-08-31 20:00:37======================== insert into mBoard_order set rOrdNo = 'Direct-mibaek-1630407332', AuthTy = 'card', memberId = 'mibaek', OrdNm ='임준범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미백', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******6860', rApprNo = 'mjsof2021083120020660030', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-31 20:00:37', InvoiceNum = '결제성공:Direct-mibaek-1630407332/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-31 20:00:37' ========================2021-08-31 20:00:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021083120020660030' 0 = 1 cnt = 1 ========================2021-08-31 20:00:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mibaek' 0 = mibaek Mid = mibaek 1 = (주)미백 Mcompany = (주)미백 2 = 1268646239 companyNum = 1268646239 3 = 070-4036-5559 Mtel1 = 070-4036-5559 4 = 010-9489-9618 Mhp = 010-9489-9618 ========================2021-08-31 20:00:38======================== select * from customers where id = 'mibaek' ========================2021-08-31 20:00:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mibaek','2021-08-31 20:00:37','220000','220000','온라인','0')