zhaozhiqiang
/
YH_Web_UI


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
							<!DOCTYPE html>
<html>

	<head>
		<meta charset="UTF-8">
		<title>单位信息</title>
		<meta name="viewport" content="width=device-width, initial-scale=1.0">
		<script src="../Script/Common/huayi.load.js"></script>
		<script src="../Script/Common/huayi.config.js"></script>
		<link href="../js/bootstrap-select/css/bootstrap-select.css" rel="stylesheet" />
		<link href="../css/Table/table1.css" rel="stylesheet" />
		<link href="../css/init.css" rel="stylesheet" />
		<link href="./css/onlineServiceList.css" rel="stylesheet" />
	</head>

	<body class="gray-bg">
		<div class="daoHang clearfix">
			<div class="dhLeft">
				<sapn><i class="syIcon"></i>位置：
					<a id="ReIndex" href="javaScript:;" class="indexreturn">首页</a>&gt;
					<a href="javaScript:;">在线客服</a>&gt;
					<a href="javascript:location.reload()" class="now_position">统计报表</a>
				</sapn>
			</div>
		</div>
		<div class="wrapper wrapper-content animated fadeInRight equp_management">
			<div class="th-box">
				<div class="form-inline th-bar clearfix">
					<div class="form-group time-box">
						<i class="tub fa fa-calendar"></i>
						<input class="form-control search_time" type="text" id="startTime" placeholder="请选择时间范围">
					</div>
					<div class="form-group tool_bars pull-right">
						<input type="button" class="btn_gray" id="btn_export" value="导出" onclick="btn_export()" />
						<input type="button" class="btn_gray" id="btn_search" value="搜索" onclick="btn_search()" />
					</div>
				</div>
			</div>
			<div class="tab_contents" id="tab_contents">
				<div class="tabs_details showtabs">
					<table id="table_all" data-row-style="rowStyle" data-query-params="queryParams">
						<thead>
							<tr>
								<th data-field="zxusercoude" data-align="center">客服账号</th>
								<th data-field="yyghcount" data-align="center">预约挂号</th>
								<th data-field="Tjcount" data-align="center">体检</th>
								<th data-field="Zpcount" data-align="center">招聘</th>
								<th data-field="bqdhcount" data-align="center">病情、电话</th>
								<th data-field="xgymcount" data-align="center">核酸检测新冠疫苗</th>
								<th data-field="sbsjcount" data-align="center">上班时间</th>
								<th data-field="ybcount" data-align="center">医保</th>
								<th data-field="wnrhcount" data-align="center">无内容</th>
								<th data-field="allcount" data-align="center">总数</th>
							</tr>
						</thead>
					</table>
				</div>
			</div>
		</div>
	</body>
	<script src="../Script/Common/regexs.js"></script>
	<script src="../js/laydate/laydate.js"></script>
	<!--<script src="../Script/Common/regexs.js"></script>-->
	<script src="../js/autosize/autosize.min.js"></script>
	<script src="../js/bootstrap-select/js/bootstrap-select.js"></script>
	<script src="../js/bootstrap-select/js/i18n/defaults-zh_CN.js"></script>
	<script type="text/javascript">
		var showdatas=[]
		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();
		}

		function btn_search() {
			initTable();
		}

		function initTable() {
			var $tableLeft = $('#table_all');
			$tableLeft.bootstrapTable('destroy');
			//先销毁表格
			$tableLeft.bootstrapTable({
				method: "get", //使用get请求到服务器获取数据
				url: huayi.config.callcenter_url + "testusertypeapi/api/TestUserType/getonlinesertype",
				contentType: "application/x-www-form-urlencoded",
				striped: true, //表格显示条纹
				pagination: false, //启动分页
				pageSize: 500, //每页显示的记录数
				pageNumber: 1, //当前第几页
				fixedColumns: true,
				fixedNumber: 3,
				pageList: [500, 1000, 1500], //记录数可选列表
				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 = {
						stime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[0], //开始时间
						etime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[1], //结束时间
					};
					return param;
				},
				responseHandler: function(data) {
					var data = data.data
					var yyghcount = data.reduce((sum, e) => sum + parseInt(e.yyghcount), 0)
					var Tjcount = data.reduce((sum, e) => sum + parseInt(e.Tjcount), 0)
					var Zpcount = data.reduce((sum, e) => sum + parseInt(e.Zpcount), 0)
					var bqdhcount = data.reduce((sum, e) => sum + parseInt(e.bqdhcount), 0)
					var xgymcount = data.reduce((sum, e) => sum + parseInt(e.xgymcount), 0)
					var sbsjcount = data.reduce((sum, e) => sum + parseInt(e.sbsjcount), 0)
					var ybcount = data.reduce((sum, e) => sum + parseInt(e.ybcount), 0)
					var wnrhcount = data.reduce((sum, e) => sum + parseInt(e.wnrhcount), 0)
					var newhzdata = [{
						zxusercoude: '合计',
						yyghcount: yyghcount,
						Tjcount: Tjcount,
						Zpcount: Zpcount,
						bqdhcount: bqdhcount,
						xgymcount: xgymcount,
						sbsjcount: sbsjcount,
						ybcount: ybcount,
						wnrhcount: wnrhcount,
						allcount: yyghcount + Tjcount + Zpcount + bqdhcount + xgymcount + sbsjcount + ybcount + wnrhcount
					}]

					data = data.concat(newhzdata)
					showdatas=data
					return {
						"rows": data //数据
					};
				},
				onLoadSuccess: function(data) { //加载成功时执行

				},
				onLoadError: function() { //加载失败时执行
					layer.msg("加载数据失败", {
						time: 1500,
						icon: 2
					});
				}
			});
		}

		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;
		}
		//导出
		function btn_export() {
			//要导出的json数据
			const jsonData = showdatas
			console.log(jsonData)
			//列标题，逗号隔开，每一个逗号就是隔开一个单元格
			var str = `客服账号,预约挂号,体检,招聘,病情、电话,核酸检测新冠疫苗,上班时间,医保,无内容,总数\n`;
			//增加\t为了不让表格显示科学计数法或者其他格式
			for(let i = 0; i < jsonData.length; i++) {

				for(let item in jsonData[i]) {
					str += `${jsonData[i][item] + '\t'},`;
				}
				str += '\n';
			}
			//encodeURIComponent解决中文乱码
			let uri = 'data:text/csv/xls;charset=utf-8,\ufeff' + encodeURIComponent(str);
			//通过创建a标签实现
			let link = document.createElement("a");
			link.href = uri;
			//对下载的文件命名
			link.download = "统计报表.xls";
			document.body.appendChild(link);
			link.click();
			document.body.removeChild(link);
		}
	</script>

</html>