public function getvolumes($data = null) { $date = new Date('last ' . Input::get('date')); $volumes = Media::join($this->tables['pool'], $this->tables['media'] . '.poolid', '=', $this->tables['pool'] . '.poolid')->where('lastwritten', '>=', (string) $date)->select(array('volumename', 'slot', 'volbytes', 'mediatype', $this->tables['pool'] . '.name', 'lastwritten', 'volstatus')); return Datatables::of($volumes)->make(); }