> 文档中心 > ajax前端业务实现发送和多项选择

ajax前端业务实现发送和多项选择

目录

一,实现发送

1,前端html写法:

2,js的写法

3,新增

4,修改

二,后端写法

1,MedicineInformationController写法

2,IMedicineInformationService写法

3,消息群发Service业务层处理(MedicineInformationServiceImpl)

4,消息群发Mapper接口(MedicineInformationMapper)

5,MedicineInformationMapper.xml


一,实现发送

1,前端html写法:

    
var editFlag = [[${@permission.hasPermi('data:information:edit')}]]; var removeFlag = [[${@permission.hasPermi('data:information:remove')}]]; var fsFlag = [[${@permission.hasPermi('data:information:fs')}]]; var information = [[${@dict.getType('information')}]]; var prefix = ctx + "data/information"; function addInformation() { $.modal.openTab("新增消息群发", prefix + "/add"); } $(function () { var options = { url: prefix + "/list", createUrl: prefix + "/add", updateUrl: prefix + "/edit/{id}", detailUrl: prefix + "/detail/{id}", removeUrl: prefix + "/remove", exportUrl: prefix + "/export", modalName: "消息群发", showSearch: false, showRefresh: false, showColumns: false, showToggle: false, sortName: "createTime", sortOrder: "desc", columns: [ { field: 'substance', title: '通知内容' }, { field: 'changeTime', title: '通知时间' }, { field: 'medicineName', title: '通知人员名称' }, { title: '消息状态', align: 'center', field: "status", formatter: function (value, row, index) { return $.table.selectDictLabel(information, value); } }, { title: '操作', align: 'center', formatter: function (value, row, index) { var actions = []; actions.push('' +'发送 '); actions.push('' +'修改 '); actions.push('' +'查看'); return actions.join(''); } }] }; $.table.init(options); }); //发送消息状态 function statusTools(id){ $.ajax({ type: "POST", url: prefix + "/fs", data: {"id":id}, dataType: 'json', success: function (result) { if (result.code == web_status.SUCCESS) { $.modal.msgReload("保存成功,正在刷新数据请稍后……", modal_status.SUCCESS); } else { $.modal.alertError(result.msg); } }, error: function (error) { $.modal.alertWarning("发送失败。"); } }); }

2,js的写法

/** * 通用js方法封装处理 * Copyright (c) 2019 guizhou */// 当前table相关信息var table = {    config: {},    // 当前实例配置    options: {},    // 设置实例配置    set: function(id) {    if($.common.getLength(table.config) > 1) {    var tableId = $.common.isEmpty(id) ? $(event.currentTarget).parents(".bootstrap-table").find(".table").attr("id") : id;     if ($.common.isNotEmpty(tableId)) {  table.options = table.get(tableId);     }    }    },    // 获取实例配置    get: function(id) { return table.config[id];    },    // 记住选择实例组    rememberSelecteds: {},    // 记住选择ID组    rememberSelectedIds: {}};(function ($) {    $.extend({    _tree: {},    bttTable: {},    // 表格封装处理    table: {     // 初始化表格参数     init: function(options) {     var defaults = {     id: "bootstrap-table",     type: 0, // 0 代表bootstrapTable 1代表bootstrapTreeTable     height: undefined,     sidePagination: "server",     sortName: "",     sortOrder: "asc",     pagination: true,     pageSize: 10,     pageList: [10, 25, 50],     toolbar: "toolbar",     striped: false,     escape: false,     firstLoad: true,     showFooter: false,     search: false,      showSearch: true,      showPageGo: false,      showRefresh: true,      showColumns: true,      showToggle: true,      showExport: false,      clickToSelect: false,      singleSelect: false,      mobileResponsive: true,      rememberSelected: false,     fixedColumns: false,     fixedNumber: 0,     rightFixedColumns: false,     rightFixedNumber: 0,     queryParams: $.table.queryParams,     rowStyle: {}, };     var options = $.extend(defaults, options);     table.options = options;     table.config[options.id] = options;  $.table.initEvent();  $('#' + options.id).bootstrapTable({  id: options.id,      url: options.url,// 请求后台的URL(*)      contentType: "application/x-www-form-urlencoded",   // 编码类型      method: 'post',  // 请求方式(*)      cache: false,    // 是否使用缓存      height: options.height, // 表格的高度      striped: options.striped,      // 是否显示行间隔色      sortable: true,  // 是否启用排序      sortStable: true,// 设置为 true 将获得稳定的排序      sortName: options.sortName,    // 排序列名称      sortOrder: options.sortOrder,  // 排序方式  asc 或者 desc      pagination: options.pagination,// 是否显示分页(*)      pageNumber: 1,   // 初始化加载第一页,默认第一页      pageSize: options.pageSize,    // 每页的记录行数(*)pageList: options.pageList,    // 可供选择的每页的行数(*)      firstLoad: options.firstLoad,  // 是否首次请求加载数据,对于数据较大可以配置false      escape: options.escape, // 转义HTML字符串      showFooter: options.showFooter,// 是否显示表尾      iconSize: 'outline',    // 图标大小:undefined默认的按钮尺寸 xs超小按钮sm小按钮lg大按钮      toolbar: '#' + options.toolbar,// 指定工作栏      sidePagination: options.sidePagination,      // server启用服务端分页client客户端分页      search: options.search, // 是否显示查询框功能      searchText: options.searchText,//查询框初始显示的内容,默认为空      showSearch: options.showSearch,// 是否显示检索信息      showPageGo: options.showPageGo, // 是否显示跳转页      showRefresh: options.showRefresh,     // 是否显示刷新按钮      showColumns: options.showColumns,     // 是否显示隐藏某列下拉框      showToggle: options.showToggle,// 是否显示详细视图和列表视图的切换按钮      showExport: options.showExport,// 是否支持导出文件      uniqueId: options.uniqueId,    // 唯 一的标识符      clickToSelect: options.clickToSelect,// 是否启用点击选中行      singleSelect: options.singleSelect,   // 是否单选checkbox      mobileResponsive: options.mobileResponsive,  // 是否支持移动端适配      detailView: options.detailView,// 是否启用显示细节视图      onClickRow: options.onClickRow,// 点击某行触发的事件      onDblClickRow: options.onDblClickRow, // 双击某行触发的事件      onClickCell: options.onClickCell,     // 单击某格触发的事件      onDblClickCell: options.onDblClickCell,      // 双击某格触发的事件      onEditableSave: options.onEditableSave,      // 行内编辑保存的事件      onExpandRow: options.onExpandRow,     // 点击详细视图的事件      rememberSelected: options.rememberSelected,  // 启用翻页记住前面的选择      fixedColumns: options.fixedColumns,   // 是否启用冻结列(左侧)      fixedNumber: options.fixedNumber,     // 列冻结的个数(左侧)      rightFixedColumns: options.rightFixedColumns,// 是否启用冻结列(右侧)      rightFixedNumber: options.rightFixedNumber,  // 列冻结的个数(右侧)      onReorderRow: options.onReorderRow,   // 当拖拽结束后处理函数      queryParams: options.queryParams,     // 传递参数(*)      rowStyle: options.rowStyle,    // 通过自定义函数设置行样式      columns: options.columns,      // 显示列信息(*)      data: options.data,     // 被加载的数据      responseHandler: $.table.responseHandler,    // 在加载服务器发送来的数据之前处理函数      onLoadSuccess: $.table.onLoadSuccess, // 当所有数据被加载时触发处理函数      exportOptions: options.exportOptions, // 前端导出忽略列索引      detailFormatter: options.detailFormatter,    // 在行下面展示其他数据列表onCheck: options.onCheck,      // 复选框点击选择onUncheck: options.onUncheck,// 复选框点击取消  });     },     // 获取实例ID,如存在多个返回#id1,#id2 delimeter分隔符     getOptionsIds: function(separator) {     var _separator = $.common.isEmpty(separator) ? "," : separator;     var optionsIds = "";$.each(table.config, function(key, value){     optionsIds += "#" + key + _separator;     });     return optionsIds.substring(0, optionsIds.length - 1);     },     // 查询条件     queryParams: function(params) {     var curParams = {     // 传递参数查询参数   pageSize:params.limit,   pageNum: params.offset / params.limit + 1,   searchValue:    params.search,   orderByColumn:  params.sort,   isAsc:   params.order     };     var currentId = $.common.isEmpty(table.options.formId) ? $('form').attr('id') : table.options.formId;     return $.extend(curParams, $.common.formToJSON(currentId));      },     // 请求获取数据后处理回调函数     responseHandler: function(res) {     if (typeof table.options.responseHandler == "function") {     table.options.responseHandler(res);  }  if (res.code == 0) {      if ($.common.isNotEmpty(table.options.sidePagination) && table.options.sidePagination == 'client') {      return res.rows;      } else {      if ($.common.isNotEmpty(table.options.rememberSelected) && table.options.rememberSelected) {      var column = $.common.isEmpty(table.options.uniqueId) ? table.options.columns[1].field : table.options.uniqueId;      $.each(res.rows, function(i, row) {      row.state = $.inArray(row[column], table.rememberSelectedIds[table.options.id]) !== -1;})      }   return { rows: res.rows, total: res.total };      }  } else {      $.modal.alertWarning(res.msg);      return { rows: [], total: 0 };  }     },     // 初始化事件     initEvent: function() {     // 实例ID信息     var optionsIds = $.table.getOptionsIds();     // 监听事件处理     $(optionsIds).on(TABLE_EVENTS, function () {     table.set($(this).attr("id"));     });     // 选中、取消、全部选中、全部取消(事件)     $(optionsIds).on("check.bs.table check-all.bs.table uncheck.bs.table uncheck-all.bs.table", function (e, rows) {     // 复选框分页保留保存选中数组     var rowIds = $.table.affectedRowIds(rows);     if ($.common.isNotEmpty(table.options.rememberSelected) && table.options.rememberSelected) {     func = $.inArray(e.type, ['check', 'check-all']) > -1 ? 'union' : 'difference';     var selectedIds = table.rememberSelectedIds[table.options.id];     if($.common.isNotEmpty(selectedIds)) {     table.rememberSelectedIds[table.options.id] = _[func](selectedIds, rowIds);     } else {     table.rememberSelectedIds[table.options.id] = _[func]([], rowIds);     }     var selectedRows = table.rememberSelecteds[table.options.id];     if($.common.isNotEmpty(selectedRows)) {     table.rememberSelecteds[table.options.id] = _[func](selectedRows, rows);     } else {     table.rememberSelecteds[table.options.id] = _[func]([], rows);     }     }     });     // 加载成功、选中、取消、全部选中、全部取消(事件)     $(optionsIds).on("check.bs.table uncheck.bs.table check-all.bs.table uncheck-all.bs.table load-success.bs.table", function () {     var toolbar = table.options.toolbar;     var uniqueId = table.options.uniqueId;     // 工具栏按钮控制     var rows = $.common.isEmpty(uniqueId) ? $.table.selectFirstColumns() : $.table.selectColumns(uniqueId);     // 非多个禁用     $('#' + toolbar + ' .multiple').toggleClass('disabled', !rows.length);     // 非单个禁用     $('#' + toolbar + ' .single').toggleClass('disabled', rows.length!=1);     });     // 图片预览事件     $(optionsIds).off("click").on("click", '.img-circle', function() { var src = $(this).attr('src'); var target = $(this).data('target'); if($.common.equals("self", target)) { var height = $(this).data('height');var width = $(this).data('width');// 如果是移动端,就使用自适应大小弹窗if ($.common.isMobile()) {width = 'auto';height = 'auto';} layer.open({  title: false,  type: 1,  closeBtn: true,  shadeClose: true,  area: ['auto', 'auto'],  content: ""     }); } else if ($.common.equals("blank", target)) {     window.open(src); }    });     // 单击tooltip事件     $(optionsIds).on("click", '.tooltip-show', function() {     var target = $(this).data('target');     var input = $(this).prev();     if ($.common.equals("copy", target)) {  input.select();  document.execCommand("copy");     } else if ($.common.equals("open", target)) {     parent.layer.alert(input.val(), {   title: "信息内容",   shadeClose: true,   btn: ['确认'],   btnclass: ['btn btn-primary'],      });     }     });     },     // 当所有数据被加载时触发     onLoadSuccess: function(data) {     if (typeof table.options.onLoadSuccess == "function") {     table.options.onLoadSuccess(data);     }     // 浮动提示框特效     $(".table [data-toggle='tooltip']").tooltip();     },     // 表格销毁     destroy: function (tableId) {     var currentId = $.common.isEmpty(tableId) ? table.options.id : tableId;     $("#" + currentId).bootstrapTable('destroy'); },     // 序列号生成     serialNumber: function (index, tableId) {     var currentId = $.common.isEmpty(tableId) ? table.options.id : tableId;var tableParams = $("#" + currentId).bootstrapTable('getOptions');var pageSize = tableParams.pageSize;var pageNumber = tableParams.pageNumber;return pageSize * (pageNumber - 1) + index + 1;},// 列超出指定长度浮动提示 target(copy单击复制文本 open弹窗打开文本)tooltip: function (value, length, target) {var _length = $.common.isEmpty(length) ? 20 : length;var _text = "";var _value = $.common.nullToStr(value);var _target = $.common.isEmpty(target) ? 'copy' : target;if (_value.length > _length) {_text = _value.substr(0, _length) + "...";_value = _value.replace(/\'/g,"'");_value = _value.replace(/\"/g,""");var actions = [];actions.push($.common.sprintf('', _value));  actions.push($.common.sprintf('%s', _target, _value, _text));return actions.join('');} else {_text = _value;return _text;}},// 下拉按钮切换dropdownToggle: function (value) {var actions = [];actions.push('
');actions.push('');actions.push('');actions.push('
');return actions.join('');},// 图片预览imageView: function (value, height, width, target) {if ($.common.isEmpty(width)) { width = 'auto'; } if ($.common.isEmpty(height)) { height = 'auto'; }// blank or selfvar _target = $.common.isEmpty(target) ? 'self' : target;if ($.common.isNotEmpty(value)) {return $.common.sprintf("", height, width, _target, value);} else {return $.common.nullToStr(value);}}, //查询-默认第一个form search: function(formId, tableId, data) { table.set(tableId); var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; var params = $.common.isEmpty(tableId) ? $("#" + table.options.id).bootstrapTable('getOptions') : $("#" + tableId).bootstrapTable('getOptions'); params.queryParams = function(params) { var search = $.common.formToJSON(currentId); if($.common.isNotEmpty(data)){ $.each(data, function(key) { search[key] = data[key]; }); } search.pageSize = params.limit; search.pageNum = params.offset / params.limit + 1; search.searchValue = params.search; search.orderByColumn = params.sort; search.isAsc = params.order; return search; } if($.common.isNotEmpty(tableId)){ $("#" + tableId).bootstrapTable('refresh', params); } else{ $("#" + table.options.id).bootstrapTable('refresh', params); } }, // 导出数据 exportExcel: function(formId) { table.set(); $.modal.confirm("确定导出所有" + table.options.modalName + "吗?", function() { var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; var params = $("#" + table.options.id).bootstrapTable('getOptions'); var dataParam = $("#" + currentId).serializeArray(); dataParam.push({ "name": "orderByColumn", "value": params.sortName }); dataParam.push({ "name": "isAsc", "value": params.sortOrder }); $.modal.loading("正在导出数据,请稍后..."); $.post(table.options.exportUrl, dataParam, function(result) { if (result.code == web_status.SUCCESS) { window.location.href = ctx + "common/download?fileName=" + encodeURI(result.msg) + "&delete=" + true; } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); }); }); }, // 下载模板 importTemplate: function() { table.set(); $.get(table.options.importTemplateUrl, function(result) { if (result.code == web_status.SUCCESS) { window.location.href = ctx + "common/download?fileName=" + encodeURI(result.msg) + "&delete=" + true; } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } }); }, // 导入数据 importExcel: function(formId) { table.set(); var currentId = $.common.isEmpty(formId) ? 'importTpl' : formId; layer.open({ type: 1, area: ['400px', '230px'], fix: false, //不固定 maxmin: true, shade: 0.3, title: '导入' + table.options.modalName + '数据', content: $('#' + currentId).html(), btn: [' 导入', ' 取消'], // 弹层外区域关闭 shadeClose: true, btn1: function(index, layero){ var file = layero.find('#file').val(); if (file == '' || (!$.common.endWith(file, '.xls') && !$.common.endWith(file, '.xlsx'))){ $.modal.msgWarning("请选择后缀为 “xls”或“xlsx”的文件。"); return false; } var index = layer.load(2, {shade: false}); $.modal.disable(); var formData = new FormData(layero.find('form')[0]); $.ajax({ url: table.options.importUrl, data: formData, cache: false, contentType: false, processData: false, type: 'POST', success: function (result) { if (result.code == web_status.SUCCESS) { $.modal.closeAll(); $.modal.alertSuccess(result.msg); $.table.refresh(); } else if (result.code == web_status.WARNING) { layer.close(index); $.modal.enable(); $.modal.alertWarning(result.msg)} else { layer.close(index); $.modal.enable(); $.modal.alertError(result.msg); } } }); } }); },// 导入数据importExcelMed: function(formId,fileId) {table.set();var currentId = $.common.isEmpty(formId) ? 'importTpl' : formId;layer.open({type: 1,area: ['400px', '230px'],fix: false,//不固定maxmin: true,shade: 0.3,title: '导入' + table.options.modalName + '数据',content: $('#' + currentId).html(),btn: [' 导入', ' 取消'],// 弹层外区域关闭shadeClose: true,btn1: function(index, layero){var file = layero.find('#'+fileId).val();if (file == '' || (!$.common.endWith(file, '.xls') && !$.common.endWith(file, '.xlsx'))){$.modal.msgWarning("请选择后缀为 “xls”或“xlsx”的文件。");return false;}var index = layer.load(2, {shade: false});$.modal.disable();var formData = new FormData(layero.find('form')[0]);$.ajax({url: table.options.importUrl,data: formData,cache: false,contentType: false,processData: false,type: 'POST',success: function (result) {if (result.code == web_status.SUCCESS) {$.modal.closeAll();$.modal.alertSuccess(result.msg);$.table.refresh();} else if (result.code == web_status.WARNING) {layer.close(index);$.modal.enable();$.modal.alertWarning(result.msg)} else {layer.close(index);$.modal.enable();$.modal.alertError(result.msg);}}});}});}, // 刷新表格 refresh: function(tableId) { var currentId = $.common.isEmpty(tableId) ? table.options.id : tableId; $("#" + currentId).bootstrapTable('refresh', { silent: true }); },refreshCs: function(currentId,opt) {$("#" + currentId).bootstrapTable('refresh', opt);}, // 查询表格指定列值 selectColumns: function(column) { var rows = $.map($("#" + table.options.id).bootstrapTable('getSelections'), function (row) { return row[column]; }); if ($.common.isNotEmpty(table.options.rememberSelected) && table.options.rememberSelected) { var selectedRows = table.rememberSelecteds[table.options.id]; if($.common.isNotEmpty(selectedRows)) { rows = $.map(table.rememberSelecteds[table.options.id], function (row) { return row[column]; }); } } return $.common.uniqueFn(rows); }, // 获取当前页选中或者取消的行ID affectedRowIds: function(rows) { var column = $.common.isEmpty(table.options.uniqueId) ? table.options.columns[1].field : table.options.uniqueId; var rowIds; if ($.isArray(rows)) { rowIds = $.map(rows, function(row) { return row[column]; }); } else { rowIds = [rows[column]]; } return rowIds; }, // 查询表格首列值 selectFirstColumns: function() { var rows = $.map($("#" + table.options.id).bootstrapTable('getSelections'), function (row) { return row[table.options.columns[1].field]; }); if ($.common.isNotEmpty(table.options.rememberSelected) && table.options.rememberSelected) { var selectedRows = table.rememberSelecteds[table.options.id]; if($.common.isNotEmpty(selectedRows)) { rows = $.map(selectedRows, function (row) {return row[table.options.columns[1].field]; }); } } return $.common.uniqueFn(rows); }, // 回显数据字典 selectDictLabel: function(datas, value) { var actions = []; $.each(datas, function(index, dict) { if (dict.dictValue == ('' + value)) { var listClass = $.common.equals("default", dict.listClass) || $.common.isEmpty(dict.listClass) ? "" : "badge badge-" + dict.listClass; actions.push($.common.sprintf("%s", listClass, dict.dictLabel)); return false; } }); return actions.join(''); }, // 显示表格指定列 showColumn: function(column, tableId) { var currentId = $.common.isEmpty(tableId) ? table.options.id : tableId; $("#" + currentId).bootstrapTable('showColumn', column); }, // 隐藏表格指定列 hideColumn: function(column, tableId) { var currentId = $.common.isEmpty(tableId) ? table.options.id : tableId; $("#" + currentId).bootstrapTable('hideColumn', column); } }, // 表格树封装处理 treeTable: { // 初始化表格 init: function(options) { var defaults = { id: "bootstrap-tree-table", type: 1, // 0 代表bootstrapTable 1代表bootstrapTreeTable height: 0, rootIdValue: null, ajaxParams: {}, toolbar: "toolbar", striped: false, expandColumn: 1, showSearch: true, showRefresh: true, showColumns: true, expandAll: true, expandFirst: true }; var options = $.extend(defaults, options); table.options = options; table.config[options.id] = options; $.bttTable = $('#' + options.id).bootstrapTreeTable({ code: options.code, // 用于设置父子关系 parentCode: options.parentCode,// 用于设置父子关系 type: 'post', // 请求方式(*) url: options.url,// 请求后台的URL(*) data: options.data, // 无url时用于渲染的数据 ajaxParams: options.ajaxParams,// 请求数据的ajax的data属性 rootIdValue: options.rootIdValue, // 设置指定根节点id值 height: options.height, // 表格树的高度 expandColumn: options.expandColumn, // 在哪一列上面显示展开按钮 striped: options.striped, // 是否显示行间隔色 bordered: false, // 是否显示边框 toolbar: '#' + options.toolbar,// 指定工作栏 showSearch: options.showSearch,// 是否显示检索信息 showRefresh: options.showRefresh, // 是否显示刷新按钮 showColumns: options.showColumns, // 是否显示隐藏某列下拉框 expandAll: options.expandAll, // 是否全部展开 expandFirst: options.expandFirst, // 是否默认第一级展开--expandAll为false时生效 columns: options.columns, // 显示列信息(*) responseHandler: $.treeTable.responseHandler // 当所有数据被加载时触发处理函数 }); }, // 条件查询 search: function(formId) { var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; var params = $.common.formToJSON(currentId); $.bttTable.bootstrapTreeTable('refresh', params); }, // 刷新 refresh: function() { $.bttTable.bootstrapTreeTable('refresh'); }, // 查询表格树指定列值 selectColumns: function(column) { var rows = $.map($.bttTable.bootstrapTreeTable('getSelections'), function (row) { return row[column]; }); return $.common.uniqueFn(rows); }, // 请求获取数据后处理回调函数,校验异常状态提醒 responseHandler: function(res) { if (typeof table.options.responseHandler == "function") { table.options.responseHandler(res); } if (res.code != undefined && res.code != 0) { $.modal.alertWarning(res.msg); return []; } else { return res; } }, }, // 表单封装处理 form: { // 表单重置 reset: function(formId, tableId) { table.set(tableId); var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; $("#" + currentId)[0].reset(); if (table.options.type == table_type.bootstrapTable) { if($.common.isEmpty(tableId)){ $("#" + table.options.id).bootstrapTable('refresh'); } else{ $("#" + tableId).bootstrapTable('refresh'); } } else if (table.options.type == table_type.bootstrapTreeTable) { if($.common.isEmpty(tableId)){ $("#" + table.options.id).bootstrapTreeTable('refresh', []); } else{ $("#" + tableId).bootstrapTreeTable('refresh', []); } } }, // 获取选中复选框项 selectCheckeds: function(name) { var checkeds = ""; $('input:checkbox[name="' + name + '"]:checked').each(function(i) { if (0 == i) { checkeds = $(this).val(); } else { checkeds += ("," + $(this).val()); } }); return checkeds; }, // 获取选中下拉框项 selectSelects: function(name) { var selects = ""; $('#' + name + ' option:selected').each(function (i) { if (0 == i) { selects = $(this).val(); } else { selects += ("," + $(this).val()); } }); return selects; } }, // 弹出层封装处理 modal: { // 显示图标 icon: function(type) { var icon = ""; if (type == modal_status.WARNING) { icon = 0; } else if (type == modal_status.SUCCESS) { icon = 1; } else if (type == modal_status.FAIL) { icon = 2; } else { icon = 3; } return icon; }, // 消息提示 msg: function(content, type) { if (type != undefined) { layer.msg(content, { icon: $.modal.icon(type), time: 1000, shift: 5 }); } else { layer.msg(content); } }, // 错误消息 msgError: function(content) { $.modal.msg(content, modal_status.FAIL); }, // 成功消息 msgSuccess: function(content) { $.modal.msg(content, modal_status.SUCCESS); }, // 警告消息 msgWarning: function(content) { $.modal.msg(content, modal_status.WARNING); }, // 弹出提示 alert: function(content, type) { layer.alert(content, { icon: $.modal.icon(type), title: "系统提示", btn: ['确认'], btnclass: ['btn btn-primary'], }); }, // 消息提示并刷新父窗体 msgReload: function(msg, type) { layer.msg(msg, { icon: $.modal.icon(type), time: 500, shade: [0.1, '#8F8F8F'] }, function() { $.modal.reload(); }); }, // 错误提示 alertError: function(content) { $.modal.alert(content, modal_status.FAIL); }, // 成功提示 alertSuccess: function(content) { $.modal.alert(content, modal_status.SUCCESS); }, // 警告提示 alertWarning: function(content) { $.modal.alert(content, modal_status.WARNING); }, // 关闭窗体 close: function () { var index = parent.layer.getFrameIndex(window.name); parent.layer.close(index); }, // 关闭全部窗体 closeAll: function () { layer.closeAll(); }, // 确认窗体 confirm: function (content, callBack) { layer.confirm(content, { icon: 3, title: "系统提示", btn: ['确认', '取消'] }, function (index) { layer.close(index); callBack(true); }); }, // 弹出层指定宽度 open: function (title, url, width, height, callback) { //如果是移动端,就使用自适应大小弹窗 if ($.common.isMobile()) { width = 'auto'; height = 'auto'; } if ($.common.isEmpty(title)) { title = false; } if ($.common.isEmpty(url)) { url = "/404.html"; } if ($.common.isEmpty(width)) { width = 800; } if ($.common.isEmpty(height)) { height = ($(window).height() - 50); } if ($.common.isEmpty(callback)) { callback = function(index, layero) { var iframeWin = layero.find('iframe')[0]; iframeWin.contentWindow.submitHandler(index, layero); } } layer.open({ type: 2, area: [width + 'px', height + 'px'], fix: false, //不固定 maxmin: true, shade: 0.3, title: title, content: url, btn: ['确定', '关闭'], // 弹层外区域关闭 shadeClose: true, yes: callback, cancel: function(index) { return true; } }); }, // 弹出层指定参数选项 openOptions: function (options) { var _url = $.common.isEmpty(options.url) ? "/404.html" : options.url; var _title = $.common.isEmpty(options.title) ? "系统窗口" : options.title; var _width = $.common.isEmpty(options.width) ? "800" : options.width; var _height = $.common.isEmpty(options.height) ? ($(window).height() - 50) : options.height; var _btn = [' 确认', ' 关闭']; if ($.common.isEmpty(options.yes)) { options.yes = function(index, layero) { options.callBack(index, layero); } } layer.open({ type: 2, maxmin: true, shade: 0.3, title: _title, fix: false, area: [_width + 'px', _height + 'px'], content: _url, shadeClose: $.common.isEmpty(options.shadeClose) ? true : options.shadeClose, skin: options.skin, btn: $.common.isEmpty(options.btn) ? _btn : options.btn, yes: options.yes, cancel: function () { return true; } }); }, // 弹出层全屏 openFull: function (title, url, width, height) { //如果是移动端,就使用自适应大小弹窗 if ($.common.isMobile()) { width = 'auto'; height = 'auto'; } if ($.common.isEmpty(title)) { title = false; } if ($.common.isEmpty(url)) { url = "/404.html"; } if ($.common.isEmpty(width)) { width = 800; } if ($.common.isEmpty(height)) { height = ($(window).height() - 50); } var index = layer.open({ type: 2, area: [width + 'px', height + 'px'], fix: false, //不固定 maxmin: true, shade: 0.3, title: title, content: url, btn: ['确定', '关闭'], // 弹层外区域关闭 shadeClose: true, yes: function(index, layero) { var iframeWin = layero.find('iframe')[0]; iframeWin.contentWindow.submitHandler(index, layero); }, cancel: function(index) { return true; } }); layer.full(index); }, // 选卡页方式打开 openTab: function (title, url) { createMenuItem(url, title); }, // 选卡页同一页签打开 parentTab: function (title, url) { var dataId = window.frameElement.getAttribute('data-id'); createMenuItem(url, title); closeItem(dataId); }, // 关闭选项卡 closeTab: function (dataId) { closeItem(dataId); }, // 禁用按钮 disable: function() { var doc = window.top == window.parent ? window.document : window.parent.document; $("a[class*=layui-layer-btn]", doc).addClass("layer-disabled"); }, // 启用按钮 enable: function() { var doc = window.top == window.parent ? window.document : window.parent.document; $("a[class*=layui-layer-btn]", doc).removeClass("layer-disabled"); }, // 打开遮罩层 loading: function (message) { $.blockUI({ message: '
' + message + '
' }); }, // 关闭遮罩层 closeLoading: function () { setTimeout(function(){ $.unblockUI(); }, 50); }, // 重新加载 reload: function () { parent.location.reload(); } }, // 操作封装处理 operate: { // 提交数据 submit: function(url, type, dataType, data, callback) { var config = { url: url, type: type, dataType: dataType, data: data, beforeSend: function () { $.modal.loading("正在处理中,请稍后..."); }, success: function(result) { if (typeof callback == "function") { callback(result); } $.operate.ajaxSuccess(result); } }; $.ajax(config) }, // post请求传输 post: function(url, data, callback) { $.operate.submit(url, "post", "json", data, callback); }, // get请求传输 get: function(url, callback) { $.operate.submit(url, "get", "json", "", callback); }, // 详细信息 detail: function(id, width, height) { table.set(); var _url = $.operate.detailUrl(id); var _width = $.common.isEmpty(width) ? "800" : width; var _height = $.common.isEmpty(height) ? ($(window).height() - 50) : height; //如果是移动端,就使用自适应大小弹窗 if ($.common.isMobile()) { _width = 'auto'; _height = 'auto'; } var options = {title: table.options.modalName + "详细",width: _width,height: _height,url: _url,skin: 'layui-layer-gray', btn: ['关闭'],yes: function (index, layero) { layer.close(index); }}; $.modal.openOptions(options); },// 详细信息detailRemind: function(id, editUrl, width, height) {table.set();var _url = $.operate.detailUrl(id);var _width = $.common.isEmpty(width) ? "800" : width;var _height = $.common.isEmpty(height) ? ($(window).height() - 50) : height;//如果是移动端,就使用自适应大小弹窗if ($.common.isMobile()) {_width = 'auto';_height = 'auto';}var options = {title: table.options.modalName + "详细",width: _width,height: _height,url: _url,btn: ['标记已读','关闭'],yes: function (index, layero) {$.operate.save(editUrl, {"id":id});}};$.modal.openOptions(options);}, // 详细访问地址 detailUrl: function(id) { var url = "/404.html"; if ($.common.isNotEmpty(id)) { url = table.options.detailUrl.replace("{id}", id); } else { var id = $.common.isEmpty(table.options.uniqueId) ? $.table.selectFirstColumns() : $.table.selectColumns(table.options.uniqueId); if (id.length == 0) { $.modal.alertWarning("请至少选择一条记录"); return; } url = table.options.detailUrl.replace("{id}", id); } return url; }, // 删除信息 remove: function(id) { table.set(); $.modal.confirm("确定删除该条" + table.options.modalName + "信息吗?", function() { var url = $.common.isEmpty(id) ? table.options.removeUrl : table.options.removeUrl.replace("{id}", id); if(table.options.type == table_type.bootstrapTreeTable) { $.operate.get(url); } else { var data = { "ids": id }; $.operate.submit(url, "post", "json", data); } }); }, // 批量删除信息 removeAll: function() { table.set(); var rows = $.common.isEmpty(table.options.uniqueId) ? $.table.selectFirstColumns() : $.table.selectColumns(table.options.uniqueId); if (rows.length == 0) { $.modal.alertWarning("请至少选择一条记录"); return; } $.modal.confirm("确认要删除选中的" + rows.length + "条数据吗?", function() { var url = table.options.removeUrl; var data = { "ids": rows.join() }; $.operate.submit(url, "post", "json", data); }); }, // 清空信息 clean: function() { table.set(); $.modal.confirm("确定清空所有" + table.options.modalName + "吗?", function() { var url = table.options.cleanUrl; $.operate.submit(url, "post", "json", ""); }); }, // 添加信息 add: function(id) { table.set(); $.modal.open("添加" + table.options.modalName, $.operate.addUrl(id)); }, // 添加信息,以tab页展现 addTab: function (id) { table.set(); $.modal.openTab("添加" + table.options.modalName, $.operate.addUrl(id)); }, // 添加信息 全屏 addFull: function(id) { table.set(); var url = $.common.isEmpty(id) ? table.options.createUrl : table.options.createUrl.replace("{id}", id); $.modal.openFull("添加" + table.options.modalName, url); }, // 添加访问地址 addUrl: function(id) { var url = $.common.isEmpty(id) ? table.options.createUrl.replace("{id}", "") : table.options.createUrl.replace("{id}", id); return url; }, // 修改信息 edit: function(id) { table.set(); if($.common.isEmpty(id) && table.options.type == table_type.bootstrapTreeTable) { var row = $("#" + table.options.id).bootstrapTreeTable('getSelections')[0]; if ($.common.isEmpty(row)) { $.modal.alertWarning("请至少选择一条记录"); return; } var url = table.options.updateUrl.replace("{id}", row[table.options.uniqueId]); $.modal.open("修改" + table.options.modalName, url); } else { $.modal.open("修改" + table.options.modalName, $.operate.editUrl(id)); } }, // 修改信息,以tab页展现 editTab: function(id) { table.set(); $.modal.openTab("修改" + table.options.modalName, $.operate.editUrl(id)); }, // 修改信息 全屏 editFull: function(id) { table.set(); var url = "/404.html"; if ($.common.isNotEmpty(id)) { url = table.options.updateUrl.replace("{id}", id); } else { if(table.options.type == table_type.bootstrapTreeTable) { var row = $("#" + table.options.id).bootstrapTreeTable('getSelections')[0]; if ($.common.isEmpty(row)) { $.modal.alertWarning("请至少选择一条记录"); return; } url = table.options.updateUrl.replace("{id}", row[table.options.uniqueId]); } else { var row = $.common.isEmpty(table.options.uniqueId) ? $.table.selectFirstColumns() : $.table.selectColumns(table.options.uniqueId); url = table.options.updateUrl.replace("{id}", row); } } $.modal.openFull("修改" + table.options.modalName, url); }, // 修改访问地址 editUrl: function(id) { var url = "/404.html"; if ($.common.isNotEmpty(id)) { url = table.options.updateUrl.replace("{id}", id); } else { var id = $.common.isEmpty(table.options.uniqueId) ? $.table.selectFirstColumns() : $.table.selectColumns(table.options.uniqueId); if (id.length == 0) { $.modal.alertWarning("请至少选择一条记录"); return; } url = table.options.updateUrl.replace("{id}", id); } return url; }, // 保存信息 刷新表格 save: function(url, data, callback) { var config = { url: url, type: "post", dataType: "json", data: data, beforeSend: function () { $.modal.loading("正在处理中,请稍后..."); $.modal.disable(); }, success: function(result) { if (typeof callback == "function") { callback(result); } $.operate.successCallback(result); } }; $.ajax(config) }, // 保存信息 弹出提示框 saveModal: function(url, data, callback) { var config = { url: url, type: "post", dataType: "json", data: data, beforeSend: function () { $.modal.loading("正在处理中,请稍后..."); }, success: function(result) { if (typeof callback == "function") { callback(result); } if (result.code == web_status.SUCCESS) { $.modal.alertSuccess(result.msg) } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); } }; $.ajax(config) }, // 保存选项卡信息 saveTab: function(url, data, callback) { var config = { url: url, type: "post", dataType: "json", data: data, beforeSend: function () { $.modal.loading("正在处理中,请稍后..."); }, success: function(result) { if (typeof callback == "function") { callback(result); } $.operate.successTabCallback(result); } }; $.ajax(config) }, // 保存结果弹出msg刷新table表格 ajaxSuccess: function (result) { if (result.code == web_status.SUCCESS && table.options.type == table_type.bootstrapTable) { $.modal.msgSuccess(result.msg); $.table.refresh(); } else if (result.code == web_status.SUCCESS && table.options.type == table_type.bootstrapTreeTable) { $.modal.msgSuccess(result.msg); $.treeTable.refresh(); } else if (result.code == web_status.SUCCESS && table.option.type == undefined) { $.modal.msgSuccess(result.msg) } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); }, // 成功结果提示msg(父窗体全局更新) saveSuccess: function (result) { if (result.code == web_status.SUCCESS) { $.modal.msgReload("保存成功,正在刷新数据请稍后……", modal_status.SUCCESS); } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); }, // 成功回调执行事件(父窗体静默更新) successCallback: function(result) { if (result.code == web_status.SUCCESS) { var parent = window.parent; if (parent.table.options.type == table_type.bootstrapTable) { $.modal.close(); parent.$.modal.msgSuccess(result.msg); parent.$.table.refresh(); } else if (parent.table.options.type == table_type.bootstrapTreeTable) { $.modal.close(); parent.$.modal.msgSuccess(result.msg); parent.$.treeTable.refresh(); } else { $.modal.msgReload("保存成功,正在刷新数据请稍后……", modal_status.SUCCESS); } } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); $.modal.enable(); }, // 选项卡成功回调执行事件(父窗体静默更新) successTabCallback: function(result) { if (result.code == web_status.SUCCESS) { var topWindow = $(window.parent.document); var currentId = $('.page-tabs-content', topWindow).find('.active').attr('data-panel'); var $contentWindow = $('.GuiZhou_iframe[data-id="' + currentId + '"]', topWindow)[0].contentWindow; $.modal.close(); $contentWindow.$.modal.msgSuccess(result.msg); $contentWindow.$(".layui-layer-padding").removeAttr("style"); if ($contentWindow.table.options.type == table_type.bootstrapTable) { $contentWindow.$.table.refresh(); } else if ($contentWindow.table.options.type == table_type.bootstrapTreeTable) { $contentWindow.$.treeTable.refresh(); } $.modal.closeTab(); } else if (result.code == web_status.WARNING) { $.modal.alertWarning(result.msg) } else { $.modal.alertError(result.msg); } $.modal.closeLoading(); } }, // 校验封装处理 validate: { // 判断返回标识是否唯一 false 不存在 true 存在 unique: function (value) { if (value == "0") { return true; } return false; }, // 表单验证 form: function (formId) { var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; return $("#" + currentId).validate().form(); }, //清空表单验证(清除提示信息) reset: function (formId) { var currentId = $.common.isEmpty(formId) ? $('form').attr('id') : formId; return $("#" + currentId).validate().resetForm(); } }, // 树插件封装处理 tree: { _option: {}, _lastValue: {}, // 初始化树结构 init: function(options) { var defaults = { id: "tree", // 属性ID expandLevel: 0, // 展开等级节点 view: { selectedMulti: false, // 设置是否允许同时选中多个节点 nameIsHTML: true // 设置 name 属性是否支持 HTML 脚本 }, check: { enable: false, // 置 zTree 的节点上是否显示 checkbox / radio nocheckInherit: true, // 设置子节点是否自动继承 }, data: { key: { title: "title" // 节点数据保存节点提示信息的属性名称 }, simpleData: { enable: true // true / false 分别表示 使用 / 不使用 简单数据模式 } }, }; var options = $.extend(defaults, options); $.tree._option = options; // 树结构初始化加载 var setting = { callback: { onClick: options.onClick, // 用于捕获节点被点击的事件回调函数 onCheck: options.onCheck, // 用于捕获 checkbox / radio 被勾选 或 取消勾选的事件回调函数 onDblClick: options.onDblClick // 用于捕获鼠标双击之后的事件回调函数 }, check: options.check, view: options.view, data: options.data }; $.get(options.url, function(data) { var treeId = $("#treeId").val(); tree = $.fn.zTree.init($("#" + options.id), setting, data); $._tree = tree; var nodes = tree.getNodesByParam("level", options.expandLevel - 1); for (var i = 0; i = 0; i--) { if (nodes[i].getParentNode() != null) { $._tree.expandNode(nodes[i], true, false, false, false); } else { $._tree.expandNode(nodes[i], true, true, false, false); } $._tree.showNode(nodes[i]); $.tree.showAllNode(nodes[i].children); } }, // 隐藏所有节点 hideAllNode: function(nodes) { var tree = $.fn.zTree.getZTreeObj("tree"); var nodes = $._tree.transformToArray(nodes); for (var i = nodes.length - 1; i >= 0; i--) { $._tree.hideNode(nodes[i]); } }, // 显示所有父节点 showParent: function(treeNode) { var parentNode; while ((parentNode = treeNode.getParentNode()) != null) { $._tree.showNode(parentNode); $._tree.expandNode(parentNode, true, false, false); treeNode = parentNode; } }, // 显示所有孩子节点 showChildren: function(treeNode) { if (treeNode.isParent) { for (var idx in treeNode.children) { var node = treeNode.children[idx]; $._tree.showNode(node); $.tree.showChildren(node); } } }, // 更新节点状态 updateNodes: function(nodeList) { $._tree.showNodes(nodeList); for (var i = 0, l = nodeList.length; i < l; i++) { var treeNode = nodeList[i]; $.tree.showChildren(treeNode); $.tree.showParent(treeNode) } }, // 获取当前被勾选集合 getCheckedNodes: function(column) { var _column = $.common.isEmpty(column) ? "id" : column; var nodes = $._tree.getCheckedNodes(true); return $.map(nodes, function (row) { return row[_column]; }).join(); }, // 不允许根父节点选择 notAllowParents: function(_tree) { var nodes = _tree.getSelectedNodes(); if(nodes.length == 0){ $.modal.msgError("请选择节点后提交"); return false;} for (var i = 0; i < nodes.length; i++) { if (nodes[i].level == 0) { $.modal.msgError("不能选择根节点(" + nodes[i].name + ")"); return false; } if (nodes[i].isParent) { $.modal.msgError("不能选择父节点(" + nodes[i].name + ")"); return false; } } return true; }, // 不允许最后层级节点选择 notAllowLastLevel: function(_tree) { var nodes = _tree.getSelectedNodes(); for (var i = 0; i < nodes.length; i++) { if (!nodes[i].isParent) { $.modal.msgError("不能选择最后层级节点(" + nodes[i].name + ")"); return false; } } return true; }, // 隐藏/显示查询栏 toggleSearch: function() { $('#search').slideToggle(200); $('#btnShow').toggle(); $('#btnHide').toggle(); $('#keyword').focus(); }, // 折叠 collapse: function() { $._tree.expandAll(false); }, // 展开 expand: function() { $._tree.expandAll(true); } }, // 通用方法封装处理 common: { // 判断字符串是否为空 isEmpty: function (value) { if (value == null || this.trim(value) == "") { return true; } return false; }, // 判断一个字符串是否为非空串 isNotEmpty: function (value) { return !$.common.isEmpty(value); }, // 空对象转字符串 nullToStr: function(value) { if ($.common.isEmpty(value)) { return "-"; } return value; }, // 是否显示数据 为空默认为显示 visible: function (value) { if ($.common.isEmpty(value) || value == true) { return true; } return false; }, // 空格截取 trim: function (value) { if (value == null) { return ""; } return value.toString().replace(/(^\s*)|(\s*$)|\r|\n/g, ""); }, // 比较两个字符串(大小写敏感) equals: function (str, that) { return str == that; }, // 比较两个字符串(大小写不敏感) equalsIgnoreCase: function (str, that) { return String(str).toUpperCase() === String(that).toUpperCase(); }, // 将字符串按指定字符分割 split: function (str, sep, maxLen) { if ($.common.isEmpty(str)) { return null; } var value = String(str).split(sep); return maxLen ? value.slice(0, maxLen - 1) : value; }, // 字符串格式化(%s ) sprintf: function (str) { var args = arguments, flag = true, i = 1; str = str.replace(/%s/g, function () { var arg = args[i++]; if (typeof arg === 'undefined') { flag = false; return ''; } return arg; }); return flag ? str : ''; }, // 指定随机数返回 random: function (min, max) { return Math.floor((Math.random() * max) + min); }, // 判断字符串是否是以start开头 startWith: function(value, start) { var reg = new RegExp("^" + start); return reg.test(value) }, // 判断字符串是否是以end结尾 endWith: function(value, end) { var reg = new RegExp(end + "$"); return reg.test(value) }, // 数组去重 uniqueFn: function(array) { var result = []; var hashObj = {}; for (var i = 0; i < array.length; i++) { if (!hashObj[array[i]]) { hashObj[array[i]] = true; result.push(array[i]); } } return result; }, // 数组中的所有元素放入一个字符串 join: function(array, separator) { if ($.common.isEmpty(array)) { return null; } return array.join(separator); }, // 获取form下所有的字段并转换为json对象 formToJSON: function(formId) { var json = {}; $.each($("#" + formId).serializeArray(), function(i, field) { if(json[field.name]) { json[field.name] += ("," + field.value); } else { json[field.name] = field.value;} }); return json; }, // 获取obj对象长度 getLength: function(obj) { var count = 0;   for (var i in obj) { if (obj.hasOwnProperty(i)) { count++; }   } return count; }, // 判断移动端 isMobile: function () { return navigator.userAgent.match(/(Android|iPhone|SymbianOS|Windows Phone|iPad|iPod)/i); }, } });})(jQuery);/** 表格类型 */table_type = { bootstrapTable: 0, bootstrapTreeTable: 1};/** 消息状态码 */web_status = { SUCCESS: 0, FAIL: 500, WARNING: 301};/** 弹窗状态码 */modal_status = { SUCCESS: "success", FAIL: "error", WARNING: "warning"};

3,新增

        

新增消息群发

<!---->

   
var editFlag = [[${@permission.hasPermi('data:information:edit')}]]; var removeFlag = [[${@permission.hasPermi('data:information:remove')}]]; var information = [[${@dict.getType('information')}]]; var prefix = ctx + "data/information"; var prefixMed = ctx + "data/medicine"; $(function () { var panehHidden = false; if ($(this).width() < 769) { panehHidden = true; } $('body').layout({initClosed: panehHidden, west__size: 350}); var options = { url: prefixMed + "/list", showSearch: false, showRefresh: false, showColumns: false, showToggle: false, onCheck:function(row){ var html = ""+row.name+"" + ""; $("#medDiv").append(html); }, onUncheck:function (row){ $("#"+row.code+"Name").remove(); $("#"+row.id+"Id").remove(); }, sortName: "createTime", sortOrder: "desc", modalName: "数据登记", columns: [ { checkbox: true, title: '编号' }, { field: 'code', title: '编号', align: 'center', }, { field: 'name', title: '姓名', align: 'center', }] }; $.table.init(options); }); function submitHandler(type) { if ($.validate.form()) { $("input[name='medId']").each(function(i,item){ var html = '' $("#medCodeSave").append(html); }); $("span[name='medName']").each(function(i,item){ var html = '' $("#medNameSave").append(html); }); $.operate.save(prefix + "/add?type="+type, $('#form-information-add').serialize()); } }

4,修改

        

修改消息群发

<!--
--><!--
--><!-- --><!--
--><!--
--><!-- <!-- --><!--
--><!--
--><!--
--><!--
-->
 
var prefix = ctx + "data/information"; $("#form-information-edit").validate({ focusCleanup: true }); $(function () { var panehHidden = false; if ($(this).width() < 769) { panehHidden = true; } $('body').layout({initClosed: panehHidden, west__size: 350}); var options = { url: prefix + "/list", createUrl: prefix + "/add", updateUrl: prefix + "/edit/{id}", removeUrl: prefix + "/remove", exportUrl: prefix + "/export", onClickRow: onClickRow, showSearch: false, showRefresh: false, showColumns: false, showToggle: false, sortName: "createTime", sortOrder: "desc", modalName: "消息群发", columns: [ { checkbox: true }, // { // field: 'id', // title: 'id', // visible: true // }, { field: 'medicineId', title: '编号', align: 'center', }, { field: 'medicineName', title: '名称', align: 'center', }] }; $.table.init(options); }); //点击后显示数据 function onClickRow(row) { window.location.href = prefix + "/edit/" + row.id; } function submitHandler() { if ($.validate.form()) { $.operate.save(prefix + "/edit", $('#form-information-edit').serialize()); } }

二,后端写法

1,MedicineInformationController写法

package com.guizhou.data.domain;import com.guizhou.common.annotation.Excel;import com.guizhou.common.core.domain.BaseEntity;import lombok.Data;import java.util.List;/** * 消息群发对象 medicine_information *  * @author guizhou * @date 2022-02-24 */@Datapublic class MedicineInformation extends BaseEntity{    private static final long serialVersionUID = 1L;    /** id */    private String id;    /** 通知内容 */    @Excel(name = "通知内容")    private String substance;    /** 通知时间 */    @Excel(name = "通知时间")    private String changeTime;    /** 通知人员id */    @Excel(name = "通知人员id")    private String medicineId;    /** 通知人员名称 */    @Excel(name = "通知人员名称")    private String medicineName;    /** 消息状态 1未发送,0已发送 */    @Excel(name = "消息状态 1未发送,0已发送")    private String status;    private List medIds;    private List names;}
package com.guizhou.web.controller.data;import java.util.List;import java.util.Objects;import com.guizhou.common.constant.MedConstants;import com.guizhou.common.utils.DateUtils;import com.guizhou.common.utils.StringUtils;import com.guizhou.framework.util.ShiroUtils;import org.apache.shiro.authz.annotation.RequiresPermissions;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.PostMapping;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import com.guizhou.common.annotation.Log;import com.guizhou.common.enums.BusinessType;import com.guizhou.data.domain.MedicineInformation;import com.guizhou.data.service.IMedicineInformationService;import com.guizhou.common.core.controller.BaseController;import com.guizhou.common.core.domain.AjaxResult;import com.guizhou.common.utils.poi.ExcelUtil;import com.guizhou.common.core.page.TableDataInfo;/** * 消息群发Controller *  * @author guizhou * @date 2022-02-24 */@Controller@RequestMapping("/data/information")public class MedicineInformationController extends BaseController{    private String prefix = "data/information";    private String save = "save";    private String send = "send";    @Autowired    private IMedicineInformationService medicineInformationService;    @RequiresPermissions("data:information:view")    @GetMapping()    public String information()    { return prefix + "/information";    }    /**     * 查询消息群发列表     */    @RequiresPermissions("data:information:list")    @PostMapping("/list")    @ResponseBody    public TableDataInfo list(MedicineInformation medicineInformation)    { startPage(); List list = medicineInformationService.selectMedicineInformationList(medicineInformation); return getDataTable(list);    }    /**     * 导出消息群发列表     */    @RequiresPermissions("data:information:export")    @Log(title = "消息群发", businessType = BusinessType.EXPORT)    @PostMapping("/export")    @ResponseBody    public AjaxResult export(MedicineInformation medicineInformation)    { List list = medicineInformationService.selectMedicineInformationList(medicineInformation); ExcelUtil util = new ExcelUtil(MedicineInformation.class); return util.exportExcel(list, "information");    }    /**     * 新增消息群发     */    @GetMapping("/add")    public String add()    { return prefix + "/add";    }    /**     * 新增保存消息群发     */    @RequiresPermissions("data:information:add")    @Log(title = "消息群发", businessType = BusinessType.INSERT)    @PostMapping("/add")    @ResponseBody    public AjaxResult addSave(MedicineInformation medicineInformation,String type)    { medicineInformation.setId(medicineInformation.getUUId()); medicineInformation.setCreateBy(ShiroUtils.getLoginName()); if(Objects.nonNull(medicineInformation.getMedIds())){     medicineInformation.setMedicineId(StringUtils.join(medicineInformation.getMedIds().toArray(),",")); } if(Objects.nonNull(medicineInformation.getNames())){     medicineInformation.setMedicineName(StringUtils.join(medicineInformation.getNames().toArray(),",")); } //保存数据即可 if(save.equals(type)){     medicineInformation.setStatus(MedConstants.SEND_STATUS_1);     medicineInformation.setChangeTime(DateUtils.getTime()); }else if(send.equals(type)){     medicineInformation.setChangeTime(DateUtils.getTime());     medicineInformation.setStatus(MedConstants.SEND_STATUS_0); } return toAjax(medicineInformationService.insertMedicineInformation(medicineInformation));    }    /**     * 修改消息群发     */    @GetMapping("/edit/{id}")    public String edit(@PathVariable("id") String id, ModelMap mmap)    { MedicineInformation medicineInformation = medicineInformationService.selectMedicineInformationById(id); mmap.put("medicineInformation", medicineInformation); return prefix + "/edit";    }    /**     * 修改保存消息群发     */    @RequiresPermissions("data:information:edit")    @Log(title = "消息群发", businessType = BusinessType.UPDATE)    @PostMapping("/edit")    @ResponseBody    public AjaxResult editSave(MedicineInformation medicineInformation)    { medicineInformation.setUpdateBy(ShiroUtils.getLoginName()); return toAjax(medicineInformationService.updateMedicineInformation(medicineInformation));    }    /**     * 发送消息     */    //带着权限去操作data:information:fs    @RequiresPermissions("data:information:fs")    @Log(title = "消息群发", businessType = BusinessType.UPDATE)    @PostMapping("/fs")    @ResponseBody    public AjaxResult editSave(String id)    { MedicineInformation medicineInformation = medicineInformationService.selectMedicineInformationById(id); medicineInformation.setStatus(MedConstants.SEND_STATUS_0); medicineInformation.setChangeTime(DateUtils.getTime()); medicineInformation.setUpdateBy(ShiroUtils.getLoginName()); return toAjax(medicineInformationService.updateMedicineInformation(medicineInformation));    }    /**     * 查看详细     */    @GetMapping("/detail/{id}")    public String detail(@PathVariable("id") String id, ModelMap mmap) { MedicineInformation medicineInformation = medicineInformationService.selectMedicineInformationById(id); mmap.put("medicineInformation", medicineInformation); return prefix + "/detail";    }    /**     * 删除消息群发     */    @RequiresPermissions("data:information:remove")    @Log(title = "消息群发", businessType = BusinessType.DELETE)    @PostMapping( "/remove")    @ResponseBody    public AjaxResult remove(String ids)    { return toAjax(medicineInformationService.deleteMedicineInformationByIds(ids));    }}

2,IMedicineInformationService写法

  package com.guizhou.data.service;import java.util.List;import com.guizhou.data.domain.MedicineInformation;/** * 消息群发Service接口 *  * @author guizhou * @date 2022-02-24 */public interface IMedicineInformationService {    /**     * 查询消息群发     *      * @param id 消息群发ID     * @return 消息群发     */    public MedicineInformation selectMedicineInformationById(String id);    /**     * 查询消息群发列表     *      * @param medicineInformation 消息群发     * @return 消息群发集合     */    public List selectMedicineInformationList(MedicineInformation medicineInformation);    /**     * 新增消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    public int insertMedicineInformation(MedicineInformation medicineInformation);    /**     * 修改消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    public int updateMedicineInformation(MedicineInformation medicineInformation);    /**     * 批量删除消息群发     *      * @param ids 需要删除的数据ID     * @return 结果     */    public int deleteMedicineInformationByIds(String ids);    /**     * 删除消息群发信息     *      * @param id 消息群发ID     * @return 结果     */    public int deleteMedicineInformationById(String id);}

3,消息群发Service业务层处理(MedicineInformationServiceImpl)

 package com.guizhou.data.service.impl;import java.util.List;import com.guizhou.common.utils.DateUtils;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.guizhou.data.mapper.MedicineInformationMapper;import com.guizhou.data.domain.MedicineInformation;import com.guizhou.data.service.IMedicineInformationService;import com.guizhou.common.core.text.Convert;/** * 消息群发Service业务层处理 *  * @author guizhou * @date 2022-02-24 */@Servicepublic class MedicineInformationServiceImpl implements IMedicineInformationService {    @Autowired    private MedicineInformationMapper medicineInformationMapper;    /**     * 查询消息群发     *      * @param id 消息群发ID     * @return 消息群发     */    @Override    public MedicineInformation selectMedicineInformationById(String id)    { return medicineInformationMapper.selectMedicineInformationById(id);    }    /**     * 查询消息群发列表     *      * @param medicineInformation 消息群发     * @return 消息群发     */    @Override    public List selectMedicineInformationList(MedicineInformation medicineInformation)    { return medicineInformationMapper.selectMedicineInformationList(medicineInformation);    }    /**     * 新增消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    @Override    public int insertMedicineInformation(MedicineInformation medicineInformation)    { medicineInformation.setCreateTime(DateUtils.getNowDate()); return medicineInformationMapper.insertMedicineInformation(medicineInformation);    }    /**     * 修改消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    @Override    public int updateMedicineInformation(MedicineInformation medicineInformation)    { medicineInformation.setUpdateTime(DateUtils.getNowDate()); return medicineInformationMapper.updateMedicineInformation(medicineInformation);    }    /**     * 删除消息群发对象     *      * @param ids 需要删除的数据ID     * @return 结果     */    @Override    public int deleteMedicineInformationByIds(String ids)    { return medicineInformationMapper.deleteMedicineInformationByIds(Convert.toStrArray(ids));    }    /**     * 删除消息群发信息     *      * @param id 消息群发ID     * @return 结果     */    @Override    public int deleteMedicineInformationById(String id)    { return medicineInformationMapper.deleteMedicineInformationById(id);    }}

4,消息群发Mapper接口(MedicineInformationMapper)

 package com.guizhou.data.mapper;import java.util.List;import com.guizhou.data.domain.MedicineInformation;/** * 消息群发Mapper接口 *  * @author guizhou * @date 2022-02-24 */public interface MedicineInformationMapper {    /**     * 查询消息群发     *      * @param id 消息群发ID     * @return 消息群发     */    public MedicineInformation selectMedicineInformationById(String id);    /**     * 查询消息群发列表     *      * @param medicineInformation 消息群发     * @return 消息群发集合     */    public List selectMedicineInformationList(MedicineInformation medicineInformation);    /**     * 新增消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    public int insertMedicineInformation(MedicineInformation medicineInformation);    /**     * 修改消息群发     *      * @param medicineInformation 消息群发     * @return 结果     */    public int updateMedicineInformation(MedicineInformation medicineInformation);    /**     * 删除消息群发     *      * @param id 消息群发ID     * @return 结果     */    public int deleteMedicineInformationById(String id);    /**     * 批量删除消息群发     *      * @param ids 需要删除的数据ID     * @return 结果     */    public int deleteMedicineInformationByIds(String[] ids);}

5,MedicineInformationMapper.xml

                    select id, substance, change_time, medicine_id, medicine_name, status, create_by, create_time, update_by, update_time from medicine_information           and substance = #{substance}      and change_time = #{changeTime}      and medicine_id = #{medicineId}      and medicine_name like concat('%', #{medicineName}, '%')      and status = #{status}  order by create_time desc       where id = #{id}         insert into medicine_information      id,     substance,     change_time,     medicine_id,     medicine_name,     status,     create_by,     create_time,     update_by,     update_time,       #{id},     #{substance},     #{changeTime},     #{medicineId},     #{medicineName},     #{status},     #{createBy},     #{createTime},     #{updateBy},     #{updateTime},          update medicine_information      substance = #{substance},     change_time = #{changeTime},     medicine_id = #{medicineId},     medicine_name = #{medicineName},     status = #{status},     create_by = #{createBy},     create_time = #{createTime},     update_by = #{updateBy},     update_time = #{updateTime},  where id = #{id}         delete from medicine_information where id = #{id}         delete from medicine_information where id in       #{id}