meidu2021/daju/WebRoot/webpage/cn/com/lzt/dbquery/queryByCertList.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,autocomplete"></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?queryByCertDatagrid"
			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="320"></t:dgCol>
			<t:dgCol title="项目在职人数" field="total" query="false" sortable="false"
				queryMode="single" width="220"></t:dgCol>
			
			<t:dgCol title="证书" field="certId" queryMode="single" query="true" hidden="true" dictionary="t_bus_certificate_subsidy,id,certificate_name, and delete_flag='0'" 
				width="220"></t:dgCol>
			<t:dgCol title="" field="certName" queryMode="single" hidden="true"
				width="220"></t:dgCol>
				<t:dgCol title="持有证书人数" field="certCount" 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>
	<span style="display:-moz-inline-box;display:inline-block;" id="entryNameSearch">
<span style="vertical-align:middle;display:-moz-inline-box;display:inline-block;width: 90px;text-align:right;text-overflow:ellipsis;-o-text-overflow:ellipsis; overflow: hidden;white-space:nowrap; " title="项目名称">项目名称：</span>
 <t:autocomplete entityName="TSDepart" name="departname"
				 searchField="glcname" labelField="glcname" valueField="glcname" hiddenInputId="glcname" width="150"
				 groupBy="glcname"
				 scrollWidth="400" scrollHeight="400"></t:autocomplete>
</span>
	<script>
		$(document).ready(function(){
			$('#queryListForm').append($('#entryNameSearch'));
		});

		var _gridId='queryList';
		//     $(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" style="width: 74px;"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								员工姓名: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value"> -->
	<!-- 						     <input id="realname" name="realname" type="text" style="width: 157px; " class="inputxt" placeholder="请输入员工姓名"> -->
	<!-- 						</td> -->

	<!-- 						<td align="right" style="width: 74px;"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								申请状态: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value"> -->
	<%-- 						     <t:dictSelect field="bpmStatus" type="select" typeGroupCode="bpm_status" hasLabel="false" title="申请状态" ></t:dictSelect>  --%>
	<!-- 						</td> -->

	<!-- 						<td align="right" style="width: 74px;"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								所属单位: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value" colspan="3"> -->
	<!-- 							<input readonly="true" type="text" id="departname" name="departname" style="width: 157px" placeholder="请选择所属单位" onclick="openDepartmentSelect()"> -->
	<!-- 							<input id="orgIds" name="orgIds" type="hidden" value=""> -->
	<!-- 							<a href="#" class="easyui-linkbutton" plain="true" icon="icon-select" id="departSearch" onclick="openDepartmentSelect()">选择</a> -->
	<!-- 							<a href="#" class="easyui-linkbutton" plain="true" icon="icon-clean" id="departRedo" onclick="callbackClean()">清空</a> -->
	<!-- 						</td> -->
	<!-- 					</tr> -->
	<!-- 					<tr> -->
	<!-- 						<td align="right"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								申请日期: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value" colspan="3"> -->
	<!-- 						      <input id="applyDate_begin" name="applyDate_begin" type="text" style="width: 150px"  class="Wdate"  -->
	<!-- 								onclick="WdatePicker({dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'applyDate_end\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/>~ -->
	<!-- 							 <input id="applyDate_end" name="applyDate_end" type="text" style="width: 150px"  class="Wdate"   -->
	<!-- 								onclick="WdatePicker({dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'applyDate_begin\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/> -->
	<!-- 						</td> -->
	<!-- 						<td align="right"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								离职日期: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value"> -->
	<!-- 						    <input id="leaveDate_begin" name="leaveDate_begin" type="text" style="width: 150px"  class="Wdate"  -->
	<!-- 								onclick="WdatePicker({dateFmt:'yyyy-MM-dd',maxDate:'#F{$dp.$D(\'leaveDate_end\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/>~ -->
	<!-- 						     <input id="leaveDate_end" name="leaveDate_end" type="text" style="width: 150px"  class="Wdate"   -->
	<!-- 								onclick="WdatePicker({dateFmt:'yyyy-MM-dd',minDate:'#F{$dp.$D(\'leaveDate_begin\')}'})" readonly="readonly" placeholder="yyyy-MM-dd"/> -->
	<!-- 						</td> -->
	<!-- 						<td align="right" style="width: 74px;"> -->
	<!-- 							<label class="Validform_label"> -->
	<!-- 								离职类型: -->
	<!-- 							</label> -->
	<!-- 						</td> -->
	<!-- 						<td class="value"> -->
	<%-- 						     <t:dictSelect field="leaveType" type="select" typeGroupCode="outType" hasLabel="false" title="离职类型" ></t:dictSelect>  --%>
	<!-- 						</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 src = "webpage/cn/com/lzt/leave/queryList.js"></script>		 -->
	<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>