========================2024-08-07 07:44:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakeryall-1722984156 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807074236 LGD_HASHDATA = dcd310985eeded65ef6e5c85504e1142 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 = 202408070745543427EA4405EB875195B79E56DA760AC5E6E02A0F Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = bakeryall LGD_ESCROW_USEYN = N ========================2024-08-07 07:44:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807074554 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = samyang3663@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****938* LGD_FINANCEAUTHNUM = 17769886 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 95b169e09347cf93b3b73bdb0b43943b LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240807074555 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807074554jjfw8 LGD_BUYERID = LGD_OID = Direct-bakeryall-1722984156 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 07:44:02======================== insert into mBoard_order set rOrdNo = 'Direct-bakeryall-1722984156', AuthTy = 'card', memberId = 'bakeryall', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20240807074554jjfw8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 07:44:02', InvoiceNum = '결제성공:Direct-bakeryall-1722984156/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 07:44:02' ========================2024-08-07 07:44:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807074554jjfw8' 0 = 1 cnt = 1 ========================2024-08-07 07:44:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakeryall' 0 = bakeryall Mid = bakeryall 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2024-08-07 07:44:03======================== select * from customers where id = 'bakeryall' ========================2024-08-07 07:44:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakeryall','2024-08-07 07:44:02','52500','55000','온라인','0') ========================2024-08-07 09:26:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sun55-1722990271 LGD_BUYER = 류나영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807092431 LGD_HASHDATA = 66d2509786a441838832454a846dbf92 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 = 20240807092850826CB6D6B041E9BFA9D58F4581C67883DD30893B Mname = 류나영 Mcompany = 주식회사다인유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = sun55 LGD_ESCROW_USEYN = N ========================2024-08-07 09:26:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807092851 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 = 42018980****581* LGD_FINANCEAUTHNUM = 03100500 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dff6c6e196b96d3c5221bb44f3c47a30 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240807092851 LGD_PCANCELSTR = 0 LGD_BUYER = 류나영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807092851jumy8 LGD_BUYERID = LGD_OID = Direct-sun55-1722990271 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 09:26:59======================== insert into mBoard_order set rOrdNo = 'Direct-sun55-1722990271', AuthTy = 'card', memberId = 'sun55', OrdNm ='류나영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사다인유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '하나VISA 42018980****581*', rApprNo = 'mjsof20240807092851jumy8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 09:26:59', InvoiceNum = '결제성공:Direct-sun55-1722990271/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 09:26:59' ========================2024-08-07 09:26:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807092851jumy8' 0 = 1 cnt = 1 ========================2024-08-07 09:26:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sun55' 0 = sun55 Mid = sun55 1 = 주식회사다인유통 Mcompany = 주식회사다인유통 2 = 132-86-29477 companyNum = 132-86-29477 3 = 031-511-9764 Mtel1 = 031-511-9764 4 = 010-9204-0230 Mhp = 010-9204-0230 ========================2024-08-07 09:26:59======================== select * from customers where id = 'sun55' ========================2024-08-07 09:26:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sun55','2024-08-07 09:26:59','108000','110000','온라인','0') ========================2024-08-07 09:49:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-volume0305-1722991684 LGD_BUYER = 모민수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807094804 LGD_HASHDATA = a848f079052a2ea1749eeee3e5112fe4 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 = 202408070951080D727DC7B1F400FD613CB4EAE87C68D80D738A3F Mname = 모민수 Mcompany = 충청건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = volume0305 LGD_ESCROW_USEYN = N ========================2024-08-07 09:49:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807095108 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 = 62436303****674* LGD_FINANCEAUTHNUM = 45408895 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 91800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 87eb46c5bf46d30c3c36e3f5de15847a LGD_BUYERADDRESS = LGD_FINANCENAME = 농협CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240807095109 LGD_PCANCELSTR = 0 LGD_BUYER = 모민수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807095108gk8B3 LGD_BUYERID = LGD_OID = Direct-volume0305-1722991684 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 09:49:17======================== insert into mBoard_order set rOrdNo = 'Direct-volume0305-1722991684', AuthTy = 'card', memberId = 'volume0305', OrdNm ='모민수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충청건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '농협CUP 62436303****674*', rApprNo = 'mjsof20240807095108gk8B3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 09:49:17', InvoiceNum = '결제성공:Direct-volume0305-1722991684/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 09:49:17' ========================2024-08-07 09:49:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807095108gk8B3' 0 = 1 cnt = 1 ========================2024-08-07 09:49:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'volume0305' 0 = volume0305 Mid = volume0305 1 = 충청건재 Mcompany = 충청건재 2 = 733-15-01592 companyNum = 733-15-01592 3 = 010-2750-8222 Mtel1 = 010-2750-8222 4 = 010-2750-8222 Mhp = 010-2750-8222 ========================2024-08-07 09:49:17======================== select * from customers where id = 'volume0305' ========================2024-08-07 09:49:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('volume0305','2024-08-07 09:49:17','10000','11000','온라인','0') ========================2024-08-07 10:05:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1722992612 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807100332 LGD_HASHDATA = 0a1aefe930d8044788ccc695ca494a53 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 = 20240807100720D8194950C5D9C21E3826D7525EC6364438841076 Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2024-08-07 10:05:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807100721 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****454* LGD_FINANCEAUTHNUM = 51660573 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 353ecd9bfc9df7f2a11ca91af89485e4 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240807100721 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807100720iula2 LGD_BUYERID = LGD_OID = Direct-ltweenn-1722992612 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7100720iTUG4 ========================2024-08-07 10:05:29======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1722992612', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20240807100720iula2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 10:05:29', InvoiceNum = '결제성공:Direct-ltweenn-1722992612/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 10:05:29' ========================2024-08-07 10:05:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807100720iula2' 0 = 1 cnt = 1 ========================2024-08-07 10:05:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2024-08-07 10:05:29======================== select * from customers where id = 'ltweenn' ========================2024-08-07 10:05:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2024-08-07 10:05:29','220000','220000','온라인','0') ========================2024-08-07 10:51:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-knh601015-1722995321 LGD_BUYER = 김남호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807104841 LGD_HASHDATA = 64ffc7c27f71a5d86378c63f453c64ac 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 = 202408071053420EE25ABEAB720D83B07948E7BDAC105B962ED0A7 Mname = 김남호 Mcompany = 돌핀케미컬 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = knh601015 LGD_ESCROW_USEYN = N ========================2024-08-07 10:51:50======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20240807105342 LGD_DISCOUNTUSEYN = 1 LGD_BUYEREMAIL = nhkim@dolphin.co.kr 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 = 51202899****984* LGD_FINANCEAUTHNUM = 65685147 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 1000 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bd3c0d3e63cf117876be233af63281d6 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20240807105342 LGD_PCANCELSTR = 0 LGD_BUYER = 김남호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807105342T81r1 LGD_BUYERID = LGD_OID = Direct-knh601015-1722995321 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 10:51:50======================== insert into mBoard_order set rOrdNo = 'Direct-knh601015-1722995321', AuthTy = 'card', memberId = 'knh601015', OrdNm ='김남호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '돌핀케미컬', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 51202899****984*', rApprNo = 'mjsof20240807105342T81r1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 10:51:50', InvoiceNum = '결제성공:Direct-knh601015-1722995321/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 10:51:50' ========================2024-08-07 10:51:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807105342T81r1' 0 = 1 cnt = 1 ========================2024-08-07 10:51:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'knh601015' 0 = knh601015 Mid = knh601015 1 = 돌핀케미컬 Mcompany = 돌핀케미컬 2 = 130-08-32319 companyNum = 130-08-32319 3 = 010-3371-4097 Mtel1 = 010-3371-4097 4 = 010-3371-4097 Mhp = 010-3371-4097 ========================2024-08-07 10:51:50======================== select * from customers where id = 'knh601015' ========================2024-08-07 10:51:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('knh601015','2024-08-07 10:51:50','108000','110000','온라인','0') ========================2024-08-07 13:21:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin1-1723004468 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807132108 LGD_HASHDATA = 45a4e813c9ef5cc15e94ef991da7b758 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 = 202408071323474536D15B1A8325AF4A707B0C4FCDC6D3939EBD73 Mname = 김다영 Mcompany = 금진윤활유 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gumjin1 LGD_ESCROW_USEYN = N ========================2024-08-07 13:21:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807132348 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = 21788317 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d6cfc248ea9e48765401bf15b3c86e07 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240807132348 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807132347UsJC0 LGD_BUYERID = LGD_OID = Direct-gumjin1-1723004468 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 13:21:55======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin1-1723004468', AuthTy = 'card', memberId = 'gumjin1', OrdNm ='김다영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금진윤활유', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof20240807132347UsJC0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 13:21:55', InvoiceNum = '결제성공:Direct-gumjin1-1723004468/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 13:21:55' ========================2024-08-07 13:21:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807132347UsJC0' 0 = 1 cnt = 1 ========================2024-08-07 13:21:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin1' 0 = gumjin1 Mid = gumjin1 1 = 금진윤활유 Mcompany = 금진윤활유 2 = 1261585310 companyNum = 1261585310 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2024-08-07 13:21:55======================== select * from customers where id = 'gumjin1' ========================2024-08-07 13:21:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin1','2024-08-07 13:21:55','108000','110000','온라인','0') ========================2024-08-07 14:01:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1723006740 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807135900 LGD_HASHDATA = d9f43eb1876baef2ad9e8aa77e0e740a 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 = 20240807140302E7948DE0E262B8CFABC2908BEECD5BC98045A72D Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2024-08-07 14:01:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807140302 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 = 94301604****416* LGD_FINANCEAUTHNUM = 48401685 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dd507414b03683743d2fe97fba4da09b LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240807140303 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807140302ZtU31 LGD_BUYERID = LGD_OID = Direct-snbfood-1723006740 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 14:01:10======================== insert into mBoard_order set rOrdNo = 'Direct-snbfood-1723006740', AuthTy = 'card', memberId = 'snbfood', OrdNm ='임승순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH 94301604****416*', rApprNo = 'mjsof20240807140302ZtU31', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 14:01:10', InvoiceNum = '결제성공:Direct-snbfood-1723006740/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 14:01:10' ========================2024-08-07 14:01:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807140302ZtU31' 0 = 1 cnt = 1 ========================2024-08-07 14:01:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'snbfood' 0 = snbfood Mid = snbfood 1 = (주)비에스푸드 Mcompany = (주)비에스푸드 2 = 4098701740 companyNum = 4098701740 3 = 042-823-6330 Mtel1 = 042-823-6330 4 = 010-5612-3122 Mhp = 010-5612-3122 ========================2024-08-07 14:01:11======================== select * from customers where id = 'snbfood' ========================2024-08-07 14:01:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('snbfood','2024-08-07 14:01:10','52500','55000','온라인','0') ========================2024-08-07 14:37:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-myungsin2841-1723008989 LGD_BUYER = 한순옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807143629 LGD_HASHDATA = 85327a1ca48f372812aa1eda3648e008 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 = 20240807143923E0B936375FAA8391B865CE110E5026C507AA0ADD Mname = 한순옥 Mcompany = 명신종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = myungsin2841 LGD_ESCROW_USEYN = N ========================2024-08-07 14:37:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807143924 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 = 40921703****526* LGD_FINANCEAUTHNUM = 48802819 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5fb7e949883badc3611ed7f394291156 LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240807143924 LGD_PCANCELSTR = 0 LGD_BUYER = 한순옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807143924WNUZ9 LGD_BUYERID = LGD_OID = Direct-myungsin2841-1723008989 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 14:37:32======================== insert into mBoard_order set rOrdNo = 'Direct-myungsin2841-1723008989', AuthTy = 'card', memberId = 'myungsin2841', OrdNm ='한순옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '명신종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH VISA 40921703****526*', rApprNo = 'mjsof20240807143924WNUZ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 14:37:32', InvoiceNum = '결제성공:Direct-myungsin2841-1723008989/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 14:37:32' ========================2024-08-07 14:37:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807143924WNUZ9' 0 = 1 cnt = 1 ========================2024-08-07 14:37:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'myungsin2841' 0 = myungsin2841 Mid = myungsin2841 1 = 명신종합상사 Mcompany = 명신종합상사 2 = 3122308786 companyNum = 3122308786 3 = 010-5421-8554 Mtel1 = 010-5421-8554 4 = 010-5421-8554 Mhp = 010-5421-8554 ========================2024-08-07 14:37:32======================== select * from customers where id = 'myungsin2841' ========================2024-08-07 14:37:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('myungsin2841','2024-08-07 14:37:32','30900','33000','온라인','0') ========================2024-08-07 14:39:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yth3339-1723009064 LGD_BUYER = 유태환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807143744 LGD_HASHDATA = dbfce758daa817258cd0dc02897499ee 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 = 202408071441079C38C2D4753583EEE373D253DBBD5E549BEC01F9 Mname = 유태환 Mcompany = 주식회사 다복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yth3339 LGD_ESCROW_USEYN = N ========================2024-08-07 14:39:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807144107 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****591* LGD_FINANCEAUTHNUM = 53988912 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f7d22e4a517331646f4ed403db847404 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240807144108 LGD_PCANCELSTR = 0 LGD_BUYER = 유태환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807144107Y5tA4 LGD_BUYERID = LGD_OID = Direct-yth3339-1723009064 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7144107Yqyq8 ========================2024-08-07 14:39:15======================== insert into mBoard_order set rOrdNo = 'Direct-yth3339-1723009064', AuthTy = 'card', memberId = 'yth3339', OrdNm ='유태환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 다복유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****591*', rApprNo = 'mjsof20240807144107Y5tA4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 14:39:15', InvoiceNum = '결제성공:Direct-yth3339-1723009064/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 14:39:15' ========================2024-08-07 14:39:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807144107Y5tA4' 0 = 1 cnt = 1 ========================2024-08-07 14:39:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yth3339' 0 = yth3339 Mid = yth3339 1 = 주식회사 다복유통 Mcompany = 주식회사 다복유통 2 = 5418700763 companyNum = 5418700763 3 = 02-2208-7879 Mtel1 = 02-2208-7879 4 = 010-2679-3339 Mhp = 010-2679-3339 ========================2024-08-07 14:39:15======================== select * from customers where id = 'yth3339' ========================2024-08-07 14:39:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yth3339','2024-08-07 14:39:15','220000','220000','온라인','0') ========================2024-08-07 16:07:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kidsmango22-1723014386 LGD_BUYER = 김형석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807160626 LGD_HASHDATA = 4b88f715d1f15305c4b228c35845d201 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 = 202408071609187151C50DF9EEC97A8B41214B57CCB9DDB3C9FBEF Mname = 김형석 Mcompany = 주식회사 디웨이브 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = kidsmango22 LGD_ESCROW_USEYN = N ========================2024-08-07 16:07:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807160919 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dwave17@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 = 42890993****581* LGD_FINANCEAUTHNUM = 27896704 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 55369bfa0d03f5f82585b5d7c3eab2bd LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20240807160919 LGD_PCANCELSTR = 0 LGD_BUYER = 김형석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807160918TUtG4 LGD_BUYERID = LGD_OID = Direct-kidsmango22-1723014386 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 16:07:26======================== insert into mBoard_order set rOrdNo = 'Direct-kidsmango22-1723014386', AuthTy = 'card', memberId = 'kidsmango22', OrdNm ='김형석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 디웨이브', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '하나VISA 42890993****581*', rApprNo = 'mjsof20240807160918TUtG4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 16:07:26', InvoiceNum = '결제성공:Direct-kidsmango22-1723014386/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 16:07:26' ========================2024-08-07 16:07:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807160918TUtG4' 0 = 1 cnt = 1 ========================2024-08-07 16:07:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kidsmango22' 0 = kidsmango22 Mid = kidsmango22 1 = 주식회사 디웨이브 Mcompany = 주식회사 디웨이브 2 = 8028602484 companyNum = 8028602484 3 = 010-5888-0017 Mtel1 = 010-5888-0017 4 = 010-5888-0017 Mhp = 010-5888-0017 ========================2024-08-07 16:07:26======================== select * from customers where id = 'kidsmango22' ========================2024-08-07 16:07:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kidsmango22','2024-08-07 16:07:26','30900','33000','온라인','0') ========================2024-08-07 21:33:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1723033903 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240807213143 LGD_HASHDATA = 790e16508ed16e401cce9df054603bd6 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 = 202408072135370C8FB18DE5D56B96090FEFC54F4AD0EC434BADAC Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2024-08-07 21:33:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240807213538 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = antwin77@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 = 94091511****271* LGD_FINANCEAUTHNUM = 33398735 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c1084239d1d5d68d253bda493be0bbbb LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20240807213538 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240807213538Tp839 LGD_BUYERID = LGD_OID = Direct-antwin77-1723033903 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-08-07 21:33:45======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1723033903', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****271*', rApprNo = 'mjsof20240807213538Tp839', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-08-07 21:33:45', InvoiceNum = '결제성공:Direct-antwin77-1723033903/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-08-07 21:33:45' ========================2024-08-07 21:33:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240807213538Tp839' 0 = 1 cnt = 1 ========================2024-08-07 21:33:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2024-08-07 21:33:46======================== select * from customers where id = 'antwin77' ========================2024-08-07 21:33:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2024-08-07 21:33:45','52500','55000','온라인','0')