========================2025-01-03 07:32:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1735857072 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103073112 LGD_HASHDATA = 29fd36bf93cd92f3b7596c19745f7dd9 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 = 20250103073256CC35B4B7C3D150E2ACEA8D07BF1B8EEBDA8023EC Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-01-03 07:32:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103073257 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 = 94301703****448* LGD_FINANCEAUTHNUM = 45821629 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3b798a7f29161c95e70c4d219c6cd77f LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250103073257 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250103073257d72O2 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1735857072 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-03 07:32:03======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1735857072', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20250103073257d72O2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 07:32:03', InvoiceNum = '결제성공:Direct-goodssal5707-1735857072/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 07:32:03' ========================2025-01-03 07:32:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103073257d72O2' 0 = 1 cnt = 1 ========================2025-01-03 07:32:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-01-03 07:32:03======================== select * from customers where id = 'goodssal5707' ========================2025-01-03 07:32:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-01-03 07:32:03','220000','220000','온라인','0') ========================2025-01-03 07:33:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1735857130 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103073210 LGD_HASHDATA = d2e23e6507c4780f0cfc69fd1a62e639 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 = 202501030733579B3BF5011EEF02DE8DF149F6EF3D1526BA463F89 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2025-01-03 07:33:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103073357 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 = 94301703****448* LGD_FINANCEAUTHNUM = 45824218 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea8888d9385bfc096c6b8dc099844722 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20250103073358 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501030733575bOj3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1735857130 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-03 07:33:03======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1735857130', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof202501030733575bOj3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 07:33:03', InvoiceNum = '결제성공:Direct-goodssal5707-1735857130/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 07:33:03' ========================2025-01-03 07:33:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501030733575bOj3' 0 = 1 cnt = 1 ========================2025-01-03 07:33:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-01-03 07:33:03======================== select * from customers where id = 'goodssal5707' ========================2025-01-03 07:33:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2025-01-03 07:33:03','108000','110000','온라인','0') ========================2025-01-03 07:35:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodfood2023-1735857242 LGD_BUYER = 최상용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103073402 LGD_HASHDATA = 4520c4608a8e99062d8ae5c73d32adff 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 = 20250103073555C7CA09FE92AAE54E2113D24CB76A33283FBC804B Mname = 최상용 Mcompany = 좋은푸드컬리주식회사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = goodfood2023 LGD_ESCROW_USEYN = N ========================2025-01-03 07:35:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103073556 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****697* LGD_FINANCEAUTHNUM = 61669775 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a8f3a49392fc78d99d0229eb923973ed LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103073556 LGD_PCANCELSTR = 0 LGD_BUYER = 최상용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250103073555h0sm8 LGD_BUYERID = LGD_OID = Direct-goodfood2023-1735857242 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3073555hA0i2 ========================2025-01-03 07:35:02======================== insert into mBoard_order set rOrdNo = 'Direct-goodfood2023-1735857242', AuthTy = 'card', memberId = 'goodfood2023', OrdNm ='최상용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '좋은푸드컬리주식회사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****697*', rApprNo = 'mjsof20250103073555h0sm8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 07:35:02', InvoiceNum = '결제성공:Direct-goodfood2023-1735857242/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 07:35:02' ========================2025-01-03 07:35:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103073555h0sm8' 0 = 1 cnt = 1 ========================2025-01-03 07:35:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodfood2023' 0 = goodfood2023 Mid = goodfood2023 1 = 좋은푸드컬리주식회사 Mcompany = 좋은푸드컬리주식회사 2 = 112-86-02741 companyNum = 112-86-02741 3 = 010-8880-9146 Mtel1 = 010-8880-9146 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2025-01-03 07:35:02======================== select * from customers where id = 'goodfood2023' ========================2025-01-03 07:35:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodfood2023','2025-01-03 07:35:02','52500','55000','온라인','0') ========================2025-01-03 09:32:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gnh815-1735864238 LGD_BUYER = 가낙현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103093038 LGD_HASHDATA = 8f76798fa48c2f460ba5a26fd0c8a0e0 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 = 20250103093258526132705D3020F02FAC7C70E80CAFFC87025A5E Mname = 가낙현 Mcompany = 어업회사법인 주식회사 영광수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = gnh815 LGD_ESCROW_USEYN = N ========================2025-01-03 09:32:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103093259 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 036993 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40520308****290* LGD_FINANCEAUTHNUM = 62210286 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2eba549f31ab90e63eea8b0e79ec73cb LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103093259 LGD_PCANCELSTR = 0 LGD_BUYER = 가낙현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250103093259hcok6 LGD_BUYERID = LGD_OID = Direct-gnh815-1735864238 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3093259hDsO2 ========================2025-01-03 09:32:05======================== insert into mBoard_order set rOrdNo = 'Direct-gnh815-1735864238', AuthTy = 'card', memberId = 'gnh815', OrdNm ='가낙현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '어업회사법인 주식회사 영광수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 40520308****290*', rApprNo = 'mjsof20250103093259hcok6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 09:32:05', InvoiceNum = '결제성공:Direct-gnh815-1735864238/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 09:32:05' ========================2025-01-03 09:32:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103093259hcok6' 0 = 1 cnt = 1 ========================2025-01-03 09:32:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gnh815' 0 = gnh815 Mid = gnh815 1 = 어업회사법인 주식회사 영광수산 Mcompany = 어업회사법인 주식회사 영광수산 2 = 6668600503 companyNum = 6668600503 3 = 02-442-5993 Mtel1 = 02-442-5993 4 = 010-4113-8966 Mhp = 010-4113-8966 ========================2025-01-03 09:32:05======================== select * from customers where id = 'gnh815' ========================2025-01-03 09:32:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gnh815','2025-01-03 09:32:05','220000','220000','온라인','0') ========================2025-01-03 11:04:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1735869757 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103110237 LGD_HASHDATA = 7bbe28f68c7306c85334823a6ef8236d 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 = 202501031104594752F207B27FF6BE13FE8922ED24045ADF88A8DC Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2025-01-03 11:04:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103110500 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 = 52758500****555* LGD_FINANCEAUTHNUM = 82860361 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = W1200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ad3b6747de7215c234fd2b0e6a60c19e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = W1 LGD_DEVICE = LGD_TIMESTAMP = 20250103110500 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250103110500hrZo4 LGD_BUYERID = LGD_OID = Direct-pao7894-1735869757 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-03 11:04:06======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1735869757', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리MASTER 52758500****555*', rApprNo = 'mjsof20250103110500hrZo4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 11:04:06', InvoiceNum = '결제성공:Direct-pao7894-1735869757/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 11:04:06' ========================2025-01-03 11:04:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103110500hrZo4' 0 = 1 cnt = 1 ========================2025-01-03 11:04:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pao7894' 0 = pao7894 Mid = pao7894 1 = (주)토탈엘앤씨 Mcompany = (주)토탈엘앤씨 2 = 134-86-34108 companyNum = 134-86-34108 3 = 031-366-9051 Mtel1 = 031-366-9051 4 = 010-3022-2227 Mhp = 010-3022-2227 ========================2025-01-03 11:04:06======================== select * from customers where id = 'pao7894' ========================2025-01-03 11:04:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2025-01-03 11:04:06','220000','220000','온라인','0') ========================2025-01-03 12:47:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phocos-1735876002 LGD_BUYER = (주)포코스 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103124642 LGD_HASHDATA = 08588a63a432d0032ecc9938a170c7cd 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 = 20250103124816EE73569A321463C63A3A4F76474FE0BE62BE575A Mname = (주)포코스 Mcompany = (주)포코스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = phocos LGD_ESCROW_USEYN = N ========================2025-01-03 12:47:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103124817 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 55852699****389* LGD_FINANCEAUTHNUM = 30105954 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6616e433934fb6ffca68b4ee4c6afe4b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20250103124817 LGD_PCANCELSTR = 0 LGD_BUYER = (주)포코스 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501031248179Ktl3 LGD_BUYERID = LGD_OID = Direct-phocos-1735876002 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31248179wkU4 ========================2025-01-03 12:47:22======================== insert into mBoard_order set rOrdNo = 'Direct-phocos-1735876002', AuthTy = 'card', memberId = 'phocos', OrdNm ='(주)포코스', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)포코스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852699****389*', rApprNo = 'mjsof202501031248179Ktl3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 12:47:22', InvoiceNum = '결제성공:Direct-phocos-1735876002/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 12:47:22' ========================2025-01-03 12:47:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501031248179Ktl3' 0 = 1 cnt = 1 ========================2025-01-03 12:47:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phocos' 0 = phocos Mid = phocos 1 = (주)포코스 Mcompany = (주)포코스 2 = 140-81-22446 companyNum = 140-81-22446 3 = 031-487-1830 Mtel1 = 031-487-1830 4 = 010-6361-4527 Mhp = 010-6361-4527 ========================2025-01-03 12:47:23======================== select * from customers where id = 'phocos' ========================2025-01-03 12:47:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phocos','2025-01-03 12:47:22','52500','55000','온라인','0') ========================2025-01-03 14:03:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yujung6852-1735880562 LGD_BUYER = 윤경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103140242 LGD_HASHDATA = acb07f9a7a3d61384d2f3ebc9eb0860e 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 = 20250103140432D7BF1106F8E1C5E2DF9B00AC976497E88E440568 Mname = 윤경환 Mcompany = (주)유정배관 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yujung6852 LGD_ESCROW_USEYN = N ========================2025-01-03 14:03:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103140433 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 396727 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91003900****658* LGD_FINANCEAUTHNUM = 64192051 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bc851613bda7f8e636edcaba3eee86bf LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103140433 LGD_PCANCELSTR = 0 LGD_BUYER = 윤경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501031404338zYF1 LGD_BUYERID = LGD_OID = Direct-yujung6852-1735880562 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 31404338Sbh5 ========================2025-01-03 14:03:39======================== insert into mBoard_order set rOrdNo = 'Direct-yujung6852-1735880562', AuthTy = 'card', memberId = 'yujung6852', OrdNm ='윤경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)유정배관', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91003900****658*', rApprNo = 'mjsof202501031404338zYF1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 14:03:39', InvoiceNum = '결제성공:Direct-yujung6852-1735880562/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 14:03:39' ========================2025-01-03 14:03:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501031404338zYF1' 0 = 1 cnt = 1 ========================2025-01-03 14:03:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yujung6852' 0 = yujung6852 Mid = yujung6852 1 = (주)유정배관 Mcompany = (주)유정배관 2 = 2768700699 companyNum = 2768700699 3 = 055-325-2105 Mtel1 = 055-325-2105 4 = 010-3658-6852 Mhp = 010-3658-6852 ========================2025-01-03 14:03:39======================== select * from customers where id = 'yujung6852' ========================2025-01-03 14:03:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yujung6852','2025-01-03 14:03:39','220000','220000','온라인','0') ========================2025-01-03 14:59:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin3-1735883905 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103145825 LGD_HASHDATA = d0342c065ac427c20c94f8f4663b4fe9 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 = 202501031500157A0546FA25A490A86C7FE43FEAE7DBC965F4F2AB Mname = 김다영 Mcompany = 세영종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gumjin3 LGD_ESCROW_USEYN = N ========================2025-01-03 14:59:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103150015 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 = 40060407 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b1eb4af326933569e5608eae8b42c6ed LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20250103150015 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20250103150015h0yL5 LGD_BUYERID = LGD_OID = Direct-gumjin3-1735883905 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2025-01-03 14:59:21======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin3-1735883905', AuthTy = 'card', memberId = 'gumjin3', OrdNm ='김다영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '세영종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof20250103150015h0yL5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 14:59:21', InvoiceNum = '결제성공:Direct-gumjin3-1735883905/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 14:59:21' ========================2025-01-03 14:59:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103150015h0yL5' 0 = 1 cnt = 1 ========================2025-01-03 14:59:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin3' 0 = gumjin3 Mid = gumjin3 1 = 세영종합상사 Mcompany = 세영종합상사 2 = 1262974765 companyNum = 1262974765 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2025-01-03 14:59:21======================== select * from customers where id = 'gumjin3' ========================2025-01-03 14:59:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin3','2025-01-03 14:59:21','108000','110000','온라인','0') ========================2025-01-03 15:09:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1735884534 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103150854 LGD_HASHDATA = 8c04bdd9131477c8dd39d53bc1477d95 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 = 2025010315103919D916392250E7F4736F8037BAB7B40A2B48336D Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = support@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2025-01-03 15:09:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103151040 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 64772359 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6272d59944ce1233494cd239aa7d2de7 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103151040 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202501031510404Epa0 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1735884534 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 315104043iJ3 ========================2025-01-03 15:09:46======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1735884534', 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 = 'mjsof202501031510404Epa0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 15:09:46', InvoiceNum = '결제성공:Direct-mmthcoffee-1735884534/0000', Deliver = '', senditem = 'support@mmth.co.kr', salestopvalue = '', mod_date = '2025-01-03 15:09:46' ========================2025-01-03 15:09:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202501031510404Epa0' 0 = 1 cnt = 1 ========================2025-01-03 15:09:46======================== 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 ========================2025-01-03 15:09:46======================== select * from customers where id = 'mmthcoffee' ========================2025-01-03 15:09:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2025-01-03 15:09:46','220000','220000','온라인','0') ========================2025-01-03 15:10:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1735884596 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103150956 LGD_HASHDATA = a7c39eae49cd99f604de7a737391ae6a 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 = 2025010315111464584282203914DD839DE2C026B50062F5E72585 Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = support@mmth.co.kr UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2025-01-03 15:10:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103151115 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = support@mmth.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300309****993* LGD_FINANCEAUTHNUM = 64774208 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = db7c4333db2a078299f8eb1e7124bb11 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103151116 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof20250103151115d90C4 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1735884596 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 3151115dvCQ2 ========================2025-01-03 15:10:21======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1735884596', 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 = 'mjsof20250103151115d90C4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 15:10:21', InvoiceNum = '결제성공:Direct-mmthcoffee-1735884596/0000', Deliver = '', senditem = 'support@mmth.co.kr', salestopvalue = '', mod_date = '2025-01-03 15:10:21' ========================2025-01-03 15:10:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20250103151115d90C4' 0 = 1 cnt = 1 ========================2025-01-03 15:10:21======================== 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 ========================2025-01-03 15:10:21======================== select * from customers where id = 'mmthcoffee' ========================2025-01-03 15:10:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2025-01-03 15:10:21','220000','220000','온라인','0') ========================2025-01-03 22:11:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-alldayfood-1735909851 LGD_BUYER = 박강철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20250103221051 LGD_HASHDATA = ae0fae1b575a8225f05c5be42145d1a7 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 = 20250103221242CBDC953C27C371CF60FDAA63C14BC12BAC5D551F Mname = 박강철 Mcompany = 올데이푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = alldayfood LGD_ESCROW_USEYN = N ========================2025-01-03 22:11:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20250103221244 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756448 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****030* LGD_FINANCEAUTHNUM = 67428627 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 35e39cc3c144f5abede1e72d8058d59f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20250103221244 LGD_PCANCELSTR = 0 LGD_BUYER = 박강철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2025010322124366rl9 LGD_BUYERID = LGD_OID = Direct-alldayfood-1735909851 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 32212436wnz9 ========================2025-01-03 22:11:49======================== insert into mBoard_order set rOrdNo = 'Direct-alldayfood-1735909851', AuthTy = 'card', memberId = 'alldayfood', OrdNm ='박강철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '올데이푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****030*', rApprNo = 'mjsof2025010322124366rl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2025-01-03 22:11:49', InvoiceNum = '결제성공:Direct-alldayfood-1735909851/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2025-01-03 22:11:49' ========================2025-01-03 22:11:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2025010322124366rl9' 0 = 1 cnt = 1 ========================2025-01-03 22:11:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'alldayfood' 0 = alldayfood Mid = alldayfood 1 = 올데이푸드 Mcompany = 올데이푸드 2 = 4310201357 companyNum = 4310201357 3 = 010-3414-0228 Mtel1 = 010-3414-0228 4 = 010-7422-3317 Mhp = 010-7422-3317 ========================2025-01-03 22:11:49======================== select * from customers where id = 'alldayfood' ========================2025-01-03 22:11:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('alldayfood','2025-01-03 22:11:49','220000','220000','온라인','0')