========================2024-06-07 09:15:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmi2008-1717719266 LGD_BUYER = 김상원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607091426 LGD_HASHDATA = 142ec784b8e0cb081770ab098c256c94 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240607091605AC7C6D134B09FAC65FD95CAD3B1E4738C3A9E1ED Mname = 김상원 Mcompany = 주식회사푸드미 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = foodmi2008 LGD_ESCROW_USEYN = N ========================2024-06-07 09:15:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607091606 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****094* LGD_FINANCEAUTHNUM = 37309797 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cf23602af43c8de5adc5fc49c38413f5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240607091606 LGD_PCANCELSTR = 0 LGD_BUYER = 김상원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240607091606acdo8 LGD_BUYERID = LGD_OID = Direct-foodmi2008-1717719266 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7091606aKpu4 ========================2024-06-07 09:15:23======================== insert into mBoard_order set rOrdNo = 'Direct-foodmi2008-1717719266', AuthTy = 'card', memberId = 'foodmi2008', OrdNm ='김상원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사푸드미', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****094*', rApprNo = 'mjsof20240607091606acdo8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 09:15:23', InvoiceNum = '결제성공:Direct-foodmi2008-1717719266/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 09:15:23' ========================2024-06-07 09:15:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240607091606acdo8' 0 = 1 cnt = 1 ========================2024-06-07 09:15:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmi2008' 0 = foodmi2008 Mid = foodmi2008 1 = 주식회사푸드미 Mcompany = 주식회사푸드미 2 = 1408130951 companyNum = 1408130951 3 = 031-765-1917 Mtel1 = 031-765-1917 4 = 010-7413-0998 Mhp = 010-7413-0998 ========================2024-06-07 09:15:23======================== select * from customers where id = 'foodmi2008' ========================2024-06-07 09:15:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmi2008','2024-06-07 09:15:23','52500','55000','온라인','0') ========================2024-06-07 11:31:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1717727383 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607112943 LGD_HASHDATA = 6c6c4215d072014138aa06c9a3887931 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240607113201DEC3C15C3BFBB2170B092F8CBED3A27C6B9845B9 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2024-06-07 11:31:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607113201 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51818500****839* LGD_FINANCEAUTHNUM = 23708300 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c5a4c9c7cbe10ca700041dac93280027 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240607113202 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240607113201h93P3 LGD_BUYERID = LGD_OID = Direct-mail2020-1717727383 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-07 11:31:19======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1717727383', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 51818500****839*', rApprNo = 'mjsof20240607113201h93P3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 11:31:19', InvoiceNum = '결제성공:Direct-mail2020-1717727383/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 11:31:19' ========================2024-06-07 11:31:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240607113201h93P3' 0 = 1 cnt = 1 ========================2024-06-07 11:31:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2024-06-07 11:31:19======================== select * from customers where id = 'mail2020' ========================2024-06-07 11:31:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2024-06-07 11:31:19','10000','11000','온라인','0') ========================2024-06-07 12:58:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjs8652-1717732439 LGD_BUYER = 박주상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607125359 LGD_HASHDATA = ffee660ed828b5d439e9f2763888e6bb LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240607125915D46DC7719254E4A4F57F2D4A2FCA19CF37C340B3 Mname = 박주상 Mcompany = 인천고향 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pjs8652 LGD_ESCROW_USEYN = N ========================2024-06-07 12:58:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607125916 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = pjs573@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 476C0C LGD_AFFILIATECODE = 8BFAZI LGD_RESPMSG = A1:유효기간만료(Expired card) LGD_2TR_FLAG = Y LGD_CARDNUM = 94581300****701* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 2 LGD_HASHDATA = a93eb149f4bcf757de198cb37d8f0b3d LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240607125916 LGD_PCANCELSTR = 0 LGD_BUYER = 박주상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024060712591685y64 LGD_BUYERID = LGD_OID = Direct-pjs8652-1717732439 LGD_RESPCODE = 3000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-07 13:00:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjs8652-1717732744 LGD_BUYER = 박주상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607125904 LGD_HASHDATA = 1324f4d9298763b26d965746183e8417 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202406071300509DDB9F0482FBAE3D48AF2FA38A2445D5E07664CD Mname = 박주상 Mcompany = 인천고향 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pjs8652 LGD_ESCROW_USEYN = N ========================2024-06-07 13:00:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607130050 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = pjs573@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 476C0C LGD_AFFILIATECODE = ALMA1U LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35690801****006* LGD_FINANCEAUTHNUM = 06053239 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dba8426742c0b5fe3081899dbb48793e LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240607130051 LGD_PCANCELSTR = 0 LGD_BUYER = 박주상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202406071300505jke0 LGD_BUYERID = LGD_OID = Direct-pjs8652-1717732744 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-07 13:00:08======================== insert into mBoard_order set rOrdNo = 'Direct-pjs8652-1717732744', AuthTy = 'card', memberId = 'pjs8652', OrdNm ='박주상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '인천고향', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한JCB 35690801****006*', rApprNo = 'mjsof202406071300505jke0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 13:00:08', InvoiceNum = '결제성공:Direct-pjs8652-1717732744/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 13:00:08' ========================2024-06-07 13:00:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202406071300505jke0' 0 = 1 cnt = 1 ========================2024-06-07 13:00:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pjs8652' 0 = pjs8652 Mid = pjs8652 1 = 인천고향 Mcompany = 인천고향 2 = 1222641581 companyNum = 1222641581 3 = 032-548-7631 Mtel1 = 032-548-7631 4 = 010-3115-8652 Mhp = 010-3115-8652 ========================2024-06-07 13:00:08======================== select * from customers where id = 'pjs8652' ========================2024-06-07 13:00:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pjs8652','2024-06-07 13:00:08','220000','220000','온라인','0') ========================2024-06-07 13:33:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1717734561 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607132921 LGD_HASHDATA = 131e3bcd459cdf1e254b80b7f2d71520 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240607133344B3C83463DEA19EFE461CB75C42107001B73AEF19 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 ========================2024-06-07 13:33:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607133345 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****903* LGD_FINANCEAUTHNUM = 39052543 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c4906edebf3210d31878b8e5c41d2430 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240607133345 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240607133344ewJy2 LGD_BUYERID = LGD_OID = Direct-landhbio-1717734561 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7133344eFc42 ========================2024-06-07 13:33:02======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1717734561', AuthTy = 'card', memberId = 'landhbio', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘엔에이치바이오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****903*', rApprNo = 'mjsof20240607133344ewJy2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 13:33:02', InvoiceNum = '결제성공:Direct-landhbio-1717734561/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 13:33:02' ========================2024-06-07 13:33:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240607133344ewJy2' 0 = 1 cnt = 1 ========================2024-06-07 13:33:02======================== 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 ========================2024-06-07 13:33:02======================== select * from customers where id = 'landhbio' ========================2024-06-07 13:33:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2024-06-07 13:33:02','52500','55000','온라인','0') ========================2024-06-07 14:07:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1717736637 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607140357 LGD_HASHDATA = feac8b6f4674a1579b0a06e268ca6b39 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2024060714075476EF199BE42BF0495F079A30727F63FF6CF1D9AA Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2024-06-07 14:07:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607140755 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****280* LGD_FINANCEAUTHNUM = 30024452 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 48b797dcd36fb9f6cb34cf21b7a60c42 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240607140755 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240607140755cP071 LGD_BUYERID = LGD_OID = Direct-azfoods01-1717736637 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7140755cUZM4 ========================2024-06-07 14:07:12======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1717736637', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****280*', rApprNo = 'mjsof20240607140755cP071', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 14:07:12', InvoiceNum = '결제성공:Direct-azfoods01-1717736637/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 14:07:12' ========================2024-06-07 14:07:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240607140755cP071' 0 = 1 cnt = 1 ========================2024-06-07 14:07:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2024-06-07 14:07:12======================== select * from customers where id = 'azfoods01' ========================2024-06-07 14:07:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2024-06-07 14:07:12','108000','110000','온라인','0') ========================2024-06-07 15:33:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-potatogom-1717741919 LGD_BUYER = 권준형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240607153159 LGD_HASHDATA = 587dce9f529aa300b21c0b19cdaa9be3 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2024060715340235F5915068C220ADF64A47E7D44E38A7776FE890 Mname = 권준형 Mcompany = 로스팅 포테이토 컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = potatogom LGD_ESCROW_USEYN = N ========================2024-06-07 15:33:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240607153402 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46402200****481* LGD_FINANCEAUTHNUM = 00710725 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 42bfa4da90d427e98a6deed0ecf2cff8 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240607153402 LGD_PCANCELSTR = 0 LGD_BUYER = 권준형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202406071534028rCP5 LGD_BUYERID = LGD_OID = Direct-potatogom-1717741919 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-07 15:33:19======================== insert into mBoard_order set rOrdNo = 'Direct-potatogom-1717741919', AuthTy = 'card', memberId = 'potatogom', OrdNm ='권준형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '로스팅 포테이토 컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 46402200****481*', rApprNo = 'mjsof202406071534028rCP5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-07 15:33:19', InvoiceNum = '결제성공:Direct-potatogom-1717741919/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-07 15:33:19' ========================2024-06-07 15:33:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202406071534028rCP5' 0 = 1 cnt = 1 ========================2024-06-07 15:33:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'potatogom' 0 = potatogom Mid = potatogom 1 = 로스팅 포테이토 컴퍼니 Mcompany = 로스팅 포테이토 컴퍼니 2 = 1943700558 companyNum = 1943700558 3 = 010-2225-2252 Mtel1 = 010-2225-2252 4 = 010-2225-2252 Mhp = 010-2225-2252 ========================2024-06-07 15:33:19======================== select * from customers where id = 'potatogom' ========================2024-06-07 15:33:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('potatogom','2024-06-07 15:33:19','52500','55000','온라인','0')