========================2021-11-03 09:55:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnam4051-1635900864 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103095424 LGD_HASHDATA = 3cb22af4c92d8900fc75678777ccc58f 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 = 202111030957531034135A016F4CF488E822B3B0707DCBPDE1L5LV Mname = 이정훈 Mcompany = 동남상회 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = dongnam4051 LGD_ESCROW_USEYN = N ========================2021-11-03 09:55:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103095753 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 = 457493******8416 LGD_FINANCEAUTHNUM = 00131513 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = feafeea2f6acc09b6ae0528773359fec LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20211103095754 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103095753VH7s4 LGD_BUYERID = LGD_OID = Direct-dongnam4051-1635900864 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-03 09:55:14======================== insert into mBoard_order set rOrdNo = 'Direct-dongnam4051-1635900864', AuthTy = 'card', memberId = 'dongnam4051', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동남상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 457493******8416', rApprNo = 'mjsof20211103095753VH7s4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 09:55:14', InvoiceNum = '결제성공:Direct-dongnam4051-1635900864/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 09:55:14' ========================2021-11-03 09:55:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103095753VH7s4' 0 = 1 cnt = 1 ========================2021-11-03 09:55:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongnam4051' 0 = dongnam4051 Mid = dongnam4051 1 = 동남상회 Mcompany = 동남상회 2 = 3053766242 companyNum = 3053766242 3 = 010-2019-7470 Mtel1 = 010-2019-7470 4 = 010-2019-7470 Mhp = 010-2019-7470 ========================2021-11-03 09:55:14======================== select * from customers where id = 'dongnam4051' ========================2021-11-03 09:55:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnam4051','2021-11-03 09:55:14','30900','33000','온라인','0') ========================2021-11-03 11:19:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1635905899 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103111819 LGD_HASHDATA = 3c2313f6f84bd119417d7d446ac3eb52 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 = 202111031121592ED20FBC2521451CA3F16BA29E5168DC9LTTMSEO Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2021-11-03 11:19:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103112200 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733403 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******8971 LGD_FINANCEAUTHNUM = 47670819 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dd14ebf55a912344fe50d9513ef72bf6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103112200 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103112159Uc6G2 LGD_BUYERID = LGD_OID = Direct-pao7894-1635905899 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3112159UwtR9 ========================2021-11-03 11:21:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1635906017 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103112017 LGD_HASHDATA = 965fe0432331e5b80e46d63ed2fd55ce 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 = 20211103112438AC34E219F65E41FD9413C831EB73CAB9ENKM9BPS Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2021-11-03 11:21:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103112438 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733403 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******8971 LGD_FINANCEAUTHNUM = 47680828 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9a8a563f316dfcd4ba59a76055183175 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103112439 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103112438Ucd93 LGD_BUYERID = LGD_OID = Direct-pao7894-1635906017 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3112438Uwx82 ========================2021-11-03 11:43:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bs62-1635907106 LGD_BUYER = 우주벤딩 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103113826 LGD_HASHDATA = bebc9ec6ea24973a1d9f2b7f6f28c484 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 = 202111031146168BE45B3D2A80402395C2E6D3FA0454E3BLJFFUNH Mname = 우주벤딩 Mcompany = 우주벤딩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bs62 LGD_ESCROW_USEYN = N ========================2021-11-03 11:43:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103114617 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943032******5947 LGD_FINANCEAUTHNUM = 47817714 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c95dac479a66046f5ddd1b19c71a1c79 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103114617 LGD_PCANCELSTR = 0 LGD_BUYER = 우주벤딩 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103114616Yj9C2 LGD_BUYERID = LGD_OID = Direct-bs62-1635907106 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3114616Yvcj7 ========================2021-11-03 11:43:37======================== insert into mBoard_order set rOrdNo = 'Direct-bs62-1635907106', AuthTy = 'card', memberId = 'bs62', OrdNm ='우주벤딩', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우주벤딩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943032******5947', rApprNo = 'mjsof20211103114616Yj9C2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 11:43:37', InvoiceNum = '결제성공:Direct-bs62-1635907106/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 11:43:37' ========================2021-11-03 11:43:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103114616Yj9C2' 0 = 1 cnt = 1 ========================2021-11-03 11:43:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bs62' 0 = bs62 Mid = bs62 1 = 우주벤딩 Mcompany = 우주벤딩 2 = 606-11-21435 companyNum = 606-11-21435 3 = 051-316-1321 Mtel1 = 051-316-1321 4 = 011-499-9282 Mhp = 011-499-9282 ========================2021-11-03 11:43:37======================== select * from customers where id = 'bs62' ========================2021-11-03 11:43:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bs62','2021-11-03 11:43:37','220000','220000','온라인','0') ========================2021-11-03 12:21:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakeryall-1635909590 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103121950 LGD_HASHDATA = 0b57ad6e641783da3ab9b61279648b4b 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 = 20211103122350D77F43AF916A417191B5D420C5F4CC46HD6CI9ZG Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bakeryall LGD_ESCROW_USEYN = N ========================2021-11-03 12:21:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103122350 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******9386 LGD_FINANCEAUTHNUM = 18005387 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 44694166f52633d582a5bf98f7ad07c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20211103122351 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103122350VN8n5 LGD_BUYERID = LGD_OID = Direct-bakeryall-1635909590 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-03 12:21:11======================== insert into mBoard_order set rOrdNo = 'Direct-bakeryall-1635909590', AuthTy = 'card', memberId = 'bakeryall', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 490298******9386', rApprNo = 'mjsof20211103122350VN8n5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 12:21:11', InvoiceNum = '결제성공:Direct-bakeryall-1635909590/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 12:21:11' ========================2021-11-03 12:21:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103122350VN8n5' 0 = 1 cnt = 1 ========================2021-11-03 12:21:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakeryall' 0 = bakeryall Mid = bakeryall 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2021-11-03 12:21:11======================== select * from customers where id = 'bakeryall' ========================2021-11-03 12:21:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakeryall','2021-11-03 12:21:11','108000','110000','온라인','0') ========================2021-11-03 12:32:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1635910298 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103123138 LGD_HASHDATA = 91dde45790b76e9125910152a4757115 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 = 20211103123512B85585EC419C460EAC6FA1C03DACB441E7D2FOS1 Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2021-11-03 12:32:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103123513 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tata7894@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733403 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558503******8971 LGD_FINANCEAUTHNUM = 48150486 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d4be0f9551f477f033b0a20b21ccef34 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103123513 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103123512VNqC6 LGD_BUYERID = LGD_OID = Direct-pao7894-1635910298 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3123512V8cC4 ========================2021-11-03 12:32:33======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1635910298', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 558503******8971', rApprNo = 'mjsof20211103123512VNqC6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 12:32:33', InvoiceNum = '결제성공:Direct-pao7894-1635910298/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 12:32:33' ========================2021-11-03 12:32:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103123512VNqC6' 0 = 1 cnt = 1 ========================2021-11-03 12:32:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pao7894' 0 = pao7894 Mid = pao7894 1 = (주)토탈엘앤씨 Mcompany = (주)토탈엘앤씨 2 = 134-86-34108 companyNum = 134-86-34108 3 = 031-366-9051 Mtel1 = 031-366-9051 4 = 010-3022-2227 Mhp = 010-3022-2227 ========================2021-11-03 12:32:33======================== select * from customers where id = 'pao7894' ========================2021-11-03 12:32:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2021-11-03 12:32:33','220000','220000','온라인','0') ========================2021-11-03 15:08:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bmtec-1635919618 LGD_BUYER = 전보현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103150658 LGD_HASHDATA = a20d7c0a12eb8efbd15bbfe9a00ad8c8 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 = 20211103151113FE7E2C34076D4126ABA0B384B3A88A158QK4CSBO Mname = 전보현 Mcompany = BMTEC post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = bmtec LGD_ESCROW_USEYN = N ========================2021-11-03 15:08:34======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103151113 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 = 544689******5208 LGD_FINANCEAUTHNUM = 00615594 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7b8bec1b61ba49f6607e56d49b00bd7a LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20211103151114 LGD_PCANCELSTR = 0 LGD_BUYER = 전보현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103151113XbEG6 LGD_BUYERID = LGD_OID = Direct-bmtec-1635919618 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-03 15:08:34======================== insert into mBoard_order set rOrdNo = 'Direct-bmtec-1635919618', AuthTy = 'card', memberId = 'bmtec', OrdNm ='전보현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'BMTEC', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대MASTER 544689******5208', rApprNo = 'mjsof20211103151113XbEG6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 15:08:34', InvoiceNum = '결제성공:Direct-bmtec-1635919618/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 15:08:34' ========================2021-11-03 15:08:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103151113XbEG6' 0 = 1 cnt = 1 ========================2021-11-03 15:08:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bmtec' 0 = bmtec Mid = bmtec 1 = BMTEC Mcompany = BMTEC 2 = 1401024139 companyNum = 1401024139 3 = 031-432-3316 Mtel1 = 031-432-3316 4 = 010-3755-0729 Mhp = 010-3755-0729 ========================2021-11-03 15:08:34======================== select * from customers where id = 'bmtec' ========================2021-11-03 15:08:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bmtec','2021-11-03 15:08:34','10000','11000','온라인','0') ========================2021-11-03 15:17:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1635920044 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103151404 LGD_HASHDATA = cdf52c1b0e1a1d8cb46a6dddaff23b49 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 = 202111031520146D64BD47D6E04C28B2CFE2E906D1FBBDZIYZSNBC Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2021-11-03 15:17:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103152015 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 393487 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538839******4647 LGD_FINANCEAUTHNUM = 49382697 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 442b2f976e1c7a14dd0d2d47f6c8d41e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103152015 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103152015VSGV7 LGD_BUYERID = LGD_OID = Direct-woorimart-1635920044 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3152015VaTG2 ========================2021-11-03 15:17:35======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1635920044', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 538839******4647', rApprNo = 'mjsof20211103152015VSGV7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 15:17:35', InvoiceNum = '결제성공:Direct-woorimart-1635920044/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 15:17:35' ========================2021-11-03 15:17:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103152015VSGV7' 0 = 1 cnt = 1 ========================2021-11-03 15:17:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2021-11-03 15:17:35======================== select * from customers where id = 'woorimart' ========================2021-11-03 15:17:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2021-11-03 15:17:35','220000','220000','온라인','0') ========================2021-11-03 16:33:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1635924763 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211103163243 LGD_HASHDATA = 830ab0b2fdf9b2000b6f2e7d804974cb 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 = 202111031636056E9C0DE8FFC447EE848B55642B12CE2B5VVNPCFA 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 ========================2021-11-03 16:33:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211103163606 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 = 625003******2941 LGD_FINANCEAUTHNUM = 49888620 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 81fb26e83d3308d6b00f2c39bafe4bbd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211103163606 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211103163605VVoA2 LGD_BUYERID = LGD_OID = Direct-neotool-1635924763 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3163605Vch68 ========================2021-11-03 16:33:26======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1635924763', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 625003******2941', rApprNo = 'mjsof20211103163605VVoA2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-03 16:33:26', InvoiceNum = '결제성공:Direct-neotool-1635924763/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-03 16:33:26' ========================2021-11-03 16:33:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211103163605VVoA2' 0 = 1 cnt = 1 ========================2021-11-03 16:33:26======================== 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 ========================2021-11-03 16:33:26======================== select * from customers where id = 'neotool' ========================2021-11-03 16:33:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-11-03 16:33:26','108000','110000','온라인','0')