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