========================2023-07-10 07:53:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-we32-1688943133 LGD_BUYER = 이승민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710075213 LGD_HASHDATA = 5bf069e234261fb0738a4c2eeea666e2 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 = 202307100753432164DBA22C11D33D7E5827D3A8855B35158AC1CC 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 ========================2023-07-10 07:53:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710075343 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 = 40493380****762* LGD_FINANCEAUTHNUM = 00997893 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d8ae14caa51c76c087e2eb589d70081f LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230710075344 LGD_PCANCELSTR = 0 LGD_BUYER = 이승민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202307100753436nCJ3 LGD_BUYERID = LGD_OID = Direct-we32-1688943133 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-10 07:53:02======================== insert into mBoard_order set rOrdNo = 'Direct-we32-1688943133', 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 = 'mjsof202307100753436nCJ3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 07:53:02', InvoiceNum = '결제성공:Direct-we32-1688943133/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 07:53:02' ========================2023-07-10 07:53:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202307100753436nCJ3' 0 = 1 cnt = 1 ========================2023-07-10 07:53:03======================== 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 ========================2023-07-10 07:53:03======================== select * from customers where id = 'we32' ========================2023-07-10 07:53:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('we32','2023-07-10 07:53:02','30900','33000','온라인','0') ========================2023-07-10 13:20:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-seorinsangsa-1688962761 LGD_BUYER = 정인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710131921 LGD_HASHDATA = e9a26400556f104a87bee57bf3a62615 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 = 20230710132052E2F6DC1EF9508AE68B00467A9A1F8F382048F2E9 Mname = 정인숙 Mcompany = 서린상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = seorinsangsa LGD_ESCROW_USEYN = N ========================2023-07-10 13:20:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710132052 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41710311****497* LGD_FINANCEAUTHNUM = 56909642 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d5ac6e96033ba48f555f6f6091ec922e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230710132053 LGD_PCANCELSTR = 0 LGD_BUYER = 정인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230710132052Vw382 LGD_BUYERID = LGD_OID = Direct-seorinsangsa-1688962761 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0132052V6id3 ========================2023-07-10 13:20:11======================== insert into mBoard_order set rOrdNo = 'Direct-seorinsangsa-1688962761', AuthTy = 'card', memberId = 'seorinsangsa', OrdNm ='정인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서린상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41710311****497*', rApprNo = 'mjsof20230710132052Vw382', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 13:20:11', InvoiceNum = '결제성공:Direct-seorinsangsa-1688962761/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 13:20:11' ========================2023-07-10 13:20:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710132052Vw382' 0 = 1 cnt = 1 ========================2023-07-10 13:20:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'seorinsangsa' 0 = seorinsangsa Mid = seorinsangsa 1 = 서린상사 Mcompany = 서린상사 2 = 1378623385 companyNum = 1378623385 3 = 032-562-2057 Mtel1 = 032-562-2057 4 = 010-5423-2057 Mhp = 010-5423-2057 ========================2023-07-10 13:20:11======================== select * from customers where id = 'seorinsangsa' ========================2023-07-10 13:20:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('seorinsangsa','2023-07-10 13:20:11','220000','220000','온라인','0') ========================2023-07-10 13:24:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-barun0225-1688963032 LGD_BUYER = 조장환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710132352 LGD_HASHDATA = edbb737e90c2993b833489985d4741c2 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 = 2023071013250597D0F4B8D75D20025475E6ADAE1DE2B863E1A8C4 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 ========================2023-07-10 13:24:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710132505 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BA8AZR LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 44991481****064* LGD_FINANCEAUTHNUM = 02813907 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 2dfa4b3d4b45aa5ce27414a8098f9c4f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230710132507 LGD_PCANCELSTR = 0 LGD_BUYER = 조장환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230710132505WnKb5 LGD_BUYERID = LGD_OID = Direct-barun0225-1688963032 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-10 13:24:25======================== insert into mBoard_order set rOrdNo = 'Direct-barun0225-1688963032', 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 = 'mjsof20230710132505WnKb5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 13:24:25', InvoiceNum = '결제성공:Direct-barun0225-1688963032/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 13:24:25' ========================2023-07-10 13:24:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710132505WnKb5' 0 = 1 cnt = 1 ========================2023-07-10 13:24:26======================== 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 ========================2023-07-10 13:24:26======================== select * from customers where id = 'barun0225' ========================2023-07-10 13:24:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('barun0225','2023-07-10 13:24:25','220000','220000','온라인','0') ========================2023-07-10 14:39:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanapaper-1688967483 LGD_BUYER = 이전상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710143803 LGD_HASHDATA = 8832676eb8006f181bcc503de184dbab 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 = 202307101439420E2BE399099C5EED04F91E53B4F8F27FDF987749 Mname = 이전상 Mcompany = (주)미르티앤엠 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hanapaper LGD_ESCROW_USEYN = N ========================2023-07-10 14:39:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710143943 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003394 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41474368****707* LGD_FINANCEAUTHNUM = 30035260 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a5ed552032a4a0be9aa3727ecedfad74 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230710143943 LGD_PCANCELSTR = 0 LGD_BUYER = 이전상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2023071014394238j22 LGD_BUYERID = LGD_OID = Direct-hanapaper-1688967483 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-10 14:39:01======================== insert into mBoard_order set rOrdNo = 'Direct-hanapaper-1688967483', AuthTy = 'card', memberId = 'hanapaper', OrdNm ='이전상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미르티앤엠', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 41474368****707*', rApprNo = 'mjsof2023071014394238j22', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 14:39:01', InvoiceNum = '결제성공:Direct-hanapaper-1688967483/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 14:39:01' ========================2023-07-10 14:39:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2023071014394238j22' 0 = 1 cnt = 1 ========================2023-07-10 14:39:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanapaper' 0 = hanapaper Mid = hanapaper 1 = (주)미르티앤엠 Mcompany = (주)미르티앤엠 2 = 1348736286 companyNum = 1348736286 3 = 031-521-6690 Mtel1 = 031-521-6690 4 = 010-2216-5552 Mhp = 010-2216-5552 ========================2023-07-10 14:39:01======================== select * from customers where id = 'hanapaper' ========================2023-07-10 14:39:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanapaper','2023-07-10 14:39:01','52500','55000','온라인','0') ========================2023-07-10 16:15:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1688973267 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710161427 LGD_HASHDATA = 8e583ae0d26e4829c6583a3c4c576124 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 = 202307101615517821FBA0CDFABCCCECEF989D5DCCBFB89F47EE9B Mname = 박재호 Mcompany = (주)극광사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2023-07-10 16:15:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710161552 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52297100****685* LGD_FINANCEAUTHNUM = 30047452 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 938363a8887ba52116ba04271aabc589 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230710161552 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230710161552hPVU4 LGD_BUYERID = LGD_OID = Direct-parkco6338-1688973267 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0161552hYNX7 ========================2023-07-10 16:15:11======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1688973267', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)극광사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 52297100****685*', rApprNo = 'mjsof20230710161552hPVU4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 16:15:11', InvoiceNum = '결제성공:Direct-parkco6338-1688973267/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 16:15:11' ========================2023-07-10 16:15:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710161552hPVU4' 0 = 1 cnt = 1 ========================2023-07-10 16:15:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = (주)극광사 Mcompany = (주)극광사 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2023-07-10 16:15:11======================== select * from customers where id = 'parkco6338' ========================2023-07-10 16:15:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2023-07-10 16:15:11','220000','220000','온라인','0') ========================2023-07-10 19:36:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dmsalsdk-1688985174 LGD_BUYER = 김은민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710193254 LGD_HASHDATA = faf5bbcfc12c6e5bab4f9c580349b884 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 = 20230710193723CE7CC64240518A3B87CE8223D514BB3BAE6E9A1E Mname = 김은민 Mcompany = 소망유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = dmsalsdk LGD_ESCROW_USEYN = N ========================2023-07-10 19:36:43======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20230710193724 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 = LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 2545aaf15f2074ade111e9fabbc783c5 LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20230710193724 LGD_PCANCELSTR = 0 LGD_BUYER = 김은민 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20230710193531VyIL3 LGD_BUYERID = LGD_OID = Direct-dmsalsdk-1688985174 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-10 19:36:43======================== insert into mBoard_order set rOrdNo = 'Direct-dmsalsdk-1688985174', AuthTy = 'card', memberId = 'dmsalsdk', OrdNm ='김은민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '소망유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20230710193531VyIL3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 19:36:43', InvoiceNum = '결제성공:Direct-dmsalsdk-1688985174/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 19:36:43' ========================2023-07-10 19:36:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710193531VyIL3' 0 = 1 cnt = 1 ========================2023-07-10 19:36:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dmsalsdk' 0 = dmsalsdk Mid = dmsalsdk 1 = 소망유통 Mcompany = 소망유통 2 = 8321601014 companyNum = 8321601014 3 = 010-4696-3071 Mtel1 = 010-4696-3071 4 = 010-4081-4660 Mhp = 010-4081-4660 ========================2023-07-10 19:36:43======================== select * from customers where id = 'dmsalsdk' ========================2023-07-10 19:36:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dmsalsdk','2023-07-10 19:36:43','30900','33000','온라인','0') ========================2023-07-10 19:46:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-puduly-1688985713 LGD_BUYER = 곽윤희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710194153 LGD_HASHDATA = 29131c2b4f2ce16c0329f7d77c6fef09 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 = 202307101946493134972BE6D44EAC9CEE5B1424E1EDBB12D466BD Mname = 곽윤희 Mcompany = (주)원앤원사무용가구 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = puduly LGD_ESCROW_USEYN = N ========================2023-07-10 19:46:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710194650 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 001620 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43329061****005* LGD_FINANCEAUTHNUM = 30080388 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4158a116a4c3c050b1ae6d2023066280 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230710194650 LGD_PCANCELSTR = 0 LGD_BUYER = 곽윤희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230710194650qltU8 LGD_BUYERID = LGD_OID = Direct-puduly-1688985713 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0194650qc1c2 ========================2023-07-10 19:46:08======================== insert into mBoard_order set rOrdNo = 'Direct-puduly-1688985713', AuthTy = 'card', memberId = 'puduly', OrdNm ='곽윤희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원앤원사무용가구', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 43329061****005*', rApprNo = 'mjsof20230710194650qltU8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 19:46:08', InvoiceNum = '결제성공:Direct-puduly-1688985713/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 19:46:08' ========================2023-07-10 19:46:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710194650qltU8' 0 = 1 cnt = 1 ========================2023-07-10 19:46:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'puduly' 0 = puduly Mid = puduly 1 = (주)원앤원사무용가구 Mcompany = (주)원앤원사무용가구 2 = 6628800242 companyNum = 6628800242 3 = 010-3333-8091 Mtel1 = 010-3333-8091 4 = 010-3333-8091 Mhp = 010-3333-8091 ========================2023-07-10 19:46:08======================== select * from customers where id = 'puduly' ========================2023-07-10 19:46:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('puduly','2023-07-10 19:46:08','52500','55000','온라인','0') ========================2023-07-10 22:27:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dullee33-1688995529 LGD_BUYER = 조재광 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230710222529 LGD_HASHDATA = 067f969efefe7c1a151e618f6bc52d20 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 = 2023071022275414403512C847E4210D6948701423CB5681E74484 Mname = 조재광 Mcompany = 대흥수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dullee33 LGD_ESCROW_USEYN = N ========================2023-07-10 22:27:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230710222754 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = 009153 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54092606****000* LGD_FINANCEAUTHNUM = 30041865 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 181fba4cbae1be8a53a66e5ca30d2d1b LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230710222754 LGD_PCANCELSTR = 0 LGD_BUYER = 조재광 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230710222754dSbu8 LGD_BUYERID = LGD_OID = Direct-dullee33-1688995529 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-07-10 22:27:12======================== insert into mBoard_order set rOrdNo = 'Direct-dullee33-1688995529', AuthTy = 'card', memberId = 'dullee33', OrdNm ='조재광', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대흥수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 54092606****000*', rApprNo = 'mjsof20230710222754dSbu8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-07-10 22:27:12', InvoiceNum = '결제성공:Direct-dullee33-1688995529/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-07-10 22:27:12' ========================2023-07-10 22:27:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230710222754dSbu8' 0 = 1 cnt = 1 ========================2023-07-10 22:27:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dullee33' 0 = dullee33 Mid = dullee33 1 = 대흥수산 Mcompany = 대흥수산 2 = 5846900446 companyNum = 5846900446 3 = 010-2222-9191 Mtel1 = 010-2222-9191 4 = 010-2222-9191 Mhp = 010-2222-9191 ========================2023-07-10 22:27:13======================== select * from customers where id = 'dullee33' ========================2023-07-10 22:27:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dullee33','2023-07-10 22:27:12','220000','220000','온라인','0')