1
I have a table of invoices and customers.
In the invoice table, for example, I have the cliente_id, status and date fields
In client table id, name, etc...
What I need is to list all the invoices, which the status is still in Open (in NP case - unpaid). But I only wish to list invoices that have not been paid for more than 10 days.
Example of the listing
Cliente Data de Vencimento Valor
Teste 10/08/2016 R$ 100,00
Teste 09/08/2016 R$ 200,00
Teste 05/08/2016 R$ 100,00
Teste 01/08/2016 R$ 100,00
Teste 10/07/2016 R$ 100,00
I use PHP and Mysql.
Fetch last 7 days data from current date
– Bacco