========================2021-04-30 12:03:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ch2005-1619751637 LGD_BUYER = 김도연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430120037 LGD_HASHDATA = 4ae653d0523c39201a21599c38ad8ae7 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202104301203117F5FB8368B9A44B9BAFD4158F68F0EC0JPNU5RO6 Mname = 김도연 Mcompany = (주)대복식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ch2005 LGD_ESCROW_USEYN = N ========================2021-04-30 12:03:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430120311 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = calling19@naver.com 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 = 553180******0425 LGD_FINANCEAUTHNUM = 73445165 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 85f102d506efc858cb2f977f46ce2739 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210430120312 LGD_PCANCELSTR = 0 LGD_BUYER = 김도연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043012031161051 LGD_BUYERID = LGD_OID = Direct-ch2005-1619751637 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-30 12:03:04======================== insert into mBoard_order set rOrdNo = 'Direct-ch2005-1619751637', AuthTy = 'card', memberId = 'ch2005', OrdNm ='김도연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)대복식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 553180******0425', rApprNo = 'mjsof2021043012031161051', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 12:03:04', InvoiceNum = '결제성공:Direct-ch2005-1619751637/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 12:03:04' ========================2021-04-30 12:03:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043012031161051' 0 = 1 cnt = 1 ========================2021-04-30 12:03:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ch2005' 0 = ch2005 Mid = ch2005 1 = (주)대복식품 Mcompany = (주)대복식품 2 = 3168110187 companyNum = 3168110187 3 = 031-296-7618 Mtel1 = 031-296-7618 4 = 010-3125-7618 Mhp = 010-3125-7618 ========================2021-04-30 12:03:04======================== select * from customers where id = 'ch2005' ========================2021-04-30 12:03:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ch2005','2021-04-30 12:03:04','220000','220000','온라인','0') ========================2021-04-30 12:04:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ch2005-1619751814 LGD_BUYER = 김도연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430120334 LGD_HASHDATA = 515212d486defe06cd357df3cda3d57c LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210430120435ED3575B22AB244F99279C6A0D7559A33DWOX5TYU Mname = 김도연 Mcompany = (주)대복식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ch2005 LGD_ESCROW_USEYN = N ========================2021-04-30 12:04:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430120435 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = calling19@naver.com 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 = 553180******0425 LGD_FINANCEAUTHNUM = 73461398 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4b89eaebbac67b425ef1d48183d163d1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210430120436 LGD_PCANCELSTR = 0 LGD_BUYER = 김도연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043012043561081 LGD_BUYERID = LGD_OID = Direct-ch2005-1619751814 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-30 12:04:28======================== insert into mBoard_order set rOrdNo = 'Direct-ch2005-1619751814', AuthTy = 'card', memberId = 'ch2005', OrdNm ='김도연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)대복식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 553180******0425', rApprNo = 'mjsof2021043012043561081', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 12:04:28', InvoiceNum = '결제성공:Direct-ch2005-1619751814/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 12:04:28' ========================2021-04-30 12:04:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043012043561081' 0 = 1 cnt = 1 ========================2021-04-30 12:04:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ch2005' 0 = ch2005 Mid = ch2005 1 = (주)대복식품 Mcompany = (주)대복식품 2 = 3168110187 companyNum = 3168110187 3 = 031-296-7618 Mtel1 = 031-296-7618 4 = 010-3125-7618 Mhp = 010-3125-7618 ========================2021-04-30 12:04:28======================== select * from customers where id = 'ch2005' ========================2021-04-30 12:04:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ch2005','2021-04-30 12:04:28','220000','220000','온라인','0') ========================2021-04-30 14:37:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dysystem-1619761006 LGD_BUYER = 성열탁 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430143646 LGD_HASHDATA = 3c61132485272cf11f1bf0bdb5e65efb LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210430143802C87255D58DA54585AA7FE9D21C1CCECCYC8FNMSU Mname = 성열탁 Mcompany = 동양계량시스템 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dysystem LGD_ESCROW_USEYN = N ========================2021-04-30 14:37:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430143803 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 = 541145******7230 LGD_FINANCEAUTHNUM = 66531057 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 0b7713227e2b069ee63dd940351846f4 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210430143803 LGD_PCANCELSTR = 0 LGD_BUYER = 성열탁 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043014380361245 LGD_BUYERID = LGD_OID = Direct-dysystem-1619761006 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-30 14:37:55======================== insert into mBoard_order set rOrdNo = 'Direct-dysystem-1619761006', AuthTy = 'card', memberId = 'dysystem', OrdNm ='성열탁', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동양계량시스템', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '삼성MASTER 541145******7230', rApprNo = 'mjsof2021043014380361245', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 14:37:55', InvoiceNum = '결제성공:Direct-dysystem-1619761006/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 14:37:55' ========================2021-04-30 14:37:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043014380361245' 0 = 1 cnt = 1 ========================2021-04-30 14:37:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dysystem' 0 = dysystem Mid = dysystem 1 = 동양계량시스템 Mcompany = 동양계량시스템 2 = 401-04-95974 companyNum = 401-04-95974 3 = 063-461-9988 Mtel1 = 063-461-9988 4 = 010-2739-3597 Mhp = 010-2739-3597 ========================2021-04-30 14:37:55======================== select * from customers where id = 'dysystem' ========================2021-04-30 14:37:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dysystem','2021-04-30 14:37:55','52500','55000','온라인','0') ========================2021-04-30 16:25:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yhk8100-1619767448 LGD_BUYER = 이정훈 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430162408 LGD_HASHDATA = 2c8163913208ccf1a5eca966757260a8 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210430162548604730F188DF4B678DDC8A6FBC937ED78D1ESIPV Mname = 이정훈 Mcompany = (주)신협상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yhk8100 LGD_ESCROW_USEYN = N ========================2021-04-30 16:25:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430162548 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 733393 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943003******3927 LGD_FINANCEAUTHNUM = 41807582 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 03ba0caf82c9c1f9b25d8ca7dde23000 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210430162549 LGD_PCANCELSTR = 0 LGD_BUYER = 이정훈 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043016254861072 LGD_BUYERID = LGD_OID = Direct-yhk8100-1619767448 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 016254861038 ========================2021-04-30 16:25:41======================== insert into mBoard_order set rOrdNo = 'Direct-yhk8100-1619767448', AuthTy = 'card', memberId = 'yhk8100', OrdNm ='이정훈', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)신협상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 943003******3927', rApprNo = 'mjsof2021043016254861072', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 16:25:41', InvoiceNum = '결제성공:Direct-yhk8100-1619767448/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 16:25:41' ========================2021-04-30 16:25:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043016254861072' 0 = 1 cnt = 1 ========================2021-04-30 16:25:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yhk8100' 0 = yhk8100 Mid = yhk8100 1 = (주)신협상사 Mcompany = (주)신협상사 2 = 1288158323 companyNum = 1288158323 3 = 02-381-8100 Mtel1 = 02-381-8100 4 = 011-9834-3324 Mhp = 011-9834-3324 ========================2021-04-30 16:25:41======================== select * from customers where id = 'yhk8100' ========================2021-04-30 16:25:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yhk8100','2021-04-30 16:25:41','52500','55000','온라인','0') ========================2021-04-30 17:00:37======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-daehungsj-1619769576 LGD_BUYER = 박현진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430165936 LGD_HASHDATA = 70b12748b86e50bdc5a93ad34aecafd9 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210430170045B26BF75D77104A7DBF281C5E5D46B789BZJKYIZ4 Mname = 박현진 Mcompany = (주)대흥수지 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = daehungsj LGD_ESCROW_USEYN = N ========================2021-04-30 17:00:38======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430170045 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 738987 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943003******8969 LGD_FINANCEAUTHNUM = 42265888 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 87b2af7e4f133a4b143d3a6ac71fcfd2 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210430170046 LGD_PCANCELSTR = 0 LGD_BUYER = 박현진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043017004561163 LGD_BUYERID = LGD_OID = Direct-daehungsj-1619769576 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 017004561154 ========================2021-04-30 17:00:38======================== insert into mBoard_order set rOrdNo = 'Direct-daehungsj-1619769576', AuthTy = 'card', memberId = 'daehungsj', OrdNm ='박현진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)대흥수지', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 943003******8969', rApprNo = 'mjsof2021043017004561163', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 17:00:38', InvoiceNum = '결제성공:Direct-daehungsj-1619769576/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 17:00:38' ========================2021-04-30 17:00:38======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043017004561163' 0 = 1 cnt = 1 ========================2021-04-30 17:00:38======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'daehungsj' 0 = daehungsj Mid = daehungsj 1 = (주)대흥수지 Mcompany = (주)대흥수지 2 = 124-86-19866 companyNum = 124-86-19866 3 = 031-8065-4740 Mtel1 = 031-8065-4740 4 = 010-8507-0449 Mhp = 010-8507-0449 ========================2021-04-30 17:00:38======================== select * from customers where id = 'daehungsj' ========================2021-04-30 17:00:38======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('daehungsj','2021-04-30 17:00:38','108000','110000','온라인','0') ========================2021-04-30 18:17:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-bakingjeju-1619774112 LGD_BUYER = 박동춘 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430181512 LGD_HASHDATA = 1eed9777feb01a2929fb9208f0238bcd LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210430181713F95B05F91A71448C990D12D26CC01239LVJHVQOU Mname = 박동춘 Mcompany = 주식회사 베이킹제주 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = bakingjeju LGD_ESCROW_USEYN = N ========================2021-04-30 18:17:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430181714 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 756451 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 419803******2951 LGD_FINANCEAUTHNUM = 42936107 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = d1c0e4f55c6e1695ca01005172cc9865 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210430181715 LGD_PCANCELSTR = 0 LGD_BUYER = 박동춘 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043018171361166 LGD_BUYERID = LGD_OID = Direct-bakingjeju-1619774112 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 018171361190 ========================2021-04-30 18:17:07======================== insert into mBoard_order set rOrdNo = 'Direct-bakingjeju-1619774112', AuthTy = 'card', memberId = 'bakingjeju', OrdNm ='박동춘', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 베이킹제주', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 419803******2951', rApprNo = 'mjsof2021043018171361166', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 18:17:07', InvoiceNum = '결제성공:Direct-bakingjeju-1619774112/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 18:17:07' ========================2021-04-30 18:17:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043018171361166' 0 = 1 cnt = 1 ========================2021-04-30 18:17:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'bakingjeju' 0 = bakingjeju Mid = bakingjeju 1 = 주식회사 베이킹제주 Mcompany = 주식회사 베이킹제주 2 = 5488800984 companyNum = 5488800984 3 = 010-4467-8900 Mtel1 = 010-4467-8900 4 = 010-4467-8900 Mhp = 010-4467-8900 ========================2021-04-30 18:17:07======================== select * from customers where id = 'bakingjeju' ========================2021-04-30 18:17:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('bakingjeju','2021-04-30 18:17:07','108000','110000','온라인','0') ========================2021-04-30 21:04:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-feinstyle-1619784231 LGD_BUYER = 최대영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210430210351 LGD_HASHDATA = 3cab0846ae10b756fa5d7d865b1856b4 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 202104302104532F6C6A6808834F0BB0A2EAE2244C00A7U2TZXMK1 Mname = 최대영 Mcompany = 더바이스산업공구상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = feinstyle LGD_ESCROW_USEYN = N ========================2021-04-30 21:04:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210430210453 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 = 473867******3997 LGD_FINANCEAUTHNUM = 63109269 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4a677bcea634f8f5743d833a32ebe859 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20210430210454 LGD_PCANCELSTR = 0 LGD_BUYER = 최대영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021043021045360154 LGD_BUYERID = LGD_OID = Direct-feinstyle-1619784231 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-04-30 21:04:46======================== insert into mBoard_order set rOrdNo = 'Direct-feinstyle-1619784231', AuthTy = 'card', memberId = 'feinstyle', OrdNm ='최대영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '더바이스산업공구상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성VISA 473867******3997', rApprNo = 'mjsof2021043021045360154', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-04-30 21:04:46', InvoiceNum = '결제성공:Direct-feinstyle-1619784231/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-04-30 21:04:46' ========================2021-04-30 21:04:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021043021045360154' 0 = 1 cnt = 1 ========================2021-04-30 21:04:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'feinstyle' 0 = feinstyle Mid = feinstyle 1 = 더바이스산업공구상사 Mcompany = 더바이스산업공구상사 2 = 621-21-51072 companyNum = 621-21-51072 3 = 070-4127-0909 Mtel1 = 070-4127-0909 4 = 010-4437-6515 Mhp = 010-4437-6515 ========================2021-04-30 21:04:46======================== select * from customers where id = 'feinstyle' ========================2021-04-30 21:04:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('feinstyle','2021-04-30 21:04:46','10000','11000','온라인','0')