public function index()
{
$usuarios = User::select('*')->orderBy('father_last_name')->get();
$trabajos = Trabajo::join('users as u1', 'u1.id', '=', 'user_id')->join('users as t', 't.id', '=', 'tutor_id')->join('LineaInvestigacion as l', 'l.id', '=', 'linea_id')->select('trabajo.id', 'titulo', 'u1.first_name as uname', 'u1.father_last_name as uf', 'u1.mother_last_name as um', 't.first_name as tname', 't.father_last_name as tf', 't.mother_last_name as tm', 'l.Categoria as cat', 'trabajo.Descripcion', 'trabajo.created_at as fecha')->get();
$lineas = LineaInvestigacion::all();
return view('Admin/Reportes/index', compact('usuarios', 'trabajos', 'lineas'));
}
public function nuevotrabajo()
{
$result = LineaInvestigacion::select('id', 'Categoria')->get();
return view('Sistema/NuevoTrabajo', compact('result'));
}
