list_cust.jsp

我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统

<%@ page contentType="text/html; charset=gb2312"%>
<%@include file="/common/ValidateJavaScript.jsp"%>
<%@include file="/common/system_perms.jsp"%>
<%@page  import="intuitsoft.eclipse.table.system.ModuleFunctionPermissionService"%>
<%@page  import="intuitsoft.eclipse.table.system.ModulePermissionService"%>
<%@page  import="net.intuitsoft.xeon.table.sale.compare.*"%>
<%@page  import="net.intuitsoft.xeon.table.sale.*"%>
<%@page  import="intuitsoft.eclipse.table.common.*"%>
<%@page  import="net.intuitsoft.xeon.table.common.ItemActionBean"%>
<%@page  import="net.intuitsoft.xeon.table.common.ListBean"%>
<%@ page import="intuitsoft.eclipse.table.system.user.*"%>
<%@include file="/common/sales_perms.jsp"%>
<%@page  import="net.intuitsoft.xeon.table.report.define.*"%>
<%



boolean dispAmo = net.intuitsoft.xeon.table.sale.SalePerms.agree(perms,net.intuitsoft.xeon.table.sale.EventCode.EX_SHEET_DISP_AMO);



SaleCompareAdapter report = (SaleCompareAdapter)request.getAttribute("SaleCompareAdapter2");
if(report == null) {
    report = new SaleCompareAdapter(loginInfo.getJndiName());
}

ListAdapter listAdapter = (ListAdapter)request.getAttribute("ListAdapter");
if(listAdapter == null) {
    listAdapter = new ConcreteListAdapter(loginInfo.getJndiName());
}
ListBean list = new ListBean(loginInfo.getJndiName(),new Report(loginInfo.getJndiName()));

list.setPage(listAdapter.getPage());
list.setOrder(listAdapter.getOrder());
list.setSort(listAdapter.getSort());
list.setSqlCond(listAdapter.getSqlCond());
 






String orderSql  = "";
String cond1 = "";

if(!"".equals(report.getRegionID())) {
	cond1 += " and a.custID in (select custID from customer where regionID like '%"+ report.getRegionID() + "')";
}

if(report.getCustID() != 0) {
	cond1 += " and a.custID=" + report.getCustID(); 
}else{
    orderSql += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "custID", loginInfo.params.getCustomerPerm(), report.getCustID());
}



if(report.getEmplID() != 0) {
	cond1 += " and a.emplID=" + report.getEmplID(); 
}
    cond1 +=ToolKit.dateBound(loginInfo.getJndiName(),"a", report,loginInfo.getSysUserCode());

if(!"".equals(report.getCreateDate1()) && !"".equals(report.getCreateDate3())) {
    cond1 += " and a.createDate between '" + report.getCreateDate1() + "' and '" + report.getCreateDate3() + "'";
}
else 
if(!"".equals(report.getCreateDate1()) && "".equals(report.getCreateDate3())) {
    cond1 += " and a.createDate >= '" + report.getCreateDate1() + "'";
 }
else 
if("".equals(report.getCreateDate1()) && !"".equals(report.getCreateDate3())) {
    cond1 += " and a.createDate <= '" + report.getCreateDate3() + "'";
 }
 


if(report.getBrandID() != 0) {
	cond1 += " and c.brandID=" + report.getBrandID(); 
}else{
    cond1 += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("c", "brandID", loginInfo.params.getBrandPerm(), report.getBrandID());
}

if(!"".equals(report.getClassID())) {
	cond1 += " and c.classID like '" + report.getClassID() + "%'";
}


if(report.getWarehouseCode() != 0) {
	cond1 += " and a.warehouseCode=" + report.getWarehouseCode(); 
}else{
    cond1 += intuitsoft.eclipse.table.system.perm.Perm.sqlCondSQL("a", "warehouseCode", loginInfo.params.getWarehousePerm(), report.getWarehouseCode());
}



if(!"".equals(report.getCode())) {
	cond1 += " and c.gdsNo + c.gdsName  like '%" + report.getCode() + "%'"; 
}


 

StringBuffer sql = new StringBuffer(200);
StringBuffer sql2 = new StringBuffer(200);
sql.append("select c.custName,isnull(sum(f.qua),0) as qua,isnull(sum(f.quab),0) as quab,case isnull(sum(f.qua),0) when 0 then '100%' else cast(cast(isnull(sum(f.quab),0)*100.0/isnull(sum(f.qua),0) as decimal(10,1)) as varchar)+'%' end as rate,avg(f.price) as price,isnull(sum(f.amo),0) - isnull(sum(f.amob),0) as amo,(isnull(sum(f.amo),0) - isnull(sum(f.costAmo),0) -(isnull(sum(f.amob),0)-isnull(sum(f.costAmob),0))) as amob, c.custID ");
sql.append(" from (");
sql2.append(" from (");

sql.append("select b.goodsID,c.gdsNo,c.gdsName,c.gdsStandard,c.unit,b.qua as qua ,0 as quab,isnull(b.price,0) as price,b.amo as amo , 0 as amob, b.costAmo,0 as costAmob,a.createDate,a.custID from  exItems b, exSheet a,goods c where a.exSheetCode=b.exSheetCode and a.isRegLed=1 and c.goodsID=b.goodsID ");
sql.append(cond1);
sql.append(" union all ");
sql.append(" select b.goodsID,c.gdsNo,c.gdsName,c.gdsStandard,c.unit,0 as qua,b.qua as quab,isnull(b.price,0) as price,0 as amo,b.amo as amob,0 as costAmo,b.costAmo as costAmob, a.createDate,a.custID from  ebItems b,ebSheet a,goods c where a.ebSheetCode=b.ebSheetCode and a.isReg=1 and c.goodsID=b.goodsID ");
sql.append(cond1);

sql.append(" ) as f,customer c where c.custID=f.custID  ");
sql2.append("select b.goodsID,c.gdsNo,c.gdsName,c.gdsStandard,c.unit,b.qua as qua ,0 as quab,isnull(b.price,0) as price,b.amo as amo , 0 as amob, b.costAmo,0 as costAmob,a.createDate,a.custID from  exItems b, exSheet a,goods c where a.exSheetCode=b.exSheetCode and a.isRegLed=1 and c.goodsID=b.goodsID ");
sql2.append(cond1);
sql2.append(" union all ");
sql2.append(" select b.goodsID,c.gdsNo,c.gdsName,c.gdsStandard,c.unit,0 as qua,b.qua as quab,isnull(b.price,0) as price,0 as amo,b.amo as amob,0 as costAmo,b.costAmo as costAmob, a.createDate,a.custID from  ebItems b,ebSheet a,goods c where a.ebSheetCode=b.ebSheetCode and a.isReg=1 and c.goodsID=b.goodsID ");
sql2.append(cond1);
sql2.append(" ) as f,customer c where c.custID=f.custID  ");

list.setGroupBy(" group by c.custID,c.custName ");

list.setSql(sql.toString());
list.setPageSize(listAdapter.getPageSize());
//java.util.List  exSheets = list.executeQuery();
System.out.println(list.getNeatSql());


ReportDefine reportDefine = new ReportDefine(loginInfo.getJndiName(),"saleCompareByListCust");
if (!reportDefine.defineSheet.getSql().equals("")){
   list.setSql(reportDefine.defineSheet.getSql());
   list.setGroupBy(reportDefine.defineSheet.getGroupSql());
}

ReportDefineListBean query = new ReportDefineListBean(loginInfo.getJndiName());
query.setSql(list.getNeatSql());
query.setPageSize(listAdapter.getPageSize());
query.setPage(listAdapter.getPage());

java.util.List  sheets = query.query();
%>
<HTML>
<HEAD>

<LINK REL="stylesheet" HREF="/css/main.css" TYPE="text/css">
<script language="JavaScript">
<!--
function toPage() {
	page(document.forms[0].page.value);
}


function toPageEnter() {
  if (event.keyCode == 13) {
	toPage();
  }
}

function page(p) {
	document.forms[0].eventCode.value =<%=EventCode.COMPARE_REPORT_LIST%>;
    document.forms[0].page.value = p;
    document.forms[0].action = "/sale/accesscontrolservice";
	document.forms[0].target = "_self";
    document.forms[0].submit();
}

function orderBy(p) {
	var desc = "desc";
	var asc  = "asc";

	if(document.forms[0].sort.value == desc) {
		document.forms[0].sort.value = asc;
	}
	else {
		document.forms[0].sort.value = desc;
	}

	document.forms[0].eventCode.value =<%=EventCode.COMPARE_REPORT_LIST%>;

    document.forms[0].order.value = p;
    document.forms[0].action = "/sale/accesscontrolservice";
	document.forms[0].target = "_self";
    document.forms[0].submit();
}


function content() {
	alert("二期实现");
	return;
}
 
 

 

// -->
</script>

<body>
<TABLE width="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0" >
  <%request.getRequestDispatcher("/common/i_sys_help.jsp?className=" + this.getClass().getName()).include(request, response); %>
  <TR>                 
    <TD class="title_800"><div align="right"><a href="javascript:helpYou('<%=this.getClass().getName()%>');" class="sysHelp">.</a></div></TD>
  </TR>
</TABLE>

<table width="100%" height="75" cellpadding="0" cellspacing="1" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#999999">
  <tr bgcolor="#FFFFFF" class="tabtitt">
    <td width="3%" height="24">&#24207;</td>
    <%
	ReportDefineItems order2 = null;

	for (int j = 0; j< reportDefine.defineItems.size();j++){
		order2 = (ReportDefineItems) reportDefine.defineItems.get(j);
	%>
    <td width="<%=order2.getShowPer()%>%" height="24" ><a href="javascript:orderBy(<%=order2.getOrderSeq()%>);" class="tabtitt"><%=order2.getName()%></a></td>
    <%}%>
  </tr>
  <%
	double sum [] = new double[reportDefine.cols-1];
	int seqenceCode = 0;
	if(list.getPage() > 1) {
		seqenceCode = (list.getPage() -1) * list.getPageSize();
	}
	for(Iterator iter = sheets.iterator(); iter.hasNext();) {
		Map adapter = (Map) iter.next();
        seqenceCode++;
	%>
  <TR  bgcolor="#FFFFFF" onmouseover="this.bgColor='#DADADA';" onmouseout="this.bgColor='#FFFFFF';" class="tabcontent" > 	
    <td height="19"><div align="center"><%=seqenceCode%></div></td>
	<%
	for (int j = 0; j< reportDefine.defineItems.size();j++){
	order2 = (ReportDefineItems) reportDefine.defineItems.get(j);
    if (order2.getIsSum()){
		sum[j] += ToolKit.toDouble(String.valueOf(adapter.get(order2.getField())));
	}
	%>
    <td><div align="<%=order2.getAlign()%>" style="color:<%=order2.getFontColor()%>"><%=ToolKit.agree(order2.getPermsEventCode(),perms,order2.getPermsModule())?""+ToolKit.isZero(String.valueOf(adapter.get(order2.getField())), order2.getDecim()):""%></div></td>
    <%}%>
  </tr>
  <%}%>
  <tr bgcolor="#FFFFFF" class="usebotton">
    <td height="19"><div align="center">&#21512;</div></td>
    <%
		ReportDefineButtom order3 = null;
		for (int j=0;j<reportDefine.defineButtom.size();j++){
			order3 = (ReportDefineButtom)reportDefine.defineButtom.get(j);
            if (order3.isSum()){
   			%>
    <td><div align="center"><%=ToolKit.agree(order3.getPermsEventCode(),perms,order3.getPermsModule())?""+ToolKit.isZero(String.valueOf(sum[order3.getCol()]),order3.getDecim()):""%></div></td>
    	<%}else {%>
    <td colspan="<%=order3.getColSpan()%>" >&nbsp;</td>
    <%    }%>
    <%  }%>
  </tr>
</table>


            
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
  <TR>
    <TD height="25" colspan="2" class="title_800"> 
                  <div align="right"  >
                      <p class="pageCss">页码：<%=query.getPage()%>/<%=query.getPageCount()%> <a href="javascript:page(1);" class="pageCss">第一页</a> <a href="javascript:page(<%=query.previous()%>);" class="pageCss">上一页</a> <a href="javascript:page(<%=query.next()%>);" class="pageCss">下一页</a> <a href="javascript:page(<%=query.getPageCount()%>);" class="pageCss">最后一页</a> TO
          <input name="page" type="text" class="inputtextToPage" onChange="javascript:toPage();" onKeyPress="javascript:toPageEnter();onlyInteger();"  value="<%=list.getPage()%>" size="2">
          页</a></p>
      </div></TD>
  </TR>
  <TR>
    <TD colspan="2"><div align="right"><span class="tabcontent">每页显示：
        <input name="pageSize" type="text" id="pageSize" value="<%=listAdapter.getPageSize()%>" size="10" maxlength="10" onKeyPress="javascript:toPageEnter();onlyInteger();">
        条记录</span></div></TD>
  </TR>
</TABLE>
<input type="hidden" name="eventCode" value="">
<!--????-->
<input type="hidden" name="sort" value="<%=list.getSort()%>">
<input type="hidden" name="order" value="<%=list.getOrder()%>">
<input type="hidden" name="sqlCond" value="<%=list.getSqlCond()%>">
<input type="hidden" name="sql" value="<%=list.getNeatSql()%>">
<input type="hidden" name="groupBy" value="<%=list.getGroupBy()%>">
<input type="hidden" name="reportSetupCode" value="<%=reportDefine.defineSheet.getSheetCode()%>">

</body>
</HTML>