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', url: smz_web_url + 'salary/getSalaryInfo', 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=""+row.salaryName+".xls"; 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 = { url: smz_web_url + 'salary/getSalaryInfo', 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 = { url: smz_web_url + 'salary/getSalaryInfo', 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(); window.location.href = smz_web_url + "salary/exportSalary?keyWord=" + keyWord + "&orgId=" + orgId + "&proId=" + proId+ "&salaryId=" + salaryId+ "&isPay=" + isPay + "&x-auth-token=" + token; }