def sale(sale_id):
sale = Sale.query.get(sale_id)
sale_status_histories = SaleStatusHistory.query.filter_by(sale_id=sale_id).order_by(SaleStatusHistory.created.desc()).all()
form = SaleForm(**sale.serialize())
form.agent.query = Agent.query.order_by(Agent.first_name, Agent.last_name)
if form.validate_on_submit():
sale_status = form.sale_status.data
if sale_status != sale.sale_status:
ssh = SaleStatusHistory(sale=sale, status=sale_status)
db_session.add(ssh)
form.populate_obj(sale)
if sale.annual_consumption == '':
sale.annual_consumption = None
if sale.commission_value == '':
sale.commission_value = None
if sale.clawback_value == '':
sale.clawback_value = None
db_session.commit()
return redirect(url_for('sale', sale_id=sale_id))
context = {'sale': sale,
'form': form,
'sale_status_histories': sale_status_histories}
return render_template('sale.html', **context)
