========================2021-08-09 11:30:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-choisuan-1628476176 LGD_BUYER = 최수안 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809112936 LGD_HASHDATA = 31afa10c0b1268ef5a8a4c6944e020dc 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 = 202108091131489E11BA1FE01D4703B6DCE7B8A13CA786ATCCFPAA Mname = 최수안 Mcompany = 이에프전산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = choisuan LGD_ESCROW_USEYN = N ========================2021-08-09 11:30:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809113148 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFG03J LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941061******4976 LGD_FINANCEAUTHNUM = 13228039 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 076d8674b702d8a7c7326a9d0d83f7e3 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210809113149 LGD_PCANCELSTR = 0 LGD_BUYER = 최수안 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080911314861000 LGD_BUYERID = LGD_OID = Direct-choisuan-1628476176 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-09 11:30:44======================== insert into mBoard_order set rOrdNo = 'Direct-choisuan-1628476176', AuthTy = 'card', memberId = 'choisuan', OrdNm ='최수안', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이에프전산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한 941061******4976', rApprNo = 'mjsof2021080911314861000', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-09 11:30:44', InvoiceNum = '결제성공:Direct-choisuan-1628476176/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-09 11:30:44' ========================2021-08-09 11:30:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080911314861000' 0 = 1 cnt = 1 ========================2021-08-09 11:30:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'choisuan' 0 = choisuan Mid = choisuan 1 = 이에프전산 Mcompany = 이에프전산 2 = 134-21-19087 companyNum = 134-21-19087 3 = 031-439-6114 Mtel1 = 031-439-6114 4 = 010-3380-8923 Mhp = 010-3380-8923 ========================2021-08-09 11:30:44======================== select * from customers where id = 'choisuan' ========================2021-08-09 11:30:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('choisuan','2021-08-09 11:30:44','52500','55000','온라인','0') ========================2021-08-09 12:18:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jhs177-1628479091 LGD_BUYER = 진희성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809121811 LGD_HASHDATA = 046b004095e4416a8d71d57a4cb18599 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 = 202108091219450F35CBCD3DE743DF8BC75E96AB212105HXCT8PCF Mname = 진희성 Mcompany = 푸른교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jhs177 LGD_ESCROW_USEYN = N ========================2021-08-09 12:18:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809121946 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 = 624363******0907 LGD_FINANCEAUTHNUM = 58770694 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 20fec4abbe04ebef953fb38a2835e908 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210809121946 LGD_PCANCELSTR = 0 LGD_BUYER = 진희성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080912194660114 LGD_BUYERID = LGD_OID = Direct-jhs177-1628479091 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-09 12:20:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jhs177-1628479184 LGD_BUYER = 진희성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809121944 LGD_HASHDATA = 658f05a8c267e41e31ad86ef63d738de 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 = 202108091221315D785B4A9C2D4D719A828813413A98D5DADBQDWV Mname = 진희성 Mcompany = 푸른교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jhs177 LGD_ESCROW_USEYN = N ========================2021-08-09 12:20:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809122132 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009040 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 540926******1071 LGD_FINANCEAUTHNUM = 30023393 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c0fd0b15f5724d77c74168e06e3f0269 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210809122132 LGD_PCANCELSTR = 0 LGD_BUYER = 진희성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080912213260257 LGD_BUYERID = LGD_OID = Direct-jhs177-1628479184 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-09 14:18:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-olym8561-1628486257 LGD_BUYER = 이종미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809141737 LGD_HASHDATA = eb56275e4759d6ff521c73afeafbf542 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 = 202108091419336588F4DF0C3B45F9B0215731BE6395D1D2RZMWGY Mname = 이종미 Mcompany = (주)올림포스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = olym8561 LGD_ESCROW_USEYN = N ========================2021-08-09 14:18:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809141934 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414025******6922 LGD_FINANCEAUTHNUM = 64764627 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 36431373f51196c8f834052cfc5d56d0 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210809141935 LGD_PCANCELSTR = 0 LGD_BUYER = 이종미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080914193461231 LGD_BUYERID = LGD_OID = Direct-olym8561-1628486257 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 914193461267 ========================2021-08-09 14:18:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-olym8561-1628486257 LGD_BUYER = 이종미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809141737 LGD_HASHDATA = eb56275e4759d6ff521c73afeafbf542 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 = 202108091419336588F4DF0C3B45F9B0215731BE6395D1D2RZMWGY Mname = 이종미 Mcompany = (주)올림포스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = olym8561 LGD_ESCROW_USEYN = N ========================2021-08-09 14:18:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809141959 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-olym8561-1628486257]는 2021/08/09 14:19:34 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 64764627 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = ccb6f780dd6a7c8fd04593464fadd016 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20210809141959 LGD_PCANCELSTR = 0 LGD_BUYER = 이종미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof2021080914193461231 LGD_BUYERID = LGD_OID = Direct-olym8561-1628486257 LGD_RESPCODE = S007 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-08-09 14:23:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-olym8561-1628486578 LGD_BUYER = 이종미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809142258 LGD_HASHDATA = 68aa102b9dce215444cf1196b5ad834c 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 = 20210809142448684AE9204D7D476AAC6C50730B371030FQBZJYLO Mname = 이종미 Mcompany = (주)올림포스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = olym8561 LGD_ESCROW_USEYN = N ========================2021-08-09 14:23:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809142448 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414025******6922 LGD_FINANCEAUTHNUM = 64765465 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ebe53a8adf6a500e53ea78f63ac7b53d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210809142449 LGD_PCANCELSTR = 0 LGD_BUYER = 이종미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080914244861130 LGD_BUYERID = LGD_OID = Direct-olym8561-1628486578 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 914244861116 ========================2021-08-09 14:23:44======================== insert into mBoard_order set rOrdNo = 'Direct-olym8561-1628486578', AuthTy = 'card', memberId = 'olym8561', OrdNm ='이종미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)올림포스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 414025******6922', rApprNo = 'mjsof2021080914244861130', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-09 14:23:44', InvoiceNum = '결제성공:Direct-olym8561-1628486578/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-09 14:23:44' ========================2021-08-09 14:23:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080914244861130' 0 = 1 cnt = 1 ========================2021-08-09 14:23:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'olym8561' 0 = olym8561 Mid = olym8561 1 = (주)올림포스 Mcompany = (주)올림포스 2 = 1288651704 companyNum = 1288651704 3 = 031-925-8919 Mtel1 = 031-925-8919 4 = 010-9148-2629 Mhp = 010-9148-2629 ========================2021-08-09 14:23:44======================== select * from customers where id = 'olym8561' ========================2021-08-09 14:23:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('olym8561','2021-08-09 14:23:44','52500','55000','온라인','0') ========================2021-08-09 19:47:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dcnet727812-1628505951 LGD_BUYER = 강선정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809194551 LGD_HASHDATA = cabea3d7313b50e9d5ba0722e9c1cae7 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 = 20210809194825E0F820B53A4145BE8ABEDBCA93709391R7EX4FTL Mname = 강선정 Mcompany = 주식회사 디씨넷 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dcnet727812 LGD_ESCROW_USEYN = N ========================2021-08-09 19:47:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809194825 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 = 467009******4914 LGD_FINANCEAUTHNUM = 33445217 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = da06f4334c0654310f03830bab26f9c8 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20210809194825 LGD_PCANCELSTR = 0 LGD_BUYER = 강선정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080919482560265 LGD_BUYERID = LGD_OID = Direct-dcnet727812-1628505951 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-09 19:47:20======================== insert into mBoard_order set rOrdNo = 'Direct-dcnet727812-1628505951', AuthTy = 'card', memberId = 'dcnet727812', OrdNm ='강선정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 디씨넷', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데VISA 467009******4914', rApprNo = 'mjsof2021080919482560265', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-09 19:47:20', InvoiceNum = '결제성공:Direct-dcnet727812-1628505951/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-09 19:47:20' ========================2021-08-09 19:47:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080919482560265' 0 = 1 cnt = 1 ========================2021-08-09 19:47:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dcnet727812' 0 = dcnet727812 Mid = dcnet727812 1 = 주식회사 디씨넷 Mcompany = 주식회사 디씨넷 2 = 139-87-00745 companyNum = 139-87-00745 3 = 02-2616-7278 Mtel1 = 02-2616-7278 4 = 010-5592-5926 Mhp = 010-5592-5926 ========================2021-08-09 19:47:21======================== select * from customers where id = 'dcnet727812' ========================2021-08-09 19:47:21======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('dcnet727812','주식회사 디씨넷','1398700745','02-2616-7278','010-5592-5926','2021-08-09 19:47:20','온라인') ========================2021-08-09 19:47:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dcnet727812','2021-08-09 19:47:20','220000','220000','온라인','0') ========================2021-08-09 21:04:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rkddyd112-1628510509 LGD_BUYER = 강용진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210809210149 LGD_HASHDATA = 27f667aea7e085266dbe974bf31c36d5 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 = 202108092105493CCA63ECECD842E78585ECD47F6B35D5GACWWEUA Mname = 강용진 Mcompany = 용진농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = rkddyd112 LGD_ESCROW_USEYN = N ========================2021-08-09 21:04:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210809210549 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 = 559924******7109 LGD_FINANCEAUTHNUM = 00713926 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4c65645e2f28b6c8193c0658d532a76d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210809210550 LGD_PCANCELSTR = 0 LGD_BUYER = 강용진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080921054961081 LGD_BUYERID = LGD_OID = Direct-rkddyd112-1628510509 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-09 21:04:45======================== insert into mBoard_order set rOrdNo = 'Direct-rkddyd112-1628510509', AuthTy = 'card', memberId = 'rkddyd112', OrdNm ='강용진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '용진농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대MASTER 559924******7109', rApprNo = 'mjsof2021080921054961081', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-09 21:04:45', InvoiceNum = '결제성공:Direct-rkddyd112-1628510509/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-09 21:04:45' ========================2021-08-09 21:04:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080921054961081' 0 = 1 cnt = 1 ========================2021-08-09 21:04:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rkddyd112' 0 = rkddyd112 Mid = rkddyd112 1 = 용진농산 Mcompany = 용진농산 2 = 2013663311 companyNum = 2013663311 3 = 010-3775-1986 Mtel1 = 010-3775-1986 4 = 010-3775-1986 Mhp = 010-3775-1986 ========================2021-08-09 21:04:45======================== select * from customers where id = 'rkddyd112' ========================2021-08-09 21:04:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rkddyd112','2021-08-09 21:04:45','10000','11000','온라인','0')