========================2023-10-05 08:03:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woomin-1696460576 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005080256 LGD_HASHDATA = d6543aec5d5f6a820f65fff59ba8ee0b 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 = 202310050806015B5F705B95424938BAA9A252B2A06F8469DA3349 Mname = 김성용 Mcompany = 우민전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woomin LGD_ESCROW_USEYN = N ========================2023-10-05 08:03:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005080602 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739025 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****126* LGD_FINANCEAUTHNUM = 45098423 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b5c518a28a68eb365bc633d1d73d16e3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005080603 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005080602HG2y6 LGD_BUYERID = LGD_OID = Direct-woomin-1696460576 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5080602HpJH3 ========================2023-10-05 08:03:43======================== insert into mBoard_order set rOrdNo = 'Direct-woomin-1696460576', AuthTy = 'card', memberId = 'woomin', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****126*', rApprNo = 'mjsof20231005080602HG2y6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 08:03:43', InvoiceNum = '결제성공:Direct-woomin-1696460576/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 08:03:43' ========================2023-10-05 08:03:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005080602HG2y6' 0 = 1 cnt = 1 ========================2023-10-05 08:03:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woomin' 0 = woomin Mid = woomin 1 = 우민전기 Mcompany = 우민전기 2 = 6032966520 companyNum = 6032966520 3 = 051-262-6806 Mtel1 = 051-262-6806 4 = 011-262-6801 Mhp = 011-262-6801 ========================2023-10-05 08:03:43======================== select * from customers where id = 'woomin' ========================2023-10-05 08:03:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woomin','2023-10-05 08:03:43','220000','220000','온라인','0') ========================2023-10-05 10:29:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-poweroioi-1696469297 LGD_BUYER = 김원석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005102817 LGD_HASHDATA = 812030c23f9b993d6d09f406d8f655b0 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 = 20231005103122BFE7BFAD5B320ECEB08C34565421FCDF699FE30C Mname = 김원석 Mcompany = (주)다사랑아이엔씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = poweroioi LGD_ESCROW_USEYN = N ========================2023-10-05 10:29:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005103122 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658613****204* LGD_FINANCEAUTHNUM = 30025373 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bbe26d855532754881ccf86c7f001a13 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231005103123 LGD_PCANCELSTR = 0 LGD_BUYER = 김원석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005103122Ue9w6 LGD_BUYERID = LGD_OID = Direct-poweroioi-1696469297 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-05 10:29:03======================== insert into mBoard_order set rOrdNo = 'Direct-poweroioi-1696469297', AuthTy = 'card', memberId = 'poweroioi', OrdNm ='김원석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다사랑아이엔씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 42658613****204*', rApprNo = 'mjsof20231005103122Ue9w6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 10:29:03', InvoiceNum = '결제성공:Direct-poweroioi-1696469297/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 10:29:03' ========================2023-10-05 10:29:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005103122Ue9w6' 0 = 1 cnt = 1 ========================2023-10-05 10:29:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'poweroioi' 0 = poweroioi Mid = poweroioi 1 = (주)다사랑아이엔씨 Mcompany = (주)다사랑아이엔씨 2 = 1388603820 companyNum = 1388603820 3 = 010-3017-3597 Mtel1 = 010-3017-3597 4 = 010-3017-3597 Mhp = 010-3017-3597 ========================2023-10-05 10:29:03======================== select * from customers where id = 'poweroioi' ========================2023-10-05 10:29:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('poweroioi','2023-10-05 10:29:03','52500','55000','온라인','0') ========================2023-10-05 10:42:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sltfood-1696470031 LGD_BUYER = 최성수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005104031 LGD_HASHDATA = 3f3aaf86622f83b553819c3ead202e7f 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 = 202310051044289EFC3A7B4B020C0881826A3200E824921B24C6DF Mname = 최성수 Mcompany = (주)셀랙푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = sltfood LGD_ESCROW_USEYN = N ========================2023-10-05 10:42:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005104429 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****589* LGD_FINANCEAUTHNUM = 30125445 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c62532226e787a6797a463d7c62ae035 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231005104429 LGD_PCANCELSTR = 0 LGD_BUYER = 최성수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005104428Ke8K8 LGD_BUYERID = LGD_OID = Direct-sltfood-1696470031 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5104428KhTR1 ========================2023-10-05 10:42:09======================== insert into mBoard_order set rOrdNo = 'Direct-sltfood-1696470031', AuthTy = 'card', memberId = 'sltfood', OrdNm ='최성수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)셀랙푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****589*', rApprNo = 'mjsof20231005104428Ke8K8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 10:42:09', InvoiceNum = '결제성공:Direct-sltfood-1696470031/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 10:42:09' ========================2023-10-05 10:42:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005104428Ke8K8' 0 = 1 cnt = 1 ========================2023-10-05 10:42:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sltfood' 0 = sltfood Mid = sltfood 1 = (주)셀랙푸드 Mcompany = (주)셀랙푸드 2 = 4018800346 companyNum = 4018800346 3 = 070-8878-8572 Mtel1 = 070-8878-8572 4 = 010-9054-8572 Mhp = 010-9054-8572 ========================2023-10-05 10:42:09======================== select * from customers where id = 'sltfood' ========================2023-10-05 10:42:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sltfood','2023-10-05 10:42:09','220000','220000','온라인','0') ========================2023-10-05 11:19:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kumhocnp-1696472353 LGD_BUYER = 오충우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005111913 LGD_HASHDATA = e3e7cd84518df60f6d4dfe51876c79d9 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 = 202310051122181EFD714416AB68BFC7BFB99A0B099541A8C213C3 Mname = 오충우 Mcompany = 주식회사금호씨엔피 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kumhocnp LGD_ESCROW_USEYN = N ========================2023-10-05 11:19:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005112219 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****699* LGD_FINANCEAUTHNUM = 46485282 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8923f5b818ae9512ad0ccbb631950058 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005112219 LGD_PCANCELSTR = 0 LGD_BUYER = 오충우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005112218SEBO4 LGD_BUYERID = LGD_OID = Direct-kumhocnp-1696472353 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5112218SoXK0 ========================2023-10-05 11:19:59======================== insert into mBoard_order set rOrdNo = 'Direct-kumhocnp-1696472353', AuthTy = 'card', memberId = 'kumhocnp', OrdNm ='오충우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사금호씨엔피', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400308****699*', rApprNo = 'mjsof20231005112218SEBO4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 11:19:59', InvoiceNum = '결제성공:Direct-kumhocnp-1696472353/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 11:19:59' ========================2023-10-05 11:19:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005112218SEBO4' 0 = 1 cnt = 1 ========================2023-10-05 11:19:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kumhocnp' 0 = kumhocnp Mid = kumhocnp 1 = 주식회사금호씨엔피 Mcompany = 주식회사금호씨엔피 2 = 138-81-94592 companyNum = 138-81-94592 3 = 031-347-8161 Mtel1 = 031-347-8161 4 = 010-4232-8162 Mhp = 010-4232-8162 ========================2023-10-05 11:19:59======================== select * from customers where id = 'kumhocnp' ========================2023-10-05 11:19:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kumhocnp','2023-10-05 11:19:59','52500','55000','온라인','0') ========================2023-10-05 11:41:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-meetinggod1-1696473628 LGD_BUYER = 김희승 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005114028 LGD_HASHDATA = 15402c77510ae542d9a29e3cc983809d 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 = 2023100511434089291D2DE2E18D5D6F4D4F827D54F9EACF6AE5D0 Mname = 김희승 Mcompany = (주)세미나인터내셔널 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = meetinggod1 LGD_ESCROW_USEYN = N ========================2023-10-05 11:41:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005114341 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****282* LGD_FINANCEAUTHNUM = 30015925 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f95d05f587b9d4f060277aaaea8326c5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231005114341 LGD_PCANCELSTR = 0 LGD_BUYER = 김희승 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005114340PRyV7 LGD_BUYERID = LGD_OID = Direct-meetinggod1-1696473628 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5114340P1Zf1 ========================2023-10-05 11:41:21======================== insert into mBoard_order set rOrdNo = 'Direct-meetinggod1-1696473628', AuthTy = 'card', memberId = 'meetinggod1', OrdNm ='김희승', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세미나인터내셔널', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****282*', rApprNo = 'mjsof20231005114340PRyV7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 11:41:21', InvoiceNum = '결제성공:Direct-meetinggod1-1696473628/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 11:41:21' ========================2023-10-05 11:41:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005114340PRyV7' 0 = 1 cnt = 1 ========================2023-10-05 11:41:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'meetinggod1' 0 = meetinggod1 Mid = meetinggod1 1 = (주)세미나인터내셔널 Mcompany = (주)세미나인터내셔널 2 = 5038700626 companyNum = 5038700626 3 = 032-674-4968 Mtel1 = 032-674-4968 4 = 010-7359-4968 Mhp = 010-7359-4968 ========================2023-10-05 11:41:21======================== select * from customers where id = 'meetinggod1' ========================2023-10-05 11:41:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('meetinggod1','2023-10-05 11:41:21','220000','220000','온라인','0') ========================2023-10-05 11:58:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-narooye11-1696474461 LGD_BUYER = 임민재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005115421 LGD_HASHDATA = 5ca2199f2b58a871999b909aed04a398 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 = 20231005120044FE8567272817B112A829A2A475EA0B12C56EE070 Mname = 임민재 Mcompany = 엠제이피싱(가까운낚시) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = narooye11 LGD_ESCROW_USEYN = N ========================2023-10-05 11:58:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005120044 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94111703****665* LGD_FINANCEAUTHNUM = 45973926 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 059379588c5a91972ffe41e87f9ca2cf LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231005120045 LGD_PCANCELSTR = 0 LGD_BUYER = 임민재 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005120044SKQl9 LGD_BUYERID = LGD_OID = Direct-narooye11-1696474461 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-05 11:58:25======================== insert into mBoard_order set rOrdNo = 'Direct-narooye11-1696474461', AuthTy = 'card', memberId = 'narooye11', OrdNm ='임민재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엠제이피싱(가까운낚시)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = 'NH 94111703****665*', rApprNo = 'mjsof20231005120044SKQl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 11:58:25', InvoiceNum = '결제성공:Direct-narooye11-1696474461/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 11:58:25' ========================2023-10-05 11:58:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005120044SKQl9' 0 = 1 cnt = 1 ========================2023-10-05 11:58:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'narooye11' 0 = narooye11 Mid = narooye11 1 = 가까운낚시 Mcompany = 가까운낚시 2 = 1314400031 companyNum = 1314400031 3 = 031-666-2733 Mtel1 = 031-666-2733 4 = 010-2009-2845 Mhp = 010-2009-2845 ========================2023-10-05 11:58:25======================== select * from customers where id = 'narooye11' ========================2023-10-05 11:58:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('narooye11','2023-10-05 11:58:25','52500','55000','온라인','0') ========================2023-10-05 14:21:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bosungsf8727-1696483210 LGD_BUYER = 김태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005142010 LGD_HASHDATA = 162e76a164fb79e64073fd98009f3a54 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 = 2023100514240066D603F442514E91F8D4E86D4C4D3E5AFB4E751D Mname = 김태화 Mcompany = (주)보성씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bosungsf8727 LGD_ESCROW_USEYN = N ========================2023-10-05 14:21:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005142400 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41710306****196* LGD_FINANCEAUTHNUM = 47889741 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 317078ffabcde3305240785d58bf2d36 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005142401 LGD_PCANCELSTR = 0 LGD_BUYER = 김태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005142400Minq4 LGD_BUYERID = LGD_OID = Direct-bosungsf8727-1696483210 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5142400Mr9J1 ========================2023-10-05 14:21:41======================== insert into mBoard_order set rOrdNo = 'Direct-bosungsf8727-1696483210', AuthTy = 'card', memberId = 'bosungsf8727', OrdNm ='김태화 ', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)보성씨푸드 ', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41710306****196*', rApprNo = 'mjsof20231005142400Minq4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 14:21:41', InvoiceNum = '결제성공:Direct-bosungsf8727-1696483210/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 14:21:41' ========================2023-10-05 14:21:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005142400Minq4' 0 = 1 cnt = 1 ========================2023-10-05 14:21:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bosungsf8727' 0 = bosungsf8727 Mid = bosungsf8727 1 = (주)보성씨푸드 Mcompany = (주)보성씨푸드 2 = 1088126792 companyNum = 1088126792 3 = 031-481-8727 Mtel1 = 031-481-8727 4 = 010-8638-0714 Mhp = 010-8638-0714 ========================2023-10-05 14:21:41======================== select * from customers where id = 'bosungsf8727' ========================2023-10-05 14:21:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bosungsf8727','2023-10-05 14:21:41','108000','110000','온라인','0') ========================2023-10-05 14:28:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1696483531 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005142531 LGD_HASHDATA = f8db67ee13c52afb188d297980c4ac3a 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 = 20231005143115B66450B189C6D7736952E80F2CCA54785A3CF3E5 Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2023-10-05 14:28:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005143115 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401176****720* LGD_FINANCEAUTHNUM = 47934428 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9c0be6db4abe847f3bb77122e15bd751 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005143116 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005143115Lvma8 LGD_BUYERID = LGD_OID = Direct-woorimart-1696483531 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5143115LGVH5 ========================2023-10-05 14:28:56======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1696483531', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41401176****720*', rApprNo = 'mjsof20231005143115Lvma8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 14:28:56', InvoiceNum = '결제성공:Direct-woorimart-1696483531/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 14:28:56' ========================2023-10-05 14:28:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005143115Lvma8' 0 = 1 cnt = 1 ========================2023-10-05 14:28:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2023-10-05 14:28:56======================== select * from customers where id = 'woorimart' ========================2023-10-05 14:28:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2023-10-05 14:28:56','220000','220000','온라인','0') ========================2023-10-05 14:34:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1696484021 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005143341 LGD_HASHDATA = b85c06f874d579382269b98b40dd1473 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 = 20231005143652DA820F111C9A7C65BBF495D01A72DD30EA13F890 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 ========================2023-10-05 14:34:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005143653 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = tax@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 47980572 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4811056f2ba1dc41d3a1b9f30ed01d51 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005143653 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005143652PfcZ5 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1696484021 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5143652PaT66 ========================2023-10-05 14:34:33======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1696484021', 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 = 'mjsof20231005143652PfcZ5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 14:34:33', InvoiceNum = '결제성공:Direct-mmthcoffee-1696484021/0000', Deliver = '', senditem = 'tax@mmth.co.kr', salestopvalue = '', mod_date = '2023-10-05 14:34:33' ========================2023-10-05 14:34:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005143652PfcZ5' 0 = 1 cnt = 1 ========================2023-10-05 14:34:33======================== 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 ========================2023-10-05 14:34:33======================== select * from customers where id = 'mmthcoffee' ========================2023-10-05 14:34:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2023-10-05 14:34:33','220000','220000','온라인','0') ========================2023-10-05 16:19:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1696490099 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005161459 LGD_HASHDATA = f1104a7080c9203aaa6c76c2c29bd0fc 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 = 202310051621327BF582699770E5CFDEEF62AF027C8F33D17F0F45 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 ========================2023-10-05 16:19:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005162134 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****445* LGD_FINANCEAUTHNUM = 48855449 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 955ced2f3410d4c988354704e34bc781 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005162135 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20231005162134gD6G0 LGD_BUYERID = LGD_OID = Direct-ltweenn-1696490099 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 051621627940 ========================2023-10-05 16:19:15======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1696490099', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****445*', rApprNo = 'mjsof20231005162134gD6G0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 16:19:15', InvoiceNum = '결제성공:Direct-ltweenn-1696490099/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 16:19:15' ========================2023-10-05 16:19:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005162134gD6G0' 0 = 1 cnt = 1 ========================2023-10-05 16:19:15======================== 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 ========================2023-10-05 16:19:15======================== select * from customers where id = 'ltweenn' ========================2023-10-05 16:19:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2023-10-05 16:19:15','220000','220000','온라인','0') ========================2023-10-05 18:45:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1696499060 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231005184420 LGD_HASHDATA = 88b687f66fff4e9efeffdf6baefe4237 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 = 20231005184757B218BD9B6EA90B28BC687202185AA88E0F5AE1BB 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 ========================2023-10-05 18:45:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231005184758 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300306****392* LGD_FINANCEAUTHNUM = 49980581 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 34857a3612f74b22d57b2badc58adad7 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231005184758 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231005184758idm95 LGD_BUYERID = LGD_OID = Direct-yhk8100-1696499060 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5184758iHGf1 ========================2023-10-05 18:45:38======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1696499060', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300306****392*', rApprNo = 'mjsof20231005184758idm95', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-05 18:45:38', InvoiceNum = '결제성공:Direct-yhk8100-1696499060/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-05 18:45:38' ========================2023-10-05 18:45:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231005184758idm95' 0 = 1 cnt = 1 ========================2023-10-05 18:45:38======================== 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 = 011-9834-3324 Mhp = 011-9834-3324 ========================2023-10-05 18:45:38======================== select * from customers where id = 'yhk8100' ========================2023-10-05 18:45:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2023-10-05 18:45:38','52500','55000','온라인','0')