========================2023-05-01 08:43:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-serin6023-1682898124 LGD_BUYER = 김경화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230501084204 LGD_HASHDATA = c1859c6d1e861f29b2e7b89d9b974dae LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20230501085039E4AEE99228E3859A86D43D8D1C8ED09759B0B1EC Mname = 김경화 Mcompany = 농업회사법인(주)세린 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = serin6023 LGD_ESCROW_USEYN = N ========================2023-05-01 08:43:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230501085040 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 = 40791604****608* LGD_FINANCEAUTHNUM = 69222947 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ac4dd522b2ef0fbabbbd8b0473d74d1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230501085041 LGD_PCANCELSTR = 0 LGD_BUYER = 김경화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230501085040afi62 LGD_BUYERID = LGD_OID = Direct-serin6023-1682898124 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-01 08:43:51======================== insert into mBoard_order set rOrdNo = 'Direct-serin6023-1682898124', AuthTy = 'card', memberId = 'serin6023', OrdNm ='김경화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '농업회사법인(주)세린', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH VISA 40791604****608*', rApprNo = 'mjsof20230501085040afi62', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-01 08:43:51', InvoiceNum = '결제성공:Direct-serin6023-1682898124/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-01 08:43:51' ========================2023-05-01 08:43:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230501085040afi62' 0 = 1 cnt = 1 ========================2023-05-01 08:43:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'serin6023' 0 = serin6023 Mid = serin6023 1 = 농업회사법인(주)세린 Mcompany = 농업회사법인(주)세린 2 = 140-81-87037 companyNum = 140-81-87037 3 = 010-5624-8318 Mtel1 = 010-5624-8318 4 = 010-5624-8318 Mhp = 010-5624-8318 ========================2023-05-01 08:43:52======================== select * from customers where id = 'serin6023' ========================2023-05-01 08:43:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('serin6023','2023-05-01 08:43:51','220000','220000','온라인','0') ========================2023-05-01 09:12:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kysung8975-1682899772 LGD_BUYER = 송경국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230501090932 LGD_HASHDATA = c5234e817a1b5f04ea4787fa706a90d4 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202305010919041B5880E1DD8E5C3A5F8AD8C439272E9003E7ED10 Mname = 송경국 Mcompany = 경성기업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kysung8975 LGD_ESCROW_USEYN = N ========================2023-05-01 09:12:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230501091904 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 = 52428399****463* LGD_FINANCEAUTHNUM = 90970682 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d75be40417b030b436a65c8302346357 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230501091904 LGD_PCANCELSTR = 0 LGD_BUYER = 송경국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202305010919049Oq57 LGD_BUYERID = LGD_OID = Direct-kysung8975-1682899772 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-01 09:12:15======================== insert into mBoard_order set rOrdNo = 'Direct-kysung8975-1682899772', AuthTy = 'card', memberId = 'kysung8975', OrdNm ='송경국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '경성기업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '삼성MASTER 52428399****463*', rApprNo = 'mjsof202305010919049Oq57', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-01 09:12:15', InvoiceNum = '결제성공:Direct-kysung8975-1682899772/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-01 09:12:15' ========================2023-05-01 09:12:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202305010919049Oq57' 0 = 1 cnt = 1 ========================2023-05-01 09:12:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kysung8975' 0 = kysung8975 Mid = kysung8975 1 = 경성기업 Mcompany = 경성기업 2 = 385-28-01340 companyNum = 385-28-01340 3 = 010-8975-0112 Mtel1 = 010-8975-0112 4 = 010-8975-0112 Mhp = 010-8975-0112 ========================2023-05-01 09:12:15======================== select * from customers where id = 'kysung8975' ========================2023-05-01 09:12:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kysung8975','2023-05-01 09:12:15','220000','220000','온라인','0') ========================2023-05-01 09:37:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1682901422 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230501093702 LGD_HASHDATA = c89663d589adbaa6a870cae49b675837 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20230501094447978238C17182C45B66D7B7E94CF5010EA0BEE365 Mname = 신완철 Mcompany = (주)빅브라더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bigbrother LGD_ESCROW_USEYN = N ========================2023-05-01 09:37:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230501094447 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****400* LGD_FINANCEAUTHNUM = 49729815 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1e6715c4f23f13aa117a852b5d422f16 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230501094448 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230501094447bw2R5 LGD_BUYERID = LGD_OID = Direct-bigbrother-1682901422 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1094447bMpn5 ========================2023-05-01 09:37:58======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1682901422', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****400*', rApprNo = 'mjsof20230501094447bw2R5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-01 09:37:58', InvoiceNum = '결제성공:Direct-bigbrother-1682901422/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-01 09:37:58' ========================2023-05-01 09:37:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230501094447bw2R5' 0 = 1 cnt = 1 ========================2023-05-01 09:37:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bigbrother' 0 = bigbrother Mid = bigbrother 1 = (주)빅브라더 Mcompany = (주)빅브라더 2 = 7828800717 companyNum = 7828800717 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7747-5701 Mhp = 010-7747-5701 ========================2023-05-01 09:37:59======================== select * from customers where id = 'bigbrother' ========================2023-05-01 09:37:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2023-05-01 09:37:58','220000','220000','온라인','0') ========================2023-05-01 14:04:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fab9992-1682917448 LGD_BUYER = 신호철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230501140408 LGD_HASHDATA = c551586a4aa5951a7b6ca56e030136b9 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20230501141141F403B72B5EF9092EE6D279274940DBE01DAFD80F Mname = 신호철 Mcompany = 대도스포츠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = fab9992 LGD_ESCROW_USEYN = N ========================2023-05-01 14:04:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230501141141 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658603****706* LGD_FINANCEAUTHNUM = 30008202 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bc3ef02f59e4cf913a88f3f97923610f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230501141141 LGD_PCANCELSTR = 0 LGD_BUYER = 신호철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230501141141aQJm0 LGD_BUYERID = LGD_OID = Direct-fab9992-1682917448 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-01 14:04:52======================== insert into mBoard_order set rOrdNo = 'Direct-fab9992-1682917448', AuthTy = 'card', memberId = 'fab9992', OrdNm ='신호철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대도스포츠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658603****706*', rApprNo = 'mjsof20230501141141aQJm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-01 14:04:52', InvoiceNum = '결제성공:Direct-fab9992-1682917448/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-01 14:04:52' ========================2023-05-01 14:04:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230501141141aQJm0' 0 = 1 cnt = 1 ========================2023-05-01 14:04:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fab9992' 0 = fab9992 Mid = fab9992 1 = 대도스포츠 Mcompany = 대도스포츠 2 = 5360302018 companyNum = 5360302018 3 = 02-853-5036 Mtel1 = 02-853-5036 4 = 010-4751-0004 Mhp = 010-4751-0004 ========================2023-05-01 14:04:53======================== select * from customers where id = 'fab9992' ========================2023-05-01 14:04:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fab9992','2023-05-01 14:04:52','220000','220000','온라인','0')