========================2019-08-05 11:39:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart2-1564972661 LGD_BUYER = 류성수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = womart2266@naver.com LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20190805113741 LGD_HASHDATA = a052824e85058ce1e8b3f8639e43d53d LGD_RETURNURL = http://www.mjmall.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://www.mjmall.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 201908051139483C7A9FE609A3AA026FB5A53703BBC722BE19DEFD Mname = 류성수 Mcompany = (주)우리유통식자재속천점 post1 = 645 post2 = 020 Madd = 경남 진해시 태평동 86-52 tel1 = 055 tel2 = 542 tel3 = 2266 hp1 = 010 hp2 = 2594 hp3 = 7327 Memail = womart2266@naver.com f_price = 110000 f_point = 108000 SendItem = UserId = woorimart2 LGD_ESCROW_USEYN = N ========================2019-08-05 11:39:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20190805113949 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = womart2266@naver.com 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******0861 LGD_FINANCEAUTHNUM = 46864900 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6c94e8c5cbaff6c6ac7b7465346d0fb0 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20190805113949 LGD_PCANCELSTR = 0 LGD_BUYER = 류성수 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2019080511394851225 LGD_BUYERID = LGD_OID = Direct-woorimart2-1564972661 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 511394851259 ========================2019-08-05 11:39:46======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart2-1564972661', AuthTy = 'card', memberId = 'woorimart2', OrdNm ='류성수', OrdPhone = '055-542-2266', OrdPhone2 = '010-2594-7327', UserEmail = 'womart2266@naver.com', DlvAddr = '경남 진해시 태평동 86-52', DlvPost = '645020', OrdComp = '(주)우리유통식자재속천점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 538839******0861', rApprNo = 'mjsof2019080511394851225', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2019-08-05 11:39:46', InvoiceNum = '결제성공:Direct-woorimart2-1564972661/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2019-08-05 11:39:46' ========================2019-08-05 11:39:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2019080511394851225' 0 = 1 cnt = 1 ========================2019-08-05 11:39:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart2' 0 = woorimart2 Mid = woorimart2 1 = (주)우리유통식자재속천점 Mcompany = (주)우리유통식자재속천점 2 = 6098513764 companyNum = 6098513764 3 = 055-542-2266 Mtel1 = 055-542-2266 4 = 010-2594-7327 Mhp = 010-2594-7327 ========================2019-08-05 11:39:46======================== select * from customers where id = 'woorimart2' ========================2019-08-05 11:39:46======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('woorimart2','(주)우리유통식자재속천점','6098513764','055-542-2266','010-2594-7327','2019-08-05 11:39:46','온라인') ========================2019-08-05 11:39:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart2','2019-08-05 11:39:46','108000','110000','온라인','0') ========================2019-08-05 17:20:07======================== res_start CST_PLATFORM = test LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = tmjsoft007 LGD_OID = Direct-ryunen-1564993110 LGD_BUYER = 박성원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = ryunen@naver.com1 LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20190805171830 LGD_HASHDATA = c52a70571e380e726a624ffd34a2e543 LGD_RETURNURL = http://mjmall.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://mjmall.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20190805172010478737443964547AEE1A4C16BFA63854F28D546D Mname = 박성원 Mcompany = MJSOFT1 post1 = 42019 post2 = Madd = 대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1 tel1 = 053 tel2 = 743 tel3 = 5122 hp1 = 010 hp2 = 9357 hp3 = 0525 Memail = ryunen@naver.com1 f_price = 11000 f_point = 10000 SendItem = UserId = ryunen LGD_ESCROW_USEYN = N ========================2019-08-05 17:20:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20190805172011 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ryunen@naver.com1 LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 552194******2462 LGD_FINANCEAUTHNUM = 00000000 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a02de0e5e957727806a05dacd67f8f9e LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20190805172011 LGD_PCANCELSTR = 0 LGD_BUYER = 박성원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = tmjso2019080517201090148 LGD_BUYERID = LGD_OID = Direct-ryunen-1564993110 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = tmjsoft007 ========================2019-08-05 17:20:07======================== insert into mBoard_order set rOrdNo = 'Direct-ryunen-1564993110', AuthTy = 'card', memberId = 'ryunen', OrdNm ='박성원', OrdPhone = '053-743-5122', OrdPhone2 = '010-9357-0525', UserEmail = 'ryunen@naver.com1', DlvAddr = '대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1', DlvPost = '42019', OrdComp = 'MJSOFT1', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성MASTER 552194******2462', rApprNo = 'tmjso2019080517201090148', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2019-08-05 17:20:07', InvoiceNum = '결제성공:Direct-ryunen-1564993110/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2019-08-05 17:20:07' ========================2019-08-05 17:20:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'tmjso2019080517201090148' 0 = 1 cnt = 1 ========================2019-08-05 17:20:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ryunen' 0 = ryunen Mid = ryunen 1 = MJSOFT1 Mcompany = MJSOFT1 2 = 502-18-94746 companyNum = 502-18-94746 3 = 053-743-5122 Mtel1 = 053-743-5122 4 = 010-9357-0525 Mhp = 010-9357-0525 ========================2019-08-05 17:20:07======================== select * from customers where id = 'ryunen' ========================2019-08-05 17:20:07======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('ryunen','MJSOFT1','5021894746','053-743-5122','010-9357-0525','2019-08-05 17:20:07','온라인') ========================2019-08-05 17:20:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ryunen','2019-08-05 17:20:07','10000','11000','온라인','0') ========================2019-08-05 17:31:07======================== res_start CST_PLATFORM = test LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = tmjsoft007 LGD_OID = Direct-ryunen-1564993801 LGD_BUYER = 박성원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = ryunen@naver.com1 LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20190805173001 LGD_HASHDATA = 6fc33d35ca967c3b7d5e20cf99508494 LGD_RETURNURL = http://mjmall.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://mjmall.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20190805173111F1D6D30B6C49AA088A33CE06A1125732AA83461D Mname = 박성원 Mcompany = MJSOFT1 post1 = 42019 post2 = Madd = 대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1 tel1 = 053 tel2 = 743 tel3 = 5122 hp1 = 010 hp2 = 9357 hp3 = 0525 Memail = ryunen@naver.com1 f_price = 11000 f_point = 10000 SendItem = UserId = ryunen LGD_ESCROW_USEYN = N ========================2019-08-05 17:31:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20190805173111 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = ryunen@naver.com1 LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 552194******2462 LGD_FINANCEAUTHNUM = 00000000 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a134e9b0883b071ecbf697a200e89fc4 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20190805173111 LGD_PCANCELSTR = 0 LGD_BUYER = 박성원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = tmjso2019080517311190158 LGD_BUYERID = LGD_OID = Direct-ryunen-1564993801 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = tmjsoft007 ========================2019-08-05 17:31:08======================== insert into mBoard_order set rOrdNo = 'Direct-ryunen-1564993801', AuthTy = 'card', memberId = 'ryunen', OrdNm ='박성원', OrdPhone = '053-743-5122', OrdPhone2 = '010-9357-0525', UserEmail = 'ryunen@naver.com1', DlvAddr = '대구 수성구 동대구로 331 (범어동, 청효정빌딩) 1', DlvPost = '42019', OrdComp = 'MJSOFT1', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성MASTER 552194******2462', rApprNo = 'tmjso2019080517311190158', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2019-08-05 17:31:08', InvoiceNum = '결제성공:Direct-ryunen-1564993801/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2019-08-05 17:31:08' ========================2019-08-05 17:31:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'tmjso2019080517311190158' 0 = 1 cnt = 1 ========================2019-08-05 17:31:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ryunen' 0 = ryunen Mid = ryunen 1 = MJSOFT1 Mcompany = MJSOFT1 2 = 502-18-94746 companyNum = 502-18-94746 3 = 053-743-5122 Mtel1 = 053-743-5122 4 = 010-9357-0525 Mhp = 010-9357-0525 ========================2019-08-05 17:31:08======================== select * from customers where id = 'ryunen' ========================2019-08-05 17:31:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ryunen','2019-08-05 17:31:08','10000','11000','온라인','0')