def AddCategoryBlg():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
name_category = req["name_category"]
#id = None
Insert_ofCategory = dict()
Insert_ofCategory = {
'TABLE': 'blg_category',
'Col1': 'id',
'Col2': 'name',
'Val3': '%s',
'Val4': '%s'
}
nombre_id = "id"
nombre_tabla = "blg_category"
id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id)
print(id_max[0]["max_id"])
if id_max[0]["max_id"] == None:
id_sig = "1"
else:
proximo_id = id_max[0]["max_id"] + 1
id_sig = str(proximo_id)
Data = [id_sig, name_category]
''' result["new_proveedor"] = name '''
res_insert = connect.IT_TABLE(username, Insert_ofCategory, Data)
result = {"hola": 2}
return result
def InsertNewServicioPtdo():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect=Model(username)
if request.method == "POST":
id = None
id_servicio = request.form['idservicio']
id_cliente = request.form['cliente']
costo = request.form['costo']
fecha = request.form['fecha']
costo_descuento = request.form['costo_descuento']
obs = request.form['obs']
porc_descuento = float(costo_descuento)/float(costo)
costo_total = float(costo) * porc_descuento
if costo_total == 0:
costo_total = float(costo)
else:
costo_total = costo_total
descuento = float(costo) - costo_total
Insert_ofservicioPtdo = dict()
Insert_ofservicioPtdo = {'TABLE':'servicios',
'Col1':'id',
'Col2':'id_servicio',
'Col3':'id_cliente',
'Col4':'descuento',
'Col5':'costo_total',
'Col6':'costo_desc',
'Col7':'fecha',
'Col8':'observacion',
'Val9':'%s',
'Val10':'%s',
'Val11':'%s',
'Val12':'%s',
'Val13':'%s',
'Val14':'%s',
'Val15':'%s',
'Val16':'%s'
}
Data = [id, id_servicio, id_cliente, porc_descuento, costo_total, descuento, fecha, obs]
res_insert = connect.IT_TABLE(username, Insert_ofservicioPtdo, Data)
TSSServicioPtado = dict()
TSSServicioPtado = {'TABLE':'servicio',
'Col1':'id',
'Col2':'tipo',
'Col3':'costo',
}
DatosServicioPtado = connect.SSP_TABLE(username,TSSServicioPtado)
return render_template("/lavasplash/home_ls.html", url = urlrev, servicios = DatosServicioPtado)
def AddUserBlg():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
print(connect)
req = request.get_json()
#result = {}
#wid = req["name_user"]
id = None
''' let name_user = evt.target.form[0].value
let lastname = evt.target.form[1].value
let username = evt.target.form[2].value
let email = evt.target.form[3].value
let password = evt.target.form[4].value
let image = evt.target.form[5].value
let created_at = evt.target.form[6].value '''
name_user = req["name_user"]
lastname = req["lastname"]
user_name = req["username"]
email = req["email"]
password = req["password"]
image = req["image"]
created_at = req["created_at"]
result = {}
Insert_ofblg_user = dict()
Insert_ofblg_user = {
'TABLE': 'blg_user',
'Col1': 'id',
'Col2': 'name',
'Col3': 'lastname',
'Col4': 'username',
'Col5': 'email',
'Col6': 'password',
'Col7': 'image',
'Col8': 'created_at',
'Val9': '%s',
'Val10': '%s',
'Val11': '%s',
'Val12': '%s',
'Val13': '%s',
'Val14': '%s',
'Val15': '%s',
'Val16': '%s'
}
Data = [
id, name_user, lastname, user_name, email, password, image, created_at
]
result["new_topico"] = "Registro exitoso"
res_insert = connect.IT_TABLE(username, Insert_ofblg_user, Data)
return result
def AddPostBlg():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
id_category = req["id_category"]
id_users = req["id_users"]
title_post = req["title_post"]
date_post = req["date_post"]
#id = None
Insert_ofPost = dict()
Insert_ofPost = {
'TABLE': 'post',
'Col1': 'id',
'Col2': 'title',
'Col3': 'image',
'Col4': 'created_at',
'Col5': 'status',
'Col6': 'user_id',
'Col7': 'category_id',
'Val8': '%s',
'Val9': '%s',
'Val10': '%s',
'Val11': '%s',
'Val12': '%s',
'Val13': '%s',
'Val14': '%s'
}
nombre_id = "id"
nombre_tabla = "post"
id_max = connect.MAX_ID_TABLE(username, nombre_tabla, nombre_id)
print(id_max[0]["max_id"])
if id_max[0]["max_id"] == None:
id_sig = "1"
else:
proximo_id = id_max[0]["max_id"] + 1
id_sig = str(proximo_id)
img_name = "post" + id_sig + "user" + id_users + "catg" + id_category + ".jpg"
status = "1"
Data = [
id_sig, title_post, img_name, date_post, status, id_users, id_category
]
res_insert = connect.IT_TABLE(username, Insert_ofPost, Data)
result = {"hola": 2}
return result
def singup():
urlrev = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
if request.method == "POST":
id = None
nick = request.form['nick']
nombre = request.form['name']
email = request.form['Email']
telefono = request.form['telefono']
direccion = request.form['direccion']
password = request.form['password']
tipo_user = '******'
Insert_users = dict()
Insert_users = {
'TABLE': 'users',
'Col1': 'id',
'Col2': 'nick',
'Col3': 'nombre',
'Col4': 'email',
'Col5': 'direccion',
'Col6': 'telefono',
'Col7': 'password',
'Col8': 'salt',
'Col9': 'tipo_user',
'Val10': '%s',
'Val11': '%s',
'Val12': '%s',
'Val13': '%s',
'Val14': '%s',
'Val15': '%s',
'Val16': '%s',
'Val17': '%s',
'Val18': '%s'
}
hash = validaciones.Validar()
pass_hash = []
pass_hash = hash.hash_password(password)
salt = pass_hash[0]
password_hash = pass_hash[1]
print(salt)
Data = [
id, nick, nombre, email, direccion, telefono, password_hash, salt,
tipo_user
]
connect.IT_TABLE(username, Insert_users, Data)
return render_template("/registro/login.html", url=urlrev)
def add_topico():
Urlbase = URLBASE
username = CONFIG['TYPE_USER']['ROOT']
connect = Model(username)
req = request.get_json()
result = {}
wid = req["topico"]
topico = wid
nombre_id = "id"
nombre_tabla = "grupo"
id = None
Insert_ofgrupo = dict()
Insert_ofgrupo = {'TABLE':'grupo',
'Col1':'id',
'Col2':'topico',
'Val3':'%s',
'Val4':'%s'
}
Data = [id, topico]
result["new_topico"] = wid
res_insert = connect.IT_TABLE(username, Insert_ofgrupo , Data)
return result
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)
