========================2022-10-31 12:24:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1667186457 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221031122057 LGD_HASHDATA = b9d09552d4c8597737eea19bb54e59d0 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 = 202210311227554EDA16ADD0490BA438166D90CD68C4289C82DE5C Mname = 박현석 Mcompany = 마니푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = anbinnakdo LGD_ESCROW_USEYN = N ========================2022-10-31 12:24:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221031122756 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94091511****810* LGD_FINANCEAUTHNUM = 26009814 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 44cf6b605344aa70bea6e2a3ce346d6f LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221031122756 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221031122756EEsO6 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1667186457 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-31 12:24:28======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1667186457', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****810*', rApprNo = 'mjsof20221031122756EEsO6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-31 12:24:28', InvoiceNum = '결제성공:Direct-anbinnakdo-1667186457/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-31 12:24:28' ========================2022-10-31 12:24:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221031122756EEsO6' 0 = 1 cnt = 1 ========================2022-10-31 12:24:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'anbinnakdo' 0 = anbinnakdo Mid = anbinnakdo 1 = 마니푸드 Mcompany = 마니푸드 2 = 121-20-60884 companyNum = 121-20-60884 3 = 070-4082-2105 Mtel1 = 070-4082-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2022-10-31 12:24:28======================== select * from customers where id = 'anbinnakdo' ========================2022-10-31 12:24:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2022-10-31 12:24:28','52500','55000','온라인','0') ========================2022-10-31 14:00:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-keyintech-1667192376 LGD_BUYER = 최지훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221031135936 LGD_HASHDATA = f71d9256a166716c05fb09c03c3f490b 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 = 20221031140359CDD30E3DB552C18886AD1FCDDE88665E223D8598 Mname = 최지훈 Mcompany = 키인텍 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = keyintech LGD_ESCROW_USEYN = N ========================2022-10-31 14:00:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221031140400 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55874901****435* LGD_FINANCEAUTHNUM = 87191317 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5c08d1efbe7e37d38b73a4a3c48136e4 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20221031140400 LGD_PCANCELSTR = 0 LGD_BUYER = 최지훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221031140400y5Wk6 LGD_BUYERID = LGD_OID = Direct-keyintech-1667192376 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-31 14:00:32======================== insert into mBoard_order set rOrdNo = 'Direct-keyintech-1667192376', AuthTy = 'card', memberId = 'keyintech', OrdNm ='최지훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '키인텍', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성MASTER 55874901****435*', rApprNo = 'mjsof20221031140400y5Wk6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-31 14:00:32', InvoiceNum = '결제성공:Direct-keyintech-1667192376/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-31 14:00:32' ========================2022-10-31 14:00:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221031140400y5Wk6' 0 = 1 cnt = 1 ========================2022-10-31 14:00:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'keyintech' 0 = keyintech Mid = keyintech 1 = 키인텍 Mcompany = 키인텍 2 = 1358601954 companyNum = 1358601954 3 = 031-202-4220 Mtel1 = 031-202-4220 4 = 010-8494-6894 Mhp = 010-8494-6894 ========================2022-10-31 14:00:32======================== select * from customers where id = 'keyintech' ========================2022-10-31 14:00:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('keyintech','2022-10-31 14:00:32','30900','33000','온라인','0') ========================2022-10-31 17:54:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-naeson9-1667206369 LGD_BUYER = 김정희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221031175249 LGD_HASHDATA = 68dfcba82f68749e756e84017e0d2dbb 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 = 202210311757471914DC5EEA8FEFC483445915505ACDA81915DAB6 Mname = 김정희 Mcompany = 주식회사 내손 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = naeson9 LGD_ESCROW_USEYN = N ========================2022-10-31 17:54:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221031175747 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****484* LGD_FINANCEAUTHNUM = 30045678 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = acc08cee25db97ea8432cea470c1f7e5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221031175747 LGD_PCANCELSTR = 0 LGD_BUYER = 김정희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221031175747xIIZ5 LGD_BUYERID = LGD_OID = Direct-naeson9-1667206369 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1175747xgni8 ========================2022-10-31 17:54:19======================== insert into mBoard_order set rOrdNo = 'Direct-naeson9-1667206369', AuthTy = 'card', memberId = 'naeson9', OrdNm ='김정희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 내손', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****484*', rApprNo = 'mjsof20221031175747xIIZ5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-31 17:54:19', InvoiceNum = '결제성공:Direct-naeson9-1667206369/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-31 17:54:19' ========================2022-10-31 17:54:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221031175747xIIZ5' 0 = 1 cnt = 1 ========================2022-10-31 17:54:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'naeson9' 0 = naeson9 Mid = naeson9 1 = 주식회사 내손 Mcompany = 주식회사 내손 2 = companyNum = 3 = 031-462-0944 Mtel1 = 031-462-0944 4 = 010-2229-0959 Mhp = 010-2229-0959 ========================2022-10-31 17:54:19======================== select * from customers where id = 'naeson9' ========================2022-10-31 17:54:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('naeson9','2022-10-31 17:54:19','220000','220000','온라인','0')