========================2021-11-09 09:33:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-naeson9-1636417925 LGD_BUYER = 김정희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109093205 LGD_HASHDATA = 2f631380af5ac01ef7c8631fdc85884f 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 = 202111090935551621C37F5F1046AEB71F7B1E82226A4EOQHRZWXJ Mname = 김정희 Mcompany = 주식회사 내손 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = naeson9 LGD_ESCROW_USEYN = N ========================2021-11-09 09:33:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109093556 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 = 558526******4846 LGD_FINANCEAUTHNUM = 30039413 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b5365309a6e1150cf5666faa7d2c55af LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20211109093556 LGD_PCANCELSTR = 0 LGD_BUYER = 김정희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109093556xvJ04 LGD_BUYERID = LGD_OID = Direct-naeson9-1636417925 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9093556x4Lj9 ========================2021-11-09 09:33:09======================== insert into mBoard_order set rOrdNo = 'Direct-naeson9-1636417925', AuthTy = 'card', memberId = 'naeson9', OrdNm ='김정희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 내손', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******4846', rApprNo = 'mjsof20211109093556xvJ04', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-09 09:33:09', InvoiceNum = '결제성공:Direct-naeson9-1636417925/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-09 09:33:09' ========================2021-11-09 09:33:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211109093556xvJ04' 0 = 1 cnt = 1 ========================2021-11-09 09:33:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'naeson9' 0 = naeson9 Mid = naeson9 1 = 주식회사 내손 Mcompany = 주식회사 내손 2 = companyNum = 3 = 031-462-0944 Mtel1 = 031-462-0944 4 = 010-2229-0959 Mhp = 010-2229-0959 ========================2021-11-09 09:33:10======================== select * from customers where id = 'naeson9' ========================2021-11-09 09:33:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('naeson9','2021-11-09 09:33:09','108000','110000','온라인','0') ========================2021-11-09 11:50:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1636426207 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109115007 LGD_HASHDATA = 85c69e6b51cc53099bcff154ed93036f 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 = 20211109115339BB49E64D3B2F45E5B46417095E73BBE3CKY1VRGV 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-11-09 11:50:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109115340 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******4303 LGD_FINANCEAUTHNUM = 52794426 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2168793a58fae95038b1d320e37e16a2 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211109115340 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109115340AulY2 LGD_BUYERID = LGD_OID = Direct-landhbio-1636426207 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9115340AUgn9 ========================2021-11-09 11:52:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1636426286 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109115126 LGD_HASHDATA = 54bae941850a8ca9e58b5c5169eede4a 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 = 202111091154470C0DE517ABC94A28B9C19646C285BAE4GMHTNEKK 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-11-09 11:52:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109115448 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******4303 LGD_FINANCEAUTHNUM = 52801141 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 97aee967cdd6dbcf3730be44b551e0cc LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211109115448 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109115448zL8T9 LGD_BUYERID = LGD_OID = Direct-landhbio-1636426286 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9115448znlz9 ========================2021-11-09 11:53:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1636426366 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109115246 LGD_HASHDATA = 0864276e0220a3f091f14f5de231f5f5 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 = 20211109115611038DF5EDBD1B491CB3083E02BA250374DGY5EFPG 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-11-09 11:53:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109115612 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******4303 LGD_FINANCEAUTHNUM = 52812403 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 97eca7cf76dbd375dbbd44f734ea33ef LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211109115612 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109115611vQwj1 LGD_BUYERID = LGD_OID = Direct-landhbio-1636426366 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9115611v1Sd5 ========================2021-11-09 11:58:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1636426683 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109115803 LGD_HASHDATA = ad5776dc95a0ea130a578c4e21b6ea34 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 = 202111091201237670FB2AF8964F71AFC26331EB9D32EE52H06UVZ 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-11-09 11:58:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109120124 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 410120******4303 LGD_FINANCEAUTHNUM = 52842454 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c864aea7c254dff1f473eda40d8795c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211109120124 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109120123yHZw6 LGD_BUYERID = LGD_OID = Direct-landhbio-1636426683 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9120123yZO60 ========================2021-11-09 11:58:37======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1636426683', 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 = 'mjsof20211109120123yHZw6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-09 11:58:37', InvoiceNum = '결제성공:Direct-landhbio-1636426683/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-09 11:58:37' ========================2021-11-09 11:58:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211109120123yHZw6' 0 = 1 cnt = 1 ========================2021-11-09 11:58:37======================== 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-11-09 11:58:37======================== select * from customers where id = 'landhbio' ========================2021-11-09 11:58:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2021-11-09 11:58:37','52500','55000','온라인','0') ========================2021-11-09 12:49:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rich67-1636429667 LGD_BUYER = 안찬우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109124747 LGD_HASHDATA = 96f5278adf6dd50e6c384974974f7852 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 = 20211109125216B711FDA309A54E808BCB117D1A8FD3BBU2V5T7AX Mname = 안찬우 Mcompany = EDP울산야음점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = rich67 LGD_ESCROW_USEYN = N ========================2021-11-09 12:49:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109125217 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 = 949019******1926 LGD_FINANCEAUTHNUM = 00988875 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 739fdac71c77760b7a13a4140a4ee814 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20211109125217 LGD_PCANCELSTR = 0 LGD_BUYER = 안찬우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109125216yJDE8 LGD_BUYERID = LGD_OID = Direct-rich67-1636429667 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-09 12:49:30======================== insert into mBoard_order set rOrdNo = 'Direct-rich67-1636429667', AuthTy = 'card', memberId = 'rich67', OrdNm ='안찬우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'EDP울산야음점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대 949019******1926', rApprNo = 'mjsof20211109125216yJDE8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-09 12:49:30', InvoiceNum = '결제성공:Direct-rich67-1636429667/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-09 12:49:30' ========================2021-11-09 12:49:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211109125216yJDE8' 0 = 1 cnt = 1 ========================2021-11-09 12:49:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rich67' 0 = rich67 Mid = rich67 1 = EDP울산야음점 Mcompany = EDP울산야음점 2 = 6211013131 companyNum = 6211013131 3 = 010-3887-1179 Mtel1 = 010-3887-1179 4 = 010-3887-1179 Mhp = 010-3887-1179 ========================2021-11-09 12:49:30======================== select * from customers where id = 'rich67' ========================2021-11-09 12:49:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rich67','2021-11-09 12:49:30','52500','55000','온라인','0') ========================2021-11-09 16:54:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-park184-1636444388 LGD_BUYER = 박정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109165308 LGD_HASHDATA = 51fd9c77eb46e8a1afc8744441a11034 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 = 202111091657082B4AE5B48B724C8C8C5DDE7ED44D2968AXLSAT5Z Mname = 박정 Mcompany = 금만활저 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = park184 LGD_ESCROW_USEYN = N ========================2021-11-09 16:54:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109165708 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 = 512114******8527 LGD_FINANCEAUTHNUM = 00289775 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fec8e3f623fcc587f64ac4438a1e23dc LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20211109165709 LGD_PCANCELSTR = 0 LGD_BUYER = 박정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109165708ADZt7 LGD_BUYERID = LGD_OID = Direct-park184-1636444388 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-09 16:54:22======================== insert into mBoard_order set rOrdNo = 'Direct-park184-1636444388', AuthTy = 'card', memberId = 'park184', OrdNm ='박정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금만활저', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대MASTER 512114******8527', rApprNo = 'mjsof20211109165708ADZt7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-09 16:54:22', InvoiceNum = '결제성공:Direct-park184-1636444388/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-09 16:54:22' ========================2021-11-09 16:54:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211109165708ADZt7' 0 = 1 cnt = 1 ========================2021-11-09 16:54:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'park184' 0 = park184 Mid = park184 1 = 금만활저 Mcompany = 금만활저 2 = 403-10-33131 companyNum = 403-10-33131 3 = 063-547-2459 Mtel1 = 063-547-2459 4 = 010-5268-2362 Mhp = 010-5268-2362 ========================2021-11-09 16:54:22======================== select * from customers where id = 'park184' ========================2021-11-09 16:54:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('park184','2021-11-09 16:54:22','30900','33000','온라인','0') ========================2021-11-09 18:01:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brothers-1636448198 LGD_BUYER = 조만식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211109175638 LGD_HASHDATA = 08ea9e8a40cca613763e20f79a53bd4f 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 = 202111091804366C1285859C594A159DF51B6AEE560CD6THL8QYIY Mname = 조만식 Mcompany = 브라더 리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = brothers LGD_ESCROW_USEYN = N ========================2021-11-09 18:01:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211109180437 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = APB9YL LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 465887******6261 LGD_FINANCEAUTHNUM = 41983308 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b0d78a0041e99be90c20d644568bcbac LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20211109180437 LGD_PCANCELSTR = 0 LGD_BUYER = 조만식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20211109180437yTek8 LGD_BUYERID = LGD_OID = Direct-brothers-1636448198 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-11-09 18:01:50======================== insert into mBoard_order set rOrdNo = 'Direct-brothers-1636448198', AuthTy = 'card', memberId = 'brothers', OrdNm ='조만식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '브라더 리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 465887******6261', rApprNo = 'mjsof20211109180437yTek8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-11-09 18:01:50', InvoiceNum = '결제성공:Direct-brothers-1636448198/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-11-09 18:01:50' ========================2021-11-09 18:01:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20211109180437yTek8' 0 = 1 cnt = 1 ========================2021-11-09 18:01:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'brothers' 0 = brothers Mid = brothers 1 = 브라더 리테일 Mcompany = 브라더 리테일 2 = 8711001642 companyNum = 8711001642 3 = 010-9132-2424 Mtel1 = 010-9132-2424 4 = 010-9444-7213 Mhp = 010-9444-7213 ========================2021-11-09 18:01:51======================== select * from customers where id = 'brothers' ========================2021-11-09 18:01:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brothers','2021-11-09 18:01:50','52500','55000','온라인','0')