openNAMU__openNAMU/route/list_title_index.py

from .tool.func import *

def list_title_index_2(conn):
    curs = conn.cursor()

    page = int(number_check(flask.request.args.get('page', '1')))
    num = int(number_check(flask.request.args.get('num', '100')))
    sql_num = (page * num - num) if page * num > 0 else 0

    all_list = sql_num + 1

    if num > 1000:
        return re_error('/error/3')

    data = '<a href="/title_index?num=250">(250)</a> <a href="/title_index?num=500">(500)</a> <a href="/title_index?num=1000">(1000)</a>'

    curs.execute(db_change("select title from data order by title asc limit ?, ?"), [sql_num, num])
    title_list = curs.fetchall()
    if title_list:
        data += '<hr class="main_hr"><ul class="inside_ul">'

    for list_data in title_list:
        data += '<li>' + str(all_list) + '. <a href="/w/' + url_pas(list_data[0]) + '">' + html.escape(list_data[0]) + '</a></li>'
        all_list += 1

    if page == 1:
        count_end = []

        curs.execute(db_change('select data from other where name = "count_all_title"'))
        all_title = curs.fetchall()
        if int(all_title[0][0]) < 30000:
            curs.execute(db_change("select count(*) from data"))
            count = curs.fetchall()
            if count:
                count_end += [count[0][0]]
            else:
                count_end += [0]

            sql_list = ['category:', 'user:', 'file:']
            for sql in sql_list:
                curs.execute(db_change("select count(*) from data where title like ?"), [sql + '%'])
                count = curs.fetchall()
                if count:
                    count_end += [count[0][0]]
                else:
                    count_end += [0]

            count_end += [count_end[0] - count_end[1]  - count_end[2]  - count_end[3]]

            data += '''
                </ul>
                <hr class="main_hr">
                <ul class="inside_ul">
                    <li>''' + load_lang('all') + ' : ' + str(count_end[0]) + '''</li>
                </ul>
                <hr class="main_hr">
                <ul class="inside_ul">
                    <li>''' + load_lang('category') + ' : ' + str(count_end[1]) + '''</li>
                    <li>''' + load_lang('user_document') + ' : ' + str(count_end[2]) + '''</li>
                    <li>''' + load_lang('file') + ' : ' + str(count_end[3]) + '''</li>
                    <li>''' + load_lang('other') + ' : ' + str(count_end[4]) + '''</li>
            '''
        else:
            data += '''
                </ul>
                <hr class="main_hr">
                <ul class="inside_ul">
                    <li>''' + load_lang('all') + ' : ' + all_title[0][0] + '''</li>
            '''

    data += '</ul>' + next_fix('/title_index?num=' + str(num) + '&page=', page, title_list, num)
    sub = ' (' + str(num) + ')'

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