editTable.vue 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235
  1. <template>
  2. <el-card>
  3. <el-tabs v-model="activeName">
  4. <el-tab-pane label="基本信息" name="basic">
  5. <basic-info-form ref="basicInfo" :info="table" />
  6. </el-tab-pane>
  7. <el-tab-pane label="字段信息" name="cloum">
  8. <el-table ref="dragTable" :data="columns" row-key="columnId" :max-height="tableHeight">
  9. <el-table-column
  10. label="字段列名"
  11. prop="columnName"
  12. min-width="10%"
  13. :show-overflow-tooltip="true"
  14. />
  15. <el-table-column label="字段描述" min-width="10%">
  16. <template v-slot="scope">
  17. <el-input v-model="scope.row.columnComment"></el-input>
  18. </template>
  19. </el-table-column>
  20. <el-table-column
  21. label="物理类型"
  22. prop="dataType"
  23. min-width="10%"
  24. :show-overflow-tooltip="true"
  25. />
  26. <el-table-column label="Java类型" min-width="11%">
  27. <template v-slot="scope">
  28. <el-select v-model="scope.row.javaType">
  29. <el-option label="Long" value="Long" />
  30. <el-option label="String" value="String" />
  31. <el-option label="Integer" value="Integer" />
  32. <el-option label="Double" value="Double" />
  33. <el-option label="BigDecimal" value="BigDecimal" />
  34. <el-option label="LocalDateTime" value="LocalDateTime" />
  35. <el-option label="Boolean" value="Boolean" />
  36. </el-select>
  37. </template>
  38. </el-table-column>
  39. <el-table-column label="java属性" min-width="10%">
  40. <template v-slot="scope">
  41. <el-input v-model="scope.row.javaField"></el-input>
  42. </template>
  43. </el-table-column>
  44. <el-table-column label="插入" min-width="4%">
  45. <template v-slot="scope">
  46. <el-checkbox true-label="true" false-label="false" v-model="scope.row.createOperation"></el-checkbox>
  47. </template>
  48. </el-table-column>
  49. <el-table-column label="编辑" min-width="4%">
  50. <template v-slot="scope">
  51. <el-checkbox true-label="true" false-label="false" v-model="scope.row.updateOperation"></el-checkbox>
  52. </template>
  53. </el-table-column>
  54. <el-table-column label="列表" min-width="4%">
  55. <template v-slot="scope">
  56. <el-checkbox true-label="true" false-label="false" v-model="scope.row.listOperationResult"></el-checkbox>
  57. </template>
  58. </el-table-column>
  59. <el-table-column label="查询" min-width="4%">
  60. <template v-slot="scope">
  61. <el-checkbox true-label="true" false-label="false" v-model="scope.row.listOperation"></el-checkbox>
  62. </template>
  63. </el-table-column>
  64. <el-table-column label="查询方式" min-width="10%">
  65. <template v-slot="scope">
  66. <el-select v-model="scope.row.listOperationCondition">
  67. <el-option label="=" value="=" />
  68. <el-option label="!=" value="!=" />
  69. <el-option label=">" value=">" />
  70. <el-option label=">=" value=">=" />
  71. <el-option label="<" value="<>" />
  72. <el-option label="<=" value="<=" />
  73. <el-option label="LIKE" value="LIKE" />
  74. <el-option label="BETWEEN" value="BETWEEN" />
  75. </el-select>
  76. </template>
  77. </el-table-column>
  78. <el-table-column label="允许空" min-width="5%">
  79. <template v-slot="scope">
  80. <el-checkbox true-label="true" false-label="false" v-model="scope.row.nullable"></el-checkbox>
  81. </template>
  82. </el-table-column>
  83. <el-table-column label="显示类型" min-width="12%">
  84. <template v-slot="scope">
  85. <el-select v-model="scope.row.htmlType">
  86. <el-option label="文本框" value="input" />
  87. <el-option label="文本域" value="textarea" />
  88. <el-option label="下拉框" value="select" />
  89. <el-option label="单选框" value="radio" />
  90. <el-option label="复选框" value="checkbox" />
  91. <el-option label="日期控件" value="datetime" />
  92. <el-option label="图片上传" value="imageUpload" />
  93. <el-option label="文件上传" value="fileUpload" />
  94. <el-option label="富文本控件" value="editor" />
  95. </el-select>
  96. </template>
  97. </el-table-column>
  98. <el-table-column label="字典类型" min-width="12%">
  99. <template v-slot="scope">
  100. <el-select v-model="scope.row.dictType" clearable filterable placeholder="请选择">
  101. <el-option
  102. v-for="dict in dictOptions"
  103. :key="dict.id"
  104. :label="dict.name"
  105. :value="dict.type"
  106. />
  107. </el-select>
  108. </template>
  109. </el-table-column>
  110. <el-table-column label="示例" min-width="10%">
  111. <template v-slot="scope">
  112. <el-input v-model="scope.row.example"></el-input>
  113. </template>
  114. </el-table-column>
  115. </el-table>
  116. </el-tab-pane>
  117. <el-tab-pane label="生成信息" name="genInfo">
  118. <gen-info-form ref="genInfo" :info="table" :tables="tables" :menus="menus"/>
  119. </el-tab-pane>
  120. </el-tabs>
  121. <el-form label-width="100px">
  122. <el-form-item style="text-align: center;margin-left:-100px;margin-top:10px;">
  123. <el-button type="primary" @click="submitForm()">提交</el-button>
  124. <el-button @click="close()">返回</el-button>
  125. </el-form-item>
  126. </el-form>
  127. </el-card>
  128. </template>
  129. <script>
  130. import { getCodegenDetail, updateCodegen } from "@/api/infra/codegen";
  131. import { listAllSimple as listAllSimpleDictType } from "@/api/system/dict/type";
  132. import { listSimpleMenus } from "@/api/system/menu";
  133. import basicInfoForm from "./basicInfoForm";
  134. import genInfoForm from "./genInfoForm";
  135. import Sortable from 'sortablejs'
  136. export default {
  137. name: "GenEdit",
  138. components: {
  139. basicInfoForm,
  140. genInfoForm
  141. },
  142. data() {
  143. return {
  144. // 选中选项卡的 name
  145. activeName: "cloum",
  146. // 表格的高度
  147. tableHeight: document.documentElement.scrollHeight - 245 + "px",
  148. // 表信息
  149. tables: [],
  150. // 表列信息
  151. columns: [],
  152. // 字典信息
  153. dictOptions: [],
  154. // 菜单信息
  155. menus: [],
  156. // 表详细信息
  157. table: {}
  158. };
  159. },
  160. created() {
  161. const tableId = this.$route.params && this.$route.params.tableId;
  162. if (tableId) {
  163. // 获取表详细信息
  164. getCodegenDetail(tableId).then(res => {
  165. this.table = res.data.table;
  166. this.columns = res.data.columns;
  167. });
  168. /** 查询字典下拉列表 */
  169. listAllSimpleDictType().then(response => {
  170. this.dictOptions = response.data;
  171. });
  172. /** 查询菜单下拉列表 */
  173. listSimpleMenus().then(response => {
  174. this.menus = [];
  175. this.menus.push(...this.handleTree(response.data, "id"));
  176. });
  177. }
  178. },
  179. methods: {
  180. /** 提交按钮 */
  181. submitForm() {
  182. const basicForm = this.$refs.basicInfo.$refs.basicInfoForm;
  183. const genForm = this.$refs.genInfo.$refs.genInfoForm;
  184. Promise.all([basicForm, genForm].map(this.getFormPromise)).then(res => {
  185. const validateResult = res.every(item => !!item);
  186. if (validateResult) {
  187. const genTable = {};
  188. genTable.table = Object.assign({}, basicForm.model, genForm.model);
  189. genTable.columns = this.columns;
  190. genTable.params = {
  191. treeCode: genTable.treeCode,
  192. treeName: genTable.treeName,
  193. treeParentCode: genTable.treeParentCode,
  194. parentMenuId: genTable.parentMenuId
  195. };
  196. updateCodegen(genTable).then(res => {
  197. this.$modal.msgSuccess("修改成功!");
  198. this.close();
  199. });
  200. } else {
  201. this.$modal.msgError("表单校验未通过,请重新检查提交内容");
  202. }
  203. });
  204. },
  205. getFormPromise(form) {
  206. return new Promise(resolve => {
  207. form.validate(res => {
  208. resolve(res);
  209. });
  210. });
  211. },
  212. /** 关闭按钮 */
  213. close() {
  214. this.$tab.closeOpenPage({
  215. path: "/infra/codegen",
  216. query: { t: Date.now(), pageNum: this.$route.query.pageNum } }
  217. );
  218. }
  219. },
  220. mounted() {
  221. const el = this.$refs.dragTable.$el.querySelectorAll(".el-table__body-wrapper > table > tbody")[0];
  222. const sortable = Sortable.create(el, {
  223. handle: ".allowDrag",
  224. onEnd: evt => {
  225. const targetRow = this.columns.splice(evt.oldIndex, 1)[0];
  226. this.columns.splice(evt.newIndex, 0, targetRow);
  227. for (let index in this.columns) {
  228. this.columns[index].sort = parseInt(index) + 1;
  229. }
  230. }
  231. });
  232. }
  233. };
  234. </script>