========================2022-12-05 09:02:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang2446-1670198440 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205090040 LGD_HASHDATA = 298d06dcd3b7905df80e4e2560b48c20 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 = 2022120509063226504E353EAB61FADF121BE7CE8DCD5A071B480A Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = samyang2446 LGD_ESCROW_USEYN = N ========================2022-12-05 09:02:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205090633 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 = 94301602****834* LGD_FINANCEAUTHNUM = 60141647 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 463f91adbb07dc7aefd571e3010fba1a LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221205090634 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221205090633t4ij1 LGD_BUYERID = LGD_OID = Direct-samyang2446-1670198440 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-05 09:02:27======================== insert into mBoard_order set rOrdNo = 'Direct-samyang2446-1670198440', AuthTy = 'card', memberId = 'samyang2446', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH 94301602****834*', rApprNo = 'mjsof20221205090633t4ij1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 09:02:27', InvoiceNum = '결제성공:Direct-samyang2446-1670198440/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 09:02:27' ========================2022-12-05 09:02:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205090633t4ij1' 0 = 1 cnt = 1 ========================2022-12-05 09:02:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyang2446' 0 = samyang2446 Mid = samyang2446 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2022-12-05 09:02:27======================== select * from customers where id = 'samyang2446' ========================2022-12-05 09:02:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang2446','2022-12-05 09:02:27','10000','11000','온라인','0') ========================2022-12-05 09:19:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1670199502 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205091822 LGD_HASHDATA = 9f63ee7b2714ecdad72319d807a78d15 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 = 202212050923541CF29288B95C6BC8BC0BCDA3BC02B905725FCC65 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-12-05 09:19:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205092354 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 = 94301703****448* LGD_FINANCEAUTHNUM = 60261240 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fa0ea4c30afd0433e854ad75b79dc9f2 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221205092354 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221205092354t69U8 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1670199502 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-05 09:19:47======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1670199502', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20221205092354t69U8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 09:19:47', InvoiceNum = '결제성공:Direct-goodssal5707-1670199502/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 09:19:47' ========================2022-12-05 09:19:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205092354t69U8' 0 = 1 cnt = 1 ========================2022-12-05 09:19:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-12-05 09:19:48======================== select * from customers where id = 'goodssal5707' ========================2022-12-05 09:19:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-12-05 09:19:47','220000','220000','온라인','0') ========================2022-12-05 09:20:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1670199595 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205091955 LGD_HASHDATA = d1e4f715a93d4c1eb51f155a625b0f22 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 = 20221205092433E5DAF649EE51547343C1C59795067EDDD0BB7CD9 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-12-05 09:20:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205092434 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 = 94301703****448* LGD_FINANCEAUTHNUM = 60266166 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ef3f472ac78ec897c5b744112e8b900a LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221205092434 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221205092434uozV3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1670199595 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-05 09:20:28======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1670199595', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20221205092434uozV3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 09:20:28', InvoiceNum = '결제성공:Direct-goodssal5707-1670199595/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 09:20:28' ========================2022-12-05 09:20:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205092434uozV3' 0 = 1 cnt = 1 ========================2022-12-05 09:20:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-12-05 09:20:28======================== select * from customers where id = 'goodssal5707' ========================2022-12-05 09:20:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-12-05 09:20:28','108000','110000','온라인','0') ========================2022-12-05 11:18:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tophaeyang-1670206586 LGD_BUYER = 구본형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205111626 LGD_HASHDATA = c87cfd8d91e57e013f2eef161b96405f 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 = 202212051122458F5D856E80E4A97FA5645C621A753ED87CE67F17 Mname = 구본형 Mcompany = 해양씨위드유한회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = tophaeyang LGD_ESCROW_USEYN = N ========================2022-12-05 11:18:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205112246 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852693****585* LGD_FINANCEAUTHNUM = 30031716 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ca61b32cb0cc1fba6695c0ba8a93bd1d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221205112246 LGD_PCANCELSTR = 0 LGD_BUYER = 구본형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205112246scnM2 LGD_BUYERID = LGD_OID = Direct-tophaeyang-1670206586 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5112246sLg66 ========================2022-12-05 11:18:39======================== insert into mBoard_order set rOrdNo = 'Direct-tophaeyang-1670206586', AuthTy = 'card', memberId = 'tophaeyang', OrdNm ='구본형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해양씨위드유한회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852693****585*', rApprNo = 'mjsof20221205112246scnM2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 11:18:39', InvoiceNum = '결제성공:Direct-tophaeyang-1670206586/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 11:18:39' ========================2022-12-05 11:18:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205112246scnM2' 0 = 1 cnt = 1 ========================2022-12-05 11:18:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tophaeyang' 0 = tophaeyang Mid = tophaeyang 1 = 해양씨위드유한회사 Mcompany = 해양씨위드유한회사 2 = 749-88-00888 companyNum = 749-88-00888 3 = 02-2279-3530 Mtel1 = 02-2279-3530 4 = 010-5523-3530 Mhp = 010-5523-3530 ========================2022-12-05 11:18:39======================== select * from customers where id = 'tophaeyang' ========================2022-12-05 11:18:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tophaeyang','2022-12-05 11:18:39','220000','220000','온라인','0') ========================2022-12-05 11:44:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-haeyang201-1670208236 LGD_BUYER = 이임규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205114356 LGD_HASHDATA = 9dcc164e81a432346b75672e781b0588 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 = 202212051149061ABE1BDA1DE7B2DBCE2787D0D80FEBDC34ECB359 Mname = 이임규 Mcompany = 해양수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = haeyang201 LGD_ESCROW_USEYN = N ========================2022-12-05 11:45:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205114907 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852693****585* LGD_FINANCEAUTHNUM = 30031727 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d643f8095ae45a71971f5297b5989d83 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221205114907 LGD_PCANCELSTR = 0 LGD_BUYER = 이임규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205114907sfz66 LGD_BUYERID = LGD_OID = Direct-haeyang201-1670208236 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5114907sMuE2 ========================2022-12-05 11:45:00======================== insert into mBoard_order set rOrdNo = 'Direct-haeyang201-1670208236', AuthTy = 'card', memberId = 'haeyang201', OrdNm ='이임규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '해양수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852693****585*', rApprNo = 'mjsof20221205114907sfz66', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 11:45:00', InvoiceNum = '결제성공:Direct-haeyang201-1670208236/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 11:45:00' ========================2022-12-05 11:45:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205114907sfz66' 0 = 1 cnt = 1 ========================2022-12-05 11:45:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'haeyang201' 0 = haeyang201 Mid = haeyang201 1 = 해양수산 Mcompany = 해양수산 2 = 2019061047 companyNum = 2019061047 3 = 010-5523-3530 Mtel1 = 010-5523-3530 4 = 010-5523-3530 Mhp = 010-5523-3530 ========================2022-12-05 11:45:00======================== select * from customers where id = 'haeyang201' ========================2022-12-05 11:45:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('haeyang201','2022-12-05 11:45:00','220000','220000','온라인','0') ========================2022-12-05 14:12:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samhwa501-1670216967 LGD_BUYER = 이은순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205140927 LGD_HASHDATA = ebe81b47bf114e6606b6e120152c6d39 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 = 2022120514162416E5962A5F8075063E786C3C4493A1BEEC106643 Mname = 이은순 Mcompany = 삼화배드민턴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = samhwa501 LGD_ESCROW_USEYN = N ========================2022-12-05 14:12:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205141624 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****091* LGD_FINANCEAUTHNUM = 41669700 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b9ef7c13ea9c2f2f1ef9dc70c44b4f8d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221205141625 LGD_PCANCELSTR = 0 LGD_BUYER = 이은순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205141624xDwN9 LGD_BUYERID = LGD_OID = Direct-samhwa501-1670216967 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5141624xtqr5 ========================2022-12-05 14:13:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samhwa501-1670217185 LGD_BUYER = 이은순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205141305 LGD_HASHDATA = 8f3b636d5dab10f6368c5c73b52a0d6e 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 = 202212051417544CC4741FED5C1D4EC767D35D1A271F69C1DC61FA Mname = 이은순 Mcompany = 삼화배드민턴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = samhwa501 LGD_ESCROW_USEYN = N ========================2022-12-05 14:13:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205141754 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = samhwa502@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****091* LGD_FINANCEAUTHNUM = 41684656 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bb2bef7a0178cab602e652db76e1aaa7 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221205141755 LGD_PCANCELSTR = 0 LGD_BUYER = 이은순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205141754uTVH7 LGD_BUYERID = LGD_OID = Direct-samhwa501-1670217185 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5141754uXuV3 ========================2022-12-05 14:21:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-superman01-1670217613 LGD_BUYER = 남수성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205142013 LGD_HASHDATA = fee1112f73444d003063d4af4113fda1 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 = 20221205142556740EC88FBE840635E44FD4321D29707F1F3BC64C Mname = 남수성 Mcompany = 에스유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = superman01 LGD_ESCROW_USEYN = N ========================2022-12-05 14:21:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205142557 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******017 LGD_FINANCEAUTHNUM = 79578007 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8949ca2861555e008a9ad1abbb0a6d03 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20221205142557 LGD_PCANCELSTR = 0 LGD_BUYER = 남수성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221205142556rC7v7 LGD_BUYERID = LGD_OID = Direct-superman01-1670217613 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-05 14:21:50======================== insert into mBoard_order set rOrdNo = 'Direct-superman01-1670217613', AuthTy = 'card', memberId = 'superman01', OrdNm ='남수성', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '에스유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성AMEX 379183******017', rApprNo = 'mjsof20221205142556rC7v7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 14:21:50', InvoiceNum = '결제성공:Direct-superman01-1670217613/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 14:21:50' ========================2022-12-05 14:21:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205142556rC7v7' 0 = 1 cnt = 1 ========================2022-12-05 14:21:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'superman01' 0 = superman01 Mid = superman01 1 = 에스유통 Mcompany = 에스유통 2 = 595-69-00451 companyNum = 595-69-00451 3 = 010-8774-2123 Mtel1 = 010-8774-2123 4 = 010-8774-2123 Mhp = 010-8774-2123 ========================2022-12-05 14:21:50======================== select * from customers where id = 'superman01' ========================2022-12-05 14:21:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('superman01','2022-12-05 14:21:50','52500','55000','온라인','0') ========================2022-12-05 15:14:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1670220727 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205151207 LGD_HASHDATA = 2a6910496346e51130d5fc16d423537d 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 = 2022120515182685C1EEC8921AC9DEF19058965ABD7E21600A1F31 Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2022-12-05 15:14:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205151827 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401145****204* LGD_FINANCEAUTHNUM = 42085670 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d486ba8acea6e05cd15ef57aeed5fa99 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221205151827 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205151826v4B00 LGD_BUYERID = LGD_OID = Direct-woorimart-1670220727 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5151826vCfy6 ========================2022-12-05 15:14:20======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1670220727', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41401145****204*', rApprNo = 'mjsof20221205151826v4B00', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 15:14:20', InvoiceNum = '결제성공:Direct-woorimart-1670220727/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 15:14:20' ========================2022-12-05 15:14:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205151826v4B00' 0 = 1 cnt = 1 ========================2022-12-05 15:14:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2022-12-05 15:14:20======================== select * from customers where id = 'woorimart' ========================2022-12-05 15:14:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2022-12-05 15:14:20','220000','220000','온라인','0') ========================2022-12-05 15:36:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gssafety-1670222106 LGD_BUYER = 유명옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205153506 LGD_HASHDATA = 3b3a3ecaf3558efb9407db7f054c06c1 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 = 20221205154028481757B944614162E7A74D3F7A1CAA01570D015A Mname = 유명옥 Mcompany = 강서안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = gssafety LGD_ESCROW_USEYN = N ========================2022-12-05 15:36:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205154029 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = gs_safety@naver.com 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 = 45749200****581* LGD_FINANCEAUTHNUM = 00100931 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea65358a10442c92c5ee6a44a19f4738 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221205154029 LGD_PCANCELSTR = 0 LGD_BUYER = 유명옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221205154028TjPY8 LGD_BUYERID = LGD_OID = Direct-gssafety-1670222106 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-05 15:36:22======================== insert into mBoard_order set rOrdNo = 'Direct-gssafety-1670222106', AuthTy = 'card', memberId = 'gssafety', OrdNm ='유명옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강서안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 45749200****581*', rApprNo = 'mjsof20221205154028TjPY8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 15:36:22', InvoiceNum = '결제성공:Direct-gssafety-1670222106/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 15:36:22' ========================2022-12-05 15:36:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205154028TjPY8' 0 = 1 cnt = 1 ========================2022-12-05 15:36:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gssafety' 0 = gssafety Mid = gssafety 1 = 강서안전 Mcompany = 강서안전 2 = 284-03-02290 companyNum = 284-03-02290 3 = 051-928-8200 Mtel1 = 051-928-8200 4 = 010-8255-0246 Mhp = 010-8255-0246 ========================2022-12-05 15:36:22======================== select * from customers where id = 'gssafety' ========================2022-12-05 15:36:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gssafety','2022-12-05 15:36:22','30900','33000','온라인','0') ========================2022-12-05 18:08:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1670231205 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221205180645 LGD_HASHDATA = 7e281024e1b0d9aa91302d0987defca3 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 = 20221205181223C750C497236A4F1F81D0B76DC0E6B61C9ECEA29C Mname = 이정훈 Mcompany = (주)신협상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yhk8100 LGD_ESCROW_USEYN = N ========================2022-12-05 18:08:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221205181224 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****392* LGD_FINANCEAUTHNUM = 43691212 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 08bb8b964e8a74f3aaa3134eb5313ab6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221205181224 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221205181223UBJ64 LGD_BUYERID = LGD_OID = Direct-yhk8100-1670231205 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5181223Uv7b9 ========================2022-12-05 18:08:17======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1670231205', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300306****392*', rApprNo = 'mjsof20221205181223UBJ64', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-05 18:08:17', InvoiceNum = '결제성공:Direct-yhk8100-1670231205/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-05 18:08:17' ========================2022-12-05 18:08:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221205181223UBJ64' 0 = 1 cnt = 1 ========================2022-12-05 18:08:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yhk8100' 0 = yhk8100 Mid = yhk8100 1 = (주)신협상사 Mcompany = (주)신협상사 2 = 1288158323 companyNum = 1288158323 3 = 02-381-8100 Mtel1 = 02-381-8100 4 = 011-9834-3324 Mhp = 011-9834-3324 ========================2022-12-05 18:08:17======================== select * from customers where id = 'yhk8100' ========================2022-12-05 18:08:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2022-12-05 18:08:17','52500','55000','온라인','0')