简表报表配置以及ftl文件的一些功能

最新推荐文章于 2024-04-24 14:36:45 发布

时光旅行者一号

最新推荐文章于 2024-04-24 14:36:45 发布

阅读量3.3k

点赞数

本文链接：https://blog.csdn.net/qq_30072293/article/details/52129875

版权

本文介绍了如何修改joreportlist.ftl文件以实现页面查询时的必填项、默认值和日期格式化。内容包括设置查询条件、验证输入、日期选择器的使用，以及在页面加载成功后的操作。同时提到了JoReportDao_queryJoReportItems.sql、JoReportConstant.java和JoReportController.java的相关修改。

摘要由CSDN通过智能技术生成

因为最近做的功能是修改ftl页面一些代码，来实现页面查询时必填项，默认值，日期格式化等功能，下面是简表报表配置里需要实现的功能,顺序比较乱，希望能帮助你参考一下

简表页面查询栏

1.joreportlist.ftl文件代码

<pre name="code" class="html"><!--#setting classic_compatible=true-->
<!DOCTYPE html>
<html style="height: 100%">
<head>
	<title></title>
	<link href="plug-in/lhgDialog/skins/default.css" rel="stylesheet" id="lhgdialoglink">
	<script type="text/javascript" src="plug-in/jquery/jquery-1.8.3.min.js"></script>
	<script type="text/javascript" src="plug-in/tools/dataformat.js"></script>
	<link id="easyuiTheme" rel="stylesheet" href="plug-in/easyui/themes/default/easyui.css" type="text/css">
	<link rel="stylesheet" href="plug-in/easyui/themes/icon.css" type="text/css">
	<link rel="stylesheet" type="text/css" href="plug-in/accordion/css/accordion.css">
	<script type="text/javascript" src="plug-in/easyui/jquery.easyui.min.1.3.2.js"></script>
	<script type="text/javascript" src="plug-in/easyui/locale/easyui-lang-zh_CN.js"></script>
	<script type="text/javascript" src="plug-in/tools/syUtil.js"></script>
	<script type="text/javascript" src="plug-in/easyui/extends/datagrid-scrollview.js"></script>
	<script type="text/javascript" src="plug-in/My97DatePicker/WdatePicker.js"></script>
	<link href="plug-in/My97DatePicker/skin/WdatePicker.css" rel="stylesheet" type="text/css">
	<link rel="stylesheet" href="plug-in/tools/css/common.css" type="text/css">
	<script type="text/javascript" src="plug-in/lhgDialog/lhgdialog.min.js"></script>
	<script type="text/javascript" src="plug-in/tools/curdtools.js"></script>
	<script type="text/javascript" src="plug-in/tools/easyuiextend.js"></script>
	<script type="text/javascript" src="plug-in/jquery-plugs/hftable/jquery-hftable.js"></script>
	<link rel="stylesheet" href="plug-in/jquery/jquery-autocomplete/jquery.autocomplete.css" type="text/css">
	<script type="text/javascript" src="plug-in/jquery/jquery-autocomplete/jquery.autocomplete.min.js"></script>
    
	<style type='text/css'>
		body{margin:0px;padding:0px;}
	</style>
<script type="text/javascript">
$(function(){
	<#list config_queryList  as x>
		<#if x['search_mode']=="group">
			<#if x['field_type']=="Date" && x['data_type']=="*">
				$("input[name='${x['field_name']}_begin']").attr({datatype:"*"});
				$("input[name='${x['field_name']}_end']").attr({datatype:"*"});
			</#if>
		</#if>
		<#if x['search_mode']=="single">
			<#if x['field_type']=="Date" && x['data_type']=="*">
				$("input[name='${x['field_name']}']").attr({datatype:"*"});
			</#if>
		</#if>
	</#list>
	$('#${config_id}List').datagrid({
		idField: 'id',
		title: '${config_name}',
		url:'',
		fit:false,
		fitColumns:false,
		pageSize: 100,
		pagination:false,
		pageList:[10,30,50,100],
		singleSelect:true,
		checkbox:false,
		sortOrder:'asc',
		rownumbers:true,
		showHeader:false,
		showFooter:true,
		frozenColumns:[[]],
		columns:[
			[			
			]
		],
		onLoadSuccess:function(data){$("#${config_id}List").datagrid("clearSelections");},
		onClickRow:function(rowIndex,rowData)
			{rowid=rowData.id;gridname='${config_id}List';}
	});
});
//打开内链
function ${config_id}Listsearch(){
<#if (config_requiredList?size>0)>
		<#list config_requiredList as x>
		    <#if x['search_mode']=="single">
				var ${x['field_name']}= $('#${config_id}Listtb').find("[name='${x['field_name']}']").val();
				if(${x['field_name']}=="" || ${x['field_name']}==undefined) {
					alert("${x['field_txt']} 不能为空！");
					return;
				}
			<#else>
				var ${x['field_name']}_begin= $('#${config_id}Listtb').find("[name='${x['field_name']}_begin']").val();
				if(${x['field_name']}_begin=="" || ${x['field_name']}_begin==undefined) {
					alert("${x['field_txt']} 开始时间不能为空！");
					return;
				}
				var ${x['field_name']}_end= $('#${config_id}Listtb').find("[name='${x['field_name']}_end']").val();
				if(${x['field_name']}_end=="" || ${x['field_name']}_end==undefined) {
					alert("${x['field_txt']} 结束时间不能为空！");
					return;
				}
			</#if>
		</#list>
	</#if>
	$("#${config_id}Content").show();
	//document.${config_id}JoRForm.action = "reportviewer?file=demos/功能演示/脚本/引入自定义脚本函数.xml";
	var form = document.${config_id}JoR