========================2024-07-30 12:15:33======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ijbkoo-1722309278 LGD_BUYER = 신진홍 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240730121438 LGD_HASHDATA = 2f71800079ff3f7fdb41d712b64af4e0 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 = 20240730121716402800043EC4E679E47D5DEBECB6F9EF5438FDC8 Mname = 신진홍 Mcompany = 롯데칠성음료 평창점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ijbkoo LGD_ESCROW_USEYN = N ========================2024-07-30 12:15:34======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20240730121717 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ijbkoo@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37918394****18* LGD_FINANCEAUTHNUM = 29861290 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9d7a2d66bb3065eb3e18bf7bbe200854 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240730121717 LGD_PCANCELSTR = 0 LGD_BUYER = 신진홍 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240730121700QYjS6 LGD_BUYERID = LGD_OID = Direct-ijbkoo-1722309278 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-30 12:15:34======================== insert into mBoard_order set rOrdNo = 'Direct-ijbkoo-1722309278', AuthTy = 'card', memberId = 'ijbkoo', OrdNm ='신진홍', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료 평창점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성AMEX 37918394****18*', rApprNo = 'mjsof20240730121700QYjS6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-30 12:15:34', InvoiceNum = '결제성공:Direct-ijbkoo-1722309278/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-30 12:15:34' ========================2024-07-30 12:15:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240730121700QYjS6' 0 = 1 cnt = 1 ========================2024-07-30 12:15:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ijbkoo' 0 = ijbkoo Mid = ijbkoo 1 = 롯데칠성음료 평창점 Mcompany = 롯데칠성음료 평창점 2 = 2241632910 companyNum = 2241632910 3 = 033-332-0129 Mtel1 = 033-332-0129 4 = 010-8777-1354 Mhp = 010-8777-1354 ========================2024-07-30 12:15:34======================== select * from customers where id = 'ijbkoo' ========================2024-07-30 12:15:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ijbkoo','2024-07-30 12:15:34','108000','110000','온라인','0') ========================2024-07-30 14:11:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-eric2030-1722316138 LGD_BUYER = 정영우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240730140858 LGD_HASHDATA = 8041ccbfebd9c74b170465d6af4f4810 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 = 20240730141317DB8BAC31D65554EEF24B6203A122D057F8478EEF Mname = 정영우 Mcompany = 영우컴퍼니 주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = eric2030 LGD_ESCROW_USEYN = N ========================2024-07-30 14:11:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240730141318 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = eric20300@naver.com 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 = 55318077****144* LGD_FINANCEAUTHNUM = 44115837 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 504f436f845e3d707892d16d283e9d28 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240730141318 LGD_PCANCELSTR = 0 LGD_BUYER = 정영우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240730141318MdCp3 LGD_BUYERID = LGD_OID = Direct-eric2030-1722316138 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-30 14:11:35======================== insert into mBoard_order set rOrdNo = 'Direct-eric2030-1722316138', AuthTy = 'card', memberId = 'eric2030', OrdNm ='정영우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '영우컴퍼니 주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH MASTER 55318077****144*', rApprNo = 'mjsof20240730141318MdCp3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-30 14:11:35', InvoiceNum = '결제성공:Direct-eric2030-1722316138/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-30 14:11:35' ========================2024-07-30 14:11:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240730141318MdCp3' 0 = 1 cnt = 1 ========================2024-07-30 14:11:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'eric2030' 0 = eric2030 Mid = eric2030 1 = 영우컴퍼니 주식회사 Mcompany = 영우컴퍼니 주식회사 2 = 4998601616 companyNum = 4998601616 3 = 010-2410-4124 Mtel1 = 010-2410-4124 4 = 010-2410-4124 Mhp = 010-2410-4124 ========================2024-07-30 14:11:35======================== select * from customers where id = 'eric2030' ========================2024-07-30 14:11:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('eric2030','2024-07-30 14:11:35','10000','11000','온라인','0') ========================2024-07-30 14:58:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bambi-1722319002 LGD_BUYER = 유민우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240730145642 LGD_HASHDATA = 8adaae53664354cd3ddf6d1ad9b8210f 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 = 20240730150038ADEBE8FDB300BC79900F4ADBC6AF44239736C071 Mname = 유민우 Mcompany = 밤비테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = bambi LGD_ESCROW_USEYN = N ========================2024-07-30 14:58:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240730150038 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = happypam3@naver.com 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 = 53209200****444* LGD_FINANCEAUTHNUM = 23670997 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 38970a0b5162608ff5b64c3e75589194 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240730150039 LGD_PCANCELSTR = 0 LGD_BUYER = 유민우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240730150038MlhK4 LGD_BUYERID = LGD_OID = Direct-bambi-1722319002 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-30 14:58:55======================== insert into mBoard_order set rOrdNo = 'Direct-bambi-1722319002', AuthTy = 'card', memberId = 'bambi', OrdNm ='유민우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '밤비테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 53209200****444*', rApprNo = 'mjsof20240730150038MlhK4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-30 14:58:55', InvoiceNum = '결제성공:Direct-bambi-1722319002/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-30 14:58:55' ========================2024-07-30 14:58:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240730150038MlhK4' 0 = 1 cnt = 1 ========================2024-07-30 14:58:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bambi' 0 = bambi Mid = bambi 1 = 밤비테크 Mcompany = 밤비테크 2 = 2160669436 companyNum = 2160669436 3 = 070-7788-7770 Mtel1 = 070-7788-7770 4 = 010-7772-4668 Mhp = 010-7772-4668 ========================2024-07-30 14:58:55======================== select * from customers where id = 'bambi' ========================2024-07-30 14:58:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bambi','2024-07-30 14:58:55','10000','11000','온라인','0') ========================2024-07-30 17:34:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-korea9cc-1722327194 LGD_BUYER = 신석희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240730171314 LGD_HASHDATA = 78306fab7445e4c159adb2e613026954 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 = 2024073017363314E14FBB1BAED8674EFC9AED1B5DE7A89BEBDB6D Mname = 신석희 Mcompany = 주식회사 엔씨인베스트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = korea9cc LGD_ESCROW_USEYN = N ========================2024-07-30 17:34:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240730173634 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ncinbest@ncinbest.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****709* LGD_FINANCEAUTHNUM = 19977412 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2355b0bca3e23e1ab207c8285be54dc3 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240730173634 LGD_PCANCELSTR = 0 LGD_BUYER = 신석희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240730173633tmZa0 LGD_BUYERID = LGD_OID = Direct-korea9cc-1722327194 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-30 17:34:51======================== insert into mBoard_order set rOrdNo = 'Direct-korea9cc-1722327194', AuthTy = 'card', memberId = 'korea9cc', OrdNm ='신석희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 엔씨인베스트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****709*', rApprNo = 'mjsof20240730173633tmZa0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-30 17:34:51', InvoiceNum = '결제성공:Direct-korea9cc-1722327194/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-30 17:34:51' ========================2024-07-30 17:34:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240730173633tmZa0' 0 = 1 cnt = 1 ========================2024-07-30 17:34:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'korea9cc' 0 = korea9cc Mid = korea9cc 1 = 주식회사 엔씨인베스트 Mcompany = 주식회사 엔씨인베스트 2 = 3178142265 companyNum = 3178142265 3 = 010-3448-5189 Mtel1 = 010-3448-5189 4 = 010-5460-5185 Mhp = 010-5460-5185 ========================2024-07-30 17:34:51======================== select * from customers where id = 'korea9cc' ========================2024-07-30 17:34:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('korea9cc','2024-07-30 17:34:51','108000','110000','온라인','0')