========================2023-10-31 07:00:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phso51900-1698703157 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031065917 LGD_HASHDATA = bd6059378bc5b1667dce3e1965a31f26 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 = 20231031070341E6D0A9F0E63DE4488B5C674364EAC4C27F84CFB4 Mname = 박현석 Mcompany = 인화유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = phso51900 LGD_ESCROW_USEYN = N ========================2023-10-31 07:00:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231031070342 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797314****109* LGD_FINANCEAUTHNUM = 30036041 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b0d0ffb58d5263be8f0a11bb51a1d429 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231031070342 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231031070342ib253 LGD_BUYERID = LGD_OID = Direct-phso51900-1698703157 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-31 07:00:53======================== insert into mBoard_order set rOrdNo = 'Direct-phso51900-1698703157', AuthTy = 'card', memberId = 'phso51900', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '인화유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797314****109*', rApprNo = 'mjsof20231031070342ib253', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 07:00:53', InvoiceNum = '결제성공:Direct-phso51900-1698703157/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 07:00:53' ========================2023-10-31 07:00:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031070342ib253' 0 = 1 cnt = 1 ========================2023-10-31 07:00:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phso51900' 0 = phso51900 Mid = phso51900 1 = 인화유통 Mcompany = 인화유통 2 = 326-27-01169 companyNum = 326-27-01169 3 = 010-9099-2105 Mtel1 = 010-9099-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2023-10-31 07:00:53======================== select * from customers where id = 'phso51900' ========================2023-10-31 07:00:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phso51900','2023-10-31 07:00:53','52500','55000','온라인','0') ========================2023-10-31 10:30:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neolith69-1698715729 LGD_BUYER = 신석기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031102849 LGD_HASHDATA = 0af6eb4b6c910f1ba67d5a1efbd36772 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 = 2023103110331405681233F37EA27CB6FE7211D84B57C25C7C0092 Mname = 신석기 Mcompany = 네오텍 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = neolith69 LGD_ESCROW_USEYN = N ========================2023-10-31 10:30:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231031103315 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFH920 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 35690801****163* LGD_FINANCEAUTHNUM = 05442214 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2338ea6fa03f5e7785f56c25aa017ac5 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231031103315 LGD_PCANCELSTR = 0 LGD_BUYER = 신석기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231031103315l54T3 LGD_BUYERID = LGD_OID = Direct-neolith69-1698715729 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-31 10:30:26======================== insert into mBoard_order set rOrdNo = 'Direct-neolith69-1698715729', AuthTy = 'card', memberId = 'neolith69', OrdNm ='신석기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '네오텍', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한JCB 35690801****163*', rApprNo = 'mjsof20231031103315l54T3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 10:30:26', InvoiceNum = '결제성공:Direct-neolith69-1698715729/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 10:30:26' ========================2023-10-31 10:30:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031103315l54T3' 0 = 1 cnt = 1 ========================2023-10-31 10:30:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neolith69' 0 = neolith69 Mid = neolith69 1 = 네오텍 Mcompany = 네오텍 2 = 615-13-52616 companyNum = 615-13-52616 3 = 055-346-3318 Mtel1 = 055-346-3318 4 = 010-3550-5634 Mhp = 010-3550-5634 ========================2023-10-31 10:30:26======================== select * from customers where id = 'neolith69' ========================2023-10-31 10:30:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neolith69','2023-10-31 10:30:26','220000','220000','온라인','0') ========================2023-10-31 10:42:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hanmotor-1698716408 LGD_BUYER = 전한별 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031104008 LGD_HASHDATA = d10ca913d1190e8faaa56173d1354f5c 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 = 20231031104505F3029505DCB7262165D761D421C66BB252F14BC5 Mname = 전한별 Mcompany = 한명기전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = hanmotor LGD_ESCROW_USEYN = N ========================2023-10-31 10:42:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231031104506 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 393322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94303980****558* LGD_FINANCEAUTHNUM = 56045460 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 557da06013e6bf511f7041ce760c0b0f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231031104506 LGD_PCANCELSTR = 0 LGD_BUYER = 전한별 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231031104506efmO4 LGD_BUYERID = LGD_OID = Direct-hanmotor-1698716408 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1104506ed2b7 ========================2023-10-31 10:42:17======================== insert into mBoard_order set rOrdNo = 'Direct-hanmotor-1698716408', AuthTy = 'card', memberId = 'hanmotor', OrdNm ='전한별', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한명기전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨 94303980****558*', rApprNo = 'mjsof20231031104506efmO4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 10:42:17', InvoiceNum = '결제성공:Direct-hanmotor-1698716408/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 10:42:17' ========================2023-10-31 10:42:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031104506efmO4' 0 = 1 cnt = 1 ========================2023-10-31 10:42:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hanmotor' 0 = hanmotor Mid = hanmotor 1 = 한명기전 Mcompany = 한명기전 2 = 608-16-87404 companyNum = 608-16-87404 3 = 055-287-3723 Mtel1 = 055-287-3723 4 = 010-8817-8534 Mhp = 010-8817-8534 ========================2023-10-31 10:42:17======================== select * from customers where id = 'hanmotor' ========================2023-10-31 10:42:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hanmotor','2023-10-31 10:42:17','10000','11000','온라인','0') ========================2023-10-31 17:29:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-damiki-1698740888 LGD_BUYER = 박영옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031172808 LGD_HASHDATA = 68922ec09d7a7a91293bfb0fda43fd51 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 = 20231031173204CDFC8ECEE5BE9046F1D7D787C90477161D1F4896 Mname = 박영옥 Mcompany = 다미끼크라프트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = damiki LGD_ESCROW_USEYN = N ========================2023-10-31 17:29:17======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231031173206 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850313****193* LGD_FINANCEAUTHNUM = 60944580 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4971f5bd93772470cd1f93db3204eabd LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231031173206 LGD_PCANCELSTR = 0 LGD_BUYER = 박영옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231031173205lo3l3 LGD_BUYERID = LGD_OID = Direct-damiki-1698740888 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 1173205lm5U4 ========================2023-10-31 17:29:17======================== insert into mBoard_order set rOrdNo = 'Direct-damiki-1698740888', AuthTy = 'card', memberId = 'damiki', OrdNm ='박영옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '다미끼크라프트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850313****193*', rApprNo = 'mjsof20231031173205lo3l3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 17:29:17', InvoiceNum = '결제성공:Direct-damiki-1698740888/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 17:29:17' ========================2023-10-31 17:29:17======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031173205lo3l3' 0 = 1 cnt = 1 ========================2023-10-31 17:29:17======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'damiki' 0 = damiki Mid = damiki 1 = 다미끼크라프트 Mcompany = 다미끼크라프트 2 = 138-03-73658 companyNum = 138-03-73658 3 = 031-348-9201 Mtel1 = 031-348-9201 4 = 010-2658-0429 Mhp = 010-2658-0429 ========================2023-10-31 17:29:17======================== select * from customers where id = 'damiki' ========================2023-10-31 17:29:17======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('damiki','2023-10-31 17:29:17','108000','110000','온라인','0') ========================2023-10-31 17:32:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ksys-1698740973 LGD_BUYER = 김성현 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031172933 LGD_HASHDATA = 5120ce77f72aeee69133a5456835a3cc 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 = 20231031173545177E876A3A965A1B41F22420891A9CDF49EDC443 Mname = 김성현 Mcompany = 우석기업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ksys LGD_ESCROW_USEYN = N ========================2023-10-31 17:32:56======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20231031173545 LGD_BUYEREMAIL = 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 = LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = db3c294e3f61e4c66ecfe744e748af78 LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20231031173545 LGD_PCANCELSTR = 0 LGD_BUYER = 김성현 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20231031173457Z3qa8 LGD_BUYERID = LGD_OID = Direct-ksys-1698740973 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-31 17:32:56======================== insert into mBoard_order set rOrdNo = 'Direct-ksys-1698740973', AuthTy = 'card', memberId = 'ksys', OrdNm ='김성현', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우석기업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20231031173457Z3qa8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 17:32:56', InvoiceNum = '결제성공:Direct-ksys-1698740973/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 17:32:56' ========================2023-10-31 17:32:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031173457Z3qa8' 0 = 1 cnt = 1 ========================2023-10-31 17:32:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ksys' 0 = ksys Mid = ksys 1 = 우석기업 Mcompany = 우석기업 2 = 4102948274 companyNum = 4102948274 3 = 062-384-0985 Mtel1 = 062-384-0985 4 = 010-4040-3003 Mhp = 010-4040-3003 ========================2023-10-31 17:32:56======================== select * from customers where id = 'ksys' ========================2023-10-31 17:32:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ksys','2023-10-31 17:32:56','108000','110000','온라인','0') ========================2023-10-31 21:22:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ssg2933-1698754709 LGD_BUYER = 정구성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231031211829 LGD_HASHDATA = 067cd66928bc7fcf8dc6cc6021a7aa6d 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 = 202310312125043985C19A0DC4242B65712A9A1B9A3225788FDAE7 Mname = 정구성 Mcompany = 이레수농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ssg2933 LGD_ESCROW_USEYN = N ========================2023-10-31 21:22:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231031212505 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 51883170****697* LGD_FINANCEAUTHNUM = 44081134 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 067acab3dcb6187f94ecae4bc5b4bece LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20231031212505 LGD_PCANCELSTR = 0 LGD_BUYER = 정구성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231031212505iE8U2 LGD_BUYERID = LGD_OID = Direct-ssg2933-1698754709 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-10-31 21:22:16======================== insert into mBoard_order set rOrdNo = 'Direct-ssg2933-1698754709', AuthTy = 'card', memberId = 'ssg2933', OrdNm ='정구성', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이레수농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '삼성MASTER 51883170****697*', rApprNo = 'mjsof20231031212505iE8U2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-10-31 21:22:16', InvoiceNum = '결제성공:Direct-ssg2933-1698754709/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-10-31 21:22:16' ========================2023-10-31 21:22:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231031212505iE8U2' 0 = 1 cnt = 1 ========================2023-10-31 21:22:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ssg2933' 0 = ssg2933 Mid = ssg2933 1 = 이레수농산 Mcompany = 이레수농산 2 = 138-90-41122 companyNum = 138-90-41122 3 = 031-451-2939 Mtel1 = 031-451-2939 4 = 010-9788-2933 Mhp = 010-9788-2933 ========================2023-10-31 21:22:16======================== select * from customers where id = 'ssg2933' ========================2023-10-31 21:22:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ssg2933','2023-10-31 21:22:16','108000','110000','온라인','0')