openNAMU__openNAMU/route/vote_list.py

from .tool.func import *

async def vote_list(list_type = 'normal', num = 1):    
    with get_db_connect() as conn:
        curs = conn.cursor()

        sql_num = (num * 50 - 50) if num * 50 > 0 else 0

        data = ''
        if list_type == 'normal':
            data += '<a href="/vote/list/close">(' + get_lang(conn, 'close_vote_list') + ')</a>'
            sub = 0
            curs.execute(db_change('select name, id, type from vote where type = "open" or type = "n_open" limit ?, 50'), [sql_num])
        else:
            data += '<a href="/vote">(' + get_lang(conn, 'open_vote_list') + ')</a>'
            sub = '(' + get_lang(conn, 'closed') + ')'
            curs.execute(db_change('select name, id, type from vote where type = "close" or type = "n_close" limit ?, 50'), [sql_num])

        data += '<ul>'

        data_list = curs.fetchall()
        for i in data_list:
            if list_type == 'normal':
                open_select = get_lang(conn, 'open_vote') if i[2] == 'open' else get_lang(conn, 'not_open_vote')
            else:
                open_select = get_lang(conn, 'open_vote') if i[2] == 'close' else get_lang(conn, 'not_open_vote')

            data += '<li><a href="/vote/' + i[1] + '">' + i[1] + '. ' + html.escape(i[0]) + '</a> (' + open_select + ')</li>'

        data += '</ul>'
        menu = []
        if list_type == 'normal':
            menu = [["vote/add", get_lang(conn, 'add_vote')]] if await acl_check('', 'vote') != 1 else []
            data += next_fix(conn, '/vote/list/', num, data_list)
        else:
            data += next_fix(conn, '/vote/list/close/', num, data_list)

        return easy_minify(conn, flask.render_template(skin_check(conn),
            imp = [get_lang(conn, 'vote_list'), wiki_set(conn), await wiki_custom(conn), wiki_css([sub, 0])],
            data = data,
            menu = [['other', get_lang(conn, 'return')]] + menu
        ))