========================2022-11-07 10:59:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rhgid2020-1667786215 LGD_BUYER = 박병철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107105655 LGD_HASHDATA = e2731c8f1d6f04c63e8149b8d2cf231d LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221107110331BA95ACD06EE018B087ABF5336B3FCD186F0D99F4 Mname = 박병철 Mcompany = (유)고향식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rhgid2020 LGD_ESCROW_USEYN = N ========================2022-11-07 10:59:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107110332 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(1회사용한도초과) LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = ba57f3ce41a0e8ca1451c2e6e09b3027 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221107110332 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 박병철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071103317ngr1 LGD_BUYERID = LGD_OID = Direct-rhgid2020-1667786215 LGD_RESPCODE = 0016 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-11-07 11:14:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rhgid2020-1667787223 LGD_BUYER = 박병철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107111343 LGD_HASHDATA = c0390fad989ffdf3c1d6fdbf3534775f LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221107111753955CCC54515784346D3A25E1140ACC84BCFFAD4E Mname = 박병철 Mcompany = (유)고향식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rhgid2020 LGD_ESCROW_USEYN = N ========================2022-11-07 11:14:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107111753 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94907105****531* LGD_FINANCEAUTHNUM = 23239555 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 35000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 06ebf21fefb6fa0ced9451eeed960663 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221107111754 LGD_PCANCELSTR = 0 LGD_BUYER = 박병철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071117536U3l1 LGD_BUYERID = LGD_OID = Direct-rhgid2020-1667787223 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71117536q1S0 ========================2022-11-07 11:14:18======================== insert into mBoard_order set rOrdNo = 'Direct-rhgid2020-1667787223', AuthTy = 'card', memberId = 'rhgid2020', OrdNm ='박병철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)고향식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '전북 94907105****531*', rApprNo = 'mjsof202211071117536U3l1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 11:14:18', InvoiceNum = '결제성공:Direct-rhgid2020-1667787223/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 11:14:18' ========================2022-11-07 11:14:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211071117536U3l1' 0 = 1 cnt = 1 ========================2022-11-07 11:14:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rhgid2020' 0 = rhgid2020 Mid = rhgid2020 1 = (유)고향식품 Mcompany = (유)고향식품 2 = 4188150923 companyNum = 4188150923 3 = 010-5341-5361 Mtel1 = 010-5341-5361 4 = 010-5341-5361 Mhp = 010-5341-5361 ========================2022-11-07 11:14:18======================== select * from customers where id = 'rhgid2020' ========================2022-11-07 11:14:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rhgid2020','2022-11-07 11:14:18','220000','220000','온라인','0') ========================2022-11-07 12:01:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-seorinsangsa-1667789987 LGD_BUYER = 정인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107115947 LGD_HASHDATA = cee2adbb3fd1b61a3e7957de0a0a75f2 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110712045991CF37AE776C7682AF672AE4CAC89F55EF614FDC Mname = 정인숙 Mcompany = 서린상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = seorinsangsa LGD_ESCROW_USEYN = N ========================2022-11-07 12:01:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107120500 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41710305****090* LGD_FINANCEAUTHNUM = 60409987 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 889e087a5074597ebb2dfd707fd6cd1f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221107120501 LGD_PCANCELSTR = 0 LGD_BUYER = 정인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071205008eB77 LGD_BUYERID = LGD_OID = Direct-seorinsangsa-1667789987 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 712050089UM6 ========================2022-11-07 12:01:25======================== insert into mBoard_order set rOrdNo = 'Direct-seorinsangsa-1667789987', AuthTy = 'card', memberId = 'seorinsangsa', OrdNm ='정인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서린상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41710305****090*', rApprNo = 'mjsof202211071205008eB77', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 12:01:25', InvoiceNum = '결제성공:Direct-seorinsangsa-1667789987/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 12:01:25' ========================2022-11-07 12:01:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211071205008eB77' 0 = 1 cnt = 1 ========================2022-11-07 12:01:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'seorinsangsa' 0 = seorinsangsa Mid = seorinsangsa 1 = 서린상사 Mcompany = 서린상사 2 = 1378623385 companyNum = 1378623385 3 = 032-562-2057 Mtel1 = 032-562-2057 4 = 010-5423-2057 Mhp = 010-5423-2057 ========================2022-11-07 12:01:25======================== select * from customers where id = 'seorinsangsa' ========================2022-11-07 12:01:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('seorinsangsa','2022-11-07 12:01:25','220000','220000','온라인','0') ========================2022-11-07 14:23:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joygarden-1667798568 LGD_BUYER = 백성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107142248 LGD_HASHDATA = 723b7440b29c972e0250fd2cc063b021 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211071427159E3BFF2B678727970B8847DCADC8236E576C4197 Mname = 백성희 Mcompany = 조이가든센터 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joygarden LGD_ESCROW_USEYN = N ========================2022-11-07 14:23:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107142716 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641505****396* LGD_FINANCEAUTHNUM = 61803491 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 78667d55b52addc395cc3b3e541acbc8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221107142716 LGD_PCANCELSTR = 0 LGD_BUYER = 백성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071427161Jbb3 LGD_BUYERID = LGD_OID = Direct-joygarden-1667798568 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71427161pYQ2 ========================2022-11-07 14:23:40======================== insert into mBoard_order set rOrdNo = 'Direct-joygarden-1667798568', AuthTy = 'card', memberId = 'joygarden', OrdNm ='백성희 ', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '조이가든센터', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62641505****396*', rApprNo = 'mjsof202211071427161Jbb3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 14:23:40', InvoiceNum = '결제성공:Direct-joygarden-1667798568/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 14:23:40' ========================2022-11-07 14:23:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211071427161Jbb3' 0 = 1 cnt = 1 ========================2022-11-07 14:23:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joygarden' 0 = joygarden Mid = joygarden 1 = 조이가든센터 Mcompany = 조이가든센터 2 = 1388179553 companyNum = 1388179553 3 = 02-632-5334 Mtel1 = 02-632-5334 4 = 010-7558-8381 Mhp = 010-7558-8381 ========================2022-11-07 14:23:40======================== select * from customers where id = 'joygarden' ========================2022-11-07 14:23:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joygarden','2022-11-07 14:23:40','108000','110000','온라인','0') ========================2022-11-07 15:14:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1667801602 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107151322 LGD_HASHDATA = 8b8d9754e8040ad06a5284ee61ed0e52 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221107151801FD3CD4954DDFC59253E5E178D888BEDB10764EBB Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2022-11-07 15:14:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107151802 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30051401 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a80773a6bda59c35cf086b424fdc500b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221107151802 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071518013MSl1 LGD_BUYERID = LGD_OID = Direct-davis747-1667801602 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71518013Y3S0 ========================2022-11-07 15:14:26======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1667801602', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658696****764*', rApprNo = 'mjsof202211071518013MSl1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 15:14:26', InvoiceNum = '결제성공:Direct-davis747-1667801602/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 15:14:26' ========================2022-11-07 15:14:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211071518013MSl1' 0 = 1 cnt = 1 ========================2022-11-07 15:14:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2022-11-07 15:14:26======================== select * from customers where id = 'davis747' ========================2022-11-07 15:14:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2022-11-07 15:14:26','108000','110000','온라인','0') ========================2022-11-07 16:42:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedang2018-1667806893 LGD_BUYER = 김현정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107164133 LGD_HASHDATA = a50bc306ad2e9ca15d1e856f75e7f13b LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110716455166405156DFC7ABA321F7216F85CE713956432B09 Mname = 김현정 Mcompany = (주)예당 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yedang2018 LGD_ESCROW_USEYN = N ========================2022-11-07 16:42:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107164552 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55314600****487* LGD_FINANCEAUTHNUM = 09718183 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b1fce7e47e20bf52f217b8e3ce5c8c46 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221107164552 LGD_PCANCELSTR = 0 LGD_BUYER = 김현정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202211071645523UVF9 LGD_BUYERID = LGD_OID = Direct-yedang2018-1667806893 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-07 16:42:16======================== insert into mBoard_order set rOrdNo = 'Direct-yedang2018-1667806893', AuthTy = 'card', memberId = 'yedang2018', OrdNm ='김현정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)예당', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한MASTER 55314600****487*', rApprNo = 'mjsof202211071645523UVF9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 16:42:16', InvoiceNum = '결제성공:Direct-yedang2018-1667806893/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 16:42:16' ========================2022-11-07 16:42:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211071645523UVF9' 0 = 1 cnt = 1 ========================2022-11-07 16:42:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yedang2018' 0 = yedang2018 Mid = yedang2018 1 = (주)예당 Mcompany = (주)예당 2 = 8438801097 companyNum = 8438801097 3 = 032-465-2174 Mtel1 = 032-465-2174 4 = 010-4806-0245 Mhp = 010-4806-0245 ========================2022-11-07 16:42:16======================== select * from customers where id = 'yedang2018' ========================2022-11-07 16:42:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yedang2018','2022-11-07 16:42:16','52500','55000','온라인','0') ========================2022-11-07 17:02:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1667808107 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107170147 LGD_HASHDATA = df1763678ef56a286abec3afa6290238 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110717055397FDA1C3C8C81894F78BE8057A6E703E95427A92 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-11-07 17:02:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107170553 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****391* LGD_FINANCEAUTHNUM = 62931409 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6a6e297324ac6b73ab6ac7cb931e73e6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221107170554 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221107170553ay8B9 LGD_BUYERID = LGD_OID = Direct-paintds-1667808107 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7170553ahPt9 ========================2022-11-07 17:03:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1667808172 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107170252 LGD_HASHDATA = 1054ef3d52242950bbea1b1cef6f448a LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110717065542F02025B4322F69131343AB3D477E7DEEFDC0AD Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-11-07 17:03:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107170656 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****391* LGD_FINANCEAUTHNUM = 62935404 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f52b8dba6773858387019d92c6c2b4ab LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221107170656 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071706557VhT7 LGD_BUYERID = LGD_OID = Direct-paintds-1667808172 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71706557Wh28 ========================2022-11-07 17:07:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1667808414 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107170654 LGD_HASHDATA = 6bbd91d5ff4a674eb1f3af1e943bf5fe LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221107171108E92E15162C528B25D740579B46CD9A6DD38A14B7 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-11-07 17:07:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107171108 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****391* LGD_FINANCEAUTHNUM = 63010531 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3582445bb71507b01388093ea3963be2 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221107171109 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211071711086qOt3 LGD_BUYERID = LGD_OID = Direct-paintds-1667808414 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71711086BSx9 ========================2022-11-07 17:07:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1667808414 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107170654 LGD_HASHDATA = 6bbd91d5ff4a674eb1f3af1e943bf5fe LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221107171108E92E15162C528B25D740579B46CD9A6DD38A14B7 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-11-07 17:07:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107171127 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-paintds-1667808414]는 2022/11/07 17:11:08 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 63010531 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 61e5e91f35c1e8aade95d176248716eb LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20221107171127 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof202211071711086qOt3 LGD_BUYERID = LGD_OID = Direct-paintds-1667808414 LGD_RESPCODE = S007 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-11-07 20:13:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1667819545 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221107201225 LGD_HASHDATA = a185710360ae37aacd84421a9f5565de LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110720173329A8706484F93C63E0DB8F85AC5710970CD1DC95 Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2022-11-07 20:13:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221107201733 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 = 94091511****271* LGD_FINANCEAUTHNUM = 47340330 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 19d8fe6328c29e294a85b6a4db6d3c8b LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221107201734 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202211072017332rK00 LGD_BUYERID = LGD_OID = Direct-antwin77-1667819545 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-07 20:13:57======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1667819545', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****271*', rApprNo = 'mjsof202211072017332rK00', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-07 20:13:57', InvoiceNum = '결제성공:Direct-antwin77-1667819545/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-07 20:13:57' ========================2022-11-07 20:13:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211072017332rK00' 0 = 1 cnt = 1 ========================2022-11-07 20:13:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2022-11-07 20:13:58======================== select * from customers where id = 'antwin77' ========================2022-11-07 20:13:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2022-11-07 20:13:57','52500','55000','온라인','0')