========================2022-10-07 10:12:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1665105127 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007101207 LGD_HASHDATA = 59ade5b22e4eb941b22cadc0c2af7452 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 = 202210071015544F7416B363DE67B1D26781E4CCBD9D948E46EA7F Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2022-10-07 10:12:53======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007101555 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = azfoods@chol.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852637****282* LGD_FINANCEAUTHNUM = 30015640 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = d7916f7d220129b8d55b83ee690044fa LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221007101555 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007101554VJEf5 LGD_BUYERID = LGD_OID = Direct-azfoods01-1665105127 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7101554VmIR9 ========================2022-10-07 10:12:53======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1665105127', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852637****282*', rApprNo = 'mjsof20221007101554VJEf5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 10:12:53', InvoiceNum = '결제성공:Direct-azfoods01-1665105127/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 10:12:53' ========================2022-10-07 10:12:53======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007101554VJEf5' 0 = 1 cnt = 1 ========================2022-10-07 10:12:53======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2022-10-07 10:12:53======================== select * from customers where id = 'azfoods01' ========================2022-10-07 10:12:53======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2022-10-07 10:12:53','108000','110000','온라인','0') ========================2022-10-07 10:52:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yedangfood2-1665107491 LGD_BUYER = 강성기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007105131 LGD_HASHDATA = a7a07761a75e474747a844e892b5cf21 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 = 202210071055496FA7863B5D18C0430DBC1EF59C58F5F0A467ABEC Mname = 강성기 Mcompany = (주)예당식품(지점) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = yedangfood2 LGD_ESCROW_USEYN = N ========================2022-10-07 10:52:48======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007105549 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = yedangfood03@nate.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55314600****487* LGD_FINANCEAUTHNUM = 05121216 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f01add895bf63bbf5c3f4900d38c0c8e LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20221007105550 LGD_PCANCELSTR = 0 LGD_BUYER = 강성기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221007105549SYnv7 LGD_BUYERID = LGD_OID = Direct-yedangfood2-1665107491 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-07 10:52:48======================== insert into mBoard_order set rOrdNo = 'Direct-yedangfood2-1665107491', AuthTy = 'card', memberId = 'yedangfood2', OrdNm ='강성기', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)예당식품(지점)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한MASTER 55314600****487*', rApprNo = 'mjsof20221007105549SYnv7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 10:52:48', InvoiceNum = '결제성공:Direct-yedangfood2-1665107491/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 10:52:48' ========================2022-10-07 10:52:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007105549SYnv7' 0 = 1 cnt = 1 ========================2022-10-07 10:52:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'yedangfood2' 0 = yedangfood2 Mid = yedangfood2 1 = (주)예당식품(지점) Mcompany = (주)예당식품(지점) 2 = 1318555107 companyNum = 1318555107 3 = 032-465-2174 Mtel1 = 032-465-2174 4 = 010-4806-0245 Mhp = 010-4806-0245 ========================2022-10-07 10:52:49======================== select * from customers where id = 'yedangfood2' ========================2022-10-07 10:52:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('yedangfood2','2022-10-07 10:52:48','220000','220000','온라인','0') ========================2022-10-07 11:19:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kdscms7124-1665108987 LGD_BUYER = 김대수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007111627 LGD_HASHDATA = 4fbddad68619c5678c6665d09b85e3ce 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 = 20221007112257F98DA6069E4EC8BA5210FBE2F895F0AFC272DC6B Mname = 김대수 Mcompany = (주)꼬끼아리 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = kdscms7124 LGD_ESCROW_USEYN = N ========================2022-10-07 11:19:56======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007112257 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413211****497* LGD_FINANCEAUTHNUM = 58741977 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = aa97d94eaa94460e54db1826d251bf71 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007112257 LGD_PCANCELSTR = 0 LGD_BUYER = 김대수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007112257VQ7M0 LGD_BUYERID = LGD_OID = Direct-kdscms7124-1665108987 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7112257Vp7k4 ========================2022-10-07 11:19:56======================== insert into mBoard_order set rOrdNo = 'Direct-kdscms7124-1665108987', AuthTy = 'card', memberId = 'kdscms7124', OrdNm ='김대수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)꼬끼아리', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413211****497*', rApprNo = 'mjsof20221007112257VQ7M0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 11:19:56', InvoiceNum = '결제성공:Direct-kdscms7124-1665108987/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 11:19:56' ========================2022-10-07 11:19:56======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007112257VQ7M0' 0 = 1 cnt = 1 ========================2022-10-07 11:19:56======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kdscms7124' 0 = kdscms7124 Mid = kdscms7124 1 = (주)꼬끼아리 Mcompany = (주)꼬끼아리 2 = 750-81-00216 companyNum = 750-81-00216 3 = 031-943-1992 Mtel1 = 031-943-1992 4 = 010-3890-3428 Mhp = 010-3890-3428 ========================2022-10-07 11:19:56======================== select * from customers where id = 'kdscms7124' ========================2022-10-07 11:19:56======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kdscms7124','2022-10-07 11:19:56','220000','220000','온라인','0') ========================2022-10-07 13:44:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-paintds-1665117667 LGD_BUYER = 성규호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007134107 LGD_HASHDATA = 602df0138d7d8c6942604ebd985c2aba 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 = 202210071347076F047F597C77CF6D2644375C2B7C4AC98820CE55 Mname = 성규호 Mcompany = 대성상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = paintds LGD_ESCROW_USEYN = N ========================2022-10-07 13:44:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007134708 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = paintdesung@hanmail.net LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400308****391* LGD_FINANCEAUTHNUM = 59706330 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 87bd08d8e6ed97bd312a69dbd835ae2a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007134708 LGD_PCANCELSTR = 0 LGD_BUYER = 성규호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007134707Xgby0 LGD_BUYERID = LGD_OID = Direct-paintds-1665117667 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7134707XAux7 ========================2022-10-07 13:44:07======================== insert into mBoard_order set rOrdNo = 'Direct-paintds-1665117667', AuthTy = 'card', memberId = 'paintds', OrdNm ='성규호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대성상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 41400308****391*', rApprNo = 'mjsof20221007134707Xgby0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 13:44:07', InvoiceNum = '결제성공:Direct-paintds-1665117667/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 13:44:07' ========================2022-10-07 13:44:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007134707Xgby0' 0 = 1 cnt = 1 ========================2022-10-07 13:44:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'paintds' 0 = paintds Mid = paintds 1 = 대성상사 Mcompany = 대성상사 2 = 126-86-04132 companyNum = 126-86-04132 3 = 031-767-9248 Mtel1 = 031-767-9248 4 = 010-2699-2835 Mhp = 010-2699-2835 ========================2022-10-07 13:44:07======================== select * from customers where id = 'paintds' ========================2022-10-07 13:44:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('paintds','2022-10-07 13:44:07','30900','33000','온라인','0') ========================2022-10-07 14:11:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-cp2201-1665119416 LGD_BUYER = 주훈석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007141016 LGD_HASHDATA = e147dc09f9fdeb5d581119a11a13cb5d 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 = 20221007141423D2A6B286F8E71ACCB6FACD725BB26991726E1546 Mname = 주훈석 Mcompany = 주식회사 지얼 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = cp2201 LGD_ESCROW_USEYN = N ========================2022-10-07 14:11:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007141424 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 = 42890993****834* LGD_FINANCEAUTHNUM = 44754560 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cccff4c82605d26de0e8cb821449b4d6 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20221007141424 LGD_PCANCELSTR = 0 LGD_BUYER = 주훈석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221007141424SfEF1 LGD_BUYERID = LGD_OID = Direct-cp2201-1665119416 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-07 14:11:23======================== insert into mBoard_order set rOrdNo = 'Direct-cp2201-1665119416', AuthTy = 'card', memberId = 'cp2201', OrdNm ='주훈석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 지얼', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '하나VISA 42890993****834*', rApprNo = 'mjsof20221007141424SfEF1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 14:11:23', InvoiceNum = '결제성공:Direct-cp2201-1665119416/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 14:11:23' ========================2022-10-07 14:11:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007141424SfEF1' 0 = 1 cnt = 1 ========================2022-10-07 14:11:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'cp2201' 0 = cp2201 Mid = cp2201 1 = 주식회사 지얼 Mcompany = 주식회사 지얼 2 = 583-86-00135 companyNum = 583-86-00135 3 = 051-503-3010 Mtel1 = 051-503-3010 4 = 010-6482-3010 Mhp = 010-6482-3010 ========================2022-10-07 14:11:23======================== select * from customers where id = 'cp2201' ========================2022-10-07 14:11:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('cp2201','2022-10-07 14:11:23','220000','220000','온라인','0') ========================2022-10-07 15:41:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kukje9156-1665124873 LGD_BUYER = 조윤영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007154113 LGD_HASHDATA = 440b10b110451d14768fab2c20af8a6f 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 = 2022100715450059258E197029F162A648B5F0E77D68BA2ACD686A Mname = 조윤영 Mcompany = 주식회사 국제안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = kukje9156 LGD_ESCROW_USEYN = N ========================2022-10-07 15:41:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007154501 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****081* LGD_FINANCEAUTHNUM = 30019656 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a38f72c947e5c3bff4911d21b59dca4f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221007154501 LGD_PCANCELSTR = 0 LGD_BUYER = 조윤영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007154501RDPl9 LGD_BUYERID = LGD_OID = Direct-kukje9156-1665124873 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7154501RxRT3 ========================2022-10-07 15:41:59======================== insert into mBoard_order set rOrdNo = 'Direct-kukje9156-1665124873', AuthTy = 'card', memberId = 'kukje9156', OrdNm ='조윤영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 국제안전', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****081*', rApprNo = 'mjsof20221007154501RDPl9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 15:41:59', InvoiceNum = '결제성공:Direct-kukje9156-1665124873/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 15:41:59' ========================2022-10-07 15:42:00======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007154501RDPl9' 0 = 1 cnt = 1 ========================2022-10-07 15:42:00======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kukje9156' 0 = kukje9156 Mid = kukje9156 1 = 주식회사 국제안전 Mcompany = 주식회사 국제안전 2 = 2068666910 companyNum = 2068666910 3 = 02-469-9156 Mtel1 = 02-469-9156 4 = 010-2013-7302 Mhp = 010-2013-7302 ========================2022-10-07 15:42:00======================== select * from customers where id = 'kukje9156' ========================2022-10-07 15:42:00======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kukje9156','2022-10-07 15:41:59','108000','110000','온라인','0') ========================2022-10-07 16:16:56======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1665126966 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007161606 LGD_HASHDATA = 56694c984a90fe4f33635cc071adf428 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 = 20221007161958539980C8A6E74E9BE84AD7AB7ABA61CE8E730D4E 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-10-07 16:16:57======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007161959 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 = 55852694****589* LGD_FINANCEAUTHNUM = 30145144 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6302613d77a569605008d5d1d573bbd2 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20221007161959 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007161958TCLx9 LGD_BUYERID = LGD_OID = Direct-kds1-1665126966 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7161958T03W4 ========================2022-10-07 16:16:57======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1665126966', AuthTy = 'card', memberId = 'kds1', OrdNm ='오정호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '메인로드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민MASTER 55852694****589*', rApprNo = 'mjsof20221007161958TCLx9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 16:16:57', InvoiceNum = '결제성공:Direct-kds1-1665126966/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 16:16:57' ========================2022-10-07 16:16:57======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007161958TCLx9' 0 = 1 cnt = 1 ========================2022-10-07 16:16:57======================== 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-10-07 16:16:57======================== select * from customers where id = 'kds1' ========================2022-10-07 16:16:57======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2022-10-07 16:16:57','52500','55000','온라인','0') ========================2022-10-07 17:02:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape2-1665129672 LGD_BUYER = 함명수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007170112 LGD_HASHDATA = 26567d050e8628d1512e6b112deab614 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 = 202210071706007658C19C08670F4748D34B2D80F68FB733A709FB Mname = 함명수 Mcompany = 대운산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape2 LGD_ESCROW_USEYN = N ========================2022-10-07 17:02:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007170600 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850307****996* LGD_FINANCEAUTHNUM = 62402039 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3a5b89a126e71a71be343a56fcd983d3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007170601 LGD_PCANCELSTR = 0 LGD_BUYER = 함명수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007170600SvpM2 LGD_BUYERID = LGD_OID = Direct-unicomtape2-1665129672 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7170600SE9E8 ========================2022-10-07 17:03:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape2-1665129783 LGD_BUYER = 함명수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007170303 LGD_HASHDATA = 8fa0d07149774dfca5d1f62b53718916 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 = 20221007170646266202692B23F41D20DE19AE560FD445307B9C2E Mname = 함명수 Mcompany = 대운산업 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape2 LGD_ESCROW_USEYN = N ========================2022-10-07 17:03:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007170646 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850307****996* LGD_FINANCEAUTHNUM = 62397878 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 26681c24bf5ee1420388213d39206564 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007170647 LGD_PCANCELSTR = 0 LGD_BUYER = 함명수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007170646Q4Le4 LGD_BUYERID = LGD_OID = Direct-unicomtape2-1665129783 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7170646QquI8 ========================2022-10-07 17:05:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-unicomtape2-1665129920 LGD_BUYER = 함명수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007170520 LGD_HASHDATA = d609d685e5a52dca177117b09871d182 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 = 20221007170855C5443C39432242EABEDAAB6A93EEADE26038BCFC Mname = 함명수 Mcompany = 대운메디션 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = unicomtape2 LGD_ESCROW_USEYN = N ========================2022-10-07 17:05:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007170856 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 038535 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55850307****996* LGD_FINANCEAUTHNUM = 62422438 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 60afeb123cabda295af05e6cc72c6f34 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007170856 LGD_PCANCELSTR = 0 LGD_BUYER = 함명수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007170855SvHR3 LGD_BUYERID = LGD_OID = Direct-unicomtape2-1665129920 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7170855SEfV7 ========================2022-10-07 17:05:54======================== insert into mBoard_order set rOrdNo = 'Direct-unicomtape2-1665129920', AuthTy = 'card', memberId = 'unicomtape2', OrdNm ='함명수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대운메디션', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨MASTER 55850307****996*', rApprNo = 'mjsof20221007170855SvHR3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 17:05:54', InvoiceNum = '결제성공:Direct-unicomtape2-1665129920/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 17:05:54' ========================2022-10-07 17:05:55======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007170855SvHR3' 0 = 1 cnt = 1 ========================2022-10-07 17:05:55======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'unicomtape2' 0 = unicomtape2 Mid = unicomtape2 1 = 대운메디션 Mcompany = 대운메디션 2 = 8762500190 companyNum = 8762500190 3 = 054-744-0811 Mtel1 = 054-744-0811 4 = -- Mhp = -- ========================2022-10-07 17:05:55======================== select * from customers where id = 'unicomtape2' ========================2022-10-07 17:05:55======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('unicomtape2','2022-10-07 17:05:54','10000','11000','온라인','0') ========================2022-10-07 17:09:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dhhousing1-1665130124 LGD_BUYER = 서태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007170844 LGD_HASHDATA = 92cc15a92c73d88a27d1373cf190fd2a 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 = 202210071712351C82E285221FE75DF2ADE8A7143B0E6D45DBAA0F Mname = 서태화 Mcompany = (주)디에이치하우징 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dhhousing1 LGD_ESCROW_USEYN = N ========================2022-10-07 17:09:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007171237 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****698* LGD_FINANCEAUTHNUM = 62445612 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7472f8f8e5d1f7a9036a3714d238c2ed LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20221007171237 LGD_PCANCELSTR = 0 LGD_BUYER = 서태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20221007171236Vl5s2 LGD_BUYERID = LGD_OID = Direct-dhhousing1-1665130124 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 7171236VA1U2 ========================2022-10-07 17:09:35======================== insert into mBoard_order set rOrdNo = 'Direct-dhhousing1-1665130124', AuthTy = 'card', memberId = 'dhhousing1', OrdNm ='서태화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에이치하우징', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****698*', rApprNo = 'mjsof20221007171236Vl5s2', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 17:09:35', InvoiceNum = '결제성공:Direct-dhhousing1-1665130124/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 17:09:35' ========================2022-10-07 17:09:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007171236Vl5s2' 0 = 1 cnt = 1 ========================2022-10-07 17:09:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dhhousing1' 0 = dhhousing1 Mid = dhhousing1 1 = (주)디에이치하우징 Mcompany = (주)디에이치하우징 2 = 1358186545 companyNum = 1358186545 3 = 031-695-5977 Mtel1 = 031-695-5977 4 = 010-5115-1221 Mhp = 010-5115-1221 ========================2022-10-07 17:09:35======================== select * from customers where id = 'dhhousing1' ========================2022-10-07 17:09:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dhhousing1','2022-10-07 17:09:35','52500','55000','온라인','0') ========================2022-10-07 23:49:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-nosqr9583-1665154121 LGD_BUYER = 이희순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20221007234841 LGD_HASHDATA = b6f83fa855442d60ff8886825175935a 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 = 202210072352468084D67F70E61FEED616E4869B5C912C22F8FB8C Mname = 이희순 Mcompany = 앤오스퀘어(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = nosqr9583 LGD_ESCROW_USEYN = N ========================2022-10-07 23:49:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20221007235246 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 = 46700850****602* LGD_FINANCEAUTHNUM = 39400187 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 74c0ad5117c60128e56743a7731d5aab LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20221007235247 LGD_PCANCELSTR = 0 LGD_BUYER = 이희순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof20221007235246Yv3W8 LGD_BUYERID = LGD_OID = Direct-nosqr9583-1665154121 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-10-07 23:49:45======================== insert into mBoard_order set rOrdNo = 'Direct-nosqr9583-1665154121', AuthTy = 'card', memberId = 'nosqr9583', OrdNm ='이희순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '앤오스퀘어(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데VISA 46700850****602*', rApprNo = 'mjsof20221007235246Yv3W8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-10-07 23:49:45', InvoiceNum = '결제성공:Direct-nosqr9583-1665154121/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-10-07 23:49:45' ========================2022-10-07 23:49:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20221007235246Yv3W8' 0 = 1 cnt = 1 ========================2022-10-07 23:49:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'nosqr9583' 0 = nosqr9583 Mid = nosqr9583 1 = 앤오스퀘어(주) Mcompany = 앤오스퀘어(주) 2 = 7258800733 companyNum = 7258800733 3 = 010-3199-5304 Mtel1 = 010-3199-5304 4 = 010-3199-5304 Mhp = 010-3199-5304 ========================2022-10-07 23:49:45======================== select * from customers where id = 'nosqr9583' ========================2022-10-07 23:49:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('nosqr9583','2022-10-07 23:49:45','52500','55000','온라인','0')