========================2024-12-05 10:42:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-chparkg-1733362644 LGD_BUYER = 박춘화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241205103724 LGD_HASHDATA = 749f40d0f9bda64473f947de767d4e6d 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 = 202412051042385F7B5670C4D4FBB0FF836942D38C9D5ACEDE1029 Mname = 박춘화 Mcompany = 주식회사 동보 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = chparkg LGD_ESCROW_USEYN = N ========================2024-12-05 10:42:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241205104239 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = koj3316@hanmail.net 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 = 94301773****294* LGD_FINANCEAUTHNUM = 42115669 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4be4042d14b9de9139d87981ff294a50 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241205104239 LGD_PCANCELSTR = 0 LGD_BUYER = 박춘화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241205104239mlkl5 LGD_BUYERID = LGD_OID = Direct-chparkg-1733362644 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-05 10:42:16======================== insert into mBoard_order set rOrdNo = 'Direct-chparkg-1733362644', AuthTy = 'card', memberId = 'chparkg', OrdNm ='박춘화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 동보', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301773****294*', rApprNo = 'mjsof20241205104239mlkl5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-05 10:42:16', InvoiceNum = '결제성공:Direct-chparkg-1733362644/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-05 10:42:16' ========================2024-12-05 10:42:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241205104239mlkl5' 0 = 1 cnt = 1 ========================2024-12-05 10:42:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'chparkg' 0 = chparkg Mid = chparkg 1 = 주식회사 동보 Mcompany = 주식회사 동보 2 = 721-88-00857 companyNum = 721-88-00857 3 = 054-859-3315 Mtel1 = 054-859-3315 4 = 010-8004-3304 Mhp = 010-8004-3304 ========================2024-12-05 10:42:17======================== select * from customers where id = 'chparkg' ========================2024-12-05 10:42:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('chparkg','2024-12-05 10:42:16','108000','110000','온라인','0') ========================2024-12-05 10:57:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-orion546-1733363791 LGD_BUYER = 권혁용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241205105631 LGD_HASHDATA = 49a5eb0d7af25c2d48ec09233ff44d41 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 = 20241205105744E8C73AA94E77B061DD470640CB32AF4A84F1474E Mname = 권혁용 Mcompany = 워너커피 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = orion546 LGD_ESCROW_USEYN = N ========================2024-12-05 10:57:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241205105745 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BJBBE4 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 46195410****808* LGD_FINANCEAUTHNUM = 11785766 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = e76eb6072cbd54c432dcfd573fd9d30f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20241205105746 LGD_PCANCELSTR = 0 LGD_BUYER = 권혁용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241205105745qBbs8 LGD_BUYERID = LGD_OID = Direct-orion546-1733363791 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-05 10:57:23======================== insert into mBoard_order set rOrdNo = 'Direct-orion546-1733363791', AuthTy = 'card', memberId = 'orion546', OrdNm ='권혁용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '워너커피', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한VISA 46195410****808*', rApprNo = 'mjsof20241205105745qBbs8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-05 10:57:23', InvoiceNum = '결제성공:Direct-orion546-1733363791/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-05 10:57:23' ========================2024-12-05 10:57:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241205105745qBbs8' 0 = 1 cnt = 1 ========================2024-12-05 10:57:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'orion546' 0 = orion546 Mid = orion546 1 = 워너커피 Mcompany = 워너커피 2 = 5633900821 companyNum = 5633900821 3 = 02-817-2284 Mtel1 = 02-817-2284 4 = 010-9726-3279 Mhp = 010-9726-3279 ========================2024-12-05 10:57:23======================== select * from customers where id = 'orion546' ========================2024-12-05 10:57:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('orion546','2024-12-05 10:57:23','30900','33000','온라인','0') ========================2024-12-05 18:49:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1733391944 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241205184544 LGD_HASHDATA = 3310261d55f934ca9440a50cd22f6d6f 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 = 2024120518501248367A84D69C5C24947BD530BC8B05D5F181E60C Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = tax@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-12-05 18:49:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241205185012 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 45425960 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c7082eb8c8ec1f1fe7c360f269dc0c1b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241205185013 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241205185012y7Vg8 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1733391944 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5185012yo028 ========================2024-12-05 18:49:50======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1733391944', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof20241205185012y7Vg8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-05 18:49:50', InvoiceNum = '결제성공:Direct-mmthcoffee-1733391944/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2024-12-05 18:49:50' ========================2024-12-05 18:49:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241205185012y7Vg8' 0 = 1 cnt = 1 ========================2024-12-05 18:49:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2024-12-05 18:49:50======================== select * from customers where id = 'mmthcoffee' ========================2024-12-05 18:49:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-12-05 18:49:50','220000','220000','온라인','0') ========================2024-12-05 18:50:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1733392204 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241205185004 LGD_HASHDATA = 7e7f5a9776338ab63c57c0018f45c2d6 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 = 20241205185100D4F9688DE55D6327F771EE95A58E528CFCD7C62F Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = support@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2024-12-05 18:50:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241205185101 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 45428694 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 51973046bf76a0fde3bc0df9cab1da81 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241205185101 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241205185100lD482 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1733392204 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5185100lfON9 ========================2024-12-05 18:50:38======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1733392204', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300309****993*', rApprNo = 'mjsof20241205185100lD482', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-05 18:50:38', InvoiceNum = '결제성공:Direct-mmthcoffee-1733392204/0000', Deliver = '', senditem = 'support@mmth.co.kr', salestopvalue = '', mod_date = '2024-12-05 18:50:38' ========================2024-12-05 18:50:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241205185100lD482' 0 = 1 cnt = 1 ========================2024-12-05 18:50:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2024-12-05 18:50:38======================== select * from customers where id = 'mmthcoffee' ========================2024-12-05 18:50:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2024-12-05 18:50:38','220000','220000','온라인','0')