From 165764ed9415e176871f99f0253301f48fe3663a Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期四, 04 七月 2024 18:21:10 +0800
Subject: [PATCH] #

---
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/LocTypeBind.java                  |  242 ++++++++++++++++
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/LocTypeBindService.java          |    8 
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/impl/LocTypeBindServiceImpl.java |   12 
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/utils/CodeBuilder.java                        |    4 
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocTypeBindController.java    |  102 ++++++
 zy-asrs-admin/src/views/base/locTypeBind/edit.vue                                       |  173 +++++++++++
 zy-asrs-admin/src/views/base/locTypeBind/index.vue                                      |  291 +++++++++++++++++++
 zy-asrs-wms/src/main/resources/mapper/asrs/LocTypeBindMapper.xml                        |    5 
 zy-asrs-admin/src/locales/en_US.js                                                      |    1 
 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/LocTypeBindMapper.java            |   12 
 zy-asrs-wms/src/main/java/locTypeBind.sql                                               |    9 
 11 files changed, 857 insertions(+), 2 deletions(-)

diff --git a/zy-asrs-admin/src/locales/en_US.js b/zy-asrs-admin/src/locales/en_US.js
index 13fa638..9c627f5 100644
--- a/zy-asrs-admin/src/locales/en_US.js
+++ b/zy-asrs-admin/src/locales/en_US.js
@@ -71,6 +71,7 @@
     'page.reset.pwd':'Reset Pwd',
     'page.assign.role':'Assign Role',
     'page.input':'Please Input',
+    'page.init':'Init',
     '':'',
     '':'',
     '':'',
diff --git a/zy-asrs-admin/src/views/base/locTypeBind/edit.vue b/zy-asrs-admin/src/views/base/locTypeBind/edit.vue
new file mode 100644
index 0000000..238736f
--- /dev/null
+++ b/zy-asrs-admin/src/views/base/locTypeBind/edit.vue
@@ -0,0 +1,173 @@
+<script setup>
+import { ref, nextTick } from 'vue';
+import { get, post, postBlob, postForm } from '@/utils/request.js'
+import { formatMessage } from '@/utils/localeUtils.js';
+import { message } from 'ant-design-vue';
+
+const formTable = ref(null);
+const submitButton = ref(null);
+const isSave = ref(true);
+const open = ref(false);
+const initFormData = {}
+let formData = ref(initFormData);
+
+const emit = defineEmits(['tableReload'])
+
+const handleOk = (e) => {
+    nextTick(() => {
+        setTimeout(() => {
+            submitButton.value.$el.click();
+        }, 100);
+    });
+};
+
+const onFinish = values => {
+    // console.log('Success:', values);
+    open.value = false;
+    post(isSave.value ? '/api/locTypeBind/save' : '/api/locTypeBind/update', formData.value).then((resp) => {
+        let result = resp.data;
+        if (result.code === 200) {
+            message.success(isSave.value ? formatMessage('page.add.success', '鏂板鎴愬姛') : formatMessage('page.update.success', '鏇存柊鎴愬姛'));
+        } else {
+            message.error(result.msg);
+        }
+        emit('tableReload', 'reload')
+        nextTick(() => {
+            formTable.value.resetFields()
+        })
+    })
+};
+const onFinishFailed = errorInfo => {
+    console.log('Failed:', errorInfo);
+};
+
+const locQueryList = ref(null);
+locQuery();
+function locQuery() {
+    postForm('/api/loc/query', {}).then(resp => {
+        let result = resp.data;
+        locQueryList.value = result.data;
+    })
+}
+const locTypeQueryList = ref(null);
+locTypeQuery();
+function locTypeQuery() {
+    post('/api/locType/tree', {}).then(resp => {
+        let result = resp.data;
+        locTypeQueryList.value = result.data;
+    })
+}
+const userQueryList = ref(null);
+userQuery();
+function userQuery() {
+    postForm('/api/user/query', {}).then(resp => {
+        let result = resp.data;
+        userQueryList.value = result.data;
+    })
+}
+
+
+defineExpose({
+    open,
+    formData,
+    initFormData,
+    isSave,
+})
+
+</script>
+
+<script>
+export default {
+    name: '搴撲綅绫诲瀷缁戝畾-edit'
+}
+</script>
+
+<template>
+    <div>
+        <a-modal v-model:open="open"
+            :title="isSave ? formatMessage('page.add', '娣诲姞') : formatMessage('page.edit', '缂栬緫')" @ok="handleOk"
+            style="width: 600px;">
+            <a-form :model="formData" ref="formTable" name="formTable" :label-col="{ span: 8 }"
+                :wrapper-col="{ span: 16 }" style="display: flex;justify-content: space-between;flex-wrap: wrap;"
+                autocomplete="off" @finish="onFinish" @finishFailed="onFinishFailed">
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.loc_id', '搴撲綅')" name="locId"
+                    style="width: 250px;" :rules="[{ required: true }]">
+                    <a-select v-model:value="formData.locId" :placeholder="formatMessage('common.select', '璇烽�夋嫨')"
+                        style="width: 100%" show-search :options="locQueryList" optionFilterProp="label"
+                        optionLabelProp="label">
+                    </a-select>
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_area_type.type_id', '搴撲綅绫诲瀷')" name="typeId"
+                    style="width: 250px;" :rules="[{ required: true }]">
+                    <a-tree-select v-model:value="formData.typeId" show-search style="width: 100%"
+                        :dropdown-style="{ maxHeight: '400px', overflow: 'auto' }"
+                        :placeholder="formatMessage('page.input', '璇疯緭鍏�')" allow-clea tree-data-simple-mode
+                        :tree-data="locTypeQueryList" tree-node-filter-prop="name" :field-names="{
+                            children: 'children',
+                            label: 'name',
+                            value: 'id',
+                        }">
+                        <template #title="{ value: id, name }">
+                            {{ name }}
+                        </template>
+                    </a-tree-select>
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.uuid', '缂栧彿')" name="uuid"
+                    style="width: 250px;">
+                    <a-input v-model:value="formData.uuid" />
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.name', '鍚嶇О')" name="name"
+                    style="width: 250px;">
+                    <a-input v-model:value="formData.name" />
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.flag', '鏍囪瘑')" name="flag"
+                    style="width: 250px;">
+                    <a-input v-model:value="formData.flag" />
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.status', '鐘舵��')" name="status"
+                    style="width: 250px;">
+                    <a-select v-model:value="formData.status" :options="[
+                        { label: '姝e父', value: 1 },
+                        { label: '绂佺敤', value: 0 },
+                    ]">
+                    </a-select>
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.create_time', '娣诲姞鏃堕棿')" name="createTime"
+                    style="width: 250px;">
+                    <a-date-picker v-model:value="formData.createTime" show-time format="YYYY-MM-DD HH:mm:ss"
+                        value-format="YYYY-MM-DD HH:mm:ss" />
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.create_by', '娣诲姞浜哄憳')" name="createBy"
+                    style="width: 250px;">
+                    <a-select v-model:value="formData.createBy" :placeholder="formatMessage('common.select', '璇烽�夋嫨')"
+                        style="width: 100%" show-search :options="userQueryList" optionFilterProp="label"
+                        optionLabelProp="label">
+                    </a-select>
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.update_time', '淇敼鏃堕棿')" name="updateTime"
+                    style="width: 250px;">
+                    <a-date-picker v-model:value="formData.updateTime" show-time format="YYYY-MM-DD HH:mm:ss"
+                        value-format="YYYY-MM-DD HH:mm:ss" />
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.update_by', '淇敼浜哄憳')" name="updateBy"
+                    style="width: 250px;">
+                    <a-select v-model:value="formData.updateBy" :placeholder="formatMessage('common.select', '璇烽�夋嫨')"
+                        style="width: 100%" show-search :options="userQueryList" optionFilterProp="label"
+                        optionLabelProp="label">
+                    </a-select>
+                </a-form-item>
+                <a-form-item :label="formatMessage('db.man_loc_type_bind.memo', '澶囨敞')" name="memo"
+                    style="width: 250px;">
+                    <a-input v-model:value="formData.memo" />
+                </a-form-item>
+
+                <a-form-item>
+                    <a-button type="primary" html-type="submit" ref="submitButton"
+                        style="visibility: hidden;">Submit</a-button>
+                </a-form-item>
+            </a-form>
+        </a-modal>
+    </div>
+</template>
+
+<style></style>
diff --git a/zy-asrs-admin/src/views/base/locTypeBind/index.vue b/zy-asrs-admin/src/views/base/locTypeBind/index.vue
new file mode 100644
index 0000000..4490c60
--- /dev/null
+++ b/zy-asrs-admin/src/views/base/locTypeBind/index.vue
@@ -0,0 +1,291 @@
+<script setup>
+import { getCurrentInstance, ref, computed, reactive } from 'vue';
+import { useRouter } from "vue-router";
+import { get, post, postBlob } from '@/utils/request.js'
+import { message, Modal } from 'ant-design-vue';
+import { logout } from '@/config.js';
+import EditView from './edit.vue'
+import { formatMessage } from '@/utils/localeUtils.js';
+const context = getCurrentInstance()?.appContext.config.globalProperties;
+
+const router = useRouter();
+
+const TABLE_KEY = 'table-locTypeBind';
+let currentPage = 1;
+let pageSize = 10;
+const searchInput = ref("")
+const editChild = ref(null)
+
+let currentLocType = ref(null)
+let tableData = ref([]);
+getPage();
+
+const columns = [
+  {
+    title: formatMessage('db.man_loc_type_bind.loc_id', '搴撲綅'),
+    dataIndex: 'locId$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.type_id', '搴撲綅绫诲瀷'),
+    dataIndex: 'typeId$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.uuid', '缂栧彿'),
+    dataIndex: 'uuid',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.name', '鍚嶇О'),
+    dataIndex: 'name',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.flag', '鏍囪瘑'),
+    dataIndex: 'flag',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.status', '鐘舵��'),
+    dataIndex: 'status$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.create_time', '娣诲姞鏃堕棿'),
+    dataIndex: 'createTime$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.create_by', '娣诲姞浜哄憳'),
+    dataIndex: 'createBy$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.update_time', '淇敼鏃堕棿'),
+    dataIndex: 'updateTime$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.update_by', '淇敼浜哄憳'),
+    dataIndex: 'updateBy$',
+    width: 140,
+    ellipsis: true,
+  },
+  {
+    title: formatMessage('db.man_loc_type_bind.memo', '澶囨敞'),
+    dataIndex: 'memo',
+    width: 140,
+    ellipsis: true,
+  },
+
+  {
+    title: formatMessage('common.operation', '鎿嶄綔'),
+    name: 'oper',
+    dataIndex: 'oper',
+    key: 'oper',
+    width: 140,
+  },
+];
+
+const state = reactive({
+  selectedRowKeys: [],
+  loading: false,
+});
+const hasSelected = computed(() => state.selectedRowKeys.length > 0);
+const start = () => {
+  state.loading = true;
+  // ajax request after empty completing
+  setTimeout(() => {
+    state.loading = false;
+    state.selectedRowKeys = [];
+  }, 1000);
+};
+const onSelectChange = selectedRowKeys => {
+  // console.log('selectedRowKeys changed: ', selectedRowKeys);
+  state.selectedRowKeys = selectedRowKeys;
+};
+
+function getPage() {
+  post('/api/locTypeBind/page', {
+    current: currentPage,
+    pageSize: pageSize,
+    condition: searchInput.value,
+    typeId: currentLocType?.value,
+  }).then((resp) => {
+    let result = resp.data;
+    if (result.code == 200) {
+      let data = result.data;
+      tableData.value = data;
+    } else if (result.code === 401) {
+      message.error(result.msg);
+      logout()
+    } else {
+      message.error(result.msg);
+    }
+  })
+}
+
+const handleEdit = (item) => {
+  editChild.value.open = true;
+  editChild.value.formData = item == null ? editChild.value.initFormData : JSON.parse(JSON.stringify(item));
+  editChild.value.isSave = item == null;
+}
+
+const handleDel = (rows) => {
+  Modal.confirm({
+    title: formatMessage('page.delete', '鍒犻櫎'),
+    content: formatMessage('page.delete.confirm', '纭畾鍒犻櫎璇ラ」鍚楋紵'),
+    maskClosable: true,
+    onOk: async () => {
+      const hide = message.loading(formatMessage('common.loading', '璇锋眰涓�'));
+      try {
+        post('/api/locTypeBind/remove/' + rows.map((row) => row.id).join(','), {}).then(resp => {
+          let result = resp.data;
+          if (result.code === 200) {
+            message.success(result.msg);
+          } else {
+            message.error(result.msg);
+          }
+          getPage()
+          hide()
+        })
+      } catch (error) {
+        message.error(formatMessage('common.fail', '璇锋眰澶辫触'));
+      }
+    },
+  });
+}
+
+const handleExport = async (intl) => {
+  postBlob('/api/locTypeBind/export', {}).then(result => {
+    const blob = new Blob([result.data], { type: 'application/vnd.ms-excel' });
+    window.location.href = window.URL.createObjectURL(blob);
+    return true;
+  })
+};
+
+const onSearch = () => {
+  // console.log('search');
+  getPage()
+}
+
+const onPageChange = (page, size) => {
+  currentPage = page;
+  pageSize = size;
+  getPage();
+}
+
+function handleTableReload(value) {
+  getPage()
+}
+
+let locTypeExpandedKeys = ref([]);
+let locTypeData = ref([]);
+let searchLocType = ref("");
+getLocTypeData()
+function getLocTypeData() {
+  post('/api/locType/tree', {
+    current: currentPage,
+    pageSize: pageSize,
+    condition: searchLocType.value
+  }).then((resp) => {
+    let result = resp.data;
+    if (result.code == 200) {
+      let data = result.data;
+      locTypeData.value = [{
+        id: null,
+        name: '鍏ㄩ儴',
+        children: data
+      }]
+    } else if (result.code === 401) {
+      message.error(result.msg);
+      logout()
+    } else {
+      message.error(result.msg);
+    }
+
+    locTypeExpandedKeys.value = ['0-0']
+  })
+}
+
+const handleLocTypeSelected = (selectedKeys, e) => {
+  let tmp = [];
+  if(e.node.children != null) {
+    e.node.children.forEach((item) => {
+      tmp.push(item.id);
+    })
+  }
+  tmp.push(e.node.id)
+  currentLocType.value = tmp;
+  if(e.node.id == null) {
+    currentLocType.value = null;
+  }
+  getPage()
+}
+
+const handleLocTypeDept = (e) => {
+  getLocTypeData()
+}
+
+</script>
+
+<script>
+export default {
+  name: '搴撲綅绫诲瀷缁戝畾'
+}
+</script>
+
+<template>
+  <div style="display: flex;">
+    <a-card :title="formatMessage('db.man_loc_area_type.type_id', '搴撲綅绫诲瀷')" style="flex: 3;margin-right: 30px;">
+      <a-input v-model:value="searchLocType" @change="handleLocAreaTypeDept"
+        :placeholder="formatMessage('page.input', '璇疯緭鍏�')" style="margin-bottom: 8px" />
+      <a-tree v-model:expandedKeys="locTypeExpandedKeys" @select="handleLocTypeSelected"
+        :tree-data="locTypeData" blockNode>
+        <template #title="{ name }">
+          <span>{{ name }}</span>
+        </template>
+      </a-tree>
+    </a-card>
+
+    <a-card style="flex: 10;">
+      <EditView ref="editChild" @tableReload="handleTableReload" />
+      <div class="table-header">
+        <a-input-search v-model:value="searchInput" :placeholder="formatMessage('page.input', '璇疯緭鍏�')"
+          style="width: 200px;" @search="onSearch" />
+        <div class="table-header-right">
+          <a-button @click="handleEdit(null)" type="primary">{{ formatMessage('page.init', '鍒濆鍖�') }}</a-button>
+          <a-button @click="handleEdit(null)" type="primary">{{ formatMessage('page.add', '娣诲姞') }}</a-button>
+          <a-button @click="handleExport">{{ formatMessage('page.export', '瀵煎嚭') }}</a-button>
+        </div>
+      </div>
+      <a-table :row-selection="{ selectedRowKeys: state.selectedRowKeys, onChange: onSelectChange }"
+        :data-source="tableData.records" :defaultExpandAllRows="false" :key="TABLE_KEY" rowKey="id"
+        :pagination="{ total: tableData.total, onChange: onPageChange }"
+        :scroll="{ y: 768, scrollToFirstRowOnChange: true }" :columns="columns">
+        <template #bodyCell="{ column, text, record }">
+          <template v-if="column.dataIndex === 'oper'">
+            <div style="display: flex;justify-content: space-evenly;">
+              <a-button type="link" primary @click="handleEdit(record)">{{ formatMessage('page.edit', '缂栬緫')
+                }}</a-button>
+              <a-button type="link" danger @click="handleDel([record])">{{ formatMessage('page.delete', '鍒犻櫎')
+                }}</a-button>
+            </div>
+          </template>
+        </template>
+      </a-table>
+    </a-card>
+  </div>
+</template>
+
+<style></style>
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocTypeBindController.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocTypeBindController.java
new file mode 100644
index 0000000..28a1350
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/controller/LocTypeBindController.java
@@ -0,0 +1,102 @@
+package com.zy.asrs.wms.asrs.controller;
+
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.zy.asrs.framework.common.Cools;
+import com.zy.asrs.framework.common.R;
+import com.zy.asrs.wms.common.annotation.OperationLog;
+import com.zy.asrs.wms.common.domain.BaseParam;
+import com.zy.asrs.wms.common.domain.KeyValVo;
+import com.zy.asrs.wms.common.domain.PageParam;
+import com.zy.asrs.wms.asrs.entity.LocTypeBind;
+import com.zy.asrs.wms.asrs.service.LocTypeBindService;
+import com.zy.asrs.wms.system.controller.BaseController;
+import com.zy.asrs.wms.utils.ExcelUtil;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.access.prepost.PreAuthorize;
+import org.springframework.web.bind.annotation.*;
+
+import javax.servlet.http.HttpServletResponse;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+import java.util.Map;
+
+@RestController
+@RequestMapping("/api")
+public class LocTypeBindController extends BaseController {
+
+    @Autowired
+    private LocTypeBindService locTypeBindService;
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:list')")
+    @PostMapping("/locTypeBind/page")
+    public R page(@RequestBody Map<String, Object> map) {
+        BaseParam baseParam = buildParam(map, BaseParam.class);
+        PageParam<LocTypeBind, BaseParam> pageParam = new PageParam<>(baseParam, LocTypeBind.class);
+        return R.ok().add(locTypeBindService.page(pageParam, pageParam.buildWrapper(true)));
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:list')")
+    @PostMapping("/locTypeBind/list")
+    public R list(@RequestBody Map<String, Object> map) {
+        return R.ok().add(locTypeBindService.list());
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:list')")
+    @GetMapping("/locTypeBind/{id}")
+    public R get(@PathVariable("id") Long id) {
+        return R.ok().add(locTypeBindService.getById(id));
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:save')")
+    @OperationLog("娣诲姞搴撲綅绫诲瀷缁戝畾")
+    @PostMapping("/locTypeBind/save")
+    public R save(@RequestBody LocTypeBind locTypeBind) {
+        if (!locTypeBindService.save(locTypeBind)) {
+            return R.error("娣诲姞澶辫触");
+        }
+        return R.ok("娣诲姞鎴愬姛");
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:update')")
+    @OperationLog("淇敼搴撲綅绫诲瀷缁戝畾")
+    @PostMapping("/locTypeBind/update")
+    public R update(@RequestBody LocTypeBind locTypeBind) {
+        if (!locTypeBindService.updateById(locTypeBind)) {
+            return R.error("淇敼澶辫触");
+        }
+        return R.ok("淇敼鎴愬姛");
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:remove')")
+    @OperationLog("鍒犻櫎搴撲綅绫诲瀷缁戝畾")
+    @PostMapping("/locTypeBind/remove/{ids}")
+    public R remove(@PathVariable Long[] ids) {
+        if (!locTypeBindService.removeByIds(Arrays.asList(ids))) {
+            return R.error("鍒犻櫎澶辫触");
+        }
+        return R.ok("鍒犻櫎鎴愬姛");
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:list')")
+    @PostMapping("/locTypeBind/query")
+    public R query(@RequestParam(required = false) String condition) {
+        List<KeyValVo> vos = new ArrayList<>();
+        LambdaQueryWrapper<LocTypeBind> wrapper = new LambdaQueryWrapper<>();
+        if (!Cools.isEmpty(condition)) {
+            wrapper.like(LocTypeBind::getName, condition);
+        }
+        locTypeBindService.page(new Page<>(1, 30), wrapper).getRecords().forEach(
+                item -> vos.add(new KeyValVo(item.getId(), item.getName()))
+        );
+        return R.ok().add(vos);
+    }
+
+    @PreAuthorize("hasAuthority('asrs:locTypeBind:list')")
+    @PostMapping("/locTypeBind/export")
+    public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+        ExcelUtil.build(ExcelUtil.create(locTypeBindService.list(), LocTypeBind.class), response);
+    }
+
+}
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/LocTypeBind.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/LocTypeBind.java
new file mode 100644
index 0000000..19db2c3
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/LocTypeBind.java
@@ -0,0 +1,242 @@
+package com.zy.asrs.wms.asrs.entity;
+
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+import com.zy.asrs.wms.asrs.service.LocService;
+import com.zy.asrs.wms.asrs.service.LocTypeService;
+import com.zy.asrs.wms.system.entity.Host;
+import com.zy.asrs.wms.system.entity.User;
+import org.springframework.format.annotation.DateTimeFormat;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableLogic;
+import com.baomidou.mybatisplus.annotation.TableName;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import com.zy.asrs.framework.common.Cools;
+import com.zy.asrs.framework.common.SpringUtils;
+import com.zy.asrs.wms.system.service.UserService;
+import com.zy.asrs.wms.system.service.HostService;
+
+import java.io.Serializable;
+import java.util.Date;
+
+@Data
+@TableName("man_loc_type_bind")
+public class LocTypeBind implements Serializable {
+
+    private static final long serialVersionUID = 1L;
+
+    /**
+     * ID
+     */
+    @ApiModelProperty(value= "ID")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    /**
+     * 搴撲綅
+     */
+    @ApiModelProperty(value= "搴撲綅")
+    private Long locId;
+
+    /**
+     * 搴撲綅绫诲瀷
+     */
+    @ApiModelProperty(value= "搴撲綅绫诲瀷")
+    private Long typeId;
+
+    /**
+     * 缂栧彿
+     */
+    @ApiModelProperty(value= "缂栧彿")
+    private String uuid;
+
+    /**
+     * 鍚嶇О
+     */
+    @ApiModelProperty(value= "鍚嶇О")
+    private String name;
+
+    /**
+     * 鏍囪瘑
+     */
+    @ApiModelProperty(value= "鏍囪瘑")
+    private String flag;
+
+    /**
+     * 鎵�灞炴満鏋�
+     */
+    @ApiModelProperty(value= "鎵�灞炴満鏋�")
+    private Long hostId;
+
+    /**
+     * 鐘舵�� 1: 姝e父  0: 绂佺敤  
+     */
+    @ApiModelProperty(value= "鐘舵�� 1: 姝e父  0: 绂佺敤  ")
+    private Integer status;
+
+    /**
+     * 鏄惁鍒犻櫎 1: 鏄�  0: 鍚�  
+     */
+    @ApiModelProperty(value= "鏄惁鍒犻櫎 1: 鏄�  0: 鍚�  ")
+    @TableLogic
+    private Integer deleted;
+
+    /**
+     * 娣诲姞鏃堕棿
+     */
+    @ApiModelProperty(value= "娣诲姞鏃堕棿")
+    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
+    private Date createTime;
+
+    /**
+     * 娣诲姞浜哄憳
+     */
+    @ApiModelProperty(value= "娣诲姞浜哄憳")
+    private Long createBy;
+
+    /**
+     * 淇敼鏃堕棿
+     */
+    @ApiModelProperty(value= "淇敼鏃堕棿")
+    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
+    private Date updateTime;
+
+    /**
+     * 淇敼浜哄憳
+     */
+    @ApiModelProperty(value= "淇敼浜哄憳")
+    private Long updateBy;
+
+    /**
+     * 澶囨敞
+     */
+    @ApiModelProperty(value= "澶囨敞")
+    private String memo;
+
+    public LocTypeBind() {}
+
+    public LocTypeBind(Long locId,Long typeId,String uuid,String name,String flag,Long hostId,Integer status,Integer deleted,Date createTime,Long createBy,Date updateTime,Long updateBy,String memo) {
+        this.locId = locId;
+        this.typeId = typeId;
+        this.uuid = uuid;
+        this.name = name;
+        this.flag = flag;
+        this.hostId = hostId;
+        this.status = status;
+        this.deleted = deleted;
+        this.createTime = createTime;
+        this.createBy = createBy;
+        this.updateTime = updateTime;
+        this.updateBy = updateBy;
+        this.memo = memo;
+    }
+
+//    LocTypeBind locTypeBind = new LocTypeBind(
+//            null,    // 搴撲綅[闈炵┖]
+//            null,    // 搴撲綅绫诲瀷[闈炵┖]
+//            null,    // 缂栧彿
+//            null,    // 鍚嶇О
+//            null,    // 鏍囪瘑
+//            null,    // 鎵�灞炴満鏋�
+//            null,    // 鐘舵��
+//            null,    // 鏄惁鍒犻櫎
+//            null,    // 娣诲姞鏃堕棿
+//            null,    // 娣诲姞浜哄憳
+//            null,    // 淇敼鏃堕棿
+//            null,    // 淇敼浜哄憳
+//            null    // 澶囨敞
+//    );
+
+    public String getLocId$(){
+        LocService service = SpringUtils.getBean(LocService.class);
+        Loc loc = service.getById(this.locId);
+        if (!Cools.isEmpty(loc)){
+            return String.valueOf(loc.getLocNo());
+        }
+        return null;
+    }
+
+    public String getTypeId$(){
+        LocTypeService service = SpringUtils.getBean(LocTypeService.class);
+        LocType locType = service.getById(this.typeId);
+        if (!Cools.isEmpty(locType)){
+            return String.valueOf(locType.getName());
+        }
+        return null;
+    }
+
+    public String getHostId$(){
+        HostService service = SpringUtils.getBean(HostService.class);
+        Host host = service.getById(this.hostId);
+        if (!Cools.isEmpty(host)){
+            return String.valueOf(host.getName());
+        }
+        return null;
+    }
+
+    public String getStatus$(){
+        if (null == this.status){ return null; }
+        switch (this.status){
+            case 1:
+                return "姝e父";
+            case 0:
+                return "绂佺敤";
+            default:
+                return String.valueOf(this.status);
+        }
+    }
+
+    public String getDeleted$(){
+        if (null == this.deleted){ return null; }
+        switch (this.deleted){
+            case 1:
+                return "鏄�";
+            case 0:
+                return "鍚�";
+            default:
+                return String.valueOf(this.deleted);
+        }
+    }
+
+    public String getCreateTime$(){
+        if (Cools.isEmpty(this.createTime)){
+            return "";
+        }
+        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.createTime);
+    }
+
+    public String getCreateBy$(){
+        UserService service = SpringUtils.getBean(UserService.class);
+        User user = service.getById(this.createBy);
+        if (!Cools.isEmpty(user)){
+            return String.valueOf(user.getNickname());
+        }
+        return null;
+    }
+
+    public String getUpdateTime$(){
+        if (Cools.isEmpty(this.updateTime)){
+            return "";
+        }
+        return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.updateTime);
+    }
+
+    public String getUpdateBy$(){
+        UserService service = SpringUtils.getBean(UserService.class);
+        User user = service.getById(this.updateBy);
+        if (!Cools.isEmpty(user)){
+            return String.valueOf(user.getNickname());
+        }
+        return null;
+    }
+
+
+}
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/LocTypeBindMapper.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/LocTypeBindMapper.java
new file mode 100644
index 0000000..f5471f9
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/LocTypeBindMapper.java
@@ -0,0 +1,12 @@
+package com.zy.asrs.wms.asrs.mapper;
+
+import com.zy.asrs.wms.asrs.entity.LocTypeBind;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.stereotype.Repository;
+
+@Mapper
+@Repository
+public interface LocTypeBindMapper extends BaseMapper<LocTypeBind> {
+
+}
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/LocTypeBindService.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/LocTypeBindService.java
new file mode 100644
index 0000000..e9df8a4
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/LocTypeBindService.java
@@ -0,0 +1,8 @@
+package com.zy.asrs.wms.asrs.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.zy.asrs.wms.asrs.entity.LocTypeBind;
+
+public interface LocTypeBindService extends IService<LocTypeBind> {
+
+}
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/impl/LocTypeBindServiceImpl.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/impl/LocTypeBindServiceImpl.java
new file mode 100644
index 0000000..601ed30
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/service/impl/LocTypeBindServiceImpl.java
@@ -0,0 +1,12 @@
+package com.zy.asrs.wms.asrs.service.impl;
+
+import com.zy.asrs.wms.asrs.mapper.LocTypeBindMapper;
+import com.zy.asrs.wms.asrs.entity.LocTypeBind;
+import com.zy.asrs.wms.asrs.service.LocTypeBindService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+@Service("locTypeBindService")
+public class LocTypeBindServiceImpl extends ServiceImpl<LocTypeBindMapper, LocTypeBind> implements LocTypeBindService {
+
+}
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/utils/CodeBuilder.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/utils/CodeBuilder.java
index 9b60111..89db324 100644
--- a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/utils/CodeBuilder.java
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/utils/CodeBuilder.java
@@ -22,8 +22,8 @@
 //        generator.username="sa";
 //        generator.password="Zoneyung@zy56$";
 
-        generator.table="man_loc_area";
-        generator.tableName="搴撳尯绠$悊";
+        generator.table="man_loc_type_bind";
+        generator.tableName="搴撲綅绫诲瀷缁戝畾";
         generator.rootPackagePath="com.zy.asrs.wms";
         generator.packagePath="com.zy.asrs.wms.asrs";
 
diff --git a/zy-asrs-wms/src/main/java/locTypeBind.sql b/zy-asrs-wms/src/main/java/locTypeBind.sql
new file mode 100644
index 0000000..5f0ee65
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/locTypeBind.sql
@@ -0,0 +1,9 @@
+-- save locTypeBind record
+-- mysql
+insert into `sys_menu` ( `name`, `parent_id`, `route`, `component`, `type`, `sort`, `host_id`, `status`) values ( '搴撲綅绫诲瀷缁戝畾绠$悊', '0', '/asrs/locTypeBind', '/asrs/locTypeBind', '0' , '0', '1' , '1');
+
+insert into `sys_menu` ( `name`, `parent_id`, `type`, `authority`, `sort`, `host_id`, `status`) values ( '鏌ヨ搴撲綅绫诲瀷缁戝畾', '', '1', 'asrs:locTypeBind:list', '0', '1', '1');
+insert into `sys_menu` ( `name`, `parent_id`, `type`, `authority`, `sort`, `host_id`, `status`) values ( '娣诲姞搴撲綅绫诲瀷缁戝畾', '', '1', 'asrs:locTypeBind:save', '1', '1', '1');
+insert into `sys_menu` ( `name`, `parent_id`, `type`, `authority`, `sort`, `host_id`, `status`) values ( '淇敼搴撲綅绫诲瀷缁戝畾', '', '1', 'asrs:locTypeBind:update', '2', '1', '1');
+insert into `sys_menu` ( `name`, `parent_id`, `type`, `authority`, `sort`, `host_id`, `status`) values ( '鍒犻櫎搴撲綅绫诲瀷缁戝畾', '', '1', 'asrs:locTypeBind:remove', '3', '1', '1');
+
diff --git a/zy-asrs-wms/src/main/resources/mapper/asrs/LocTypeBindMapper.xml b/zy-asrs-wms/src/main/resources/mapper/asrs/LocTypeBindMapper.xml
new file mode 100644
index 0000000..b568f0c
--- /dev/null
+++ b/zy-asrs-wms/src/main/resources/mapper/asrs/LocTypeBindMapper.xml
@@ -0,0 +1,5 @@
+<?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.zy.asrs.wms.asrs.mapper.LocTypeBindMapper">
+
+</mapper>

--
Gitblit v1.9.1