def __init__(self,parent=None):
QtGui.QWidget.__init__(self,parent)
self.ui= Ui_gestionarTransacciones()
self.ui.setupUi(self)
temp = datetime.datetime.now()
date3 = str(temp.year)+"-"+str(temp.month)+"-"+str(temp.day)
now = datetime.datetime.strptime(date3, "%Y-%m-%d")
self.ui.dateEdit_2.setDate(QtCore.QDate(now.date()))
self.ui.productoCombo.addItem("Seleccione")
self.s1 = select([producto.c.concepto])
result1 = db.execute(self.s1)
for row in result1:
self.ui.productoCombo.addItem(row[0])
class GestionarTransacciones(QtGui.QMainWindow):
closed = pyqtSignal()
fecha1_anterior=""
fecha2_anterior=""
select_anterior=""
def __init__(self,parent=None):
QtGui.QWidget.__init__(self,parent)
self.ui= Ui_gestionarTransacciones()
self.ui.setupUi(self)
temp = datetime.datetime.now()
date3 = str(temp.year)+"-"+str(temp.month)+"-"+str(temp.day)
now = datetime.datetime.strptime(date3, "%Y-%m-%d")
self.ui.dateEdit_2.setDate(QtCore.QDate(now.date()))
self.ui.productoCombo.addItem("Seleccione")
self.s1 = select([producto.c.concepto])
result1 = db.execute(self.s1)
for row in result1:
self.ui.productoCombo.addItem(row[0])
def modifiedOrDelete(self, item):
table = item.tableWidget()
fila = item.row()
columna = item.column()
item_id = table.item(fila,0)
item_tabla = table.item(fila,1)
if len(str(item_id.text()))!=0: #Contiene el identificador del item seleccionado.
if columna==6:
try:
self.ui.horizontalScrollBar.hide()
self.ui.label.hide()
self.ui.label_2.hide()
self.ui.spinBox.hide()
self.ui.stackedWidget.hide()
except:
pass
self.modificarTransaccionWindow = ModificarTransaccion(self)
self.modificarTransaccionWindow.closed.connect(self.buscar)
self.modificarTransaccionWindow.closed.connect(self.show)
self.modificarTransaccionWindow.Rif_Ci = razon_nom
self.modificarTransaccionWindow.ui.Rif_Ci.setText(self.modificarTransaccionWindow.Rif_Ci)
self.ui.dateEdit.setDate(QtCore.QDate(self.fecha1_anterior.date()))
self.ui.dateEdit_2.setDate(QtCore.QDate(self.fecha2_anterior.date()))
self.ui.productoCombo.setCurrentIndex(self.ui.productoCombo.findText(self.select_anterior, Qt.MatchExactly))
self.modificarTransaccionWindow.show()
self.hide()
elif(columna==7):
global eliminar_id, eliminar_tabla
eliminar_id = str(item_id.text())
eliminar_tabla = str(item_tabla.text())
self.ui.dateEdit.setDate(QtCore.QDate(self.fecha1_anterior.date()))
self.ui.dateEdit_2.setDate(QtCore.QDate(self.fecha2_anterior.date()))
self.ui.productoCombo.setCurrentIndex(self.ui.productoCombo.findText(self.select_anterior, Qt.MatchExactly))
self.ui._dialog = QtGui.QDialog(self)
self.ui._dialog.resize(400, 300)
self.ui._dialog.setModal(True)
self.ui.verticalLayout_dialog = QtGui.QVBoxLayout(self.ui._dialog)
self.ui.verticalLayout_dialog.setObjectName(_fromUtf8("verticalLayout_dialog"))
self.ui.textEdit_eli = QtGui.QTextEdit(self.ui._dialog)
palette = QtGui.QPalette()
brush = QtGui.QBrush(QtGui.QColor(242, 241, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(242, 241, 240))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Base, brush)
brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
brush.setStyle(QtCore.Qt.SolidPattern)
palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Base, brush)
self.ui.textEdit_eli.setPalette(palette)
self.ui.textEdit_eli.setFrameShape(QtGui.QFrame.NoFrame)
self.ui.textEdit_eli.setReadOnly(True)
self.ui.textEdit_eli.setTextInteractionFlags(QtCore.Qt.NoTextInteraction)
self.ui.textEdit_eli.setText("Desea eliminar la donacion de la fila "+str(fila+1)+"?")
self.ui.textEdit_eli.setObjectName(_fromUtf8("textEdit_eli"))
self.ui.verticalLayout_dialog.addWidget(self.ui.textEdit_eli)
self.ui.buttonBox = QtGui.QDialogButtonBox(self.ui._dialog)
self.ui.buttonBox.setStandardButtons(QtGui.QDialogButtonBox.Cancel|QtGui.QDialogButtonBox.Ok)
self.ui.buttonBox.setObjectName(_fromUtf8("buttonBox"))
self.ui.verticalLayout_dialog.addWidget(self.ui.buttonBox)
QtCore.QObject.connect(self.ui.buttonBox, QtCore.SIGNAL(_fromUtf8("accepted()")), self.eliminar)
QtCore.QObject.connect(self.ui.buttonBox, QtCore.SIGNAL(_fromUtf8("rejected()")), self.ui._dialog.reject)
QtCore.QMetaObject.connectSlotsByName(self.ui._dialog)
self.ui._dialog.show()
def eliminar(self):
self.delete = transaccion.delete().where(transaccion.c.transaccion_id==eliminar_id)
db.execute(self.delete)
self.ui._dialog.accept()
self.buscar()
def atras(self):
self.hide()
self.closed.emit()
def buscar(self):
var_temp = self.ui.dateEdit.date()
date1 = str(var_temp.toPyDate())
var_temp = self.ui.dateEdit_2.date()
date2 = str(var_temp.toPyDate())
fecha1 = datetime.datetime.strptime(date1, "%Y-%m-%d")
fecha2 = datetime.datetime.strptime(date2, "%Y-%m-%d")
temp = datetime.datetime.now()
date3 = str(temp.year)+"-"+str(temp.month)+"-"+str(temp.day)
now = datetime.datetime.strptime(date3, "%Y-%m-%d")
if (fecha1<=fecha2) and (fecha2<=now):
self.ui.labelError.hide()
if(cmp(str(self.ui.productoCombo.currentText()),"Seleccione")==0):
print "hola"
s1 = text("SELECT transaccion.transaccion_id, transaccion.concepto, transaccion.monto, transaccion.fecha AS col "
"FROM transaccion "
"WHERE :fechaI <= transaccion.fecha AND transaccion.fecha <= :fechaF "
"ORDER BY col DESC "
)
result1 = db.execute(s1, fechaI = fecha1, fechaF = fecha2)
result2 = db.execute(s1, fechaI = fecha1, fechaF = fecha2)
else:
print "hi"
s1 = text("SELECT transaccion.transaccion_id, transaccion.concepto, transaccion.monto, transaccion.fecha AS col "
"FROM transaccion "
"WHERE :fechaI <= transaccion.fecha AND transaccion.fecha <= :fechaF "
"AND transacccion.concepto = :concepto "
"ORDER BY col DESC "
)
result1 = db.execute(s1, concepto = str(self.ui.productoCombo.currentText()), fechaI = fecha1, fechaF = fecha2)
result2 = db.execute(s1, concepto = str(self.ui.productoCombo.currentText()), fechaI = fecha1, fechaF = fecha2)
z = 0
for row in result1:
z+=1
if(z==0):
try:
self.ui.horizontalScrollBar.hide()
self.ui.label.hide()
self.ui.label_2.hide()
self.ui.spinBox.hide()
self.ui.stackedWidget.hide()
except:
pass
else:
try:
self.ui.horizontalScrollBar.hide()
self.ui.label.hide()
self.ui.label_2.hide()
self.ui.spinBox.hide()
self.ui.stackedWidget.hide()
except:
pass
self.fecha1_anterior = fecha1
self.fecha2_anterior = fecha2
self.select_anterior = str(self.ui.productoCombo.currentText())
#Creacion Tabla
self.ui.numColumnas = 4
self.ui.numFilas = 5
self.ui.numtablas = int(ceil(z/float(self.ui.numFilas)))
print self.ui.numtablas
self.ui.stackedWidget = QtGui.QStackedWidget(self.ui.centralwidget)
sizePolicy = QtGui.QSizePolicy(QtGui.QSizePolicy.Preferred, QtGui.QSizePolicy.Preferred)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.ui.stackedWidget.sizePolicy().hasHeightForWidth())
self.ui.stackedWidget.setSizePolicy(sizePolicy)
self.ui.stackedWidget.setObjectName(_fromUtf8("stackedWidget"))
row = 0
for x in range(0,self.ui.numtablas):
self.ui.page = QtGui.QWidget()
self.ui.page.setObjectName(_fromUtf8("page_"+str(x)))
self.ui.stackedWidget.addWidget(self.ui.page)
self.ui.verticalLayout_1 = QtGui.QHBoxLayout(self.ui.page)
self.ui.verticalLayout_1.setObjectName(_fromUtf8("verticalLayout_"+str(x)))
self.ui.tableWidget = QtGui.QTableWidget(self.ui.page)
self.ui.tableWidget.setAlternatingRowColors(True)
self.ui.tableWidget.setObjectName(_fromUtf8("tableWidget_"+str(x)))
self.ui.tableWidget.setColumnCount(self.ui.numColumnas)
self.ui.tableWidget.setRowCount(self.ui.numFilas)
header = self.ui.tableWidget.horizontalHeader()
header.setResizeMode(QHeaderView.Stretch)
header = self.ui.tableWidget.verticalHeader()
header.setResizeMode(QHeaderView.Stretch)
self.ui.tableWidget.setHorizontalHeaderLabels(('ID', 'Concepto', 'Cantidad','Fecha','Modificar', 'Eliminar'))
i=0
for row in result2:
if i<self.ui.numFilas:
for j in range(0,self.ui.numColumnas):
self.ui.label = QtGui.QLabel()
if (j==4):
self.ui.label.setText("Modificar")
self.ui.tableWidget.setItem(i,j,QtGui.QTableWidgetItem(self.ui.label.text()))
elif (j==5):
self.ui.label.setText("Eliminar")
self.ui.tableWidget.setItem(i,j,QtGui.QTableWidgetItem(self.ui.label.text()))
else:
self.ui.label.setText(str(row[j]))
self.ui.tableWidget.setItem(i,j,QtGui.QTableWidgetItem(self.ui.label.text()))
item = self.ui.tableWidget.item(i,j)
item.setFlags(Qt.ItemIsEnabled)
i+=1
if i==self.ui.numFilas:
break
while i < self.ui.numFilas:
for j in range(0,self.ui.numColumnas):
self.ui.tableWidget.setItem(i,j,QtGui.QTableWidgetItem(""))
item = self.ui.tableWidget.item(i,j)
item.setFlags(Qt.ItemIsEnabled)
i+=1
self.ui.tableWidget.hideColumn(0)
QtCore.QObject.connect(self.ui.tableWidget, QtCore.SIGNAL(_fromUtf8("itemClicked(QTableWidgetItem*)")), self.modifiedOrDelete)
self.ui.verticalLayout_1.addWidget(self.ui.tableWidget)
self.ui.verticalLayout.addWidget(self.ui.stackedWidget)
self.ui.horizontalLayout = QtGui.QHBoxLayout()
self.ui.horizontalLayout.setObjectName(_fromUtf8("horizontalLayout"))
self.ui.horizontalScrollBar = QtGui.QScrollBar(self.ui.centralwidget)
self.ui.horizontalScrollBar.setMaximum(self.ui.numtablas-1)
sizePolicy = QtGui.QSizePolicy(QtGui.QSizePolicy.Expanding, QtGui.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.ui.horizontalScrollBar.sizePolicy().hasHeightForWidth())
self.ui.horizontalScrollBar.setSizePolicy(sizePolicy)
self.ui.horizontalScrollBar.setOrientation(QtCore.Qt.Horizontal)
self.ui.horizontalScrollBar.setObjectName(_fromUtf8("horizontalScrollBar"))
self.ui.horizontalLayout.addWidget(self.ui.horizontalScrollBar)
self.ui.label = QtGui.QLabel(self.ui.centralwidget)
self.ui.label.setObjectName(_fromUtf8("label"))
self.ui.label.setText("page")
self.ui.horizontalLayout.addWidget(self.ui.label)
self.ui.spinBox = QtGui.QSpinBox(self.ui.centralwidget)
self.ui.spinBox.setMaximum(self.ui.numtablas-1)
self.ui.spinBox.setObjectName(_fromUtf8("spinBox"))
self.ui.horizontalLayout.addWidget(self.ui.spinBox)
self.ui.label_2 = QtGui.QLabel(self.ui.centralwidget)
self.ui.label_2.setObjectName(_fromUtf8("label_2"))
self.ui.label_2.setText("of "+str(self.ui.numtablas-1))
self.ui.horizontalLayout.addWidget(self.ui.label_2)
self.ui.verticalLayout.addLayout(self.ui.horizontalLayout)
self.ui.stackedWidget.setCurrentIndex(0)
QtCore.QObject.connect(self.ui.horizontalScrollBar, QtCore.SIGNAL(_fromUtf8("valueChanged(int)")), self.ui.stackedWidget.setCurrentIndex)
QtCore.QObject.connect(self.ui.horizontalScrollBar, QtCore.SIGNAL(_fromUtf8("valueChanged(int)")), self.ui.spinBox.setValue)
QtCore.QObject.connect(self.ui.spinBox, QtCore.SIGNAL(_fromUtf8("valueChanged(int)")), self.ui.horizontalScrollBar.setValue)
QtCore.QObject.connect(self.ui.stackedWidget, QtCore.SIGNAL(_fromUtf8("currentChanged(int)")), self.ui.spinBox.setValue)
else:
try:
self.ui.horizontalScrollBar.hide()
self.ui.label.hide()
self.ui.label_2.hide()
self.ui.spinBox.hide()
self.ui.stackedWidget.hide()
except:
pass
self.ui.labelError.show()
if(fecha1>now or fecha2>now):
self.ui.labelError.setText("Las fechas deben ser menor a la fecha actual ("+date3+").")
else:
self.ui.labelError.setText("La fecha \"Desde\" debe ser menor o igual a la fecha \"Hasta\".")