========================2025-01-08 10:36:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1736300106 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108103506 LGD_HASHDATA = ca616aca3477b6ce5b1a00b358b145a1 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 = 20250108103705EA83AE091FFCCD40F543BE6FEFE295B9C45F28B0 Mname = 박재호 Mcompany = (주)극광사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2025-01-08 10:36:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108103706 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52297176****586* LGD_FINANCEAUTHNUM = 30068594 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4132a1a5f79c4315b5e0829b362438a0 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250108103706 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2025010810370680SD7 LGD_BUYERID = LGD_OID = Direct-parkco6338-1736300106 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 81037068fa88 ========================2025-01-08 10:36:06======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1736300106', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)극광사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 52297176****586*', rApprNo = 'mjsof2025010810370680SD7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-08 10:36:06', InvoiceNum = '결제성공:Direct-parkco6338-1736300106/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-08 10:36:06' ========================2025-01-08 10:36:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025010810370680SD7' 0 = 1 cnt = 1 ========================2025-01-08 10:36:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = (주)극광사 Mcompany = (주)극광사 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2025-01-08 10:36:06======================== select * from customers where id = 'parkco6338' ========================2025-01-08 10:36:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2025-01-08 10:36:06','220000','220000','온라인','0') ========================2025-01-08 10:40:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1736300387 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108103947 LGD_HASHDATA = 02c7666d8fb812b5377b91f3d757f3fd 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 = 202501081041566D5E337594B0F4790F241736369961ED8C3C5B09 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2025-01-08 10:40:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108104157 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 = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 51818500****839* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e7dbb9288d3cbbe421e226c25b8038bf LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250108104157 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250108104157dNvE8 LGD_BUYERID = LGD_OID = Direct-mail2020-1736300387 LGD_RESPCODE = 3000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-08 10:47:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1736300493 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108104133 LGD_HASHDATA = 2aace47ff8df6358206c47e7acbb953f 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 = 20250108104838F18684E5F59F76929641256C8A0C2B35FA3049A8 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2025-01-08 10:47:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108104838 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 = 51818500****839* LGD_FINANCEAUTHNUM = 26201302 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 177c8d0f0b2bc92559d116c5a2ca13f0 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250108104839 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250108104838gF7U4 LGD_BUYERID = LGD_OID = Direct-mail2020-1736300493 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-08 10:47:39======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1736300493', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 51818500****839*', rApprNo = 'mjsof20250108104838gF7U4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-08 10:47:39', InvoiceNum = '결제성공:Direct-mail2020-1736300493/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-08 10:47:39' ========================2025-01-08 10:47:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250108104838gF7U4' 0 = 1 cnt = 1 ========================2025-01-08 10:47:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2025-01-08 10:47:39======================== select * from customers where id = 'mail2020' ========================2025-01-08 10:47:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2025-01-08 10:47:39','10000','11000','온라인','0') ========================2025-01-08 14:50:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1736315390 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108144950 LGD_HASHDATA = 021fee0af57ac4586a823c1d8394b52f 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 = 202501081451258AA5A6C2C1F734D486E312E73DD250768B93A29D Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2025-01-08 14:50:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108145126 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****454* LGD_FINANCEAUTHNUM = 57710559 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 23eb8a049df92bd62fdf66f657ae1290 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250108145127 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250108145126a0Mp1 LGD_BUYERID = LGD_OID = Direct-ltweenn-1736315390 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8145126a9Af3 ========================2025-01-08 14:50:26======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1736315390', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20250108145126a0Mp1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-08 14:50:26', InvoiceNum = '결제성공:Direct-ltweenn-1736315390/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-08 14:50:26' ========================2025-01-08 14:50:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250108145126a0Mp1' 0 = 1 cnt = 1 ========================2025-01-08 14:50:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2025-01-08 14:50:27======================== select * from customers where id = 'ltweenn' ========================2025-01-08 14:50:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2025-01-08 14:50:26','220000','220000','온라인','0') ========================2025-01-08 14:53:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-valvetcare-1736315472 LGD_BUYER = (주)벨벳케어 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108145112 LGD_HASHDATA = bb7b2e0a2bea8156e51a6bdf7550ac8f 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 = 20250108145439CEF072C5A406A90FFF2010B5436579F20D749D9E Mname = (주)벨벳케어 Mcompany = (주)벨벳케어 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = valvetcare LGD_ESCROW_USEYN = N ========================2025-01-08 14:53:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108145440 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****454* LGD_FINANCEAUTHNUM = 57719853 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 445d5f671ea8c2f64dfc1d1856c5b1c9 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250108145441 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳케어 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250108145440a1ea2 LGD_BUYERID = LGD_OID = Direct-valvetcare-1736315472 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8145440a9HZ3 ========================2025-01-08 14:53:40======================== insert into mBoard_order set rOrdNo = 'Direct-valvetcare-1736315472', AuthTy = 'card', memberId = 'valvetcare', OrdNm ='(주)벨벳케어', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳케어', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20250108145440a1ea2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-08 14:53:40', InvoiceNum = '결제성공:Direct-valvetcare-1736315472/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-08 14:53:40' ========================2025-01-08 14:53:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250108145440a1ea2' 0 = 1 cnt = 1 ========================2025-01-08 14:53:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'valvetcare' 0 = valvetcare Mid = valvetcare 1 = (주)벨벳케어 Mcompany = (주)벨벳케어 2 = 2128174481 companyNum = 2128174481 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2635-8692 Mhp = 010-2635-8692 ========================2025-01-08 14:53:40======================== select * from customers where id = 'valvetcare' ========================2025-01-08 14:53:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('valvetcare','2025-01-08 14:53:40','108000','110000','온라인','0') ========================2025-01-08 16:14:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nicetaek-1736320383 LGD_BUYER = 박성택 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250108161303 LGD_HASHDATA = 865ed979d4853d3507dd414f3cb1748c 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 = 20250108161547250081DD9174C9CBF2811300A31EC199EF3E0AE8 Mname = 박성택 Mcompany = (주)모토솔루션 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nicetaek LGD_ESCROW_USEYN = N ========================2025-01-08 16:14:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250108161547 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = nicetaek@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****682* LGD_FINANCEAUTHNUM = 30165524 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c0448ac5140ab9bfd2e449011455c727 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250108161547 LGD_PCANCELSTR = 0 LGD_BUYER = 박성택 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250108161547ur0Y8 LGD_BUYERID = LGD_OID = Direct-nicetaek-1736320383 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8161547ut2b1 ========================2025-01-08 16:14:47======================== insert into mBoard_order set rOrdNo = 'Direct-nicetaek-1736320383', AuthTy = 'card', memberId = 'nicetaek', OrdNm ='박성택', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)모토솔루션', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****682*', rApprNo = 'mjsof20250108161547ur0Y8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-08 16:14:47', InvoiceNum = '결제성공:Direct-nicetaek-1736320383/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-08 16:14:47' ========================2025-01-08 16:14:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250108161547ur0Y8' 0 = 1 cnt = 1 ========================2025-01-08 16:14:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nicetaek' 0 = nicetaek Mid = nicetaek 1 = (주)모토솔루션 Mcompany = (주)모토솔루션 2 = 1128800413 companyNum = 1128800413 3 = 02-2658-7619 Mtel1 = 02-2658-7619 4 = 010-8956-0295 Mhp = 010-8956-0295 ========================2025-01-08 16:14:47======================== select * from customers where id = 'nicetaek' ========================2025-01-08 16:14:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nicetaek','2025-01-08 16:14:47','108000','110000','온라인','0')