========================2023-01-30 11:04:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1675044220 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230130110340 LGD_HASHDATA = a4d7d85c6886af066e71476e68542023 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 = 20230130111003EA6878436B684B2CAA544E878BBA30E368BEA657 Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-01-30 11:04:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230130111004 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94512000****708* LGD_FINANCEAUTHNUM = 61646283 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 084604f40e261562f6787a4642f452c9 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230130111004 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230130111003pTRW4 LGD_BUYERID = LGD_OID = Direct-k114-1675044220 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0111003pfYd3 ========================2023-01-30 11:05:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1675044220 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230130110340 LGD_HASHDATA = a4d7d85c6886af066e71476e68542023 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 = 20230130111003EA6878436B684B2CAA544E878BBA30E368BEA657 Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-01-30 11:05:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230130111012 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-k114-1675044220]는 2023/01/30 11:10:03 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 61646283 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 27ae491af79f1667735c6acaa81bdff0 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20230130111012 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof20230130111003pTRW4 LGD_BUYERID = LGD_OID = Direct-k114-1675044220 LGD_RESPCODE = S007 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2023-01-30 11:06:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1675044335 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230130110535 LGD_HASHDATA = 34feafa3b284ff7dd82679d01936ac8b 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 = 20230130111127B2058F95841A1668E46849314E7EC60E92BB690C Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-01-30 11:06:20======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230130111128 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****736* LGD_FINANCEAUTHNUM = 61656099 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f5f7e29ff7e353db91014a7b74923c9d LGD_BUYERADDRESS = LGD_FINANCENAME = 우리MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230130111128 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230130111127VEcO4 LGD_BUYERID = LGD_OID = Direct-k114-1675044335 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0111127VGL80 ========================2023-01-30 11:09:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1675044503 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230130110823 LGD_HASHDATA = e24757205ce772231c6395a27b7d10d3 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 = 202301301114123BF23A1469BEB3F3A02D58CEEC3C93984F8C970E Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-01-30 11:09:05======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230130111413 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94512000****708* LGD_FINANCEAUTHNUM = 61668313 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 53302c7aa1bc53de89ff49cffb9e791e LGD_BUYERADDRESS = LGD_FINANCENAME = 우리 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230130111413 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202301301114132Z5X3 LGD_BUYERID = LGD_OID = Direct-k114-1675044503 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 01114132lja2 ========================2023-01-30 11:09:05======================== insert into mBoard_order set rOrdNo = 'Direct-k114-1675044503', AuthTy = 'card', memberId = 'k114', OrdNm ='김상옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강원산업안전(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리 94512000****708*', rApprNo = 'mjsof202301301114132Z5X3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-30 11:09:05', InvoiceNum = '결제성공:Direct-k114-1675044503/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-30 11:09:05' ========================2023-01-30 11:09:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202301301114132Z5X3' 0 = 1 cnt = 1 ========================2023-01-30 11:09:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k114' 0 = k114 Mid = k114 1 = 강원산업안전(주) Mcompany = 강원산업안전(주) 2 = 2388100225 companyNum = 2388100225 3 = 033-732-3114 Mtel1 = 033-732-3114 4 = 010-5115-3114 Mhp = 010-5115-3114 ========================2023-01-30 11:09:05======================== select * from customers where id = 'k114' ========================2023-01-30 11:09:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k114','2023-01-30 11:09:05','220000','220000','온라인','0') ========================2023-01-30 21:19:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mibaek-1675081082 LGD_BUYER = 임준범 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230130211802 LGD_HASHDATA = fe19ee99c5fd01435d4d74a7f211eac3 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 = 202301302125057758F8E62AF0D1AE87C109D5F2EBA116064188EE Mname = 임준범 Mcompany = (주)미백 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = mibaek LGD_ESCROW_USEYN = N ========================2023-01-30 21:19:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230130212506 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003320 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****686* LGD_FINANCEAUTHNUM = 30064756 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 094aacbb7cbf938bae091e11747e4825 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230130212506 LGD_PCANCELSTR = 0 LGD_BUYER = 임준범 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230130212505SM7u6 LGD_BUYERID = LGD_OID = Direct-mibaek-1675081082 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0212505SLSg2 ========================2023-01-30 21:19:57======================== insert into mBoard_order set rOrdNo = 'Direct-mibaek-1675081082', AuthTy = 'card', memberId = 'mibaek', OrdNm ='임준범', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)미백', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****686*', rApprNo = 'mjsof20230130212505SM7u6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-01-30 21:19:57', InvoiceNum = '결제성공:Direct-mibaek-1675081082/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-01-30 21:19:57' ========================2023-01-30 21:19:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230130212505SM7u6' 0 = 1 cnt = 1 ========================2023-01-30 21:19:57======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mibaek' 0 = mibaek Mid = mibaek 1 = (주)미백 Mcompany = (주)미백 2 = 1268646239 companyNum = 1268646239 3 = 070-4036-5559 Mtel1 = 070-4036-5559 4 = 010-9489-9618 Mhp = 010-9489-9618 ========================2023-01-30 21:19:57======================== select * from customers where id = 'mibaek' ========================2023-01-30 21:19:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mibaek','2023-01-30 21:19:57','108000','110000','온라인','0')