========================2023-04-12 11:21:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-supper2000-1681265868 LGD_BUYER = 김겸 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230412111748 LGD_HASHDATA = dfca07e71e6ee3944b86ba1d59291e49 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 = 2023041211274185341D56DF52638A4F84CEBA55E21954AB7CCF2F Mname = 김겸 Mcompany = 동부보육사/동부소독 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = supper2000 LGD_ESCROW_USEYN = N ========================2023-04-12 11:21:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230412112816 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94311702****258* LGD_FINANCEAUTHNUM = 75982460 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 72ca336cd272fae52922a8f7b8f7ea89 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230412112817 LGD_PCANCELSTR = 0 LGD_BUYER = 김겸 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230412112816nIed7 LGD_BUYERID = LGD_OID = Direct-supper2000-1681265868 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-04-12 11:21:49======================== insert into mBoard_order set rOrdNo = 'Direct-supper2000-1681265868', AuthTy = 'card', memberId = 'supper2000', OrdNm ='김겸', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동부보육사/동부소독', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = 'NH 94311702****258*', rApprNo = 'mjsof20230412112816nIed7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-12 11:21:49', InvoiceNum = '결제성공:Direct-supper2000-1681265868/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-12 11:21:49' ========================2023-04-12 11:21:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230412112816nIed7' 0 = 1 cnt = 1 ========================2023-04-12 11:21:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'supper2000' 0 = supper2000 Mid = supper2000 1 = 동부보육사/동부소독 Mcompany = 동부보육사/동부소독 2 = 8422300475 companyNum = 8422300475 3 = 010-6340-9953 Mtel1 = 010-6340-9953 4 = 010-6340-9953 Mhp = 010-6340-9953 ========================2023-04-12 11:21:49======================== select * from customers where id = 'supper2000' ========================2023-04-12 11:21:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('supper2000','2023-04-12 11:21:49','10000','11000','온라인','0') ========================2023-04-12 14:10:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joygarden2-1681276098 LGD_BUYER = 백성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230412140818 LGD_HASHDATA = c2c8f341f2c22eb3d0f5fba53f0d27b4 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 = 20230412141655D8219C49B21C72EF5D1900D523825E9EC4286C1F Mname = 백성희 Mcompany = 가든자재한샘 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = joygarden2 LGD_ESCROW_USEYN = N ========================2023-04-12 14:10:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230412141655 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****887* LGD_FINANCEAUTHNUM = 30000029 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d7bd08410b98866ca58da2cf2b96abcb LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230412141655 LGD_PCANCELSTR = 0 LGD_BUYER = 백성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230412141655qBkD7 LGD_BUYERID = LGD_OID = Direct-joygarden2-1681276098 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2141655qPOo8 ========================2023-04-12 14:10:27======================== insert into mBoard_order set rOrdNo = 'Direct-joygarden2-1681276098', AuthTy = 'card', memberId = 'joygarden2', OrdNm =' 백성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '가든자재한샘', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****887*', rApprNo = 'mjsof20230412141655qBkD7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-12 14:10:27', InvoiceNum = '결제성공:Direct-joygarden2-1681276098/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-12 14:10:27' ========================2023-04-12 14:10:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230412141655qBkD7' 0 = 1 cnt = 1 ========================2023-04-12 14:10:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joygarden2' 0 = joygarden2 Mid = joygarden2 1 = 가든자재한샘 Mcompany = 가든자재한샘 2 = 707-20-01603 companyNum = 707-20-01603 3 = 010-8299-5335 Mtel1 = 010-8299-5335 4 = Mhp = ========================2023-04-12 14:10:27======================== select * from customers where id = 'joygarden2' ========================2023-04-12 14:10:27======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('joygarden2','가든자재한샘','7072001603','010-8299-5335','','2023-04-12 14:10:27','온라인') ========================2023-04-12 14:10:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joygarden2','2023-04-12 14:10:27','10000','11000','온라인','0') ========================2023-04-12 17:47:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kostick-1681289186 LGD_BUYER = 이병식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230412174626 LGD_HASHDATA = 62a1187c88afccd768577c81e03c00d4 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 = 202304121754163669B330A31386B22B89C146115CABBDEDBD454A Mname = 이병식 Mcompany = 주식회사코스틱 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kostick LGD_ESCROW_USEYN = N ========================2023-04-12 17:47:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230412175417 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004920 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658694****788* LGD_FINANCEAUTHNUM = 30007933 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 656e13631e15eab81bc824769e18f519 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230412175418 LGD_PCANCELSTR = 0 LGD_BUYER = 이병식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230412175417U4Tw8 LGD_BUYERID = LGD_OID = Direct-kostick-1681289186 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2175417UpXu8 ========================2023-04-12 17:47:49======================== insert into mBoard_order set rOrdNo = 'Direct-kostick-1681289186', AuthTy = 'card', memberId = 'kostick', OrdNm ='이병식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사코스틱', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 42658694****788*', rApprNo = 'mjsof20230412175417U4Tw8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-04-12 17:47:49', InvoiceNum = '결제성공:Direct-kostick-1681289186/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-04-12 17:47:49' ========================2023-04-12 17:47:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230412175417U4Tw8' 0 = 1 cnt = 1 ========================2023-04-12 17:47:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kostick' 0 = kostick Mid = kostick 1 = 주식회사코스틱 Mcompany = 주식회사코스틱 2 = 2068705109 companyNum = 2068705109 3 = 010-6364-7480 Mtel1 = 010-6364-7480 4 = 010-6364-7480 Mhp = 010-6364-7480 ========================2023-04-12 17:47:49======================== select * from customers where id = 'kostick' ========================2023-04-12 17:47:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kostick','2023-04-12 17:47:49','108000','110000','온라인','0')