public function index() { $now = Carbon::now()->toDateString(); $columns = array('address' => 'Property Address', 'last_name' => 'Last Name', 'first_name' => 'First Name', 'renter_id' => 'Renter ID', 'term_start' => 'Start Date', 'term_end' => 'End Date', 'rent' => 'Rent'); $contracts = Contract::whereDate('term_start', '<=', $now)->whereDate('term_end', '>=', $now)->join('renters', 'contracts.renter_id', '=', 'renters.id')->join('properties', 'contracts.property_id', '=', 'properties.id')->select('properties.address', 'renters.first_name', 'renters.last_name', 'contracts.*')->get(); return view('contracts.index', compact('contracts', 'columns')); //return view('contracts.index', compact('contracts', 'columns', 'properties')); }