========================2021-01-07 09:00:36======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1609977566 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107085926 LGD_HASHDATA = ebfbda8d6205787ca392b999620a181a LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021010709004286F7E5B38E74DD8F22AC16AEECDB436649E4F264 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 ========================2021-01-07 09:00:37======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107090042 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306I7C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 40374817 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b9a5fa143d1842d6074a3a80d2a72985 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210107090042 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010709004261269 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1609977566 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-07 09:00:37======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1609977566', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021010709004261269', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 09:00:37', InvoiceNum = '결제성공:Direct-goodssal5707-1609977566/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 09:00:37' ========================2021-01-07 09:00:37======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010709004261269' 0 = 1 cnt = 1 ========================2021-01-07 09:00:37======================== 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-9019-7586 Mhp = 010-9019-7586 ========================2021-01-07 09:00:37======================== select * from customers where id = 'goodssal5707' ========================2021-01-07 09:00:37======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-01-07 09:00:37','220000','220000','온라인','0') ========================2021-01-07 09:01:48======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1609977652 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107090052 LGD_HASHDATA = b3d4298cd0f3fe460e8b0ec618ad3715 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210107090154E254A0C695669A508728B1ED62432F0B59D86436 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 ========================2021-01-07 09:01:49======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107090154 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306I7C LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943017******8249 LGD_FINANCEAUTHNUM = 40378546 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 314e78c8716e5b6f2917880df298e2e1 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20210107090155 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010709015414276 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1609977652 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-07 09:01:49======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1609977652', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = 'NH 943017******8249', rApprNo = 'mjsof2021010709015414276', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 09:01:49', InvoiceNum = '결제성공:Direct-goodssal5707-1609977652/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 09:01:49' ========================2021-01-07 09:01:49======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010709015414276' 0 = 1 cnt = 1 ========================2021-01-07 09:01:49======================== 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-9019-7586 Mhp = 010-9019-7586 ========================2021-01-07 09:01:49======================== select * from customers where id = 'goodssal5707' ========================2021-01-07 09:01:49======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-01-07 09:01:49','220000','220000','온라인','0') ========================2021-01-07 11:57:21======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-azfoods01-1609988179 LGD_BUYER = 박정운 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107115619 LGD_HASHDATA = 0a1faec7907653dc15a08620a1af46eb LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210107115726AAC1E235C3FE654E8A6E1F6AB16E9D17B8A40699 Mname = 박정운 Mcompany = (주)에이젯푸즈 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = azfoods01 LGD_ESCROW_USEYN = N ========================2021-01-07 11:57:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107115727 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 = 558526******2828 LGD_FINANCEAUTHNUM = 30006921 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 56f94bf9770a5dd0fde76a72ec31d488 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20210107115727 LGD_PCANCELSTR = 0 LGD_BUYER = 박정운 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010711572761058 LGD_BUYERID = LGD_OID = Direct-azfoods01-1609988179 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 711572761090 ========================2021-01-07 11:57:21======================== insert into mBoard_order set rOrdNo = 'Direct-azfoods01-1609988179', AuthTy = 'card', memberId = 'azfoods01', OrdNm ='박정운', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)에이젯푸즈', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '국민MASTER 558526******2828', rApprNo = 'mjsof2021010711572761058', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 11:57:21', InvoiceNum = '결제성공:Direct-azfoods01-1609988179/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 11:57:21' ========================2021-01-07 11:57:21======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010711572761058' 0 = 1 cnt = 1 ========================2021-01-07 11:57:21======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'azfoods01' 0 = azfoods01 Mid = azfoods01 1 = (주)에이젯푸즈 Mcompany = (주)에이젯푸즈 2 = 4098625143 companyNum = 4098625143 3 = 062-524-0600 Mtel1 = 062-524-0600 4 = 010-7177-8486 Mhp = 010-7177-8486 ========================2021-01-07 11:57:21======================== select * from customers where id = 'azfoods01' ========================2021-01-07 11:57:21======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('azfoods01','2021-01-07 11:57:21','108000','110000','온라인','0') ========================2021-01-07 16:03:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rkddyd112-1610002915 LGD_BUYER = 강용진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107160155 LGD_HASHDATA = 232dc61201c5718e87d9b18843542231 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 2021010716032868943BC4E54285AE3094D26522E5362363463518 Mname = 강용진 Mcompany = 용진농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = rkddyd112 LGD_ESCROW_USEYN = N ========================2021-01-07 16:03:22======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107160328 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 559924******7109 LGD_FINANCEAUTHNUM = 00383399 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = bb8a948f9877020fb4a13c3d15328cce LGD_BUYERADDRESS = LGD_FINANCENAME = 현대MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210107160328 LGD_PCANCELSTR = 0 LGD_BUYER = 강용진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010716032861217 LGD_BUYERID = LGD_OID = Direct-rkddyd112-1610002915 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-07 16:03:22======================== insert into mBoard_order set rOrdNo = 'Direct-rkddyd112-1610002915', AuthTy = 'card', memberId = 'rkddyd112', OrdNm ='강용진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '용진농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대MASTER 559924******7109', rApprNo = 'mjsof2021010716032861217', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 16:03:22', InvoiceNum = '결제성공:Direct-rkddyd112-1610002915/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 16:03:22' ========================2021-01-07 16:03:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010716032861217' 0 = 1 cnt = 1 ========================2021-01-07 16:03:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rkddyd112' 0 = rkddyd112 Mid = rkddyd112 1 = 용진농산 Mcompany = 용진농산 2 = 6229305637 companyNum = 6229305637 3 = 010-3775-1986 Mtel1 = 010-3775-1986 4 = 010-3775-1986 Mhp = 010-3775-1986 ========================2021-01-07 16:03:23======================== select * from customers where id = 'rkddyd112' ========================2021-01-07 16:03:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rkddyd112','2021-01-07 16:03:22','30900','33000','온라인','0') ========================2021-01-07 22:25:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isaac24-1610025708 LGD_BUYER = 임현국 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107222148 LGD_HASHDATA = da0be945c06f43678623c0b73b8a6fa7 LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210107222518705618D40A2BE81B3D96488442F9A9F74ECE307D Mname = 임현국 Mcompany = 이삭홍대 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = isaac24 LGD_ESCROW_USEYN = N ========================2021-01-07 22:25:12======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107222518 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 949019******8719 LGD_FINANCEAUTHNUM = 00152006 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 61000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 67351e942b9fdd4fc2c4d26acfe88f00 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20210107222518 LGD_PCANCELSTR = 0 LGD_BUYER = 임현국 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010722251861122 LGD_BUYERID = LGD_OID = Direct-isaac24-1610025708 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-07 22:25:12======================== insert into mBoard_order set rOrdNo = 'Direct-isaac24-1610025708', AuthTy = 'card', memberId = 'isaac24', OrdNm ='임현국', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '이삭홍대', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '현대 949019******8719', rApprNo = 'mjsof2021010722251861122', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 22:25:12', InvoiceNum = '결제성공:Direct-isaac24-1610025708/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 22:25:12' ========================2021-01-07 22:25:12======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010722251861122' 0 = 1 cnt = 1 ========================2021-01-07 22:25:12======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isaac24' 0 = isaac24 Mid = isaac24 1 = 이삭홍대 Mcompany = 이삭홍대 2 = 5584600322 companyNum = 5584600322 3 = 010-2572-3382 Mtel1 = 010-2572-3382 4 = 010-2572-3382 Mhp = 010-2572-3382 ========================2021-01-07 22:25:12======================== select * from customers where id = 'isaac24' ========================2021-01-07 22:25:12======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isaac24','2021-01-07 22:25:12','108000','110000','온라인','0') ========================2021-01-07 22:48:05======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-assacocois-1610027240 LGD_BUYER = 이욱용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20210107224720 LGD_HASHDATA = b52d441e0e661576bb3c63835e1dde6f LGD_RETURNURL = http://mjsoft.co/xpay/returnurl.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 = 20210107224811A474CDC81377A6A14B0994D0CE7ABAB01A455DE6 Mname = 이욱용 Mcompany = 주식회사 아다미 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = assacocois LGD_ESCROW_USEYN = N ========================2021-01-07 22:48:06======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20210107224812 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = DAA6B6 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 451844******6895 LGD_FINANCEAUTHNUM = 25977025 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 884e075dacc34d9a14bc5ab5d955ed6b LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20210107224812 LGD_PCANCELSTR = 0 LGD_BUYER = 이욱용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021010722481260112 LGD_BUYERID = LGD_OID = Direct-assacocois-1610027240 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-01-07 22:48:06======================== insert into mBoard_order set rOrdNo = 'Direct-assacocois-1610027240', AuthTy = 'card', memberId = 'assacocois', OrdNm ='이욱용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 아다미', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '신한VISA 451844******6895', rApprNo = 'mjsof2021010722481260112', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-01-07 22:48:06', InvoiceNum = '결제성공:Direct-assacocois-1610027240/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-01-07 22:48:06' ========================2021-01-07 22:48:06======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021010722481260112' 0 = 1 cnt = 1 ========================2021-01-07 22:48:06======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'assacocois' 0 = assacocois Mid = assacocois 1 = 주식회사 아다미 Mcompany = 주식회사 아다미 2 = 106-81-48882 companyNum = 106-81-48882 3 = 010-9386-4080 Mtel1 = 010-9386-4080 4 = 010-9386-4080 Mhp = 010-9386-4080 ========================2021-01-07 22:48:06======================== select * from customers where id = 'assacocois' ========================2021-01-07 22:48:06======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('assacocois','2021-01-07 22:48:06','220000','220000','온라인','0')