def get():
obj = Encoder.to_dict(request.vars)
rows = db(
(db.auth_membership.user_id == db.UsuarioUSB.id) & (db.auth_membership.group_id == db.auth_group.id)).select()
prueba=rows.as_json()
return rows.as_json()
def etapas():
obj = Encoder.to_dict(request.vars)
rows = Etapa.find(obj)
response.view = 'mis_pasantias/etapas.load.html'
return dict(etapas=rows.as_list(),id="id")
def get():
obj = Encoder.to_dict(request.vars)
rows = Pasantia.JMaterias(obj)
rows = rows.as_json()
return rows
def get():
obj = Encoder.to_dict(request.vars)
rows = Permiso.find(obj)
rows = rows.as_json()
return rows
def get():
obj = Encoder.to_dict(request.vars)
rows = Accion_Usuario.find(obj)
rows = rows.as_json()
return rows
def configuracion():
rows = []
obj = Encoder.to_dict(request.vars)
#TODO Hacer que esto filtre dependiendo del rol del usuario logeado
if ('currentUser' in session):
usuario = session.currentUser
rol = db((db.auth_membership.user_id == auth.user.id)
& (db.auth_membership.group_id == db.auth_group.id)).select().first()
rows = db((db.Accion_Usuario.rol == rol.auth_group.id) & (db.Accion_Usuario.contexto == 'configuracion')).select()
response.view = 'sidebar/configuracion.load.html'
return dict(routes=rows,id="id")
def get():
obj = Encoder.to_dict(request.vars)
query = "db.Estudiante"
if 'searchTerm' in obj and obj['searchTerm'] != '{}':
query = dict()
search = ast.literal_eval(obj['searchTerm'])
query = "db.Estudiante." + search["key"] + ".startswith('" + search["value"] + "')"
rows = db(eval(query) & (db.Inscripcion.pasantia == db.Pasantia.id) & (db.Pasantia.estudiante == db.Estudiante.id) & (db.Pasantia.id == db.Plan_Trabajo.pasantia)).select()
return rows.as_json()
def count():
obj = Encoder.to_dict(request.vars)
query = "db.Estudiante"
if 'searchTerm' in obj and obj['searchTerm'] != '{}':
query = dict()
search = ast.literal_eval(obj['searchTerm'])
query = "db.Estudiante." + search["key"] + ".startswith('" + search["value"] + "')"
count = db(eval(query) & (db.Plan_Trabajo.pasantia == db.Pasantia.id) & (db.Estudiante.id == db.Pasantia.estudiante)).count()
return count
def get():
obj = Encoder.to_dict(request.vars)
rows = Material.find(obj)
for row in rows:
row.area = row.area.nombre_area
row.unidad_metrica = row.unidad_metrica.nombre_unidadMetrica
row.hasEnough = True
if (row.cantidad and row.cantidad_Minima):
if (row.cantidad < row.cantidad_Minima):
row.hasEnough = False
rows = rows.as_json()
return rows
def get():
obj = Encoder.to_dict(request.vars)
rows = Empleado.find(obj)
#In case of references
for row in rows:
row.area = row.area.nombre_area
row.isActive = True
if row.estado == 'Inactivo':
row.isActive = False
rows = rows.as_json()
return rows
def count():
obj = Encoder.to_dict(request.vars)
count = Material.count(obj)
return count
def get():
obj = Encoder.to_dict(request.vars)
rows = db((db.Plan_Trabajo.pasantia == db.Pasantia.id) & (db.Pasantia.estudiante == db.Estudiante.id)).select()
return rows.as_json()
def count():
obj = Encoder.to_dict(request.vars)
count = PlanTrabajo.count(obj)
return count
def count():
obj = Encoder.to_dict(request.vars)
count = Permiso.count(obj)
return count
def count():
obj = Encoder.to_dict(request.vars)
count = Pasantia.count(obj)
return count
def count():
obj = Encoder.to_dict(request.vars)
count = Usuario.count(obj)
return count
def count():
obj = Encoder.to_dict(request.vars)
count = Empleado.count(obj)
return count
