def get_result(policy, supplied_date):
errors = {}
try:
pa = PolicyAccounting(policy)
except orm.exc.NoResultFound:
error_text = "No Policy found with Policy id: " + policy
errors['error'] = error_text
logger.error(error_text)
return render_template("error.html", context=errors)
invoices = pa.get_invoices(supplied_date)
balance = pa.return_account_balance(supplied_date)
main_dic = {}
invoices_list = []
for invoice in invoices:
logger.debug(
"invoice: bill_date: %s - due_date: %s - cancel_date: %s - amount_due: %s",
invoice.bill_date, invoice.due_date, invoice.cancel_date,
invoice.amount_due)
invoices_list.append({
'bill_date':
invoice.bill_date.strftime('%Y-%m-%d'),
'due_date':
invoice.due_date.strftime('%Y-%m-%d'),
'cancel_date':
invoice.cancel_date.strftime('%Y-%m-%d'),
'amount_due':
invoice.amount_due
})
main_dic['invoices'] = invoices_list
main_dic['balance'] = balance
main_dic['policy_id'] = policy
return render_template('table.html', context=main_dic)
def get_invoice():
if request.json or request.post:
data = dict()
policy_id = int(request.json['policy_id'])
query_date = datetime.datetime.strptime(request.json['query_date'], '%d/%m/%Y').date()
pa = PolicyAccounting(policy_id)
data['policy_number'] = pa.get_policy_number()
data['account_balance'] = pa.return_account_balance(query_date)
data['invoices'] = pa.get_invoices(query_date)
return jsonify(data)
else:
return make_response(jsonify({'error': 'Bad request'}), 400)
