========================2023-04-10 12:12:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yoohyukno1-1681096198 LGD_BUYER = 유혁 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410120958 LGD_HASHDATA = a27edc1a908fb6b4c8eade3c8fcbae32 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 = 20230410121847959E48EC81D415AD05167251994737B793B5925A Mname = 유혁 Mcompany = 미르농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yoohyukno1 LGD_ESCROW_USEYN = N ========================2023-04-10 12:12:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410121848 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BJCBLP LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62433100****722* LGD_FINANCEAUTHNUM = 35148118 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bed5b92d7ffcd4eac0b07227f43d50c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230410121848 LGD_PCANCELSTR = 0 LGD_BUYER = 유혁 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410121848uiCI2 LGD_BUYERID = LGD_OID = Direct-yoohyukno1-1681096198 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-10 12:12:22======================== insert into mBoard_order set rOrdNo = 'Direct-yoohyukno1-1681096198', AuthTy = 'card', memberId = 'yoohyukno1', OrdNm ='유혁', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '미르농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한CUP 62433100****722*', rApprNo = 'mjsof20230410121848uiCI2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 12:12:22', InvoiceNum = '결제성공:Direct-yoohyukno1-1681096198/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 12:12:22' ========================2023-04-10 12:12:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410121848uiCI2' 0 = 1 cnt = 1 ========================2023-04-10 12:12:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yoohyukno1' 0 = yoohyukno1 Mid = yoohyukno1 1 = 옹달샘농산 Mcompany = 옹달샘농산 2 = 7229000381 companyNum = 7229000381 3 = 010-5541-8876 Mtel1 = 010-5541-8876 4 = 010-5541-8876 Mhp = 010-5541-8876 ========================2023-04-10 12:12:22======================== select * from customers where id = 'yoohyukno1' ========================2023-04-10 12:12:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yoohyukno1','2023-04-10 12:12:22','220000','220000','온라인','0') ========================2023-04-10 15:20:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanapaper-1681107614 LGD_BUYER = 이전상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410152014 LGD_HASHDATA = 77c62ea009788f9f8542199cf3e51fbb 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 = 202304101527225269E87F8E43A049DFFA7800113E5260C8E25A36 Mname = 이전상 Mcompany = (주)미르티앤엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hanapaper LGD_ESCROW_USEYN = N ========================2023-04-10 15:20:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410152723 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003394 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41474300****181* LGD_FINANCEAUTHNUM = 30032863 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e5e2196cf5f49e802f8d226bb539a737 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230410152724 LGD_PCANCELSTR = 0 LGD_BUYER = 이전상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410152723wZev3 LGD_BUYERID = LGD_OID = Direct-hanapaper-1681107614 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0152723wYdj5 ========================2023-04-10 15:20:57======================== insert into mBoard_order set rOrdNo = 'Direct-hanapaper-1681107614', AuthTy = 'card', memberId = 'hanapaper', OrdNm ='이전상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미르티앤엠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 41474300****181*', rApprNo = 'mjsof20230410152723wZev3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 15:20:57', InvoiceNum = '결제성공:Direct-hanapaper-1681107614/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 15:20:57' ========================2023-04-10 15:20:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410152723wZev3' 0 = 1 cnt = 1 ========================2023-04-10 15:20:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanapaper' 0 = hanapaper Mid = hanapaper 1 = (주)미르티앤엠 Mcompany = (주)미르티앤엠 2 = 1348736286 companyNum = 1348736286 3 = 031-521-6690 Mtel1 = 031-521-6690 4 = 010-2216-5552 Mhp = 010-2216-5552 ========================2023-04-10 15:20:57======================== select * from customers where id = 'hanapaper' ========================2023-04-10 15:20:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanapaper','2023-04-10 15:20:57','52500','55000','온라인','0') ========================2023-04-10 15:55:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodyhs1-1681109662 LGD_BUYER = 유효상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410155422 LGD_HASHDATA = 997dcc9989edf127ee948bd18a7c90f2 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 = 20230410160152D6A61F56F062E8187D775FEB36DB90845B181AB0 Mname = 유효상 Mcompany = 해로유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodyhs1 LGD_ESCROW_USEYN = N ========================2023-04-10 15:55:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410160153 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 = 379183******208 LGD_FINANCEAUTHNUM = 08810411 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 311efeb825c04da6daab654dcacc203f LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230410160153 LGD_PCANCELSTR = 0 LGD_BUYER = 유효상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410160153pCMf3 LGD_BUYERID = LGD_OID = Direct-goodyhs1-1681109662 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-10 15:55:27======================== insert into mBoard_order set rOrdNo = 'Direct-goodyhs1-1681109662', AuthTy = 'card', memberId = 'goodyhs1', OrdNm ='유효상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해로유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성AMEX 379183******208', rApprNo = 'mjsof20230410160153pCMf3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 15:55:27', InvoiceNum = '결제성공:Direct-goodyhs1-1681109662/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 15:55:27' ========================2023-04-10 15:55:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410160153pCMf3' 0 = 1 cnt = 1 ========================2023-04-10 15:55:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodyhs1' 0 = goodyhs1 Mid = goodyhs1 1 = 해로유통 Mcompany = 해로유통 2 = 5210600305 companyNum = 5210600305 3 = 062-671-7977 Mtel1 = 062-671-7977 4 = 010-9990-7977 Mhp = 010-9990-7977 ========================2023-04-10 15:55:27======================== select * from customers where id = 'goodyhs1' ========================2023-04-10 15:55:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodyhs1','2023-04-10 15:55:27','108000','110000','온라인','0') ========================2023-04-10 15:59:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ds2avq-1681109877 LGD_BUYER = 김기철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410155757 LGD_HASHDATA = 71a7fb5504e96fe46ec8fe18bf9c05fd 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 = 202304101606012593D145028448A914F9D883C00A5BB642AC6106 Mname = 김기철 Mcompany = 화일정보산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ds2avq LGD_ESCROW_USEYN = N ========================2023-04-10 15:59:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410160601 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 = 53279300****761* LGD_FINANCEAUTHNUM = 00043529 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c122ba5e7028761efcda8035de3b6a03 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230410160602 LGD_PCANCELSTR = 0 LGD_BUYER = 김기철 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410160601w2Z77 LGD_BUYERID = LGD_OID = Direct-ds2avq-1681109877 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-10 15:59:35======================== insert into mBoard_order set rOrdNo = 'Direct-ds2avq-1681109877', AuthTy = 'card', memberId = 'ds2avq', OrdNm ='김기철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '화일정보산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 53279300****761*', rApprNo = 'mjsof20230410160601w2Z77', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 15:59:35', InvoiceNum = '결제성공:Direct-ds2avq-1681109877/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 15:59:35' ========================2023-04-10 15:59:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410160601w2Z77' 0 = 1 cnt = 1 ========================2023-04-10 15:59:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ds2avq' 0 = ds2avq Mid = ds2avq 1 = 화일정보산업 Mcompany = 화일정보산업 2 = 1341391987 companyNum = 1341391987 3 = 031-439-2800 Mtel1 = 031-439-2800 4 = 010-7707-6519 Mhp = 010-7707-6519 ========================2023-04-10 15:59:36======================== select * from customers where id = 'ds2avq' ========================2023-04-10 15:59:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ds2avq','2023-04-10 15:59:35','108000','110000','온라인','0') ========================2023-04-10 17:38:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkjung184-1681115814 LGD_BUYER = 박정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410173654 LGD_HASHDATA = 2fe86ba56bdb68ec4d8fc3afd96fd357 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 = 2023041017452143817AF098B655C49D59ABF56374E6D8A96B2148 Mname = 박정 Mcompany = 금만푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = parkjung184 LGD_ESCROW_USEYN = N ========================2023-04-10 17:38:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410174522 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834593 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91002001****272* LGD_FINANCEAUTHNUM = 44877791 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f3249ee6ae535550e6cc015cc6f0c1df LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230410174523 LGD_PCANCELSTR = 0 LGD_BUYER = 박정 LGD_CARDINSTALLMONTH = 02 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410174522tPnA6 LGD_BUYERID = LGD_OID = Direct-parkjung184-1681115814 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0174522ts784 ========================2023-04-10 17:38:56======================== insert into mBoard_order set rOrdNo = 'Direct-parkjung184-1681115814', AuthTy = 'card', memberId = 'parkjung184', OrdNm ='박정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금만푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨 91002001****272*', rApprNo = 'mjsof20230410174522tPnA6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 17:38:56', InvoiceNum = '결제성공:Direct-parkjung184-1681115814/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 17:38:56' ========================2023-04-10 17:38:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410174522tPnA6' 0 = 1 cnt = 1 ========================2023-04-10 17:38:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkjung184' 0 = parkjung184 Mid = parkjung184 1 = 금만푸드 Mcompany = 금만푸드 2 = 4230901054 companyNum = 4230901054 3 = 010-5268-2362 Mtel1 = 010-5268-2362 4 = 010-5268-2362 Mhp = 010-5268-2362 ========================2023-04-10 17:38:56======================== select * from customers where id = 'parkjung184' ========================2023-04-10 17:38:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkjung184','2023-04-10 17:38:56','52500','55000','온라인','0') ========================2023-04-10 20:33:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-l7h7w7-1681126259 LGD_BUYER = 이현우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230410203059 LGD_HASHDATA = 4c737462fa46887fe15815bba83f86e8 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 = 20230410203943C21E556AED52F0B4E964BF266E3A2235E5386B2A Mname = 이현우 Mcompany = 경북유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = l7h7w7 LGD_ESCROW_USEYN = N ========================2023-04-10 20:33:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230410203944 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40330200****071* LGD_FINANCEAUTHNUM = 00590391 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 97f082ff26dd0da98089030350996b54 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230410203944 LGD_PCANCELSTR = 0 LGD_BUYER = 이현우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230410203944AFZu6 LGD_BUYERID = LGD_OID = Direct-l7h7w7-1681126259 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-10 20:33:18======================== insert into mBoard_order set rOrdNo = 'Direct-l7h7w7-1681126259', AuthTy = 'card', memberId = 'l7h7w7', OrdNm ='이현우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '경북유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 40330200****071*', rApprNo = 'mjsof20230410203944AFZu6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-10 20:33:18', InvoiceNum = '결제성공:Direct-l7h7w7-1681126259/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-10 20:33:18' ========================2023-04-10 20:33:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230410203944AFZu6' 0 = 1 cnt = 1 ========================2023-04-10 20:33:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'l7h7w7' 0 = l7h7w7 Mid = l7h7w7 1 = 경북유통 Mcompany = 경북유통 2 = 2211329851 companyNum = 2211329851 3 = 033-244-7488 Mtel1 = 033-244-7488 4 = 010-4177-6444 Mhp = 010-4177-6444 ========================2023-04-10 20:33:18======================== select * from customers where id = 'l7h7w7' ========================2023-04-10 20:33:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('l7h7w7','2023-04-10 20:33:18','10000','11000','온라인','0')