def search_invoice():
invoice_id = request.args.get('invoice_id')
inv = Invoice()
inv.invoice_id = invoice_id
invoice = inv.get_invoice_by_id()
if invoice:
id = invoice[0][1]
costumer = invoice[0][2]
date = str(datetime.strftime(invoice[0][3], '%Y-%m-%d'))
seller = invoice[0][4]
items = invoice[0][5]
total = invoice[0][6]
pending = invoice[0][7]
return redirect(url_for('print_invoice', id=id, costumer=costumer, date=date, seller=seller,
items=items, total=total, pending=pending))
else:
return redirect(url_for('select_invoice', nfy="No found"))
