dicttype.py 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  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/type/list', methods=['GET'])
  7. def sysdict_type_list():
  8. filters = []
  9. if 'dictName' in request.args:
  10. filters.append(DictType.dict_name.like('%' + request.args['dictName'] + '%'))
  11. if 'dictType' in request.args:
  12. filters.append(DictType.dict_type.like('%' + request.args['dictType'] + '%'))
  13. if 'status' in request.args:
  14. filters.append(DictType.status == request.args['status'])
  15. if 'params[beginTime]' in request.args and 'params[endTime]' in request.args:
  16. filters.append(DictType.create_time > request.args['params[beginTime]'])
  17. filters.append(DictType.create_time < request.args['params[endTime]'])
  18. page = request.args.get('pageNum', 1, type=int)
  19. rows = request.args.get('pageSize', 10, type=int)
  20. pagination = DictType.query.filter(*filters).paginate(
  21. page, per_page=rows, error_out=False)
  22. types = pagination.items
  23. return jsonify({'msg': '操作成功', 'code': 200, 'rows': [type.to_json() for type in types], 'total': len(types)})
  24. @base.route('/system/dict/type/<id>', methods=['GET'])
  25. def sysdict_type_get_by_id(id):
  26. type = DictData.query.get(id)
  27. return jsonify({'msg': '操作成功', 'code': 200, 'data': type.to_json()})
  28. @base.route('/system/dict/type/optionselect', methods=['GET'])
  29. def sysdict_type_all():
  30. types = DictData.query.all()
  31. return jsonify({'msg': '操作成功', 'code': 200, 'data': [type.to_json() for type in types]})