========================2024-09-02 07:16:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-filsy82-1725228861 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902071421 LGD_HASHDATA = 32eea80d921c46828ac8a9c6c978e2c3 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 = 20240902071823E79468C435CC2A1DE6D96285B5F5AAF6013B6890 Mname = 이승환 Mcompany = 동원상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = filsy82 LGD_ESCROW_USEYN = N ========================2024-09-02 07:16:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902071823 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = filsy@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BBBBPW LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55448100****439* LGD_FINANCEAUTHNUM = 19801996 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dfbbd576b0a2f6447f66ba0c9e1cc563 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240902071824 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902071823qgSo6 LGD_BUYERID = LGD_OID = Direct-filsy82-1725228861 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 07:16:02======================== insert into mBoard_order set rOrdNo = 'Direct-filsy82-1725228861', AuthTy = 'card', memberId = 'filsy82', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동원상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '신한MASTER 55448100****439*', rApprNo = 'mjsof20240902071823qgSo6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 07:16:02', InvoiceNum = '결제성공:Direct-filsy82-1725228861/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 07:16:02' ========================2024-09-02 07:16:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902071823qgSo6' 0 = 1 cnt = 1 ========================2024-09-02 07:16:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'filsy82' 0 = filsy82 Mid = filsy82 1 = 동원상사 Mcompany = 동원상사 2 = 1243632559 companyNum = 1243632559 3 = 010-3363-5661 Mtel1 = 010-3363-5661 4 = -- Mhp = -- ========================2024-09-02 07:16:02======================== select * from customers where id = 'filsy82' ========================2024-09-02 07:16:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('filsy82','2024-09-02 07:16:02','10000','11000','온라인','0') ========================2024-09-02 10:19:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kgr1214-1725239877 LGD_BUYER = 김경래 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902101757 LGD_HASHDATA = b2a218319fbd198cc866557be31bb84f 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 = 20240902102144546FFF1030F47579C2584CF2C34D36DF14C358DA Mname = 김경래 Mcompany = 지성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kgr1214 LGD_ESCROW_USEYN = N ========================2024-09-02 10:19:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902102145 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jisung131201@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003239 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94104970****606* LGD_FINANCEAUTHNUM = 30067332 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4ec81eabcef77e7ff1dc53ad59f48adb LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240902102145 LGD_PCANCELSTR = 0 LGD_BUYER = 김경래 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902102145dext1 LGD_BUYERID = LGD_OID = Direct-kgr1214-1725239877 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 10:19:23======================== insert into mBoard_order set rOrdNo = 'Direct-kgr1214-1725239877', AuthTy = 'card', memberId = 'kgr1214', OrdNm ='김경래', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '지성상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민 94104970****606*', rApprNo = 'mjsof20240902102145dext1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 10:19:23', InvoiceNum = '결제성공:Direct-kgr1214-1725239877/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 10:19:23' ========================2024-09-02 10:19:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902102145dext1' 0 = 1 cnt = 1 ========================2024-09-02 10:19:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kgr1214' 0 = kgr1214 Mid = kgr1214 1 = 지성상사 Mcompany = 지성상사 2 = 1410563145 companyNum = 1410563145 3 = 02-2699-3716 Mtel1 = 02-2699-3716 4 = 010-4190-4584 Mhp = 010-4190-4584 ========================2024-09-02 10:19:23======================== select * from customers where id = 'kgr1214' ========================2024-09-02 10:19:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kgr1214','2024-09-02 10:19:23','52500','55000','온라인','0') ========================2024-09-02 12:12:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dae1936-1725246640 LGD_BUYER = 전찬홍 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902121040 LGD_HASHDATA = f431aba1dfce5ad2f27a0073a735cabf 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 = 20240902121438A19608E7E2F28C4ACBBEE732B02ABF9B74D9650B Mname = 전찬홍 Mcompany = 대건비니루상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dae1936 LGD_ESCROW_USEYN = N ========================2024-09-02 12:12:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902121439 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hilfiger2000@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 473C0C LGD_AFFILIATECODE = AEA009 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184212****825* LGD_FINANCEAUTHNUM = 23185033 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f7840a83cbbf8eef569bf5579f1de413 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240902121440 LGD_PCANCELSTR = 0 LGD_BUYER = 전찬홍 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902121439dGaa8 LGD_BUYERID = LGD_OID = Direct-dae1936-1725246640 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 12:12:17======================== insert into mBoard_order set rOrdNo = 'Direct-dae1936-1725246640', AuthTy = 'card', memberId = 'dae1936', OrdNm ='전찬홍', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대건비니루상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 45184212****825*', rApprNo = 'mjsof20240902121439dGaa8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 12:12:17', InvoiceNum = '결제성공:Direct-dae1936-1725246640/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 12:12:17' ========================2024-09-02 12:12:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902121439dGaa8' 0 = 1 cnt = 1 ========================2024-09-02 12:12:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dae1936' 0 = dae1936 Mid = dae1936 1 = 대건비니루상사 Mcompany = 대건비니루상사 2 = 202-31-60141 companyNum = 202-31-60141 3 = 02-2265-1936 Mtel1 = 02-2265-1936 4 = 010-3920-1936 Mhp = 010-3920-1936 ========================2024-09-02 12:12:17======================== select * from customers where id = 'dae1936' ========================2024-09-02 12:12:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dae1936','2024-09-02 12:12:17','220000','220000','온라인','0') ========================2024-09-02 14:16:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kyg2031-1725254155 LGD_BUYER = 김용국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902141555 LGD_HASHDATA = 46d6b5374eb9334d71a3f733fe25781a 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 = 2024090214185432CCB0328244BB359412BA093C67B870EFE4468E Mname = 김용국 Mcompany = (유)성광물산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kyg2031 LGD_ESCROW_USEYN = N ========================2024-09-02 14:16:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902141855 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005759 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55353101****671* LGD_FINANCEAUTHNUM = 29286099 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0419ee2282b369065f54751e9d95cba9 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240902141856 LGD_PCANCELSTR = 0 LGD_BUYER = 김용국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240902141855twyg2 LGD_BUYERID = LGD_OID = Direct-kyg2031-1725254155 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 021418285118 ========================2024-09-02 14:16:33======================== insert into mBoard_order set rOrdNo = 'Direct-kyg2031-1725254155', AuthTy = 'card', memberId = 'kyg2031', OrdNm ='김용국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)성광물산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 55353101****671*', rApprNo = 'mjsof20240902141855twyg2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 14:16:33', InvoiceNum = '결제성공:Direct-kyg2031-1725254155/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 14:16:33' ========================2024-09-02 14:16:34======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902141855twyg2' 0 = 1 cnt = 1 ========================2024-09-02 14:16:34======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kyg2031' 0 = kyg2031 Mid = kyg2031 1 = (유)성광물산 Mcompany = (유)성광물산 2 = 4018113328 companyNum = 4018113328 3 = 063-442-0360 Mtel1 = 063-442-0360 4 = 010-6796-1030 Mhp = 010-6796-1030 ========================2024-09-02 14:16:34======================== select * from customers where id = 'kyg2031' ========================2024-09-02 14:16:34======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kyg2031','2024-09-02 14:16:33','52500','55000','온라인','0') ========================2024-09-02 15:29:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lkg002-1725258369 LGD_BUYER = 이갑구 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902152609 LGD_HASHDATA = c9f094ad6815f9baeffc3350379b91d8 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 = 202409021531336C72FF238F9BA788D9E7C05689840F52277D6411 Mname = 이갑구 Mcompany = 미래씰링시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = lkg002 LGD_ESCROW_USEYN = N ========================2024-09-02 15:29:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902153134 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = lkg002@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004423 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35641547****105* LGD_FINANCEAUTHNUM = 30074594 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 13dc255ac3f2eb6a1b54daf55a756ecf LGD_BUYERADDRESS = LGD_FINANCENAME = 국민JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240902153134 LGD_PCANCELSTR = 0 LGD_BUYER = 이갑구 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902153134fXV77 LGD_BUYERID = LGD_OID = Direct-lkg002-1725258369 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 15:29:12======================== insert into mBoard_order set rOrdNo = 'Direct-lkg002-1725258369', AuthTy = 'card', memberId = 'lkg002', OrdNm ='이갑구', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '미래씰링시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민JCB 35641547****105*', rApprNo = 'mjsof20240902153134fXV77', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 15:29:12', InvoiceNum = '결제성공:Direct-lkg002-1725258369/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 15:29:12' ========================2024-09-02 15:29:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902153134fXV77' 0 = 1 cnt = 1 ========================2024-09-02 15:29:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lkg002' 0 = lkg002 Mid = lkg002 1 = 미래씰링시스템 Mcompany = 미래씰링시스템 2 = 1303635323 companyNum = 1303635323 3 = 031-366-5166 Mtel1 = 031-366-5166 4 = 010-3729-2427 Mhp = 010-3729-2427 ========================2024-09-02 15:29:12======================== select * from customers where id = 'lkg002' ========================2024-09-02 15:29:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lkg002','2024-09-02 15:29:12','52500','55000','온라인','0') ========================2024-09-02 19:28:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fatec2016-1725272768 LGD_BUYER = 원정묵 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902192608 LGD_HASHDATA = 3887d836446261b125ba69891aa051d3 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 = 202409021930391B16692C2FF8B2D5CBB4FEBC021B5AAA17786134 Mname = 원정묵 Mcompany = 파텍ENG post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = fatec2016 LGD_ESCROW_USEYN = N ========================2024-09-02 19:28:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902193040 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = fatec2016@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 = 94901924****301* LGD_FINANCEAUTHNUM = 00729978 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6a2456097a6bdc2dae9a1570b8511f76 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240902193040 LGD_PCANCELSTR = 0 LGD_BUYER = 원정묵 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902193040u5SR1 LGD_BUYERID = LGD_OID = Direct-fatec2016-1725272768 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 19:28:18======================== insert into mBoard_order set rOrdNo = 'Direct-fatec2016-1725272768', AuthTy = 'card', memberId = 'fatec2016', OrdNm ='원정묵', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '파텍ENG', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대 94901924****301*', rApprNo = 'mjsof20240902193040u5SR1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 19:28:18', InvoiceNum = '결제성공:Direct-fatec2016-1725272768/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 19:28:18' ========================2024-09-02 19:28:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902193040u5SR1' 0 = 1 cnt = 1 ========================2024-09-02 19:28:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fatec2016' 0 = fatec2016 Mid = fatec2016 1 = 파텍ENG Mcompany = 파텍ENG 2 = 8721500336 companyNum = 8721500336 3 = 052-263-0511 Mtel1 = 052-263-0511 4 = 010-3875-8083 Mhp = 010-3875-8083 ========================2024-09-02 19:28:18======================== select * from customers where id = 'fatec2016' ========================2024-09-02 19:28:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fatec2016','2024-09-02 19:28:18','108000','110000','온라인','0') ========================2024-09-02 20:27:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ssg2933-1725276194 LGD_BUYER = 정구성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902202314 LGD_HASHDATA = 1d8b21a8d28fb623cbb185616ce8cddf 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 = 202409022030144E70AE6F5480492BB8E8D8F58721248A37C80CAF Mname = 정구성 Mcompany = 이레수농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ssg2933 LGD_ESCROW_USEYN = N ========================2024-09-02 20:27:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902203015 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94901924****610* LGD_FINANCEAUTHNUM = 00954710 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fbcbae7f457fff488974529fec928be9 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240902203015 LGD_PCANCELSTR = 0 LGD_BUYER = 정구성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240902203015UzcH7 LGD_BUYERID = LGD_OID = Direct-ssg2933-1725276194 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 20:27:53======================== insert into mBoard_order set rOrdNo = 'Direct-ssg2933-1725276194', AuthTy = 'card', memberId = 'ssg2933', OrdNm ='정구성', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이레수농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대 94901924****610*', rApprNo = 'mjsof20240902203015UzcH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 20:27:53', InvoiceNum = '결제성공:Direct-ssg2933-1725276194/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 20:27:53' ========================2024-09-02 20:27:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240902203015UzcH7' 0 = 1 cnt = 1 ========================2024-09-02 20:27:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ssg2933' 0 = ssg2933 Mid = ssg2933 1 = 이레수농산 Mcompany = 이레수농산 2 = 138-90-41122 companyNum = 138-90-41122 3 = 031-451-2939 Mtel1 = 031-451-2939 4 = 010-9788-2933 Mhp = 010-9788-2933 ========================2024-09-02 20:27:53======================== select * from customers where id = 'ssg2933' ========================2024-09-02 20:27:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ssg2933','2024-09-02 20:27:53','52500','55000','온라인','0') ========================2024-09-02 21:27:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-retro60s-1725280002 LGD_BUYER = 배성혁 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240902212642 LGD_HASHDATA = 6b527049f60e95a4f3c4b7cac22fef9e 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 = 20240902213009287DCABAD350D96628FE8F9EDF89A39E3BAEA2E9 Mname = 배성혁 Mcompany = 식스티즈 커피컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = retro60s LGD_ESCROW_USEYN = N ========================2024-09-02 21:27:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240902213010 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BFBBQ0 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37798808****63* LGD_FINANCEAUTHNUM = 31147801 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4dd30adbbf25d6c50d07f400f4c82c1f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240902213010 LGD_PCANCELSTR = 0 LGD_BUYER = 배성혁 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024090221301017T42 LGD_BUYERID = LGD_OID = Direct-retro60s-1725280002 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-02 21:27:48======================== insert into mBoard_order set rOrdNo = 'Direct-retro60s-1725280002', AuthTy = 'card', memberId = 'retro60s', OrdNm ='배성혁', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '식스티즈 커피컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한AMEX 37798808****63*', rApprNo = 'mjsof2024090221301017T42', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-02 21:27:48', InvoiceNum = '결제성공:Direct-retro60s-1725280002/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-02 21:27:48' ========================2024-09-02 21:27:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024090221301017T42' 0 = 1 cnt = 1 ========================2024-09-02 21:27:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'retro60s' 0 = retro60s Mid = retro60s 1 = 식스티즈 커피컴퍼니 Mcompany = 식스티즈 커피컴퍼니 2 = 6407100166 companyNum = 6407100166 3 = 010-8550-9988 Mtel1 = 010-8550-9988 4 = 010-8550-9988 Mhp = 010-8550-9988 ========================2024-09-02 21:27:48======================== select * from customers where id = 'retro60s' ========================2024-09-02 21:27:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('retro60s','2024-09-02 21:27:48','108000','110000','온라인','0')