========================2024-07-09 09:59:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nowfix-1720486731 LGD_BUYER = 임경섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240709095851 LGD_HASHDATA = fa9112991cfdd987cb18bed2e5e7cb96 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240709100103ADE377FC5044EB685B1070A0445928D3A348D681 Mname = 임경섭 Mcompany = (주)나우픽스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = nowfix LGD_ESCROW_USEYN = N ========================2024-07-09 09:59:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240709100103 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = nowfix@nowfix.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40791672****919* LGD_FINANCEAUTHNUM = 62334588 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5f88ec6c5101cb5220188fe02bfa7dce LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20240709100104 LGD_PCANCELSTR = 0 LGD_BUYER = 임경섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2024070910010332uZ9 LGD_BUYERID = LGD_OID = Direct-nowfix-1720486731 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-09 09:59:44======================== insert into mBoard_order set rOrdNo = 'Direct-nowfix-1720486731', AuthTy = 'card', memberId = 'nowfix', OrdNm ='임경섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)나우픽스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH VISA 40791672****919*', rApprNo = 'mjsof2024070910010332uZ9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-09 09:59:44', InvoiceNum = '결제성공:Direct-nowfix-1720486731/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-09 09:59:44' ========================2024-07-09 09:59:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2024070910010332uZ9' 0 = 1 cnt = 1 ========================2024-07-09 09:59:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nowfix' 0 = nowfix Mid = nowfix 1 = (주)나우픽스 Mcompany = (주)나우픽스 2 = 1688100038 companyNum = 1688100038 3 = 043-218-3002 Mtel1 = 043-218-3002 4 = 010-3453-9496 Mhp = 010-3453-9496 ========================2024-07-09 09:59:45======================== select * from customers where id = 'nowfix' ========================2024-07-09 09:59:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nowfix','2024-07-09 09:59:44','220000','220000','온라인','0') ========================2024-07-09 15:51:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-C00771-1720507755 LGD_BUYER = 전세일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240709154915 LGD_HASHDATA = 2fd9d1dfd353d11b6da07c436514d269 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202407091552207E3A269219B54C7ECEE76B81438E394E648F18CD Mname = 전세일 Mcompany = 척테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = C00771 LGD_ESCROW_USEYN = N ========================2024-07-09 15:51:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240709155221 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = chucktech1516@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45749200****911* LGD_FINANCEAUTHNUM = 00709332 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e718a22d51969ec43f6ab56fa033e89e LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20240709155221 LGD_PCANCELSTR = 0 LGD_BUYER = 전세일 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240709155221esF04 LGD_BUYERID = LGD_OID = Direct-C00771-1720507755 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-07-09 15:51:01======================== insert into mBoard_order set rOrdNo = 'Direct-C00771-1720507755', AuthTy = 'card', memberId = 'C00771', OrdNm ='전세일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '척테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 45749200****911*', rApprNo = 'mjsof20240709155221esF04', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-09 15:51:01', InvoiceNum = '결제성공:Direct-C00771-1720507755/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-09 15:51:01' ========================2024-07-09 15:51:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240709155221esF04' 0 = 1 cnt = 1 ========================2024-07-09 15:51:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'C00771' 0 = c00771 Mid = c00771 1 = 척테크 Mcompany = 척테크 2 = 539-14-00771 companyNum = 539-14-00771 3 = 02-3394-7801 Mtel1 = 02-3394-7801 4 = 010-6280-7566 Mhp = 010-6280-7566 ========================2024-07-09 15:51:01======================== select * from customers where id = 'C00771' ========================2024-07-09 15:51:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('C00771','2024-07-09 15:51:01','108000','110000','온라인','0') ========================2024-07-09 18:58:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kong3188-1720519011 LGD_BUYER = 유재일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240709185651 LGD_HASHDATA = e05b91d5e316b6d8dd8b9f037c0e9bdd LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240709185921753066BB18ED1CD9A3FE86044DBF2CE3A222693A Mname = 유재일 Mcompany = 콩살이(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kong3188 LGD_ESCROW_USEYN = N ========================2024-07-09 18:58:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240709185922 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850307****594* LGD_FINANCEAUTHNUM = 60557242 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5e62f7d4bdf1b3b99e38011008801c16 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240709185922 LGD_PCANCELSTR = 0 LGD_BUYER = 유재일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20240709185921uORt5 LGD_BUYERID = LGD_OID = Direct-kong3188-1720519011 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 9185921u4244 ========================2024-07-09 18:58:02======================== insert into mBoard_order set rOrdNo = 'Direct-kong3188-1720519011', AuthTy = 'card', memberId = 'kong3188', OrdNm ='유재일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '콩살이(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850307****594*', rApprNo = 'mjsof20240709185921uORt5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-09 18:58:02', InvoiceNum = '결제성공:Direct-kong3188-1720519011/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-09 18:58:02' ========================2024-07-09 18:58:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240709185921uORt5' 0 = 1 cnt = 1 ========================2024-07-09 18:58:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kong3188' 0 = kong3188 Mid = kong3188 1 = 콩살이(주) Mcompany = 콩살이(주) 2 = 794-87-02628 companyNum = 794-87-02628 3 = Mtel1 = 4 = 010-5065-7440 Mhp = 010-5065-7440 ========================2024-07-09 18:58:02======================== select * from customers where id = 'kong3188' ========================2024-07-09 18:58:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kong3188','2024-07-09 18:58:02','52500','55000','온라인','0') ========================2024-07-09 21:36:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bf5957-1720528547 LGD_BUYER = 윤성필 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20240709213547 LGD_HASHDATA = 33512a47d8b9898b9418a9fc13c13695 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20240709213746CA7BDF07B23F02D0C448B74D424BDB6C12F07B3D Mname = 윤성필 Mcompany = 비엔에프 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = bf5957 LGD_ESCROW_USEYN = N ========================2024-07-09 21:36:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20240709213746 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005005 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 53301481****503* LGD_FINANCEAUTHNUM = 61550410 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 46200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 27ab92c15f660ef01efa81d6eb5dca7c LGD_BUYERADDRESS = LGD_FINANCENAME = 광주Master LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20240709213747 LGD_PCANCELSTR = 0 LGD_BUYER = 윤성필 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20240709213746r5LU0 LGD_BUYERID = LGD_OID = Direct-bf5957-1720528547 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 092137656078 ========================2024-07-09 21:36:27======================== insert into mBoard_order set rOrdNo = 'Direct-bf5957-1720528547', AuthTy = 'card', memberId = 'bf5957', OrdNm ='윤성필', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '비엔에프', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '광주Master 53301481****503*', rApprNo = 'mjsof20240709213746r5LU0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-07-09 21:36:27', InvoiceNum = '결제성공:Direct-bf5957-1720528547/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-07-09 21:36:27' ========================2024-07-09 21:36:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20240709213746r5LU0' 0 = 1 cnt = 1 ========================2024-07-09 21:36:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bf5957' 0 = bf5957 Mid = bf5957 1 = 비엔에프 Mcompany = 비엔에프 2 = 4578101034 companyNum = 4578101034 3 = 062-515-5957 Mtel1 = 062-515-5957 4 = 010-5610-3711 Mhp = 010-5610-3711 ========================2024-07-09 21:36:27======================== select * from customers where id = 'bf5957' ========================2024-07-09 21:36:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bf5957','2024-07-09 21:36:27','52500','55000','온라인','0')