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)