openNAMU__openNAMU/route/topic_stop.py

from .tool.func import *

def topic_stop_2(conn, topic_num):
    curs = conn.cursor()

    if admin_check(3) != 1:
        return re_error('/error/3')

    ip = ip_check()
    time = get_time()
    topic_num = str(topic_num)

    if flask.request.method == 'POST':
        curs.execute(db_change("select id from topic where code = ? order by id + 0 desc limit 1"), [topic_num])
        topic_check = curs.fetchall()
        if topic_check:
            stop_d = flask.request.form.get('stop_d', '')
            why_d = flask.request.form.get('why', '')
            agree_d = flask.request.form.get('agree', '')

            curs.execute(db_change("update rd set stop = ?, agree = ? where code = ?"), [
                stop_d,
                agree_d,
                topic_num
            ])

            if stop_d == 'S':
                t_state = 'Stop'
            elif stop_d == 'O':
                t_state = 'Close'
            else:
                t_state = 'Normal'

            curs.execute(db_change("insert into topic (id, data, date, ip, top, code) values (?, ?, ?, ?, '1', ?)"), [
                str(int(topic_check[0][0]) + 1),
                t_state + (' (Agree)' if agree_d != '' else '') + (('[br][br]Why : ' + why_d) if why_d else ''),
                time,
                ip,
                topic_num
            ])

            rd_plus(topic_num, time)

        return redirect('/thread/' + topic_num)
    else:
        stop_d_list = ''
        agree_check = ''

        curs.execute(db_change("select stop, agree from rd where code = ? limit 1"), [topic_num])
        rd_d = curs.fetchall()
        if rd_d[0][0] == 'O':
            stop_d_list += '''
                <option value="O">Close</option>
                <option value="">Normal</option>
                <option value="S">Stop</option>
            '''
        elif rd_d[0][0] == 'S':
            stop_d_list += '''
                <option value="S">Stop</option>
                <option value="">Normal</option>
                <option value="O">Close</option>
            '''
        else:
            stop_d_list += '''
                <option value="">Normal</option>
                <option value="S">Stop</option>
                <option value="O">Close</option>
            '''

        if rd_d[0][1] == 'O':
            agree_check = 'checked="checked"'
        else:
            agree_check = ''

        return easy_minify(flask.render_template(skin_check(),
            imp = [load_lang('topic_setting'), wiki_set(), custom(), other2([0, 0])],
            data = '''
                <hr class=\"main_hr\">
                <form method="post">
                    <select name="stop_d">
                        ''' + stop_d_list + '''
                    </select>
                    <hr class=\"main_hr\">
                    <input type="checkbox" name="agree" value="O" ''' + agree_check + '''> Agree
                    <hr class=\"main_hr\">
                    <input placeholder="''' + load_lang('why') + ''' (''' + load_lang('markup_enabled') + ''')" name="why" type="text">
                    <hr class=\"main_hr\">
                    <button type="submit">''' + load_lang('save') + '''</button>
                </form>
            ''',
            menu = [['thread/' + topic_num + '/tool', load_lang('return')]]
        ))