========================2023-10-04 09:47:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hokaido-1696380325 LGD_BUYER = 김미영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004094525 LGD_HASHDATA = 2040604b94e9f542db087a0c70c440b8 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 = 2023100409493906FEEF21CF1060F4E8360671850513D9A0EA1F7A Mname = 김미영 Mcompany = (주)에이치디씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hokaido LGD_ESCROW_USEYN = N ========================2023-10-04 09:47:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004094940 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 = 42890993****404* LGD_FINANCEAUTHNUM = 40744237 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 62a0841804a40417aafe706addfaaaee LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20231004094940 LGD_PCANCELSTR = 0 LGD_BUYER = 김미영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004094940K3q48 LGD_BUYERID = LGD_OID = Direct-hokaido-1696380325 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 09:47:22======================== insert into mBoard_order set rOrdNo = 'Direct-hokaido-1696380325', AuthTy = 'card', memberId = 'hokaido', OrdNm ='김미영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이치디씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '하나VISA 42890993****404*', rApprNo = 'mjsof20231004094940K3q48', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 09:47:22', InvoiceNum = '결제성공:Direct-hokaido-1696380325/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 09:47:22' ========================2023-10-04 09:47:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004094940K3q48' 0 = 1 cnt = 1 ========================2023-10-04 09:47:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hokaido' 0 = hokaido Mid = hokaido 1 = (주)에이치디씨 Mcompany = (주)에이치디씨 2 = 129-81-68275 companyNum = 129-81-68275 3 = 031-675-9967 Mtel1 = 031-675-9967 4 = 011-433-3972 Mhp = 011-433-3972 ========================2023-10-04 09:47:22======================== select * from customers where id = 'hokaido' ========================2023-10-04 09:47:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hokaido','2023-10-04 09:47:22','108000','110000','온라인','0') ========================2023-10-04 10:02:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1696381295 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004100135 LGD_HASHDATA = 2ede9601a72fa128bddd70cfa0b25812 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 = 20231004100452BA27F25311B74C443956B126BD3D7095E5FDD67E Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2023-10-04 10:02:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004100452 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 = 94301703****448* LGD_FINANCEAUTHNUM = 71911457 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4924e2b391025c821c57b8b17868c37d LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231004100453 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004100452vF344 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1696381295 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 10:02:34======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1696381295', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20231004100452vF344', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 10:02:34', InvoiceNum = '결제성공:Direct-goodssal5707-1696381295/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 10:02:34' ========================2023-10-04 10:02:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004100452vF344' 0 = 1 cnt = 1 ========================2023-10-04 10:02:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2023-10-04 10:02:34======================== select * from customers where id = 'goodssal5707' ========================2023-10-04 10:02:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2023-10-04 10:02:34','220000','220000','온라인','0') ========================2023-10-04 10:03:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1696381366 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004100246 LGD_HASHDATA = 59a2c3d72a7f2283d73ba4a18778e8b9 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 = 202310041005475103D10007D8E8D02090DA605BBF9FAF4AAC11F8 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2023-10-04 10:03:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004100548 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 = 94301703****448* LGD_FINANCEAUTHNUM = 71921423 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a2a505b325fa0ea079ba51fd87e7ecdb LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231004100548 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004100548O7yl7 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1696381366 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 10:03:29======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1696381366', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20231004100548O7yl7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 10:03:29', InvoiceNum = '결제성공:Direct-goodssal5707-1696381366/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 10:03:29' ========================2023-10-04 10:03:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004100548O7yl7' 0 = 1 cnt = 1 ========================2023-10-04 10:03:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2023-10-04 10:03:29======================== select * from customers where id = 'goodssal5707' ========================2023-10-04 10:03:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2023-10-04 10:03:29','108000','110000','온라인','0') ========================2023-10-04 10:18:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodfood2023-1696381975 LGD_BUYER = 최상용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004101255 LGD_HASHDATA = 2b2fc698d80483ef6d52be8fa6769f35 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 = 2023100410204396DE920728F5A94EE1DE77C3AA38B26E3BF11D68 Mname = 최상용 Mcompany = 좋은푸드컬리주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodfood2023 LGD_ESCROW_USEYN = N ========================2023-10-04 10:18:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004102044 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****697* LGD_FINANCEAUTHNUM = 37720607 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 19c31997e93e1d5945060e87245c355d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231004102044 LGD_PCANCELSTR = 0 LGD_BUYER = 최상용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004102044BeqH1 LGD_BUYERID = LGD_OID = Direct-goodfood2023-1696381975 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4102044Bg8N9 ========================2023-10-04 10:18:26======================== insert into mBoard_order set rOrdNo = 'Direct-goodfood2023-1696381975', AuthTy = 'card', memberId = 'goodfood2023', OrdNm ='최상용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '좋은푸드컬리주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****697*', rApprNo = 'mjsof20231004102044BeqH1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 10:18:26', InvoiceNum = '결제성공:Direct-goodfood2023-1696381975/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 10:18:26' ========================2023-10-04 10:18:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004102044BeqH1' 0 = 1 cnt = 1 ========================2023-10-04 10:18:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodfood2023' 0 = goodfood2023 Mid = goodfood2023 1 = 좋은푸드컬리주식회사 Mcompany = 좋은푸드컬리주식회사 2 = 112-86-02741 companyNum = 112-86-02741 3 = 010-8880-9146 Mtel1 = 010-8880-9146 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2023-10-04 10:18:26======================== select * from customers where id = 'goodfood2023' ========================2023-10-04 10:18:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodfood2023','2023-10-04 10:18:26','108000','110000','온라인','0') ========================2023-10-04 10:21:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sayysh61-1696382380 LGD_BUYER = 양성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004101940 LGD_HASHDATA = eda7b0fcc9baadf7dbb3ac87a5882fbb 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 = 20231004102347DB9C7CBEE581B7D7EF518D1960C2C4DFE880587A Mname = 양성희 Mcompany = 블루메디칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sayysh61 LGD_ESCROW_USEYN = N ========================2023-10-04 10:21:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004102347 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 = 55201421****196* LGD_FINANCEAUTHNUM = 19069124 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7c48cd80fcd63987c94786049e9aabb3 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20231004102348 LGD_PCANCELSTR = 0 LGD_BUYER = 양성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004102347xN0C4 LGD_BUYERID = LGD_OID = Direct-sayysh61-1696382380 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 10:21:29======================== insert into mBoard_order set rOrdNo = 'Direct-sayysh61-1696382380', AuthTy = 'card', memberId = 'sayysh61', OrdNm ='양성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '블루메디칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 55201421****196*', rApprNo = 'mjsof20231004102347xN0C4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 10:21:29', InvoiceNum = '결제성공:Direct-sayysh61-1696382380/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 10:21:29' ========================2023-10-04 10:21:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004102347xN0C4' 0 = 1 cnt = 1 ========================2023-10-04 10:21:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sayysh61' 0 = sayysh61 Mid = sayysh61 1 = 블루메디칼 Mcompany = 블루메디칼 2 = 119-12-39710 companyNum = 119-12-39710 3 = 02-805-6451 Mtel1 = 02-805-6451 4 = 010-3581-4479 Mhp = 010-3581-4479 ========================2023-10-04 10:21:29======================== select * from customers where id = 'sayysh61' ========================2023-10-04 10:21:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sayysh61','2023-10-04 10:21:29','108000','110000','온라인','0') ========================2023-10-04 10:52:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjw1439-1696384253 LGD_BUYER = 박흥수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004105053 LGD_HASHDATA = e026f08382194cb676f8ed83e55f8c7e 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 = 20231004105506FD640CD944662C4B97850324DF9A1DAAF7CE154F Mname = 박흥수 Mcompany = (주)모닝에프디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = pjw1439 LGD_ESCROW_USEYN = N ========================2023-10-04 10:52:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004105507 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 = 55317172****375* LGD_FINANCEAUTHNUM = 72465461 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e5786b58742ab24fb3ffe1fb4cdb45b5 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231004105507 LGD_PCANCELSTR = 0 LGD_BUYER = 박흥수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004105506Ahmr9 LGD_BUYERID = LGD_OID = Direct-pjw1439-1696384253 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 10:52:49======================== insert into mBoard_order set rOrdNo = 'Direct-pjw1439-1696384253', AuthTy = 'card', memberId = 'pjw1439', OrdNm ='박흥수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)모닝에프디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317172****375*', rApprNo = 'mjsof20231004105506Ahmr9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 10:52:49', InvoiceNum = '결제성공:Direct-pjw1439-1696384253/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 10:52:49' ========================2023-10-04 10:52:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004105506Ahmr9' 0 = 1 cnt = 1 ========================2023-10-04 10:52:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pjw1439' 0 = pjw1439 Mid = pjw1439 1 = (주)모닝에프디 Mcompany = (주)모닝에프디 2 = 4328800262 companyNum = 4328800262 3 = 010-4820-4572 Mtel1 = 010-4820-4572 4 = 010-2545-9942 Mhp = 010-2545-9942 ========================2023-10-04 10:52:49======================== select * from customers where id = 'pjw1439' ========================2023-10-04 10:52:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pjw1439','2023-10-04 10:52:49','52500','55000','온라인','0') ========================2023-10-04 11:26:24======================== res_start ========================2023-10-04 11:26:24======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2023-10-04 11:59:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mnziper-1696387559 LGD_BUYER = 정형관 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004114559 LGD_HASHDATA = 1938f631c6f20ee12bb59e381c7521a6 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 = 20231004120139F3F45E2B6738CD3EDB53ABF996A8DB900760C168 Mname = 정형관 Mcompany = (주)만나케미칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = mnzipper@naver.com UserId = mnziper LGD_ESCROW_USEYN = N ========================2023-10-04 11:59:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004120140 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mnzipper@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****889* LGD_FINANCEAUTHNUM = 30082998 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fc8c8d0ac67887a9df74565e45f15fa2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231004120140 LGD_PCANCELSTR = 0 LGD_BUYER = 정형관 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004120139C7Rq0 LGD_BUYERID = LGD_OID = Direct-mnziper-1696387559 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4120139CmRI8 ========================2023-10-04 11:59:21======================== insert into mBoard_order set rOrdNo = 'Direct-mnziper-1696387559', AuthTy = 'card', memberId = 'mnziper', OrdNm ='정형관', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)만나케미칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****889*', rApprNo = 'mjsof20231004120139C7Rq0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 11:59:21', InvoiceNum = '결제성공:Direct-mnziper-1696387559/0000', Deliver = '', senditem = 'mnzipper@naver.com', salestopvalue = '', mod_date = '2023-10-04 11:59:21' ========================2023-10-04 11:59:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004120139C7Rq0' 0 = 1 cnt = 1 ========================2023-10-04 11:59:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mnziper' 0 = mnziper Mid = mnziper 1 = (주)만나케미칼 Mcompany = (주)만나케미칼 2 = 3518600993 companyNum = 3518600993 3 = 032-671-8070 Mtel1 = 032-671-8070 4 = 010-4569-3717 Mhp = 010-4569-3717 ========================2023-10-04 11:59:21======================== select * from customers where id = 'mnziper' ========================2023-10-04 11:59:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mnziper','2023-10-04 11:59:21','108000','110000','온라인','0') ========================2023-10-04 13:35:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tndbs12-1696393864 LGD_BUYER = 김수윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004133104 LGD_HASHDATA = 19ba503c4d924ed88d78418587e01321 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 = 20231004133751831782D9F64CF2F8C6A86F69EB0990F811233D4D Mname = 김수윤 Mcompany = 수복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tndbs12 LGD_ESCROW_USEYN = N ========================2023-10-04 13:35:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004133751 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 009216 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35641594****206* LGD_FINANCEAUTHNUM = 30077954 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 20de4b34823b670313fb80d4a97fd843 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231004133752 LGD_PCANCELSTR = 0 LGD_BUYER = 김수윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004133751Rp715 LGD_BUYERID = LGD_OID = Direct-tndbs12-1696393864 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 13:35:33======================== insert into mBoard_order set rOrdNo = 'Direct-tndbs12-1696393864', AuthTy = 'card', memberId = 'tndbs12', OrdNm ='김수윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '수복유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민JCB 35641594****206*', rApprNo = 'mjsof20231004133751Rp715', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 13:35:33', InvoiceNum = '결제성공:Direct-tndbs12-1696393864/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 13:35:33' ========================2023-10-04 13:35:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004133751Rp715' 0 = 1 cnt = 1 ========================2023-10-04 13:35:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tndbs12' 0 = tndbs12 Mid = tndbs12 1 = 수복유통 Mcompany = 수복유통 2 = 4589600181 companyNum = 4589600181 3 = 010-5400-8883 Mtel1 = 010-5400-8883 4 = 010-5400-8883 Mhp = 010-5400-8883 ========================2023-10-04 13:35:33======================== select * from customers where id = 'tndbs12' ========================2023-10-04 13:35:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tndbs12','2023-10-04 13:35:33','30900','33000','온라인','0') ========================2023-10-04 15:29:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dae1936-1696400915 LGD_BUYER = 전찬홍 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004152835 LGD_HASHDATA = 7281d434f05a95a07494271462256a59 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 = 20231004153215AFF743030960DA00F481FEF9DA76A14F1A667D22 Mname = 전찬홍 Mcompany = 대건비니루상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dae1936 LGD_ESCROW_USEYN = N ========================2023-10-04 15:29:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004153216 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373C0C LGD_AFFILIATECODE = AEA009 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184212****825* LGD_FINANCEAUTHNUM = 48041776 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 506c4c9a0eccafb98620fb53071f4507 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231004153216 LGD_PCANCELSTR = 0 LGD_BUYER = 전찬홍 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004153216wAua4 LGD_BUYERID = LGD_OID = Direct-dae1936-1696400915 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 15:29:57======================== insert into mBoard_order set rOrdNo = 'Direct-dae1936-1696400915', AuthTy = 'card', memberId = 'dae1936', OrdNm ='전찬홍', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대건비니루상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 45184212****825*', rApprNo = 'mjsof20231004153216wAua4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 15:29:57', InvoiceNum = '결제성공:Direct-dae1936-1696400915/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 15:29:57' ========================2023-10-04 15:29:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004153216wAua4' 0 = 1 cnt = 1 ========================2023-10-04 15:29:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dae1936' 0 = dae1936 Mid = dae1936 1 = 대건비니루상사 Mcompany = 대건비니루상사 2 = 202-31-60141 companyNum = 202-31-60141 3 = 02-2265-1936 Mtel1 = 02-2265-1936 4 = 010-3920-1936 Mhp = 010-3920-1936 ========================2023-10-04 15:29:57======================== select * from customers where id = 'dae1936' ========================2023-10-04 15:29:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dae1936','2023-10-04 15:29:57','220000','220000','온라인','0') ========================2023-10-04 16:26:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pcwjun-1696404288 LGD_BUYER = 박찬우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004162448 LGD_HASHDATA = 7806865bbc0f6cb2f284a6b45a9ca2a6 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 = 20231004162849C39E5815494F004C646CC321A23E2DFC25D92CBD Mname = 박찬우 Mcompany = 은성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pcwjun LGD_ESCROW_USEYN = N ========================2023-10-04 16:26:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231004162850 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852638****181* LGD_FINANCEAUTHNUM = 30019074 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2b9c7533a3b4d19cbd70ee71cede1864 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231004162850 LGD_PCANCELSTR = 0 LGD_BUYER = 박찬우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004162850YFXH5 LGD_BUYERID = LGD_OID = Direct-pcwjun-1696404288 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4162850YX0n9 ========================2023-10-04 16:26:31======================== insert into mBoard_order set rOrdNo = 'Direct-pcwjun-1696404288', AuthTy = 'card', memberId = 'pcwjun', OrdNm ='박찬우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '은성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852638****181*', rApprNo = 'mjsof20231004162850YFXH5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 16:26:31', InvoiceNum = '결제성공:Direct-pcwjun-1696404288/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 16:26:31' ========================2023-10-04 16:26:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004162850YFXH5' 0 = 1 cnt = 1 ========================2023-10-04 16:26:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pcwjun' 0 = pcwjun Mid = pcwjun 1 = 은성유통 Mcompany = 은성유통 2 = 1123048599 companyNum = 1123048599 3 = 010-6674-8808 Mtel1 = 010-6674-8808 4 = 010-6674-8808 Mhp = 010-6674-8808 ========================2023-10-04 16:26:31======================== select * from customers where id = 'pcwjun' ========================2023-10-04 16:26:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pcwjun','2023-10-04 16:26:31','220000','220000','온라인','0') ========================2023-10-04 17:16:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jsjs1018-1696406431 LGD_BUYER = 전성림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231004170031 LGD_HASHDATA = 11495aaa081c096c440668a1073ba967 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 = 20231004171900675CC56423871FFB17198EEDF94EB6C3E5E1EE7D Mname = 전성림 Mcompany = 혜 창 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jsjs1018 LGD_ESCROW_USEYN = N ========================2023-10-04 17:16:44======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20231004171903 LGD_DISCOUNTUSEYN = 1 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 = 53107080****840* LGD_FINANCEAUTHNUM = 64368635 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 1500 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8a4b8143cff31ba090e36f8aa83d4b82 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20231004171903 LGD_PCANCELSTR = 0 LGD_BUYER = 전성림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231004171902MAkh1 LGD_BUYERID = LGD_OID = Direct-jsjs1018-1696406431 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-04 17:16:44======================== insert into mBoard_order set rOrdNo = 'Direct-jsjs1018-1696406431', AuthTy = 'card', memberId = 'jsjs1018', OrdNm ='전성림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '혜 창', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 53107080****840*', rApprNo = 'mjsof20231004171902MAkh1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-04 17:16:44', InvoiceNum = '결제성공:Direct-jsjs1018-1696406431/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-04 17:16:44' ========================2023-10-04 17:16:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231004171902MAkh1' 0 = 1 cnt = 1 ========================2023-10-04 17:16:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jsjs1018' 0 = jsjs1018 Mid = jsjs1018 1 = 혜 창 Mcompany = 혜 창 2 = 204-22-79343 companyNum = 204-22-79343 3 = 02-2242-1126 Mtel1 = 02-2242-1126 4 = 010-5344-9245 Mhp = 010-5344-9245 ========================2023-10-04 17:16:44======================== select * from customers where id = 'jsjs1018' ========================2023-10-04 17:16:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jsjs1018','2023-10-04 17:16:44','108000','110000','온라인','0')