客户类别维护，修改sql
diff --git a/src/main/resources/templates/restaurant/custtype/index.html b/src/main/resources/templates/restaurant/custtype/index.html
new file mode 100644
index 0000000..a09bdca
--- /dev/null
+++ b/src/main/resources/templates/restaurant/custtype/index.html
@@ -0,0 +1,109 @@
+<div class="layui-card">
+ <div class="layui-card-header">
+ <h2 class="header-title">客户类别维护</h2>
+ <span class="layui-breadcrumb pull-right">
+ <a href="#">客户类别维护</a>
+ <a><cite>客户类别维护</cite></a>
+ </span>
+ </div>
+ <div class="layui-card-body">
+ <div class="layui-form toolbar">
+ 搜索：
+ <input id="custtype-search-value" class="layui-input search-input" type="text" placeholder="输入类别名称"/> 
+ <button id="custtype-btn-search" class="layui-btn icon-btn" data-type="search"><i class="layui-icon"></i>搜索
+ </button>
+ <button id="custtype-btn-add" class="layui-btn icon-btn" data-type="add"><i class="layui-icon"></i>添加类别</button>
+ </div>
+ <table class="layui-table" id="custtype-table" lay-filter="custtype-table"></table>
+ </div>
+</div>
+<script>
+
+ layui.use(['form', 'table', 'layer', 'admin', 'element'], function () {
+ let form = layui.form;
+ let table = layui.table;
+ let admin = layui.admin;
+
+ // form.render('select');
+
+ // 渲染表格
+ table.render({
+ elem: '#custtype-table',
+ url: '[[@{/custtype/list}]]',
+ page: true,
+ cols: [
+ [
+ {field: 'custtypeid', title: '类别号', fixed: 'left', sort: true},
+ {field: 'custtypename', title: '类别名称', sort: true},
+ {
+ field: 'custtypeid', align: 'center',width:160, title: '操作', fixed: 'right', templet: function (item) {
+ return ' <a class="layui-btn layui-btn-xs" lay-event="custtype-edit"><i class="layui-icon layui-icon-edit"></i>编辑</a> ' +
+ ' <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="custtype-del"><i class="layui-icon layui-icon-delete"></i>删除</a>'
+ }
+ }
+ ]
+ ]
+ });
+ // 搜索按钮点击事件
+ $('#custtype-btn-search').click(function () {
+ let key = $('#custtype-search-value').val();
+ table.reload('custtype-table', {where: {searchkey: key}, page: {curr: 1}});
+ });
+ $('#custtype-btn-add').click(function () {
+ showModel();
+ });
+ let showModel = function (data) {
+ let title = data ? '修改客户类别' : '添加客户类别';
+ admin.putTempData('t_ct', data);
+ admin.popupCenter({
+ title: title,
+ path: '[[@{/custtype/loadadd}]]',
+ finish: function () {
+ table.reload('custtype-table', {});
+ }
+ });
+ };
+
+
+ // 工具条点击事件
+ table.on('tool(custtype-table)', function (obj) {
+ let data = obj.data;
+ let layEvent = obj.event;
+ console.log(data);
+ if (layEvent === 'custtype-edit') {
+ showModel(data);
+ } else if (layEvent === 'custtype-del') {
+ showDelete(data);
+ }
+ });
+ let showDelete = function (data) {
+ layer.confirm('确定要删除吗？', function (i) {
+ layer.close(i);
+ layer.load(2);
+ let token = $("meta[name='_csrf_token']").attr("value");
+ admin.go('[[@{/custtype/delete}]]', {
+ id: data.custtypeid,
+ _csrf: token
+ }, function (data) {
+ console.log(data.code);
+ layer.closeAll('loading');
+ if (data.code == 200) {
+ layer.msg(data.msg, {icon: 1});
+ } else if (data.code == 401) {
+ layer.msg(data.msg, {icon: 2, time: 1500}, function () {
+ location.replace('/login');
+ }, 1000);
+ return;
+ } else {
+ layer.msg(data.msg, {icon: 2});
+ }
+ table.reload('table', {});
+ }, function (ret) {
+ console.log(ret);
+ layer.closeAll('loading');
+ layer.msg('请求失败了，请稍后再试', {icon: 2});
+ });
+ });
+ }
+ });
+</script>