📄 crm_project_report.jsp
字号:
<%@ include file="../../include/configuration.jsp"%>
<%@ include file="../../include/authorizemanager.jsp"%>
<%@ page import="com.vere.crm.customer.bean.*"%>
<%@ page import="com.vere.crm.customer.item.*"%>
<%@ page import="com.vere.crm.project.bean.*"%>
<%@ page import="com.vere.crm.project.item.*"%>
<%@ page contentType="text/html; charset=gb2312" %>
<%
ParameterUtils.setCharacterEncoding(request);
SessionFactory sessionFactory=(SessionFactory)session.getAttribute("sessionFactory");
String crm_project_info_id=ParameterUtils.getString(request,"crm_project_info_id");
if(!crm_project_info_id.equals(""))
{
sessionFactory.setCrm_project_info_id(crm_project_info_id);
session.setAttribute("sessionFactory",sessionFactory);
}
String status=ParameterUtils.getString(request,"status");
//删除
if(status.equals("remove"))
{
Crm_project_reportItem item=new Crm_project_reportItem();
item.setId(ParameterUtils.getString(request,"id"));
Crm_project_reportBean bean=new Crm_project_reportBean();
boolean b=bean.removeItem(item);
}
//删除全部选择的
if(status.equals("removeSelect"))
{
String ids=ParameterUtils.getString(request,"ids");
Crm_project_reportBean bean=new Crm_project_reportBean();
String[] idArray=ids.split(",");
boolean b=bean.removeItems(idArray);
}
int pageNo=ParameterUtils.getInt(request,"page");
if(pageNo<=0)
{
pageNo=1;
}
Crm_project_reportItem item=new Crm_project_reportItem();
String crm_customer_id=ParameterUtils.getString(request,"crm_customer_id");//客户名称
String crm_customer_contact_id=ParameterUtils.getString(request,"crm_customer_contact_id");//联系人名称
String report_date=ParameterUtils.getString(request,"report_date");//报告日期
String report_people=ParameterUtils.getString(request,"report_people");//报告人
item.setCrm_project_info_id(crm_project_info_id);
item.setCrm_customer_id(crm_customer_id);
item.setCrm_customer_contact_id(crm_customer_contact_id);
item.setReport_date(report_date);
item.setReport_people(report_people);
Crm_project_reportBean bean=new Crm_project_reportBean();
List list=bean.find(item,pageNo,pageSize);
int totalRecord=bean.getTotalRecord();
int page_num=(int)Math.ceil((double)totalRecord/pageSize);
%>
<html>
<head>
<title><%=titleName%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/css.css" rel="stylesheet" type="text/css">
<script language="javascript" src="../../js/check.js"></script>
<link href="../../css/date.css" rel="stylesheet" type="text/css">
<script src="../../js/ShowDate.js"></script>
<script language="javascript">
init();
</script>
</head>
<body>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" class="firsttable">
<tr>
<td align="center" valign="top">
<table class="centertable">
<tr>
<td>
</td>
</tr>
<tr>
<td align="center" valign="top">
<table class="containContentsTable">
<tr>
<td align="right" colspan=2 >
报告日期:
<input name="report_date" type="text" size="10" value="<%=ParameterUtils.getString(request,"report_date")%>"><a href="javascript:" onClick="show_cele_date(report_date,'','',report_date)"><img src='../../icon/cal.gif' border=0></a>
报告人:<input type="text" size=10 name="report_people" value="<%=ParameterUtils.getString(request,"report_people")%>">
</td>
</tr>
<tr>
<td colspan="2" align='center'><input type="button" class="button" value="添加" onClick="javascript:add()">
<input type="button" class="button" value="删除" onClick="javascript:removeSelect()">
<input type="button" class="button" value="修改" onClick="javascript:edit()">
<input type="button" class="button" value="浏览" onClick="javascript:look()">
<input type="button" class="button" value="查询" onClick="javascript:query()">
</td>
</tr>
<tr>
<td colspan="2">
<%
out.println("<table class='contentsTable' border='0' cellpadding='0' cellspacing='1'>");
out.println("<tr class='tr1' align=center ><td width=5% ></td><td>项目名称</td><td>报告日期</td><td>报告人</td><td>报告部门</td><td>完成情况</td><td>疑难问题</td></tr>");
Iterator e=list.iterator();
while(e.hasNext()){
Crm_project_reportItem rItem=(Crm_project_reportItem)e.next();
out.println("<tr align='center' onMouseOver=\"old_bg=this.getAttribute('bgcolor');this.setAttribute('bgcolor', '"+Constants.T_BGCOLOR_OVER+"', 0);\" onMouseOut=\"this.setAttribute('bgcolor', old_bg, 0);\" bgColor='"+Constants.T_BGCOLOR+"' >");
out.println("<td><input type='checkbox' name=checkvalue value='"+rItem.getId()+"'></td>");
out.println("<td>");
out.println(rItem.getCrm_project_infoItem().getProject_name());
out.println("</td>");
out.println("<td>"+DateUtils.formatString(rItem.getReport_date())+"</td>");//报告日期
out.println("<td>"+rItem.getReport_people()+"</td>");//报告人
out.println("<td>"+rItem.getDepartment()+"</td>");//报告部门
out.println("<td>"+rItem.getFinish_info()+"</td>");//完成情况
out.println("<td>"+rItem.getDifficult_info()+"</td>");//疑难问题
out.println("</tr>");
}
out.println("</table>");
%>
</td>
</tr>
<tr>
<td>
<input name="cboAll" type="checkbox" id="cboAll" value="checkbox" onClick="checkBoxAll()"> 全选
</td>
<td align="right" class="pagelink" > 共 <%=totalRecord%> 条, 共 <%=page_num%> 页, 第 <%=pageNo%> 页 <a href="javascript:first()">第一页</a> <a href="javascript:next()">下一页</a> <a href="javascript:pre()">上一页</a> <a href="javascript:last()" >最后一页</a>
<select name="position" id="position" onChange="goposition()">
<option value=""></option>
<%
for(int i=1;i<=page_num;i++)
{
out.println("<option ");
if(pageNo==i){out.println("selected");}
out.println(" value="+i+">");
out.println(i);
out.println("</option>");
}
%>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
<input type="hidden" name="status" value="">
<input type="hidden" name="page" value=<%=pageNo%>>
<input type="hidden" name="totalpage" value=<%=page_num%>>
<input type="hidden" name="id" value="">
<input type="hidden" name="ids" value="">
</form>
</body>
</html>
<script language="JavaScript" >
function checkBoxAll()//全选
{
var form = form1;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
form.elements[i].checked = form.cboAll.checked;
}
}
}
function edit()
{
var form=form1;
var j=0;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.id.value=form.elements[i].value;
j++;
}
}
}
if(form.id.value=="")
{
alert("请选择要修改的一条记录");
return;
}
if(j>1)
{
alert("一次只能修改一条记录");
return;
}
location="crm_project_reportedit.jsp?id="+form.id.value;
}
function look()
{
var form=form1;
var j=0;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.id.value=form.elements[i].value;
j++;
}
}
}
if(form.id.value=="")
{
alert("请选择要浏览的一条记录");
return;
}
if(j>1)
{
alert("一次只能浏览一条记录");
return;
}
location="crm_project_reportlook.jsp?id="+form.id.value;
}
function remove(id)
{
if(confirm("是否要删除选择的记录")==true)
{
var form=form1;
form.id.value=id;
form.status.value="remove";
form.submit();
}
}
function removeSelect()
{
var form=form1;
for(i=0; i<form.elements.length; i++)
{
if(form.elements[i].type=="checkbox" && form.elements[i].name=="checkvalue")
{
if(form.elements[i].checked==true)
{
form.ids.value+=form.elements[i].value+",";
}
}
}
if(form.ids.value=="")
{
alert("请选择要删除的记录");
return;
}
if(confirm("是否要删除选择的记录")==false)
return;
form.status.value="removeSelect";
form.submit();
}
function add()
{
location="crm_project_reportadd.jsp";
}
function query()
{
var form=form1;
if(form.report_date.value!=""&&!isDateTime(form.report_date.value))
{
alert("报告日期只能是短日期，形如 (2003-12-05)!");
form.report_date.focus();
return;
}
form.submit();
}
function first()
{
var form=form1;
if(eval(form.page.value)==1)
return;
form.page.value=1;
form.submit();
}
function next()
{
var form=form1;
if(eval(form.page.value)>=eval(form.totalpage.value))
return;
form.page.value=eval(form.page.value)+1;
form.submit();
}
function last()
{
var form=form1;
if(eval(form.page.value)>=eval(form.totalpage.value))
return;
form.page.value=eval(form.totalpage.value);
form.submit();
}
function pre()
{
var form=form1;
if(form.page.value<=1)
return;
form.page.value=eval(form.page.value)-1;
form.submit();
}
function goposition()
{
var form=form1;
form.page.value=form.position.value;
form.submit();
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -