========================2022-11-03 10:41:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nowfix-1667439663 LGD_BUYER = 임경섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103104103 LGD_HASHDATA = 8ea15e54806450546bce1dc80219854e LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211031045299B3C5CB80B01B0F160F76C9226E60D58A44D50AA Mname = 임경섭 Mcompany = (주)나우픽스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = nowfix LGD_ESCROW_USEYN = N ========================2022-11-03 10:41:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103104530 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301602****263* LGD_FINANCEAUTHNUM = 70357671 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 49701c7259c7b0aa4d1b4b1db420350a LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221103104531 LGD_PCANCELSTR = 0 LGD_BUYER = 임경섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221103104530WHqH7 LGD_BUYERID = LGD_OID = Direct-nowfix-1667439663 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-03 10:41:59======================== insert into mBoard_order set rOrdNo = 'Direct-nowfix-1667439663', AuthTy = 'card', memberId = 'nowfix', OrdNm ='임경섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)나우픽스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301602****263*', rApprNo = 'mjsof20221103104530WHqH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 10:41:59', InvoiceNum = '결제성공:Direct-nowfix-1667439663/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 10:41:59' ========================2022-11-03 10:41:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221103104530WHqH7' 0 = 1 cnt = 1 ========================2022-11-03 10:41:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nowfix' 0 = nowfix Mid = nowfix 1 = (주)나우픽스 Mcompany = (주)나우픽스 2 = 1688100038 companyNum = 1688100038 3 = 043-218-3002 Mtel1 = 043-218-3002 4 = 010-3453-9496 Mhp = 010-3453-9496 ========================2022-11-03 10:41:59======================== select * from customers where id = 'nowfix' ========================2022-11-03 10:41:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nowfix','2022-11-03 10:41:59','220000','220000','온라인','0') ========================2022-11-03 10:48:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-blueseafood2-1667439435 LGD_BUYER = 곽동원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103103715 LGD_HASHDATA = 66d282fa3d295567aeaa1794d1be661a LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211031051439F817EFABD9560D592A2EAEC2DB7E7414C68862D Mname = 곽동원 Mcompany = (주)블루씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = blueseafood2 LGD_ESCROW_USEYN = N ========================2022-11-03 10:48:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103105143 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****747* LGD_FINANCEAUTHNUM = 31890783 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 20c8890e60c31a528d3514a67f1bae71 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221103105143 LGD_PCANCELSTR = 0 LGD_BUYER = 곽동원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211031051431O7k4 LGD_BUYERID = LGD_OID = Direct-blueseafood2-1667439435 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31051431DX60 ========================2022-11-03 10:48:12======================== insert into mBoard_order set rOrdNo = 'Direct-blueseafood2-1667439435', AuthTy = 'card', memberId = 'blueseafood2', OrdNm ='곽동원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루씨푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리VISA 41012020****747*', rApprNo = 'mjsof202211031051431O7k4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 10:48:12', InvoiceNum = '결제성공:Direct-blueseafood2-1667439435/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 10:48:12' ========================2022-11-03 10:48:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211031051431O7k4' 0 = 1 cnt = 1 ========================2022-11-03 10:48:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'blueseafood2' 0 = blueseafood2 Mid = blueseafood2 1 = (주)블루씨푸드 Mcompany = (주)블루씨푸드 2 = 5478700548 companyNum = 5478700548 3 = 051-256-7005 Mtel1 = 051-256-7005 4 = 010-0000-0000 Mhp = 010-0000-0000 ========================2022-11-03 10:48:12======================== select * from customers where id = 'blueseafood2' ========================2022-11-03 10:48:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('blueseafood2','2022-11-03 10:48:12','220000','220000','온라인','0') ========================2022-11-03 11:09:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-chparkg-1667441315 LGD_BUYER = 박춘화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103110835 LGD_HASHDATA = 609095e23c057d68e9d5b9644520182c LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221103111309F2B228446686A2D49A6974067559B997527634FE Mname = 박춘화 Mcompany = 주식회사 동보 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = chparkg LGD_ESCROW_USEYN = N ========================2022-11-03 11:09:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103111309 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94301702****089* LGD_FINANCEAUTHNUM = 70614258 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2b4f93435aa1cb138ab41091385c77d2 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221103111310 LGD_PCANCELSTR = 0 LGD_BUYER = 박춘화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202211031113091QLB9 LGD_BUYERID = LGD_OID = Direct-chparkg-1667441315 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-03 11:09:38======================== insert into mBoard_order set rOrdNo = 'Direct-chparkg-1667441315', AuthTy = 'card', memberId = 'chparkg', OrdNm ='박춘화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 동보', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301702****089*', rApprNo = 'mjsof202211031113091QLB9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 11:09:38', InvoiceNum = '결제성공:Direct-chparkg-1667441315/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 11:09:38' ========================2022-11-03 11:09:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211031113091QLB9' 0 = 1 cnt = 1 ========================2022-11-03 11:09:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'chparkg' 0 = chparkg Mid = chparkg 1 = 주식회사 동보 Mcompany = 주식회사 동보 2 = 721-88-00857 companyNum = 721-88-00857 3 = 054-859-3315 Mtel1 = 054-859-3315 4 = 010-8004-3304 Mhp = 010-8004-3304 ========================2022-11-03 11:09:38======================== select * from customers where id = 'chparkg' ========================2022-11-03 11:09:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('chparkg','2022-11-03 11:09:38','108000','110000','온라인','0') ========================2022-11-03 11:55:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1667443984 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103115304 LGD_HASHDATA = 6c1de8ddbc43b64f6abfc06f709ee306 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221103115914D4A300395B32246068B4B12B766F4ACEBA8EBD62 Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-11-03 11:55:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103115915 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yk4546@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94908900****220* LGD_FINANCEAUTHNUM = 00225797 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a37b8b22660dd1e8bf94f9c211ed5e35 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221103115915 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202211031159144EDI2 LGD_BUYERID = LGD_OID = Direct-jupiter-1667443984 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-03 11:59:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1667444318 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103115838 LGD_HASHDATA = 6069f4fcbfddd64af981bd3b3e91931d LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211031203202833ED13DE741BDFD01B8A7A4228D96FB54E0DAA Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-11-03 11:59:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103120320 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94908900****220* LGD_FINANCEAUTHNUM = 00224111 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 63b7a8f7815f3d2e16a729300bf293dc LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221103120320 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202211031203203Ulp1 LGD_BUYERID = LGD_OID = Direct-jupiter-1667444318 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-03 12:02:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1667444399 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103115959 LGD_HASHDATA = a3918ba450444f05b2e04267e5fea12a LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211031205590931DA55D4A041E8CFDFEAFCFC66F20B494A143E Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-11-03 12:02:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103120600 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yk4546@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 002080 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797207****307* LGD_FINANCEAUTHNUM = 30106867 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 91e8cc9f772424b2f15b133e85dd75c9 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221103120600 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211031206006WNS4 LGD_BUYERID = LGD_OID = Direct-jupiter-1667444399 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3120600611v7 ========================2022-11-03 14:55:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1667454910 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103145510 LGD_HASHDATA = 3ecc8899060f3473c966492d3478a074 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022110314592345CB4BFC1E62008F3AEBF3C69E498A31D0310D0D Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2022-11-03 14:55:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103145924 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62500305****294* LGD_FINANCEAUTHNUM = 33655148 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 68e01e3dc06e8ccb49f9be2deb8a1e0f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221103145924 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221103145923izyS2 LGD_BUYERID = LGD_OID = Direct-neotool-1667454910 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3145923i4Q33 ========================2022-11-03 14:55:53======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1667454910', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62500305****294*', rApprNo = 'mjsof20221103145923izyS2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 14:55:53', InvoiceNum = '결제성공:Direct-neotool-1667454910/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 14:55:53' ========================2022-11-03 14:55:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221103145923izyS2' 0 = 1 cnt = 1 ========================2022-11-03 14:55:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2022-11-03 14:55:53======================== select * from customers where id = 'neotool' ========================2022-11-03 14:55:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2022-11-03 14:55:53','108000','110000','온라인','0') ========================2022-11-03 16:02:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1667458901 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103160141 LGD_HASHDATA = 5b4d3e0d68d8eb5e7949ac22d22c2b57 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221103160622290355E79DF1EB0FB98D8EA5CC3063416288BEDC Mname = 신완철 Mcompany = (주)빅브라더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bigbrother LGD_ESCROW_USEYN = N ========================2022-11-03 16:02:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103160623 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****400* LGD_FINANCEAUTHNUM = 34083883 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ee198e416b1c37e301f0da22ee1331b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221103160624 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221103160623j4DR7 LGD_BUYERID = LGD_OID = Direct-bigbrother-1667458901 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3160623jqUA2 ========================2022-11-03 16:02:52======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1667458901', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 55892098****400*', rApprNo = 'mjsof20221103160623j4DR7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 16:02:52', InvoiceNum = '결제성공:Direct-bigbrother-1667458901/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 16:02:52' ========================2022-11-03 16:02:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221103160623j4DR7' 0 = 1 cnt = 1 ========================2022-11-03 16:02:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bigbrother' 0 = bigbrother Mid = bigbrother 1 = (주)빅브라더 Mcompany = (주)빅브라더 2 = 7828800717 companyNum = 7828800717 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7747-5701 Mhp = 010-7747-5701 ========================2022-11-03 16:02:52======================== select * from customers where id = 'bigbrother' ========================2022-11-03 16:02:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2022-11-03 16:02:52','220000','220000','온라인','0') ========================2022-11-03 17:34:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jupiter-1667464426 LGD_BUYER = 이영기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103173346 LGD_HASHDATA = 2b205f916c91d40a773d2591912682b9 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202211031738115FA714CC6044FE5FD8DBA16A4EF778E6E1888186 Mname = 이영기 Mcompany = 목성데코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jupiter LGD_ESCROW_USEYN = N ========================2022-11-03 17:34:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103173811 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94908900****220* LGD_FINANCEAUTHNUM = 00640403 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a952266a3e91729cfc84df58b57ff233 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221103173812 LGD_PCANCELSTR = 0 LGD_BUYER = 이영기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221103173811aoWP3 LGD_BUYERID = LGD_OID = Direct-jupiter-1667464426 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-03 17:34:40======================== insert into mBoard_order set rOrdNo = 'Direct-jupiter-1667464426', AuthTy = 'card', memberId = 'jupiter', OrdNm ='이영기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '목성데코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대 94908900****220*', rApprNo = 'mjsof20221103173811aoWP3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 17:34:40', InvoiceNum = '결제성공:Direct-jupiter-1667464426/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 17:34:40' ========================2022-11-03 17:34:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221103173811aoWP3' 0 = 1 cnt = 1 ========================2022-11-03 17:34:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jupiter' 0 = jupiter Mid = jupiter 1 = 목성데코 Mcompany = 목성데코 2 = 120-08-30823 companyNum = 120-08-30823 3 = 02-516-8336 Mtel1 = 02-516-8336 4 = 010-5269-4546 Mhp = 010-5269-4546 ========================2022-11-03 17:34:40======================== select * from customers where id = 'jupiter' ========================2022-11-03 17:34:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jupiter','2022-11-03 17:34:40','220000','220000','온라인','0') ========================2022-11-03 17:34:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-haigadun-1667464417 LGD_BUYER = 정동규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221103173337 LGD_HASHDATA = 0df76f306c5541d45e75b168867a8470 LGD_RETURNURL = http://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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20221103173814EE90547FCCD62F45575EF45769107122D7DEBEB1 Mname = 정동규 Mcompany = 주식회사 해가든 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = haigadun LGD_ESCROW_USEYN = N ========================2022-11-03 17:34:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221103173815 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300307****693* LGD_FINANCEAUTHNUM = 34954063 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8934ddc6f63641075614f163fd02b10e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221103173815 LGD_PCANCELSTR = 0 LGD_BUYER = 정동규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202211031738148vic2 LGD_BUYERID = LGD_OID = Direct-haigadun-1667464417 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 317381488DH3 ========================2022-11-03 17:34:43======================== insert into mBoard_order set rOrdNo = 'Direct-haigadun-1667464417', AuthTy = 'card', memberId = 'haigadun', OrdNm ='정동규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 해가든', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300307****693*', rApprNo = 'mjsof202211031738148vic2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-03 17:34:43', InvoiceNum = '결제성공:Direct-haigadun-1667464417/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-03 17:34:43' ========================2022-11-03 17:34:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202211031738148vic2' 0 = 1 cnt = 1 ========================2022-11-03 17:34:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'haigadun' 0 = haigadun Mid = haigadun 1 = 주식회사 해가든 Mcompany = 주식회사 해가든 2 = 126-86-36411 companyNum = 126-86-36411 3 = 02-429-0103 Mtel1 = 02-429-0103 4 = 010-3742-4164 Mhp = 010-3742-4164 ========================2022-11-03 17:34:44======================== select * from customers where id = 'haigadun' ========================2022-11-03 17:34:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('haigadun','2022-11-03 17:34:43','220000','220000','온라인','0')