Exemple #1
0
 def inicializarDatos(self, tabla):
     self.updateFechas()
     documentos = DBController.obtenerLista(tabla.objectName(), None, None, None)
     tabla.setRowCount(len(documentos))
     for i in range(len(documentos)):
         for j in range(len(documentos[i])):
             item = QtGui.QTableWidgetItem()
             item.setText(documentos[i][j])
             item.setTextAlignment(QtCore.Qt.AlignHCenter|QtCore.Qt.AlignVCenter|QtCore.Qt.AlignCenter)
             tabla.setItem(i, j, item) # QtGui.QTableWidgetItem(documentos[i][j])
     for i in range(tabla.verticalHeader().count()):
         tabla.verticalHeader().setResizeMode(i, QtGui.QHeaderView.Fixed)
     tabla.setColumnHidden(tabla.horizontalHeader().count()-1, True)
Exemple #2
0
    def filtrar(self, data):
        if(self.ui.filtrarEmpresaComboBox.currentIndex() == 0):
            self.ui.editarEmpresaToolButton.setEnabled(False)
        else:
            self.ui.editarEmpresaToolButton.setEnabled(True)
        tablas = [self.ui.tableWidget_Compras, self.ui.tableWidget_Ventas]
        f = self.fechas[self.ui.fechaComboBox.currentIndex()]
        if data != "":
            for tabla in tablas:
                documentos = DBController.obtenerLista(tabla.objectName(), unicode(self.empresas[data][0]), f[1], f[2])

                tabla.clearContents()
                tabla.setRowCount(len(documentos))
                for i in range(len(documentos)):
                    for j in range(len(documentos[i])):
                        item = QtGui.QTableWidgetItem()
                        item.setText(documentos[i][j])
                        item.setTextAlignment(QtCore.Qt.AlignHCenter|QtCore.Qt.AlignVCenter|QtCore.Qt.AlignCenter)
                        tabla.setItem(i, j, item) # QtGui.QTableWidgetItem(documentos[i][j])
                tabla.verticalHeader().setVisible(True)
                tabla.resizeColumnsToContents()