========================2022-05-04 09:44:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1651625037 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504094357 LGD_HASHDATA = 7d517b16f6e911f5367ed58f68a8bcbf 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 = 2022050409445983C5E891F9E84A5F9799B8F930DFFFADINEKBZE1 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-05-04 09:44:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504094459 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 = 943017******4487 LGD_FINANCEAUTHNUM = 74235045 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2e8e55437713485de6b286662facf293 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220504094500 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504094459tNWm4 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1651625037 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 09:44:52======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1651625037', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******4487', rApprNo = 'mjsof20220504094459tNWm4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 09:44:52', InvoiceNum = '결제성공:Direct-goodssal5707-1651625037/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 09:44:52' ========================2022-05-04 09:44:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504094459tNWm4' 0 = 1 cnt = 1 ========================2022-05-04 09:44:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-05-04 09:44:52======================== select * from customers where id = 'goodssal5707' ========================2022-05-04 09:44:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-05-04 09:44:52','220000','220000','온라인','0') ========================2022-05-04 09:46:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1651625102 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504094502 LGD_HASHDATA = 4fca19977371865b68384480f0c4ff26 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 = 20220504094625AB67BD00D2D44E5C993FF39BA54E2658U1M9RCLZ Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-05-04 09:46:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504094626 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 = 943017******4487 LGD_FINANCEAUTHNUM = 74246289 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8b02728bc3bdb252065d8a5cbfe8b295 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220504094626 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504094626tNZN7 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1651625102 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 09:46:18======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1651625102', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******4487', rApprNo = 'mjsof20220504094626tNZN7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 09:46:18', InvoiceNum = '결제성공:Direct-goodssal5707-1651625102/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 09:46:18' ========================2022-05-04 09:46:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504094626tNZN7' 0 = 1 cnt = 1 ========================2022-05-04 09:46:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-05-04 09:46:19======================== select * from customers where id = 'goodssal5707' ========================2022-05-04 09:46:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-05-04 09:46:18','220000','220000','온라인','0') ========================2022-05-04 11:24:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paolo1117-1651630997 LGD_BUYER = 권혁래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504112317 LGD_HASHDATA = 10b8dbccbcbc87498bc0d0656e93cbb8 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 = 20220504112449CE1ED88A5597446EAF8577CC97805E0AWNRZFZSO Mname = 권혁래 Mcompany = 푸드스토어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paolo1117 LGD_ESCROW_USEYN = N ========================2022-05-04 11:24:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504112449 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = DAAAPS LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553152******3862 LGD_FINANCEAUTHNUM = 05998372 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 575eadacdc89100a5735f79798f0b8c4 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220504112449 LGD_PCANCELSTR = 0 LGD_BUYER = 권혁래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504112449tV086 LGD_BUYERID = LGD_OID = Direct-paolo1117-1651630997 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 11:24:41======================== insert into mBoard_order set rOrdNo = 'Direct-paolo1117-1651630997', AuthTy = 'card', memberId = 'paolo1117', OrdNm ='권혁래', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '푸드스토어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한MASTER 553152******3862', rApprNo = 'mjsof20220504112449tV086', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 11:24:41', InvoiceNum = '결제성공:Direct-paolo1117-1651630997/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 11:24:41' ========================2022-05-04 11:24:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504112449tV086' 0 = 1 cnt = 1 ========================2022-05-04 11:24:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'paolo1117' 0 = paolo1117 Mid = paolo1117 1 = 푸드스토어 Mcompany = 푸드스토어 2 = 1308706795 companyNum = 1308706795 3 = 032-676-6626 Mtel1 = 032-676-6626 4 = 010-8999-6626 Mhp = 010-8999-6626 ========================2022-05-04 11:24:41======================== select * from customers where id = 'paolo1117' ========================2022-05-04 11:24:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('paolo1117','2022-05-04 11:24:41','30900','33000','온라인','0') ========================2022-05-04 11:30:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dsdb1011-1651631352 LGD_BUYER = 윤경미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504112912 LGD_HASHDATA = db16a5cedddd6996a1fd320279dd86f8 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 = 202205041130151F4F6A317D704795A446E33DB5D7CB0ARWTGO2EJ Mname = 윤경미 Mcompany = (주)디에스동부대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dsdb1011 LGD_ESCROW_USEYN = N ========================2022-05-04 11:30:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504113015 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******5962 LGD_FINANCEAUTHNUM = 56234123 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2a3b6e313110d107128c53f4766eeb1b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220504113015 LGD_PCANCELSTR = 0 LGD_BUYER = 윤경미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504113015onE35 LGD_BUYERID = LGD_OID = Direct-dsdb1011-1651631352 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4113015o49b5 ========================2022-05-04 11:30:07======================== insert into mBoard_order set rOrdNo = 'Direct-dsdb1011-1651631352', AuthTy = 'card', memberId = 'dsdb1011', OrdNm ='윤경미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에스동부대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 654132******5962', rApprNo = 'mjsof20220504113015onE35', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 11:30:07', InvoiceNum = '결제성공:Direct-dsdb1011-1651631352/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 11:30:07' ========================2022-05-04 11:30:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504113015onE35' 0 = 1 cnt = 1 ========================2022-05-04 11:30:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dsdb1011' 0 = dsdb1011 Mid = dsdb1011 1 = (주)디에스동부대리점 Mcompany = (주)디에스동부대리점 2 = 6458601112 companyNum = 6458601112 3 = 010-4556-6507 Mtel1 = 010-4556-6507 4 = 010-4564-2692 Mhp = 010-4564-2692 ========================2022-05-04 11:30:07======================== select * from customers where id = 'dsdb1011' ========================2022-05-04 11:30:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dsdb1011','2022-05-04 11:30:07','52500','55000','온라인','0') ========================2022-05-04 14:32:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kgr1214-1651642296 LGD_BUYER = 김경래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504143136 LGD_HASHDATA = 8d6c513573c07c2060878be230845374 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 = 20220504143246BA639F6454384ED0B83B3B5BF5138C83O51L5E6X Mname = 김경래 Mcompany = 지성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kgr1214 LGD_ESCROW_USEYN = N ========================2022-05-04 14:32:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504143247 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003239 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941049******9059 LGD_FINANCEAUTHNUM = 30051141 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8101365a50150f68558ac1cb5d0003dd LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220504143247 LGD_PCANCELSTR = 0 LGD_BUYER = 김경래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504143247t84n3 LGD_BUYERID = LGD_OID = Direct-kgr1214-1651642296 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 14:33:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kgr1214-1651642393 LGD_BUYER = 김경래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504143313 LGD_HASHDATA = 61b632429e038de46fb2defa0bffdf79 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 = 20220504143405DE04EE4EA6374C86B7D78B9063841516NWU4IWKH Mname = 김경래 Mcompany = 지성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kgr1214 LGD_ESCROW_USEYN = N ========================2022-05-04 14:33:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504143405 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003239 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941049******1009 LGD_FINANCEAUTHNUM = 30051152 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ecb55d4a57485b73d9e35d9697c6eaa7 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220504143406 LGD_PCANCELSTR = 0 LGD_BUYER = 김경래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504143405u9tE4 LGD_BUYERID = LGD_OID = Direct-kgr1214-1651642393 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 14:36:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kgr1214-1651642503 LGD_BUYER = 김경래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504143503 LGD_HASHDATA = 8e052d468709e97a0bf8517d4f854102 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 = 20220504143653FD5798B576C44FA8A6A20FF700598C98JM7KTMPT Mname = 김경래 Mcompany = 지성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kgr1214 LGD_ESCROW_USEYN = N ========================2022-05-04 14:36:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504143653 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003239 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941049******0059 LGD_FINANCEAUTHNUM = 30051163 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 38f8c2158fc7a5f3dbc55cebc2275be2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220504143653 LGD_PCANCELSTR = 0 LGD_BUYER = 김경래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504143653xqjI6 LGD_BUYERID = LGD_OID = Direct-kgr1214-1651642503 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-05-04 17:13:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1651651956 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504171236 LGD_HASHDATA = 5a9641e52fe248b690e82ce5a8e6f98a 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 = 2022050417134438335157006E417E970611398C26CF9FUEST9XXF Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2022-05-04 17:13:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504171344 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943003******7980 LGD_FINANCEAUTHNUM = 58996391 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5ec28849938f77976caeef74a1cb3bb1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220504171345 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504171344MV2V9 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1651651956 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4171344MiIX9 ========================2022-05-04 17:13:36======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1651651956', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943003******7980', rApprNo = 'mjsof20220504171344MV2V9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 17:13:36', InvoiceNum = '결제성공:Direct-mmthcoffee-1651651956/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 17:13:36' ========================2022-05-04 17:13:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504171344MV2V9' 0 = 1 cnt = 1 ========================2022-05-04 17:13:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2022-05-04 17:13:36======================== select * from customers where id = 'mmthcoffee' ========================2022-05-04 17:13:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2022-05-04 17:13:36','220000','220000','온라인','0') ========================2022-05-04 17:14:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1651652063 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504171423 LGD_HASHDATA = 801df5cb3c3f8d5f6331f6dd1ef16e1a 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 = 20220504171507F812C16A9F934087AAF9D84FF7AB9259FD98OUKX Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2022-05-04 17:15:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504171508 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943003******7980 LGD_FINANCEAUTHNUM = 59002760 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7f81feb3027d6a2d680ded95a9237cce LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220504171508 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504171507VClP5 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1651652063 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4171507VulH5 ========================2022-05-04 17:15:00======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1651652063', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943003******7980', rApprNo = 'mjsof20220504171507VClP5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 17:15:00', InvoiceNum = '결제성공:Direct-mmthcoffee-1651652063/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 17:15:00' ========================2022-05-04 17:15:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504171507VClP5' 0 = 1 cnt = 1 ========================2022-05-04 17:15:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2022-05-04 17:15:00======================== select * from customers where id = 'mmthcoffee' ========================2022-05-04 17:15:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2022-05-04 17:15:00','220000','220000','온라인','0') ========================2022-05-04 17:29:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1651652920 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220504172840 LGD_HASHDATA = 1a56edfeefbcb7f5ad6da8cadf2c11e2 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 = 2022050417294344D32150B251405EBA53E0626F53B043T9BWJY6K 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 ========================2022-05-04 17:29:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220504172944 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 625003******2941 LGD_FINANCEAUTHNUM = 59124023 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9fdddb277f32faa38677985514e4ea8d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220504172944 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220504172944Qc9o0 LGD_BUYERID = LGD_OID = Direct-neotool-1651652920 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4172944QRka2 ========================2022-05-04 17:29:36======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1651652920', 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 = 'mjsof20220504172944Qc9o0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-05-04 17:29:36', InvoiceNum = '결제성공:Direct-neotool-1651652920/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-05-04 17:29:36' ========================2022-05-04 17:29:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220504172944Qc9o0' 0 = 1 cnt = 1 ========================2022-05-04 17:29:36======================== 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 ========================2022-05-04 17:29:36======================== select * from customers where id = 'neotool' ========================2022-05-04 17:29:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2022-05-04 17:29:36','108000','110000','온라인','0')