========================2022-01-05 07:00:27======================== res_start ========================2022-01-05 07:00:27======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2022-01-05 10:27:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-a01074518547-1641345989 LGD_BUYER = 오원석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105102629 LGD_HASHDATA = e060b73478bfdf7d8b227c8bbfbec87a 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 = 2022010510313526603E01713D4BEBA3AC1C8123F0A89AJILAUACC Mname = 오원석 Mcompany = 원사이언스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = a01074518547 LGD_ESCROW_USEYN = N ========================2022-01-05 10:27:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105103136 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 520504******7903 LGD_FINANCEAUTHNUM = 30000081 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 1c30da731eb4804862dd5facb66f09ae LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220105103136 LGD_PCANCELSTR = 0 LGD_BUYER = 오원석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220105103136TYoG0 LGD_BUYERID = LGD_OID = Direct-a01074518547-1641345989 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5103136TPDf7 ========================2022-01-05 10:29:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-a01074518547-1641346145 LGD_BUYER = 오원석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105102905 LGD_HASHDATA = b04b3c7ae2e2d10ce88c091afb1a35bc 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 = 20220105103340B035E2FF3DF64425A76E51B3D3375D08MHAWBNU7 Mname = 오원석 Mcompany = 원사이언스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = a01074518547 LGD_ESCROW_USEYN = N ========================2022-01-05 10:29:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105103341 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 520504******7903 LGD_FINANCEAUTHNUM = 30000092 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 038514f0738593a12beb8af7e05c706a LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220105103341 LGD_PCANCELSTR = 0 LGD_BUYER = 오원석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220105103341VXqu8 LGD_BUYERID = LGD_OID = Direct-a01074518547-1641346145 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5103341VZu04 ========================2022-01-05 11:22:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1641349297 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105112137 LGD_HASHDATA = 837ec17ea311b3d8b7c3cc71989ac3f7 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 = 202201051126230ED7225F49E64D3E90B8B693F7E651569VCHCKEJ 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-01-05 11:22:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105112623 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 = 58802647 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6a3aa063ba2a862ecb5ea345facd040b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220105112624 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010511262360001 LGD_BUYERID = LGD_OID = Direct-woorimart-1641349297 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 511262360056 ========================2022-01-05 11:22:35======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1641349297', 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 = 'mjsof2022010511262360001', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 11:22:35', InvoiceNum = '결제성공:Direct-woorimart-1641349297/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 11:22:35' ========================2022-01-05 11:22:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010511262360001' 0 = 1 cnt = 1 ========================2022-01-05 11:22:35======================== 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-01-05 11:22:35======================== select * from customers where id = 'woorimart' ========================2022-01-05 11:22:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2022-01-05 11:22:35','220000','220000','온라인','0') ========================2022-01-05 11:40:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1641349877 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105113117 LGD_HASHDATA = 3083e68a1115a0d3ff545aa6d55ce09c 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 = 20220105114438F2BD5BAAA75D4540BF83BDF0E20A9743PDKVCLZI Mname = 김창민 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2022-01-05 11:40:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105114439 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 = 467008******6022 LGD_FINANCEAUTHNUM = 36498640 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 77d32b711bc9e042e57b332c22937468 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20220105114439 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010511443914000 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1641349877 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 11:40:50======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1641349877', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데VISA 467008******6022', rApprNo = 'mjsof2022010511443914000', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 11:40:50', InvoiceNum = '결제성공:Direct-nosqr9583-1641349877/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 11:40:50' ========================2022-01-05 11:40:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010511443914000' 0 = 1 cnt = 1 ========================2022-01-05 11:40:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 010-3199-5304 Mtel1 = 010-3199-5304 4 = 010-3199-5304 Mhp = 010-3199-5304 ========================2022-01-05 11:40:50======================== select * from customers where id = 'nosqr9583' ========================2022-01-05 11:40:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2022-01-05 11:40:50','52500','55000','온라인','0') ========================2022-01-05 13:10:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnam4051-1641355682 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105130802 LGD_HASHDATA = 2eb56caa79522ebc8aa7dc4fcdc569f4 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 = 202201051314309604198DF0BD4495AEA25291B28723BDVQWFJILN 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-01-05 13:10:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105131430 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BIABE0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 542879******2427 LGD_FINANCEAUTHNUM = 40681732 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8a522901ee9d687d6997063d10a54a03 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220105131430 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010513143061235 LGD_BUYERID = LGD_OID = Direct-dongnam4051-1641355682 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 13:10:42======================== insert into mBoard_order set rOrdNo = 'Direct-dongnam4051-1641355682', AuthTy = 'card', memberId = 'dongnam4051', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동남상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한MASTER 542879******2427', rApprNo = 'mjsof2022010513143061235', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 13:10:42', InvoiceNum = '결제성공:Direct-dongnam4051-1641355682/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 13:10:42' ========================2022-01-05 13:10:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010513143061235' 0 = 1 cnt = 1 ========================2022-01-05 13:10:42======================== 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-01-05 13:10:42======================== select * from customers where id = 'dongnam4051' ========================2022-01-05 13:10:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnam4051','2022-01-05 13:10:42','30900','33000','온라인','0') ========================2022-01-05 14:11:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ycco2513-1641358961 LGD_BUYER = 김진연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105140241 LGD_HASHDATA = 69b1eb84f5d698b0b70b5841ab08ae15 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 = 20220105141529C2B7D31F78E6400EBA1AF54F41DE0D79PJGUS4EU Mname = 김진연 Mcompany = (주)양천물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = ycco2513 LGD_ESCROW_USEYN = N ========================2022-01-05 14:11:42======================== xpay_res LGD_EASYPAY_TRANTYPE = TOSSPAY LGD_BUYERPHONE = LGD_PAYDATE = 20220105141530 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = LGD_FINANCEAUTHNUM = 05021529 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 075098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = f56b4ff7aad7b19b6a5d6bb746b41d09 LGD_BUYERADDRESS = LGD_FINANCENAME = 토스 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20220105141530 LGD_PCANCELSTR = 0 LGD_BUYER = 김진연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof2022010514142170287 LGD_BUYERID = LGD_OID = Direct-ycco2513-1641358961 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 14:11:42======================== insert into mBoard_order set rOrdNo = 'Direct-ycco2513-1641358961', AuthTy = 'card', memberId = 'ycco2513', OrdNm ='김진연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)양천물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '토스 ', rApprNo = 'mjsof2022010514142170287', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 14:11:42', InvoiceNum = '결제성공:Direct-ycco2513-1641358961/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 14:11:42' ========================2022-01-05 14:11:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010514142170287' 0 = 1 cnt = 1 ========================2022-01-05 14:11:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ycco2513' 0 = ycco2513 Mid = ycco2513 1 = (주)양천물산 Mcompany = (주)양천물산 2 = 392-86-02124 companyNum = 392-86-02124 3 = 010-5278-9418 Mtel1 = 010-5278-9418 4 = 010-5278-9418 Mhp = 010-5278-9418 ========================2022-01-05 14:11:42======================== select * from customers where id = 'ycco2513' ========================2022-01-05 14:11:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ycco2513','2022-01-05 14:11:42','10000','11000','온라인','0') ========================2022-01-05 15:03:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rich67-1641362341 LGD_BUYER = 안찬우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105145901 LGD_HASHDATA = 11538c3097ed9e22293b31bf88c80600 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 = 20220105150710E4CEDB07FA4145B39688DC1632BA31DDOBMR0GJG Mname = 안찬우 Mcompany = EDP울산야음점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = rich67 LGD_ESCROW_USEYN = N ========================2022-01-05 15:03:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105150711 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 = 949019******1926 LGD_FINANCEAUTHNUM = 00158249 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 07e8720c0fb2383c80f9ae73856100aa LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220105150711 LGD_PCANCELSTR = 0 LGD_BUYER = 안찬우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010515071014266 LGD_BUYERID = LGD_OID = Direct-rich67-1641362341 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 15:03:22======================== insert into mBoard_order set rOrdNo = 'Direct-rich67-1641362341', AuthTy = 'card', memberId = 'rich67', OrdNm ='안찬우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'EDP울산야음점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대 949019******1926', rApprNo = 'mjsof2022010515071014266', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 15:03:22', InvoiceNum = '결제성공:Direct-rich67-1641362341/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 15:03:22' ========================2022-01-05 15:03:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010515071014266' 0 = 1 cnt = 1 ========================2022-01-05 15:03:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rich67' 0 = rich67 Mid = rich67 1 = EDP울산야음점 Mcompany = EDP울산야음점 2 = 6211013131 companyNum = 6211013131 3 = 010-3887-1179 Mtel1 = 010-3887-1179 4 = 010-3887-1179 Mhp = 010-3887-1179 ========================2022-01-05 15:03:22======================== select * from customers where id = 'rich67' ========================2022-01-05 15:03:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rich67','2022-01-05 15:03:22','52500','55000','온라인','0') ========================2022-01-05 15:09:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1641362913 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105150833 LGD_HASHDATA = 783d4b452da78c51cd01bc6519659ebf 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 = 202201051513170991C651D1624C8B9BA879F0B12A0647LY1GIDYG 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-01-05 15:09:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105151318 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 = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 553146******7471 LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8734a1b7527f5db3effa8f9e3526b3ec LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220105151318 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010515131714050 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1641362913 LGD_RESPCODE = 3000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 15:10:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1641362985 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105150945 LGD_HASHDATA = 86b83cee637c74246b87008ddf9309a6 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 = 202201051514228A6C33932AA846D896A808B4E2474C145CGMOVZS 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-01-05 15:10:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105151422 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 = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 553146******7471 LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f4f6062b2f2937540c9f018986a4b776 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220105151422 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010515142261106 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1641362985 LGD_RESPCODE = 3000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 15:11:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1641363052 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105151052 LGD_HASHDATA = 32368fefdf9d2671123fee07c2541382 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 = 20220105151521F84FB9E9F04942429DEF60791D84933BHPDSS7TG Mname = 강성기 Mcompany = (주)예당식품(지점) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = yedangfood2 LGD_ESCROW_USEYN = N ========================2022-01-05 15:11:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105151521 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 = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 553146******7471 LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6539da8189486724f10a1c9fe582ad43 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220105151521 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010515152115005 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1641363052 LGD_RESPCODE = 3000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 15:16:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1641363352 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105151552 LGD_HASHDATA = 100d4c5cd2576103d8bf347c66808cc4 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 = 2022010515204245382C671CFB47AAB7FA74FAE0C49BC9AQKUGAEC Mname = 강성기 Mcompany = (주)예당식품(지점) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = yedangfood2 LGD_ESCROW_USEYN = N ========================2022-01-05 15:16:54======================== xpay_res LGD_EASYPAY_TRANTYPE = TOSSPAY LGD_BUYERPHONE = LGD_PAYDATE = 20220105152043 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 = LGD_FINANCEAUTHNUM = 05032042 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = b9f1686ed989d4119124f028445be2ba LGD_BUYERADDRESS = LGD_FINANCENAME = 토스 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20220105152043 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof2022010515201772233 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1641363352 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 15:16:54======================== insert into mBoard_order set rOrdNo = 'Direct-yedangfood2-1641363352', AuthTy = 'card', memberId = 'yedangfood2', OrdNm ='강성기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)예당식품(지점)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '토스 ', rApprNo = 'mjsof2022010515201772233', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 15:16:54', InvoiceNum = '결제성공:Direct-yedangfood2-1641363352/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 15:16:54' ========================2022-01-05 15:16:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010515201772233' 0 = 1 cnt = 1 ========================2022-01-05 15:16:54======================== 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-01-05 15:16:54======================== select * from customers where id = 'yedangfood2' ========================2022-01-05 15:16:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yedangfood2','2022-01-05 15:16:54','30900','33000','온라인','0') ========================2022-01-05 17:30:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tmtech2801-1641371265 LGD_BUYER = 김원만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220105172745 LGD_HASHDATA = 2140282f96646069f95220261fc0cbe7 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 = 2022010517344523CBA958C6A54263AA41CC16D9328015Y49UKLPL Mname = 김원만 Mcompany = 티엠텍 동부대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tmtech2801 LGD_ESCROW_USEYN = N ========================2022-01-05 17:30:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220105173445 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 543333******7907 LGD_FINANCEAUTHNUM = 00349944 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 326b616c00dad2fce1e72cd0f07f71c1 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220105173446 LGD_PCANCELSTR = 0 LGD_BUYER = 김원만 LGD_CARDINSTALLMONTH = 02 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022010517344514277 LGD_BUYERID = LGD_OID = Direct-tmtech2801-1641371265 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-01-05 17:30:57======================== insert into mBoard_order set rOrdNo = 'Direct-tmtech2801-1641371265', AuthTy = 'card', memberId = 'tmtech2801', OrdNm ='김원만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '티엠텍 동부대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대MASTER 543333******7907', rApprNo = 'mjsof2022010517344514277', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-01-05 17:30:57', InvoiceNum = '결제성공:Direct-tmtech2801-1641371265/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-01-05 17:30:57' ========================2022-01-05 17:30:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022010517344514277' 0 = 1 cnt = 1 ========================2022-01-05 17:30:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tmtech2801' 0 = tmtech2801 Mid = tmtech2801 1 = 티엠텍 동부대리점 Mcompany = 티엠텍 동부대리점 2 = 138-09-88546 companyNum = 138-09-88546 3 = 031-427-9823 Mtel1 = 031-427-9823 4 = 010-8590-2391 Mhp = 010-8590-2391 ========================2022-01-05 17:30:57======================== select * from customers where id = 'tmtech2801' ========================2022-01-05 17:30:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tmtech2801','2022-01-05 17:30:57','30900','33000','온라인','0')