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 set_focus(self, widget):
if widget == self.frm('entry2'):
widget.set_text(Format.fecha(widget.get_text()))
if widget == self.frm('entry4'):
self.cargar_proveedor()
if widget == self.frm('entry1'):
widget.set_text(Format.factura(widget.get_text()))
if widget == self.frm('entry9'):
self.cargar_articulos()
widget.get_toplevel().child_focus(Gtk.DirectionType.TAB_FORWARD)
if widget == self.frm('entry12'):
self.guardar()
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 set_focus(self, widget):
if widget == self.frm("entry2"):
widget.set_text(Format.fecha(widget.get_text()))
if widget == self.frm("entry4"):
self.cargar_proveedor()
# en este caso clientes
if widget == self.frm("entry9"):
self.cargar_articulos()
widget.get_toplevel().child_focus(Gtk.DirectionType.TAB_FORWARD)
if widget == self.frm("entry12"):
self.guardar()
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 createDomainConfig(domain, client_locales):
"""
TODO: Cache?
"""
config = json.decode(domain.content) if domain.content else {}
# Fetch global values
m = memcache.get_multi(['clicks_total', 'already_donated', 'already_clicked', 'eur_goal', 'eur_increment'])
if 'already_clicked' not in m:
memcache.set('already_clicked', ALREADY_CLICKED)
already_clicked = ALREADY_CLICKED
else:
already_clicked = m['already_clicked']
if 'already_donated' not in m:
memcache.set('already_donated', ALREADY_DONATED)
already_donated = ALREADY_DONATED
else:
already_donated = m['already_donated']
if 'eur_goal' not in m:
memcache.set('eur_goal', EUR_GOAL)
goal = EUR_GOAL
else:
goal = m['eur_goal']
if 'eur_increment' not in m:
memcache.set('eur_increment', EUR_INCREMENT)
increment = EUR_INCREMENT
else:
increment = m['eur_increment']
clicks_total = m['clicks_total'] if 'clicks_total' in m else already_clicked
clicks = clicks_total - already_clicked
## Plain values
config['donated'] = float(already_donated)
unlocked = already_donated + clicks * increment
config['unlocked'] = unlocked
config['percent'] = unlocked / goal
config['clicks'] = clicks_total
config['increment'] = increment
# Create labels
locale = 'en'
if 'default_locale' in config:
locale = config['default_locale']
del config['default_locale']
# Get client locale
for client_locale in client_locales:
if client_locale in config['__locales']:
locale = client_locale
break
del config['__locales']
f = Format(locale)
labels = {
'donated': f.decimalMoney(already_donated),
'unlocked': f.money(unlocked),
'clicks': f.decimal(clicks_total),
'increment': f.money(increment)
}
if 'strings' in config:
for key in config['strings'][locale]:
if isinstance(config['strings'][locale][key], basestring):
config[key] = config['strings'][locale][key]
for labelkey in labels:
config[key] = config[key].replace('%' + labelkey + '%', labels[labelkey])
del config['strings']
return config
def set_focus(self, widget):
if widget in (self.frm('entry2'), self.frm('entry3')):
widget.set_text(Format.fecha(widget.get_text()))
widget.get_toplevel().child_focus(Gtk.DirectionType.TAB_FORWARD)
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))
