报表jsp

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@page import="com.jltour.common.manager.OptionManager"%>
<%@page import="com.jltour.common.constant.OptionType"%>
<%@ taglib uri="java91" prefix="java91" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<link rel="stylesheet" type="text/css" href="/css/reportcss.css"/>
<script language='javascript' charset='utf-8' src='/js/framework.js'></script>
<script language='javascript' charset='utf-8' src='/js/area.js'></script>
<script language='javascript' charset='utf-8' src='/js/areafun.js'></script>
<script language='javascript' charset='utf-8' src='/js/hotelname.js'></script>
<script language='javascript' charset='utf-8' src='/js/supplierAll.js'></script>
<script language='javascript' charset='utf-8' src='/js/customer.js'></script>
<script language='javascript' charset='utf-8' src='/js/calendarSelect/WdatePicker.js'></script>
<script language='javascript' charset='utf-8' src='/js/Validation.js'></script>
<style >

</style>
</head>
<body>
<table>
<div id="queryFormDiv" style="POSITION:absolute;">
<form name="queryForm" action="/report/reportinfoAction!sellreporthotelall.action" method="post" target="queryFrame">
<table width="100%" class="searchtable3" align="center" border="0" cellpadding="1" cellspacing="0">
<tr>
<th height="10" colspan="8">销售报表查询</th>
</tr>
<tr>
<td width="120px" align="right">酒店区域:</td>
<td colspan="3">
<select id=country name="reportQueryPara.hotelcountry" οnchange="countryChange(this.value);" style="width:100px" ></select>
<select id=state name="reportQueryPara.hotelstate" οnchange="stateChange(this.value)"></select>
<select id=city name="reportQueryPara.hotelcity" ></select>
   产品经理:<select name="reportQueryPara.manager" ><option value="">-请选择-</option><java91:genoptionGe type="<%=OptionType.manager%>" checkedCode="" color="true" appendListType="manager" /></select>
</td>
<td width="120px" align="right">酒店星级:</td>
<td colspan="3">
<input type="hidden" value="" name="reportQueryPara.star"/>
<%=OptionManager.generateCheckBoxHtml(OptionType.star,"","",true,false)%></td>
</tr>
<tr>
<td width="120px" align="right">类型:</td><td><%=OptionManager.generateRadioGe(OptionType.pricingtype,"","",false,null,"","","") %></td>
<td width="120px" align="right">供应商类型:</td><td><java91:genCheckBox optionTypeCode="<%=OptionType.busstype%>" checkedValues="${supplier.funtype}" hasSetCheckedAll="true" /></td>
<td width="120px" align="right" >酒店选择:</td><td colspan="3"><input type="text" size="23" name="reportQueryPara.namechn" οnkeyup="return suggesthotel.displayhotelname(this,event);" style="width: 160px"/><input type="hidden" name="reportQueryPara.hotelid"/>
<img style="CURSOR: pointer;" src="/images/tab/images/33.gif" width="13" height="13" title="选择酒店" οnclick="openHotelSelect();" />
</td>
</tr>
<tr>
<td width="120px" align="right" >报表类型:</td>
<td>
<input type='radio' id='datetyped' style="CURSOR:pointer;" name="datetype" value="d" ><label for='datetyped' style='CURSOR:pointer;color:#697268'>日</label>
<input type='radio' id='datetypem' style="CURSOR:pointer;" name="datetype" value="m" checked="checked"><label for='datetypem' style='CURSOR:pointer;color:#697268'>月</label>
<input type='radio' id='datetypes' style="CURSOR:pointer;" name="datetype" value="w" ><label for='datetypes' style='CURSOR:pointer;color:#697268'>季</label>
<input type='radio' id='datetypey' style="CURSOR:pointer;" name="datetype" value="y" ><label for='datetypey' style='CURSOR:pointer;color:#697268'>年</label>
<input type='radio' id='datetypeo' style="CURSOR:pointer;" name="datetype" value="o" ><label for='datetypeo' style='CURSOR:pointer;color:#697268'>自定义区域</label>
</td>
<td colspan="6">
</td>
</tr>

<tr>
<td width="120px" align="right">开始日期:</td><td><input type="text" mandatory="true" vtype="date" name="reportQueryPara.begindate" id="start" class="Wdate" onClick="WdatePicker()"/></td>
<td width="120px" align="right">结束日期:</td><td><input type="text" mandatory="true" vtype="date" name="reportQueryPara.enddate" class="Wdate" onClick="WdatePicker({minDate:'#F{$dp.$D(\'start\',{d:1});}'})"/></td>
<td width="120px" align="right">预定日期:</td><td><input type="text" name="reportQueryPara.reservedate" vtype="date" class="Wdate" onClick="WdatePicker({minDate:'#F{$dp.$D(\'start\',{d:1});}'})"/></td>
</tr>

<tr>
<td colspan="8" align="right">
<input type="button" value="查询酒店总报表" οnclick="doQuery('/report/reportinfoAction!sellreporthotelall.action','all')" style="CURSOR:pointer;" > 
<input type="reset" value="重 置" style="CURSOR:pointer;" > 
</td>
</tr>
</table>
</form>
</div>
</table>
<table width="100%">
<div id="editDiv" style="POSITION:absolute;display:none;">
<tr>
<td >
<iframe name="queryFrame" id="queryFrame" width="100%" height="600" border="0" frameborder="0" > </iframe>
<input type="hidden" id="hotelname"/>
<input type="hidden" id="customername"/>
<input type="hidden" id="suppliername"/>
</td>
</tr>
</div>

</table>
<script>
function doQuery(actionscc,type){
if(notEmpty(actionscc)){
queryForm.action=actionscc;//'/report/reportinfoAction!sellreporthotelall.action
if(validateByform("queryForm")){
if('time' == type){
var times = getChecked("datetype");
if(notEmpty(times)){///reportQueryPara.datetype
setvalue("reportQueryPara.datetype",times);
}else{
alert("请选择导出类型:日,月,季,年");
return ;
}
}
var sStars = getChecked("star");
setvalue("reportQueryPara.star",sStars);
queryForm.submit();
}
}else{
alert("请选择您选择的报表类型");
}
}


var countryObj=id("country");
var stateObj=id("state");
var cityObj=id("city");
var zoneObj=id("zone");
//var bizzoneObj=id("bizzone");


var countryValue="70007";
var stateValue="70017";
var cityValue="70002";
var zoneValue="70014";


if(countryValue==null || countryValue=="" ){
countryValue="70007";
}

initCountry(countryValue,countryObj);
initState(countryValue,stateValue,stateObj);
initCity(stateValue,cityValue,cityObj);


function countryChange(a){
countryChangeHandle2(a,stateObj,cityObj);
clearSelectForm(zoneObj);
}
function stateChange(a){
stateChangeHandle2(a,cityObj);
}


function changeFrameSrc(fSrc){
// alert(fSrc);
document.getElementById("editFrame").src=fSrc;
}

var suggestsupplierAll = new supplierAll_all();
var suggestcustomer = new customer_all();
var suggesthotel = new hotelname_all();

function dojob(){
if(notEmpty(id('suppliername').value)){
name('reportQueryPara.suppliername').value=id('suppliername').value;
name('reportQueryPara.supplierid').value=id('suppliername').name;
id('suppliername').value="";
return;
}
if(notEmpty(id('customername').value)){//hotelname customername suppliername
name('reportQueryPara.customername').value=id('customername').value;
name('reportQueryPara.customerid').value=id('customername').name;
id('customername').value="";
return;
}
if(notEmpty(id('hotelname').value)){
name('reportQueryPara.namechn').value=id('hotelname').value;
name('reportQueryPara.hotelid').value=id('hotelname').name;
id('hotelname').value="";
}
}
</script>
</body>
</html>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要在JSP页面中显示图形报表,可以使用以下步骤: 1. 选择一个图形报表库,例如JFreeChart或Google Charts。 2. 在项目中添加图形报表库的相关JAR文件。 3. 在JSP页面中引入图形报表库的相关代码库。 4. 创建一个数据源,例如一个数组或数据库查询结果。 5. 使用图形报表库的API创建图表对象,并将数据源传递给它。 6. 将图表对象转换为图像格式,例如PNG或JPEG。 7. 在JSP页面中使用<img>标签将图像显示在页面上。 以下是一个简单的例子,使用JFreeChart在JSP页面中显示一个柱形图: 1. 引入JFreeChart的相关代码库: ``` <%@ page import="org.jfree.chart.ChartFactory" %> <%@ page import="org.jfree.chart.JFreeChart" %> <%@ page import="org.jfree.data.general.DefaultPieDataset" %> <%@ page import="org.jfree.chart.ChartUtilities" %> ``` 2. 创建一个数据源: ``` <% double[] data = new double[] { 20.0, 30.0, 50.0 }; String[] categories = new String[] { "Category 1", "Category 2", "Category 3" }; %> ``` 3. 创建图表对象: ``` <% DefaultPieDataset dataset = new DefaultPieDataset(); for (int i = 0; i < data.length; i++) { dataset.setValue(categories[i], data[i]); } JFreeChart chart = ChartFactory.createPieChart( "Sample Pie Chart", dataset, true, true, false ); %> ``` 4. 将图表对象转换为图像: ``` <% byte[] chartBytes = ChartUtilities.encodeAsPNG(chart.createBufferedImage(400, 300)); %> ``` 5. 在JSP页面中显示图像: ``` <img src="data:image/png;base64,<%=new String(org.apache.commons.codec.binary.Base64.encodeBase64(chartBytes))%>" /> ``` 这将在JSP页面中显示一个400x300像素的饼图。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值