========================2025-07-10 08:28:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yth3339-1752103586 LGD_BUYER = 유태환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250710082626 LGD_HASHDATA = 7b42aa91f5fb13980c03d56c58c011c8 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 = 2025071008324251A98CCDB671EF422A07E7AB15C2D5118BE5A809 Mname = 유태환 Mcompany = 주식회사 다복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = yth3339 LGD_ESCROW_USEYN = N ========================2025-07-10 08:28:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250710083242 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yth3339@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****011* LGD_FINANCEAUTHNUM = 55479387 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 34f93e6541eac3f00fb592585b9fa754 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250710083243 LGD_PCANCELSTR = 0 LGD_BUYER = 유태환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250710083242aT8x9 LGD_BUYERID = LGD_OID = Direct-yth3339-1752103586 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0083242awrF3 ========================2025-07-10 08:28:16======================== insert into mBoard_order set rOrdNo = 'Direct-yth3339-1752103586', AuthTy = 'card', memberId = 'yth3339', OrdNm ='유태환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 다복유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 91000300****011*', rApprNo = 'mjsof20250710083242aT8x9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-10 08:28:16', InvoiceNum = '결제성공:Direct-yth3339-1752103586/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-10 08:28:16' ========================2025-07-10 08:28:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250710083242aT8x9' 0 = 1 cnt = 1 ========================2025-07-10 08:28:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yth3339' 0 = yth3339 Mid = yth3339 1 = 주식회사 다복유통 Mcompany = 주식회사 다복유통 2 = 5418700763 companyNum = 5418700763 3 = 02-2208-7879 Mtel1 = 02-2208-7879 4 = 010-2679-3339 Mhp = 010-2679-3339 ========================2025-07-10 08:28:17======================== select * from customers where id = 'yth3339' ========================2025-07-10 08:28:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yth3339','2025-07-10 08:28:16','108000','110000','온라인','0') ========================2025-07-10 10:27:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1752110761 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250710102601 LGD_HASHDATA = ac73e00b802e2354d11c415ab35b1006 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 = 202507101031358D0B36EF6D915550256C0B778430DC5A579B3F87 Mname = 이승민 Mcompany = 주식회사 피앤코리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2025-07-10 10:27:09======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20250710103136 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94188171****442* LGD_FINANCEAUTHNUM = 13106401 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 92d8e8cd637ced3ed996dbb4b197c505 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20250710103136 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250710103128eUbQ2 LGD_BUYERID = LGD_OID = Direct-we32-1752110761 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-07-10 10:27:09======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1752110761', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 피앤코리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '하나 94188171****442*', rApprNo = 'mjsof20250710103128eUbQ2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-10 10:27:09', InvoiceNum = '결제성공:Direct-we32-1752110761/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-10 10:27:09' ========================2025-07-10 10:27:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250710103128eUbQ2' 0 = 1 cnt = 1 ========================2025-07-10 10:27:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 주식회사 피앤코리테일 Mcompany = 주식회사 피앤코리테일 2 = 3278802158 companyNum = 3278802158 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2025-07-10 10:27:10======================== select * from customers where id = 'we32' ========================2025-07-10 10:27:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2025-07-10 10:27:09','52500','55000','온라인','0') ========================2025-07-10 10:38:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bada2680-1752111209 LGD_BUYER = 윤주현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250710103329 LGD_HASHDATA = e80b5c1ca334515eb6c38275a45c9d07 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 = 2025071010424451661E90B9B463496218967BDC097996C23ED44D Mname = 윤주현 Mcompany = 식자재DC마트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = 발행삭제한 포인트는 복구가 안되네요 UserId = bada2680 LGD_ESCROW_USEYN = N ========================2025-07-10 10:38:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250710104245 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009063 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797358****027* LGD_FINANCEAUTHNUM = 30019107 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 18ebeb16d9f1740fa08883eaabad78b6 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250710104245 LGD_PCANCELSTR = 0 LGD_BUYER = 윤주현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250710104245i7dN3 LGD_BUYERID = LGD_OID = Direct-bada2680-1752111209 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-07-10 10:38:19======================== insert into mBoard_order set rOrdNo = 'Direct-bada2680-1752111209', AuthTy = 'card', memberId = 'bada2680', OrdNm ='윤주현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '식자재DC마트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 45797358****027*', rApprNo = 'mjsof20250710104245i7dN3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-10 10:38:19', InvoiceNum = '결제성공:Direct-bada2680-1752111209/0000', Deliver = '', senditem = '발행삭제한 포인트는 복구가 안되네요', salestopvalue = '', mod_date = '2025-07-10 10:38:19' ========================2025-07-10 10:38:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250710104245i7dN3' 0 = 1 cnt = 1 ========================2025-07-10 10:38:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bada2680' 0 = bada2680 Mid = bada2680 1 = 식자재DC마트 Mcompany = 식자재DC마트 2 = 1252435497 companyNum = 1252435497 3 = 010-5225-0392 Mtel1 = 010-5225-0392 4 = 010-5225-0392 Mhp = 010-5225-0392 ========================2025-07-10 10:38:19======================== select * from customers where id = 'bada2680' ========================2025-07-10 10:38:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bada2680','2025-07-10 10:38:19','108000','110000','온라인','0') ========================2025-07-10 10:55:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ovistec-1752112407 LGD_BUYER = 남정우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250710105327 LGD_HASHDATA = 387ee1039108659185847b7886c72fee 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 = 202507101100068BB2DCD99B702213D8E075D6D7F365002F3434EA Mname = 남정우 Mcompany = 오비스텍 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = ovistec LGD_ESCROW_USEYN = N ========================2025-07-10 10:55:41======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_POINT LGD_BUYERPHONE = LGD_PAYDATE = 20250710110008 LGD_BUYEREMAIL = nblite@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 = receiptSelf = N LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 30cfeac0809d133613873779a2d315d5 LGD_BUYERADDRESS = receiptKind = 0 LGD_FINANCENAME = 네이버페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250710110008 LGD_PCANCELSTR = 0 LGD_BUYER = 남정우 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250710105944moTC6 LGD_BUYERID = LGD_OID = Direct-ovistec-1752112407 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-07-10 10:55:41======================== insert into mBoard_order set rOrdNo = 'Direct-ovistec-1752112407', AuthTy = 'card', memberId = 'ovistec', OrdNm ='남정우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '오비스텍', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '네이버페이 ', rApprNo = 'mjsof20250710105944moTC6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-10 10:55:41', InvoiceNum = '결제성공:Direct-ovistec-1752112407/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-10 10:55:41' ========================2025-07-10 10:55:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250710105944moTC6' 0 = 1 cnt = 1 ========================2025-07-10 10:55:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ovistec' 0 = ovistec Mid = ovistec 1 = 오비스텍 Mcompany = 오비스텍 2 = 2080816290 companyNum = 2080816290 3 = 010-2861-8623 Mtel1 = 010-2861-8623 4 = -- Mhp = -- ========================2025-07-10 10:55:41======================== select * from customers where id = 'ovistec' ========================2025-07-10 10:55:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ovistec','2025-07-10 10:55:41','10000','11000','온라인','0') ========================2025-07-10 13:51:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-barun0225-1752123069 LGD_BUYER = 조장환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250710135109 LGD_HASHDATA = 98051e7eba2c52fe55a9eb8c8285e841 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 = 202507101356118F0D6469D2F1D8515AE385CEFD78AE6696E050DB Mname = 조장환 Mcompany = 바른식품푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = barun0225 LGD_ESCROW_USEYN = N ========================2025-07-10 13:51:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250710135612 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BA8AZR LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 44991481****064* LGD_FINANCEAUTHNUM = 41471194 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 162340af6cf6be362f20bced0faff201 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250710135613 LGD_PCANCELSTR = 0 LGD_BUYER = 조장환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250710135611jDlY8 LGD_BUYERID = LGD_OID = Direct-barun0225-1752123069 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-07-10 13:51:46======================== insert into mBoard_order set rOrdNo = 'Direct-barun0225-1752123069', AuthTy = 'card', memberId = 'barun0225', OrdNm ='조장환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바른식품푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 44991481****064*', rApprNo = 'mjsof20250710135611jDlY8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-07-10 13:51:46', InvoiceNum = '결제성공:Direct-barun0225-1752123069/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-07-10 13:51:46' ========================2025-07-10 13:51:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250710135611jDlY8' 0 = 1 cnt = 1 ========================2025-07-10 13:51:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'barun0225' 0 = barun0225 Mid = barun0225 1 = 바른식품푸드 Mcompany = 바른식품푸드 2 = 324-03-01793 companyNum = 324-03-01793 3 = 010-5581-2073 Mtel1 = 010-5581-2073 4 = 010 -5581-2073 Mhp = 010 -5581-2073 ========================2025-07-10 13:51:46======================== select * from customers where id = 'barun0225' ========================2025-07-10 13:51:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('barun0225','2025-07-10 13:51:46','220000','220000','온라인','0')