Newer
Older
urbanLifeline_YanAn / src / views / system / tool / editTable.vue
@zhangqy zhangqy on 3 Oct 7 KB first commit
  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="info" />
  6. </el-tab-pane>
  7. <el-tab-pane label="字段信息" name="columnInfo">
  8. <el-table ref="dragTable" :data="columns" row-key="columnId" :max-height="tableHeight" v-loading="tableLoading">
  9. <el-table-column label="序号" type="index" min-width="5%" />
  10. <el-table-column label="字段列名" prop="columnName" min-width="10%" show-overflow-tooltip />
  11. <el-table-column label="字段描述" min-width="10%">
  12. <template #default="scope">
  13. <el-input v-model="scope.row.columnComment"></el-input>
  14. </template>
  15. </el-table-column>
  16. <el-table-column label="物理类型" prop="columnType" min-width="10%" show-overflow-tooltip />
  17. <el-table-column label="Java类型" min-width="11%">
  18. <template #default="scope">
  19. <el-select v-model="scope.row.javaType">
  20. <el-option label="Long" value="Long" />
  21. <el-option label="String" value="String" />
  22. <el-option label="Integer" value="Integer" />
  23. <el-option label="Double" value="Double" />
  24. <el-option label="BigDecimal" value="BigDecimal" />
  25. <el-option label="Date" value="Date" />
  26. <el-option label="Boolean" value="Boolean" />
  27. </el-select>
  28. </template>
  29. </el-table-column>
  30. <el-table-column label="java属性" min-width="10%">
  31. <template #default="scope">
  32. <el-input v-model="scope.row.javaField"></el-input>
  33. </template>
  34. </el-table-column>
  35.  
  36. <el-table-column label="插入" min-width="5%">
  37. <template #default="scope">
  38. <el-checkbox true-label="1" false-label="0" v-model="scope.row.isInsert"></el-checkbox>
  39. </template>
  40. </el-table-column>
  41. <el-table-column label="编辑" min-width="5%">
  42. <template #default="scope">
  43. <el-checkbox true-label="1" false-label="0" v-model="scope.row.isEdit"></el-checkbox>
  44. </template>
  45. </el-table-column>
  46. <el-table-column label="列表" min-width="5%">
  47. <template #default="scope">
  48. <el-checkbox true-label="1" false-label="0" v-model="scope.row.isList"></el-checkbox>
  49. </template>
  50. </el-table-column>
  51. <el-table-column label="查询" min-width="5%">
  52. <template #default="scope">
  53. <el-checkbox true-label="1" false-label="0" v-model="scope.row.isQuery"></el-checkbox>
  54. </template>
  55. </el-table-column>
  56. <el-table-column label="查询方式" min-width="10%">
  57. <template #default="scope">
  58. <el-select v-model="scope.row.queryType">
  59. <el-option label="=" value="EQ" />
  60. <el-option label="!=" value="NE" />
  61. <el-option label=">" value="GT" />
  62. <el-option label=">=" value="GTE" />
  63. <el-option label="<" value="LT" />
  64. <el-option label="<=" value="LTE" />
  65. <el-option label="LIKE" value="LIKE" />
  66. <el-option label="BETWEEN" value="BETWEEN" />
  67. </el-select>
  68. </template>
  69. </el-table-column>
  70. <el-table-column label="必填" min-width="5%">
  71. <template #default="scope">
  72. <el-checkbox true-label="1" false-label="0" v-model="scope.row.isRequired"></el-checkbox>
  73. </template>
  74. </el-table-column>
  75. <el-table-column label="显示类型" min-width="12%">
  76. <template #default="scope">
  77. <el-select v-model="scope.row.htmlType">
  78. <el-option label="文本框" value="input" />
  79. <el-option label="文本域" value="textarea" />
  80. <el-option label="下拉框" value="select" />
  81. <el-option label="单选框" value="radio" />
  82. <el-option label="复选框" value="checkbox" />
  83. <el-option label="日期控件" value="datetime" />
  84. <el-option label="图片上传" value="imageUpload" />
  85. <el-option label="文件上传" value="fileUpload" />
  86. <el-option label="富文本控件" value="editor" />
  87. </el-select>
  88. </template>
  89. </el-table-column>
  90. <el-table-column label="字典类型" min-width="12%">
  91. <template #default="scope">
  92. <el-select v-model="scope.row.dictType" clearable filterable placeholder="请选择">
  93. <el-option v-for="dict in dictOptions" :key="dict.dictType" :label="dict.dictName" :value="dict.dictType">
  94. <span style="float: left">{{ dict.dictName }}</span>
  95. <span style="float: right; color: #8492a6; font-size: 13px">{{ dict.dictType }}</span>
  96. </el-option>
  97. </el-select>
  98. </template>
  99. </el-table-column>
  100. </el-table>
  101. </el-tab-pane>
  102. <el-tab-pane label="生成信息" name="genInfo">
  103. <gen-info-form ref="genInfo" :info="info" :tables="tables" />
  104. </el-tab-pane>
  105. </el-tabs>
  106. <el-form label-width="100px">
  107. <div style="text-align: center; margin-left: -100px; margin-top: 10px">
  108. <el-button type="primary" @click="submitForm()">提交</el-button>
  109. <el-button @click="close()">返回</el-button>
  110. </div>
  111. </el-form>
  112. </el-card>
  113. </template>
  114.  
  115. <script setup name="GenEdit">
  116. import { getGenTable, updateGenTable } from '@/api/system/tool';
  117. import { optionselect as getDictOptionselect } from '@/api/system/dict/type';
  118. import basicInfoForm from './basicInfoForm';
  119. import genInfoForm from './genInfoForm';
  120.  
  121. const props = defineProps({
  122. // route object
  123. tableIdEdit: {
  124. type: Number,
  125. default: '',
  126. },
  127. pageNumEdit: {
  128. type: Number,
  129. default: 1,
  130. },
  131. });
  132.  
  133. const { proxy } = getCurrentInstance();
  134.  
  135. const activeName = ref('columnInfo');
  136. const tableHeight = ref(document.documentElement.scrollHeight - 245 + 'px');
  137. const tables = ref([]);
  138. const columns = ref([]);
  139. const dictOptions = ref([]);
  140. const info = ref({});
  141. const tableLoading = ref(true);
  142.  
  143. /** 提交按钮 */
  144. function submitForm() {
  145. const basicForm = proxy.$refs.basicInfo.$refs.basicInfoForm;
  146. const genForm = proxy.$refs.genInfo.$refs.genInfoForm;
  147. Promise.all([basicForm, genForm].map(getFormPromise)).then(res => {
  148. const validateResult = res.every(item => !!item);
  149. if (validateResult) {
  150. const genTable = Object.assign({}, info.value);
  151. genTable.columns = columns.value;
  152. genTable.params = {
  153. treeCode: info.value.treeCode,
  154. treeName: info.value.treeName,
  155. treeParentCode: info.value.treeParentCode,
  156. parentMenuId: info.value.parentMenuId,
  157. };
  158. updateGenTable(genTable).then(res => {
  159. console.log(res);
  160. proxy.$modal.msgSuccess(res.msg);
  161. if (res.code === 200) {
  162. close();
  163. }
  164. });
  165. } else {
  166. proxy.$modal.msgError('表单校验未通过,请重新检查提交内容');
  167. }
  168. });
  169. }
  170. function getFormPromise(form) {
  171. return new Promise(resolve => {
  172. form.validate(res => {
  173. resolve(res);
  174. });
  175. });
  176. }
  177. const emit = defineEmits();
  178. function close() {
  179. emit('childClose');
  180. }
  181. onMounted(() => {
  182. // 获取表详细信息
  183. tableLoading.value = true;
  184. getGenTable(props.tableIdEdit).then(res => {
  185. columns.value = res.data.rows;
  186. info.value = res.data.info;
  187. tables.value = res.data.tables;
  188. tableLoading.value = false;
  189. });
  190. /** 查询字典下拉列表 */
  191. getDictOptionselect().then(response => {
  192. dictOptions.value = response.data;
  193. });
  194. });
  195. </script>