========================2024-06-10 05:57:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1717966543 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240610055543 LGD_HASHDATA = b83b43ef5e5a950010ddde8f8aeb1fb3 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 = 2024061005580877FA88ED220C594AD7782AB911BB03894D4CCDB2 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 ========================2024-06-10 05:57:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240610055811 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 = 43890180****870* LGD_FINANCEAUTHNUM = 00170470 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2ea02224c7fa1575eca4da625cb252ef LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240610055811 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240610055810eehc2 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1717966543 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-10 05:57:24======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1717966543', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='김창민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 43890180****870*', rApprNo = 'mjsof20240610055810eehc2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-10 05:57:24', InvoiceNum = '결제성공:Direct-nosqr9583-1717966543/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-10 05:57:24' ========================2024-06-10 05:57:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240610055810eehc2' 0 = 1 cnt = 1 ========================2024-06-10 05:57:25======================== 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 ========================2024-06-10 05:57:25======================== select * from customers where id = 'nosqr9583' ========================2024-06-10 05:57:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2024-06-10 05:57:24','108000','110000','온라인','0') ========================2024-06-10 10:13:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1717981788 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240610100948 LGD_HASHDATA = 05ccdc8640d2daa774d11f3cef57cac6 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 = 2024061010140236077E6132A8837CA2434FFD116AFC1B8896A7D9 Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2024-06-10 10:13:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240610101403 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****454* LGD_FINANCEAUTHNUM = 59040407 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cf396085578213501b723d3856a0edf8 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240610101403 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240610101403ddTn5 LGD_BUYERID = LGD_OID = Direct-ltweenn-1717981788 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0101403dc9e0 ========================2024-06-10 10:13:17======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1717981788', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****454*', rApprNo = 'mjsof20240610101403ddTn5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-10 10:13:17', InvoiceNum = '결제성공:Direct-ltweenn-1717981788/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-10 10:13:17' ========================2024-06-10 10:13:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240610101403ddTn5' 0 = 1 cnt = 1 ========================2024-06-10 10:13:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2024-06-10 10:13:17======================== select * from customers where id = 'ltweenn' ========================2024-06-10 10:13:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2024-06-10 10:13:17','108000','110000','온라인','0') ========================2024-06-10 14:51:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-barun0225-1717998668 LGD_BUYER = 조장환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240610145108 LGD_HASHDATA = dfb55415e1e8a337a6ec7e6aa58a335f 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 = 20240610145218159C4CF62AD0BC503FE042F61BA5F07C6E3318D0 Mname = 조장환 Mcompany = 바른식품푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = barun0225 LGD_ESCROW_USEYN = N ========================2024-06-10 14:51:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240610145218 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BA8AZR LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 44991481****064* LGD_FINANCEAUTHNUM = 48223922 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 38091b77cd7d86a140da0a5cac4c96ba LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240610145220 LGD_PCANCELSTR = 0 LGD_BUYER = 조장환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202406101452187PE37 LGD_BUYERID = LGD_OID = Direct-barun0225-1717998668 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-10 14:51:33======================== insert into mBoard_order set rOrdNo = 'Direct-barun0225-1717998668', AuthTy = 'card', memberId = 'barun0225', OrdNm ='조장환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바른식품푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 44991481****064*', rApprNo = 'mjsof202406101452187PE37', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-10 14:51:33', InvoiceNum = '결제성공:Direct-barun0225-1717998668/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-10 14:51:33' ========================2024-06-10 14:51:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202406101452187PE37' 0 = 1 cnt = 1 ========================2024-06-10 14:51:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'barun0225' 0 = barun0225 Mid = barun0225 1 = 바른식품푸드 Mcompany = 바른식품푸드 2 = 324-03-01793 companyNum = 324-03-01793 3 = 010-5581-2073 Mtel1 = 010-5581-2073 4 = 010 -5581-2073 Mhp = 010 -5581-2073 ========================2024-06-10 14:51:33======================== select * from customers where id = 'barun0225' ========================2024-06-10 14:51:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('barun0225','2024-06-10 14:51:33','220000','220000','온라인','0') ========================2024-06-10 14:57:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woori3451777-1717998942 LGD_BUYER = 최현숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240610145542 LGD_HASHDATA = fc8de086d6d1d6b51c64a2d8bc3565b0 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 = 20240610145814D784CF478641C7D9F03D0F2E807395DA8421D7A3 Mname = 최현숙 Mcompany = 우리농산식자재도매센타 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = woori3451777 LGD_ESCROW_USEYN = N ========================2024-06-10 14:57:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240610145814 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009310 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62443440****709* LGD_FINANCEAUTHNUM = 30034768 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f4bb4e8f209e9fabd281cdb4e0274f5f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240610145815 LGD_PCANCELSTR = 0 LGD_BUYER = 최현숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202406101458145iI77 LGD_BUYERID = LGD_OID = Direct-woori3451777-1717998942 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-10 14:57:28======================== insert into mBoard_order set rOrdNo = 'Direct-woori3451777-1717998942', AuthTy = 'card', memberId = 'woori3451777', OrdNm ='최현숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우리농산식자재도매센타', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민CUP 62443440****709*', rApprNo = 'mjsof202406101458145iI77', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-10 14:57:28', InvoiceNum = '결제성공:Direct-woori3451777-1717998942/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-10 14:57:28' ========================2024-06-10 14:57:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202406101458145iI77' 0 = 1 cnt = 1 ========================2024-06-10 14:57:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woori3451777' 0 = woori3451777 Mid = woori3451777 1 = 우리농산식자재도매센타 Mcompany = 우리농산식자재도매센타 2 = 6151876286 companyNum = 6151876286 3 = 010-6300-4579 Mtel1 = 010-6300-4579 4 = 010-6300-4579 Mhp = 010-6300-4579 ========================2024-06-10 14:57:28======================== select * from customers where id = 'woori3451777' ========================2024-06-10 14:57:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woori3451777','2024-06-10 14:57:28','30900','33000','온라인','0') ========================2024-06-10 16:45:53======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-laon0707-1718005429 LGD_BUYER = 김영중 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240610164349 LGD_HASHDATA = 1a1aa893af8702d54bf55fa7d5747c04 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 = 202406101646408A24FC8853AEC639F1C5367D3C54C4255BFB933D Mname = 김영중 Mcompany = (주)라온물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = laon0707 LGD_ESCROW_USEYN = N ========================2024-06-10 16:45:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240610164640 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 = 49022082****487* LGD_FINANCEAUTHNUM = 63935889 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 39e3a1e10173d57b0dfcc0f63a21b369 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240610164641 LGD_PCANCELSTR = 0 LGD_BUYER = 김영중 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240610164640PEBU0 LGD_BUYERID = LGD_OID = Direct-laon0707-1718005429 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-06-10 16:45:54======================== insert into mBoard_order set rOrdNo = 'Direct-laon0707-1718005429', AuthTy = 'card', memberId = 'laon0707', OrdNm ='김영중', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)라온물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '우리비씨VISA 49022082****487*', rApprNo = 'mjsof20240610164640PEBU0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-06-10 16:45:54', InvoiceNum = '결제성공:Direct-laon0707-1718005429/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-06-10 16:45:54' ========================2024-06-10 16:45:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240610164640PEBU0' 0 = 1 cnt = 1 ========================2024-06-10 16:45:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'laon0707' 0 = laon0707 Mid = laon0707 1 = (주)라온물류 Mcompany = (주)라온물류 2 = 192-81-00462 companyNum = 192-81-00462 3 = 010-9300-0155 Mtel1 = 010-9300-0155 4 = 010-9447-8839 Mhp = 010-9447-8839 ========================2024-06-10 16:45:54======================== select * from customers where id = 'laon0707' ========================2024-06-10 16:45:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('laon0707','2024-06-10 16:45:54','30900','33000','온라인','0')