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)