def index():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
wid = "1"
TablaServicioAutomotor = dict()
TablaServicioAutomotor = {
'TABLE': 'products',
'Col1': 'id_product',
'Col2': 'id_proveedor',
'Col3': 'id_categoria',
'Col4': 'name',
'Col5': 'precio',
'Col6': 'descripcion',
'Whe7': 'id_product=%s'
}
Data = (wid, )
url_product = "/home/product" + "_" + wid + ".html"
DatosServicioV = connect.SW_TABLE(username, TablaServicioAutomotor, Data)
print(DatosServicioV)
id_pdt = "/static/imgs/img_product_" + wid + ".jpeg"
return render_template("/home/index.html",
url=urlrev,
Oferta_Servicio=DatosServicioV,
id_pdt=id_pdt)
def Category_id():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
id_categoria = req["id_categoria"]
wid = id_categoria
TablaServicioAutomotor = dict()
TablaServicioAutomotor = {
'TABLE': 'products',
'Col1': 'id_product ',
'Col2': 'id_proveedor',
'Col3': 'id_categoria',
'Col4': 'name',
'Col5': 'precio',
'Col6': 'descripcion',
'Col7': 'media',
'Whe8': 'id_categoria=%s'
}
Data = (wid, )
DatosServicioV = connect.SW_TABLE(username, TablaServicioAutomotor, Data)
print(DatosServicioV)
DatosAllMedia = json.dumps(DatosServicioV)
return (DatosAllMedia)
def Servicios(id):
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect=Model(username)
wid = id
TablaServicioAutomotor = dict()
TablaServicioAutomotor = {'TABLE':'servicio',
'Col1':'id',
'Col2':'tipo',
'Col3':'costo',
'Col4':'detalles',
'Col5':'automotor',
'Whe6':'automotor=%s'
}
Data = (wid,)
DatosServicioV = connect.SW_TABLE(username,TablaServicioAutomotor, Data)
return render_template("/lavasplash/Servicios.html", url = urlrev, Oferta_Servicio = DatosServicioV)
def VerDetallesServicio(id):
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect=Model(username)
TSSOfServicio = dict()
wid = id
TSSOfServicio = {'TABLE':'servicio',
'Col1':'id',
'Col2':'tipo',
'Col3':'costo',
'Col4':'detalles',
'Whe5':'id=%s'
}
Data = (wid,)
DatosOfServicio = connect.SW_TABLE(username,TSSOfServicio, Data)
return render_template("/lavasplash/ActualizarServicio.html", url = urlrev,
Oferta_Servicio = DatosOfServicio)
def palabra():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
wid = req["nro_crucigrama"]
#wid = "1"
TSSPalabras = {'TABLE': 'crucigrama', 'Col1': 'palabras', 'Whe2': 'id=%s'}
Data = (wid, )
EnCrucigrama = connect.SW_TABLE(username, TSSPalabras, Data)
cx = "*"
Total_palabras = EnCrucigrama[0]["palabras"]
palabra = req["palabra"]
cx += palabra
acierto = True
for item in req["coordenadas"]:
coord = req["coordenadas"][item]
cx += coord
mtrix_palabras = Total_palabras.split("*")
palabras_in_crucigrama = ""
x_palabra = cx.strip("*")
if x_palabra in mtrix_palabras:
acierto = True
else:
acierto = False
if (acierto):
result = {
"palabra": req["palabra"],
"coordenadas": req["coordenadas"],
"acierto": True
}
else:
result = {
"palabra": req["palabra"],
"coordenadas": req["coordenadas"],
"acierto": False
}
res = make_response(jsonify({"message": "OK"}), 200)
return result
def perfil():
Sql = "ddasddf"
url = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
Nick = "Redoxfox"
TSWusers = dict()
TSWusers = {
'TABLE': 'users',
'Col1': 'nick',
'Col2': 'password',
'Col3': 'salt',
'Whe4': 'nick=%s'
}
Data = (Nick, )
DatosUsers = connect.SW_TABLE(username, TSWusers, Data)
return render_template("/home/perfil.html", url=url, lista=DatosUsers)
def images():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
wid = "0"
Tabla_All_Images = dict()
Tabla_All_Images = {
'TABLE': 'products ORDER BY name',
'Col1': 'id_product',
'Col2': 'name',
'Col3': 'media',
'Col4': 'precio',
'Whe5': 'id_product>%s'
}
Data = (wid, )
# SW_TABLE(username,TablaServicioAutomotor, Data)
DatosAllImages = connect.SW_TABLE(username, Tabla_All_Images, Data)
DatosAllImages_json = json.dumps(DatosAllImages)
return (DatosAllImages_json)
def reg_prestado(id):
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect=Model(username)
wid = id
TSSServicioPtado = dict()
TSSServicioPtado = {'TABLE':'servicio',
'Col1':'id',
'Col2':'tipo',
'Col3':'costo',
'Whe4':'id=%s'
}
Data = (wid,)
DatosServicioPtado = connect.SW_TABLE(username,TSSServicioPtado, Data)
TSSClient = dict()
TSSClient = {'TABLE':'clientes',
'Col1':'id',
'Col2':'nombre'
}
DatosClient = connect.SSP_TABLE(username,TSSClient)
return render_template("/lavasplash/form_registro_servicio.html", url = urlrev, servicios = DatosServicioPtado,
clientes=DatosClient)
def validar():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
if request.method == "POST":
nick = request.form["username"]
password = request.form["password"]
wid = nick
TSWusers = dict()
TSWusers = {'TABLE': 'users',
'Col1': 'nick',
'Col2': 'password',
'Col3': 'salt',
'Col4': 'tipo_user',
'Whe5': 'nick=%s'
}
Data = (wid,)
DatosUsers = connect.SW_TABLE(username, TSWusers, Data)
if DatosUsers:
password_userbd = DatosUsers[0]['password']
salt_userbd = DatosUsers[0]['salt']
tipo_user = DatosUsers[0]['tipo_user']
hash= validaciones.Validar()
h2=hash.check_password(password_userbd, password, salt_userbd)
if h2 == True and tipo_user=="admin":
#return render_template("/admin/principal.html")
return redirect(url_for('admin'))
else:
return render_template("/registro/login.html")
else:
return render_template("/registro/login.html")
''' password_userbd = DatosUsers[0]['password']
def media(id):
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
wid = id
TablaMedia = dict()
TablaMedia = {
'TABLE': 'media',
'Col1': 'id',
'Col2': 'id_product',
'Col3': 'img',
'Col4': 'video',
'Col5': 'tipo',
'Whe6': 'id_product=%s'
}
Data = (wid, )
DatosMedia = connect.SW_TABLE(username, TablaMedia, Data)
DatosAllMedia = json.dumps(DatosMedia)
#print(DatosMedia)
return (DatosAllMedia)
def sopa_letters():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
#urlrev = URLBASE
if request.method == "POST":
id_topic = request.form['topic']
else:
id_topic = "1"
print(id_topic)
num_palabras = 0
TSSTopico = {'TABLE': 'grupo', 'Col1': 'id', 'Col2': 'topico'}
DatosTopico = connect.SSP_TABLE(username, TSSTopico)
wid = id_topic
TSSVocabulary = {
'TABLE': 'vocabulary',
'Col1': 'id',
'Col2': 'english',
'Col3': 'spanish',
'Col4': 'grupo',
'Col5': 'ejemplos',
'Whe6': 'grupo=%s'
}
Data = (wid, )
PalabrasCrucigrama = connect.SW_TABLE(username, TSSVocabulary, Data)
list_palabras = []
list_id = []
Palabras_in_Crucigrama = []
for items in PalabrasCrucigrama:
list_id.append(items["id"])
acierto = 0
num_palabras = 0
while num_palabras < 15:
value_palabra = randint(0, len(list_id) - 1)
palabra_select = PalabrasCrucigrama[value_palabra]["english"]
palabra_select = re.sub(r"\s+", "", palabra_select, flags=re.UNICODE)
num_letras = len(palabra_select)
nueva_palabra = {}
if acierto == 0 and num_letras > 10 and num_letras < 13:
if palabra_select not in list_palabras:
list_palabras.append(palabra_select)
nueva_palabra["spanish"] = PalabrasCrucigrama[value_palabra][
"spanish"]
nueva_palabra["english"] = palabra_select
Palabras_in_Crucigrama.append(nueva_palabra)
num_palabras += 1
acierto = 1
else:
if palabra_select not in list_palabras:
list_palabras.append(palabra_select)
nueva_palabra["spanish"] = PalabrasCrucigrama[value_palabra][
"spanish"]
nueva_palabra["english"] = palabra_select
Palabras_in_Crucigrama.append(nueva_palabra)
num_palabras += 1
resultados_crucigrama = sopa_letras.llenar_palabra()
result_crucigrama = resultados_crucigrama.generar_crucigrama(list_palabras)
data = result_crucigrama[0]
palabras = result_crucigrama[1]
nombre_id = "id"
nombre_tabla = "crucigrama"
id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id)
proximo_id = id_max[0]["max_id"] + 1
id = str(proximo_id)
grupo = "1"
Insert_ofCrucigrama = dict()
Insert_ofCrucigrama = {
'TABLE': 'crucigrama',
'Col1': 'id',
'Col2': 'grupo',
'Col3': 'palabras',
'Val4': '%s',
'Val5': '%s',
'Val6': '%s',
}
Data = [id, grupo, palabras]
res_insert = connect.IT_TABLE(username, Insert_ofCrucigrama, Data)
return render_template("/blog/sopa.html",
url=Urlbase,
data=data,
palabras_crucigrama=Palabras_in_Crucigrama,
id_crucigrama=proximo_id,
DatosTopico=DatosTopico)
def add_NewVerb():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
id = None
if request.method == "POST":
english_form = request.form["english"]
spanish_form = request.form["spanish"]
past_form = request.form["past"]
pronunciation = request.form["pronunc"]
tipo = request.form["tipo"]
present = request.form["present"]
future = request.form["future"]
english = english_form.upper()
spanish = spanish_form.upper()
past = past_form.upper()
wid = english
TSWVocabulary = dict()
TSWVocabulary = {'TABLE': 'verbs',
'Col1': 'english',
'Whe2': 'english=%s'
}
Data = (wid,)
DatosVocabulary = connect.SW_TABLE(username, TSWVocabulary, Data)
if DatosVocabulary:
result["new_topico"] = "Ya se encuentra registrado " + english + " en BD"
else:
Insert_ofvocabulary = dict()
Insert_ofvocabulary = {'TABLE':'verbs',
'Col1':'id',
'Col2':'english',
'Col3':'spanish',
'Col4':'present',
'Col5':'pass',
'Col6':'future',
'Col7':'pronunciation',
'Col8':'tipo',
'Val9':'%s',
'Val10':'%s',
'Val11':'%s',
'Val12':'%s',
'Val13':'%s',
'Val14':'%s',
'Val15':'%s',
'Val16':'%s'
}
Data = [id, english, spanish, present, past, future, pronunciation, tipo]
result["new_topico"] = "Registro exitoso"
res_insert = connect.IT_TABLE(username, Insert_ofvocabulary, Data)
TSSVerbs = dict()
TSSVerbs = {'TABLE':'verbs',
'Col1':'id',
'Col2':'english',
'Col3':'spanish',
'Col4':'pronunciation',
'Col5':'pass'
}
DatosVerbs = connect.SSP_TABLE(username,TSSVerbs)
return render_template("/admin/addNewVerb.html", url = Urlbase, verbs = DatosVerbs)
def add_NewWord():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
id = None
if request.method == "POST":
english_form = request.form["english"].upper()
spanish_form = request.form["spanish"].upper()
grupo = request.form["grupo"]
ejemplos = request.form["ejemplos"]
pronunc = request.form["pronunc"]
english = english_form.upper()
spanish = spanish_form.upper()
wid = english
TSWVocabulary = dict()
TSWVocabulary = {'TABLE': 'vocabulary',
'Col1': 'english',
'Whe2': 'english=%s'
}
Data = (wid,)
DatosVocabulary = connect.SW_TABLE(username, TSWVocabulary, Data)
Tabla_All_Grupos = dict()
Tabla_All_Grupos = {'TABLE':'grupo',
'Col1':'id',
'Col2':'topico'
}
DatosAllGrupos = connect.SSP_TABLE(username, Tabla_All_Grupos)
if DatosVocabulary:
result["message"] = "Ya se encuentra registrado " + english + " en BD"
else:
Insert_ofvocabulary = dict()
Insert_ofvocabulary = {'TABLE':'vocabulary',
'Col1':'id',
'Col2':'english',
'Col3':'spanish',
'Col4':'grupo',
'Col5':'ejemplos',
'Col6':'pronunc',
'Val7':'%s',
'Val8':'%s',
'Val9':'%s',
'Val10':'%s',
'Val11':'%s',
'Val12':'%s'
}
Data = [id, english, spanish, grupo, ejemplos, pronunc]
result["message"] = "Registro exitoso"
res_insert = connect.IT_TABLE(username, Insert_ofvocabulary, Data)
Tabla_All_Words = dict()
Tabla_All_Words = {'TABLE':'vocabulary',
'Col1':'id',
'Col2':'english',
'Col3':'spanish',
'Col4':'pronunc'
}
DatosAllWords = connect.SSP_TABLE(username, Tabla_All_Words)
return render_template("/admin/addNewWord.html", url = Urlbase, grupos = DatosAllGrupos, words = DatosAllWords , result=result)
