========================2023-01-31 09:34:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-supper2000-1675125123 LGD_BUYER = 김겸 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131093203 LGD_HASHDATA = 26a92549fea6a8b3c010369af8789528 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 = 20230131093948F1F0B1EDE507707E9EBA1FA828B21B0CE02C7CC3 Mname = 김겸 Mcompany = 동부보육사/동부소독 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = supper2000 LGD_ESCROW_USEYN = N ========================2023-01-31 09:34:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131093950 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 = 94311702****258* LGD_FINANCEAUTHNUM = 63119034 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = a94414b90a518e7c42ab7a1bd78a6e91 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230131093950 LGD_PCANCELSTR = 0 LGD_BUYER = 김겸 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20230131093950TDyj3 LGD_BUYERID = LGD_OID = Direct-supper2000-1675125123 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-01-31 09:34:41======================== insert into mBoard_order set rOrdNo = 'Direct-supper2000-1675125123', AuthTy = 'card', memberId = 'supper2000', OrdNm ='김겸', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동부보육사/동부소독', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH 94311702****258*', rApprNo = 'mjsof20230131093950TDyj3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 09:34:41', InvoiceNum = '결제성공:Direct-supper2000-1675125123/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 09:34:41' ========================2023-01-31 09:34:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131093950TDyj3' 0 = 1 cnt = 1 ========================2023-01-31 09:34:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'supper2000' 0 = supper2000 Mid = supper2000 1 = 동부보육사/동부소독 Mcompany = 동부보육사/동부소독 2 = 8422300475 companyNum = 8422300475 3 = 010-6340-9953 Mtel1 = 010-6340-9953 4 = 010-6340-9953 Mhp = 010-6340-9953 ========================2023-01-31 09:34:41======================== select * from customers where id = 'supper2000' ========================2023-01-31 09:34:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('supper2000','2023-01-31 09:34:41','10000','11000','온라인','0') ========================2023-01-31 09:43:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-baekdoo312-1675125674 LGD_BUYER = 고민재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131094114 LGD_HASHDATA = 9cbf5b8370af3a3f02db657a1bb72164 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 = 20230131094821E125BE2EC8A5AE25F4031A47C21779BF1B34CA1D Mname = 고민재 Mcompany = 승도배관 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = baekdoo312 LGD_ESCROW_USEYN = N ========================2023-01-31 09:43:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131094822 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = baekdoo312@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 001664 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52728922****109* LGD_FINANCEAUTHNUM = 30005429 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = fa96f42e5c785c25204fbc211851c0b9 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230131094822 LGD_PCANCELSTR = 0 LGD_BUYER = 고민재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20230131094822UylR1 LGD_BUYERID = LGD_OID = Direct-baekdoo312-1675125674 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-01-31 09:43:12======================== insert into mBoard_order set rOrdNo = 'Direct-baekdoo312-1675125674', AuthTy = 'card', memberId = 'baekdoo312', OrdNm ='고민재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승도배관', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 52728922****109*', rApprNo = 'mjsof20230131094822UylR1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 09:43:12', InvoiceNum = '결제성공:Direct-baekdoo312-1675125674/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 09:43:12' ========================2023-01-31 09:43:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131094822UylR1' 0 = 1 cnt = 1 ========================2023-01-31 09:43:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'baekdoo312' 0 = baekdoo312 Mid = baekdoo312 1 = 승도배관 Mcompany = 승도배관 2 = 377-07-02284 companyNum = 377-07-02284 3 = 010-2285-0591 Mtel1 = 010-2285-0591 4 = 010-2285-0581 Mhp = 010-2285-0581 ========================2023-01-31 09:43:13======================== select * from customers where id = 'baekdoo312' ========================2023-01-31 09:43:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('baekdoo312','2023-01-31 09:43:12','52500','55000','온라인','0') ========================2023-01-31 13:35:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-psh4788-1675139689 LGD_BUYER = 박수희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131133449 LGD_HASHDATA = 54aa2725f7ed07612ee7b84594f536a1 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 = 202301311341043D938D95D5C6A126D2377D272ACDD5EB57586B70 Mname = 박수희 Mcompany = 디자인휀스산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = psh4788 LGD_ESCROW_USEYN = N ========================2023-01-31 13:35:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131134105 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 040633 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94400307****192* LGD_FINANCEAUTHNUM = 30653698 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 941223412941614f21a91da9db974112 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230131134106 LGD_PCANCELSTR = 0 LGD_BUYER = 박수희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131134105Ll9y6 LGD_BUYERID = LGD_OID = Direct-psh4788-1675139689 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1134105Lvbh3 ========================2023-01-31 13:37:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-psh4788-1675139802 LGD_BUYER = 박수희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131133642 LGD_HASHDATA = 19c99762fd146e8b8890681e08c3f4bf 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 = 20230131134230CBD9908FDA82623972D28B057158E3892E41630F Mname = 박수희 Mcompany = 디자인휀스산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = psh4788 LGD_ESCROW_USEYN = N ========================2023-01-31 13:37:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131134230 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 738987 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300308****395* LGD_FINANCEAUTHNUM = 30648579 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ddb4e7ddd9604a21d027912992bbbf66 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230131134231 LGD_PCANCELSTR = 0 LGD_BUYER = 박수희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131134230VfVH7 LGD_BUYERID = LGD_OID = Direct-psh4788-1675139802 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1134230VU3S4 ========================2023-01-31 15:58:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1675148246 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131155726 LGD_HASHDATA = 879973edcd59d50b527c7953e5ae7f57 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 = 2023013116031377524736F28F30BD0EBBBBB0890B9F566080C557 Mname = 박재호 Mcompany = 주식회사 극광 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2023-01-31 15:58:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131160314 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52297100****685* LGD_FINANCEAUTHNUM = 30042053 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3a750061dc20824036a3981b82b829f9 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230131160314 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131160314VrDg2 LGD_BUYERID = LGD_OID = Direct-parkco6338-1675148246 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1160314VY2C2 ========================2023-01-31 15:58:04======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1675148246', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 극광', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 52297100****685*', rApprNo = 'mjsof20230131160314VrDg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 15:58:04', InvoiceNum = '결제성공:Direct-parkco6338-1675148246/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 15:58:04' ========================2023-01-31 15:58:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131160314VrDg2' 0 = 1 cnt = 1 ========================2023-01-31 15:58:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = 주식회사 극광 Mcompany = 주식회사 극광 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2023-01-31 15:58:04======================== select * from customers where id = 'parkco6338' ========================2023-01-31 15:58:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2023-01-31 15:58:04','220000','220000','온라인','0') ========================2023-01-31 16:02:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjs8862-1675148452 LGD_BUYER = 정정수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131160052 LGD_HASHDATA = 1e698d7dc30a8e2ad4ea34ced88024c1 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 = 20230131160721B119F7212C2FF5223ACC0E1E1D88A9F43C09EB5E Mname = 정정수 Mcompany = (주)엘리스메드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jjs8862 LGD_ESCROW_USEYN = N ========================2023-01-31 16:02:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131160721 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850308****796* LGD_FINANCEAUTHNUM = 33196227 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7bd7017defd52f6039724ea18b9c4771 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230131160722 LGD_PCANCELSTR = 0 LGD_BUYER = 정정수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131160721SQv66 LGD_BUYERID = LGD_OID = Direct-jjs8862-1675148452 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1160721S9fL3 ========================2023-01-31 16:02:12======================== insert into mBoard_order set rOrdNo = 'Direct-jjs8862-1675148452', AuthTy = 'card', memberId = 'jjs8862', OrdNm ='정정수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘리스메드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850308****796*', rApprNo = 'mjsof20230131160721SQv66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 16:02:12', InvoiceNum = '결제성공:Direct-jjs8862-1675148452/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 16:02:12' ========================2023-01-31 16:02:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131160721SQv66' 0 = 1 cnt = 1 ========================2023-01-31 16:02:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjs8862' 0 = jjs8862 Mid = jjs8862 1 = (주)엘리스메드 Mcompany = (주)엘리스메드 2 = 8748600249 companyNum = 8748600249 3 = 055-381-5771 Mtel1 = 055-381-5771 4 = 010-6382-5771 Mhp = 010-6382-5771 ========================2023-01-31 16:02:12======================== select * from customers where id = 'jjs8862' ========================2023-01-31 16:02:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjs8862','2023-01-31 16:02:12','108000','110000','온라인','0') ========================2023-01-31 17:19:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-slove-1675153062 LGD_BUYER = 고동원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131171742 LGD_HASHDATA = ba9e2f9b87bfa9b0f3853bc174dc6513 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 = 202301311724136D525DD2EC0A4FA7DE0116697D207158A661F9F6 Mname = 고동원 Mcompany = 과학사랑 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = slove LGD_ESCROW_USEYN = N ========================2023-01-31 17:19:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131172414 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003239 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****587* LGD_FINANCEAUTHNUM = 30082213 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 94e949bd126833e32975ee0027087672 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230131172414 LGD_PCANCELSTR = 0 LGD_BUYER = 고동원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131172414QQ304 LGD_BUYERID = LGD_OID = Direct-slove-1675153062 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1172414Qoyl5 ========================2023-01-31 17:19:04======================== insert into mBoard_order set rOrdNo = 'Direct-slove-1675153062', AuthTy = 'card', memberId = 'slove', OrdNm ='고동원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '과학사랑', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****587*', rApprNo = 'mjsof20230131172414QQ304', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 17:19:04', InvoiceNum = '결제성공:Direct-slove-1675153062/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 17:19:04' ========================2023-01-31 17:19:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131172414QQ304' 0 = 1 cnt = 1 ========================2023-01-31 17:19:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'slove' 0 = slove Mid = slove 1 = 과학사랑 Mcompany = 과학사랑 2 = 229-01-06029 companyNum = 229-01-06029 3 = 031-938-9594 Mtel1 = 031-938-9594 4 = 010-3930-9988 Mhp = 010-3930-9988 ========================2023-01-31 17:19:04======================== select * from customers where id = 'slove' ========================2023-01-31 17:19:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('slove','2023-01-31 17:19:04','108000','110000','온라인','0') ========================2023-01-31 18:32:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bigbrother-1675157480 LGD_BUYER = 신완철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230131183120 LGD_HASHDATA = 12a71356904a62c19429567679da0925 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 = 202301311837262F33950DFBB84641436EF366CBC916941A2C0A49 Mname = 신완철 Mcompany = (주)빅브라더 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = bigbrother LGD_ESCROW_USEYN = N ========================2023-01-31 18:32:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230131183727 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****400* LGD_FINANCEAUTHNUM = 34347276 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = acb9fba97ba83805fe4ecabe566e004e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230131183727 LGD_PCANCELSTR = 0 LGD_BUYER = 신완철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230131183727NiTM0 LGD_BUYERID = LGD_OID = Direct-bigbrother-1675157480 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1183727NUih7 ========================2023-01-31 18:32:17======================== insert into mBoard_order set rOrdNo = 'Direct-bigbrother-1675157480', AuthTy = 'card', memberId = 'bigbrother', OrdNm ='신완철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)빅브라더', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 55892098****400*', rApprNo = 'mjsof20230131183727NiTM0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-31 18:32:17', InvoiceNum = '결제성공:Direct-bigbrother-1675157480/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-31 18:32:17' ========================2023-01-31 18:32:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230131183727NiTM0' 0 = 1 cnt = 1 ========================2023-01-31 18:32:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bigbrother' 0 = bigbrother Mid = bigbrother 1 = (주)빅브라더 Mcompany = (주)빅브라더 2 = 7828800717 companyNum = 7828800717 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7747-5701 Mhp = 010-7747-5701 ========================2023-01-31 18:32:18======================== select * from customers where id = 'bigbrother' ========================2023-01-31 18:32:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bigbrother','2023-01-31 18:32:17','220000','220000','온라인','0')