========================2025-04-03 10:10:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woomin-1743642508 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250403100828 LGD_HASHDATA = 47aecf538fcf24c09aca6d789bbe9e29 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 = 20250403101326A5E4E4307547D284218FC4945F8D41FC0452D586 Mname = 김성용 Mcompany = 우민전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woomin LGD_ESCROW_USEYN = N ========================2025-04-03 10:10:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250403101327 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woomincorp@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****083* LGD_FINANCEAUTHNUM = 40068842 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4daba80ef4f2f1b5905508c58bf4ee78 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250403101327 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250403101327Dbcd1 LGD_BUYERID = LGD_OID = Direct-woomin-1743642508 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3101327DZGr5 ========================2025-04-03 10:10:53======================== insert into mBoard_order set rOrdNo = 'Direct-woomin-1743642508', AuthTy = 'card', memberId = 'woomin', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****083*', rApprNo = 'mjsof20250403101327Dbcd1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-03 10:10:53', InvoiceNum = '결제성공:Direct-woomin-1743642508/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-03 10:10:53' ========================2025-04-03 10:10:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250403101327Dbcd1' 0 = 1 cnt = 1 ========================2025-04-03 10:10:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woomin' 0 = woomin Mid = woomin 1 = 우민전기 Mcompany = 우민전기 2 = 6032966520 companyNum = 6032966520 3 = 051-262-6806 Mtel1 = 051-262-6806 4 = 011-262-6801 Mhp = 011-262-6801 ========================2025-04-03 10:10:53======================== select * from customers where id = 'woomin' ========================2025-04-03 10:10:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woomin','2025-04-03 10:10:53','220000','220000','온라인','0') ========================2025-04-03 12:03:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1743649307 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250403120147 LGD_HASHDATA = 59b036287485ea05701e3e1265e74fc2 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 = 202504031205516EED1E2327AD04FB474BFE5D45275CEA561100F5 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-04-03 12:03:17======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20250403120552 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 = cfe8b5143b4e927e0bb7a6fd018c2f3f LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20250403120552 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20250403120515ucq28 LGD_BUYERID = LGD_OID = Direct-mail2020-1743649307 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-03 12:03:17======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1743649307', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20250403120515ucq28', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-03 12:03:17', InvoiceNum = '결제성공:Direct-mail2020-1743649307/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-03 12:03:17' ========================2025-04-03 12:03:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250403120515ucq28' 0 = 1 cnt = 1 ========================2025-04-03 12:03:18======================== 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-04-03 12:03:18======================== select * from customers where id = 'mail2020' ========================2025-04-03 12:03:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2025-04-03 12:03:17','10000','11000','온라인','0') ========================2025-04-03 13:09:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-poweroioi-1743653322 LGD_BUYER = 김원석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250403130842 LGD_HASHDATA = 43e9cb8289b19695f5c48211bbab1bfd 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 = 2025040313115412671B74F1C958C30CA47401965A300A9C469F0F Mname = 김원석 Mcompany = (주)다사랑아이엔씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = poweroioi LGD_ESCROW_USEYN = N ========================2025-04-03 13:09:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250403131154 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dasaranginc@daum.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658675****901* LGD_FINANCEAUTHNUM = 30033987 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ce2053e2a021f81d698de0a89eddbbc LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250403131154 LGD_PCANCELSTR = 0 LGD_BUYER = 김원석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250403131154EpQU0 LGD_BUYERID = LGD_OID = Direct-poweroioi-1743653322 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-04-03 13:09:20======================== insert into mBoard_order set rOrdNo = 'Direct-poweroioi-1743653322', AuthTy = 'card', memberId = 'poweroioi', OrdNm ='김원석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다사랑아이엔씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 42658675****901*', rApprNo = 'mjsof20250403131154EpQU0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-03 13:09:20', InvoiceNum = '결제성공:Direct-poweroioi-1743653322/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-03 13:09:20' ========================2025-04-03 13:09:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250403131154EpQU0' 0 = 1 cnt = 1 ========================2025-04-03 13:09:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'poweroioi' 0 = poweroioi Mid = poweroioi 1 = (주)다사랑아이엔씨 Mcompany = (주)다사랑아이엔씨 2 = 1388603820 companyNum = 1388603820 3 = 010-3017-3597 Mtel1 = 010-3017-3597 4 = 010-3017-3597 Mhp = 010-3017-3597 ========================2025-04-03 13:09:20======================== select * from customers where id = 'poweroioi' ========================2025-04-03 13:09:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('poweroioi','2025-04-03 13:09:20','52500','55000','온라인','0') ========================2025-04-03 14:26:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ad9737108-1743657978 LGD_BUYER = 안현기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250403142618 LGD_HASHDATA = adeb498d4c58b9df2ab8b44bba6d4011 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 = 2025040314292742A3F7D4F27537DB88B6299ED546CB43FFF355C3 Mname = 안현기 Mcompany = 에이디바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ad9737108 LGD_ESCROW_USEYN = N ========================2025-04-03 14:26:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250403142928 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 835331 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55908400****007* LGD_FINANCEAUTHNUM = 42096453 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 05736421a9b4040e92f7a70dc5d74f09 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250403142928 LGD_PCANCELSTR = 0 LGD_BUYER = 안현기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250403142927B47f5 LGD_BUYERID = LGD_OID = Direct-ad9737108-1743657978 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3142927BFuk4 ========================2025-04-03 14:26:54======================== insert into mBoard_order set rOrdNo = 'Direct-ad9737108-1743657978', AuthTy = 'card', memberId = 'ad9737108', OrdNm ='안현기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '에이디바이오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55908400****007*', rApprNo = 'mjsof20250403142927B47f5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-03 14:26:54', InvoiceNum = '결제성공:Direct-ad9737108-1743657978/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-03 14:26:54' ========================2025-04-03 14:26:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250403142927B47f5' 0 = 1 cnt = 1 ========================2025-04-03 14:26:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ad9737108' 0 = ad9737108 Mid = ad9737108 1 = 에이디바이오 Mcompany = 에이디바이오 2 = 3170462353 companyNum = 3170462353 3 = 043-241-3349 Mtel1 = 043-241-3349 4 = 010-3408-0725 Mhp = 010-3408-0725 ========================2025-04-03 14:26:54======================== select * from customers where id = 'ad9737108' ========================2025-04-03 14:26:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ad9737108','2025-04-03 14:26:54','108000','110000','온라인','0') ========================2025-04-03 17:45:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1743669882 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250403174442 LGD_HASHDATA = 27519dcdef9adf72ce60b653be82c3b8 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 = 2025040317475941F78D1517FE54188BC150CE131F8E861F7798C5 Mname = 이정훈 Mcompany = (주)신협상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yhk8100 LGD_ESCROW_USEYN = N ========================2025-04-03 17:45:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250403174800 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300320****092* LGD_FINANCEAUTHNUM = 43297851 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec626d1da389f697609fdd6af15b65f3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250403174801 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250403174800BnM19 LGD_BUYERID = LGD_OID = Direct-yhk8100-1743669882 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3174800BNJH9 ========================2025-04-03 17:45:26======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1743669882', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300320****092*', rApprNo = 'mjsof20250403174800BnM19', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-04-03 17:45:26', InvoiceNum = '결제성공:Direct-yhk8100-1743669882/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-04-03 17:45:26' ========================2025-04-03 17:45:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250403174800BnM19' 0 = 1 cnt = 1 ========================2025-04-03 17:45:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yhk8100' 0 = yhk8100 Mid = yhk8100 1 = (주)신협상사 Mcompany = (주)신협상사 2 = 1288158323 companyNum = 1288158323 3 = 02-381-8100 Mtel1 = 02-381-8100 4 = 010-6364-5451 Mhp = 010-6364-5451 ========================2025-04-03 17:45:26======================== select * from customers where id = 'yhk8100' ========================2025-04-03 17:45:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2025-04-03 17:45:26','52500','55000','온라인','0') ========================2025-04-03 19:47:49======================== res_start ========================2025-04-03 19:47:49======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다.