2025-11-27 16:55:35 +08:00
|
|
|
|
var proName = localStorage.getItem("proName");
|
|
|
|
|
|
$(function() {
|
|
|
|
|
|
findCompany(); //公司
|
|
|
|
|
|
findPro();//工程
|
|
|
|
|
|
$("#proId option:contains('"+proName+"')").attr("selected", true).trigger("change");
|
|
|
|
|
|
$("#isPay").val("1");
|
|
|
|
|
|
initTable();
|
|
|
|
|
|
})
|
|
|
|
|
|
|
|
|
|
|
|
function responseHandler(res) {
|
|
|
|
|
|
var datas=[];
|
|
|
|
|
|
datas.push({total:res.total,rows:res.list});
|
|
|
|
|
|
return datas[0];
|
|
|
|
|
|
}
|
|
|
|
|
|
function initTable() {
|
|
|
|
|
|
index = top.layer.load(0, {
|
|
|
|
|
|
shade: false
|
|
|
|
|
|
}); // 0代表加载的风格，支持0-2
|
|
|
|
|
|
//初始化Table
|
|
|
|
|
|
$("#table").bootstrapTable({
|
|
|
|
|
|
classes: 'table table-hover',
|
2025-12-09 18:44:29 +08:00
|
|
|
|
url: smz_web_url + 'salary/getSalaryInfo',
|
2025-11-27 16:55:35 +08:00
|
|
|
|
method: 'post',
|
|
|
|
|
|
responseHandler: responseHandler, //处理服务器返回的数据格式
|
|
|
|
|
|
height: $(window).height() - ($(window).height() * 0.13),
|
|
|
|
|
|
undefinedText: '', //当数据为 undefined 时显示的字符
|
|
|
|
|
|
queryParams: function(param) {
|
|
|
|
|
|
param = {
|
|
|
|
|
|
orgId: $("#orgId").val(),
|
|
|
|
|
|
proId: $("#proId").val(),
|
|
|
|
|
|
isPay:$("#isPay").val(),
|
|
|
|
|
|
keyWord: $("#keyWord").val(),
|
|
|
|
|
|
pageSize: param.limit,
|
|
|
|
|
|
pageNum: param.offset / param.limit + 1,
|
|
|
|
|
|
sort: param.sort, //排序列名
|
|
|
|
|
|
sortOrder: param.order //排位命令（desc，asc）
|
|
|
|
|
|
}
|
|
|
|
|
|
return param;
|
|
|
|
|
|
},
|
|
|
|
|
|
sortable: true, //是否启用排序
|
|
|
|
|
|
sortOrder: "asc", //排序方式
|
|
|
|
|
|
cache: false, //是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）
|
|
|
|
|
|
pagination: true,
|
|
|
|
|
|
pageNumber: 1,
|
|
|
|
|
|
pageSize: 50,
|
|
|
|
|
|
pageList: [50, 100, 200, 300],
|
|
|
|
|
|
smartDisplay: false,
|
|
|
|
|
|
showColumns: false,
|
|
|
|
|
|
sidePagination: "server", //分页方式：client客户端分页，server服务端分页（*）
|
|
|
|
|
|
contentType: "application/x-www-form-urlencoded",
|
|
|
|
|
|
minimumCountColumns: 2, //最少允许的列数
|
|
|
|
|
|
uniqueId: "no", //每一行的唯一标识，一般为主键列
|
|
|
|
|
|
columns: [{
|
|
|
|
|
|
title: '序号',
|
|
|
|
|
|
formatter: function(value, row, index) {
|
|
|
|
|
|
return index + 1;
|
|
|
|
|
|
},
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
width: 50
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '公司',
|
|
|
|
|
|
field: 'orgName',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 150
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '工程名称',
|
|
|
|
|
|
field: 'proName',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 200
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '姓名',
|
|
|
|
|
|
field: 'name',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 100
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '身份证',
|
|
|
|
|
|
field: 'idNumber',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 230
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '银行卡号',
|
|
|
|
|
|
field: 'bankNumber',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 100
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '银行名称',
|
|
|
|
|
|
field: 'bankName',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 100
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '支行名称',
|
|
|
|
|
|
field: 'bankBrank',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 200
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '应发金额',
|
|
|
|
|
|
field: 'payinAmount',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 100
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '实发金额',
|
|
|
|
|
|
field: 'payableAmount',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 130
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '发放日期',
|
|
|
|
|
|
field: 'payDate',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 130
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '发放工资年月',
|
|
|
|
|
|
field: 'payMonth',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 150
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '是否补发',
|
|
|
|
|
|
field: 'isReissue',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '考勤结算量',
|
|
|
|
|
|
field: 'workDays',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '财务确认标志',
|
|
|
|
|
|
field: 'financeSure',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 130
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '个人核对标志',
|
|
|
|
|
|
field: 'personSure',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 150
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '提交批次号',
|
|
|
|
|
|
field: 'submitNo',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '代发代扣编号',
|
|
|
|
|
|
field: 'bankHandleno',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 150
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '发放状态',
|
|
|
|
|
|
field: '',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120,
|
|
|
|
|
|
cellStyle:function (value, row, index) {
|
|
|
|
|
|
if(row.isPay=="提交成功" || row.isPay=="发放成功"){
|
|
|
|
|
|
return {css:{'color':'greenyellow'}};
|
|
|
|
|
|
}else if(row.isPay=="未提交" || row.isPay=="提交失败" || row.isPay=="发放失败" || row.isPay=="无效数据" || row.isPay=="异常数据" || row.isPay=="异常,未知状态"){
|
|
|
|
|
|
return {css:{'color':'red'}};
|
|
|
|
|
|
}else{
|
|
|
|
|
|
return {css:{'color':'orange'}};
|
|
|
|
|
|
}
|
|
|
|
|
|
return '';
|
|
|
|
|
|
}//更具条件修改某行样式
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '工资册名称',
|
|
|
|
|
|
field: '',
|
|
|
|
|
|
formatter: function(value, row, index) {
|
|
|
|
|
|
var html="<a href='#' onclick='exportBtn(\""+row.salaryId+"\")'>"+row.salaryName+".xls</a>";
|
|
|
|
|
|
return html;
|
|
|
|
|
|
},
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120
|
|
|
|
|
|
},
|
|
|
|
|
|
{
|
|
|
|
|
|
title: '备注',
|
|
|
|
|
|
field: 'remark',
|
|
|
|
|
|
rowspan: 1,
|
|
|
|
|
|
align: 'center',
|
|
|
|
|
|
valign: 'middle',
|
|
|
|
|
|
sortable: true,
|
|
|
|
|
|
width: 120
|
|
|
|
|
|
}
|
|
|
|
|
|
],
|
|
|
|
|
|
onLoadSuccess: function(data) {
|
|
|
|
|
|
$("#dataCount").html("数量：" + data.total);
|
|
|
|
|
|
top.layer.close(index);
|
|
|
|
|
|
},
|
|
|
|
|
|
onLoadError: function() {
|
|
|
|
|
|
$("#dataCount").html("数量:0");
|
|
|
|
|
|
$("#table").bootstrapTable('removeAll');
|
|
|
|
|
|
top.layer.close(index);
|
|
|
|
|
|
}
|
|
|
|
|
|
});
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
var index;
|
|
|
|
|
|
// 模糊查询数据、重置查询
|
|
|
|
|
|
function query(type) {
|
|
|
|
|
|
index = top.layer.load(0, {
|
|
|
|
|
|
shade: false
|
|
|
|
|
|
}); // 0代表加载的风格，支持0-2
|
|
|
|
|
|
if (type == 1) {
|
|
|
|
|
|
var keyWord = $("#keyWord").val();
|
|
|
|
|
|
var orgId = $("#orgId").val();
|
|
|
|
|
|
var proId = $("#proId").val();
|
|
|
|
|
|
var isPay=$("#isPay").val();
|
|
|
|
|
|
$("#query").css("background-image", "url(../../img/info/queryClick.png)");
|
|
|
|
|
|
$("#reset").css("background-image", "url(../../img/info/resetQuery.png)");
|
|
|
|
|
|
$("#export").css("background-image", "url(../../img/info/export.png)");
|
|
|
|
|
|
var opt = {
|
2025-12-09 18:44:29 +08:00
|
|
|
|
url: smz_web_url + 'salary/getSalaryInfo',
|
2025-11-27 16:55:35 +08:00
|
|
|
|
silent: true,
|
|
|
|
|
|
query: {
|
|
|
|
|
|
orgId: orgId,
|
|
|
|
|
|
proId: proId,
|
|
|
|
|
|
isPay:isPay,
|
|
|
|
|
|
keyWord: keyWord,
|
|
|
|
|
|
}
|
|
|
|
|
|
};
|
|
|
|
|
|
$("#table").bootstrapTable('refresh', opt);
|
|
|
|
|
|
}else if (type == 2) {
|
|
|
|
|
|
$("#query").css("background-image", "url(../../img/info/query.png)");
|
|
|
|
|
|
$("#reset").css("background-image", "url(../../img/info/resetQueryClick.png)");
|
|
|
|
|
|
$("#export").css("background-image", "url(../../img/info/export.png)");
|
|
|
|
|
|
$("#keyWord").val("");
|
|
|
|
|
|
findCompany(); //分公司
|
|
|
|
|
|
findPro();//工程
|
|
|
|
|
|
$("#proId option:contains('"+proName+"')").attr("selected", true).trigger("change");
|
|
|
|
|
|
$("#isPay").val("1");
|
|
|
|
|
|
var keyWord = $("#keyWord").val();
|
|
|
|
|
|
var orgId = $("#selOrg").val();
|
|
|
|
|
|
var proId = $("#selPro").val();
|
|
|
|
|
|
var isPay=$("#isPay").val();
|
|
|
|
|
|
var opt = {
|
2025-12-09 18:44:29 +08:00
|
|
|
|
url: smz_web_url + 'salary/getSalaryInfo',
|
2025-11-27 16:55:35 +08:00
|
|
|
|
silent: true,
|
|
|
|
|
|
query: {
|
|
|
|
|
|
orgId: orgId,
|
|
|
|
|
|
proId: proId,
|
|
|
|
|
|
keyWord: keyWord
|
|
|
|
|
|
}
|
|
|
|
|
|
};
|
|
|
|
|
|
}
|
|
|
|
|
|
$("#table").bootstrapTable('refresh', opt);
|
|
|
|
|
|
initTable();
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
function exportBtn(salaryId) {
|
|
|
|
|
|
$("#query").css("background-image", "url(../../img/info/query.png)");
|
|
|
|
|
|
$("#reset").css("background-image", "url(../../img/info/resetQuery.png)");
|
|
|
|
|
|
$("#export").css("background-image", "url(../../img/info/exportClick.png)");
|
|
|
|
|
|
var keyWord = $("#keyWord").val();
|
|
|
|
|
|
var orgId = $("#orgId").val();
|
|
|
|
|
|
var proId = $("#proId").val();
|
|
|
|
|
|
var isPay=$("#isPay").val();
|
2025-12-09 18:44:29 +08:00
|
|
|
|
window.location.href = smz_web_url + "salary/exportSalary?keyWord=" + keyWord + "&orgId=" + orgId + "&proId=" + proId+ "&salaryId=" + salaryId+ "&isPay=" + isPay + "&x-auth-token=" + token;
|
2025-11-27 16:55:35 +08:00
|
|
|
|
}
|
