dictdata.py 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  1. from datetime import datetime
  2. from flask_login import current_user
  3. from ..base import base
  4. from ..models import DictData, DictType
  5. from flask import render_template, request, jsonify
  6. from sqlalchemy import asc
  7. from sqlalchemy import desc
  8. from .. import db
  9. from flask_login import login_required
  10. from .. import permission
  11. @base.route('/system/dict/data/type/<dictType>', methods=['GET'])
  12. @login_required
  13. def sysdictdata_get_by_type(dictType):
  14. data_list = DictData.query.filter(DictData.dict_type == dictType)
  15. return jsonify({'msg': '操作成功', 'code': 200, 'data': [data.to_json() for data in data_list]})
  16. @base.route('/system/dict/data/list', methods=['GET'])
  17. @login_required
  18. @permission('system:dict:list')
  19. def sysdict_data_list():
  20. filters = []
  21. if 'dictLabel' in request.args:
  22. filters.append(DictData.dict_label.like('%' + request.args['dictLabel'] + '%'))
  23. if 'dictType' in request.args:
  24. filters.append(DictData.dict_type.like('%' + request.args['dictType'] + '%'))
  25. if 'status' in request.args:
  26. filters.append(DictData.status == request.args['status'])
  27. page = request.args.get('pageNum', 1, type=int)
  28. rows = request.args.get('pageSize', 10, type=int)
  29. pagination = DictData.query.filter(*filters).paginate(
  30. page=page, per_page=rows, error_out=False)
  31. data_list = pagination.items
  32. return jsonify({'msg': '操作成功', 'code': 200, 'rows': [data.to_json() for data in data_list], 'total': pagination.total})
  33. @base.route('/system/dict/data/<id>', methods=['GET'])
  34. @login_required
  35. @permission('system:dict:query')
  36. def sysdict_data_get_by_id(id):
  37. data = DictData.query.get(id)
  38. return jsonify({'msg': '操作成功', 'code': 200, 'data': data.to_json()})
  39. @base.route('/system/dict/data', methods=['POST'])
  40. @login_required
  41. @permission('system:dict:add')
  42. def sysdict_data_add():
  43. dictData = DictData()
  44. if 'dictLabel' in request.json: dictData.dict_label = request.json['dictLabel']
  45. if 'dictSort' in request.json: dictData.dict_sort = request.json['dictSort']
  46. if 'dictType' in request.json: dictData.dict_type = request.json['dictType']
  47. if 'dictValue' in request.json: dictData.dict_value = request.json['dictValue']
  48. if 'listClass' in request.json: dictData.list_class = request.json['listClass']
  49. if 'status' in request.json: dictData.status = request.json['status']
  50. dictData.create_time = datetime.now()
  51. dictData.create_by = current_user.NAME
  52. db.session.add(dictData)
  53. return jsonify({'code': 200, 'msg': '操作成功'})
  54. @base.route('/system/dict/data', methods=['PUT'])
  55. @login_required
  56. @permission('system:dict:edit')
  57. def sysdict_data_update():
  58. dictData = DictData.query.get(request.json['dictCode'])
  59. if 'dictLabel' in request.json: dictData.dict_label = request.json['dictLabel']
  60. if 'dictSort' in request.json: dictData.dict_sort = request.json['dictSort']
  61. if 'dictType' in request.json: dictData.dict_type = request.json['dictType']
  62. if 'dictValue' in request.json: dictData.dict_value = request.json['dictValue']
  63. if 'listClass' in request.json: dictData.list_class = request.json['listClass']
  64. if 'status' in request.json: dictData.status = request.json['status']
  65. if 'remark' in request.json: dictData.remark = request.json['remark']
  66. if 'isDefault' in request.json: dictData.is_default = request.json['isDefault']
  67. dictData.update_time = datetime.now()
  68. dictData.update_by = current_user.NAME
  69. db.session.add(dictData)
  70. return jsonify({'msg': '操作成功', 'code': 200})
  71. @base.route('/system/dict/data/<string:ids>', methods=['DELETE'])
  72. @login_required
  73. @permission('system:dict:remove')
  74. def sydata_delete(ids):
  75. idList = ids.split(',')
  76. for id in idList:
  77. dictData = DictData.query.get(id)
  78. if dictData:
  79. db.session.delete(dictData)
  80. return jsonify({'code': 200, 'msg': '操作成功'})