dictdata.py 1.3 KB

123456789101112131415161718192021222324252627282930313233
  1. from ..base import base
  2. from ..models import DictData, DictType
  3. from flask import render_template, request, jsonify
  4. from sqlalchemy import asc
  5. from sqlalchemy import desc
  6. @base.route('/system/dict/data/type/<dictType>', methods=['GET'])
  7. def sysdictdata_get_by_type(dictType):
  8. data_list = DictData.query.filter(DictData.dict_type == dictType)
  9. return jsonify({'msg': '操作成功', 'code': 200, 'data': [data.to_json() for data in data_list]})
  10. @base.route('/system/dict/data/list', methods=['GET'])
  11. def sysdict_data_list():
  12. filters = []
  13. if 'dictLabel' in request.args:
  14. filters.append(DictData.dict_label.like('%' + request.args['dictLabel'] + '%'))
  15. if 'dictType' in request.args:
  16. filters.append(DictData.dict_type.like('%' + request.args['dictType'] + '%'))
  17. if 'status' in request.args:
  18. filters.append(DictData.status == request.args['status'])
  19. page = request.args.get('pageNum', 1, type=int)
  20. rows = request.args.get('pageSize', 10, type=int)
  21. pagination = DictData.query.filter(*filters).paginate(
  22. page, per_page=rows, error_out=False)
  23. data_list = pagination.items
  24. return jsonify({'msg': '操作成功', 'code': 200, 'rows': [data.to_json() for data in data_list], 'total': len(data_list)})