========================2023-03-02 08:04:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang2446-1677711755 LGD_BUYER = 박병배 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302080235 LGD_HASHDATA = d35da6cf949cf68f9ef1fda3eeddabd5 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 = 2023030208094422019AD8E760C7EAAD8A9EC3B4A4C948FD724CBF Mname = 박병배 Mcompany = (주)베이커리의 모든 것 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = samyang2446 LGD_ESCROW_USEYN = N ========================2023-03-02 08:04:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302080945 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 49029841****938* LGD_FINANCEAUTHNUM = 29351143 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 331854cc05f4561f5bf25e0676c67cbd LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20230302080945 LGD_PCANCELSTR = 0 LGD_BUYER = 박병배 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302080945jcN95 LGD_BUYERID = LGD_OID = Direct-samyang2446-1677711755 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 08:04:03======================== insert into mBoard_order set rOrdNo = 'Direct-samyang2446-1677711755', AuthTy = 'card', memberId = 'samyang2446', OrdNm ='박병배', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)베이커리의 모든 것', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 49029841****938*', rApprNo = 'mjsof20230302080945jcN95', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 08:04:03', InvoiceNum = '결제성공:Direct-samyang2446-1677711755/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 08:04:03' ========================2023-03-02 08:04:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302080945jcN95' 0 = 1 cnt = 1 ========================2023-03-02 08:04:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'samyang2446' 0 = samyang2446 Mid = samyang2446 1 = (주)베이커리의 모든 것 Mcompany = (주)베이커리의 모든 것 2 = 5768800922 companyNum = 5768800922 3 = 064-722-2446 Mtel1 = 064-722-2446 4 = 010-9257-0407 Mhp = 010-9257-0407 ========================2023-03-02 08:04:03======================== select * from customers where id = 'samyang2446' ========================2023-03-02 08:04:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang2446','2023-03-02 08:04:03','220000','220000','온라인','0') ========================2023-03-02 08:07:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-samyang3446-1677712008 LGD_BUYER = 김명순 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302080648 LGD_HASHDATA = c399e7c51714df09797c178328269433 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 = 20230302081331FFF72609A432C1C5A530472CB6516335295D9734 Mname = 김명순 Mcompany = 삼양상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = samyang3446 LGD_ESCROW_USEYN = N ========================2023-03-02 08:07:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302081331 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 = 94301602****834* LGD_FINANCEAUTHNUM = 65093648 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2d85ab1a1703e40ac602581d6c8f9083 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230302081331 LGD_PCANCELSTR = 0 LGD_BUYER = 김명순 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302081331aAJ48 LGD_BUYERID = LGD_OID = Direct-samyang3446-1677712008 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 08:07:49======================== insert into mBoard_order set rOrdNo = 'Direct-samyang3446-1677712008', AuthTy = 'card', memberId = 'samyang3446', OrdNm ='김명순', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '삼양상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301602****834*', rApprNo = 'mjsof20230302081331aAJ48', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 08:07:49', InvoiceNum = '결제성공:Direct-samyang3446-1677712008/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 08:07:49' ========================2023-03-02 08:07:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302081331aAJ48' 0 = 1 cnt = 1 ========================2023-03-02 08:07:49======================== 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-9257-0407 Mhp = 010-9257-0407 ========================2023-03-02 08:07:49======================== select * from customers where id = 'samyang3446' ========================2023-03-02 08:07:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('samyang3446','2023-03-02 08:07:49','220000','220000','온라인','0') ========================2023-03-02 08:43:39======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sinjejuutong-1677713962 LGD_BUYER = 한승호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302083922 LGD_HASHDATA = b2c4adda61559f7635178d1a612bf0bf 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 = 20230302084921088D6B7376E501EB341F50963C91F9D4F72A2FE4 Mname = 한승호 Mcompany = 신제주유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sinjejuutong LGD_ESCROW_USEYN = N ========================2023-03-02 08:43:40======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302084922 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 = 370300******908 LGD_FINANCEAUTHNUM = 00137768 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b3002199a1840ba0c50314bda52081cb LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230302084922 LGD_PCANCELSTR = 0 LGD_BUYER = 한승호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302084922b3IJ5 LGD_BUYERID = LGD_OID = Direct-sinjejuutong-1677713962 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 08:45:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sun1002-1677714263 LGD_BUYER = 권미향 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302084423 LGD_HASHDATA = af10abe66787a2613486e6dcb73d7d53 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 = 20230302085055D09043849DE6AC4E448AF0F3362F1FD33399A107 Mname = 권미향 Mcompany = 락앤락총판 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sun1002 LGD_ESCROW_USEYN = N ========================2023-03-02 08:45:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302085056 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****829* LGD_FINANCEAUTHNUM = 58629065 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9e253e271c65f4782f1b172e461201a8 LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230302085056 LGD_PCANCELSTR = 0 LGD_BUYER = 권미향 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302085055cB1U6 LGD_BUYERID = LGD_OID = Direct-sun1002-1677714263 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2085055chOv9 ========================2023-03-02 08:45:14======================== insert into mBoard_order set rOrdNo = 'Direct-sun1002-1677714263', AuthTy = 'card', memberId = 'sun1002', OrdNm ='권미향', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '락앤락총판', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****829*', rApprNo = 'mjsof20230302085055cB1U6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 08:45:14', InvoiceNum = '결제성공:Direct-sun1002-1677714263/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 08:45:14' ========================2023-03-02 08:45:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302085055cB1U6' 0 = 1 cnt = 1 ========================2023-03-02 08:45:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sun1002' 0 = sun1002 Mid = sun1002 1 = 락앤락총판 Mcompany = 락앤락총판 2 = 6228507362 companyNum = 6228507362 3 = 031-564-5266 Mtel1 = 031-564-5266 4 = 010-3914-9308 Mhp = 010-3914-9308 ========================2023-03-02 08:45:14======================== select * from customers where id = 'sun1002' ========================2023-03-02 08:45:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sun1002','2023-03-02 08:45:14','10000','11000','온라인','0') ========================2023-03-02 08:45:27======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sinjejuutong-1677714275 LGD_BUYER = 한승호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302084435 LGD_HASHDATA = 7f5da76f3437af104d77b036b6379f44 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 = 202303020851093DE2A65E24CE84D4BCF1EA46911659EBBAC9B76B Mname = 한승호 Mcompany = 신제주유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sinjejuutong LGD_ESCROW_USEYN = N ========================2023-03-02 08:45:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302085110 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 = 370300******908 LGD_FINANCEAUTHNUM = 00877724 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 61400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5dda52d3694ba10b5077e7f50fafb7d7 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230302085110 LGD_PCANCELSTR = 0 LGD_BUYER = 한승호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2023030208510997Ao4 LGD_BUYERID = LGD_OID = Direct-sinjejuutong-1677714275 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 10:23:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pan2018-1677720110 LGD_BUYER = 박승찬 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302102150 LGD_HASHDATA = 9e68ea7f7daad08dc444ef6820f4639c 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 = 202303021028575FC37718346B4973CBD1871CAFF45102B334CA05 Mname = 박승찬 Mcompany = . post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = pan2018 LGD_ESCROW_USEYN = N ========================2023-03-02 10:23:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302102858 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 = 55318440****752* LGD_FINANCEAUTHNUM = 38724806 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9644a05145c73e6e30869a1d070ed9a9 LGD_BUYERADDRESS = LGD_FINANCENAME = 하나MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20230302102858 LGD_PCANCELSTR = 0 LGD_BUYER = 박승찬 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302102858jpJn3 LGD_BUYERID = LGD_OID = Direct-pan2018-1677720110 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 10:23:15======================== insert into mBoard_order set rOrdNo = 'Direct-pan2018-1677720110', AuthTy = 'card', memberId = 'pan2018', OrdNm ='박승찬', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '.', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '하나MASTER 55318440****752*', rApprNo = 'mjsof20230302102858jpJn3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 10:23:15', InvoiceNum = '결제성공:Direct-pan2018-1677720110/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 10:23:15' ========================2023-03-02 10:23:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302102858jpJn3' 0 = 1 cnt = 1 ========================2023-03-02 10:23:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pan2018' 0 = pan2018 Mid = pan2018 1 = . Mcompany = . 2 = 5435800323 companyNum = 5435800323 3 = 010-5423-0269 Mtel1 = 010-5423-0269 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2023-03-02 10:23:15======================== select * from customers where id = 'pan2018' ========================2023-03-02 10:23:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pan2018','2023-03-02 10:23:15','10000','11000','온라인','0') ========================2023-03-02 13:56:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-babobong76-1677732893 LGD_BUYER = 신광섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302135453 LGD_HASHDATA = b77d2e4120cb89c6593de72ad7aa8188 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 = 20230302140234DB2E06559D19FA6042C65AB3D9E599CDCE1233A6 Mname = 신광섭 Mcompany = 풍성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = babobong76 LGD_ESCROW_USEYN = N ========================2023-03-02 13:56:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302140234 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 = 94901924****952* LGD_FINANCEAUTHNUM = 00953857 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 69b3bcf4136ad72c668b0d7eeda96f63 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230302140235 LGD_PCANCELSTR = 0 LGD_BUYER = 신광섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302140234yL633 LGD_BUYERID = LGD_OID = Direct-babobong76-1677732893 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 14:03:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-babobong76-1677733328 LGD_BUYER = 신광섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302140208 LGD_HASHDATA = 62bf01ee9266d73ecd35f19f34255f38 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 = 202303021408469E26A3A088B7C85D99C2E460342286D7989B0D21 Mname = 신광섭 Mcompany = 풍성유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = babobong76 LGD_ESCROW_USEYN = N ========================2023-03-02 14:03:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302140847 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 = 94901924****952* LGD_FINANCEAUTHNUM = 00122110 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 352dd87095094e31aa43ff8b1a58b17c LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230302140847 LGD_PCANCELSTR = 0 LGD_BUYER = 신광섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302140847zySI8 LGD_BUYERID = LGD_OID = Direct-babobong76-1677733328 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 14:03:04======================== insert into mBoard_order set rOrdNo = 'Direct-babobong76-1677733328', AuthTy = 'card', memberId = 'babobong76', OrdNm ='신광섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '풍성유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '현대 94901924****952*', rApprNo = 'mjsof20230302140847zySI8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 14:03:04', InvoiceNum = '결제성공:Direct-babobong76-1677733328/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 14:03:04' ========================2023-03-02 14:03:05======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302140847zySI8' 0 = 1 cnt = 1 ========================2023-03-02 14:03:05======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'babobong76' 0 = babobong76 Mid = babobong76 1 = 풍성유통 Mcompany = 풍성유통 2 = 1283414317 companyNum = 1283414317 3 = 070-5017-5882 Mtel1 = 070-5017-5882 4 = 010-4798-0526 Mhp = 010-4798-0526 ========================2023-03-02 14:03:05======================== select * from customers where id = 'babobong76' ========================2023-03-02 14:03:05======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('babobong76','2023-03-02 14:03:04','52500','55000','온라인','0') ========================2023-03-02 14:13:51======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-shindaesung-1677733841 LGD_BUYER = 최지석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302141041 LGD_HASHDATA = b7eb23cedbd21b3ac5239c98e90a1d79 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 = 20230302141933AC1F5B43031ACC50EEB705D7C741045B90BDA09B Mname = 최지석 Mcompany = 신대성테크 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = shindaesung LGD_ESCROW_USEYN = N ========================2023-03-02 14:13:51======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302141934 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 = 377989******182 LGD_FINANCEAUTHNUM = 56697723 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 42e9d5889ecde34bbf6005a16b6bd452 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230302141934 LGD_PCANCELSTR = 0 LGD_BUYER = 최지석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302141934AmLz7 LGD_BUYERID = LGD_OID = Direct-shindaesung-1677733841 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-03-02 14:13:51======================== insert into mBoard_order set rOrdNo = 'Direct-shindaesung-1677733841', AuthTy = 'card', memberId = 'shindaesung', OrdNm ='최지석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '신대성테크', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '삼성AMEX 377989******182', rApprNo = 'mjsof20230302141934AmLz7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 14:13:51', InvoiceNum = '결제성공:Direct-shindaesung-1677733841/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 14:13:51' ========================2023-03-02 14:13:51======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302141934AmLz7' 0 = 1 cnt = 1 ========================2023-03-02 14:13:51======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'shindaesung' 0 = shindaesung Mid = shindaesung 1 = 신대성테크 Mcompany = 신대성테크 2 = 394-10-00578 companyNum = 394-10-00578 3 = 010-4653-4391 Mtel1 = 010-4653-4391 4 = 010-4653-4391 Mhp = 010-4653-4391 ========================2023-03-02 14:13:51======================== select * from customers where id = 'shindaesung' ========================2023-03-02 14:13:51======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('shindaesung','2023-03-02 14:13:51','220000','220000','온라인','0') ========================2023-03-02 16:01:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-seorinsangsa-1677740400 LGD_BUYER = 정인숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230302160000 LGD_HASHDATA = 114fe645a9e245de3d9c2026550b9026 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 = 20230302160728E89FF06AC9D6C546FD96B927F4EB63911035274F Mname = 정인숙 Mcompany = 서린상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = seorinsangsa LGD_ESCROW_USEYN = N ========================2023-03-02 16:01:46======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230302160728 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41710305****090* LGD_FINANCEAUTHNUM = 62216950 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 6f62b2159690c3a3c798a70001db2bba LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230302160729 LGD_PCANCELSTR = 0 LGD_BUYER = 정인숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230302160728hyr44 LGD_BUYERID = LGD_OID = Direct-seorinsangsa-1677740400 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 2160728hgcZ9 ========================2023-03-02 16:01:46======================== insert into mBoard_order set rOrdNo = 'Direct-seorinsangsa-1677740400', AuthTy = 'card', memberId = 'seorinsangsa', OrdNm ='정인숙', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '서린상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 41710305****090*', rApprNo = 'mjsof20230302160728hyr44', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-03-02 16:01:46', InvoiceNum = '결제성공:Direct-seorinsangsa-1677740400/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-03-02 16:01:46' ========================2023-03-02 16:01:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230302160728hyr44' 0 = 1 cnt = 1 ========================2023-03-02 16:01:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'seorinsangsa' 0 = seorinsangsa Mid = seorinsangsa 1 = 서린상사 Mcompany = 서린상사 2 = 1378623385 companyNum = 1378623385 3 = 032-562-2057 Mtel1 = 032-562-2057 4 = 010-5423-2057 Mhp = 010-5423-2057 ========================2023-03-02 16:01:46======================== select * from customers where id = 'seorinsangsa' ========================2023-03-02 16:01:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('seorinsangsa','2023-03-02 16:01:46','220000','220000','온라인','0')