var table = $('#table1'); var token = $.cookie("token"); $(document).ready(function(){ rolePermissions(); getProvinceCounty($("#searchProvince"), 0, "请选择省"); }); laydate.render({ elem: '#searchTime', type: 'date', theme: '#1e90ff', range: '~', }); $('.search').click(function () { initTable(token); }) //添加 $('.add').click(function () { layer.open({ type: 2, title: '添加客户信息', maxmin: true, //开启最大化最小化按钮 area: ['80%', '80%'], content: 'addOrEdit.html' }); }) //修改 var did; $('.change').click(function () { var ids = $.map(table.bootstrapTable('getSelections'), function (row) { return row.F_Id; }); did = ids.toString(); if (ids.length != 1) { layer.confirm('请选择一行进行修改!', { btn: ['确定'] }); return; } else { layer.open({ type: 2, title: '修改客户信息', maxmin: true, //开启最大化最小化按钮 area: ['80%', '80%'], content: 'addOrEdit.html?ids=' + did }); } }) //删除 var delid; $('.del').click(function () { var ids = $.map(table.bootstrapTable('getSelections'), function (row) { return row.F_Id; }); delid = ids; if (ids.length <= 0) { layer.confirm('请选择要删除的行!', { btn: ['确定'] }); return; } else { var laye = layer.confirm('您确定要删除吗?', { btn: ['确定', '取消'] //可以无限个按钮 }, function () { //按钮【按钮一】的回调 $.ajax({ type: "post", url: huayi.config.callcenter_url + "Customer/DelCustomer", async: true, dataType: "json", data: { token: token, ids: delid }, success: function (data) { if (data.state.toLowerCase() == 'success') { layer.msg("删除成功!"); table.bootstrapTable('refresh'); } } }); }, function (index) { //按钮【按钮二】的回调 layer.close(laye) }); } }) //列表 initTable(token); function initTable(token) { //先销毁表格 table.bootstrapTable('destroy'); //初始化表格,动态从服务器加载数据 table.bootstrapTable({ method: "get", //使用get请求到服务器获取数据 url: huayi.config.callcenter_url + "Customer/GetList", //获取数据的Servlet地址 contentType: 'application/x-www-form-urlencoded', // url: "kehu.json", //获取数据的Servlet地址 striped: true, //表格显示条纹 pagination: true, //启动分页 pageSize: 10, //每页显示的记录数 pageNumber: 1, //当前第几页 pageList: [10, 15, 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) { //设置查询参数 var param = { token: token, key: $("#searchKeyword").val().replace(/\s+/g, ""), //关键字 prov: $("#searchProvince option:selected").text() == "请选择省" ? "" : $("#searchProvince option:selected").text(), //省 city: $("#searchCity option:selected").text() == "请选择市" ? "" : $("#searchCity option:selected").text(), //城市 country: $("#searchCounty option:selected").text() == "请选择县/区" ? "" : $("#searchCounty option:selected").text(), //县区 starttime: $('#searchTime').val() ? $('#searchTime').val().split('~')[0]:"", //开始时间 endtime: $('#searchTime').val() ? $('#searchTime').val().split('~')[1]:"", //结束时间 pageindex: params.pageNumber, pagesize: params.pageSize, isdc: 0, //是否导出 }; return param; }, onLoadSuccess: function () { //加载成功时执行 //layer.msg("加载成功"); }, onLoadError: function () { //加载失败时执行 //layer.msg("加载数据失败", { time: 1500, icon: 2 }); } }); } function formatterSpecialTag(val, row) { var specialTagArr = ['否', '是']; return specialTagArr[val] } //导出 $("#exportButton").click(function() { var key = $("#searchKeyword").val().replace(/\s+/g, ""); //关键字 var prov = $("#searchProvince option:selected").text() == "请选择省" ? "" : $("#searchProvince option:selected").text(); //省 var city = $("#searchCity option:selected").text() == "请选择市" ? "" : $("#searchCity option:selected").text(); //城市 var country = $("#searchCounty option:selected").text() == "请选择县/区" ? "" : $("#searchCounty option:selected").text(); //县区 var starttime = $('#searchTime').val() ? $('#searchTime').val().split('~')[0]:""; //开始时间 var endtime = $('#searchTime').val() ? $('#searchTime').val().split('~')[1]:""; //结束时间 var isdc = 1; window.location.href = huayi.config.callcenter_url + "Customer/GetList?token"+ token + "&key=" + key + "&prov=" + prov + "&city=" + city + "&country=" + country + "&starttime=" + starttime + "&endtime=" + endtime + "&isdc=" + isdc; }) //上传文件 $("#btndr").click(function () { $("#upFile").trigger("click"); }) $("#upFile").change(function () { upload(); }) function ExcelMod() { window.location.href ='../../commonTpl/客户列表.xls'; } //上传文件 function upload() { if (document.getElementById("upFile").files.length > 0) { var formData = new FormData(); formData.append("upFile", document.getElementById("upFile").files[0]); formData.append("type", 1); formData.append("token", $.cookie("token")); $.ajax({ url: huayi.config.callcenter_url + "Customer/ImportExcel", type: "POST", data: formData, contentType: false, processData: false, success: function (result) { document.getElementById("upFile").outerHTML = document.getElementById("upFile").outerHTML; $("#upFile").change(function () { upload(); }); var r = $.parseJSON(result); if (r.state.toLowerCase() == "success") { debugger layer.msg("导入成功"); initTable(token); } } }); } else { layer.confirm('请上传文件!', { btn: ['确定'] }); } } //按enter搜索 document.onkeydown = function (e) { // 回车提交表单 var theEvent = window.event || e; var code = theEvent.keyCode || theEvent.which || theEvent.charCode; if (code == 13) { initTable(token); } } /* 获取 省 市 县/区 parameter: pid int */ function getProvinceCounty(element, pid, text) { element.empty(); element.append(''); $.getJSON(huayi.config.callcenter_url + "RegionCategory/GetCountyList", { "token": $.cookie("token"), pid: pid, }, function (data) { if (data.state.toLowerCase() == "success") { var content = data.data; $(content).each(function (i, n) { element.append(""); }) } }) } $("#searchProvince").on('change',function(){ getProvinceCounty($("#searchCity"), $("#searchProvince").val(), "请选择市"); }); $("#searchCity").on('change',function(){ getProvinceCounty($("#searchCounty"), $("#searchCity").val(), "请选择县/区"); }); //角色按钮权限 function rolePermissions() { var roleCode = $.cookie('roleCode') if (roleCode === "XTGLY") { $('.change').show() $('.del').show() $('#btndr').show() $('#excelMod').show() } else { } } // 按回车搜索 document.onkeydown = function (e) { var theEvent = window.event || e; var code = theEvent.keyCode || theEvent.which || theEvent.charCode; if (code == 13) { initTable(token); } }