========================2025-03-05 08:22:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1741130511 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305082151 LGD_HASHDATA = ebe24cb7ea5a98c2c16e6db21aa4b6f5 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 = 20250305082430B37D0BECCDFE0E997D783D98D06FDCC5C3C2F4C4 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-03-05 08:22:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305082431 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 = 94301703****448* LGD_FINANCEAUTHNUM = 53923871 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3918315dbc2c4bcd28e147ef7b6de56e LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250305082431 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250305082430qT9z3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1741130511 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 08:22:30======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1741130511', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20250305082430qT9z3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 08:22:30', InvoiceNum = '결제성공:Direct-goodssal5707-1741130511/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 08:22:30' ========================2025-03-05 08:22:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305082430qT9z3' 0 = 1 cnt = 1 ========================2025-03-05 08:22:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-03-05 08:22:30======================== select * from customers where id = 'goodssal5707' ========================2025-03-05 08:22:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-03-05 08:22:30','220000','220000','온라인','0') ========================2025-03-05 08:24:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodfood2023-1741130613 LGD_BUYER = 최상용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305082333 LGD_HASHDATA = f48808e8533c9055464746df751198ea 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 = 20250305082634A7725DEDAC22A379767248834D24EAD84ED82943 Mname = 최상용 Mcompany = 좋은푸드컬리주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = goodfood2023 LGD_ESCROW_USEYN = N ========================2025-03-05 08:24:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305082635 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****697* LGD_FINANCEAUTHNUM = 62416244 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 869c8d0268f7331d9ce0a8b2e10c2773 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305082635 LGD_PCANCELSTR = 0 LGD_BUYER = 최상용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250305082635vxrg2 LGD_BUYERID = LGD_OID = Direct-goodfood2023-1741130613 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5082635vu3w8 ========================2025-03-05 08:24:34======================== insert into mBoard_order set rOrdNo = 'Direct-goodfood2023-1741130613', AuthTy = 'card', memberId = 'goodfood2023', OrdNm ='최상용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '좋은푸드컬리주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****697*', rApprNo = 'mjsof20250305082635vxrg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 08:24:34', InvoiceNum = '결제성공:Direct-goodfood2023-1741130613/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 08:24:34' ========================2025-03-05 08:24:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305082635vxrg2' 0 = 1 cnt = 1 ========================2025-03-05 08:24:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodfood2023' 0 = goodfood2023 Mid = goodfood2023 1 = 좋은푸드컬리주식회사 Mcompany = 좋은푸드컬리주식회사 2 = 112-86-02741 companyNum = 112-86-02741 3 = 010-8880-9146 Mtel1 = 010-8880-9146 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-03-05 08:24:34======================== select * from customers where id = 'goodfood2023' ========================2025-03-05 08:24:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodfood2023','2025-03-05 08:24:34','52500','55000','온라인','0') ========================2025-03-05 09:56:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1741136168 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305095608 LGD_HASHDATA = 5daf69ea557323b34999ae49ba05c670 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 = 2025030509585552E654880EDB9CA2C445ACAF106B96C880E40642 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-03-05 09:56:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305095855 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 = 94301703****448* LGD_FINANCEAUTHNUM = 54589540 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b016ed6e55dade8a8effc4a333beb964 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250305095856 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2025030509585564cF1 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1741136168 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 09:56:54======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1741136168', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof2025030509585564cF1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 09:56:54', InvoiceNum = '결제성공:Direct-goodssal5707-1741136168/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 09:56:54' ========================2025-03-05 09:56:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025030509585564cF1' 0 = 1 cnt = 1 ========================2025-03-05 09:56:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-03-05 09:56:54======================== select * from customers where id = 'goodssal5707' ========================2025-03-05 09:56:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-03-05 09:56:54','108000','110000','온라인','0') ========================2025-03-05 10:25:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joytomin-1741137626 LGD_BUYER = 박민식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305102026 LGD_HASHDATA = cacbe701c13de2c727a50dc6744efa56 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 = 20250305102752E880DE82D5002D738EE70F61C7AFF6780486B276 Mname = 박민식 Mcompany = 드럼코리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joytomin LGD_ESCROW_USEYN = N ========================2025-03-05 10:25:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305102753 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45995281****558* LGD_FINANCEAUTHNUM = 63211777 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 46100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5393c30236e653fe51b364547320a178 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305102753 LGD_PCANCELSTR = 0 LGD_BUYER = 박민식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20250305102753Zfo31 LGD_BUYERID = LGD_OID = Direct-joytomin-1741137626 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 051027274292 ========================2025-03-05 10:25:52======================== insert into mBoard_order set rOrdNo = 'Direct-joytomin-1741137626', AuthTy = 'card', memberId = 'joytomin', OrdNm ='박민식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '드럼코리아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '광주VISA 45995281****558*', rApprNo = 'mjsof20250305102753Zfo31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 10:25:52', InvoiceNum = '결제성공:Direct-joytomin-1741137626/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 10:25:52' ========================2025-03-05 10:25:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305102753Zfo31' 0 = 1 cnt = 1 ========================2025-03-05 10:25:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joytomin' 0 = joytomin Mid = joytomin 1 = 드럼코리아 Mcompany = 드럼코리아 2 = 4098634531 companyNum = 4098634531 3 = 062-651-9871 Mtel1 = 062-651-9871 4 = 010-8291-0098 Mhp = 010-8291-0098 ========================2025-03-05 10:25:52======================== select * from customers where id = 'joytomin' ========================2025-03-05 10:25:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joytomin','2025-03-05 10:25:52','108000','110000','온라인','0') ========================2025-03-05 11:17:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dae1936-1741140998 LGD_BUYER = 전찬홍 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305111638 LGD_HASHDATA = 06dc90e773e670a28b7b948488295150 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 = 202503051119546857F91DEED4E9AD7CA8640AA7E46C31B5A92D91 Mname = 전찬홍 Mcompany = 대건비니루상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dae1936 LGD_ESCROW_USEYN = N ========================2025-03-05 11:17:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305111955 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 473C0C LGD_AFFILIATECODE = AEA009 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184212****620* LGD_FINANCEAUTHNUM = 44470703 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f981d405d5cc5d9cb0f56a398500417e LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250305111955 LGD_PCANCELSTR = 0 LGD_BUYER = 전찬홍 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503051119556uCy0 LGD_BUYERID = LGD_OID = Direct-dae1936-1741140998 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 11:17:54======================== insert into mBoard_order set rOrdNo = 'Direct-dae1936-1741140998', AuthTy = 'card', memberId = 'dae1936', OrdNm ='전찬홍', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대건비니루상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 45184212****620*', rApprNo = 'mjsof202503051119556uCy0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 11:17:54', InvoiceNum = '결제성공:Direct-dae1936-1741140998/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 11:17:54' ========================2025-03-05 11:17:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503051119556uCy0' 0 = 1 cnt = 1 ========================2025-03-05 11:17:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dae1936' 0 = dae1936 Mid = dae1936 1 = 대건비니루상사 Mcompany = 대건비니루상사 2 = 202-31-60141 companyNum = 202-31-60141 3 = 02-2265-1936 Mtel1 = 02-2265-1936 4 = 010-3920-1936 Mhp = 010-3920-1936 ========================2025-03-05 11:17:54======================== select * from customers where id = 'dae1936' ========================2025-03-05 11:17:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dae1936','2025-03-05 11:17:54','220000','220000','온라인','0') ========================2025-03-05 11:57:24======================== res_start ========================2025-03-05 11:57:24======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. ========================2025-03-05 11:57:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pcwjun-1741143388 LGD_BUYER = 박찬우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305115628 LGD_HASHDATA = e3d17a5b48474caca1f879172c84ce79 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 = 202503051159498372773C04BF08CEDB0E719A116BAD45B5BE4153 Mname = 박찬우 Mcompany = 은성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = pcwjun LGD_ESCROW_USEYN = N ========================2025-03-05 11:57:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305115949 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 = 45749380****670* LGD_FINANCEAUTHNUM = 00922313 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8ddb64fd3463eadfd0a14f37b7291c01 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250305115949 LGD_PCANCELSTR = 0 LGD_BUYER = 박찬우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503051159494GDv7 LGD_BUYERID = LGD_OID = Direct-pcwjun-1741143388 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 11:57:47======================== insert into mBoard_order set rOrdNo = 'Direct-pcwjun-1741143388', AuthTy = 'card', memberId = 'pcwjun', OrdNm ='박찬우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '은성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****670*', rApprNo = 'mjsof202503051159494GDv7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 11:57:47', InvoiceNum = '결제성공:Direct-pcwjun-1741143388/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 11:57:47' ========================2025-03-05 11:57:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503051159494GDv7' 0 = 1 cnt = 1 ========================2025-03-05 11:57:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pcwjun' 0 = pcwjun Mid = pcwjun 1 = 은성유통 Mcompany = 은성유통 2 = 1123048599 companyNum = 1123048599 3 = 010-6674-8808 Mtel1 = 010-6674-8808 4 = 010-6674-8808 Mhp = 010-6674-8808 ========================2025-03-05 11:57:48======================== select * from customers where id = 'pcwjun' ========================2025-03-05 11:57:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pcwjun','2025-03-05 11:57:47','108000','110000','온라인','0') ========================2025-03-05 12:04:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samwon1-1741143761 LGD_BUYER = 이정행 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305120241 LGD_HASHDATA = b431943a167aba2df9c9982524ca12b1 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 = 20250305120640A9D948D1308FE30C843732BC5743AB1A7CE73FC6 Mname = 이정행 Mcompany = (주)삼원무역 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = samwon1 LGD_ESCROW_USEYN = N ========================2025-03-05 12:04:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305120640 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DALC6G LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55315240****910* LGD_FINANCEAUTHNUM = 45136512 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8cb13a29ab192c0a06a09f0ceb2158f1 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250305120640 LGD_PCANCELSTR = 0 LGD_BUYER = 이정행 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503051206400ZWo4 LGD_BUYERID = LGD_OID = Direct-samwon1-1741143761 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 12:04:39======================== insert into mBoard_order set rOrdNo = 'Direct-samwon1-1741143761', AuthTy = 'card', memberId = 'samwon1', OrdNm ='이정행', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)삼원무역', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한MASTER 55315240****910*', rApprNo = 'mjsof202503051206400ZWo4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 12:04:39', InvoiceNum = '결제성공:Direct-samwon1-1741143761/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 12:04:39' ========================2025-03-05 12:04:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503051206400ZWo4' 0 = 1 cnt = 1 ========================2025-03-05 12:04:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samwon1' 0 = samwon1 Mid = samwon1 1 = (주)삼원무역 Mcompany = (주)삼원무역 2 = 129-86-59432 companyNum = 129-86-59432 3 = 031-766-0546 Mtel1 = 031-766-0546 4 = 010-9019-4041 Mhp = 010-9019-4041 ========================2025-03-05 12:04:39======================== select * from customers where id = 'samwon1' ========================2025-03-05 12:04:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samwon1','2025-03-05 12:04:39','108000','110000','온라인','0') ========================2025-03-05 12:23:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hankooksteel-1741144971 LGD_BUYER = 오병준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305122251 LGD_HASHDATA = bbfc5321718700890d40eae77ec3a9a4 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 = 20250305122547D026C6D88E5D49C781F82A2C80BC4BE6E24DA160 Mname = 오병준 Mcompany = (주)조선아이디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hankooksteel LGD_ESCROW_USEYN = N ========================2025-03-05 12:23:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305122547 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hkbill@daum.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62500307****096* LGD_FINANCEAUTHNUM = 63984041 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 32db70bc61048c7e49ff517f7534717f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305122548 LGD_PCANCELSTR = 0 LGD_BUYER = 오병준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503051225476N5b7 LGD_BUYERID = LGD_OID = Direct-hankooksteel-1741144971 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51225476K9Z3 ========================2025-03-05 12:23:46======================== insert into mBoard_order set rOrdNo = 'Direct-hankooksteel-1741144971', AuthTy = 'card', memberId = 'hankooksteel', OrdNm ='오병준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)조선아이디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨CUP 62500307****096*', rApprNo = 'mjsof202503051225476N5b7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 12:23:46', InvoiceNum = '결제성공:Direct-hankooksteel-1741144971/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 12:23:46' ========================2025-03-05 12:23:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503051225476N5b7' 0 = 1 cnt = 1 ========================2025-03-05 12:23:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hankooksteel' 0 = hankooksteel Mid = hankooksteel 1 = (주)조선아이디 Mcompany = (주)조선아이디 2 = 3018600192 companyNum = 3018600192 3 = 043-267-3114 Mtel1 = 043-267-3114 4 = 010-3076-7005 Mhp = 010-3076-7005 ========================2025-03-05 12:23:46======================== select * from customers where id = 'hankooksteel' ========================2025-03-05 12:23:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hankooksteel','2025-03-05 12:23:46','220000','220000','온라인','0') ========================2025-03-05 12:40:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmj-1741145908 LGD_BUYER = 전은탁 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305123828 LGD_HASHDATA = 6bf5cca98c9c5a4799f959be04f9aa62 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 = 20250305124233E87E5347A3AC5981275216B0325B4A0ACCF51367 Mname = 전은탁 Mcompany = 푸드명장 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = foodmj LGD_ESCROW_USEYN = N ========================2025-03-05 12:40:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305124234 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 = 94901925****670* LGD_FINANCEAUTHNUM = 00121682 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6af31b3582b27bb91d77451d2b48e8ee LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20250305124234 LGD_PCANCELSTR = 0 LGD_BUYER = 전은탁 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250305124234XPOR7 LGD_BUYERID = LGD_OID = Direct-foodmj-1741145908 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 12:40:32======================== insert into mBoard_order set rOrdNo = 'Direct-foodmj-1741145908', AuthTy = 'card', memberId = 'foodmj', OrdNm ='전은탁', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '푸드명장', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대 94901925****670*', rApprNo = 'mjsof20250305124234XPOR7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 12:40:32', InvoiceNum = '결제성공:Direct-foodmj-1741145908/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 12:40:32' ========================2025-03-05 12:40:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305124234XPOR7' 0 = 1 cnt = 1 ========================2025-03-05 12:40:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmj' 0 = foodmj Mid = foodmj 1 = 푸드명장 Mcompany = 푸드명장 2 = 5409200672 companyNum = 5409200672 3 = 010-5146-4745 Mtel1 = 010-5146-4745 4 = 010-5146-4745 Mhp = 010-5146-4745 ========================2025-03-05 12:40:32======================== select * from customers where id = 'foodmj' ========================2025-03-05 12:40:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmj','2025-03-05 12:40:32','30900','33000','온라인','0') ========================2025-03-05 13:40:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-offline77-1741149551 LGD_BUYER = 박혜지 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305133911 LGD_HASHDATA = f0237c812eb957d489bd38531459d0b9 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 = 202503051342273FEC628894089CC05DB1E6A4AC49318108CC08DC Mname = 박혜지 Mcompany = (주)오프라인 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = offline77 LGD_ESCROW_USEYN = N ========================2025-03-05 13:40:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305134228 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94303255****544* LGD_FINANCEAUTHNUM = 64518427 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e608834d2164da21a9d429ff5862817a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305134228 LGD_PCANCELSTR = 0 LGD_BUYER = 박혜지 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250305134228680y6 LGD_BUYERID = LGD_OID = Direct-offline77-1741149551 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51342286Qbj9 ========================2025-03-05 13:40:26======================== insert into mBoard_order set rOrdNo = 'Direct-offline77-1741149551', AuthTy = 'card', memberId = 'offline77', OrdNm ='박혜지', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)오프라인', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94303255****544*', rApprNo = 'mjsof20250305134228680y6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 13:40:26', InvoiceNum = '결제성공:Direct-offline77-1741149551/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 13:40:26' ========================2025-03-05 13:40:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305134228680y6' 0 = 1 cnt = 1 ========================2025-03-05 13:40:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'offline77' 0 = offline77 Mid = offline77 1 = (주)오프라인 Mcompany = (주)오프라인 2 = 6218174220 companyNum = 6218174220 3 = 051-515-3721 Mtel1 = 051-515-3721 4 = 010-2507-8015 Mhp = 010-2507-8015 ========================2025-03-05 13:40:27======================== select * from customers where id = 'offline77' ========================2025-03-05 13:40:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('offline77','2025-03-05 13:40:26','52500','55000','온라인','0') ========================2025-03-05 14:12:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1741151486 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305141126 LGD_HASHDATA = f6e333a5fa9ea907c722f7fc4647ef24 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 = 20250305141415F6DB5700F223F3054C18E9316716E95A207F1EAA Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = support@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2025-03-05 14:12:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305141416 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@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 = 65006383 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9e5eb9b88d583c679dbe9b4e2b113dd8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305141416 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250305141415ZhEu8 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1741151486 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5141415Z4J62 ========================2025-03-05 14:12:14======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1741151486', 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 = 'mjsof20250305141415ZhEu8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 14:12:14', InvoiceNum = '결제성공:Direct-mmthcoffee-1741151486/0000', Deliver = '', senditem = 'support@mmth.co.kr', salestopvalue = '', mod_date = '2025-03-05 14:12:14' ========================2025-03-05 14:12:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305141415ZhEu8' 0 = 1 cnt = 1 ========================2025-03-05 14:12:15======================== 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-03-05 14:12:15======================== select * from customers where id = 'mmthcoffee' ========================2025-03-05 14:12:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2025-03-05 14:12:14','220000','220000','온라인','0') ========================2025-03-05 14:12:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1741151546 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305141226 LGD_HASHDATA = 1b5b6c250d7f0c27efb355f86fb1b688 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 = 2025030514145554F6BA5DB6AB8B8CBBED7DFE2E3F70D7963EB8B8 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-03-05 14:12:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305141456 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@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 = 65008350 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9cfc055a7e375c3e1db1da6c55bf9daf LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250305141456 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202503051414550yvf3 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1741151546 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51414550Yva2 ========================2025-03-05 14:12:55======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1741151546', 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 = 'mjsof202503051414550yvf3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 14:12:55', InvoiceNum = '결제성공:Direct-mmthcoffee-1741151546/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 14:12:55' ========================2025-03-05 14:12:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202503051414550yvf3' 0 = 1 cnt = 1 ========================2025-03-05 14:12:55======================== 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-03-05 14:12:55======================== select * from customers where id = 'mmthcoffee' ========================2025-03-05 14:12:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2025-03-05 14:12:55','220000','220000','온라인','0') ========================2025-03-05 19:32:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakeryall-1741170689 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250305193129 LGD_HASHDATA = 96fcdf10b15f1683710eff9657c8e30c 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 = 202503051934351E40E3A4BFAE104DBD1281846EDB458E0C359D75 Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bakeryall LGD_ESCROW_USEYN = N ========================2025-03-05 19:32:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250305193436 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****938* LGD_FINANCEAUTHNUM = 01583950 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fb6705154321de577d494e08f6a53d2d LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250305193436 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20250305193435Zye93 LGD_BUYERID = LGD_OID = Direct-bakeryall-1741170689 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-03-05 19:32:34======================== insert into mBoard_order set rOrdNo = 'Direct-bakeryall-1741170689', AuthTy = 'card', memberId = 'bakeryall', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20250305193435Zye93', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-03-05 19:32:34', InvoiceNum = '결제성공:Direct-bakeryall-1741170689/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-03-05 19:32:34' ========================2025-03-05 19:32:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250305193435Zye93' 0 = 1 cnt = 1 ========================2025-03-05 19:32:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakeryall' 0 = bakeryall Mid = bakeryall 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2025-03-05 19:32:34======================== select * from customers where id = 'bakeryall' ========================2025-03-05 19:32:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakeryall','2025-03-05 19:32:34','108000','110000','온라인','0')