========================2022-10-04 07:15:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo602r-1664835209 LGD_BUYER = 김재우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004071329 LGD_HASHDATA = a36c2da19d5075ec2c091aa2d532946a 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 = 202210040718230E8908B5DDCC313DE61EB61169043A995E68D660 Mname = 김재우 Mcompany = 서울치즈울산동부가공고객센타 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = woo602r LGD_ESCROW_USEYN = N ========================2022-10-04 07:15:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004071824 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 = 94111602****188* LGD_FINANCEAUTHNUM = 51976265 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = a3356d6bcd4724ec7f99bffd859148ef LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004071824 LGD_PCANCELSTR = 0 LGD_BUYER = 김재우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof2022100407182457t84 LGD_BUYERID = LGD_OID = Direct-woo602r-1664835209 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 08:37:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1664840178 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004083618 LGD_HASHDATA = 35eecd39b8dbc94dae4e0437a8fa9284 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 = 2022100408401125A5F65673944E9ADE7756CB872D17CBD3C1B12E Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-10-04 08:37:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004084011 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 = 94301703****448* LGD_FINANCEAUTHNUM = 52276773 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2f95f44ac191646a6a61dc8f0f34bf1f LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004084012 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221004084011deUB5 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1664840178 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 08:37:14======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1664840178', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20221004084011deUB5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 08:37:14', InvoiceNum = '결제성공:Direct-goodssal5707-1664840178/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 08:37:14' ========================2022-10-04 08:37:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221004084011deUB5' 0 = 1 cnt = 1 ========================2022-10-04 08:37:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-10-04 08:37:14======================== select * from customers where id = 'goodssal5707' ========================2022-10-04 08:37:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-10-04 08:37:14','220000','220000','온라인','0') ========================2022-10-04 08:38:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1664840245 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004083725 LGD_HASHDATA = 2f17d4031f110963dee90bcad8f273ef 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 = 20221004084104EDFCFB7673A2CC5485422DE9F1156075EB3E034A Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2022-10-04 08:38:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004084104 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 = 94301703****448* LGD_FINANCEAUTHNUM = 52281424 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5075230ea80b917ad89d03385384fa17 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004084105 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221004084104bQLA8 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1664840245 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 08:38:07======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1664840245', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20221004084104bQLA8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 08:38:07', InvoiceNum = '결제성공:Direct-goodssal5707-1664840245/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 08:38:07' ========================2022-10-04 08:38:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221004084104bQLA8' 0 = 1 cnt = 1 ========================2022-10-04 08:38:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2022-10-04 08:38:07======================== select * from customers where id = 'goodssal5707' ========================2022-10-04 08:38:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2022-10-04 08:38:07','220000','220000','온라인','0') ========================2022-10-04 08:57:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-whysystem-1664841317 LGD_BUYER = 윤신호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004085517 LGD_HASHDATA = fc5948489d8ffbde94a555f6ad010b76 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 = 202210040900532BEC32DC37346E63AAFF0B2670C91A204FC64D5D Mname = 윤신호 Mcompany = 와이시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = whysystem LGD_ESCROW_USEYN = N ========================2022-10-04 08:57:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004090053 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 = 52171800****084* LGD_FINANCEAUTHNUM = 28221554 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 98f5cf41d47691144be8b9afcac24a90 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221004090053 LGD_PCANCELSTR = 0 LGD_BUYER = 윤신호 LGD_CARDINSTALLMONTH = 03 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202210040900538o459 LGD_BUYERID = LGD_OID = Direct-whysystem-1664841317 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 08:57:55======================== insert into mBoard_order set rOrdNo = 'Direct-whysystem-1664841317', AuthTy = 'card', memberId = 'whysystem', OrdNm ='윤신호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '와이시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '롯데MASTER 52171800****084*', rApprNo = 'mjsof202210040900538o459', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 08:57:55', InvoiceNum = '결제성공:Direct-whysystem-1664841317/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 08:57:55' ========================2022-10-04 08:57:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210040900538o459' 0 = 1 cnt = 1 ========================2022-10-04 08:57:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'whysystem' 0 = whysystem Mid = whysystem 1 = 와이시스템 Mcompany = 와이시스템 2 = 1890500628 companyNum = 1890500628 3 = 010-4111-6206 Mtel1 = 010-4111-6206 4 = 010-4111-6206 Mhp = 010-4111-6206 ========================2022-10-04 08:57:56======================== select * from customers where id = 'whysystem' ========================2022-10-04 08:57:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('whysystem','2022-10-04 08:57:55','108000','110000','온라인','0') ========================2022-10-04 10:24:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1664846580 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004102300 LGD_HASHDATA = 8a1ab5e5616119d61317e689eaaadd41 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 = 202210041027446819798EA4B53ECE6A1D807771C63CBBFB032404 Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2022-10-04 10:24:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004102745 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 244581 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****454* LGD_FINANCEAUTHNUM = 35596038 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 29e42d75b07b1df402c2a4820bef7a1d LGD_BUYERADDRESS = LGD_FINANCENAME = 우리VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221004102745 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210041027446tfT1 LGD_BUYERID = LGD_OID = Direct-ltweenn-1664846580 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 41027446wVR5 ========================2022-10-04 10:24:47======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1664846580', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리VISA 41012020****454*', rApprNo = 'mjsof202210041027446tfT1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 10:24:47', InvoiceNum = '결제성공:Direct-ltweenn-1664846580/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 10:24:47' ========================2022-10-04 10:24:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210041027446tfT1' 0 = 1 cnt = 1 ========================2022-10-04 10:24:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2022-10-04 10:24:47======================== select * from customers where id = 'ltweenn' ========================2022-10-04 10:24:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2022-10-04 10:24:47','220000','220000','온라인','0') ========================2022-10-04 13:30:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tealimc-1664857770 LGD_BUYER = 정영호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004132930 LGD_HASHDATA = 133cfa65589d3c9d663d87bf6844fadd 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 = 202210041333583DF0C14C531DC72BE0B60573CD1BDFE562B238E2 Mname = 정영호 Mcompany = 태림화학 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tealimc LGD_ESCROW_USEYN = N ========================2022-10-04 13:31:00======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004133358 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41403211****996* LGD_FINANCEAUTHNUM = 36884244 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b809187d58fe745932064ea4153c4991 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221004133358 LGD_PCANCELSTR = 0 LGD_BUYER = 정영호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221004133358dHa46 LGD_BUYERID = LGD_OID = Direct-tealimc-1664857770 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4133358dc906 ========================2022-10-04 13:31:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tealimc-1664857770 LGD_BUYER = 정영호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004132930 LGD_HASHDATA = 133cfa65589d3c9d663d87bf6844fadd 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 = 202210041333583DF0C14C531DC72BE0B60573CD1BDFE562B238E2 Mname = 정영호 Mcompany = 태림화학 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tealimc LGD_ESCROW_USEYN = N ========================2022-10-04 13:31:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004133412 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-tealimc-1664857770]는 2022/10/04 13:33:58 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 36884244 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 9b5bd4e7697d496e0cdd9168e9a9e386 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20221004133412 LGD_PCANCELSTR = 0 LGD_BUYER = 정영호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20221004133358dHa46 LGD_BUYERID = LGD_OID = Direct-tealimc-1664857770 LGD_RESPCODE = S007 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-10-04 13:50:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tealimc-1664858997 LGD_BUYER = 정영호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004134957 LGD_HASHDATA = 4cf064e8038300b96e6e5ed78d5c04cc 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 = 20221004135350C6A93F6821F5CBF21E784D59387CC800D8ED0051 Mname = 정영호 Mcompany = 태림화학 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = tealimc LGD_ESCROW_USEYN = N ========================2022-10-04 13:50:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004135351 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41403211****996* LGD_FINANCEAUTHNUM = 37045736 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f1a3d2b5664e45918f44604bcd14261b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221004135351 LGD_PCANCELSTR = 0 LGD_BUYER = 정영호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221004135351dJpT5 LGD_BUYERID = LGD_OID = Direct-tealimc-1664858997 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4135351dcYO8 ========================2022-10-04 13:50:53======================== insert into mBoard_order set rOrdNo = 'Direct-tealimc-1664858997', AuthTy = 'card', memberId = 'tealimc', OrdNm ='정영호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태림화학', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 41403211****996*', rApprNo = 'mjsof20221004135351dJpT5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 13:50:53', InvoiceNum = '결제성공:Direct-tealimc-1664858997/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 13:50:53' ========================2022-10-04 13:50:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221004135351dJpT5' 0 = 1 cnt = 1 ========================2022-10-04 13:50:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tealimc' 0 = tealimc Mid = tealimc 1 = 태림화학 Mcompany = 태림화학 2 = 603-30-60712 companyNum = 603-30-60712 3 = 051-206-2307 Mtel1 = 051-206-2307 4 = 010-3859-0119 Mhp = 010-3859-0119 ========================2022-10-04 13:50:53======================== select * from customers where id = 'tealimc' ========================2022-10-04 13:50:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tealimc','2022-10-04 13:50:53','30900','33000','온라인','0') ========================2022-10-04 14:04:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1664859807 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004140327 LGD_HASHDATA = 63b133c1005ef8bb7a0b06e4b6f94676 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 = 20221004140719AA224CFDFD5D5A2C025C2D827A6ED8199BAFFE30 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2022-10-04 14:04:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004140719 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 = 94301604****416* LGD_FINANCEAUTHNUM = 55677475 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3b8ebf6be5c98f0703343d70afc3e452 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004140719 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221004140719dL0Y8 LGD_BUYERID = LGD_OID = Direct-snbfood-1664859807 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:04:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1664859807 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004140327 LGD_HASHDATA = 63b133c1005ef8bb7a0b06e4b6f94676 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 = 20221004140719AA224CFDFD5D5A2C025C2D827A6ED8199BAFFE30 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2022-10-04 14:04:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004140729 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-snbfood-1664859807]는 2022/10/04 14:07:19 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = LGD_FINANCEAUTHNUM = 55677475 LGD_ESCROWYN = N LGD_TRANSAMOUNT = LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = d1614e6282ff3a8737c63d32cb3232dc LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20221004140729 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20221004140719dL0Y8 LGD_BUYERID = LGD_OID = Direct-snbfood-1664859807 LGD_RESPCODE = S007 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 ========================2022-10-04 14:07:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1664859996 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004140636 LGD_HASHDATA = 31993b6c0481dda08594d0ac15a797f0 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 = 20221004141011021624725CBFEB8D908EEC2AE2BF7323C7B80719 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2022-10-04 14:07:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004141011 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 = 94301604****416* LGD_FINANCEAUTHNUM = 55709183 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 68a18a26ed98c57cf9d8b1c79e573a8f LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004141012 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221004141011aGdG6 LGD_BUYERID = LGD_OID = Direct-snbfood-1664859996 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:09:17======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1664860063 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004140743 LGD_HASHDATA = ff812bd672ae81fbc0327cfb134b5645 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 = 20221004141215E9C41907F236A5382B4A33EC8FB27EF4757DF479 Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2022-10-04 14:09:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004141216 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 = 94301604****416* LGD_FINANCEAUTHNUM = 55732218 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9d81104e8ee60b6512a2bd132837979b LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004141216 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210041412165Hrr3 LGD_BUYERID = LGD_OID = Direct-snbfood-1664860063 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:12:16======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1664860304 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004141144 LGD_HASHDATA = ed7844ecb812d0595b608302f5fc70a3 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 = 20221004141514FADFDF0DBCBAD58B23896A5B372015E39312701C Mname = 임승순 Mcompany = (주)비에스푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = snbfood LGD_ESCROW_USEYN = N ========================2022-10-04 14:12:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004141514 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 = 94301604****416* LGD_FINANCEAUTHNUM = 55764949 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = abee2669c8c0c1f6b96b328257497db5 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221004141514 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210041415149WPN3 LGD_BUYERID = LGD_OID = Direct-snbfood-1664860304 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:12:16======================== insert into mBoard_order set rOrdNo = 'Direct-snbfood-1664860304', AuthTy = 'card', memberId = 'snbfood', OrdNm ='임승순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)비에스푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = 'NH 94301604****416*', rApprNo = 'mjsof202210041415149WPN3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 14:12:16', InvoiceNum = '결제성공:Direct-snbfood-1664860304/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 14:12:16' ========================2022-10-04 14:12:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210041415149WPN3' 0 = 1 cnt = 1 ========================2022-10-04 14:12:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'snbfood' 0 = snbfood Mid = snbfood 1 = (주)비에스푸드 Mcompany = (주)비에스푸드 2 = 4098701740 companyNum = 4098701740 3 = 042-823-6330 Mtel1 = 042-823-6330 4 = 010-5612-3122 Mhp = 010-5612-3122 ========================2022-10-04 14:12:16======================== select * from customers where id = 'snbfood' ========================2022-10-04 14:12:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('snbfood','2022-10-04 14:12:16','30900','33000','온라인','0') ========================2022-10-04 14:12:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1664860244 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004141044 LGD_HASHDATA = 72ad2018ae54dfd33d4e824cf5e51c89 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 = 202210041415343D5DA002B1C5CF1A7681C6C00DACCE16EDBF6148 Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2022-10-04 14:12:36======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004141534 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 = 94091511****271* LGD_FINANCEAUTHNUM = 62379277 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 52e676de0b263b02383229089f1ba5b2 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221004141535 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221004141534aGQO2 LGD_BUYERID = LGD_OID = Direct-antwin77-1664860244 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:15:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1664860471 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004141431 LGD_HASHDATA = 0834126510a896c6ec1f69a38094713c 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 = 20221004141833A7847BDEC86770351E7656E4358D819A4398E341 Mname = 김태우 Mcompany = 새미래식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2022-10-04 14:15:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004141833 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 = 94091511****271* LGD_FINANCEAUTHNUM = 35111278 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7464ce63674e9f180100f45c4f4836e8 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221004141834 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210041418337TEU6 LGD_BUYERID = LGD_OID = Direct-antwin77-1664860471 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 14:15:35======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1664860471', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '새미래식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데 94091511****271*', rApprNo = 'mjsof202210041418337TEU6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 14:15:35', InvoiceNum = '결제성공:Direct-antwin77-1664860471/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 14:15:35' ========================2022-10-04 14:15:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210041418337TEU6' 0 = 1 cnt = 1 ========================2022-10-04 14:15:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2022-10-04 14:15:35======================== select * from customers where id = 'antwin77' ========================2022-10-04 14:15:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2022-10-04 14:15:35','52500','55000','온라인','0') ========================2022-10-04 16:08:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jsjs1018-1664867164 LGD_BUYER = 전성림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221004160604 LGD_HASHDATA = feda171d81329494689e0d6aaa655731 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 = 20221004161134C4154DFB3CA15ED01FADF958E61D5933F89FFFFB Mname = 전성림 Mcompany = 혜 창 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jsjs1018 LGD_ESCROW_USEYN = N ========================2022-10-04 16:08:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221004161134 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = jsjs1018@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = AFG03J LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94106186****778* LGD_FINANCEAUTHNUM = 21226575 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fde481d7e536dc49a8c5fff13b45422c LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221004161135 LGD_PCANCELSTR = 0 LGD_BUYER = 전성림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202210041611345TGI8 LGD_BUYERID = LGD_OID = Direct-jsjs1018-1664867164 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-04 16:08:37======================== insert into mBoard_order set rOrdNo = 'Direct-jsjs1018-1664867164', AuthTy = 'card', memberId = 'jsjs1018', OrdNm ='전성림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '혜 창', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한 94106186****778*', rApprNo = 'mjsof202210041611345TGI8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-04 16:08:37', InvoiceNum = '결제성공:Direct-jsjs1018-1664867164/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-04 16:08:37' ========================2022-10-04 16:08:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202210041611345TGI8' 0 = 1 cnt = 1 ========================2022-10-04 16:08:37======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jsjs1018' 0 = jsjs1018 Mid = jsjs1018 1 = 혜 창 Mcompany = 혜 창 2 = 204-22-79343 companyNum = 204-22-79343 3 = 02-2242-1126 Mtel1 = 02-2242-1126 4 = 010-5344-9245 Mhp = 010-5344-9245 ========================2022-10-04 16:08:37======================== select * from customers where id = 'jsjs1018' ========================2022-10-04 16:08:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jsjs1018','2022-10-04 16:08:37','52500','55000','온라인','0')