def on_bAcepta_clicked(self, button, data=None):
for x in self.lista:
y = ['', '', '', '', '']
devengo = Nomina_Devengo(x[0])
locale.setlocale(locale.LC_ALL, 'en_US.UTF-8')
print "Precio y cuantia", devengo.cuantia, devengo.precio,
y[2] = locale.atof(x[2])
y[3] = locale.atof(x[3])
y[4] = locale.atof(x[4])
devengo.ac_campo('imp_cuantia', y[2])
devengo.ac_campo('imp_precio', y[3])
devengo.ac_campo('imp_devengo', y[4])
print devengo.precio, devengo.cuantia
calcular = CalcNomina(self.laempresa, self.mes, self.anio)
calcular.update_devengos(self.lanomina)
for x in self.vista.get_columns():
self.vista.remove_column(x)
self.lista.clear()
self.nomina()
return
def on_bAcepta_clicked(self, button, data=None):
for x in self.lista:
y = ['', '', '', '', '']
devengo = Nomina_Devengo(x[0])
locale.setlocale(locale.LC_ALL, 'en_US.UTF-8')
print "Precio y cuantia",devengo.cuantia, devengo.precio,
y[2] = locale.atof(x[2])
y[3] = locale.atof(x[3])
y[4] = locale.atof(x[4])
devengo.ac_campo('imp_cuantia',y[2])
devengo.ac_campo('imp_precio', y[3])
devengo.ac_campo('imp_devengo', y[4])
print devengo.precio, devengo.cuantia
calcular = CalcNomina(self.laempresa, self.mes, self.anio)
calcular.update_devengos(self.lanomina)
for x in self.vista.get_columns():
self.vista.remove_column(x)
self.lista.clear()
self.nomina()
return
def on_bRecalculo_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text())
self.calculo.recalcular()
def on_bCalcular_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(), self.esnomina,
self.esfiniquito, self.esnominapextra)
self.calculo.calcular()
class Nomina():
def __init__(self):
self.gladefile = "Ventanas/nomina.glade"
self.builder = Gtk.Builder()
self.builder.add_from_file(self.gladefile)
self.builder.connect_signals(self)
self.grabarfichero1 = self.builder.get_object("grabarfichero1")
self.window2 = self.builder.get_object("window2")
self.lTitulo = self.builder.get_object("lTitulo")
self.lTitulo.set_text("A darle fuerte")
self.bBuscar = self.builder.get_object("bBuscar")
self.bSalir = self.builder.get_object("bSalir")
self.bImprimir = self.builder.get_object("bImprimir")
self.cbnum = self.builder.get_object("num_emp")
self.num = valor_combobox(self.cbnum)
self.lista_empresas()
self.cbmes = self.builder.get_object("mes")
self.mes = valor_combobox(self.cbmes)
self.anio = self.builder.get_object("anio")
self.anio.set_text(str(datetime.datetime.today().year))
self.formnom = self.builder.get_object("formnom")
self.box9 = self.builder.get_object("box9")
self.tabla = Gtk.Table(1, 1)
self.box9.add(self.tabla)
self.rbnomina = self.builder.get_object('rbnomina')
self.rbfiniquito = self.builder.get_object('rbfiniquito')
self.rbnominapextra = self.builder.get_object('rbnominapextra')
self.on_rbnomina_toggled(self.rbnomina)
self.tabla.show()
self.box9.show()
self.window2.show()
def on_window2_destroy(self, objecto, data=None):
self.window2.destroy()
def on_bSalir_clicked(self, button, data=None):
self.window2.destroy()
def on_bImprimir_clicked(self, button, data=None):
# self.grabarfichero1.show()
self.canvas = canvas.Canvas("nomina.pdf", pagesize=A4)
impr_nomina(self.canvas, valor_combobox(self.cbnum),
valor_combobox(self.cbmes), int(self.anio.get_text()),
valor_combobox(self.formnom), 0)
# width, height = A4
self.canvas.save()
# self.anio.set_text("")
# self.dialImprimir = dialImprimir()
print os.name
os.system("/usr/bin/evince nomina.pdf")
def on_bCalcular_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(), self.esnomina,
self.esfiniquito, self.esnominapextra)
self.calculo.calcular()
# self.dialDato
def on_bRecalculo_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text())
self.calculo.recalcular()
def on_bBorrar_clicked(self, botton, data=None):
print botton
supr = NomBorrar(valor_combobox(self.cbnum),
valor_combobox(self.cbmes), int(self.anio.get_text()),
0, self.esnomina, self.esfiniquito,
self.esnominapextra)
supr.borrar_mes()
def lista_empresas(self):
listaempresas = Gtk.ListStore(long, str)
empresas = SqlEmpresa(0).listaempresas()
for k in empresas:
contenido = []
for l in k:
contenido.append(l)
listaempresas.append(contenido)
self.cbnum.set_model(listaempresas)
render1 = Gtk.CellRendererText()
self.cbnum.pack_start(render1, True)
self.cbnum.add_attribute(render1, 'int', 0)
render2 = Gtk.CellRendererText()
self.cbnum.pack_start(render2, True)
self.cbnum.add_attribute(render2, 'text', 1)
def on_change(self, entry, data=None):
self.tabla.destroy()
empresa = SqlNominas(0)
trabajadores = empresa.trabajadores(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(),
self.esnomina, self.esfiniquito,
self.esnominapextra)
tabla = Gtk.Table(10, 1)
t = 0
while t < len(trabajadores):
boton = Gtk.Button(trabajadores[t][0])
boton.connect("clicked", self.clicked, trabajadores[t][1])
boton.show()
tabla.attach(boton, 0, 1, t, t + 1)
t += 1
self.tabla = tabla
self.tabla.show()
self.box9.add(self.tabla)
self.box9.show()
def on_rbnomina_toggled(self, button, data=None):
if button.get_active():
if button.get_label() == 'Nomina':
self.esnomina = True
self.esfiniquito = False
self.esnominapextra = False
elif button.get_label() == 'Finiquito':
self.esnomina = False
self.esfiniquito = True
self.esnominapextra = False
elif button.get_label == 'Nomina pagas extras':
self.esnomina = False
self.esfiniquito = False
self.esnominapextra = True
self.on_change(self.cbnum)
def clicked(self, widget, data=None):
devengos = vernomina(data, valor_combobox(self.cbmes),
self.anio.get_text(),
valor_combobox(self.formnom), self.esnomina,
self.esfiniquito, self.esnominapextra)
def on_bRecalculo_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text())
self.calculo.recalcular()
def on_bCalcular_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(), self.esnomina,
self.esfiniquito, self.esnominapextra)
self.calculo.calcular()
class Nomina():
def __init__(self):
self.gladefile = "Ventanas/nomina.glade"
self.builder = Gtk.Builder()
self.builder.add_from_file(self.gladefile)
self.builder.connect_signals(self)
self.grabarfichero1 = self.builder.get_object("grabarfichero1")
self.window2 = self.builder.get_object("window2")
self.lTitulo = self.builder.get_object("lTitulo")
self.lTitulo.set_text("A darle fuerte")
self.bBuscar = self.builder.get_object("bBuscar")
self.bSalir = self.builder.get_object("bSalir")
self.bImprimir = self.builder.get_object("bImprimir")
self.cbnum = self.builder.get_object("num_emp")
self.num = valor_combobox(self.cbnum)
self.lista_empresas()
self.cbmes = self.builder.get_object("mes")
self.mes = valor_combobox(self.cbmes)
self.anio = self.builder.get_object("anio")
self.anio.set_text(str(datetime.datetime.today().year))
self.formnom = self.builder.get_object("formnom")
self.box9 = self.builder.get_object("box9")
self.tabla = Gtk.Table(1, 1)
self.box9.add(self.tabla)
self.rbnomina = self.builder.get_object('rbnomina')
self.rbfiniquito = self.builder.get_object('rbfiniquito')
self.rbnominapextra = self.builder.get_object('rbnominapextra')
self.on_rbnomina_toggled(self.rbnomina)
self.tabla.show()
self.box9.show()
self.window2.show()
def on_window2_destroy(self, objecto, data=None):
self.window2.destroy()
def on_bSalir_clicked(self, button, data=None):
self.window2.destroy()
def on_bImprimir_clicked(self, button, data=None):
# self.grabarfichero1.show()
self.canvas = canvas.Canvas("nomina.pdf", pagesize=A4)
impr_nomina(self.canvas,
valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
int(self.anio.get_text()),
valor_combobox(self.formnom), 0)
# width, height = A4
self.canvas.save()
# self.anio.set_text("")
# self.dialImprimir = dialImprimir()
print os.name
os.system("/usr/bin/evince nomina.pdf")
def on_bCalcular_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(), self.esnomina,
self.esfiniquito, self.esnominapextra)
self.calculo.calcular()
# self.dialDato
def on_bRecalculo_clicked(self, botton, data=None):
self.calculo = CalcNomina(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text())
self.calculo.recalcular()
def on_bBorrar_clicked(self, botton, data=None):
print botton
supr = NomBorrar(valor_combobox(self.cbnum), valor_combobox(self.cbmes), int(self.anio.get_text()), 0,
self.esnomina, self.esfiniquito, self.esnominapextra)
supr.borrar_mes()
def lista_empresas(self):
listaempresas = Gtk.ListStore(long, str)
empresas = SqlEmpresa(0).listaempresas()
for k in empresas:
contenido = []
for l in k:
contenido.append(l)
listaempresas.append(contenido)
self.cbnum.set_model(listaempresas)
render1 = Gtk.CellRendererText()
self.cbnum.pack_start(render1, True)
self.cbnum.add_attribute(render1, 'int', 0)
render2 = Gtk.CellRendererText()
self.cbnum.pack_start(render2, True)
self.cbnum.add_attribute(render2, 'text', 1)
def on_change(self, entry, data=None):
self.tabla.destroy()
empresa = SqlNominas(0)
trabajadores = empresa.trabajadores(valor_combobox(self.cbnum),
valor_combobox(self.cbmes),
self.anio.get_text(), self.esnomina,
self.esfiniquito, self.esnominapextra)
tabla = Gtk.Table(10, 1)
t = 0
while t < len(trabajadores):
boton = Gtk.Button(trabajadores[t][0])
boton.connect("clicked", self.clicked, trabajadores[t][1])
boton.show()
tabla.attach(boton, 0, 1, t, t + 1)
t += 1
self.tabla = tabla
self.tabla.show()
self.box9.add(self.tabla)
self.box9.show()
def on_rbnomina_toggled(self, button, data=None):
if button.get_active():
if button.get_label() == 'Nomina':
self.esnomina = True
self.esfiniquito = False
self.esnominapextra = False
elif button.get_label() == 'Finiquito':
self.esnomina = False
self.esfiniquito = True
self.esnominapextra = False
elif button.get_label == 'Nomina pagas extras':
self.esnomina = False
self.esfiniquito = False
self.esnominapextra = True
self.on_change(self.cbnum)
def clicked(self, widget, data=None):
devengos = vernomina(data, valor_combobox(self.cbmes),
self.anio.get_text(), valor_combobox(self.formnom), self.esnomina,
self.esfiniquito, self.esnominapextra)
