========================2022-06-21 11:11:42======================== 
res_start 
CST_PLATFORM = service 
LGD_WINDOW_TYPE = iframe 
CST_MID = mjsoft007 
LGD_MID = mjsoft007 
LGD_OID = Direct-elthus-1655777427 
LGD_BUYER = 决犁苛 
LGD_PRODUCTINFO = [官肺搬力] 
LGD_AMOUNT = 55000 
LGD_BUYEREMAIL =  
LGD_CUSTOM_SKIN = red 
LGD_CUSTOM_PROCESSTYPE = TWOTR 
LGD_TIMESTAMP = 20220621111027 
LGD_HASHDATA = 11b26d210e63c0acff41f8d097f50035 
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 = 20220621111243807C0FAB91A50EC655D082FDBA657D087BE986C7 
Mname = 决犁苛 
Mcompany = (林)举歹胶萍矩郡 
post1 =  
post2 =  
Madd =  
tel1 =  
tel2 =  
tel3 =  
hp1 =  
hp2 =  
hp3 =  
Memail =  
f_price = 55000 
f_point = 52500 
SendItem =  
UserId = elthus 
LGD_ESCROW_USEYN = N 
========================2022-06-21 11:11:43======================== 
xpay_res 
LGD_BUYERPHONE =  
LGD_PAYDATE = 20220621111244 
LGD_DISCOUNTUSEYN = 0 
LGD_BUYEREMAIL =  
LGD_RECEIVER =  
LGD_DELIVERYINFO =  
LGD_PAYTYPE = SC0010 
LGD_RECEIVERPHONE =  
LGD_EXCHANGERATE = 1.0 
LGD_IFOS = 306C0C 
LGD_AFFILIATECODE = 244581 
LGD_RESPMSG = 搬力己傍 
LGD_2TR_FLAG = Y 
LGD_CARDNUM = 410120******7807 
LGD_FINANCEAUTHNUM = 56080423 
LGD_CARDNOINTEREST_YN = 0 
LGD_ESCROWYN = N 
LGD_TRANSAMOUNT = 55000 
LGD_FINANCECODE = 33100 
LGD_DISCOUNTUSEAMOUNT = 0 
LGD_CARDGUBUN1 = 1 
LGD_CARDGUBUN2 = 0 
LGD_HASHDATA = 7fd63c715ae93e1364d7d952907e35ee 
LGD_BUYERADDRESS =  
LGD_FINANCENAME = 快府VISA 
LGD_CARDNOINTYN = 0 
LGD_CARDACQUIRER = 31 
LGD_DEVICE =  
LGD_TIMESTAMP = 20220621111244 
LGD_PCANCELSTR = 0 
LGD_BUYER = 决犁苛 
LGD_CARDINSTALLMONTH = 00 
LGD_PRODUCTINFO = [官肺搬力] 
LGD_BUYERSSN =  
LGD_PRODUCTCODE =  
LGD_VANCODE = van0017 
LGD_TID = mjsof20220621111244jK6p1 
LGD_BUYERID =  
LGD_OID = Direct-elthus-1655777427 
LGD_RESPCODE = 0000 
LGD_AMOUNT = 55000 
LGD_PCANCELFLAG = 1 
LGD_MID = mjsoft007 
LGD_ISPKEY = 1111244jKGJ3 
========================2022-06-21 11:11:43======================== 
 insert into mBoard_order set
											rOrdNo = 'Direct-elthus-1655777427', AuthTy = 'card', memberId = 'elthus', OrdNm ='决犁苛',
											OrdPhone = '--', OrdPhone2 = '--', UserEmail = '', DlvAddr = '', 
											DlvPost = '', OrdComp = '(林)举歹胶萍矩郡', ProductCode = 'point', rProdNm = '[器牢飘面傈]',
											rProdNm2 = '', rProdNm3 = '', rProdNm4 = '', rAmt = '55000', 
											rSuccYn = 'y', rCardNm = '快府VISA 410120******7807', rApprNo = 'mjsof20220621111244jK6p1', ICHE_OUTBANKNAME = '',
											ICHE_OUTACCTNO = '', ICHE_OUTBANKMASTER = '', ICHE_AMOUNT = '', bank = '',
											Pcnt = 'N', reg_date = '2022-06-21 11:11:43', InvoiceNum = '搬力己傍:Direct-elthus-1655777427/0000', Deliver = '', 
											senditem = '', salestopvalue = '', mod_date = '2022-06-21 11:11:43'
				 
========================2022-06-21 11:11:43======================== 
select count(*) as cnt from mBoard_order where rApprNo = 'mjsof20220621111244jK6p1'  
0 = 1 
cnt = 1 
========================2022-06-21 11:11:43======================== 
 select Mid, Mcompany, companyNum, Mtel1, Mhp from member where Mid = 'elthus' 
0 = elthus 
Mid = elthus 
1 = (林)举歹胶萍矩郡 
Mcompany = (林)举歹胶萍矩郡 
2 = 101-81-44504 
companyNum = 101-81-44504 
3 = 02-2264-8111 
Mtel1 = 02-2264-8111 
4 = 010-9171-7449 
Mhp = 010-9171-7449 
========================2022-06-21 11:11:43======================== 
select * from customers where id = 'elthus' 
========================2022-06-21 11:11:43======================== 
INSERT INTO cash_fill (cust_id, rgst_dtm, addpoint, price, rgster_nm, delkey)
													values ('elthus','2022-06-21 11:11:43','52500','55000','柯扼牢','0')