========================2023-11-30 09:44:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-men9579-1701304953 LGD_BUYER = 이정민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130094233 LGD_HASHDATA = 940dc2fa4297b61299bdb7ef6b7a062b 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 = 202311300947493040580EFA2B995594699FE959CB855809C0A9A4 Mname = 이정민 Mcompany = 알리다(천안) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = men9579 LGD_ESCROW_USEYN = N ========================2023-11-30 09:44:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130094750 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 3570424@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37922040****52* LGD_FINANCEAUTHNUM = 27585083 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d4d281911bf906a5a72265c0feab70bd LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20231130094750 LGD_PCANCELSTR = 0 LGD_BUYER = 이정민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231130094750Tzkb1 LGD_BUYERID = LGD_OID = Direct-men9579-1701304953 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 09:44:28======================== insert into mBoard_order set rOrdNo = 'Direct-men9579-1701304953', AuthTy = 'card', memberId = 'men9579', OrdNm ='이정민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '알리다(천안)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데AMEX 37922040****52*', rApprNo = 'mjsof20231130094750Tzkb1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 09:44:28', InvoiceNum = '결제성공:Direct-men9579-1701304953/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 09:44:28' ========================2023-11-30 09:44:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231130094750Tzkb1' 0 = 1 cnt = 1 ========================2023-11-30 09:44:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'men9579' 0 = men9579 Mid = men9579 1 = 알리다(천안) Mcompany = 알리다(천안) 2 = 3128659878 companyNum = 3128659878 3 = 041-551-6844 Mtel1 = 041-551-6844 4 = 010-4434-4846 Mhp = 010-4434-4846 ========================2023-11-30 09:44:28======================== select * from customers where id = 'men9579' ========================2023-11-30 09:44:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('men9579','2023-11-30 09:44:28','220000','220000','온라인','0') ========================2023-11-30 11:04:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kclab-1701309791 LGD_BUYER = 홍성모 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130110311 LGD_HASHDATA = b8a4ca12757027c431c34efa0417e8b3 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 = 202311301108117FDA92D959DB3B045C9F4E23C4B1B8424A0B10E1 Mname = 홍성모 Mcompany = 주식회사케이씨랩그로운다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kclab LGD_ESCROW_USEYN = N ========================2023-11-30 11:04:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130110811 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = account@davisdia.com 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 = 55852694****888* LGD_FINANCEAUTHNUM = 30005613 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b0b0117f876be43ecafe3df0c34902eb LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231130110811 LGD_PCANCELSTR = 0 LGD_BUYER = 홍성모 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301108115rM04 LGD_BUYERID = LGD_OID = Direct-kclab-1701309791 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01108115Jky4 ========================2023-11-30 11:04:49======================== insert into mBoard_order set rOrdNo = 'Direct-kclab-1701309791', AuthTy = 'card', memberId = 'kclab', OrdNm ='홍성모', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사케이씨랩그로운다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****888*', rApprNo = 'mjsof202311301108115rM04', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 11:04:49', InvoiceNum = '결제성공:Direct-kclab-1701309791/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 11:04:49' ========================2023-11-30 11:04:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301108115rM04' 0 = 1 cnt = 1 ========================2023-11-30 11:04:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kclab' 0 = kclab Mid = kclab 1 = 주식회사케이씨랩그로운다이아몬드 Mcompany = 주식회사케이씨랩그로운다이아몬드 2 = 748-87-01892 companyNum = 748-87-01892 3 = 02-766-8787 Mtel1 = 02-766-8787 4 = 010-5477-6018 Mhp = 010-5477-6018 ========================2023-11-30 11:04:49======================== select * from customers where id = 'kclab' ========================2023-11-30 11:04:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kclab','2023-11-30 11:04:49','108000','110000','온라인','0') ========================2023-11-30 13:14:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1701317563 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130131243 LGD_HASHDATA = eaf7e1a04b36d665c11d0aec8bc4f77f 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 = 2023113013181916FF686A98C956AFED62E61DA759DB3290CD1BEE Mname = 박현석 Mcompany = 마니푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = anbinnakdo LGD_ESCROW_USEYN = N ========================2023-11-30 13:14:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130131819 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = phso519@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797316****307* LGD_FINANCEAUTHNUM = 30036759 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b7fa301abcb26449d10405dcf0976aad LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231130131819 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301318199uSs6 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1701317563 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 13:14:56======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1701317563', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797316****307*', rApprNo = 'mjsof202311301318199uSs6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 13:14:56', InvoiceNum = '결제성공:Direct-anbinnakdo-1701317563/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 13:14:56' ========================2023-11-30 13:14:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301318199uSs6' 0 = 1 cnt = 1 ========================2023-11-30 13:14:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'anbinnakdo' 0 = anbinnakdo Mid = anbinnakdo 1 = 마니푸드 Mcompany = 마니푸드 2 = 121-20-60884 companyNum = 121-20-60884 3 = 070-4082-2105 Mtel1 = 070-4082-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2023-11-30 13:14:56======================== select * from customers where id = 'anbinnakdo' ========================2023-11-30 13:14:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2023-11-30 13:14:56','52500','55000','온라인','0') ========================2023-11-30 14:10:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kukje9156-1701321012 LGD_BUYER = 조윤영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130141012 LGD_HASHDATA = 2e65db8d9786eb08b09596f89daa8935 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 = 2023113014141016FFECFA129C5293F96096C67490A4B778F74F0A Mname = 조윤영 Mcompany = 주식회사 국제안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kukje9156 LGD_ESCROW_USEYN = N ========================2023-11-30 14:10:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130141411 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 55852694****081* LGD_FINANCEAUTHNUM = 30026340 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3fc92355be17f1ab3e8850203c61e4e0 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231130141411 LGD_PCANCELSTR = 0 LGD_BUYER = 조윤영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231130141411a0po4 LGD_BUYERID = LGD_OID = Direct-kukje9156-1701321012 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0141411aoWr9 ========================2023-11-30 14:10:48======================== insert into mBoard_order set rOrdNo = 'Direct-kukje9156-1701321012', AuthTy = 'card', memberId = 'kukje9156', OrdNm ='조윤영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 국제안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****081*', rApprNo = 'mjsof20231130141411a0po4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 14:10:48', InvoiceNum = '결제성공:Direct-kukje9156-1701321012/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 14:10:48' ========================2023-11-30 14:10:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231130141411a0po4' 0 = 1 cnt = 1 ========================2023-11-30 14:10:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kukje9156' 0 = kukje9156 Mid = kukje9156 1 = 주식회사 국제안전 Mcompany = 주식회사 국제안전 2 = 2068666910 companyNum = 2068666910 3 = 02-469-9156 Mtel1 = 02-469-9156 4 = 010-2013-7302 Mhp = 010-2013-7302 ========================2023-11-30 14:10:48======================== select * from customers where id = 'kukje9156' ========================2023-11-30 14:10:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kukje9156','2023-11-30 14:10:48','108000','110000','온라인','0') ========================2023-11-30 14:31:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1701322242 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130143042 LGD_HASHDATA = 285fc5d8d764ece045456d48c3e114a5 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 = 202311301435116ADA0CB31306C11F4AAED28DC5359124FECDF9CE Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2023-11-30 14:31:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130143512 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = kyg30000@daum.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005759 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353101****671* LGD_FINANCEAUTHNUM = 21269881 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9d75f23cfc84d01e59cedc59e4d7d9fe LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231130143512 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2023113014351274LC8 LGD_BUYERID = LGD_OID = Direct-kyg2031-1701322242 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 301435255822 ========================2023-11-30 14:31:50======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1701322242', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353101****671*', rApprNo = 'mjsof2023113014351274LC8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 14:31:50', InvoiceNum = '결제성공:Direct-kyg2031-1701322242/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 14:31:50' ========================2023-11-30 14:31:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2023113014351274LC8' 0 = 1 cnt = 1 ========================2023-11-30 14:31:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-6796-1030 Mhp = 010-6796-1030 ========================2023-11-30 14:31:50======================== select * from customers where id = 'kyg2031' ========================2023-11-30 14:31:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2023-11-30 14:31:50','52500','55000','온라인','0') ========================2023-11-30 15:01:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yookil34-1701324066 LGD_BUYER = 황준상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130150106 LGD_HASHDATA = 2b0d77a8397a68fb9c2eadbd79731bb7 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 = 20231130150514ABDCC9027F23B09BB517FE0307F4B974CF78BEC4 Mname = 황준상 Mcompany = 주식회사 육일상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yookil34 LGD_ESCROW_USEYN = N ========================2023-11-30 15:01:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130150515 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 = 41400314****492* LGD_FINANCEAUTHNUM = 63704704 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b7d7545985ed4bbe683be001fbaf868f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231130150515 LGD_PCANCELSTR = 0 LGD_BUYER = 황준상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301505158out5 LGD_BUYERID = LGD_OID = Direct-yookil34-1701324066 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01505158dBa6 ========================2023-11-30 15:01:53======================== insert into mBoard_order set rOrdNo = 'Direct-yookil34-1701324066', AuthTy = 'card', memberId = 'yookil34', OrdNm ='황준상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 육일상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41400314****492*', rApprNo = 'mjsof202311301505158out5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 15:01:53', InvoiceNum = '결제성공:Direct-yookil34-1701324066/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 15:01:53' ========================2023-11-30 15:01:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301505158out5' 0 = 1 cnt = 1 ========================2023-11-30 15:01:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yookil34' 0 = yookil34 Mid = yookil34 1 = 주식회사 육일상사 Mcompany = 주식회사 육일상사 2 = 2378701693 companyNum = 2378701693 3 = 032-220-6334 Mtel1 = 032-220-6334 4 = 010-5858-1952 Mhp = 010-5858-1952 ========================2023-11-30 15:01:53======================== select * from customers where id = 'yookil34' ========================2023-11-30 15:01:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yookil34','2023-11-30 15:01:53','220000','220000','온라인','0') ========================2023-11-30 16:56:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mreakeu-1701330859 LGD_BUYER = 조만기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130165419 LGD_HASHDATA = 79f2c44e9dd3f6b6a1d59f63591de690 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 = 20231130165938203D59C667B1CFB353C9008E7A555C95D90028E1 Mname = 조만기 Mcompany = 용접박사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mreakeu LGD_ESCROW_USEYN = N ========================2023-11-30 16:56:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130165938 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = eakeu@hanmail.ner 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 = 94411602****155* LGD_FINANCEAUTHNUM = 51301362 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = a8bc63c17059c11fb75847b6cbe78b30 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231130165939 LGD_PCANCELSTR = 0 LGD_BUYER = 조만기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301659387kji6 LGD_BUYERID = LGD_OID = Direct-mreakeu-1701330859 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 16:56:16======================== insert into mBoard_order set rOrdNo = 'Direct-mreakeu-1701330859', AuthTy = 'card', memberId = 'mreakeu', OrdNm ='조만기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '용접박사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH 94411602****155*', rApprNo = 'mjsof202311301659387kji6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 16:56:16', InvoiceNum = '결제성공:Direct-mreakeu-1701330859/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 16:56:16' ========================2023-11-30 16:56:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301659387kji6' 0 = 1 cnt = 1 ========================2023-11-30 16:56:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mreakeu' 0 = mreakeu Mid = mreakeu 1 = 용접박사 Mcompany = 용접박사 2 = 7950500573 companyNum = 7950500573 3 = 010-4825-0079 Mtel1 = 010-4825-0079 4 = 010-4825-0079 Mhp = 010-4825-0079 ========================2023-11-30 16:56:16======================== select * from customers where id = 'mreakeu' ========================2023-11-30 16:56:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mreakeu','2023-11-30 16:56:16','52500','55000','온라인','0') ========================2023-11-30 16:59:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dani3529-1701331085 LGD_BUYER = 김봉단 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130165805 LGD_HASHDATA = 21075fbd0ce50c6a0f86155077161bc7 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 = 202311301702488DFC5D7436869C4E516CC30921D6F43DF230F9C5 Mname = 김봉단 Mcompany = 이레종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dani3529 LGD_ESCROW_USEYN = N ========================2023-11-30 16:59:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130170248 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dani3529@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 476C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51236500****854* LGD_FINANCEAUTHNUM = 82491891 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5f94866062754a9109667ff9a91f1dde LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20231130170249 LGD_PCANCELSTR = 0 LGD_BUYER = 김봉단 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301702481jyo8 LGD_BUYERID = LGD_OID = Direct-dani3529-1701331085 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 16:59:26======================== insert into mBoard_order set rOrdNo = 'Direct-dani3529-1701331085', AuthTy = 'card', memberId = 'dani3529', OrdNm ='김봉단', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이레종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성MASTER 51236500****854*', rApprNo = 'mjsof202311301702481jyo8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 16:59:26', InvoiceNum = '결제성공:Direct-dani3529-1701331085/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 16:59:26' ========================2023-11-30 16:59:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301702481jyo8' 0 = 1 cnt = 1 ========================2023-11-30 16:59:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dani3529' 0 = dani3529 Mid = dani3529 1 = 이레종합상사 Mcompany = 이레종합상사 2 = 1245042859 companyNum = 1245042859 3 = 031-235-1610 Mtel1 = 031-235-1610 4 = 010-8758-3529 Mhp = 010-8758-3529 ========================2023-11-30 16:59:26======================== select * from customers where id = 'dani3529' ========================2023-11-30 16:59:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dani3529','2023-11-30 16:59:26','52500','55000','온라인','0') ========================2023-11-30 19:45:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ajhsyo-1701340924 LGD_BUYER = 안정환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130194204 LGD_HASHDATA = 80819dba45c87b87bca1c5a377641bf4 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 = 20231130194835FAE92610CCC4730D13C47F5071B7DE4E62423383 Mname = 안정환 Mcompany = 이룸컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ajhsyo LGD_ESCROW_USEYN = N ========================2023-11-30 19:45:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130194836 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ajhsyo@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = AFIA7D LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 48357810****648* LGD_FINANCEAUTHNUM = 09078310 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7747faffa9cbd4066d18689d7ec8af0a LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231130194836 LGD_PCANCELSTR = 0 LGD_BUYER = 안정환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202311301948366xzx5 LGD_BUYERID = LGD_OID = Direct-ajhsyo-1701340924 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 19:45:13======================== insert into mBoard_order set rOrdNo = 'Direct-ajhsyo-1701340924', AuthTy = 'card', memberId = 'ajhsyo', OrdNm ='안정환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이룸컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 48357810****648*', rApprNo = 'mjsof202311301948366xzx5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 19:45:13', InvoiceNum = '결제성공:Direct-ajhsyo-1701340924/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 19:45:13' ========================2023-11-30 19:45:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202311301948366xzx5' 0 = 1 cnt = 1 ========================2023-11-30 19:45:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ajhsyo' 0 = ajhsyo Mid = ajhsyo 1 = 이룸컴퍼니 Mcompany = 이룸컴퍼니 2 = 260-39-01047 companyNum = 260-39-01047 3 = 010-9004-4050 Mtel1 = 010-9004-4050 4 = 010-9004-4050 Mhp = 010-9004-4050 ========================2023-11-30 19:45:13======================== select * from customers where id = 'ajhsyo' ========================2023-11-30 19:45:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ajhsyo','2023-11-30 19:45:13','108000','110000','온라인','0') ========================2023-11-30 19:59:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1701341904 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130195824 LGD_HASHDATA = 32fca8db59ff616ee96f80c454a9c34e 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 = 20231130200237B2CA0EDF795E430E56EB9A3E6C45F49ED69DCB23 Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-11-30 19:59:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231130200237 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****736* LGD_FINANCEAUTHNUM = 66093037 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eb4b8914755057033d2fbe919acc527d LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231130200238 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231130200237aB0s6 LGD_BUYERID = LGD_OID = Direct-k114-1701341904 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0200237aB0N7 ========================2023-11-30 19:59:15======================== insert into mBoard_order set rOrdNo = 'Direct-k114-1701341904', AuthTy = 'card', memberId = 'k114', OrdNm ='김상옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강원산업안전(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****736*', rApprNo = 'mjsof20231130200237aB0s6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 19:59:15', InvoiceNum = '결제성공:Direct-k114-1701341904/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 19:59:15' ========================2023-11-30 19:59:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231130200237aB0s6' 0 = 1 cnt = 1 ========================2023-11-30 19:59:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k114' 0 = k114 Mid = k114 1 = 강원산업안전(주) Mcompany = 강원산업안전(주) 2 = 2388100225 companyNum = 2388100225 3 = 033-732-3114 Mtel1 = 033-732-3114 4 = 010-5115-3114 Mhp = 010-5115-3114 ========================2023-11-30 19:59:15======================== select * from customers where id = 'k114' ========================2023-11-30 19:59:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k114','2023-11-30 19:59:15','220000','220000','온라인','0') ========================2023-11-30 23:40:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-roastercow-1701354908 LGD_BUYER = 민경언 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231130233508 LGD_HASHDATA = a39ed341d918071d96e6d13fa5778faa 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 = 202311302343335A6BC81280DB8433797E2C1D13B8FD5B4AF5EACB Mname = 민경언 Mcompany = 매일우유 이태원 대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = roastercow LGD_ESCROW_USEYN = N ========================2023-11-30 23:40:11======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20231130234334 LGD_DISCOUNTUSEYN = 1 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 = 51370800****196* LGD_FINANCEAUTHNUM = 67271200 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cee66fcfc4a5cf7b2715dcd09015116a LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231130234334 LGD_PCANCELSTR = 0 LGD_BUYER = 민경언 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231130234333ZHsg4 LGD_BUYERID = LGD_OID = Direct-roastercow-1701354908 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-11-30 23:40:11======================== insert into mBoard_order set rOrdNo = 'Direct-roastercow-1701354908', AuthTy = 'card', memberId = 'roastercow', OrdNm ='민경언', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유 이태원 대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 51370800****196*', rApprNo = 'mjsof20231130234333ZHsg4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-11-30 23:40:11', InvoiceNum = '결제성공:Direct-roastercow-1701354908/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-11-30 23:40:11' ========================2023-11-30 23:40:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231130234333ZHsg4' 0 = 1 cnt = 1 ========================2023-11-30 23:40:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'roastercow' 0 = roastercow Mid = roastercow 1 = 매일우유 이태원 대리점 Mcompany = 매일우유 이태원 대리점 2 = 8040201730 companyNum = 8040201730 3 = 010-6234-0927 Mtel1 = 010-6234-0927 4 = 010-6234-0927 Mhp = 010-6234-0927 ========================2023-11-30 23:40:11======================== select * from customers where id = 'roastercow' ========================2023-11-30 23:40:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('roastercow','2023-11-30 23:40:11','220000','220000','온라인','0')