========================2024-12-04 11:38:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mail2020-1733279825 LGD_BUYER = 임요한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204113705 LGD_HASHDATA = a05b35113b1516c5c180e534d5eb5350 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20241204113904C4A673D42DD9FAD4748269C70F1C71F171AE02D0 Mname = 임요한 Mcompany = 매일우유천전점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = mail2020 LGD_ESCROW_USEYN = N ========================2024-12-04 11:38:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204113905 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51818500****839* LGD_FINANCEAUTHNUM = 17109901 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8118127043839261152ce4287eb74fd3 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20241204113905 LGD_PCANCELSTR = 0 LGD_BUYER = 임요한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204113905udum4 LGD_BUYERID = LGD_OID = Direct-mail2020-1733279825 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 11:38:44======================== insert into mBoard_order set rOrdNo = 'Direct-mail2020-1733279825', AuthTy = 'card', memberId = 'mail2020', OrdNm ='임요한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '매일우유천전점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 51818500****839*', rApprNo = 'mjsof20241204113905udum4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 11:38:44', InvoiceNum = '결제성공:Direct-mail2020-1733279825/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 11:38:44' ========================2024-12-04 11:38:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204113905udum4' 0 = 1 cnt = 1 ========================2024-12-04 11:38:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mail2020' 0 = mail2020 Mid = mail2020 1 = 매일우유천전점 Mcompany = 매일우유천전점 2 = 2174400621 companyNum = 2174400621 3 = 010-9198-1005 Mtel1 = 010-9198-1005 4 = 010-5330-1535 Mhp = 010-5330-1535 ========================2024-12-04 11:38:44======================== select * from customers where id = 'mail2020' ========================2024-12-04 11:38:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mail2020','2024-12-04 11:38:44','10000','11000','온라인','0') ========================2024-12-04 12:47:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kfnc2-1733283949 LGD_BUYER = 김군호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204124549 LGD_HASHDATA = 270ae5f083ff6c4fd8d5d1ead08aa545 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20241204124746589A912E3C38D2D92D26F4EDC4BBE876370F3ACA Mname = 김군호 Mcompany = (주)한국푸앤코 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = kfnc2 LGD_ESCROW_USEYN = N ========================2024-12-04 12:47:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204124746 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51055400****962* LGD_FINANCEAUTHNUM = 29406064 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 71200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6dfada55a1c66843b035c876aa039173 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20241204124747 LGD_PCANCELSTR = 0 LGD_BUYER = 김군호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204124746otZL5 LGD_BUYERID = LGD_OID = Direct-kfnc2-1733283949 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 12:47:25======================== insert into mBoard_order set rOrdNo = 'Direct-kfnc2-1733283949', AuthTy = 'card', memberId = 'kfnc2', OrdNm ='김군호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)한국푸앤코', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '롯데MASTER 51055400****962*', rApprNo = 'mjsof20241204124746otZL5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 12:47:25', InvoiceNum = '결제성공:Direct-kfnc2-1733283949/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 12:47:25' ========================2024-12-04 12:47:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204124746otZL5' 0 = 1 cnt = 1 ========================2024-12-04 12:47:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'kfnc2' 0 = kfnc2 Mid = kfnc2 1 = (주)한국푸앤코 Mcompany = (주)한국푸앤코 2 = 1248622100 companyNum = 1248622100 3 = 031-254-4013 Mtel1 = 031-254-4013 4 = 010-8338-6424 Mhp = 010-8338-6424 ========================2024-12-04 12:47:25======================== select * from customers where id = 'kfnc2' ========================2024-12-04 12:47:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kfnc2','2024-12-04 12:47:25','52500','55000','온라인','0') ========================2024-12-04 13:35:54======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-antwin77-1733286827 LGD_BUYER = 김태우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204133347 LGD_HASHDATA = 7be7b61f1c3ffd0d85a8320ace197da7 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2024120413361577E48301174A0388EDC82D6A4BEDA272EBBD75DB Mname = 김태우 Mcompany = 태산식자재유통센터 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = antwin77 LGD_ESCROW_USEYN = N ========================2024-12-04 13:35:54======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204133616 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 40330201****042* LGD_FINANCEAUTHNUM = 00914141 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fc7dfe080b717dc7694d3e6584e82bc5 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20241204133616 LGD_PCANCELSTR = 0 LGD_BUYER = 김태우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204133616tPml9 LGD_BUYERID = LGD_OID = Direct-antwin77-1733286827 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 13:35:54======================== insert into mBoard_order set rOrdNo = 'Direct-antwin77-1733286827', AuthTy = 'card', memberId = 'antwin77', OrdNm ='김태우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '태산식자재유통센터', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대VISA 40330201****042*', rApprNo = 'mjsof20241204133616tPml9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 13:35:54', InvoiceNum = '결제성공:Direct-antwin77-1733286827/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 13:35:54' ========================2024-12-04 13:35:54======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204133616tPml9' 0 = 1 cnt = 1 ========================2024-12-04 13:35:54======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'antwin77' 0 = antwin77 Mid = antwin77 1 = 새미래식품 Mcompany = 새미래식품 2 = 6212013066 companyNum = 6212013066 3 = 051-515-6374 Mtel1 = 051-515-6374 4 = 010-2823-6378 Mhp = 010-2823-6378 ========================2024-12-04 13:35:54======================== select * from customers where id = 'antwin77' ========================2024-12-04 13:35:54======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('antwin77','2024-12-04 13:35:54','52500','55000','온라인','0') ========================2024-12-04 13:53:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-suby77-1733287914 LGD_BUYER = 박양섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204135154 LGD_HASHDATA = ea7d1476c7b8921ed8b32447d480da4a LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20241204135349DD159ACCED9F1D8E371AE782A8EB333C572C39CA 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 ========================2024-12-04 13:53:28======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20241204135349 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37922030****82* LGD_FINANCEAUTHNUM = 50131872 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 71400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 51906e810c9f18d9ba92b7526d6b59f2 LGD_BUYERADDRESS = LGD_FINANCENAME = 롯데AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 71 LGD_DEVICE = LGD_TIMESTAMP = 20241204135350 LGD_PCANCELSTR = 0 LGD_BUYER = 박양섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204135339mns86 LGD_BUYERID = LGD_OID = Direct-suby77-1733287914 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 13:53:28======================== insert into mBoard_order set rOrdNo = 'Direct-suby77-1733287914', AuthTy = 'card', memberId = 'suby77', OrdNm ='박양섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)창조식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '롯데AMEX 37922030****82*', rApprNo = 'mjsof20241204135339mns86', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 13:53:28', InvoiceNum = '결제성공:Direct-suby77-1733287914/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 13:53:28' ========================2024-12-04 13:53:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204135339mns86' 0 = 1 cnt = 1 ========================2024-12-04 13:53:28======================== 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 ========================2024-12-04 13:53:28======================== select * from customers where id = 'suby77' ========================2024-12-04 13:53:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('suby77','2024-12-04 13:53:28','220000','220000','온라인','0') ========================2024-12-04 14:36:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-todamls-1733290542 LGD_BUYER = 유대웅 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204143542 LGD_HASHDATA = 1af9fdb5c5b77691dcbb32291451f495 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202412041436455E70465F6FA98D5015C3192B32B9E9336DB5BAC8 Mname = 유대웅 Mcompany = (주)토담유통상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = todamls LGD_ESCROW_USEYN = N ========================2024-12-04 14:36:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204143646 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005772 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51107002****015* LGD_FINANCEAUTHNUM = 22267690 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = aab129170c6416f0e19724af5e182c9b LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241204143647 LGD_PCANCELSTR = 0 LGD_BUYER = 유대웅 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20241204143646s96H1 LGD_BUYERID = LGD_OID = Direct-todamls-1733290542 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 041436688091 ========================2024-12-04 14:36:25======================== insert into mBoard_order set rOrdNo = 'Direct-todamls-1733290542', AuthTy = 'card', memberId = 'todamls', OrdNm ='유대웅', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토담유통상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '전북MASTER 51107002****015*', rApprNo = 'mjsof20241204143646s96H1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 14:36:25', InvoiceNum = '결제성공:Direct-todamls-1733290542/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 14:36:25' ========================2024-12-04 14:36:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204143646s96H1' 0 = 1 cnt = 1 ========================2024-12-04 14:36:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'todamls' 0 = todamls Mid = todamls 1 = (주)토담유통상사 Mcompany = (주)토담유통상사 2 = 403-81-36254 companyNum = 403-81-36254 3 = 063-837-7799 Mtel1 = 063-837-7799 4 = 010-9626-7293 Mhp = 010-9626-7293 ========================2024-12-04 14:36:25======================== select * from customers where id = 'todamls' ========================2024-12-04 14:36:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('todamls','2024-12-04 14:36:25','52500','55000','온라인','0') ========================2024-12-04 14:38:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-kds1-1733290671 LGD_BUYER = 오정호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204143751 LGD_HASHDATA = b99d892489131b662c56c3db437f9da5 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20241204143912DE0A5A7E8F486097A22AAEC6C691BC3EEF21D6D9 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 ========================2024-12-04 14:38:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204143913 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003300 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852694****589* LGD_FINANCEAUTHNUM = 30194991 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1fbaf0ae8025385f7554be55c720a79f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20241204143913 LGD_PCANCELSTR = 0 LGD_BUYER = 오정호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204143913yHZL1 LGD_BUYERID = LGD_OID = Direct-kds1-1733290671 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4143913ypeQ0 ========================2024-12-04 14:38:51======================== insert into mBoard_order set rOrdNo = 'Direct-kds1-1733290671', 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 = 'mjsof20241204143913yHZL1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 14:38:51', InvoiceNum = '결제성공:Direct-kds1-1733290671/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 14:38:51' ========================2024-12-04 14:38:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204143913yHZL1' 0 = 1 cnt = 1 ========================2024-12-04 14:38:51======================== 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 ========================2024-12-04 14:38:51======================== select * from customers where id = 'kds1' ========================2024-12-04 14:38:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('kds1','2024-12-04 14:38:51','52500','55000','온라인','0') ========================2024-12-04 16:54:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-potatogom-1733298775 LGD_BUYER = 권준형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204165255 LGD_HASHDATA = 978fe02c00f65fc87114dd60fc9c048d LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202412041654488FE9F3202AB804535E8EB148E718BDCEE689609F Mname = 권준형 Mcompany = 로스팅 포테이토 컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = potatogom LGD_ESCROW_USEYN = N ========================2024-12-04 16:54:27======================== xpay_res LGD_EASYPAY_TRANTYPE = NAVERPAY_CARD LGD_BUYERPHONE = LGD_PAYDATE = 20241204165449 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_UPAYFLG = U LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 91002003****366* LGD_FINANCEAUTHNUM = 37136955 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 33000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c8ef0e614d18434e89c920959f4c3181 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241204165449 LGD_PCANCELSTR = 0 LGD_BUYER = 권준형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_EASYPAY_DISCOUNT = 0 LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204165432tsvS4 LGD_BUYERID = LGD_OID = Direct-potatogom-1733298775 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 16:54:27======================== insert into mBoard_order set rOrdNo = 'Direct-potatogom-1733298775', AuthTy = 'card', memberId = 'potatogom', OrdNm ='권준형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '로스팅 포테이토 컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '우리비씨 91002003****366*', rApprNo = 'mjsof20241204165432tsvS4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 16:54:27', InvoiceNum = '결제성공:Direct-potatogom-1733298775/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 16:54:27' ========================2024-12-04 16:54:28======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204165432tsvS4' 0 = 1 cnt = 1 ========================2024-12-04 16:54:28======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'potatogom' 0 = potatogom Mid = potatogom 1 = 로스팅 포테이토 컴퍼니 Mcompany = 로스팅 포테이토 컴퍼니 2 = 1943700558 companyNum = 1943700558 3 = 010-2225-2252 Mtel1 = 010-2225-2252 4 = 010-2225-2252 Mhp = 010-2225-2252 ========================2024-12-04 16:54:28======================== select * from customers where id = 'potatogom' ========================2024-12-04 16:54:28======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('potatogom','2024-12-04 16:54:27','30900','33000','온라인','0') ========================2024-12-04 18:55:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-fancimilli-1733305975 LGD_BUYER = 김형석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241204185255 LGD_HASHDATA = 70e0c553c8d5c398c2875611387039a5 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20241204185550B485A88F120A03656AB5FF396D467943C1A42689 Mname = 김형석 Mcompany = (주)팬시밀리 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = fancimilli LGD_ESCROW_USEYN = N ========================2024-12-04 18:55:29======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241204185551 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55320800****859* LGD_FINANCEAUTHNUM = 38025645 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 62bf27eb858f33a3a36f013a2ae8454b LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241204185551 LGD_PCANCELSTR = 0 LGD_BUYER = 김형석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241204185551o1I57 LGD_BUYERID = LGD_OID = Direct-fancimilli-1733305975 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-12-04 18:55:29======================== insert into mBoard_order set rOrdNo = 'Direct-fancimilli-1733305975', AuthTy = 'card', memberId = 'fancimilli', OrdNm ='김형석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)팬시밀리', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55320800****859*', rApprNo = 'mjsof20241204185551o1I57', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-12-04 18:55:29', InvoiceNum = '결제성공:Direct-fancimilli-1733305975/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-12-04 18:55:29' ========================2024-12-04 18:55:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241204185551o1I57' 0 = 1 cnt = 1 ========================2024-12-04 18:55:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'fancimilli' 0 = fancimilli Mid = fancimilli 1 = (주)팬시밀리 Mcompany = (주)팬시밀리 2 = 349-86-03319 companyNum = 349-86-03319 3 = 031-487-1830 Mtel1 = 031-487-1830 4 = 010-6361-4527 Mhp = 010-6361-4527 ========================2024-12-04 18:55:29======================== select * from customers where id = 'fancimilli' ========================2024-12-04 18:55:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('fancimilli','2024-12-04 18:55:29','10000','11000','온라인','0')