========================2024-10-08 09:05:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1728345858 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008090418 LGD_HASHDATA = 7df5537cb0063c594bbf5d91f057ba7c 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 = 202410080908063538BDCD2548188DE4401F03D3BDD675D4317879 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 ========================2024-10-08 09:05:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241008090807 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 = 64007764 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8ec4df17ad600e2f083d766ec3f868ce LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241008090808 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241008090807Dkp66 LGD_BUYERID = LGD_OID = Direct-ltweenn-1728345858 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8090807DB3t3 ========================2024-10-08 09:05:04======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1728345858', 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 = 'mjsof20241008090807Dkp66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-10-08 09:05:04', InvoiceNum = '결제성공:Direct-ltweenn-1728345858/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-10-08 09:05:04' ========================2024-10-08 09:05:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241008090807Dkp66' 0 = 1 cnt = 1 ========================2024-10-08 09:05:05======================== 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 ========================2024-10-08 09:05:05======================== select * from customers where id = 'ltweenn' ========================2024-10-08 09:05:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2024-10-08 09:05:04','220000','220000','온라인','0') ========================2024-10-08 10:24:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanapaper-1728350627 LGD_BUYER = 이전상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008102347 LGD_HASHDATA = cbc48eac2868597a465720d5b171ca35 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 = 20241008102755E765BAABFC9F22DE2AAA970ABD66A6FA8D6DC28C 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-10-08 10:24:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241008102756 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 = 64518386 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 20f252449e6ec6c18dd84142e64feca9 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241008102756 LGD_PCANCELSTR = 0 LGD_BUYER = 이전상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241008102755AlrQ0 LGD_BUYERID = LGD_OID = Direct-hanapaper-1728350627 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-10-08 10:24:53======================== insert into mBoard_order set rOrdNo = 'Direct-hanapaper-1728350627', 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 = 'mjsof20241008102755AlrQ0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-10-08 10:24:53', InvoiceNum = '결제성공:Direct-hanapaper-1728350627/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-10-08 10:24:53' ========================2024-10-08 10:24:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241008102755AlrQ0' 0 = 1 cnt = 1 ========================2024-10-08 10:24:53======================== 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-10-08 10:24:53======================== select * from customers where id = 'hanapaper' ========================2024-10-08 10:24:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanapaper','2024-10-08 10:24:53','52500','55000','온라인','0') ========================2024-10-08 12:49:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wjdtltmq-1728359292 LGD_BUYER = 정시습 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008124812 LGD_HASHDATA = eddbd19993536187f215eb26257f2a55 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 = 202410081252234F35FFBEA5BCAA0FE3301F8793AEC85AC2D7D24F Mname = 정시습 Mcompany = 이연아크릴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = wjdtltmq LGD_ESCROW_USEYN = N ========================2024-10-08 12:49:22======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20241008125225 LGD_BUYEREMAIL = 2yeonac@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 = 33000 LGD_FINANCECODE = 075098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 0dc3be2ac913225ec0126c5ab1d065a9 LGD_BUYERADDRESS = receiptKind = 0 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20241008125225 LGD_PCANCELSTR = 0 LGD_BUYER = 정시습 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 572 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20241008125208hcp95 LGD_BUYERID = LGD_OID = Direct-wjdtltmq-1728359292 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-10-08 12:49:22======================== insert into mBoard_order set rOrdNo = 'Direct-wjdtltmq-1728359292', AuthTy = 'card', memberId = 'wjdtltmq', OrdNm ='정시습', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이연아크릴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20241008125208hcp95', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-10-08 12:49:22', InvoiceNum = '결제성공:Direct-wjdtltmq-1728359292/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-10-08 12:49:22' ========================2024-10-08 12:49:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241008125208hcp95' 0 = 1 cnt = 1 ========================2024-10-08 12:49:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wjdtltmq' 0 = wjdtltmq Mid = wjdtltmq 1 = 이연아크릴 Mcompany = 이연아크릴 2 = 669-21-01972 companyNum = 669-21-01972 3 = 051-715-5141 Mtel1 = 051-715-5141 4 = 010-7922-5141 Mhp = 010-7922-5141 ========================2024-10-08 12:49:22======================== select * from customers where id = 'wjdtltmq' ========================2024-10-08 12:49:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wjdtltmq','2024-10-08 12:49:22','30900','33000','온라인','0') ========================2024-10-08 16:18:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-qnc1425-1728371640 LGD_BUYER = 은효미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008161400 LGD_HASHDATA = f73d5d35fc66117b856f4968fda3be50 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 = 202410081621246CF690E3677E8D675418FF5AF99755D6C30095FF Mname = 은효미 Mcompany = (주)큐엔씨B2B점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = qnc1425 LGD_ESCROW_USEYN = N ========================2024-10-08 16:18:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241008162125 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jjang9411@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003556 LGD_RESPMSG = G0:카드사문의요망(Refer to card issuer)(Tel.1588-1688) LGD_2TR_FLAG = Y LGD_CARDNUM = 94912169****815* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 8875b55975cd3600c478ccfb755e5589 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241008162125 LGD_PCANCELSTR = 0 LGD_BUYER = 은효미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202410081621253nJc4 LGD_BUYERID = LGD_OID = Direct-qnc1425-1728371640 LGD_RESPCODE = 3000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-10-08 16:27:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-qnc1425-1728372059 LGD_BUYER = 은효미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008162059 LGD_HASHDATA = 7af334aa5c5edf50aea6784c4489159f 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 = 20241008163012313307AEA9E6EB9DDF7E1562CCAA23F70B796D48 Mname = 은효미 Mcompany = (주)큐엔씨B2B점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = qnc1425 LGD_ESCROW_USEYN = N ========================2024-10-08 16:27:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241008163013 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jjang9411@nate.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 = 94091530****364* LGD_FINANCEAUTHNUM = 47694338 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c37115eea338970634fcc48afd815bbf LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20241008163013 LGD_PCANCELSTR = 0 LGD_BUYER = 은효미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241008163013idc84 LGD_BUYERID = LGD_OID = Direct-qnc1425-1728372059 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-10-08 16:27:10======================== insert into mBoard_order set rOrdNo = 'Direct-qnc1425-1728372059', AuthTy = 'card', memberId = 'qnc1425', OrdNm ='은효미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)큐엔씨B2B점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '롯데 94091530****364*', rApprNo = 'mjsof20241008163013idc84', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-10-08 16:27:10', InvoiceNum = '결제성공:Direct-qnc1425-1728372059/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-10-08 16:27:10' ========================2024-10-08 16:27:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241008163013idc84' 0 = 1 cnt = 1 ========================2024-10-08 16:27:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'qnc1425' 0 = qnc1425 Mid = qnc1425 1 = (주)큐엔씨B2B점 Mcompany = (주)큐엔씨B2B점 2 = 2038505014 companyNum = 2038505014 3 = 031-684-1425 Mtel1 = 031-684-1425 4 = 010-3675-2628 Mhp = 010-3675-2628 ========================2024-10-08 16:27:10======================== select * from customers where id = 'qnc1425' ========================2024-10-08 16:27:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('qnc1425','2024-10-08 16:27:10','30900','33000','온라인','0') ========================2024-10-08 17:45:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-aejuka-1728376960 LGD_BUYER = 염길선 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241008174240 LGD_HASHDATA = 7704a29bf4ec0bba27fcf7044dba1dff 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 = 20241008174828FE869348740CC48363D941968B0F9BB251880EFC Mname = 염길선 Mcompany = 맛미푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = aejuka LGD_ESCROW_USEYN = N ========================2024-10-08 17:45:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241008174830 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = aejuka@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62436304****229* LGD_FINANCEAUTHNUM = 57082698 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = c7c54bb9ee76a0191fbc71be601c60ae LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241008174831 LGD_PCANCELSTR = 0 LGD_BUYER = 염길선 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241008174829gWDl1 LGD_BUYERID = LGD_OID = Direct-aejuka-1728376960 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-10-08 17:45:27======================== insert into mBoard_order set rOrdNo = 'Direct-aejuka-1728376960', AuthTy = 'card', memberId = 'aejuka', OrdNm ='염길선', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '맛미푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '농협CUP 62436304****229*', rApprNo = 'mjsof20241008174829gWDl1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-10-08 17:45:27', InvoiceNum = '결제성공:Direct-aejuka-1728376960/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-10-08 17:45:27' ========================2024-10-08 17:45:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241008174829gWDl1' 0 = 1 cnt = 1 ========================2024-10-08 17:45:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'aejuka' 0 = aejuka Mid = aejuka 1 = 맛미푸드 Mcompany = 맛미푸드 2 = 140-90-49165 companyNum = 140-90-49165 3 = 010-6284-8240 Mtel1 = 010-6284-8240 4 = 010-4732-8502 Mhp = 010-4732-8502 ========================2024-10-08 17:45:27======================== select * from customers where id = 'aejuka' ========================2024-10-08 17:45:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('aejuka','2024-10-08 17:45:27','52500','55000','온라인','0')