📄 report.jsp
字号:
<option value="2" <%=(saleCompareAdapter.getStat()==2)?"selected":""%>>销售分析(按客户)</option>
<option value="3" <%=(saleCompareAdapter.getStat()==3)?"selected":""%>>销售分析(订销存)</option>
<option value="1" <%=(saleCompareAdapter.getStat()==1)?"selected":""%>>销售分析(店铺)</option>
<option value="4" <%=(saleCompareAdapter.getStat()==4)?"selected":""%>>销售分析(按日期)</option>
<option value="5" <%=(saleCompareAdapter.getStat()==5)?"selected":""%>>销售分析(进存销)</option>
<option value="6" <%=(saleCompareAdapter.getStat()==6)?"selected":""%>>销售分析(进存销)[按品牌]</option>
<option value="7" <%=(saleCompareAdapter.getStat()==7)?"selected":""%>>销售分析(按单据)</option>
<option value="8" <%=(saleCompareAdapter.getStat()==8)?"selected":""%>>销售分析(日销售收支表)</option>
</select>
</p>
</div></td>
</tr>
</TABLE>
<table width="100%" height="66" cellpadding="0" cellspacing="1" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#999999">
<tr bgcolor="#FFFFFF" class="usebotton">
<td width="85" height="24"><div align="center"><a href="#" onClick="javascript: selectedCustomer();">客户</a></div></td>
<td width="261" height="24" >
<%
{
RegionDDBean dropDownList=new RegionDDBean(loginInfo.getJndiName());
dropDownList.setSelectName("regionID2");
dropDownList.setScript("onChange='queryReport();'");
dropDownList.setDefaultName(saleCompareAdapter.getRegionID());
dropDownList.setSql("select * from region a where a.regionID is not null ");
out.println(dropDownList.writerTree());
}
%>
<%{
DropDownListBean dropDownList = new DropDownListBean(loginInfo.getJndiName());
dropDownList.setSelectName("custID2");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getCustID()));
dropDownList.setWidth("style=width:150");
dropDownList.setSQL("select a.custID,a.custNo + space(1) + a.custName from customer a where a.custType is not null "+cond+customerPerm+" order by 2");
out.print(dropDownList.getDropDownList());
}%> </td>
<td width="94" height="24"> <div align="center">经手人</div></td>
<td width="183" height="24" bgcolor="#FFFFFF">
<%{
DropDownListBean dropDownList = new DropDownListBean(loginInfo.getJndiName());
dropDownList.setSelectName("emplID2");
dropDownList.setWidth("style=width:150");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getEmplID()));
dropDownList.setSQL("select a.emplID,a.emplNo + space(1) + a.name from empl a where a.emplID is not null and a.status=1 "+pc+" order by 2");
out.print(dropDownList.getDropDownList());
}%> </td>
<td width="113" bgcolor="#FFFFFF"> <div align="center">开单日期</div></td>
<td width="227" height="24" bgcolor="#FFFFFF"> <div class="usebotton">
<div align="left">
<input name="createDate1" type="text" class="inputtext" id="dc2" size="10" maxlength="50" value="<%=saleCompareAdapter.getCreateDate1()%>" onClick="javascript:selectdate2(this);">
至
<input name="createDate3" type="text" class="inputtext" id="createDate32" size="10" maxlength="50" value="<%=saleCompareAdapter.getCreateDate3()%>" onClick="javascript:selectdate2(this);">
</div>
</div></td>
</tr>
<tr bgcolor="#FFFFFF" class="usebotton">
<td width="85" height="23"> <div align="center"><a href="#" onClick="javascript: selectStandBrand();">品牌</a></div></td>
<td width="261" height="23" > <div align="left">
<%{
DropDownListBean dropDownList = new DropDownListBean(loginInfo.getJndiName());
dropDownList.setSelectName("brandID2");
dropDownList.setWidth("style=width:150");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getBrandID()));
dropDownList.setSQL("select a.ID,a.brandNo + space(1) + a.brandName from brand a where a.ID is not null "+brandPermDrp+" order by 2");
out.print(dropDownList.getDropDownList());
}%>
</div></td>
<td width="94" height="23" > <div align="center">商品分类</div></td>
<td height="23" >
<%{
GdsClassDDBean dropDownList=new GdsClassDDBean(loginInfo.getJndiName());
dropDownList.setSelectName("classID2");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getClassID()));
dropDownList.setWidth("style=width:150");
dropDownList.setSql("select * from gdsClass");
out.println(dropDownList.writerTree());
}%> </td>
<td height="23" >
<div align="center">条形码/品名/规格</div></td>
<td height="23" > <div align="left"><input name="code2" type="text" class="inputtext" id="code2" value="<%=saleCompareAdapter.getCode()%>" size="20" maxlength="50"></div></td>
<input name="filt1" type="hidden" value="1" <%=saleCompareAdapter.getFilt1()?"checked":""%>>
<input name="filt2" type="hidden" value="1" <%=saleCompareAdapter.getFilt2()?"checked":""%>>
<input name="filt4" type="hidden" value="1" <%=saleCompareAdapter.getFilt4()?"checked":""%>>
</tr>
<tr bgcolor="#FFFFFF" class="usebotton">
<td width="85" height="23"><div align="center">备注</div></td>
<td width="261" height="23" ><input name="remark2" type="text" class="inputtext" id="remark2" size="20" maxlength="50" value="<%=saleCompareAdapter.getRemark()%>"></td>
<td width="94" height="23" > <div align="center">供货商</div></td>
<td height="23" >
<%{
DropDownListBean dropDownList = new DropDownListBean(loginInfo.getJndiName());
dropDownList.setSelectName("suppID2");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getSuppID()));
dropDownList.setWidth("style=width:150");
dropDownList.setSQL("select a.suppID,a.suppNo + space(1) + a.suppName from supplier a where a.suppID is not null "+pc+ supplierPerm +" order by 2");
out.print(dropDownList.getDropDownList());
}%></td>
<td height="23" > </td>
<td height="23" ><div align="right"><input type="submit" name="Submit22" value="查询"></div></td>
<input name="filt1" type="hidden" value="1" <%=saleCompareAdapter.getFilt1()?"checked":""%>>
<input name="filt2" type="hidden" value="1" <%=saleCompareAdapter.getFilt2()?"checked":""%>>
<input name="filt4" type="hidden" value="1" <%=saleCompareAdapter.getFilt4()?"checked":""%>>
</tr>
<%if(saleCompareAdapter.getStat()>4){%>
<tr bgcolor="#FFFFFF" class="usebotton">
<td width="85" height="23"><div align="center">仓库</div></td>
<td width="261" height="23" >
<%{
DropDownListBean dropDownList = new DropDownListBean(loginInfo.getJndiName());
dropDownList.setSelectName("warehouseCode2");
dropDownList.setDefaultName(String.valueOf(saleCompareAdapter.getWarehouseCode()));
dropDownList.setWidth("style=width:150");
dropDownList.setSQL("select a.warehouseCode,a.warehouseNo + space(1) + a.name from warehouse a where a.warehouseCode is not null "+pc+warehousePerm+" order by 2");
out.print(dropDownList.getDropDownList());
}%></td>
<td width="94" height="23" ><div align="center"></div></td>
<td height="23" > </td>
<td height="23" > </td>
<td height="23" ></td>
</tr>
<%}else{%>
<input name="warehouseCode2" type="hidden" value="0">
<%}%>
<%if(saleCompareAdapter.getStat()==5 || saleCompareAdapter.getStat()==6){%>
<tr bgcolor="#FFFFFF" class="usebotton">
<td height="21"><div align="center">交易情况</div></td>
<td height="21">
<select name="type2" style='width:80'>
<option value="0" <%=(saleCompareAdapter.getType()==0)?"selected":""%>>全部</option>
<option value="1" <%=(saleCompareAdapter.getType()==1)?"selected":""%>>有交易</option>
<option value="2" <%=(saleCompareAdapter.getType()==2)?"selected":""%>>无交易</option>
</select>
</td>
<td height="21"> </td>
<td height="21"> </td>
<td height="21"> </td>
<td height="21"> </td>
</tr>
<%}%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" height=5>
<tr>
<td>
</td>
</tr>
</table>
<%
switch (saleCompareAdapter.getStat()) {
case 0:
request.getRequestDispatcher("/sale/compare/list.jsp").include(request, response);
break;
case 1:
request.getRequestDispatcher("/sale/compare/list.jsp").include(request, response);
break;
case 2:
request.getRequestDispatcher("/sale/compare/list_cust.jsp").include(request, response);
break;
case 3:
request.getRequestDispatcher("/sale/compare/order_list_by_exec.jsp").include(request, response);
break;
case 4:
request.getRequestDispatcher("/sale/compare/sale_by_date.jsp").include(request, response);
break;
case 5:
request.getRequestDispatcher("/sale/compare/jxc_by_goods.jsp").include(request, response);
break;
case 6:
request.getRequestDispatcher("/sale/compare/jxc_by_brand.jsp").include(request, response);
break;
case 7:
request.getRequestDispatcher("/sale/compare/sale_by_sheet.jsp").include(request, response);
break;
case 8:
request.getRequestDispatcher("/sale/compare/sale_by_date.jsp").include(request, response);
break;
}
%>
<table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr valign="middle" class="button">
<td height="21">
<input type="button" name="Submit3" value="返回" onClick="javascript:backList();"> </td>
<td><div align="right">
<input type="button" name="Submit422" value="定制" onClick="javascript:reportSetup();">
<input type="button" name="Submit42" value="打印" onClick="javascript:printSetup();">
</div></td>
</tr>
</table>
<!-- 打印设置 在父窗口设值-->
<input type="hidden" name="print" value="">
<input type="hidden" name="r" value="">
<input type="hidden" name="printIds" value="">
<input type="hidden" name="printColor" value="">
<input type="hidden" name="isDetail" value="">
<input type="hidden" name="printType" value="">
<input type="hidden" name="pageRows" value="">
</form>
<!-- #EndEditable --></td>
</tr>
<tr>
<td height="16" colspan="2" valign="TOP" bgcolor="#FFFFFF"><form name="tmppost" method="post"></form> </td>
</tr>
</table></td>
</tr>
</table>
<TABLE WIDTH="100%" BORDER="0" align="center" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD align="left" valign="bottom" BGCOLOR="#D0D0D0"><img src="../../images/jiao_003.gif" width="15" height="12"></TD>
<TD valign="bottom" BGCOLOR="#D0D0D0">
<div align="right"><img src="../../images/jiao_002.gif" width="15" height="12"></div></TD>
</TR>
</TABLE>
<TABLE WIDTH="100%" BORDER="0" align="center" CELLPADDING="0" CELLSPACING="2">
<TR>
<TD width="642" height="38" valign="top">
<DIV ALIGN="CENTER">
<p align="left" class="down"><font color="#FFFFFF"><img src="../../images/logo_copyright.gif" width="231" height="38">
</font></p>
</DIV>
</TD>
<TD width="302" align="right" valign="top">
<div align="right"><img src="../../images/logo_java.gif" width="231" height="38"></div></TD>
</TR>
</TABLE>
</BODY>
<!-- #EndTemplate --></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -