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

@base.route('/system/config/configKey/<configKey>', methods=['GET'])
def sysconfig_get_value(configKey):
    data = Config.query.filter(Config.config_key == configKey).first()

    return jsonify({'code': 200, 'msg': data.config_value})


@base.route('/system/config/list', methods=['GET'])
def sys_config_list():
    filters = []
    if 'configName' in request.args:
        filters.append(Config.config_name.like('%' + request.args['configName'] + '%'))
    if 'configKey' in request.args:
        filters.append(Config.config_key.like('%' + request.args['configKey'] + '%'))
    if 'configType' in request.args:
        filters.append(Config.config_type.like('%' + request.args['configType'] + '%'))


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

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

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