main.py

  1. $!globalPort
  2. $!callback.setFileName("${tableInfo.name}Main.py")
  3. $!callback.setSavePath($tool.append($tableInfo.savePath, "/$tableInfo.obj.name"))
  4. #if(!$tableInfo.pkColumn.isEmpty())
  5.     #set($pk = $tableInfo.pkColumn.get(0))
  6. #end
  7. # -*- coding: utf-8 -*-
  8. import logging
  9. import threading
  10. import webbrowser
  12. from DBUtil import DBUtil
  13. from LogUtil import getLogger
  14. from flask import Flask, render_template
  15. from flask import request
  16. from flask_cors import CORS
  18. # html同级
  19. app = Flask(__name__, template_folder=".")
  21. # flask日志输出级别
  22. log = logging.getLogger('werkzeug')
  23. log.setLevel(logging.ERROR)
  25. # 项目日志
  26. logger = getLogger("log")
  28. CORS(app, resources='/*')
  29. # 数据库
  30. db = DBUtil("$tableInfo.obj.getParent().getPresentableText()")
  31. # 表名
  32. tableName = "$tableInfo.obj.name"
  34. app.jinja_env.variable_start_string = '{['
  35. app.jinja_env.variable_end_string = ']}'
  37. def request_parse():
  38.     if request.method == 'POST' or request.method == 'PUT':
  39.         return request.json
  40.     elif request.method == 'GET' or request.method == 'DELETE':
  41.         return request.args
  44. @app.route('/getList', methods=['GET'])
  45. def getList():
  46.     # region 参数
  47.     data = request_parse()
  48.     pageNum = data.get("pageNum")
  49.     pageSize = data.get("pageSize")
  50.     parmOrder = data.get("parmOrder")
  51.     parmColumn = data.get("parmColumn")
  52. #foreach($column in $tableInfo.fullColumn)
  53.     ${column.obj.name} = data.get("${column.obj.name}")
  54. #end
  55.     # endregion
  57.     # region 计算分页
  58.     if not pageNum:
  59.         pageNum = 1
  60.     else:
  61.         pageNum = int(pageNum)
  63.     if not pageSize:
  64.         pageSize = 10
  65.     else:
  66.         pageSize = int(pageSize)
  68.     if pageNum < 0:
  69.         pageNum = 0
  71.     # 起始位置
  72.     selectIndex = (pageNum - 1) * pageSize
  74.     if selectIndex < 0:
  75.         selectIndex = 0
  76.     # endregion
  78.     sql = "select * from {} where 1=1 ".format(tableName)
  79.     countWhereSql = " where 1=1 "
  81. #foreach($column in $tableInfo.fullColumn)
  82.     if ${column.obj.name}:
  83.         sql += " and ${column.obj.name} like '%{}%' ".format(${column.obj.name})
  84.         countWhereSql += " and ${column.obj.name} like '%{}%'".format(${column.obj.name})
  85. #end
  87.     if parmOrder:
  88.         orderSql = " order by {} {} ".format(parmColumn, parmOrder)
  89.         sql += "{} limit {},{}".format(orderSql, selectIndex, pageSize)
  90.         countWhereSql += orderSql
  91.     else:
  92.         sql += "limit {},{}".format(selectIndex, pageSize)
  94.     logger.info("getList()----sql: {}".format(sql))
  95.     logger.info("getList()----countWhereSql: {}".format(countWhereSql))
  97.     result_data = db.select(sql)
  99.     for i in range(len(result_data)):
  100. #foreach($column in $tableInfo.fullColumn)
  101. #if($column.type.equals("java.util.Date"))
  102.         result_data[i]["$column.obj.name"] = str(result_data[i]["$column.obj.name"])
  103. #end
  104. #end
  105.         pass
  107.     count = db.selectCount(tableName, countWhereSql)
  109.     return {
  110.         "resultCode":200,
  111.         "rows": result_data,
  112.         "total": count
  113.     }
  116. @app.route('/getOne', methods=['GET'])
  117. def getOne():
  118.     data = request_parse()
  119.     $pk.obj.name = data.get("$pk.obj.name")
  120.     sql = "select * from {} where $pk.obj.name = '{}'".format(tableName,$pk.obj.name)
  121.     logger.info("getOne()----sql: {}".format(sql))
  122.     oneData = db.select(sql)
  123.     if oneData:
  124. #foreach($column in $tableInfo.fullColumn)
  125. #if($column.type.equals("java.util.Date"))
  126.         oneData[0]["$column.obj.name"] = str(oneData[0]["$column.obj.name"])
  127. #end
  128. #end
  129.         return {"resultCode": 200, "data": oneData[0]}
  130.     else:
  131.         return {"resultCode": 404, "msg": "没有找到此记录"}
  134. @app.route('/update', methods=['PUT'])
  135. def update():
  136.     data = request_parse()
  137. #foreach($column in $tableInfo.fullColumn)
  138.     ${column.obj.name} = data.get("${column.obj.name}")
  139. #end
  141.     sql = "update {} set ".format(tableName)
  142. #foreach($column in $tableInfo.otherColumn)
  143.     if ${column.obj.name}:
  144.         sql += " ${column.obj.name} = '{}' ,".format(${column.obj.name})
  145. #end
  146.     sql = sql.strip(",")
  147.     sql += " where $pk.obj.name = '{}'".format($pk.obj.name)
  149.     logger.info("update()----sql: {}".format(sql))
  150.     db.execute(sql)
  151.     return {"resultCode": 200}
  154. @app.route('/delete', methods=['DELETE'])
  155. def delete():
  156.     data = request_parse()
  157.     ${pk.obj.name}s = data.getlist("${pk.obj.name}s[]")
  158.     for ${pk.obj.name} in ${pk.obj.name}s:
  159.         sql = "delete from {} where $pk.obj.name = '{}'".format(tableName,$pk.obj.name)
  160.         logger.info("delete()----sql: {}".format(sql))
  161.         db.execute(sql)
  162.     return {"resultCode": 200}
  165. @app.route('/add', methods=['POST'])
  166. def add():
  167.     data = request_parse()
  169.     # 移除主键
  170.     if '$pk.obj.name' in  data.keys():
  171.         del data['$pk.obj.name']
  173.     logger.info("add()----数据: {}".format(data))
  175.     db.insertOne(data,tableName)
  176.     return {"resultCode": 200}
  179. @app.route("/")
  180. def index():
  181.     return render_template('index.html')
  184. def openUrl(port):
  185.     webbrowser.open("http://127.0.0.1:{}".format(port), new=0)
  188. @app.errorhandler(Exception)
  189. def error_handler(e):
  190.     logger.error("全局异常捕获: {}".format(e))
  191.     data = {
  192.         "resultCode": 500,
  193.         "msg": str(e)
  194.     }
  195.     return data
  198. if __name__ == '__main__':
  199.     port = $port
  201.     if not os.environ.get('WERKZEUG_RUN_MAIN'):
  202.         th = threading.Thread(target=openUrl, args=(port,))
  203.         th.start()
  204.     else:
  205.         print("热加载")
  207.     app.run(port=port, debug=True)

index.html

  1. $!globalPort
  2. $!callback.setFileName("index.html")
  3. $!callback.setSavePath($tool.append($tableInfo.savePath, "/$tableInfo.obj.name"))
  4. #if(!$tableInfo.pkColumn.isEmpty())
  5.     #set($pk = $tableInfo.pkColumn.get(0))
  6. #end
  8. <!DOCTYPE html>
  9. <html lang="zh">
  10. <head>
  11.     <meta charset="UTF-8">
  12. #if(!$tableInfo.comment)
  13.     <title>$tableInfo.obj.name</title>
  14. #else
  15.     <title>$tableInfo.comment</title>
  16. #end
  17.     <link rel="stylesheet" href="static/css/element.css">
  18.     <script src="static/js/vue-2.6.12.js"></script>
  19.     <script src="static/js/element.js"></script>
  20.     <script src="static/js/axios.min.js"></script>
  21.     <link rel="shortcut icon" href="static/favicon.ico" type="image/x-icon"/>
  22. </head>
  23. <style>
  24.     /*body {
  25.         width: 80%;
  26.         margin: auto;
  27.         margin-top: 20px;
  28.     }*/
  29. </style>
  30. <body>
  31. <div id="app">
  32.     <div class="app-container">
  33.         <el-form :model="queryParams" ref="queryForm" :inline="true" label-width="68px">
  34. #foreach($column in $tableInfo.fullColumn)
  35. #if(!$column.comment)
  36.             <el-form-item label="$column.obj.name" prop="$column.obj.name">
  37. #else
  38.             <el-form-item label="$column.comment" prop="$column.obj.name">
  39. #end            
  40.                 <el-input
  41.                     v-model.trim="queryParams.${column.obj.name}"
  42. #if(!$column.comment)
  43.                     placeholder="请输入$column.obj.name"
  44. #else
  45.                     placeholder="请输入$column.comment"
  46. #end                     
  47.                     clearable
  48.                     size="small"
  49.                     @keyup.enter.native="handleQuery"/>
  50.             </el-form-item>
  51.             #end
  52.             <el-form-item>
  53.                 <el-pagination
  54.                         background
  55.                         :current-page.sync="queryParams.pageNum"
  56.                         :page-sizes="[10, 20, 30, 50, 400]"
  57.                         :page-size.sync="queryParams.pageSize"
  58.                         layout="total, sizes, prev, pager, next"
  59.                         @size-change="getList"
  60.                         @current-change="getList"
  61.                         :total="total">
  62.                 </el-pagination>
  63.             </el-form-item>
  64.             <el-form-item>
  65.                 <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
  66.                 <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
  67.             </el-form-item>
  68.         </el-form>
  70.         <el-row :gutter="10">
  71.             <el-col :span="1.5">
  72.                 <el-button
  73.                         type="primary"
  74.                         icon="el-icon-plus"
  75.                         size="mini"
  76.                         @click="handleAdd"
  77.                 >新增
  78.                 </el-button>
  79.             </el-col>
  80.             <el-col :span="1.5">
  81.                 <el-button
  82.                         type="success"
  83.                         icon="el-icon-edit"
  84.                         size="mini"
  85.                         :disabled="single"
  86.                         @click="handleUpdate"
  87.                 >修改
  88.                 </el-button>
  89.             </el-col>
  90.             <el-col :span="1.5">
  91.                 <el-button
  92.                         type="danger"
  93.                         icon="el-icon-delete"
  94.                         size="mini"
  95.                         :disabled="multiple"
  96.                         @click="handleDelete"
  97.                 >删除
  98.                 </el-button>
  99.             </el-col>
  100.         </el-row>
  102.         <el-table v-loading="loading" :data="${tableInfo.obj.name}List" @sort-change="handleSortChange" @selection-change="handleSelectionChange">
  103.             <el-table-column type="selection" width="55" align="center"></el-table-column>
  104. #foreach($column in $tableInfo.fullColumn)
  105. #if(!$column.comment)
  106.             <el-table-column label="${column.obj.name}" align="center" sortable prop="${column.obj.name}"></el-table-column>
  107. #else
  108.             <el-table-column label="${column.comment}" align="center" sortable prop="${column.obj.name}"></el-table-column>
  109. #end  
  110. #end
  111.             <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
  112.                 <template slot-scope="scope">
  113.                     <el-button
  114.                             size="mini"
  115.                             type="text"
  116.                             icon="el-icon-edit"
  117.                             @click="handleUpdate(scope.row)"
  118.                     >修改
  119.                     </el-button>
  120.                     <el-button
  121.                             size="mini"
  122.                             type="text"
  123.                             icon="el-icon-delete"
  124.                             @click="handleDelete(scope.row)"
  125.                     >删除
  126.                     </el-button>
  127.                 </template>
  128.             </el-table-column>
  129.         </el-table>
  131.         <!-- 添加或修改对话框 -->
  132.         <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
  133.             <el-form ref="form" :model="form" :rules="rules" label-width="80px">
  134. #foreach($column in $tableInfo.otherColumn)
  135. #if(!$column.comment)
  136.             <el-form-item label="${column.obj.name}" prop="${column.obj.name}">
  137. #if($column.type.equals("java.util.Date"))
  138.                 <el-date-picker clearable size="small" style="width: 200px"
  139.                               v-model="form.${column.obj.name}"
  140.                               type="date"
  141.                               value-format="yyyy-MM-dd"
  142.                               placeholder="选择${column.obj.name}">
  143.                 </el-date-picker>
  144. #else
  145.                 <el-input v-model="form.${column.obj.name}" placeholder="请输入${column.obj.name}"/>
  146. #end
  147.             </el-form-item>
  148. #else
  149.             <el-form-item label="${column.comment}" prop="${column.obj.name}">
  150. #if($column.type.equals("java.util.Date"))
  151.                 <el-date-picker clearable size="small" style="width: 200px"
  152.                               v-model="form.${column.obj.name}"
  153.                               type="date"
  154.                               value-format="yyyy-MM-dd"
  155.                               placeholder="选择${column.comment}">
  156.                 </el-date-picker>
  157. #else
  158.                 <el-input v-model="form.${column.obj.name}" placeholder="请输入${column.comment}"/>
  159. #end
  160.             </el-form-item>
  161. #end 
  162. #end
  163.             </el-form>
  164.             <div slot="footer" class="dialog-footer">
  165.                 <el-button type="primary" @click="submitForm">确 定</el-button>
  166.                 <el-button @click="cancel">取 消</el-button>
  167.             </div>
  168.         </el-dialog>
  169.     </div>
  170. </div>
  171. </body>
  172. <script>
  173.     baseUrl = "http://127.0.0.1:$port"
  174.     new Vue({
  175.         el: '#app',
  176.         data() {
  177.             return {
  178.                 // 遮罩层
  179.                 loading: true,
  180.                 // 选中数组
  181.                 ids: [],
  182.                 // 非单个禁用
  183.                 single: true,
  184.                 // 非多个禁用
  185.                 multiple: true,
  186.                 // 总条数
  187.                 total: 0,
  188.                 // $tableInfo.obj.name表格数据
  189.                 ${tableInfo.obj.name}List: [],
  190.                 // 弹出层标题
  191.                 title: "",
  192.                 // 是否显示弹出层
  193.                 open: false,
  194.                 // 查询参数
  195.                 queryParams: {
  196.                     pageNum: 1,
  197.                     pageSize: 10,
  198. #foreach($column in $tableInfo.fullColumn)
  199.                     ${column.obj.name}:undefined,
  200. #end
  201.                     parmOrder: undefined,
  202.                     parmColumn: undefined
  203.                 },
  204.                 // 表单参数
  205.                 form: {},
  206.                 // 表单校验
  207.                 rules: {
  208. #foreach ($column in $tableInfo.otherColumn)
  209. #if(!$column.comment)
  210.                     ${column.obj.name}: [ { required: true, message: "$column.obj.name不能为空", trigger: "blur" } ],
  211. #else
  212.                     ${column.obj.name}: [ { required: true, message: "$column.comment不能为空", trigger: "blur" } ],
  213. #end
  214. #end
  215.                 }
  216.             };
  217.         },
  218.         created() {
  219.             this.getList();
  220.         },
  221.         methods: {
  222.             // 查询列表
  223.             getList() {
  224.                 this.loading = true;
  225.                 axios({
  226.                     method: 'get',
  227.                     url: baseUrl + '/getList',
  228.                     params:this.queryParams,
  229.                 }).then(res => {
  230.                     const response = res.data;
  231.                     const resultCode = response.resultCode
  232.                     if (resultCode === 200) {
  233.                         this.${tableInfo.obj.name}List = response.rows;
  234.                         this.total = response.total;
  235.                         this.loading = false;
  236.                     } else {
  237.                         this.$message({
  238.                             message: '查询失败,' + response.msg,
  239.                             type: 'error'
  240.                         });
  241.                     }
  242.                 }).catch(function (error) {
  243.                     console.log(error);
  244.                 });
  245.             },
  246.             // 取消按钮
  247.             cancel() {
  248.                 this.open = false;
  249.                 this.reset();
  250.             },
  251.             // 表单重置
  252.             reset() {
  253.                 this.form = {
  254. #foreach ($column in $tableInfo.otherColumn)
  255.                     $column.obj.name: undefined,
  256. #end
  257.                 };
  258.             },
  259.             /** 搜索按钮操作 */
  260.             handleQuery() {
  261.                 this.queryParams.pageNum = 1;
  262.                 this.getList();
  263.             },
  264.             /** 重置按钮操作 */
  265.             resetQuery() {
  266.                 this.$refs.queryForm.resetFields();
  267.                 this.handleQuery();
  268.             },
  269.             // 多选框选中数据
  270.             handleSelectionChange(selection) {
  271.                 this.ids = selection.map(item => item.${pk.obj.name})
  272.                 this.single = selection.length!=1
  273.                 this.multiple = !selection.length
  274.             },
  275.             // 排序
  276.             handleSortChange(column) {
  277.                 let parmOrder = column.order === "ascending" ? "asc" : "desc"
  278.                 this.queryParams.parmColumn = column.prop
  279.                 this.queryParams.parmOrder = parmOrder
  281.                 if (column.order == null) {
  282.                     this.queryParams.parmColumn = undefined
  283.                     this.queryParams.parmOrder = undefined
  284.                 }
  285.                 this.getList()
  286.             },
  287.             /** 新增按钮操作 */
  288.             handleAdd() {
  289.                 this.reset();
  290.                 this.open = true;
  291.                 this.title = "添加";
  292.             },
  293.             /** 修改按钮操作 */
  294.             handleUpdate(row) {
  295.                 this.reset();
  296.                 const ${pk.obj.name} = row.${pk.obj.name} || this.ids[0]
  297.                 axios({
  298.                     method: 'get',
  299.                     url: baseUrl + '/getOne',
  300.                     params:{"${pk.obj.name}":${pk.obj.name}},
  301.                 }).then(res => {
  302.                     if (res.data.resultCode === 200) {
  303.                         this.form = res.data.data;
  304.                         this.open = true;
  305.                         this.title = "修改";
  306.                     }else{
  307.                         this.getList();
  308.                         this.$message({
  309.                             message: "查询失败:" + res.data.msg,
  310.                             type: 'error'
  311.                         });
  312.                     }
  313.                 }).catch(function (error) {
  314.                     console.log(error);
  315.                 });
  316.             },
  317.             /** 提交按钮 */
  318.             submitForm: function() {
  319.                 this.#[[$]]#refs["form"].validate(valid => {
  320.                     if (valid) {
  321.                         if (this.form.${pk.obj.name} != undefined) {
  322.                             axios({
  323.                                 method: 'put',
  324.                                 url: baseUrl + '/update',
  325.                                 data:this.form,
  326.                             }).then(res => {
  327.                                 if (res.data.resultCode === 200) {
  328.                                     this.$message({
  329.                                       message: '修改成功',
  330.                                       type: 'success'
  331.                                     });
  332.                                     this.open = false;
  333.                                     this.getList();
  334.                                 }else{
  335.                                     this.getList();
  336.                                     this.$message({
  337.                                         message: "修改失败:" + res.data.msg,
  338.                                         type: 'error'
  339.                                     });
  340.                                 }
  341.                             }).catch(function (error) {
  342.                                 console.log(error);
  343.                             });
  344.                         } else {
  345.                             axios({
  346.                                 method: 'post',
  347.                                 url: baseUrl + '/add',
  348.                                 data:this.form,
  349.                             }).then(res => {
  350.                                 if (res.data.resultCode === 200) {
  351.                                     this.$message({
  352.                                       message: '新增成功',
  353.                                       type: 'success'
  354.                                     });
  355.                                     this.open = false;
  356.                                     this.getList();
  357.                                 }else{
  358.                                     this.getList();
  359.                                     this.$message({
  360.                                         message: "新增失败:" + res.data.msg,
  361.                                         type: 'error'
  362.                                     });
  363.                                 }
  364.                             }).catch(function (error) {
  365.                                 console.log(error);
  366.                             });
  367.                         }
  368.                     }
  369.                 });
  370.             },
  371.             /** 删除按钮操作 */
  372.             handleDelete(row) {
  373.                 const ${pk.obj.name}s = row.${pk.obj.name} ? [row.${pk.obj.name}] : this.ids
  374.                 this.$confirm('是否确认删除编号为"' + ${pk.obj.name}s + '"的数据项?', "警告", {
  375.                     confirmButtonText: "确定",
  376.                     cancelButtonText: "取消",
  377.                     type: "warning"
  378.                 }).then(() => {
  379.                     axios({
  380.                         method: 'delete',
  381.                         url: baseUrl + '/delete',
  382.                         params:{"${pk.obj.name}s":${pk.obj.name}s},
  383.                     }).then(res => {
  384.                         if (res.data.resultCode === 200) {
  385.                             this.$message({
  386.                               message: '删除成功',
  387.                               type: 'success'
  388.                             });
  389.                             this.open = false;
  390.                             this.getList();
  391.                         }else{
  392.                             this.getList();
  393.                             this.$message({
  394.                                 message: "删除失败:" + res.data.msg,
  395.                                 type: 'error'
  396.                             });
  397.                         }
  398.                     });
  399.                 }).catch(() => {
  400.                 });
  401.             },
  402.         }
  403.     })
  404. </script>
  405. </html>

Global Config

globalPort

  1. #set($port = 666)