========================2024-09-09 10:11:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jinmyungfood-1725844241 LGD_BUYER = 이채민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909101041 LGD_HASHDATA = 5c894f3ea631cf0a42e55d29db25a5f9 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 = 20240909101358BD8E477095A4BD7C9C91C9D4EFE1FEF0B8BD9678 Mname = 이채민 Mcompany = (주)진명푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jinmyungfood LGD_ESCROW_USEYN = N ========================2024-09-09 10:11:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909101358 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 926871 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400318****791* LGD_FINANCEAUTHNUM = 36746259 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b5f28c2c6bbd51e4429cc7953fa20de3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240909101359 LGD_PCANCELSTR = 0 LGD_BUYER = 이채민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202409091013585FQC6 LGD_BUYERID = LGD_OID = Direct-jinmyungfood-1725844241 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 910135853KC2 ========================2024-09-09 10:11:28======================== insert into mBoard_order set rOrdNo = 'Direct-jinmyungfood-1725844241', AuthTy = 'card', memberId = 'jinmyungfood', OrdNm ='이채민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)진명푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨VISA 41400318****791*', rApprNo = 'mjsof202409091013585FQC6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 10:11:28', InvoiceNum = '결제성공:Direct-jinmyungfood-1725844241/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 10:11:28' ========================2024-09-09 10:11:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202409091013585FQC6' 0 = 1 cnt = 1 ========================2024-09-09 10:11:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jinmyungfood' 0 = jinmyungfood Mid = jinmyungfood 1 = (주)진명푸드 Mcompany = (주)진명푸드 2 = 794-86-02897 companyNum = 794-86-02897 3 = 010-5410-3580 Mtel1 = 010-5410-3580 4 = 010-2112-3392 Mhp = 010-2112-3392 ========================2024-09-09 10:11:29======================== select * from customers where id = 'jinmyungfood' ========================2024-09-09 10:11:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jinmyungfood','2024-09-09 10:11:28','10000','11000','온라인','0') ========================2024-09-09 11:17:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1725848213 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909111653 LGD_HASHDATA = 92f6c73926e1ed0adbfc49000f5de891 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 = 20240909112022303BD1AC055A1324108B20BAF2883AC857D935E6 Mname = 이승민 Mcompany = 승진종합유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = we32 LGD_ESCROW_USEYN = N ========================2024-09-09 11:17:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909112023 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 = 40493380****762* LGD_FINANCEAUTHNUM = 00923617 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0deab06587f647c286c16af61ed1fea0 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240909112023 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202409091120239Tx62 LGD_BUYERID = LGD_OID = Direct-we32-1725848213 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-09 11:17:53======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1725848213', AuthTy = 'card', memberId = 'we32', OrdNm ='이승민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '승진종합유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 40493380****762*', rApprNo = 'mjsof202409091120239Tx62', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 11:17:53', InvoiceNum = '결제성공:Direct-we32-1725848213/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 11:17:53' ========================2024-09-09 11:17:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202409091120239Tx62' 0 = 1 cnt = 1 ========================2024-09-09 11:17:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'we32' 0 = we32 Mid = we32 1 = 승진종합유통 Mcompany = 승진종합유통 2 = 2042832170 companyNum = 2042832170 3 = 010-5366-6466 Mtel1 = 010-5366-6466 4 = 010-5366-6466 Mhp = 010-5366-6466 ========================2024-09-09 11:17:53======================== select * from customers where id = 'we32' ========================2024-09-09 11:17:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2024-09-09 11:17:53','30900','33000','온라인','0') ========================2024-09-09 13:17:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sychemicals-1725855406 LGD_BUYER = 허진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909131649 LGD_HASHDATA = 114c46c4ec92ba0f4290691721a9950d 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 = 20240909132014C2CB21B40BB691A66ED3AAEF8AA581DB1F11086C Mname = 허진 Mcompany = 신영화공약품상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = sychemicals LGD_ESCROW_USEYN = N ========================2024-09-09 13:17:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909132015 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BA7AQ7 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37798808****20* LGD_FINANCEAUTHNUM = 17656824 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4c51f72540a715e2fc3a3f8c2582cb11 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240909132016 LGD_PCANCELSTR = 0 LGD_BUYER = 허진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240909132015d7rA8 LGD_BUYERID = LGD_OID = Direct-sychemicals-1725855406 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-09 13:17:45======================== insert into mBoard_order set rOrdNo = 'Direct-sychemicals-1725855406', AuthTy = 'card', memberId = 'sychemicals', OrdNm ='허진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신영화공약품상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한AMEX 37798808****20*', rApprNo = 'mjsof20240909132015d7rA8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 13:17:45', InvoiceNum = '결제성공:Direct-sychemicals-1725855406/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 13:17:45' ========================2024-09-09 13:17:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240909132015d7rA8' 0 = 1 cnt = 1 ========================2024-09-09 13:17:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sychemicals' 0 = sychemicals Mid = sychemicals 1 = 신영화공약품상사 Mcompany = 신영화공약품상사 2 = 134-12-67705 companyNum = 134-12-67705 3 = 031-430-4256 Mtel1 = 031-430-4256 4 = 010-2336-6568 Mhp = 010-2336-6568 ========================2024-09-09 13:17:45======================== select * from customers where id = 'sychemicals' ========================2024-09-09 13:17:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sychemicals','2024-09-09 13:17:45','52500','55000','온라인','0') ========================2024-09-09 14:18:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1725859030 LGD_BUYER = 김창민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909141710 LGD_HASHDATA = 01d188af7dc8b9144edd9f6203e01213 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 = 2024090914204581CC187EF78007E5989FCDC6F7719B12B9888D01 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-09-09 14:18:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909142046 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 = 00821777 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 01d008e9973c6e46a4d60952758de9e3 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240909142046 LGD_PCANCELSTR = 0 LGD_BUYER = 김창민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240909142046hw6r7 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1725859030 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-09-09 14:18:16======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1725859030', 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 = 'mjsof20240909142046hw6r7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 14:18:16', InvoiceNum = '결제성공:Direct-nosqr9583-1725859030/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 14:18:16' ========================2024-09-09 14:18:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240909142046hw6r7' 0 = 1 cnt = 1 ========================2024-09-09 14:18:16======================== 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-09-09 14:18:16======================== select * from customers where id = 'nosqr9583' ========================2024-09-09 14:18:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2024-09-09 14:18:16','108000','110000','온라인','0') ========================2024-09-09 17:19:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ysothea-1725869804 LGD_BUYER = (주)이소시아 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909171644 LGD_HASHDATA = 28a1d61e278ca3213e314fa27cf3a59d 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 = 202409091721389AB3F526B24EFCF20718607BC6AA83B89FBDB225 Mname = (주)이소시아 Mcompany = (주)이소시아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ysothea LGD_ESCROW_USEYN = N ========================2024-09-09 17:19:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909172139 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ysothea@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****389* LGD_FINANCEAUTHNUM = 30152461 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 913d7127a1851b5dfdf30f883ac43c7a LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240909172140 LGD_PCANCELSTR = 0 LGD_BUYER = (주)이소시아 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240909172139xed13 LGD_BUYERID = LGD_OID = Direct-ysothea-1725869804 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9172139x6242 ========================2024-09-09 17:19:09======================== insert into mBoard_order set rOrdNo = 'Direct-ysothea-1725869804', AuthTy = 'card', memberId = 'ysothea', OrdNm ='(주)이소시아', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)이소시아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****389*', rApprNo = 'mjsof20240909172139xed13', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 17:19:09', InvoiceNum = '결제성공:Direct-ysothea-1725869804/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 17:19:09' ========================2024-09-09 17:19:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240909172139xed13' 0 = 1 cnt = 1 ========================2024-09-09 17:19:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ysothea' 0 = ysothea Mid = ysothea 1 = (주)이소시아 Mcompany = (주)이소시아 2 = 3498700449 companyNum = 3498700449 3 = 02-6239-0026 Mtel1 = 02-6239-0026 4 = 010-3282-0466 Mhp = 010-3282-0466 ========================2024-09-09 17:19:09======================== select * from customers where id = 'ysothea' ========================2024-09-09 17:19:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ysothea','2024-09-09 17:19:09','220000','220000','온라인','0') ========================2024-09-09 17:54:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1725872008 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240909175328 LGD_HASHDATA = e8677002e734410209697ee32af7451b 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 = 202409091757233074EA1CA3F9E88D25894D02FE8BA767DF9FD54B 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 ========================2024-09-09 17:54:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240909175724 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yhk3818100@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300320****092* LGD_FINANCEAUTHNUM = 40761417 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 99ac37b80d8fb1cb61b87d9f8899b727 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240909175724 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240909175724gGAe4 LGD_BUYERID = LGD_OID = Direct-yhk8100-1725872008 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9175724gvbK2 ========================2024-09-09 17:54:54======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1725872008', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 94300320****092*', rApprNo = 'mjsof20240909175724gGAe4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-09-09 17:54:54', InvoiceNum = '결제성공:Direct-yhk8100-1725872008/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-09-09 17:54:54' ========================2024-09-09 17:54:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240909175724gGAe4' 0 = 1 cnt = 1 ========================2024-09-09 17:54:54======================== 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 = 010-6364-5451 Mhp = 010-6364-5451 ========================2024-09-09 17:54:54======================== select * from customers where id = 'yhk8100' ========================2024-09-09 17:54:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2024-09-09 17:54:54','52500','55000','온라인','0')