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()
