========================2024-03-07 09:19:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-insnara-1709770510 LGD_BUYER = 김회기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307091510 LGD_HASHDATA = d426a6f61dd3bb0030df7d0dd3fb8adf 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 = 2024030709243140006BE78B370C6E0DB6E2DDD5A9051FE4699CAA Mname = 김회기 Mcompany = 케이비물산[주] post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = insnara LGD_ESCROW_USEYN = N ========================2024-03-07 09:19:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307092432 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = DAA67I LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****802* LGD_FINANCEAUTHNUM = 35664689 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ff5111202b2651b03eed23a184275eee LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20240307092432 LGD_PCANCELSTR = 0 LGD_BUYER = 김회기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202403070924322KUT1 LGD_BUYERID = LGD_OID = Direct-insnara-1709770510 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-03-07 09:19:20======================== insert into mBoard_order set rOrdNo = 'Direct-insnara-1709770510', AuthTy = 'card', memberId = 'insnara', OrdNm ='김회기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '케이비물산[주]', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****802*', rApprNo = 'mjsof202403070924322KUT1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 09:19:20', InvoiceNum = '결제성공:Direct-insnara-1709770510/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 09:19:20' ========================2024-03-07 09:19:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202403070924322KUT1' 0 = 1 cnt = 1 ========================2024-03-07 09:19:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'insnara' 0 = insnara Mid = insnara 1 = 케이비물산[주] Mcompany = 케이비물산[주] 2 = 4168199217 companyNum = 4168199217 3 = 061-727-7272 Mtel1 = 061-727-7272 4 = 010-6600-5060 Mhp = 010-6600-5060 ========================2024-03-07 09:19:20======================== select * from customers where id = 'insnara' ========================2024-03-07 09:19:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('insnara','2024-03-07 09:19:20','220000','220000','온라인','0') ========================2024-03-07 10:03:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kog1223-1709773334 LGD_BUYER = 김원귀 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307100214 LGD_HASHDATA = dd434f51bb090b3a2f22c7ba4b57cfba 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 = 20240307100813A9E37F7B25506F0D44F5442040718BA34232D1F3 Mname = 김원귀 Mcompany = (주)닭사부 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kog1223 LGD_ESCROW_USEYN = N ========================2024-03-07 10:03:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307100814 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 004686 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****784* LGD_FINANCEAUTHNUM = 30021134 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 29995265d71d895163dbd14dc5a0247d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240307100814 LGD_PCANCELSTR = 0 LGD_BUYER = 김원귀 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202403071008135RHc0 LGD_BUYERID = LGD_OID = Direct-kog1223-1709773334 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71008135BGO2 ========================2024-03-07 10:03:01======================== insert into mBoard_order set rOrdNo = 'Direct-kog1223-1709773334', AuthTy = 'card', memberId = 'kog1223', OrdNm ='김원귀', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)닭사부', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****784*', rApprNo = 'mjsof202403071008135RHc0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 10:03:01', InvoiceNum = '결제성공:Direct-kog1223-1709773334/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 10:03:01' ========================2024-03-07 10:03:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202403071008135RHc0' 0 = 1 cnt = 1 ========================2024-03-07 10:03:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kog1223' 0 = kog1223 Mid = kog1223 1 = (주)닭사부 Mcompany = (주)닭사부 2 = 6528100417 companyNum = 6528100417 3 = 010-8220-1531 Mtel1 = 010-8220-1531 4 = 010-8220-1531 Mhp = 010-8220-1531 ========================2024-03-07 10:03:01======================== select * from customers where id = 'kog1223' ========================2024-03-07 10:03:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kog1223','2024-03-07 10:03:01','220000','220000','온라인','0') ========================2024-03-07 10:28:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-landhbio-1709774827 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307102707 LGD_HASHDATA = fdb57baa25987a5f438c90256473b7e9 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 = 202403071033258BA803665651B64132757ADF2F2249DFDE03AAD8 Mname = 이승환 Mcompany = (주)엘엔에이치바이오 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = landhbio LGD_ESCROW_USEYN = N ========================2024-03-07 10:28:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307103326 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 834865 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****903* LGD_FINANCEAUTHNUM = 60542497 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1449a0939151b708ccddc0ca1f2c906c LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240307103326 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240307103325bOAw4 LGD_BUYERID = LGD_OID = Direct-landhbio-1709774827 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7103325b9lP9 ========================2024-03-07 10:28:14======================== insert into mBoard_order set rOrdNo = 'Direct-landhbio-1709774827', AuthTy = 'card', memberId = 'landhbio', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)엘엔에이치바이오', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****903*', rApprNo = 'mjsof20240307103325bOAw4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 10:28:14', InvoiceNum = '결제성공:Direct-landhbio-1709774827/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 10:28:14' ========================2024-03-07 10:28:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240307103325bOAw4' 0 = 1 cnt = 1 ========================2024-03-07 10:28:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'landhbio' 0 = landhbio Mid = landhbio 1 = (주)엘엔에이치바이오 Mcompany = (주)엘엔에이치바이오 2 = 1448113110 companyNum = 1448113110 3 = 070-4111-0496 Mtel1 = 070-4111-0496 4 = 010-2703-0694 Mhp = 010-2703-0694 ========================2024-03-07 10:28:14======================== select * from customers where id = 'landhbio' ========================2024-03-07 10:28:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('landhbio','2024-03-07 10:28:14','52500','55000','온라인','0') ========================2024-03-07 10:30:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nhfood-1709774968 LGD_BUYER = 김성수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307102928 LGD_HASHDATA = 6cfe5405ccf96f4fcd27ff91d3f53e3c 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 = 20240307103547CAB90A9AB9B6BDA456E28AFDD731D899452FB037 Mname = 김성수 Mcompany = 엔에이치푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nhfood LGD_ESCROW_USEYN = N ========================2024-03-07 10:30:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307103547 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 = 55852694****483* LGD_FINANCEAUTHNUM = 30074970 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e94296041c47fd69380211c60d4784fa LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240307103547 LGD_PCANCELSTR = 0 LGD_BUYER = 김성수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240307103547bONM6 LGD_BUYERID = LGD_OID = Direct-nhfood-1709774968 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7103547b9q64 ========================2024-03-07 10:30:35======================== insert into mBoard_order set rOrdNo = 'Direct-nhfood-1709774968', AuthTy = 'card', memberId = 'nhfood', OrdNm ='김성수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '엔에이치푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****483*', rApprNo = 'mjsof20240307103547bONM6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 10:30:35', InvoiceNum = '결제성공:Direct-nhfood-1709774968/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 10:30:35' ========================2024-03-07 10:30:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240307103547bONM6' 0 = 1 cnt = 1 ========================2024-03-07 10:30:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nhfood' 0 = nhfood Mid = nhfood 1 = 엔에이치푸드 Mcompany = 엔에이치푸드 2 = 6218198770 companyNum = 6218198770 3 = 055-375-6601 Mtel1 = 055-375-6601 4 = 010-9210-1876 Mhp = 010-9210-1876 ========================2024-03-07 10:30:35======================== select * from customers where id = 'nhfood' ========================2024-03-07 10:30:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nhfood','2024-03-07 10:30:35','52500','55000','온라인','0') ========================2024-03-07 11:40:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wjosc09-1709779147 LGD_BUYER = 심보미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307113907 LGD_HASHDATA = a2b4cb33433ca020e275fc5e70deafd4 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 = 20240307114525B83FE69D2CE9D704E8CCAFAEDE0C26C0FE2A9DC9 Mname = 심보미 Mcompany = (주)원진오에스씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = wjosc09 LGD_ESCROW_USEYN = N ========================2024-03-07 11:40:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307114526 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = bill@wjosc.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94307870****307* LGD_FINANCEAUTHNUM = 60970697 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8b869636a0e25f38731b0128c7012ec5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240307114527 LGD_PCANCELSTR = 0 LGD_BUYER = 심보미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202403071145265aWq2 LGD_BUYERID = LGD_OID = Direct-wjosc09-1709779147 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 71145265HYa2 ========================2024-03-07 11:40:14======================== insert into mBoard_order set rOrdNo = 'Direct-wjosc09-1709779147', AuthTy = 'card', memberId = 'wjosc09', OrdNm ='심보미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원진오에스씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94307870****307*', rApprNo = 'mjsof202403071145265aWq2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 11:40:14', InvoiceNum = '결제성공:Direct-wjosc09-1709779147/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 11:40:14' ========================2024-03-07 11:40:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202403071145265aWq2' 0 = 1 cnt = 1 ========================2024-03-07 11:40:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wjosc09' 0 = wjosc09 Mid = wjosc09 1 = (주)원진오에스씨 Mcompany = (주)원진오에스씨 2 = 119-81-66436 companyNum = 119-81-66436 3 = 010-3785-4495 Mtel1 = 010-3785-4495 4 = 010-3785-4495 Mhp = 010-3785-4495 ========================2024-03-07 11:40:15======================== select * from customers where id = 'wjosc09' ========================2024-03-07 11:40:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wjosc09','2024-03-07 11:40:14','220000','220000','온라인','0') ========================2024-03-07 11:57:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jinsco2277-1709780204 LGD_BUYER = (주)우리유통 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307115644 LGD_HASHDATA = 91bc14f9f49e83e38b3d57b87ffa2f2d 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 = 20240307120311DB5FB373C8BF8D4F48193084F90F25DC2F99904D Mname = (주)우리유통 Mcompany = (주)우리유통 진스코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jinsco2277 LGD_ESCROW_USEYN = N ========================2024-03-07 11:57:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307120311 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401172****793* LGD_FINANCEAUTHNUM = 61066477 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c0a8b6addcb6119de0666983bd62f7b9 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240307120312 LGD_PCANCELSTR = 0 LGD_BUYER = (주)우리유통 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240307120311UXRn5 LGD_BUYERID = LGD_OID = Direct-jinsco2277-1709780204 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7120311UkxO6 ========================2024-03-07 11:57:59======================== insert into mBoard_order set rOrdNo = 'Direct-jinsco2277-1709780204', AuthTy = 'card', memberId = 'jinsco2277', OrdNm ='(주)우리유통', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통 진스코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41401172****793*', rApprNo = 'mjsof20240307120311UXRn5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 11:57:59', InvoiceNum = '결제성공:Direct-jinsco2277-1709780204/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 11:57:59' ========================2024-03-07 11:57:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240307120311UXRn5' 0 = 1 cnt = 1 ========================2024-03-07 11:57:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jinsco2277' 0 = jinsco2277 Mid = jinsco2277 1 = (주)우리유통 진스코 Mcompany = (주)우리유통 진스코 2 = 609-81-01557 companyNum = 609-81-01557 3 = 055-542-2277 Mtel1 = 055-542-2277 4 = 010-8935-4203 Mhp = 010-8935-4203 ========================2024-03-07 11:57:59======================== select * from customers where id = 'jinsco2277' ========================2024-03-07 11:57:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jinsco2277','2024-03-07 11:57:59','220000','220000','온라인','0') ========================2024-03-07 12:42:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yk9906-1709782881 LGD_BUYER = 류경동 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307124121 LGD_HASHDATA = f2946b8d1f3ee94f51731049aad7a7aa 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 = 20240307124755E53747AA6D6F81B162B73D7E974799880CD4B071 Mname = 류경동 Mcompany = 영암상회 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yk9906 LGD_ESCROW_USEYN = N ========================2024-03-07 12:42:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307124755 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 476C0C LGD_AFFILIATECODE = 171272 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55321245****934* LGD_FINANCEAUTHNUM = 61347115 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 18052770e126d9cc42b65afd0f2d5c78 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240307124756 LGD_PCANCELSTR = 0 LGD_BUYER = 류경동 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240307124755aGIV3 LGD_BUYERID = LGD_OID = Direct-yk9906-1709782881 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7124755aBdH7 ========================2024-03-07 12:42:43======================== insert into mBoard_order set rOrdNo = 'Direct-yk9906-1709782881', AuthTy = 'card', memberId = 'yk9906', OrdNm ='류경동', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '영암상회', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55321245****934*', rApprNo = 'mjsof20240307124755aGIV3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 12:42:43', InvoiceNum = '결제성공:Direct-yk9906-1709782881/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 12:42:43' ========================2024-03-07 12:42:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240307124755aGIV3' 0 = 1 cnt = 1 ========================2024-03-07 12:42:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yk9906' 0 = yk9906 Mid = yk9906 1 = 영암상회 Mcompany = 영암상회 2 = 4098162691 companyNum = 4098162691 3 = 062-267-0414 Mtel1 = 062-267-0414 4 = 010-3912-9906 Mhp = 010-3912-9906 ========================2024-03-07 12:42:43======================== select * from customers where id = 'yk9906' ========================2024-03-07 12:42:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yk9906','2024-03-07 12:42:43','52500','55000','온라인','0') ========================2024-03-07 14:35:10======================== res_start ========================2024-03-07 14:35:10======================== xpay_res LGD_RESPCODE = XC01 LGD_RESPMSG = LGD_MID 필드가 누락되었습니다. Init_TX(LGD_MID)를 해주시기 바랍니다. 또는 mall.conf 에 상점키가 셋팅되어 있지 않습니다. ========================2024-03-07 17:54:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ts5ttogi-1709801574 LGD_BUYER = 김건우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307175254 LGD_HASHDATA = cfdd555a4ab1506f4a2028c417938e70 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 = 20240307175939E281F37EAFB4498E7AB7C0BB9EEA3D7BCA8B2E44 Mname = 김건우 Mcompany = (주)태신종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ts5ttogi LGD_ESCROW_USEYN = N ========================2024-03-07 17:54:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307175940 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****938* LGD_FINANCEAUTHNUM = 63987897 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c738a13781ae8782e1cceea00c5a53e5 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240307175940 LGD_PCANCELSTR = 0 LGD_BUYER = 김건우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240307175940fBhx5 LGD_BUYERID = LGD_OID = Direct-ts5ttogi-1709801574 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7175940f2Bf7 ========================2024-03-07 17:54:28======================== insert into mBoard_order set rOrdNo = 'Direct-ts5ttogi-1709801574', AuthTy = 'card', memberId = 'ts5ttogi', OrdNm ='김건우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태신종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****938*', rApprNo = 'mjsof20240307175940fBhx5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 17:54:28', InvoiceNum = '결제성공:Direct-ts5ttogi-1709801574/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 17:54:28' ========================2024-03-07 17:54:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240307175940fBhx5' 0 = 1 cnt = 1 ========================2024-03-07 17:54:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ts5ttogi' 0 = ts5ttogi Mid = ts5ttogi 1 = (주)태신종합물류 Mcompany = (주)태신종합물류 2 = 6918600886 companyNum = 6918600886 3 = 010-4841-6383 Mtel1 = 010-4841-6383 4 = 010-3350-6383 Mhp = 010-3350-6383 ========================2024-03-07 17:54:28======================== select * from customers where id = 'ts5ttogi' ========================2024-03-07 17:54:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ts5ttogi','2024-03-07 17:54:28','220000','220000','온라인','0') ========================2024-03-07 18:21:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jhs177-1709803231 LGD_BUYER = 진희성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240307182031 LGD_HASHDATA = 9d9b91eb36efd788bba388cbdeadeabd 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 = 202403071826344A7B471852932A3DBF0669A14D5BC9B1C4B5DAAC Mname = 진희성 Mcompany = 푸른교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = jhs177 LGD_ESCROW_USEYN = N ========================2024-03-07 18:21:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240307182635 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009040 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54092623****601* LGD_FINANCEAUTHNUM = 30030874 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c07c5e60c00a67a9bdb44150f0223b80 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20240307182635 LGD_PCANCELSTR = 0 LGD_BUYER = 진희성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202403071826352atM6 LGD_BUYERID = LGD_OID = Direct-jhs177-1709803231 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-03-07 18:21:22======================== insert into mBoard_order set rOrdNo = 'Direct-jhs177-1709803231', AuthTy = 'card', memberId = 'jhs177', OrdNm ='진희성', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '푸른교육사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 54092623****601*', rApprNo = 'mjsof202403071826352atM6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-03-07 18:21:22', InvoiceNum = '결제성공:Direct-jhs177-1709803231/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-03-07 18:21:22' ========================2024-03-07 18:21:22======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202403071826352atM6' 0 = 1 cnt = 1 ========================2024-03-07 18:21:22======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jhs177' 0 = jhs177 Mid = jhs177 1 = 푸른교육사 Mcompany = 푸른교육사 2 = 127-30-66906 companyNum = 127-30-66906 3 = 02-939-8566 Mtel1 = 02-939-8566 4 = 010-9244-9993 Mhp = 010-9244-9993 ========================2024-03-07 18:21:22======================== select * from customers where id = 'jhs177' ========================2024-03-07 18:21:22======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jhs177','2024-03-07 18:21:22','10000','11000','온라인','0')