(error) Landing page details

[mbayopanda]

There is an error on the landing page details :

• 400 : BAD REQUEST
• SQL ER_PARSE_ERROR

[jniles]

The error is because this line:

  const dbPromise = [db.exec(sqlInvoices, [date, date]), db.exec(sqlBalance, [date, date])];

Should be

  const dbPromise = [db.exec(sqlInvoices, [date, date, date, date]), db.exec(sqlBalance, [date, date, date, date])];

[jniles]

Also, the sqlInvoices query could be greatly improved by only scanning the invoices table instead of the invoices JOINed with voucher.

[jniles]

I'll take this.