========================2023-05-31 09:12:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jtwo0115-1685491818 LGD_BUYER = 김정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531091018 LGD_HASHDATA = a9e098bd2b6e785735cb05ef3d954244 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 = 2023053109192377599590545FEC09497D0A2018B442B27C4BB13A Mname = 김정훈 Mcompany = 제이투유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jtwo0115 LGD_ESCROW_USEYN = N ========================2023-05-31 09:12:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531091923 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 = 41190530****159* LGD_FINANCEAUTHNUM = 54704938 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 09b6832df94edbff25cf5b02bb30f846 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20230531091924 LGD_PCANCELSTR = 0 LGD_BUYER = 김정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531091923djbg4 LGD_BUYERID = LGD_OID = Direct-jtwo0115-1685491818 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-31 09:12:01======================== insert into mBoard_order set rOrdNo = 'Direct-jtwo0115-1685491818', AuthTy = 'card', memberId = 'jtwo0115', OrdNm ='김정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이투유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나VISA 41190530****159*', rApprNo = 'mjsof20230531091923djbg4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 09:12:01', InvoiceNum = '결제성공:Direct-jtwo0115-1685491818/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 09:12:01' ========================2023-05-31 09:12:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531091923djbg4' 0 = 1 cnt = 1 ========================2023-05-31 09:12:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jtwo0115' 0 = jtwo0115 Mid = jtwo0115 1 = 제이투유통 Mcompany = 제이투유통 2 = 519-15-00487 companyNum = 519-15-00487 3 = 010-4575-7850 Mtel1 = 010-4575-7850 4 = 010-4575-7850 Mhp = 010-4575-7850 ========================2023-05-31 09:12:02======================== select * from customers where id = 'jtwo0115' ========================2023-05-31 09:12:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jtwo0115','2023-05-31 09:12:01','10000','11000','온라인','0') ========================2023-05-31 10:59:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kdb457384-1685497661 LGD_BUYER = 김대범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531104741 LGD_HASHDATA = 2579771709dc09d0fbc42ae2bfaa9f6f 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 = 20230531110712E737B0960D02F6536B6D2F996724F0E44CE23A76 Mname = 김대범 Mcompany = 강산씨앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kdb457384 LGD_ESCROW_USEYN = N ========================2023-05-31 10:59:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531110713 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****882* LGD_FINANCEAUTHNUM = 30057781 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 66f234f04fa8231aac90abd59c68da12 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230531110713 LGD_PCANCELSTR = 0 LGD_BUYER = 김대범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531110713oCDm2 LGD_BUYERID = LGD_OID = Direct-kdb457384-1685497661 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1110713o9jJ9 ========================2023-05-31 10:59:51======================== insert into mBoard_order set rOrdNo = 'Direct-kdb457384-1685497661', AuthTy = 'card', memberId = 'kdb457384', OrdNm ='김대범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강산씨앤티', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****882*', rApprNo = 'mjsof20230531110713oCDm2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 10:59:51', InvoiceNum = '결제성공:Direct-kdb457384-1685497661/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 10:59:51' ========================2023-05-31 10:59:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531110713oCDm2' 0 = 1 cnt = 1 ========================2023-05-31 10:59:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kdb457384' 0 = kdb457384 Mid = kdb457384 1 = 강산씨앤티 Mcompany = 강산씨앤티 2 = 1643000581 companyNum = 1643000581 3 = 010-9777-8005 Mtel1 = 010-9777-8005 4 = 010-8934-8428 Mhp = 010-8934-8428 ========================2023-05-31 10:59:51======================== select * from customers where id = 'kdb457384' ========================2023-05-31 10:59:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kdb457384','2023-05-31 10:59:51','30900','33000','온라인','0') ========================2023-05-31 12:06:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-oil1-1685502339 LGD_BUYER = 임찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531120539 LGD_HASHDATA = a730f97329fc69d0031c0d7c3914b4ff 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 = 20230531121347B52597E84EB2310B2CDDB700887F6522BE7801D6 Mname = 임찬 Mcompany = 오일원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = oil1 LGD_ESCROW_USEYN = N ========================2023-05-31 12:06:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531121348 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 005318 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 53333730****603* LGD_FINANCEAUTHNUM = 50381594 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 10d83184dee4700e6b1dcc3f364290e7 LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230531121349 LGD_PCANCELSTR = 0 LGD_BUYER = 임찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20230531121348gU1t5 LGD_BUYERID = LGD_OID = Direct-oil1-1685502339 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 311213262499 ========================2023-05-31 12:06:26======================== insert into mBoard_order set rOrdNo = 'Direct-oil1-1685502339', AuthTy = 'card', memberId = 'oil1', OrdNm ='임찬', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '오일원', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '광주Master 53333730****603*', rApprNo = 'mjsof20230531121348gU1t5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 12:06:26', InvoiceNum = '결제성공:Direct-oil1-1685502339/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 12:06:26' ========================2023-05-31 12:06:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531121348gU1t5' 0 = 1 cnt = 1 ========================2023-05-31 12:06:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'oil1' 0 = oil1 Mid = oil1 1 = 오일원 Mcompany = 오일원 2 = 5818601123 companyNum = 5818601123 3 = 062-576-0261 Mtel1 = 062-576-0261 4 = 010-8616-9346 Mhp = 010-8616-9346 ========================2023-05-31 12:06:27======================== select * from customers where id = 'oil1' ========================2023-05-31 12:06:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('oil1','2023-05-31 12:06:26','220000','220000','온라인','0') ========================2023-05-31 13:40:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakingjeju-1685507840 LGD_BUYER = 박동춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531133720 LGD_HASHDATA = d33817bf78463aa6469fa6f7603d5f6d 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 = 2023053113473544035E48006395206678794B69554887B074C7EE Mname = 박동춘 Mcompany = 주식회사 베이킹제주 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bakingjeju LGD_ESCROW_USEYN = N ========================2023-05-31 13:40:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531134736 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756451 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41980310****194* LGD_FINANCEAUTHNUM = 51191096 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = f245c657a3e6230e648317e8a0c1c774 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230531134737 LGD_PCANCELSTR = 0 LGD_BUYER = 박동춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531134736f2Ud3 LGD_BUYERID = LGD_OID = Direct-bakingjeju-1685507840 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1134736fRZx7 ========================2023-05-31 13:40:14======================== insert into mBoard_order set rOrdNo = 'Direct-bakingjeju-1685507840', AuthTy = 'card', memberId = 'bakingjeju', OrdNm ='박동춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 베이킹제주', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41980310****194*', rApprNo = 'mjsof20230531134736f2Ud3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 13:40:14', InvoiceNum = '결제성공:Direct-bakingjeju-1685507840/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 13:40:14' ========================2023-05-31 13:40:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531134736f2Ud3' 0 = 1 cnt = 1 ========================2023-05-31 13:40:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakingjeju' 0 = bakingjeju Mid = bakingjeju 1 = 주식회사 베이킹제주 Mcompany = 주식회사 베이킹제주 2 = 5488800984 companyNum = 5488800984 3 = 010-4467-8900 Mtel1 = 010-4467-8900 4 = 010-4467-8900 Mhp = 010-4467-8900 ========================2023-05-31 13:40:14======================== select * from customers where id = 'bakingjeju' ========================2023-05-31 13:40:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakingjeju','2023-05-31 13:40:14','108000','110000','온라인','0') ========================2023-05-31 16:35:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin1-1685518467 LGD_BUYER = 김샛별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531163427 LGD_HASHDATA = 60c5f49fb54002a82a447d580ff60b6a 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 = 2023053116423236178D9776D1F503FA1865BBC4732EE835C8E0DA Mname = 김샛별 Mcompany = 금진포장 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gumjin1 LGD_ESCROW_USEYN = N ========================2023-05-31 16:35:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531164232 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = 18856221 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6048a6619f34ae214454870f57f9f488 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230531164233 LGD_PCANCELSTR = 0 LGD_BUYER = 김샛별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531164232AyBA6 LGD_BUYERID = LGD_OID = Direct-gumjin1-1685518467 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-31 16:35:10======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin1-1685518467', AuthTy = 'card', memberId = 'gumjin1', OrdNm ='김샛별', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금진포장', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof20230531164232AyBA6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 16:35:10', InvoiceNum = '결제성공:Direct-gumjin1-1685518467/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 16:35:10' ========================2023-05-31 16:35:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531164232AyBA6' 0 = 1 cnt = 1 ========================2023-05-31 16:35:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin1' 0 = gumjin1 Mid = gumjin1 1 = 금진윤활유 Mcompany = 금진윤활유 2 = 1261585310 companyNum = 1261585310 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2023-05-31 16:35:10======================== select * from customers where id = 'gumjin1' ========================2023-05-31 16:35:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin1','2023-05-31 16:35:10','108000','110000','온라인','0') ========================2023-05-31 17:09:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-euungut-1685520487 LGD_BUYER = 임수미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531170807 LGD_HASHDATA = 22077ea25086a1fed38a1dc5daa0fb16 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 = 2023053117164365BECE2F7ACBED87CDE5BB32C600A71E3CFD4EB8 Mname = 임수미 Mcompany = (주)이찌마루로꾸일공육에이앤 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = euungut LGD_ESCROW_USEYN = N ========================2023-05-31 17:09:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531171644 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****880* LGD_FINANCEAUTHNUM = 30133665 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7bfafbeea421d56ca77b6c9808c024f2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230531171644 LGD_PCANCELSTR = 0 LGD_BUYER = 임수미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531171643BQIX5 LGD_BUYERID = LGD_OID = Direct-euungut-1685520487 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1171643BXzO6 ========================2023-05-31 17:09:21======================== insert into mBoard_order set rOrdNo = 'Direct-euungut-1685520487', AuthTy = 'card', memberId = 'euungut', OrdNm ='임수미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)이찌마루로꾸일공육에이앤', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****880*', rApprNo = 'mjsof20230531171643BQIX5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 17:09:21', InvoiceNum = '결제성공:Direct-euungut-1685520487/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 17:09:21' ========================2023-05-31 17:09:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531171643BQIX5' 0 = 1 cnt = 1 ========================2023-05-31 17:09:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'euungut' 0 = euungut Mid = euungut 1 = (주)이찌마루로꾸일공육에이앤 Mcompany = (주)이찌마루로꾸일공육에이앤 2 = 211-88-77785 companyNum = 211-88-77785 3 = 02-3445-0813 Mtel1 = 02-3445-0813 4 = 010-7122-3588 Mhp = 010-7122-3588 ========================2023-05-31 17:09:21======================== select * from customers where id = 'euungut' ========================2023-05-31 17:09:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('euungut','2023-05-31 17:09:21','108000','110000','온라인','0') ========================2023-05-31 18:53:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jsungho93-1685526731 LGD_BUYER = 정성호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531185211 LGD_HASHDATA = f660f1669d2d852aa50795619cd5d2b9 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 = 202305311901119788076DE1BE0C8F856E94857E0886FCF2639142 Mname = 정성호 Mcompany = 한양상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jsungho93 LGD_ESCROW_USEYN = N ========================2023-05-31 18:53:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531190111 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 = 35651771****347* LGD_FINANCEAUTHNUM = 65964564 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 551f61a46d69d03ec0c00e95f5e5cf6f LGD_BUYERADDRESS = LGD_FINANCENAME = NH JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230531190112 LGD_PCANCELSTR = 0 LGD_BUYER = 정성호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531190111vDBo4 LGD_BUYERID = LGD_OID = Direct-jsungho93-1685526731 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-05-31 18:53:49======================== insert into mBoard_order set rOrdNo = 'Direct-jsungho93-1685526731', AuthTy = 'card', memberId = 'jsungho93', OrdNm ='정성호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한양상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH JCB 35651771****347*', rApprNo = 'mjsof20230531190111vDBo4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 18:53:49', InvoiceNum = '결제성공:Direct-jsungho93-1685526731/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 18:53:49' ========================2023-05-31 18:53:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531190111vDBo4' 0 = 1 cnt = 1 ========================2023-05-31 18:53:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jsungho93' 0 = jsungho93 Mid = jsungho93 1 = 한양상사 Mcompany = 한양상사 2 = 6201231197 companyNum = 6201231197 3 = 010-4540-2360 Mtel1 = 010-4540-2360 4 = 010-4541-2360 Mhp = 010-4541-2360 ========================2023-05-31 18:53:49======================== select * from customers where id = 'jsungho93' ========================2023-05-31 18:53:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jsungho93','2023-05-31 18:53:49','52500','55000','온라인','0') ========================2023-05-31 18:59:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sunmro-1685527140 LGD_BUYER = 강찬수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230531185900 LGD_HASHDATA = e9ccedeaf389f563b709ec218f83aa53 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 = 20230531190706641CF7F710EB47FC9862581C96F24CAA929E6EF3 Mname = 강찬수 Mcompany = (주)태양엠알오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sunmro LGD_ESCROW_USEYN = N ========================2023-05-31 18:59:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230531190707 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****244* LGD_FINANCEAUTHNUM = 55287858 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 54ef4a05635fa48054cb50df70226554 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230531190707 LGD_PCANCELSTR = 0 LGD_BUYER = 강찬수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230531190706zNQV7 LGD_BUYERID = LGD_OID = Direct-sunmro-1685527140 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1190706zHPq0 ========================2023-05-31 18:59:44======================== insert into mBoard_order set rOrdNo = 'Direct-sunmro-1685527140', AuthTy = 'card', memberId = 'sunmro', OrdNm ='강찬수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태양엠알오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****244*', rApprNo = 'mjsof20230531190706zNQV7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-05-31 18:59:44', InvoiceNum = '결제성공:Direct-sunmro-1685527140/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-05-31 18:59:44' ========================2023-05-31 18:59:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230531190706zNQV7' 0 = 1 cnt = 1 ========================2023-05-31 18:59:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sunmro' 0 = sunmro Mid = sunmro 1 = (주)태양엠알오 Mcompany = (주)태양엠알오 2 = 262-81-00306 companyNum = 262-81-00306 3 = 02-1899-0942 Mtel1 = 02-1899-0942 4 = 010-5482-0951 Mhp = 010-5482-0951 ========================2023-05-31 18:59:44======================== select * from customers where id = 'sunmro' ========================2023-05-31 18:59:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sunmro','2023-05-31 18:59:44','220000','220000','온라인','0')