def __init__(self):
self.db = DBAccess()
self.botonera = self.db.table_botonera()
self.pages_botonera = self.db.table_pages_botonera()
self.sort_pages_botonera = self.db.ordenar(self.pages_botonera, 'id_page')
self.articulos = self.db.table_articles()
self.widget = gtk.glade.XML('pytpv.glade', 'winBotonera')
self.winbotonera = self.widget.get_widget('winBotonera')
self.winbotonera.set_title('Configurar Botonera')
self.winbotonera.set_icon_from_file('images' + os.sep + 'yinyang.png')
vbox = self.widget.get_widget('vbox13')
self.winbotonera.show()
self.widget.signal_autoconnect(self)
self.notebook = gtk.Notebook()
data_botonera = []
for item in self.botonera:
data_botonera.append(item)
data_articulos = []
for item in self.articulos:
data_articulos.append(item)
vbox.pack_start(self.notebook)
a = 0
c = 0
r = 0
aopt = gtk.FILL|gtk.SHRINK
for page in self.sort_pages_botonera:
label = gtk.Label(page[1])
label.set_padding(15, 15)
self.table = gtk.Table(6, 6)
self.notebook.append_page(self.table, label)
for x in range(36):
button = MakeButton(data_botonera[a][5])
print "button %s" % a
# button.set_data("id", (a+1))
button.set_data("id", data_botonera[a][0])
button.connect("clicked", self.clicked, button.get_data("id"))
button.set_size_request(100, 100)
# if button.get_label() is None:
# button.set_sensitive(False)
self.notebook.get_nth_page(page[2]).attach(button, c, \
c+1, r, \
r+1, aopt, aopt, 0, 0)
a += 1
c += 1
if c == 6:
c = 0
r += 1
if r == 6:
r = 0
self.winbotonera.show_all()
class winFamilys:
def __init__(self):
self.db = DBAccess()
self.family = self.db.table_family()
self.widget = gtk.glade.XML('pytpv.glade', 'winFamily')
self.winfamily = self.widget.get_widget('winFamily')
self.winfamily.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.winfamily.set_title('Familias')
vbox = self.widget.get_widget('vbox10')
self.familiasview = FamiliaView(self)
self.familiasview.set_size_request(400, 300)
vbox.pack_end(self.familiasview, False, False)
for row in self.family:
self.familiasview.add(row)
self.winfamily.show_all()
self.widget.signal_autoconnect(self)
def on_btnNewFamily_clicked(self, widget, args=[]):
familys = dlgFamilys().NewFamily(self, widget)
print familys
if familys != None:
self.familiasview.prepend(familys)
self.familiasview.scroll_to_cell(0)
def on_btnEditFamily_clicked(self, item):
datos = []
for item in range(3):
it = self.familiasview.getSelectedItem(item)
datos.append(it)
editfamilys = dlgFamilys().EditFamily(datos)
if editfamilys:
a = 1
b = 1
for x in range(2):
self.familiasview.update(iter, a, editfamilys[b])
a += 1
b += 1
print editfamilys
def on_btnDelFamily_clicked(self, item):
item = self.familiasview.getSelectedItem(0)
DBAccess().remove(self.family, 'id=%s' % item)
self.familiasview.remove()
def on_btnPrintFamily_clicked(self, item):
pass
def __init__(self):
self.db = DBAccess()
self.clients = self.db.table_clients()
self.tickets = self.db.table_tickets()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgNewTicket')
self.dialognewticket = self.widget.get_widget('dlgNewTicket')
self.dialognewticket.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.combo = self.widget.get_widget('cmbOderTimeNewTicket')
self.widget.signal_autoconnect(self)
items = ['12:00', '12:15', '12:30', '12:45', '13:00', '13:15', \
'13:30', '13:45', '14:00', '14:15', '14:30', '14:45', \
'15:00', '15:15', '15:30']
self.MakeCombo(items)
self.idnewticket = self.widget.get_widget('entIdNewTicket')
self.entidclientnewticket = self.widget.get_widget('entIdClientNewTicket')
self.entnamenewticket = self.widget.get_widget('entNameNewTicket')
self.entaddressnewticket = self.widget.get_widget('entAddressNewTicket')
self.entphonenewticket = self.widget.get_widget('entPhoneNewTicket')
self.entoderhournewticket = self.widget.get_widget('entOrderHourNewTicket')
self.entdatenewticket = self.widget.get_widget('entDateNewTicket')
self.entcallhournewticket = self.widget.get_widget('entCallHourNewTicket')
self.checkcredit = self.widget.get_widget('checkCredit')
self.checkdelivery = self.widget.get_widget('checkDelivery')
self.checkordered = self.widget.get_widget('checkOrdered')
self.checkorderwithdrawn = self.widget.get_widget('checkOrderWithdrawn')
# self.entrys = ['entIdNewTicket',\
# 'entIdClientNewTicket', \
# 'entNameNewTicket',\
# 'entAddressNewTicket', \
# 'entPhoneNewTicket', \
# 'entOrderHourNewTicket', \
# 'entDateNewTicket', \
# 'entCallHourNewTicket', \
# 'checkCredit', \
# 'checkDelivery', \
# 'checkOrdered', \
# 'checkOrderWithdrawn']
# print self.entrys
self.clientesview = ClientesView(self)
self.scrollednewticket = self.widget.get_widget('scrolledNewTicket')
self.scrollednewticket.add(self.clientesview)
self.clientesview.set_size_request(400, 250)
for client in self.clients:
self.clientesview.add(client)
self.clientesview.show()
self.clientesview.connect('cursor-changed', self.update_entrys)
def __init__(self):
self.db = DBAccess()
self.clients = self.db.table_clients()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgClients')
self.dialogclient = self.widget.get_widget('dlgClients')
self.dialogclient.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entIdClient',\
'entNameClient', \
'entAddressClient',\
'entPhoneClient', \
'entDateClient', \
'entLastBuyClient']
def __init__(self):
self.db = DBAccess()
self.family = self.db.table_family()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgFamilys')
self.dlgfamily = self.widget.get_widget('dlgFamilys')
self.dlgfamily.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entIdFamily', \
'entNameFamily', \
'entDescriptionFamily']
self.widget.signal_autoconnect(self)
def __init__(self):
self.db = DBAccess()
self.family = self.db.table_family()
self.widget = gtk.glade.XML('pytpv.glade', 'winFamily')
self.winfamily = self.widget.get_widget('winFamily')
self.winfamily.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.winfamily.set_title('Familias')
vbox = self.widget.get_widget('vbox10')
self.familiasview = FamiliaView(self)
self.familiasview.set_size_request(400, 300)
vbox.pack_end(self.familiasview, False, False)
for row in self.family:
self.familiasview.add(row)
self.winfamily.show_all()
self.widget.signal_autoconnect(self)
def __init__(self):
self.db = DBAccess()
self.articles = self.db.table_articles()
self.family = self.db.table_family()
items = []
for row in self.family:
items.append(row)
self.widget = gtk.glade.XML('pytpv.glade', 'dlgArticles')
self.dialogarticles = self.widget.get_widget('dlgArticles')
self.dialogarticles.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.combo = self.widget.get_widget('cmbFamilyArticle')
self.MakeCombo(items)
self.entrys = ['entIdArticle', \
'cmbFamilyArticle', \
'entDescriptionArticle', \
'entStockArticle', \
'entMinStockArticle', \
'entSalePriceArticle', \
'entImageArticle']
self.widget.signal_autoconnect(self)
def __init__(self):
# We create the notebook for store buttons called botonera
self.notebook = gtk.Notebook()
self.db = DBAccess()
self.botonera = self.db.table_botonera()
self.pages_botonera = self.db.table_pages_botonera()
self.sort_pages_botonera = self.db.ordenar(self.pages_botonera, 'id_page')
self.ticketlinea = self.db.table_ticketlinea()
self.articulos = self.db.table_articles()
data_botonera = []
for item in self.botonera:
data_botonera.append(item)
data_articulos = []
for item in self.articulos:
data_articulos.append(item)
a = 0
c = 0
r = 0
aopt = gtk.FILL|gtk.SHRINK
# Add the pages and buttons to notebook
for page in self.sort_pages_botonera:
label = gtk.Label(page[1])
label.set_padding(15, 15)
self.table = gtk.Table(6, 6)
self.notebook.append_page(self.table, label)
for x in range(36):
button = MakeButton(data_botonera[a][5])
print "button %s" % a
#button.set_data("id", (a+1))
button.set_data("id", data_botonera[a][0])
button.connect("clicked", self.clicked, button.get_data("id"))
button.set_focus_on_click(False)
button.set_size_request(100, 100)
if button.get_label() is None:
button.set_sensitive(False)
self.notebook.get_nth_page(page[2]).attach(button, c, \
c+1, r, \
r+1, aopt, aopt, 0, 0)
a += 1
c += 1
if c == 6:
c = 0
r += 1
if r == 6:
r = 0
self.widget = gtk.glade.XML('pytpv.glade')
window = self.widget.get_widget('mainwindow')
window.set_title(app + " " + version)
window.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.clientesview = ClientesView(self)
self.ticketview = TicketView(self)
self.ticketview.set_size_request(500, 309)
self.ticketview.connect('cursor-changed', self.on_TicketView_Cursor_Changed)
self.ticketlineaview = TicketLineaView(self)
self.ticketlineaview.set_size_request(300, -1)
self.articlesview = ArticulosView(self)
self.creditoview = CreditoView(self)
self.historicoview = HistoricoView(self)
self.scrolledticket = self.widget.get_widget('scrolledTicket')
self.scrolledticketlinea = self.widget.get_widget('scrolledTicketLinea')
self.scrolledarticles = self.widget.get_widget('scrolledArticles')
self.scrolledclients = self.widget.get_widget('scrolledClients')
self.scrolledhistory = self.widget.get_widget('scrolledHistory')
self.scrolledcredit = self.widget.get_widget('scrolledCredit')
self.scrolledticket.add(self.ticketview)
self.scrolledticketlinea.add(self.ticketlineaview)
self.scrolledarticles.add(self.articlesview)
self.scrolledclients.add(self.clientesview)
self.scrolledhistory.add(self.historicoview)
self.scrolledcredit.add(self.creditoview)
hbox = self.widget.get_widget('hbox1')
self.buttonbox = self.notebook
#self.buttonbox = Buttons()
hbox.pack_start(self.buttonbox, False, False)
window.show_all()
self.db = DBAccess()
self.clients = DBAccess().table_clients()
self.dbclients = DBAccess().select(self.clients)
#print self.dbclients
if self.dbclients:
for row in self.dbclients:
self.clientesview.add(row)
self.articles = DBAccess().table_articles()
self.dbarticles = DBAccess().select(self.articles)
self.family = self.db.table_family()
if self.dbarticles:
for row in self.dbarticles:
print "%-5s %-5s %-5s" % (row[:-4])
familyname = self.family.busqueda('familia', 'id=%s' % (row[1]))
#print familyname[1]
datos = row[0], familyname[1], row[2], ("%0.2f" %row[3]), \
("%0.2f" %row[4]), ("%0.2f" %row[5]), row[6]
self.articlesview.add(datos)
self.currentdate = self.db.date(self.clients)
self.ticket = DBAccess().table_tickets()
self.tickets = self.ticket.search('ticket', "fecha=\"%s\"" % self.currentdate)
if self.tickets:
for row in self.tickets:
client = self.clients.busqueda('clientes', 'id=%s' % (row[1]))
if row[6]:
credito = gtk.STOCK_ADD
else:
credito = None
if row[7]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if row[8]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row = [row[0], credito, servicio, comanda, client[1], \
client[2], None, row[3]]
print structured_row
self.ticketview.add(structured_row)
self.widget.signal_autoconnect(self)
class MainWindow:
"""
Main class of PyTPV.
Build dinamically notebook and all treeviews.
All functions of Main Windows are here.
"""
def __init__(self):
# We create the notebook for store buttons called botonera
self.notebook = gtk.Notebook()
self.db = DBAccess()
self.botonera = self.db.table_botonera()
self.pages_botonera = self.db.table_pages_botonera()
self.sort_pages_botonera = self.db.ordenar(self.pages_botonera, 'id_page')
self.ticketlinea = self.db.table_ticketlinea()
self.articulos = self.db.table_articles()
data_botonera = []
for item in self.botonera:
data_botonera.append(item)
data_articulos = []
for item in self.articulos:
data_articulos.append(item)
a = 0
c = 0
r = 0
aopt = gtk.FILL|gtk.SHRINK
# Add the pages and buttons to notebook
for page in self.sort_pages_botonera:
label = gtk.Label(page[1])
label.set_padding(15, 15)
self.table = gtk.Table(6, 6)
self.notebook.append_page(self.table, label)
for x in range(36):
button = MakeButton(data_botonera[a][5])
print "button %s" % a
#button.set_data("id", (a+1))
button.set_data("id", data_botonera[a][0])
button.connect("clicked", self.clicked, button.get_data("id"))
button.set_focus_on_click(False)
button.set_size_request(100, 100)
if button.get_label() is None:
button.set_sensitive(False)
self.notebook.get_nth_page(page[2]).attach(button, c, \
c+1, r, \
r+1, aopt, aopt, 0, 0)
a += 1
c += 1
if c == 6:
c = 0
r += 1
if r == 6:
r = 0
self.widget = gtk.glade.XML('pytpv.glade')
window = self.widget.get_widget('mainwindow')
window.set_title(app + " " + version)
window.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.clientesview = ClientesView(self)
self.ticketview = TicketView(self)
self.ticketview.set_size_request(500, 309)
self.ticketview.connect('cursor-changed', self.on_TicketView_Cursor_Changed)
self.ticketlineaview = TicketLineaView(self)
self.ticketlineaview.set_size_request(300, -1)
self.articlesview = ArticulosView(self)
self.creditoview = CreditoView(self)
self.historicoview = HistoricoView(self)
self.scrolledticket = self.widget.get_widget('scrolledTicket')
self.scrolledticketlinea = self.widget.get_widget('scrolledTicketLinea')
self.scrolledarticles = self.widget.get_widget('scrolledArticles')
self.scrolledclients = self.widget.get_widget('scrolledClients')
self.scrolledhistory = self.widget.get_widget('scrolledHistory')
self.scrolledcredit = self.widget.get_widget('scrolledCredit')
self.scrolledticket.add(self.ticketview)
self.scrolledticketlinea.add(self.ticketlineaview)
self.scrolledarticles.add(self.articlesview)
self.scrolledclients.add(self.clientesview)
self.scrolledhistory.add(self.historicoview)
self.scrolledcredit.add(self.creditoview)
hbox = self.widget.get_widget('hbox1')
self.buttonbox = self.notebook
#self.buttonbox = Buttons()
hbox.pack_start(self.buttonbox, False, False)
window.show_all()
self.db = DBAccess()
self.clients = DBAccess().table_clients()
self.dbclients = DBAccess().select(self.clients)
#print self.dbclients
if self.dbclients:
for row in self.dbclients:
self.clientesview.add(row)
self.articles = DBAccess().table_articles()
self.dbarticles = DBAccess().select(self.articles)
self.family = self.db.table_family()
if self.dbarticles:
for row in self.dbarticles:
print "%-5s %-5s %-5s" % (row[:-4])
familyname = self.family.busqueda('familia', 'id=%s' % (row[1]))
#print familyname[1]
datos = row[0], familyname[1], row[2], ("%0.2f" %row[3]), \
("%0.2f" %row[4]), ("%0.2f" %row[5]), row[6]
self.articlesview.add(datos)
self.currentdate = self.db.date(self.clients)
self.ticket = DBAccess().table_tickets()
self.tickets = self.ticket.search('ticket', "fecha=\"%s\"" % self.currentdate)
if self.tickets:
for row in self.tickets:
client = self.clients.busqueda('clientes', 'id=%s' % (row[1]))
if row[6]:
credito = gtk.STOCK_ADD
else:
credito = None
if row[7]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if row[8]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row = [row[0], credito, servicio, comanda, client[1], \
client[2], None, row[3]]
print structured_row
self.ticketview.add(structured_row)
self.widget.signal_autoconnect(self)
def clicked(self, button, data):
try:
x = self.ticketview.getSelectedItem(0)
if x:
# if data:
a = self.botonera.busqueda('botonera', 'id=%s' % (data))
articuloboton = self.botonera.inner(a[4])
print articuloboton
suma = float(2.4)*float(3.5)
print ("%0.2f" %suma)
ticket = self.ticket.busqueda('tickets', 'id=%s' % \
(self.on_TicketView_Cursor_Changed \
(self, data)))
ticketlinea = self.ticketlinea.busqueda('ticket_linea', \
'ticket_FK_id=%s and articulo_FK_id=%s' % \
(ticket[0], data))
if ticketlinea:
cells = "cantidad, articulo_FK_id"
cantidad = ticketlinea[2] + 1
datos = cantidad, ticketlinea[3]
self.db.update(self.ticketlinea, 'ticket_linea', cells, datos, \
"id=\"%s\"" % ticketlinea[0])
# result = float(cantidad)*float(ticketlinea[4])
# print ("%0.2f" % result)
# self.ticketlineaview.update(1, 2, ("%0.2f" % cantidad))
# self.ticketlineaview.update(1, 4, ("%0.2f" % result))
importe = cantidad*ticketlinea[4]
print "%0.2f" % importe
datos = ticketlinea[0], cantidad, importe
print datos
self.ticketlineaview.model_foreach(datos)
else:
self.db.insert(self.ticketlinea, None, ticket[0], \
float(1), articuloboton[0], float(articuloboton[5]))
row = self.db.get_last_insert(self.ticketlinea)
row = row[0], row[1], ("%0.2f" % 1), articuloboton[2], ("%0.2f" % row[4])
self.ticketlineaview.add(row)
print (self.on_TicketView_Cursor_Changed(self, data))
print ticket
except:
print 'You should select a row in ticketview'
def on_mainwindow_destroy(self, widget, args=[]):
print 'on_mainwindow_destroy called with self.%s' % widget.get_name()
gtk.main_quit()
print 'aplicacion destruida'
def on_btnNewTicket_clicked(self, widget, args=[]):
print 'on_btnNewTicket_clicked called with self.%s' % widget.get_name()
#winnewticket = winNewTicket()
newticket = dlgNewTicket().NewTicket(self, widget)
if newticket != None:
print 'va o no' % newticket
path = self.ticketview.add(newticket)
self.ticketview.scroll_to_cell(path[1])
self.ticketview.get_selection().select_path(path[1])
ticket = self.ticket.busqueda('ticket', 'id=%s' % \
(self.on_TicketView_Cursor_Changed \
(self, args)))
print ticket[1]
def on_btnEditTicket_clicked(self, widget, args=[]):
print 'on_btnEditTicket_clicked called with self.%s' % widget.get_name()
searchticket = dlgNewTicket().tickets.busqueda('ticket', 'id=%s' % \
(self.ticketview.getSelectedItem(0)))
editticket = dlgNewTicket().EditTicket(searchticket)
print editticket
if editticket != None:
a = 1
b = 1
for x in range(7):
self.ticketview.update(iter, a, editticket[b])
a += 1
b += 1
print editticket
def on_btnDelTicket_clicked(self, widget, args=[]):
print 'on_btnDelTicket_clicked called with self.%s' % widget.get_name()
item = self.ticketview.getSelectedItem(0)
DBAccess().remove(self.tickets, 'id=%s' % item)
self.ticketview.remove()
ticketlinea = self.ticketlinea.search('ticket_linea', 'ticket_FK_id=%s' % \
(item))
if ticketlinea:
for row in ticketlinea:
self.db.remove(self.ticketlinea, 'ticket_FK_id=%s' % (item))
self.ticketlineaview.clear()
def on_TicketView_Cursor_Changed(self, widget, args=[]):
id_ticket = self.ticketview.getSelectedItem(0)
ticketlinea = self.ticketlinea.search('ticket_linea', 'ticket_FK_id=%s' % \
(id_ticket))
self.ticketlineaview.clear()
for row in ticketlinea:
articulo = self.articles.busqueda('articulos', 'id=%s' % (row[3]))
structured_row = row[0], row[1], ("%0.2f" % row[2]), \
articulo[2], ("%0.2f" % row[4])
self.ticketlineaview.add(structured_row)
print id_ticket
return id_ticket
def on_btnOrder_clicked(self, widget, args=[]):
print 'on_btnOrder_clicked called with self.%s' % widget.get_name()
def on_btnDeselect_clicked(self, widget, args=[]):
print 'on_btnDeselect_clicked called with self.%s' % widget.get_name()
def on_btnHideOrder_clicked(self, widget, args=[]):
print 'on_btnHideOrder_clicked called with self.%s' % widget.get_name()
def on_btnHideDelivery_clicked(self, widget, args=[]):
print 'on_btnHideDelivery_clicked called with self.%s' % widget.get_name()
def on_btnHideHides_clicked(self, widget, args=[]):
print 'on_btnHideHides_clicked called with self.%s' % widget.get_name()
def on_btnShowHides_clicked(self, widget, args=[]):
print 'on_btnShowHides_clicked called with self.%s' % widget.get_name()
def on_btnShowAll_clicked(self, widget, args=[]):
print 'on_btnShowAll_clicked called with self.%s' % widget.get_name()
def on_btnCredit_clicked(self, widget, args=[]):
print 'on_btnCredit_clicked called with self.%s' % widget.get_name()
def on_entFilterTicket_changed(self, widget, args=[]):
print 'on_entFilterTicket_changed called with self.%s' % widget.get_name()
self.ticketview.clear()
# datos = self.clients.search("clientes", "fecha = \"%s\" and nombre like = \"%s\"" % \
# (self.currentdate, self.widget. \
# get_widget('entFilterTicket').get_text()+'%'))
datos = self.db.filter(self.clients, 'clientes', 'nombre', self.widget.get_widget('entFilterTicket').get_text()+'%')
for dato in datos:
#linea = self.db.filter(self.tickets, 'ticket', 'cliente_FK_id', dato[0])
linea = self.ticket.search("ticket", "fecha = \"%s\" and cliente_FK_id = %s" % \
(self.currentdate, dato[0]))
for row in linea:
print row
if row[6]:
credito = gtk.STOCK_ADD
else:
credito = None
if row[7]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if row[8]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row1 = [row[0], credito, servicio, comanda, dato[1], \
dato[2], None, row[4]]
print 'row is' % structured_row1
self.ticketview.add(structured_row1)
def on_btnCleanTicketFilter_clicked(self, widget, args=[]):
print 'on_btnCleanTicketFilter_clicked called with self.%s' % widget.get_name()
a = self.widget.get_widget('entFilterTicket')
a.delete_text(0, -1)
def on_button_CloseTicket_clicked(self, widget, args=[]):
print 'on_button_CloseTicket_clicked called with self.%s' % widget.get_name()
def on_button_Ticket_clicked(self, widget, args=[]):
print 'on_button_Ticket_clicked called with self.%s' % widget.get_name()
def on_button_Comanda_clicked(self, widget, args=[]):
print 'on_button_Comanda_clicked called with self.%s' % widget.get_name()
def on_button_ExecuteDeliverys_clicked(self, widget, args=[]):
print 'on_button_ExecuteDeliverys_clicked called with self.%s' % widget.get_name()
def on_button_CashRegister_clicked(self, widget, args=[]):
print 'on_button_CashRegister_clicked called with self.%s' % widget.get_name()
def on_button_ChangeCash_clicked(self, widget, args=[]):
print 'on_button_ChangeCash_clicked called with self.%s' % widget.get_name()
def on_btnAddArticle_clicked(self, widget, args=[]):
print 'on_btnAddArticle_clicked called with self.%s' % widget.get_name()
articulos = dlgArticles().NewArticle(self, widget)
if articulos != None:
self.articlesview.prepend(articulos)
self.articlesview.scroll_to_cell(0)
def on_btnEditArticle_clicked(self, widget, args=[]):
print 'on_btnEditArticle_clicked called with self.%s' % widget.get_name()
datos = []
for item in range(7):
it = self.articlesview.getSelectedItem(item)
datos.append(it)
editarticles = dlgArticles().EditArticle(datos)
print editarticles
if editarticles:
a = 1
b = 1
for x in range(6):
self.articlesview.update(iter, a, editarticles[b])
a += 1
b += 1
print editarticles
def on_btnDelArticle_clicked(self, widget, args=[]):
print 'on_btnDelArticle_clicked called with self.%s' % widget.get_name()
item = self.articlesview.getSelectedItem(0)
DBAccess().remove(self.articles, 'id=%s' % item)
self.articlesview.remove()
def on_btnPrintArticles_clicked(self, widget, args=[]):
print 'on_btnPrintArticles_clicked called with self.%s' % widget.get_name()
def on_entFilterArticles_changed(self, widget, args=[]):
print 'on_entFilterArticles_changed called with self.%s' % widget.get_name()
self.articlesview.clear()
datos = self.db.filter(self.articles, 'articulos', 'descripcion', \
self.widget.get_widget('entFilterArticles'). \
get_text()+'%')
for dato in datos:
searchfamily = self.family.busqueda('familia', 'id=%s' % (dato[1]))
print datos
estructured_row = [dato[0], searchfamily[1], dato[2], dato[3], \
dato[4], dato[5], dato[6]]
self.articlesview.add(estructured_row)
def on_btnCleanFilterArticles_clicked(self, widget, args=[]):
print 'on_btnCleanFilterArticles_clicked called with self.%s' % widget.get_name()
a = self.widget.get_widget('entFilterArticles')
a.delete_text(0, -1)
def on_btnAddClient_clicked(self, widget, args=[]):
print 'on_btnAddClient_clicked called with self.%s' % widget.get_name()
clientes = dlgClients().NewClient(self, widget)
if clientes != None:
self.clientesview.prepend(clientes)
self.clientesview.scroll_to_cell(0)
def on_btnEditClient_clicked(self, widget, args=[]):
print 'on_btnEditClient_clicked called with self.%s' % widget.get_name()
datos = []
for item in range(6):
it = self.clientesview.getSelectedItem(item)
datos.append(it)
editclients = dlgClients().EditClient(datos)
if editclients:
a = 1
b = 1
for x in range(5):
self.clientesview.update(iter, a, editclients[b])
a += 1
b += 1
print editclients
def on_btnDelClient_clicked(self, widget, args=[]):
print 'on_btnDelClient_clicked called with self.%s' % widget.get_name()
item = self.clientesview.getSelectedItem(0)
DBAccess().remove(self.clients, 'id=%s' % item)
self.clientesview.remove()
def on_btnPrintClients_clicked(self, widget, args=[]):
print 'on_btnPrintClients_clicked called with self.%s' % widget.get_name()
def on_entFilterClients_changed(self, widget, args=[]):
print 'on_entFilterClients_changed called with self.%s' % widget.get_name()
self.clientesview.clear()
datos = self.db.filter(self.clients, 'clientes', 'nombre', self.widget.get_widget('entFilterClients').get_text()+'%')
print datos
for dato in datos:
self.clientesview.add(dato)
def on_btnCleanFilterClients_clicked(self, widget, args=[]):
print 'on_btnCleanFilterClients_clicked called with self.%s' % widget.get_name()
self.widget.get_widget('entFilterClients').set_text('')
def on_btnAddHistory_clicked(self, widget, args=[]):
print 'on_btnAddHistory_clicked called with self.%s' % widget.get_name()
def on_btnEditHistory_clicked(self, widget, args=[]):
print 'on_btnEditHistory_clicked called with self.%s' % widget.get_name()
def on_btnDelHistory_clicked(self, widget, args=[]):
print 'on_btnDelHistory_clicked called with self.%s' % widget.get_name()
def on_btnPrintHistory_clicked(self, widget, args=[]):
print 'on_btnPrintHistory_clicked called with self.%s' % widget.get_name()
def on_entFilterHistory_changed(self, widget, args=[]):
print 'on_entFilterHistory_changed called with self.%s' % widget.get_name()
def on_btnCleanFilterHistory_clicked(self, widget, args=[]):
print 'on_btnCleanFilterHistory_clicked called with self.%s' % widget.get_name()
def on_btnAddCredit_clicked(self, widget, args=[]):
print 'on_btnAddCredit_clicked called with self.%s' % widget.get_name()
def on_btnEditCredit_clicked(self, widget, args=[]):
print 'on_btnEditCredit_clicked called with self.%s' % widget.get_name()
def on_btnDelCredit_clicked(self, widget, args=[]):
print 'on_btnDelCredit_clicked called with self.%s' % widget.get_name()
def on_btnPrintCredit_clicked(self, widget, args=[]):
print 'on_btnPrintCredit_clicked called with self.%s' % widget.get_name()
def on_entFilterCredit_changed(self, widget, args=[]):
print 'on_entFilterCredit_changed called with self.%s' % widget.get_name()
def on_btnCleanFilterCredit_clicked(self, widget, args=[]):
print 'on_btnCleanFilterCredit_clicked called with self.%s' % widget.get_name()
def on_btnAddCashRegister_clicked(self, widget, args=[]):
print 'on_btnAddCashRegister_clicked called with self.%s' % widget.get_name()
def on_btnEditCashRegister_clicked(self, widget, args=[]):
print 'on_btnEditCashRegister_clicked called with self.%s' % widget.get_name()
def on_btnDelCashRegister_clicked(self, widget, args=[]):
print 'on_btnDelCashRegister_clicked called with self.%s' % widget.get_name()
def on_btnPrintCashRegister_clicked(self, widget, args=[]):
print 'on_btnPrintCashRegister_clicked called with self.%s' % widget.get_name()
def on_entFilterCashRegister_changed(self, widget, args=[]):
print 'on_entFilterCashRegister_changed called with self.%s' % widget.get_name()
def on_btnCleanFilterCashResgister_clicked(self, widget, args=[]):
print 'on_btnCleanFilterCashResgister_clicked called with self.%s' % widget.get_name()
def on_btnFamilias_clicked(self, widget, args=[]):
winfamily = winFamilys()
def on_btnEditBotonera_clicked(self, widget, args=[]):
botonera = Botonera()
class dlgNewTicket:
def __init__(self):
self.db = DBAccess()
self.clients = self.db.table_clients()
self.tickets = self.db.table_tickets()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgNewTicket')
self.dialognewticket = self.widget.get_widget('dlgNewTicket')
self.dialognewticket.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.combo = self.widget.get_widget('cmbOderTimeNewTicket')
self.widget.signal_autoconnect(self)
items = ['12:00', '12:15', '12:30', '12:45', '13:00', '13:15', \
'13:30', '13:45', '14:00', '14:15', '14:30', '14:45', \
'15:00', '15:15', '15:30']
self.MakeCombo(items)
self.idnewticket = self.widget.get_widget('entIdNewTicket')
self.entidclientnewticket = self.widget.get_widget('entIdClientNewTicket')
self.entnamenewticket = self.widget.get_widget('entNameNewTicket')
self.entaddressnewticket = self.widget.get_widget('entAddressNewTicket')
self.entphonenewticket = self.widget.get_widget('entPhoneNewTicket')
self.entoderhournewticket = self.widget.get_widget('entOrderHourNewTicket')
self.entdatenewticket = self.widget.get_widget('entDateNewTicket')
self.entcallhournewticket = self.widget.get_widget('entCallHourNewTicket')
self.checkcredit = self.widget.get_widget('checkCredit')
self.checkdelivery = self.widget.get_widget('checkDelivery')
self.checkordered = self.widget.get_widget('checkOrdered')
self.checkorderwithdrawn = self.widget.get_widget('checkOrderWithdrawn')
# self.entrys = ['entIdNewTicket',\
# 'entIdClientNewTicket', \
# 'entNameNewTicket',\
# 'entAddressNewTicket', \
# 'entPhoneNewTicket', \
# 'entOrderHourNewTicket', \
# 'entDateNewTicket', \
# 'entCallHourNewTicket', \
# 'checkCredit', \
# 'checkDelivery', \
# 'checkOrdered', \
# 'checkOrderWithdrawn']
# print self.entrys
self.clientesview = ClientesView(self)
self.scrollednewticket = self.widget.get_widget('scrolledNewTicket')
self.scrollednewticket.add(self.clientesview)
self.clientesview.set_size_request(400, 250)
for client in self.clients:
self.clientesview.add(client)
self.clientesview.show()
self.clientesview.connect('cursor-changed', self.update_entrys)
def NewTicket(self, boton, datos=None):
#TODO: fix write a function for don't repeat code
self.dialognewticket.set_title('Nuevo Pedido')
self.dialognewticket.add_buttons(gtk.STOCK_NEW, gtk.RESPONSE_OK , \
gtk.STOCK_OK, gtk.RESPONSE_ACCEPT, \
gtk.STOCK_CANCEL, gtk.RESPONSE_CANCEL)
currenttime = self.db.time(self.clients)
self.entcallhournewticket.set_text(str(currenttime))
currentdate = self.db.date(self.clients)
self.entdatenewticket.set_text(str(currentdate))
# for entry in self.entrys:
# self.widget.get_widget(entry).set_text('')
# pass
resultado = self.dialognewticket.run()
self.dialognewticket.hide()
if resultado == -3:
datos = []
datos.append(self.entidclientnewticket.get_text())
datos.append(self.entnamenewticket.get_text())
datos.append(self.entaddressnewticket.get_text())
datos.append(self.entphonenewticket.get_text())
datos.append(self.entoderhournewticket.get_text())
datos.append(self.entdatenewticket.get_text())
datos.append(self.entcallhournewticket.get_text())
if self.checkcredit.get_active():
datos.append(1)
else:
datos.append(0)
if self.checkdelivery.get_active():
datos.append(1)
else:
datos.append(0)
if self.checkordered.get_active():
datos.append(1)
else:
datos.append(0)
if self.checkorderwithdrawn.get_active():
datos.append(1)
else:
datos.append(0)
datos.append(0)
print datos
self.db.insert(self.tickets, None, datos[0], None, datos[4], datos[5], \
currenttime, datos[7], datos[8], datos[9], \
datos[10], datos[11])
row = self.db.get_last_insert(self.tickets)
searclients = self.clients.busqueda('clientes', 'id=%s' % (datos[0]))
if row[6]:
credito = gtk.STOCK_ADD
else:
credito = None
if row[7]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if row[8]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row = [row[0], credito, servicio, comanda, searclients[1], \
searclients[2], None, datos[4]]
print 'row is' % structured_row
return structured_row
if resultado == -5:
datos = []
datos.append(self.entnamenewticket.get_text())
datos.append(self.entaddressnewticket.get_text())
datos.append(self.entphonenewticket.get_text())
currentdate = self.db.date(self.clients)
self.db.insert(self.clients, None, datos[0], datos[1], datos[2], \
currentdate, currentdate)
row = self.db.get_last_insert(self.clients)
datos1 = []
datos1.append(row[0])
datos1.append(row[1])
datos1.append(row[2])
datos1.append(row[3])
datos1.append(self.entoderhournewticket.get_text())
datos1.append(self.entdatenewticket.get_text())
datos1.append(self.entcallhournewticket.get_text())
if self.checkcredit.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkdelivery.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkordered.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkorderwithdrawn.get_active():
datos1.append(1)
else:
datos1.append(0)
datos1.append(0)
print datos1
self.db.insert(self.tickets, None, row[0], None, datos1[4], datos1[5], \
currenttime, datos1[7], datos1[8], datos1[9], \
datos1[10], datos1[11])
row = self.db.get_last_insert(self.tickets)
searclients = self.clients.busqueda('clientes', 'id=%s' % (datos1[0]))
if row[6]:
credito = gtk.STOCK_ADD
else:
credito = None
if row[7]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if row[8]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row1 = [row[0], credito, servicio, comanda, searclients[1], \
searclients[2], None, datos1[4]]
print 'row is' % structured_row1
return structured_row1
def EditTicket(self, datos):
self.dialognewticket.set_title('Editar Pedido')
self.dialognewticket.add_buttons(gtk.STOCK_OK, gtk.RESPONSE_ACCEPT, \
gtk.STOCK_CANCEL, gtk.RESPONSE_CANCEL)
client = self.clients.busqueda('clientes', 'id=%s' % int(datos[1]))
self.idnewticket.set_text(str(datos[0]))
self.entidclientnewticket.set_text(str(client[0]))
self.entnamenewticket.set_text(client[1])
self.entaddressnewticket.set_text(client[2])
self.entphonenewticket.set_text(client[3])
self.entoderhournewticket.set_text(str(datos[3]))
self.entdatenewticket.set_text(str(datos[4]))
self.entcallhournewticket.set_text(str(datos[5]))
if datos[6] != 0:
self.checkcredit.set_active(True)
if datos[7] != 0:
self.checkdelivery.set_active(True)
if datos[8] != 0:
self.checkordered.set_active(True)
if datos[9] != 0:
self.checkorderwithdrawn.set_active(True)
resultado = self.dialognewticket.run()
self.dialognewticket.hide()
if resultado == -3:
datos1 = []
datos1.append(self.entidclientnewticket.get_text())
datos1.append(0)
datos1.append(self.entoderhournewticket.get_text())
datos1.append(self.entdatenewticket.get_text())
datos1.append(self.entcallhournewticket.get_text())
if self.checkcredit.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkdelivery.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkordered.get_active():
datos1.append(1)
else:
datos1.append(0)
if self.checkorderwithdrawn.get_active():
datos1.append(1)
else:
datos1.append(0)
datos1.append(datos[8])
print datos1
cells = "cliente_FK_id, caja_FK_id, hora, fecha, hora_llamada, \
credito, servicioadomicilio, comandaenviada, servido, oculto"
self.db.update(self.tickets, 'ticket', cells, datos1, "id=\"%s\"" % datos[0])
client = self.clients.busqueda('clientes', 'id=%s' % datos1[0])
if datos1[5]:
credito = gtk.STOCK_ADD
else:
credito = None
if datos1[6]:
servicio = gtk.STOCK_DIALOG_WARNING
else:
servicio = None
if datos1[7]:
comanda = gtk.STOCK_APPLY
else:
comanda = None
structured_row1 = [datos1[0], credito, servicio, comanda, client[1], \
client[2], None, datos1[2]]
return structured_row1
def on_tglNameNewTicket_toggled(self, widget, args=[]):
print 'on_tglNameNewTicket_toggled called with self.%s' % widget.get_name()
self.clientesview.clear()
datos = self.db.filter(self.clients, 'clientes', 'nombre', \
self.entnamenewticket. \
get_text()+'%')
print datos
for dato in datos:
self.clientesview.add(dato)
def on_tglAddressNewTicket_toggled(self, widget, args=[]):
print 'on_tglAddressNewTicket_toggled called with self.%s' % widget.get_name()
self.clientesview.clear()
datos = self.db.filter(self.clients, 'clientes', 'direccion', \
self.entaddressnewticket. \
get_text()+'%')
print datos
for dato in datos:
self.clientesview.add(dato)
def on_tglPhoneNewTicket_toggled(self, widget, args=[]):
print 'on_tglPhoneNewTicket_toggled called with self.%s' % widget.get_name()
self.clientesview.clear()
datos = self.db.filter(self.clients, 'clientes', 'telefono', \
self.entphonenewticket. \
get_text()+'%')
print datos
for dato in datos:
self.clientesview.add(dato)
def on_btnShowCalendar_clicked(self, widget):
print 'on_btnShowCalendar_clicked called with self.%s' % widget.get_name()
dlgcalendar = dlgCalendar(self).newDate(self)
if dlgcalendar:
self.entdatenewticket.set_text(dlgcalendar)
def update_entrys(self, widget):
print 'on_update_entrys called with self.%s' % widget.get_name()
id = self.clientesview.getSelectedItem(0)
nombre = self.clientesview.getSelectedItem(1)
direccion = self.clientesview.getSelectedItem(2)
telefono = self.clientesview.getSelectedItem(3)
self.entidclientnewticket.set_text(str(id))
self.entnamenewticket.set_text(nombre)
self.entaddressnewticket.set_text(direccion)
self.entphonenewticket.set_text(telefono)
def MakeCombo(self, items):
"""Setup a ComboBox or ComboBoxEntry based on a list of strings."""
model = gtk.ListStore(str)
for i in items:
model.append([i])
self.combo.set_model(model)
if type(self.combo) == gtk.ComboBoxEntry:
self.combo.set_text_column(0)
elif type(self.combo) == gtk.ComboBox:
cell = gtk.CellRendererText()
self.combo.pack_start(cell, False)
self.combo.add_attribute(cell, 'text', 0)
cell1 = gtk.CellRendererText()
self.combo.pack_start(cell1, True)
self.combo.add_attribute(cell1, 'text', 1)
class Botonera:
def __init__(self):
self.db = DBAccess()
self.botonera = self.db.table_botonera()
self.pages_botonera = self.db.table_pages_botonera()
self.sort_pages_botonera = self.db.ordenar(self.pages_botonera, 'id_page')
self.articulos = self.db.table_articles()
self.widget = gtk.glade.XML('pytpv.glade', 'winBotonera')
self.winbotonera = self.widget.get_widget('winBotonera')
self.winbotonera.set_title('Configurar Botonera')
self.winbotonera.set_icon_from_file('images' + os.sep + 'yinyang.png')
vbox = self.widget.get_widget('vbox13')
self.winbotonera.show()
self.widget.signal_autoconnect(self)
self.notebook = gtk.Notebook()
data_botonera = []
for item in self.botonera:
data_botonera.append(item)
data_articulos = []
for item in self.articulos:
data_articulos.append(item)
vbox.pack_start(self.notebook)
a = 0
c = 0
r = 0
aopt = gtk.FILL|gtk.SHRINK
for page in self.sort_pages_botonera:
label = gtk.Label(page[1])
label.set_padding(15, 15)
self.table = gtk.Table(6, 6)
self.notebook.append_page(self.table, label)
for x in range(36):
button = MakeButton(data_botonera[a][5])
print "button %s" % a
# button.set_data("id", (a+1))
button.set_data("id", data_botonera[a][0])
button.connect("clicked", self.clicked, button.get_data("id"))
button.set_size_request(100, 100)
# if button.get_label() is None:
# button.set_sensitive(False)
self.notebook.get_nth_page(page[2]).attach(button, c, \
c+1, r, \
r+1, aopt, aopt, 0, 0)
a += 1
c += 1
if c == 6:
c = 0
r += 1
if r == 6:
r = 0
self.winbotonera.show_all()
def clicked(self, button, data):
page = self.notebook.get_current_page()
self.articles = self.db.table_articles()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgEditButton')
self.dlgeditbutton = self.widget.get_widget('dlgEditButton')
self.dlgeditbutton.set_title('Editar Botón')
self.dlgeditbutton.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.scrolledbotonera = self.widget.get_widget('scrolledbotonera')
self.articlesview = ArticulosView(self)
self.scrolledbotonera.add(self.articlesview)
for article in self.articles:
self.articlesview.add(article)
self.articlesview.show_all()
self.entrys = ['entIdArticleButton', 'entLabelButton']
resultado = self.dlgeditbutton.run()
self.dlgeditbutton.hide()
if resultado == -3:
#for entry in self.entrys:
datos = []
it = self.articlesview.getSelectedItem(0)
datos.append(int(it))
for entry in self.entrys[1:]:
datos.append(self.widget.get_widget(entry).get_text())
print datos
cells = "article_FK_Id, label_button"
self.db.update(self.botonera, 'botonera', cells, datos, "id=\"%s\"" \
%int(button.get_data("id")))
def on_btnAddPageNotebook_clicked(self, widget, args=[]):
self.widget = gtk.glade.XML('pytpv.glade', 'dlgAddPage')
self.dlgaddpage = self.widget.get_widget('dlgAddPage')
self.dlgaddpage.set_title('Nueva Pestaña')
self.dlgaddpage.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entNamePageNotebook']
resultado = self.dlgaddpage.run()
self.dlgaddpage.hide()
if resultado == -3:
table = MakeTable(6, 6)
table.show_all()
c = 0
r = 0
for entry in self.entrys:
label = gtk.Label(self.widget.get_widget(entry).get_text())
label.set_padding(0, 15)
self.notebook.append_page(table, label)
aopt = gtk.FILL|gtk.SHRINK
for x in range(36):
label2 = "r=%s,c=%d" % (r, c)
button = MakeButton(label2)
button.connect("clicked", self.clicked)
button.set_data("row", (r))
button.set_data("col", (c))
button.set_size_request(100, 100)
button.show()
self.notebook.get_nth_page(0).attach(button, c, c+1, r, \
r+1, aopt, aopt, 0, 0)
c += 1
if c == 6:
c = 0
r += 1
if r == 6:
r = 0
linea = self.pages_botonera.max_value('id_page', 'pages_botonera')
linea += 1
self.db.insert(self.botonera, None, linea, r, c, None, None)
pages = self.notebook.get_n_pages() - 1
print pages
self.db.insert(self.pages_botonera, None, \
self.widget.get_widget(entry).get_text(), linea)
self.winbotonera.show_all()
def on_btnEditPageNoteBook_clicked(self, widget, args=[]):
print 'on_btnEditPageNotebook_clicked called with self.%s' % widget.get_name()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgAddPage')
self.dlgaddpage = self.widget.get_widget('dlgAddPage')
self.dlgaddpage.set_title('Editar Pestaña')
self.dlgaddpage.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entNamePageNotebook']
resultado = self.dlgaddpage.run()
self.dlgaddpage.hide()
if resultado == -3:
child = self.notebook.get_children()
index = self.notebook.get_current_page()
label = gtk.Label(self.widget.get_widget(self.entrys[0]).get_text())
self.notebook.set_tab_label(child[index], label)
label.set_padding(15, 15)
searchpagebotonera = self.pages_botonera.busqueda('pages_botonera', \
'id_page=%s' % index)
cells = "label_page, id_page"
datos = []
datos.append(label.get_text())
datos.append(searchpagebotonera[2])
self.db.update(self.pages_botonera , 'pages_botonera', cells, datos, \
"id_page=\"%s\"" % index)
def on_btnDelPageNotebook_clicked(self, widget, args=[]):
print 'on_btnDelPageNotebook_clicked called with self.%s' % widget.get_name()
index = self.notebook.get_current_page()
filterbotonera = self.db.filter(self.botonera, 'botonera', 'botonera_FK_id', index)
if index:
for row in filterbotonera:
self.db.remove(self.botonera, "botonera_FK_id=\"%s\"" % index)
self.notebook.remove_page(index)
self.db.remove(self.pages_botonera, "id_page=\"%s\"" % index)
count = self.pages_botonera.count('pages_botonera')
print count
datos = []
for row in self.pages_botonera:
datos.append(row)
a = 0
for n in range(count):
print 'COUNT IS %d:' % n
cells = "label_page, id_page"
values = [datos[a][1], n]
self.db.update(self.pages_botonera, 'pages_botonera', cells, \
values, "id=\"%s\"" % datos[a][0])
a += 1
a = 0
datos = []
prueba = self.botonera.search('botonera', "botonera_FK_id>%s" % index)
for row in prueba:
datos.append(row)
cells = 'botonera_FK_id, row'
index = datos[a][1] - 1
values = [index, datos[a][2]]
self.db.update(self.botonera, 'botonera', cells, values, "id=\"%s\"" % datos[a][0])
a +=1
class dlgArticles:
def __init__(self):
self.db = DBAccess()
self.articles = self.db.table_articles()
self.family = self.db.table_family()
items = []
for row in self.family:
items.append(row)
self.widget = gtk.glade.XML('pytpv.glade', 'dlgArticles')
self.dialogarticles = self.widget.get_widget('dlgArticles')
self.dialogarticles.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.combo = self.widget.get_widget('cmbFamilyArticle')
self.MakeCombo(items)
self.entrys = ['entIdArticle', \
'cmbFamilyArticle', \
'entDescriptionArticle', \
'entStockArticle', \
'entMinStockArticle', \
'entSalePriceArticle', \
'entImageArticle']
self.widget.signal_autoconnect(self)
def MakeCombo(self, items):
"""Setup a ComboBox or ComboBoxEntry based on a list of strings."""
model = gtk.ListStore(str, str)
for i, k, j in items:
model.append([i] + [k])
self.combo.set_model(model)
if type(self.combo) == gtk.ComboBoxEntry:
self.combo.set_text_column(0)
elif type(self.combo) == gtk.ComboBox:
cell = gtk.CellRendererText()
self.combo.pack_start(cell, False)
self.combo.add_attribute(cell, 'text', 0)
cell1 = gtk.CellRendererText()
self.combo.pack_start(cell1, True)
self.combo.add_attribute(cell1, 'text', 1)
def on_cmbFamilyArticle_changed(self, widget):
model = self.combo.get_model()
m_iter = self.combo.get_active_iter()
if m_iter:
print model.get_value(m_iter, 0)
return model.get_value(m_iter, 0)
else:
return 0
def NewArticle(self, boton, datos=None):
self.dialogarticles.set_title('Nuevo Articulo')
for entry in self.entrys:
print entry
if not entry == 'cmbFamilyArticle':
self.widget.get_widget(entry).set_text('')
resultado = self.dialogarticles.run()
self.dialogarticles.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:]:
if entry != 'cmbFamilyArticle':
datos.append(self.widget.get_widget(entry).get_text())
if entry == 'cmbFamilyArticle':
combo = self.on_cmbFamilyArticle_changed(self)
print combo
datos.append(combo)
#datos.append(self.widget.get_widget(entry).get_active_text())
print datos
# lo meto en la base de datos
self.db.insert(self.articles, None, datos[0], datos[1], \
float(datos[2]), float(datos[3]), \
float(datos[4]), datos[5])
row = self.db.get_last_insert(self.articles)
familyname = self.family.busqueda('familia', 'id=%s' % (datos[0]))
print familyname
row = row[0], familyname[1], row[2], ("%0.2f" %row[3]), \
("%0.2f" %row[4]), ("%0.2f" %row[5]), row[6]
print row
return row
def EditArticle(self, item):
self.dialogarticles.set_title('Editar Articulo')
searcharticles = self.articles.busqueda('articulos', 'id=%s' % (item[0]))
searchfamily = self.family.busqueda('familia', 'id=%s' % (searcharticles[1]))
a = 0
for entry in self.entrys:
if not entry == 'cmbFamilyArticle':
it = item[a]
print it
if it != None:
self.widget.get_widget(entry).set_text(str(it))
elif it == None:
self.widget.get_widget(entry).set_text("")
if entry == 'cmbFamilyArticle':
self.widget.get_widget(entry).set_active(int(searchfamily[0])-1)
a += 1
resultado = self.dialogarticles.run()
self.dialogarticles.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:]:
if entry == 'cmbFamilyArticle':
combo = self.on_cmbFamilyArticle_changed(self)
datos.append(combo)
else:
datos.append(self.widget.get_widget(entry).get_text())
#print datos
cells = "familia_FK_id, descripcion, stock, stock_minimo, \
precio_venta, imagen"
self.db.update(self.articles, 'articulos', cells, datos, \
"id=\"%s\"" % item[0])
datos = []
for entry in self.entrys:
if entry == 'entIdArticle':
datos.append(self.widget.get_widget(entry).get_text())
# if not entry == 'cmbFamilyArticle':
# datos.append(self.widget.get_widget(entry).get_text())
if entry == 'cmbFamilyArticle':
searchfamily = self.family.busqueda('familia', 'id=%s' % \
(self.on_cmbFamilyArticle_changed(self)))
datos.append(searchfamily[1])
if entry == 'entDescriptionArticle':
datos.append(self.widget.get_widget(entry).get_text())
if entry == 'entStockArticle':
a = float(self.widget.get_widget(entry).get_text())
datos.append("%0.2f" %a)
if entry == 'entMinStockArticle':
a = float(self.widget.get_widget(entry).get_text())
datos.append("%0.2f" %a)
if entry == 'entSalePriceArticle':
a = float(self.widget.get_widget(entry).get_text())
datos.append("%0.2f" %a)
if entry == 'entImageArticle':
datos.append(self.widget.get_widget(entry).get_text())
print datos
return datos
def on_filechooserbutton1_file_set(self, widget, args=[]):
print 'on_filechooserbutton1_file_set called with self.%s' % widget.get_name()
c1 = self.widget.get_widget("filechoose").get_filename()
c2 = self.widget.get_widget("entImageArticle")
if c1:
c2.set_text(c1)
class dlgClients:
def __init__(self):
self.db = DBAccess()
self.clients = self.db.table_clients()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgClients')
self.dialogclient = self.widget.get_widget('dlgClients')
self.dialogclient.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entIdClient',\
'entNameClient', \
'entAddressClient',\
'entPhoneClient', \
'entDateClient', \
'entLastBuyClient']
def NewClient(self, boton, datos=None):
self.dialogclient.set_title('Nuevo Cliente')
for entry in self.entrys:
self.widget.get_widget(entry).set_text('')
resultado = self.dialogclient.run()
self.dialogclient.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:]:
datos.append(self.widget.get_widget(entry).get_text())
print datos
# lo meto en la base de datos
currentdate = self.db.date(self.clients)
print "fecha de hoy es %s" % currentdate
self.db.insert(self.clients, None, datos[0], datos[1], datos[2],\
currentdate, None)
row = self.db.get_last_insert(self.clients)
print row
return row
def EditClient(self, item):
self.dialogclient.set_title('Editar Cliente')
a = 0
for entry in self.entrys:
it = item[a]
#print it
if it != None:
if entry == 'entIdClient':
self.widget.get_widget(entry).set_text(str(it))
else:
self.widget.get_widget(entry).set_text(it)
elif it == None:
self.widget.get_widget(entry).set_text("")
a += 1
resultado = self.dialogclient.run()
self.dialogclient.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:-1]:
datos.append(self.widget.get_widget(entry).get_text())
#print datos
cells = "nombre, direccion, telefono, fecha_alta"
self.db.update(self.clients, 'clientes', cells, datos, "id=\"%s\"" \
%item[0])
datos = []
for entry in self.entrys:
text = self.widget.get_widget(entry).get_text()
datos.append(text)
return datos
class dlgFamilys:
def __init__(self):
self.db = DBAccess()
self.family = self.db.table_family()
self.widget = gtk.glade.XML('pytpv.glade', 'dlgFamilys')
self.dlgfamily = self.widget.get_widget('dlgFamilys')
self.dlgfamily.set_icon_from_file('images'+ os.sep +'yinyang.png')
self.entrys = ['entIdFamily', \
'entNameFamily', \
'entDescriptionFamily']
self.widget.signal_autoconnect(self)
def NewFamily(self, widget, datos=None):
self.dlgfamily.set_title('Nueva Familia')
for entry in self.entrys:
self.widget.get_widget(entry).set_text('')
resultado = self.dlgfamily.run()
self.dlgfamily.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:]:
datos.append(self.widget.get_widget(entry).get_text())
print datos
# lo meto en la base de datos
self.db.insert(self.family, None, datos[0], datos[1])
row = self.db.get_last_insert(self.family)
print row
return row
def EditFamily(self, item):
self.dlgfamily.set_title('Editar Familia')
a = 0
for entry in self.entrys:
it = item[a]
#print it
if it != None:
if entry == 'entIdFamily':
self.widget.get_widget(entry).set_text(str(it))
else:
self.widget.get_widget(entry).set_text(it)
elif it == None:
self.widget.get_widget(entry).set_text("")
a += 1
resultado = self.dlgfamily.run()
self.dlgfamily.hide()
if resultado == -3:
datos = []
for entry in self.entrys[1:]:
datos.append(self.widget.get_widget(entry).get_text())
#print datos
cells = "nombre, descripcion"
self.db.update(self.family, 'familia', cells, datos, "id=\"%s\"" \
%item[0])
datos = []
for entry in self.entrys:
text = self.widget.get_widget(entry).get_text()
datos.append(text)
return datos