========================2021-07-10 14:18:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-an5845-1625894241 LGD_BUYER = 안상주 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210710141721 LGD_HASHDATA = 072cfbddd93d15acb975c7656787cad1 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 = 2021071014184928C2DADE92914534879B8D75455871072YLLLI2P Mname = 안상주 Mcompany = 그린푸드 D&S post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = an5845 LGD_ESCROW_USEYN = N ========================2021-07-10 14:18:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210710141849 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 = 403293******8614 LGD_FINANCEAUTHNUM = 00352775 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8e04fbb3e6068b116f251d25c220ddb9 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210710141849 LGD_PCANCELSTR = 0 LGD_BUYER = 안상주 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021071014184960069 LGD_BUYERID = LGD_OID = Direct-an5845-1625894241 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-10 14:18:18======================== insert into mBoard_order set rOrdNo = 'Direct-an5845-1625894241', AuthTy = 'card', memberId = 'an5845', OrdNm ='안상주', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '그린푸드 D&S', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 403293******8614', rApprNo = 'mjsof2021071014184960069', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-10 14:18:18', InvoiceNum = '결제성공:Direct-an5845-1625894241/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-10 14:18:18' ========================2021-07-10 14:18:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021071014184960069' 0 = 1 cnt = 1 ========================2021-07-10 14:18:18======================== 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 ========================2021-07-10 14:18:18======================== select * from customers where id = 'an5845' ========================2021-07-10 14:18:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('an5845','2021-07-10 14:18:18','108000','110000','온라인','0') ========================2021-07-10 14:25:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brothers-1625894499 LGD_BUYER = 조만식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210710142139 LGD_HASHDATA = edbb030f82397f06833f7afc7cba3135 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 = 2021071014254316191385D35D4D0D9EEA620ABB1DF407LKZSXQJV Mname = 조만식 Mcompany = 브라더 리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = brothers LGD_ESCROW_USEYN = N ========================2021-07-10 14:25:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210710142543 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = brother-3@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = APB9YL LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 465887******6261 LGD_FINANCEAUTHNUM = 28957388 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9151f749bec4c8f70e9078288f4efb5a LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210710142543 LGD_PCANCELSTR = 0 LGD_BUYER = 조만식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021071014254360224 LGD_BUYERID = LGD_OID = Direct-brothers-1625894499 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-10 14:25:11======================== insert into mBoard_order set rOrdNo = 'Direct-brothers-1625894499', AuthTy = 'card', memberId = 'brothers', OrdNm ='조만식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '브라더 리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 465887******6261', rApprNo = 'mjsof2021071014254360224', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-10 14:25:11', InvoiceNum = '결제성공:Direct-brothers-1625894499/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-10 14:25:11' ========================2021-07-10 14:25:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021071014254360224' 0 = 1 cnt = 1 ========================2021-07-10 14:25:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'brothers' 0 = brothers Mid = brothers 1 = 브라더 리테일 Mcompany = 브라더 리테일 2 = 8711001642 companyNum = 8711001642 3 = 010-9132-2424 Mtel1 = 010-9132-2424 4 = 010-9444-7213 Mhp = 010-9444-7213 ========================2021-07-10 14:25:11======================== select * from customers where id = 'brothers' ========================2021-07-10 14:25:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brothers','2021-07-10 14:25:11','52500','55000','온라인','0') ========================2021-07-10 17:12:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mikku73-1625904658 LGD_BUYER = 김은영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210710171058 LGD_HASHDATA = a4b8566c4384797a1e175d8d0de96a18 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 = 2021071017131136545E1D6C1149DE950F47FA94794E95DSPXIV1F Mname = 김은영 Mcompany = 이와이유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mikku73 LGD_ESCROW_USEYN = N ========================2021-07-10 17:12:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210710171311 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 451842******9042 LGD_FINANCEAUTHNUM = 30990245 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 226ec97ec1e88ee8a4e5952cef65bc5f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210710171311 LGD_PCANCELSTR = 0 LGD_BUYER = 김은영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021071017131160219 LGD_BUYERID = LGD_OID = Direct-mikku73-1625904658 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-10 17:23:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1625905371 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210710172251 LGD_HASHDATA = 537b6fe7d89f6e59565697e48d597656 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 = 20210710172428FBDBE730D12D4C7EBD78A07F62645D51N46GPUVN Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2021-07-10 17:23:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210710172429 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 = 404933******4019 LGD_FINANCEAUTHNUM = 00051417 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eed7264eb61b9e15e4990e3b4451a2a6 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210710172429 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021071017242961141 LGD_BUYERID = LGD_OID = Direct-we32-1625905371 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-10 17:23:57======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1625905371', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 404933******4019', rApprNo = 'mjsof2021071017242961141', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-10 17:23:57', InvoiceNum = '결제성공:Direct-we32-1625905371/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-10 17:23:57' ========================2021-07-10 17:23:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021071017242961141' 0 = 1 cnt = 1 ========================2021-07-10 17:23:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2021-07-10 17:23:57======================== select * from customers where id = 'we32' ========================2021-07-10 17:23:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2021-07-10 17:23:57','52500','55000','온라인','0') ========================2021-07-10 17:25:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mikku73-1625905457 LGD_BUYER = 김은영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210710172417 LGD_HASHDATA = d2f6a5c00eaa921d9b61310396f05d0e 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 = 20210710172610429FA5278F984EFBB2DBAB9D5163C1AAOJZX8WC9 Mname = 김은영 Mcompany = 이와이유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mikku73 LGD_ESCROW_USEYN = N ========================2021-07-10 17:25:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210710172611 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 451842******9042 LGD_FINANCEAUTHNUM = 31147089 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7fdb995a2d865f1e2afaf37ea9b99162 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210710172611 LGD_PCANCELSTR = 0 LGD_BUYER = 김은영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021071017261161178 LGD_BUYERID = LGD_OID = Direct-mikku73-1625905457 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-10 17:25:39======================== insert into mBoard_order set rOrdNo = 'Direct-mikku73-1625905457', AuthTy = 'card', memberId = 'mikku73', OrdNm ='김은영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이와이유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 451842******9042', rApprNo = 'mjsof2021071017261161178', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-10 17:25:39', InvoiceNum = '결제성공:Direct-mikku73-1625905457/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-10 17:25:39' ========================2021-07-10 17:25:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021071017261161178' 0 = 1 cnt = 1 ========================2021-07-10 17:25:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mikku73' 0 = mikku73 Mid = mikku73 1 = 이와이유통 Mcompany = 이와이유통 2 = 6052177430 companyNum = 6052177430 3 = 070-8827-8084 Mtel1 = 070-8827-8084 4 = 010-9984-9760 Mhp = 010-9984-9760 ========================2021-07-10 17:25:39======================== select * from customers where id = 'mikku73' ========================2021-07-10 17:25:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mikku73','2021-07-10 17:25:39','52500','55000','온라인','0')