TableDesig.vue 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312
  1. <template>
  2. <div>
  3. <el-button style="margin-top:10px" @click="genEntrty">生成实体类</el-button>
  4. <el-button style="margin-top:10px" @click="genControler">生成接口类</el-button>
  5. <el-table
  6. :data="tableData.ColumnList"
  7. :header-cell-style="headerStyle"
  8. border
  9. stripe
  10. fit
  11. style="width: 100%;margin-top: 25px;"
  12. >
  13. <el-table-column fixed prop="ColumnName" label="字段名" width="150"></el-table-column>
  14. <el-table-column prop="Description" min-width="200" label="说明"></el-table-column>
  15. <el-table-column prop="ColumnType" min-width="120" label="类型"></el-table-column>
  16. <el-table-column prop="CharMaxLength" min-width="60" label="长度"></el-table-column>
  17. <el-table-column prop="Nullable" align="center" label="不是 null"></el-table-column>
  18. <el-table-column prop="Default" min-width="260" label="默认值"></el-table-column>
  19. </el-table>
  20. </div>
  21. </template>
  22. <script>
  23. import Vue from "vue";
  24. import ElementUI from "element-ui";
  25. import Axios from "axios";
  26. import "element-ui/lib/theme-chalk/index.css";
  27. import Opt from "../opt";
  28. import { SStringBuilder } from "@persagy-web/base";
  29. Vue.use(ElementUI);
  30. export default {
  31. data: function() {
  32. return {
  33. tableData: [],
  34. headerStyle: {
  35. backgroundColor: "#e1e4e5",
  36. color: "#2b2b2b",
  37. lineHeight: "30px"
  38. }, // 列表样式
  39. urlObj: {} // 路径参数
  40. };
  41. },
  42. components: {},
  43. created: function() {
  44. this.getData();
  45. },
  46. mounted: function() {
  47. },
  48. props: ["sys", "schema", "table"],
  49. computed: {},
  50. methods: {
  51. getData() {
  52. Axios.get(
  53. `${window.location.origin}/${this.sys}/--database-doc--/table-info?schema=${
  54. this.schema
  55. }&table=${this.table}`,
  56. {}
  57. ).then(res => {
  58. this.tableData = res.data;
  59. });
  60. },
  61. //生成实体类
  62. genEntrty() {
  63. this.getUrlData();
  64. let strBuild = new SStringBuilder();
  65. const table = this.toHump(this.urlObj.urlType);
  66. strBuild.append(
  67. `package cn.sagacloud.server.datacenter.models.entities
  68. import cn.sagacloud.server.datacenter.models.entities.base.BaseInfo
  69. import cn.sagacloud.server.datacenter.models.entities.task.SchemeUtils
  70. import com.alibaba.fastjson.annotation.JSONField
  71. import com.sybotan.service.models.annotations.SCascade
  72. import io.swagger.annotations.ApiModel
  73. import io.swagger.annotations.ApiModelProperty
  74. import javax.persistence.Column
  75. import javax.persistence.Id
  76. import javax.persistence.Table
  77. /**
  78. * ${this.urlObj.urlName}信息实体类
  79. *
  80. * @author 自动生成
  81. */
  82. @ApiModel(description = "资产信息实体类")
  83. @Table(name = "${this.schema}.${this.urlObj.urlType}")
  84. open class ${table} : BaseInfo(),Comparator<${table}> {
  85. `
  86. );
  87. this.tableData.forEach(element => {
  88. strBuild.append(` /** ${element.Description} */`);
  89. if (element.Nullable == "YES") {
  90. strBuild.append(
  91. ` @ApiModelProperty(value = "${element.Description}")`
  92. );
  93. } else {
  94. strBuild.append(
  95. ` @ApiModelProperty(value = "${element.Description}", required = true)`
  96. );
  97. }
  98. strBuild.append(` @Column(name = "${element.ColumnName}")`);
  99. strBuild.append(
  100. ` var ${this.toSmallHump(element.ColumnName)}: ${this.typeToName(
  101. element.ColumnType
  102. )}? = null\n`
  103. );
  104. });
  105. strBuild.append(`} // Class ${table}`);
  106. this.download(`${table}.kt`, strBuild.toString());
  107. },
  108. //生成接口类
  109. genControler() {
  110. this.getUrlData();
  111. let strBuild = new SStringBuilder();
  112. const className = `${this.toHump(this.urlObj.urlType)}Controller`;
  113. strBuild.append(`package cn.sagacloud.server.datacenter.controllers
  114. import cn.sagacloud.server.datacenter.models.entities.Property
  115. import cn.sagacloud.server.datacenter.services.PropertyService
  116. import com.sybotan.base.extensions.toJson
  117. import com.sybotan.database.SFilter
  118. import com.sybotan.service.SPageContext
  119. import com.sybotan.service.models.requests.SCountRequest
  120. import com.sybotan.service.models.requests.SCreateRequest
  121. import com.sybotan.service.models.requests.SQueryRequest
  122. import com.sybotan.service.models.requests.SUpdateRequest
  123. import com.sybotan.service.models.responses.SBaseResponse
  124. import com.sybotan.service.models.responses.SCountResponse
  125. import com.sybotan.service.models.responses.SCreateResponse
  126. import com.sybotan.service.models.responses.SQueryResponse
  127. import io.swagger.annotations.Api
  128. import io.swagger.annotations.ApiOperation
  129. import org.slf4j.LoggerFactory
  130. import org.springframework.web.bind.annotation.PostMapping
  131. import org.springframework.web.bind.annotation.RequestBody
  132. import org.springframework.web.bind.annotation.RequestMapping
  133. import org.springframework.web.bind.annotation.RestController
  134. /**
  135. * ${this.urlObj.urlName}接口
  136. *
  137. * @author 自动生成
  138. */
  139. @Api(tags = ["${this.urlObj.urlName}"])
  140. @RestController
  141. @RequestMapping("/object/${this.urlObj.urlType}")
  142. open class ${className} {
  143. companion object {
  144. /** 日志 */
  145. private val logger = LoggerFactory.getLogger(${className}::class.java)
  146. } // Companion object
  147. /**
  148. * 创建${this.urlObj.urlName}
  149. *
  150. * @param request ${this.urlObj.urlName}对象列表
  151. * @return 创建结果信息
  152. */
  153. @ApiOperation(value = "创建${this.urlObj.urlName}信息", notes = "")
  154. @PostMapping(value = ["/create"])
  155. fun create(@RequestBody request: SCreateRequest<${this.toHump(
  156. this.table
  157. )}>): SCreateResponse<${this.toHump(this.table)}> {
  158. return PropertyService.createList( request)
  159. } // Function create()
  160. /**
  161. * 根据id删除${this.urlObj.urlName}
  162. *
  163. * @param idList id数组
  164. * @return 删除的结果信息
  165. */
  166. @ApiOperation(value = "根据id删除${this.urlObj.urlName}信息", notes = "")
  167. @PostMapping(value = ["/delete"])
  168. fun delete(@RequestBody idList: ArrayList<${this.toHump(
  169. this.table
  170. )}>): SBaseResponse {
  171. return PropertyService.deleteByKeysList(idList)
  172. } // Function delete()
  173. /**
  174. * 更新${this.urlObj.urlName}信息
  175. *
  176. * @param request 更新的内容对象
  177. * @return 更新的结果
  178. */
  179. @ApiOperation(value = "更新${this.urlObj.urlName}信息", notes = "")
  180. @PostMapping(value = ["/update"])
  181. fun update(@RequestBody request: SUpdateRequest<${this.toHump(
  182. this.table
  183. )}>): SBaseResponse {
  184. return PropertyService.updateList(request)
  185. } // Function update()
  186. /**
  187. * 查询${this.urlObj.urlName}信息
  188. *
  189. * @param request 查询信息条件
  190. * @return 查询结果
  191. */
  192. @ApiOperation(value = "查询${this.urlObj.urlName}信息", notes="")
  193. @PostMapping(value = ["/query"])
  194. fun query(@RequestBody request: SQueryRequest): SQueryResponse<${this.toHump(
  195. this.table
  196. )}> {
  197. return PropertyService.pageQuery(request)
  198. } // Function query()
  199. /**
  200. * 根据条件查询统计数量
  201. */
  202. @ApiOperation(value = "根据条件查询统计数量", notes = "")
  203. @PostMapping(value = ["/count"])
  204. fun count(@RequestBody request: SCountRequest): SCountResponse {
  205. return PropertyService.count(request)
  206. } // Function count()
  207. `);
  208. strBuild.append(`} // Class ${className}`);
  209. // this.download(`${className}.kt`, strBuild.toString());
  210. },
  211. // 数据包类型到实体类的转换
  212. typeToName(name) {
  213. const obj = {
  214. varchar: "String",
  215. char: "String",
  216. timestamptz: "Date",
  217. timestamp: "Date",
  218. text: "String",
  219. bool: "Boolean",
  220. int4: "Int",
  221. date: "Date",
  222. int2: "Int",
  223. json: "HashMap<String, Any?>",
  224. jsonb: "HashMap<String, Any?>"
  225. };
  226. if (name) {
  227. return obj[name] ? obj[name] : "String";
  228. } else {
  229. return "String";
  230. }
  231. },
  232. //转大驼峰
  233. toHump(str) {
  234. var arr = str.split("_");
  235. for (var i = 0; i < arr.length; i++) {
  236. arr[i] = arr[i].charAt(0).toUpperCase() + arr[i].substring(1);
  237. }
  238. return arr.join("");
  239. },
  240. //转小驼峰
  241. toSmallHump(str) {
  242. var arr = str.split("_");
  243. for (var i = 1; i < arr.length; i++) {
  244. arr[i] = arr[i].charAt(0).toUpperCase() + arr[i].substring(1);
  245. }
  246. return arr.join("");
  247. },
  248. // 获取路径名称以及路径type
  249. getUrlData() {
  250. const dataArr = window.location.href.split("#")[1].split("-");
  251. let obj = {};
  252. if (dataArr.length == 2) {
  253. obj = {
  254. urlType: dataArr[1],
  255. urlName: decodeURIComponent(dataArr[0])
  256. };
  257. } else {
  258. let urlName = "";
  259. let lengthNum = dataArr.length;
  260. dataArr.forEach((item, i) => {
  261. if (i + 2 <= lengthNum) {
  262. urlName = urlName + "-" + item;
  263. }
  264. });
  265. obj = {
  266. urlType: dataArr[lengthNum-1],
  267. urlName: decodeURIComponent(urlName)
  268. };
  269. }
  270. this.urlObj = obj;
  271. },
  272. // 下载文件
  273. download(filename, text) {
  274. var element = document.createElement("a");
  275. element.setAttribute(
  276. "href",
  277. "data:text/plain;charset=utf-8," + encodeURIComponent(text)
  278. );
  279. element.setAttribute("download", filename);
  280. element.style.display = "none";
  281. document.body.appendChild(element);
  282. element.click();
  283. document.body.removeChild(element);
  284. }
  285. }
  286. };
  287. </script>
  288. <style scoped>
  289. /deep/ table {
  290. margin: 0;
  291. }
  292. </style>