========================2021-05-10 09:18:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-h00327-1620605834 LGD_BUYER = 문정민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510091714 LGD_HASHDATA = 21c9b86be163d621afc3c75078689a9a 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 = 20210510091843E15648A49B684256AA3307BD8912813AKW8AFJGD Mname = 문정민 Mcompany = (주)현대비아이디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = h00327 LGD_ESCROW_USEYN = N ========================2021-05-10 09:18:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510091844 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = DAF9C4 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941081******2698 LGD_FINANCEAUTHNUM = 38246180 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 534bedbc152ef7f809c78055bf11a8a7 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210510091844 LGD_PCANCELSTR = 0 LGD_BUYER = 문정민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051009184460160 LGD_BUYERID = LGD_OID = Direct-h00327-1620605834 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-10 09:18:41======================== insert into mBoard_order set rOrdNo = 'Direct-h00327-1620605834', AuthTy = 'card', memberId = 'h00327', OrdNm ='문정민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)현대비아이디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한 941081******2698', rApprNo = 'mjsof2021051009184460160', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 09:18:41', InvoiceNum = '결제성공:Direct-h00327-1620605834/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 09:18:41' ========================2021-05-10 09:18:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051009184460160' 0 = 1 cnt = 1 ========================2021-05-10 09:18:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'h00327' 0 = h00327 Mid = h00327 1 = (주)현대비아이디 Mcompany = (주)현대비아이디 2 = 6868100327 companyNum = 6868100327 3 = 032-426-3907 Mtel1 = 032-426-3907 4 = 010-6389-2099 Mhp = 010-6389-2099 ========================2021-05-10 09:18:41======================== select * from customers where id = 'h00327' ========================2021-05-10 09:18:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('h00327','2021-05-10 09:18:41','220000','220000','온라인','0') ========================2021-05-10 10:08:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-honamtpan-1620608887 LGD_BUYER = 임찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510100807 LGD_HASHDATA = f3452dc49b75652381c90c517d9b24be 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 = 2021051010085907770987401B43D995CCFB26FF9EB714OE7X9H09 Mname = 임찬 Mcompany = (주)더맑은컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = honamtpan LGD_ESCROW_USEYN = N ========================2021-05-10 10:08:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510100900 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 459952******9900 LGD_FINANCEAUTHNUM = 30358310 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 46100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1ddf4698afef477f52b3c19387bc849c LGD_BUYERADDRESS = LGD_FINANCENAME = 광주VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210510100900 LGD_PCANCELSTR = 0 LGD_BUYER = 임찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021051010085960289 LGD_BUYERID = LGD_OID = Direct-honamtpan-1620608887 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 101008280260 ========================2021-05-10 10:08:57======================== insert into mBoard_order set rOrdNo = 'Direct-honamtpan-1620608887', AuthTy = 'card', memberId = 'honamtpan', OrdNm ='임찬', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)더맑은컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '광주VISA 459952******9900', rApprNo = 'mjsof2021051010085960289', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 10:08:57', InvoiceNum = '결제성공:Direct-honamtpan-1620608887/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 10:08:57' ========================2021-05-10 10:08:58======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051010085960289' 0 = 1 cnt = 1 ========================2021-05-10 10:08:58======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'honamtpan' 0 = honamtpan Mid = honamtpan 1 = (주)더맑은컴퍼니 Mcompany = (주)더맑은컴퍼니 2 = 4098640412 companyNum = 4098640412 3 = 062-576-0261 Mtel1 = 062-576-0261 4 = 010-4604-5441 Mhp = 010-4604-5441 ========================2021-05-10 10:08:58======================== select * from customers where id = 'honamtpan' ========================2021-05-10 10:08:58======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('honamtpan','2021-05-10 10:08:57','108000','110000','온라인','0') ========================2021-05-10 14:44:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnamfs-1620625418 LGD_BUYER = 양원준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510144338 LGD_HASHDATA = 294194f4b1d1e615f579ded99e844b94 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 = 202105101444473790E172A4E54C2D8EC891E7B4CF9760NLR0BFWM Mname = 양원준 Mcompany = (주)동남에프에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = dongnamfs LGD_ESCROW_USEYN = N ========================2021-05-10 14:44:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510144448 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******3881 LGD_FINANCEAUTHNUM = 30093624 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b7276d8335ec1384a7c345c296bd58f4 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210510144448 LGD_PCANCELSTR = 0 LGD_BUYER = 양원준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051014444860289 LGD_BUYERID = LGD_OID = Direct-dongnamfs-1620625418 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 014444860224 ========================2021-05-10 14:44:45======================== insert into mBoard_order set rOrdNo = 'Direct-dongnamfs-1620625418', AuthTy = 'card', memberId = 'dongnamfs', OrdNm ='양원준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)동남에프에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민VISA 426586******3881', rApprNo = 'mjsof2021051014444860289', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 14:44:45', InvoiceNum = '결제성공:Direct-dongnamfs-1620625418/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 14:44:45' ========================2021-05-10 14:44:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051014444860289' 0 = 1 cnt = 1 ========================2021-05-10 14:44:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongnamfs' 0 = dongnamfs Mid = dongnamfs 1 = (주)동남에프에스 Mcompany = (주)동남에프에스 2 = 6078612053 companyNum = 6078612053 3 = 051-868-0114 Mtel1 = 051-868-0114 4 = 010-2056-3658 Mhp = 010-2056-3658 ========================2021-05-10 14:44:45======================== select * from customers where id = 'dongnamfs' ========================2021-05-10 14:44:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnamfs','2021-05-10 14:44:45','10000','11000','온라인','0') ========================2021-05-10 14:50:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dongnamfs-1620625745 LGD_BUYER = 양원준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510144905 LGD_HASHDATA = 9abb84d6a6a7d4b5ac76e82ee2e147d3 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 = 2021051014500481089FFE3F92460A90885328F7F41090R3LLZFNO Mname = 양원준 Mcompany = (주)동남에프에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = dongnamfs LGD_ESCROW_USEYN = N ========================2021-05-10 14:50:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510145005 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******3881 LGD_FINANCEAUTHNUM = 30093635 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = da05b4f2f2bdb41aaea9b99f01131c8d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210510145005 LGD_PCANCELSTR = 0 LGD_BUYER = 양원준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051014500461141 LGD_BUYERID = LGD_OID = Direct-dongnamfs-1620625745 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 014500461126 ========================2021-05-10 14:50:01======================== insert into mBoard_order set rOrdNo = 'Direct-dongnamfs-1620625745', AuthTy = 'card', memberId = 'dongnamfs', OrdNm ='양원준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)동남에프에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민VISA 426586******3881', rApprNo = 'mjsof2021051014500461141', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 14:50:01', InvoiceNum = '결제성공:Direct-dongnamfs-1620625745/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 14:50:01' ========================2021-05-10 14:50:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051014500461141' 0 = 1 cnt = 1 ========================2021-05-10 14:50:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dongnamfs' 0 = dongnamfs Mid = dongnamfs 1 = (주)동남에프에스 Mcompany = (주)동남에프에스 2 = 6078612053 companyNum = 6078612053 3 = 051-868-0114 Mtel1 = 051-868-0114 4 = 010-2056-3658 Mhp = 010-2056-3658 ========================2021-05-10 14:50:02======================== select * from customers where id = 'dongnamfs' ========================2021-05-10 14:50:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dongnamfs','2021-05-10 14:50:01','10000','11000','온라인','0') ========================2021-05-10 15:47:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samjinsa-1620629204 LGD_BUYER = 이상곤 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510154644 LGD_HASHDATA = ce0525e41f7808e45213c80477d60013 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 = 20210510154740AE3314D6C5E24C00A1E27118596776B1SXMFNLWP Mname = 이상곤 Mcompany = 삼진사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = samjinsa LGD_ESCROW_USEYN = N ========================2021-05-10 15:47:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510154740 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = AFG03J LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941061******9736 LGD_FINANCEAUTHNUM = 45226716 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = dbdb809ecfee841b7de59de453b0fec9 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210510154741 LGD_PCANCELSTR = 0 LGD_BUYER = 이상곤 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051015474061055 LGD_BUYERID = LGD_OID = Direct-samjinsa-1620629204 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-10 15:47:38======================== insert into mBoard_order set rOrdNo = 'Direct-samjinsa-1620629204', AuthTy = 'card', memberId = 'samjinsa', OrdNm ='이상곤', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼진사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한 941061******9736', rApprNo = 'mjsof2021051015474061055', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 15:47:38', InvoiceNum = '결제성공:Direct-samjinsa-1620629204/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 15:47:38' ========================2021-05-10 15:47:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051015474061055' 0 = 1 cnt = 1 ========================2021-05-10 15:47:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samjinsa' 0 = samjinsa Mid = samjinsa 1 = 삼진사 Mcompany = 삼진사 2 = 104-05-20579 companyNum = 104-05-20579 3 = 02-2267-5468 Mtel1 = 02-2267-5468 4 = 010-5899-5468 Mhp = 010-5899-5468 ========================2021-05-10 15:47:38======================== select * from customers where id = 'samjinsa' ========================2021-05-10 15:47:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samjinsa','2021-05-10 15:47:38','52500','55000','온라인','0') ========================2021-05-10 19:23:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pro5500-1620642182 LGD_BUYER = 최원철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510192302 LGD_HASHDATA = 6033440d348de042099ff2aadcef5dac 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 = 202105101924021F24CD7214494960AFB8705355C3AFB3S3EPKNJA Mname = 최원철 Mcompany = 대원화장품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = pro5500 LGD_ESCROW_USEYN = N ========================2021-05-10 19:23:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510192402 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558420******0365 LGD_FINANCEAUTHNUM = 35788704 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 506fe50ac1af9d2e60a84358d0ca5fed LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210510192403 LGD_PCANCELSTR = 0 LGD_BUYER = 최원철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051019240260199 LGD_BUYERID = LGD_OID = Direct-pro5500-1620642182 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 019240260193 ========================2021-05-10 19:23:59======================== insert into mBoard_order set rOrdNo = 'Direct-pro5500-1620642182', AuthTy = 'card', memberId = 'pro5500', OrdNm ='최원철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대원화장품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리MASTER 558420******0365', rApprNo = 'mjsof2021051019240260199', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 19:23:59', InvoiceNum = '결제성공:Direct-pro5500-1620642182/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 19:23:59' ========================2021-05-10 19:24:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051019240260199' 0 = 1 cnt = 1 ========================2021-05-10 19:24:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pro5500' 0 = pro5500 Mid = pro5500 1 = 대원화장품 Mcompany = 대원화장품 2 = 106-08-30787 companyNum = 106-08-30787 3 = 02-3272-5500 Mtel1 = 02-3272-5500 4 = 010-2054-4385 Mhp = 010-2054-4385 ========================2021-05-10 19:24:00======================== select * from customers where id = 'pro5500' ========================2021-05-10 19:24:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pro5500','2021-05-10 19:23:59','10000','11000','온라인','0') ========================2021-05-10 21:25:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isaac13-1620649426 LGD_BUYER = 이성현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510212346 LGD_HASHDATA = a38ef9735f086ba7786a63032e6562c4 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 = 202105102125080306C639D5F149C3A9F1803A41C28974M5TDAK6X Mname = 이성현 Mcompany = 이삭종로 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = isaac13 LGD_ESCROW_USEYN = N ========================2021-05-10 21:25:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510212509 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 229739 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910020******5220 LGD_FINANCEAUTHNUM = 36527889 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 354391c702795ec56822c37f932d5e01 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210510212509 LGD_PCANCELSTR = 0 LGD_BUYER = 이성현 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051021250960026 LGD_BUYERID = LGD_OID = Direct-isaac13-1620649426 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 021250960002 ========================2021-05-10 21:25:06======================== insert into mBoard_order set rOrdNo = 'Direct-isaac13-1620649426', AuthTy = 'card', memberId = 'isaac13', OrdNm ='이성현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이삭종로', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '우리 910020******5220', rApprNo = 'mjsof2021051021250960026', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 21:25:06', InvoiceNum = '결제성공:Direct-isaac13-1620649426/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 21:25:06' ========================2021-05-10 21:25:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051021250960026' 0 = 1 cnt = 1 ========================2021-05-10 21:25:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isaac13' 0 = isaac13 Mid = isaac13 1 = 이삭종로 Mcompany = 이삭종로 2 = 6741000964 companyNum = 6741000964 3 = 010-9160-3382 Mtel1 = 010-9160-3382 4 = 010-9160-3382 Mhp = 010-9160-3382 ========================2021-05-10 21:25:06======================== select * from customers where id = 'isaac13' ========================2021-05-10 21:25:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isaac13','2021-05-10 21:25:06','108000','110000','온라인','0') ========================2021-05-10 21:54:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nowonbb-1620650848 LGD_BUYER = 정동호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210510214728 LGD_HASHDATA = 8399802dc72233363420fe17b6a33942 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 = 202105102154219EDFE4EAEEBA4280999D70DBAAF9EDAERW9JNPHB Mname = 정동호 Mcompany = 굿라이스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nowonbb LGD_ESCROW_USEYN = N ========================2021-05-10 21:54:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210510215421 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 = 512635******8228 LGD_FINANCEAUTHNUM = 41167247 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fded1e1e79a72f33037e68c0140bed03 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20210510215421 LGD_PCANCELSTR = 0 LGD_BUYER = 정동호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021051021542160041 LGD_BUYERID = LGD_OID = Direct-nowonbb-1620650848 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-05-10 21:54:18======================== insert into mBoard_order set rOrdNo = 'Direct-nowonbb-1620650848', AuthTy = 'card', memberId = 'nowonbb', OrdNm ='정동호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '굿라이스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데MASTER 512635******8228', rApprNo = 'mjsof2021051021542160041', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-05-10 21:54:18', InvoiceNum = '결제성공:Direct-nowonbb-1620650848/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-05-10 21:54:18' ========================2021-05-10 21:54:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021051021542160041' 0 = 1 cnt = 1 ========================2021-05-10 21:54:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nowonbb' 0 = nowonbb Mid = nowonbb 1 = 굿라이스 Mcompany = 굿라이스 2 = 3260300811 companyNum = 3260300811 3 = 010-9782-3337 Mtel1 = 010-9782-3337 4 = 010-9782-3337 Mhp = 010-9782-3337 ========================2021-05-10 21:54:18======================== select * from customers where id = 'nowonbb' ========================2021-05-10 21:54:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nowonbb','2021-05-10 21:54:18','52500','55000','온라인','0')