========================2024-06-04 08:39:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1717457894 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604083814 LGD_HASHDATA = acf9797e6dd32c62cb4b082901bccdaa 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 = 202406040840137DA63A49136D5DEF000B00D837B05C0B8B8E686F 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 ========================2024-06-04 08:39:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604084014 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301703****448* LGD_FINANCEAUTHNUM = 56916102 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a09756396c5f6a0834987c41acdb4b69 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240604084015 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604084014aDKS2 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1717457894 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 08:39:35======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1717457894', 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 = 'mjsof20240604084014aDKS2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 08:39:35', InvoiceNum = '결제성공:Direct-goodssal5707-1717457894/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 08:39:35' ========================2024-06-04 08:39:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604084014aDKS2' 0 = 1 cnt = 1 ========================2024-06-04 08:39:36======================== 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 ========================2024-06-04 08:39:36======================== select * from customers where id = 'goodssal5707' ========================2024-06-04 08:39:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-06-04 08:39:35','220000','220000','온라인','0') ========================2024-06-04 08:40:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1717457986 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604083946 LGD_HASHDATA = 516e71153b99b0086d6d4d08a145688e 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 = 20240604084059E685B5D37E8C3DB094A75947543A3A5594E1F9C3 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 ========================2024-06-04 08:40:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604084100 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301703****448* LGD_FINANCEAUTHNUM = 56920806 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9dbcfc4d6d74d061cdf530fdce4ecd77 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240604084100 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604084100bDef9 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1717457986 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 08:40:21======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1717457986', 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 = 'mjsof20240604084100bDef9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 08:40:21', InvoiceNum = '결제성공:Direct-goodssal5707-1717457986/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 08:40:21' ========================2024-06-04 08:40:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604084100bDef9' 0 = 1 cnt = 1 ========================2024-06-04 08:40:21======================== 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 ========================2024-06-04 08:40:21======================== select * from customers where id = 'goodssal5707' ========================2024-06-04 08:40:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2024-06-04 08:40:21','108000','110000','온라인','0') ========================2024-06-04 10:17:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bada2680-1717463636 LGD_BUYER = 윤주현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604101356 LGD_HASHDATA = c9f76cf5bddd62179b4c5743974ed5d0 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 = 20240604101757B19F515603640982E0B0AD8F1F97619DD3CCD768 Mname = 윤주현 Mcompany = 식자재DC마트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = bada2680 LGD_ESCROW_USEYN = N ========================2024-06-04 10:17:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604101757 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009063 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797384****629* LGD_FINANCEAUTHNUM = 30015811 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = be8a1de813a3a3aef5f313e0a6030d44 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240604101757 LGD_PCANCELSTR = 0 LGD_BUYER = 윤주현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202406041017577ZXC0 LGD_BUYERID = LGD_OID = Direct-bada2680-1717463636 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 10:17:18======================== insert into mBoard_order set rOrdNo = 'Direct-bada2680-1717463636', AuthTy = 'card', memberId = 'bada2680', OrdNm ='윤주현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '식자재DC마트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797384****629*', rApprNo = 'mjsof202406041017577ZXC0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 10:17:18', InvoiceNum = '결제성공:Direct-bada2680-1717463636/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 10:17:18' ========================2024-06-04 10:17:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202406041017577ZXC0' 0 = 1 cnt = 1 ========================2024-06-04 10:17:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bada2680' 0 = bada2680 Mid = bada2680 1 = 식자재DC마트 Mcompany = 식자재DC마트 2 = 1252435497 companyNum = 1252435497 3 = 010-5225-0392 Mtel1 = 010-5225-0392 4 = 010-5225-0392 Mhp = 010-5225-0392 ========================2024-06-04 10:17:18======================== select * from customers where id = 'bada2680' ========================2024-06-04 10:17:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bada2680','2024-06-04 10:17:18','52500','55000','온라인','0') ========================2024-06-04 10:21:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-serin6023-1717463972 LGD_BUYER = 김경화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604101932 LGD_HASHDATA = 968eaef7801987a56d6e10ab224b65ca 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 = 20240604102152D76E3F79EAAE8EC4C152DB39B89D770646D90C65 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 ========================2024-06-04 10:21:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604102152 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = lck3030@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40791604****608* LGD_FINANCEAUTHNUM = 57777439 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4068f205942f665ca808c22eba0c611a LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240604102153 LGD_PCANCELSTR = 0 LGD_BUYER = 김경화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604102152jJa88 LGD_BUYERID = LGD_OID = Direct-serin6023-1717463972 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 10:21:13======================== insert into mBoard_order set rOrdNo = 'Direct-serin6023-1717463972', 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 = 'mjsof20240604102152jJa88', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 10:21:13', InvoiceNum = '결제성공:Direct-serin6023-1717463972/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 10:21:13' ========================2024-06-04 10:21:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604102152jJa88' 0 = 1 cnt = 1 ========================2024-06-04 10:21:13======================== 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 ========================2024-06-04 10:21:13======================== select * from customers where id = 'serin6023' ========================2024-06-04 10:21:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('serin6023','2024-06-04 10:21:13','220000','220000','온라인','0') ========================2024-06-04 10:36:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mnziper-1717464846 LGD_BUYER = 정형관 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604103406 LGD_HASHDATA = e659a661eb080fffa7d98d4e0daf5667 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 = 20240604103714CCF9A3BC1666D231DA4CADDB2FD84C4181A4930E Mname = 정형관 Mcompany = (주)만나케미칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = mnziper LGD_ESCROW_USEYN = N ========================2024-06-04 10:36:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604103715 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mnzipper@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****889* LGD_FINANCEAUTHNUM = 30096094 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 53b82e89f0f7b4a78e8267fe7ebb4587 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240604103715 LGD_PCANCELSTR = 0 LGD_BUYER = 정형관 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604103714jLDr3 LGD_BUYERID = LGD_OID = Direct-mnziper-1717464846 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4103714j1L31 ========================2024-06-04 10:36:35======================== insert into mBoard_order set rOrdNo = 'Direct-mnziper-1717464846', 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 = 'mjsof20240604103714jLDr3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 10:36:35', InvoiceNum = '결제성공:Direct-mnziper-1717464846/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 10:36:35' ========================2024-06-04 10:36:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604103714jLDr3' 0 = 1 cnt = 1 ========================2024-06-04 10:36:35======================== 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 ========================2024-06-04 10:36:35======================== select * from customers where id = 'mnziper' ========================2024-06-04 10:36:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mnziper','2024-06-04 10:36:35','108000','110000','온라인','0') ========================2024-06-04 11:50:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-segi114-1717469385 LGD_BUYER = 남상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604114945 LGD_HASHDATA = cdb84ec8d58d521f8500712d47af41d3 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 = 202406041151264A43A8C415DE17D2492C785B57A7A54F53F36441 Mname = 남상만 Mcompany = 세기엔지니어링 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = segi114 LGD_ESCROW_USEYN = N ========================2024-06-04 11:50:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604115127 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****286* LGD_FINANCEAUTHNUM = 30024682 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0bbf3299c3db92cbacc1b97fe8b5e8f4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240604115127 LGD_PCANCELSTR = 0 LGD_BUYER = 남상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604115126iKlM4 LGD_BUYERID = LGD_OID = Direct-segi114-1717469385 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4115126iCfN1 ========================2024-06-04 11:50:47======================== insert into mBoard_order set rOrdNo = 'Direct-segi114-1717469385', AuthTy = 'card', memberId = 'segi114', OrdNm ='남상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세기엔지니어링', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****286*', rApprNo = 'mjsof20240604115126iKlM4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 11:50:47', InvoiceNum = '결제성공:Direct-segi114-1717469385/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 11:50:47' ========================2024-06-04 11:50:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604115126iKlM4' 0 = 1 cnt = 1 ========================2024-06-04 11:50:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'segi114' 0 = segi114 Mid = segi114 1 = 세기엔지니어링 Mcompany = 세기엔지니어링 2 = 1311628322 companyNum = 1311628322 3 = 010-3888-5576 Mtel1 = 010-3888-5576 4 = 010-3214-5531 Mhp = 010-3214-5531 ========================2024-06-04 11:50:47======================== select * from customers where id = 'segi114' ========================2024-06-04 11:50:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('segi114','2024-06-04 11:50:47','52500','55000','온라인','0') ========================2024-06-04 13:54:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-olym8561-1717476786 LGD_BUYER = 이수연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604135306 LGD_HASHDATA = 37a04045f12291327391aa7406571785 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 = 202406041354540F076D00D3D8E0A097FF989ADF718F8A9261B3C9 Mname = 이수연 Mcompany = (주)올림포스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = olym8561 LGD_ESCROW_USEYN = N ========================2024-06-04 13:54:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604135454 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41402546****599* LGD_FINANCEAUTHNUM = 61488533 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6681c732d6ee44c9e0081188045b37b8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240604135455 LGD_PCANCELSTR = 0 LGD_BUYER = 이수연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604135454boX60 LGD_BUYERID = LGD_OID = Direct-olym8561-1717476786 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4135454bWEk2 ========================2024-06-04 13:54:15======================== insert into mBoard_order set rOrdNo = 'Direct-olym8561-1717476786', AuthTy = 'card', memberId = 'olym8561', OrdNm ='이수연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)올림포스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41402546****599*', rApprNo = 'mjsof20240604135454boX60', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 13:54:15', InvoiceNum = '결제성공:Direct-olym8561-1717476786/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 13:54:15' ========================2024-06-04 13:54:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604135454boX60' 0 = 1 cnt = 1 ========================2024-06-04 13:54:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'olym8561' 0 = olym8561 Mid = olym8561 1 = (주)올림포스 Mcompany = (주)올림포스 2 = 1288651704 companyNum = 1288651704 3 = 031-925-8919 Mtel1 = 031-925-8919 4 = 010-9148-2629 Mhp = 010-9148-2629 ========================2024-06-04 13:54:15======================== select * from customers where id = 'olym8561' ========================2024-06-04 13:54:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('olym8561','2024-06-04 13:54:15','108000','110000','온라인','0') ========================2024-06-04 14:51:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1934-1717480160 LGD_BUYER = 정동인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604144920 LGD_HASHDATA = df69e2205defdb084ded5d718aaf499b 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 = 2024060414515286689DB3ED8C14BC408AC4CF7B96C0E9AC330A8C Mname = 정동인 Mcompany = (주)우진글로벌 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woo1934 LGD_ESCROW_USEYN = N ========================2024-06-04 14:51:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604145152 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woojinglobal@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51055400****369* LGD_FINANCEAUTHNUM = 61312319 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 93042add9db6d79b1f34e1b58805fb86 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20240604145152 LGD_PCANCELSTR = 0 LGD_BUYER = 정동인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604145152h3m73 LGD_BUYERID = LGD_OID = Direct-woo1934-1717480160 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 14:51:13======================== insert into mBoard_order set rOrdNo = 'Direct-woo1934-1717480160', AuthTy = 'card', memberId = 'woo1934', OrdNm ='정동인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우진글로벌', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데MASTER 51055400****369*', rApprNo = 'mjsof20240604145152h3m73', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 14:51:13', InvoiceNum = '결제성공:Direct-woo1934-1717480160/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 14:51:13' ========================2024-06-04 14:51:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604145152h3m73' 0 = 1 cnt = 1 ========================2024-06-04 14:51:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo1934' 0 = woo1934 Mid = woo1934 1 = (주)우진글로벌 Mcompany = (주)우진글로벌 2 = 4038178083 companyNum = 4038178083 3 = 010-8643-1934 Mtel1 = 010-8643-1934 4 = 010-8371-3533 Mhp = 010-8371-3533 ========================2024-06-04 14:51:13======================== select * from customers where id = 'woo1934' ========================2024-06-04 14:51:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1934','2024-06-04 14:51:13','220000','220000','온라인','0') ========================2024-06-04 15:51:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-motorngear-1717483717 LGD_BUYER = 김혜영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604154837 LGD_HASHDATA = 3967fd2234511cdb9f88b01f07fffd30 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 = 20240604155144CB73F388275FA2324F4CA87F506C6020E98FD283 Mname = 김혜영 Mcompany = 모터앤기어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = motorngear LGD_ESCROW_USEYN = N ========================2024-06-04 15:51:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604155145 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****389* LGD_FINANCEAUTHNUM = 30084946 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fe5e341e0b30ef8abcd6144f2d2af397 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240604155145 LGD_PCANCELSTR = 0 LGD_BUYER = 김혜영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604155145e2JN7 LGD_BUYERID = LGD_OID = Direct-motorngear-1717483717 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4155145eIJh3 ========================2024-06-04 15:51:05======================== insert into mBoard_order set rOrdNo = 'Direct-motorngear-1717483717', AuthTy = 'card', memberId = 'motorngear', OrdNm ='김혜영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '모터앤기어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****389*', rApprNo = 'mjsof20240604155145e2JN7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 15:51:05', InvoiceNum = '결제성공:Direct-motorngear-1717483717/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 15:51:05' ========================2024-06-04 15:51:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604155145e2JN7' 0 = 1 cnt = 1 ========================2024-06-04 15:51:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'motorngear' 0 = motorngear Mid = motorngear 1 = 모터앤기어 Mcompany = 모터앤기어 2 = 131-86-29931 companyNum = 131-86-29931 3 = 032-816-3697 Mtel1 = 032-816-3697 4 = 010-3384-2521 Mhp = 010-3384-2521 ========================2024-06-04 15:51:05======================== select * from customers where id = 'motorngear' ========================2024-06-04 15:51:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('motorngear','2024-06-04 15:51:05','30900','33000','온라인','0') ========================2024-06-04 17:06:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tjswn0807-1717488327 LGD_BUYER = 이승헌 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240604170527 LGD_HASHDATA = 01f91045f2b744ee769db9d90ba7fee7 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 = 2024060417073410512B59FD2FAAD35F18AE9E7969E160431FEA5F Mname = 이승헌 Mcompany = 팩하우스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = tjswn0807 LGD_ESCROW_USEYN = N ========================2024-06-04 17:06:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240604170734 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALMA1U LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 44509010****030* LGD_FINANCEAUTHNUM = 19846681 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2785b5384e60fa5f4829b42226512888 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240604170735 LGD_PCANCELSTR = 0 LGD_BUYER = 이승헌 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240604170734lI2N9 LGD_BUYERID = LGD_OID = Direct-tjswn0807-1717488327 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-04 17:06:55======================== insert into mBoard_order set rOrdNo = 'Direct-tjswn0807-1717488327', AuthTy = 'card', memberId = 'tjswn0807', OrdNm ='이승헌', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '팩하우스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 44509010****030*', rApprNo = 'mjsof20240604170734lI2N9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-04 17:06:55', InvoiceNum = '결제성공:Direct-tjswn0807-1717488327/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-04 17:06:55' ========================2024-06-04 17:06:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240604170734lI2N9' 0 = 1 cnt = 1 ========================2024-06-04 17:06:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tjswn0807' 0 = tjswn0807 Mid = tjswn0807 1 = 팩하우스 Mcompany = 팩하우스 2 = 127-43-13471 companyNum = 127-43-13471 3 = 031-827-5107 Mtel1 = 031-827-5107 4 = 010-5493-5107 Mhp = 010-5493-5107 ========================2024-06-04 17:06:55======================== select * from customers where id = 'tjswn0807' ========================2024-06-04 17:06:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tjswn0807','2024-06-04 17:06:55','52500','55000','온라인','0')