========================2022-08-31 13:30:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tns1-1661920110 LGD_BUYER = 진규옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220831132830 LGD_HASHDATA = 6af1916342e03a19feae4a47355680a1 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220831133311C8497076D6102F97161E3D6D2D6D8D86F6FC0DBC Mname = 진규옥 Mcompany = (주)티앤드에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = tns1 LGD_ESCROW_USEYN = N ========================2022-08-31 13:30:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220831133311 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = TNS-1@NAVER.COM LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****161* LGD_FINANCEAUTHNUM = 44202292 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f777442229a3d0b42cf235c2035dbb13 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220831133312 LGD_PCANCELSTR = 0 LGD_BUYER = 진규옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220831133311BkKg8 LGD_BUYERID = LGD_OID = Direct-tns1-1661920110 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1133311BhC15 ========================2022-08-31 13:35:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jwon-1661920501 LGD_BUYER = 태재원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220831133501 LGD_HASHDATA = e6dad7b7448137e147d38173623ad908 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220831133814A3B9A7440248D990096B28D375A8D4127391C012 Mname = 태재원 Mcompany = 제이원 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jwon LGD_ESCROW_USEYN = N ========================2022-08-31 13:35:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220831133815 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031749 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91000300****310* LGD_FINANCEAUTHNUM = 44228485 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 805aae9e1c1005d66a68f0dfee0c3f11 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220831133815 LGD_PCANCELSTR = 0 LGD_BUYER = 태재원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220831133815IgOQ6 LGD_BUYERID = LGD_OID = Direct-jwon-1661920501 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1133815IQJS2 ========================2022-08-31 13:35:55======================== insert into mBoard_order set rOrdNo = 'Direct-jwon-1661920501', AuthTy = 'card', memberId = 'jwon', OrdNm ='태재원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이원', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨 91000300****310*', rApprNo = 'mjsof20220831133815IgOQ6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-31 13:35:55', InvoiceNum = '결제성공:Direct-jwon-1661920501/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-31 13:35:55' ========================2022-08-31 13:35:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220831133815IgOQ6' 0 = 1 cnt = 1 ========================2022-08-31 13:35:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jwon' 0 = jwon Mid = jwon 1 = 제이원 Mcompany = 제이원 2 = 609-20-85935 companyNum = 609-20-85935 3 = 055-237-3280 Mtel1 = 055-237-3280 4 = 010-6567-3281 Mhp = 010-6567-3281 ========================2022-08-31 13:35:55======================== select * from customers where id = 'jwon' ========================2022-08-31 13:35:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jwon','2022-08-31 13:35:55','30900','33000','온라인','0') ========================2022-08-31 14:29:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-parkco6338-1661923708 LGD_BUYER = 박재호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220831142828 LGD_HASHDATA = efa8f1e94b1ac77890bcb8e2b5e98d7b LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2022083114313321C0C828B774CF6C33D67D5A90CA82A2D5D91093 Mname = 박재호 Mcompany = 주식회사 극광 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = parkco6338 LGD_ESCROW_USEYN = N ========================2022-08-31 14:29:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220831143134 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003397 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 52297100****685* LGD_FINANCEAUTHNUM = 30036999 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6c826cc89d6751d8cff3688d8da3489d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220831143134 LGD_PCANCELSTR = 0 LGD_BUYER = 박재호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220831143133FaKF3 LGD_BUYERID = LGD_OID = Direct-parkco6338-1661923708 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1143133FyHY2 ========================2022-08-31 14:29:13======================== insert into mBoard_order set rOrdNo = 'Direct-parkco6338-1661923708', AuthTy = 'card', memberId = 'parkco6338', OrdNm ='박재호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 극광', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 52297100****685*', rApprNo = 'mjsof20220831143133FaKF3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-31 14:29:13', InvoiceNum = '결제성공:Direct-parkco6338-1661923708/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-31 14:29:13' ========================2022-08-31 14:29:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220831143133FaKF3' 0 = 1 cnt = 1 ========================2022-08-31 14:29:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'parkco6338' 0 = parkco6338 Mid = parkco6338 1 = 주식회사 극광 Mcompany = 주식회사 극광 2 = 5068166232 companyNum = 5068166232 3 = 010-8581-1957 Mtel1 = 010-8581-1957 4 = 010-8581-1957 Mhp = 010-8581-1957 ========================2022-08-31 14:29:13======================== select * from customers where id = 'parkco6338' ========================2022-08-31 14:29:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('parkco6338','2022-08-31 14:29:13','220000','220000','온라인','0') ========================2022-08-31 17:29:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-thevise-1661934490 LGD_BUYER = 최대영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220831172810 LGD_HASHDATA = ebb4bda4d74828e8dac3091eb7116b83 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl_nosess.php LGD_VERSION = PHP_Non-ActiveX_Standard LGD_CUSTOM_USABLEPAY = SC0010,SC0030,SC0040 LGD_CUSTOM_SWITCHINGTYPE = IFRAME LGD_OSTYPE_CHECK = P LGD_WINDOW_VER = 2.5 LGD_CASNOTEURL = http://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20220831173120B3977968C364ACCEC1DD5BE829ED81D2A820E632 Mname = 최대영 Mcompany = 더바이스산업공구상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = thevise LGD_ESCROW_USEYN = N ========================2022-08-31 17:29:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220831173121 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 47386799****399* LGD_FINANCEAUTHNUM = 75248027 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bde1e7f7361d0553f5d162a6c709765c LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20220831173121 LGD_PCANCELSTR = 0 LGD_BUYER = 최대영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20220831173121sfc15 LGD_BUYERID = LGD_OID = Direct-thevise-1661934490 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-08-31 17:29:01======================== insert into mBoard_order set rOrdNo = 'Direct-thevise-1661934490', AuthTy = 'card', memberId = 'thevise', OrdNm ='최대영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '더바이스산업공구상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 47386799****399*', rApprNo = 'mjsof20220831173121sfc15', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-08-31 17:29:01', InvoiceNum = '결제성공:Direct-thevise-1661934490/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-08-31 17:29:01' ========================2022-08-31 17:29:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220831173121sfc15' 0 = 1 cnt = 1 ========================2022-08-31 17:29:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'thevise' 0 = thevise Mid = thevise 1 = 더바이스산업공구상사 Mcompany = 더바이스산업공구상사 2 = 621-21-51072 companyNum = 621-21-51072 3 = 070-4127-0909 Mtel1 = 070-4127-0909 4 = 010-4437-6515 Mhp = 010-4437-6515 ========================2022-08-31 17:29:01======================== select * from customers where id = 'thevise' ========================2022-08-31 17:29:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('thevise','2022-08-31 17:29:01','10000','11000','온라인','0')