========================2022-07-29 08:46:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hty0077-1659051893 LGD_BUYER = 김순옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729084453 LGD_HASHDATA = dd4477cb3f1e80a66c6c2b7bcb3ad074 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 = 20220729084836CE1093CBF03BFDEDC2E083FC406F9EA630D4CBC4 Mname = 김순옥 Mcompany = 세림금속 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hty0077 LGD_ESCROW_USEYN = N ========================2022-07-29 08:46:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729084837 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 = 49029841****791* LGD_FINANCEAUTHNUM = 07619645 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ed18ff9675dba801b7977c7762fa17dc LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220729084837 LGD_PCANCELSTR = 0 LGD_BUYER = 김순옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729084837yyE17 LGD_BUYERID = LGD_OID = Direct-hty0077-1659051893 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 08:46:54======================== insert into mBoard_order set rOrdNo = 'Direct-hty0077-1659051893', AuthTy = 'card', memberId = 'hty0077', OrdNm ='김순옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세림금속', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****791*', rApprNo = 'mjsof20220729084837yyE17', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 08:46:54', InvoiceNum = '결제성공:Direct-hty0077-1659051893/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 08:46:54' ========================2022-07-29 08:46:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729084837yyE17' 0 = 1 cnt = 1 ========================2022-07-29 08:46:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hty0077' 0 = hty0077 Mid = hty0077 1 = 세림금속 Mcompany = 세림금속 2 = 314-86-08375 companyNum = 314-86-08375 3 = 042-931-8103 Mtel1 = 042-931-8103 4 = 010-3116-3015 Mhp = 010-3116-3015 ========================2022-07-29 08:46:54======================== select * from customers where id = 'hty0077' ========================2022-07-29 08:46:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hty0077','2022-07-29 08:46:54','220000','220000','온라인','0') ========================2022-07-29 10:13:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cschem2010-1659057127 LGD_BUYER = 안준식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729101207 LGD_HASHDATA = 107c40768bc47da458902c2016782e0d 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 = 202207291014478E419BB815F29FFEEE60029A4847B53FA6DF03BB Mname = 안준식 Mcompany = (주)블루마운트 테크놀러지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = cschem2010 LGD_ESCROW_USEYN = N ========================2022-07-29 10:13:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729101447 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = one@bluemountec.com 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 = 55888100****913* LGD_FINANCEAUTHNUM = 17764548 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f51a095cb58c7a1d8294fcfc2479ae4a LGD_BUYERADDRESS = LGD_FINANCENAME = 외환MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20220729101447 LGD_PCANCELSTR = 0 LGD_BUYER = 안준식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729101447zPau4 LGD_BUYERID = LGD_OID = Direct-cschem2010-1659057127 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 10:13:04======================== insert into mBoard_order set rOrdNo = 'Direct-cschem2010-1659057127', AuthTy = 'card', memberId = 'cschem2010', OrdNm ='안준식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루마운트 테크놀러지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '외환MASTER 55888100****913*', rApprNo = 'mjsof20220729101447zPau4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 10:13:04', InvoiceNum = '결제성공:Direct-cschem2010-1659057127/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 10:13:04' ========================2022-07-29 10:13:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729101447zPau4' 0 = 1 cnt = 1 ========================2022-07-29 10:13:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cschem2010' 0 = cschem2010 Mid = cschem2010 1 = (주)블루마운트 테크놀러지 Mcompany = (주)블루마운트 테크놀러지 2 = 3028101578 companyNum = 3028101578 3 = 043-733-0055 Mtel1 = 043-733-0055 4 = 010-5920-0916 Mhp = 010-5920-0916 ========================2022-07-29 10:13:04======================== select * from customers where id = 'cschem2010' ========================2022-07-29 10:13:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cschem2010','2022-07-29 10:13:04','108000','110000','온라인','0') ========================2022-07-29 10:45:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1659059059 LGD_BUYER = 이성춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729104419 LGD_HASHDATA = 5023ee707baccc3946e044732fa73956 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 = 20220729104706F4B89146E6A95232BE4612E66DE32ED41AB69BA2 Mname = 이성춘 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2022-07-29 10:45:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729104707 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****181* LGD_FINANCEAUTHNUM = 30090948 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8cbf69c7b9b0110d23d8f1733e738cbd LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220729104707 LGD_PCANCELSTR = 0 LGD_BUYER = 이성춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729104707yIPQ0 LGD_BUYERID = LGD_OID = Direct-uksung1966-1659059059 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9104707yYlN1 ========================2022-07-29 10:47:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-uksung1966-1659059227 LGD_BUYER = 이성춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729104707 LGD_HASHDATA = 74c57d0afe61da4658f4f6073e115242 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 = 2022072910493197BC25B57BC981B752E071DD678F6EA71C2266D9 Mname = 이성춘 Mcompany = 욱성화학공업사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = uksung1966 LGD_ESCROW_USEYN = N ========================2022-07-29 10:47:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729104932 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = uksung1966@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003302 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****181* LGD_FINANCEAUTHNUM = 30090959 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1a90f9e1c18339f5a8aee752e0b399d8 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220729104932 LGD_PCANCELSTR = 0 LGD_BUYER = 이성춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729104932CPm86 LGD_BUYERID = LGD_OID = Direct-uksung1966-1659059227 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9104932CVfJ3 ========================2022-07-29 10:47:49======================== insert into mBoard_order set rOrdNo = 'Direct-uksung1966-1659059227', AuthTy = 'card', memberId = 'uksung1966', OrdNm ='이성춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '욱성화학공업사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****181*', rApprNo = 'mjsof20220729104932CPm86', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 10:47:49', InvoiceNum = '결제성공:Direct-uksung1966-1659059227/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 10:47:49' ========================2022-07-29 10:47:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729104932CPm86' 0 = 1 cnt = 1 ========================2022-07-29 10:47:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'uksung1966' 0 = uksung1966 Mid = uksung1966 1 = 욱성화학공업사 Mcompany = 욱성화학공업사 2 = 113-05-62312 companyNum = 113-05-62312 3 = 031-949-4516 Mtel1 = 031-949-4516 4 = 010-4749-2036 Mhp = 010-4749-2036 ========================2022-07-29 10:47:49======================== select * from customers where id = 'uksung1966' ========================2022-07-29 10:47:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('uksung1966','2022-07-29 10:47:49','108000','110000','온라인','0') ========================2022-07-29 11:26:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phceramic-1659061414 LGD_BUYER = 박세환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729112334 LGD_HASHDATA = 029bfe73360b5920fa3015dc678a8a29 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 = 20220729112747C5DCCA2A057DE4A4D0E8E92CE1BFF3B1DF821B99 Mname = 박세환 Mcompany = (주) 가우디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = phceramic LGD_ESCROW_USEYN = N ========================2022-07-29 11:26:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729112747 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003345 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94364634****703* LGD_FINANCEAUTHNUM = 30000350 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = b95876675289637cdc6904e42a729ed4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220729112747 LGD_PCANCELSTR = 0 LGD_BUYER = 박세환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729112747x3WG0 LGD_BUYERID = LGD_OID = Direct-phceramic-1659061414 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 11:26:04======================== insert into mBoard_order set rOrdNo = 'Direct-phceramic-1659061414', AuthTy = 'card', memberId = 'phceramic', OrdNm ='박세환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주) 가우디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민 94364634****703*', rApprNo = 'mjsof20220729112747x3WG0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 11:26:04', InvoiceNum = '결제성공:Direct-phceramic-1659061414/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 11:26:04' ========================2022-07-29 11:26:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729112747x3WG0' 0 = 1 cnt = 1 ========================2022-07-29 11:26:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phceramic' 0 = phceramic Mid = phceramic 1 = (주) 가우디 Mcompany = (주) 가우디 2 = 1418601018 companyNum = 1418601018 3 = 010-8989-5709 Mtel1 = 010-8989-5709 4 = 010-8989-5709 Mhp = 010-8989-5709 ========================2022-07-29 11:26:04======================== select * from customers where id = 'phceramic' ========================2022-07-29 11:26:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phceramic','2022-07-29 11:26:04','30900','33000','온라인','0') ========================2022-07-29 12:04:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-boysdream-1659063772 LGD_BUYER = 유현일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729120252 LGD_HASHDATA = b8b2fd011e521800d0d64fe8b5aaeb6d 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 = 202207291205447CA437F68528722AA74D341F961A5736D138A1E9 Mname = 유현일 Mcompany = 유진메디칼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = boysdream LGD_ESCROW_USEYN = N ========================2022-07-29 12:04:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729120544 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 = 91000300****928* LGD_FINANCEAUTHNUM = 56349370 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 76f7894e32b4bdea2fe6166ca598aad6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220729120545 LGD_PCANCELSTR = 0 LGD_BUYER = 유현일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729120544rNJB3 LGD_BUYERID = LGD_OID = Direct-boysdream-1659063772 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9120544rF2Q0 ========================2022-07-29 12:04:01======================== insert into mBoard_order set rOrdNo = 'Direct-boysdream-1659063772', AuthTy = 'card', memberId = 'boysdream', OrdNm ='유현일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '유진메디칼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 91000300****928*', rApprNo = 'mjsof20220729120544rNJB3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 12:04:01', InvoiceNum = '결제성공:Direct-boysdream-1659063772/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 12:04:01' ========================2022-07-29 12:04:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729120544rNJB3' 0 = 1 cnt = 1 ========================2022-07-29 12:04:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'boysdream' 0 = boysdream Mid = boysdream 1 = 유진메디칼 Mcompany = 유진메디칼 2 = 7943200090 companyNum = 7943200090 3 = 055-327-0085 Mtel1 = 055-327-0085 4 = 010-3848-8444 Mhp = 010-3848-8444 ========================2022-07-29 12:04:01======================== select * from customers where id = 'boysdream' ========================2022-07-29 12:04:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('boysdream','2022-07-29 12:04:01','108000','110000','온라인','0') ========================2022-07-29 13:50:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sun1002-1659070170 LGD_BUYER = 권미향 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729134930 LGD_HASHDATA = 5bdfe2d2a368e02f202440ef6a3912a2 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 = 20220729135210DCDE5FE2AA5F29A8137A94E4B1165E6F5FC84E2C Mname = 권미향 Mcompany = 락앤락총판 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = sun1002 LGD_ESCROW_USEYN = N ========================2022-07-29 13:50:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729135210 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62500307****898* LGD_FINANCEAUTHNUM = 57183089 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c9f433da362e0b63001fa7c134a2db5c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220729135211 LGD_PCANCELSTR = 0 LGD_BUYER = 권미향 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729135210z8o44 LGD_BUYERID = LGD_OID = Direct-sun1002-1659070170 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9135210zoKW6 ========================2022-07-29 13:50:27======================== insert into mBoard_order set rOrdNo = 'Direct-sun1002-1659070170', AuthTy = 'card', memberId = 'sun1002', OrdNm ='권미향', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '락앤락총판', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨CUP 62500307****898*', rApprNo = 'mjsof20220729135210z8o44', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 13:50:27', InvoiceNum = '결제성공:Direct-sun1002-1659070170/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 13:50:27' ========================2022-07-29 13:50:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729135210z8o44' 0 = 1 cnt = 1 ========================2022-07-29 13:50:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sun1002' 0 = sun1002 Mid = sun1002 1 = 락앤락총판 Mcompany = 락앤락총판 2 = 6228507362 companyNum = 6228507362 3 = 031-564-5266 Mtel1 = 031-564-5266 4 = 010-3914-9308 Mhp = 010-3914-9308 ========================2022-07-29 13:50:27======================== select * from customers where id = 'sun1002' ========================2022-07-29 13:50:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sun1002','2022-07-29 13:50:27','30900','33000','온라인','0') ========================2022-07-29 17:24:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hohoajc-1659082892 LGD_BUYER = 이규민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729172132 LGD_HASHDATA = 8641e0e13b8b329160e92a3de644b1d4 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 = 20220729172601D6A5E5704749E55E6C9B8D00889FAC0EA7AF1D1B Mname = 이규민 Mcompany = 우창유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hohoajc LGD_ESCROW_USEYN = N ========================2022-07-29 17:24:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729172602 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 = 379183******625 LGD_FINANCEAUTHNUM = 16090221 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 59039b5e7e39c459807c1fbe8db102b1 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20220729172602 LGD_PCANCELSTR = 0 LGD_BUYER = 이규민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729172602FsOS6 LGD_BUYERID = LGD_OID = Direct-hohoajc-1659082892 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 17:26:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hohoajc-1659083117 LGD_BUYER = 이규민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729172517 LGD_HASHDATA = bb867860eafc7ebb22eb978aac3e6bc8 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 = 2022072917282468472929D89CB926AB7D99D398844272A8413E65 Mname = 이규민 Mcompany = 우창유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hohoajc LGD_ESCROW_USEYN = N ========================2022-07-29 17:26:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729172825 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 = 379183******625 LGD_FINANCEAUTHNUM = 73055915 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 57f2f0352dce620a4ec01954c492989b LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20220729172825 LGD_PCANCELSTR = 0 LGD_BUYER = 이규민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729172825IawL1 LGD_BUYERID = LGD_OID = Direct-hohoajc-1659083117 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 17:38:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hohoajc-1659083871 LGD_BUYER = 이규민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729173751 LGD_HASHDATA = 0e1fedaf0c440dc00bc003957743aaad 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 = 20220729174017059211C90D09F5368BA8DC48389A971268ABDFF4 Mname = 이규민 Mcompany = 우창유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hohoajc LGD_ESCROW_USEYN = N ========================2022-07-29 17:38:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729174018 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 = 379183******625 LGD_FINANCEAUTHNUM = 55989915 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 78af01acb1ae4596735002aa8bd15d84 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20220729174019 LGD_PCANCELSTR = 0 LGD_BUYER = 이규민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729174018HVvh7 LGD_BUYERID = LGD_OID = Direct-hohoajc-1659083871 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 17:38:35======================== insert into mBoard_order set rOrdNo = 'Direct-hohoajc-1659083871', AuthTy = 'card', memberId = 'hohoajc', OrdNm ='이규민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우창유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성AMEX 379183******625', rApprNo = 'mjsof20220729174018HVvh7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 17:38:35', InvoiceNum = '결제성공:Direct-hohoajc-1659083871/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 17:38:35' ========================2022-07-29 17:38:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729174018HVvh7' 0 = 1 cnt = 1 ========================2022-07-29 17:38:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hohoajc' 0 = hohoajc Mid = hohoajc 1 = 우창유통 Mcompany = 우창유통 2 = 4650501671 companyNum = 4650501671 3 = 010-4921-1831 Mtel1 = 010-4921-1831 4 = 010-4921-1831 Mhp = 010-4921-1831 ========================2022-07-29 17:38:35======================== select * from customers where id = 'hohoajc' ========================2022-07-29 17:38:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hohoajc','2022-07-29 17:38:35','108000','110000','온라인','0') ========================2022-07-29 18:09:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ONGDALSEM-1659085653 LGD_BUYER = 이석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220729180733 LGD_HASHDATA = e3f15f771c1f7858a5dfb516666d2a87 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 = 20220729181056C48DF9EFFC94F3FF2008777DA109F08499ABD3D7 Mname = 이석 Mcompany = 옹달샘유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ONGDALSEM LGD_ESCROW_USEYN = N ========================2022-07-29 18:09:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220729181056 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852614****602* LGD_FINANCEAUTHNUM = 30017291 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e30fcab76512eb7069bd634b9ff19c3f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220729181056 LGD_PCANCELSTR = 0 LGD_BUYER = 이석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220729181056HXRM0 LGD_BUYERID = LGD_OID = Direct-ONGDALSEM-1659085653 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-29 18:09:12======================== insert into mBoard_order set rOrdNo = 'Direct-ONGDALSEM-1659085653', AuthTy = 'card', memberId = 'ONGDALSEM', OrdNm ='이석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '옹달샘유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852614****602*', rApprNo = 'mjsof20220729181056HXRM0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-29 18:09:12', InvoiceNum = '결제성공:Direct-ONGDALSEM-1659085653/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-29 18:09:12' ========================2022-07-29 18:09:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220729181056HXRM0' 0 = 1 cnt = 1 ========================2022-07-29 18:09:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ONGDALSEM' 0 = ongdalsem Mid = ongdalsem 1 = 옹달샘유통 Mcompany = 옹달샘유통 2 = 4828602107 companyNum = 4828602107 3 = 02-322-1861 Mtel1 = 02-322-1861 4 = 010-9484-1861 Mhp = 010-9484-1861 ========================2022-07-29 18:09:12======================== select * from customers where id = 'ONGDALSEM' ========================2022-07-29 18:09:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ONGDALSEM','2022-07-29 18:09:12','52500','55000','온라인','0')