def create():
    form_errors = None
    conn, cur = get_sql()
    if request.method == 'POST':
        for k,v in request.form.iteritems():
            print k,v
        form_errors = collect_form_errors(request.form)
        if not len(form_errors) > 1:
            form_items = {}
            for k, v in request.form.iteritems():
                print "key = {} value = {}".format(k,v)
                if (k == 'editor1'):
                    form_items['html'] = request.form[k]
                elif (k == 'file'):
                    form_items['preview'] = request.form[k]
                elif (v != ''):
                    form_items[k] = v

            form_items['author'] = session.get('current_user')
            form_items['date_added'] = int(time())
            tid = insert_row('template', form_items, conn, cur)
            if not tid:
                return render_template('server_error.html')
            return redirect(url_for('templates.edit', tid=tid))
    return render_template('templates/details.html', form_errors=form_errors)
Пример #2
0
def create():
    form_errors = None
    conn, cur = get_sql()
    if request.method == "POST":
        form_errors = collect_form_errors(request.form)
        if not form_errors:
            form_items = {}
            for k, v in request.form.iteritems():
                if v != "":
                    form_items[k] = v
            form_items["author"] = session.get("current_user")
            form_items["date_added"] = int(time())
            lid = insert_row("list", form_items, conn, cur)
            if not lid:
                return render_template("server_error.html")
            return redirect(url_for("lists.edit", lid=lid))
    return render_template("lists/details.html", form_errors=form_errors, editing=False)
def create():
    form_errors = None
    conn, cur = get_sql()
    companies = get_companies(conn, cur)
    staff = get_staff(conn, cur)
    if request.method == 'POST':    
        form_errors = collect_form_errors(request.form)
        if not form_errors:
            form_items = {}
            for k, v in request.form.iteritems():
                if (v != '' and k[len(k) - 3:] != 'sel'):
                    form_items[k] = v
            form_items['author'] = session.get('current_user')
            form_items['date_added'] = int(time())
            nid = insert_row('newsletter', form_items, conn, cur)
            if not nid:
                return render_template('server_error.html')
            return redirect(url_for('lists.index', nid=nid))
    return render_template('newsletters/details.html', companies=companies,
                           staff=staff, form_errors=form_errors)
def edit():
    form_errors = None
    conn, cur = get_sql()
    companies = get_companies(conn, cur)
    staff = get_staff(conn, cur)
    # for k,v in request.args.iteritems():
    #     print k,v
    if request.method == 'GET':
        nid = request.args.get('nid')
        cur.execute('SELECT * FROM `newsletter` WHERE newsletter_id = %d' % int(nid))
        res = cur.fetchone()
        if res:
            cols = tuple([d[0].decode('utf8') for d in cur.description])
            newsletter = dict(zip(cols, res))
            company_name = cur.execute("""SELECT name 
                                          FROM company 
                                          WHERE company_id = %d""" % int(newsletter['company']))
            comp_name = cur.fetchone()[0]
            newsletter['company'] = (newsletter['company'], comp_name)
            return render_template('newsletters/details.html', newsletter=newsletter,
                                   staff=staff, companies=companies, nid=nid)
        return render_template('404.html')
    if request.method == 'POST':    
        nid = request.args.get('nid')
        form_errors = collect_form_errors(request.form)
        if not form_errors:
            form_items = {}
            for k, v in request.form.iteritems():
                if (v != '' and k[len(k) - 3:] != 'sel'):
                    form_items[k] = v
            form_items['date_added'] = int(time())
            nid = update_row('newsletter', form_items, conn, cur, nid)
            if not nid:
                return render_template('server_error.html')
            return redirect(url_for('lists.index', nid=nid))
        return render_template('newsletters/details.html', newsletter=newsletter,
                                staff=staff, companies=companies, nid=nid, 
                                form_errors=form_errors)