========================2024-07-02 09:46:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kdb457384-1719881135 LGD_BUYER = 김대범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702094535 LGD_HASHDATA = a9d2ddd5f22693844aac5a5c7a735031 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 = 2024070209480718E414A011BC65941958B63FF84224C26AF9BB27 Mname = 김대범 Mcompany = 강산씨앤티 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kdb457384 LGD_ESCROW_USEYN = N ========================2024-07-02 09:46:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702094808 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852695****882* LGD_FINANCEAUTHNUM = 30062013 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 30c7e22e39da1befebe239265a0adc64 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240702094808 LGD_PCANCELSTR = 0 LGD_BUYER = 김대범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240702094808cRBP7 LGD_BUYERID = LGD_OID = Direct-kdb457384-1719881135 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2094808cWy33 ========================2024-07-02 09:46:57======================== insert into mBoard_order set rOrdNo = 'Direct-kdb457384-1719881135', AuthTy = 'card', memberId = 'kdb457384', OrdNm ='김대범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강산씨앤티', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852695****882*', rApprNo = 'mjsof20240702094808cRBP7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 09:46:57', InvoiceNum = '결제성공:Direct-kdb457384-1719881135/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 09:46:57' ========================2024-07-02 09:46:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702094808cRBP7' 0 = 1 cnt = 1 ========================2024-07-02 09:46:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kdb457384' 0 = kdb457384 Mid = kdb457384 1 = 강산씨앤티 Mcompany = 강산씨앤티 2 = 1643000581 companyNum = 1643000581 3 = 010-9777-8005 Mtel1 = 010-9777-8005 4 = 010-8934-8428 Mhp = 010-8934-8428 ========================2024-07-02 09:46:57======================== select * from customers where id = 'kdb457384' ========================2024-07-02 09:46:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kdb457384','2024-07-02 09:46:57','30900','33000','온라인','0') ========================2024-07-02 10:51:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hiki187-1719885035 LGD_BUYER = 박승완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702105035 LGD_HASHDATA = 0b711deeb4209a2290fb250bc8f00f74 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 = 20240702105300D910A00161754611EDEA192F0BE2AB423783BD55 Mname = 박승완 Mcompany = 주식회사 하이키 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hiki187 LGD_ESCROW_USEYN = N ========================2024-07-02 10:51:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702105301 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DAA67I LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****486* LGD_FINANCEAUTHNUM = 43180690 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 85e49c6683eaeb8cc507d526962442f9 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240702105301 LGD_PCANCELSTR = 0 LGD_BUYER = 박승완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240702105301fcOW6 LGD_BUYERID = LGD_OID = Direct-hiki187-1719885035 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-02 10:51:50======================== insert into mBoard_order set rOrdNo = 'Direct-hiki187-1719885035', AuthTy = 'card', memberId = 'hiki187', OrdNm ='박승완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하이키', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****486*', rApprNo = 'mjsof20240702105301fcOW6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 10:51:50', InvoiceNum = '결제성공:Direct-hiki187-1719885035/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 10:51:50' ========================2024-07-02 10:51:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702105301fcOW6' 0 = 1 cnt = 1 ========================2024-07-02 10:51:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hiki187' 0 = hiki187 Mid = hiki187 1 = 주식회사 하이키 Mcompany = 주식회사 하이키 2 = 1148639017 companyNum = 1148639017 3 = 02-3477-1129 Mtel1 = 02-3477-1129 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2024-07-02 10:51:50======================== select * from customers where id = 'hiki187' ========================2024-07-02 10:51:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hiki187','2024-07-02 10:51:50','52500','55000','온라인','0') ========================2024-07-02 11:29:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goldstar6693-1719887080 LGD_BUYER = 나대균 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702112440 LGD_HASHDATA = df2387c4799a38ac0659f209729df2ab 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 = 20240702113042FC808068A5D5E5B21F3C6744F730A97DC5DBE2A8 Mname = 나대균 Mcompany = 금성전기조명 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goldstar6693 LGD_ESCROW_USEYN = N ========================2024-07-02 11:29:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702113042 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 = 53769200****672* LGD_FINANCEAUTHNUM = 00573462 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 58878831dd318ffdbe70810cb0594a0d LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240702113042 LGD_PCANCELSTR = 0 LGD_BUYER = 나대균 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240702113042ZgNI6 LGD_BUYERID = LGD_OID = Direct-goldstar6693-1719887080 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-02 11:29:31======================== insert into mBoard_order set rOrdNo = 'Direct-goldstar6693-1719887080', AuthTy = 'card', memberId = 'goldstar6693', OrdNm ='나대균', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금성전기조명', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 53769200****672*', rApprNo = 'mjsof20240702113042ZgNI6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 11:29:31', InvoiceNum = '결제성공:Direct-goldstar6693-1719887080/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 11:29:31' ========================2024-07-02 11:29:31======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702113042ZgNI6' 0 = 1 cnt = 1 ========================2024-07-02 11:29:31======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goldstar6693' 0 = goldstar6693 Mid = goldstar6693 1 = 금성전기조명 Mcompany = 금성전기조명 2 = 488-15-00015 companyNum = 488-15-00015 3 = 010-5114-6693 Mtel1 = 010-5114-6693 4 = 010-5119-6693 Mhp = 010-5119-6693 ========================2024-07-02 11:29:31======================== select * from customers where id = 'goldstar6693' ========================2024-07-02 11:29:31======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goldstar6693','2024-07-02 11:29:31','108000','110000','온라인','0') ========================2024-07-02 13:42:29======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmi007-1719895284 LGD_BUYER = 신영준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702134124 LGD_HASHDATA = 8d1ecd692d2c36f9b1b24ce03cb66023 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 = 202407021343403F32D5C101249565F394BE1A9ACA04D5B1A6EBE1 Mname = 신영준 Mcompany = 옹달샘식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = mmi007 LGD_ESCROW_USEYN = N ========================2024-07-02 13:42:30======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20240702134341 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 52994200****130* LGD_FINANCEAUTHNUM = 00809971 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d337e886dcfa42a6e2b452e62d9dfcb3 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240702134341 LGD_PCANCELSTR = 0 LGD_BUYER = 신영준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240702134334yONy2 LGD_BUYERID = LGD_OID = Direct-mmi007-1719895284 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-02 13:42:30======================== insert into mBoard_order set rOrdNo = 'Direct-mmi007-1719895284', AuthTy = 'card', memberId = 'mmi007', OrdNm ='신영준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '옹달샘식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 52994200****130*', rApprNo = 'mjsof20240702134334yONy2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 13:42:30', InvoiceNum = '결제성공:Direct-mmi007-1719895284/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 13:42:30' ========================2024-07-02 13:42:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702134334yONy2' 0 = 1 cnt = 1 ========================2024-07-02 13:42:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmi007' 0 = mmi007 Mid = mmi007 1 = 옹달샘식품 Mcompany = 옹달샘식품 2 = 5346600305 companyNum = 5346600305 3 = 010-3397-9292 Mtel1 = 010-3397-9292 4 = 010-3397-9292 Mhp = 010-3397-9292 ========================2024-07-02 13:42:30======================== select * from customers where id = 'mmi007' ========================2024-07-02 13:42:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmi007','2024-07-02 13:42:30','108000','110000','온라인','0') ========================2024-07-02 13:43:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-md_eng-1719895242 LGD_BUYER = 김난희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702134042 LGD_HASHDATA = d5681be2e5f926f85b43b021db2b01c5 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 = 202407021344212DBE00620772A549D5D0EB8BBB31E8BF8E1465CE Mname = 김난희 Mcompany = 엠디엔지니어링 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = md_eng LGD_ESCROW_USEYN = N ========================2024-07-02 13:43:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702134421 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = md_eng@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 040633 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94400315****499* LGD_FINANCEAUTHNUM = 45393267 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = afbc38e5092aca53c8cf7dc686d19fd6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240702134422 LGD_PCANCELSTR = 0 LGD_BUYER = 김난희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240702134421ZEed1 LGD_BUYERID = LGD_OID = Direct-md_eng-1719895242 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2134421Z1lZ7 ========================2024-07-02 13:43:11======================== insert into mBoard_order set rOrdNo = 'Direct-md_eng-1719895242', AuthTy = 'card', memberId = 'md_eng', OrdNm ='김난희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엠디엔지니어링', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94400315****499*', rApprNo = 'mjsof20240702134421ZEed1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 13:43:11', InvoiceNum = '결제성공:Direct-md_eng-1719895242/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 13:43:11' ========================2024-07-02 13:43:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702134421ZEed1' 0 = 1 cnt = 1 ========================2024-07-02 13:43:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'md_eng' 0 = md_eng Mid = md_eng 1 = 엠디엔지니어링 Mcompany = 엠디엔지니어링 2 = 1288677723 companyNum = 1288677723 3 = 031-907-1586 Mtel1 = 031-907-1586 4 = 010-2320-1586 Mhp = 010-2320-1586 ========================2024-07-02 13:43:11======================== select * from customers where id = 'md_eng' ========================2024-07-02 13:43:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('md_eng','2024-07-02 13:43:11','220000','220000','온라인','0') ========================2024-07-02 16:57:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-todamls-1719907006 LGD_BUYER = 유대웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702165646 LGD_HASHDATA = cb77d66b9985213884502101e6c0bd98 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 = 2024070216584685DD2CAEFA0A00D446BDCB50BE22B20AB9EAFE1B Mname = 유대웅 Mcompany = (주)토담유통상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = todamls LGD_ESCROW_USEYN = N ========================2024-07-02 16:57:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702165847 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51107002****015* LGD_FINANCEAUTHNUM = 29266923 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bf9c277049bc037310b7b2fe157b86fe LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240702165848 LGD_PCANCELSTR = 0 LGD_BUYER = 유대웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240702165847c4qG0 LGD_BUYERID = LGD_OID = Direct-todamls-1719907006 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 021658263206 ========================2024-07-02 16:57:36======================== insert into mBoard_order set rOrdNo = 'Direct-todamls-1719907006', AuthTy = 'card', memberId = 'todamls', OrdNm ='유대웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토담유통상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 51107002****015*', rApprNo = 'mjsof20240702165847c4qG0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 16:57:36', InvoiceNum = '결제성공:Direct-todamls-1719907006/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 16:57:36' ========================2024-07-02 16:57:36======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240702165847c4qG0' 0 = 1 cnt = 1 ========================2024-07-02 16:57:36======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'todamls' 0 = todamls Mid = todamls 1 = (주)토담유통상사 Mcompany = (주)토담유통상사 2 = 403-81-36254 companyNum = 403-81-36254 3 = 063-837-7799 Mtel1 = 063-837-7799 4 = 010-9626-7293 Mhp = 010-9626-7293 ========================2024-07-02 16:57:36======================== select * from customers where id = 'todamls' ========================2024-07-02 16:57:36======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('todamls','2024-07-02 16:57:36','52500','55000','온라인','0') ========================2024-07-02 17:13:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1719907938 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240702171218 LGD_HASHDATA = 4659fd87bec90742385aec30769f2c5b 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 = 20240702171417259D2897CE8A2246AB7C62A20B62A97255EDD244 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 ========================2024-07-02 17:13:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240702171417 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300317****994* LGD_FINANCEAUTHNUM = 47647312 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c3c84a4211beb5135598bcaa4ca89317 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240702171418 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202407021714171T4j7 LGD_BUYERID = LGD_OID = Direct-yhk8100-1719907938 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 21714171t379 ========================2024-07-02 17:13:06======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1719907938', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300317****994*', rApprNo = 'mjsof202407021714171T4j7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-02 17:13:06', InvoiceNum = '결제성공:Direct-yhk8100-1719907938/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-02 17:13:06' ========================2024-07-02 17:13:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202407021714171T4j7' 0 = 1 cnt = 1 ========================2024-07-02 17:13:06======================== 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 = 010-6364-5451 Mhp = 010-6364-5451 ========================2024-07-02 17:13:06======================== select * from customers where id = 'yhk8100' ========================2024-07-02 17:13:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2024-07-02 17:13:06','52500','55000','온라인','0')