123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228 |
- <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
- <%@include file="/pages/includes/taglibs.jsp" %>
- <head>
- <script type="text/javascript" src="<%=request.getContextPath() %>/resource/js/jquery-1.8.3.js"></script>
- <script type="text/ecmascript" src="<%=request.getContextPath() %>/resource/plugin/jqgrid/js/jquery.jqGrid.min.js"></script>
- <script type="text/ecmascript" src="<%=request.getContextPath() %>/resource/plugin/jqgrid/js/i18n/grid.locale-cn.js"></script>
-
- <script type="text/ecmascript" src="<%=request.getContextPath()%>/resource/js/system/jqdatagrid.js"></script>
- <script src="<%=request.getContextPath()%>/resource/js/datePicker/WdatePicker.js" type="text/javascript"></script>
- <link rel="stylesheet" type="text/css" href="<%=request.getContextPath() %>/resource/plugin/jqueryui/css/custom-theme/jquery-ui-1.9.2.custom.css" />
- <link rel="stylesheet" type="text/css" media="screen" href="<%=request.getContextPath() %>/resource/plugin/jqgrid/css/ui.jqgrid.css" />
- <style type="text/css">
- a{ /* 统一设置所以样式 */
- font-family:Arial;
- font-size:12px;
- text-align:center;
- margin:3px;
- }
- a:link,a:visited{ /* 超链接正常状态、被访问过的样式 */
- color:#000000;
- padding:4px 10px 4px 10px;
- background-color:#f1f1f1;
- text-decoration:none;
-
- border-top:1px solid #EEEEEE; /* 边框实现阴影效果 */
- border-left:1px solid #EEEEEE;
- border-bottom:1px solid #717171;
- border-right:1px solid #717171;
- }
- a:hover{ /* 鼠标指针经过时的超链接 */
- color:#821818; /* 改变文字颜色 */
- padding:5px 8px 3px 12px; /* 改变文字位置 */
- background-color:#e2c4c9; /* 改变背景色 */
- border-top:1px solid #717171; /* 边框变换,实现“按下去”的效果 */
- border-left:1px solid #717171;
- border-bottom:1px solid #EEEEEE;
- border-right:1px solid #EEEEEE;
- }
- fieldset legend {
- color:#302A2A;
- font: bold 16px/2 Verdana, Geneva, sans-serif;
- font-weight: bold;
- text-align: left;
- text-shadow: 2px 2px 2px rgb(88, 126, 156);
- }
- </style>
- <script type="text/javascript">
-
- function changeFc(type){
- var url1 = "windfarmAjax.action?type="+type;
- $.ajax({
- type:"post",
- url:url1,
- dataType:"json",
- success: function(data){
- if(data.length != 0){
- eval(data);
- $("#wpId").empty();
- $("#wpId").append("<option value=''>请选择</option>");
-
- for(var i=0; i<data.length; i++){
- $("#wpId").append("<option value='"+data[i].id+"'>"+data[i].name+"</option>");
- }
-
- }else{
- $("#wpId").append("<option value=''>请选择</option>");
- $("#wpId").addOption("请选择","");
- }
-
- queryData();
- }
- });
-
-
- }
- function queryData(){
- if("" == $("#beginDate").val()){
- alert("请选择查询开始日期!");
- }else if("" == $("#endDate").val()){
- alert("请选择查询结束日期!");
- }
- else{
- //var type=$("#type").val();
- //var wpId=$("#wpId").find("option:selected").val();
- //var beginDate=$("#beginDate").val();
- //var endDate=$("#endDate").val();
- //var url = '<%=request.getContextPath() %>/charts/totalPowerCapacityTopList.action?wpId='+wpId
- // +"&beginDate="+beginDate +"&endDate="+endDate+"&type="+type;
- //$("#gridTable").setGridParam({url:url}).trigger("reloadGrid");
- $("#gridTable").jqGrid('GridUnload');
- showJqGrid();
- }
- }
- $(document).ready(function () {
- showJqGrid();
- });
- function showJqGrid() {
- var wpId=$("#wpId").find("option:selected").val();
- var beginDate=$("#beginDate").val();
- var endDate=$("#endDate").val();
- var url = '<%=request.getContextPath() %>/charts/totalPowerCapacityTopList.action?wpId='+wpId
- +"&beginDate="+beginDate +"&endDate="+endDate;
- var id = 'gridTable';
- var datatype = 'json';
- var colNames = ['风场', '风机','起始日期','截至日期','平均风速','SCADA发电量(万kwh)'];
- var colModel = [
- { name: 'windfarm', index: 'windfarm', width: 200, align: 'center'},
- { name: 'windturbine', index: 'windturbine', width: 200, align: 'center'},
- { name: 'beginDate', index: 'beginDate', width: 250, align: 'center',formatter:'date', formatoptions:{newformat:'Y-m-d'},align:'center'},
- { name: 'endDate', index: 'endDate', width: 250, align: 'center',formatter:'date', formatoptions:{newformat:'Y-m-d'},align:'center'},
- { name: 'speed', index: 'speed', width: 200, align: 'center', formatter:'number', formatoptions:{decimalPlaces: 2},sorttype: 'int'},
- { name: 'generatingCapacity', index: 'generatingCapacity', width: 200, align: 'center', formatter:'number', formatoptions:{decimalPlaces: 4},sorttype: 'int'}
- ];
- var caption = '总发电量排行榜';
- var sortname = 'generatingCapacity';
- var gridPagerID ='gridPager';
- var sortorder='desc';
- var height='auto';
- var width='auto';
- var rownumbers=true;
- var multiselect=false;
- myJqGrid(id, url, datatype, colNames, colModel, caption, sortname, gridPagerID,sortorder,height,width,
- multiselect,rownumbers);}
- function toExcel() {
- if("" == $("#beginDate").val()){
- alert("请选择查询开始日期!");
- }else if("" == $("#endDate").val()){
- alert("请选择查询结束日期!");
- }
- else{
- var type=$("#type").val();
- var wpId=$("#wpId").find("option:selected").val();
- var beginDate=$("#beginDate").val();
- var endDate=$("#endDate").val();
- var url = '<%=request.getContextPath() %>/charts/totalPowerCapacityTopExcel.action?wpId='+wpId
- +"&beginDate="+beginDate +"&endDate="+endDate+"&type="+type;
- $('#toexcel').attr('href',url);
- }
- }
-
- </script>
- <style type="text/css">
- fieldset legend {
- color:#302A2A;
- font: bold 16px/2 Verdana, Geneva, sans-serif;
- font-weight: bold;
- text-align: left;
- text-shadow: 2px 2px 2px rgb(88, 126, 156);
- }
- </style>
- </head>
- <body>
- <form action="generatingcapacityTop.action" method="post" id="f1">
- <fieldset style="height: 60px" id="fst">
- <legend class="item_Name">查询条件</legend>
- <table width="1300px" cellpadding="0" cellspacing="0" class="dataform">
- <tr>
- <th width="100px" class="item_Name">
- 类型:
- </th>
- <td width="100px" >
- <s:select list="#{'':'全部','fc':'风场'}" cssStyle="width:100px" id="type" name="type" onchange="javascript:changeFc(this.value);"></s:select>
- </td>
- <th width="100px" class="item_Name">
- 风场:
- </th>
- <td width="200px" >
- <s:select list="wps" cssStyle="width:200px" listKey="id" listValue="name" id="wpId" name="wpId" headerKey="" headerValue="请选择" onchange="javascript:queryData();"></s:select>
- </td>
-
- <th width="100px" class="item_Name">
- 开始日期
- </th>
- <td width="100px" style="text-align: left">
- <s:textfield cssClass="Wdate" onFocus="WdatePicker({dateFmt:'yyyy-MM-dd',isShowWeek:true,readOnly:true})"
- id="beginDate" name="beginDate" title="开始日期" onchange="javascript:queryData();"/>
- </td>
- <th width="100px" class="item_Name">
- 结束日期
- </th>
- <td width="100px" style="text-align: left">
- <s:textfield cssClass="Wdate" onFocus="WdatePicker({dateFmt:'yyyy-MM-dd',isShowWeek:true,readOnly:true})"
- id="endDate" name="endDate" title="结束日期" onchange="javascript:queryData();"/>
- </td>
- <td width="200px" style="text-align: right">
- <a href="#" onclick="javascript:toExcel();" id="toexcel">导出</a>
- </td>
- </tr>
- </table>
- </fieldset>
- <br/>
- <table id='gridTable' >
- </table>
- <div id='gridPager'></div>
- </form>
- </body>
|