========================2021-02-26 11:00:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jeonyae-1614304509 LGD_BUYER = 전혜영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226105509 LGD_HASHDATA = 630001dc76cc9c84b7d7785545bf43ec LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202102261100241DC704A3C85CB1F45542200E2956AA7C2712D5FF Mname = 전혜영 Mcompany = 현대상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jeonyae LGD_ESCROW_USEYN = N ========================2021-02-26 11:00:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226110025 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943016******4213 LGD_FINANCEAUTHNUM = 55989222 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b00881a72c779efeeef4c2f54d19bbd6 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210226110025 LGD_PCANCELSTR = 0 LGD_BUYER = 전혜영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022611002560286 LGD_BUYERID = LGD_OID = Direct-jeonyae-1614304509 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-26 11:00:18======================== insert into mBoard_order set rOrdNo = 'Direct-jeonyae-1614304509', AuthTy = 'card', memberId = 'jeonyae', OrdNm ='전혜영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '현대상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH 943016******4213', rApprNo = 'mjsof2021022611002560286', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 11:00:18', InvoiceNum = '결제성공:Direct-jeonyae-1614304509/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 11:00:18' ========================2021-02-26 11:00:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022611002560286' 0 = 1 cnt = 1 ========================2021-02-26 11:00:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jeonyae' 0 = jeonyae Mid = jeonyae 1 = 현대상사 Mcompany = 현대상사 2 = 2673800625 companyNum = 2673800625 3 = 010-4391-8585 Mtel1 = 010-4391-8585 4 = 010-4391-8585 Mhp = 010-4391-8585 ========================2021-02-26 11:00:18======================== select * from customers where id = 'jeonyae' ========================2021-02-26 11:00:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jeonyae','2021-02-26 11:00:18','30900','33000','온라인','0') ========================2021-02-26 13:10:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-iceclean-1614312439 LGD_BUYER = 남정아 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226130719 LGD_HASHDATA = 463485ce21037c7e7d2200c8bf172581 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202102261310132DAF7B6DEB6E268C990DF2B7A22A0F47E3EBF971 Mname = 남정아 Mcompany = 아이스크린 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = iceclean LGD_ESCROW_USEYN = N ========================2021-02-26 13:10:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226131013 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFH920 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 356908******5821 LGD_FINANCEAUTHNUM = 10479453 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 56db6344305cb2652b0e2221944a3b71 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210226131014 LGD_PCANCELSTR = 0 LGD_BUYER = 남정아 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022613101361219 LGD_BUYERID = LGD_OID = Direct-iceclean-1614312439 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-26 13:10:06======================== insert into mBoard_order set rOrdNo = 'Direct-iceclean-1614312439', AuthTy = 'card', memberId = 'iceclean', OrdNm ='남정아', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '아이스크린', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한JCB 356908******5821', rApprNo = 'mjsof2021022613101361219', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 13:10:06', InvoiceNum = '결제성공:Direct-iceclean-1614312439/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 13:10:06' ========================2021-02-26 13:10:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022613101361219' 0 = 1 cnt = 1 ========================2021-02-26 13:10:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'iceclean' 0 = iceclean Mid = iceclean 1 = 아이스크린 Mcompany = 아이스크린 2 = 1060342600 companyNum = 1060342600 3 = 031-726-7577 Mtel1 = 031-726-7577 4 = 010-2245-2352 Mhp = 010-2245-2352 ========================2021-02-26 13:10:06======================== select * from customers where id = 'iceclean' ========================2021-02-26 13:10:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('iceclean','2021-02-26 13:10:06','52500','55000','온라인','0') ========================2021-02-26 13:47:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1614314803 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226134643 LGD_HASHDATA = 701b1251526565cd16d1679047a869ef LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2021022613473116914B199022CD8CE54B0736D56D7C7C21F5815F Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2021-02-26 13:47:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226134732 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 고객님의 신용카드 한도가 부족하거나, 체크카드인 경우 통장잔액 부족입니다(1회사용한도초과) LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 8c101d5d6fd2751b1bf324a498f0f474 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210226134732 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022613473160291 LGD_BUYERID = LGD_OID = Direct-neotool-1614314803 LGD_RESPCODE = 0016 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2021-02-26 13:52:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1614314934 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226134854 LGD_HASHDATA = 336c67718a6e354b5c8d6adc81cf4514 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202102261352165D2E1BF8DD7EE172A31370DF227C5DA8C387EBB7 Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2021-02-26 13:52:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226135216 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******9945 LGD_FINANCEAUTHNUM = 49627751 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5d64658e2318aa6b1c8e05671f1194e7 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210226135217 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022613521661244 LGD_BUYERID = LGD_OID = Direct-neotool-1614314934 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 613521661229 ========================2021-02-26 13:52:09======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1614314934', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******9945', rApprNo = 'mjsof2021022613521661244', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 13:52:09', InvoiceNum = '결제성공:Direct-neotool-1614314934/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 13:52:09' ========================2021-02-26 13:52:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022613521661244' 0 = 1 cnt = 1 ========================2021-02-26 13:52:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2021-02-26 13:52:09======================== select * from customers where id = 'neotool' ========================2021-02-26 13:52:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2021-02-26 13:52:09','108000','110000','온라인','0') ========================2021-02-26 14:04:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-itbarcode-1614315795 LGD_BUYER = 원정현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226140315 LGD_HASHDATA = a7f1730a07f13fb57ba733f08818d7f9 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2021022614042410FB692868C1416A6292E671D3BD731689310D6D Mname = 원정현 Mcompany = 주식회사 아이티바코드시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = itbarcode LGD_ESCROW_USEYN = N ========================2021-02-26 14:04:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226140425 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558420******8729 LGD_FINANCEAUTHNUM = 49802983 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a09addbc7b0e184bfea103ff1118f8d5 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210226140425 LGD_PCANCELSTR = 0 LGD_BUYER = 원정현 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022614042461205 LGD_BUYERID = LGD_OID = Direct-itbarcode-1614315795 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 614042461280 ========================2021-02-26 14:04:17======================== insert into mBoard_order set rOrdNo = 'Direct-itbarcode-1614315795', AuthTy = 'card', memberId = 'itbarcode', OrdNm ='원정현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 아이티바코드시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리MASTER 558420******8729', rApprNo = 'mjsof2021022614042461205', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 14:04:17', InvoiceNum = '결제성공:Direct-itbarcode-1614315795/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 14:04:17' ========================2021-02-26 14:04:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022614042461205' 0 = 1 cnt = 1 ========================2021-02-26 14:04:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'itbarcode' 0 = itbarcode Mid = itbarcode 1 = 주식회사 아이티바코드시스템 Mcompany = 주식회사 아이티바코드시스템 2 = 131-86-42986 companyNum = 131-86-42986 3 = 032-251-5677 Mtel1 = 032-251-5677 4 = 010-9010-1158 Mhp = 010-9010-1158 ========================2021-02-26 14:04:17======================== select * from customers where id = 'itbarcode' ========================2021-02-26 14:04:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('itbarcode','2021-02-26 14:04:17','108000','110000','온라인','0') ========================2021-02-26 14:50:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jgh8807-1614318549 LGD_BUYER = 정가훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226144909 LGD_HASHDATA = 78c11c2d2d7e6886918e335dfdfe4dc0 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202102261450108265C4BBB16262ACC161CB739FB1A64BE7F3102A Mname = 정가훈 Mcompany = 정가훈유아교육사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jgh8807 LGD_ESCROW_USEYN = N ========================2021-02-26 14:50:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226145011 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = BAEARL LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 356297******2700 LGD_FINANCEAUTHNUM = 12006989 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 64bb4e5c61f2703d308cfda6a2961465 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210226145011 LGD_PCANCELSTR = 0 LGD_BUYER = 정가훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022614501060073 LGD_BUYERID = LGD_OID = Direct-jgh8807-1614318549 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-26 14:50:03======================== insert into mBoard_order set rOrdNo = 'Direct-jgh8807-1614318549', AuthTy = 'card', memberId = 'jgh8807', OrdNm ='정가훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '정가훈유아교육사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한JCB 356297******2700', rApprNo = 'mjsof2021022614501060073', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 14:50:03', InvoiceNum = '결제성공:Direct-jgh8807-1614318549/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 14:50:03' ========================2021-02-26 14:50:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022614501060073' 0 = 1 cnt = 1 ========================2021-02-26 14:50:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jgh8807' 0 = jgh8807 Mid = jgh8807 1 = 정가훈유아교육사 Mcompany = 정가훈유아교육사 2 = 3422800252 companyNum = 3422800252 3 = 010-3002-2008 Mtel1 = 010-3002-2008 4 = 010-3002-2008 Mhp = 010-3002-2008 ========================2021-02-26 14:50:03======================== select * from customers where id = 'jgh8807' ========================2021-02-26 14:50:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jgh8807','2021-02-26 14:50:03','220000','220000','온라인','0') ========================2021-02-26 14:54:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jungga8807-1614318805 LGD_BUYER = 정가훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226145325 LGD_HASHDATA = 26ad234bcb83d1497f3db4cba6d57a99 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202102261454222C8D47F61AAD235AEDA570288E3B456E745D0313 Mname = 정가훈 Mcompany = 정가 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jungga8807 LGD_ESCROW_USEYN = N ========================2021-02-26 14:54:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226145423 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = BAEARL LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 356297******2700 LGD_FINANCEAUTHNUM = 12065519 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3a35f0268429f87ae176a04c99c5cbbf LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210226145423 LGD_PCANCELSTR = 0 LGD_BUYER = 정가훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022614542260277 LGD_BUYERID = LGD_OID = Direct-jungga8807-1614318805 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-26 14:54:15======================== insert into mBoard_order set rOrdNo = 'Direct-jungga8807-1614318805', AuthTy = 'card', memberId = 'jungga8807', OrdNm ='정가훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '정가', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한JCB 356297******2700', rApprNo = 'mjsof2021022614542260277', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 14:54:15', InvoiceNum = '결제성공:Direct-jungga8807-1614318805/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 14:54:15' ========================2021-02-26 14:54:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022614542260277' 0 = 1 cnt = 1 ========================2021-02-26 14:54:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jungga8807' 0 = jungga8807 Mid = jungga8807 1 = 정가 Mcompany = 정가 2 = 2441001457 companyNum = 2441001457 3 = 010-3002-2008 Mtel1 = 010-3002-2008 4 = 010-3002-2008 Mhp = 010-3002-2008 ========================2021-02-26 14:54:15======================== select * from customers where id = 'jungga8807' ========================2021-02-26 14:54:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jungga8807','2021-02-26 14:54:15','108000','110000','온라인','0') ========================2021-02-26 16:13:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1614323531 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210226161211 LGD_HASHDATA = 4a73007fa52baf4a3a03670984a2de08 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20210226161402C299DB31918FF94891B6F7C7E3EB230C6E64AECB Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2021-02-26 16:13:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210226161403 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******0625 LGD_FINANCEAUTHNUM = 30027253 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4c1c6d2d50fafa8e3d3f56bc686e79c4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210226161403 LGD_PCANCELSTR = 0 LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021022616140361125 LGD_BUYERID = LGD_OID = Direct-lyj4819-1614323531 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 616140361168 ========================2021-02-26 16:13:56======================== insert into mBoard_order set rOrdNo = 'Direct-lyj4819-1614323531', AuthTy = 'card', memberId = 'lyj4819', OrdNm ='이영재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신성골재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******0625', rApprNo = 'mjsof2021022616140361125', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-26 16:13:56', InvoiceNum = '결제성공:Direct-lyj4819-1614323531/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-26 16:13:56' ========================2021-02-26 16:13:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021022616140361125' 0 = 1 cnt = 1 ========================2021-02-26 16:13:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lyj4819' 0 = lyj4819 Mid = lyj4819 1 = 신성골재 Mcompany = 신성골재 2 = 6603200410 companyNum = 6603200410 3 = 010-5453-7583 Mtel1 = 010-5453-7583 4 = 010-5453-7583 Mhp = 010-5453-7583 ========================2021-02-26 16:13:56======================== select * from customers where id = 'lyj4819' ========================2021-02-26 16:13:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lyj4819','2021-02-26 16:13:56','108000','110000','온라인','0')