========================2024-05-30 10:27:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-youngwoohn-1717032297 LGD_BUYER = 김우순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240530102457 LGD_HASHDATA = a03d8e4edbfc476e8f22067509d806a1 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 = 202405301028167B4EDB3AD7D9C55E4C4D1B75431FC6A80B6A0374 Mname = 김우순 Mcompany = (주)영우유화 호남지사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = youngwoohn LGD_ESCROW_USEYN = N ========================2024-05-30 10:27:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240530102817 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641507****698* LGD_FINANCEAUTHNUM = 53165173 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3d339d55fb0f233f2d770715245d979e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240530102817 LGD_PCANCELSTR = 0 LGD_BUYER = 김우순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240530102817v5a33 LGD_BUYERID = LGD_OID = Direct-youngwoohn-1717032297 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0102817veTG8 ========================2024-05-30 10:27:43======================== insert into mBoard_order set rOrdNo = 'Direct-youngwoohn-1717032297', AuthTy = 'card', memberId = 'youngwoohn', OrdNm ='김우순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)영우유화 호남지사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62641507****698*', rApprNo = 'mjsof20240530102817v5a33', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-30 10:27:43', InvoiceNum = '결제성공:Direct-youngwoohn-1717032297/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-30 10:27:43' ========================2024-05-30 10:27:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240530102817v5a33' 0 = 1 cnt = 1 ========================2024-05-30 10:27:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'youngwoohn' 0 = youngwoohn Mid = youngwoohn 1 = (주)영우유화 호남지사 Mcompany = (주)영우유화 호남지사 2 = 416-81-44987 companyNum = 416-81-44987 3 = 010-3626-2090 Mtel1 = 010-3626-2090 4 = 010-3626-2090 Mhp = 010-3626-2090 ========================2024-05-30 10:27:43======================== select * from customers where id = 'youngwoohn' ========================2024-05-30 10:27:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('youngwoohn','2024-05-30 10:27:43','108000','110000','온라인','0') ========================2024-05-30 13:29:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rvs2019-1717043207 LGD_BUYER = 신원빈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240530132647 LGD_HASHDATA = 2f0e4f846bb665e16e41f595eac036c8 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 = 202405301329466A0026A811B165AF74CF6C17DDC2A252B2AC1046 Mname = 신원빈 Mcompany = 알비에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = rvs2019 LGD_ESCROW_USEYN = N ========================2024-05-30 13:29:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240530132947 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = glgk34@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94303213****098* LGD_FINANCEAUTHNUM = 54284319 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5c7ed0dc985bf1345345ea9012947cc5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240530132947 LGD_PCANCELSTR = 0 LGD_BUYER = 신원빈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405301329464UJs2 LGD_BUYERID = LGD_OID = Direct-rvs2019-1717043207 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01329464AEz9 ========================2024-05-30 13:29:13======================== insert into mBoard_order set rOrdNo = 'Direct-rvs2019-1717043207', AuthTy = 'card', memberId = 'rvs2019', OrdNm ='신원빈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '알비에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94303213****098*', rApprNo = 'mjsof202405301329464UJs2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-30 13:29:13', InvoiceNum = '결제성공:Direct-rvs2019-1717043207/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-30 13:29:13' ========================2024-05-30 13:29:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405301329464UJs2' 0 = 1 cnt = 1 ========================2024-05-30 13:29:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rvs2019' 0 = rvs2019 Mid = rvs2019 1 = 알비에스 Mcompany = 알비에스 2 = 587-67-00344 companyNum = 587-67-00344 3 = 010-4845-5751 Mtel1 = 010-4845-5751 4 = 010-4845-5751 Mhp = 010-4845-5751 ========================2024-05-30 13:29:13======================== select * from customers where id = 'rvs2019' ========================2024-05-30 13:29:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rvs2019','2024-05-30 13:29:13','52500','55000','온라인','0') ========================2024-05-30 15:01:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sewoolube-1717048733 LGD_BUYER = 강향주 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240530145853 LGD_HASHDATA = 4cb39651c51174c4b31326f917e5560f 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 = 20240530150136C70CA7512BA115C000EE84DA0C7072259DD30F39 Mname = 강향주 Mcompany = (주)세우루브 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = 세우루브 UserId = sewoolube LGD_ESCROW_USEYN = N ========================2024-05-30 15:01:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240530150137 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = sewoolube@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55853255****880* LGD_FINANCEAUTHNUM = 55337542 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dbc687b93793becd6bee172c65e01fab LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240530150137 LGD_PCANCELSTR = 0 LGD_BUYER = 강향주 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202405301501373Dlr5 LGD_BUYERID = LGD_OID = Direct-sewoolube-1717048733 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01501373zRd9 ========================2024-05-30 15:01:03======================== insert into mBoard_order set rOrdNo = 'Direct-sewoolube-1717048733', AuthTy = 'card', memberId = 'sewoolube', OrdNm ='강향주', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세우루브', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55853255****880*', rApprNo = 'mjsof202405301501373Dlr5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-30 15:01:03', InvoiceNum = '결제성공:Direct-sewoolube-1717048733/0000', Deliver = '', senditem = '세우루브', salestopvalue = '', mod_date = '2024-05-30 15:01:03' ========================2024-05-30 15:01:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202405301501373Dlr5' 0 = 1 cnt = 1 ========================2024-05-30 15:01:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sewoolube' 0 = sewoolube Mid = sewoolube 1 = (주)세우루브 Mcompany = (주)세우루브 2 = 607-81-85982 companyNum = 607-81-85982 3 = 051-853-1580 Mtel1 = 051-853-1580 4 = 010-9306-6632 Mhp = 010-9306-6632 ========================2024-05-30 15:01:03======================== select * from customers where id = 'sewoolube' ========================2024-05-30 15:01:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sewoolube','2024-05-30 15:01:03','52500','55000','온라인','0') ========================2024-05-30 16:27:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-moa5185-1717054001 LGD_BUYER = 견경수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240530162641 LGD_HASHDATA = f75db15ad78f1be29df2f9fcdc9dbeb4 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 = 202405301628147978E316BBB4CDF70379BFB8D4823656439D3C04 Mname = 견경수 Mcompany = 모아나눔사회적협동조합 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = moa5185 LGD_ESCROW_USEYN = N ========================2024-05-30 16:27:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240530162815 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46323592****495* LGD_FINANCEAUTHNUM = 30035910 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = a7f522ab8b98dbe97f18f66c87a73abe LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240530162815 LGD_PCANCELSTR = 0 LGD_BUYER = 견경수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240530162814b8LF7 LGD_BUYERID = LGD_OID = Direct-moa5185-1717054001 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0162814b7Br9 ========================2024-05-30 16:27:41======================== insert into mBoard_order set rOrdNo = 'Direct-moa5185-1717054001', AuthTy = 'card', memberId = 'moa5185', OrdNm ='견경수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '모아나눔사회적협동조합', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 46323592****495*', rApprNo = 'mjsof20240530162814b8LF7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-30 16:27:41', InvoiceNum = '결제성공:Direct-moa5185-1717054001/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-30 16:27:41' ========================2024-05-30 16:27:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240530162814b8LF7' 0 = 1 cnt = 1 ========================2024-05-30 16:27:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'moa5185' 0 = moa5185 Mid = moa5185 1 = 모아나눔사회적협동조합 Mcompany = 모아나눔사회적협동조합 2 = 1098642000 companyNum = 1098642000 3 = 02-1644-5205 Mtel1 = 02-1644-5205 4 = 010-8200-8060 Mhp = 010-8200-8060 ========================2024-05-30 16:27:41======================== select * from customers where id = 'moa5185' ========================2024-05-30 16:27:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('moa5185','2024-05-30 16:27:41','108000','110000','온라인','0') ========================2024-05-30 17:21:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-damiki-1717057191 LGD_BUYER = 박영옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240530171951 LGD_HASHDATA = e8899c188316ad0c76d5159423556bd6 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 = 202405301722137168A9E337855FBA397B9CBDCD9CE692181CF47F Mname = 박영옥 Mcompany = 다미끼크라프트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = damiki LGD_ESCROW_USEYN = N ========================2024-05-30 17:21:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240530172214 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = wanaka99@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****193* LGD_FINANCEAUTHNUM = 56274556 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = db25e7bfcf7b7973bf17f7724a0276fd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240530172214 LGD_PCANCELSTR = 0 LGD_BUYER = 박영옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024053017221316MT5 LGD_BUYERID = LGD_OID = Direct-damiki-1717057191 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01722131Etj7 ========================2024-05-30 17:21:40======================== insert into mBoard_order set rOrdNo = 'Direct-damiki-1717057191', AuthTy = 'card', memberId = 'damiki', OrdNm ='박영옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다미끼크라프트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****193*', rApprNo = 'mjsof2024053017221316MT5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-05-30 17:21:40', InvoiceNum = '결제성공:Direct-damiki-1717057191/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-05-30 17:21:40' ========================2024-05-30 17:21:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024053017221316MT5' 0 = 1 cnt = 1 ========================2024-05-30 17:21:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'damiki' 0 = damiki Mid = damiki 1 = 다미끼크라프트 Mcompany = 다미끼크라프트 2 = 138-03-73658 companyNum = 138-03-73658 3 = 031-348-9201 Mtel1 = 031-348-9201 4 = 010-2658-0429 Mhp = 010-2658-0429 ========================2024-05-30 17:21:40======================== select * from customers where id = 'damiki' ========================2024-05-30 17:21:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('damiki','2024-05-30 17:21:40','108000','110000','온라인','0')