========================2024-11-08 10:59:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-jeongho9080-1731031106 LGD_BUYER = 문지호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108105826 LGD_HASHDATA = fa54755dd808466081e4f083a28c72eb 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 = 20241108110328C17BEE5975ED9DF55DFAC5C47CDD1877CE9D5E92 Mname = 문지호 Mcompany = 정호종합건재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = jeongho9080 LGD_ESCROW_USEYN = N ========================2024-11-08 10:59:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108110328 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 = 52881500****130* LGD_FINANCEAUTHNUM = 00125667 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f8c1afc7af84785da6274e8b7d222c09 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20241108110328 LGD_PCANCELSTR = 0 LGD_BUYER = 문지호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108110328oq5r1 LGD_BUYERID = LGD_OID = Direct-jeongho9080-1731031106 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-08 10:59:50======================== insert into mBoard_order set rOrdNo = 'Direct-jeongho9080-1731031106', AuthTy = 'card', memberId = 'jeongho9080', OrdNm ='문지호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '정호종합건재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대MASTER 52881500****130*', rApprNo = 'mjsof20241108110328oq5r1', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 10:59:50', InvoiceNum = '결제성공:Direct-jeongho9080-1731031106/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 10:59:50' ========================2024-11-08 10:59:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108110328oq5r1' 0 = 1 cnt = 1 ========================2024-11-08 10:59:50======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'jeongho9080' 0 = jeongho9080 Mid = jeongho9080 1 = 정호종합건재 Mcompany = 정호종합건재 2 = 616-31-19628 companyNum = 616-31-19628 3 = 010-3697-9080 Mtel1 = 010-3697-9080 4 = 010-3697-9080 Mhp = 010-3697-9080 ========================2024-11-08 10:59:50======================== select * from customers where id = 'jeongho9080' ========================2024-11-08 10:59:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('jeongho9080','2024-11-08 10:59:50','108000','110000','온라인','0') ========================2024-11-08 13:31:06======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ts5ttogi-1731036202 LGD_BUYER = 김건우 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108122322 LGD_HASHDATA = e1f751e986630da1189de91b08431f63 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 = 202411081334457022E630E46E898B27941EAF18211EE4328C8968 Mname = 김건우 Mcompany = (주)태신종합물류 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ts5ttogi LGD_ESCROW_USEYN = N ========================2024-11-08 13:31:07======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108133445 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 = 91000300****487* LGD_FINANCEAUTHNUM = 30574884 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b39533eff58a27f96264f45b2cd4f309 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241108133446 LGD_PCANCELSTR = 0 LGD_BUYER = 김건우 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108133445KiCN7 LGD_BUYERID = LGD_OID = Direct-ts5ttogi-1731036202 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8133445KWcA2 ========================2024-11-08 13:31:07======================== insert into mBoard_order set rOrdNo = 'Direct-ts5ttogi-1731036202', AuthTy = 'card', memberId = 'ts5ttogi', OrdNm ='김건우', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)태신종합물류', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 91000300****487*', rApprNo = 'mjsof20241108133445KiCN7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 13:31:07', InvoiceNum = '결제성공:Direct-ts5ttogi-1731036202/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 13:31:07' ========================2024-11-08 13:31:07======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108133445KiCN7' 0 = 1 cnt = 1 ========================2024-11-08 13:31:07======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ts5ttogi' 0 = ts5ttogi Mid = ts5ttogi 1 = (주)태신종합물류 Mcompany = (주)태신종합물류 2 = 6918600886 companyNum = 6918600886 3 = 010-4841-6383 Mtel1 = 010-4841-6383 4 = 010-3350-6383 Mhp = 010-3350-6383 ========================2024-11-08 13:31:07======================== select * from customers where id = 'ts5ttogi' ========================2024-11-08 13:31:07======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ts5ttogi','2024-11-08 13:31:07','220000','220000','온라인','0') ========================2024-11-08 14:28:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-brfood-1731043660 LGD_BUYER = 조경미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108142740 LGD_HASHDATA = 4522b9f49df8f81e82f6dfa2a9d02230 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 = 20241108143149A6584A1E7C5E542C2682C7DD32AB6770BAF5032B Mname = 조경미 Mcompany = 농업회사법인주식회사강남푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = brfood LGD_ESCROW_USEYN = N ========================2024-11-08 14:28:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108143150 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 = 94311704****674* LGD_FINANCEAUTHNUM = 52133090 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = 0b18afc313643ba2e12c4c7e7be75896 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20241108143150 LGD_PCANCELSTR = 0 LGD_BUYER = 조경미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108143150FQ462 LGD_BUYERID = LGD_OID = Direct-brfood-1731043660 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-08 14:28:11======================== insert into mBoard_order set rOrdNo = 'Direct-brfood-1731043660', AuthTy = 'card', memberId = 'brfood', OrdNm ='조경미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '농업회사법인주식회사강남푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 94311704****674*', rApprNo = 'mjsof20241108143150FQ462', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 14:28:11', InvoiceNum = '결제성공:Direct-brfood-1731043660/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 14:28:11' ========================2024-11-08 14:28:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108143150FQ462' 0 = 1 cnt = 1 ========================2024-11-08 14:28:11======================== 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 ========================2024-11-08 14:28:11======================== select * from customers where id = 'brfood' ========================2024-11-08 14:28:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('brfood','2024-11-08 14:28:11','220000','220000','온라인','0') ========================2024-11-08 14:31:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woo1935-1731043750 LGD_BUYER = 김병창 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108142910 LGD_HASHDATA = ac06ce8d2da827df0d0de6280193a2ff 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 = 202411081435105EE12A53E2BA796EC8510585A13C546BB371780F Mname = 김병창 Mcompany = 우진 글로벌 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woo1935 LGD_ESCROW_USEYN = N ========================2024-11-08 14:31:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108143510 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woojinglobal@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = ALXC6E LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94106186****990* LGD_FINANCEAUTHNUM = 09027303 LGD_CARDNOINTEREST_YN = 1 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a66072e9131bdfcd329569bb4553ea58 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20241108143511 LGD_PCANCELSTR = 0 LGD_BUYER = 김병창 LGD_CARDINSTALLMONTH = 05 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108143510I51h9 LGD_BUYERID = LGD_OID = Direct-woo1935-1731043750 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-08 14:31:32======================== insert into mBoard_order set rOrdNo = 'Direct-woo1935-1731043750', AuthTy = 'card', memberId = 'woo1935', OrdNm ='김병창', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우진 글로벌', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한 94106186****990*', rApprNo = 'mjsof20241108143510I51h9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 14:31:32', InvoiceNum = '결제성공:Direct-woo1935-1731043750/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 14:31:32' ========================2024-11-08 14:31:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108143510I51h9' 0 = 1 cnt = 1 ========================2024-11-08 14:31:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woo1935' 0 = woo1935 Mid = woo1935 1 = 우진 글로벌 Mcompany = 우진 글로벌 2 = 1950101022 companyNum = 1950101022 3 = 010-8371-3533 Mtel1 = 010-8371-3533 4 = 010-8643-1935 Mhp = 010-8643-1935 ========================2024-11-08 14:31:32======================== select * from customers where id = 'woo1935' ========================2024-11-08 14:31:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woo1935','2024-11-08 14:31:32','220000','220000','온라인','0') ========================2024-11-08 14:37:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-barun0225-1731044236 LGD_BUYER = 조장환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108143716 LGD_HASHDATA = 8664f722bcca0beef367fb3bd2d3bd34 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 = 20241108144121DAE82244548C1179CD9BE51A4455DAB5E8DFBE2F Mname = 조장환 Mcompany = 바른식품푸드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = barun0225 LGD_ESCROW_USEYN = N ========================2024-11-08 14:37:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108144121 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = BA8AZR LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 44991481****064* LGD_FINANCEAUTHNUM = 09113075 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 1 LGD_HASHDATA = d383763b3bd98c8efed1da02e8223a2d LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20241108144123 LGD_PCANCELSTR = 0 LGD_BUYER = 조장환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108144121BVxf9 LGD_BUYERID = LGD_OID = Direct-barun0225-1731044236 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2024-11-08 14:37:44======================== insert into mBoard_order set rOrdNo = 'Direct-barun0225-1731044236', AuthTy = 'card', memberId = 'barun0225', OrdNm ='조장환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '바른식품푸드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 44991481****064*', rApprNo = 'mjsof20241108144121BVxf9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 14:37:44', InvoiceNum = '결제성공:Direct-barun0225-1731044236/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 14:37:44' ========================2024-11-08 14:37:44======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108144121BVxf9' 0 = 1 cnt = 1 ========================2024-11-08 14:37:44======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'barun0225' 0 = barun0225 Mid = barun0225 1 = 바른식품푸드 Mcompany = 바른식품푸드 2 = 324-03-01793 companyNum = 324-03-01793 3 = 010-5581-2073 Mtel1 = 010-5581-2073 4 = 010 -5581-2073 Mhp = 010 -5581-2073 ========================2024-11-08 14:37:44======================== select * from customers where id = 'barun0225' ========================2024-11-08 14:37:44======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('barun0225','2024-11-08 14:37:44','220000','220000','온라인','0') ========================2024-11-08 14:47:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-akdlanffo-1731044803 LGD_BUYER = 김주한 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108144643 LGD_HASHDATA = 76a700ab1d173658d2790340a738c100 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 = 20241108145057A833B467ED6B63976DE6A1077B7DCC0ACA5CC426 Mname = 김주한 Mcompany = 주식회사장한유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = akdlanffo LGD_ESCROW_USEYN = N ========================2024-11-08 14:47:18======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108145057 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 393322 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 65413980****288* LGD_FINANCEAUTHNUM = 32376368 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 31500 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 3aab02254560769a760f1b0d709c8441 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨DINERS LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241108145057 LGD_PCANCELSTR = 0 LGD_BUYER = 김주한 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108145057QFkR7 LGD_BUYERID = LGD_OID = Direct-akdlanffo-1731044803 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8145057QqYR7 ========================2024-11-08 14:47:18======================== insert into mBoard_order set rOrdNo = 'Direct-akdlanffo-1731044803', AuthTy = 'card', memberId = 'akdlanffo', OrdNm ='김주한', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사장한유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '비씨DINERS 65413980****288*', rApprNo = 'mjsof20241108145057QFkR7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 14:47:18', InvoiceNum = '결제성공:Direct-akdlanffo-1731044803/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 14:47:18' ========================2024-11-08 14:47:18======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108145057QFkR7' 0 = 1 cnt = 1 ========================2024-11-08 14:47:18======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'akdlanffo' 0 = akdlanffo Mid = akdlanffo 1 = 주식회사장한유통 Mcompany = 주식회사장한유통 2 = 5908701347 companyNum = 5908701347 3 = 051-322-3338 Mtel1 = 051-322-3338 4 = 010-5567-7289 Mhp = 010-5567-7289 ========================2024-11-08 14:47:18======================== select * from customers where id = 'akdlanffo' ========================2024-11-08 14:47:18======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('akdlanffo','2024-11-08 14:47:18','30900','33000','온라인','0') ========================2024-11-08 17:38:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wjosc09-1731055032 LGD_BUYER = 심보미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20241108173712 LGD_HASHDATA = bb6d46566b6463099cab47e64161a2d0 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 = 202411081741527A5827EBBEC4E1BC266208F5ADA85FD3AFA25847 Mname = 심보미 Mcompany = (주)원진오에스씨 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = wjosc09 LGD_ESCROW_USEYN = N ========================2024-11-08 17:38:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20241108174152 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = bomee486@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94307870****307* LGD_FINANCEAUTHNUM = 33911491 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 1a52ed9433ade4a95c78cc8c3fc5df5a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20241108174153 LGD_PCANCELSTR = 0 LGD_BUYER = 심보미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20241108174152WeJV3 LGD_BUYERID = LGD_OID = Direct-wjosc09-1731055032 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 8174152WwPG2 ========================2024-11-08 17:38:14======================== insert into mBoard_order set rOrdNo = 'Direct-wjosc09-1731055032', AuthTy = 'card', memberId = 'wjosc09', OrdNm ='심보미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)원진오에스씨', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94307870****307*', rApprNo = 'mjsof20241108174152WeJV3', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2024-11-08 17:38:14', InvoiceNum = '결제성공:Direct-wjosc09-1731055032/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2024-11-08 17:38:14' ========================2024-11-08 17:38:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20241108174152WeJV3' 0 = 1 cnt = 1 ========================2024-11-08 17:38:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wjosc09' 0 = wjosc09 Mid = wjosc09 1 = (주)원진오에스씨 Mcompany = (주)원진오에스씨 2 = 119-81-66436 companyNum = 119-81-66436 3 = 010-3785-4495 Mtel1 = 010-3785-4495 4 = 010-3785-4495 Mhp = 010-3785-4495 ========================2024-11-08 17:38:14======================== select * from customers where id = 'wjosc09' ========================2024-11-08 17:38:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wjosc09','2024-11-08 17:38:14','220000','220000','온라인','0')