========================2022-11-10 13:47:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1668055602 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110134642 LGD_HASHDATA = ef57458a7a2528889b2339f5a3f79256 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 = 2022111013513007547570D2ABF219B68D8C1CA489E06EA8A47D1E Mname = 김창민 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2022-11-10 13:47:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110135130 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 = 46700850****602* LGD_FINANCEAUTHNUM = 36490274 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 71100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f9e887ecc40bf48fab2753e91b81044b LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221110135131 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110135130SJPc4 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1668055602 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 13:47:51======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1668055602', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '롯데VISA 46700850****602*', rApprNo = 'mjsof20221110135130SJPc4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 13:47:51', InvoiceNum = '결제성공:Direct-nosqr9583-1668055602/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 13:47:51' ========================2022-11-10 13:47:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110135130SJPc4' 0 = 1 cnt = 1 ========================2022-11-10 13:47:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 010-3199-5304 Mtel1 = 010-3199-5304 4 = 010-3199-5304 Mhp = 010-3199-5304 ========================2022-11-10 13:47:51======================== select * from customers where id = 'nosqr9583' ========================2022-11-10 13:47:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2022-11-10 13:47:51','108000','110000','온라인','0') ========================2022-11-10 14:52:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-an5845-1668059456 LGD_BUYER = 안상주 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110145056 LGD_HASHDATA = 7c8b16a603d0024d94ca622371f2b78b 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 = 202211101456045E6CEBBE525AB27C016CEB023D54A55FE1E0590E Mname = 안상주 Mcompany = 그린푸드 D&S post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = an5845 LGD_ESCROW_USEYN = N ========================2022-11-10 14:52:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110145605 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 = 40329380****861* LGD_FINANCEAUTHNUM = 00568613 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b065adb1352c71d0bd4eee2caaf2dfb9 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221110145605 LGD_PCANCELSTR = 0 LGD_BUYER = 안상주 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110145605yzri2 LGD_BUYERID = LGD_OID = Direct-an5845-1668059456 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 14:52:26======================== insert into mBoard_order set rOrdNo = 'Direct-an5845-1668059456', AuthTy = 'card', memberId = 'an5845', OrdNm ='안상주', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '그린푸드 D&S', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대VISA 40329380****861*', rApprNo = 'mjsof20221110145605yzri2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 14:52:26', InvoiceNum = '결제성공:Direct-an5845-1668059456/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 14:52:26' ========================2022-11-10 14:52:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110145605yzri2' 0 = 1 cnt = 1 ========================2022-11-10 14:52:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'an5845' 0 = an5845 Mid = an5845 1 = 그린푸드 D&S Mcompany = 그린푸드 D&S 2 = 1091181174 companyNum = 1091181174 3 = 02-2695-5242 Mtel1 = 02-2695-5242 4 = 010-3170-4774 Mhp = 010-3170-4774 ========================2022-11-10 14:52:26======================== select * from customers where id = 'an5845' ========================2022-11-10 14:52:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('an5845','2022-11-10 14:52:26','220000','220000','온라인','0') ========================2022-11-10 15:44:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nuzeekorea-1668062512 LGD_BUYER = 뉴지코리아 주식회사 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110154152 LGD_HASHDATA = 1cc2d65d489a610ad0764e4b325de3c7 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 = 2022111015475072FD87F27DE5E9A4D250F01CDD3AD8E405D00431 Mname = 뉴지코리아 주식회사 Mcompany = 뉴지코리아 주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = nuzeekorea LGD_ESCROW_USEYN = N ========================2022-11-10 15:44:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110154750 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = nuzee@nuzeekorea.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****790* LGD_FINANCEAUTHNUM = 49269683 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c3ea25b81be0cc7a9a518d744469c5bb LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221110154751 LGD_PCANCELSTR = 0 LGD_BUYER = 뉴지코리아 주식회사 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110154750pbcS2 LGD_BUYERID = LGD_OID = Direct-nuzeekorea-1668062512 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 15:44:12======================== insert into mBoard_order set rOrdNo = 'Direct-nuzeekorea-1668062512', AuthTy = 'card', memberId = 'nuzeekorea', OrdNm ='뉴지코리아 주식회사', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '뉴지코리아 주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****790*', rApprNo = 'mjsof20221110154750pbcS2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 15:44:12', InvoiceNum = '결제성공:Direct-nuzeekorea-1668062512/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 15:44:12' ========================2022-11-10 15:44:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110154750pbcS2' 0 = 1 cnt = 1 ========================2022-11-10 15:44:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nuzeekorea' 0 = nuzeekorea Mid = nuzeekorea 1 = 뉴지코리아 주식회사 Mcompany = 뉴지코리아 주식회사 2 = 7308600968 companyNum = 7308600968 3 = 010-2459-8961 Mtel1 = 010-2459-8961 4 = 010-8669-5336 Mhp = 010-8669-5336 ========================2022-11-10 15:44:12======================== select * from customers where id = 'nuzeekorea' ========================2022-11-10 15:44:12======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('nuzeekorea','뉴지코리아 주식회사','7308600968','010-2459-8961','010-8669-5336','2022-11-10 15:44:12','온라인') ========================2022-11-10 15:44:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nuzeekorea','2022-11-10 15:44:12','10000','11000','온라인','0') ========================2022-11-10 15:55:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hinoki11-1668063113 LGD_BUYER = 정시열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110155153 LGD_HASHDATA = 222f24fb55d3180b7917de61f55c2d2e 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 = 2022111015593765DD8666A15210CBC43D8292477DEDF2001EBFEE Mname = 정시열 Mcompany = 재우사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = hinoki11 LGD_ESCROW_USEYN = N ========================2022-11-10 15:55:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110155938 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BJABE3 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62584000****389* LGD_FINANCEAUTHNUM = 49427683 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c448fd8963914a1d2ac3d8d09723ca72 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221110155938 LGD_PCANCELSTR = 0 LGD_BUYER = 정시열 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110155937tDAZ9 LGD_BUYERID = LGD_OID = Direct-hinoki11-1668063113 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 15:55:58======================== insert into mBoard_order set rOrdNo = 'Direct-hinoki11-1668063113', AuthTy = 'card', memberId = 'hinoki11', OrdNm ='정시열', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '재우사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한CUP 62584000****389*', rApprNo = 'mjsof20221110155937tDAZ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 15:55:58', InvoiceNum = '결제성공:Direct-hinoki11-1668063113/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 15:55:58' ========================2022-11-10 15:55:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110155937tDAZ9' 0 = 1 cnt = 1 ========================2022-11-10 15:55:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hinoki11' 0 = hinoki11 Mid = hinoki11 1 = 재우사 Mcompany = 재우사 2 = 5032067906 companyNum = 5032067906 3 = 010-2798-8360 Mtel1 = 010-2798-8360 4 = 010-2798-8360 Mhp = 010-2798-8360 ========================2022-11-10 15:55:59======================== select * from customers where id = 'hinoki11' ========================2022-11-10 15:55:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hinoki11','2022-11-10 15:55:58','30900','33000','온라인','0') ========================2022-11-10 16:03:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jbwoo358-1668063473 LGD_BUYER = 최보배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110155753 LGD_HASHDATA = b794dd72fee961ca77f02d748eb184c9 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 = 202211101607261B6E34C83FF0A47564C5E643D97F561D99E2DE9E Mname = 최보배 Mcompany = 보배유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jbwoo358 LGD_ESCROW_USEYN = N ========================2022-11-10 16:03:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110160726 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 = 41372000****235* LGD_FINANCEAUTHNUM = 64812974 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d02bc7696c258f325ff77401170aa486 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20221110160726 LGD_PCANCELSTR = 0 LGD_BUYER = 최보배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110160726vzXN7 LGD_BUYERID = LGD_OID = Direct-jbwoo358-1668063473 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 16:03:47======================== insert into mBoard_order set rOrdNo = 'Direct-jbwoo358-1668063473', AuthTy = 'card', memberId = 'jbwoo358', OrdNm ='최보배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '보배유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성VISA 41372000****235*', rApprNo = 'mjsof20221110160726vzXN7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 16:03:47', InvoiceNum = '결제성공:Direct-jbwoo358-1668063473/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 16:03:47' ========================2022-11-10 16:03:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110160726vzXN7' 0 = 1 cnt = 1 ========================2022-11-10 16:03:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jbwoo358' 0 = jbwoo358 Mid = jbwoo358 1 = 보배유통 Mcompany = 보배유통 2 = 6870701557 companyNum = 6870701557 3 = 010-4081-4660 Mtel1 = 010-4081-4660 4 = 010-4081-4660 Mhp = 010-4081-4660 ========================2022-11-10 16:03:47======================== select * from customers where id = 'jbwoo358' ========================2022-11-10 16:03:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jbwoo358','2022-11-10 16:03:47','30900','33000','온라인','0') ========================2022-11-10 16:12:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harry0111-1668064284 LGD_BUYER = 최규윤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110161124 LGD_HASHDATA = 5a940a4b70948cdd68f356fdf7d95fec 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 = 20221110161556032269007B91B9FD3F176080765465A680929F17 Mname = 최규윤 Mcompany = (주)한국종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = harry0111 LGD_ESCROW_USEYN = N ========================2022-11-10 16:12:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110161557 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413211****899* LGD_FINANCEAUTHNUM = 48019313 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 648d305137e26da57ebe83fddbadda15 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221110161557 LGD_PCANCELSTR = 0 LGD_BUYER = 최규윤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221110161557utR57 LGD_BUYERID = LGD_OID = Direct-harry0111-1668064284 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0161557u3pO2 ========================2022-11-10 16:12:18======================== insert into mBoard_order set rOrdNo = 'Direct-harry0111-1668064284', AuthTy = 'card', memberId = 'harry0111', OrdNm ='최규윤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한국종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413211****899*', rApprNo = 'mjsof20221110161557utR57', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 16:12:18', InvoiceNum = '결제성공:Direct-harry0111-1668064284/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 16:12:18' ========================2022-11-10 16:12:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110161557utR57' 0 = 1 cnt = 1 ========================2022-11-10 16:12:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harry0111' 0 = harry0111 Mid = harry0111 1 = (주)한국종합물류 Mcompany = (주)한국종합물류 2 = 5448801472 companyNum = 5448801472 3 = 010-4331-0111 Mtel1 = 010-4331-0111 4 = 010-4331-0111 Mhp = 010-4331-0111 ========================2022-11-10 16:12:18======================== select * from customers where id = 'harry0111' ========================2022-11-10 16:12:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harry0111','2022-11-10 16:12:18','108000','110000','온라인','0') ========================2022-11-10 20:02:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dearceh-1668078065 LGD_BUYER = 최은화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110200105 LGD_HASHDATA = fbfa894b75678eeb132933a1486c2744 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 = 20221110200637CCCEB830F2D32CD9370013375A5FDD0006DB3D18 Mname = 최은화 Mcompany = 올키즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dearceh LGD_ESCROW_USEYN = N ========================2022-11-10 20:02:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110200639 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46323506****490* LGD_FINANCEAUTHNUM = 30020712 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 24cfe6ec8f715004f042de19244fa48b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221110200639 LGD_PCANCELSTR = 0 LGD_BUYER = 최은화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221110200638pyQd3 LGD_BUYERID = LGD_OID = Direct-dearceh-1668078065 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0200638pc2O2 ========================2022-11-10 20:15:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dearceh-1668078863 LGD_BUYER = 최은화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110201423 LGD_HASHDATA = e17c5dcedd977d992acd7faf90d30566 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 = 20221110201908582B3CF2B6977C4AC2712DB7AECBC1C6D3737CB9 Mname = 최은화 Mcompany = 올키즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dearceh LGD_ESCROW_USEYN = N ========================2022-11-10 20:15:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110201909 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46323506****490* LGD_FINANCEAUTHNUM = 30020723 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 4400f612d74d494d53aeb528053a7c67 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221110201909 LGD_PCANCELSTR = 0 LGD_BUYER = 최은화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221110201908sDTL3 LGD_BUYERID = LGD_OID = Direct-dearceh-1668078863 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0201908slxL7 ========================2022-11-10 21:53:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hubpet-1668084616 LGD_BUYER = 전지훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221110215016 LGD_HASHDATA = 78d02491f99a17379a5b309c2184491e 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 = 2022111021564110488D7C02645CD02ABE7A9ADE8D46677FCBF054 Mname = 전지훈 Mcompany = 허브펫통상 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = hubpet LGD_ESCROW_USEYN = N ========================2022-11-10 21:53:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221110215641 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 = 51883100****021* LGD_FINANCEAUTHNUM = 48686520 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 54630839405f807e2b893ae0c937fb4a LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20221110215642 LGD_PCANCELSTR = 0 LGD_BUYER = 전지훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221110215641v6Ms8 LGD_BUYERID = LGD_OID = Direct-hubpet-1668084616 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-11-10 21:53:02======================== insert into mBoard_order set rOrdNo = 'Direct-hubpet-1668084616', AuthTy = 'card', memberId = 'hubpet', OrdNm ='전지훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '허브펫통상', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성MASTER 51883100****021*', rApprNo = 'mjsof20221110215641v6Ms8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-11-10 21:53:02', InvoiceNum = '결제성공:Direct-hubpet-1668084616/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-11-10 21:53:02' ========================2022-11-10 21:53:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221110215641v6Ms8' 0 = 1 cnt = 1 ========================2022-11-10 21:53:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hubpet' 0 = hubpet Mid = hubpet 1 = 허브펫통상 Mcompany = 허브펫통상 2 = 5102212927 companyNum = 5102212927 3 = 010-2090-3721 Mtel1 = 010-2090-3721 4 = 010-2090-3721 Mhp = 010-2090-3721 ========================2022-11-10 21:53:03======================== select * from customers where id = 'hubpet' ========================2022-11-10 21:53:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hubpet','2022-11-10 21:53:02','30900','33000','온라인','0')