openNAMU__openNAMU/route/list_acl.py

from .tool.func import *

def list_acl_2():
    with get_db_connect() as conn:
        curs = conn.cursor()

        num = int(number_check(flask.request.args.get('num', '1')))
        sql_num = (num * 50 - 50) if num * 50 > 0 else 0
        div = '<ul class="inside_ul">'

        curs.execute(db_change(
            "select distinct title, data, type from acl where data != '' and not title like 'user:%' order by title desc limit ?, 50"
        ), [sql_num])
        list_data = curs.fetchall()
        for data in list_data:
            curs.execute(db_change("select time from re_admin where what like ? order by time desc limit 1"), ['acl (' + data[0] + ')%'])
            time_data = curs.fetchall()
            time_data = (time_data[0][0] + ' | ') if time_data else ''

            curs.execute(db_change("select data from acl where title = ? and type = 'why'"), [data[0]])
            why_data = curs.fetchall()
            why_data = (' | ' + why_data[0][0]) if why_data and why_data[0][0] != '' else ''

            div += '' + \
                '<li>' + \
                    time_data + \
                    '<a href="/acl/' + url_pas(data[0]) + '">' + html.escape(data[0]) + '</a>' + \
                    why_data + \
                '</li>' + \
            ''

        div += '</ul>'
        div += next_fix('/acl_list?num=', num, list_data)

        return easy_minify(flask.render_template(skin_check(),
            imp = [load_lang('acl_document_list'), wiki_set(), wiki_custom(), wiki_css([0, 0])],
            data = div,
            menu = [['other', load_lang('return')]]
        ))