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'); }