========================2024-07-05 09:19:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yeongmin80-1720138650 LGD_BUYER = 안영민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705091730 LGD_HASHDATA = 51fb5cd5c9ea01028ffa961db8444346 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 = 20240705092041A261EF54E55E97E31811272F97CD99D558FF8E8E Mname = 안영민 Mcompany = YM메드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yeongmin80 LGD_ESCROW_USEYN = N ========================2024-07-05 09:19:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240705092042 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = adamyung@daum.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850310****490* LGD_FINANCEAUTHNUM = 66355089 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2c4e1b9eded50ed0880a5744bee049ee LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240705092042 LGD_PCANCELSTR = 0 LGD_BUYER = 안영민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202407050920421jmk0 LGD_BUYERID = LGD_OID = Direct-yeongmin80-1720138650 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 50920421CpA8 ========================2024-07-05 09:19:28======================== insert into mBoard_order set rOrdNo = 'Direct-yeongmin80-1720138650', AuthTy = 'card', memberId = 'yeongmin80', OrdNm ='안영민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'YM메드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850310****490*', rApprNo = 'mjsof202407050920421jmk0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 09:19:28', InvoiceNum = '결제성공:Direct-yeongmin80-1720138650/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-05 09:19:28' ========================2024-07-05 09:19:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202407050920421jmk0' 0 = 1 cnt = 1 ========================2024-07-05 09:19:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yeongmin80' 0 = yeongmin80 Mid = yeongmin80 1 = Mcompany = 2 = 5835200289 companyNum = 5835200289 3 = 051-241-5771 Mtel1 = 051-241-5771 4 = 010-6382-5771 Mhp = 010-6382-5771 ========================2024-07-05 09:19:28======================== select * from customers where id = 'yeongmin80' ========================2024-07-05 09:19:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yeongmin80','2024-07-05 09:19:28','220000','220000','온라인','0') ========================2024-07-05 09:30:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kpl7789-1720139328 LGD_BUYER = 케이피엘산업개발 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705092848 LGD_HASHDATA = 725bb721d938cab9ad5f139cd29028e2 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 = 202407050931175109F124824BDF5970A02EC2F07967076A60123C Mname = 케이피엘산업개발 Mcompany = (유)케이피엘산업개발 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kpl7789 LGD_ESCROW_USEYN = N ========================2024-07-05 09:30:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240705093118 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kpl7789@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 = 42658695****989* LGD_FINANCEAUTHNUM = 30000483 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6f5919b2f7add753b0e6a40fb955ab86 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240705093118 LGD_PCANCELSTR = 0 LGD_BUYER = 케이피엘산업개발 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240705093117FhbX9 LGD_BUYERID = LGD_OID = Direct-kpl7789-1720139328 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5093117F7Ar7 ========================2024-07-05 09:30:03======================== insert into mBoard_order set rOrdNo = 'Direct-kpl7789-1720139328', AuthTy = 'card', memberId = 'kpl7789', OrdNm ='케이피엘산업개발', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)케이피엘산업개발', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민VISA 42658695****989*', rApprNo = 'mjsof20240705093117FhbX9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 09:30:03', InvoiceNum = '결제성공:Direct-kpl7789-1720139328/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-05 09:30:03' ========================2024-07-05 09:30:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705093117FhbX9' 0 = 1 cnt = 1 ========================2024-07-05 09:30:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kpl7789' 0 = kpl7789 Mid = kpl7789 1 = (유)케이피엘산업개발 Mcompany = (유)케이피엘산업개발 2 = 884-81-03364 companyNum = 884-81-03364 3 = 010-9438-7789 Mtel1 = 010-9438-7789 4 = 010-9438-7789 Mhp = 010-9438-7789 ========================2024-07-05 09:30:03======================== select * from customers where id = 'kpl7789' ========================2024-07-05 09:30:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kpl7789','2024-07-05 09:30:03','30900','33000','온라인','0') ========================2024-07-05 10:31:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1720143045 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705103045 LGD_HASHDATA = a002a615717c5cdd0586ef984b2408b6 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 = 20240705103255DD20831C1A01A7876F0D94B9EF01DC883C8C2ACB Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-07-05 10:31:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240705103256 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr 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 = 66841409 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dc0eb6354eee785d9178901c62be940c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240705103256 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240705103255Dgy80 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1720143045 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5103255DXrw2 ========================2024-07-05 10:31:41======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1720143045', 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 = 'mjsof20240705103255Dgy80', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 10:31:41', InvoiceNum = '결제성공:Direct-mmthcoffee-1720143045/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-07-05 10:31:41' ========================2024-07-05 10:31:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705103255Dgy80' 0 = 1 cnt = 1 ========================2024-07-05 10:31:41======================== 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 ========================2024-07-05 10:31:41======================== select * from customers where id = 'mmthcoffee' ========================2024-07-05 10:31:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-07-05 10:31:41','220000','220000','온라인','0') ========================2024-07-05 10:32:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1720143122 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705103202 LGD_HASHDATA = e95186566640c314db2836e5937a18c4 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 = 20240705103343C727A63C15474A45B81E3EAB5922EAD24386A7E0 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-07-05 10:32:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240705103343 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr 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 = 66844174 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f49085ce0406787a6c58df7f1f23a25b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240705103344 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240705103343DgIU8 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1720143122 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5103343DXuD5 ========================2024-07-05 10:32:29======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1720143122', 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 = 'mjsof20240705103343DgIU8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 10:32:29', InvoiceNum = '결제성공:Direct-mmthcoffee-1720143122/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-07-05 10:32:29' ========================2024-07-05 10:32:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705103343DgIU8' 0 = 1 cnt = 1 ========================2024-07-05 10:32:29======================== 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 ========================2024-07-05 10:32:29======================== select * from customers where id = 'mmthcoffee' ========================2024-07-05 10:32:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-07-05 10:32:29','220000','220000','온라인','0') ========================2024-07-05 13:41:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kook21-1720154405 LGD_BUYER = 황종국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705134005 LGD_HASHDATA = 962761bb11e9d6cdd9f83bddfe69db33 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 = 20240705134303EFCF9597CDFC3F2B8BF5D7646EE1AE63734AE0BD Mname = 황종국 Mcompany = 채운 영농조합법인 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kook21 LGD_ESCROW_USEYN = N ========================2024-07-05 13:41:50======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20240705134305 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 = 220000 LGD_FINANCECODE = 075098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 7f89fd0022ef9385f81dd1fe5bdf00ba LGD_BUYERADDRESS = receiptKind = 1 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20240705134305 LGD_PCANCELSTR = 0 LGD_BUYER = 황종국 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 3984 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20240705134250of640 LGD_BUYERID = LGD_OID = Direct-kook21-1720154405 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-05 13:41:50======================== insert into mBoard_order set rOrdNo = 'Direct-kook21-1720154405', AuthTy = 'card', memberId = 'kook21', OrdNm ='황종국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '채운 영농조합법인', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20240705134250of640', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 13:41:50', InvoiceNum = '결제성공:Direct-kook21-1720154405/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-05 13:41:50' ========================2024-07-05 13:41:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705134250of640' 0 = 1 cnt = 1 ========================2024-07-05 13:41:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kook21' 0 = kook21 Mid = kook21 1 = 채운 영농조합법인 Mcompany = 채운 영농조합법인 2 = 512-81-19355 companyNum = 512-81-19355 3 = 010-9427-1004 Mtel1 = 010-9427-1004 4 = 010-9427-1004 Mhp = 010-9427-1004 ========================2024-07-05 13:41:51======================== select * from customers where id = 'kook21' ========================2024-07-05 13:41:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kook21','2024-07-05 13:41:50','220000','220000','온라인','0') ========================2024-07-05 13:43:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kook21-1720154538 LGD_BUYER = 황종국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705134218 LGD_HASHDATA = 025b858e49ba438fb602290114e041c1 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 = 2024070513442574A198497337DE9AF50354DC40242D60E4FBEF31 Mname = 황종국 Mcompany = 채운 영농조합법인 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kook21 LGD_ESCROW_USEYN = N ========================2024-07-05 13:43:12======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20240705134426 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 = 220000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 612bec9e514f6b3a730ee4542ebc2a78 LGD_BUYERADDRESS = receiptKind = 1 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20240705134426 LGD_PCANCELSTR = 0 LGD_BUYER = 황종국 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20240705134415kCsE4 LGD_BUYERID = LGD_OID = Direct-kook21-1720154538 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-05 13:43:12======================== insert into mBoard_order set rOrdNo = 'Direct-kook21-1720154538', AuthTy = 'card', memberId = 'kook21', OrdNm ='황종국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '채운 영농조합법인', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20240705134415kCsE4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 13:43:12', InvoiceNum = '결제성공:Direct-kook21-1720154538/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-05 13:43:12' ========================2024-07-05 13:43:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705134415kCsE4' 0 = 1 cnt = 1 ========================2024-07-05 13:43:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kook21' 0 = kook21 Mid = kook21 1 = 채운 영농조합법인 Mcompany = 채운 영농조합법인 2 = 512-81-19355 companyNum = 512-81-19355 3 = 010-9427-1004 Mtel1 = 010-9427-1004 4 = 010-9427-1004 Mhp = 010-9427-1004 ========================2024-07-05 13:43:12======================== select * from customers where id = 'kook21' ========================2024-07-05 13:43:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kook21','2024-07-05 13:43:12','220000','220000','온라인','0') ========================2024-07-05 15:50:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lims6449-1720162134 LGD_BUYER = 임석원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240705154854 LGD_HASHDATA = 39b26a38bb37704b49be0bc5edd83184 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 = 20240705155117C8513730624D990892FD7DB0AC01BC3A4746EBD0 Mname = 임석원 Mcompany = (주)성화주방 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = lims6449 LGD_ESCROW_USEYN = N ========================2024-07-05 15:50:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240705155118 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 = 94311775****769* LGD_FINANCEAUTHNUM = 66983797 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 0c824ff756923d9ab1317c068ccea036 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240705155119 LGD_PCANCELSTR = 0 LGD_BUYER = 임석원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240705155118D91o2 LGD_BUYERID = LGD_OID = Direct-lims6449-1720162134 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-05 15:50:04======================== insert into mBoard_order set rOrdNo = 'Direct-lims6449-1720162134', AuthTy = 'card', memberId = 'lims6449', OrdNm ='임석원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)성화주방', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH 94311775****769*', rApprNo = 'mjsof20240705155118D91o2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-05 15:50:04', InvoiceNum = '결제성공:Direct-lims6449-1720162134/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-05 15:50:04' ========================2024-07-05 15:50:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240705155118D91o2' 0 = 1 cnt = 1 ========================2024-07-05 15:50:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lims6449' 0 = lims6449 Mid = lims6449 1 = (주)성화주방 Mcompany = (주)성화주방 2 = 8378801961 companyNum = 8378801961 3 = 061-287-6565 Mtel1 = 061-287-6565 4 = 010-6240-8836 Mhp = 010-6240-8836 ========================2024-07-05 15:50:04======================== select * from customers where id = 'lims6449' ========================2024-07-05 15:50:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lims6449','2024-07-05 15:50:04','30900','33000','온라인','0')