========================2025-03-31 10:22:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1743383934 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331101854 LGD_HASHDATA = 4386de1c5e116be16188eb83bd36a78c 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 = 202503311024434AE55F34E073614198E34DE33D15E6A534D3A38F Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2025-03-31 10:22:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331102444 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods01@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 = 55852695****280* LGD_FINANCEAUTHNUM = 30029772 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 29f35d8cc4bb8e711e4573cfd0aabf80 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331102445 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331102444Z0k77 LGD_BUYERID = LGD_OID = Direct-azfoods01-1743383934 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1102444ZjwA6 ========================2025-03-31 10:22:14======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1743383934', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****280*', rApprNo = 'mjsof20250331102444Z0k77', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 10:22:14', InvoiceNum = '결제성공:Direct-azfoods01-1743383934/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 10:22:14' ========================2025-03-31 10:22:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331102444Z0k77' 0 = 1 cnt = 1 ========================2025-03-31 10:22:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2025-03-31 10:22:14======================== select * from customers where id = 'azfoods01' ========================2025-03-31 10:22:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2025-03-31 10:22:14','108000','110000','온라인','0') ========================2025-03-31 10:45:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kin1914-1743385403 LGD_BUYER = 김민찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331104323 LGD_HASHDATA = e8e1dced97ef09315378dc8bccd1dadb 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 = 202503311048290BD332BA37DB41574EDF1E1CEDD5E0F2B19359A5 Mname = 김민찬 Mcompany = 새한전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kin1914 LGD_ESCROW_USEYN = N ========================2025-03-31 10:46:00======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20250331104831 LGD_BUYEREMAIL = kin1913@gmail.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 = receiptSelf = N LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = b9ef6dbeb7e8216a163a2441a574f549 LGD_BUYERADDRESS = receiptKind = 1 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250331104831 LGD_PCANCELSTR = 0 LGD_BUYER = 김민찬 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250331104807mjEN9 LGD_BUYERID = LGD_OID = Direct-kin1914-1743385403 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 10:46:00======================== insert into mBoard_order set rOrdNo = 'Direct-kin1914-1743385403', AuthTy = 'card', memberId = 'kin1914', OrdNm ='김민찬', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새한전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20250331104807mjEN9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 10:46:00', InvoiceNum = '결제성공:Direct-kin1914-1743385403/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 10:46:00' ========================2025-03-31 10:46:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331104807mjEN9' 0 = 1 cnt = 1 ========================2025-03-31 10:46:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kin1914' 0 = kin1914 Mid = kin1914 1 = 새한전기 Mcompany = 새한전기 2 = 607-15-73875 companyNum = 607-15-73875 3 = 051-621-5589 Mtel1 = 051-621-5589 4 = 010-3813-9119 Mhp = 010-3813-9119 ========================2025-03-31 10:46:00======================== select * from customers where id = 'kin1914' ========================2025-03-31 10:46:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kin1914','2025-03-31 10:46:00','108000','110000','온라인','0') ========================2025-03-31 10:48:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kin1913-1743385673 LGD_BUYER = 김진곤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331104753 LGD_HASHDATA = 569151e453cebe3be591883518b2b663 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 = 20250331105125B9CC42EE8291B433DEC1CAC01C39EC15CE164750 Mname = 김진곤 Mcompany = 새한계기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kin1913 LGD_ESCROW_USEYN = N ========================2025-03-31 10:48:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331105125 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kin1913@gmail.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 243647 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49022082****128* LGD_FINANCEAUTHNUM = 55366693 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7239787a013997561f5345c6db533299 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250331105126 LGD_PCANCELSTR = 0 LGD_BUYER = 김진곤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311051253hHG6 LGD_BUYERID = LGD_OID = Direct-kin1913-1743385673 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11051253Bug4 ========================2025-03-31 10:48:55======================== insert into mBoard_order set rOrdNo = 'Direct-kin1913-1743385673', AuthTy = 'card', memberId = 'kin1913', OrdNm ='김진곤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새한계기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 49022082****128*', rApprNo = 'mjsof202503311051253hHG6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 10:48:55', InvoiceNum = '결제성공:Direct-kin1913-1743385673/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 10:48:55' ========================2025-03-31 10:48:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311051253hHG6' 0 = 1 cnt = 1 ========================2025-03-31 10:48:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kin1913' 0 = kin1913 Mid = kin1913 1 = 새한계기 Mcompany = 새한계기 2 = 607-61-60192 companyNum = 607-61-60192 3 = 051-621-5589 Mtel1 = 051-621-5589 4 = 010-3813-9119 Mhp = 010-3813-9119 ========================2025-03-31 10:48:55======================== select * from customers where id = 'kin1913' ========================2025-03-31 10:48:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kin1913','2025-03-31 10:48:55','220000','220000','온라인','0') ========================2025-03-31 12:29:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-worldoffice-1743391705 LGD_BUYER = 강미정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331122825 LGD_HASHDATA = 50dee20784dafa2e817adce4c92e9557 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 = 2025033112323097D5C5B80426351BFBB323E69242D4BC67398B40 Mname = 강미정 Mcompany = 주식회사 월드오피스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = worldoffice LGD_ESCROW_USEYN = N ========================2025-03-31 12:30:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331123231 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91003200****606* LGD_FINANCEAUTHNUM = 55982573 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8bcd9eaaece0da5dc14f40f61c19582a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250331123231 LGD_PCANCELSTR = 0 LGD_BUYER = 강미정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311232318OU13 LGD_BUYERID = LGD_OID = Direct-worldoffice-1743391705 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11232318EoF9 ========================2025-03-31 12:30:00======================== insert into mBoard_order set rOrdNo = 'Direct-worldoffice-1743391705', AuthTy = 'card', memberId = 'worldoffice', OrdNm ='강미정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 월드오피스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 91003200****606*', rApprNo = 'mjsof202503311232318OU13', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 12:30:00', InvoiceNum = '결제성공:Direct-worldoffice-1743391705/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 12:30:00' ========================2025-03-31 12:30:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311232318OU13' 0 = 1 cnt = 1 ========================2025-03-31 12:30:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'worldoffice' 0 = worldoffice Mid = worldoffice 1 = 주식회사 월드오피스 Mcompany = 주식회사 월드오피스 2 = 705-88-03060 companyNum = 705-88-03060 3 = 010-3813-7268 Mtel1 = 010-3813-7268 4 = 010-3813-7268 Mhp = 010-3813-7268 ========================2025-03-31 12:30:00======================== select * from customers where id = 'worldoffice' ========================2025-03-31 12:30:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('worldoffice','2025-03-31 12:30:00','108000','110000','온라인','0') ========================2025-03-31 12:54:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1743393206 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331125326 LGD_HASHDATA = 75ef919cc251b0315ff53fef072707a6 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 = 20250331125703E7C73C64726914D0A121E7ACBC7C4757912C2E85 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 ========================2025-03-31 12:54:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331125703 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = phso519@nanver.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 = 45797370****903* LGD_FINANCEAUTHNUM = 30043926 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e6b8002e2a7585978b92671e98d0ecd0 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331125704 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311257036UxH3 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1743393206 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 12:54:33======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1743393206', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797370****903*', rApprNo = 'mjsof202503311257036UxH3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 12:54:33', InvoiceNum = '결제성공:Direct-anbinnakdo-1743393206/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 12:54:33' ========================2025-03-31 12:54:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311257036UxH3' 0 = 1 cnt = 1 ========================2025-03-31 12:54:33======================== 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 ========================2025-03-31 12:54:33======================== select * from customers where id = 'anbinnakdo' ========================2025-03-31 12:54:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2025-03-31 12:54:33','52500','55000','온라인','0') ========================2025-03-31 13:57:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tonystark-1743396932 LGD_BUYER = 김선정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331135532 LGD_HASHDATA = 8242c364bf45974473db459179686c3b 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 = 20250331135943E6F2F80A200FBA0980E5F8067F19B4B1B65F4751 Mname = 김선정 Mcompany = 티엠에스컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tonystark LGD_ESCROW_USEYN = N ========================2025-03-31 13:57:14======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20250331135945 LGD_BUYEREMAIL = pksj74@daum.net 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 = LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 5d76248d7d281001cb3667d99312c120 LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250331135945 LGD_PCANCELSTR = 0 LGD_BUYER = 김선정 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250331135911mkD24 LGD_BUYERID = LGD_OID = Direct-tonystark-1743396932 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 13:57:14======================== insert into mBoard_order set rOrdNo = 'Direct-tonystark-1743396932', AuthTy = 'card', memberId = 'tonystark', OrdNm ='김선정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '티엠에스컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20250331135911mkD24', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 13:57:14', InvoiceNum = '결제성공:Direct-tonystark-1743396932/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 13:57:14' ========================2025-03-31 13:57:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331135911mkD24' 0 = 1 cnt = 1 ========================2025-03-31 13:57:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tonystark' 0 = tonystark Mid = tonystark 1 = 티엠에스컴퍼니 Mcompany = 티엠에스컴퍼니 2 = 818-04-03065 companyNum = 818-04-03065 3 = 010-3494-3868 Mtel1 = 010-3494-3868 4 = 010-3033-3868 Mhp = 010-3033-3868 ========================2025-03-31 13:57:14======================== select * from customers where id = 'tonystark' ========================2025-03-31 13:57:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tonystark','2025-03-31 13:57:14','30900','33000','온라인','0') ========================2025-03-31 15:52:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sw9376-1743403880 LGD_BUYER = 고승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331155120 LGD_HASHDATA = c48a505a5c4f3c5ba77d232551280c38 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 = 2025033115543432C057FFBB965E497D88032AEE19F5EB263648A1 Mname = 고승환 Mcompany = 주식회사 신우 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sw9376 LGD_ESCROW_USEYN = N ========================2025-03-31 15:52:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331155435 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****994* LGD_FINANCEAUTHNUM = 59735877 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a238b4fbbd05864a403a0b3a770b7874 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250331155435 LGD_PCANCELSTR = 0 LGD_BUYER = 고승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331155434969a2 LGD_BUYERID = LGD_OID = Direct-sw9376-1743403880 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11554349bCH3 ========================2025-03-31 15:52:04======================== insert into mBoard_order set rOrdNo = 'Direct-sw9376-1743403880', AuthTy = 'card', memberId = 'sw9376', OrdNm ='고승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 신우', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****994*', rApprNo = 'mjsof20250331155434969a2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 15:52:04', InvoiceNum = '결제성공:Direct-sw9376-1743403880/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 15:52:04' ========================2025-03-31 15:52:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331155434969a2' 0 = 1 cnt = 1 ========================2025-03-31 15:52:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sw9376' 0 = sw9376 Mid = sw9376 1 = 주식회사 신우 Mcompany = 주식회사 신우 2 = 125-81-89093 companyNum = 125-81-89093 3 = 031-611-1000 Mtel1 = 031-611-1000 4 = 010-2540-5599 Mhp = 010-2540-5599 ========================2025-03-31 15:52:04======================== select * from customers where id = 'sw9376' ========================2025-03-31 15:52:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sw9376','2025-03-31 15:52:04','220000','220000','온라인','0') ========================2025-03-31 15:59:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-moonn-1743403320 LGD_BUYER = 문프룻 농업회사법인(주) LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331154200 LGD_HASHDATA = 902233e20732120ebc57b4c96dfb815e 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 = 20250331160222C06C8EE62400065E01C49DA0FB88906C384C70EE Mname = 문프룻 농업회사법인(주) Mcompany = 문프룻 농업회사법인(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = moonn LGD_ESCROW_USEYN = N ========================2025-03-31 15:59:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331160223 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****888* LGD_FINANCEAUTHNUM = 30030475 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f6897d4c50bc06f2511887efeeee2ee3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331160223 LGD_PCANCELSTR = 0 LGD_BUYER = 문프룻 농업회사법인(주) LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311602233Ml59 LGD_BUYERID = LGD_OID = Direct-moonn-1743403320 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11602233OtY8 ========================2025-03-31 15:59:52======================== insert into mBoard_order set rOrdNo = 'Direct-moonn-1743403320', AuthTy = 'card', memberId = 'moonn', OrdNm ='문프룻 농업회사법인(주)', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '문프룻 농업회사법인(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****888*', rApprNo = 'mjsof202503311602233Ml59', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 15:59:52', InvoiceNum = '결제성공:Direct-moonn-1743403320/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 15:59:52' ========================2025-03-31 15:59:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311602233Ml59' 0 = 1 cnt = 1 ========================2025-03-31 15:59:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'moonn' 0 = moonn Mid = moonn 1 = 문프룻 농업회사법인(주) Mcompany = 문프룻 농업회사법인(주) 2 = 161-86-02777 companyNum = 161-86-02777 3 = 010-6347-2454 Mtel1 = 010-6347-2454 4 = 010-6347-2454 Mhp = 010-6347-2454 ========================2025-03-31 15:59:52======================== select * from customers where id = 'moonn' ========================2025-03-31 15:59:52======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('moonn','문프룻 농업회사법인(주)','1618602777','010-6347-2454','010-6347-2454','2025-03-31 15:59:52','온라인') ========================2025-03-31 15:59:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('moonn','2025-03-31 15:59:52','10000','11000','온라인','0') ========================2025-03-31 16:02:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-moons-1743404421 LGD_BUYER = 문프룻스피릿츠엘티디 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331160021 LGD_HASHDATA = 88a1f559fb4e86da772499f95b40626c 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 = 202503311604452DFE999F07E107C65D0E5C678A32F0A374C1938C Mname = 문프룻스피릿츠엘티디 Mcompany = 문프룻스피릿츠엘티디(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = moons LGD_ESCROW_USEYN = N ========================2025-03-31 16:02:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331160446 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****888* LGD_FINANCEAUTHNUM = 30030486 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ba7cebe385ab479d81e0d71ea2dcf268 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331160446 LGD_PCANCELSTR = 0 LGD_BUYER = 문프룻스피릿츠엘티디 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331160446br7E2 LGD_BUYERID = LGD_OID = Direct-moons-1743404421 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1160446bLXf1 ========================2025-03-31 16:02:15======================== insert into mBoard_order set rOrdNo = 'Direct-moons-1743404421', AuthTy = 'card', memberId = 'moons', OrdNm ='문프룻스피릿츠엘티디', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '문프룻스피릿츠엘티디(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****888*', rApprNo = 'mjsof20250331160446br7E2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 16:02:15', InvoiceNum = '결제성공:Direct-moons-1743404421/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 16:02:15' ========================2025-03-31 16:02:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331160446br7E2' 0 = 1 cnt = 1 ========================2025-03-31 16:02:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'moons' 0 = moons Mid = moons 1 = 문프룻스피릿츠엘티디(주) Mcompany = 문프룻스피릿츠엘티디(주) 2 = 211-88-57867 companyNum = 211-88-57867 3 = 010-6347-2454 Mtel1 = 010-6347-2454 4 = 010-6347-2454 Mhp = 010-6347-2454 ========================2025-03-31 16:02:15======================== select * from customers where id = 'moons' ========================2025-03-31 16:02:15======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('moons','문프룻스피릿츠엘티디(주)','2118857867','010-6347-2454','010-6347-2454','2025-03-31 16:02:15','온라인') ========================2025-03-31 16:02:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('moons','2025-03-31 16:02:15','10000','11000','온라인','0') ========================2025-03-31 16:02:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo602r-1743404412 LGD_BUYER = 김재우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331160012 LGD_HASHDATA = 1b1c155562f6b2fb13ef15dd2a392cc3 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 = 202503311604474289B08E9DAF0488259F9A564D21F208053C5782 Mname = 김재우 Mcompany = 서울치즈울산동부가공고객센타 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = woo602r LGD_ESCROW_USEYN = N ========================2025-03-31 16:02:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331160448 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 = 54611120****500* LGD_FINANCEAUTHNUM = 42080723 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = dbb2d5dae0abc745a0a25ec417d7bbd2 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250331160449 LGD_PCANCELSTR = 0 LGD_BUYER = 김재우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311604476CEE2 LGD_BUYERID = LGD_OID = Direct-woo602r-1743404412 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 16:02:18======================== insert into mBoard_order set rOrdNo = 'Direct-woo602r-1743404412', AuthTy = 'card', memberId = 'woo602r', OrdNm ='김재우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서울치즈울산동부가공고객센타', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH MASTER 54611120****500*', rApprNo = 'mjsof202503311604476CEE2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 16:02:18', InvoiceNum = '결제성공:Direct-woo602r-1743404412/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 16:02:18' ========================2025-03-31 16:02:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311604476CEE2' 0 = 1 cnt = 1 ========================2025-03-31 16:02:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo602r' 0 = woo602r Mid = woo602r 1 = 서울치즈울산동부가공고객센타 Mcompany = 서울치즈울산동부가공고객센타 2 = 620-10-47661 companyNum = 620-10-47661 3 = 052-257-3287 Mtel1 = 052-257-3287 4 = 010-4057-3287 Mhp = 010-4057-3287 ========================2025-03-31 16:02:18======================== select * from customers where id = 'woo602r' ========================2025-03-31 16:02:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo602r','2025-03-31 16:02:18','10000','11000','온라인','0') ========================2025-03-31 16:04:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-moonb-1743404627 LGD_BUYER = 문프룻비버리지스엘티디 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331160347 LGD_HASHDATA = 5c84f89f10be10248328502ff10f0af5 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 = 20250331160646BC082EBFF878B872DA3655F7E947A33792D0930E Mname = 문프룻비버리지스엘티디 Mcompany = 문프룻비버리지스엘티디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = moonb LGD_ESCROW_USEYN = N ========================2025-03-31 16:04:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331160647 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****888* LGD_FINANCEAUTHNUM = 30030497 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 36aaae07e39ffd8c957e68ff456a68d5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331160647 LGD_PCANCELSTR = 0 LGD_BUYER = 문프룻비버리지스엘티디 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331160647brj39 LGD_BUYERID = LGD_OID = Direct-moonb-1743404627 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1160647bM2e0 ========================2025-03-31 16:04:16======================== insert into mBoard_order set rOrdNo = 'Direct-moonb-1743404627', AuthTy = 'card', memberId = 'moonb', OrdNm ='문프룻비버리지스엘티디', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '문프룻비버리지스엘티디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****888*', rApprNo = 'mjsof20250331160647brj39', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 16:04:16', InvoiceNum = '결제성공:Direct-moonb-1743404627/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 16:04:16' ========================2025-03-31 16:04:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331160647brj39' 0 = 1 cnt = 1 ========================2025-03-31 16:04:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'moonb' 0 = moonb Mid = moonb 1 = 문프룻비버리지스엘티디 Mcompany = 문프룻비버리지스엘티디 2 = 120-10-80651 companyNum = 120-10-80651 3 = 010-6347-2454 Mtel1 = 010-6347-2454 4 = 010-6347-2454 Mhp = 010-6347-2454 ========================2025-03-31 16:04:16======================== select * from customers where id = 'moonb' ========================2025-03-31 16:04:16======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('moonb','문프룻비버리지스엘티디','1201080651','010-6347-2454','010-6347-2454','2025-03-31 16:04:16','온라인') ========================2025-03-31 16:04:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('moonb','2025-03-31 16:04:16','10000','11000','온라인','0') ========================2025-03-31 17:05:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1743408300 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331170500 LGD_HASHDATA = 770a28ed1275a91537ccd2aaebc30299 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 = 20250331170824E2CBE16D2CAD11FD981319A2CBBCD25664FEDFEF Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2025-03-31 17:05:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331170824 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94512000****310* LGD_FINANCEAUTHNUM = 60306053 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3c70e45712ecbb5e9a24c9896a9c206b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250331170825 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311708246RRz3 LGD_BUYERID = LGD_OID = Direct-k114-1743408300 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11708246H9c2 ========================2025-03-31 17:05:53======================== insert into mBoard_order set rOrdNo = 'Direct-k114-1743408300', AuthTy = 'card', memberId = 'k114', OrdNm ='김상옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강원산업안전(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨 94512000****310*', rApprNo = 'mjsof202503311708246RRz3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 17:05:53', InvoiceNum = '결제성공:Direct-k114-1743408300/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 17:05:53' ========================2025-03-31 17:05:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311708246RRz3' 0 = 1 cnt = 1 ========================2025-03-31 17:05:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k114' 0 = k114 Mid = k114 1 = 강원산업안전(주) Mcompany = 강원산업안전(주) 2 = 2388100225 companyNum = 2388100225 3 = 033-732-3114 Mtel1 = 033-732-3114 4 = 010-5115-3114 Mhp = 010-5115-3114 ========================2025-03-31 17:05:53======================== select * from customers where id = 'k114' ========================2025-03-31 17:05:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k114','2025-03-31 17:05:53','220000','220000','온라인','0') ========================2025-03-31 17:17:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1743409008 LGD_BUYER = 강찬수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331171648 LGD_HASHDATA = 236b9dca11e3da902ac5af5c097b6751 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 = 20250331171949DDFD1771E7BB54BDF63286355DD7B333FCA3B7B3 Mname = 강찬수 Mcompany = (주)태양엠알오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sunmro LGD_ESCROW_USEYN = N ========================2025-03-31 17:17:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331171950 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 926871 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****198* LGD_FINANCEAUTHNUM = 60381936 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eb87d92922d728b899ffbe8626099fa3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250331171950 LGD_PCANCELSTR = 0 LGD_BUYER = 강찬수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331171949byqq4 LGD_BUYERID = LGD_OID = Direct-sunmro-1743409008 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1171949bP968 ========================2025-03-31 17:17:19======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1743409008', AuthTy = 'card', memberId = 'sunmro', OrdNm ='강찬수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태양엠알오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****198*', rApprNo = 'mjsof20250331171949byqq4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 17:17:19', InvoiceNum = '결제성공:Direct-sunmro-1743409008/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 17:17:19' ========================2025-03-31 17:17:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331171949byqq4' 0 = 1 cnt = 1 ========================2025-03-31 17:17:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sunmro' 0 = sunmro Mid = sunmro 1 = (주)태양엠알오 Mcompany = (주)태양엠알오 2 = 262-81-00306 companyNum = 262-81-00306 3 = 02-1899-0942 Mtel1 = 02-1899-0942 4 = 010-5482-0951 Mhp = 010-5482-0951 ========================2025-03-31 17:17:19======================== select * from customers where id = 'sunmro' ========================2025-03-31 17:17:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2025-03-31 17:17:19','220000','220000','온라인','0') ========================2025-03-31 17:19:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-naeson9-1743409133 LGD_BUYER = 김정희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331171853 LGD_HASHDATA = a62ace5bb7d0e55e413b63dbd75124de 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 = 202503311722268910FD3BE51FD6FFBD909B48098380B8CB04CAB0 Mname = 김정희 Mcompany = 주식회사 내손 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = naeson9 LGD_ESCROW_USEYN = N ========================2025-03-31 17:19:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331172227 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****584* LGD_FINANCEAUTHNUM = 30061252 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3845ce258b3d66a6595e08c1b1a1aabd LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250331172227 LGD_PCANCELSTR = 0 LGD_BUYER = 김정희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250331172227byGX9 LGD_BUYERID = LGD_OID = Direct-naeson9-1743409133 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1172227bPfQ6 ========================2025-03-31 17:19:56======================== insert into mBoard_order set rOrdNo = 'Direct-naeson9-1743409133', AuthTy = 'card', memberId = 'naeson9', OrdNm ='김정희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 내손', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****584*', rApprNo = 'mjsof20250331172227byGX9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 17:19:56', InvoiceNum = '결제성공:Direct-naeson9-1743409133/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 17:19:56' ========================2025-03-31 17:19:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250331172227byGX9' 0 = 1 cnt = 1 ========================2025-03-31 17:19:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'naeson9' 0 = naeson9 Mid = naeson9 1 = 주식회사 내손 Mcompany = 주식회사 내손 2 = companyNum = 3 = 031-462-0944 Mtel1 = 031-462-0944 4 = 010-2229-0959 Mhp = 010-2229-0959 ========================2025-03-31 17:19:56======================== select * from customers where id = 'naeson9' ========================2025-03-31 17:19:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('naeson9','2025-03-31 17:19:56','220000','220000','온라인','0') ========================2025-03-31 17:27:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cschem2010-1743409503 LGD_BUYER = 안준식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331172503 LGD_HASHDATA = 75bc084081431fb51678bce8101a1701 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 = 20250331173001C9EA588DE65E4810072110CDEDA2E33BBA2630D1 Mname = 안준식 Mcompany = (주)블루마운트 테크놀러지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = cschem2010 LGD_ESCROW_USEYN = N ========================2025-03-31 17:27:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331173002 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 = 55888100****934* LGD_FINANCEAUTHNUM = 12863704 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 020467c3d2f94ec7fd0c746ae8c7d1c2 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250331173003 LGD_PCANCELSTR = 0 LGD_BUYER = 안준식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2025033117300288fj1 LGD_BUYERID = LGD_OID = Direct-cschem2010-1743409503 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 17:27:32======================== insert into mBoard_order set rOrdNo = 'Direct-cschem2010-1743409503', AuthTy = 'card', memberId = 'cschem2010', OrdNm ='안준식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루마운트 테크놀러지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '하나MASTER 55888100****934*', rApprNo = 'mjsof2025033117300288fj1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 17:27:32', InvoiceNum = '결제성공:Direct-cschem2010-1743409503/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 17:27:32' ========================2025-03-31 17:27:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025033117300288fj1' 0 = 1 cnt = 1 ========================2025-03-31 17:27:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cschem2010' 0 = cschem2010 Mid = cschem2010 1 = (주)블루마운트 테크놀러지 Mcompany = (주)블루마운트 테크놀러지 2 = 3028101578 companyNum = 3028101578 3 = 043-733-0055 Mtel1 = 043-733-0055 4 = 010-5920-0916 Mhp = 010-5920-0916 ========================2025-03-31 17:27:32======================== select * from customers where id = 'cschem2010' ========================2025-03-31 17:27:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cschem2010','2025-03-31 17:27:32','108000','110000','온라인','0') ========================2025-03-31 18:11:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1743412247 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331181047 LGD_HASHDATA = 0a1713b1b38b63fe0db4465e4a79db9f 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 = 20250331181428DB215B10E4E755091145A97F3C30E9268772A097 Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2025-03-31 18:11:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331181428 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 = 37029923****53* LGD_FINANCEAUTHNUM = 00612154 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e99957a4d9b6de666e83f8344edb1353 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250331181429 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503311814289jA31 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1743412247 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 18:11:57======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1743412247', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029923****53*', rApprNo = 'mjsof202503311814289jA31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 18:11:57', InvoiceNum = '결제성공:Direct-ksm03172002-1743412247/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 18:11:57' ========================2025-03-31 18:11:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503311814289jA31' 0 = 1 cnt = 1 ========================2025-03-31 18:11:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2025-03-31 18:11:58======================== select * from customers where id = 'ksm03172002' ========================2025-03-31 18:11:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2025-03-31 18:11:57','30900','33000','온라인','0') ========================2025-03-31 21:00:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksb7925-1743422327 LGD_BUYER = 고성배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331205847 LGD_HASHDATA = 516dbecd7ae9de2cf5822f5ba8e89abb 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 = 20250331210256C48D61FFBFA148922F500969701B45884F7DAA9A Mname = 고성배 Mcompany = (주)디앤유 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ksb7925 LGD_ESCROW_USEYN = N ========================2025-03-31 21:00:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331210257 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 = 37922040****02* LGD_FINANCEAUTHNUM = 57393672 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c589b5cf019c728203bf92e9c0b04be3 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20250331210258 LGD_PCANCELSTR = 0 LGD_BUYER = 고성배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503312102577YhU0 LGD_BUYERID = LGD_OID = Direct-ksb7925-1743422327 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 21:00:26======================== insert into mBoard_order set rOrdNo = 'Direct-ksb7925-1743422327', AuthTy = 'card', memberId = 'ksb7925', OrdNm ='고성배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디앤유', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데AMEX 37922040****02*', rApprNo = 'mjsof202503312102577YhU0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 21:00:26', InvoiceNum = '결제성공:Direct-ksb7925-1743422327/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 21:00:26' ========================2025-03-31 21:00:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503312102577YhU0' 0 = 1 cnt = 1 ========================2025-03-31 21:00:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksb7925' 0 = ksb7925 Mid = ksb7925 1 = (주)디앤유 Mcompany = (주)디앤유 2 = 6178614271 companyNum = 6178614271 3 = 010-4782-0770 Mtel1 = 010-4782-0770 4 = 010-4782-0770 Mhp = 010-4782-0770 ========================2025-03-31 21:00:26======================== select * from customers where id = 'ksb7925' ========================2025-03-31 21:00:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksb7925','2025-03-31 21:00:26','220000','220000','온라인','0') ========================2025-03-31 21:21:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1743423643 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250331212043 LGD_HASHDATA = b8e615b0cf6e269779ff2da6dd3acf93 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 = 202503312124115CD9212FFF87DDF8D9A9A912EDB0E26BD527CAFA Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2025-03-31 21:21:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250331212411 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 = 40493380****762* LGD_FINANCEAUTHNUM = 00744428 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 528a4844d1ad73253ab421f84e56dfa7 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250331212411 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503312124119B122 LGD_BUYERID = LGD_OID = Direct-we32-1743423643 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-31 21:21:40======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1743423643', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 40493380****762*', rApprNo = 'mjsof202503312124119B122', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-31 21:21:40', InvoiceNum = '결제성공:Direct-we32-1743423643/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-31 21:21:40' ========================2025-03-31 21:21:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503312124119B122' 0 = 1 cnt = 1 ========================2025-03-31 21:21:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2025-03-31 21:21:40======================== select * from customers where id = 'we32' ========================2025-03-31 21:21:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2025-03-31 21:21:40','10000','11000','온라인','0') ========================2025-03-31 23:50:47======================== res_start ========================2025-03-31 23:50:47======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다.