========================2021-01-04 09:53:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bslube-1609721535 LGD_BUYER = 김수영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104095215 LGD_HASHDATA = 7c14efece3e1b0251ea91d10e78ada6c LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202101040953267A38086B5AA3C92B8A74C549BFA4A700D865DDAA Mname = 김수영 Mcompany = (주)비에스루브 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bslube LGD_ESCROW_USEYN = N ========================2021-01-04 09:53:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104095326 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******1115 LGD_FINANCEAUTHNUM = 00025250 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e8393d9bc91490b05850945b702af2bc LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210104095327 LGD_PCANCELSTR = 0 LGD_BUYER = 김수영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0014 LGD_TID = mjsof2021010409532661105 LGD_BUYERID = LGD_OID = Direct-bslube-1609721535 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-04 09:53:24======================== insert into mBoard_order set rOrdNo = 'Direct-bslube-1609721535', AuthTy = 'card', memberId = 'bslube', OrdNm ='김수영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스루브', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대MASTER 553142******1115', rApprNo = 'mjsof2021010409532661105', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 09:53:24', InvoiceNum = '결제성공:Direct-bslube-1609721535/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 09:53:24' ========================2021-01-04 09:53:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010409532661105' 0 = 1 cnt = 1 ========================2021-01-04 09:53:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bslube' 0 = bslube Mid = bslube 1 = (주)비에스루브 Mcompany = (주)비에스루브 2 = 6178195508 companyNum = 6178195508 3 = 051-646-4163 Mtel1 = 051-646-4163 4 = 010-8514-5189 Mhp = 010-8514-5189 ========================2021-01-04 09:53:24======================== select * from customers where id = 'bslube' ========================2021-01-04 09:53:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bslube','2021-01-04 09:53:24','220000','220000','온라인','0') ========================2021-01-04 11:55:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jwon-1609728825 LGD_BUYER = 태재원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104115345 LGD_HASHDATA = a6379ce8b7a99c2d0373f615cebc2f48 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202101041155324A71A292238C26A17C988AF583877843545C9DB8 Mname = 태재원 Mcompany = 제이원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jwon LGD_ESCROW_USEYN = N ========================2021-01-04 11:55:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104115532 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031749 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******7440 LGD_FINANCEAUTHNUM = 44212115 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 72b7c14f07dd59df6b68940cd9807100 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210104115533 LGD_PCANCELSTR = 0 LGD_BUYER = 태재원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010411553260007 LGD_BUYERID = LGD_OID = Direct-jwon-1609728825 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 411553260061 ========================2021-01-04 11:55:30======================== insert into mBoard_order set rOrdNo = 'Direct-jwon-1609728825', AuthTy = 'card', memberId = 'jwon', OrdNm ='태재원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이원', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨 910003******7440', rApprNo = 'mjsof2021010411553260007', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 11:55:30', InvoiceNum = '결제성공:Direct-jwon-1609728825/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 11:55:30' ========================2021-01-04 11:55:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010411553260007' 0 = 1 cnt = 1 ========================2021-01-04 11:55:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jwon' 0 = jwon Mid = jwon 1 = 제이원 Mcompany = 제이원 2 = 609-20-85935 companyNum = 609-20-85935 3 = 055-237-3280 Mtel1 = 055-237-3280 4 = 010-6567-3281 Mhp = 010-6567-3281 ========================2021-01-04 11:55:30======================== select * from customers where id = 'jwon' ========================2021-01-04 11:55:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jwon','2021-01-04 11:55:30','10000','11000','온라인','0') ========================2021-01-04 13:00:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rhgid2016-1609732752 LGD_BUYER = (유)고향식품 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104125912 LGD_HASHDATA = e8f2ad931953c4eb81cc9b07731ad928 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210104130016E76DD606C2A77278F7C301EFE7FAFEE27F0C1D51 Mname = (유)고향식품 Mcompany = (유)고향식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rhgid2016 LGD_ESCROW_USEYN = N ========================2021-01-04 13:00:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104130017 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 0000V0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553531******0398 LGD_FINANCEAUTHNUM = 44593510 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d52498e5bf94f7b5e302850ab1f4fd8e LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210104130017 LGD_PCANCELSTR = 0 LGD_BUYER = (유)고향식품 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021010413001615101 LGD_BUYERID = LGD_OID = Direct-rhgid2016-1609732752 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 041300664286 ========================2021-01-04 13:00:15======================== insert into mBoard_order set rOrdNo = 'Direct-rhgid2016-1609732752', AuthTy = 'card', memberId = 'rhgid2016', OrdNm ='(유)고향식품', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)고향식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '전북MASTER 553531******0398', rApprNo = 'mjsof2021010413001615101', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 13:00:15', InvoiceNum = '결제성공:Direct-rhgid2016-1609732752/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 13:00:15' ========================2021-01-04 13:00:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010413001615101' 0 = 1 cnt = 1 ========================2021-01-04 13:00:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rhgid2016' 0 = rhgid2016 Mid = rhgid2016 1 = (유)고향식품 Mcompany = (유)고향식품 2 = 4188150923 companyNum = 4188150923 3 = 010-4002-4567 Mtel1 = 010-4002-4567 4 = 010-4002-4567 Mhp = 010-4002-4567 ========================2021-01-04 13:00:15======================== select * from customers where id = 'rhgid2016' ========================2021-01-04 13:00:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rhgid2016','2021-01-04 13:00:15','220000','220000','온라인','0') ========================2021-01-04 13:28:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-meetinggod1-1609734487 LGD_BUYER = 김희승 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104132807 LGD_HASHDATA = d0dfb687ddb855768ca97d3a8609733d LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210104132859B6D725EEBA107A7D707717A16EEEA0C54BC2A8CD Mname = 김희승 Mcompany = (주)세미나인터내셔널 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = meetinggod1 LGD_ESCROW_USEYN = N ========================2021-01-04 13:28:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104132859 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******2833 LGD_FINANCEAUTHNUM = 30009515 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a4b6ae9923a42d3e3abb1dd739dfed9b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210104132859 LGD_PCANCELSTR = 0 LGD_BUYER = 김희승 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010413285961113 LGD_BUYERID = LGD_OID = Direct-meetinggod1-1609734487 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 413285961180 ========================2021-01-04 13:28:57======================== insert into mBoard_order set rOrdNo = 'Direct-meetinggod1-1609734487', AuthTy = 'card', memberId = 'meetinggod1', OrdNm ='김희승', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세미나인터내셔널', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 426586******2833', rApprNo = 'mjsof2021010413285961113', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 13:28:57', InvoiceNum = '결제성공:Direct-meetinggod1-1609734487/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 13:28:57' ========================2021-01-04 13:28:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010413285961113' 0 = 1 cnt = 1 ========================2021-01-04 13:28:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'meetinggod1' 0 = meetinggod1 Mid = meetinggod1 1 = (주)세미나인터내셔널 Mcompany = (주)세미나인터내셔널 2 = 5038700626 companyNum = 5038700626 3 = 032-674-4968 Mtel1 = 032-674-4968 4 = 010-7359-4968 Mhp = 010-7359-4968 ========================2021-01-04 13:28:57======================== select * from customers where id = 'meetinggod1' ========================2021-01-04 13:28:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('meetinggod1','2021-01-04 13:28:57','220000','220000','온라인','0') ========================2021-01-04 13:57:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harry0111-1609736177 LGD_BUYER = 최규윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104135617 LGD_HASHDATA = 9e5690ca383b5404619bc3cec75aca77 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021010413572414A6838A1AE1E77047AE50C9C2E31A66444FF843 Mname = 최규윤 Mcompany = (주)한국종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = harry0111 LGD_ESCROW_USEYN = N ========================2021-01-04 13:57:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104135725 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******8993 LGD_FINANCEAUTHNUM = 45035213 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ebfa2d58a6bdb71727f00d246dc73538 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210104135725 LGD_PCANCELSTR = 0 LGD_BUYER = 최규윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010413572561292 LGD_BUYERID = LGD_OID = Direct-harry0111-1609736177 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 413572561207 ========================2021-01-04 13:57:22======================== insert into mBoard_order set rOrdNo = 'Direct-harry0111-1609736177', AuthTy = 'card', memberId = 'harry0111', OrdNm ='최규윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한국종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 654132******8993', rApprNo = 'mjsof2021010413572561292', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 13:57:22', InvoiceNum = '결제성공:Direct-harry0111-1609736177/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 13:57:22' ========================2021-01-04 13:57:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010413572561292' 0 = 1 cnt = 1 ========================2021-01-04 13:57:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harry0111' 0 = harry0111 Mid = harry0111 1 = (주)한국종합물류 Mcompany = (주)한국종합물류 2 = 5448801472 companyNum = 5448801472 3 = 010-4331-0111 Mtel1 = 010-4331-0111 4 = 010-4331-0111 Mhp = 010-4331-0111 ========================2021-01-04 13:57:23======================== select * from customers where id = 'harry0111' ========================2021-01-04 13:57:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harry0111','2021-01-04 13:57:22','52500','55000','온라인','0') ========================2021-01-04 16:48:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bangchun-1609746469 LGD_BUYER = 이진석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104164749 LGD_HASHDATA = 24a1db3a9c6dfbe69e3b166db85c6dac LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021010416485572CFCCD74B85B5A61BB1B26F92526A58BAC884CA Mname = 이진석 Mcompany = 한반도 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bangchun LGD_ESCROW_USEYN = N ========================2021-01-04 16:48:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104164855 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = admin@hanbandosalt.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 031118 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******8951 LGD_FINANCEAUTHNUM = 46216952 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f0c531f99135fea063b5bdd356f093ee LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210104164856 LGD_PCANCELSTR = 0 LGD_BUYER = 이진석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010416485560137 LGD_BUYERID = LGD_OID = Direct-bangchun-1609746469 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 416485560127 ========================2021-01-04 16:48:53======================== insert into mBoard_order set rOrdNo = 'Direct-bangchun-1609746469', AuthTy = 'card', memberId = 'bangchun', OrdNm ='이진석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한반도', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******8951', rApprNo = 'mjsof2021010416485560137', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 16:48:53', InvoiceNum = '결제성공:Direct-bangchun-1609746469/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 16:48:53' ========================2021-01-04 16:48:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010416485560137' 0 = 1 cnt = 1 ========================2021-01-04 16:48:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bangchun' 0 = bangchun Mid = bangchun 1 = 한반도 Mcompany = 한반도 2 = 504-15-52891 companyNum = 504-15-52891 3 = 053-356-8787 Mtel1 = 053-356-8787 4 = 010-4768-8787 Mhp = 010-4768-8787 ========================2021-01-04 16:48:53======================== select * from customers where id = 'bangchun' ========================2021-01-04 16:48:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bangchun','2021-01-04 16:48:53','220000','220000','온라인','0') ========================2021-01-04 17:31:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dynasty76-1609749006 LGD_BUYER = 김송암 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104173006 LGD_HASHDATA = 683654115abaf9e41bc59656c0d0944d LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210104173103003663E1BC3F9B301AD59A1FCD1D0B8AF948AA7D Mname = 김송암 Mcompany = 태현루브리컨츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dynasty76 LGD_ESCROW_USEYN = N ========================2021-01-04 17:31:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104173103 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 111193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 552111******6742 LGD_FINANCEAUTHNUM = 46487845 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 921a5d969cb79e242197577ae36b1a05 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210104173104 LGD_PCANCELSTR = 0 LGD_BUYER = 김송암 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010417310314185 LGD_BUYERID = LGD_OID = Direct-dynasty76-1609749006 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 417310314114 ========================2021-01-04 17:31:01======================== insert into mBoard_order set rOrdNo = 'Direct-dynasty76-1609749006', AuthTy = 'card', memberId = 'dynasty76', OrdNm ='김송암', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태현루브리컨츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 552111******6742', rApprNo = 'mjsof2021010417310314185', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 17:31:01', InvoiceNum = '결제성공:Direct-dynasty76-1609749006/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 17:31:01' ========================2021-01-04 17:31:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010417310314185' 0 = 1 cnt = 1 ========================2021-01-04 17:31:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dynasty76' 0 = dynasty76 Mid = dynasty76 1 = 태현루브리컨츠 Mcompany = 태현루브리컨츠 2 = 125-24-40758 companyNum = 125-24-40758 3 = 031-682-8951 Mtel1 = 031-682-8951 4 = 010-3333-5189 Mhp = 010-3333-5189 ========================2021-01-04 17:31:01======================== select * from customers where id = 'dynasty76' ========================2021-01-04 17:31:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dynasty76','2021-01-04 17:31:01','52500','55000','온라인','0') ========================2021-01-04 20:25:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-syu007-1609759315 LGD_BUYER = 이병학 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210104202155 LGD_HASHDATA = c64fef02a994c672f5a7c8829282089e LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202101042025284FE2D07C855035D5E874BE808E8090B57D27A3C0 Mname = 이병학 Mcompany = 직거래농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = syu007 LGD_ESCROW_USEYN = N ========================2021-01-04 20:25:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210104202529 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 009061 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 944542******7059 LGD_FINANCEAUTHNUM = 30001804 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 76b5f10747808807481fe23431251c56 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210104202529 LGD_PCANCELSTR = 0 LGD_BUYER = 이병학 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010420252860100 LGD_BUYERID = LGD_OID = Direct-syu007-1609759315 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 420252860158 ========================2021-01-04 20:25:26======================== insert into mBoard_order set rOrdNo = 'Direct-syu007-1609759315', AuthTy = 'card', memberId = 'syu007', OrdNm ='이병학', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '직거래농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민 944542******7059', rApprNo = 'mjsof2021010420252860100', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-04 20:25:26', InvoiceNum = '결제성공:Direct-syu007-1609759315/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-04 20:25:26' ========================2021-01-04 20:25:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010420252860100' 0 = 1 cnt = 1 ========================2021-01-04 20:25:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'syu007' 0 = syu007 Mid = syu007 1 = 직거래농산 Mcompany = 직거래농산 2 = 801-97-00077 companyNum = 801-97-00077 3 = 010-3178-8686 Mtel1 = 010-3178-8686 4 = 010-3178-8686 Mhp = 010-3178-8686 ========================2021-01-04 20:25:26======================== select * from customers where id = 'syu007' ========================2021-01-04 20:25:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('syu007','2021-01-04 20:25:26','10000','11000','온라인','0')