Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- from PyQt4 import QtCore, QtGui
- try:
- _fromUtf8 = QtCore.QString.fromUtf8
- except AttributeError:
- def _fromUtf8(s):
- return s
- try:
- _encoding = QtGui.QApplication.UnicodeUTF8
- def _translate(context, text, disambig):
- return QtGui.QApplication.translate(context, text, disambig, _encoding)
- except AttributeError:
- def _translate(context, text, disambig):
- return QtGui.QApplication.translate(context, text, disambig)
- class Ui_Form(object):
- def setupUi(self, Form):
- Form.setObjectName(_fromUtf8("Form"))
- Form.setEnabled(True)
- Form.resize(600, 400)
- Form.setMinimumSize(QtCore.QSize(600, 400))
- Form.setMaximumSize(QtCore.QSize(600, 400))
- palette = QtGui.QPalette()
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.WindowText, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Button, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Light, brush)
- brush = QtGui.QBrush(QtGui.QColor(247, 247, 248))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Midlight, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Dark, brush)
- brush = QtGui.QBrush(QtGui.QColor(159, 160, 161))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Mid, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Text, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.BrightText, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ButtonText, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Base, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Window, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.Shadow, brush)
- brush = QtGui.QBrush(QtGui.QColor(247, 247, 248))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.AlternateBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Active, QtGui.QPalette.ToolTipText, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.WindowText, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Button, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Light, brush)
- brush = QtGui.QBrush(QtGui.QColor(247, 247, 248))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Midlight, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Dark, brush)
- brush = QtGui.QBrush(QtGui.QColor(159, 160, 161))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Mid, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Text, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.BrightText, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ButtonText, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Base, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Window, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.Shadow, brush)
- brush = QtGui.QBrush(QtGui.QColor(247, 247, 248))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.AlternateBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Inactive, QtGui.QPalette.ToolTipText, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.WindowText, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Button, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Light, brush)
- brush = QtGui.QBrush(QtGui.QColor(247, 247, 248))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Midlight, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Dark, brush)
- brush = QtGui.QBrush(QtGui.QColor(159, 160, 161))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Mid, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Text, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 255))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.BrightText, brush)
- brush = QtGui.QBrush(QtGui.QColor(119, 120, 120))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ButtonText, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Base, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Window, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.Shadow, brush)
- brush = QtGui.QBrush(QtGui.QColor(239, 240, 241))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.AlternateBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(255, 255, 220))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipBase, brush)
- brush = QtGui.QBrush(QtGui.QColor(0, 0, 0))
- brush.setStyle(QtCore.Qt.SolidPattern)
- palette.setBrush(QtGui.QPalette.Disabled, QtGui.QPalette.ToolTipText, brush)
- Form.setPalette(palette)
- Form.setMouseTracking(False)
- Form.setContextMenuPolicy(QtCore.Qt.NoContextMenu)
- icon = QtGui.QIcon()
- icon.addPixmap(QtGui.QPixmap(_fromUtf8("logo.svg")), QtGui.QIcon.Normal, QtGui.QIcon.Off)
- Form.setWindowIcon(icon)
- self.gridLayout = QtGui.QGridLayout(Form)
- self.gridLayout.setObjectName(_fromUtf8("gridLayout"))
- self.label_5 = QtGui.QLabel(Form)
- self.label_5.setObjectName(_fromUtf8("label_5"))
- self.gridLayout.addWidget(self.label_5, 3, 3, 1, 1)
- self.label_4 = QtGui.QLabel(Form)
- self.label_4.setObjectName(_fromUtf8("label_4"))
- self.gridLayout.addWidget(self.label_4, 2, 3, 1, 1)
- self.label_6 = QtGui.QLabel(Form)
- font = QtGui.QFont()
- font.setBold(True)
- font.setWeight(75)
- self.label_6.setFont(font)
- self.label_6.setObjectName(_fromUtf8("label_6"))
- self.gridLayout.addWidget(self.label_6, 4, 2, 1, 1)
- self.user = QtGui.QLineEdit(Form)
- self.user.setObjectName(_fromUtf8("user"))
- self.gridLayout.addWidget(self.user, 4, 0, 1, 1)
- self.password = QtGui.QLineEdit(Form)
- self.password.setEchoMode(QtGui.QLineEdit.Password)
- self.password.setObjectName(_fromUtf8("password"))
- self.gridLayout.addWidget(self.password, 5, 0, 1, 1)
- self.login = QtGui.QPushButton(Form)
- self.login.setObjectName(_fromUtf8("login"))
- self.gridLayout.addWidget(self.login, 6, 0, 1, 1)
- self.label_2 = QtGui.QLabel(Form)
- font = QtGui.QFont()
- font.setBold(True)
- font.setWeight(75)
- self.label_2.setFont(font)
- self.label_2.setObjectName(_fromUtf8("label_2"))
- self.gridLayout.addWidget(self.label_2, 2, 2, 1, 1)
- self.line = QtGui.QFrame(Form)
- self.line.setFrameShape(QtGui.QFrame.VLine)
- self.line.setFrameShadow(QtGui.QFrame.Sunken)
- self.line.setObjectName(_fromUtf8("line"))
- self.gridLayout.addWidget(self.line, 0, 1, 7, 2)
- self.Guardar = QtGui.QPushButton(Form)
- self.Guardar.setObjectName(_fromUtf8("Guardar"))
- self.gridLayout.addWidget(self.Guardar, 7, 2, 1, 2)
- self.Cerrar = QtGui.QPushButton(Form)
- self.Cerrar.setObjectName(_fromUtf8("Cerrar"))
- self.gridLayout.addWidget(self.Cerrar, 7, 0, 1, 1)
- self.AntesdeAutenticar = QtGui.QLabel(Form)
- self.AntesdeAutenticar.setObjectName(_fromUtf8("AntesdeAutenticar"))
- self.gridLayout.addWidget(self.AntesdeAutenticar, 1, 2, 1, 1)
- self.label_3 = QtGui.QLabel(Form)
- font = QtGui.QFont()
- font.setBold(True)
- font.setWeight(75)
- self.label_3.setFont(font)
- self.label_3.setObjectName(_fromUtf8("label_3"))
- self.gridLayout.addWidget(self.label_3, 3, 2, 1, 1)
- self.label_7 = QtGui.QLabel(Form)
- self.label_7.setText(_fromUtf8(""))
- self.label_7.setPixmap(QtGui.QPixmap(_fromUtf8("logo.svg")))
- self.label_7.setScaledContents(True)
- self.label_7.setObjectName(_fromUtf8("label_7"))
- self.gridLayout.addWidget(self.label_7, 0, 0, 4, 1)
- self.actionCargar_funcion = QtGui.QAction(Form)
- self.actionCargar_funcion.setObjectName(_fromUtf8("actionCargar_funcion"))
- self.Cerrar.raise_()
- self.user.raise_()
- self.password.raise_()
- self.label_2.raise_()
- self.label_4.raise_()
- self.line.raise_()
- self.label_6.raise_()
- self.label_7.raise_()
- self.login.raise_()
- self.label_3.raise_()
- self.label_5.raise_()
- self.AntesdeAutenticar.raise_()
- self.Guardar.raise_()
- QtCore.QObject.connect(self.Cerrar, QtCore.SIGNAL(_fromUtf8("clicked()")), Form.close)
- QtCore.QMetaObject.connectSlotsByName(Form)
- Form.setTabOrder(self.user, self.password)
- Form.setTabOrder(self.password, self.login)
- Form.setTabOrder(self.login, self.Cerrar)
- def accion():
- from passlib.hash import pbkdf2_sha256
- import hashlib
- import MySQLdb
- u = self.user.text()
- p = self.password.text()
- p = pbkdf2_sha256.encrypt(str(p), rounds=12000, salt_size=16)
- db = MySQLdb.connect("localhost","root","root","sii" )
- cursor = db.cursor()
- cursor1 = db.cursor()
- cursor2 = db.cursor()
- cursor3 = db.cursor()
- cursor4 = db.cursor()
- cursor5 = db.cursor()
- cursor6 = db.cursor()
- data = cursor.execute("SELECT * from auth_user where username = '%s' and password = md5(%s)" % (u,p) )
- #~ data = cursor.execute("SELECT * from auth_user where username = '%s'" % (u) )
- results = cursor.fetchone()
- if data == 1:
- data1 = cursor1.execute("SELECT * from rrhh_perfil where user_id = '%s'" % (results[0]))
- results1 = cursor1.fetchall()
- for k in results1:
- data2 = cursor2.execute("SELECT * from rrhh_trabajador where id = '%s'"% (k[2]))
- results2 = cursor2.fetchall()
- for l in results2:
- data3 = cursor3.execute("SELECT * from unidad_plaza_departamento where id = '%s'"% (l[10]))
- results3 = cursor3.fetchall()
- for m in results3:
- data4 = cursor4.execute("SELECT * from unidad_departamento where id = '%s'"% (m[4]))
- results4 = cursor4.fetchall()
- for n in results4:
- #~ data5 = cursor5.execute("SELECT * from unidad_departamento where unidad_id = '%s'"% (n[4]))
- data5 = cursor5.execute("SELECT unidad_departamento.nombre_id, unidad_unidad_organizativa.nombre FROM unidad_departamento INNER JOIN unidad_unidad_organizativa ON unidad_departamento.nombre_id=unidad_unidad_organizativa.id where unidad_id = '%s'"% (n[4]))
- results5 = cursor5.fetchall()
- for o in results5:
- data6 = cursor6.execute("SELECT * from unidad_unidad where id = '%s'"% (n[4]))
- results6 = cursor6.fetchall()
- for q in results6:
- q
- self.Select = QtGui.QComboBox(Form)
- self.Select.setObjectName(_fromUtf8("Select"))
- self.Select.addItem(_fromUtf8(""))
- for o in results5:
- self.Select.addItem(_fromUtf8(""))
- self.gridLayout.addWidget(self.Select, 5, 2, 1, 2)
- self.Select.raise_()
- Form.setWindowTitle(_translate("Form", "Sistema Integral de Información", None))
- self.label_5.setText(_translate("Form", str(q[2]), None))
- self.label_4.setText(_translate("Form", str(l[1]), None))
- self.label_6.setText(_translate("Form", "Departamento:", None))
- self.user.setPlaceholderText(_translate("Form", "Usuario", None))
- self.password.setPlaceholderText(_translate("Form", "Contraseña", None))
- self.login.setText(_translate("Form", "Login", None))
- self.label_2.setText(_translate("Form", "Usuario:", None))
- self.Guardar.setText(_translate("Form", "Guardar Datos", None))
- self.Cerrar.setText(_translate("Form", "Cerrar", None))
- self.AntesdeAutenticar.setText(_translate("Form", "Bienvenido", None))
- self.label_3.setText(_translate("Form", "Unidad:", None))
- self.Select.setItemText(0, _translate("Form", "---------", None))
- d=0
- for row in results5:
- d=d + 1
- self.Select.setItemText(d, _translate("Form", str(row[1]), None))
- def guardar():
- print "ejecutar script aqui"
- QtCore.QObject.connect(self.Guardar, QtCore.SIGNAL(_fromUtf8("clicked()")), guardar)
- db.close()
- self.actionCargar_funcion.setText(_translate("Form", "cargar funcion", None))
- Form.setWindowTitle(_translate("Form", "Sistema Integral de Información", None))
- #~ self.label_5.setText(_translate("Form", "TextLabel", None))
- #~ self.label_4.setText(_translate("Form", "TextLabel", None))
- #~ self.label_6.setText(_translate("Form", "Departamento:", None))
- self.user.setPlaceholderText(_translate("Form", "Usuario", None))
- self.password.setPlaceholderText(_translate("Form", "Contraseña", None))
- self.login.setText(_translate("Form", "Login", None))
- #~ self.label_2.setText(_translate("Form", "Usuario:", None))
- #~ self.Guardar.setText(_translate("Form", "Guardar Datos", None))
- self.Cerrar.setText(_translate("Form", "Cerrar", None))
- self.AntesdeAutenticar.setText(_translate("Form", "No se encuentra autenticado", None))
- #~ self.label_3.setText(_translate("Form", "Unidad:", None))
- QtCore.QObject.connect(self.login, QtCore.SIGNAL(_fromUtf8("clicked()")), accion)
- if __name__ == "__main__":
- import sys
- app = QtGui.QApplication(sys.argv)
- Form = QtGui.QWidget()
- ui = Ui_Form()
- ui.setupUi(Form)
- Form.show()
- sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement