========================2023-12-06 09:23:11======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-dhhousing1-1701822160 LGD_BUYER = 서태화 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206092240 LGD_HASHDATA = 3bd1387ac7a09b2be7c223344f57ae7b LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 202312060926406FC8C1B9BBA1C2CAF89728BB85F13BBE9962DD6E Mname = 서태화 Mcompany = (주)디에이치하우징 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = dhhousing1 LGD_ESCROW_USEYN = N ========================2023-12-06 09:23:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206092641 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 756406 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41400307****698* LGD_FINANCEAUTHNUM = 67906338 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 31100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 312952ba4657be53d56a871495d0cd55 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231206092642 LGD_PCANCELSTR = 0 LGD_BUYER = 서태화 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231206092641xrg99 LGD_BUYERID = LGD_OID = Direct-dhhousing1-1701822160 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6092641x8A93 ========================2023-12-06 09:23:13======================== insert into mBoard_order set rOrdNo = 'Direct-dhhousing1-1701822160', AuthTy = 'card', memberId = 'dhhousing1', OrdNm ='서태화', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)디에이치하우징', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '비씨VISA 41400307****698*', rApprNo = 'mjsof20231206092641xrg99', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 09:23:13', InvoiceNum = '결제성공:Direct-dhhousing1-1701822160/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 09:23:13' ========================2023-12-06 09:23:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231206092641xrg99' 0 = 1 cnt = 1 ========================2023-12-06 09:23:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'dhhousing1' 0 = dhhousing1 Mid = dhhousing1 1 = (주)디에이치하우징 Mcompany = (주)디에이치하우징 2 = 1358186545 companyNum = 1358186545 3 = 031-695-5977 Mtel1 = 031-695-5977 4 = 010-5115-1221 Mhp = 010-5115-1221 ========================2023-12-06 09:23:13======================== select * from customers where id = 'dhhousing1' ========================2023-12-06 09:23:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('dhhousing1','2023-12-06 09:23:13','52500','55000','온라인','0') ========================2023-12-06 11:08:22======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-haigadun-1701828413 LGD_BUYER = 정동규 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206110653 LGD_HASHDATA = 633d999430bc743e1a4e7597fc8573ee LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023120611115212D46790D282F85D5F6D63E24884D0813B8592C4 Mname = 정동규 Mcompany = 주식회사 해가든 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = haigadun LGD_ESCROW_USEYN = N ========================2023-12-06 11:08:23======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206111152 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = sunrice10@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 739012 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 94300307****693* LGD_FINANCEAUTHNUM = 68585591 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 31000 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 0 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = ea92075b7728be9fbf1a49fc1e023c22 LGD_BUYERADDRESS = LGD_FINANCENAME = 비씨 LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231206111153 LGD_PCANCELSTR = 0 LGD_BUYER = 정동규 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231206111152vGHz9 LGD_BUYERID = LGD_OID = Direct-haigadun-1701828413 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6111152vkrQ6 ========================2023-12-06 11:08:23======================== insert into mBoard_order set rOrdNo = 'Direct-haigadun-1701828413', AuthTy = 'card', memberId = 'haigadun', OrdNm ='정동규', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 해가든', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '비씨 94300307****693*', rApprNo = 'mjsof20231206111152vGHz9', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 11:08:23', InvoiceNum = '결제성공:Direct-haigadun-1701828413/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 11:08:23' ========================2023-12-06 11:08:23======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231206111152vGHz9' 0 = 1 cnt = 1 ========================2023-12-06 11:08:23======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'haigadun' 0 = haigadun Mid = haigadun 1 = 주식회사 해가든 Mcompany = 주식회사 해가든 2 = 126-86-36411 companyNum = 126-86-36411 3 = 02-429-0103 Mtel1 = 02-429-0103 4 = 010-3742-4164 Mhp = 010-3742-4164 ========================2023-12-06 11:08:23======================== select * from customers where id = 'haigadun' ========================2023-12-06 11:08:23======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('haigadun','2023-12-06 11:08:23','220000','220000','온라인','0') ========================2023-12-06 11:45:28======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-meetinggod1-1701830650 LGD_BUYER = 김희승 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206114410 LGD_HASHDATA = 0fa578461becdc0f8acc88dac8601aed LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20231206114857BD20969AC34F847E3E11ADF2E5977BE86C91E9CF Mname = 김희승 Mcompany = (주)세미나인터내셔널 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = meetinggod1 LGD_ESCROW_USEYN = N ========================2023-12-06 11:45:28======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206114858 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003191 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 42658692****282* LGD_FINANCEAUTHNUM = 30016027 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 11100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 35b842f33d713f85c41e7e76276207c3 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231206114858 LGD_PCANCELSTR = 0 LGD_BUYER = 김희승 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231206114857zkmb5 LGD_BUYERID = LGD_OID = Direct-meetinggod1-1701830650 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6114857z4ys2 ========================2023-12-06 11:45:28======================== insert into mBoard_order set rOrdNo = 'Direct-meetinggod1-1701830650', AuthTy = 'card', memberId = 'meetinggod1', OrdNm ='김희승', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)세미나인터내셔널', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '국민VISA 42658692****282*', rApprNo = 'mjsof20231206114857zkmb5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 11:45:28', InvoiceNum = '결제성공:Direct-meetinggod1-1701830650/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 11:45:28' ========================2023-12-06 11:45:29======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231206114857zkmb5' 0 = 1 cnt = 1 ========================2023-12-06 11:45:29======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'meetinggod1' 0 = meetinggod1 Mid = meetinggod1 1 = (주)세미나인터내셔널 Mcompany = (주)세미나인터내셔널 2 = 5038700626 companyNum = 5038700626 3 = 032-674-4968 Mtel1 = 032-674-4968 4 = 010-7359-4968 Mhp = 010-7359-4968 ========================2023-12-06 11:45:29======================== select * from customers where id = 'meetinggod1' ========================2023-12-06 11:45:29======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('meetinggod1','2023-12-06 11:45:28','220000','220000','온라인','0') ========================2023-12-06 12:07:45======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-superman01-1701831897 LGD_BUYER = 남수성 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 55000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206120457 LGD_HASHDATA = 7bb8006fd896b31321fda928d52eff79 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 20231206121114AE788AE58601FD4D5D1DCED3B15EA3F2A3905962 Mname = 남수성 Mcompany = 에스유통 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 55000 f_point = 52500 SendItem = UserId = superman01 LGD_ESCROW_USEYN = N ========================2023-12-06 12:07:45======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206121114 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = hhkk812@naver.com LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = DAA6AC LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 37798508****03* LGD_FINANCEAUTHNUM = 28264523 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 55000 LGD_FINANCECODE = 41400 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = c138231ce73b2e0c10cf3a063cb3b395 LGD_BUYERADDRESS = LGD_FINANCENAME = 신한AMEX LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 41 LGD_DEVICE = LGD_TIMESTAMP = 20231206121115 LGD_PCANCELSTR = 0 LGD_BUYER = 남수성 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231206121114yWUl5 LGD_BUYERID = LGD_OID = Direct-superman01-1701831897 LGD_RESPCODE = 0000 LGD_AMOUNT = 55000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-06 12:07:45======================== insert into mBoard_order set rOrdNo = 'Direct-superman01-1701831897', AuthTy = 'card', memberId = 'superman01', OrdNm ='남수성', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '에스유통', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', rSuccYn = 'y', rCardNm = '신한AMEX 37798508****03*', rApprNo = 'mjsof20231206121114yWUl5', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 12:07:45', InvoiceNum = '결제성공:Direct-superman01-1701831897/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 12:07:45' ========================2023-12-06 12:07:46======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231206121114yWUl5' 0 = 1 cnt = 1 ========================2023-12-06 12:07:46======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'superman01' 0 = superman01 Mid = superman01 1 = 에스유통 Mcompany = 에스유통 2 = 5178602892 companyNum = 5178602892 3 = 010-8774-2123 Mtel1 = 010-8774-2123 4 = 010-8774-2123 Mhp = 010-8774-2123 ========================2023-12-06 12:07:46======================== select * from customers where id = 'superman01' ========================2023-12-06 12:07:46======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('superman01','2023-12-06 12:07:45','52500','55000','온라인','0') ========================2023-12-06 15:01:12======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-ltweenn-1701842366 LGD_BUYER = (주)벨벳 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 220000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206145926 LGD_HASHDATA = 90c11048ffc9147cbe874190ead55a61 LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023120615044159B3F1F021404A38F13D4DB88A4F1BCD34E68DDC Mname = (주)벨벳 Mcompany = (주)벨벳 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 220000 f_point = 220000 SendItem = UserId = ltweenn LGD_ESCROW_USEYN = N ========================2023-12-06 15:01:13======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206150442 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 620105 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 41012020****445* LGD_FINANCEAUTHNUM = 31660460 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 220000 LGD_FINANCECODE = 33100 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 309036b35119d7af60212e10660d1aae LGD_BUYERADDRESS = LGD_FINANCENAME = 우리비씨VISA LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 31 LGD_DEVICE = LGD_TIMESTAMP = 20231206150442 LGD_PCANCELSTR = 0 LGD_BUYER = (주)벨벳 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof20231206150442zJUy6 LGD_BUYERID = LGD_OID = Direct-ltweenn-1701842366 LGD_RESPCODE = 0000 LGD_AMOUNT = 220000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 LGD_ISPKEY = 6150442zdT79 ========================2023-12-06 15:01:13======================== insert into mBoard_order set rOrdNo = 'Direct-ltweenn-1701842366', AuthTy = 'card', memberId = 'ltweenn', OrdNm ='(주)벨벳', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '(주)벨벳', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '220000', rSuccYn = 'y', rCardNm = '우리비씨VISA 41012020****445*', rApprNo = 'mjsof20231206150442zJUy6', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 15:01:13', InvoiceNum = '결제성공:Direct-ltweenn-1701842366/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 15:01:13' ========================2023-12-06 15:01:13======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20231206150442zJUy6' 0 = 1 cnt = 1 ========================2023-12-06 15:01:13======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'ltweenn' 0 = ltweenn Mid = ltweenn 1 = (주)벨벳 Mcompany = (주)벨벳 2 = 2128600475 companyNum = 2128600475 3 = 02-478-1440 Mtel1 = 02-478-1440 4 = 010-2743-1484 Mhp = 010-2743-1484 ========================2023-12-06 15:01:13======================== select * from customers where id = 'ltweenn' ========================2023-12-06 15:01:13======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('ltweenn','2023-12-06 15:01:13','220000','220000','온라인','0') ========================2023-12-06 16:31:10======================== res_start CST_PLATFORM = service LGD_WINDOW_TYPE = iframe CST_MID = mjsoft007 LGD_MID = mjsoft007 LGD_OID = Direct-byronbay-1701847798 LGD_BUYER = 이정신 LGD_PRODUCTINFO = [바로결제] LGD_AMOUNT = 11000 LGD_BUYEREMAIL = LGD_CUSTOM_SKIN = red LGD_CUSTOM_PROCESSTYPE = TWOTR LGD_TIMESTAMP = 20231206162958 LGD_HASHDATA = 0f5762832ae6386e8c1a30c1b4993a8a LGD_RETURNURL = https://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 = https://mjsoft.co/html/millennium/Order_point_Process_new_noteurl.php LGD_RESPCODE = LGD_RESPMSG = LGD_PAYKEY = 2023120616343956183E464A06EE41ECDD2B690359333C3BEA73CD Mname = 이정신 Mcompany = 주식회사 코러스코리아 post1 = post2 = Madd = tel1 = tel2 = tel3 = hp1 = hp2 = hp3 = Memail = f_price = 11000 f_point = 10000 SendItem = UserId = byronbay LGD_ESCROW_USEYN = N ========================2023-12-06 16:31:11======================== xpay_res LGD_BUYERPHONE = LGD_PAYDATE = 20231206163440 LGD_DISCOUNTUSEYN = 0 LGD_BUYEREMAIL = LGD_RECEIVER = LGD_DELIVERYINFO = LGD_PAYTYPE = SC0010 LGD_RECEIVERPHONE = LGD_EXCHANGERATE = 1.0 LGD_IFOS = 406C0C LGD_AFFILIATECODE = 003193 LGD_RESPMSG = 결제성공 LGD_2TR_FLAG = Y LGD_CARDNUM = 55852666****403* LGD_FINANCEAUTHNUM = 30029724 LGD_CARDNOINTEREST_YN = 0 LGD_ESCROWYN = N LGD_TRANSAMOUNT = 11000 LGD_FINANCECODE = 11200 LGD_DISCOUNTUSEAMOUNT = 0 LGD_CARDGUBUN1 = 1 LGD_CARDGUBUN2 = 0 LGD_HASHDATA = 65a0580b20c97054e541c1a875552499 LGD_BUYERADDRESS = LGD_FINANCENAME = 국민MASTER LGD_CARDNOINTYN = 0 LGD_CARDACQUIRER = 11 LGD_DEVICE = LGD_TIMESTAMP = 20231206163440 LGD_PCANCELSTR = 0 LGD_BUYER = 이정신 LGD_CARDINSTALLMONTH = 00 LGD_PRODUCTINFO = [바로결제] LGD_BUYERSSN = LGD_PRODUCTCODE = LGD_VANCODE = van0017 LGD_TID = mjsof202312061634407WNY0 LGD_BUYERID = LGD_OID = Direct-byronbay-1701847798 LGD_RESPCODE = 0000 LGD_AMOUNT = 11000 LGD_PCANCELFLAG = 1 LGD_MID = mjsoft007 ========================2023-12-06 16:31:11======================== insert into mBoard_order set rOrdNo = 'Direct-byronbay-1701847798', AuthTy = 'card', memberId = 'byronbay', OrdNm ='이정신', OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', DlvPost = '', OrdComp = '주식회사 코러스코리아', ProductCode = 'point', rProdNm = '[포인트충전]', rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '11000', rSuccYn = 'y', rCardNm = '국민MASTER 55852666****403*', rApprNo = 'mjsof202312061634407WNY0', ICHE_OUTBANKNAME = '', ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '', Pcnt = 'N', reg_date = '2023-12-06 16:31:11', InvoiceNum = '결제성공:Direct-byronbay-1701847798/0000', Deliver = '', senditem = '', salestopvalue = '', mod_date = '2023-12-06 16:31:11' ========================2023-12-06 16:31:11======================== select count(*) as cnt from mBoard_order where rApprNo = 'mjsof202312061634407WNY0' 0 = 1 cnt = 1 ========================2023-12-06 16:31:11======================== select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'byronbay' 0 = byronbay Mid = byronbay 1 = 주식회사 코러스코리아 Mcompany = 주식회사 코러스코리아 2 = 578-87-01667 companyNum = 578-87-01667 3 = 070-8863-4055 Mtel1 = 070-8863-4055 4 = 010-8201-0008 Mhp = 010-8201-0008 ========================2023-12-06 16:31:11======================== select * from customers where id = 'byronbay' ========================2023-12-06 16:31:11======================== INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey) values ('byronbay','2023-12-06 16:31:11','10000','11000','온라인','0')