========================2021-09-02 07:43:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1630536107 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902074147 LGD_HASHDATA = 4024ec2ef5bbe23efaeba3efb49a4a95 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 = 20210902074452D1D3960B883D49AEB0B2B5FF221D0D0BQCO9AXT1 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 ========================2021-09-02 07:43:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902074453 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******3983 LGD_FINANCEAUTHNUM = 32151614 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 38b66cb2395a470d9a25148e47fd3319 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902074453 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090207445260042 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1630536107 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 207445260058 ========================2021-09-02 07:43:22======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1630536107', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******3983', rApprNo = 'mjsof2021090207445260042', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 07:43:22', InvoiceNum = '결제성공:Direct-goodssal5707-1630536107/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 07:43:22' ========================2021-09-02 07:43:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090207445260042' 0 = 1 cnt = 1 ========================2021-09-02 07:43:22======================== 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 ========================2021-09-02 07:43:22======================== select * from customers where id = 'goodssal5707' ========================2021-09-02 07:43:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-09-02 07:43:22','220000','220000','온라인','0') ========================2021-09-02 07:44:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1630536256 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902074416 LGD_HASHDATA = ece3e645b373abed9cb920bfb33bef67 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 = 20210902074627C1F45B63121D4EE4A993664E88367E19VARKZRKC Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-09-02 07:44:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902074627 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******3983 LGD_FINANCEAUTHNUM = 32154468 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8897d919f75a0ad8a54e73df3e6acb22 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902074628 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090207462761263 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1630536256 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 207462761276 ========================2021-09-02 07:44:57======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1630536256', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******3983', rApprNo = 'mjsof2021090207462761263', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 07:44:57', InvoiceNum = '결제성공:Direct-goodssal5707-1630536256/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 07:44:57' ========================2021-09-02 07:44:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090207462761263' 0 = 1 cnt = 1 ========================2021-09-02 07:44:57======================== 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 ========================2021-09-02 07:44:57======================== select * from customers where id = 'goodssal5707' ========================2021-09-02 07:44:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-09-02 07:44:57','108000','110000','온라인','0') ========================2021-09-02 09:24:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1630542237 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902092357 LGD_HASHDATA = eb8562c27de66d407fcd03a1d33af3ed 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 = 20210902092617EA206AEDA8FE4F9E8802DD5454485A0FIU3T6HBX Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2021-09-02 09:24:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902092617 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 = 32643113 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fdbafa3487e725911640e570653929d1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902092618 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090209261760108 LGD_BUYERID = LGD_OID = Direct-neotool-1630542237 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 209261760199 ========================2021-09-02 09:24:47======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1630542237', 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 = 'mjsof2021090209261760108', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 09:24:47', InvoiceNum = '결제성공:Direct-neotool-1630542237/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 09:24:47' ========================2021-09-02 09:24:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090209261760108' 0 = 1 cnt = 1 ========================2021-09-02 09:24:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2021-09-02 09:24:47======================== select * from customers where id = 'neotool' ========================2021-09-02 09:24:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-09-02 09:24:47','108000','110000','온라인','0') ========================2021-09-02 11:17:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjss5009-1630548938 LGD_BUYER = 한명화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902111538 LGD_HASHDATA = 1a4b5720f67831996919c27b6b097de0 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 = 2021090211184553D765237B1C4CB7B430CE8EA1DED3D2CLFCQNZ5 Mname = 한명화 Mcompany = 주식회사제이앤에스팩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jjss5009 LGD_ESCROW_USEYN = N ========================2021-09-02 11:17:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902111846 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 = 553142******7202 LGD_FINANCEAUTHNUM = 00647318 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fe00ed371e7f47296d4af43d971415cc LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210902111846 LGD_PCANCELSTR = 0 LGD_BUYER = 한명화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090211184660093 LGD_BUYERID = LGD_OID = Direct-jjss5009-1630548938 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-09-02 11:17:15======================== insert into mBoard_order set rOrdNo = 'Direct-jjss5009-1630548938', AuthTy = 'card', memberId = 'jjss5009', OrdNm ='한명화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사제이앤에스팩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대MASTER 553142******7202', rApprNo = 'mjsof2021090211184660093', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 11:17:15', InvoiceNum = '결제성공:Direct-jjss5009-1630548938/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 11:17:15' ========================2021-09-02 11:17:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090211184660093' 0 = 1 cnt = 1 ========================2021-09-02 11:17:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjss5009' 0 = jjss5009 Mid = jjss5009 1 = 주식회사제이앤에스팩 Mcompany = 주식회사제이앤에스팩 2 = 5718701889 companyNum = 5718701889 3 = 043-224-7982 Mtel1 = 043-224-7982 4 = 010-4243-6887 Mhp = 010-4243-6887 ========================2021-09-02 11:17:15======================== select * from customers where id = 'jjss5009' ========================2021-09-02 11:17:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjss5009','2021-09-02 11:17:15','52500','55000','온라인','0') ========================2021-09-02 14:35:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-petzone-1630560762 LGD_BUYER = 부산지사 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902143242 LGD_HASHDATA = 573d97ebc169c1cb85f9dbf20ed08c70 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 = 2021090214365415AC19A359474275AC8832C0543229A4RDGEQPJD Mname = 부산지사 Mcompany = (주)제이앤씨컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = petzone LGD_ESCROW_USEYN = N ========================2021-09-02 14:35:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902143655 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******4942 LGD_FINANCEAUTHNUM = 35254649 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 66e485b02d9e86ad2873fb0ea0ea972e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902143655 LGD_PCANCELSTR = 0 LGD_BUYER = 부산지사 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090214365560205 LGD_BUYERID = LGD_OID = Direct-petzone-1630560762 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 214365560246 ========================2021-09-02 14:46:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-petzone-1630561526 LGD_BUYER = 부산지사 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902144526 LGD_HASHDATA = 1ea9ab381bdc2e1e8fc90fc4ebfa33f5 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 = 202109021447527B7002775B114A1FA7D1D4F2541159FEENOORSIX Mname = 부산지사 Mcompany = (주)제이앤씨컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = petzone LGD_ESCROW_USEYN = N ========================2021-09-02 14:46:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902144753 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 654132******4942 LGD_FINANCEAUTHNUM = 35318805 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 83c3181574f7f4407fa094ebee0306f8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902144753 LGD_PCANCELSTR = 0 LGD_BUYER = 부산지사 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090214475261139 LGD_BUYERID = LGD_OID = Direct-petzone-1630561526 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 214475261109 ========================2021-09-02 14:46:22======================== insert into mBoard_order set rOrdNo = 'Direct-petzone-1630561526', AuthTy = 'card', memberId = 'petzone', OrdNm ='부산지사', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)제이앤씨컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨 654132******4942', rApprNo = 'mjsof2021090214475261139', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 14:46:22', InvoiceNum = '결제성공:Direct-petzone-1630561526/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 14:46:22' ========================2021-09-02 14:46:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090214475261139' 0 = 1 cnt = 1 ========================2021-09-02 14:46:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'petzone' 0 = petzone Mid = petzone 1 = (주)제이앤씨컴퍼니 Mcompany = (주)제이앤씨컴퍼니 2 = 6758600899 companyNum = 6758600899 3 = 010-7140-1700 Mtel1 = 010-7140-1700 4 = 010-7140-1700 Mhp = 010-7140-1700 ========================2021-09-02 14:46:22======================== select * from customers where id = 'petzone' ========================2021-09-02 14:46:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('petzone','2021-09-02 14:46:22','30900','33000','온라인','0') ========================2021-09-02 15:04:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-blueseafood2-1630562301 LGD_BUYER = 곽동원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902145821 LGD_HASHDATA = bceaa4cdb85198cced7f9423f112e146 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 = 202109021506029B3C4C4676304EC281313D8F99443635AVQVDPHM Mname = 곽동원 Mcompany = (주)블루씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = blueseafood2 LGD_ESCROW_USEYN = N ========================2021-09-02 15:04:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902150603 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943032******7916 LGD_FINANCEAUTHNUM = 35429483 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ffe3770d1e368c1585ab70ecae0fc8e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902150603 LGD_PCANCELSTR = 0 LGD_BUYER = 곽동원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090215060361036 LGD_BUYERID = LGD_OID = Direct-blueseafood2-1630562301 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 215060361009 ========================2021-09-02 15:04:32======================== insert into mBoard_order set rOrdNo = 'Direct-blueseafood2-1630562301', AuthTy = 'card', memberId = 'blueseafood2', OrdNm ='곽동원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루씨푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943032******7916', rApprNo = 'mjsof2021090215060361036', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 15:04:32', InvoiceNum = '결제성공:Direct-blueseafood2-1630562301/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 15:04:32' ========================2021-09-02 15:04:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090215060361036' 0 = 1 cnt = 1 ========================2021-09-02 15:04:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'blueseafood2' 0 = blueseafood2 Mid = blueseafood2 1 = (주)블루씨푸드 Mcompany = (주)블루씨푸드 2 = 5478700548 companyNum = 5478700548 3 = 051-256-7005 Mtel1 = 051-256-7005 4 = 010-0000-0000 Mhp = 010-0000-0000 ========================2021-09-02 15:04:33======================== select * from customers where id = 'blueseafood2' ========================2021-09-02 15:04:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('blueseafood2','2021-09-02 15:04:32','220000','220000','온라인','0') ========================2021-09-02 17:00:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tjswn0807-1630569564 LGD_BUYER = 이승헌 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902165924 LGD_HASHDATA = 7be2ba3304d202221a8c95ecc4b56a86 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 = 20210902170156866EE616F6794D02A01A418906ED95BC2GUAGOCZ Mname = 이승헌 Mcompany = 팩하우스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = tjswn0807 LGD_ESCROW_USEYN = N ========================2021-09-02 17:00:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902170156 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ALMA1U LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 445090******3130 LGD_FINANCEAUTHNUM = 37878376 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0e48734a0717f5527fc02570839accfc LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210902170156 LGD_PCANCELSTR = 0 LGD_BUYER = 이승헌 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090217015661228 LGD_BUYERID = LGD_OID = Direct-tjswn0807-1630569564 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-09-02 17:00:25======================== insert into mBoard_order set rOrdNo = 'Direct-tjswn0807-1630569564', AuthTy = 'card', memberId = 'tjswn0807', OrdNm ='이승헌', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '팩하우스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 445090******3130', rApprNo = 'mjsof2021090217015661228', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 17:00:25', InvoiceNum = '결제성공:Direct-tjswn0807-1630569564/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 17:00:25' ========================2021-09-02 17:00:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090217015661228' 0 = 1 cnt = 1 ========================2021-09-02 17:00:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tjswn0807' 0 = tjswn0807 Mid = tjswn0807 1 = 팩하우스 Mcompany = 팩하우스 2 = 127-43-13471 companyNum = 127-43-13471 3 = 031-827-5107 Mtel1 = 031-827-5107 4 = 010-5493-5107 Mhp = 010-5493-5107 ========================2021-09-02 17:00:25======================== select * from customers where id = 'tjswn0807' ========================2021-09-02 17:00:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tjswn0807','2021-09-02 17:00:25','52500','55000','온라인','0') ========================2021-09-02 22:07:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gf3832-1630587903 LGD_BUYER = 황재준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210902220503 LGD_HASHDATA = 11c9f5b041ef1cd71cf8a99faefb5e78 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 = 202109022209097B5F2AFFB8144B3493B58C19B4C4DD8EPPGLQCAO Mname = 황재준 Mcompany = (주)골프링크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = gf3832 LGD_ESCROW_USEYN = N ========================2021-09-02 22:07:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210902220910 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 944023******4979 LGD_FINANCEAUTHNUM = 38412075 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 5a72320d6767f03b8fc9745a95af679e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210902220910 LGD_PCANCELSTR = 0 LGD_BUYER = 황재준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021090222091061039 LGD_BUYERID = LGD_OID = Direct-gf3832-1630587903 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 222091061088 ========================2021-09-02 22:07:39======================== insert into mBoard_order set rOrdNo = 'Direct-gf3832-1630587903', AuthTy = 'card', memberId = 'gf3832', OrdNm ='황재준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)골프링크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨 944023******4979', rApprNo = 'mjsof2021090222091061039', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-09-02 22:07:39', InvoiceNum = '결제성공:Direct-gf3832-1630587903/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-09-02 22:07:39' ========================2021-09-02 22:07:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021090222091061039' 0 = 1 cnt = 1 ========================2021-09-02 22:07:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gf3832' 0 = gf3832 Mid = gf3832 1 = (주)골프링크 Mcompany = (주)골프링크 2 = 215-86-70887 companyNum = 215-86-70887 3 = 02-3401-3831 Mtel1 = 02-3401-3831 4 = 010-7475-2331 Mhp = 010-7475-2331 ========================2021-09-02 22:07:39======================== select * from customers where id = 'gf3832' ========================2021-09-02 22:07:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gf3832','2021-09-02 22:07:39','30900','33000','온라인','0')