var myChart = echarts.init(document.getElementById('attendanceStatsChar'),'walden'); var myChart2 = echarts.init(document.getElementById('attendanceStatsChar2'),'walden'); option = { color: ['#3398DB'], tooltip: { trigger: 'axis' }, grid:{ left: '3%', right: '4%', bottom: '1%', containLabel: true }, legend: { data:[], width:'90%', left:'center' }, xAxis: { type: 'category', data: [], axisLabel: { interval: 0, formatter:function(value) { var ret = "";//拼接加\n返回的类目项 var maxLength = 1;//每项显示文字个数 var valLength = value.length;//X轴类目项的文字个数 var rowN = Math.ceil(valLength / maxLength); //类目项需要换行的行数 if (rowN > 1)//如果类目项的文字大于3, { for (var i = 0; i < rowN; i++) { var temp = "";//每次截取的字符串 var start = i * maxLength;//开始截取的位置 var end = start + maxLength;//结束截取的位置 //这里也可以加一个是否是最后一行的判断,但是不加也没有影响,那就不加吧 temp = value.substring(start, end) + "\n"; ret += temp; //凭借最终的字符串 } return ret; } else { return value; } } } }, yAxis: [ { type: 'value', name:'工资支出总金额(元)' } ], dataZoom: [ { type: 'inside', start: 0, end: 100 } ], series: [ { name:'', type:'bar', data:[] } ] }; option2 = { color: ['#3398DB'], tooltip: { trigger: 'axis' }, grid:{ left: '3%', right: '4%', bottom: '1%', containLabel: true }, legend: { data:[], width:'90%', left:'center' }, xAxis: { type: 'category', data: ['1月','2月','3月','4月','5月','6月','7月','8月','9月','10月','11月','12月',], axisLabel: { interval: 0, formatter:function(value) { var ret = "";//拼接加\n返回的类目项 var maxLength = 1;//每项显示文字个数 var valLength = value.length;//X轴类目项的文字个数 var rowN = Math.ceil(valLength / maxLength); //类目项需要换行的行数 if (rowN > 1)//如果类目项的文字大于3, { for (var i = 0; i < rowN; i++) { var temp = "";//每次截取的字符串 var start = i * maxLength;//开始截取的位置 var end = start + maxLength;//结束截取的位置 //这里也可以加一个是否是最后一行的判断,但是不加也没有影响,那就不加吧 temp = value.substring(start, end) + "\n"; ret += temp; //凭借最终的字符串 } return ret; } else { return value; } } } }, yAxis: [ { type: 'value', name:'工资支出总金额(元)' } ], dataZoom: [ { type: 'inside', start: 0, end: 100 } ], series: [ { name:'', type:'bar', data:[] } ] }; $(function() { $(document).ready(function() { attendanceStatssearch(); }); }); function attendanceStatssearch(){ handleAjaxSimple("wageStatsController.do?wageStatsData", $("#attendanceStatsForm").serialize(), handleSuccess); } function handleSuccess(data){ if(data.cdata.noData){ $(".content").hide(); $("#uptb").hide(); $("#upbg").hide(); $("#upexport").hide(); $(".err-info").show(); }else{ $(".content").show(); $(".err-info").hide(); //$("#upBtn").show(); $("#uptb").show(); $("#upbg").show(); var srcstr = $("#uptb").attr("src"); if(srcstr.indexOf("tb1.png") < 0){ $("#upexport").show(); } var rolefalg = $("#roleFlag").val(); var prostr; if(rolefalg == 1){ prostr = '项目'; }else{ prostr = '部门'; } var charheadStr; var attType = $("#attType").val(); if(attType == 0 ){ charheadStr =$("#curYear").val()+"年"+$("#attMonth").val()+"月各"+prostr+"工资费用"; }else if(attType == 1){ var attQuarters = $("#attQuarters").val(); if(attQuarters == 1){ charheadStr = $("#curYear").val()+"年一季度(01月-03月)各"+prostr+"工资费用"; }else if(attQuarters == 2){ charheadStr = $("#curYear").val()+"年二季度(04月-06月)各"+prostr+"工资费用"; }else if(attQuarters == 3){ charheadStr = $("#curYear").val()+"年三季度(07月-09月)各"+prostr+"工资费用"; }else { charheadStr = $("#curYear").val()+"年四季度(10月-12月)各"+prostr+"工资费用"; } }else if(attType == 2){ charheadStr = $("#curYear").val()+"年度各"+prostr+"工资费用"; } $("#upcharheaddiv").html(charheadStr); initCharDate(data.cdata); initNdateList(data.tdata); } } function initNdateList(data){ var rolefalg = $("#roleFlag").val(); var pjNamestr; var pidNamestr; if(rolefalg == 1){ pjNamestr = '项目名称'; pidNamestr='项目经理'; }else{ pjNamestr = '项目名称'; pidNamestr='部门名称'; } var attType = $("#attType").val(); var peopleTotalStr; if(attType == 0 ){ peopleTotalStr="当月工资总人数"; }else{ peopleTotalStr="每月工资平均人数"; } var colums = [[ {field:'pName',title:pjNamestr,width:150}, {field:'pidName',title:pidNamestr,width:150}, {field:'peopleTotal',title:peopleTotalStr,width:150 ,align:'right',halign:'center' }, {field:'wagePayTotal',title:'工资支出总金额(元)',width:150 ,align:'right',halign:'center'} ]] $('#attendanceStatsTable').datagrid({ singleSelect : true, loadMsg:'数据加载中,请稍后……', columns:colums, rownumbers:true, fitColumns:true }).datagrid('loadData',data); } function initCharDate(data){ myChart.clear(); option.xAxis.data = data.xAxisData; option.series = data.series; myChart.setOption(option); myChart.resize(); } function showTabel(){ $("#attendanceStatsChar").hide(); $("#tablediv").show(); $("#upexport").show(); $("#uptb").attr("src","images/tb.png"); $("#upbg").attr("src","images/bg1.png"); //$("#attendanceStatsTable").datagrid("resize"); var h=$(".content").height(); $('#attendanceStatsTable').datagrid('resize', { height :h-50 }); } function showChar(){ $("#tablediv").hide(); $("#attendanceStatsChar").show(); $("#upexport").hide(); $("#uptb").attr("src","images/tb1.png"); $("#upbg").attr("src","images/bg.png"); myChart.resize(); } myChart.on('click', function (params) { console.log(params); var rolefalg = $("#roleFlag").val(); var attType = $("#attType").val(); if(rolefalg == 1){ $("#downcharheaddiv").html(params.name + "-"+$("#curYear").val()+"年01月~"+$("#curYear").val()+"年12月工资费用趋势变化"); $("#upcharheaddiv2").html($("#curYear").val()+"年度项目工资费用"); if(attType == 2){ var data ={ "attYear" : $("#curYear").val(), "pid":params.data.id }; handleAjaxSimple("wageStatsController.do?wageYearInto", data, showDownChar); } }else{ $("#downcharheaddiv").html($("#pid").find("option:selected").text()+"-"+$("#curYear").val()+"年"+$("#attMonth").val()+"月"+params.name+"人员工资费用"); if(attType == 0){ var data = { "attYear" : $("#curYear").val(), "attMonth" : $("#attMonth").val(), "pid":$("#pid").val(), "did":params.data.id } handleAjaxSimple("wageStatsController.do?wageMonthInto", data, showDownChar); } } }) function goBefore(){ $("#attendanceStatsChar2").css("display","none"); $("#tablediv2").hide(); $("#searchColums").show(); $("#downcharhead").hide(); $("#attendanceStatsChar").show(); $("#upcharhead").show(); $("#upcharhead2").hide(); $("#upBtn").show(); $("#downBtn").hide(); $("#downexport").hide(); $("#downtb").attr("src","images/tb1.png"); $("#downbg").attr("src","images/bg.png"); myChart.resize(); } //显示下钻图表 function showDownChar(data){ $("#attendanceStatsChar").css("display","none"); $("#attendanceStatsChar2").show(); $("#upBtn").hide(); $("#downBtn").show(); $("#searchColums").hide(); $("#downcharhead").show(); $("#upcharhead").hide(); $("#upcharhead2").show(); $("#yearspan2").html($("#curYear").val()); initDownCharDate(data.cdata); initDownTabDate(data.tdata); } function initDownCharDate(data){ myChart2.clear(); option2.xAxis.data = data.xAxisData; option2.series = data.series; myChart2.setOption(option2); myChart2.resize(); } function initDownTabDate(data){ var attType = $("#attType").val(); var peopleTotalStr; if(attType == 0 ){ peopleTotalStr="当月工资总人数"; }else{ peopleTotalStr="每月工资平均人数"; } var rolefalg = $("#roleFlag").val(); var pjNamestr; var pidNamestr; var userNameField; var colums ; if(rolefalg == 1){ colums = [[ {field:'yearMonth',title:'日期范围',width:150}, {field:'pName',title:'项目名称',width:150}, {field:'pidName',title:'项目经理',width:150}, {field:'peopleTotal',title:peopleTotalStr,width:150 ,align:'right',halign:'center' }, {field:'wagePayTotal',title:'工资支出总金额(元)',width:150 ,align:'right',halign:'center' } ]] }else{ colums = [[ {field:'pName',title:'项目名称',width:150}, {field:'pidName',title:'部门名称',width:150}, {field:'userName',title:'员工姓名',width:150}, {field:'wagePayTotal',title:'工资支出总金额(元)',width:150} ]] } $('#attendanceStatsTable2').datagrid({ singleSelect : true, loadMsg:'数据加载中,请稍后……', columns:colums, rownumbers:true, fitColumns:true }).datagrid('loadData',data); } function showDownTabelBtn(){ $("#attendanceStatsChar2").hide(); $("#tablediv2").show(); $("#downexport").show(); $("#downtb").attr("src","images/tb.png"); $("#downbg").attr("src","images/bg1.png"); //$("#attendanceStatsTable2").datagrid("resize"); var h=$(".content").height(); $('#attendanceStatsTable2').datagrid('resize', { height :h-50 }); } function showDownCharBtn(){ $("#tablediv2").hide(); $("#downexport").hide(); $("#downtb").attr("src","images/tb1.png"); $("#downbg").attr("src","images/bg.png"); $("#attendanceStatsChar2").show(); myChart2.resize(); } function exportExcel(flag){ var opts; if(flag == 1){ opts = $('#attendanceStatsTable').datagrid('getColumnFields'); //这是获取到所有的FIELD }else{ opts = $('#attendanceStatsTable2').datagrid('getColumnFields'); //这是获取到所有的FIELD } var exceltitles=[]; for(i=0;i'; $("#export").html(formdom); $("#formdom").submit(); }