📄 service.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/inc/pv/admin.jsp"%>
<%@ include file="/inc/public/msg.jsp"%>
<%
String strId = igec.util.Tool.getStr(request.getParameter("id"));
if(igec.util.Tool.IsEmpty(strId)){
showError("请将需要查看的会员ID传入！",request,response);
return;
}
String strCurMenuName = igec.site.base.business.DataUtilBusiness.getFieldValue("TITLE","TAB_IGECMENU","WHERE ID='" + strMenuId + "'");
String strCurMenuPic = igec.site.base.business.DataUtilBusiness.getFieldValue("SHOWIMG","TAB_IGECMENU","WHERE ID='" + strMenuId + "'");
igec.site.base.bean.ServiceRegObj service = new igec.site.base.bean.ServiceRegObj();
service.setStrMebId(strId);
int iFlag = igec.site.base.business.MemberBusiness.getMemberService(service);
if(iFlag<0){
showError("获取会员的购买服务信息失败，请稍后重试！",request,response);
return;
}
//获取会员的相应信息
String strMebInfo[] = igec.site.base.business.DataUtilBusiness.getValue("SELECT MEBNAME,STARTDATE,ENDDATE,PESTYPE FROM TAB_MEBINFO WHERE ID='" + service.getStrMebId() + "'");
if(strMebInfo==null){
showError("获取会员的相应信息失败！",request,response);
return;
}
%>
<html>
<head>
<title>会员服务信息管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" type="text/css" href="<%=strCssPath%>">
<script language="javascript" src="<%=site.bean.SitePara.strVirtualName%>/js/public.js"></script>
<script language="javascript" src="<%=site.bean.SitePara.strVirtualName%>/js/check.js"></script>
<script language="javascript" src="<%=strSkinBase%>/js/forbid.js"></script>
<script language="javascript">
<!--
function PageCheck(loForm){
return Check(loForm);
}
//-->
</script>
</head>
<body class="bodycolor" topmargin="5" onload="resizeWin('objBody');">
<table border="0" name="objBody" id="objBody" width="600" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form action="<%=site.bean.SitePara.strVirtualName + site.bean.SitePara.strManageFolder%>/member.do?action=service&MebId=<%=service.getStrMebId()%>&iid=<%=strMenuId%>" method="post" name="form1" onsubmit="return PageCheck(this);">
<tr>
<td colspan=4 class="TableHeader"><img src="<%=strSkinBase%>/images/menu/sys/menu.gif" align="absmiddle"> 基本信息</td>
</td>
</tr>
<tr height="30">
<td nowrap class="TableData" width="20%"> 会员帐号：</td>
<td class="TableData">
<a href="javascript:" onclick="javascript:openWindow('../show.jsp?id=<%=service.getStrMebId()%>','450','500');"><span class="big3"><%=strMebInfo[0]%></span></a>
</td>
<td nowrap class="TableData" width="20%"> 会员姓名：</td>
<td class="TableData">
<span class="big3"><%=igec.site.base.business.DataUtilBusiness.getFieldValue("NICKNAME","TAB_IGECMEBADV","WHERE MEBID='"+service.getStrMebId()+"'")%></span>
</td>
</tr>
<tr style="display:none">
<td nowrap class="TableData">有效期(开始)：</td>
<td class="TableData"><span class="big3"><%=igec.util.Tool.getStrTime(strMebInfo[1],1)%></span>
</td>
<td nowrap class="TableData">有效期(结束)：</td>
<td class="TableData"><span class="big3"><%=igec.util.Tool.getStrTime(strMebInfo[2],1)%></span>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 站内短信条数：</td>
<td class="TableData">
<span class="big3"><%=Integer.parseInt(service.getStrBuyNum(),10)%>条</span>
</td>
<td nowrap class="TableData"> 接收短信手机号码：</td>
<td class="TableData">
<span class="big3"><input class="BigInput" value="<%=igec.site.base.business.DataUtilBusiness.getFieldValue("SMSREC","TAB_IGECMEBADV","WHERE MEBID='" + service.getStrMebId() + "'")%>" id="recMobile" name="recMobile" type="text" size="20" maxlength="15" ValueFormat="int" label="短信接收手机"></span>
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan=4><font color="#FF0000">注 </font> 如果已买服务的有效期截止时间大于当前日期，则在有效期之后追加相应的年份；否则，在当天日期基础上追加。</td>
</tr>
<tr>
<td colspan=4 class="TableHeader"><img src="<%=strSkinBase%>/images/menu/sys/menu.gif" align="absmiddle"> 续费参数</td>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 服务续费年数：</td>
<td class="TableData">
<select name="BuyYear" id="BuyYear" EmptyDisable label="购买服务年数"><option value="1">一年</option><option value="2">二年</option><option value="3">三年</option><option value="4">四年</option><option value="5">五年</option></select>
</td>
<td nowrap class="TableData"> 站内短信购买条数：</td>
<td class="TableData">
<select name="BuySmsNum" id="BuySmsNum" EmptyDisable label="站内短信条数"><option value="0">0条</option><option value="1">1000条</option><option value="2">2000条</option><option value="3">3000条</option><option value="4">4000条</option><option value="5">5000条</option></select>
</td>
</tr>
<tr>
<td colspan=4 class="TableHeader"><img src="<%=strSkinBase%>/images/menu/sys/menu.gif" align="absmiddle"> 系统服务 <input type="checkbox" name="ServiceAll" id="ServiceAll" onclick="javascript:checkPageBox(this,'service');"> <label for="ServiceAll">全选</label></td>
</td>
</tr>
<tr height="30">
<td class="TableData" colspan="4" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
String strService[][] = null;
if("0".equals(strMebInfo[3]))//个人会员
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,NAME,MONEY FROM TAB_IGECMEBSEV WHERE FLAG LIKE '1%' AND ID NOT IN ('S00001','S00019','S00020') ORDER BY XH");
else
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,NAME,MONEY FROM TAB_IGECMEBSEV WHERE FLAG LIKE '_1%' AND ID NOT IN ('S00001','S00019','S00020') ORDER BY XH");
String strOrderService = "," + service.getStrService() + ",";
if(strService!=null){
for(int i=0;i<strService.length;){
out.println("<tr align=\"left\">");
for(int n=0;n<3;n++){
if(i<strService.length){
if(strOrderService.indexOf(","+strService[i][0]+",")>=0)
out.println("<td><input type=\"Checkbox\" name=\"service\" value=\"" + strService[i][0] + "\" money=\"" + strService[i][2] + "\" group=\"service\" checked> " + strService[i][1] + "(" + strService[i][2] + "元/年)</td>");
else
out.println("<td><input type=\"Checkbox\" name=\"service\" value=\"" + strService[i][0] + "\" money=\"" + strService[i][2] + "\" group=\"service\"> " + strService[i][1] + "(" + strService[i][2] + "元/年)</td>");
}else{
out.println("<td> </td>");
}
i++;
}
out.println("</tr>");
}
}
%>
</table>
</td>
</tr>
<tr>
<td colspan=4 class="TableHeader"><img src="<%=strSkinBase%>/images/menu/sys/menu.gif" align="absmiddle"> 浏览资讯信息 <input type="checkbox" name="NewsAll" id="NewsAll" onclick="javascript:checkPageBox(this,'news');"> <label for="NewsAll">全选</label></td>
</td>
</tr>
<tr height="30">
<td class="TableData" colspan="4" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
strOrderService = "," + service.getStrNewsType() + ",";
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT PARENTID FROM (SELECT (SELECT COUNT(*) FROM TAB_NEWSTYPE WHERE PARENTID=a.ID AND USEFLAG='1') AS SONNUM,PARENTID FROM TAB_NEWSTYPE a WHERE USEFLAG='1') as t WHERE SONNUM=0 GROUP BY PARENTID ORDER BY PARENTID");
if(strService!=null){
for(int i=0;i<strService.length;i++){
out.println("<tr><td colspan=\"3\" bgcolor=\"rgb(239,248,254)\" align=\"left\"> " + igec.site.base.business.SysUtilBusiness.getStrPath(strService[i][0],"PARENTID","TITLE","TAB_NEWSTYPE") + "</td></tr>");
String strNewsType[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,TITLE,MONEY FROM TAB_NEWSTYPE WHERE PARENTID='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH");
for(int n=0;n<strNewsType.length;){
out.println("<tr align=\"left\">");
for(int t=0;t<3;t++){
if(n<strNewsType.length){
if(strOrderService.indexOf(","+strNewsType[n][0]+",")>=0)
out.println("<td><input type=\"Checkbox\" name=\"newstype\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" group=\"news\" checked> " + strNewsType[n][1] + "(" + strNewsType[n][2] + "元/年)</td>");
else
out.println("<td><input type=\"Checkbox\" name=\"newstype\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" group=\"news\"> " + strNewsType[n][1] + "(" + strNewsType[n][2] + "元/年)</td>");
}else{
out.println("<td> </td>");
}
n++;
}
out.println("</tr>");
}
}
}
%>
</table>
</td>
</tr>
<tr>
<td colspan=4 class="TableHeader"><img src="<%=strSkinBase%>/images/menu/sys/menu.gif" align="absmiddle"> 短信订阅服务 <input type="checkbox" name="SmsAll" id="SmsAll" onclick="javascript:checkPageBox(this,'sms');"> <label for="SmsAll">全选</label></td>
</td>
</tr>
<tr height="30">
<td class="TableData" colspan="4" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
strOrderService = "," + service.getStrSmsType() + ",";
strService = igec.site.base.business.DataUtilBusiness.getValues("SELECT PID FROM (SELECT (SELECT COUNT(*) FROM TAB_IGECSMSINFO WHERE PID=a.ID AND USEFLAG='1') AS SONNUM,PID FROM TAB_IGECSMSINFO a WHERE USEFLAG='1') as t WHERE SONNUM=0 GROUP BY PID ORDER BY PID");
if(strService!=null){
for(int i=0;i<strService.length;i++){
out.println("<tr><td colspan=\"5\" bgcolor=\"rgb(239,248,254)\" align=\"left\"> " + igec.site.base.business.SysUtilBusiness.getStrPath(strService[i][0],"PID","TITLE","TAB_IGECSMSINFO") + "</td></tr>");
String strNewsType[][] = igec.site.base.business.DataUtilBusiness.getValues("SELECT ID,TITLE,COSTMN FROM TAB_IGECSMSINFO WHERE PID='" + strService[i][0] + "' AND USEFLAG='1' ORDER BY XH");
for(int n=0;n<strNewsType.length;){
out.println("<tr align=\"left\">");
for(int t=0;t<3;t++){
if(n<strNewsType.length){
if(strOrderService.indexOf(","+strNewsType[n][0]+",")>=0)
out.println("<td><input type=\"Checkbox\" name=\"sms\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" group=\"sms\" checked> " + strNewsType[n][1] + "(" + strNewsType[n][2] + "元/年)</td>");
else
out.println("<td><input type=\"Checkbox\" name=\"sms\" value=\"" + strNewsType[n][0] + "\" money=\"" + strNewsType[n][2] + "\" group=\"sms\"> " + strNewsType[n][1] + "(" + strNewsType[n][2] + "元/年)</td>");
}else{
out.println("<td> </td>");
}
n++;
}
out.println("</tr>");
}
}
}
%>
</table>
</td>
</tr>
<tr align="center" class="TableControl">
<td colspan="4" nowrap>
<input type="submit" value="服务续费" class="BigButton" title="对会员的购买服务进行续费操作">
<input type="button" value="关 闭" class="BigButton" onClick="javascript:window.close();">
</td>
</tr>
</form>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -