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