var f_State = '住院患者' var $tableLeft = '' $(function() { getdept() initTable() var t, n, count = 0; t = setInterval("showAuto()", 1000 * 60); $("#sc_btns").click(function() { initTable() }) //时间 laydate.render({ elem: '#startTime', range: '~', theme: '#249fea' }); 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; } 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(); } //TAB切换 $('#tab_head_left li').click(function() { $(this).addClass('tab_head_active').siblings().removeClass('tab_head_active'); state = $(this).attr('data-index'); f_State = state initTable(); }) }) function getdept() { $("#deptname").html(''); equipmentdata = [] $("#deptname").append(''); $.ajax({ type: "get", url: huayi.config.callcenter_url + "testusertypeapi/api/Test/gethzcyksinfo", async: true, dataType: 'json', success: function(data) { var leveldata = [] if(data.state.toLowerCase() == 'success') { console.log(data) leveldata = data.data $(leveldata).each(function(q, p) { $("").appendTo("#deptname"); $("#deptname").selectpicker('refresh'); }); } else { $("#deptname").empty(); $("#deptname").selectpicker('refresh'); } } }); } function initTable() { $tableLeft = $('#table_all'); $tableLeft.bootstrapTable('destroy'); //先销毁表格 $tableLeft.bootstrapTable({ method: "get", //使用get请求到服务器获取数据 url: huayi.config.callcenter_url + "testusertypeapi/api/Test/getsendhfinfo", contentType: "application/x-www-form-urlencoded", striped: true, //表格显示条纹 pagination: true, //启动分页 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 = { PageIndex: params.pageNumber, PageSize: params.pageSize, iszyormz: f_State, key: $("#key").val(), yqinfo: $("#projectid").val(), sendmydcent: $("#myd").val(), deptname: $("#deptname").val(), state: $("#state").val(), stime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[0], //开始时间 etime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[1], //结束时间 }; return param; }, onPostBody: function() { //console.log("行数据渲染完成!"); var totalPages = $tableLeft.bootstrapTable("getOptions").totalPages; var pageNumber = $tableLeft.bootstrapTable("getOptions").pageNumber; var goInputWidth = 45; //输入框默认宽度 var maxLen = ("" + totalPages).length; //根据总页数设定跳转页面输入框宽度 if(totalPages > 999) goInputWidth = maxLen * 10 + 15; var $pageGo = $('跳转到/' + totalPages + '页 '); var $go = $("Go"); var $shou = $("首页") var $wei = $("尾页") $pageGo.append($go); $pageGo.append($shou); $pageGo.append($wei); $(".pagination-detail").append($pageGo); //页码范围限定(部分浏览器min~max失效时) $pageGo.change(function() { var goPage = $('#c_jump-to-page').val(); if(goPage < 1) $('#c_jump-to-page').val(1); if(goPage > totalPages) $('#c_jump-to-page').val(totalPages); }); //跳转到 $go.click(function() { var goPage = parseInt($('#c_jump-to-page').val()); console.log(totalPages) if(goPage != pageNumber) $tableLeft.bootstrapTable('selectPage', parseInt(goPage)); }); $shou.click(function() { $tableLeft.bootstrapTable('selectPage', 1); }); $wei.click(function() { $tableLeft.bootstrapTable('selectPage', totalPages); }); }, onLoadSuccess: function(data) { //加载成功时执行 //判断 住院患者和门诊患者展示信息 if(f_State == '住院患者') { $tableLeft.bootstrapTable('showColumn', 'ZY_NO'); //显示 // $tableLeft.bootstrapTable('showColumn', 'NAME');//显示 // $tableLeft.bootstrapTable('showColumn', 'SEX');//显示 // $tableLeft.bootstrapTable('showColumn', 'PAT_PHONE');//显示 $tableLeft.bootstrapTable('showColumn', 'ZY_AGE'); //显示 $tableLeft.bootstrapTable('showColumn', 'CY_ZD'); //显示 $tableLeft.bootstrapTable('showColumn', 'CY_DEPT_NAME'); //显示 $tableLeft.bootstrapTable('showColumn', 'CY_DATE'); //显示 $tableLeft.bootstrapTable('showColumn', 'ZY_DAYS'); //显示 $tableLeft.bootstrapTable('showColumn', 'PA_ADDRESS'); //显示 $tableLeft.bootstrapTable('showColumn', 'ZY_DEPT_NAME'); //显示 // $tableLeft.bootstrapTable('hideColumn', 'chinic_no');//隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'patient_name');//隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'sex');//隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'phone');//隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'JB_NAME'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'mzjzdeptname'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'mzjztime'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'ZZ_DOC'); //隐藏上述variablevalue列 } else { $tableLeft.bootstrapTable('showColumn', 'ZY_AGE'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'ZY_NO'); //隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'NAME');//隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'SEX');//隐藏上述variablevalue列 // $tableLeft.bootstrapTable('hideColumn', 'PAT_PHONE');//隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'CY_ZD'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'CY_DEPT_NAME'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'CY_DATE'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'ZY_DEPT_NAME'); //隐藏上述variablevalue列 $tableLeft.bootstrapTable('hideColumn', 'ZY_DAYS'); //显示 $tableLeft.bootstrapTable('hideColumn', 'PA_ADDRESS'); //显示 // $tableLeft.bootstrapTable('showColumn', 'chinic_no');// 显示 // $tableLeft.bootstrapTable('showColumn', 'patient_name');// 显示 // $tableLeft.bootstrapTable('showColumn', 'sex');// 显示 // $tableLeft.bootstrapTable('showColumn', 'phone');// 显示 $tableLeft.bootstrapTable('showColumn', 'JB_NAME'); // 显示 $tableLeft.bootstrapTable('showColumn', 'mzjzdeptname'); // 显示 $tableLeft.bootstrapTable('showColumn', 'mzjztime'); // 显示 $tableLeft.bootstrapTable('showColumn', 'ZZ_DOC'); // 显示 } var newDataL = {}; newDataL.state = data.state; newDataL.message = data.message; newDataL.rows = data.data.rows; newDataL.total = data.data.total; for(var i = 0; i < newDataL.rows.length; i++) { if(newDataL.rows[i].PAT_PHONE == null) { newDataL.rows[i].PAT_PHONE = ''; } } $tableLeft.bootstrapTable('load', newDataL); $('.tool_downs').authorizeOperateButton(); }, onLoadError: function() { //加载失败时执行 layer.msg("加载数据失败", { time: 1500, icon: 2 }); } }); } $(function() { projectName() }) // 院区选择 function projectName() { $("#projectid").empty(); $("#projectid").append(""); $.getJSON(huayi.config.callcenter_url + "equipmentapi/api/ProjectInfo/getlistdrop", function(result) { if(result.state.toLowerCase() == "success") { var content = result.data; $(content).each(function(i, n) { $("").appendTo("#projectid"); }) $("#projectid").selectpicker('refresh'); } }) } //格式化操作 function formatterOperate(val, row) { console.log(row.PAT_PHONE) if(f_State == "门诊患者") { { var str = ''; return str } } else { { var str = ''; return str } } } // // 外呼 function callout(val, row) { if(val == '') { var str = '
' + val + '
'; return str; } else { var str = '
' + val + '' + '
' return str } } //外呼 function callPhone(val) { console.log('号码',val) if(val) { $.ajax({ type: "get", url: huayi.config.call_url + "CallOutOpt/GetCallOutprefix", async: true, dataType: 'json', data: { phone: val }, success: function(result) { //result = $.parseJSON(result); if(result.state.toLowerCase() == "success") { top.scoketDatas = { "Type": "MakeCall", "AgentID": window.localStorage.getItem('userCode'), "AgentExten": window.localStorage.getItem("extno"), "Header": result.data.fix, //号码前缀 用于截断前缀得到真实号码 "DestinationNumber": result.data.phone, // }; top.Send(); } } }); } } function btn_myd(sendmyeds) { layer.open({ type: 2, content: "./myd.html?sendmyeds=" + sendmyeds, title: '修改满意度', area: ['50%', '45%'], //宽高 }); } function btn_detail(detail_id) { layer.open({ type: 2, content: "./afterDischargeDetail.html?detail_id=" + detail_id, title: '出院患者记录详细信息', area: ['50%', '65%'], //宽高 }); } function btn_callDetail(phone){ layer.open({ type: 2, content: "./afterDischargeCallDetail.html?detail_phone=" + phone, title: '出院患者记录详细信息', area: ['50%', '65%'], //宽高 }); } // 备注 function btn_remark(remark_id) { layer.open({ type: 2, content: "./remark.html?remark_id=" + remark_id, title: '备注', area: ['50%', '65%'], //宽高 }); } //获取短信回复内容 function sendmsg() { $.ajax({ type: "get", url: huayi.config.callcenter_url + "testusertypeapi/api/Test/getmassagereply", //获取数据的Servlet地址 async: true, dataType: 'json', data: {}, success: function(data) { } }); } function showAuto() { sendmsg() } // 导出 $("#HY_export").click(function() { if(f_State == '住院患者') { var key = $("#key").val() //关键字 var yqinfo = $('#projectid').val() var sendmydcent = $('#myd').val() //满意度 var deptname = $('#deptname').val() //科室名称 var iszyormz = f_State var state = $('#state').val() var stime = $('#startTime').val() && $('#startTime').val().split(' ~ ')[0] //开始时间 var etime = $('#startTime').val() && $('#startTime').val().split(' ~ ')[1] //结束时间 window.location.href = huayi.config.callcenter_url + "testusertypeapi/api/Test/exportexcel?sendmydcent=" + sendmydcent + "&stime=" + stime + "&etime=" + etime + "+&key=" + key + "&deptname=" + deptname + "&yqinfo=" + yqinfo + "&iszyormz=" + iszyormz + "&state=" + state } else { $.ajax({ type: "get", url: huayi.config.callcenter_url + "testusertypeapi/api/Test/exportExcelAsyncmz", async: true, dataType: 'json', data: { iszyormz: f_State, key: $("#key").val(), yqinfo: $("#projectid").val(), sendmydcent: $("#myd").val(), deptname: $("#deptname").val(), state: $("#state").val(), stime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[0], //开始时间 etime: $('#startTime').val() && $('#startTime').val().split(' ~ ')[1], //结束时间 }, success: function(data) { if(data.state.toLowerCase() == 'success') { //要导出的json数据 const jsonData = data.data for(var i = 0; i < jsonData.length; i++) { if(jsonData[i].replaycenters == null) { jsonData[i].replaycenters = '' } if(jsonData[i].sendmyeds == null) { jsonData[i].sendmyeds = '' } if(jsonData[i].senddate == null) { jsonData[i].senddate = '' } if(jsonData[i].ZY_NO == null) { jsonData[i].ZY_NO = '' } if(jsonData[i].NAME == null) { jsonData[i].NAME = '' } if(jsonData[i].SEX == null) { jsonData[i].SEX = '' } if(jsonData[i].PAT_PHONE == null) { jsonData[i].PAT_PHONE = '' } if(jsonData[i].CLINIC_DIAG_NAME == null) { jsonData[i].CLINIC_DIAG_NAME = '' } if(jsonData[i].dept_name == null) { jsonData[i].dept_name = '' } if(jsonData[i].CLINIC_DATE == null) { jsonData[i].CLINIC_DATE = '' } if(jsonData[i].statesissuccess == null) { jsonData[i].statesissuccess = '' } if(jsonData[i].nomybecause == null) { jsonData[i].nomybecause = '' } jsonData[i].replaycenters.replace(/[\r\n]/g, "") jsonData[i].sendmyeds.replace(/[\r\n]/g, "") jsonData[i].senddate.replace(/[\r\n]/g, "") jsonData[i].ZY_NO.replace(/[\r\n]/g, "") jsonData[i].NAME.replace(/[\r\n]/g, "") jsonData[i].SEX.replace(/[\r\n]/g, "") jsonData[i].PAT_PHONE.replace(/[\r\n]/g, "") jsonData[i].CLINIC_DIAG_NAME.replace(/[\r\n]/g, "") jsonData[i].dept_name.replace(/[\r\n]/g, "") jsonData[i].CLINIC_DATE.replace(/[\r\n]/g, "") jsonData[i].statesissuccess.replace(/[\r\n]/g, "") jsonData[i].nomybecause.replace(/[\r\n]/g, "") //console.log(jsonData[i].CLINIC_DIAG_NAME) } //列标题,逗号隔开,每一个逗号就是隔开一个单元格 var str = `回复内容,满意度,发送时间,住院号,病人姓名,病人性别,联系电话,就诊内容,就诊科室,就诊时间,发送状态,备注\n`; //增加\t为了不让表格显示科学计数法或者其他格式 for(let i = 0; i < jsonData.length; i++) { for(let item in jsonData[i]) { str += `${jsonData[i][item].replace(/[\r\n]/g, "") + '\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 = "门诊患者.xlsx"; document.body.appendChild(link); link.click(); document.body.removeChild(link); } } }); } })