========================2025-06-05 10:37:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1749087387 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605103627 LGD_HASHDATA = 802c4587b15b2dedad8837f9fb5222a4 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 = 2025060510411107041644D41F7F6A0DA62531F9635AE88A2B87D1 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-06-05 10:37:25======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20250605104111 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 = LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 91b390979c4136a1670f0e8c87a303ca LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250605104112 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250605104042VGoo8 LGD_BUYERID = LGD_OID = Direct-mail2020-1749087387 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-05 10:37:25======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1749087387', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20250605104042VGoo8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 10:37:25', InvoiceNum = '결제성공:Direct-mail2020-1749087387/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 10:37:25' ========================2025-06-05 10:37:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250605104042VGoo8' 0 = 1 cnt = 1 ========================2025-06-05 10:37:25======================== 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-06-05 10:37:25======================== select * from customers where id = 'mail2020' ========================2025-06-05 10:37:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2025-06-05 10:37:25','10000','11000','온라인','0') ========================2025-06-05 11:42:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1749090954 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605113554 LGD_HASHDATA = a5276c05a16badae668a341e31aacabb 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 = 20250605114643733C449A0730320BA05C1B9EC5189C19D2E6B36D Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2025-06-05 11:42:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605114644 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 32116839 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 84a63a8c996b722bcdeef431ab1c286b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250605114644 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506051146447FwI2 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1749090954 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51146447at97 ========================2025-06-05 11:42:58======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1749090954', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof202506051146447FwI2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 11:42:58', InvoiceNum = '결제성공:Direct-mmthcoffee-1749090954/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 11:42:58' ========================2025-06-05 11:42:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506051146447FwI2' 0 = 1 cnt = 1 ========================2025-06-05 11:42:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2025-06-05 11:42:58======================== select * from customers where id = 'mmthcoffee' ========================2025-06-05 11:42:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2025-06-05 11:42:58','220000','220000','온라인','0') ========================2025-06-05 11:53:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ohjinsoo57-1749091828 LGD_BUYER = 오진수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605115028 LGD_HASHDATA = d18d6f39ef9b194ddc3b3918cd0d0e8f 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 = 202506051157083CB85B37A1DB3945B773CF65B06257D0CE08AB8D Mname = 오진수 Mcompany = 쁘리마쥬주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ohjinsoo57 LGD_ESCROW_USEYN = N ========================2025-06-05 11:53:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605115708 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852696****985* LGD_FINANCEAUTHNUM = 30040465 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 166404ddef37e47f428ae50106c6e1a6 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250605115708 LGD_PCANCELSTR = 0 LGD_BUYER = 오진수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250605115708ZH9q6 LGD_BUYERID = LGD_OID = Direct-ohjinsoo57-1749091828 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5115708ZtFp3 ========================2025-06-05 11:53:22======================== insert into mBoard_order set rOrdNo = 'Direct-ohjinsoo57-1749091828', AuthTy = 'card', memberId = 'ohjinsoo57', OrdNm ='오진수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '쁘리마쥬주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852696****985*', rApprNo = 'mjsof20250605115708ZH9q6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 11:53:22', InvoiceNum = '결제성공:Direct-ohjinsoo57-1749091828/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 11:53:22' ========================2025-06-05 11:53:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250605115708ZH9q6' 0 = 1 cnt = 1 ========================2025-06-05 11:53:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ohjinsoo57' 0 = ohjinsoo57 Mid = ohjinsoo57 1 = 쁘리마쥬주식회사 Mcompany = 쁘리마쥬주식회사 2 = 2648600063 companyNum = 2648600063 3 = 010-5630-3164 Mtel1 = 010-5630-3164 4 = 010-5630-3164 Mhp = 010-5630-3164 ========================2025-06-05 11:53:22======================== select * from customers where id = 'ohjinsoo57' ========================2025-06-05 11:53:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ohjinsoo57','2025-06-05 11:53:22','52500','55000','온라인','0') ========================2025-06-05 13:11:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hjss1976-1749096592 LGD_BUYER = 양진규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605130952 LGD_HASHDATA = d6fefb45a21d7f02fe9afd2ddf6cd2f4 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 = 20250605131509C951C267A7FF8994DBA0DD14440CC4E54A86EDAB Mname = 양진규 Mcompany = 형제상사 주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hjss1976 LGD_ESCROW_USEYN = N ========================2025-06-05 13:11:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605131509 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 1359sun@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 = 94301679****596* LGD_FINANCEAUTHNUM = 45707321 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fd277f5b2d5673de901ba86b16cc41f9 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250605131510 LGD_PCANCELSTR = 0 LGD_BUYER = 양진규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506051315093DkZ7 LGD_BUYERID = LGD_OID = Direct-hjss1976-1749096592 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-05 13:11:23======================== insert into mBoard_order set rOrdNo = 'Direct-hjss1976-1749096592', AuthTy = 'card', memberId = 'hjss1976', OrdNm ='양진규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '형제상사 주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH 94301679****596*', rApprNo = 'mjsof202506051315093DkZ7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 13:11:23', InvoiceNum = '결제성공:Direct-hjss1976-1749096592/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 13:11:23' ========================2025-06-05 13:11:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506051315093DkZ7' 0 = 1 cnt = 1 ========================2025-06-05 13:11:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hjss1976' 0 = hjss1976 Mid = hjss1976 1 = Mcompany = 2 = companyNum = 3 = 010-6365-6448 Mtel1 = 010-6365-6448 4 = Mhp = ========================2025-06-05 13:11:23======================== select * from customers where id = 'hjss1976' ========================2025-06-05 13:11:23======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('hjss1976','','','010-6365-6448','','2025-06-05 13:11:23','온라인') ========================2025-06-05 13:11:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hjss1976','2025-06-05 13:11:23','52500','55000','온라인','0') ========================2025-06-05 14:00:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jeng97-1749099402 LGD_BUYER = 안지현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605135642 LGD_HASHDATA = fdfb705666e604303ba529e74a4bf8e2 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 = 202506051404210A9751BA30CA35051B6720C5D26BD752FD571044 Mname = 안지현 Mcompany = 제이이엔지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jeng97 LGD_ESCROW_USEYN = N ========================2025-06-05 14:00:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605140422 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 = 40329380****080* LGD_FINANCEAUTHNUM = 00913474 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 701552503f97705e2676db77f137518e LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250605140422 LGD_PCANCELSTR = 0 LGD_BUYER = 안지현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506051404225csp9 LGD_BUYERID = LGD_OID = Direct-jeng97-1749099402 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-05 14:00:35======================== insert into mBoard_order set rOrdNo = 'Direct-jeng97-1749099402', AuthTy = 'card', memberId = 'jeng97', OrdNm ='안지현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이이엔지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 40329380****080*', rApprNo = 'mjsof202506051404225csp9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 14:00:35', InvoiceNum = '결제성공:Direct-jeng97-1749099402/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 14:00:35' ========================2025-06-05 14:00:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506051404225csp9' 0 = 1 cnt = 1 ========================2025-06-05 14:00:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jeng97' 0 = jeng97 Mid = jeng97 1 = 제이이엔지 Mcompany = 제이이엔지 2 = 881-13-00511 companyNum = 881-13-00511 3 = 055-312-3477 Mtel1 = 055-312-3477 4 = 010-4913-3494 Mhp = 010-4913-3494 ========================2025-06-05 14:00:36======================== select * from customers where id = 'jeng97' ========================2025-06-05 14:00:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jeng97','2025-06-05 14:00:35','30900','33000','온라인','0') ========================2025-06-05 15:27:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmall-1749104808 LGD_BUYER = 문시연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605152648 LGD_HASHDATA = 1908c43d5a6b44a81c70b9d25abf14f8 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 = 2025060515313547B33DDEE3D23EEBF37D607C5F95F4A4821410C3 Mname = 문시연 Mcompany = (주)다다통상 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = foodmall LGD_ESCROW_USEYN = N ========================2025-06-05 15:27:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605153136 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dada_trade@naver.com 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 = 41710311****790* LGD_FINANCEAUTHNUM = 34554157 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c97bafc5b1f94eb1037d4438217bfbc3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250605153136 LGD_PCANCELSTR = 0 LGD_BUYER = 문시연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506051531351wnN3 LGD_BUYERID = LGD_OID = Direct-foodmall-1749104808 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51531351roQ8 ========================2025-06-05 15:27:50======================== insert into mBoard_order set rOrdNo = 'Direct-foodmall-1749104808', AuthTy = 'card', memberId = 'foodmall', OrdNm ='문시연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다다통상', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨VISA 41710311****790*', rApprNo = 'mjsof202506051531351wnN3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 15:27:50', InvoiceNum = '결제성공:Direct-foodmall-1749104808/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 15:27:50' ========================2025-06-05 15:27:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506051531351wnN3' 0 = 1 cnt = 1 ========================2025-06-05 15:27:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmall' 0 = foodmall Mid = foodmall 1 = (주)다다통상 Mcompany = (주)다다통상 2 = 6058601749 companyNum = 6058601749 3 = 051-701-1901 Mtel1 = 051-701-1901 4 = 010-2985-5344 Mhp = 010-2985-5344 ========================2025-06-05 15:27:50======================== select * from customers where id = 'foodmall' ========================2025-06-05 15:27:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmall','2025-06-05 15:27:50','10000','11000','온라인','0') ========================2025-06-05 16:50:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-koryo88-1749109721 LGD_BUYER = 정지원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605164841 LGD_HASHDATA = ee9f8f5a5ac45f320ec22c429c0ac5f0 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 = 20250605165356003A1725C7DC8B0D0615F90E630242020F5C2977 Mname = 정지원 Mcompany = 고려종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = koryo88 LGD_ESCROW_USEYN = N ========================2025-06-05 16:50:11======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20250605165358 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 = 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 = 062996b2125d0eabeb8244399364a225 LGD_BUYERADDRESS = receiptKind = 1 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250605165358 LGD_PCANCELSTR = 0 LGD_BUYER = 정지원 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250605165331SY886 LGD_BUYERID = LGD_OID = Direct-koryo88-1749109721 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-06-05 16:50:11======================== insert into mBoard_order set rOrdNo = 'Direct-koryo88-1749109721', AuthTy = 'card', memberId = 'koryo88', OrdNm ='정지원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '고려종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20250605165331SY886', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 16:50:11', InvoiceNum = '결제성공:Direct-koryo88-1749109721/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 16:50:11' ========================2025-06-05 16:50:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250605165331SY886' 0 = 1 cnt = 1 ========================2025-06-05 16:50:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'koryo88' 0 = koryo88 Mid = koryo88 1 = 고려종합상사 Mcompany = 고려종합상사 2 = 126-15-83670 companyNum = 126-15-83670 3 = 010-9912-5771 Mtel1 = 010-9912-5771 4 = 010-9912-5771 Mhp = 010-9912-5771 ========================2025-06-05 16:50:12======================== select * from customers where id = 'koryo88' ========================2025-06-05 16:50:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('koryo88','2025-06-05 16:50:11','108000','110000','온라인','0') ========================2025-06-05 18:01:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongjo-1749112765 LGD_BUYER = 김호순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250605173925 LGD_HASHDATA = aed5f9f69c30374632ab3ead0d60905e 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 = 20250605180523FF93A66788B929BC03D67E592BB2AF82207BB8EE Mname = 김호순 Mcompany = (주)동조 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dongjo LGD_ESCROW_USEYN = N ========================2025-06-05 18:01:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250605180523 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jiha@thedawn.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 101044 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850322****690* LGD_FINANCEAUTHNUM = 35671226 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ba31ea66d6a51e126264427bd7b93d20 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250605180524 LGD_PCANCELSTR = 0 LGD_BUYER = 김호순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202506051805234C5D1 LGD_BUYERID = LGD_OID = Direct-dongjo-1749112765 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51805234xd19 ========================2025-06-05 18:01:37======================== insert into mBoard_order set rOrdNo = 'Direct-dongjo-1749112765', AuthTy = 'card', memberId = 'dongjo', OrdNm ='김호순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)동조', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850322****690*', rApprNo = 'mjsof202506051805234C5D1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-06-05 18:01:37', InvoiceNum = '결제성공:Direct-dongjo-1749112765/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-06-05 18:01:37' ========================2025-06-05 18:01:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202506051805234C5D1' 0 = 1 cnt = 1 ========================2025-06-05 18:01:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongjo' 0 = dongjo Mid = dongjo 1 = (주)동조 Mcompany = (주)동조 2 = 1108121335 companyNum = 1108121335 3 = 02-730-8228 Mtel1 = 02-730-8228 4 = 010-8705-8756 Mhp = 010-8705-8756 ========================2025-06-05 18:01:37======================== select * from customers where id = 'dongjo' ========================2025-06-05 18:01:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongjo','2025-06-05 18:01:37','108000','110000','온라인','0')