sale_by_sheet.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.*"%>
<%@page  import="net.intuitsoft.xeon.table.report.define.*"%>
<%
 



boolean profit = intuitsoft.eclipse.table.system.SystemPerms.agree(perms,intuitsoft.eclipse.table.system.EventCode.DISP_COST);



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


 






                StringBuffer tmp = new StringBuffer();
                tmp.append(ToolKit.dateBound(loginInfo.getJndiName(),"a",report, loginInfo.getSysUserCode()));


                if (!"".equals(report.getCreateDate1()) &&
                    !"".equals(report.getCreateDate3())) {
                    tmp.append(" and a.createDate  between '");
                    tmp.append(report.getCreateDate1());
                    tmp.append("' and '");
                    tmp.append(report.getCreateDate3());
                    tmp.append("'");
                }

                if (!"".equals(report.getCreateDate1()) &&
                    "".equals(report.getCreateDate3())) {
                    tmp.append(" and a.createDate  >= '");
                    tmp.append(report.getCreateDate1());
                    tmp.append("'");
                }
                if ("".equals(report.getCreateDate1()) &&
                    !"".equals(report.getCreateDate3())) {
                    tmp.append(" and a.createDate  <= '");
                    tmp.append(report.getCreateDate3());
                    tmp.append("'");
                }
				

StringBuffer exSheetCode = new StringBuffer();

if (report.getExSheetCode() != null && !"".equals(report.getExSheetCode())) {
   exSheetCode.append(" and a.exSheetCode  like  '%");
   exSheetCode.append(report.getExSheetCode());
   exSheetCode.append("%'");
}


StringBuffer ebSheetCode = new StringBuffer();

if (report.getExSheetCode() != null && !"".equals(report.getExSheetCode())) {
   ebSheetCode.append(" and a.ebSheetCode  like  '%");
   ebSheetCode.append(report.getExSheetCode());
   ebSheetCode.append("%'");
}

String orderSql = "";
orderSql += tmp.toString();



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

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


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





System.out.println("orderSql: " + orderSql);
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());

StringBuffer sb = new StringBuffer(500);
sb.append(" select convert(varchar(10), a.createDate, 120) as createDate,(select name from empl where emplID=a.emplID)  as emplName,a.exSheetCode as sheetCode, b.custName, a.qua as saleQua,0 as backQua,a.qua,a.amo as saleAmo,0 as backAmo,a.amo,1 as ID  from  exSheet a left join customer b on(a.custID=b.custID) where a.exSheetCode is not null and a.isRegLed=1 "+orderSql.toString()+exSheetCode.toString());
sb.append(" union all " );
sb.append(" select convert(varchar(10), a.createDate, 120) as createDate,(select name from empl where emplID=a.emplID)  as emplName,a.ebSheetCode as sheetCode, b.custName, 0         ,a.qua as backQua,-1*a.qua,0,         a.amo as backAmo,-1*a.amo,2  from  ebSheet a left join customer b on(a.custID=b.custID) where a.ebSheetCode is not null and a.isReg=1 "+orderSql.toString()+ebSheetCode.toString());

list.setSql(sb.toString());
list.setPageSize(listAdapter.getPageSize());
//java.util.List  exSheets = list.executeQuery();




ReportDefine reportDefine = new ReportDefine(loginInfo.getJndiName(),"saleCompareBySheet");
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;
}
 
function redirect(sheetCode,type) {
    if(type==2){
       var url = "/sale/accesscontrolservice?eventCode=" + <%=net.intuitsoft.xeon.table.sale.EventCode.EB_SHEET_CONTENT%> + "&ebSheetCode=" + sheetCode;
	}else{
       var url = "/sale/accesscontrolservice?eventCode=" + <%=net.intuitsoft.xeon.table.sale.EventCode.EX_SHEET_CONTENT%> + "&exSheetCode=" + sheetCode;
	}
	document.tmppost.action = url;
	document.tmppost.target = "_blank";
    document.tmppost.submit();
} 
 

// -->
</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">序</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();
		String bg = "#FFFFFF";
		if(Integer.parseInt(String.valueOf(adapter.get("ID")))==2) {
			bg = "#FFFF00";
		}        
		seqenceCode++;
	%>
  <TR  bgcolor="<%=bg%>" onmouseover="this.bgColor='#DADADA';" onmouseout="this.bgColor='<%=bg%>';" class="tabcontent" > 	
    <td height="19"><div align="center"><a href="javascript:redirect('<%=String.valueOf(adapter.get("sheetCode"))%>','<%=String.valueOf(adapter.get("ID"))%>');"><%=seqenceCode%></a></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">合</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>