def __init__(self, establecimiento=None, mes=None, anho=None): 'Constructor de la clase' QtGui.QMainWindow.__init__(self) self.ui = Ui_MainWindow() self.establecimiento = establecimiento self.mes = mes self.anho = int(anho) self.ui.setupUi(self) self.setSignals() self.cargarDatos() self.show()
class registroCargadoWindow(QtGui.QMainWindow): def __init__(self, establecimiento=None, mes=None, anho=None): 'Constructor de la clase' QtGui.QMainWindow.__init__(self) self.ui = Ui_MainWindow() self.establecimiento = establecimiento self.mes = mes self.anho = int(anho) self.ui.setupUi(self) self.setSignals() self.cargarDatos() self.show() def setSignals(self): 'Eventos de los elementos de la ventana principal' self.ui.button_ingresar.clicked.connect(self.aceptarIngreso) self.ui.button_cancelar.clicked.connect(self.close) def cargarDatos(self): """ Se cargan los datos desde la base correspondiende a la planilla ingresada. """ idEstablecimiento = controller.obtenerIdEstablecimiento(self.establecimiento) tabla1 = controller.obtenerTabla1(idEstablecimiento,self.mes,self.anho) tabla2 = controller.obtenerTabla2(idEstablecimiento,self.mes,self.anho) tabla3 = controller.obtenerTabla3(idEstablecimiento,self.mes,self.anho) tabla4 = controller.obtenerTabla4(idEstablecimiento,self.mes,self.anho) #DATOS PRIMERA TABLA - BASICO #FILA1 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m0_2)) self.ui.tableWidget.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m3_5)) self.ui.tableWidget.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m6_11)) self.ui.tableWidget.setItem(0,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m12_17)) self.ui.tableWidget.setItem(0,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m18_23)) self.ui.tableWidget.setItem(0,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m24_47)) self.ui.tableWidget.setItem(0,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].m48_71)) self.ui.tableWidget.setItem(0,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].NSO)) self.ui.tableWidget.setItem(0,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].BP)) self.ui.tableWidget.setItem(0,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].LME)) self.ui.tableWidget.setItem(0,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].LMP)) self.ui.tableWidget.setItem(0,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[0].FPE)) self.ui.tableWidget.setItem(0,11,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m0_2)) self.ui.tableWidget.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m3_5)) self.ui.tableWidget.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m6_11)) self.ui.tableWidget.setItem(1,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m12_17)) self.ui.tableWidget.setItem(1,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m18_23)) self.ui.tableWidget.setItem(1,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m24_47)) self.ui.tableWidget.setItem(1,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].m48_71)) self.ui.tableWidget.setItem(1,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].NSO)) self.ui.tableWidget.setItem(1,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].BP)) self.ui.tableWidget.setItem(1,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].LME)) self.ui.tableWidget.setItem(1,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].LMP)) self.ui.tableWidget.setItem(1,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[1].FPE)) self.ui.tableWidget.setItem(1,11,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m0_2)) self.ui.tableWidget.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m3_5)) self.ui.tableWidget.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m6_11)) self.ui.tableWidget.setItem(2,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m12_17)) self.ui.tableWidget.setItem(2,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m18_23)) self.ui.tableWidget.setItem(2,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m24_47)) self.ui.tableWidget.setItem(2,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].m48_71)) self.ui.tableWidget.setItem(2,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].NSO)) self.ui.tableWidget.setItem(2,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].BP)) self.ui.tableWidget.setItem(2,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].LME)) self.ui.tableWidget.setItem(2,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].LMP)) self.ui.tableWidget.setItem(2,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[2].FPE)) self.ui.tableWidget.setItem(2,11,item) #DATOS SEGUNDA TABLA - REFUERZO 1 #FILA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m0_2)) self.ui.tableWidget_3.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m3_5)) self.ui.tableWidget_3.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m6_11)) self.ui.tableWidget_3.setItem(0,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m12_17)) self.ui.tableWidget_3.setItem(0,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m18_23)) self.ui.tableWidget_3.setItem(0,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m24_47)) self.ui.tableWidget_3.setItem(0,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].m48_71)) self.ui.tableWidget_3.setItem(0,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].NSO)) self.ui.tableWidget_3.setItem(0,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].BP)) self.ui.tableWidget_3.setItem(0,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].LME)) self.ui.tableWidget_3.setItem(0,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].LMP)) self.ui.tableWidget_3.setItem(0,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[3].FPE)) self.ui.tableWidget_3.setItem(0,11,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m0_2)) self.ui.tableWidget_3.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m3_5)) self.ui.tableWidget_3.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m6_11)) self.ui.tableWidget_3.setItem(1,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m12_17)) self.ui.tableWidget_3.setItem(1,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m18_23)) self.ui.tableWidget_3.setItem(1,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m24_47)) self.ui.tableWidget_3.setItem(1,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].m48_71)) self.ui.tableWidget_3.setItem(1,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].NSO)) self.ui.tableWidget_3.setItem(1,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].BP)) self.ui.tableWidget_3.setItem(1,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].LME)) self.ui.tableWidget_3.setItem(1,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].LMP)) self.ui.tableWidget_3.setItem(1,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[4].FPE)) self.ui.tableWidget_3.setItem(1,11,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m0_2)) self.ui.tableWidget_3.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m3_5)) self.ui.tableWidget_3.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m6_11)) self.ui.tableWidget_3.setItem(2,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m12_17)) self.ui.tableWidget_3.setItem(2,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m18_23)) self.ui.tableWidget_3.setItem(2,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m24_47)) self.ui.tableWidget_3.setItem(2,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].m48_71)) self.ui.tableWidget_3.setItem(2,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].NSO)) self.ui.tableWidget_3.setItem(2,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].BP)) self.ui.tableWidget_3.setItem(2,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].LME)) self.ui.tableWidget_3.setItem(2,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].LMP)) self.ui.tableWidget_3.setItem(2,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[5].FPE)) self.ui.tableWidget_3.setItem(2,11,item) #FILA 4 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m0_2)) self.ui.tableWidget_3.setItem(3,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m3_5)) self.ui.tableWidget_3.setItem(3,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m6_11)) self.ui.tableWidget_3.setItem(3,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m12_17)) self.ui.tableWidget_3.setItem(3,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m18_23)) self.ui.tableWidget_3.setItem(3,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m24_47)) self.ui.tableWidget_3.setItem(3,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].m48_71)) self.ui.tableWidget_3.setItem(3,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].NSO)) self.ui.tableWidget_3.setItem(3,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].BP)) self.ui.tableWidget_3.setItem(3,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].LME)) self.ui.tableWidget_3.setItem(3,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].LMP)) self.ui.tableWidget_3.setItem(3,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[6].FPE)) self.ui.tableWidget_3.setItem(3,11,item) #DATOS TERCERA TABLA - REFUERZO 2 #FILA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m0_2)) self.ui.tableWidget_4.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m3_5)) self.ui.tableWidget_4.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m6_11)) self.ui.tableWidget_4.setItem(0,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m12_17)) self.ui.tableWidget_4.setItem(0,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m18_23)) self.ui.tableWidget_4.setItem(0,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m24_47)) self.ui.tableWidget_4.setItem(0,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].m48_71)) self.ui.tableWidget_4.setItem(0,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].NSO)) self.ui.tableWidget_4.setItem(0,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].BP)) self.ui.tableWidget_4.setItem(0,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].LME)) self.ui.tableWidget_4.setItem(0,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].LMP)) self.ui.tableWidget_4.setItem(0,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[7].FPE)) self.ui.tableWidget_4.setItem(0,11,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m0_2)) self.ui.tableWidget_4.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m3_5)) self.ui.tableWidget_4.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m6_11)) self.ui.tableWidget_4.setItem(1,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m12_17)) self.ui.tableWidget_4.setItem(1,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m18_23)) self.ui.tableWidget_4.setItem(1,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m24_47)) self.ui.tableWidget_4.setItem(1,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].m48_71)) self.ui.tableWidget_4.setItem(1,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].NSO)) self.ui.tableWidget_4.setItem(1,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].BP)) self.ui.tableWidget_4.setItem(1,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].LME)) self.ui.tableWidget_4.setItem(1,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].LMP)) self.ui.tableWidget_4.setItem(1,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[8].FPE)) self.ui.tableWidget_4.setItem(1,11,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m0_2)) self.ui.tableWidget_4.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m3_5)) self.ui.tableWidget_4.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m6_11)) self.ui.tableWidget_4.setItem(2,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m12_17)) self.ui.tableWidget_4.setItem(2,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m18_23)) self.ui.tableWidget_4.setItem(2,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m24_47)) self.ui.tableWidget_4.setItem(2,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].m48_71)) self.ui.tableWidget_4.setItem(2,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].NSO)) self.ui.tableWidget_4.setItem(2,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].BP)) self.ui.tableWidget_4.setItem(2,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].LME)) self.ui.tableWidget_4.setItem(2,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].LMP)) self.ui.tableWidget_4.setItem(2,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla1[9].FPE)) self.ui.tableWidget_4.setItem(2,11,item) #DATOS CUARTA TABLA - PERSONAS BENEFICIADAS #FILA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m0_2)) self.ui.tableWidget_5.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m3_5)) self.ui.tableWidget_5.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m6_11)) self.ui.tableWidget_5.setItem(0,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m12_17)) self.ui.tableWidget_5.setItem(0,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m18_23)) self.ui.tableWidget_5.setItem(0,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m24_47)) self.ui.tableWidget_5.setItem(0,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].m48_71)) self.ui.tableWidget_5.setItem(0,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].NSO)) self.ui.tableWidget_5.setItem(0,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].BP)) self.ui.tableWidget_5.setItem(0,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].LME)) self.ui.tableWidget_5.setItem(0,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].LMP)) self.ui.tableWidget_5.setItem(0,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[0].FPE)) self.ui.tableWidget_5.setItem(0,11,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m0_2)) self.ui.tableWidget_5.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m3_5)) self.ui.tableWidget_5.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m6_11)) self.ui.tableWidget_5.setItem(1,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m12_17)) self.ui.tableWidget_5.setItem(1,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m18_23)) self.ui.tableWidget_5.setItem(1,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m24_47)) self.ui.tableWidget_5.setItem(1,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].m48_71)) self.ui.tableWidget_5.setItem(1,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].NSO)) self.ui.tableWidget_5.setItem(1,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].BP)) self.ui.tableWidget_5.setItem(1,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].LME)) self.ui.tableWidget_5.setItem(1,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].LMP)) self.ui.tableWidget_5.setItem(1,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[1].FPE)) self.ui.tableWidget_5.setItem(1,11,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m0_2)) self.ui.tableWidget_5.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m3_5)) self.ui.tableWidget_5.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m6_11)) self.ui.tableWidget_5.setItem(2,2,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m12_17)) self.ui.tableWidget_5.setItem(2,3,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m18_23)) self.ui.tableWidget_5.setItem(2,4,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m24_47)) self.ui.tableWidget_5.setItem(2,5,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].m48_71)) self.ui.tableWidget_5.setItem(2,6,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].NSO)) self.ui.tableWidget_5.setItem(2,7,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].BP)) self.ui.tableWidget_5.setItem(2,8,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].LME)) self.ui.tableWidget_5.setItem(2,9,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].LMP)) self.ui.tableWidget_5.setItem(2,10,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla2[2].FPE)) self.ui.tableWidget_5.setItem(2,11,item) #DATOS QUINTA TABLA - ADULTO MAYOR KILOS #COLUMNA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla3[0].mas_70)) self.ui.tableWidget_2.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[0].chile_solidario)) self.ui.tableWidget_2.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[0].mas_65)) self.ui.tableWidget_2.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[0].mas_60)) self.ui.tableWidget_2.setItem(3,0,item) #COLUMNA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla3[1].mas_70)) self.ui.tableWidget_2.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[1].chile_solidario)) self.ui.tableWidget_2.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[1].mas_65)) self.ui.tableWidget_2.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla3[1].mas_60)) self.ui.tableWidget_2.setItem(3,1,item) #DATOS SEXTA TABLA - PERSONAS BENEFICIADAS CAD #FILA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_70_1)) self.ui.tableWidget_7.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_70_2)) self.ui.tableWidget_7.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_70_3)) self.ui.tableWidget_7.setItem(0,2,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].chile_solidario_1)) self.ui.tableWidget_7.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].chile_solidario_2)) self.ui.tableWidget_7.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].chile_solidario_3)) self.ui.tableWidget_7.setItem(1,2,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_65_1)) self.ui.tableWidget_7.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_65_2)) self.ui.tableWidget_7.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_65_3)) self.ui.tableWidget_7.setItem(2,2,item) #FILA 4 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_60_1)) self.ui.tableWidget_7.setItem(3,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_60_2)) self.ui.tableWidget_7.setItem(3,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[0].mas_60_3)) self.ui.tableWidget_7.setItem(3,2,item) #DATOS SEPTIMA TABLA - PERSONAS BENEFICIADAS BL #FILA 1 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_70_1)) self.ui.tableWidget_6.setItem(0,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_70_2)) self.ui.tableWidget_6.setItem(0,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_70_3)) self.ui.tableWidget_6.setItem(0,2,item) #FILA 2 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].chile_solidario_1)) self.ui.tableWidget_6.setItem(1,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].chile_solidario_2)) self.ui.tableWidget_6.setItem(1,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].chile_solidario_3)) self.ui.tableWidget_6.setItem(1,2,item) #FILA 3 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_65_1)) self.ui.tableWidget_6.setItem(2,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_65_2)) self.ui.tableWidget_6.setItem(2,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_65_3)) self.ui.tableWidget_6.setItem(2,2,item) #FILA 4 item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_60_1)) self.ui.tableWidget_6.setItem(3,0,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_60_2)) self.ui.tableWidget_6.setItem(3,1,item) item = QtGui.QTableWidgetItem() item.setText(str(tabla4[1].mas_60_3)) self.ui.tableWidget_6.setItem(3,2,item) def aceptarIngreso(self): """ Se aceptan los datos modificados en la planilla y se ingresan a la base de datos. """ tabla1 = {} tabla2 = {} tabla3 = {} tabla4 = {} tabla5 = {} tabla6 = {} tabla7 = {} tabla8 = {} tabla9 = {} try: for i in range(0,3): for j in range(0,12): tabla1[i,j] = int(self.ui.tableWidget.item(i,j).text()) for i in range(0,4): for j in range(0,12): tabla2[i,j] = int(self.ui.tableWidget_3.item(i,j).text()) for i in range(0,3): for j in range(0,12): tabla3[i,j] = int(self.ui.tableWidget_4.item(i,j).text()) for j in range(0,12): tabla4[0,j] = int(self.ui.tableWidget_5.item(0,j).text()) for j in range(0,12): tabla5[0,j] = int(self.ui.tableWidget_5.item(1,j).text()) for j in range(0,12): tabla6[0,j] = int(self.ui.tableWidget_5.item(2,j).text()) for i in range(0,4): for j in range(0,2): tabla7[i,j] = int(self.ui.tableWidget_2.item(i,j).text()) for i in range(0,4): for j in range(0,3): tabla8[i,j] = int(self.ui.tableWidget_7.item(i,j).text()) for i in range(0,4): for j in range(0,3): tabla9[i,j] = int(self.ui.tableWidget_6.item(i,j).text()) except: self.errorMessage(u"Existen celdas vacias") idEstablecimiento = controller.obtenerIdEstablecimiento(self.establecimiento) controller.ingresarRegistro(tabla1, tabla2, tabla3, tabla4, tabla5, tabla6, tabla7, tabla8, tabla9, idEstablecimiento, self.mes, self.anho, 1) self.correctMessage(u"Ingreso Exitoso") self.close() def correctMessage(self, message): """Función que despliega un mensaje de operacion correcta. @param message""" QtGui.QMessageBox.information(self ,u"Operacion correcta", message) def errorMessage(self, message): """Función que despliega un mensaje de error. @param message""" QtGui.QMessageBox.warning( self, u"ERROR!", message)