========================2021-02-05 07:30:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1612477737 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205072857 LGD_HASHDATA = 3f69d6a947249eb0b7077e425ed37748 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102050730560B1230D9D4F43D0DF2A22F599F5A556A87650082 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-02-05 07:30:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205073057 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306I7C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 51573777 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 04951b152176a6ecf309261f31b9d11b LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210205073057 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020507305760281 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1612477737 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-05 07:30:50======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1612477737', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021020507305760281', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 07:30:50', InvoiceNum = '결제성공:Direct-goodssal5707-1612477737/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 07:30:50' ========================2021-02-05 07:30:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020507305760281' 0 = 1 cnt = 1 ========================2021-02-05 07:30:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-9019-7586 Mhp = 010-9019-7586 ========================2021-02-05 07:30:51======================== select * from customers where id = 'goodssal5707' ========================2021-02-05 07:30:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-02-05 07:30:50','220000','220000','온라인','0') ========================2021-02-05 07:31:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1612477859 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205073059 LGD_HASHDATA = 4c1f96c04c4b067d0f802c6c70aaa31c LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210205073159DFFA1F88E6666780114FBFE3828206A18D846B4C Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-02-05 07:31:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205073200 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306I7C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 51575901 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5df9f443b7ca3eab4602908cfa568ef6 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210205073200 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020507315960157 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1612477859 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-05 07:31:53======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1612477859', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021020507315960157', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 07:31:53', InvoiceNum = '결제성공:Direct-goodssal5707-1612477859/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 07:31:53' ========================2021-02-05 07:31:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020507315960157' 0 = 1 cnt = 1 ========================2021-02-05 07:31:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-9019-7586 Mhp = 010-9019-7586 ========================2021-02-05 07:31:53======================== select * from customers where id = 'goodssal5707' ========================2021-02-05 07:31:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-02-05 07:31:53','220000','220000','온라인','0') ========================2021-02-05 09:47:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongjo-1612485426 LGD_BUYER = 김호순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205093706 LGD_HASHDATA = d45be51484886a6398bdaf78a35a024a LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021020509473160912246D616F72B679E54B6F1788836D9DF65BD Mname = 김호순 Mcompany = (주)동조 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dongjo LGD_ESCROW_USEYN = N ========================2021-02-05 09:47:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205094732 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hskim@dongjo.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 944081******2003 LGD_FINANCEAUTHNUM = 24752918 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = ec66d5c2fe51febf32f61f62059fcf6f LGD_BUYERADDRESS = LGD_FINANCENAME = 외환 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20210205094733 LGD_PCANCELSTR = 0 LGD_BUYER = 김호순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020509473160176 LGD_BUYERID = LGD_OID = Direct-dongjo-1612485426 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-05 09:47:26======================== insert into mBoard_order set rOrdNo = 'Direct-dongjo-1612485426', AuthTy = 'card', memberId = 'dongjo', OrdNm ='김호순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)동조', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '외환 944081******2003', rApprNo = 'mjsof2021020509473160176', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 09:47:26', InvoiceNum = '결제성공:Direct-dongjo-1612485426/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 09:47:26' ========================2021-02-05 09:47:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020509473160176' 0 = 1 cnt = 1 ========================2021-02-05 09:47:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongjo' 0 = dongjo Mid = dongjo 1 = (주)동조 Mcompany = (주)동조 2 = 1108121335 companyNum = 1108121335 3 = 02-730-8228 Mtel1 = 02-730-8228 4 = 010-8705-8756 Mhp = 010-8705-8756 ========================2021-02-05 09:47:26======================== select * from customers where id = 'dongjo' ========================2021-02-05 09:47:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongjo','2021-02-05 09:47:26','52500','55000','온라인','0') ========================2021-02-05 09:51:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-seorinsangsa-1612486264 LGD_BUYER = 정인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205095104 LGD_HASHDATA = e9a645f2cd3f7cc0698e92deb869e0cd LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021020509520373A0D61497E5B6610A0F9B791D5EE00A1425BFD8 Mname = 정인숙 Mcompany = 서린상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = seorinsangsa LGD_ESCROW_USEYN = N ========================2021-02-05 09:51:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205095203 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 417103******0909 LGD_FINANCEAUTHNUM = 58020835 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0bb7f83d133f250a50eaa391e9705a92 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210205095204 LGD_PCANCELSTR = 0 LGD_BUYER = 정인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020509520361181 LGD_BUYERID = LGD_OID = Direct-seorinsangsa-1612486264 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 509520361124 ========================2021-02-05 09:51:57======================== insert into mBoard_order set rOrdNo = 'Direct-seorinsangsa-1612486264', AuthTy = 'card', memberId = 'seorinsangsa', OrdNm ='정인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서린상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 417103******0909', rApprNo = 'mjsof2021020509520361181', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 09:51:57', InvoiceNum = '결제성공:Direct-seorinsangsa-1612486264/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 09:51:57' ========================2021-02-05 09:51:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020509520361181' 0 = 1 cnt = 1 ========================2021-02-05 09:51:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'seorinsangsa' 0 = seorinsangsa Mid = seorinsangsa 1 = 서린상사 Mcompany = 서린상사 2 = 1378623385 companyNum = 1378623385 3 = 032-562-2057 Mtel1 = 032-562-2057 4 = 010-5423-2057 Mhp = 010-5423-2057 ========================2021-02-05 09:51:57======================== select * from customers where id = 'seorinsangsa' ========================2021-02-05 09:51:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('seorinsangsa','2021-02-05 09:51:57','220000','220000','온라인','0') ========================2021-02-05 13:21:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tjswn0807-1612498735 LGD_BUYER = 이승헌 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205131855 LGD_HASHDATA = 41b9ca293a967975bad03829ee20b640 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202102051321546A1C8D589379FEBEF919A6F21DCB0FCFD48EA8B5 Mname = 이승헌 Mcompany = 팩하우스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tjswn0807 LGD_ESCROW_USEYN = N ========================2021-02-05 13:21:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205132154 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ALMA1U LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 445090******3130 LGD_FINANCEAUTHNUM = 01133253 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b2b204df3a770c39342366cf1c248004 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210205132154 LGD_PCANCELSTR = 0 LGD_BUYER = 이승헌 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020513215460246 LGD_BUYERID = LGD_OID = Direct-tjswn0807-1612498735 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-05 13:21:47======================== insert into mBoard_order set rOrdNo = 'Direct-tjswn0807-1612498735', AuthTy = 'card', memberId = 'tjswn0807', OrdNm ='이승헌', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '팩하우스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한VISA 445090******3130', rApprNo = 'mjsof2021020513215460246', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 13:21:47', InvoiceNum = '결제성공:Direct-tjswn0807-1612498735/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 13:21:47' ========================2021-02-05 13:21:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020513215460246' 0 = 1 cnt = 1 ========================2021-02-05 13:21:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tjswn0807' 0 = tjswn0807 Mid = tjswn0807 1 = 팩하우스 Mcompany = 팩하우스 2 = 127-43-13471 companyNum = 127-43-13471 3 = 031-827-5107 Mtel1 = 031-827-5107 4 = 010-5493-5107 Mhp = 010-5493-5107 ========================2021-02-05 13:21:47======================== select * from customers where id = 'tjswn0807' ========================2021-02-05 13:21:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tjswn0807','2021-02-05 13:21:47','30900','33000','온라인','0') ========================2021-02-05 15:16:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodduck-1612505691 LGD_BUYER = 박찬우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205151451 LGD_HASHDATA = 22ce54d456c745f39d74934393cedf11 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210205151641BF01944B6BA9B57D76DBFFFB3951194F4B40EB93 Mname = 박찬우 Mcompany = 농업회사법인 더조은푸드(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = goodduck LGD_ESCROW_USEYN = N ========================2021-02-05 15:16:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205151642 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tje5683@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 626415******7916 LGD_FINANCEAUTHNUM = 60582744 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8e9db64bfc094891d1eff017e1260d18 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210205151643 LGD_PCANCELSTR = 0 LGD_BUYER = 박찬우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020515164261178 LGD_BUYERID = LGD_OID = Direct-goodduck-1612505691 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 515164261189 ========================2021-02-05 15:16:36======================== insert into mBoard_order set rOrdNo = 'Direct-goodduck-1612505691', AuthTy = 'card', memberId = 'goodduck', OrdNm ='박찬우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '농업회사법인 더조은푸드(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 626415******7916', rApprNo = 'mjsof2021020515164261178', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 15:16:36', InvoiceNum = '결제성공:Direct-goodduck-1612505691/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 15:16:36' ========================2021-02-05 15:16:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020515164261178' 0 = 1 cnt = 1 ========================2021-02-05 15:16:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodduck' 0 = goodduck Mid = goodduck 1 = 농업회사법인 더조은푸드(주) Mcompany = 농업회사법인 더조은푸드(주) 2 = 656-87-00987 companyNum = 656-87-00987 3 = 031-352-0825 Mtel1 = 031-352-0825 4 = 010-8001-5289 Mhp = 010-8001-5289 ========================2021-02-05 15:16:36======================== select * from customers where id = 'goodduck' ========================2021-02-05 15:16:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodduck','2021-02-05 15:16:36','52500','55000','온라인','0') ========================2021-02-05 16:32:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dream1admin-1612510324 LGD_BUYER = 김영석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210205163204 LGD_HASHDATA = d5abde1478c5526e580e93bc1fb2d9d0 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210205163258CB50AF53C0BAB2714955A3D4865147480B4BC7E2 Mname = 김영석 Mcompany = 드림엠앤에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dream1admin LGD_ESCROW_USEYN = N ========================2021-02-05 16:32:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210205163258 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******1467 LGD_FINANCEAUTHNUM = 03271843 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea880ec023edb4d0eaf285e5fa595fa2 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210205163259 LGD_PCANCELSTR = 0 LGD_BUYER = 김영석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020516325860012 LGD_BUYERID = LGD_OID = Direct-dream1admin-1612510324 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-05 16:32:52======================== insert into mBoard_order set rOrdNo = 'Direct-dream1admin-1612510324', AuthTy = 'card', memberId = 'dream1admin', OrdNm ='김영석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '드림엠앤에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 490298******1467', rApprNo = 'mjsof2021020516325860012', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-05 16:32:52', InvoiceNum = '결제성공:Direct-dream1admin-1612510324/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-05 16:32:52' ========================2021-02-05 16:32:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020516325860012' 0 = 1 cnt = 1 ========================2021-02-05 16:32:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dream1admin' 0 = dream1admin Mid = dream1admin 1 = 드림엠앤에스 Mcompany = 드림엠앤에스 2 = 2638100288 companyNum = 2638100288 3 = 010-9095-8778 Mtel1 = 010-9095-8778 4 = 010-8814-6666 Mhp = 010-8814-6666 ========================2021-02-05 16:32:52======================== select * from customers where id = 'dream1admin' ========================2021-02-05 16:32:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dream1admin','2021-02-05 16:32:52','108000','110000','온라인','0')