========================2021-07-02 07:01:18======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-filsy82-1625176817 LGD_BUYER = 이승환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702070017 LGD_HASHDATA = 8d065bc75742b25c614809f4262c1438 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 = 202107020701419900F540C5AE49E38B490713770CAF6AZWQZWFJU Mname = 이승환 Mcompany = 동원상사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = filsy82 LGD_ESCROW_USEYN = N ========================2021-07-02 07:01:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702070141 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BBBBPW LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 554481******6314 LGD_FINANCEAUTHNUM = 36508157 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e266a3dba2ad2c6fa58d5fdc22749ab1 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210702070141 LGD_PCANCELSTR = 0 LGD_BUYER = 이승환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070207014160212 LGD_BUYERID = LGD_OID = Direct-filsy82-1625176817 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-02 07:01:19======================== insert into mBoard_order set rOrdNo = 'Direct-filsy82-1625176817', AuthTy = 'card', memberId = 'filsy82', OrdNm ='이승환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '동원상사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '신한MASTER 554481******6314', rApprNo = 'mjsof2021070207014160212', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 07:01:19', InvoiceNum = '결제성공:Direct-filsy82-1625176817/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 07:01:19' ========================2021-07-02 07:01:19======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070207014160212' 0 = 1 cnt = 1 ========================2021-07-02 07:01:19======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'filsy82' 0 = filsy82 Mid = filsy82 1 = 동원상사 Mcompany = 동원상사 2 = 1243632559 companyNum = 1243632559 3 = 010-3363-5661 Mtel1 = 010-3363-5661 4 = -- Mhp = -- ========================2021-07-02 07:01:19======================== select * from customers where id = 'filsy82' ========================2021-07-02 07:01:19======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('filsy82','2021-07-02 07:01:19','30900','33000','온라인','0') ========================2021-07-02 09:18:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ositrade-1625184970 LGD_BUYER = (주)오에스아이무역 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702091610 LGD_HASHDATA = 1d42d069d5f6651b970e50a559dcf7e6 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 = 2021070209185499BE6A987F5F43DEA89FAC3A6ACC84AALW7YBAXN Mname = (주)오에스아이무역 Mcompany = (주)오에스아이무역 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = ositrade LGD_ESCROW_USEYN = N ========================2021-07-02 09:18:32======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702091854 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 003332 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 558526******2828 LGD_FINANCEAUTHNUM = 30248626 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = f813f6441b6387e55c6e748a19de1618 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210702091854 LGD_PCANCELSTR = 0 LGD_BUYER = (주)오에스아이무역 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070209185461273 LGD_BUYERID = LGD_OID = Direct-ositrade-1625184970 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 209185461233 ========================2021-07-02 09:18:32======================== insert into mBoard_order set rOrdNo = 'Direct-ositrade-1625184970', AuthTy = 'card', memberId = 'ositrade', OrdNm ='(주)오에스아이무역', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)오에스아이무역', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2828', rApprNo = 'mjsof2021070209185461273', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 09:18:32', InvoiceNum = '결제성공:Direct-ositrade-1625184970/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 09:18:32' ========================2021-07-02 09:18:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070209185461273' 0 = 1 cnt = 1 ========================2021-07-02 09:18:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ositrade' 0 = ositrade Mid = ositrade 1 = (주)오에스아이무역 Mcompany = (주)오에스아이무역 2 = 206-86-15838 companyNum = 206-86-15838 3 = 031-529-7155 Mtel1 = 031-529-7155 4 = 010-2253-8722 Mhp = 010-2253-8722 ========================2021-07-02 09:18:32======================== select * from customers where id = 'ositrade' ========================2021-07-02 09:18:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ositrade','2021-07-02 09:18:32','108000','110000','온라인','0') ========================2021-07-02 14:01:55======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-clover70-1625201997 LGD_BUYER = 최일신 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702135957 LGD_HASHDATA = be4221b5350f79182628adf7590493c3 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 = 2021070214021868A07BF18B8A4B218E6B2010A8944A8CBPFHGCDM Mname = 최일신 Mcompany = 크로바코리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = clover70 LGD_ESCROW_USEYN = N ========================2021-07-02 14:01:55======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702140218 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = 70clover!@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = AFA00A LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 356297******9538 LGD_FINANCEAUTHNUM = 40592866 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 41300 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cca0b4c211fa51df6bc32ca256e8cc00 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한JCB LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210702140218 LGD_PCANCELSTR = 0 LGD_BUYER = 최일신 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070214021861095 LGD_BUYERID = LGD_OID = Direct-clover70-1625201997 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-02 14:23:59======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hara-1625203351 LGD_BUYER = 박태진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702142231 LGD_HASHDATA = 9248af6bb1bbc6703e65f2799364724e 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 = 2021070214242292DDAC0B15B142018E089E4ECFA3A6A91B2LWTTY Mname = 박태진 Mcompany = 주식회사 하라 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hara LGD_ESCROW_USEYN = N ========================2021-07-02 14:24:01======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702142423 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396C0C LGD_AFFILIATECODE = 755342 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******5905 LGD_FINANCEAUTHNUM = 43250719 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 87d6017e01a96692803e19a6c9cd859d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210702142424 LGD_PCANCELSTR = 0 LGD_BUYER = 박태진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070214242361024 LGD_BUYERID = LGD_OID = Direct-hara-1625203351 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 214242361068 ========================2021-07-02 14:24:01======================== insert into mBoard_order set rOrdNo = 'Direct-hara-1625203351', AuthTy = 'card', memberId = 'hara', OrdNm ='박태진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하라', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******5905', rApprNo = 'mjsof2021070214242361024', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 14:24:01', InvoiceNum = '결제성공:Direct-hara-1625203351/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 14:24:01' ========================2021-07-02 14:24:01======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070214242361024' 0 = 1 cnt = 1 ========================2021-07-02 14:24:01======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hara' 0 = hara Mid = hara 1 = 주식회사 하라 Mcompany = 주식회사 하라 2 = 6248700715 companyNum = 6248700715 3 = 061-278-5144 Mtel1 = 061-278-5144 4 = 010-8700-5002 Mhp = 010-8700-5002 ========================2021-07-02 14:24:01======================== select * from customers where id = 'hara' ========================2021-07-02 14:24:01======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hara','2021-07-02 14:24:01','108000','110000','온라인','0') ========================2021-07-02 14:25:40======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-harapolymer-1625203491 LGD_BUYER = 박인홍 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702142451 LGD_HASHDATA = e2b840fac4e0bc6a632ad1a08d36e2af 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 = 2021070214260392659BC9A32840BAB3D3AD272F02765BMKOLNRXC Mname = 박인홍 Mcompany = 하라포리마 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = harapolymer LGD_ESCROW_USEYN = N ========================2021-07-02 14:25:41======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702142604 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 396C0C LGD_AFFILIATECODE = 755342 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414003******5905 LGD_FINANCEAUTHNUM = 43256144 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 5fcd3f8391c87f68ed8facd82792de0a LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20210702142604 LGD_PCANCELSTR = 0 LGD_BUYER = 박인홍 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070214260360180 LGD_BUYERID = LGD_OID = Direct-harapolymer-1625203491 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 214260360117 ========================2021-07-02 14:25:41======================== insert into mBoard_order set rOrdNo = 'Direct-harapolymer-1625203491', AuthTy = 'card', memberId = 'harapolymer', OrdNm ='박인홍', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '하라포리마', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '비씨VISA 414003******5905', rApprNo = 'mjsof2021070214260360180', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 14:25:41', InvoiceNum = '결제성공:Direct-harapolymer-1625203491/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 14:25:41' ========================2021-07-02 14:25:41======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070214260360180' 0 = 1 cnt = 1 ========================2021-07-02 14:25:41======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'harapolymer' 0 = harapolymer Mid = harapolymer 1 = 하라포리마 Mcompany = 하라포리마 2 = 411-16-91115 companyNum = 411-16-91115 3 = 061-272-5004 Mtel1 = 061-272-5004 4 = 010-8700-5002 Mhp = 010-8700-5002 ========================2021-07-02 14:25:41======================== select * from customers where id = 'harapolymer' ========================2021-07-02 14:25:41======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('harapolymer','2021-07-02 14:25:41','10000','11000','온라인','0') ========================2021-07-02 15:32:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-davis747-1625207476 LGD_BUYER = 홍연호 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702153116 LGD_HASHDATA = 8806c5237f4992ca279f784f63edbd1b 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 = 20210702153233A72ED76D4826427C9D47316F4AC83665AS0G6VKI Mname = 홍연호 Mcompany = (주)다비스다이아몬드 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = davis747 LGD_ESCROW_USEYN = N ========================2021-07-02 15:32:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702153234 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 = 426586******4667 LGD_FINANCEAUTHNUM = 30046771 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 2e1b73f50feb8d1b6bc6d28cb1d0e2bb LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210702153234 LGD_PCANCELSTR = 0 LGD_BUYER = 홍연호 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070215323361212 LGD_BUYERID = LGD_OID = Direct-davis747-1625207476 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 215323361243 ========================2021-07-02 15:32:11======================== insert into mBoard_order set rOrdNo = 'Direct-davis747-1625207476', AuthTy = 'card', memberId = 'davis747', OrdNm ='홍연호', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다비스다이아몬드', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민VISA 426586******4667', rApprNo = 'mjsof2021070215323361212', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 15:32:11', InvoiceNum = '결제성공:Direct-davis747-1625207476/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 15:32:11' ========================2021-07-02 15:32:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070215323361212' 0 = 1 cnt = 1 ========================2021-07-02 15:32:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'davis747' 0 = davis747 Mid = davis747 1 = (주)다비스다이아몬드 Mcompany = (주)다비스다이아몬드 2 = 101-81-80077 companyNum = 101-81-80077 3 = 02-747-1802 Mtel1 = 02-747-1802 4 = 010-7528-2227 Mhp = 010-7528-2227 ========================2021-07-02 15:32:11======================== select * from customers where id = 'davis747' ========================2021-07-02 15:32:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('davis747','2021-07-02 15:32:11','108000','110000','온라인','0') ========================2021-07-02 16:52:19======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hankook0954-1625212186 LGD_BUYER = 김시룡 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210702164946 LGD_HASHDATA = c965dd591d529aa33fbd0a4efdcf6a19 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 = 20210702165242906EC320A8994F9486BE521F41389D91NEM5PXE1 Mname = 김시룡 Mcompany = 한국종합기계 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = hankook0954 LGD_ESCROW_USEYN = N ========================2021-07-02 16:52:19======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210702165242 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 373ICC LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******6961 LGD_FINANCEAUTHNUM = 42613598 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 91f9f1369e0a232cedf9f319dc71c4b5 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210702165243 LGD_PCANCELSTR = 0 LGD_BUYER = 김시룡 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021070216524261005 LGD_BUYERID = LGD_OID = Direct-hankook0954-1625212186 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-07-02 16:52:19======================== insert into mBoard_order set rOrdNo = 'Direct-hankook0954-1625212186', AuthTy = 'card', memberId = 'hankook0954', OrdNm ='김시룡', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '한국종합기계', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 490298******6961', rApprNo = 'mjsof2021070216524261005', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-07-02 16:52:19', InvoiceNum = '결제성공:Direct-hankook0954-1625212186/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-07-02 16:52:19' ========================2021-07-02 16:52:20======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021070216524261005' 0 = 1 cnt = 1 ========================2021-07-02 16:52:20======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hankook0954' 0 = hankook0954 Mid = hankook0954 1 = 한국종합기계 Mcompany = 한국종합기계 2 = 2261013479 companyNum = 2261013479 3 = 033-653-0953 Mtel1 = 033-653-0953 4 = 010-5594-6784 Mhp = 010-5594-6784 ========================2021-07-02 16:52:20======================== select * from customers where id = 'hankook0954' ========================2021-07-02 16:52:20======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hankook0954','2021-07-02 16:52:19','220000','220000','온라인','0')