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)
