========================2022-04-06 11:11:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1649211017 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406111017 LGD_HASHDATA = bc2f8f62c42abeadf1d284a9c5b741f7 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 = 2022040611164389FBFCD10B1B46F78227C92CD2BCB79DUHEOL225 Mname = 오정호 Mcompany = 메인로드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kds1 LGD_ESCROW_USEYN = N ========================2022-04-06 11:11:16======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406111644 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******9875 LGD_FINANCEAUTHNUM = 30132964 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a18b8a321fcb16aa1d51a27b4cc3a596 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406111644 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061116448kUN1 LGD_BUYERID = LGD_OID = Direct-kds1-1649211017 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61116448L6n3 ========================2022-04-06 11:11:16======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1649211017', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******9875', rApprNo = 'mjsof202204061116448kUN1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-06 11:11:16', InvoiceNum = '결제성공:Direct-kds1-1649211017/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-06 11:11:16' ========================2022-04-06 11:11:16======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202204061116448kUN1' 0 = 1 cnt = 1 ========================2022-04-06 11:11:16======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kds1' 0 = kds1 Mid = kds1 1 = 메인로드 Mcompany = 메인로드 2 = 1180300092 companyNum = 1180300092 3 = 031-267-3340 Mtel1 = 031-267-3340 4 = 010-8680-1206 Mhp = 010-8680-1206 ========================2022-04-06 11:11:16======================== select * from customers where id = 'kds1' ========================2022-04-06 11:11:16======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2022-04-06 11:11:16','52500','55000','온라인','0') ========================2022-04-06 13:57:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jlgis0421-1649221014 LGD_BUYER = 이종욱 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406135654 LGD_HASHDATA = 1df067433998ca33527d1c562cba93f6 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 = 202204061403099E501F0E3D7442F99B90E95F4CBA8796WNZRVHOV Mname = 이종욱 Mcompany = 제이엘산전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = jlgis0421 LGD_ESCROW_USEYN = N ========================2022-04-06 13:57:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406140310 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003338 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******7895 LGD_FINANCEAUTHNUM = 30014581 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3851a9b753b51dc1ed1a2b7351c1837c LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406140310 LGD_PCANCELSTR = 0 LGD_BUYER = 이종욱 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061403105dFv5 LGD_BUYERID = LGD_OID = Direct-jlgis0421-1649221014 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61403105qzg0 ========================2022-04-06 13:57:42======================== insert into mBoard_order set rOrdNo = 'Direct-jlgis0421-1649221014', AuthTy = 'card', memberId = 'jlgis0421', OrdNm ='이종욱', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '제이엘산전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******7895', rApprNo = 'mjsof202204061403105dFv5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-06 13:57:42', InvoiceNum = '결제성공:Direct-jlgis0421-1649221014/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-06 13:57:42' ========================2022-04-06 13:57:42======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202204061403105dFv5' 0 = 1 cnt = 1 ========================2022-04-06 13:57:42======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jlgis0421' 0 = jlgis0421 Mid = jlgis0421 1 = 제이엘산전 Mcompany = 제이엘산전 2 = 1343255982 companyNum = 1343255982 3 = 070-4755-4955 Mtel1 = 070-4755-4955 4 = 010-9979-1973 Mhp = 010-9979-1973 ========================2022-04-06 13:57:42======================== select * from customers where id = 'jlgis0421' ========================2022-04-06 13:57:42======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jlgis0421','2022-04-06 13:57:42','52500','55000','온라인','0') ========================2022-04-06 14:53:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224339 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406145219 LGD_HASHDATA = 21774a380d4d04b63fddd524ad7bbbb6 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 = 20220406145923C9BB1078B1F6461BB02BAE78BAC68C30SODWU5WF Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 14:53:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406145923 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004651 LGD_RESPMSG = 도난/분실,위,변조카드 LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 04238ebd73d3a0aa272e32f1bc0295fe LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406145923 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061459238zco8 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224339 LGD_RESPCODE = 0026 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-04-06 14:54:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224339 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406145219 LGD_HASHDATA = 21774a380d4d04b63fddd524ad7bbbb6 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 = 20220406145923C9BB1078B1F6461BB02BAE78BAC68C30SODWU5WF Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 14:54:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406145946 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004651 LGD_RESPMSG = 잘못된 결제요청입니다. 다시 시도해 주시기 바랍니다. LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = cc515d477edfb2122de5a9983d4b0060 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406145946 LGD_PCANCELSTR = 부분취소 불가 카드입니다. LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061459238zco8 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224339 LGD_RESPCODE = 0204 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-04-06 14:58:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224557 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406145557 LGD_HASHDATA = 09acaf2062c947bca9b06e4f420b6d68 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 = 20220406150415EA77610D33D140D0AD2329F41DEA2F35ARDKCQWF Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 14:58:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406150416 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 = 558526******0625 LGD_FINANCEAUTHNUM = 30040797 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 522e447d5dfbb92f37597017f0fe8a0d LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406150416 LGD_PCANCELSTR = 0 LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061504152tRX1 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224557 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61504152YED9 ========================2022-04-06 15:01:08======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224801 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406150001 LGD_HASHDATA = 460ce63cc189b1072455094eebca91bd 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 = 2022040615063658ECB88E19124DEABB1F98B689449BD0JLP3WSQ7 Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 15:01:09======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406150637 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 = 558526******0625 LGD_FINANCEAUTHNUM = 30040809 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 31e3ad533ca3812acbed15cf89697836 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406150637 LGD_PCANCELSTR = 0 LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061506362tWL9 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224801 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61506362YGG6 ========================2022-04-06 15:01:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224801 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406150001 LGD_HASHDATA = 460ce63cc189b1072455094eebca91bd 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 = 2022040615063658ECB88E19124DEABB1F98B689449BD0JLP3WSQ7 Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 15:01:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406150659 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 요청하신 거래[주문번호:Direct-lyj4819-1649224801]는 2022/04/06 15:06:36 에 이미 신용카드로 결제로 시도한 거래입니다. 상점연락처[02-401-5121] LGD_2TR_FLAG = Y LGD_CARDNUM = **************** LGD_FINANCEAUTHNUM = 30040809 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = LGD_CARDGUBUN1 = 9 LGD_CARDGUBUN2 = 9 LGD_HASHDATA = 42122b04074ea7661963c7d3d6a676b5 LGD_BUYERADDRESS = LGD_FINANCENAME = LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 0 LGD_DEVICE = LGD_TIMESTAMP = 20220406150659 LGD_PCANCELSTR = 0 LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = 0 LGD_TID = mjsof202204061506362tWL9 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224801 LGD_RESPCODE = S007 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 0 LGD_MID = mjsoft007 LGD_ISPKEY = ========================2022-04-06 15:03:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-lyj4819-1649224949 LGD_BUYER = 이영재 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406150229 LGD_HASHDATA = bc03f434dcecbae4a7476cef85d7e69f 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 = 2022040615084697D84E5D91094621B540352CF0084DC3HUHK0ZDT Mname = 이영재 Mcompany = 신성골재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = lyj4819 LGD_ESCROW_USEYN = N ========================2022-04-06 15:03:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406150847 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 = 558526******0625 LGD_FINANCEAUTHNUM = 30040810 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 39e7b15c1f80d95a3ef3f6a3e892a9e5 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220406150847 LGD_PCANCELSTR = 0 LGD_BUYER = 이영재 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061508465g8f5 LGD_BUYERID = LGD_OID = Direct-lyj4819-1649224949 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61508465rEo2 ========================2022-04-06 15:03:19======================== insert into mBoard_order set rOrdNo = 'Direct-lyj4819-1649224949', AuthTy = 'card', memberId = 'lyj4819', OrdNm ='이영재', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신성골재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******0625', rApprNo = 'mjsof202204061508465g8f5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-06 15:03:19', InvoiceNum = '결제성공:Direct-lyj4819-1649224949/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-06 15:03:19' ========================2022-04-06 15:03:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202204061508465g8f5' 0 = 1 cnt = 1 ========================2022-04-06 15:03:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'lyj4819' 0 = lyj4819 Mid = lyj4819 1 = 신성골재 Mcompany = 신성골재 2 = 6603200410 companyNum = 6603200410 3 = 010-5453-7583 Mtel1 = 010-5453-7583 4 = 010-5453-7583 Mhp = 010-5453-7583 ========================2022-04-06 15:03:19======================== select * from customers where id = 'lyj4819' ========================2022-04-06 15:03:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('lyj4819','2022-04-06 15:03:19','108000','110000','온라인','0') ========================2022-04-06 15:12:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jsjs1018-1649225440 LGD_BUYER = 전성림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406151040 LGD_HASHDATA = 50e1e296c006330b7bd7dbbac938d9dc 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 = 20220406151748D96EB7E7D0884E0D8FFEE8ED8E05F181VRZLLBQV 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-04-06 15:12:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406151749 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 941061******7781 LGD_FINANCEAUTHNUM = 11706671 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7f4c1aa305fe6125bc369b107500e877 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220406151749 LGD_PCANCELSTR = 0 LGD_BUYER = 전성림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061517497neK6 LGD_BUYERID = LGD_OID = Direct-jsjs1018-1649225440 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-04-06 15:12:21======================== insert into mBoard_order set rOrdNo = 'Direct-jsjs1018-1649225440', AuthTy = 'card', memberId = 'jsjs1018', OrdNm ='전성림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '혜 창', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한 941061******7781', rApprNo = 'mjsof202204061517497neK6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-06 15:12:21', InvoiceNum = '결제성공:Direct-jsjs1018-1649225440/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-06 15:12:21' ========================2022-04-06 15:12:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202204061517497neK6' 0 = 1 cnt = 1 ========================2022-04-06 15:12:21======================== 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-04-06 15:12:21======================== select * from customers where id = 'jsjs1018' ========================2022-04-06 15:12:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jsjs1018','2022-04-06 15:12:21','52500','55000','온라인','0') ========================2022-04-06 17:22:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-olym8561-1649233255 LGD_BUYER = 이수연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406172055 LGD_HASHDATA = 736f5fc33e35c254bfd394c539efa498 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 = 20220406172740F5798F30C94A40159F096721CA7BBD0DYCNEIL8M Mname = 이수연 Mcompany = (주)올림포스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = olym8561 LGD_ESCROW_USEYN = N ========================2022-04-06 17:22:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406172741 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414025******5995 LGD_FINANCEAUTHNUM = 63491836 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bb4b4c37a5018d9ea873d155ac6a2df8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220406172742 LGD_PCANCELSTR = 0 LGD_BUYER = 이수연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061727417rNz1 LGD_BUYERID = LGD_OID = Direct-olym8561-1649233255 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61727417rk53 ========================2022-04-06 18:27:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-inho7353-1649237119 LGD_BUYER = 유인호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406182519 LGD_HASHDATA = a94059082ddb711d9d854ab943e6d4e5 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 = 202204061832300C8376C2EE634C2F813F3B7F1EC64440MQMD0MB8 Mname = 유인호 Mcompany = 삼화상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = inho7353 LGD_ESCROW_USEYN = N ========================2022-04-06 18:27:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406183230 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 943003******6963 LGD_FINANCEAUTHNUM = 32096688 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b802cd85715f05a19005bca393d58d2c LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220406183231 LGD_PCANCELSTR = 0 LGD_BUYER = 유인호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220406183230axag8 LGD_BUYERID = LGD_OID = Direct-inho7353-1649237119 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6183230acZO0 ========================2022-04-06 18:28:57======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-inho7353-1649237291 LGD_BUYER = 유인호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220406182811 LGD_HASHDATA = 110443fb34d7e8d9b6b677228f2bb46b 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 = 2022040618342571D6C09A59EC40E19423E2394EE2EF4DNVTAICSX Mname = 유인호 Mcompany = 삼화상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = inho7353 LGD_ESCROW_USEYN = N ========================2022-04-06 18:28:58======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220406183426 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 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 = 943003******6963 LGD_FINANCEAUTHNUM = 32104187 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ae647fecd33ab99e4f33d08aa4e6d5d6 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220406183426 LGD_PCANCELSTR = 0 LGD_BUYER = 유인호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202204061834257tMT7 LGD_BUYERID = LGD_OID = Direct-inho7353-1649237291 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 61834257sbr1