========================2023-03-30 10:13:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gcompany0901-1680138752 LGD_BUYER = 박관수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230330101232 LGD_HASHDATA = af085e9094d60dd916cf3ec549901fa3 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 = 20230330102007F906CAA27AACD259FED2E1F0530C928A2E921DB6 Mname = 박관수 Mcompany = 주식회사 지컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = gcompany0901 LGD_ESCROW_USEYN = N ========================2023-03-30 10:13:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230330102008 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834878 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55322400****742* LGD_FINANCEAUTHNUM = 36537193 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = b578f1e0b32d1c6ff5a1064bfc18f67d LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230330102009 LGD_PCANCELSTR = 0 LGD_BUYER = 박관수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230330102008VFo79 LGD_BUYERID = LGD_OID = Direct-gcompany0901-1680138752 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0102008Vk317 ========================2023-03-30 10:13:55======================== insert into mBoard_order set rOrdNo = 'Direct-gcompany0901-1680138752', AuthTy = 'card', memberId = 'gcompany0901', OrdNm ='박관수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 지컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55322400****742*', rApprNo = 'mjsof20230330102008VFo79', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-30 10:13:55', InvoiceNum = '결제성공:Direct-gcompany0901-1680138752/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-30 10:13:55' ========================2023-03-30 10:13:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230330102008VFo79' 0 = 1 cnt = 1 ========================2023-03-30 10:13:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gcompany0901' 0 = gcompany0901 Mid = gcompany0901 1 = 주식회사 지컴퍼니 Mcompany = 주식회사 지컴퍼니 2 = 388-86-02746 companyNum = 388-86-02746 3 = 010-8698-5533 Mtel1 = 010-8698-5533 4 = 010-3081-5533 Mhp = 010-3081-5533 ========================2023-03-30 10:13:55======================== select * from customers where id = 'gcompany0901' ========================2023-03-30 10:13:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gcompany0901','2023-03-30 10:13:55','10000','11000','온라인','0') ========================2023-03-30 14:26:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mreakeu-1680153900 LGD_BUYER = 조만기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230330142500 LGD_HASHDATA = 0ae86f78c5389336affab31e7e67976a 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 = 202303301433113F27A203D1D99BC66BEFEA15BD4C547DBFD50404 Mname = 조만기 Mcompany = 용접박사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = mreakeu LGD_ESCROW_USEYN = N ========================2023-03-30 14:26:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230330143312 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 = 62432004****755* LGD_FINANCEAUTHNUM = 67624698 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5dd0efa050f72a0160a9bfded0e336c4 LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230330143312 LGD_PCANCELSTR = 0 LGD_BUYER = 조만기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230330143312U4mI4 LGD_BUYERID = LGD_OID = Direct-mreakeu-1680153900 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-30 14:26:59======================== insert into mBoard_order set rOrdNo = 'Direct-mreakeu-1680153900', AuthTy = 'card', memberId = 'mreakeu', OrdNm ='조만기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '용접박사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '농협CUP 62432004****755*', rApprNo = 'mjsof20230330143312U4mI4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-30 14:26:59', InvoiceNum = '결제성공:Direct-mreakeu-1680153900/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-30 14:26:59' ========================2023-03-30 14:26:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230330143312U4mI4' 0 = 1 cnt = 1 ========================2023-03-30 14:26:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mreakeu' 0 = mreakeu Mid = mreakeu 1 = 용접박사 Mcompany = 용접박사 2 = 7950500573 companyNum = 7950500573 3 = 010-4825-0079 Mtel1 = 010-4825-0079 4 = 010-4825-0079 Mhp = 010-4825-0079 ========================2023-03-30 14:26:59======================== select * from customers where id = 'mreakeu' ========================2023-03-30 14:26:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mreakeu','2023-03-30 14:26:59','52500','55000','온라인','0') ========================2023-03-30 15:17:42======================== res_start CST_PLATFORM = test LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = tmjsoft007 LGD_OID = Direct-kak0936-1680156990 LGD_BUYER = 김남수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230330151630 LGD_HASHDATA = 16598394057135cfd9b47a9bf8a648fc 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 = 202303301523567F4782156C65D0DCF2813A8DE82CC2AC751BC1A3 Mname = 김남수 Mcompany = 엠제이소프트11 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = kak0936 LGD_ESCROW_USEYN = N ========================2023-03-30 15:17:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230330152357 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AMAC0G LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51073784****473* LGD_FINANCEAUTHNUM = 00000000 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 118f89e91577912d1c673d6bb394c66a LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230330152357 LGD_PCANCELSTR = 0 LGD_BUYER = 김남수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = tmjso20230330152356DYm48 LGD_BUYERID = LGD_OID = Direct-kak0936-1680156990 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = tmjsoft007 ========================2023-03-30 15:17:43======================== insert into mBoard_order set rOrdNo = 'Direct-kak0936-1680156990', AuthTy = 'card', memberId = 'kak0936', OrdNm ='김남수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엠제이소프트11', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한MASTER 51073784****473*', rApprNo = 'tmjso20230330152356DYm48', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-30 15:17:43', InvoiceNum = '결제성공:Direct-kak0936-1680156990/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-30 15:17:43' ========================2023-03-30 15:17:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'tmjso20230330152356DYm48' 0 = 1 cnt = 1 ========================2023-03-30 15:17:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kak0936' 0 = kak0936 Mid = kak0936 1 = 엠제이소프트11 Mcompany = 엠제이소프트11 2 = companyNum = 3 = 010-7345-0936 Mtel1 = 010-7345-0936 4 = -1231- Mhp = -1231- ========================2023-03-30 15:17:43======================== select * from customers where id = 'kak0936' ========================2023-03-30 15:17:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kak0936','2023-03-30 15:17:43','10000','11000','온라인','0') ========================2023-03-30 15:20:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mirae251-1680157100 LGD_BUYER = 장경순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230330151820 LGD_HASHDATA = e3b47cd986cf44d297d525a11f1289cb 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 = 2023033015262047E39349D138460D5B1A1CD2F15E82DF03DD4DA2 Mname = 장경순 Mcompany = 미래기업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mirae251 LGD_ESCROW_USEYN = N ========================2023-03-30 15:20:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230330152620 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFH920 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35690801****953* LGD_FINANCEAUTHNUM = 44479489 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 61761037213be5037e0a9abec5a0d124 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230330152621 LGD_PCANCELSTR = 0 LGD_BUYER = 장경순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230330152620TK7P9 LGD_BUYERID = LGD_OID = Direct-mirae251-1680157100 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-30 15:20:07======================== insert into mBoard_order set rOrdNo = 'Direct-mirae251-1680157100', AuthTy = 'card', memberId = 'mirae251', OrdNm ='장경순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '미래기업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한JCB 35690801****953*', rApprNo = 'mjsof20230330152620TK7P9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-30 15:20:07', InvoiceNum = '결제성공:Direct-mirae251-1680157100/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-30 15:20:07' ========================2023-03-30 15:20:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230330152620TK7P9' 0 = 1 cnt = 1 ========================2023-03-30 15:20:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mirae251' 0 = mirae251 Mid = mirae251 1 = 미래기업 Mcompany = 미래기업 2 = 5022736506 companyNum = 5022736506 3 = 010-5883-5003 Mtel1 = 010-5883-5003 4 = 010-5548-5300 Mhp = 010-5548-5300 ========================2023-03-30 15:20:07======================== select * from customers where id = 'mirae251' ========================2023-03-30 15:20:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mirae251','2023-03-30 15:20:07','10000','11000','온라인','0')