========================2022-07-04 09:00:31======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-gs7273n-1656892709 LGD_BUYER = 송형림 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704085829 LGD_HASHDATA = d958d1ec66e9830eb26becb0069d1727 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 = 20220704090146910FD27851945F299A340F34CF144DF656104851 Mname = 송형림 Mcompany = 금성전공사 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = gs7273n LGD_ESCROW_USEYN = N ========================2022-07-04 09:00:31======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704090146 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 376C0C LGD_AFFILIATECODE = AFG03J LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94106186****334* LGD_FINANCEAUTHNUM = 29986021 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 312251ad975a8c11bde7c5de232f50fb LGD_BUYERADDRESS = LGD_FINANCENAME = 신한 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220704090147 LGD_PCANCELSTR = 0 LGD_BUYER = 송형림 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof2022070409014660163 LGD_BUYERID = LGD_OID = Direct-gs7273n-1656892709 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 09:00:31======================== insert into mBoard_order set rOrdNo = 'Direct-gs7273n-1656892709', AuthTy = 'card', memberId = 'gs7273n', OrdNm ='송형림', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '금성전공사', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한 94106186****334*', rApprNo = 'mjsof2022070409014660163', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-04 09:00:31', InvoiceNum = '결제성공:Direct-gs7273n-1656892709/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-04 09:00:31' ========================2022-07-04 09:00:32======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof2022070409014660163' 0 = 1 cnt = 1 ========================2022-07-04 09:00:32======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'gs7273n' 0 = gs7273n Mid = gs7273n 1 = 금성전공사 Mcompany = 금성전공사 2 = 7047700201 companyNum = 7047700201 3 = 043-843-7273 Mtel1 = 043-843-7273 4 = 010-4490-1368 Mhp = 010-4490-1368 ========================2022-07-04 09:00:32======================== select * from customers where id = 'gs7273n' ========================2022-07-04 09:00:32======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('gs7273n','2022-07-04 09:00:31','108000','110000','온라인','0') ========================2022-07-04 11:13:41======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-rsnvcx-1656900307 LGD_BUYER = 정영숙 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704110507 LGD_HASHDATA = f7bb9aa5098c75af951fe6e06cb6931d 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 = 20220704111456C1C67A1F280D38FA8603CF2290926D8A7FC7B00F Mname = 정영숙 Mcompany = 목화안전 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = rsnvcx LGD_ESCROW_USEYN = N ========================2022-07-04 11:13:42======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704111457 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 004650 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94104991****805* LGD_FINANCEAUTHNUM = 30053251 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 11000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8357f4f0db8e0991303b98d9cec04754 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20220704111457 LGD_PCANCELSTR = 0 LGD_BUYER = 정영숙 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof2022070411145761252 LGD_BUYERID = LGD_OID = Direct-rsnvcx-1656900307 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 13:47:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yosujmk-1656909986 LGD_BUYER = 정민기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704134626 LGD_HASHDATA = 25e0b1e15186a0f6198b919068df9da1 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 = 2022070413483748ED3EE2509AB27B255ACB698BABBB41DE0C7AB7 Mname = 정민기 Mcompany = 건설발전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yosujmk LGD_ESCROW_USEYN = N ========================2022-07-04 13:47:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704134838 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 = 40921703****801* LGD_FINANCEAUTHNUM = 53482091 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 9ec965952c0ce3f08fad282dc019c66a LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220704134838 LGD_PCANCELSTR = 0 LGD_BUYER = 정민기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202207041348386p8H9 LGD_BUYERID = LGD_OID = Direct-yosujmk-1656909986 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 13:51:43======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-yosujmk-1656910251 LGD_BUYER = 정민기 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704135052 LGD_HASHDATA = 85be473253a5b8bafe35e8cc3abda6bc 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 = 20220704135259DF9F429E8D898A8214300CEC922F6412C48590EF Mname = 정민기 Mcompany = 건설발전기 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = yosujmk LGD_ESCROW_USEYN = N ========================2022-07-04 13:51:44======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704135259 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 = 40921703****801* LGD_FINANCEAUTHNUM = 53528291 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 91100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 4618b19066e4da9a5908e097835874cf LGD_BUYERADDRESS = LGD_FINANCENAME = NH VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 91 LGD_DEVICE = LGD_TIMESTAMP = 20220704135300 LGD_PCANCELSTR = 0 LGD_BUYER = 정민기 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202207041352595hoq2 LGD_BUYERID = LGD_OID = Direct-yosujmk-1656910251 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 16:12:03======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-hiki187-1656918636 LGD_BUYER = 박승완 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704161036 LGD_HASHDATA = 85454f33beea5c4ed8699e7d3ee6a5ca 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 = 202207041613197EBD4150B1775251DFCC38A94A5881BBC6E1B3B2 Mname = 박승완 Mcompany = 주식회사 하이키 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = hiki187 LGD_ESCROW_USEYN = N ========================2022-07-04 16:12:04======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704161319 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = DAA67I LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 45184445****116* LGD_FINANCEAUTHNUM = 35652652 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 41100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = b64929fbb65cebcb9aa339a490f03be4 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20220704161320 LGD_PCANCELSTR = 0 LGD_BUYER = 박승완 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202207041613195tzI0 LGD_BUYERID = LGD_OID = Direct-hiki187-1656918636 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 16:12:04======================== insert into mBoard_order set rOrdNo = 'Direct-hiki187-1656918636', AuthTy = 'card', memberId = 'hiki187', OrdNm ='박승완', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 하이키', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '신한VISA 45184445****116*', rApprNo = 'mjsof202207041613195tzI0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-04 16:12:04', InvoiceNum = '결제성공:Direct-hiki187-1656918636/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-04 16:12:04' ========================2022-07-04 16:12:04======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202207041613195tzI0' 0 = 1 cnt = 1 ========================2022-07-04 16:12:04======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'hiki187' 0 = hiki187 Mid = hiki187 1 = 주식회사 하이키 Mcompany = 주식회사 하이키 2 = 1148639017 companyNum = 1148639017 3 = 02-3477-1129 Mtel1 = 02-3477-1129 4 = 010-5423-0269 Mhp = 010-5423-0269 ========================2022-07-04 16:12:04======================== select * from customers where id = 'hiki187' ========================2022-07-04 16:12:04======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('hiki187','2022-07-04 16:12:04','108000','110000','온라인','0') ========================2022-07-04 16:21:52======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-potatogom-1656919248 LGD_BUYER = 권준형 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 33000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704162048 LGD_HASHDATA = 3d34ff925d13684cbd47015de9fc4697 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 = 202207041623076CAACABFAA25CB17A4A690A8703586B64FEAF413 Mname = 권준형 Mcompany = 로스팅 포테이토 컴퍼니 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 33000 f_point = 30900 SendItem = UserId = potatogom LGD_ESCROW_USEYN = N ========================2022-07-04 16:21:52======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704162308 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 = 43302888****430* LGD_FINANCEAUTHNUM = 00995363 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 33000 LGD_FINANCECODE = 61100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 8f4c7e07013991fadb5a2d57fe0ca295 LGD_BUYERADDRESS = LGD_FINANCENAME = 현대VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 61 LGD_DEVICE = LGD_TIMESTAMP = 20220704162308 LGD_PCANCELSTR = 0 LGD_BUYER = 권준형 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0001 LGD_TID = mjsof202207041623080tBr7 LGD_BUYERID = LGD_OID = Direct-potatogom-1656919248 LGD_RESPCODE = 0000 LGD_AMOUNT = 33000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2022-07-04 16:21:52======================== insert into mBoard_order set rOrdNo = 'Direct-potatogom-1656919248', AuthTy = 'card', memberId = 'potatogom', OrdNm ='권준형', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '로스팅 포테이토 컴퍼니', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '33000', rSuccYn = 'y', rCardNm = '현대VISA 43302888****430*', rApprNo = 'mjsof202207041623080tBr7', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-04 16:21:52', InvoiceNum = '결제성공:Direct-potatogom-1656919248/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-04 16:21:52' ========================2022-07-04 16:21:52======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202207041623080tBr7' 0 = 1 cnt = 1 ========================2022-07-04 16:21:52======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'potatogom' 0 = potatogom Mid = potatogom 1 = 로스팅 포테이토 컴퍼니 Mcompany = 로스팅 포테이토 컴퍼니 2 = 1943700558 companyNum = 1943700558 3 = 010-2225-2252 Mtel1 = 010-2225-2252 4 = 010-2225-2252 Mhp = 010-2225-2252 ========================2022-07-04 16:21:52======================== select * from customers where id = 'potatogom' ========================2022-07-04 16:21:52======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('potatogom','2022-07-04 16:21:52','30900','33000','온라인','0') ========================2022-07-04 17:32:07======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-foodmall-1656923474 LGD_BUYER = 문시연 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 110000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20220704173114 LGD_HASHDATA = ca6cdb382e6909f96ad1336f31cc148c 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 = 202207041733236D7765BF8084DB99649E731F93C8A9E41C89FEF2 Mname = 문시연 Mcompany = (주)다다통상 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 110000 f_point = 108000 SendItem = UserId = foodmall LGD_ESCROW_USEYN = N ========================2022-07-04 17:32:08======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20220704173323 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = dada737@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 306C0C LGD_AFFILIATECODE = 756419 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41710305****396* LGD_FINANCEAUTHNUM = 46996618 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 110000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 659e909d713dfba51f3c2f2e36ed7fe3 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20220704173324 LGD_PCANCELSTR = 0 LGD_BUYER = 문시연 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20220704173323UV7h9 LGD_BUYERID = LGD_OID = Direct-foodmall-1656923474 LGD_RESPCODE = 0000 LGD_AMOUNT = 110000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 4173323U7ks6 ========================2022-07-04 17:32:08======================== insert into mBoard_order set rOrdNo = 'Direct-foodmall-1656923474', AuthTy = 'card', memberId = 'foodmall', OrdNm ='문시연', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)다다통상', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '110000', rSuccYn = 'y', rCardNm = '비씨VISA 41710305****396*', rApprNo = 'mjsof20220704173323UV7h9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2022-07-04 17:32:08', InvoiceNum = '결제성공:Direct-foodmall-1656923474/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2022-07-04 17:32:08' ========================2022-07-04 17:32:08======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220704173323UV7h9' 0 = 1 cnt = 1 ========================2022-07-04 17:32:08======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'foodmall' 0 = foodmall Mid = foodmall 1 = (주)다다통상 Mcompany = (주)다다통상 2 = 6058601749 companyNum = 6058601749 3 = 051-701-1901 Mtel1 = 051-701-1901 4 = 010-2985-5344 Mhp = 010-2985-5344 ========================2022-07-04 17:32:08======================== select * from customers where id = 'foodmall' ========================2022-07-04 17:32:08======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('foodmall','2022-07-04 17:32:08','108000','110000','온라인','0')