def consultar(self, widget=None):
self.nav('liststore1').clear()
color = False
for row in self.entity.compras_all(self.nav('entry1').get_text()):
if not color:
t_color = "#FFFFDA"
color = True
else:
t_color = "#A9FFA9"
color = False
self.nav('liststore1').append([
row[0], row[1], row[2], row[3],
Format.number(row[4]), Format.number(row[5]),
Format.number(row[6]), Format.number(row[7]), t_color
])
if len(self.nav('liststore1')) == 0:
self.nav('bt_editar').set_sensitive(False)
self.nav('bt_eliminar').set_sensitive(False)
self.nav('label1').set_text(' 0 Registros Encontrados')
else:
self.nav('bt_editar').set_sensitive(True)
self.nav('bt_eliminar').set_sensitive(True)
self.nav('label1').set_text(' %s Registros Encontrados' % len(self.nav('liststore1')))
self.nav('entry1').set_text(self.nav('entry1').get_text().upper())
def consultar(self, widget=None):
self.nav("liststore1").clear()
color = False
for row in self.entity.presupuesto_all(self.nav("entry1").get_text()):
if not color:
t_color = "#FFFFDA"
color = True
else:
t_color = "#A9FFA9"
color = False
self.nav("liststore1").append(
[
str(row[0]),
row[1],
str(row[2]),
row[3],
Format.number(row[4]),
Format.number(row[5]),
Format.number(row[6]),
Format.number(row[7]),
t_color,
]
)
if len(self.nav("liststore1")) == 0:
self.nav("bt_editar").set_sensitive(False)
self.nav("bt_eliminar").set_sensitive(False)
self.nav("label1").set_text(" 0 Registros Encontrados")
else:
self.nav("bt_editar").set_sensitive(True)
self.nav("bt_eliminar").set_sensitive(True)
self.nav("label1").set_text(" %s Registros Encontrados" % len(self.nav("liststore1")))
self.nav("entry1").set_text(self.nav("entry1").get_text().upper())
def calcular_pago(self):
total = 0.0
for row in self.frm('liststore1'):
if row[4]:
total += float(row[3].replace(',', ''))
self.frm('label3').set_text(Format.number(total))
def append_formas(self, forma, monto):
if len(self.frm('entry4').get_text()) > 0:
efectivo = float(self.frm('entry4').get_text())
else:
efectivo = 0
total_docs = float(self.frm('label99').get_text().replace(',', ''))
self.frm('liststore2').append([forma, str(monto)])
#calculando totales de las formas de pago
total = 0.0 + efectivo
for row in self.frm('liststore2'):
total += float(row[1])
self.frm('label99').set_text(Format.number(total))
def cargar_cuentas(self):
if len(self.frm('entry1').get_text()) > 0:
idcontacto = self.frm('entry1').get_text().split('-')[0]
self.frm('liststore1').clear()
for row in self.cuentas.cuentas_all(idcontacto):
self.frm('liststore1').append([str(row[0]),
str(row[1]),
str(row[2]),
Format.number(row[3]),
row[4]])
if len(self.frm('liststore1')) == 0:
msg.errorMsgBox(self.frm('window1'),
"Cliente sin cuentas",
"Cliente sin cuentas pendientes de pago.")
def consultar(self, widget = None):
self.nav('liststore1').clear()
color = False
for row in self.compras.compras_list(self.nav('entry1').get_text()):
if not color:
t_color = "#FFFFDA"
color = True
else:
t_color = "#A9FFA9"
color = False
self.nav('liststore1').append([
row[0], row[1], str(row[2]), str(row[3]), row[4],
row[5], row[6], Format.number(row[7]), t_color
])
def imprimir(self):
file = open("reportes/presupuesto.html", "r").readlines()
rows = ""
for row in self.frm("liststore1"):
stotal = float(row[4].replace(",", "")) + float(row[5].replace(",", "")) + float(row[6].replace(",", ""))
rows += """
<tr>
<td style = "{text-align: right;}" width = 50>%s</td>
<td style = "{text-align: left;}">%s</td>
<td style = "{text-align: right;}" width = 80>%s</td>
<td style = "{text-align: right;}" width = 80>%s</td>
<td style = "{text-align: right;}" width = 80>%s</td>
</tr>
""" % (
row[0],
row[1],
row[2],
row[3],
Format.number(stotal),
)
rows += """
<tr>
<td style = "{text-align: right;}" width = 50> </td>
<td style = "{text-align: left;}"> </td>
<td style = "{text-align: right;}" width = 80> </td>
<td style = "{text-align: right;}" width = 80><big>TOTAL</big></td>
<td style = "{text-align: right;}" width = 80>%s</td>
</tr>
""" % (
self.frm("t_documento").get_text()
)
self.dic_rp = {
"{TITLE}": "Nota de Presupuesto",
"{EMPRESA}": self.padre.main("label1").get_text(),
"{FECHA}": datetime.now().strftime("%d/%m/%Y"),
"{CLIENTE}": self.frm("entry5").get_text(),
"{ROW}": rows,
}
html = ""
for row in file:
line = self.getLines(row)
html += line
html += "\n"
# print html
self.pdf(html)
def refrescar_detalle(self):
self.frm('liststore1').clear()
ex = 0.0
g5 = 0.0
g10 = 0.0
for row in self.detalle.get_detalle(self.frm('entry1').get_text(), self.frm('entry7').get_text(),
self.frm('entry4').get_text()):
ex += row[4]
g5 += row[5]
g10 += row[6]
self.frm('liststore1').append([
str(row[0]), row[1], Format.number(row[2]), Format.number(row[3]),
Format.number(row[4]), Format.number(row[5]),
Format.number(row[6])
])
self.frm('exentas').set_text(Format.number(ex))
self.frm('gravada5').set_text(Format.number(g5))
self.frm('gravada10').set_text(Format.number(g10))
self.frm('iva5').set_text(Format.number(round(g5/21)))
self.frm('iva10').set_text(Format.number(round(g10/11)))
self.frm('t_iva').set_text(Format.number(round(g5/21)+round(g10/11)))
self.frm('t_documento').set_text(Format.number(ex+g5+g10))
def refrescar_detalle(self):
self.frm("liststore1").clear()
ex = 0.0
g5 = 0.0
g10 = 0.0
for row in self.detalle.det_all(self.frm("entry1").get_text()):
ex += row[4]
g5 += row[5]
g10 += row[6]
self.frm("liststore1").append(
[
str(row[0]),
row[1],
Format.number(float(row[2].split("-")[0])),
Format.number(row[3]),
Format.number(row[4]),
Format.number(row[5]),
Format.number(row[6]),
]
)
self.frm("exentas").set_text(Format.number(ex))
self.frm("gravada5").set_text(Format.number(g5))
self.frm("gravada10").set_text(Format.number(g10))
self.frm("iva5").set_text(Format.number(round(g5 / 21)))
self.frm("iva10").set_text(Format.number(round(g10 / 11)))
self.frm("t_iva").set_text(Format.number(round(g5 / 21) + round(g10 / 11)))
self.frm("t_documento").set_text(Format.number(ex + g5 + g10))
def refrescar_detalle(self):
self.frm('liststore1').clear()
ex = 0.0
g5 = 0.0
g10 = 0.0
nro_factura = self.frm('entry1').get_text().split('-')[2]
for row in self.detalle.get_detalle(nro_factura, self.frm('entry7').get_text(),
self.padre.idpunto_expedicion,
self.padre.establecimiento):
ex += row[4]
g5 += row[5]
g10 += row[6]
self.frm('liststore1').append([
str(row[0]), row[1], Format.number(row[2]), Format.number(row[3]),
Format.number(row[4]), Format.number(row[5]),
Format.number(row[6])
])
self.frm('exentas').set_text(Format.number(ex))
self.frm('gravada5').set_text(Format.number(g5))
self.frm('gravada10').set_text(Format.number(g10))
self.frm('iva5').set_text(Format.number(round(g5/21)))
self.frm('iva10').set_text(Format.number(round(g10/11)))
self.frm('t_iva').set_text(Format.number(round(g5/21)+round(g10/11)))
self.frm('t_documento').set_text(Format.number(ex+g5+g10))
