========================2023-12-04 07:48:26======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dicst6199-1701643626 LGD_BUYER = 송택환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204074706 LGD_HASHDATA = 62f386e18ca2313a666845b567046554 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 = 2023120407515281BED0AB5A06C93724914F8D6D77DCECDEE55A7D Mname = 송택환 Mcompany = 대일cst post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = dicst6199 LGD_ESCROW_USEYN = N ========================2023-12-04 07:48:27======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204075154 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 009305 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 53632600****708* LGD_FINANCEAUTHNUM = 30020805 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 56659bc128832ed8f34cc1a0eed044a7 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231204075154 LGD_PCANCELSTR = 0 LGD_BUYER = 송택환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204075153Rw6E0 LGD_BUYERID = LGD_OID = Direct-dicst6199-1701643626 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4075153RQtL3 ========================2023-12-04 07:48:27======================== insert into mBoard_order set rOrdNo = 'Direct-dicst6199-1701643626', AuthTy = 'card', memberId = 'dicst6199', OrdNm ='송택환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '대일cst', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 53632600****708*', rApprNo = 'mjsof20231204075153Rw6E0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 07:48:27', InvoiceNum = '결제성공:Direct-dicst6199-1701643626/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 07:48:27' ========================2023-12-04 07:48:27======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204075153Rw6E0' 0 = 1 cnt = 1 ========================2023-12-04 07:48:27======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dicst6199' 0 = dicst6199 Mid = dicst6199 1 = 대일cst Mcompany = 대일cst 2 = 1300170105 companyNum = 1300170105 3 = 032-684-6199 Mtel1 = 032-684-6199 4 = 010-2789-8444 Mhp = 010-2789-8444 ========================2023-12-04 07:48:27======================== select * from customers where id = 'dicst6199' ========================2023-12-04 07:48:27======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dicst6199','2023-12-04 07:48:27','220000','220000','온라인','0') ========================2023-12-04 08:47:02======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rhgid2016-1701647112 LGD_BUYER = (유)고향식품 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204084512 LGD_HASHDATA = 5f6cf455ed22922db28dc8e27044762e 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 = 20231204085029CF3581E758F60A76B1B21132A1A5444ACBC82E9C Mname = (유)고향식품 Mcompany = (유)고향식품 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = rhgid2016 LGD_ESCROW_USEYN = N ========================2023-12-04 08:47:03======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204085030 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 005770 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 51107005****105* LGD_FINANCEAUTHNUM = 28265011 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 35200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ec7ba90531ec6a1cadbe73ead65d4f02 LGD_BUYERADDRESS = LGD_FINANCENAME = 전북MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231204085030 LGD_PCANCELSTR = 0 LGD_BUYER = (유)고향식품 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof20231204085030SonG4 LGD_BUYERID = LGD_OID = Direct-rhgid2016-1701647112 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 040850298463 ========================2023-12-04 08:47:03======================== insert into mBoard_order set rOrdNo = 'Direct-rhgid2016-1701647112', AuthTy = 'card', memberId = 'rhgid2016', OrdNm ='(유)고향식품', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(유)고향식품', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '전북MASTER 51107005****105*', rApprNo = 'mjsof20231204085030SonG4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 08:47:03', InvoiceNum = '결제성공:Direct-rhgid2016-1701647112/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 08:47:03' ========================2023-12-04 08:47:03======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204085030SonG4' 0 = 1 cnt = 1 ========================2023-12-04 08:47:03======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rhgid2016' 0 = rhgid2016 Mid = rhgid2016 1 = (유)고향식품 Mcompany = (유)고향식품 2 = 4188150923 companyNum = 4188150923 3 = 010-4002-4567 Mtel1 = 010-4002-4567 4 = 010-4002-4567 Mhp = 010-4002-4567 ========================2023-12-04 08:47:03======================== select * from customers where id = 'rhgid2016' ========================2023-12-04 08:47:03======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rhgid2016','2023-12-04 08:47:03','220000','220000','온라인','0') ========================2023-12-04 10:53:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jjholdings-1701654554 LGD_BUYER = 김진영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204104914 LGD_HASHDATA = 32457c3c5ed58a14c78bc1167561619c 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 = 202312041056599A7CF3A00E2C37EDD2E919FE188DD11E97FAE2AB Mname = 김진영 Mcompany = JJ홀딩스 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = jjholdings LGD_ESCROW_USEYN = N ========================2023-12-04 10:53:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204105659 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 54287966****913* LGD_FINANCEAUTHNUM = 01897263 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f4238a4a72a8079c71e34f4da01f87f4 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231204105659 LGD_PCANCELSTR = 0 LGD_BUYER = 김진영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204105659MqWS4 LGD_BUYERID = LGD_OID = Direct-jjholdings-1701654554 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-04 10:53:32======================== insert into mBoard_order set rOrdNo = 'Direct-jjholdings-1701654554', AuthTy = 'card', memberId = 'jjholdings', OrdNm ='김진영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = 'JJ홀딩스', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한MASTER 54287966****913*', rApprNo = 'mjsof20231204105659MqWS4', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 10:53:32', InvoiceNum = '결제성공:Direct-jjholdings-1701654554/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 10:53:32' ========================2023-12-04 10:53:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204105659MqWS4' 0 = 1 cnt = 1 ========================2023-12-04 10:53:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jjholdings' 0 = jjholdings Mid = jjholdings 1 = JJ홀딩스 Mcompany = JJ홀딩스 2 = 2091547120 companyNum = 2091547120 3 = 010-9059-3310 Mtel1 = 010-9059-3310 4 = 010-9059-3310 Mhp = 010-9059-3310 ========================2023-12-04 10:53:32======================== select * from customers where id = 'jjholdings' ========================2023-12-04 10:53:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jjholdings','2023-12-04 10:53:32','220000','220000','온라인','0') ========================2023-12-04 13:55:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1701665698 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204135458 LGD_HASHDATA = 29a7b7f21b2331be8e1a237409bea36b 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 = 2023120413591144BCAEC52BC8B75C497BD4293888E91C96CE642A Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2023-12-04 13:55:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204135912 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 = 94301703****448* LGD_FINANCEAUTHNUM = 48178567 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 255262e6ee820010cb567f1c7f39d27c LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231204135912 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204135912y8rr3 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1701665698 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-04 13:55:45======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1701665698', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20231204135912y8rr3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 13:55:45', InvoiceNum = '결제성공:Direct-goodssal5707-1701665698/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 13:55:45' ========================2023-12-04 13:55:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204135912y8rr3' 0 = 1 cnt = 1 ========================2023-12-04 13:55:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2023-12-04 13:55:45======================== select * from customers where id = 'goodssal5707' ========================2023-12-04 13:55:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2023-12-04 13:55:45','220000','220000','온라인','0') ========================2023-12-04 13:56:58======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1701665786 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204135626 LGD_HASHDATA = 6349b679971e6be48304c41976c965ce 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 = 20231204140025735965262C8C8950E79BF8A17AA87C4F107BCFD7 Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2023-12-04 13:56:59======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204140025 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 = 94301703****448* LGD_FINANCEAUTHNUM = 48191936 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a1e95c27f0b556e3a1ac5e9324a794e1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20231204140026 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204140025plfB1 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1701665786 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-04 13:56:59======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1701665786', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94301703****448*', rApprNo = 'mjsof20231204140025plfB1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 13:56:59', InvoiceNum = '결제성공:Direct-goodssal5707-1701665786/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 13:56:59' ========================2023-12-04 13:56:59======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204140025plfB1' 0 = 1 cnt = 1 ========================2023-12-04 13:56:59======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'goodssal5707' 0 = goodssal5707 Mid = goodssal5707 1 = (주)좋은이웃FS Mcompany = (주)좋은이웃FS 2 = 129-86-41214 companyNum = 129-86-41214 3 = 031-705-5707 Mtel1 = 031-705-5707 4 = 010-8880-9146 Mhp = 010-8880-9146 ========================2023-12-04 13:56:59======================== select * from customers where id = 'goodssal5707' ========================2023-12-04 13:56:59======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2023-12-04 13:56:59','108000','110000','온라인','0') ========================2023-12-04 14:50:25======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joygarden2-1701668986 LGD_BUYER = 백성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204144946 LGD_HASHDATA = 301a9249cd338a2b3b1ff5d5090f24fa 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 = 20231204145352E30B06B50852F7D660C8DF425A3AE70CB87B0960 Mname = 백성희 Mcompany = 가든자재한샘 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joygarden2 LGD_ESCROW_USEYN = N ========================2023-12-04 14:50:26======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204145353 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 62641511****295* LGD_FINANCEAUTHNUM = 55432483 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31800 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3a1332da6ddc2bf0dfa56b48864ce4ee LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨CUP LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231204145353 LGD_PCANCELSTR = 0 LGD_BUYER = 백성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204145352ye4T9 LGD_BUYERID = LGD_OID = Direct-joygarden2-1701668986 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4145352yUG64 ========================2023-12-04 14:50:26======================== insert into mBoard_order set rOrdNo = 'Direct-joygarden2-1701668986', AuthTy = 'card', memberId = 'joygarden2', OrdNm =' 백성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '가든자재한샘', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨CUP 62641511****295*', rApprNo = 'mjsof20231204145352ye4T9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 14:50:26', InvoiceNum = '결제성공:Direct-joygarden2-1701668986/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 14:50:26' ========================2023-12-04 14:50:26======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204145352ye4T9' 0 = 1 cnt = 1 ========================2023-12-04 14:50:26======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joygarden2' 0 = joygarden2 Mid = joygarden2 1 = 가든자재한샘 Mcompany = 가든자재한샘 2 = 707-20-01603 companyNum = 707-20-01603 3 = 010-8299-5335 Mtel1 = 010-8299-5335 4 = 010-8299-5335 Mhp = 010-8299-5335 ========================2023-12-04 14:50:26======================== select * from customers where id = 'joygarden2' ========================2023-12-04 14:50:26======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joygarden2','2023-12-04 14:50:26','108000','110000','온라인','0') ========================2023-12-04 15:14:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-joygarden2-1701670286 LGD_BUYER = 백성희 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204151126 LGD_HASHDATA = 2dc6214d94dff019673b5c98e9a8193e 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 = 2023120415181101BDD807EC292852721C6454D88675E18DA5A1DA Mname = 백성희 Mcompany = 가든자재한샘 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = joygarden2 LGD_ESCROW_USEYN = N ========================2023-12-04 15:14:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204151812 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003289 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852697****585* LGD_FINANCEAUTHNUM = 30000120 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1b878e4ddf72c2fe1aeecf87d0edf37e LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231204151812 LGD_PCANCELSTR = 0 LGD_BUYER = 백성희 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204151812jYyb9 LGD_BUYERID = LGD_OID = Direct-joygarden2-1701670286 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4151812j0OC8 ========================2023-12-04 15:14:45======================== insert into mBoard_order set rOrdNo = 'Direct-joygarden2-1701670286', AuthTy = 'card', memberId = 'joygarden2', OrdNm =' 백성희', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '가든자재한샘', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 55852697****585*', rApprNo = 'mjsof20231204151812jYyb9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 15:14:45', InvoiceNum = '결제성공:Direct-joygarden2-1701670286/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 15:14:45' ========================2023-12-04 15:14:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204151812jYyb9' 0 = 1 cnt = 1 ========================2023-12-04 15:14:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'joygarden2' 0 = joygarden2 Mid = joygarden2 1 = 가든자재한샘 Mcompany = 가든자재한샘 2 = 707-20-01603 companyNum = 707-20-01603 3 = 010-8299-5335 Mtel1 = 010-8299-5335 4 = 010-8299-5335 Mhp = 010-8299-5335 ========================2023-12-04 15:14:45======================== select * from customers where id = 'joygarden2' ========================2023-12-04 15:14:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('joygarden2','2023-12-04 15:14:45','108000','110000','온라인','0') ========================2023-12-04 15:19:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pao7894-1701670692 LGD_BUYER = 심재후 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204151812 LGD_HASHDATA = cdceab5c8bc801f706d05030a2ca6cb7 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 = 202312041522285AFF4D306BEF9F8C7FB9BBECDE651546829289C0 Mname = 심재후 Mcompany = (주)토탈엘앤씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = pao7894 LGD_ESCROW_USEYN = N ========================2023-12-04 15:19:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204152228 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400306****197* LGD_FINANCEAUTHNUM = 55606721 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 297aad3b0ba9e988c1bac36e422350b1 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231204152229 LGD_PCANCELSTR = 0 LGD_BUYER = 심재후 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204152228od9k0 LGD_BUYERID = LGD_OID = Direct-pao7894-1701670692 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4152228op8A2 ========================2023-12-04 15:19:02======================== insert into mBoard_order set rOrdNo = 'Direct-pao7894-1701670692', AuthTy = 'card', memberId = 'pao7894', OrdNm =' 심재후', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)토탈엘앤씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41400306****197*', rApprNo = 'mjsof20231204152228od9k0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 15:19:02', InvoiceNum = '결제성공:Direct-pao7894-1701670692/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 15:19:02' ========================2023-12-04 15:19:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204152228od9k0' 0 = 1 cnt = 1 ========================2023-12-04 15:19:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pao7894' 0 = pao7894 Mid = pao7894 1 = (주)토탈엘앤씨 Mcompany = (주)토탈엘앤씨 2 = 134-86-34108 companyNum = 134-86-34108 3 = 031-366-9051 Mtel1 = 031-366-9051 4 = 010-3022-2227 Mhp = 010-3022-2227 ========================2023-12-04 15:19:02======================== select * from customers where id = 'pao7894' ========================2023-12-04 15:19:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pao7894','2023-12-04 15:19:02','108000','110000','온라인','0') ========================2023-12-04 15:42:44======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gumjin2-1701672121 LGD_BUYER = 김다영 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231204154201 LGD_HASHDATA = 018ebdaaeded60fed32f1bfaceac3a76 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 = 2023120415461163EB3209C7C45882678549AB2EE1BA8818C560C6 Mname = 김다영 Mcompany = 금진윤활유 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gumjin2 LGD_ESCROW_USEYN = N ========================2023-12-04 15:42:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231204154611 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALZCCX LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 43123600****604* LGD_FINANCEAUTHNUM = 06034234 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e0bfc5b112a3b404a2d4519894fd08a0 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231204154612 LGD_PCANCELSTR = 0 LGD_BUYER = 김다영 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231204154611ofxw8 LGD_BUYERID = LGD_OID = Direct-gumjin2-1701672121 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-04 15:42:44======================== insert into mBoard_order set rOrdNo = 'Direct-gumjin2-1701672121', AuthTy = 'card', memberId = 'gumjin2', OrdNm ='김다영', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금진윤활유', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 43123600****604*', rApprNo = 'mjsof20231204154611ofxw8', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-04 15:42:44', InvoiceNum = '결제성공:Direct-gumjin2-1701672121/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-04 15:42:44' ========================2023-12-04 15:42:45======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231204154611ofxw8' 0 = 1 cnt = 1 ========================2023-12-04 15:42:45======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gumjin2' 0 = gumjin2 Mid = gumjin2 1 = 금진윤활유 Mcompany = 금진윤활유 2 = 1261880316 companyNum = 1261880316 3 = 010-9292-5964 Mtel1 = 010-9292-5964 4 = 010-9292-5964 Mhp = 010-9292-5964 ========================2023-12-04 15:42:45======================== select * from customers where id = 'gumjin2' ========================2023-12-04 15:42:45======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gumjin2','2023-12-04 15:42:44','108000','110000','온라인','0')