========================2022-12-06 10:18:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-phocos-1670289403 LGD_BUYER = (주)포코스 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206101643 LGD_HASHDATA = da2b9568754bbac6b40b362939d62c10 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 = 202212061022156EF4669D7F12D5360414664F1CB0C1892901BE29 Mname = (주)포코스 Mcompany = (주)포코스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = phocos LGD_ESCROW_USEYN = N ========================2022-12-06 10:18:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206102217 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852693****185* LGD_FINANCEAUTHNUM = 30090710 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b11b783f95aeb51c6de18112df42f407 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221206102217 LGD_PCANCELSTR = 0 LGD_BUYER = (주)포코스 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221206102216ZLPd3 LGD_BUYERID = LGD_OID = Direct-phocos-1670289403 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6102216Z5Ob1 ========================2022-12-06 10:18:09======================== insert into mBoard_order set rOrdNo = 'Direct-phocos-1670289403', AuthTy = 'card', memberId = 'phocos', OrdNm ='(주)포코스', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)포코스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '국민MASTER 55852693****185*', rApprNo = 'mjsof20221206102216ZLPd3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 10:18:09', InvoiceNum = '결제성공:Direct-phocos-1670289403/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 10:18:09' ========================2022-12-06 10:18:09======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206102216ZLPd3' 0 = 1 cnt = 1 ========================2022-12-06 10:18:09======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'phocos' 0 = phocos Mid = phocos 1 = (주)포코스 Mcompany = (주)포코스 2 = 140-81-22446 companyNum = 140-81-22446 3 = 031-487-1830 Mtel1 = 031-487-1830 4 = 010-6361-4527 Mhp = 010-6361-4527 ========================2022-12-06 10:18:09======================== select * from customers where id = 'phocos' ========================2022-12-06 10:18:09======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('phocos','2022-12-06 10:18:09','30900','33000','온라인','0') ========================2022-12-06 10:29:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woncy77-1670290068 LGD_BUYER = 원치열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206102748 LGD_HASHDATA = 44afe4ac24c0e4b0fd1d03b4f2a44cb6 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 = 20221206103339AB623A3CEBF9146EF178045F35B35CA5CE9868F6 Mname = 원치열 Mcompany = 신평산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = woncy77 LGD_ESCROW_USEYN = N ========================2022-12-06 10:29:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206103340 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 = 94311602****744* LGD_FINANCEAUTHNUM = 69786013 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 9a35ae1a1a04eae92eb903da527d64fd LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221206103340 LGD_PCANCELSTR = 0 LGD_BUYER = 원치열 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202212061033403G5H1 LGD_BUYERID = LGD_OID = Direct-woncy77-1670290068 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 10:32:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woncy77-1670290245 LGD_BUYER = 원치열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206103045 LGD_HASHDATA = bc61bedaa8801a0a93809a73257f7bc4 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 = 20221206103628C2AE6C10586DBB41EDF4E04B1B67090A31286D8C Mname = 원치열 Mcompany = 신평산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = woncy77 LGD_ESCROW_USEYN = N ========================2022-12-06 10:32:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206103628 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 = 94311602****744* LGD_FINANCEAUTHNUM = 69809038 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = cc915196b9e9bc443c4c25bb4d60e07c LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221206103629 LGD_PCANCELSTR = 0 LGD_BUYER = 원치열 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202212061036283Guh5 LGD_BUYERID = LGD_OID = Direct-woncy77-1670290245 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 10:34:35======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woncy77-1670290393 LGD_BUYER = 원치열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206103313 LGD_HASHDATA = 421b061c61f6a4dd499d287ebee48534 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 = 20221206103843BE7F9A8AAD35CC9A738FDA6F52A8BCAC30AE9CAB Mname = 원치열 Mcompany = 신평산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = woncy77 LGD_ESCROW_USEYN = N ========================2022-12-06 10:34:36======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20221206103844 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 = 55000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 8efca0b125bca815d9ec2427f1619c37 LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20221206103844 LGD_PCANCELSTR = 0 LGD_BUYER = 원치열 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20221206103808pO9b5 LGD_BUYERID = LGD_OID = Direct-woncy77-1670290393 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 10:40:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woncy77-1670290534 LGD_BUYER = 원치열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206103534 LGD_HASHDATA = 5d06541168e5f8448da09af6a7aa2315 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 = 202212061044358745839DC3E730CCBD6DF49F690F3E1AF32BFAAB Mname = 원치열 Mcompany = 신평산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = woncy77 LGD_ESCROW_USEYN = N ========================2022-12-06 10:40:28======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20221206104436 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 = 55000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 0d049092d97f9146c0fdbf750f08db3c LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20221206104436 LGD_PCANCELSTR = 0 LGD_BUYER = 원치열 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20221206104413AIeJ3 LGD_BUYERID = LGD_OID = Direct-woncy77-1670290534 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 10:42:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woncy77-1670290914 LGD_BUYER = 원치열 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206104154 LGD_HASHDATA = 3f97668e204e3722c6c5c791245dfffe 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 = 2022120610465580305A7970F7EBB0466E5599FB6D28BD3B7228D8 Mname = 원치열 Mcompany = 신평산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = woncy77 LGD_ESCROW_USEYN = N ========================2022-12-06 10:42:48======================== xpay_res LGD_EASYPAY_TRANTYPE = KAKAOPAY LGD_BUYERPHONE = LGD_PAYDATE = 20221206104656 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 = 55000 LGD_FINANCECODE = 098 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = d20c63e40e4c19d8216ff73a16994f9a LGD_BUYERADDRESS = LGD_FINANCENAME = 카카오페이 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = LGD_DEVICE = LGD_TIMESTAMP = 20221206104656 LGD_PCANCELSTR = 0 LGD_BUYER = 원치열 LGD_CARDINSTALLMONTH = LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = LGD_TID = mjsof20221206104637wBhE2 LGD_BUYERID = LGD_OID = Direct-woncy77-1670290914 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 10:42:48======================== insert into mBoard_order set rOrdNo = 'Direct-woncy77-1670290914', AuthTy = 'card', memberId = 'woncy77', OrdNm ='원치열', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신평산업', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '카카오페이 ', rApprNo = 'mjsof20221206104637wBhE2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 10:42:48', InvoiceNum = '결제성공:Direct-woncy77-1670290914/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 10:42:48' ========================2022-12-06 10:42:48======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206104637wBhE2' 0 = 1 cnt = 1 ========================2022-12-06 10:42:48======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woncy77' 0 = woncy77 Mid = woncy77 1 = 신평산업 Mcompany = 신평산업 2 = 7540701070 companyNum = 7540701070 3 = 033-764-7780 Mtel1 = 033-764-7780 4 = 010-5213-4194 Mhp = 010-5213-4194 ========================2022-12-06 10:42:48======================== select * from customers where id = 'woncy77' ========================2022-12-06 10:42:48======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woncy77','2022-12-06 10:42:48','52500','55000','온라인','0') ========================2022-12-06 12:54:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hjss1005-1670298831 LGD_BUYER = 홍성신 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206125351 LGD_HASHDATA = 44046965cbe9e67612c7152d7fecbcbd 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 = 20221206125903D2FF848102B391E76B9CDC62D249FBF59FD4144B Mname = 홍성신 Mcompany = 주식회사 제이유수산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = hjss1005 LGD_ESCROW_USEYN = N ========================2022-12-06 12:54:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206125903 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 101748 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850309****895* LGD_FINANCEAUTHNUM = 48269455 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9bb8632ef6ce6c7c1d5998d53ce0da3b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221206125904 LGD_PCANCELSTR = 0 LGD_BUYER = 홍성신 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212061259032kIy2 LGD_BUYERID = LGD_OID = Direct-hjss1005-1670298831 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61259032KPK2 ========================2022-12-06 12:54:56======================== insert into mBoard_order set rOrdNo = 'Direct-hjss1005-1670298831', AuthTy = 'card', memberId = 'hjss1005', OrdNm ='홍성신', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 제이유수산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850309****895*', rApprNo = 'mjsof202212061259032kIy2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 12:54:56', InvoiceNum = '결제성공:Direct-hjss1005-1670298831/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 12:54:56' ========================2022-12-06 12:54:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202212061259032kIy2' 0 = 1 cnt = 1 ========================2022-12-06 12:54:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hjss1005' 0 = hjss1005 Mid = hjss1005 1 = 주식회사 제이유수산 Mcompany = 주식회사 제이유수산 2 = 291-81-02603 companyNum = 291-81-02603 3 = 010-2812-2541 Mtel1 = 010-2812-2541 4 = 010-2812-2541 Mhp = 010-2812-2541 ========================2022-12-06 12:54:56======================== select * from customers where id = 'hjss1005' ========================2022-12-06 12:54:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hjss1005','2022-12-06 12:54:56','52500','55000','온라인','0') ========================2022-12-06 13:11:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjk6788-1670299791 LGD_BUYER = 전중근 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206130951 LGD_HASHDATA = f0073df952e58b5df06349952499896e 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 = 202212061315499EE2DB404AA5B132F9F30DA8326CF8445336AA3B Mname = 전중근 Mcompany = 동송유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = jjk6788 LGD_ESCROW_USEYN = N ========================2022-12-06 13:11:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206131550 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 = 45749380****961* LGD_FINANCEAUTHNUM = 00282254 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ee7b2d04757911245dc2af009361a73 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20221206131550 LGD_PCANCELSTR = 0 LGD_BUYER = 전중근 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221206131550TT3A2 LGD_BUYERID = LGD_OID = Direct-jjk6788-1670299791 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 13:11:42======================== insert into mBoard_order set rOrdNo = 'Direct-jjk6788-1670299791', AuthTy = 'card', memberId = 'jjk6788', OrdNm ='전중근', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동송유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****961*', rApprNo = 'mjsof20221206131550TT3A2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 13:11:42', InvoiceNum = '결제성공:Direct-jjk6788-1670299791/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 13:11:42' ========================2022-12-06 13:11:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206131550TT3A2' 0 = 1 cnt = 1 ========================2022-12-06 13:11:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjk6788' 0 = jjk6788 Mid = jjk6788 1 = 동송유통 Mcompany = 동송유통 2 = 127-40-50704 companyNum = 127-40-50704 3 = 033-455-9624 Mtel1 = 033-455-9624 4 = 010-3823-9624 Mhp = 010-3823-9624 ========================2022-12-06 13:11:42======================== select * from customers where id = 'jjk6788' ========================2022-12-06 13:11:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjk6788','2022-12-06 13:11:42','30900','33000','온라인','0') ========================2022-12-06 14:08:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-snbfood-1670303260 LGD_BUYER = 임승순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206140741 LGD_HASHDATA = a5b9f13e615b44b1a3a9cf423983c060 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 = 202212061412295E4E7DB2C80F60E110A2FDA34065B86B919D4AE3 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-12-06 14:08:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206141230 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 = 72119106 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = aca9134202d6a4b7fc54d7670d4b51d8 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20221206141231 LGD_PCANCELSTR = 0 LGD_BUYER = 임승순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221206141230Bhgb1 LGD_BUYERID = LGD_OID = Direct-snbfood-1670303260 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 14:08:22======================== insert into mBoard_order set rOrdNo = 'Direct-snbfood-1670303260', 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 = 'mjsof20221206141230Bhgb1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 14:08:22', InvoiceNum = '결제성공:Direct-snbfood-1670303260/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 14:08:22' ========================2022-12-06 14:08:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206141230Bhgb1' 0 = 1 cnt = 1 ========================2022-12-06 14:08:23======================== 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-12-06 14:08:23======================== select * from customers where id = 'snbfood' ========================2022-12-06 14:08:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('snbfood','2022-12-06 14:08:22','30900','33000','온라인','0') ========================2022-12-06 15:43:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1670308833 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206154033 LGD_HASHDATA = 92d0467f35c18f60063112b5548f31f7 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 = 20221206154746B8EA1DEE59BA572F0361B4648CC5C6EED5BEBB2B Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2022-12-06 15:43:39======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206154747 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = neotool@neotool.co.kr LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62500305****294* LGD_FINANCEAUTHNUM = 49896074 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 448aa015b2057936b5b2ec939225bb2b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221206154747 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202212061547472wWS8 LGD_BUYERID = LGD_OID = Direct-neotool-1670308833 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61547472Tra4 ========================2022-12-06 15:43:39======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1670308833', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62500305****294*', rApprNo = 'mjsof202212061547472wWS8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 15:43:39', InvoiceNum = '결제성공:Direct-neotool-1670308833/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 15:43:39' ========================2022-12-06 15:43:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202212061547472wWS8' 0 = 1 cnt = 1 ========================2022-12-06 15:43:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2022-12-06 15:43:39======================== select * from customers where id = 'neotool' ========================2022-12-06 15:43:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2022-12-06 15:43:39','108000','110000','온라인','0') ========================2022-12-06 21:16:50======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-easy0103-1670328639 LGD_BUYER = 허영일 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206211039 LGD_HASHDATA = 535f304557ca4a1fbd03f1898605f930 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 = 20221206212058EDBC5094772F17CF5DB10C8CD5F0B9E0B7D92421 Mname = 허영일 Mcompany = 성남꽃도매 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = easy0103 LGD_ESCROW_USEYN = N ========================2022-12-06 21:16:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206212059 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 = 53107080****279* LGD_FINANCEAUTHNUM = 86703863 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c0e86a1543f7ea818d9d7f1c4141cb85 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20221206212059 LGD_PCANCELSTR = 0 LGD_BUYER = 허영일 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221206212059kSAR1 LGD_BUYERID = LGD_OID = Direct-easy0103-1670328639 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-12-06 21:16:51======================== insert into mBoard_order set rOrdNo = 'Direct-easy0103-1670328639', AuthTy = 'card', memberId = 'easy0103', OrdNm ='허영일', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '성남꽃도매', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '삼성MASTER 53107080****279*', rApprNo = 'mjsof20221206212059kSAR1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 21:16:51', InvoiceNum = '결제성공:Direct-easy0103-1670328639/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 21:16:51' ========================2022-12-06 21:16:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206212059kSAR1' 0 = 1 cnt = 1 ========================2022-12-06 21:16:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'easy0103' 0 = easy0103 Mid = easy0103 1 = 성남꽃도매 Mcompany = 성남꽃도매 2 = 314-90-43855 companyNum = 314-90-43855 3 = 042-471-6356 Mtel1 = 042-471-6356 4 = 011-408-1404 Mhp = 011-408-1404 ========================2022-12-06 21:16:51======================== select * from customers where id = 'easy0103' ========================2022-12-06 21:16:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('easy0103','2022-12-06 21:16:51','30900','33000','온라인','0') ========================2022-12-06 23:23:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sjretail-1670336528 LGD_BUYER = 김선재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221206232208 LGD_HASHDATA = f20ce7f3b04a4c22257d7e176a04e210 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 = 202212062327372039FEECC8DCBB07B3C53E1B45FFC7C7D199440F Mname = 김선재 Mcompany = (주)에스제이리테일 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = sjretail LGD_ESCROW_USEYN = N ========================2022-12-06 23:23:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221206232737 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413211****192* LGD_FINANCEAUTHNUM = 52758510 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2faa34ed218c223d5049482a5a060f64 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221206232738 LGD_PCANCELSTR = 0 LGD_BUYER = 김선재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221206232737ihbo4 LGD_BUYERID = LGD_OID = Direct-sjretail-1670336528 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6232737iT6s0 ========================2022-12-06 23:23:29======================== insert into mBoard_order set rOrdNo = 'Direct-sjretail-1670336528', AuthTy = 'card', memberId = 'sjretail', OrdNm ='김선재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에스제이리테일', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413211****192*', rApprNo = 'mjsof20221206232737ihbo4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-12-06 23:23:29', InvoiceNum = '결제성공:Direct-sjretail-1670336528/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-12-06 23:23:29' ========================2022-12-06 23:23:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221206232737ihbo4' 0 = 1 cnt = 1 ========================2022-12-06 23:23:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sjretail' 0 = sjretail Mid = sjretail 1 = (주)에스제이리테일 Mcompany = (주)에스제이리테일 2 = 5058700113 companyNum = 5058700113 3 = 070-8827-8084 Mtel1 = 070-8827-8084 4 = 010-3856-8084 Mhp = 010-3856-8084 ========================2022-12-06 23:23:29======================== select * from customers where id = 'sjretail' ========================2022-12-06 23:23:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sjretail','2022-12-06 23:23:29','52500','55000','온라인','0')