meidu2021/daju/WebRoot/webpage/cn/com/lzt/dbquery/queryByAgeList.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<t:base type="jquery,easyui,tools,DatePicker"></t:base>
<div class="easyui-layout" fit="true">
	<div region="center" style="padding: 0px; border: 0px">
		<t:datagrid name="queryList" checkbox="false" fitColumns="false"
			title="按年龄统计" actionUrl="dbQueryUserController.do?queryByAgeDatagrid"
			idField="id" fit="true" queryMode="group">
			<t:dgCol title="主键" field="pid" hidden="true" queryMode="single"
				width="210"></t:dgCol>
			<t:dgCol title="项目名称" field="departname" sortable="false"
				queryMode="single" width="220"></t:dgCol>
			<t:dgCol title="项目在职人数" field="total" query="false" sortable="false"
				queryMode="single" width="220"></t:dgCol>
			<t:dgCol title="" field="certName" queryMode="single" hidden="true"
				width="220"></t:dgCol>
			<t:dgCol title="符合条件人数" field="querycount" query="false"  sortable="false"
				queryMode="group" width="220"></t:dgCol>
			<t:dgCol title="百分比" field="percent" query="false"  formatterjs="customFmatter" sortable="false"
				queryMode="group" width="220"></t:dgCol>
			<%--    <t:dgCol title="操作" sortable="false" field="opt" width="300"></t:dgCol> --%>
			<%-- <t:dgFunOpt title="开启" funname="enableObj(id,bpmStatus)" urlclass="ace_button"  urlfont="fa-cog"></t:dgFunOpt> --%>
			<%--    <t:dgFunOpt title="离职报告下载" funname="downloadFile(id)"  urlclass="ace_button" urlfont="fa-check" ></t:dgFunOpt> --%>
			<%--    <t:dgFunOpt exp="bpmStatus#eq#1" urlclass="ace_button"  urlfont="fa-cog" funname="startUserDefinedProcess(id,bpmStatus,applicantId)" title="提交流程" /> --%>
			<%--    <t:dgFunOpt exp="bpmStatus#ne#1" urlclass="ace_button"  urlfont="fa-cog" funname="startus(id,procInstId)" title="查看流程" /> --%>
			<%--    <t:dgFunOpt exp="bpmStatus#eq#2" urlclass="ace_button"  urlfont="fa-cog" funname="startusr(id,procInstId,bpmStatus,reject,iamApplyUser,applicantId)" title="撤回流程" /> --%>
			<%-- <t:dgDelOpt title="删除" url="dbQueryUserController.do?doDel&id={id}" urlclass="ace_button"  urlfont="fa-trash-o"/> --%>
<%-- 			   <t:dgToolBar title="录入" icon="icon-add" operationCode="add"  url="dbQueryUserController.do?goAdd" funname="add"></t:dgToolBar> --%>
			<%--    <t:dgToolBar title="修改" icon="icon-edit" operationCode="edit"  url="dbQueryUserController.do?goUpdate" funname="update"></t:dgToolBar> --%>
			<%--    <t:dgToolBar title="删除" icon="icon-remove" operationCode="remove"  url="dbQueryUserController.do?logicDel" funname="deleteObj"></t:dgToolBar> --%>
			<%--    <t:dgToolBar title="查看" icon="icon-view" url="dbQueryUserController.do?goview" funname="goview"></t:dgToolBar> --%>
			<%-- <t:dgToolBar title="定时" icon="icon-search" url="dbQueryUserController.do?modify" funname="modify"></t:dgToolBar> --%>
			<%-- <t:dgToolBar title="撤销" icon="icon-edit" operationCode="edit"  url="dbQueryUserController.do?disable" funname="disableObj"></t:dgToolBar> --%>
			<t:dgToolBar title="导出" icon="icon-put" operationCode="put"  funname="ExportXls"></t:dgToolBar>
		</t:datagrid>
	</div>
</div>
	<script>
		    $(function() {
		        var datagrid = $("#queryListtb");
		        datagrid.prepend($("#pinjie1 div[name='pinjie2']").html());
		        $("#pinjie1").html('');

		        datagrid.children(".datagrid-toolbar").children("span:first").after($("#pinjiechaxun1 div[name='pinjiechaxun2']").html());
		        $("#pinjiechaxun1").html('');
			});
		    
		    function customFmatter(cellvalue, options, rowObject){  
		    	
		    	cellvalue = cellvalue * 100;
		    	cellvalue = changeTwoDecimal_f(cellvalue);
		        return ""+cellvalue+" %";  
		    };
		    
		    function changeTwoDecimal_f(x) {
		    	 var f_x = parseFloat(x);
		    	 if (isNaN(f_x)) {
		    	 alert('function:changeTwoDecimal->parameter error');
		    	 return false;
		    	 }
		    	 var f_x = Math.round(x * 100) / 100;
		    	 var s_x = f_x.toString();
		    	 var pos_decimal = s_x.indexOf('.');
		    	 if (pos_decimal < 0) {
		    	 pos_decimal = s_x.length;
		    	 s_x += '.';
		    	 }
		    	 while (s_x.length <= pos_decimal + 2) {
		    	 s_x += '0';
		    	 }
		    	 return s_x;
		    	}

	</script>
	  <div id="pinjie1">
		    <div name="pinjie2"  style="padding:3px; height: auto" class="datagrid-toolbar">
	         <table style="height:85px;padding:0px" cellpadding="0" cellspacing="1" >
					<tbody>
						
						<tr>
							<td align="right">
								<label class="Validform_label">
									出生日期:
								</label>
							</td>
							<td class="value" colspan="3">
							      <input id="minBirth" name="minBirth" type="text" style="width: 150px"  class="Wdate" 
									onclick="WdatePicker({dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'maxBirth\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/>~
								 <input id="maxBirth" name="maxBirth" type="text" style="width: 150px"  class="Wdate"  
									onclick="WdatePicker({dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'minBirth\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/>
							</td>
							
						</tr>
					</tbody>
				</table>
		    </div>
		</div>

		<div id="pinjiechaxun1">
		    <div name="pinjiechaxun2"  style="padding:3px; height: auto" class="datagrid-toolbar">
		    	<div style="float: right;">
		    		<span>
			    		<a href="#" class="easyui-linkbutton" plain="true" icon="icon-search" id="personnelBaseArchivesManageSearch" onclick="queryListsearch()">查询</a>
			    	</span>
			    	<span>
			    		<a href="#" class="easyui-linkbutton" plain="true" icon="icon-reload " id="personnelBaseArchivesManageRedo" onclick="searchReset('queryList')">重置</a>
			    	</span>
		    	</div>
		    </div>
		</div>
	 </div>
	
	<script type="text/javascript">
		//导入
		function ImportXls() {
			openuploadwin('Excel导入', 'dbQueryUserController.do?upload',
					"queryList");
		}

		//导出
		function ExportXls() {
			JeecgExcelExport("dbQueryUserController.do?exportXls", "queryList");
		}

		//模板下载
		function ExportXlsByT() {
			JeecgExcelExport("dbQueryUserController.do?exportXlsByT",
					"queryList");
		}

		//新增
		function add(title, url, id) {
			window.location.href = url
		}
		//修改
		function update(title, url, id) {
			var rowsData = $('#' + id).datagrid('getSelections');
			if (!rowsData || rowsData.length == 0) {
				layer.alert('请选中一条数据');
				return;
			}
			/* if(rowsData[0].bpmStatus != 1){
				layer.alert('<t:mutiLang langKey="只有状态为<待提交>时才可进行<修改>操作"/>');
				return;
			} */
			if (rowsData[0].bpmStatus == 2) {
				layer.alert('<t:mutiLang langKey="申请处理中不可编辑"/>');
				return;
			} else if (rowsData[0].bpmStatus == 3) {
				layer.alert('<t:mutiLang langKey="申请已完成不可编辑"/>');
				return;
			}
			/* if(rowsData[0].applicantId != $("#user").val()){
				layer.alert('您无权限操作该数据!');
				return;
			} */
			updateNotCreateWin("修改", url, "queryList", false);
		}
		//查看
		function view(title, url, id) {
			viewNotCreateWin("查看", url, "queryList", false)
		}
		//新增
		function goview(title, url, id) {
			var rowsData = $('#' + id).datagrid('getSelections');
			if (!rowsData || rowsData.length == 0) {
				layer.alert('请选中一条数据');
				return;
			}

			window.location.href = url + '&id=' + rowsData[0].id + '&typeid='
					+ rowsData[0].transferType;
		}

		function openDepartmentSelect() {
			$.dialog.setting.zIndex = getzIndex();
			var orgIds = $("#orgIds").val();

			// 查询所有组织结构
			$
					.dialog(
							{
								content : 'url:departController.do?departSelect&orgIds='
										+ orgIds,
								zIndex : getzIndex(),
								title : '所属部门列表',
								lock : true,
								width : '400px',
								height : '350px',
								opacity : 0.4,
								button : [
										{
											name : '<t:mutiLang langKey="common.confirm"/>',
											callback : callbackDepartmentSelect,
											focus : true
										},
										{
											name : '<t:mutiLang langKey="common.cancel"/>',
											callback : function() {
											}
										} ]
							}).zindex();
		}

		function callbackDepartmentSelect() {
			// 查询所有组织结构
			var iframe = this.iframe.contentWindow;
			var treeObj = iframe.$.fn.zTree.getZTreeObj("departSelect");
			var nodes = treeObj.getCheckedNodes(true);
			if (nodes.length > 0) {
				var ids = '', names = '';
				for (i = 0; i < nodes.length; i++) {
					var node = nodes[i];
					ids += node.id + ',';
					names += node.name + ',';
				}
				$('#departname').val(names);
				$('#departname').blur();
				$('#orgIds').val(ids);
			}
		}

		function callbackClean() {
			$('#departname').val('');
			$('#orgIds').val('');
		}
	</script>