========================2023-06-30 08:42:47======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ongdalsem-1688082094 LGD_BUYER = 이석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630084134 LGD_HASHDATA = 5e7e25c96ce19c36b66a2644fec10f6d 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 = 20230630084317551D7494D49F2E951C1A2034CD015F6C54449A6C Mname = 이석 Mcompany = 주식회사 오씨코퍼레이션 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ongdalsem LGD_ESCROW_USEYN = N ========================2023-06-30 08:42:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630084317 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852612****802* LGD_FINANCEAUTHNUM = 30031062 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 741b090b5ddadbd72f16cebf5a4c205f LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230630084317 LGD_PCANCELSTR = 0 LGD_BUYER = 이석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202306300843171wwJ7 LGD_BUYERID = LGD_OID = Direct-ongdalsem-1688082094 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 08:42:47======================== insert into mBoard_order set rOrdNo = 'Direct-ongdalsem-1688082094', AuthTy = 'card', memberId = 'ongdalsem', OrdNm ='이석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 오씨코퍼레이션', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민MASTER 55852612****802*', rApprNo = 'mjsof202306300843171wwJ7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 08:42:47', InvoiceNum = '결제성공:Direct-ongdalsem-1688082094/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 08:42:47' ========================2023-06-30 08:42:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202306300843171wwJ7' 0 = 1 cnt = 1 ========================2023-06-30 08:42:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ongdalsem' 0 = ongdalsem Mid = ongdalsem 1 = 주식회사 오씨코퍼레이션 Mcompany = 주식회사 오씨코퍼레이션 2 = 4828602107 companyNum = 4828602107 3 = 02-322-1861 Mtel1 = 02-322-1861 4 = 010-9484-1861 Mhp = 010-9484-1861 ========================2023-06-30 08:42:47======================== select * from customers where id = 'ongdalsem' ========================2023-06-30 08:42:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ongdalsem','2023-06-30 08:42:47','220000','220000','온라인','0') ========================2023-06-30 09:58:24======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rpc0501-1688086494 LGD_BUYER = 장영미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630095454 LGD_HASHDATA = 95417981a0c2261ca623dacdcfe6b0cf 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 = 20230630095854245384F006374D76961AA7E7AE6CF57FE83E45AC Mname = 장영미 Mcompany = 충주시농협쌀조합공동사업법인 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = rpc0501 LGD_ESCROW_USEYN = N ========================2023-06-30 09:58:25======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630095854 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 000000 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41401245****196* LGD_FINANCEAUTHNUM = 55636234 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 662f43b4a58066dcff7c6873ef595141 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230630095855 LGD_PCANCELSTR = 0 LGD_BUYER = 장영미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230630095854czdv7 LGD_BUYERID = LGD_OID = Direct-rpc0501-1688086494 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 0095854cYiI0 ========================2023-06-30 09:58:25======================== insert into mBoard_order set rOrdNo = 'Direct-rpc0501-1688086494', AuthTy = 'card', memberId = 'rpc0501', OrdNm ='장영미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '충주시농협쌀조합공동사업법인', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨VISA 41401245****196*', rApprNo = 'mjsof20230630095854czdv7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 09:58:25', InvoiceNum = '결제성공:Direct-rpc0501-1688086494/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 09:58:25' ========================2023-06-30 09:58:25======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230630095854czdv7' 0 = 1 cnt = 1 ========================2023-06-30 09:58:25======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rpc0501' 0 = rpc0501 Mid = rpc0501 1 = 충주시농협쌀조합공동사업법인 Mcompany = 충주시농협쌀조합공동사업법인 2 = 303-82-08926 companyNum = 303-82-08926 3 = 010-6620-3917 Mtel1 = 010-6620-3917 4 = 010-6620-3917 Mhp = 010-6620-3917 ========================2023-06-30 09:58:25======================== select * from customers where id = 'rpc0501' ========================2023-06-30 09:58:25======================== INSERT INTO customers ( id, custname, custnum, tel, hpno, frst_rgst_dtm, frst_rgster_nm) values ('rpc0501','충주시농협쌀조합공동사업법인','3038208926','010-6620-3917','010-6620-3917','2023-06-30 09:58:25','온라인') ========================2023-06-30 09:58:25======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rpc0501','2023-06-30 09:58:25','30900','33000','온라인','0') ========================2023-06-30 10:08:09======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-sejifc-1688087246 LGD_BUYER = 이정화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630100726 LGD_HASHDATA = 45f333e3b8740bfadd4ef17d6aea407c 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 = 20230630100839FC737547575B77E71B6831B2C0A941EDE38C7B55 Mname = 이정화 Mcompany = (주)세지에프씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = sejifc LGD_ESCROW_USEYN = N ========================2023-06-30 10:08:10======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630100840 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 = 53618190****645* LGD_FINANCEAUTHNUM = 81246389 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 51200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ab458cbf4467b9c80987a7e0c041a5b7 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230630100840 LGD_PCANCELSTR = 0 LGD_BUYER = 이정화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202306301008403ASB9 LGD_BUYERID = LGD_OID = Direct-sejifc-1688087246 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 10:08:10======================== insert into mBoard_order set rOrdNo = 'Direct-sejifc-1688087246', AuthTy = 'card', memberId = 'sejifc', OrdNm ='이정화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세지에프씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '삼성MASTER 53618190****645*', rApprNo = 'mjsof202306301008403ASB9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 10:08:10', InvoiceNum = '결제성공:Direct-sejifc-1688087246/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 10:08:10' ========================2023-06-30 10:08:10======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202306301008403ASB9' 0 = 1 cnt = 1 ========================2023-06-30 10:08:10======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'sejifc' 0 = sejifc Mid = sejifc 1 = (주)세지에프씨 Mcompany = (주)세지에프씨 2 = 214-88-52124 companyNum = 214-88-52124 3 = 02-522-6777 Mtel1 = 02-522-6777 4 = 010-8952-2514 Mhp = 010-8952-2514 ========================2023-06-30 10:08:10======================== select * from customers where id = 'sejifc' ========================2023-06-30 10:08:10======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('sejifc','2023-06-30 10:08:10','10000','11000','온라인','0') ========================2023-06-30 12:02:38======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hohoajc-1688094041 LGD_BUYER = 이규민 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630120041 LGD_HASHDATA = f8e85aac96126d8575ea1f9e651cbe82 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 = 2023063012030869E6AE70FDC6C0083918E83091BC2AD6E24309E9 Mname = 이규민 Mcompany = 우창유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hohoajc LGD_ESCROW_USEYN = N ========================2023-06-30 12:02:39======================== xpay_res LGD_DCNO = DC LGD_BUYERPHONE = LGD_PAYDATE = 20230630120308 LGD_DISCOUNTUSEYN = 1 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 = 37918394****62* LGD_FINANCEAUTHNUM = 32143449 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 51400 LGD_DISCOUNTUSEAMOUNT = 1500 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1bc403facbc78be9582079170a4ca358 LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20230630120309 LGD_PCANCELSTR = 0 LGD_BUYER = 이규민 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230630120308cNDp9 LGD_BUYERID = LGD_OID = Direct-hohoajc-1688094041 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 12:02:39======================== insert into mBoard_order set rOrdNo = 'Direct-hohoajc-1688094041', AuthTy = 'card', memberId = 'hohoajc', OrdNm ='이규민', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우창유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '삼성AMEX 37918394****62*', rApprNo = 'mjsof20230630120308cNDp9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 12:02:39', InvoiceNum = '결제성공:Direct-hohoajc-1688094041/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 12:02:39' ========================2023-06-30 12:02:39======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230630120308cNDp9' 0 = 1 cnt = 1 ========================2023-06-30 12:02:39======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hohoajc' 0 = hohoajc Mid = hohoajc 1 = 우창유통 Mcompany = 우창유통 2 = 4650501671 companyNum = 4650501671 3 = 010-4921-1831 Mtel1 = 010-4921-1831 4 = 010-4921-1831 Mhp = 010-4921-1831 ========================2023-06-30 12:02:39======================== select * from customers where id = 'hohoajc' ========================2023-06-30 12:02:39======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hohoajc','2023-06-30 12:02:39','220000','220000','온라인','0') ========================2023-06-30 12:27:04======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-anbinnakdo-1688095476 LGD_BUYER = 박현석 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630122436 LGD_HASHDATA = 683bea13202f6e1e0ac39932f19fb559 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 = 20230630122734E418FDF217E729EC662B08AB82537650F4E9BA99 Mname = 박현석 Mcompany = 마니푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = anbinnakdo LGD_ESCROW_USEYN = N ========================2023-06-30 12:27:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630122734 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 001550 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45797356****305* LGD_FINANCEAUTHNUM = 30033745 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 239d1bc27aa0b84f1b0e1dd494213028 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20230630122734 LGD_PCANCELSTR = 0 LGD_BUYER = 박현석 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20230630122734cPZP7 LGD_BUYERID = LGD_OID = Direct-anbinnakdo-1688095476 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 12:27:04======================== insert into mBoard_order set rOrdNo = 'Direct-anbinnakdo-1688095476', AuthTy = 'card', memberId = 'anbinnakdo', OrdNm ='박현석', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '마니푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '국민VISA 45797356****305*', rApprNo = 'mjsof20230630122734cPZP7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 12:27:04', InvoiceNum = '결제성공:Direct-anbinnakdo-1688095476/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 12:27:04' ========================2023-06-30 12:27:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20230630122734cPZP7' 0 = 1 cnt = 1 ========================2023-06-30 12:27:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'anbinnakdo' 0 = anbinnakdo Mid = anbinnakdo 1 = 마니푸드 Mcompany = 마니푸드 2 = 121-20-60884 companyNum = 121-20-60884 3 = 070-4082-2105 Mtel1 = 070-4082-2105 4 = 010-9099-2105 Mhp = 010-9099-2105 ========================2023-06-30 12:27:04======================== select * from customers where id = 'anbinnakdo' ========================2023-06-30 12:27:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('anbinnakdo','2023-06-30 12:27:04','52500','55000','온라인','0') ========================2023-06-30 14:47:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-guil09-1688103983 LGD_BUYER = 최해국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630144623 LGD_HASHDATA = 543212b7c304069c834e1819e5fa8251 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 = 20230630144740F8BD236B9862CE225A46F31571261918AF5824D6 Mname = 최해국 Mcompany = 구일종합상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = guil09 LGD_ESCROW_USEYN = N ========================2023-06-30 14:47:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630144741 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 = 45749380****302* LGD_FINANCEAUTHNUM = 00176411 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 087f4fae1c2163aa30f37e38a55e25ea LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20230630144741 LGD_PCANCELSTR = 0 LGD_BUYER = 최해국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202306301447414A3v1 LGD_BUYERID = LGD_OID = Direct-guil09-1688103983 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 14:47:11======================== insert into mBoard_order set rOrdNo = 'Direct-guil09-1688103983', AuthTy = 'card', memberId = 'guil09', OrdNm ='최해국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '구일종합상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대VISA 45749380****302*', rApprNo = 'mjsof202306301447414A3v1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 14:47:11', InvoiceNum = '결제성공:Direct-guil09-1688103983/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 14:47:11' ========================2023-06-30 14:47:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202306301447414A3v1' 0 = 1 cnt = 1 ========================2023-06-30 14:47:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'guil09' 0 = guil09 Mid = guil09 1 = 구일종합상사 Mcompany = 구일종합상사 2 = 3052186849 companyNum = 3052186849 3 = 010-4224-4146 Mtel1 = 010-4224-4146 4 = 010-4224-4146 Mhp = 010-4224-4146 ========================2023-06-30 14:47:11======================== select * from customers where id = 'guil09' ========================2023-06-30 14:47:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('guil09','2023-06-30 14:47:11','108000','110000','온라인','0') ========================2023-06-30 15:45:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-k114-1688107511 LGD_BUYER = 김상옥 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630154511 LGD_HASHDATA = 7ad3987f55a7ac602fba4f7e9a5459c8 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 = 2023063015461822417B5BBE79E10119461565738318C47E6FA7E2 Mname = 김상옥 Mcompany = 강원산업안전(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = k114 LGD_ESCROW_USEYN = N ========================2023-06-30 15:45:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630154619 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 224776 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55892098****736* LGD_FINANCEAUTHNUM = 60677693 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4c42df4e587b058ecd6ec2af8e7d675c LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20230630154619 LGD_PCANCELSTR = 0 LGD_BUYER = 김상옥 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2023063015461872Uu0 LGD_BUYERID = LGD_OID = Direct-k114-1688107511 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 015461872UM8 ========================2023-06-30 15:45:49======================== insert into mBoard_order set rOrdNo = 'Direct-k114-1688107511', AuthTy = 'card', memberId = 'k114', OrdNm ='김상옥', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '강원산업안전(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨MASTER 55892098****736*', rApprNo = 'mjsof2023063015461872Uu0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 15:45:49', InvoiceNum = '결제성공:Direct-k114-1688107511/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 15:45:49' ========================2023-06-30 15:45:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2023063015461872Uu0' 0 = 1 cnt = 1 ========================2023-06-30 15:45:49======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'k114' 0 = k114 Mid = k114 1 = 강원산업안전(주) Mcompany = 강원산업안전(주) 2 = 2388100225 companyNum = 2388100225 3 = 033-732-3114 Mtel1 = 033-732-3114 4 = 010-5115-3114 Mhp = 010-5115-3114 ========================2023-06-30 15:45:49======================== select * from customers where id = 'k114' ========================2023-06-30 15:45:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('k114','2023-06-30 15:45:49','220000','220000','온라인','0') ========================2023-06-30 16:16:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brfood-1688109326 LGD_BUYER = 조경미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20230630161526 LGD_HASHDATA = 7e356407ae9f530297b35dce92b6083a 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 = 202306301616429ED266252B2FFF2704DE488A462E68BB6B002704 Mname = 조경미 Mcompany = 농업회사법인주식회사강남푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = brfood LGD_ESCROW_USEYN = N ========================2023-06-30 16:16:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20230630161642 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 = 94311704****674* LGD_FINANCEAUTHNUM = 58133385 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 2374b1616e0b39448faded7b0bd80d8b LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20230630161643 LGD_PCANCELSTR = 0 LGD_BUYER = 조경미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202306301616421gW33 LGD_BUYERID = LGD_OID = Direct-brfood-1688109326 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-06-30 16:16:13======================== insert into mBoard_order set rOrdNo = 'Direct-brfood-1688109326', AuthTy = 'card', memberId = 'brfood', OrdNm ='조경미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '농업회사법인주식회사강남푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 94311704****674*', rApprNo = 'mjsof202306301616421gW33', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-06-30 16:16:13', InvoiceNum = '결제성공:Direct-brfood-1688109326/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-06-30 16:16:13' ========================2023-06-30 16:16:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202306301616421gW33' 0 = 1 cnt = 1 ========================2023-06-30 16:16:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'brfood' 0 = brfood Mid = brfood 1 = 농업회사법인주식회사강남푸드 Mcompany = 농업회사법인주식회사강남푸드 2 = 270-87-01026 companyNum = 270-87-01026 3 = 010-5581-2073 Mtel1 = 010-5581-2073 4 = 010-5581-2073 Mhp = 010-5581-2073 ========================2023-06-30 16:16:13======================== select * from customers where id = 'brfood' ========================2023-06-30 16:16:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brfood','2023-06-30 16:16:13','108000','110000','온라인','0')