def conectar_BD(self,self_ventana_principal): nombres_bd = ["lana","merceria","regaleria","santeria","bijouterie","jugueteria"] liststore = [self.liststore_lana,self.liststore_merceria,self.liststore_regaleria,self.liststore_santeria,self.liststore_bijouterie,self.liststore_jugueteria] self.bbdd=bdapi.connect( leer_ruta() ) for i,nombre in enumerate(nombres_bd): if nombre == "lana" or nombre == "merceria": liststore[i].clear() self.cursor=self.bbdd.cursor() self.cursor.execute("SELECT * FROM "+nombre) for tupla in self.cursor.fetchall(): if tupla[9]: liststore[i].append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,float(tupla[8]),"Si",True]) else: liststore[i].append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,float(tupla[8]),"No",False]) else: liststore[i].clear() self.cursor=self.bbdd.cursor() self.cursor.execute("SELECT * FROM "+nombre) for tupla in self.cursor.fetchall(): if tupla[9]: liststore[i].append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),int(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"Si",True]) else: liststore[i].append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),int(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"No",False]) self.bbdd.commit() self.cursor.execute("SELECT * FROM ropa") for tupla in self.cursor.fetchall(): if tupla[10]: self.liststore_ropa.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),int(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),int(tupla[9]),"Si",True]) else: self.liststore_ropa.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),int(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),int(tupla[9]),"No",False]) self.bbdd.commit() self.cursor.close() self.bbdd.close() self.bbdd.close()
def eliminar(self, widget, self_seccion_stock, self_ventana_principal): bbdd = bdapi.connect(leer_ruta()) cursor = bbdd.cursor() if self_seccion_stock.tipo_producto == "merceria": self_seccion_stock.total_liststore_productos[0].remove( self.fila_seleccionada) cursor.execute("DELETE FROM merceria WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "lana": self_seccion_stock.total_liststore_productos[1].remove( self.fila_seleccionada) cursor.execute("DELETE FROM lana WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "ropa": self_seccion_stock.total_liststore_productos[2].remove( self.fila_seleccionada) cursor.execute("DELETE FROM ropa WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "regaleria": self_seccion_stock.total_liststore_productos[3].remove( self.fila_seleccionada) cursor.execute("DELETE FROM regaleria WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "santeria": self_seccion_stock.total_liststore_productos[5].remove( self.fila_seleccionada) cursor.execute("DELETE FROM santeria WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "jugueteria": self_seccion_stock.total_liststore_productos[4].remove( self.fila_seleccionada) cursor.execute("DELETE FROM jugueteria WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "bijouterie": self_seccion_stock.total_liststore_productos[6].remove( self.fila_seleccionada) cursor.execute("DELETE FROM bijouterie WHERE codigo = ?", self.codigo) bbdd.commit() cursor.close() bbdd.close() self.window.destroy() self_ventana_principal.window.set_sensitive(True)
def aceptar_datos(self, widget, self_seccion_stock, self_ventana_principal): b = len(self_seccion_stock.datos_seleccionados_productos) iter = self_seccion_stock.datos_seleccionados_productos[b - 1] bbdd = bdapi.connect(leer_ruta()) cursor = bbdd.cursor() if self_seccion_stock.tipo_producto != "ropa": valores_update = [] for x in range(4): valores_update.append(self.entry_generales[x + 1].get_text()) #valores_update.append(self.pin_generales.get_text() ) valores_update.append(self.codigo_anterior) self.liststore_elejido.set_value( iter, 2, self.entry_generales[1].get_text()) #codigo self.liststore_elejido.set_value( iter, 3, self.entry_generales[2].get_text()) #descripcion self.liststore_elejido.set_value( iter, 4, float(self.entry_generales[3].get_text())) #costo self.liststore_elejido.set_value( iter, 5, float(self.entry_generales[4].get_text())) #precio #self.liststore_elejido.set_value(iter,6,int(self.pin_generales.get_text() ))#ganancia nombre_bd = self_seccion_stock.tipo_producto.lower() #wtf!! cursor.execute( "UPDATE " + str(nombre_bd) + " SET codigo=? , descripcion=?, costo=?, precio=? WHERE codigo = ?", valores_update) else: valores_update = [] for x in range(4): valores_update.append(self.entry_ropa[x + 1].get_text()) #valores_update.append(1) #valores_update.append( self.pin_ropa.get_text() ) valores_update.append(self.codigo_anterior) self_seccion_stock.liststore_ropa.set_value( iter, 2, self.entry_ropa[1].get_text()) self_seccion_stock.liststore_ropa.set_value( iter, 3, self.entry_ropa[2].get_text()) #self_seccion_stock.liststore_ropa.set_value(iter,4,int(self.pin_talle.get_text())) self_seccion_stock.liststore_ropa.set_value( iter, 5, float(self.entry_ropa[3].get_text())) self_seccion_stock.liststore_ropa.set_value( iter, 6, float(self.entry_ropa[4].get_text())) #self_seccion_stock.liststore_ropa.set_value(iter,7,int(self.pin_ropa.get_text()) ) cursor.execute( "UPDATE ropa SET codigo=? , descripcion=?, costo=?, precio=? WHERE codigo = ?", valores_update) bbdd.commit() cursor.close() bbdd.close() self.window.destroy() self_ventana_principal.window.set_sensitive(True)
def eliminar(self,widget,self_seccion_stock,self_ventana_principal): bbdd=bdapi.connect(leer_ruta() ) cursor=bbdd.cursor() if self_seccion_stock.tipo_producto == "merceria": self_seccion_stock.total_liststore_productos[0].remove(self.fila_seleccionada) cursor.execute("DELETE FROM merceria WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "lana": self_seccion_stock.total_liststore_productos[1].remove(self.fila_seleccionada) cursor.execute("DELETE FROM lana WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "ropa": self_seccion_stock.total_liststore_productos[2].remove(self.fila_seleccionada) cursor.execute("DELETE FROM ropa WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "regaleria": self_seccion_stock.total_liststore_productos[3].remove(self.fila_seleccionada) cursor.execute("DELETE FROM regaleria WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "santeria": self_seccion_stock.total_liststore_productos[5].remove(self.fila_seleccionada) cursor.execute("DELETE FROM santeria WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "jugueteria": self_seccion_stock.total_liststore_productos[4].remove(self.fila_seleccionada) cursor.execute("DELETE FROM jugueteria WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() elif self_seccion_stock.tipo_producto == "bijouterie": self_seccion_stock.total_liststore_productos[6].remove(self.fila_seleccionada) cursor.execute("DELETE FROM bijouterie WHERE codigo = ?",self.codigo) bbdd.commit() cursor.close() bbdd.close() self.window.destroy() self_ventana_principal.window.set_sensitive(True)
def buscar(self, cod): datos = [] self.cursor2 = None self.bbdd = bdapi.connect(leer_ruta()) self.cursor = self.bbdd.cursor() if cod[0][0] in self.codigos_repetidos: self.cursor2 = self.bbdd.cursor() cod[0] = cod[0].upper() if cod[0][0].upper() == "M": self.cursor.execute(" SELECT * FROM merceria WHERE codigo = ?", cod) elif cod[0][0].upper() == "L": bandera = True self.cursor.execute(" SELECT * FROM lana WHERE codigo = ?", cod) self.cursor2.execute(" SELECT * FROM ropa WHERE codigo = ?", cod) elif cod[0][0].upper() == "R": bandera = True self.cursor.execute(" SELECT * FROM regaleria WHERE codigo = ? ", cod) self.cursor2.execute(" SELECT * FROM ropa WHERE codigo = ?", cod) elif cod[0][0].upper() == "J": self.cursor.execute(" SELECT * FROM jugueteria WHERE codigo = ? ", cod) elif cod[0][0].upper() == "S": self.cursor.execute(" SELECT * FROM santeria WHERE codigo = ?", cod) elif cod[0][0].upper() == "B": self.cursor.execute(" SELECT * FROM bijouterie WHERE codigo = ?", cod) self.bbdd.commit() if self.cursor2 != None: tupla = self.cursor2.fetchone() self.cursor2.close() if tupla == None: tupla = self.cursor.fetchone() self.cursor.close() else: tupla = self.cursor.fetchone() self.cursor.close() self.bbdd.close() if tupla != None: for x in tupla: datos.append(x) return datos else: return False
def buscar(self,cod): datos = [] self.cursor2 = None self.bbdd=bdapi.connect(leer_ruta()) self.cursor=self.bbdd.cursor() if cod[0][0] in self.codigos_repetidos: self.cursor2=self.bbdd.cursor() cod[0]=cod[0].upper() if cod[0][0].upper() == "M": self.cursor.execute(" SELECT * FROM merceria WHERE codigo = ?",cod) elif cod[0][0].upper() == "L": bandera = True self.cursor.execute(" SELECT * FROM lana WHERE codigo = ?",cod) self.cursor2.execute(" SELECT * FROM ropa WHERE codigo = ?",cod) elif cod[0][0].upper() == "R": bandera = True self.cursor.execute(" SELECT * FROM regaleria WHERE codigo = ? ",cod) self.cursor2.execute(" SELECT * FROM ropa WHERE codigo = ?",cod) elif cod[0][0].upper() == "J": self.cursor.execute(" SELECT * FROM jugueteria WHERE codigo = ? ",cod) elif cod[0][0].upper() == "S": self.cursor.execute(" SELECT * FROM santeria WHERE codigo = ?",cod) elif cod[0][0].upper() == "B": self.cursor.execute(" SELECT * FROM bijouterie WHERE codigo = ?",cod) self.bbdd.commit() if self.cursor2 != None: tupla = self.cursor2.fetchone() self.cursor2.close() if tupla == None: tupla = self.cursor.fetchone() self.cursor.close() else: tupla = self.cursor.fetchone() self.cursor.close() self.bbdd.close() if tupla != None: for x in tupla: datos.append(x) return datos else: return False
def aceptar_datos(self,widget,self_seccion_stock,self_ventana_principal): b=len(self_seccion_stock.datos_seleccionados_productos) iter=self_seccion_stock.datos_seleccionados_productos[b-1] bbdd=bdapi.connect(leer_ruta() ) cursor=bbdd.cursor() if self_seccion_stock.tipo_producto !="ropa": valores_update=[] for x in range(4): valores_update.append( self.entry_generales[x+1].get_text() ) #valores_update.append(self.pin_generales.get_text() ) valores_update.append( self.codigo_anterior ) self.liststore_elejido.set_value(iter,2,self.entry_generales[1].get_text())#codigo self.liststore_elejido.set_value(iter,3,self.entry_generales[2].get_text())#descripcion self.liststore_elejido.set_value(iter,4,float(self.entry_generales[3].get_text() ))#costo self.liststore_elejido.set_value(iter,5,float(self.entry_generales[4].get_text() ))#precio #self.liststore_elejido.set_value(iter,6,int(self.pin_generales.get_text() ))#ganancia nombre_bd=self_seccion_stock.tipo_producto.lower()#wtf!! cursor.execute("UPDATE "+str(nombre_bd)+" SET codigo=? , descripcion=?, costo=?, precio=? WHERE codigo = ?",valores_update) else: valores_update=[] for x in range(4): valores_update.append( self.entry_ropa[x+1].get_text() ) #valores_update.append(1) #valores_update.append( self.pin_ropa.get_text() ) valores_update.append( self.codigo_anterior ) self_seccion_stock.liststore_ropa.set_value(iter,2,self.entry_ropa[1].get_text()) self_seccion_stock.liststore_ropa.set_value(iter,3,self.entry_ropa[2].get_text()) #self_seccion_stock.liststore_ropa.set_value(iter,4,int(self.pin_talle.get_text())) self_seccion_stock.liststore_ropa.set_value(iter,5,float(self.entry_ropa[3].get_text() )) self_seccion_stock.liststore_ropa.set_value(iter,6,float(self.entry_ropa[4].get_text())) #self_seccion_stock.liststore_ropa.set_value(iter,7,int(self.pin_ropa.get_text()) ) cursor.execute("UPDATE ropa SET codigo=? , descripcion=?, costo=?, precio=? WHERE codigo = ?",valores_update) bbdd.commit() cursor.close() bbdd.close() self.window.destroy() self_ventana_principal.window.set_sensitive(True)
def cargar(self, widget, self_seccion_stock): self.bbdd = bdapi.connect(leer_ruta()) self.cursor = self.bbdd.cursor() cod = self.codigo if cod[0][0] in self.codigos_repetidos: self.cursor2 = self.bbdd.cursor() cod[0] = cod[0].upper() if cod[0][0] == "M" or cod[0][0:2] == "LA" or cod[0][0] == "J" or cod[ 0][0] == "S" or cod[0][0:2] == "RE" or cod[0][0] == "B": cantidad = self.datos[7] - float(self.entry_cantidad.get_text()) if cantidad <= self.datos[8]: values = (cantidad, True, cod[0]) else: values = (cantidad, False, cod[0]) else: cantidad = self.datos[8] - int(self.entry_cantidad.get_text()) if cantidad <= self.datos[9]: values = (cantidad, True, cod[0]) else: values = (cantidad, False, cod[0]) if cod[0][0] == "M": self.cursor.execute( " UPDATE merceria SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) for x in range(len(self_seccion_stock.liststore_merceria)): if self_seccion_stock.liststore_merceria[x][2] == self.datos[ 1]: self_seccion_stock.liststore_merceria[x][8] = values[0] self_seccion_stock.liststore_merceria[x][11] = values[1] elif cod[0][0] == "L": self.cursor.execute( " UPDATE lana SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) self.cursor2.execute( " UPDATE ropa SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) if cod[0][0:2] == "LA": for x in range(len(self_seccion_stock.liststore_lana)): if self_seccion_stock.liststore_lana[x][2] == self.datos[ 1]: self_seccion_stock.liststore_lana[x][8] = values[0] self_seccion_stock.liststore_lana[x][11] = values[1] else: for x in range(len(self_seccion_stock.liststore_ropa)): if self_seccion_stock.liststore_ropa[x][2] == self.datos[ 1]: self_seccion_stock.liststore_ropa[x][9] = values[0] self_seccion_stock.liststore_ropa[x][12] = values[1] elif cod[0][0] == "R": self.cursor.execute( " UPDATE regaleria SET stk_disp = ?, aviso = ? WHERE codigo = ? ", values) self.cursor2.execute( " UPDATE ropa SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) if cod[0][0:2] == "RE": for x in range(len(self_seccion_stock.liststore_regaleria)): if self_seccion_stock.liststore_regaleria[x][ 2] == self.datos[1]: self_seccion_stock.liststore_regaleria[x][8] = values[ 0] self_seccion_stock.liststore_regaleria[x][11] = values[ 1] else: for x in range(len(self_seccion_stock.liststore_ropa)): if self_seccion_stock.liststore_ropa[x][2] == self.datos[ 1]: self_seccion_stock.liststore_ropa[x][9] = values[0] self_seccion_stock.liststore_ropa[x][12] = values[1] elif cod[0][0] == "J": self.cursor.execute( " UPDATE jugueteria SET stk_disp = ?, aviso = ? WHERE codigo = ? ", values) for x in range(len(self_seccion_stock.liststore_jugueteria)): if self_seccion_stock.liststore_jugueteria[x][2] == self.datos[ 1]: self_seccion_stock.liststore_jugueteria[x][8] = values[0] self_seccion_stock.liststore_jugueteria[x][11] = values[1] elif cod[0][0] == "S": self.cursor.execute( " UPDATE santeria SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) for x in range(len(self_seccion_stock.liststore_santeria)): if self_seccion_stock.liststore_santeria[x][2] == self.datos[ 1]: self_seccion_stock.liststore_santeria[x][8] = values[0] self_seccion_stock.liststore_santeria[x][11] = values[1] elif cod[0][0] == "B": self.cursor.execute( " UPDATE bijouterie SET stk_disp = ?, aviso = ? WHERE codigo = ?", values) for x in range(len(self_seccion_stock.liststore_bijouterie)): if self_seccion_stock.liststore_bijouterie[x][2] == self.datos[ 1]: self_seccion_stock.liststore_bijouterie[x][8] = values[0] self_seccion_stock.liststore_bijouterie[x][11] = values[1] self.bbdd.commit() self.cursor.close() self.bbdd.close() self.entry.set_text("") self.entry_cantidad.set_text("") self.entry_descripcion.set_text("") self.entry.set_property("is focus", 1)
def mostrar(self, widget, data): cod = self.entry.get_text() self.liststore.clear() self.bbdd = bdapi.connect(leer_ruta()) self.cursor = self.bbdd.cursor() bandera = False if cod != "": if cod[0] in self.codigos_repetidos: self.cursor2 = self.bbdd.cursor() if cod[0] == "M" or cod[0] == "m": self.cursor.execute( " SELECT * FROM merceria WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "L" or cod[0] == "l": bandera = True self.cursor.execute( " SELECT * FROM lana WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco self.cursor2.execute( " SELECT * FROM ropa WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "R" or cod[0] == "r": bandera = True self.cursor.execute( " SELECT * FROM regaleria WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco self.cursor2.execute( " SELECT * FROM ropa WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "J" or cod[0] == "j": self.cursor.execute( " SELECT * FROM jugueteria WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "S" or cod[0] == "s": self.cursor.execute( " SELECT * FROM santeria WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "B" or cod[0] == "b": self.cursor.execute( " SELECT * FROM bijouterie WHERE codigo LIKE '" + cod + "%'") #imprime cuando el nombre sea = a lo qe busco if not bandera: if cod[0].upper() == "M": for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), int(tupla[8]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), int(tupla[8]), "No", False ]) self.bbdd.commit() self.cursor.close() else: for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "No", False ]) self.bbdd.commit() self.cursor.close() else: if cod[0].upper() == "L": for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), int(tupla[8]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), int(tupla[8]), "No", False ]) self.bbdd.commit() self.cursor.close() for tupla in self.cursor2.fetchall(): if tupla[10]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[4]), float(tupla[5]), float(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[4]), float(tupla[5]), float(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "No", False ]) else: for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "No", False ]) self.bbdd.commit() for tupla in self.cursor2.fetchall(): if tupla[10]: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[4]), float(tupla[5]), float(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "Si", True ]) else: self.liststore.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[4]), float(tupla[5]), float(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "No", False ]) self.bbdd.commit() self.cursor.close() self.cursor2.close() self.bbdd.close()
def actualizar(self, widget, self_seccion_stock, self_ventana_principal): bbdd = bdapi.connect(leer_ruta()) cursor = bbdd.cursor() nombre_bd = self_seccion_stock.tipo_producto.lower() if self_seccion_stock.tipo_producto != "ropa": self.liststore_elejido.set_value( self.fila_seleccionada, 6, self.pin_generales[0].get_value()) #ganancia self.liststore_elejido.set_value( self.fila_seleccionada, 7, self.pin_generales[1].get_value()) #stk inical self.liststore_elejido.set_value( self.fila_seleccionada, 8, self.pin_generales[2].get_value()) #stk disponible self.liststore_elejido.set_value( self.fila_seleccionada, 9, self.pin_generales[3].get_value()) #pnt rep self.liststore_elejido.set_value( self.fila_seleccionada, 10, self.calcular_reponer( self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) #reponer self.liststore_elejido.set_value( self.fila_seleccionada, 11, self.calcular_pintar( self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) #pintar valores_update = [] for x in range(4): valores_update.append(self.pin_generales[x].get_value()) valores_update.append( self.calcular_pintar(self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) valores_update.append( self_seccion_stock.datos_seleccionados_productos[2]) else: self.liststore_elejido.set_value( self.fila_seleccionada, 7, self.pin_generales[0].get_value()) #ganancia self.liststore_elejido.set_value( self.fila_seleccionada, 8, self.pin_generales[1].get_value()) #stock inicial self.liststore_elejido.set_value( self.fila_seleccionada, 9, self.pin_generales[2].get_value()) #stock disponible self.liststore_elejido.set_value( self.fila_seleccionada, 10, self.pin_generales[3].get_value()) #punto reposicion self.liststore_elejido.set_value( self.fila_seleccionada, 11, self.calcular_reponer( self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) #reponer self.liststore_elejido.set_value( self.fila_seleccionada, 12, self.calcular_pintar( self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) #pintar valores_update = [] for x in range(4): valores_update.append(self.pin_generales[x].get_value()) valores_update.append( self.calcular_pintar(self.pin_generales[2].get_value(), self.pin_generales[3].get_value())) valores_update.append( self_seccion_stock.datos_seleccionados_productos[2]) cursor.execute( "UPDATE " + str(nombre_bd) + " SET ganancia=? , stk_ini=?, stk_disp=?, pnt_rep=? ,aviso=? WHERE codigo = ?", valores_update) bbdd.commit() cursor.close() bbdd.close() self.window.destroy() self_ventana_principal.window.set_sensitive(True)
def mostrar(self,widget,data): cod = self.entry.get_text() self.liststore.clear() self.bbdd=bdapi.connect(leer_ruta()) self.cursor=self.bbdd.cursor() bandera = False if cod != "": if cod[0] in self.codigos_repetidos: self.cursor2=self.bbdd.cursor() if cod[0] == "M" or cod[0] == "m": self.cursor.execute(" SELECT * FROM merceria WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "L" or cod[0] =="l": bandera = True self.cursor.execute(" SELECT * FROM lana WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco self.cursor2.execute(" SELECT * FROM ropa WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "R" or cod[0] =="r": bandera = True self.cursor.execute(" SELECT * FROM regaleria WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco self.cursor2.execute(" SELECT * FROM ropa WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "J" or cod[0] =="j": self.cursor.execute(" SELECT * FROM jugueteria WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "S" or cod[0] =="s": self.cursor.execute(" SELECT * FROM santeria WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco elif cod[0] == "B" or cod[0] =="b": self.cursor.execute(" SELECT * FROM bijouterie WHERE codigo LIKE '"+cod+"%'") #imprime cuando el nombre sea = a lo qe busco if not bandera: if cod[0].upper() == "M": for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,int(tupla[8]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,int(tupla[8]),"No",False]) self.bbdd.commit() self.cursor.close() else: for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"No",False]) self.bbdd.commit() self.cursor.close() else: if cod[0].upper() == "L": for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,int(tupla[8]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),float(tupla[6]),float(tupla[7]) ,int(tupla[8]),"No",False]) self.bbdd.commit() self.cursor.close() for tupla in self.cursor2.fetchall(): if tupla[10]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[4]),float(tupla[5]),float(tupla[6]),int(tupla[7]),int(tupla[8]) ,int(tupla[9]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[4]),float(tupla[5]),float(tupla[6]),int(tupla[7]),int(tupla[8]) ,int(tupla[9]),"No",False]) else: for tupla in self.cursor.fetchall(): if tupla[9]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[3]),float(tupla[4]),float(tupla[5]),int(tupla[6]),int(tupla[7]) ,int(tupla[8]),"No",False]) self.bbdd.commit() for tupla in self.cursor2.fetchall(): if tupla[10]: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[4]),float(tupla[5]),float(tupla[6]),int(tupla[7]),int(tupla[8]) ,int(tupla[9]),"Si",True]) else: self.liststore.append(["", int(tupla[0]),tupla[1],tupla[2],float(tupla[4]),float(tupla[5]),float(tupla[6]),int(tupla[7]),int(tupla[8]) ,int(tupla[9]),"No",False]) self.bbdd.commit() self.cursor.close() self.cursor2.close() self.bbdd.close()
def cargar(self,widget,self_seccion_stock): self.bbdd=bdapi.connect(leer_ruta()) self.cursor=self.bbdd.cursor() cod = self.codigo if cod[0][0] in self.codigos_repetidos: self.cursor2=self.bbdd.cursor() cod[0]=cod[0].upper() if cod[0][0]=="M"or cod[0][0:2] == "LA" or cod[0][0] == "J"or cod[0][0] == "S" or cod[0][0:2] == "RE" or cod[0][0] == "B": cantidad = self.datos[7]-float(self.entry_cantidad.get_text()) if cantidad<=self.datos[8]: values = (cantidad,True,cod[0]) else: values = (cantidad,False,cod[0]) else: cantidad = self.datos[8]-int(self.entry_cantidad.get_text()) if cantidad<=self.datos[9]: values = (cantidad,True,cod[0]) else: values = (cantidad,False,cod[0]) if cod[0][0] == "M": self.cursor.execute(" UPDATE merceria SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) for x in range(len(self_seccion_stock.liststore_merceria)): if self_seccion_stock.liststore_merceria[x][2] == self.datos[1]: self_seccion_stock.liststore_merceria[x][8] = values[0] self_seccion_stock.liststore_merceria[x][11]= values[1] elif cod[0][0] == "L": self.cursor.execute(" UPDATE lana SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) self.cursor2.execute(" UPDATE ropa SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) if cod[0][0:2]=="LA": for x in range(len(self_seccion_stock.liststore_lana)): if self_seccion_stock.liststore_lana[x][2] == self.datos[1]: self_seccion_stock.liststore_lana[x][8] = values[0] self_seccion_stock.liststore_lana[x][11]= values[1] else: for x in range(len(self_seccion_stock.liststore_ropa)): if self_seccion_stock.liststore_ropa[x][2] == self.datos[1]: self_seccion_stock.liststore_ropa[x][9] = values[0] self_seccion_stock.liststore_ropa[x][12]= values[1] elif cod[0][0] == "R": self.cursor.execute(" UPDATE regaleria SET stk_disp = ?, aviso = ? WHERE codigo = ? ",values) self.cursor2.execute(" UPDATE ropa SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) if cod[0][0:2] == "RE": for x in range(len(self_seccion_stock.liststore_regaleria)): if self_seccion_stock.liststore_regaleria[x][2] == self.datos[1]: self_seccion_stock.liststore_regaleria[x][8] = values[0] self_seccion_stock.liststore_regaleria[x][11]= values[1] else: for x in range(len(self_seccion_stock.liststore_ropa)): if self_seccion_stock.liststore_ropa[x][2] == self.datos[1]: self_seccion_stock.liststore_ropa[x][9] = values[0] self_seccion_stock.liststore_ropa[x][12]= values[1] elif cod[0][0] == "J": self.cursor.execute(" UPDATE jugueteria SET stk_disp = ?, aviso = ? WHERE codigo = ? ",values) for x in range(len(self_seccion_stock.liststore_jugueteria)): if self_seccion_stock.liststore_jugueteria[x][2] == self.datos[1]: self_seccion_stock.liststore_jugueteria[x][8] = values[0] self_seccion_stock.liststore_jugueteria[x][11]= values[1] elif cod[0][0] == "S": self.cursor.execute(" UPDATE santeria SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) for x in range(len(self_seccion_stock.liststore_santeria)): if self_seccion_stock.liststore_santeria[x][2] == self.datos[1]: self_seccion_stock.liststore_santeria[x][8] = values[0] self_seccion_stock.liststore_santeria[x][11]= values[1] elif cod[0][0] == "B": self.cursor.execute(" UPDATE bijouterie SET stk_disp = ?, aviso = ? WHERE codigo = ?",values) for x in range(len(self_seccion_stock.liststore_bijouterie)): if self_seccion_stock.liststore_bijouterie[x][2] == self.datos[1]: self_seccion_stock.liststore_bijouterie[x][8] = values[0] self_seccion_stock.liststore_bijouterie[x][11]= values[1] self.bbdd.commit() self.cursor.close() self.bbdd.close() self.entry.set_text("") self.entry_cantidad.set_text("") self.entry_descripcion.set_text("") self.entry.set_property("is focus",1)
def conectar_BD(self, self_ventana_principal): nombres_bd = [ "lana", "merceria", "regaleria", "santeria", "bijouterie", "jugueteria" ] liststore = [ self.liststore_lana, self.liststore_merceria, self.liststore_regaleria, self.liststore_santeria, self.liststore_bijouterie, self.liststore_jugueteria ] self.bbdd = bdapi.connect(leer_ruta()) for i, nombre in enumerate(nombres_bd): if nombre == "lana" or nombre == "merceria": liststore[i].clear() self.cursor = self.bbdd.cursor() self.cursor.execute("SELECT * FROM " + nombre) for tupla in self.cursor.fetchall(): if tupla[9]: liststore[i].append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), float(tupla[8]), "Si", True ]) else: liststore[i].append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), float(tupla[5]), float(tupla[6]), float(tupla[7]), float(tupla[8]), "No", False ]) else: liststore[i].clear() self.cursor = self.bbdd.cursor() self.cursor.execute("SELECT * FROM " + nombre) for tupla in self.cursor.fetchall(): if tupla[9]: liststore[i].append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), int(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "Si", True ]) else: liststore[i].append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), int(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), "No", False ]) self.bbdd.commit() self.cursor.execute("SELECT * FROM ropa") for tupla in self.cursor.fetchall(): if tupla[10]: self.liststore_ropa.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), int(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "Si", True ]) else: self.liststore_ropa.append([ "", int(tupla[0]), tupla[1], tupla[2], float(tupla[3]), float(tupla[4]), int(tupla[5]), int(tupla[6]), int(tupla[7]), int(tupla[8]), int(tupla[9]), "No", False ]) self.bbdd.commit() self.cursor.close() self.bbdd.close() self.bbdd.close()