========================2022-03-04 08:16:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1646349295 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304081455 LGD_HASHDATA = 1eb0db959191425b37b876cc5e680e14 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 = 202203040821000C078B246A5148CCA3E6491035C7C139DTU6O4VQ 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-03-04 08:16:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304082100 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 = 65815103 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bc8ad0be541aabf3889056119c017d7c LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220304082101 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304082100y75M6 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1646349295 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 08:16:09======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1646349295', 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 = 'mjsof20220304082100y75M6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 08:16:09', InvoiceNum = '결제성공:Direct-goodssal5707-1646349295/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 08:16:09' ========================2022-03-04 08:16:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304082100y75M6' 0 = 1 cnt = 1 ========================2022-03-04 08:16:09======================== 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-03-04 08:16:09======================== select * from customers where id = 'goodssal5707' ========================2022-03-04 08:16:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-03-04 08:16:09','220000','220000','온라인','0') ========================2022-03-04 08:17:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1646349381 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304081621 LGD_HASHDATA = 672eb0a8887dfb4bd2a9f97d6583b3f0 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 = 202203040821538DA27709ED1347108CBC3EB9FAF96686IZEPXVCR 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-03-04 08:17:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304082154 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 = 65818535 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e101a5a6302564b008e48fb1a6cc678e LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220304082154 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304082153A6oR5 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1646349381 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 08:17:02======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1646349381', 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 = 'mjsof20220304082153A6oR5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 08:17:02', InvoiceNum = '결제성공:Direct-goodssal5707-1646349381/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 08:17:02' ========================2022-03-04 08:17:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304082153A6oR5' 0 = 1 cnt = 1 ========================2022-03-04 08:17:03======================== 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-03-04 08:17:03======================== select * from customers where id = 'goodssal5707' ========================2022-03-04 08:17:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-03-04 08:17:02','220000','220000','온라인','0') ========================2022-03-04 08:51:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnam4051-1646351372 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304084932 LGD_HASHDATA = d8b8b2bba1424e0d62786ad44fd2a664 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 = 202203040856182575F8AAFE66480C8CCDB1AF7F848DE9MH5UH6XN Mname = 이정훈 Mcompany = 동남상회 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = dongnam4051 LGD_ESCROW_USEYN = N ========================2022-03-04 08:51:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304085618 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 = 457493******8416 LGD_FINANCEAUTHNUM = 00160957 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6dae47369a3b7255c0d466bc45503850 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220304085618 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304085618u0TW8 LGD_BUYERID = LGD_OID = Direct-dongnam4051-1646351372 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 08:51:26======================== insert into mBoard_order set rOrdNo = 'Direct-dongnam4051-1646351372', AuthTy = 'card', memberId = 'dongnam4051', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동남상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 457493******8416', rApprNo = 'mjsof20220304085618u0TW8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 08:51:26', InvoiceNum = '결제성공:Direct-dongnam4051-1646351372/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 08:51:26' ========================2022-03-04 08:51:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304085618u0TW8' 0 = 1 cnt = 1 ========================2022-03-04 08:51:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongnam4051' 0 = dongnam4051 Mid = dongnam4051 1 = 동남상회 Mcompany = 동남상회 2 = 3053766242 companyNum = 3053766242 3 = 010-2019-7470 Mtel1 = 010-2019-7470 4 = 010-2019-7470 Mhp = 010-2019-7470 ========================2022-03-04 08:51:26======================== select * from customers where id = 'dongnam4051' ========================2022-03-04 08:51:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnam4051','2022-03-04 08:51:26','30900','33000','온라인','0') ========================2022-03-04 09:39:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1646354249 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304093729 LGD_HASHDATA = 00ac460a659bfd0c3f93db2bcf477af8 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 = 20220304094405D56278427F504B53B7D3F1DD8C0CFC0FZNCWDZE2 Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2022-03-04 09:39:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304094405 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 = 940915******2716 LGD_FINANCEAUTHNUM = 31491061 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2f271ec4a908c3b42283ce67377db6f7 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20220304094406 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304094405zh860 LGD_BUYERID = LGD_OID = Direct-antwin77-1646354249 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 09:39:14======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1646354249', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 940915******2716', rApprNo = 'mjsof20220304094405zh860', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 09:39:14', InvoiceNum = '결제성공:Direct-antwin77-1646354249/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 09:39:14' ========================2022-03-04 09:39:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304094405zh860' 0 = 1 cnt = 1 ========================2022-03-04 09:39:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2022-03-04 09:39:14======================== select * from customers where id = 'antwin77' ========================2022-03-04 09:39:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2022-03-04 09:39:14','52500','55000','온라인','0') ========================2022-03-04 09:53:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pk7646-1646355143 LGD_BUYER = 박기덕 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304095223 LGD_HASHDATA = 966f0b586ca48d1ac333d602e5e047b2 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 = 202203040958361DC58A3E49A4484E9A1677A000C4B4DAFQAUBEEE Mname = 박기덕 Mcompany = 한성씨엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pk7646 LGD_ESCROW_USEYN = N ========================2022-03-04 09:53:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304095837 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 129389 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538811******4563 LGD_FINANCEAUTHNUM = 57049522 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fe6a628b381e92db08a9f23c16614931 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220304095837 LGD_PCANCELSTR = 0 LGD_BUYER = 박기덕 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304095837tgeE2 LGD_BUYERID = LGD_OID = Direct-pk7646-1646355143 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4095837t9yx7 ========================2022-03-04 10:05:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pk7646-1646355852 LGD_BUYER = 박기덕 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304100412 LGD_HASHDATA = dd299086a7775f10a0535b16f870ce8c 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 = 20220304101017C97870A4B98642BC9140454E762C3F88QTLYDXWP Mname = 박기덕 Mcompany = 한성씨엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pk7646 LGD_ESCROW_USEYN = N ========================2022-03-04 10:05:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304101018 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 129389 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538811******4563 LGD_FINANCEAUTHNUM = 57133615 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec6303b5a162926b2c3b86bcf9016839 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220304101018 LGD_PCANCELSTR = 0 LGD_BUYER = 박기덕 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304101018u3JF3 LGD_BUYERID = LGD_OID = Direct-pk7646-1646355852 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4101018up3L3 ========================2022-03-04 10:28:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1646357186 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304102626 LGD_HASHDATA = c85604e499fd195d16602ab8256be6b5 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 = 20220304103350E4FF062317724993A795BC2D02691900ZWWXNTJA Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2022-03-04 10:29:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304103351 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 393487 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538839******4647 LGD_FINANCEAUTHNUM = 57267337 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 78586a5d5d9f11b4b720de6207195aa4 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220304103351 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304103351Absm2 LGD_BUYERID = LGD_OID = Direct-woorimart-1646357186 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4103351ACZa4 ========================2022-03-04 10:29:00======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1646357186', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 538839******4647', rApprNo = 'mjsof20220304103351Absm2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 10:29:00', InvoiceNum = '결제성공:Direct-woorimart-1646357186/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 10:29:00' ========================2022-03-04 10:29:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304103351Absm2' 0 = 1 cnt = 1 ========================2022-03-04 10:29:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2022-03-04 10:29:00======================== select * from customers where id = 'woorimart' ========================2022-03-04 10:29:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2022-03-04 10:29:00','220000','220000','온라인','0') ========================2022-03-04 14:06:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1646370334 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304140534 LGD_HASHDATA = 33b827762c28c573a81e3b0fcb3adeb5 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 = 202203041411116078EC449AE748F6A473DA454B9188C2WSKJSYRS Mname = 강성기 Mcompany = (주)예당식품(지점) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yedangfood2 LGD_ESCROW_USEYN = N ========================2022-03-04 14:06:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304141111 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553146******7471 LGD_FINANCEAUTHNUM = 30985670 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a2602985f89ea27432f21a6fdade2dce LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220304141112 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304141111ul899 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1646370334 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 14:06:20======================== insert into mBoard_order set rOrdNo = 'Direct-yedangfood2-1646370334', AuthTy = 'card', memberId = 'yedangfood2', OrdNm ='강성기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)예당식품(지점)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한MASTER 553146******7471', rApprNo = 'mjsof20220304141111ul899', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 14:06:20', InvoiceNum = '결제성공:Direct-yedangfood2-1646370334/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 14:06:20' ========================2022-03-04 14:06:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304141111ul899' 0 = 1 cnt = 1 ========================2022-03-04 14:06:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yedangfood2' 0 = yedangfood2 Mid = yedangfood2 1 = (주)예당식품(지점) Mcompany = (주)예당식품(지점) 2 = 1318555107 companyNum = 1318555107 3 = 032-465-2174 Mtel1 = 032-465-2174 4 = 010-4806-0245 Mhp = 010-4806-0245 ========================2022-03-04 14:06:20======================== select * from customers where id = 'yedangfood2' ========================2022-03-04 14:06:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yedangfood2','2022-03-04 14:06:20','52500','55000','온라인','0') ========================2022-03-04 16:29:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-supper2000-1646378801 LGD_BUYER = 김겸 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220304162642 LGD_HASHDATA = c283f5da37d65bee4c4a98d0b56d3ef0 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 = 202203041634426C73468D75B34D62A8ADD8CA471FFCC3DIE4EIWL Mname = 김겸 Mcompany = 동부보육사/동부소독 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = supper2000 LGD_ESCROW_USEYN = N ========================2022-03-04 16:29:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220304163443 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943117******2582 LGD_FINANCEAUTHNUM = 70506083 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = befc895ae17c154011980bc675c14681 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220304163443 LGD_PCANCELSTR = 0 LGD_BUYER = 김겸 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220304163443tCmo0 LGD_BUYERID = LGD_OID = Direct-supper2000-1646378801 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-03-04 16:29:51======================== insert into mBoard_order set rOrdNo = 'Direct-supper2000-1646378801', AuthTy = 'card', memberId = 'supper2000', OrdNm ='김겸', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동부보육사/동부소독', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH 943117******2582', rApprNo = 'mjsof20220304163443tCmo0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-03-04 16:29:51', InvoiceNum = '결제성공:Direct-supper2000-1646378801/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-03-04 16:29:51' ========================2022-03-04 16:29:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220304163443tCmo0' 0 = 1 cnt = 1 ========================2022-03-04 16:29:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'supper2000' 0 = supper2000 Mid = supper2000 1 = 동부보육사/동부소독 Mcompany = 동부보육사/동부소독 2 = 8422300475 companyNum = 8422300475 3 = 010-6340-9953 Mtel1 = 010-6340-9953 4 = 010-6340-9953 Mhp = 010-6340-9953 ========================2022-03-04 16:29:51======================== select * from customers where id = 'supper2000' ========================2022-03-04 16:29:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('supper2000','2022-03-04 16:29:51','30900','33000','온라인','0')