from ..base import base
from ..models import DictData, DictType
from flask import render_template, request, jsonify
from sqlalchemy import asc
from sqlalchemy import desc

@base.route('/system/dict/type/list', methods=['GET'])
def sysdict_type_list():
    filters = []
    if 'dictName' in request.args:
        filters.append(DictType.dict_name.like('%' + request.args['dictName'] + '%'))
    if 'dictType' in request.args:
        filters.append(DictType.dict_type.like('%' + request.args['dictType'] + '%'))

    if 'status' in request.args:
        filters.append(DictType.status == request.args['status'])


    if 'params[beginTime]' in request.args and 'params[endTime]' in request.args:
        filters.append(DictType.create_time >  request.args['params[beginTime]'])
        filters.append(DictType.create_time <  request.args['params[endTime]'])

    page = request.args.get('pageNum', 1, type=int)
    rows = request.args.get('pageSize', 10, type=int)
    pagination = DictType.query.filter(*filters).paginate(
        page, per_page=rows, error_out=False)
    types = pagination.items

    return jsonify({'msg': '操作成功', 'code': 200, 'rows': [type.to_json() for type in types], 'total': len(types)})

@base.route('/system/dict/type/<id>', methods=['GET'])
def sysdict_type_get_by_id(id):
    type = DictData.query.get(id)

    return jsonify({'msg': '操作成功', 'code': 200, 'data': type.to_json()})

@base.route('/system/dict/type/optionselect', methods=['GET'])
def sysdict_type_all():
    types = DictData.query.all()

    return jsonify({'msg': '操作成功', 'code': 200, 'data': [type.to_json() for type in types]})