def alluniversidad(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT UNI_ID, UNI_NOMBRE FROM UNIVERSIDAD"
cursor.execute(sql)
UNIVERSIDAD = cursor.fetchall()
db.close()
return UNIVERSIDAD
def all(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT id, title, description FROM posts"
cursor.execute(sql)
posts = cursor.fetchall()
db.close()
return posts
def all(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT MED_PAG_ID, MED_PAG_NOMBRE FROM MEDIO_PAGO"
cursor.execute(sql)
MEDIO_PAGO = cursor.fetchall()
db.close()
return MEDIO_PAGO
def all_kiosco(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID,K.KIO_NOMBRE,C.CAR_NOMBRE, U.UNI_NOMBRE, K.KIO_UBICACION, K.KIO_APERTURA, K.KIO_CERRAR FROM KIOSCO as K, CARRERA as C, UNIVERSIDAD as U WHERE K.KIO_CAR_ID = C.CAR_ID AND K.KIO_UNI_ID = U.UNI_ID;"
cursor.execute(sql)
KIOSCO = cursor.fetchall()
db.close()
return KIOSCO
def all_almuerzo(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT ALM_ID, ALM_NOMBRE FROM ALMUERZO"
cursor.execute(sql)
ALMUERZO = cursor.fetchall()
db.close()
return ALMUERZO
def all_permiso(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT PER_ID, PER_NOMBRE FROM PERMISO"
cursor.execute(sql)
PERMISO = cursor.fetchall()
db.close()
return PERMISO
def find_carrera(self, CAR_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM CARRERA WHERE CAR_ID = " + CAR_ID + ";"
result = cursor.execute(sql)
CARRERA = cursor.fetchone()
db.close()
return CARRERA
def search_kioUsuario(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT U.USU_NOMBRE, U.USU_CORREO, K.KIO_NOMBRE,KU.KIO_USU_F_I,KU.KIO_USU_F_T FROM KIOSCO_USUARIO AS KU, KIOSCO AS K, USUARIO AS U WHERE KU.KIO_USU_KIO = K.KIO_ID AND KU.KIO_USU_ID = U.USU_ID AND KU.KIO_USU_F_T = '0000-00-00' ORDER BY `KU`.`KIO_USU_F_I` DESC;"
cursor.execute(sql)
KUSUARIO = cursor.fetchall()
db.close()
return KUSUARIO
def not_assigned(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID, K.KIO_NOMBRE FROM KIOSCO as K WHERE K.KIO_ID NOT IN (SELECT K.KIO_ID FROM KIOSCO_USUARIO AS KU, KIOSCO AS K, USUARIO AS U WHERE KU.KIO_USU_KIO = K.KIO_ID AND KU.KIO_USU_ID = U.USU_ID AND KU.KIO_USU_F_T = '0000-00-00');"
cursor.execute(sql)
NOTASG = cursor.fetchall()
db.close()
return NOTASG
def all_usuario(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT USU_ID, USU_NOMBRE, USU_CORREO, TIP_USU_NOMBRE, USU_BANEADO, PER_NOMBRE, PER_USU_F_I, PER_USU_F_T FROM USUARIO, PERMISO_USUARIO, PERMISO, TIPO_USUARIO WHERE USUARIO.USU_ID = PERMISO_USUARIO.PER_USU_ID AND PERMISO_USUARIO.PER_USU_PER = PERMISO.PER_ID AND USUARIO.USU_TIP_USU = TIPO_USUARIO.TIP_USU_ID;"
cursor.execute(sql)
USUARIO = cursor.fetchall()
db.close()
return USUARIO
def search_admKiosco(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = " SELECT USU_ID, USU_NOMBRE, USU_CORREO FROM USUARIO WHERE USU_TIP_USU = '2' AND USU_BANEADO = '0' GROUP BY USU_NOMBRE;"
cursor.execute(sql)
ADMKIOSCO = cursor.fetchall()
db.close()
return ADMKIOSCO
def all_mediopago(self): # lista todas las carreras de la base de datos db = DatabaseManager() connection= db.get_connection() with connection.cursor() as cursor: sql = "SELECT MED_PAG_ID, MED_PAG_NOMBRE FROM MEDIO_PAGO" cursor.execute(sql) MEDIO_PAGO = cursor.fetchall() db.close() return MEDIO_PAGO
def find_mediopago(self, MED_PAG_ID): # encuentra una carrera en especifico db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT * FROM MEDIO_PAGO WHERE MED_PAG_ID = "+MED_PAG_ID+";" result = cursor.execute(sql) MEDIO_PAGO = cursor.fetchone() db.close() return MEDIO_PAGO
def search_metodo(self, MT_ID, KA_DATE):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT KA.KIO_ALM_ID ,K.KIO_ID,K.KIO_NOMBRE, A.ALM_ID,A.ALM_NOMBRE, KA.PRECIO, KA.HORA, MP.MED_PAG_ID,MP.MED_PAG_NOMBRE FROM kiosco_medio_pago as KMP, kiosco as K, medio_pago as MP, kiosco_almuerzo as KA, almuerzo as A WHERE KMP.KIO_MED_PAG_KIO = K.KIO_ID AND KMP.KIO_MED_PAG_MED = MP.MED_PAG_ID AND KA.KIO_ALM_KIO=K.KIO_ID AND KA.KIO_ALM_ALM = A.ALM_ID AND MP.MED_PAG_ID = '" + MT_ID + "' AND KA.Fecha = '" + KA_DATE + "';"
cursor.execute(sql)
S_CATEGORIA = cursor.fetchall()
db.close()
return S_CATEGORIA
def search_almu_categoria(self,KA_CATEGORIA,KA_DATE): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT KA.KIO_ALM_ID,K.KIO_ID,K.KIO_NOMBRE,A.ALM_ID,A.ALM_NOMBRE,C.CAT_ID,C.CAT_NOMBRE, KA.PRECIO, KA.HORA FROM KIOSCO_ALMUERZO as KA, CATEGORIA as C, KIOSCO as K, ALMUERZO as A WHERE KA.KIO_ALM_CAT = C.CAT_ID AND KA.KIO_ALM_KIO = K.KIO_ID AND KA.KIO_ALM_ALM = A.ALM_ID AND C.CAT_ID = '"+KA_CATEGORIA+"' AND KA.Fecha = '"+KA_DATE+"';" cursor.execute(sql) KA_CAT = cursor.fetchall() db.close() return KA_CAT
def all_almuerzo(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID, K.KIO_NOMBRE,A.ALM_NOMBRE, KA.PRECIO,KA.HORA,KA.FECHA FROM ALMUERZO as A, KIOSCO_ALMUERZO as KA, KIOSCO as K WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_KIO = K.KIO_ID;"
cursor.execute(sql)
ALMUERZO = cursor.fetchall()
db.close()
return ALMUERZO
def all_tipousuario(self): # lista todas las carreras de la base de datos
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT TIP_USU_ID, TIP_USU_NOMBRE FROM TIPO_USUARIO"
cursor.execute(sql)
TIPO_USUARIO = cursor.fetchall()
db.close()
return TIPO_USUARIO
def today_almuerzo(self, KIO_FECHA):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT KA.KIO_ALM_ID,K.KIO_ID, K.KIO_NOMBRE,A.ALM_NOMBRE, KA.PRECIO,KA.HORA,KA.FECHA FROM ALMUERZO as A, KIOSCO_ALMUERZO as KA, KIOSCO as K WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_KIO = K.KIO_ID AND KA.Fecha = '" + KIO_FECHA + "' ORDER BY `A`.`ALM_NOMBRE` ASC;"
cursor.execute(sql)
TODAY = cursor.fetchall()
db.close()
return TODAY
def find_permiso(self, PER_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM PERMISO WHERE PER_ID = " + PER_ID + ";"
result = cursor.execute(sql)
PERMISO = cursor.fetchone()
db.close()
return PERMISO
def almuerzo_precio(self, KIO_FECHA):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT KA.KIO_ALM_ID,A.ALM_ID, A.ALM_NOMBRE,C.CAT_ID,C.CAT_NOMBRE,KA.PRECIO FROM KIOSCO_ALMUERZO as KA, ALMUERZO as A, CATEGORIA as C WHERE KA.KIO_ALM_ALM = A.ALM_ID AND KA.KIO_ALM_CAT = C.CAT_ID AND KA.Fecha = '" + KIO_FECHA + "' ORDER BY `KA`.`PRECIO` ASC ;"
cursor.execute(sql)
A_PRECIO = cursor.fetchall()
db.close()
return A_PRECIO
def search_admin_user(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT USUARIO.USU_NOMBRE FROM USUARIO WHERE USUARIO.USU_TIP_USU = 3;"
cursor.execute(sql)
ADMIN = cursor.fetchall()
db.close()
return ADMIN
def find_kiosco(self, KIO_ALM_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM KIOSCO_ALMUERZO WHERE KIO_ALM_ID = " + KIO_ALM_ID + ";"
result = cursor.execute(sql)
KIOSCO_ALMUERZO = cursor.fetchone()
db.close()
return KIOSCO_ALMUERZO
def find_kiosco(self, KIO_ID):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT K.KIO_ID,K.KIO_NOMBRE,K.KIO_CAR_ID,C.CAR_NOMBRE,K.KIO_UNI_ID,U.UNI_NOMBRE,K.KIO_UBICACION FROM KIOSCO as K, UNIVERSIDAD AS U, CARRERA as C WHERE K.KIO_UNI_ID = U.UNI_ID AND K.KIO_CAR_ID = C.CAR_ID AND K.KIO_ID = '" + KIO_ID + "' "
result = cursor.execute(sql)
KIOSCO = cursor.fetchone()
db.close()
return KIOSCO
def all_categoria(self): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT CAT_ID,CAT_NOMBRE FROM CATEGORIA;" cursor.execute(sql) CATEGORIA = cursor.fetchall() db.close() return CATEGORIA
def find_almuerzo(self, ALM_ID): # encuentra una carrera en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM ALMUERZO WHERE ALM_ID = " + ALM_ID + ";"
result = cursor.execute(sql)
ALMUERZO = cursor.fetchone()
db.close()
return ALMUERZO
def search_categorias(self,CAT_ID): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT CAT_NOMBRE FROM CATEGORIA WHERE CAT_ID = '"+CAT_ID+"';" cursor.execute(sql) S_CATEGORIA = cursor.fetchall() db.close() return S_CATEGORIA
def allcarrera(self):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT CAR_ID, CAR_NOMBRE FROM CARRERA"
cursor.execute(sql)
CARRERA = cursor.fetchall()
db.close()
return CARRERA
def categorias_existentes(self): db = DatabaseManager() connection = db.get_connection() with connection.cursor() as cursor: sql = "SELECT C.CAT_ID, C.CAT_NOMBRE FROM KIOSCO_ALMUERZO as KA, CATEGORIA as C WHERE KA.KIO_ALM_CAT = C.CAT_ID GROUP BY C.CAT_ID ;" cursor.execute(sql) CATEGORIA_E = cursor.fetchall() db.close() return CATEGORIA_E
def find_usuario(self, USU_ID): # encuentra una usuario en especifico
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM USUARIO WHERE USU_ID = " + USU_ID + " LIMIT 1;"
result = cursor.execute(sql)
USUARIO = cursor.fetchone()
db.close()
return USUARIO
def find(self, MED_PAG_ID):
db = DatabaseManager()
connection = db.get_connection()
with connection.cursor() as cursor:
sql = "SELECT * FROM MEDIO_PAGO WHERE MED_PAG_ID = " + MED_PAG_ID + ";"
result = cursor.execute(sql)
med_pag = cursor.fetchone()
db.close()
return med_pag
