========================2024-01-31 09:56:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-aria1635-1706662567 LGD_BUYER = 최상철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131095607 LGD_HASHDATA = f6bbbe34a4961c7c798cb69f4c643220 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 = 202401311001263E42234FC99352F17C44E07D31D86239860C2FFA Mname = 최상철 Mcompany = 주식회사 아리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = aria1635 LGD_ESCROW_USEYN = N ========================2024-01-31 09:56:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131100126 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****489* LGD_FINANCEAUTHNUM = 36117105 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 91641b87fd5b46e9d6ee9bb3bb8f5001 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240131100127 LGD_PCANCELSTR = 0 LGD_BUYER = 최상철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131100126Q57o8 LGD_BUYERID = LGD_OID = Direct-aria1635-1706662567 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 09:56:55======================== insert into mBoard_order set rOrdNo = 'Direct-aria1635-1706662567', AuthTy = 'card', memberId = 'aria1635', OrdNm ='최상철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 아리아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****489*', rApprNo = 'mjsof20240131100126Q57o8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 09:56:55', InvoiceNum = '결제성공:Direct-aria1635-1706662567/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 09:56:55' ========================2024-01-31 09:56:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131100126Q57o8' 0 = 1 cnt = 1 ========================2024-01-31 09:56:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'aria1635' 0 = aria1635 Mid = aria1635 1 = 주식회사 아리아 Mcompany = 주식회사 아리아 2 = 8808600526 companyNum = 8808600526 3 = 031-764-8822 Mtel1 = 031-764-8822 4 = 010-3428-6749 Mhp = 010-3428-6749 ========================2024-01-31 09:56:55======================== select * from customers where id = 'aria1635' ========================2024-01-31 09:56:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('aria1635','2024-01-31 09:56:55','52500','55000','온라인','0') ========================2024-01-31 11:52:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakingjeju-1706669381 LGD_BUYER = 박동춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131114941 LGD_HASHDATA = 06419fa6df9777fdef81c01c5e827e01 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 = 20240131115703E584834C0A78DFDC5550E97D1B4F8432D47D3A31 Mname = 박동춘 Mcompany = 주식회사 베이킹제주 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bakingjeju LGD_ESCROW_USEYN = N ========================2024-01-31 11:52:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131115704 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756451 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41980310****194* LGD_FINANCEAUTHNUM = 63159543 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 90aeb74231bead910012836b84c53c77 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240131115705 LGD_PCANCELSTR = 0 LGD_BUYER = 박동춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131115704N7WA0 LGD_BUYERID = LGD_OID = Direct-bakingjeju-1706669381 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1115704N4HQ4 ========================2024-01-31 11:52:33======================== insert into mBoard_order set rOrdNo = 'Direct-bakingjeju-1706669381', AuthTy = 'card', memberId = 'bakingjeju', OrdNm ='박동춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 베이킹제주', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41980310****194*', rApprNo = 'mjsof20240131115704N7WA0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 11:52:33', InvoiceNum = '결제성공:Direct-bakingjeju-1706669381/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 11:52:33' ========================2024-01-31 11:52:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131115704N7WA0' 0 = 1 cnt = 1 ========================2024-01-31 11:52:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakingjeju' 0 = bakingjeju Mid = bakingjeju 1 = 주식회사 베이킹제주 Mcompany = 주식회사 베이킹제주 2 = 5488800984 companyNum = 5488800984 3 = 010-4467-8900 Mtel1 = 010-4467-8900 4 = 010-4467-8900 Mhp = 010-4467-8900 ========================2024-01-31 11:52:33======================== select * from customers where id = 'bakingjeju' ========================2024-01-31 11:52:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakingjeju','2024-01-31 11:52:33','108000','110000','온라인','0') ========================2024-01-31 12:40:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1706672324 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131123844 LGD_HASHDATA = 273368878acc83bcd6e54833ac950153 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 = 20240131124501B45556129276085D2D295DDE4FC8815098DA0C35 Mname = 박현석 Mcompany = 마니푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = anbinnakdo LGD_ESCROW_USEYN = N ========================2024-01-31 12:40:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131124502 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = phso519@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797394****508* LGD_FINANCEAUTHNUM = 30037862 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d592907a7f36348473869fe3040ec6ce LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240131124502 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131124502NbSM0 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1706672324 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 12:40:30======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1706672324', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797394****508*', rApprNo = 'mjsof20240131124502NbSM0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 12:40:30', InvoiceNum = '결제성공:Direct-anbinnakdo-1706672324/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 12:40:30' ========================2024-01-31 12:40:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131124502NbSM0' 0 = 1 cnt = 1 ========================2024-01-31 12:40:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'anbinnakdo' 0 = anbinnakdo Mid = anbinnakdo 1 = 마니푸드 Mcompany = 마니푸드 2 = 121-20-60884 companyNum = 121-20-60884 3 = 070-4082-2105 Mtel1 = 070-4082-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2024-01-31 12:40:30======================== select * from customers where id = 'anbinnakdo' ========================2024-01-31 12:40:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2024-01-31 12:40:30','52500','55000','온라인','0') ========================2024-01-31 13:13:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kdb457384-1706674385 LGD_BUYER = 김대범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131131305 LGD_HASHDATA = a249096f8f6a46d7fa962af9d3d5e4d5 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 = 2024013113182954F079279A66944BDAFEDA5FAE81055FA6E0E322 Mname = 김대범 Mcompany = 강산씨앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kdb457384 LGD_ESCROW_USEYN = N ========================2024-01-31 13:13:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131131830 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****882* LGD_FINANCEAUTHNUM = 30060853 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 282ac5a1344e62774356816238bea854 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240131131830 LGD_PCANCELSTR = 0 LGD_BUYER = 김대범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131131830zr7E2 LGD_BUYERID = LGD_OID = Direct-kdb457384-1706674385 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1131830zIiZ3 ========================2024-01-31 13:13:58======================== insert into mBoard_order set rOrdNo = 'Direct-kdb457384-1706674385', AuthTy = 'card', memberId = 'kdb457384', OrdNm ='김대범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강산씨앤티', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****882*', rApprNo = 'mjsof20240131131830zr7E2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 13:13:58', InvoiceNum = '결제성공:Direct-kdb457384-1706674385/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 13:13:58' ========================2024-01-31 13:13:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131131830zr7E2' 0 = 1 cnt = 1 ========================2024-01-31 13:13:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kdb457384' 0 = kdb457384 Mid = kdb457384 1 = 강산씨앤티 Mcompany = 강산씨앤티 2 = 1643000581 companyNum = 1643000581 3 = 010-9777-8005 Mtel1 = 010-9777-8005 4 = 010-8934-8428 Mhp = 010-8934-8428 ========================2024-01-31 13:13:58======================== select * from customers where id = 'kdb457384' ========================2024-01-31 13:13:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kdb457384','2024-01-31 13:13:58','30900','33000','온라인','0') ========================2024-01-31 13:33:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kofas68-1706675502 LGD_BUYER = 김윤희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131133142 LGD_HASHDATA = 15a0c02ca3c43ed4cba615f91720919f 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 = 2024013113375507AA6BE2A32C55695F567CF902B3D86CD7E244C3 Mname = 김윤희 Mcompany = 코파스주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kofas68 LGD_ESCROW_USEYN = N ========================2024-01-31 13:33:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131133756 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 = 55318078****184* LGD_FINANCEAUTHNUM = 75020865 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0ee3a4a1bf899b9213ed8aa9437de534 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240131133756 LGD_PCANCELSTR = 0 LGD_BUYER = 김윤희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131133756F7yo0 LGD_BUYERID = LGD_OID = Direct-kofas68-1706675502 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 13:33:24======================== insert into mBoard_order set rOrdNo = 'Direct-kofas68-1706675502', AuthTy = 'card', memberId = 'kofas68', OrdNm ='김윤희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '코파스주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH MASTER 55318078****184*', rApprNo = 'mjsof20240131133756F7yo0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 13:33:24', InvoiceNum = '결제성공:Direct-kofas68-1706675502/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 13:33:24' ========================2024-01-31 13:33:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131133756F7yo0' 0 = 1 cnt = 1 ========================2024-01-31 13:33:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kofas68' 0 = kofas68 Mid = kofas68 1 = 코파스주식회사 Mcompany = 코파스주식회사 2 = 819-86-00688 companyNum = 819-86-00688 3 = 041-541-6822 Mtel1 = 041-541-6822 4 = 010-8752-6823 Mhp = 010-8752-6823 ========================2024-01-31 13:33:24======================== select * from customers where id = 'kofas68' ========================2024-01-31 13:33:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kofas68','2024-01-31 13:33:24','10000','11000','온라인','0') ========================2024-01-31 13:48:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1706676447 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131134727 LGD_HASHDATA = 769a83925536befaee94a2fc17ccdb54 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 = 20240131135250923865F4086D29FF3B6398B2528AAB0BA251802C Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2024-01-31 13:48:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131135250 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353104****161* LGD_FINANCEAUTHNUM = 27272196 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 55c4d4060a4a08a9f38531567aad9218 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240131135251 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240131135250VPWR3 LGD_BUYERID = LGD_OID = Direct-kyg2031-1706676447 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 311352622109 ========================2024-01-31 13:48:18======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1706676447', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353104****161*', rApprNo = 'mjsof20240131135250VPWR3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 13:48:18', InvoiceNum = '결제성공:Direct-kyg2031-1706676447/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 13:48:18' ========================2024-01-31 13:48:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131135250VPWR3' 0 = 1 cnt = 1 ========================2024-01-31 13:48:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-6796-1030 Mhp = 010-6796-1030 ========================2024-01-31 13:48:19======================== select * from customers where id = 'kyg2031' ========================2024-01-31 13:48:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2024-01-31 13:48:18','52500','55000','온라인','0') ========================2024-01-31 14:14:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kofas68-1706677623 LGD_BUYER = 윤호현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131140703 LGD_HASHDATA = 6f4bd2ffe325d644ed72b675c84dde36 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 = 20240131141919010A3A705E7F749DE0D72886FB0FC0F82E26139C Mname = 윤호현 Mcompany = 코파스주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kofas68 LGD_ESCROW_USEYN = N ========================2024-01-31 14:14:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131141919 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 = 55318073****292* LGD_FINANCEAUTHNUM = 75479589 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4cd01e159e37658165380d990a1498b6 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240131141920 LGD_PCANCELSTR = 0 LGD_BUYER = 윤호현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131141919T64e6 LGD_BUYERID = LGD_OID = Direct-kofas68-1706677623 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 14:14:48======================== insert into mBoard_order set rOrdNo = 'Direct-kofas68-1706677623', AuthTy = 'card', memberId = 'kofas68', OrdNm ='윤호현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '코파스주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH MASTER 55318073****292*', rApprNo = 'mjsof20240131141919T64e6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 14:14:48', InvoiceNum = '결제성공:Direct-kofas68-1706677623/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 14:14:48' ========================2024-01-31 14:14:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131141919T64e6' 0 = 1 cnt = 1 ========================2024-01-31 14:14:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kofas68' 0 = kofas68 Mid = kofas68 1 = 코파스주식회사 Mcompany = 코파스주식회사 2 = 819-86-00688 companyNum = 819-86-00688 3 = 041-541-6822 Mtel1 = 041-541-6822 4 = 010-8752-6823 Mhp = 010-8752-6823 ========================2024-01-31 14:14:48======================== select * from customers where id = 'kofas68' ========================2024-01-31 14:14:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kofas68','2024-01-31 14:14:48','108000','110000','온라인','0') ========================2024-01-31 15:36:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-partystory3-1706682884 LGD_BUYER = 정기영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131153444 LGD_HASHDATA = 2c68728efe8bddb1ccc3129d5eb8ddd6 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 = 20240131154107DE32635E6E4E35DBF3D062BDA1A0D0E320090438 Mname = 정기영 Mcompany = 파티스토리 다산점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = partystory3 LGD_ESCROW_USEYN = N ========================2024-01-31 15:36:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131154107 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37029925****50* LGD_FINANCEAUTHNUM = 00107437 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 44dedc25dfe298dfc5753e8e1ad2e841 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240131154108 LGD_PCANCELSTR = 0 LGD_BUYER = 정기영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131154107JQ8l5 LGD_BUYERID = LGD_OID = Direct-partystory3-1706682884 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 15:36:35======================== insert into mBoard_order set rOrdNo = 'Direct-partystory3-1706682884', AuthTy = 'card', memberId = 'partystory3', OrdNm ='정기영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '파티스토리 다산점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대AMEX 37029925****50*', rApprNo = 'mjsof20240131154107JQ8l5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 15:36:35', InvoiceNum = '결제성공:Direct-partystory3-1706682884/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 15:36:35' ========================2024-01-31 15:36:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131154107JQ8l5' 0 = 1 cnt = 1 ========================2024-01-31 15:36:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'partystory3' 0 = partystory3 Mid = partystory3 1 = 파티스토리 다산점 Mcompany = 파티스토리 다산점 2 = 652-11-02765 companyNum = 652-11-02765 3 = 010-4521-8641 Mtel1 = 010-4521-8641 4 = 010-4521-8641 Mhp = 010-4521-8641 ========================2024-01-31 15:36:36======================== select * from customers where id = 'partystory3' ========================2024-01-31 15:36:36======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('partystory3','파티스토리 다산점','6521102765','010-4521-8641','010-4521-8641','2024-01-31 15:36:35','온라인') ========================2024-01-31 15:36:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('partystory3','2024-01-31 15:36:35','52500','55000','온라인','0') ========================2024-01-31 16:57:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimhando-1706687569 LGD_BUYER = 김한도 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240131165249 LGD_HASHDATA = f7958bcb7cb6560cce29293a639cf9fb 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 = 202401311702114D61A977D150DD74C5AD8F71761465C8CCBDC826 Mname = 김한도 Mcompany = 주식회사 종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kimhando LGD_ESCROW_USEYN = N ========================2024-01-31 16:57:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240131170212 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = daehanmobil1@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 = 55317204****255* LGD_FINANCEAUTHNUM = 40334735 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ef7101d1d29ba3f9f03fdbf75084040e LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240131170212 LGD_PCANCELSTR = 0 LGD_BUYER = 김한도 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240131170211VaEm2 LGD_BUYERID = LGD_OID = Direct-kimhando-1706687569 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-01-31 16:57:40======================== insert into mBoard_order set rOrdNo = 'Direct-kimhando-1706687569', AuthTy = 'card', memberId = 'kimhando', OrdNm ='김한도', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH MASTER 55317204****255*', rApprNo = 'mjsof20240131170211VaEm2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-01-31 16:57:40', InvoiceNum = '결제성공:Direct-kimhando-1706687569/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-01-31 16:57:40' ========================2024-01-31 16:57:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240131170211VaEm2' 0 = 1 cnt = 1 ========================2024-01-31 16:57:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimhando' 0 = kimhando Mid = kimhando 1 = 주식회사 종합유통 Mcompany = 주식회사 종합유통 2 = 3648100688 companyNum = 3648100688 3 = 044-553-9203 Mtel1 = 044-553-9203 4 = 010-8774-8951 Mhp = 010-8774-8951 ========================2024-01-31 16:57:40======================== select * from customers where id = 'kimhando' ========================2024-01-31 16:57:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimhando','2024-01-31 16:57:40','108000','110000','온라인','0')