========================2022-04-05 08:51:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-giai2160-1649116252 LGD_BUYER = 정병준 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220405085052 LGD_HASHDATA = 7840e6ce5936f35d8c73985e229be080 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 = 202204050857096CC7D3E115534DC082B4D4928366F51EILPUTQCX Mname = 정병준 Mcompany = 북하특품사업단(주) post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = giai2160 LGD_ESCROW_USEYN = N ========================2022-04-05 08:51:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220405085709 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 171272 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 553211******4658 LGD_FINANCEAUTHNUM = 59453026 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 20cf4d5680f5f71629544b6e6605257d LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220405085710 LGD_PCANCELSTR = 0 LGD_BUYER = 정병준 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220405085709nQuX7 LGD_BUYERID = LGD_OID = Direct-giai2160-1649116252 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 5085709nA764 ========================2022-04-05 08:51:43======================== insert into mBoard_order set rOrdNo = 'Direct-giai2160-1649116252', AuthTy = 'card', memberId = 'giai2160', OrdNm ='정병준', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '북하특품사업단(주)', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨MASTER 553211******4658', rApprNo = 'mjsof20220405085709nQuX7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-05 08:51:43', InvoiceNum = '결제성공:Direct-giai2160-1649116252/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-05 08:51:43' ========================2022-04-05 08:51:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220405085709nQuX7' 0 = 1 cnt = 1 ========================2022-04-05 08:51:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'giai2160' 0 = giai2160 Mid = giai2160 1 = 북하특품사업단(주) Mcompany = 북하특품사업단(주) 2 = 409-86-01971 companyNum = 409-86-01971 3 = 011-9048-2160 Mtel1 = 011-9048-2160 4 = 011-9048-2160 Mhp = 011-9048-2160 ========================2022-04-05 08:51:43======================== select * from customers where id = 'giai2160' ========================2022-04-05 08:51:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('giai2160','2022-04-05 08:51:43','52500','55000','온라인','0') ========================2022-04-05 13:42:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-wmhyair-1649133493 LGD_BUYER = 김성용 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220405133813 LGD_HASHDATA = fdf6d14d8a1c846f2548c56522ae43c1 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 = 202204051348131E42DB675CF249B2A3ACD3259E05B87CWRQV7VTC Mname = 김성용 Mcompany = 우민전기유공압 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = wmhyair LGD_ESCROW_USEYN = N ========================2022-04-05 13:42:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220405134814 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = woomincorp@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 739025 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 910003******1261 LGD_FINANCEAUTHNUM = 61506934 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 66ee9ab1b117178cf8a8b173ae15dea8 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220405134814 LGD_PCANCELSTR = 0 LGD_BUYER = 김성용 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022040513481315255 LGD_BUYERID = LGD_OID = Direct-wmhyair-1649133493 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 513481315233 ========================2022-04-05 13:42:47======================== insert into mBoard_order set rOrdNo = 'Direct-wmhyair-1649133493', AuthTy = 'card', memberId = 'wmhyair', OrdNm ='김성용', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '우민전기유공압', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 910003******1261', rApprNo = 'mjsof2022040513481315255', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-05 13:42:47', InvoiceNum = '결제성공:Direct-wmhyair-1649133493/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-05 13:42:47' ========================2022-04-05 13:42:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022040513481315255' 0 = 1 cnt = 1 ========================2022-04-05 13:42:47======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'wmhyair' 0 = wmhyair Mid = wmhyair 1 = 우민전기유공압 Mcompany = 우민전기유공압 2 = 609-07-96108 companyNum = 609-07-96108 3 = 051-831-2345 Mtel1 = 051-831-2345 4 = 011-559-0179 Mhp = 011-559-0179 ========================2022-04-05 13:42:47======================== select * from customers where id = 'wmhyair' ========================2022-04-05 13:42:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('wmhyair','2022-04-05 13:42:47','220000','220000','온라인','0') ========================2022-04-05 14:36:32======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-neotool-1649136951 LGD_BUYER = 김동섭 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220405143551 LGD_HASHDATA = 6fc6616630c42b8a46f793e5dcfa2ccd 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 = 2022040514415970E0DF0AEFD64A31AE17073221D787E46UOKQZSF Mname = 김동섭 Mcompany = (주)네오툴 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = neotool LGD_ESCROW_USEYN = N ========================2022-04-05 14:36:33======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220405144200 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306ICC LGD_AFFILIATECODE = 755339 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 625003******2941 LGD_FINANCEAUTHNUM = 62011073 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = db8c8edffeb840552d317930245e0f30 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220405144200 LGD_PCANCELSTR = 0 LGD_BUYER = 김동섭 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022040514415915112 LGD_BUYERID = LGD_OID = Direct-neotool-1649136951 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 514415915133 ========================2022-04-05 14:36:33======================== insert into mBoard_order set rOrdNo = 'Direct-neotool-1649136951', AuthTy = 'card', memberId = 'neotool', OrdNm ='김동섭', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)네오툴', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨 625003******2941', rApprNo = 'mjsof2022040514415915112', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-05 14:36:33', InvoiceNum = '결제성공:Direct-neotool-1649136951/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-05 14:36:33' ========================2022-04-05 14:36:33======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022040514415915112' 0 = 1 cnt = 1 ========================2022-04-05 14:36:33======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'neotool' 0 = neotool Mid = neotool 1 = (주)네오툴 Mcompany = (주)네오툴 2 = 1138686104 companyNum = 1138686104 3 = 02-1644-0946 Mtel1 = 02-1644-0946 4 = 010-5306-7049 Mhp = 010-5306-7049 ========================2022-04-05 14:36:33======================== select * from customers where id = 'neotool' ========================2022-04-05 14:36:33======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('neotool','2022-04-05 14:36:33','108000','110000','온라인','0') ========================2022-04-05 16:42:34======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-woorimart-1649144466 LGD_BUYER = 유봉천 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220405164106 LGD_HASHDATA = 08e3406ec4805c5f286ffcf8c0039df7 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 = 20220405164759B850CFFA689B49D2AFBEFE657FC55B47OWRMQYWC Mname = 유봉천 Mcompany = (주)우리유통식자재 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = woorimart LGD_ESCROW_USEYN = N ========================2022-04-05 16:42:35======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220405164802 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 414011******2040 LGD_FINANCEAUTHNUM = 62819505 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c0d9dfb45de2fb3b105149409923a38b LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220405164802 LGD_PCANCELSTR = 0 LGD_BUYER = 유봉천 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022040516480114175 LGD_BUYERID = LGD_OID = Direct-woorimart-1649144466 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 516480114179 ========================2022-04-05 16:42:35======================== insert into mBoard_order set rOrdNo = 'Direct-woorimart-1649144466', AuthTy = 'card', memberId = 'woorimart', OrdNm ='유봉천', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)우리유통식자재', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨VISA 414011******2040', rApprNo = 'mjsof2022040516480114175', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-05 16:42:35', InvoiceNum = '결제성공:Direct-woorimart-1649144466/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-05 16:42:35' ========================2022-04-05 16:42:35======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022040516480114175' 0 = 1 cnt = 1 ========================2022-04-05 16:42:35======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'woorimart' 0 = woorimart Mid = woorimart 1 = (주)우리유통식자재 Mcompany = (주)우리유통식자재 2 = 609-85-27254 companyNum = 609-85-27254 3 = 055-541-6100 Mtel1 = 055-541-6100 4 = 016-594-7327 Mhp = 016-594-7327 ========================2022-04-05 16:42:35======================== select * from customers where id = 'woorimart' ========================2022-04-05 16:42:35======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('woorimart','2022-04-05 16:42:35','220000','220000','온라인','0') ========================2022-04-05 18:20:15======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-pjw1439-1649150264 LGD_BUYER = 박흥수 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220405181744 LGD_HASHDATA = 4a3bdbb505f224b77f9dabb1521e8734 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 = 2022040518254290DE48776D224F94BDD9E918EDA0B8DF57KJJA3B Mname = 박흥수 Mcompany = (주)모닝에프디 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = pjw1439 LGD_ESCROW_USEYN = N ========================2022-04-05 18:20:15======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220405182542 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 = 428909******2023 LGD_FINANCEAUTHNUM = 42774009 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 21100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ab8cf19b9a1c31c9f7242fc396318f43 LGD_BUYERADDRESS = LGD_FINANCENAME = 외환VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 21 LGD_DEVICE = LGD_TIMESTAMP = 20220405182543 LGD_PCANCELSTR = 0 LGD_BUYER = 박흥수 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2022040518254260059 LGD_BUYERID = LGD_OID = Direct-pjw1439-1649150264 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-04-05 18:20:15======================== insert into mBoard_order set rOrdNo = 'Direct-pjw1439-1649150264', AuthTy = 'card', memberId = 'pjw1439', OrdNm ='박흥수', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)모닝에프디', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '외환VISA 428909******2023', rApprNo = 'mjsof2022040518254260059', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-04-05 18:20:15', InvoiceNum = '결제성공:Direct-pjw1439-1649150264/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-04-05 18:20:15' ========================2022-04-05 18:20:15======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022040518254260059' 0 = 1 cnt = 1 ========================2022-04-05 18:20:15======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'pjw1439' 0 = pjw1439 Mid = pjw1439 1 = (주)모닝에프디 Mcompany = (주)모닝에프디 2 = 4328800262 companyNum = 4328800262 3 = 010-4820-4572 Mtel1 = 010-4820-4572 4 = 010-2545-9942 Mhp = 010-2545-9942 ========================2022-04-05 18:20:15======================== select * from customers where id = 'pjw1439' ========================2022-04-05 18:20:15======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('pjw1439','2022-04-05 18:20:15','10000','11000','온라인','0')