========================2024-04-05 02:07:26======================== res_start ========================2024-04-05 02:07:26======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-04-05 08:00:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woomin-1712271578 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405075938 LGD_HASHDATA = 4d8c39137d4dc2aa107fe21c2868bb85 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 = 20240405080623C7109022834FE0187D222F39BA0B6C86611A153F 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 ========================2024-04-05 08:00:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405080623 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 = 739025 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****126* LGD_FINANCEAUTHNUM = 50325047 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 880154aa5da993c9f69da3485452d114 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240405080624 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240405080623ikzA6 LGD_BUYERID = LGD_OID = Direct-woomin-1712271578 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5080623imuE8 ========================2024-04-05 08:00:38======================== insert into mBoard_order set rOrdNo = 'Direct-woomin-1712271578', AuthTy = 'card', memberId = 'woomin', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****126*', rApprNo = 'mjsof20240405080623ikzA6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 08:00:38', InvoiceNum = '결제성공:Direct-woomin-1712271578/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 08:00:38' ========================2024-04-05 08:00:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240405080623ikzA6' 0 = 1 cnt = 1 ========================2024-04-05 08:00:39======================== 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 ========================2024-04-05 08:00:39======================== select * from customers where id = 'woomin' ========================2024-04-05 08:00:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woomin','2024-04-05 08:00:38','220000','220000','온라인','0') ========================2024-04-05 10:14:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1712279275 LGD_BUYER = 이경원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405100755 LGD_HASHDATA = 4a41bc704502aff99661283a6af638da 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 = 2024040510200116A1346E2CC9D8B6A750F4CAEA5D18C121657C57 Mname = 이경원 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2024-04-05 10:14:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405102002 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jaicandoit@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****181* LGD_FINANCEAUTHNUM = 30116509 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 79fb44e352b0b3712b21769048bb1ded LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240405102002 LGD_PCANCELSTR = 0 LGD_BUYER = 이경원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404051020027KwA4 LGD_BUYERID = LGD_OID = Direct-uksung1966-1712279275 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 510200274ws8 ========================2024-04-05 10:14:17======================== insert into mBoard_order set rOrdNo = 'Direct-uksung1966-1712279275', AuthTy = 'card', memberId = 'uksung1966', OrdNm ='이경원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '욱성화학공업사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****181*', rApprNo = 'mjsof202404051020027KwA4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 10:14:17', InvoiceNum = '결제성공:Direct-uksung1966-1712279275/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 10:14:17' ========================2024-04-05 10:14:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404051020027KwA4' 0 = 1 cnt = 1 ========================2024-04-05 10:14:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'uksung1966' 0 = uksung1966 Mid = uksung1966 1 = 욱성화학공업사 Mcompany = 욱성화학공업사 2 = 113-05-62312 companyNum = 113-05-62312 3 = 031-949-4516 Mtel1 = 031-949-4516 4 = 010-4749-2036 Mhp = 010-4749-2036 ========================2024-04-05 10:14:17======================== select * from customers where id = 'uksung1966' ========================2024-04-05 10:14:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('uksung1966','2024-04-05 10:14:17','220000','220000','온라인','0') ========================2024-04-05 11:03:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goong51189-1712282061 LGD_BUYER = 공부남 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405105421 LGD_HASHDATA = c2fdf457aa1e053d471b7323011722e8 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 = 2024040511093746097753E3F2D1F8AFBA509891A47505A7485597 Mname = 공부남 Mcompany = 알핀코리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = goong51189 LGD_ESCROW_USEYN = N ========================2024-04-05 11:03:52======================== xpay_res LGD_CASTAMOUNT = 0 LGD_BUYERPHONE = LGD_PAYDATE = 20240405110937 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0040 LGD_ACCOUNTNUM = 79019637981522 LGD_CASSEQNO = 000 LGD_RECEIVERPHONE = LGD_IFOS = 406C0C LGD_CASHRECEIPTKIND = 1 LGD_RESPMSG = 11: LGD_2TR_FLAG = Y LGD_PAYER = 공부남 LGD_CASFLAG = R LGD_ESCROWYN = N LGD_FINANCECODE = 011 LGD_CASHRECEIPTCODE = 0000 LGD_HASHDATA = 92564bd7d89f1e2fe35e1458f93fa4c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 농협 LGD_ACCOUNT_TYPE = 0 LGD_DEVICE = LGD_TIMESTAMP = 20240405110937 LGD_BUYER = 공부남 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = . LGD_PRODUCTCODE = LGD_TID = mjsof202404051109371v3p5 LGD_BUYERID = LGD_OID = Direct-goong51189-1712282061 LGD_RESPCODE = 0000 LGD_CASCAMOUNT = 0 LGD_AMOUNT = 55000 LGD_SAOWNER = 엠제이소프트 LGD_MID = mjsoft007 ========================2024-04-05 11:25:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1712283858 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405112418 LGD_HASHDATA = 7eb126992d1bf33fc4c3a74b3f133f7c 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 = 2024040511304975105225551AFAB7427097E71999313BB180A293 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-04-05 11:25:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405113049 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 = 51632150 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ae947242243905dd3babf18e3281d903 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240405113050 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240405113049Z2wf7 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1712283858 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5113049Zom44 ========================2024-04-05 11:25:05======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1712283858', 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 = 'mjsof20240405113049Z2wf7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 11:25:05', InvoiceNum = '결제성공:Direct-mmthcoffee-1712283858/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-04-05 11:25:05' ========================2024-04-05 11:25:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240405113049Z2wf7' 0 = 1 cnt = 1 ========================2024-04-05 11:25:05======================== 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-04-05 11:25:05======================== select * from customers where id = 'mmthcoffee' ========================2024-04-05 11:25:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-04-05 11:25:05','220000','220000','온라인','0') ========================2024-04-05 11:25:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1712283926 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405112526 LGD_HASHDATA = eed16224b506c8e51b197aab83ca60f6 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 = 20240405113140112D17718B816706528FFB609732DDF12684B29E 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-04-05 11:25:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405113140 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 = 51635144 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fab33ada10f3bcd9ceae96a90912268a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240405113141 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404051131405dyr7 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1712283926 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51131405RUc6 ========================2024-04-05 11:25:56======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1712283926', 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 = 'mjsof202404051131405dyr7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 11:25:56', InvoiceNum = '결제성공:Direct-mmthcoffee-1712283926/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-04-05 11:25:56' ========================2024-04-05 11:25:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404051131405dyr7' 0 = 1 cnt = 1 ========================2024-04-05 11:25:56======================== 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-04-05 11:25:56======================== select * from customers where id = 'mmthcoffee' ========================2024-04-05 11:25:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-04-05 11:25:56','220000','220000','온라인','0') ========================2024-04-05 12:52:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1712289051 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405125051 LGD_HASHDATA = d0e8d53a0fcad2135c21911ae824841c 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 = 2024040512581034060CC776737C9291DF617F13F990112DA4F85D 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 ========================2024-04-05 12:52:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405125810 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 = 51883168****558* LGD_FINANCEAUTHNUM = 94690925 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 892cff5dc5bb695ece043c07053b7eec LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240405125811 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024040512581008gK0 LGD_BUYERID = LGD_OID = Direct-mail2020-1712289051 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-05 12:52:25======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1712289051', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성MASTER 51883168****558*', rApprNo = 'mjsof2024040512581008gK0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 12:52:25', InvoiceNum = '결제성공:Direct-mail2020-1712289051/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 12:52:25' ========================2024-04-05 12:52:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024040512581008gK0' 0 = 1 cnt = 1 ========================2024-04-05 12:52:26======================== 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 ========================2024-04-05 12:52:26======================== select * from customers where id = 'mail2020' ========================2024-04-05 12:52:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2024-04-05 12:52:25','10000','11000','온라인','0') ========================2024-04-05 14:38:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1712295432 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405143712 LGD_HASHDATA = 5d8385b45dd155dd94a5f263a0e9e462 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 = 20240405144354FA0B1AFE060D270EC0916AF32D7818387D97EFBA Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2024-04-05 14:38:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405144355 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658696****764* LGD_FINANCEAUTHNUM = 30056282 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 13bf39cfae3667cd1267a180dc9bbdb1 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240405144355 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240405144355ZpXL5 LGD_BUYERID = LGD_OID = Direct-davis747-1712295432 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5144355Zvk15 ========================2024-04-05 14:38:10======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1712295432', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658696****764*', rApprNo = 'mjsof20240405144355ZpXL5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 14:38:10', InvoiceNum = '결제성공:Direct-davis747-1712295432/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 14:38:10' ========================2024-04-05 14:38:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240405144355ZpXL5' 0 = 1 cnt = 1 ========================2024-04-05 14:38:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2024-04-05 14:38:10======================== select * from customers where id = 'davis747' ========================2024-04-05 14:38:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2024-04-05 14:38:10','108000','110000','온라인','0') ========================2024-04-05 14:55:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hd9999-1712296306 LGD_BUYER = 정신유 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405145146 LGD_HASHDATA = 971e126a201781c7dc556ba05ac61708 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 = 20240405150137228AF11AE91A22DFCAC433105C546AA90733FDB8 Mname = 정신유 Mcompany = (주)건우씨엔엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hd9999 LGD_ESCROW_USEYN = N ========================2024-04-05 14:55:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405150138 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 = 55873800****584* LGD_FINANCEAUTHNUM = 33591000 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = df5178d8110a0fa6581c56e834d1f31d LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240405150138 LGD_PCANCELSTR = 0 LGD_BUYER = 정신유 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404051501387kDj7 LGD_BUYERID = LGD_OID = Direct-hd9999-1712296306 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-04-05 14:55:53======================== insert into mBoard_order set rOrdNo = 'Direct-hd9999-1712296306', AuthTy = 'card', memberId = 'hd9999', OrdNm ='정신유', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)건우씨엔엠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '하나MASTER 55873800****584*', rApprNo = 'mjsof202404051501387kDj7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 14:55:53', InvoiceNum = '결제성공:Direct-hd9999-1712296306/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 14:55:53' ========================2024-04-05 14:55:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404051501387kDj7' 0 = 1 cnt = 1 ========================2024-04-05 14:55:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hd9999' 0 = HD9999 Mid = HD9999 1 = (주)건우씨엔엠 Mcompany = (주)건우씨엔엠 2 = 342-86-01493 companyNum = 342-86-01493 3 = 053-851-9760 Mtel1 = 053-851-9760 4 = 010-3827-9643 Mhp = 010-3827-9643 ========================2024-04-05 14:55:53======================== select * from customers where id = 'hd9999' ========================2024-04-05 14:55:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hd9999','2024-04-05 14:55:53','108000','110000','온라인','0') ========================2024-04-05 15:41:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dhhousing1-1712299268 LGD_BUYER = 서태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240405154108 LGD_HASHDATA = 7bdbb237e8355d76653dd7247e1805cd 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 = 2024040515472198CE6543EBB2481E1EA7A163CEB9AF8C331A1456 Mname = 서태화 Mcompany = (주)디에이치하우징 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dhhousing1 LGD_ESCROW_USEYN = N ========================2024-04-05 15:41:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240405154722 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 41400307****698* LGD_FINANCEAUTHNUM = 54261153 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e87866686aa09ef3132d714805142b16 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240405154722 LGD_PCANCELSTR = 0 LGD_BUYER = 서태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202404051547217qqq2 LGD_BUYERID = LGD_OID = Direct-dhhousing1-1712299268 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 51547217h2r9 ========================2024-04-05 15:41:37======================== insert into mBoard_order set rOrdNo = 'Direct-dhhousing1-1712299268', AuthTy = 'card', memberId = 'dhhousing1', OrdNm ='서태화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에이치하우징', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****698*', rApprNo = 'mjsof202404051547217qqq2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-04-05 15:41:37', InvoiceNum = '결제성공:Direct-dhhousing1-1712299268/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-04-05 15:41:37' ========================2024-04-05 15:41:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202404051547217qqq2' 0 = 1 cnt = 1 ========================2024-04-05 15:41:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dhhousing1' 0 = dhhousing1 Mid = dhhousing1 1 = (주)디에이치하우징 Mcompany = (주)디에이치하우징 2 = 1358186545 companyNum = 1358186545 3 = 031-695-5977 Mtel1 = 031-695-5977 4 = 010-5115-1221 Mhp = 010-5115-1221 ========================2024-04-05 15:41:37======================== select * from customers where id = 'dhhousing1' ========================2024-04-05 15:41:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dhhousing1','2024-04-05 15:41:37','52500','55000','온라인','0')