========================2021-02-09 10:45:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1612835056 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209104416 LGD_HASHDATA = 22f819aaf564d08e1e083892b076b737 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 = 202102091045200E4293038D992C91DF5809D5DAE8242506BEC2B3 Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2021-02-09 10:45:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209104521 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 393487 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 538839******4647 LGD_FINANCEAUTHNUM = 44926830 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9c4994fe47a778f4a985c33fc98280aa LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210209104521 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020910452061137 LGD_BUYERID = LGD_OID = Direct-woorimart-1612835056 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 910452061159 ========================2021-02-09 10:45:16======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1612835056', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 538839******4647', rApprNo = 'mjsof2021020910452061137', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 10:45:16', InvoiceNum = '결제성공:Direct-woorimart-1612835056/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 10:45:16' ========================2021-02-09 10:45:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020910452061137' 0 = 1 cnt = 1 ========================2021-02-09 10:45:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2021-02-09 10:45:17======================== select * from customers where id = 'woorimart' ========================2021-02-09 10:45:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2021-02-09 10:45:16','220000','220000','온라인','0') ========================2021-02-09 11:17:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-blueseafood2-1612836710 LGD_BUYER = 곽동원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209111150 LGD_HASHDATA = c7a0db3ee99bb6fe18f5ada301b6ebea 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 = 20210209111722D8C033D1A51A109E0983CCC673B7DB68A1F301AC Mname = 곽동원 Mcompany = (주)블루씨푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = blueseafood2 LGD_ESCROW_USEYN = N ========================2021-02-09 11:17:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209111723 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943032******7916 LGD_FINANCEAUTHNUM = 45089064 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d323b15e7c4e0380ac118bb165bf9c4e LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210209111724 LGD_PCANCELSTR = 0 LGD_BUYER = 곽동원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020911172360263 LGD_BUYERID = LGD_OID = Direct-blueseafood2-1612836710 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 911172360263 ========================2021-02-09 11:17:19======================== insert into mBoard_order set rOrdNo = 'Direct-blueseafood2-1612836710', AuthTy = 'card', memberId = 'blueseafood2', OrdNm ='곽동원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)블루씨푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943032******7916', rApprNo = 'mjsof2021020911172360263', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 11:17:19', InvoiceNum = '결제성공:Direct-blueseafood2-1612836710/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 11:17:19' ========================2021-02-09 11:17:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020911172360263' 0 = 1 cnt = 1 ========================2021-02-09 11:17:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'blueseafood2' 0 = blueseafood2 Mid = blueseafood2 1 = (주)블루씨푸드 Mcompany = (주)블루씨푸드 2 = 5478700548 companyNum = 5478700548 3 = 051-256-7005 Mtel1 = 051-256-7005 4 = 010-0000-0000 Mhp = 010-0000-0000 ========================2021-02-09 11:17:19======================== select * from customers where id = 'blueseafood2' ========================2021-02-09 11:17:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('blueseafood2','2021-02-09 11:17:19','220000','220000','온라인','0') ========================2021-02-09 14:04:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isaac1-1612846950 LGD_BUYER = 김주형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209140230 LGD_HASHDATA = e95f4581753878c864c044a7a3a2faf8 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 = 20210209140443E2542F44F50ADCA7410995E34747AA51683BC07A Mname = 김주형 Mcompany = 논현이삭 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = isaac1 LGD_ESCROW_USEYN = N ========================2021-02-09 14:04:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209140444 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 536648******0185 LGD_FINANCEAUTHNUM = 45242476 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f48f0ebfc79773bc5daa2403b365b135 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210209140444 LGD_PCANCELSTR = 0 LGD_BUYER = 김주형 LGD_CARDINSTALLMONTH = 02 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020914044460011 LGD_BUYERID = LGD_OID = Direct-isaac1-1612846950 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-09 14:04:40======================== insert into mBoard_order set rOrdNo = 'Direct-isaac1-1612846950', AuthTy = 'card', memberId = 'isaac1', OrdNm ='김주형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '논현이삭', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 536648******0185', rApprNo = 'mjsof2021020914044460011', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 14:04:40', InvoiceNum = '결제성공:Direct-isaac1-1612846950/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 14:04:40' ========================2021-02-09 14:04:40======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020914044460011' 0 = 1 cnt = 1 ========================2021-02-09 14:04:40======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isaac1' 0 = isaac1 Mid = isaac1 1 = 논현이삭 Mcompany = 논현이삭 2 = 612-15-62007 companyNum = 612-15-62007 3 = 010-9146-3382 Mtel1 = 010-9146-3382 4 = 010-9146-3382 Mhp = 010-9146-3382 ========================2021-02-09 14:04:40======================== select * from customers where id = 'isaac1' ========================2021-02-09 14:04:40======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isaac1','2021-02-09 14:04:40','108000','110000','온라인','0') ========================2021-02-09 15:04:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-qnffnans-1612850656 LGD_BUYER = 강민철 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209150416 LGD_HASHDATA = e20728641abfdaf13f1f1d6c28406f91 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 = 20210209150500084FAE80C60343E850147530A81F768122AA3736 Mname = 강민철 Mcompany = (주)깜장수레푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = qnffnans LGD_ESCROW_USEYN = N ========================2021-02-09 15:04:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209150500 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = DAA6B6 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 451844******3546 LGD_FINANCEAUTHNUM = 41668602 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 13c18b89aecb1c19751c658845a6ce5f LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210209150501 LGD_PCANCELSTR = 0 LGD_BUYER = 강민철 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020915050061134 LGD_BUYERID = LGD_OID = Direct-qnffnans-1612850656 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-09 15:04:56======================== insert into mBoard_order set rOrdNo = 'Direct-qnffnans-1612850656', AuthTy = 'card', memberId = 'qnffnans', OrdNm ='강민철', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)깜장수레푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한VISA 451844******3546', rApprNo = 'mjsof2021020915050061134', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 15:04:56', InvoiceNum = '결제성공:Direct-qnffnans-1612850656/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 15:04:56' ========================2021-02-09 15:04:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020915050061134' 0 = 1 cnt = 1 ========================2021-02-09 15:04:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'qnffnans' 0 = qnffnans Mid = qnffnans 1 = (주)깜장수레푸드 Mcompany = (주)깜장수레푸드 2 = 1638801142 companyNum = 1638801142 3 = 033-644-4051 Mtel1 = 033-644-4051 4 = 010-3949-4051 Mhp = 010-3949-4051 ========================2021-02-09 15:04:56======================== select * from customers where id = 'qnffnans' ========================2021-02-09 15:04:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('qnffnans','2021-02-09 15:04:56','52500','55000','온라인','0') ========================2021-02-09 15:05:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yth3339_1-1612850687 LGD_BUYER = 유태환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209150447 LGD_HASHDATA = f78deb0687cd1aeb898851e91b6f0736 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 = 20210209150532808B65B8A16C2F479DB327E4DF7C0F92A186C758 Mname = 유태환 Mcompany = (주)다복유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yth3339_1 LGD_ESCROW_USEYN = N ========================2021-02-09 15:05:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209150532 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 426586******9023 LGD_FINANCEAUTHNUM = 30020860 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cae44a3c4c5d9df6c4ead9baff46f3cc LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210209150532 LGD_PCANCELSTR = 0 LGD_BUYER = 유태환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020915053261227 LGD_BUYERID = LGD_OID = Direct-yth3339_1-1612850687 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-09 15:05:28======================== insert into mBoard_order set rOrdNo = 'Direct-yth3339_1-1612850687', AuthTy = 'card', memberId = 'yth3339_1', OrdNm ='유태환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다복유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 426586******9023', rApprNo = 'mjsof2021020915053261227', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 15:05:28', InvoiceNum = '결제성공:Direct-yth3339_1-1612850687/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 15:05:28' ========================2021-02-09 15:05:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020915053261227' 0 = 1 cnt = 1 ========================2021-02-09 15:05:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yth3339_1' 0 = yth3339_1 Mid = yth3339_1 1 = (주)다복유통 Mcompany = (주)다복유통 2 = 5418700763 companyNum = 5418700763 3 = 010-2679-3339 Mtel1 = 010-2679-3339 4 = 010-2679-3339 Mhp = 010-2679-3339 ========================2021-02-09 15:05:28======================== select * from customers where id = 'yth3339_1' ========================2021-02-09 15:05:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yth3339_1','2021-02-09 15:05:28','52500','55000','온라인','0') ========================2021-02-09 16:04:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hyy7975-1612853877 LGD_BUYER = 금화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209155757 LGD_HASHDATA = 2cfffddfaa5aee73ea576acde7b6a14b 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 = 20210209160449AE7FA305C522257C468E377F1F7A7E7824D82BB5 Mname = 금화 Mcompany = 금화 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = hyy7975 LGD_ESCROW_USEYN = N ========================2021-02-09 16:04:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209160449 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 = 540497******3922 LGD_FINANCEAUTHNUM = 29754395 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d2296e1a8a8c941910c769a92725b48d LGD_BUYERADDRESS = LGD_FINANCENAME = 외환MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20210209160449 LGD_PCANCELSTR = 0 LGD_BUYER = 금화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020916044960190 LGD_BUYERID = LGD_OID = Direct-hyy7975-1612853877 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-09 16:04:45======================== insert into mBoard_order set rOrdNo = 'Direct-hyy7975-1612853877', AuthTy = 'card', memberId = 'hyy7975', OrdNm ='금화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금화', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '외환MASTER 540497******3922', rApprNo = 'mjsof2021020916044960190', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 16:04:45', InvoiceNum = '결제성공:Direct-hyy7975-1612853877/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 16:04:45' ========================2021-02-09 16:04:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020916044960190' 0 = 1 cnt = 1 ========================2021-02-09 16:04:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hyy7975' 0 = hyy7975 Mid = hyy7975 1 = 금화 Mcompany = 금화 2 = 3058193820 companyNum = 3058193820 3 = 042-626-8001 Mtel1 = 042-626-8001 4 = 010-2512-7975 Mhp = 010-2512-7975 ========================2021-02-09 16:04:45======================== select * from customers where id = 'hyy7975' ========================2021-02-09 16:04:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hyy7975','2021-02-09 16:04:45','10000','11000','온라인','0') ========================2021-02-09 16:21:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samcoppy-1612855188 LGD_BUYER = 이은숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209161948 LGD_HASHDATA = a6c75398a5c4c1f66f1edebf2fc6a3e1 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 = 202102091621462FB0346E88D74F4E112C3A328489438AE3983A35 Mname = 이은숙 Mcompany = 삼성인쇄사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = samcoppy LGD_ESCROW_USEYN = N ========================2021-02-09 16:21:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209162146 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 = 379183******501 LGD_FINANCEAUTHNUM = 16970608 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b29082e01d3219bacda91d4a52a17a7b LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210209162147 LGD_PCANCELSTR = 0 LGD_BUYER = 이은숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020916214660260 LGD_BUYERID = LGD_OID = Direct-samcoppy-1612855188 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-09 16:21:42======================== insert into mBoard_order set rOrdNo = 'Direct-samcoppy-1612855188', AuthTy = 'card', memberId = 'samcoppy', OrdNm ='이은숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼성인쇄사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성AMEX 379183******501', rApprNo = 'mjsof2021020916214660260', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 16:21:42', InvoiceNum = '결제성공:Direct-samcoppy-1612855188/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 16:21:42' ========================2021-02-09 16:21:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020916214660260' 0 = 1 cnt = 1 ========================2021-02-09 16:21:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samcoppy' 0 = samcoppy Mid = samcoppy 1 = 삼성인쇄사 Mcompany = 삼성인쇄사 2 = 6030748291 companyNum = 6030748291 3 = 051-292-5142 Mtel1 = 051-292-5142 4 = 010-9394-0111 Mhp = 010-9394-0111 ========================2021-02-09 16:21:42======================== select * from customers where id = 'samcoppy' ========================2021-02-09 16:21:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samcoppy','2021-02-09 16:21:42','52500','55000','온라인','0') ========================2021-02-09 23:59:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gksmf919-1612882689 LGD_BUYER = 차하늘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210209235809 LGD_HASHDATA = 4fdbd3b31b70570f8b510ce0b479f08b 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 = 202102092359087335602DA5C5BCCF83A9BEBEA5A4D4337864722C Mname = 차하늘 Mcompany = 대한유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = gksmf919 LGD_ESCROW_USEYN = N ========================2021-02-09 23:59:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210209235909 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 000069 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 536883******6225 LGD_FINANCEAUTHNUM = 49984779 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = d64cf3b8e6d869da9ff1fcd3aa6dbc34 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210209235910 LGD_PCANCELSTR = 0 LGD_BUYER = 차하늘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021020923590860223 LGD_BUYERID = LGD_OID = Direct-gksmf919-1612882689 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 092359611392 ========================2021-02-09 23:59:05======================== insert into mBoard_order set rOrdNo = 'Direct-gksmf919-1612882689', AuthTy = 'card', memberId = 'gksmf919', OrdNm ='차하늘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대한유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨MASTER 536883******6225', rApprNo = 'mjsof2021020923590860223', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-09 23:59:05', InvoiceNum = '결제성공:Direct-gksmf919-1612882689/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-09 23:59:05' ========================2021-02-09 23:59:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020923590860223' 0 = 1 cnt = 1 ========================2021-02-09 23:59:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gksmf919' 0 = gksmf919 Mid = gksmf919 1 = 대한유통 Mcompany = 대한유통 2 = companyNum = 3 = 010-5147-5197 Mtel1 = 010-5147-5197 4 = -- Mhp = -- ========================2021-02-09 23:59:05======================== select * from customers where id = 'gksmf919' ========================2021-02-09 23:59:05======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('gksmf919','대한유통','','010-5147-5197','--','2021-02-09 23:59:05','온라인') ========================2021-02-09 23:59:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gksmf919','2021-02-09 23:59:05','220000','220000','온라인','0')