目录
1,MedicineInformationController写法
2,IMedicineInformationService写法
3,消息群发Service业务层处理(MedicineInformationServiceImpl)
4,消息群发Mapper接口(MedicineInformationMapper)
5,MedicineInformationMapper.xml
一,实现发送
1,前端html写法:
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org" xmlns:shiro="http://www.pollix.at/thymeleaf/shiro">
<head>
<th:block th:include="include :: header('消息群发列表')"/>
</head>
<body class="gray-bg">
<div class="container-div">
<div class="row">
<div class="col-sm-12 search-collapse">
<form id="formId">
<div class="select-list">
<ul>
<li>
<label>通知时间:</label>
<input type="text" class="time-input" id="startTime" name="changeTime" readonly/>
</li>
<li>
<label>通知人员:</label>
<input type="text" name="medicineName"/>
</li>
<li>
<a class="btn btn-primary btn-rounded btn-sm" onclick="$.table.search()"><i
class="fa fa-search"></i> 查询</a>
<a class="btn btn-warning btn-rounded btn-sm" onclick="$.form.reset()"><i
class="fa fa-refresh"></i> 重置</a>
</li>
</ul>
</div>
</form>
</div>
<div class="btn-group-sm" id="toolbar" role="group">
<a class="btn btn-success" onclick="addInformation()"
shiro:hasPermission="data:information:add">
<i class="fa fa-plus"></i> 添加
</a>
</div>
<div class="col-sm-12 select-table table-striped">
<table id="bootstrap-table"></table>
</div>
</div>
</div>
<th:block th:include="include :: footer"/>
<script th:inline="javascript">
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('<a class="btn btn-success btn-xs ' + fsFlag + '" href="javascript:void(0)" ' +
'onclick="statusTools(\'' + row.id + '\')" >' +
'<i class="fa fa-send"></i>发送</a> ');
actions.push('<a class="btn btn-warning btn-xs ' + editFlag + '" href="javascript:void(0)" ' +
'onclick="$.operate.editTab(\'' + row.id + '\')">' +
'<i class="fa fa-edit"></i>修改</a> ');
actions.push('<a class="btn btn-primary btn-xs" href="javascript:void(0)" ' +
'onclick="$.operate.detail(\'' + row.id + '\')">' +
'<i class="fa fa-search"></i>查看</a>');
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("发送失败。");
}
});
}
</script>
</body>
</html>
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: "<img src='" + src + "' height='" + height + "' width='" + width + "'/>"
});
} 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('<input id="tooltip-show" style="opacity: 0;position: absolute;z-index:-1" type="text" value="%s"/>', _value));
actions.push($.common.sprintf('<a href="###" class="tooltip-show" data-toggle="tooltip" data-target="%s" title="%s">%s</a>', _target, _value, _text));
return actions.join('');
} else {
_text = _value;
return _text;
}
},
// 下拉按钮切换
dropdownToggle: function (value) {
var actions = [];
actions.push('<div class="btn-group">');
actions.push('<button type="button" class="btn btn-xs dropdown-toggle" data-toggle="dropdown" aria-expanded="false">');
actions.push('<i class="fa fa-cog"></i> <span class="fa fa-chevron-down"></span></button>');
actions.push('<ul class="dropdown-menu">');
actions.push(value.replace(/<a/g,"<li><a").replace(/<\/a>/g,"</a></li>"));
actions.push('</ul>');
actions.push('</div>');
return actions.join('');
},
// 图片预览
imageView: function (value, height, width, target) {
if ($.common.isEmpty(width)) {
width = 'auto';
}
if ($.common.isEmpty(height)) {
height = 'auto';
}
// blank or self
var _target = $.common.isEmpty(target) ? 'self' : target;
if ($.common.isNotEmpty(value)) {
return $.common.sprintf("<img class='img-circle img-xs' data-height='%s' data-width='%s' data-target='%s' src='%s'/>", 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: ['<i class="fa fa-check"></i> 导入', '<i class="fa fa-remove"></i> 取消'],
// 弹层外区域关闭
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: ['<i class="fa fa-check"></i> 导入', '<i class="fa fa-remove"></i> 取消'],
// 弹层外区域关闭
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("<span class='%s'>%s</span>", 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 = ['<i class="fa fa-check"></i> 确认', '<i class="fa fa-close"></i> 关闭'];
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: '<div class="loaderbox"><div class="loading-activity"></div> ' + message + '</div>' });
},
// 关闭遮罩层
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 < nodes.length; i++) {
tree.expandNode(nodes[i], true, false, false);
}
var node = tree.getNodesByParam("id", treeId, null)[0];
$.tree.selectByIdName(treeId, node);
});
},
//查询节点
searchNode: function() {
// 取得输入的关键字的值
var value = $.common.trim($("#keyword").val());
if ($.tree._lastValue == value) {
return;
}
// 保存最后一次查询名称
$.tree._lastValue = value;
var nodes = $._tree.getNodes();
// 如果要查空字串,就退出不查了。
if (value == "") {
$.tree.showAllNode(nodes);
return;
}
$.tree.hideAllNode(nodes);
// 根据查询值模糊匹配
$.tree.updateNodes($._tree.getNodesByParamFuzzy("name", value));
},
// 根据Id和Name选中指定节点
selectByIdName: function(treeId, node) {
if ($.common.isNotEmpty(treeId) && treeId == node.id) {
$._tree.selectNode(node, true);
}
},
// 显示所有节点
showAllNode: function(nodes) {
nodes = $._tree.transformToArray(nodes);
for (var i = nodes.length - 1; 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,新增
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org">
<head>
<th:block th:include="include :: header('新增消息群发')"/>
<th:block th:include="include :: layout-latest-css"/>
</head>
<style>
</style>
<body class="gray-bg">
<div class="ui-layout-west">
<div class="box box-main">
<div class="box-header">
<div class="box-tools">
<form id="formId">
<div class="select-list">
<ul>
<li>
<label style="width: auto">编号/姓名:</label>
<input type="text" id="codeName" name="codeName" style="width: 42%"/>
<a class="btn btn-primary btn-rounded btn-sm" onclick="$.table.search()"><i
class="fa fa-search"></i> 查询</a>
</li>
</ul>
</div>
</form>
</div>
</div>
<div class="col-sm-12 select-table table-striped">
<table id="bootstrap-table"></table>
</div>
</div>
</div>
<div class="ui-layout-center">
<div class="main-content">
<form class="form-horizontal m" id="form-information-add">
<h4 class="form-header h4">新增消息群发</h4>
<div class="row">
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 12%">通知内容:</label>
<div class="col-sm-10">
<textarea name="substance" class="form-control" type="text" required></textarea>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 12%">通知人员:</label>
<input id="medicineId" name="medicineId" type="hidden"/>
<input id="medicineName" name="medicineName" type="hidden"/>
<div id="medDiv" class="col-sm-10" style="padding-top: 5px">
<!--<input name="medicineName" class="form-control" type="text">-->
</div>
<div id="medNameSave">
</div>
<div id="medCodeSave">
</div>
</div>
</div>
</div>
<hr>
<div class="row">
<div style="text-align:right;" class="col-sm-12">
<button type="button" class="btn btn-sm btn-primary" onclick="submitHandler('save')"><i
class="fa fa-check"></i>保 存
</button>
<button type="button" class="btn btn-sm btn-success" onclick="submitHandler('send')"><i
class="fa fa-send"></i>发 送
</button>
<button type="button" class="btn btn-sm btn-danger" onclick="closeItem()"><i
class="fa fa-reply-all"></i>关 闭
</button>
</div>
</div>
</form>
</div>
</div>
<th:block th:include="include :: footer"/>
<th:block th:include="include :: layout-latest-js"/>
<script th:inline="javascript">
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 = "<span id="+row.code+"Name name='medName' " +
"style='background: #dd4b39;" +
"padding: 10px 10px;margin-right:10px;color: #FFFFFF''>"+row.name+"</span>"
+ "<input id="+row.id+"Id name='medId' value="+row.id+" type='hidden'/>";
$("#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 = '<input type="hidden" name="medIds['+i+']" value="'+item.value+'">'
$("#medCodeSave").append(html);
});
$("span[name='medName']").each(function(i,item){
var html = '<input type="hidden" name="names['+i+']" value="'+item.innerText+'">'
$("#medNameSave").append(html);
});
$.operate.save(prefix + "/add?type="+type, $('#form-information-add').serialize());
}
}
</script>
</body>
</html>
4,修改
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org">
<head>
<th:block th:include="include :: header('修改消息群发')"/>
<th:block th:include="include :: layout-latest-css"/>
</head>
<style>
</style>
<body class="gray-bg">
<div class="ui-layout-west">
<div class="box box-main">
<div class="box-header">
<div class="box-tools">
<form id="formId">
<div class="select-list">
<ul>
<li>
<label style="width: auto">编号/姓名:</label>
<input type="text" id="medicineId" name="medicineId" style="width: 42%"/>
<a class="btn btn-primary btn-rounded btn-sm" onclick="$.table.search()"><i
class="fa fa-search"></i> 查询</a>
</li>
</ul>
</div>
</form>
</div>
</div>
<div class="col-sm-12 select-table table-striped">
<table id="bootstrap-table"></table>
</div>
</div>
</div>
<div class="ui-layout-center">
<div class="main-content">
<form class="form-horizontal m" id="form-information-edit" th:object="${medicineInformation}">
<input name="id" th:field="*{id}" type="hidden">
<h4 class="form-header h4">修改消息群发</h4>
<div class="row">
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 15%">通知内容:</label>
<div class="col-sm-10">
<input name="substance" th:field="*{substance}" class="form-control" type="text">
</div>
</div>
</div>
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 15%">通知人员id:</label>
<div class="col-sm-10">
<input name="medicineId" th:field="*{medicineId}" class="form-control" type="text">
</div>
</div>
</div>
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 15%">通知人员名称:</label>
<div class="col-sm-10">
<input name="medicineName" th:field="*{medicineName}" class="form-control" type="text">
</div>
</div>
</div>
<!-- <div class="col-sm-12">-->
<!-- <div class="form-group">-->
<!-- <label class="col-sm-1 control-label" style="width: 15%">消息发送状态:</label>-->
<!-- <div class="col-sm-10">-->
<!-- <div class="radio-box" th:each="dict : ${@dict.getType('information')}">-->
<!-- <input type="radio" th:id="${dict.dictCode}" name="status" th:value="${dict.dictValue}"-->
<!-- th:field="*{status}">-->
<!-- <label th:for="${dict.dictCode}" th:text="${dict.dictLabel}"></label>-->
<!-- </div>-->
<!-- </div>-->
<!-- </div>-->
<!-- </div>-->
<div class="col-sm-12">
<div class="form-group">
<label class="col-sm-1 control-label" style="width: 15%">通知时间:</label>
<div class="col-sm-10">
<input type="text" th:field="*{changeTime}" class="time-input"
id="startTime" placeholder="选择时间" name="changeTime"/>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-10">
<button type="button" class="btn btn-sm btn-primary" onclick="submitHandler()"><i
class="fa fa-check"></i>保 存
</button>
<button type="button" class="btn btn-sm btn-danger" onclick="closeItem()"><i
class="fa fa-reply-all"></i>关 闭
</button>
</div>
</div>
</form>
</div>
</div>
<th:block th:include="include :: footer"/>
<th:block th:include="include :: layout-latest-js"/>
<script th:inline="javascript">
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());
}
}
</script>
</body>
</html>
二,后端写法
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
*/
@Data
public 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<String> medIds;
private List<String> 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<MedicineInformation> 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<MedicineInformation> list = medicineInformationService.selectMedicineInformationList(medicineInformation);
ExcelUtil<MedicineInformation> util = new ExcelUtil<MedicineInformation>(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<MedicineInformation> 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
*/
@Service
public 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<MedicineInformation> 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<MedicineInformation> 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
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.guizhou.data.mapper.MedicineInformationMapper">
<resultMap type="MedicineInformation" id="MedicineInformationResult">
<result property="id" column="id" />
<result property="substance" column="substance" />
<result property="changeTime" column="change_time" />
<result property="medicineId" column="medicine_id" />
<result property="medicineName" column="medicine_name" />
<result property="status" column="status" />
<result property="createBy" column="create_by" />
<result property="createTime" column="create_time" />
<result property="updateBy" column="update_by" />
<result property="updateTime" column="update_time" />
</resultMap>
<sql id="selectMedicineInformationVo">
select id, substance, change_time, medicine_id, medicine_name, status, create_by, create_time, update_by, update_time from medicine_information
</sql>
<select id="selectMedicineInformationList" parameterType="MedicineInformation" resultMap="MedicineInformationResult">
<include refid="selectMedicineInformationVo"/>
<where>
<if test="substance != null and substance != ''"> and substance = #{substance}</if>
<if test="changeTime != null and changeTime != ''"> and change_time = #{changeTime}</if>
<if test="medicineId != null and medicineId != ''"> and medicine_id = #{medicineId}</if>
<if test="medicineName != null and medicineName != ''"> and medicine_name like concat('%', #{medicineName}, '%')</if>
<if test="status != null and status != ''"> and status = #{status}</if>
</where>
order by create_time desc
</select>
<select id="selectMedicineInformationById" parameterType="String" resultMap="MedicineInformationResult">
<include refid="selectMedicineInformationVo"/>
where id = #{id}
</select>
<insert id="insertMedicineInformation" parameterType="MedicineInformation">
insert into medicine_information
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null and id != ''">id,</if>
<if test="substance != null and substance != ''">substance,</if>
<if test="changeTime != null and changeTime != ''">change_time,</if>
<if test="medicineId != null and medicineId != ''">medicine_id,</if>
<if test="medicineName != null and medicineName != ''">medicine_name,</if>
<if test="status != null and status != ''">status,</if>
<if test="createBy != null and createBy != ''">create_by,</if>
<if test="createTime != null ">create_time,</if>
<if test="updateBy != null and updateBy != ''">update_by,</if>
<if test="updateTime != null ">update_time,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="id != null and id != ''">#{id},</if>
<if test="substance != null and substance != ''">#{substance},</if>
<if test="changeTime != null and changeTime != ''">#{changeTime},</if>
<if test="medicineId != null and medicineId != ''">#{medicineId},</if>
<if test="medicineName != null and medicineName != ''">#{medicineName},</if>
<if test="status != null and status != ''">#{status},</if>
<if test="createBy != null and createBy != ''">#{createBy},</if>
<if test="createTime != null ">#{createTime},</if>
<if test="updateBy != null and updateBy != ''">#{updateBy},</if>
<if test="updateTime != null ">#{updateTime},</if>
</trim>
</insert>
<update id="updateMedicineInformation" parameterType="MedicineInformation">
update medicine_information
<trim prefix="SET" suffixOverrides=",">
<if test="substance != null and substance != ''">substance = #{substance},</if>
<if test="changeTime != null and changeTime != ''">change_time = #{changeTime},</if>
<if test="medicineId != null and medicineId != ''">medicine_id = #{medicineId},</if>
<if test="medicineName != null and medicineName != ''">medicine_name = #{medicineName},</if>
<if test="status != null and status != ''">status = #{status},</if>
<if test="createBy != null and createBy != ''">create_by = #{createBy},</if>
<if test="createTime != null ">create_time = #{createTime},</if>
<if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if>
<if test="updateTime != null ">update_time = #{updateTime},</if>
</trim>
where id = #{id}
</update>
<delete id="deleteMedicineInformationById" parameterType="String">
delete from medicine_information where id = #{id}
</delete>
<delete id="deleteMedicineInformationByIds" parameterType="String">
delete from medicine_information where id in
<foreach item="id" collection="array" open="(" separator="," close=")">
#{id}
</foreach>
</delete>
</mapper>