========================2024-12-30 09:40:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ahaeindus-1735519026 LGD_BUYER = 채근호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230093706 LGD_HASHDATA = ec12ca27f480c31e762524a7dea32bd2 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 = 2024123009405704A6D6B7A4581FA55586FA9C4135DB1D9192F86A Mname = 채근호 Mcompany = 에스엔티산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ahaeindus LGD_ESCROW_USEYN = N ========================2024-12-30 09:40:08======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20241230094058 LGD_DISCOUNTUSEYN = 1 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 = 47428910****263* LGD_FINANCEAUTHNUM = 94670282 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 04f3d53c07b00723b7e4c7b21737daf3 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20241230094059 LGD_PCANCELSTR = 0 LGD_BUYER = 채근호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412300940585JaO0 LGD_BUYERID = LGD_OID = Direct-ahaeindus-1735519026 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 09:40:08======================== insert into mBoard_order set rOrdNo = 'Direct-ahaeindus-1735519026', AuthTy = 'card', memberId = 'ahaeindus', OrdNm ='채근호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '에스엔티산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성VISA 47428910****263*', rApprNo = 'mjsof202412300940585JaO0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 09:40:08', InvoiceNum = '결제성공:Direct-ahaeindus-1735519026/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 09:40:08' ========================2024-12-30 09:40:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412300940585JaO0' 0 = 1 cnt = 1 ========================2024-12-30 09:40:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ahaeindus' 0 = ahaeindus Mid = ahaeindus 1 = 에스엔티산업 Mcompany = 에스엔티산업 2 = 502-19-19477 companyNum = 502-19-19477 3 = 053-811-7811 Mtel1 = 053-811-7811 4 = 010-2847-7814 Mhp = 010-2847-7814 ========================2024-12-30 09:40:08======================== select * from customers where id = 'ahaeindus' ========================2024-12-30 09:40:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ahaeindus','2024-12-30 09:40:08','108000','110000','온라인','0') ========================2024-12-30 16:30:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanapaper-1735543733 LGD_BUYER = 이전상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230162853 LGD_HASHDATA = 863fa0c553dc2078da8be54a5b852944 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 = 202412301630590FC3EF4A05BE0C8CA6625A68443D6C40FDAF20E4 Mname = 이전상 Mcompany = (주)미르티앤엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hanapaper LGD_ESCROW_USEYN = N ========================2024-12-30 16:30:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241230163100 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 = 41452000****446* LGD_FINANCEAUTHNUM = 35440711 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 52398dd408ce704a85a9ebcf36b7e268 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241230163100 LGD_PCANCELSTR = 0 LGD_BUYER = 이전상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241230163100huIm0 LGD_BUYERID = LGD_OID = Direct-hanapaper-1735543733 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 16:30:10======================== insert into mBoard_order set rOrdNo = 'Direct-hanapaper-1735543733', AuthTy = 'card', memberId = 'hanapaper', OrdNm ='이전상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미르티앤엠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41452000****446*', rApprNo = 'mjsof20241230163100huIm0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 16:30:10', InvoiceNum = '결제성공:Direct-hanapaper-1735543733/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 16:30:10' ========================2024-12-30 16:30:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241230163100huIm0' 0 = 1 cnt = 1 ========================2024-12-30 16:30:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanapaper' 0 = hanapaper Mid = hanapaper 1 = (주)미르티앤엠 Mcompany = (주)미르티앤엠 2 = 1348736286 companyNum = 1348736286 3 = 031-521-6690 Mtel1 = 031-521-6690 4 = 010-2216-5552 Mhp = 010-2216-5552 ========================2024-12-30 16:30:10======================== select * from customers where id = 'hanapaper' ========================2024-12-30 16:30:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanapaper','2024-12-30 16:30:10','52500','55000','온라인','0') ========================2024-12-30 16:33:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sinton1-1735543963 LGD_BUYER = 신도겸 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230163243 LGD_HASHDATA = c0ff3ebac112c47f051c85ef6004cf18 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 = 202412301634401A2D9D475B1F993FB66B92CA8F2D81D9F4FF181B Mname = 신도겸 Mcompany = 신도조각 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sinton1 LGD_ESCROW_USEYN = N ========================2024-12-30 16:33:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241230163441 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 = 40201780****460* LGD_FINANCEAUTHNUM = 00592858 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 36a469c64f3b9d55c0e98ad35ed23423 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20241230163441 LGD_PCANCELSTR = 0 LGD_BUYER = 신도겸 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412301634411hkv9 LGD_BUYERID = LGD_OID = Direct-sinton1-1735543963 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 16:33:50======================== insert into mBoard_order set rOrdNo = 'Direct-sinton1-1735543963', AuthTy = 'card', memberId = 'sinton1', OrdNm ='신도겸', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신도조각', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 40201780****460*', rApprNo = 'mjsof202412301634411hkv9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 16:33:50', InvoiceNum = '결제성공:Direct-sinton1-1735543963/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 16:33:50' ========================2024-12-30 16:33:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412301634411hkv9' 0 = 1 cnt = 1 ========================2024-12-30 16:33:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sinton1' 0 = sinton1 Mid = sinton1 1 = 신도조각 Mcompany = 신도조각 2 = 595-39-01040 companyNum = 595-39-01040 3 = 010-4023-8456 Mtel1 = 010-4023-8456 4 = -- Mhp = -- ========================2024-12-30 16:33:51======================== select * from customers where id = 'sinton1' ========================2024-12-30 16:33:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sinton1','2024-12-30 16:33:50','10000','11000','온라인','0') ========================2024-12-30 17:21:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-retro60s-1735546794 LGD_BUYER = 배성혁 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230171954 LGD_HASHDATA = 667adcb197237a4e089ed9d50ec8bc3b 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 = 202412301722325D7645E1D24CE1C80142EB66B176D98ABE69C7E8 Mname = 배성혁 Mcompany = 식스티즈 커피컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = retro60s LGD_ESCROW_USEYN = N ========================2024-12-30 17:21:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241230172233 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = wj0807@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BJBBE4 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46195410****918* LGD_FINANCEAUTHNUM = 42329899 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = ba752a5374e34f4ef557058dba05e20a LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20241230172234 LGD_PCANCELSTR = 0 LGD_BUYER = 배성혁 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412301722336Yws2 LGD_BUYERID = LGD_OID = Direct-retro60s-1735546794 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 17:21:43======================== insert into mBoard_order set rOrdNo = 'Direct-retro60s-1735546794', AuthTy = 'card', memberId = 'retro60s', OrdNm ='배성혁', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '식스티즈 커피컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 46195410****918*', rApprNo = 'mjsof202412301722336Yws2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 17:21:43', InvoiceNum = '결제성공:Direct-retro60s-1735546794/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 17:21:43' ========================2024-12-30 17:21:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412301722336Yws2' 0 = 1 cnt = 1 ========================2024-12-30 17:21:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'retro60s' 0 = retro60s Mid = retro60s 1 = 식스티즈 커피컴퍼니 Mcompany = 식스티즈 커피컴퍼니 2 = 6407100166 companyNum = 6407100166 3 = 010-8550-9988 Mtel1 = 010-8550-9988 4 = 010-8550-9988 Mhp = 010-8550-9988 ========================2024-12-30 17:21:43======================== select * from customers where id = 'retro60s' ========================2024-12-30 17:21:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('retro60s','2024-12-30 17:21:43','108000','110000','온라인','0') ========================2024-12-30 17:32:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tjdwns0203-1735547495 LGD_BUYER = 이성준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230173135 LGD_HASHDATA = aac1e86e093e8316f641d4ea15d9e68e 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 = 202412301733423C0D2F114C1A9FF2F31EC884732BD7671F0B6C48 Mname = 이성준 Mcompany = SJ유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = tjdwns0203 LGD_ESCROW_USEYN = N ========================2024-12-30 17:32:52======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20241230173342 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37918395****14* LGD_FINANCEAUTHNUM = 11738791 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 18657671235a9a175079cd8662283ddf LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20241230173342 LGD_PCANCELSTR = 0 LGD_BUYER = 이성준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241230173322aLAq6 LGD_BUYERID = LGD_OID = Direct-tjdwns0203-1735547495 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 17:32:52======================== insert into mBoard_order set rOrdNo = 'Direct-tjdwns0203-1735547495', AuthTy = 'card', memberId = 'tjdwns0203', OrdNm ='이성준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'SJ유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성AMEX 37918395****14*', rApprNo = 'mjsof20241230173322aLAq6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 17:32:52', InvoiceNum = '결제성공:Direct-tjdwns0203-1735547495/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 17:32:52' ========================2024-12-30 17:32:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241230173322aLAq6' 0 = 1 cnt = 1 ========================2024-12-30 17:32:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tjdwns0203' 0 = tjdwns0203 Mid = tjdwns0203 1 = SJ유통 Mcompany = SJ유통 2 = 5100563604 companyNum = 5100563604 3 = 054-473-1463 Mtel1 = 054-473-1463 4 = 011-533-1556 Mhp = 011-533-1556 ========================2024-12-30 17:32:52======================== select * from customers where id = 'tjdwns0203' ========================2024-12-30 17:32:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tjdwns0203','2024-12-30 17:32:52','52500','55000','온라인','0') ========================2024-12-30 21:57:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-soda278-1735563380 LGD_BUYER = 박승완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241230215620 LGD_HASHDATA = 7ec832a6253365018762c086ffc5409d 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 = 2024123021584742FCAED6E70CFFE9D6694735F213B8A8B0771E03 Mname = 박승완 Mcompany = 하이키한의원 부설 원외탕전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = soda278 LGD_ESCROW_USEYN = N ========================2024-12-30 21:57:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241230215847 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 = 55318440****798* LGD_FINANCEAUTHNUM = 01619105 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6c833c6697100f1f7d937b0ca9f972cd LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20241230215848 LGD_PCANCELSTR = 0 LGD_BUYER = 박승완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412302158479bkV1 LGD_BUYERID = LGD_OID = Direct-soda278-1735563380 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-30 21:57:57======================== insert into mBoard_order set rOrdNo = 'Direct-soda278-1735563380', AuthTy = 'card', memberId = 'soda278', OrdNm ='박승완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '하이키한의원 부설 원외탕전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '하나MASTER 55318440****798*', rApprNo = 'mjsof202412302158479bkV1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-30 21:57:57', InvoiceNum = '결제성공:Direct-soda278-1735563380/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-30 21:57:57' ========================2024-12-30 21:57:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412302158479bkV1' 0 = 1 cnt = 1 ========================2024-12-30 21:57:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'soda278' 0 = soda278 Mid = soda278 1 = 하이키한의원 부설 원외탕전 Mcompany = 하이키한의원 부설 원외탕전 2 = 1140654544 companyNum = 1140654544 3 = 010-5423-0269 Mtel1 = 010-5423-0269 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2024-12-30 21:57:57======================== select * from customers where id = 'soda278' ========================2024-12-30 21:57:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('soda278','2024-12-30 21:57:57','52500','55000','온라인','0')