public function index()
{
$days = 31;
//# of days compared
$accstbp = Account::whereRaw('datediff(accounts.dueDate,curdate()) <= ' . $days . ' and datediff(accounts.dueDate,curdate()) >= 0')->orderByRaw('datediff(accounts.dueDate,curdate()) ASC')->get();
$accspd = Account::whereRaw('datediff(accounts.dueDate,curdate()) < 0')->orderByRaw('datediff(accounts.dueDate,curdate()) ASC')->get();
return view('admin.home', ['accstbp' => $accstbp, 'accspd' => $accspd]);
}
/**
*Prints the accounts past due with the given # of days.
*/
public function accPastDue()
{
$accs = Account::whereRaw('datediff(accounts.dueDate,curdate()) < 0')->orderByRaw('datediff(accounts.dueDate,curdate()) ASC')->get();
$title = "ACCOUNTS PAST DUE";
return \PDF::loadHTML(view('reports.account_template', compact('accs', 'title')))->stream('report.pdf');
}
