public static function get_closed_ccproject_thread($proj_id, $bdo_id) { $thread = DB::table('project_thread')->select('project_thread.*', 'users.image', 'users.first_name', 'users.last_name')->join('users', 'users.id', '=', 'project_thread.user_id')->where('project_thread.proj_id', $proj_id)->where('project_thread.returned', 2)->orderBy('id', 'desc')->get(); $data = array(); foreach ($thread as $key => $value) { $data[$key] = $value; $data[$key]->files = Project::getFiles($value->id); } foreach ($thread as $key => $value) { $data[$key] = $value; $data[$key]->file = Project::getFile($value->id); } return $data; }