========================2022-10-10 08:59:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkjung184-1665359851 LGD_BUYER = 박정 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010085731 LGD_HASHDATA = 404f7349a4b857212446d531dab8e555 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 = 202210100902204A12F115F99C662C3ABA64EF61E19CBBFBB82DA0 Mname = 박정 Mcompany = 금만푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = parkjung184 LGD_ESCROW_USEYN = N ========================2022-10-10 08:59:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010090221 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 834593 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91002001****272* LGD_FINANCEAUTHNUM = 40219327 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7c9e6f720c97de835818cffd0246df77 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221010090221 LGD_PCANCELSTR = 0 LGD_BUYER = 박정 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221010090221YsDp5 LGD_BUYERID = LGD_OID = Direct-parkjung184-1665359851 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0090221YXuC4 ========================2022-10-10 08:59:17======================== insert into mBoard_order set rOrdNo = 'Direct-parkjung184-1665359851', AuthTy = 'card', memberId = 'parkjung184', OrdNm ='박정', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금만푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리 91002001****272*', rApprNo = 'mjsof20221010090221YsDp5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 08:59:17', InvoiceNum = '결제성공:Direct-parkjung184-1665359851/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 08:59:17' ========================2022-10-10 08:59:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010090221YsDp5' 0 = 1 cnt = 1 ========================2022-10-10 08:59:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkjung184' 0 = parkjung184 Mid = parkjung184 1 = 금만푸드 Mcompany = 금만푸드 2 = 4230901054 companyNum = 4230901054 3 = 010-5268-2362 Mtel1 = 010-5268-2362 4 = 010-5268-2362 Mhp = 010-5268-2362 ========================2022-10-10 08:59:17======================== select * from customers where id = 'parkjung184' ========================2022-10-10 08:59:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkjung184','2022-10-10 08:59:17','52500','55000','온라인','0') ========================2022-10-10 11:28:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-volume0305-1665368728 LGD_BUYER = 모민수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010112528 LGD_HASHDATA = 006127257b524382eeb2bd1f9ad25675 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 = 20221010113133C4023FB8C1CEFDDFF94A07D3F1F94C8EF9853295 Mname = 모민수 Mcompany = 충청건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = volume0305 LGD_ESCROW_USEYN = N ========================2022-10-10 11:28:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010113134 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 = 62436303****674* LGD_FINANCEAUTHNUM = 71539401 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 017f070a66bc0ad91bd0459dbd6d0dec LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221010113134 LGD_PCANCELSTR = 0 LGD_BUYER = 모민수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221010113134XexK8 LGD_BUYERID = LGD_OID = Direct-volume0305-1665368728 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-10 11:28:30======================== insert into mBoard_order set rOrdNo = 'Direct-volume0305-1665368728', AuthTy = 'card', memberId = 'volume0305', OrdNm ='모민수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충청건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '농협CUP 62436303****674*', rApprNo = 'mjsof20221010113134XexK8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 11:28:30', InvoiceNum = '결제성공:Direct-volume0305-1665368728/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 11:28:30' ========================2022-10-10 11:28:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010113134XexK8' 0 = 1 cnt = 1 ========================2022-10-10 11:28:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'volume0305' 0 = volume0305 Mid = volume0305 1 = 충청건재 Mcompany = 충청건재 2 = 733-15-01592 companyNum = 733-15-01592 3 = 010-2750-8222 Mtel1 = 010-2750-8222 4 = 010-2750-8222 Mhp = 010-2750-8222 ========================2022-10-10 11:28:30======================== select * from customers where id = 'volume0305' ========================2022-10-10 11:28:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('volume0305','2022-10-10 11:28:30','10000','11000','온라인','0') ========================2022-10-10 13:23:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1665375754 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010132234 LGD_HASHDATA = 7690ff8066a8d9218ba7a94e9053f170 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 = 20221010132635A3E4A1858FA8E81CA707ACFD1964BE511617F508 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-10-10 13:23:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010132636 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 = 41680971 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1e59d672806577391f6c245ac604a5a5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221010132636 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221010132635UqPR9 LGD_BUYERID = LGD_OID = Direct-yhk8100-1665375754 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0132635UjPt7 ========================2022-10-10 13:23:31======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1665375754', 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 = 'mjsof20221010132635UqPR9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 13:23:31', InvoiceNum = '결제성공:Direct-yhk8100-1665375754/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 13:23:31' ========================2022-10-10 13:23:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010132635UqPR9' 0 = 1 cnt = 1 ========================2022-10-10 13:23:31======================== 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-10-10 13:23:31======================== select * from customers where id = 'yhk8100' ========================2022-10-10 13:23:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2022-10-10 13:23:31','52500','55000','온라인','0') ========================2022-10-10 16:36:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yk9906-1665387270 LGD_BUYER = 류경동 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010163430 LGD_HASHDATA = c2b571bbf656a95199bd14c0488b2c56 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 = 2022101016392923C9D9B892BED17B1B698E1ACB5346954D11E6C4 Mname = 류경동 Mcompany = 영암상회 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yk9906 LGD_ESCROW_USEYN = N ========================2022-10-10 16:36:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010163930 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 171272 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55321245****934* LGD_FINANCEAUTHNUM = 43204441 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 05d26fbad47c46c7d48bad00a4cab799 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221010163930 LGD_PCANCELSTR = 0 LGD_BUYER = 류경동 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221010163930Y1YH7 LGD_BUYERID = LGD_OID = Direct-yk9906-1665387270 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0163930YarY4 ========================2022-10-10 16:36:25======================== insert into mBoard_order set rOrdNo = 'Direct-yk9906-1665387270', AuthTy = 'card', memberId = 'yk9906', OrdNm ='류경동', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '영암상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55321245****934*', rApprNo = 'mjsof20221010163930Y1YH7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 16:36:25', InvoiceNum = '결제성공:Direct-yk9906-1665387270/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 16:36:25' ========================2022-10-10 16:36:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010163930Y1YH7' 0 = 1 cnt = 1 ========================2022-10-10 16:36:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yk9906' 0 = yk9906 Mid = yk9906 1 = 영암상회 Mcompany = 영암상회 2 = 4098162691 companyNum = 4098162691 3 = 062-267-0414 Mtel1 = 062-267-0414 4 = 010-3912-9906 Mhp = 010-3912-9906 ========================2022-10-10 16:36:25======================== select * from customers where id = 'yk9906' ========================2022-10-10 16:36:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yk9906','2022-10-10 16:36:25','52500','55000','온라인','0') ========================2022-10-10 20:01:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1665399661 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010200101 LGD_HASHDATA = af18702103268ed13fced19c536bf9b5 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 = 202210102004560B2C7CF21F459174B362694AA91184D9B6FDC42A Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2022-10-10 20:01:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010200457 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 = 40493380****762* LGD_FINANCEAUTHNUM = 00165270 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1abb00c3d148c4363c51fe03ba57e1ed LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221010200457 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221010200457T1XC0 LGD_BUYERID = LGD_OID = Direct-we32-1665399661 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-10 20:01:52======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1665399661', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 40493380****762*', rApprNo = 'mjsof20221010200457T1XC0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 20:01:52', InvoiceNum = '결제성공:Direct-we32-1665399661/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 20:01:52' ========================2022-10-10 20:01:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010200457T1XC0' 0 = 1 cnt = 1 ========================2022-10-10 20:01:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2022-10-10 20:01:52======================== select * from customers where id = 'we32' ========================2022-10-10 20:01:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2022-10-10 20:01:52','52500','55000','온라인','0') ========================2022-10-10 23:19:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejongmaster-1665411474 LGD_BUYER = 김민준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221010231754 LGD_HASHDATA = a2bc657d84ac1df49b548d0ab3879d76 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 = 202210102322129D91EA35E775208C5C07693C2D9ACE8054330A5F Mname = 김민준 Mcompany = 그래인팜 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sejongmaster LGD_ESCROW_USEYN = N ========================2022-10-10 23:19:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221010232213 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 = 54241604****128* LGD_FINANCEAUTHNUM = 40729045 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 093b7af9dbccf0416a3872667571ff59 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221010232213 LGD_PCANCELSTR = 0 LGD_BUYER = 김민준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221010232213PI7U6 LGD_BUYERID = LGD_OID = Direct-sejongmaster-1665411474 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-10 23:19:08======================== insert into mBoard_order set rOrdNo = 'Direct-sejongmaster-1665411474', AuthTy = 'card', memberId = 'sejongmaster', OrdNm ='김민준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '그래인팜', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH MASTER 54241604****128*', rApprNo = 'mjsof20221010232213PI7U6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-10 23:19:08', InvoiceNum = '결제성공:Direct-sejongmaster-1665411474/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-10 23:19:08' ========================2022-10-10 23:19:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221010232213PI7U6' 0 = 1 cnt = 1 ========================2022-10-10 23:19:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejongmaster' 0 = sejongmaster Mid = sejongmaster 1 = 그래인팜 Mcompany = 그래인팜 2 = 5770600079 companyNum = 5770600079 3 = 010-3927-8183 Mtel1 = 010-3927-8183 4 = 010-3827-8183 Mhp = 010-3827-8183 ========================2022-10-10 23:19:08======================== select * from customers where id = 'sejongmaster' ========================2022-10-10 23:19:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejongmaster','2022-10-10 23:19:08','10000','11000','온라인','0')