========================2021-02-01 10:49:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-servomecha-1612144112 LGD_BUYER = 황교석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201104832 LGD_HASHDATA = df15c4ebd26005565fda92daa11bd7e8 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 = 202102011049453ADB41A46E23124E1300A308A23CF4A2B5330366 Mname = 황교석 Mcompany = 한일상공사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = servomecha LGD_ESCROW_USEYN = N ========================2021-02-01 10:49:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201104945 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 004249 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 557042******7016 LGD_FINANCEAUTHNUM = 30097771 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fbc6fcafaa97b4ba91005ac029f91d76 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210201104945 LGD_PCANCELSTR = 0 LGD_BUYER = 황교석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020110494514064 LGD_BUYERID = LGD_OID = Direct-servomecha-1612144112 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 10:49:43======================== insert into mBoard_order set rOrdNo = 'Direct-servomecha-1612144112', AuthTy = 'card', memberId = 'servomecha', OrdNm ='황교석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한일상공사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 557042******7016', rApprNo = 'mjsof2021020110494514064', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 10:49:43', InvoiceNum = '결제성공:Direct-servomecha-1612144112/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 10:49:43' ========================2021-02-01 10:49:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020110494514064' 0 = 1 cnt = 1 ========================2021-02-01 10:49:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'servomecha' 0 = servomecha Mid = servomecha 1 = 한일상공사 Mcompany = 한일상공사 2 = 131-01-61268 companyNum = 131-01-61268 3 = 032-883-2533 Mtel1 = 032-883-2533 4 = 010-6346-2533 Mhp = 010-6346-2533 ========================2021-02-01 10:49:43======================== select * from customers where id = 'servomecha' ========================2021-02-01 10:49:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('servomecha','2021-02-01 10:49:43','108000','110000','온라인','0') ========================2021-02-01 11:52:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ujd4026-1612147823 LGD_BUYER = 우종대 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201115023 LGD_HASHDATA = efc8e98a0d0f876effbc0b29b3f3f13f 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 = 20210201115301DAE53AC8865C5333BBA8352FB6696185977A5B32 Mname = 우종대 Mcompany = 신성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ujd4026 LGD_ESCROW_USEYN = N ========================2021-02-01 11:52:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201115301 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = DAAAPS LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553152******3344 LGD_FINANCEAUTHNUM = 11414091 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8c32fc8ef41405b8c57474a333f6b18c LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210201115302 LGD_PCANCELSTR = 0 LGD_BUYER = 우종대 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020111530114194 LGD_BUYERID = LGD_OID = Direct-ujd4026-1612147823 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 11:52:59======================== insert into mBoard_order set rOrdNo = 'Direct-ujd4026-1612147823', AuthTy = 'card', memberId = 'ujd4026', OrdNm ='우종대', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신성상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한MASTER 553152******3344', rApprNo = 'mjsof2021020111530114194', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 11:52:59', InvoiceNum = '결제성공:Direct-ujd4026-1612147823/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 11:52:59' ========================2021-02-01 11:52:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020111530114194' 0 = 1 cnt = 1 ========================2021-02-01 11:52:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ujd4026' 0 = ujd4026 Mid = ujd4026 1 = 신성상사 Mcompany = 신성상사 2 = 304-81-27536 companyNum = 304-81-27536 3 = 043-648-4026 Mtel1 = 043-648-4026 4 = 010-5486-5566 Mhp = 010-5486-5566 ========================2021-02-01 11:52:59======================== select * from customers where id = 'ujd4026' ========================2021-02-01 11:52:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ujd4026','2021-02-01 11:52:59','220000','220000','온라인','0') ========================2021-02-01 12:41:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dus365-1612150745 LGD_BUYER = 연운모 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201123905 LGD_HASHDATA = 8d81bd6256f43f234cedccb737c3a049 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 = 20210201124105EA85B64E2173500EBC3290A05431703E72C35AF8 Mname = 연운모 Mcompany = 주식회사 디케이인베스트 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = dus365 LGD_ESCROW_USEYN = N ========================2021-02-01 12:41:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201124106 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 = 528664******4996 LGD_FINANCEAUTHNUM = 61998906 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = c8542206538d7378b1a4f53b095d07e6 LGD_BUYERADDRESS = LGD_FINANCENAME = NH MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210201124106 LGD_PCANCELSTR = 0 LGD_BUYER = 연운모 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020112410661217 LGD_BUYERID = LGD_OID = Direct-dus365-1612150745 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 12:41:04======================== insert into mBoard_order set rOrdNo = 'Direct-dus365-1612150745', AuthTy = 'card', memberId = 'dus365', OrdNm ='연운모', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 디케이인베스트', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH MASTER 528664******4996', rApprNo = 'mjsof2021020112410661217', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 12:41:04', InvoiceNum = '결제성공:Direct-dus365-1612150745/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 12:41:04' ========================2021-02-01 12:41:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020112410661217' 0 = 1 cnt = 1 ========================2021-02-01 12:41:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dus365' 0 = dus365 Mid = dus365 1 = 주식회사 디케이인베스트 Mcompany = 주식회사 디케이인베스트 2 = 6618600736 companyNum = 6618600736 3 = 032-813-3467 Mtel1 = 032-813-3467 4 = 010-2001-0983 Mhp = 010-2001-0983 ========================2021-02-01 12:41:04======================== select * from customers where id = 'dus365' ========================2021-02-01 12:41:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dus365','2021-02-01 12:41:04','108000','110000','온라인','0') ========================2021-02-01 13:13:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-suby77-1612152761 LGD_BUYER = 박양섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201131241 LGD_HASHDATA = 59d0709c8a70cab0cd1f4f067a18ee1e 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 = 20210201131328C97D6C0A778CF392DCA858CA929025591CE4AB7E Mname = 박양섭 Mcompany = (주)창조식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = suby77 LGD_ESCROW_USEYN = N ========================2021-02-01 13:13:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201131329 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = DAA9SR LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 377985******946 LGD_FINANCEAUTHNUM = 12468410 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4165e793a516074d692bc27e167faca9 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210201131329 LGD_PCANCELSTR = 0 LGD_BUYER = 박양섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020113132961137 LGD_BUYERID = LGD_OID = Direct-suby77-1612152761 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 13:13:26======================== insert into mBoard_order set rOrdNo = 'Direct-suby77-1612152761', AuthTy = 'card', memberId = 'suby77', OrdNm ='박양섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)창조식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한AMEX 377985******946', rApprNo = 'mjsof2021020113132961137', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 13:13:26', InvoiceNum = '결제성공:Direct-suby77-1612152761/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 13:13:26' ========================2021-02-01 13:13:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020113132961137' 0 = 1 cnt = 1 ========================2021-02-01 13:13:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'suby77' 0 = suby77 Mid = suby77 1 = (주)창조식품 Mcompany = (주)창조식품 2 = 1498801001 companyNum = 1498801001 3 = 031-868-5423 Mtel1 = 031-868-5423 4 = 010-3470-9613 Mhp = 010-3470-9613 ========================2021-02-01 13:13:26======================== select * from customers where id = 'suby77' ========================2021-02-01 13:13:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('suby77','2021-02-01 13:13:26','220000','220000','온라인','0') ========================2021-02-01 13:51:23======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang3446-1612154875 LGD_BUYER = 김명순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201134755 LGD_HASHDATA = 0598834af738ee031e7671afa5fb9131 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 = 20210201135126A481C4A84E39066C5E9D062355D3D28B0AF4263D Mname = 김명순 Mcompany = 삼양상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = samyang3446 LGD_ESCROW_USEYN = N ========================2021-02-01 13:51:24======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201135126 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 = 943016******8343 LGD_FINANCEAUTHNUM = 62667297 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 59c513a372279391e670d78cfab26bdd LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210201135127 LGD_PCANCELSTR = 0 LGD_BUYER = 김명순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020113512661164 LGD_BUYERID = LGD_OID = Direct-samyang3446-1612154875 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 13:51:24======================== insert into mBoard_order set rOrdNo = 'Direct-samyang3446-1612154875', AuthTy = 'card', memberId = 'samyang3446', OrdNm ='김명순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼양상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 943016******8343', rApprNo = 'mjsof2021020113512661164', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 13:51:24', InvoiceNum = '결제성공:Direct-samyang3446-1612154875/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 13:51:24' ========================2021-02-01 13:51:24======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020113512661164' 0 = 1 cnt = 1 ========================2021-02-01 13:51:24======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyang3446' 0 = samyang3446 Mid = samyang3446 1 = 삼양상사 Mcompany = 삼양상사 2 = 3647300174 companyNum = 3647300174 3 = 064-722-3446 Mtel1 = 064-722-3446 4 = 010-7178-5735 Mhp = 010-7178-5735 ========================2021-02-01 13:51:24======================== select * from customers where id = 'samyang3446' ========================2021-02-01 13:51:24======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang3446','2021-02-01 13:51:24','108000','110000','온라인','0') ========================2021-02-01 17:11:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-tkddn9-1612167012 LGD_BUYER = 이의호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201171012 LGD_HASHDATA = 9284376f649c0cfd5bf507f36a546ada 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 = 202102011711353E856297249571747DEB8D37C8C6B2402D41B7ED Mname = 이의호 Mcompany = (주) 엠알에스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = tkddn9 LGD_ESCROW_USEYN = N ========================2021-02-01 17:11:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201171135 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 = 402857******3112 LGD_FINANCEAUTHNUM = 00656376 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3532708b4a7c1d56210b1f44b79608c1 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210201171135 LGD_PCANCELSTR = 0 LGD_BUYER = 이의호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020117113560047 LGD_BUYERID = LGD_OID = Direct-tkddn9-1612167012 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 17:11:32======================== insert into mBoard_order set rOrdNo = 'Direct-tkddn9-1612167012', AuthTy = 'card', memberId = 'tkddn9', OrdNm ='이의호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주) 엠알에스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 402857******3112', rApprNo = 'mjsof2021020117113560047', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 17:11:32', InvoiceNum = '결제성공:Direct-tkddn9-1612167012/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 17:11:32' ========================2021-02-01 17:11:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020117113560047' 0 = 1 cnt = 1 ========================2021-02-01 17:11:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'tkddn9' 0 = tkddn9 Mid = tkddn9 1 = (주) 엠알에스 Mcompany = (주) 엠알에스 2 = 1378623158 companyNum = 1378623158 3 = 031-981-2306 Mtel1 = 031-981-2306 4 = 010-2363-9107 Mhp = 010-2363-9107 ========================2021-02-01 17:11:32======================== select * from customers where id = 'tkddn9' ========================2021-02-01 17:11:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('tkddn9','2021-02-01 17:11:32','10000','11000','온라인','0') ========================2021-02-01 17:28:00======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yuillss-1612168017 LGD_BUYER = 김번영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201172657 LGD_HASHDATA = b95bb4d1a41de772bd0e3cc02e8e731c 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 = 20210201172803128EFB38B763A63ABFFEC6EECD65C175967EB0E2 Mname = 김번영 Mcompany = 유일공구철물 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = yuillss LGD_ESCROW_USEYN = N ========================2021-02-01 17:28:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201172804 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 303C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 417233******9706 LGD_FINANCEAUTHNUM = 00849587 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 39ced4ff4dda122d6be5e59c93781c00 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210201172804 LGD_PCANCELSTR = 0 LGD_BUYER = 김번영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020117280414252 LGD_BUYERID = LGD_OID = Direct-yuillss-1612168017 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 17:28:01======================== insert into mBoard_order set rOrdNo = 'Direct-yuillss-1612168017', AuthTy = 'card', memberId = 'yuillss', OrdNm ='김번영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '유일공구철물', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '현대VISA 417233******9706', rApprNo = 'mjsof2021020117280414252', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 17:28:01', InvoiceNum = '결제성공:Direct-yuillss-1612168017/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 17:28:01' ========================2021-02-01 17:28:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020117280414252' 0 = 1 cnt = 1 ========================2021-02-01 17:28:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yuillss' 0 = yuillss Mid = yuillss 1 = 유일공구철물 Mcompany = 유일공구철물 2 = 1273147570 companyNum = 1273147570 3 = 031-861-7337 Mtel1 = 031-861-7337 4 = 010-3693-7517 Mhp = 010-3693-7517 ========================2021-02-01 17:28:01======================== select * from customers where id = 'yuillss' ========================2021-02-01 17:28:01======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('yuillss','유일공구철물','1273147570','031-861-7337','010-3693-7517','2021-02-01 17:28:01','온라인') ========================2021-02-01 17:28:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yuillss','2021-02-01 17:28:01','10000','11000','온라인','0') ========================2021-02-01 18:58:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-taehwa-1612173463 LGD_BUYER = 이도원 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210201185743 LGD_HASHDATA = aab5e43bd14cecec0bbf126bde7929ea 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 = 202102011858505B436CE2AD88C32408AE6AC4B97C41B14450EC7F Mname = 이도원 Mcompany = 디자인태화 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = taehwa LGD_ESCROW_USEYN = N ========================2021-02-01 18:58:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210201185850 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 009271 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 523612******0098 LGD_FINANCEAUTHNUM = 30051074 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7ea40699c8959af5d6d7535d69824de7 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210201185850 LGD_PCANCELSTR = 0 LGD_BUYER = 이도원 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021020118585061097 LGD_BUYERID = LGD_OID = Direct-taehwa-1612173463 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-02-01 18:58:47======================== insert into mBoard_order set rOrdNo = 'Direct-taehwa-1612173463', AuthTy = 'card', memberId = 'taehwa', OrdNm ='이도원', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '디자인태화', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 523612******0098', rApprNo = 'mjsof2021020118585061097', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-02-01 18:58:47', InvoiceNum = '결제성공:Direct-taehwa-1612173463/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-02-01 18:58:47' ========================2021-02-01 18:58:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021020118585061097' 0 = 1 cnt = 1 ========================2021-02-01 18:58:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'taehwa' 0 = taehwa Mid = taehwa 1 = 디자인태화 Mcompany = 디자인태화 2 = 1220964836 companyNum = 1220964836 3 = 02-2272-9222 Mtel1 = 02-2272-9222 4 = 010-7567-6727 Mhp = 010-7567-6727 ========================2021-02-01 18:58:47======================== select * from customers where id = 'taehwa' ========================2021-02-01 18:58:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('taehwa','2021-02-01 18:58:47','10000','11000','온라인','0')