========================2024-12-31 07:08:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phso51900-1735596422 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231070702 LGD_HASHDATA = 7d14f03bb5dee55beb7488a031a6c256 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 = 20241231070916FC4112401E302182F7A8E57D3ECACC1EE36BF019 Mname = 박현석 Mcompany = 인화유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = phso51900 LGD_ESCROW_USEYN = N ========================2024-12-31 07:08:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231070917 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = phso519@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797347****608* LGD_FINANCEAUTHNUM = 30042767 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2976bc3eef531d93c761020fe6d3cec2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241231070917 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241231070917dRO79 LGD_BUYERID = LGD_OID = Direct-phso51900-1735596422 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 07:08:26======================== insert into mBoard_order set rOrdNo = 'Direct-phso51900-1735596422', AuthTy = 'card', memberId = 'phso51900', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '인화유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797347****608*', rApprNo = 'mjsof20241231070917dRO79', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 07:08:26', InvoiceNum = '결제성공:Direct-phso51900-1735596422/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 07:08:26' ========================2024-12-31 07:08:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241231070917dRO79' 0 = 1 cnt = 1 ========================2024-12-31 07:08:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phso51900' 0 = phso51900 Mid = phso51900 1 = 인화유통 Mcompany = 인화유통 2 = 326-27-01169 companyNum = 326-27-01169 3 = 010-9099-2105 Mtel1 = 010-9099-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2024-12-31 07:08:26======================== select * from customers where id = 'phso51900' ========================2024-12-31 07:08:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phso51900','2024-12-31 07:08:26','52500','55000','온라인','0') ========================2024-12-31 10:27:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kimhando-1735608302 LGD_BUYER = 김한도 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231102502 LGD_HASHDATA = 4b6e994dc412ec96ea72add220466df1 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 = 20241231102810A5E26B592BB0379E824DB8F4288E08207011388D Mname = 김한도 Mcompany = 주식회사 종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kimhando LGD_ESCROW_USEYN = N ========================2024-12-31 10:27:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231102811 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = daehanmobil1@naver.com 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 = 94301703****829* LGD_FINANCEAUTHNUM = 57080220 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 29b50bf5963530801f56589e3e9d1246 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241231102812 LGD_PCANCELSTR = 0 LGD_BUYER = 김한도 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241231102811dcJa8 LGD_BUYERID = LGD_OID = Direct-kimhando-1735608302 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 10:27:20======================== insert into mBoard_order set rOrdNo = 'Direct-kimhando-1735608302', AuthTy = 'card', memberId = 'kimhando', OrdNm ='김한도', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****829*', rApprNo = 'mjsof20241231102811dcJa8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 10:27:20', InvoiceNum = '결제성공:Direct-kimhando-1735608302/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 10:27:20' ========================2024-12-31 10:27:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241231102811dcJa8' 0 = 1 cnt = 1 ========================2024-12-31 10:27:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kimhando' 0 = kimhando Mid = kimhando 1 = 주식회사 종합유통 Mcompany = 주식회사 종합유통 2 = 3648100688 companyNum = 3648100688 3 = 044-553-9203 Mtel1 = 044-553-9203 4 = 010-8774-8951 Mhp = 010-8774-8951 ========================2024-12-31 10:27:20======================== select * from customers where id = 'kimhando' ========================2024-12-31 10:27:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kimhando','2024-12-31 10:27:20','220000','220000','온라인','0') ========================2024-12-31 10:42:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kdb457384-1735609231 LGD_BUYER = 김대범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231104031 LGD_HASHDATA = f6d488ec265750068e1f42c561295cce 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 = 202412311043425D6E079F710FCACFDC17CACC2EB6EE6E0BE5D737 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-12-31 10:42:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231104342 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 = 30064598 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0230f3cd0efdf89b8e24be30ba7d7ce4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241231104342 LGD_PCANCELSTR = 0 LGD_BUYER = 김대범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311043424IuR9 LGD_BUYERID = LGD_OID = Direct-kdb457384-1735609231 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11043424EoU4 ========================2024-12-31 10:42:51======================== insert into mBoard_order set rOrdNo = 'Direct-kdb457384-1735609231', 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 = 'mjsof202412311043424IuR9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 10:42:51', InvoiceNum = '결제성공:Direct-kdb457384-1735609231/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 10:42:51' ========================2024-12-31 10:42:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311043424IuR9' 0 = 1 cnt = 1 ========================2024-12-31 10:42:51======================== 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-12-31 10:42:51======================== select * from customers where id = 'kdb457384' ========================2024-12-31 10:42:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kdb457384','2024-12-31 10:42:51','30900','33000','온라인','0') ========================2024-12-31 13:31:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jgs3010-1735619446 LGD_BUYER = 주건석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231133046 LGD_HASHDATA = fc0165d19db817a5e2ebb28a56503953 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 = 20241231133234BFBC2B94F0567456666F92C6ECEF4A256281979A Mname = 주건석 Mcompany = 제이앤티종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jgs3010 LGD_ESCROW_USEYN = N ========================2024-12-31 13:31:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231133235 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jgs3010@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009063 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54092676****706* LGD_FINANCEAUTHNUM = 30099860 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0cacbdd21048d8eb2ecfc033a8403ac4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241231133236 LGD_PCANCELSTR = 0 LGD_BUYER = 주건석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241231133235dBYH1 LGD_BUYERID = LGD_OID = Direct-jgs3010-1735619446 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 13:31:44======================== insert into mBoard_order set rOrdNo = 'Direct-jgs3010-1735619446', AuthTy = 'card', memberId = 'jgs3010', OrdNm ='주건석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이앤티종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 54092676****706*', rApprNo = 'mjsof20241231133235dBYH1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 13:31:44', InvoiceNum = '결제성공:Direct-jgs3010-1735619446/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 13:31:44' ========================2024-12-31 13:31:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241231133235dBYH1' 0 = 1 cnt = 1 ========================2024-12-31 13:31:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jgs3010' 0 = jgs3010 Mid = jgs3010 1 = 제이앤티종합상사 Mcompany = 제이앤티종합상사 2 = 6212227943 companyNum = 6212227943 3 = 055-367-5275 Mtel1 = 055-367-5275 4 = 010-7444-5275 Mhp = 010-7444-5275 ========================2024-12-31 13:31:44======================== select * from customers where id = 'jgs3010' ========================2024-12-31 13:31:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jgs3010','2024-12-31 13:31:44','10000','11000','온라인','0') ========================2024-12-31 14:21:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ganam5766-1735622404 LGD_BUYER = 김재웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231142004 LGD_HASHDATA = e65f913104ffa30aada31b13fdb67d81 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 = 2024123114220732BCE9A47A6AEF34AA5A558CACC5A73976917769 Mname = 김재웅 Mcompany = 주식회사 가남철물건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = ganam5766 LGD_ESCROW_USEYN = N ========================2024-12-31 14:21:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231142207 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ganam5766@gmail.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852682****804* LGD_FINANCEAUTHNUM = 30004380 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 64e2fff86e1d80becab9886aef5fe697 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241231142208 LGD_PCANCELSTR = 0 LGD_BUYER = 김재웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311422078iIw2 LGD_BUYERID = LGD_OID = Direct-ganam5766-1735622404 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 14:21:16======================== insert into mBoard_order set rOrdNo = 'Direct-ganam5766-1735622404', AuthTy = 'card', memberId = 'ganam5766', OrdNm ='김재웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 가남철물건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852682****804*', rApprNo = 'mjsof202412311422078iIw2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 14:21:16', InvoiceNum = '결제성공:Direct-ganam5766-1735622404/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 14:21:16' ========================2024-12-31 14:21:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311422078iIw2' 0 = 1 cnt = 1 ========================2024-12-31 14:21:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ganam5766' 0 = ganam5766 Mid = ganam5766 1 = 주식회사 가남철물건재 Mcompany = 주식회사 가남철물건재 2 = 5918603211 companyNum = 5918603211 3 = 010-9250-5766 Mtel1 = 010-9250-5766 4 = 010-9250-5766 Mhp = 010-9250-5766 ========================2024-12-31 14:21:16======================== select * from customers where id = 'ganam5766' ========================2024-12-31 14:21:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ganam5766','2024-12-31 14:21:16','52500','55000','온라인','0') ========================2024-12-31 14:26:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ongdalsem-1735622686 LGD_BUYER = 이석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231142446 LGD_HASHDATA = c5747d9089ecf7ff845fba990578dd1e 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 = 202412311426538DF977987C3A6D22C2C91B75E1086BFE4EAAAB98 Mname = 이석 Mcompany = 주식회사 오씨코퍼레이션 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ongdalsem LGD_ESCROW_USEYN = N ========================2024-12-31 14:26:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231142654 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = startme0109@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658660****303* LGD_FINANCEAUTHNUM = 30054057 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2fba4acf433b918bd7e1ea514e05b522 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241231142654 LGD_PCANCELSTR = 0 LGD_BUYER = 이석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311426541nWw0 LGD_BUYERID = LGD_OID = Direct-ongdalsem-1735622686 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 14:26:02======================== insert into mBoard_order set rOrdNo = 'Direct-ongdalsem-1735622686', AuthTy = 'card', memberId = 'ongdalsem', OrdNm ='이석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 오씨코퍼레이션', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658660****303*', rApprNo = 'mjsof202412311426541nWw0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 14:26:02', InvoiceNum = '결제성공:Direct-ongdalsem-1735622686/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 14:26:02' ========================2024-12-31 14:26:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311426541nWw0' 0 = 1 cnt = 1 ========================2024-12-31 14:26:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ongdalsem' 0 = ongdalsem Mid = ongdalsem 1 = 주식회사 오씨코퍼레이션 Mcompany = 주식회사 오씨코퍼레이션 2 = 4828602107 companyNum = 4828602107 3 = 02-322-1861 Mtel1 = 02-322-1861 4 = 010-9484-1861 Mhp = 010-9484-1861 ========================2024-12-31 14:26:03======================== select * from customers where id = 'ongdalsem' ========================2024-12-31 14:26:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ongdalsem','2024-12-31 14:26:02','220000','220000','온라인','0') ========================2024-12-31 14:30:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fatec2016-1735622916 LGD_BUYER = 원정묵 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231142836 LGD_HASHDATA = 3184dec4c6b4b88730f36931fd0a78da 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 = 202412311431460150B5E240DD1A38FB948671BE1E67250A41AE8A Mname = 원정묵 Mcompany = 파텍ENG post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = fatec2016 LGD_ESCROW_USEYN = N ========================2024-12-31 14:30:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231143147 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = fatec2016@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 755342 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****794* LGD_FINANCEAUTHNUM = 42419658 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b19ee9fb72447266fc00698390b6c352 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241231143147 LGD_PCANCELSTR = 0 LGD_BUYER = 원정묵 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311431478jXp9 LGD_BUYERID = LGD_OID = Direct-fatec2016-1735622916 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11431478EMu6 ========================2024-12-31 14:30:56======================== insert into mBoard_order set rOrdNo = 'Direct-fatec2016-1735622916', AuthTy = 'card', memberId = 'fatec2016', OrdNm ='원정묵', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '파텍ENG', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41400308****794*', rApprNo = 'mjsof202412311431478jXp9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 14:30:56', InvoiceNum = '결제성공:Direct-fatec2016-1735622916/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 14:30:56' ========================2024-12-31 14:30:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311431478jXp9' 0 = 1 cnt = 1 ========================2024-12-31 14:30:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fatec2016' 0 = fatec2016 Mid = fatec2016 1 = 파텍ENG Mcompany = 파텍ENG 2 = 8721500336 companyNum = 8721500336 3 = 052-263-0511 Mtel1 = 052-263-0511 4 = 010-3875-8083 Mhp = 010-3875-8083 ========================2024-12-31 14:30:56======================== select * from customers where id = 'fatec2016' ========================2024-12-31 14:30:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fatec2016','2024-12-31 14:30:56','108000','110000','온라인','0') ========================2024-12-31 15:01:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-thevise-1735624835 LGD_BUYER = 최대영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231150035 LGD_HASHDATA = b9158978686e9a728a40558c23f07c7e 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 = 2024123115022996BE642386C94AC35F40237057F9FA3AA9D6E189 Mname = 최대영 Mcompany = 더바이스산업공구상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = thevise LGD_ESCROW_USEYN = N ========================2024-12-31 15:01:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231150229 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 = 47386799****399* LGD_FINANCEAUTHNUM = 98452227 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cdcf57d6a8a97aacd260223447177ed3 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20241231150229 LGD_PCANCELSTR = 0 LGD_BUYER = 최대영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311502299ID48 LGD_BUYERID = LGD_OID = Direct-thevise-1735624835 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 15:01:38======================== insert into mBoard_order set rOrdNo = 'Direct-thevise-1735624835', AuthTy = 'card', memberId = 'thevise', OrdNm ='최대영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '더바이스산업공구상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 47386799****399*', rApprNo = 'mjsof202412311502299ID48', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 15:01:38', InvoiceNum = '결제성공:Direct-thevise-1735624835/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 15:01:38' ========================2024-12-31 15:01:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311502299ID48' 0 = 1 cnt = 1 ========================2024-12-31 15:01:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'thevise' 0 = thevise Mid = thevise 1 = 더바이스산업공구상사 Mcompany = 더바이스산업공구상사 2 = 621-21-51072 companyNum = 621-21-51072 3 = 010-3227-0982 Mtel1 = 010-3227-0982 4 = 010-4437-6515 Mhp = 010-4437-6515 ========================2024-12-31 15:01:38======================== select * from customers where id = 'thevise' ========================2024-12-31 15:01:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('thevise','2024-12-31 15:01:38','10000','11000','온라인','0') ========================2024-12-31 15:19:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-akssusbolt-1735625823 LGD_BUYER = 강동기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231151703 LGD_HASHDATA = 37cdd9c2aa33b9d9aa03e891b1b3c004 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 = 202412311520072CC617CFE1F366C1CB8B51C6BCCCB07C0291A22C Mname = 강동기 Mcompany = 주식회사 만년볼트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = akssusbolt LGD_ESCROW_USEYN = N ========================2024-12-31 15:19:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231152007 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 = 94301677****445* LGD_FINANCEAUTHNUM = 61021819 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e659b48c0e3eb0477cf60afd17e9a55c LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241231152008 LGD_PCANCELSTR = 0 LGD_BUYER = 강동기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311520074k9T3 LGD_BUYERID = LGD_OID = Direct-akssusbolt-1735625823 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 15:19:16======================== insert into mBoard_order set rOrdNo = 'Direct-akssusbolt-1735625823', AuthTy = 'card', memberId = 'akssusbolt', OrdNm ='강동기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 만년볼트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301677****445*', rApprNo = 'mjsof202412311520074k9T3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 15:19:16', InvoiceNum = '결제성공:Direct-akssusbolt-1735625823/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 15:19:16' ========================2024-12-31 15:19:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311520074k9T3' 0 = 1 cnt = 1 ========================2024-12-31 15:19:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'akssusbolt' 0 = akssusbolt Mid = akssusbolt 1 = 주식회사 만년볼트 Mcompany = 주식회사 만년볼트 2 = 476-86-02970 companyNum = 476-86-02970 3 = 010-7274-9195 Mtel1 = 010-7274-9195 4 = 010-7274-9195 Mhp = 010-7274-9195 ========================2024-12-31 15:19:17======================== select * from customers where id = 'akssusbolt' ========================2024-12-31 15:19:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('akssusbolt','2024-12-31 15:19:16','220000','220000','온라인','0') ========================2024-12-31 17:27:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1735633611 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231172651 LGD_HASHDATA = c0077cbcd3a7bacf7a5dd422ca918e18 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 = 202412311728320C941D4AA4E1C4D522D766C179EF22FF2E94E5B8 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-12-31 17:27:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231172832 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 = 94300320****092* LGD_FINANCEAUTHNUM = 45095860 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3495d089c8f7554af5e8414cdb8b79a5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241231172833 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311728327nob1 LGD_BUYERID = LGD_OID = Direct-yhk8100-1735633611 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 11728327YbO2 ========================2024-12-31 17:27:42======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1735633611', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300320****092*', rApprNo = 'mjsof202412311728327nob1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 17:27:42', InvoiceNum = '결제성공:Direct-yhk8100-1735633611/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 17:27:42' ========================2024-12-31 17:27:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311728327nob1' 0 = 1 cnt = 1 ========================2024-12-31 17:27:42======================== 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-12-31 17:27:42======================== select * from customers where id = 'yhk8100' ========================2024-12-31 17:27:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2024-12-31 17:27:42','52500','55000','온라인','0') ========================2024-12-31 19:18:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-roastercow-1735640208 LGD_BUYER = 민경언 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231191648 LGD_HASHDATA = 548eeb1560dba099d4f268f5f25ee9bc 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 = 20241231191928E4EC2C913F23699D64CABEFDB5B211E9166FB9CE Mname = 민경언 Mcompany = 매일우유 이태원 대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = roastercow LGD_ESCROW_USEYN = N ========================2024-12-31 19:18:37======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20241231191928 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = mke0927@naver.com 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 = 94168171****112* LGD_FINANCEAUTHNUM = 00505102 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6d737286ae772ee03723616807495c3a LGD_BUYERADDRESS = LGD_FINANCENAME = 하나 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20241231191929 LGD_PCANCELSTR = 0 LGD_BUYER = 민경언 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241231191910aSPl9 LGD_BUYERID = LGD_OID = Direct-roastercow-1735640208 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 19:18:37======================== insert into mBoard_order set rOrdNo = 'Direct-roastercow-1735640208', AuthTy = 'card', memberId = 'roastercow', OrdNm ='민경언', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유 이태원 대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나 94168171****112*', rApprNo = 'mjsof20241231191910aSPl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 19:18:37', InvoiceNum = '결제성공:Direct-roastercow-1735640208/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 19:18:37' ========================2024-12-31 19:18:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241231191910aSPl9' 0 = 1 cnt = 1 ========================2024-12-31 19:18:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'roastercow' 0 = roastercow Mid = roastercow 1 = 매일우유 이태원 대리점 Mcompany = 매일우유 이태원 대리점 2 = 8040201730 companyNum = 8040201730 3 = 010-6234-0927 Mtel1 = 010-6234-0927 4 = 010-6234-0927 Mhp = 010-6234-0927 ========================2024-12-31 19:18:37======================== select * from customers where id = 'roastercow' ========================2024-12-31 19:18:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('roastercow','2024-12-31 19:18:37','220000','220000','온라인','0') ========================2024-12-31 19:37:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksm03172002-1735641363 LGD_BUYER = 김상만 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241231193603 LGD_HASHDATA = 4c136a468200ce13b2ff95e9902098ec 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 = 20241231193809076847C269CDF7D31C9D8AC44C4923CC04616370 Mname = 김상만 Mcompany = 롯데칠성음료수진점(대성음료상사) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = ksm03172002 LGD_ESCROW_USEYN = N ========================2024-12-31 19:37:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241231193810 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 = 37029923****53* LGD_FINANCEAUTHNUM = 00466352 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 850057f1d1fef12e4638b3bdb6d01783 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20241231193810 LGD_PCANCELSTR = 0 LGD_BUYER = 김상만 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202412311938098YLp9 LGD_BUYERID = LGD_OID = Direct-ksm03172002-1735641363 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-31 19:37:18======================== insert into mBoard_order set rOrdNo = 'Direct-ksm03172002-1735641363', AuthTy = 'card', memberId = 'ksm03172002', OrdNm ='김상만', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '롯데칠성음료수진점(대성음료상사)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대AMEX 37029923****53*', rApprNo = 'mjsof202412311938098YLp9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-31 19:37:18', InvoiceNum = '결제성공:Direct-ksm03172002-1735641363/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-31 19:37:18' ========================2024-12-31 19:37:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202412311938098YLp9' 0 = 1 cnt = 1 ========================2024-12-31 19:37:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksm03172002' 0 = ksm03172002 Mid = ksm03172002 1 = 롯데칠성음료수진점(대성음료상사) Mcompany = 롯데칠성음료수진점(대성음료상사) 2 = 1292984340 companyNum = 1292984340 3 = 031-756-7037 Mtel1 = 031-756-7037 4 = 010-2748-0432 Mhp = 010-2748-0432 ========================2024-12-31 19:37:18======================== select * from customers where id = 'ksm03172002' ========================2024-12-31 19:37:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksm03172002','2024-12-31 19:37:18','30900','33000','온라인','0')