YH_Web_UI/WebUI/CallCenterWe.../equipmentOpe.../js/equipmentRep...

$(document).ready(function() {
	//时间
	laydate.render({
		elem: '#startTime',
		range: '~',
		theme: '#249fea'
	});
	//显示时间
	if ($('#startTime').val() == "") {
		function p(s) {
			return s < 10 ? '0' + s : s;
		}
		var currentYear = new Date().getFullYear();
		var currentMonth = new Date().getMonth() + 1;
		var currentDate = new Date().getDate();
		var prevCurrentYear = 0;
		var prevCurrentMonth = 0;
		if (currentMonth == 1) {
			prevCurrentYear = currentYear - 1;
			prevCurrentMonth = 12;
		} else {
			prevCurrentYear = currentYear;
			prevCurrentMonth = currentMonth - 1;
		}

		var current = currentYear + "-" + p(currentMonth) + "-" + p(currentDate);
		// var lastmonth = prevCurrentYear + "-" + p(prevCurrentMonth) + "-" + p(currentDate)
		var a = getPreDatetime(3600 * 1000 * 24 * 30);
		$('#startTime').val(getPreDatetime(3600 * 1000 * 24 * 30) + " ~ " + current)
		initTable()
	}

	//获取所有科室信息
	$.getJSON(huayi.config.callcenter_url + 'testusertypeapi/api/TestUserType/getalldeptnlists', {
		name: $("#Qdepartment").val()
	}, function(res) {
		if (res.state == "success") {
			QdepartmentList = res.data;
			getQdepartment($("#Qdepartment"));
			$('#Qdepartment').selectpicker('refresh');
		}
	})
	//搜索
	$("#sc_btns").click(function() {
		initTable();
	})
	//导出
	$('#HY_export').click(function() {
		var deptname=$("#Qdepartment").val();
		var stime=$('#startTime').val() && $('#startTime').val().split(' ~ ')[0];
		var etime=$('#startTime').val() && $('#startTime').val().split(' ~ ')[1];
		if(deptname==undefined){
			deptname='';
		}
		if(stime==undefined){
			stime='';
		}
		if(etime==undefined){
			etime='';
		}
		window.location.href=huayi.config.callcenter_url + "testusertypeapi/api/TestUserType/excelsbtplist?deptnames=" + deptname+
		"&stime=" + stime+"&etime="+etime;
	})
})
//初始化表格
function initTable() {
	var $tableLeft = $('#tables');
	$tableLeft.bootstrapTable('destroy');
	//初始化表格,动态从服务器加载数据
	$tableLeft.bootstrapTable({
		method: "get", //使用get请求到服务器获取数据
		url: huayi.config.callcenter_url + "testusertypeapi/api/TestUserType/getexcelsbtplist",
//		url: huayi.config.callcenter_url + "testusertypeapi/api/TestUserType/getequipmentmanagementlist",
		striped: true, //表格显示条纹
		pagination: false, //启动分页
		pageSize: 10, //每页显示的记录数
		pageNumber: 1, //当前第几页
		fixedColumns: true,
		fixedNumber: 3,
		pageList: [5, 10, 20, 50, 100], //记录数可选列表
		search: false, //是否启用查询
		showColumns: false, //显示下拉框勾选要显示的列
		showRefresh: false, //显示刷新按钮
		sidePagination: "server", //表示服务端请求
		//设置为undefined可以获取pageNumber，pageSize，searchText，sortName，sortOrder
		//设置为limit可以获取limit, offset, search, sort, order
		queryParamsType: "undefined",
		queryParams: function queryParams(params) { //设置查询参数
			console.log(params)
			var param = {
				deptnames: $("#Qdepartment").val(),
				stime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[0], //开始时间
				etime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[1], //结束时间
			};
			return param;
		},
		responseHandler: function(res) {
			//格式化数据
			for(var i=0;i<res.data.length;i++){
		           len=res.data.length
			}
			hzdata =res.data
			var allcount = hzdata.reduce((sum, e) => sum + parseInt(e.allcount), 0) //总台数
			var alltimeleth = hzdata.reduce((sum, e) => sum + parseInt(e.alltimeleth), 0)//总时长
			var allprice = hzdata.reduce((sum, e) => sum + parseInt(e.allprice), 0)//总金额
			var newhzdata = [{
				deptname: '合计',
				allcount:allcount, //随访总数
				alltimeleth: alltimeleth,
				allprice: allprice
			}]
			if(hzdata.length>0){
				showdatas = hzdata.concat(newhzdata)
			}else{
				showdatas=[]
			}
			return {
				"rows": showdatas //数据
			};
		},
		onLoadSuccess: function(data) { //加载成功时执行
//			var newDataL = {};
//			newDataL.state = data.state;
//			newDataL.message = data.message;
//			newDataL.rows = data.data;
//			$tableLeft.bootstrapTable('load', newDataL);
//			$('.tool_downs').authorizeOperateButton();
		},
		onLoadError: function() { //加载失败时执行
			layer.msg("加载数据失败", {
				time: 1500,
				icon: 2
			});
		}
	});
}

//获取科室名
function getQdepartment(obj) {
	obj.empty();
	obj.append('<option value="">请选择科室</option>');
	$(QdepartmentList).each(function(i, n) {
		obj.append('<option value="' + n.name + '">' + n.name + '</option>');
	})
}
//显示时间
function getPreDatetime(pdate) {
	var start = new Date()
	start.setTime(start.getTime() - pdate)
	start.getYear(); // 获取当前年份(2位)
	var YY = start.getFullYear() // 获取完整的年份(4位,1970-????)
	var MM = start.getMonth() + 1 // 获取当前月份(0-11,0代表1月)
	MM = MM > 9 ? MM : ('0' + MM);
	var DD = start.getDate() // 获取当前日(1-31)
	DD = DD > 9 ? DD : ('0' + DD)
	var lastmonth = YY + '-' + MM + '-' + DD;
	return lastmonth;
}