public function postindex(Request $request)
 {
     $id_cod = $request->input('id_cod');
     $hora = $request->input('hora');
     $per = Personal::where('id', $id_cod)->first();
     if ($per) {
         $id = DB::table("hora")->insertGetId(array('hora' => $hora));
         DB::table("registra")->insertGetId(array('id_e' => $id_cod, 'id_hor' => $id, 'fecha_ac' => date('y-m-d')));
         return response()->json(array('msg' => "<h1>" . $per->nombre . " Registrado exitosamente</h1>"));
     } else {
         return response()->json(array('msg' => "<h1>No existe el codigo " . $id_cod . "</h1>"));
     }
 }
 public function sendtests()
 {
     if (Input::has('enviar')) {
         $personal = Personal::where('user_id', $this->user->id)->get();
         $data["user_id"] = $this->user->id;
         $data["proyecto_id"] = Input::get('proyectoid');
         foreach ($personal as $personals) {
             $data["user_id"] = $personals["id"];
             $data["testmd5"] = md5($personals["id"] + time());
             Resultado::create($data);
             $proyecto = Proyecto::find($data["proyecto_id"]);
             $proyecto->estado = 1;
             $proyecto->save();
             $datosempresa = $this->datosempresa;
             Mail::queue('emails.tests', ['empresa' => $datosempresa, 'link' => $data["testmd5"]], function ($message) use($personals, $datosempresa) {
                 $message->to($personals["correo"])->subject('Cuestionarios ' . $datosempresa["name"] . ' - Puzzle Analytics');
             });
             $value[] = $personals["correo"];
         }
         return redirect('proyectos');
     }
 }
 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function eliminar($id)
 {
     $persona = Personal::where('documento', '=', $id)->get();
     if (is_null($persona)) {
         App::abort(404);
     }
     $persona->delete();
     return response()->json(['mensaje' => 'El registro se elimino correctamente']);
 }