========================2023-10-09 00:00:30======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k10s20-1696777004 LGD_BUYER = 김광식 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231008235644 LGD_HASHDATA = c93570c69bce5255b89a38e7caf69648 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 = 20231009000254B1C99ED82CC2A03F9F62928D93B72DA45FAF842F Mname = 김광식 Mcompany = 삼육식품동작대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = k10s20 LGD_ESCROW_USEYN = N ========================2023-10-09 00:00:30======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231009000254 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 = 94901925****448* LGD_FINANCEAUTHNUM = 00962112 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d85b171d5a17fb9b206fa8587479d357 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20231009000254 LGD_PCANCELSTR = 0 LGD_BUYER = 김광식 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231009000254OYv24 LGD_BUYERID = LGD_OID = Direct-k10s20-1696777004 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-09 00:00:30======================== insert into mBoard_order set rOrdNo = 'Direct-k10s20-1696777004', AuthTy = 'card', memberId = 'k10s20', OrdNm ='김광식', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼육식품동작대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대 94901925****448*', rApprNo = 'mjsof20231009000254OYv24', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-09 00:00:30', InvoiceNum = '결제성공:Direct-k10s20-1696777004/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-09 00:00:30' ========================2023-10-09 00:00:30======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231009000254OYv24' 0 = 1 cnt = 1 ========================2023-10-09 00:00:30======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k10s20' 0 = k10s20 Mid = k10s20 1 = 삼육식품동작대리점 Mcompany = 삼육식품동작대리점 2 = 1180674654 companyNum = 1180674654 3 = 02-822-8515 Mtel1 = 02-822-8515 4 = 010-9349-3626 Mhp = 010-9349-3626 ========================2023-10-09 00:00:30======================== select * from customers where id = 'k10s20' ========================2023-10-09 00:00:30======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k10s20','2023-10-09 00:00:30','30900','33000','온라인','0') ========================2023-10-09 16:07:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1696835185 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231009160625 LGD_HASHDATA = b8d8cc53e6aecf84124fd03d267f0f0c 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 = 202310091610015EB21229E642EAEFC9D904B3D7EC8939DFED8C68 Mname = 김창민 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2023-10-09 16:07:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231009161002 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 = 51379100****927* LGD_FINANCEAUTHNUM = 37127459 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5f7818f4fe07324004465ebcda6aa647 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20231009161002 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231009161002PW0S6 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1696835185 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-09 16:07:37======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1696835185', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '롯데MASTER 51379100****927*', rApprNo = 'mjsof20231009161002PW0S6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-09 16:07:37', InvoiceNum = '결제성공:Direct-nosqr9583-1696835185/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-09 16:07:37' ========================2023-10-09 16:07:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231009161002PW0S6' 0 = 1 cnt = 1 ========================2023-10-09 16:07:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 055-363-9583 Mtel1 = 055-363-9583 4 = 010-4591-3793 Mhp = 010-4591-3793 ========================2023-10-09 16:07:38======================== select * from customers where id = 'nosqr9583' ========================2023-10-09 16:07:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2023-10-09 16:07:37','108000','110000','온라인','0') ========================2023-10-09 17:41:14======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejongmaster-1696840727 LGD_BUYER = 김민준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231009173847 LGD_HASHDATA = 62d941e577903db8201e635d57077476 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 = 202310091743398D13E6BC5F57D2F5EF9F38E5D6558F2B161CEE0A Mname = 김민준 Mcompany = 그래인팜 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sejongmaster LGD_ESCROW_USEYN = N ========================2023-10-09 17:41:16======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20231009174341 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 3ETS0E LGD_AFFILIATECODE = ****** LGD_RESPMSG = A8:고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(한도초과 또는 잔액부족) LGD_2TR_FLAG = Y LGD_CARDNUM = 40329029****002* LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 559a8fe3ae1ba6b9029779ff8aec9958 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231009174341 LGD_PCANCELSTR = 0 LGD_BUYER = 김민준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231009174319N6Tx9 LGD_BUYERID = LGD_OID = Direct-sejongmaster-1696840727 LGD_RESPCODE = 3000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-09 17:42:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejongmaster-1696840930 LGD_BUYER = 김민준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231009174210 LGD_HASHDATA = 0f184d2a52601a008feb2bc4740ef6a9 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 = 202310091745011C5318C736DCF8FFE2374AC5E77B6CBDCBA590A5 Mname = 김민준 Mcompany = 그래인팜 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sejongmaster LGD_ESCROW_USEYN = N ========================2023-10-09 17:42:39======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20231009174501 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 3ETS0E LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40329025****302* LGD_FINANCEAUTHNUM = 20016860 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 39fd77b71f616608a09bb72b67bf6235 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231009174503 LGD_PCANCELSTR = 0 LGD_BUYER = 김민준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231009174451N6TU2 LGD_BUYERID = LGD_OID = Direct-sejongmaster-1696840930 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-09 17:42:39======================== insert into mBoard_order set rOrdNo = 'Direct-sejongmaster-1696840930', AuthTy = 'card', memberId = 'sejongmaster', OrdNm ='김민준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '그래인팜', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민VISA 40329025****302*', rApprNo = 'mjsof20231009174451N6TU2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-09 17:42:39', InvoiceNum = '결제성공:Direct-sejongmaster-1696840930/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-09 17:42:39' ========================2023-10-09 17:42:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231009174451N6TU2' 0 = 1 cnt = 1 ========================2023-10-09 17:42:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejongmaster' 0 = sejongmaster Mid = sejongmaster 1 = 그래인팜 Mcompany = 그래인팜 2 = 5770600079 companyNum = 5770600079 3 = 010-3927-8183 Mtel1 = 010-3927-8183 4 = 010-3827-8183 Mhp = 010-3827-8183 ========================2023-10-09 17:42:39======================== select * from customers where id = 'sejongmaster' ========================2023-10-09 17:42:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejongmaster','2023-10-09 17:42:39','10000','11000','온라인','0')