========================2021-10-05 09:08:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dsdb1011-1633392424 LGD_BUYER = 윤경미 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005090704 LGD_HASHDATA = f710146e3da6f664218c770d0e26ce02 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 = 20211005091010632162C848744996BBBB820CF3657836K5RG0LOH Mname = 윤경미 Mcompany = (주)디에스동부대리점 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dsdb1011 LGD_ESCROW_USEYN = N ========================2021-10-05 09:08:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005091011 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 328193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 654132******5962 LGD_FINANCEAUTHNUM = 53550279 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = a8fc31482c8750f0226bf4ff48eb937f LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211005091011 LGD_PCANCELSTR = 0 LGD_BUYER = 윤경미 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021100509101162Cl5 LGD_BUYERID = LGD_OID = Direct-dsdb1011-1633392424 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 50910116tQI4 ========================2021-10-05 09:08:04======================== insert into mBoard_order set rOrdNo = 'Direct-dsdb1011-1633392424', AuthTy = 'card', memberId = 'dsdb1011', OrdNm ='윤경미', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에스동부대리점', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨 654132******5962', rApprNo = 'mjsof2021100509101162Cl5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 09:08:04', InvoiceNum = '결제성공:Direct-dsdb1011-1633392424/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 09:08:04' ========================2021-10-05 09:08:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021100509101162Cl5' 0 = 1 cnt = 1 ========================2021-10-05 09:08:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dsdb1011' 0 = dsdb1011 Mid = dsdb1011 1 = (주)디에스동부대리점 Mcompany = (주)디에스동부대리점 2 = 6458601112 companyNum = 6458601112 3 = 010-4556-6507 Mtel1 = 010-4556-6507 4 = 010-4564-2692 Mhp = 010-4564-2692 ========================2021-10-05 09:08:04======================== select * from customers where id = 'dsdb1011' ========================2021-10-05 09:08:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dsdb1011','2021-10-05 09:08:04','52500','55000','온라인','0') ========================2021-10-05 09:37:49======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1633393968 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005093248 LGD_HASHDATA = 61eb3d5f3c82505b7c14ec911672c346 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 = 202110050939578C9E94B331E94AA3BBA4422034EB0A5ESZZYS1GI 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-10-05 09:37:50======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005093957 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 = 943017******4487 LGD_FINANCEAUTHNUM = 65118023 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = e8b026d03093a8312db8ec5694e8cefa LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20211005093958 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0012 LGD_TID = mjsof202110050939575AbD5 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1633393968 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-10-05 09:37:50======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1633393968', 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******4487', rApprNo = 'mjsof202110050939575AbD5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 09:37:50', InvoiceNum = '결제성공:Direct-goodssal5707-1633393968/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 09:37:50' ========================2021-10-05 09:37:50======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202110050939575AbD5' 0 = 1 cnt = 1 ========================2021-10-05 09:37:50======================== 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-8880-9146 Mhp = 010-8880-9146 ========================2021-10-05 09:37:50======================== select * from customers where id = 'goodssal5707' ========================2021-10-05 09:37:50======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-10-05 09:37:50','220000','220000','온라인','0') ========================2021-10-05 09:38:46======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-goodssal5707-1633394279 LGD_BUYER = 김복인 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005093759 LGD_HASHDATA = e8f0d897a407af87fb4707ef647d4369 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 = 20211005094053F1B9D2DA30C54CA7811D9C06BA8A72C1G2FYGEGP Mname = 김복인 Mcompany = (주)좋은이웃FS post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = goodssal5707 LGD_ESCROW_USEYN = N ========================2021-10-05 09:38:47======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005094056 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 = 943017******4487 LGD_FINANCEAUTHNUM = 65125582 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 91000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = fcd2dda8f23493c7b6d630cab79cc204 LGD_BUYERADDRESS = LGD_FINANCENAME = NH LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20211005094054 LGD_PCANCELSTR = 0 LGD_BUYER = 김복인 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof202110050940545AfZ5 LGD_BUYERID = LGD_OID = Direct-goodssal5707-1633394279 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-10-05 09:38:47======================== insert into mBoard_order set rOrdNo = 'Direct-goodssal5707-1633394279', AuthTy = 'card', memberId = 'goodssal5707', OrdNm ='김복인', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)좋은이웃FS', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = 'NH 943017******4487', rApprNo = 'mjsof202110050940545AfZ5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 09:38:47', InvoiceNum = '결제성공:Direct-goodssal5707-1633394279/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 09:38:47' ========================2021-10-05 09:38:47======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202110050940545AfZ5' 0 = 1 cnt = 1 ========================2021-10-05 09:38:47======================== 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-8880-9146 Mhp = 010-8880-9146 ========================2021-10-05 09:38:47======================== select * from customers where id = 'goodssal5707' ========================2021-10-05 09:38:47======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('goodssal5707','2021-10-05 09:38:47','108000','110000','온라인','0') ========================2021-10-05 10:33:20======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gaonsafety-1633397506 LGD_BUYER = 김현아 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005103146 LGD_HASHDATA = 9b5ffed1f563067d4218ee08b3b25cd3 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 = 202110051035285590E786195842B7A268E6F9DEC62430H31EM1EZ Mname = 김현아 Mcompany = 가온안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = gaonsafety LGD_ESCROW_USEYN = N ========================2021-10-05 10:33:21======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005103528 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = CAC626 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 490298******2769 LGD_FINANCEAUTHNUM = 21466677 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 7f78c95eda3a83d260c1a2592717827a LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20211005103529 LGD_PCANCELSTR = 0 LGD_BUYER = 김현아 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0003 LGD_TID = mjsof2021100510352867BI6 LGD_BUYERID = LGD_OID = Direct-gaonsafety-1633397506 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-10-05 15:39:42======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-mmthcoffee-1633415679 LGD_BUYER = 최경환 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005153439 LGD_HASHDATA = d79a8f2d12ad2599f5369de51992a1ee 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 = 2021100515415069F6DC4F776C4A4294BEDE56FEF002A1YTHKFFOA Mname = 최경환 Mcompany = (주)매머드커피랩 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = mmthcoffee LGD_ESCROW_USEYN = N ========================2021-10-05 15:39:43======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005154150 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 031095 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 943003******7980 LGD_FINANCEAUTHNUM = 56616853 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = cb7a55d824ec0e62273bc2323a3db894 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20211005154151 LGD_PCANCELSTR = 0 LGD_BUYER = 최경환 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021100515415060204 LGD_BUYERID = LGD_OID = Direct-mmthcoffee-1633415679 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 515415060223 ========================2021-10-05 15:39:43======================== insert into mBoard_order set rOrdNo = 'Direct-mmthcoffee-1633415679', AuthTy = 'card', memberId = 'mmthcoffee', OrdNm ='최경환', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)매머드커피랩', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 943003******7980', rApprNo = 'mjsof2021100515415060204', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 15:39:43', InvoiceNum = '결제성공:Direct-mmthcoffee-1633415679/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 15:39:43' ========================2021-10-05 15:39:43======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021100515415060204' 0 = 1 cnt = 1 ========================2021-10-05 15:39:43======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'mmthcoffee' 0 = mmthcoffee Mid = mmthcoffee 1 = (주)매머드커피랩 Mcompany = (주)매머드커피랩 2 = 1058779176 companyNum = 1058779176 3 = 031-794-5086 Mtel1 = 031-794-5086 4 = 010-4595-5086 Mhp = 010-4595-5086 ========================2021-10-05 15:39:43======================== select * from customers where id = 'mmthcoffee' ========================2021-10-05 15:39:43======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('mmthcoffee','2021-10-05 15:39:43','220000','220000','온라인','0') ========================2021-10-05 16:09:01======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-isaac37-1633417666 LGD_BUYER = 정근상 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005160746 LGD_HASHDATA = 8e8f78fd1c66b7e3d1f858d462d0aacc 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 = 20211005161109E656878254F545168AF601C2279F3E67I3RQCYCL Mname = 정근상 Mcompany = 은평 이삭 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = isaac37 LGD_ESCROW_USEYN = N ========================2021-10-05 16:09:02======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005161109 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376ICC LGD_AFFILIATECODE = ****** LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 941010******2900 LGD_FINANCEAUTHNUM = 23721432 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 51000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 587d9f2901f9ccdcc2722c1bdbd06b4a LGD_BUYERADDRESS = LGD_FINANCENAME = 삼성 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 51 LGD_DEVICE = LGD_TIMESTAMP = 20211005161110 LGD_PCANCELSTR = 0 LGD_BUYER = 정근상 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021100516110915099 LGD_BUYERID = LGD_OID = Direct-isaac37-1633417666 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-10-05 16:09:02======================== insert into mBoard_order set rOrdNo = 'Direct-isaac37-1633417666', AuthTy = 'card', memberId = 'isaac37', OrdNm ='정근상', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '은평 이삭', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '삼성 941010******2900', rApprNo = 'mjsof2021100516110915099', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 16:09:02', InvoiceNum = '결제성공:Direct-isaac37-1633417666/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 16:09:02' ========================2021-10-05 16:09:02======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021100516110915099' 0 = 1 cnt = 1 ========================2021-10-05 16:09:02======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'isaac37' 0 = isaac37 Mid = isaac37 1 = 은평 이삭 Mcompany = 은평 이삭 2 = 3212800731 companyNum = 3212800731 3 = 010-9446-9185 Mtel1 = 010-9446-9185 4 = 010-9446-9185 Mhp = 010-9446-9185 ========================2021-10-05 16:09:02======================== select * from customers where id = 'isaac37' ========================2021-10-05 16:09:02======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('isaac37','2021-10-05 16:09:02','220000','220000','온라인','0') ========================2021-10-05 17:14:13======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rkddyd112-1633421581 LGD_BUYER = 강용진 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20211005171301 LGD_HASHDATA = 90d3a081427089de339b339af4630fa9 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 = 202110051716213FD7444B028547AB9636F325B7CA676F0SDNQFR8 Mname = 강용진 Mcompany = 용진농산 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = rkddyd112 LGD_ESCROW_USEYN = N ========================2021-10-05 17:14:14======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20211005171621 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = BBAAZG LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 528638******9489 LGD_FINANCEAUTHNUM = 26964155 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = eabf4e363b1cd1a3cbc341e5c1ad82cb LGD_BUYERADDRESS = LGD_FINANCENAME = 신한MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20211005171622 LGD_PCANCELSTR = 0 LGD_BUYER = 강용진 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof2021100517162115027 LGD_BUYERID = LGD_OID = Direct-rkddyd112-1633421581 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2021-10-05 17:14:14======================== insert into mBoard_order set rOrdNo = 'Direct-rkddyd112-1633421581', AuthTy = 'card', memberId = 'rkddyd112', OrdNm ='강용진', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '용진농산', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한MASTER 528638******9489', rApprNo = 'mjsof2021100517162115027', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2021-10-05 17:14:14', InvoiceNum = '결제성공:Direct-rkddyd112-1633421581/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2021-10-05 17:14:14' ========================2021-10-05 17:14:14======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2021100517162115027' 0 = 1 cnt = 1 ========================2021-10-05 17:14:14======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'rkddyd112' 0 = rkddyd112 Mid = rkddyd112 1 = 용진농산 Mcompany = 용진농산 2 = 2013663311 companyNum = 2013663311 3 = 010-3775-1986 Mtel1 = 010-3775-1986 4 = 010-3775-1986 Mhp = 010-3775-1986 ========================2021-10-05 17:14:14======================== select * from customers where id = 'rkddyd112' ========================2021-10-05 17:14:14======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('rkddyd112','2021-10-05 17:14:14','52500','55000','온라인','0')