meidu2021/daju/WebRoot/webpage/cn/com/lzt/userwage/userWageViewList.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="userWageList" pagination="false"  checkbox="false" fitColumns="false" title="月度工资一览" actionUrl="userWageController.do?datagrid1" idField="id" fit="true" queryMode="group">
   <t:dgCol title="主键"  field="id"  hidden="true"  sortable="false" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="员工id" hidden="true" field="userid" sortable="false" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="所属单位"  sortable="false" frozenColumn="true" field="belongUnitname" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="所属单位id" align="center" sortable="false" hidden="true" field="belongUnitid" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="人数" style="text-align:right," sortable="false" frozenColumn="true" field="sumcount"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="工资月度" align="center" sortable="false" frozenColumn="true" query="false" field="monthly" queryMode="single" width="120"></t:dgCol>
   <t:dgCol title="基本工资（元）" style="text-align:right," sortable="false" field="basicWage"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="职务津贴（元）" style="text-align:right," sortable="false" field="dutiesAllowance"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="补贴项（元）" style="text-align:right," sortable="false" field="certificateSubsidy"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="餐补（元）" style="text-align:right," sortable="false" field="mealsSubsidy"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="加班费（元）" style="text-align:right," sortable="false" field="specialOvertime"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="项目绩效（元）" style="text-align:right," sortable="false" field="projectPerformance"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="考勤扣（元）" style="text-align:right," sortable="false" field="absenceDebit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="代扣款（元）" style="text-align:right," sortable="false" field="daikouDebit" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="其他扣除（元）" style="text-align:right," sortable="false" field="otherDebit" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="缴金补贴（元）" style="text-align:right," sortable="false" field="paymentSubsidy" queryMode="single"  width="120"></t:dgCol>
    <t:dgCol title="补发调整（元）" style="text-align:right," sortable="false" field="reissue" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="应发工资（元）" style="text-align:right," sortable="false" field="preTaxMone"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="扣税金额（元）" style="text-align:right," sortable="false" field="taxMoney" queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="实发金额（元）" style="text-align:right," sortable="false" field="actualMoney"  queryMode="single"  width="120"></t:dgCol>
    <t:dgCol title="缴金扣除（元）" style="text-align:right," sortable="false" field="deductions" queryMode="single"  width="120"></t:dgCol>
    <t:dgCol title="企业缴金（元）" style="text-align:right," sortable="false" field="comDeductions" queryMode="single"  width="120"></t:dgCol>
 <t:dgCol title="企业成本（元）" style="text-align:right," sortable="false" field="comCost" queryMode="single"  width="120"></t:dgCol>
   <t:dgToolBar title="明细" icon="icon-detail" url="userWageController.do?goview" funname="goview"></t:dgToolBar>
   <t:dgToolBar title="导出一览表"  icon="icon-putout" operationCode="putout"  funname="ExportXls"></t:dgToolBar>
   <t:dgToolBar title="导出全部明细"  icon="icon-putout" operationCode="putout"  funname="ExportXlsAllDetail"></t:dgToolBar>
   <t:dgToolBar title="导出项目明细"  icon="icon-putout" operationCode="putout"  funname="ExportXlsDetailByProject"></t:dgToolBar>
  </t:datagrid>
  	</div>
   <script>
    $(function() {
        var datagrid = $("#userWageListtb");
        datagrid.prepend($("#pinjie1 div[name='pinjie2']").html());
        $("#pinjie1").html('');
        
        
        datagrid.children(".datagrid-toolbar").children("span:first").after($("#pinjiechaxun1 div[name='pinjiechaxun2']").html());
        $("#pinjiechaxun1").html('');
	});
  </script>
  <div id="pinjie1">
	    <div name="pinjie2"  style="padding:3px; height: auto" class="datagrid-toolbar">
	    <div name="searchColums" style="margin:23px 0 18px 0;">
         <table style="padding:0px" cellpadding="0" cellspacing="1" >
				<tbody>
					<tr>
						<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>
						<td align="right" style="width: 74px;">
							<label class="Validform_label">
							<span color="red" class="requiredIcon">*</span>
								工资月度:
							</label>
						</td>
						<td class="value">
							 <input class="Wdate" id="monthlys" name="monthlys" style="width: 157px; height: 28px;border-radius: 3px;" onClick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: 'yyyy-MM'})"/>
						</td>
					</tr>
				</tbody>
			</table>
			</div>
	    </div>
	</div>
	
	<div id="pinjiechaxun1">
	    <div name="pinjiechaxun2"  style="padding:3px; height: auto" class="datagrid-toolbar">
	    	<span style="float:right;margin-bottom:4px;">
	    		<span>
		    		<a href="#" class="easyui-linkbutton" plain="true" icon="icon-search" id="personnelBaseArchivesManageSearch" onclick="userWageListsearch()">查询</a>
		    	</span>
		    	<span>
		    		<a href="#" class="easyui-linkbutton" plain="true" icon="icon-reload " id="personnelBaseArchivesManageRedo" onclick="searchReset('userWageList')">重置</a>
		    	</span>
	    	</div>
	    </div>
	</div>
 </div>
 <script src = "webpage/cn/com/lzt/userwage/userWageList.js"></script>		
 <script type="text/javascript">
 
 $(function(){
	 isCss();
 });
 
 function isCss(){
 	$("td[field='preTaxMone']").css({"background":"#d65653"});
	$("td[field='preTaxMone']").css({"color":"#ffffff"});
	$("td[field='actualMoney']").css({"background":"#d65653"});
	$("td[field='actualMoney']").css({"color":"#ffffff"});
	$("td[field='comCost']").css({"background":"#d65653"});
	$("td[field='comCost']").css({"color":"#ffffff"});
 }
 
//导入
function ImportXls() {
	openuploadwin('Excel导入', 'userWageController.do?upload', "userWageList");
}

//导出
function ExportXls() {
	var monthlys = $("#monthlys").val();
	if(monthlys ==null||monthlys ==''){
		layer.alert('请选择工资月度');
		return false;
	}
	JeecgExcelExport("userWageController.do?exportXls1","userWageList");
}



//导出
function ExportXlsAllDetail(title,url,id) {
	 var monthlys = $("#monthlys").val();
	if(monthlys ==null||monthlys ==''){
		layer.alert('请选择工资月度');
		return false;
	}
	
	//JeecgExcelExport("userWageController.do?exportXlsDetailByProject"+"&monthly="+monthlys,"userWageList");
	var datagridId = "userWageList";
	var queryParams = $('#'+datagridId).datagrid('options').queryParams;
	$('#'+datagridId+'tb').find('*').each(function() {
	    queryParams[$(this).attr('name')] = $(this).val();
	});
	var params = '&';
	$.each(queryParams, function(key, val){
		params+='&'+key+'='+val;
	}); 
	var fields = '&field=';
	$.each($('#'+ datagridId).datagrid('options').columns[0], function(i, val){
		if(val.field != 'opt'){
			fields+=val.field+',';
		}
	});
    var id='&id=';
    layer.msg('数据导出中，请稍候···', {
        time : 16000,
        shade: 0.1});

	window.location.href = "userWageController.do?exportXlsDetailByProject"+"&monthly="+monthlys+ encodeURI(fields+params+id);
}

//导出
function ExportXlsDetailByProject(title,url,id) {
	/* var monthlys = $("#monthlys").val();
	if(monthlys ==null||monthlys ==''){
		layer.alert('请选择工资月度');
		return false;
	} */
	var rowsData = $('#'+id).datagrid('getSelections');
	if (!rowsData || rowsData.length==0) {
		layer.alert('请选择一条数据');
		return;
	}
	JeecgExcelExport("userWageController.do?exportXlsDetailByProject&orgId="+rowsData[0].belongUnitid+'&monthly='+rowsData[0].monthly,"userWageList");
}



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


	//新增
	function add(title,url,id){
		window.location.href=url
	}
	//修改
	function update(title,url, id){
		updateNotCreateWin("修改",url, "userWageList",false);
	}
	//查看
	function view(title,url, id){
	  viewNotCreateWin("查看",url, "userWageList",false)
	}
	
	//新增
	function goview(title,url,id){
		var rowsData = $('#'+id).datagrid('getSelections');
		if (!rowsData || rowsData.length==0) {
			layer.alert('请选择一条数据');
			return;
		}
		var type = '';
		if(rowsData[0].belongUnitname == '其他管理层'){
			type = 1;
		}else{
			type = 2;
		}
		window.location.href=url+'&id='+rowsData[0].belongUnitid+'&monthly='+rowsData[0].monthly+'&type='+type;
	//addOneTab('项目月度工资明细', url+'&belongUnitname='+rowsData[0].belongUnitname+'&id='+rowsData[0].belongUnitid+'&monthly='+rowsData[0].monthly+'&type='+type);
}
	//选择项目名称,列表================
	function openDepartmentSelect() {
		//$.dialog.setting.zIndex = getzIndex(); 
		var orgIds = $("#belongUnitid").val();
		$.dialog({
			content: 'url:userWageController.do?projectDepartTableAll&ids='+orgIds, zIndex:  getzIndex(), title: '项目名称列表', lock: true, width: '600px', height: '350px', opacity: 0.4, button: [
		   {name: '<t:mutiLang langKey="common.confirm"/>', callback: function (){
			   var iframe = this.iframe.contentWindow;
	  	    	if(iframe.getReason().length>0){
	  	    		var strData=eval(iframe.getReason());
	  	    		for(var key in strData[0]){
		    			if(key=="strPId"){
		    				$("#orgIds").val(strData[0][key]);
		    			}else if(key=="strDepartName"){
		    				$("#departname").val(strData[0][key]);
		    			}
		    		}
	  	    	}
		   }, focus: true},
		   {name: '<t:mutiLang langKey="common.cancel"/>', callback: function (){}}
		   
	   ]}).zindex();
	}

	function callbackClean(){
		$('#departname').val('');
		$('#orgIds').val('');	
	}
	
	function userWageListsearch() {
		try {
			if (!$("#userWageListForm").Validform({
				tiptype : 3
			}).check()) {
				return false;
			}
		} catch (e) {
		}
		if (true) {
			var queryParams = $('#userWageList').datagrid('options').queryParams;
			$('#userWageListtb').find('*').each(function() {
				queryParams[$(this).attr('name')] = $(this).val();
			});
			
			if(queryParams.monthlys ==null||queryParams.monthlys ==''){
				layer.alert('请选择工资月度！');
				return false;
			}
			
			$('#userWageList')
					.datagrid(
							{
								url : 'userWageController.do?datagrid1&field=id,userid,belongUnitname,belongUnitid,sumcount,monthly,basicWage,dutiesAllowance,certificateSubsidy,mealsSubsidy,specialOvertime,projectPerformance,absenceDebit,paymentSubsidy,daikouDebit,otherDebit,reissue,preTaxMone,deductions,comDeductions,comCost,taxMoney,actualMoney,',
								pageNumber : 1
							});
			isCss();
		}
	}
 </script>