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)