public function search($search, $id)
 {
     if (!empty($search)) {
         $entries = $this->entry->join('users', 'users.id', '=', 'entries.user_id')->where('users.name', 'LIKE', '%' . $search . '%')->where('project_id', '=', $id);
         if ($entries->count() > 0) {
             return $entries->paginate(5);
         } else {
             $entries = $this->entry->join('users', 'users.id', '=', 'entries.user_id')->where('users.email', 'LIKE', '%' . $search . '%')->where('project_id', '=', $id);
             if ($entries->count() > 0) {
                 return $entries->paginate(5);
             }
         }
     }
 }
 public function query($id)
 {
     if (!empty($id)) {
         $users = $this->entry->select('*')->join('projects', 'projects.id', '=', 'entries.project_id')->join('entry_free', 'entries.id', '=', 'entry_free.entry_id')->join('frees', 'entry_free.free_id', '=', 'frees.id')->where('projects.id', $id)->get();
         if ($users->count() > 0) {
             $entry = $this->entry->find($id);
             $protocol = $entry->project->protocol->protocol_number;
             $file = 'export_frees/01757321000106_' . $protocol . '_' . date('dmY') . '_001.txt';
             foreach ($users as $user) {
                 $contents = $user->nome . ';' . $user->nis . ';' . $user->datadenascimento . ';' . $user->sexo . ';' . $user->num_identid_rg . ';' . $user->dt_identid_rg . ';' . $user->sg_em_identid_rg . ';' . $user->cpf . ';' . $user->nomedamae . ";\r\n";
                 $bytes_written = File::append($file, $contents);
                 if ($bytes_written === false) {
                     die("Error writing to file");
                 }
             }
             return $file;
         }
     }
 }