========================2021-06-30 10:02:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimfanju-1625014855 LGD_BUYER = 이은희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630100055 LGD_HASHDATA = 179ea30e15602c1dd29a01f24de01971 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 = 20210630100225047049E0994540258D980A94493F6052F58YGGSS Mname = 이은희 Mcompany = 바로푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kimfanju LGD_ESCROW_USEYN = N ========================2021-06-30 10:02:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630100226 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 242868 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490220******2522 LGD_FINANCEAUTHNUM = 63086600 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 12e01c724237dba29ab7dca24e24052e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630100226 LGD_PCANCELSTR = 0 LGD_BUYER = 이은희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063010022560277 LGD_BUYERID = LGD_OID = Direct-kimfanju-1625014855 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 010022560283 ========================2021-06-30 10:02:06======================== insert into mBoard_order set rOrdNo = 'Direct-kimfanju-1625014855', AuthTy = 'card', memberId = 'kimfanju', OrdNm ='이은희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바로푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리VISA 490220******2522', rApprNo = 'mjsof2021063010022560277', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 10:02:06', InvoiceNum = '결제성공:Direct-kimfanju-1625014855/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 10:02:06' ========================2021-06-30 10:02:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063010022560277' 0 = 1 cnt = 1 ========================2021-06-30 10:02:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimfanju' 0 = kimfanju Mid = kimfanju 1 = 바로푸드 Mcompany = 바로푸드 2 = 8805100280 companyNum = 8805100280 3 = 051-752-0017 Mtel1 = 051-752-0017 4 = 010-2980-0017 Mhp = 010-2980-0017 ========================2021-06-30 10:02:06======================== select * from customers where id = 'kimfanju' ========================2021-06-30 10:02:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimfanju','2021-06-30 10:02:06','10000','11000','온라인','0') ========================2021-06-30 10:37:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-puduly-1625016916 LGD_BUYER = 곽윤희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630103516 LGD_HASHDATA = 13281f93ef8eec1206483fb8ad7cdd9b 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 = 20210630103743EA24F5A9093A4B378A075AAD6F0801BA0YUQJU8R Mname = 곽윤희 Mcompany = (주)원앤원사무용가구 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = puduly LGD_ESCROW_USEYN = N ========================2021-06-30 10:37:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630103744 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 001620 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 433290******7083 LGD_FINANCEAUTHNUM = 30056058 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e2f2af9700700da7a38d81476cab18e4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630103744 LGD_PCANCELSTR = 0 LGD_BUYER = 곽윤희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063010374460296 LGD_BUYERID = LGD_OID = Direct-puduly-1625016916 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 010374460295 ========================2021-06-30 10:37:24======================== insert into mBoard_order set rOrdNo = 'Direct-puduly-1625016916', AuthTy = 'card', memberId = 'puduly', OrdNm ='곽윤희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원앤원사무용가구', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 433290******7083', rApprNo = 'mjsof2021063010374460296', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 10:37:24', InvoiceNum = '결제성공:Direct-puduly-1625016916/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 10:37:24' ========================2021-06-30 10:37:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063010374460296' 0 = 1 cnt = 1 ========================2021-06-30 10:37:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'puduly' 0 = puduly Mid = puduly 1 = (주)원앤원사무용가구 Mcompany = (주)원앤원사무용가구 2 = 6628800242 companyNum = 6628800242 3 = 010-3333-8091 Mtel1 = 010-3333-8091 4 = 010-3333-8091 Mhp = 010-3333-8091 ========================2021-06-30 10:37:24======================== select * from customers where id = 'puduly' ========================2021-06-30 10:37:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('puduly','2021-06-30 10:37:24','52500','55000','온라인','0') ========================2021-06-30 11:28:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-west-1625020020 LGD_BUYER = 최재영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630112700 LGD_HASHDATA = a3dd4db542a888c54f73d9d165221921 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 = 20210630112844679F3E8A982C475FA941796F5A7F63BDX4JP0MP5 Mname = 최재영 Mcompany = 삼성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = west LGD_ESCROW_USEYN = N ========================2021-06-30 11:28:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630112844 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 004409 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 557042******6009 LGD_FINANCEAUTHNUM = 30147677 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea280cf0c508d8e85e1abe9e94f7bba8 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630112845 LGD_PCANCELSTR = 0 LGD_BUYER = 최재영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063011284461103 LGD_BUYERID = LGD_OID = Direct-west-1625020020 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-06-30 11:28:24======================== insert into mBoard_order set rOrdNo = 'Direct-west-1625020020', AuthTy = 'card', memberId = 'west', OrdNm ='최재영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 557042******6009', rApprNo = 'mjsof2021063011284461103', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 11:28:24', InvoiceNum = '결제성공:Direct-west-1625020020/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 11:28:24' ========================2021-06-30 11:28:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063011284461103' 0 = 1 cnt = 1 ========================2021-06-30 11:28:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'west' 0 = west Mid = west 1 = 삼성유통 Mcompany = 삼성유통 2 = 1192129214 companyNum = 1192129214 3 = 02-856-2358 Mtel1 = 02-856-2358 4 = 010-9991-4577 Mhp = 010-9991-4577 ========================2021-06-30 11:28:24======================== select * from customers where id = 'west' ========================2021-06-30 11:28:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('west','2021-06-30 11:28:24','52500','55000','온라인','0') ========================2021-06-30 13:28:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tlsehvmfkwk-1625026981 LGD_BUYER = 정성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630132302 LGD_HASHDATA = 32b53f43a2f9f114bce60350b5abfd7c 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 = 2021063013291626527B5D4A1B40DFA34862A45F923F2B8KZEMPOZ Mname = 정성희 Mcompany = 신도oa프라자 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = tlsehvmfkwk LGD_ESCROW_USEYN = N ========================2021-06-30 13:28:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630132917 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 038836 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******2397 LGD_FINANCEAUTHNUM = 64455050 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c4d47d3c1013297b928f7a5e6c73dccc LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630132918 LGD_PCANCELSTR = 0 LGD_BUYER = 정성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063013291661076 LGD_BUYERID = LGD_OID = Direct-tlsehvmfkwk-1625026981 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 013291661098 ========================2021-06-30 13:28:57======================== insert into mBoard_order set rOrdNo = 'Direct-tlsehvmfkwk-1625026981', AuthTy = 'card', memberId = 'tlsehvmfkwk', OrdNm ='정성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신도oa프라자', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 910003******2397', rApprNo = 'mjsof2021063013291661076', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 13:28:57', InvoiceNum = '결제성공:Direct-tlsehvmfkwk-1625026981/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 13:28:57' ========================2021-06-30 13:28:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063013291661076' 0 = 1 cnt = 1 ========================2021-06-30 13:28:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tlsehvmfkwk' 0 = tlsehvmfkwk Mid = tlsehvmfkwk 1 = 신도oa프라자 Mcompany = 신도oa프라자 2 = 608-03-23846 companyNum = 608-03-23846 3 = 055-222-8572 Mtel1 = 055-222-8572 4 = 010-8776-0850 Mhp = 010-8776-0850 ========================2021-06-30 13:28:57======================== select * from customers where id = 'tlsehvmfkwk' ========================2021-06-30 13:28:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tlsehvmfkwk','2021-06-30 13:28:57','108000','110000','온라인','0') ========================2021-06-30 13:53:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1625028663 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630135103 LGD_HASHDATA = 4802ff4997fb36dc4e3bb631397ebf36 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 = 2021063013535826B1F569DEF146A5BD8839E2904AE6020S4PZWWM 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-06-30 13:53:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630135359 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 625003******2941 LGD_FINANCEAUTHNUM = 64794417 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6bddf6f0c90cd0c9ec569ae5d8bfd566 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630135359 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063013535960076 LGD_BUYERID = LGD_OID = Direct-neotool-1625028663 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 013535960056 ========================2021-06-30 13:54:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1625028663 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630135103 LGD_HASHDATA = 4802ff4997fb36dc4e3bb631397ebf36 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 = 2021063013535826B1F569DEF146A5BD8839E2904AE6020S4PZWWM 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-06-30 13:54:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630135439 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-neotool-1625028663]는 2021/06/30 13:53:59 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 64794417 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = ee27785c3bbbbf0bab7c3195b2b866bb LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20210630135439 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof2021063013535960076 LGD_BUYERID = LGD_OID = Direct-neotool-1625028663 LGD_RESPCODE = S007 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-06-30 13:54:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1625028663 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630135103 LGD_HASHDATA = 4802ff4997fb36dc4e3bb631397ebf36 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 = 2021063013535826B1F569DEF146A5BD8839E2904AE6020S4PZWWM 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-06-30 13:54:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630135443 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-neotool-1625028663]는 2021/06/30 13:53:59 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 64794417 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = b631200b7d3e24270f5d7981830007c1 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20210630135443 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof2021063013535960076 LGD_BUYERID = LGD_OID = Direct-neotool-1625028663 LGD_RESPCODE = S007 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-06-30 13:55:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1625028920 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630135520 LGD_HASHDATA = a3b615d38727a6f0737b8b2e207f8e56 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 = 20210630135614ECF92A10D275425AAEA7CB88B2C166F0ZJA9EEOH 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-06-30 13:55:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630135614 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 = 64871812 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9a2cae9f2b4724e7c5a448d7f3b96f82 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630135615 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063013561461266 LGD_BUYERID = LGD_OID = Direct-neotool-1625028920 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 013561461227 ========================2021-06-30 13:55:54======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1625028920', 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 = 'mjsof2021063013561461266', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 13:55:54', InvoiceNum = '결제성공:Direct-neotool-1625028920/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 13:55:54' ========================2021-06-30 13:55:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063013561461266' 0 = 1 cnt = 1 ========================2021-06-30 13:55:54======================== 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-06-30 13:55:54======================== select * from customers where id = 'neotool' ========================2021-06-30 13:55:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-06-30 13:55:54','108000','110000','온라인','0') ========================2021-06-30 13:58:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wnsgh7521-1625028993 LGD_BUYER = 황준호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630135633 LGD_HASHDATA = 0ff16629ac1614e30f33f5bcd47fa6bc 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 = 20210630135836A567942A624E4990AE441A940C23126E5K8EXTC4 Mname = 황준호 Mcompany = 주식회사 동신이앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = wnsgh7521 LGD_ESCROW_USEYN = N ========================2021-06-30 13:58:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630135837 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 625003******6906 LGD_FINANCEAUTHNUM = 64879468 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d81c789e93da96f1f75d3c63ca81e8f0 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630135837 LGD_PCANCELSTR = 0 LGD_BUYER = 황준호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063013583660088 LGD_BUYERID = LGD_OID = Direct-wnsgh7521-1625028993 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 013583660065 ========================2021-06-30 14:01:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wnsgh7521-1625029211 LGD_BUYER = 황준호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630140011 LGD_HASHDATA = 222e41bc71b39b663cade59d091a2b31 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 = 20210630140121F790F126AC0D4ED1830BA6685EC33779E4N8MMS0 Mname = 황준호 Mcompany = 주식회사 동신이앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = wnsgh7521 LGD_ESCROW_USEYN = N ========================2021-06-30 14:01:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630140122 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 625003******6906 LGD_FINANCEAUTHNUM = 64968621 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 688b74ea7677f83486c395ff900bbf63 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630140122 LGD_PCANCELSTR = 0 LGD_BUYER = 황준호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063014012160065 LGD_BUYERID = LGD_OID = Direct-wnsgh7521-1625029211 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 014012160040 ========================2021-06-30 14:04:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wnsgh7521-1625029409 LGD_BUYER = 황준호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630140329 LGD_HASHDATA = 41015c7e041cc9162ff9ab6720e44138 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 = 20210630140502C29FB1569ADC4A2C99C6166512D2B436VDUWI0KS Mname = 황준호 Mcompany = 주식회사 동신이앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = wnsgh7521 LGD_ESCROW_USEYN = N ========================2021-06-30 14:04:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630140503 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AXFBZE LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 451842******7181 LGD_FINANCEAUTHNUM = 17420800 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e5974d33d035919c2da2782b1d495624 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210630140503 LGD_PCANCELSTR = 0 LGD_BUYER = 황준호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063014050361135 LGD_BUYERID = LGD_OID = Direct-wnsgh7521-1625029409 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-06-30 14:08:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1625029695 LGD_BUYER = 강찬수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630140815 LGD_HASHDATA = c1f7ac51091d5e8dca55f310ced0707e 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 = 202106301409178651FA38E8E14E62AA2AF0844250A1F4CZRRFA0E Mname = 강찬수 Mcompany = (주)태양엠알오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sunmro LGD_ESCROW_USEYN = N ========================2021-06-30 14:08:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630140917 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558920******2440 LGD_FINANCEAUTHNUM = 65226920 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 677aa28258d6a2e0f202e679aced604a LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630140917 LGD_PCANCELSTR = 0 LGD_BUYER = 강찬수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063014091760081 LGD_BUYERID = LGD_OID = Direct-sunmro-1625029695 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 014091760050 ========================2021-06-30 14:08:57======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1625029695', AuthTy = 'card', memberId = 'sunmro', OrdNm ='강찬수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태양엠알오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 558920******2440', rApprNo = 'mjsof2021063014091760081', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 14:08:57', InvoiceNum = '결제성공:Direct-sunmro-1625029695/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 14:08:57' ========================2021-06-30 14:08:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063014091760081' 0 = 1 cnt = 1 ========================2021-06-30 14:08:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sunmro' 0 = sunmro Mid = sunmro 1 = (주)태양엠알오 Mcompany = (주)태양엠알오 2 = 262-81-00306 companyNum = 262-81-00306 3 = 02-1899-0942 Mtel1 = 02-1899-0942 4 = 010-5482-0951 Mhp = 010-5482-0951 ========================2021-06-30 14:08:57======================== select * from customers where id = 'sunmro' ========================2021-06-30 14:08:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2021-06-30 14:08:57','220000','220000','온라인','0') ========================2021-06-30 14:08:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wnsgh7521-1625029682 LGD_BUYER = 황준호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630140802 LGD_HASHDATA = 7076df60767a2f4bcefe5374046ff7f9 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 = 202106301409205A280E78E09A45F4BE749B2BD2C700397DLQ4WOV Mname = 황준호 Mcompany = 주식회사 동신이앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = wnsgh7521 LGD_ESCROW_USEYN = N ========================2021-06-30 14:09:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630140921 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******6906 LGD_FINANCEAUTHNUM = 65227110 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a22d406ae329d5a08cc703aa7b1d6ec1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210630140921 LGD_PCANCELSTR = 0 LGD_BUYER = 황준호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063014092060084 LGD_BUYERID = LGD_OID = Direct-wnsgh7521-1625029682 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 014092060053 ========================2021-06-30 14:09:00======================== insert into mBoard_order set rOrdNo = 'Direct-wnsgh7521-1625029682', AuthTy = 'card', memberId = 'wnsgh7521', OrdNm ='황준호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 동신이앤티', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 625003******6906', rApprNo = 'mjsof2021063014092060084', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 14:09:00', InvoiceNum = '결제성공:Direct-wnsgh7521-1625029682/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 14:09:00' ========================2021-06-30 14:09:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063014092060084' 0 = 1 cnt = 1 ========================2021-06-30 14:09:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wnsgh7521' 0 = wnsgh7521 Mid = wnsgh7521 1 = 주식회사 동신이앤티 Mcompany = 주식회사 동신이앤티 2 = 1408105980 companyNum = 1408105980 3 = 041-546-3931 Mtel1 = 041-546-3931 4 = 010-8935-4514 Mhp = 010-8935-4514 ========================2021-06-30 14:09:00======================== select * from customers where id = 'wnsgh7521' ========================2021-06-30 14:09:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wnsgh7521','2021-06-30 14:09:00','52500','55000','온라인','0') ========================2021-06-30 16:40:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape-1625038752 LGD_BUYER = (주)유니콤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630163912 LGD_HASHDATA = ad99323217cc21fa77b6b4785f80ddb1 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 = 202106301640415162767F8E254302A686293B4A5DF88D1ORQBN5H Mname = (주)유니콤 Mcompany = (주)유니콤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape LGD_ESCROW_USEYN = N ========================2021-06-30 16:40:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630164041 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******4805 LGD_FINANCEAUTHNUM = 30001787 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6baa1b4e84a4e2f40b0813b65de4dc34 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630164041 LGD_PCANCELSTR = 0 LGD_BUYER = (주)유니콤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063016404160046 LGD_BUYERID = LGD_OID = Direct-unicomtape-1625038752 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 016404160028 ========================2021-06-30 16:40:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape-1625038752 LGD_BUYER = (주)유니콤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630163912 LGD_HASHDATA = ad99323217cc21fa77b6b4785f80ddb1 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 = 202106301640415162767F8E254302A686293B4A5DF88D1ORQBN5H Mname = (주)유니콤 Mcompany = (주)유니콤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape LGD_ESCROW_USEYN = N ========================2021-06-30 16:40:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630164049 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-unicomtape-1625038752]는 2021/06/30 16:40:41 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 30001787 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 78b5c7bd936e89c478cf33ab0807d96c LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20210630164049 LGD_PCANCELSTR = 0 LGD_BUYER = (주)유니콤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof2021063016404160046 LGD_BUYERID = LGD_OID = Direct-unicomtape-1625038752 LGD_RESPCODE = S007 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-06-30 16:41:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape-1625038840 LGD_BUYER = (주)유니콤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630164040 LGD_HASHDATA = 9c28e36d6edfaac6446a7e630c57543f 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 = 2021063016412980BE840E19574467A5AE507F46E3CB82IDMLEP7M Mname = (주)유니콤 Mcompany = (주)유니콤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape LGD_ESCROW_USEYN = N ========================2021-06-30 16:41:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630164130 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******4805 LGD_FINANCEAUTHNUM = 30001798 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = aa5feb87f10a57ee7f8ab14212ffa714 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630164130 LGD_PCANCELSTR = 0 LGD_BUYER = (주)유니콤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063016412961019 LGD_BUYERID = LGD_OID = Direct-unicomtape-1625038840 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 016412961030 ========================2021-06-30 16:42:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape-1625038934 LGD_BUYER = (주)유니콤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630164214 LGD_HASHDATA = 16a39f172975943dddfb376aaa66d695 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 = 2021063016430658B18A07BFED440987DB7E12FD3E5785NUY8PAVY Mname = (주)유니콤 Mcompany = (주)유니콤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape LGD_ESCROW_USEYN = N ========================2021-06-30 16:42:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630164306 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******4805 LGD_FINANCEAUTHNUM = 30001800 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 242de1dfc6544cb62abf655cf27e6818 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630164306 LGD_PCANCELSTR = 0 LGD_BUYER = (주)유니콤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063016430660021 LGD_BUYERID = LGD_OID = Direct-unicomtape-1625038934 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 016430660000 ========================2021-06-30 16:42:45======================== insert into mBoard_order set rOrdNo = 'Direct-unicomtape-1625038934', AuthTy = 'card', memberId = 'unicomtape', OrdNm ='(주)유니콤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)유니콤', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******4805', rApprNo = 'mjsof2021063016430660021', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 16:42:45', InvoiceNum = '결제성공:Direct-unicomtape-1625038934/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 16:42:45' ========================2021-06-30 16:42:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063016430660021' 0 = 1 cnt = 1 ========================2021-06-30 16:42:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'unicomtape' 0 = unicomtape Mid = unicomtape 1 = (주)유니콤 Mcompany = (주)유니콤 2 = 505-81-47339 companyNum = 505-81-47339 3 = 054-744-0811 Mtel1 = 054-744-0811 4 = 010-7741-3035 Mhp = 010-7741-3035 ========================2021-06-30 16:42:45======================== select * from customers where id = 'unicomtape' ========================2021-06-30 16:42:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('unicomtape','2021-06-30 16:42:45','10000','11000','온라인','0') ========================2021-06-30 17:15:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-naeson9-1625040823 LGD_BUYER = 김정희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630171343 LGD_HASHDATA = 64bf825d327e180da8c3f742c370af6b 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 = 20210630171521C0A3B2C58DE84573A51B006D92DD37EA0IPJMQQ3 Mname = 김정희 Mcompany = 주식회사 내손 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = naeson9 LGD_ESCROW_USEYN = N ========================2021-06-30 17:15:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630171522 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003321 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******2856 LGD_FINANCEAUTHNUM = 30036914 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 138889132baee5fb2df9a3a3f3fe7007 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210630171522 LGD_PCANCELSTR = 0 LGD_BUYER = 김정희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063017152160298 LGD_BUYERID = LGD_OID = Direct-naeson9-1625040823 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 017152160251 ========================2021-06-30 17:15:01======================== insert into mBoard_order set rOrdNo = 'Direct-naeson9-1625040823', AuthTy = 'card', memberId = 'naeson9', OrdNm ='김정희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 내손', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2856', rApprNo = 'mjsof2021063017152160298', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 17:15:01', InvoiceNum = '결제성공:Direct-naeson9-1625040823/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 17:15:01' ========================2021-06-30 17:15:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063017152160298' 0 = 1 cnt = 1 ========================2021-06-30 17:15:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'naeson9' 0 = naeson9 Mid = naeson9 1 = 주식회사 내손 Mcompany = 주식회사 내손 2 = companyNum = 3 = 031-462-0944 Mtel1 = 031-462-0944 4 = 010-2229-0959 Mhp = 010-2229-0959 ========================2021-06-30 17:15:01======================== select * from customers where id = 'naeson9' ========================2021-06-30 17:15:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('naeson9','2021-06-30 17:15:01','220000','220000','온라인','0') ========================2021-06-30 23:49:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-roastercow-1625064420 LGD_BUYER = 민경언 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210630234700 LGD_HASHDATA = 8ebe71b7900853e428ba711b4b002273 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 = 20210630234931B758F9AEB9934799BE958DEAC9F70F20ESIYOINE Mname = 민경언 Mcompany = 매일우유 이태원 대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = roastercow LGD_ESCROW_USEYN = N ========================2021-06-30 23:49:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210630234931 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 = 941034******0613 LGD_FINANCEAUTHNUM = 82321921 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8e9b06f47d867329ccc726ab2f82edc3 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210630234932 LGD_PCANCELSTR = 0 LGD_BUYER = 민경언 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021063023493161100 LGD_BUYERID = LGD_OID = Direct-roastercow-1625064420 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-06-30 23:49:10======================== insert into mBoard_order set rOrdNo = 'Direct-roastercow-1625064420', AuthTy = 'card', memberId = 'roastercow', OrdNm ='민경언', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유 이태원 대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성 941034******0613', rApprNo = 'mjsof2021063023493161100', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-06-30 23:49:10', InvoiceNum = '결제성공:Direct-roastercow-1625064420/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-06-30 23:49:10' ========================2021-06-30 23:49:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021063023493161100' 0 = 1 cnt = 1 ========================2021-06-30 23:49:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'roastercow' 0 = roastercow Mid = roastercow 1 = 매일우유 이태원 대리점 Mcompany = 매일우유 이태원 대리점 2 = 8040201730 companyNum = 8040201730 3 = 010-6234-0927 Mtel1 = 010-6234-0927 4 = 010-6234-0927 Mhp = 010-6234-0927 ========================2021-06-30 23:49:10======================== select * from customers where id = 'roastercow' ========================2021-06-30 23:49:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('roastercow','2021-06-30 23:49:10','108000','110000','온라인','0')