meidu2021/daju/WebRoot/webpage/cn/com/lzt/userwage/managerWageDetailsList.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@include file="/context/mytags.jsp"%>
<link rel="stylesheet" type="text/css" href="css/commoncss.css"/>
<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"  pageSize="20"  checkbox="false" fitColumns="false" title="员工月度工资明细" actionUrl="userNewWageController.do?datagrid_manager_detail" idField="id" fit="true" queryMode="group">
   <t:dgCol title="主键"  field="id"  hidden="true"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="员工id" hidden="true" field="userid"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="员工工号"  sortable="false" frozenColumn="true" query="false" field="username"  queryMode="single"  width="80"></t:dgCol>
   <t:dgCol title="员工姓名" sortable="false" frozenColumn="true" query="false" field="realname"  queryMode="single"  width="80"></t:dgCol>
   <t:dgCol title="所属单位" sortable="false" frozenColumn="true" field="belongUnitName" queryMode="single"  width="220"></t:dgCol>
    <t:dgCol title="(旧)应发金额" style="text-align:right," frozenColumn="true" sortable="false" field="oldPreTaxMoney"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="(旧)实发金额" style="text-align:right," frozenColumn="true" sortable="false" field="oldActualMoney"  queryMode="single"  width="120"></t:dgCol>
       <t:dgCol title="应发金额" style="text-align:right," frozenColumn="true"  sortable="false" field="preTaxMone"  queryMode="single"  width="120"></t:dgCol>
 <t:dgCol title="实发金额" style="text-align:right," frozenColumn="true"  sortable="false" field="actualMoney"  queryMode="single"  width="120"></t:dgCol>
  
  <%--  <t:dgCol title="职务层级" align="center" sortable="false" field="pduname"  queryMode="single"  width="120"></t:dgCol> --%>
   <t:dgCol title="身份证号" align="center" sortable="false" field="pduname"  queryMode="single"  width="160"></t:dgCol>
   <t:dgCol title="职务" sortable="false" field="duname"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="开户银行" sortable="false" field="belongBank" query="false" queryMode="single"  width="80"></t:dgCol>
   <t:dgCol title="工资卡号" sortable="false" field="cardNumber"  queryMode="single"  width="170"></t:dgCol>
    <t:dgCol title="缴金单位" sortable="false" field="socialSecurityUnit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="工资月度" align="center" sortable="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="postAllowance"  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="dutieslevelAllowance"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="人才津贴" style="text-align:right," sortable="false" field="talentAllowance"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="司龄津贴" style="text-align:right," sortable="false" field="comyearAllowance"  queryMode="single"  width="120"></t:dgCol>
      <t:dgCol title="其它工作补贴" style="text-align:right," sortable="false" field="otherworkSubsidy"  queryMode="single"  width="120"></t:dgCol>
    <t:dgCol title="主管项目工资" style="text-align:right," sortable="false" field="xianchangBonus"  queryMode="single"  width="120"></t:dgCol>
    <t:dgCol title="监管项目工资" style="text-align:right," sortable="false" field="jianguanBonus"  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="certificateSubsidy"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="交通补贴" style="text-align:right," sortable="false" field="trafficSubsidy"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="高温补贴" style="text-align:right," sortable="false" field="megathermalSubsidy"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="独生子女费" style="text-align:right," sortable="false" field="onlyChildCost" queryMode="single"  width="120"></t:dgCol>
<%--    <t:dgCol title="其他补贴" style="text-align:right," sortable="false" field="otherSubsidy" queryMode="single"  width="120"></t:dgCol> --%>
   <t:dgCol title="奖金" style="text-align:right," sortable="false" field="bonus"  queryMode="single" width="120"></t:dgCol>
   <t:dgCol title="处罚扣除" style="text-align:right," sortable="false" field="fakuan"  queryMode="single" width="120"></t:dgCol>
   <t:dgCol title="餐补白班津贴" style="text-align:right," sortable="false" field="mealsSubsidyDay"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="餐补夜班津贴" style="text-align:right," sortable="false" field="mealsSubsidyNight"  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="overtimepayTimeout"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="国定加班费" style="text-align:right," sortable="false" field="overtimepayFixed"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="值班费" style="text-align:right," sortable="false" field="duty"  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="sickLeaveDebit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="事假扣" style="text-align:right," sortable="false" field="thingLeaveDebit"  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="socialSecurityDebit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="公积金扣除" style="text-align:right," sortable="false" field="providentFundDebit"  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="comSocialSecurityDebit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="企业公积金" style="text-align:right," sortable="false" field="comProvidentFundDebit"  queryMode="single"  width="120"></t:dgCol>
   <t:dgCol title="企业成本合计" style="text-align:right," sortable="false" field="comCost"  queryMode="single"  width="120"></t:dgCol>
  
   <t:dgCol title="备注说明" sortable="false" field="remark" extendParams="editor:'text'" queryMode="single"  width="400"></t:dgCol>
   <t:dgToolBar  title="核算所有经理工资"  icon="icon-calculation" url="userNewWagePayrollController.do?projectManagerPayroll" funname="allManagerPayroll"></t:dgToolBar>
   <t:dgToolBar  title="核算单个经理工资"  icon="icon-calculation" url="userNewWagePayrollController.do?userPayroll" funname="userPayroll"></t:dgToolBar>
  
<%--    <t:dgToolBar  title="修改" icon="icon-edit" operationCode="edit"   funname="editRow"></t:dgToolBar> --%>
<%--    <t:dgToolBar title="保存" icon="icon-save" url="userNewWageController.do?saveRows" funname="saveData"></t:dgToolBar> --%>
<%--    <t:dgToolBar title="取消编辑" icon="icon-cancel1" funname="reject"></t:dgToolBar> --%>
<%--    <t:dgToolBar title="确认" url="userNewWageController.do?updateStatus" icon="icon-confirm"  funname="updateStatus"></t:dgToolBar> --%>
   <t:dgToolBar title="导出" icon="icon-put" operationCode="put"  funname="ExportXls"></t:dgToolBar>
  </t:datagrid>
	<script>
    $(function() {
        var datagrid = $("#userWageListtb");
        datagrid.children("div:first").before($("#pinjie1 div[name='pinjie11']").html());
//         datagrid.children("div:first").after($("#pinjie2 div[name='pinjie21']").html());
//         datagrid.children(".datagrid-toolbar").children("span:first").after($("#pinjie2 div[name='pinjie21']").html());
// 		datagrid.append($("#pinjie2 div[name='pinjie21']").html());	
        $("#pinjie12").next("div").attr("style","border-bottom-width:0;height:auto;");
        $("#pinjie12").next("div").attr("class","datagrid-toolbar");
        datagrid.children(".datagrid-toolbar").children("span:first").after($("#pinjie2 div[name='pinjie21']").html());
        $("#pinjie1").html('');
        $("#pinjie2").html('');
        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"});
    }
  </script>
  <div id="pinjie1" style="display: none;">
	    <div name="pinjie11">
	    <div id="pinjie12" style="margin:23px 0 18px 0;" >
		<table style="padding:0px;width: 100%;" cellpadding="0" cellspacing="1" border='0'>
				<tbody >
					<tr>
						<td align="right" style="width: 74px;">
							<label class="Validform_label">
								员工姓名:
							</label>
						</td>
						<td class="value" style="width: 74px;">
						     <input id="realname" name="realname" type="text" style="width: 120px; " class="inputxt" placeholder="">
						</td>
						
						
						<td align="right" style="width: 74px;">
							<label class="Validform_label">
								开户银行:
							</label>
						</td>
						<td class="value" style="width: 74px;">
						     <input id="belongBank" name="belongBank" type="text" style="width: 120px; " class="inputxt" placeholder="">
						</td>
						<td align="right" style="width: 74px;">
							<label class="Validform_label">
							<span color="red" class="requiredIcon">*</span>
								工资月度:
							</label>
						</td>
						<td class="value" style="width: 74px;">
							 <input class="Wdate"  name="monthlys" style="width: 120px;height: 28px; border-radius: 3px;" onClick="WdatePicker({readOnly:true,enableKeyboard:false,enableInputMask:false,dateFmt: 'yyyy-MM'})"/>
						</td>
						<td align="right" style="width: 74px;">
							<label class="Validform_label">
								项目名称:
							</label>
						</td>
						<td class="value" >
							<input readonly="true" type="text" id="departname" name="departname" style="width: 120px" 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 colspan="10"></td>
						<td >
					    	<span>
					    		<a href="#" style="float: right;" class="easyui-linkbutton" plain="true" icon="icon-reload " id="personnelBaseArchivesManageRedo" onclick="searchReset('userWageList')">重置</a>
					    	</span>
							<span>
					    		<a href="#" style="float: right;" class="easyui-linkbutton" plain="true" icon="icon-search" id="personnelBaseArchivesManageSearch" onclick="userWageListsearch()">查询</a>
					    	</span>
						</td>
					</tr> -->
				</tbody>
			</table>
		</div>
	    </div>
	</div>
	
	<div id="pinjie2" style="display: none;">
		<div  name="pinjie21">
			<span style="float:right;margin-bottom:4px;">
				<a href="#" style="float: right;" class="easyui-linkbutton" plain="true" icon="icon-reload " id="personnelBaseArchivesManageRedo" onclick="searchReset('userWageList')">重置</a>&nbsp;&nbsp;&nbsp;
				<a href="#" style="float: right;" class="easyui-linkbutton" plain="true" icon="icon-search" id="personnelBaseArchivesManageSearch" onclick="userWageListsearch()">查询</a>
			</span>
		</div>
	</div>
	
	</div> 
 </div>
 <script src = "webpage/cn/com/lzt/userwage/userWageList.js"></script>		
 <script type="text/javascript">
 
 function allManagerPayroll(title,addurl,gname){
		var result = "";
		var date = $(".Wdate").val();
		if(date == null || date == ""){
			layer.alert("请选择工资月度");
			return;
		}
	    layer.msg('工资计算中，请稍候···', {
	        time : 30000,
	        shade: 0.1});
	 $.ajax({
			url:"<%=basePath%>/"+addurl,
			type:"post",
			data:{ids:result,status:true,moth:date},
			dataType:"json",
			success:function(data){
				tip(data.msg);
				userWageListsearch();
				//layer.alert(data.msg);
				//tip(data.msg);
			}
		});
 }
//核算单个
	function userPayroll(title,addurl,gname){
		var rows=$('#'+gname).datagrid("getChecked");
		var date = $(".Wdate").val();
		var pid = $("#orgIds").val();
		var monthly = $("#monthlys").val();
		var realname = $("#realname").val();
		var belongBank = $("#belongBank").val();
		if(rows.length==0){
			layer.alert("请选择需要重新核算工资的员工!");
			//tip("请选择需要重新核算工资的员工!");
			return;
		}
		var result = "";
		for(var i=0;i<rows.length;i++){
			if(rows[i].status == '2'){
				layer.alert("员工【"+rows[i].realname+"】的工资已确认，不可再点击核算");
				//tip("员工【"+rows[i].realname+"】的工资已确认，不可再点击核算");
				return;
			}
			if(rows[i].duname == ''){
				layer.alert("员工【"+rows[i].realname+"】没有职务，请先设定职务");
				//tip("员工【"+rows[i].realname+"】的工资已确认，不可再点击核算");
				return;
			}
			result += rows[i].userid+",";
		}
		
		$.ajax({
			url:"<%=basePath%>/"+addurl,
			type:"post",
			data:{ids:result,status:true,moth:date},
			dataType:"json",
			success:function(data){
				tip(data.msg);
				userWageListsearch();
				//layer.alert(data.msg);
				//tip(data.msg);
			}
		});
	}
//手动核算员工选择
	function userPayrollBySelectUser(){
		//项目id
		var pid = $("#orgIds").val();
		var monthly = $("#monthlys").val();
		
//		var date = new Date();
//		var day = date.getDate();
	
//		if(day> 1 && day <6){
//			layer.alert("每月2日~5日为考勤和工资核算期, 不能手工核算工资");
//			return false;
//		}
		
		$.dialog({content: 'url:userPayrollController.do?personnelBaseArchivesManageSelectList&pid='+pid, zIndex:  getzIndex(), title: '员工选择', lock: true, width: '650px', height: '400px', 
				opacity: 0.4, button: [
		   {name: '<t:mutiLang langKey="common.confirm"/>', callback: function (){
	   	    	//var postGeneralId=$("#id").val();
	   	    	//父页面接子页面传值
	   	    	
	   	    	//获得子页面getReason()方法中的值
	   	    	var iframe = this.iframe.contentWindow;
	   	    	var userid=""; 
	   	    	if(iframe.getReason().length>0){
	   	    		var strData=eval(iframe.getReason());
	   	    		for(var key in strData[0]){
		    			if(key=="strUserId"){
		    				userid = strData[0][key];
		    			}
		    		}
	   	    		$.ajax({
		 				url:"userPayrollController.do?userPayrollByUserId",
		 				async:true,
		 				type:"post",
		 				data: {
		 					userid : userid,
		 					pid : pid,
		 					monthly : monthly
		 					},
		 				cache : false,
		 				success:function(aj){
		 					data=JSON.parse(aj);
							if (data.success) {
//								layer.alert("手动核算完成");
								var refreshURL= 'userNewWageController.do?goview&orgid='+pid+'&monthly='+'${monthly}';
								 		
								layer.msg('手动核算完成', {
									time: 2000, //2s后自动关闭
								     btn: ['确定']
								     ,yes: function(index, layero){
								    	 window.location.href=refreshURL;
								     }
								});
								//刷新表格数据
					 			//refresh();
						 		window.location.href=refreshURL;
							} else {
								layer.alert(data.msg);
							}
		 				}
		 			});
	   	    	}
	   	    	
	   	    },  focus: true},
		   {name: '<t:mutiLang langKey="common.cancel"/>', callback: function (){}}
	   ]}).zindex();
	}
	//保存数据
	function saveData(title,addurl,gname){
		if(!endEdit(gname))
			return false;
		var rows=$('#'+gname).datagrid("getChanges","inserted");
		var uprows=$('#'+gname).datagrid("getChanges","updated");
		rows=rows.concat(uprows);
		if(rows.length<=0){
			layer.alert("没有需要保存的数据！");
			//tip("没有需要保存的数据！");
			return false;
		}
		var result={};
		for(var i=0;i<rows.length;i++){
			for(var d in rows[i]){
				result["userWageList["+i+"]."+d]=rows[i][d];
			}
		}
		$.ajax({
			url:"<%=basePath%>/"+addurl,
			type:"post",
			data:result,
			dataType:"json",
			success:function(data){
				tip(data.msg);
				reloadTable();
			}
		})
	}
	//结束编辑
	function endEdit(gname){
		var  editIndex = $('#'+gname).datagrid('getRows').length-1;
		for(var i=0;i<=editIndex;i++){
			if($('#'+gname).datagrid('validateRow', i))
				$('#'+gname).datagrid('endEdit', i);
			else
				return false;
		}
		return true;
	}
	//编辑行
	function editRow(title,addurl,gname){
		var rows=$('#'+gname).datagrid("getChecked");
		if(rows.length==0){
			layer.alert("请选择条目");
			//tip("请选择条目");
			return false;
		}
		for(var i=0;i<rows.length;i++){
			var index= $('#'+gname).datagrid('getRowIndex', rows[i]);
			$('#'+gname).datagrid('beginEdit', index);
		}
	}
	//update-begin--Author:张忠亮  Date:20150709 for：修正 取消编辑后再次点击录入不进入编辑状态
	//取消编辑
	function reject(title,addurl,gname){
		$('#'+gname).datagrid('clearChecked');
		$('#'+gname).datagrid('rejectChanges');
	}
 
	function returnGopage(){
		window.location.href="userNewWageController.do?listView";
	}
//导入
function ImportXls() {
	openuploadwin('Excel导入', 'userNewWageController.do?upload', "userWageList");
}

//导出
function ExportXls() {
	JeecgExcelExport("userNewWageController.do?exportManagerNewWageDetailXls","userWageList");
}

//模板下载
function ExportXlsByT() {
	JeecgExcelExport("userNewWageController.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 openDepartmentSelect() {
		//$.dialog.setting.zIndex = getzIndex(); 
		var orgIds = $("#belongUnitid").val();
		$.dialog({
			content: 'url:userNewWageController.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;
			}
			var orgIds = $("#belongUnitid").val();
// 			if(orgIds ==null||orgIds ==''){
// 				layer.alert('请选择项目');
// 				return false;
// 			}
			
			$('#userWageList')
					.datagrid(
							{
								url : 'userNewWageController.do?datagrid_manager_detail&field=id,userid,username,realname,belongUnitName,pduname,duname,belongBank,socialSecurityUnit,cardNumber,monthly,basicWage,postAllowance,dutiesAllowance,dutieslevelAllowance,talentAllowance,comyearAllowance,otherworkSubsidy,xianchangBonus,jianguanBonus,certificateSubsidy,trafficSubsidy,megathermalSubsidy,onlyChildCost,otherSubsidy,bonus,fakuan,projectPerformance,mealsSubsidyDay,mealsSubsidyNight,mealsSubsidy,overtimepayTimeout,overtimepayFixed,duty,specialOvertime,sickLeaveDebit,thingLeaveDebit,absenceDebit,paymentSubsidy,socialSecurityDebit,providentFundDebit,comSocialSecurityDebit,comProvidentFundDebit,comCost,daikouDebit,otherDebit,reissue,preTaxMone,taxMoney,actualMoney,oldPreTaxMoney,oldActualMoney,remark,',
								pageNumber : 1
							});
		}
	}
 </script>