========================2021-08-04 08:29:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1628033310 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804082830 LGD_HASHDATA = 0f8aeb96c0e699eef0d56e938fa29988 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 = 2021080408302016E9EA33381340CFBF414ECBBA9E9560XAV6NJVO Mname = 이승환 Mcompany = (주)엘엔에이치바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = landhbio LGD_ESCROW_USEYN = N ========================2021-08-04 08:29:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804083020 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******4303 LGD_FINANCEAUTHNUM = 53061176 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e2745d1e468f4e37860a3b28aa51425b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210804083020 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080408302061178 LGD_BUYERID = LGD_OID = Direct-landhbio-1628033310 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 408302061104 ========================2021-08-04 08:29:22======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1628033310', AuthTy = 'card', memberId = 'landhbio', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘엔에이치바이오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리VISA 410120******4303', rApprNo = 'mjsof2021080408302061178', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 08:29:22', InvoiceNum = '결제성공:Direct-landhbio-1628033310/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 08:29:22' ========================2021-08-04 08:29:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080408302061178' 0 = 1 cnt = 1 ========================2021-08-04 08:29:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'landhbio' 0 = landhbio Mid = landhbio 1 = (주)엘엔에이치바이오 Mcompany = (주)엘엔에이치바이오 2 = 1448113110 companyNum = 1448113110 3 = 070-4111-0496 Mtel1 = 070-4111-0496 4 = 010-2703-0694 Mhp = 010-2703-0694 ========================2021-08-04 08:29:22======================== select * from customers where id = 'landhbio' ========================2021-08-04 08:29:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2021-08-04 08:29:22','52500','55000','온라인','0') ========================2021-08-04 09:57:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hiboyuksa-1628038575 LGD_BUYER = 김광식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804095615 LGD_HASHDATA = 6e4bdae3bd9b068cdbade6f6b7135fb4 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 = 20210804095855BF4AA605950B495FB8329279808A4350KBTGCYZQ Mname = 김광식 Mcompany = 이천보육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hiboyuksa LGD_ESCROW_USEYN = N ========================2021-08-04 09:57:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804095855 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 403293******6711 LGD_FINANCEAUTHNUM = 00998925 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 78ac40cfc06172d6207e55dc20ace89b LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210804095856 LGD_PCANCELSTR = 0 LGD_BUYER = 김광식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080409585561098 LGD_BUYERID = LGD_OID = Direct-hiboyuksa-1628038575 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-04 09:57:57======================== insert into mBoard_order set rOrdNo = 'Direct-hiboyuksa-1628038575', AuthTy = 'card', memberId = 'hiboyuksa', OrdNm ='김광식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이천보육사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 403293******6711', rApprNo = 'mjsof2021080409585561098', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 09:57:57', InvoiceNum = '결제성공:Direct-hiboyuksa-1628038575/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 09:57:57' ========================2021-08-04 09:57:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080409585561098' 0 = 1 cnt = 1 ========================2021-08-04 09:57:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hiboyuksa' 0 = hiboyuksa Mid = hiboyuksa 1 = 이천보육사 Mcompany = 이천보육사 2 = 126-24-73854 companyNum = 126-24-73854 3 = 031-635-6380 Mtel1 = 031-635-6380 4 = 010-6359-6380 Mhp = 010-6359-6380 ========================2021-08-04 09:57:57======================== select * from customers where id = 'hiboyuksa' ========================2021-08-04 09:57:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hiboyuksa','2021-08-04 09:57:57','52500','55000','온라인','0') ========================2021-08-04 10:30:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1628040568 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804102928 LGD_HASHDATA = 7eb16dc4fa829f048747214c80bce1f5 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 = 202108041031298EC428C8AD614E8EB0E9229E12D278793A2KXZPY Mname = 오정호 Mcompany = 메인로드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kds1 LGD_ESCROW_USEYN = N ========================2021-08-04 10:30:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804103130 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******9875 LGD_FINANCEAUTHNUM = 30119217 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a32e53e45537e787fa9de2334598118e LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210804103130 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080410312961225 LGD_BUYERID = LGD_OID = Direct-kds1-1628040568 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 410312961234 ========================2021-08-04 10:30:31======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1628040568', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******9875', rApprNo = 'mjsof2021080410312961225', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 10:30:31', InvoiceNum = '결제성공:Direct-kds1-1628040568/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 10:30:31' ========================2021-08-04 10:30:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080410312961225' 0 = 1 cnt = 1 ========================2021-08-04 10:30:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kds1' 0 = kds1 Mid = kds1 1 = 메인로드 Mcompany = 메인로드 2 = 1180300092 companyNum = 1180300092 3 = 031-267-3340 Mtel1 = 031-267-3340 4 = 010-8680-1206 Mhp = 010-8680-1206 ========================2021-08-04 10:30:31======================== select * from customers where id = 'kds1' ========================2021-08-04 10:30:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2021-08-04 10:30:31','52500','55000','온라인','0') ========================2021-08-04 10:35:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jihoostyle-1628040825 LGD_BUYER = 이봉석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804103345 LGD_HASHDATA = 50a494eb37a89bdc10fb8d9e7307a305 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 = 202108041035591F8E6A2B80534AC8AC7DF797DF319B63LGIP0PXB Mname = 이봉석 Mcompany = 지후윤활유 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jihoostyle LGD_ESCROW_USEYN = N ========================2021-08-04 10:35:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804103600 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 = 468911******2357 LGD_FINANCEAUTHNUM = 66511209 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f1ffb76c9086c061a4c7f00a731c25fe LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210804103600 LGD_PCANCELSTR = 0 LGD_BUYER = 이봉석 LGD_CARDINSTALLMONTH = 06 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080410360060179 LGD_BUYERID = LGD_OID = Direct-jihoostyle-1628040825 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-04 10:35:01======================== insert into mBoard_order set rOrdNo = 'Direct-jihoostyle-1628040825', AuthTy = 'card', memberId = 'jihoostyle', OrdNm ='이봉석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '지후윤활유', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성VISA 468911******2357', rApprNo = 'mjsof2021080410360060179', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 10:35:01', InvoiceNum = '결제성공:Direct-jihoostyle-1628040825/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 10:35:01' ========================2021-08-04 10:35:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080410360060179' 0 = 1 cnt = 1 ========================2021-08-04 10:35:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jihoostyle' 0 = jihoostyle Mid = jihoostyle 1 = 지후윤활유 Mcompany = 지후윤활유 2 = 1245302197 companyNum = 1245302197 3 = 010-7616-8947 Mtel1 = 010-7616-8947 4 = 010-7616-8947 Mhp = 010-7616-8947 ========================2021-08-04 10:35:01======================== select * from customers where id = 'jihoostyle' ========================2021-08-04 10:35:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jihoostyle','2021-08-04 10:35:01','108000','110000','온라인','0') ========================2021-08-04 11:01:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bslube-1628042331 LGD_BUYER = 김수영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804105851 LGD_HASHDATA = 834c9ba3734430dbad111dd25aee41c0 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 = 2021080411022087A3431EBEC546EFBD05B3AB113C0A51CXJRPU9Q Mname = 김수영 Mcompany = (주)비에스루브 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bslube LGD_ESCROW_USEYN = N ========================2021-08-04 11:01:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804110220 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 = 553142******1115 LGD_FINANCEAUTHNUM = 00245776 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 975c7fe3820422db7f0e02109e3de090 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210804110221 LGD_PCANCELSTR = 0 LGD_BUYER = 김수영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080411022060199 LGD_BUYERID = LGD_OID = Direct-bslube-1628042331 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-04 11:01:22======================== insert into mBoard_order set rOrdNo = 'Direct-bslube-1628042331', AuthTy = 'card', memberId = 'bslube', OrdNm ='김수영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스루브', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '현대MASTER 553142******1115', rApprNo = 'mjsof2021080411022060199', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 11:01:22', InvoiceNum = '결제성공:Direct-bslube-1628042331/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 11:01:22' ========================2021-08-04 11:01:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080411022060199' 0 = 1 cnt = 1 ========================2021-08-04 11:01:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bslube' 0 = bslube Mid = bslube 1 = (주)비에스루브 Mcompany = (주)비에스루브 2 = 6178195508 companyNum = 6178195508 3 = 051-646-4163 Mtel1 = 051-646-4163 4 = 010-8514-5189 Mhp = 010-8514-5189 ========================2021-08-04 11:01:22======================== select * from customers where id = 'bslube' ========================2021-08-04 11:01:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bslube','2021-08-04 11:01:22','220000','220000','온라인','0') ========================2021-08-04 13:11:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-guil09-1628050214 LGD_BUYER = 최해국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804131014 LGD_HASHDATA = 146b62802ba0c6e35ceecec276027f44 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 = 2021080413124121BA2B85982B40E396D04E252E289605DPCK9B1Z Mname = 최해국 Mcompany = 구일종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = guil09 LGD_ESCROW_USEYN = N ========================2021-08-04 13:11:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804131241 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 = 457493******3029 LGD_FINANCEAUTHNUM = 00489219 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8314156d766f8cb243b1c723ba222e02 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210804131242 LGD_PCANCELSTR = 0 LGD_BUYER = 최해국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080413124161190 LGD_BUYERID = LGD_OID = Direct-guil09-1628050214 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-04 13:11:43======================== insert into mBoard_order set rOrdNo = 'Direct-guil09-1628050214', AuthTy = 'card', memberId = 'guil09', OrdNm ='최해국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '구일종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 457493******3029', rApprNo = 'mjsof2021080413124161190', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 13:11:43', InvoiceNum = '결제성공:Direct-guil09-1628050214/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 13:11:43' ========================2021-08-04 13:11:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080413124161190' 0 = 1 cnt = 1 ========================2021-08-04 13:11:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'guil09' 0 = guil09 Mid = guil09 1 = 구일종합상사 Mcompany = 구일종합상사 2 = 3052186849 companyNum = 3052186849 3 = 010-4224-4146 Mtel1 = 010-4224-4146 4 = 010-4224-4146 Mhp = 010-4224-4146 ========================2021-08-04 13:11:43======================== select * from customers where id = 'guil09' ========================2021-08-04 13:11:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('guil09','2021-08-04 13:11:43','108000','110000','온라인','0') ========================2021-08-04 13:14:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hch2860-1628050332 LGD_BUYER = 한철희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804131212 LGD_HASHDATA = 530c9fb13bd6c4a6f3f434f120c7ad88 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 = 20210804131535C8E8DEE9915944A7B7291CA53BB1F61ELP5EJNWF Mname = 한철희 Mcompany = 주식회사 뜰아래 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hch2860 LGD_ESCROW_USEYN = N ========================2021-08-04 13:14:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804131536 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******4923 LGD_FINANCEAUTHNUM = 54739842 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8d11c7ff5525eee617f4bb3af0bcc3cd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210804131536 LGD_PCANCELSTR = 0 LGD_BUYER = 한철희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080413153561169 LGD_BUYERID = LGD_OID = Direct-hch2860-1628050332 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 413153561136 ========================2021-08-04 13:14:37======================== insert into mBoard_order set rOrdNo = 'Direct-hch2860-1628050332', AuthTy = 'card', memberId = 'hch2860', OrdNm ='한철희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 뜰아래', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******4923', rApprNo = 'mjsof2021080413153561169', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 13:14:37', InvoiceNum = '결제성공:Direct-hch2860-1628050332/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 13:14:37' ========================2021-08-04 13:14:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080413153561169' 0 = 1 cnt = 1 ========================2021-08-04 13:14:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hch2860' 0 = hch2860 Mid = hch2860 1 = 주식회사 뜰아래 Mcompany = 주식회사 뜰아래 2 = 653-87-00047 companyNum = 653-87-00047 3 = 010-7196-4089 Mtel1 = 010-7196-4089 4 = 010-3311-2692 Mhp = 010-3311-2692 ========================2021-08-04 13:14:37======================== select * from customers where id = 'hch2860' ========================2021-08-04 13:14:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hch2860','2021-08-04 13:14:37','52500','55000','온라인','0') ========================2021-08-04 14:26:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-medday77-1628054254 LGD_BUYER = 장춘식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804141734 LGD_HASHDATA = 3b34c9fab8e84d2654e96225fe4570ec 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 = 20210804142723F235ECFF645640B1BC808D74A5E36F2APYQSDGF1 Mname = 장춘식 Mcompany = (주)메드데이코리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = medday77 LGD_ESCROW_USEYN = N ========================2021-08-04 14:26:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804142724 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = meddaykorea@naver.com 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******6712 LGD_FINANCEAUTHNUM = 12889346 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 08ba4c8c4dc648d8347b3a07770aabd2 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210804142724 LGD_PCANCELSTR = 0 LGD_BUYER = 장춘식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080414272461138 LGD_BUYERID = LGD_OID = Direct-medday77-1628054254 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-08-04 14:26:25======================== insert into mBoard_order set rOrdNo = 'Direct-medday77-1628054254', AuthTy = 'card', memberId = 'medday77', OrdNm ='장춘식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)메드데이코리아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한VISA 490298******6712', rApprNo = 'mjsof2021080414272461138', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 14:26:25', InvoiceNum = '결제성공:Direct-medday77-1628054254/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 14:26:25' ========================2021-08-04 14:26:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080414272461138' 0 = 1 cnt = 1 ========================2021-08-04 14:26:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'medday77' 0 = medday77 Mid = medday77 1 = (주)메드데이코리아 Mcompany = (주)메드데이코리아 2 = 1448123205 companyNum = 1448123205 3 = 031-8016-1045 Mtel1 = 031-8016-1045 4 = 010-8950-0054 Mhp = 010-8950-0054 ========================2021-08-04 14:26:25======================== select * from customers where id = 'medday77' ========================2021-08-04 14:26:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('medday77','2021-08-04 14:26:25','30900','33000','온라인','0') ========================2021-08-04 14:48:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nanum1068-1628055992 LGD_BUYER = 이용진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210804144632 LGD_HASHDATA = a13a23991bc614da59fe364ddcecda45 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 = 202108041449167D745CA6CC9B40A593B3EAD75F9F5E61QFOVJ3S5 Mname = 이용진 Mcompany = 글로벌푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nanum1068 LGD_ESCROW_USEYN = N ========================2021-08-04 14:48:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210804144916 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******5934 LGD_FINANCEAUTHNUM = 55557684 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0acb12a8f2f4b6d1f7c044873c353b49 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210804144917 LGD_PCANCELSTR = 0 LGD_BUYER = 이용진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021080414491660229 LGD_BUYERID = LGD_OID = Direct-nanum1068-1628055992 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 414491660255 ========================2021-08-04 14:48:18======================== insert into mBoard_order set rOrdNo = 'Direct-nanum1068-1628055992', AuthTy = 'card', memberId = 'nanum1068', OrdNm ='이용진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '글로벌푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******5934', rApprNo = 'mjsof2021080414491660229', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-08-04 14:48:18', InvoiceNum = '결제성공:Direct-nanum1068-1628055992/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-08-04 14:48:18' ========================2021-08-04 14:48:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021080414491660229' 0 = 1 cnt = 1 ========================2021-08-04 14:48:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nanum1068' 0 = nanum1068 Mid = nanum1068 1 = 글로벌푸드 Mcompany = 글로벌푸드 2 = 4418101664 companyNum = 4418101664 3 = 070-7729-8157 Mtel1 = 070-7729-8157 4 = 010-3111-1068 Mhp = 010-3111-1068 ========================2021-08-04 14:48:18======================== select * from customers where id = 'nanum1068' ========================2021-08-04 14:48:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nanum1068','2021-08-04 14:48:18','108000','110000','온라인','0')