def cargar_grid(self): """función que muestra los empleados de un local en específico, usando su id_local""" empleados = c.obtener_empleados_por_local(self.ui.idlocal.text()) #Creamos el modelo asociado a la tabla self.model = QtGui.QStandardItemModel(len(empleados), 6) self.model.setHorizontalHeaderItem(0, QtGui.QStandardItem(u"RUT")) self.model.setHorizontalHeaderItem(1, QtGui.QStandardItem(u"Nombre")) self.model.setHorizontalHeaderItem(2, QtGui.QStandardItem(u"Cargo")) self.model.setHorizontalHeaderItem(3, QtGui.QStandardItem(u"Genero")) self.model.setHorizontalHeaderItem(4, QtGui.QStandardItem(u"Sueldo")) self.model.setHorizontalHeaderItem(5, QtGui.QStandardItem(u"local")) r = 0 for row in empleados: #print row index = self.model.index(r, 0, QtCore.QModelIndex()) self.model.setData(index, row[0]) index = self.model.index(r, 1, QtCore.QModelIndex()) self.model.setData(index, row[1]) index = self.model.index(r, 2, QtCore.QModelIndex()) self.model.setData(index, row[2]) index = self.model.index(r, 3, QtCore.QModelIndex()) self.model.setData(index, row[3]) index = self.model.index(r, 4, QtCore.QModelIndex()) self.model.setData(index, row[4]) index = self.model.index(r, 5, QtCore.QModelIndex()) self.model.setData(index, row[5]) r = r+1 self.ui.tableView.setModel(self.model) self.ui.tableView.setColumnWidth(0, 120) self.ui.tableView.setColumnWidth(1, 120) self.ui.tableView.setColumnWidth(2, 120) self.ui.tableView.setColumnWidth(3, 120) self.ui.tableView.setColumnWidth(4, 120) self.ui.tableView.setColumnWidth(5, 120)
def load_datos(self, locales=None):
"""función que carga todos los locales en la ventana principal"""
if locales is None:
locales = controller_local.get_locales()
self.model = QtGui.QStandardItemModel(len(locales), 7)
self.model.setHorizontalHeaderItem(0, QtGui.QStandardItem(u"id_local"))
self.model.setHorizontalHeaderItem(1, QtGui.QStandardItem(u"Nombre"))
self.model.setHorizontalHeaderItem(2, QtGui.QStandardItem(u"Direccion"))
self.model.setHorizontalHeaderItem(3, QtGui.QStandardItem(u"Ciudad"))
self.model.setHorizontalHeaderItem(4, QtGui.QStandardItem(u"N° empleados"))
self.model.setHorizontalHeaderItem(5, QtGui.QStandardItem(u"hombres"))
self.model.setHorizontalHeaderItem(6, QtGui.QStandardItem(u"mujeres"))
r = 0
for row in locales:
index = self.model.index(r, 0, QtCore.QModelIndex());
self.model.setData(index, row['id_local'])
index = self.model.index(r, 1, QtCore.QModelIndex());
self.model.setData(index, row['nombre'])
index = self.model.index(r, 2, QtCore.QModelIndex());
self.model.setData(index, row['direccion'])
index = self.model.index(r, 3, QtCore.QModelIndex());
self.model.setData(index, row['ciudad'])
index = self.model.index(r, 4, QtCore.QModelIndex());
empleados = c.obtener_empleados_por_local(row['id_local'])
self.model.setData(index, len(empleados));
index = self.model.index(r, 5, QtCore.QModelIndex());
self.model.setData(index, c.obtener_hombres(row['id_local']))
index = self.model.index(r, 6, QtCore.QModelIndex());
self.model.setData(index, c.obtener_mujeres(row['id_local']))
r = r+1
self.ui.table_win.setModel(self.model)
self.ui.table_win.setColumnWidth(1, 200)
self.ui.table_win.setColumnWidth(2, 300)
self.ui.table_win.setColumnWidth(3, 140)
self.ui.table_win.setColumnWidth(4, 100)
self.ui.table_win.setColumnWidth(5, 80)
self.ui.table_win.setColumnWidth(6, 80)
self.ui.table_win.hideColumn(0)
self.update_search()