def logs(self): if self.comboBox.currentText() == 'Tutti': db_table = sql_query.Q( action='allLogs', kwargs=[ str(self.calendarFrom.selectedDate().year()) + '-' + str(self.calendarFrom.selectedDate().month()) + '-' + str(self.calendarFrom.selectedDate().day()) + ' 00:00:00', str(self.calendarTo.selectedDate().year()) + '-' + str(self.calendarTo.selectedDate().month()) + '-' + str(self.calendarTo.selectedDate().day()) + ' 23:59:59' ]) else: db_table = sql_query.Q( action='logs_by', kwargs=[ str(self.calendarFrom.selectedDate().year()) + '-' + str(self.calendarFrom.selectedDate().month()) + '-' + str(self.calendarFrom.selectedDate().day()) + ' 00:00:00', str(self.calendarTo.selectedDate().year()) + '-' + str(self.calendarTo.selectedDate().month()) + '-' + str(self.calendarTo.selectedDate().day()) + ' 23:59:59', str(self.comboBox.currentText()) ]) for i in reversed(range(self.tableWidget.rowCount())): self.tableWidget.removeRow(i) for row in range(0, len(db_table)): self.tableWidget.insertRow(self.tableWidget.rowCount()) for colum in range(0, 3): value = QTableWidgetItem(str(db_table[row][colum]), 0) self.tableWidget.setItem(row, colum, value) colum += 1 row += 1
def accept(self): if self.EditDialog.text() == '': QMessageBox.about(self, 'Attenzione', 'Deve scrivere un nome cliente') else: check_client = sql_query.Q(action='check_client', kwargs=[self.EditDialog.text()]) if str(check_client) == '()': sql_query.Q(action='new_client', kwargs=[self.EditDialog.text()]) self.hide() else: QMessageBox.about(self, 'Attenzione', 'Cliente esistente')
def _save(self): conf = configparser.RawConfigParser() conf.read( os.path.join(os.path.dirname(os.path.abspath(__file__)), '../db.conf')) email_regex = re.compile(r"[^@]+@[^@]+\.[^@]+") if self.lineEditClient.text() == '' or \ self.lineEditName.text() == '' or \ self.lineEditEmail.text() == '' or \ self.lineEditReq.text() == '' or \ self.lineEditLic.text() == '' or \ not email_regex.match(self.lineEditEmail.text()): QMessageBox.about(self, 'Attenzione', codes.msg(code=413)) else: sql_query.Q(action='insert_lic', kwargs=[ self.lineEditClient.text(), self.lineEditName.text(), self.lineEditEmail.text(), self.dateEditActive.text(), self.dateEditExpire.text(), self.lineEditReq.text(), self.lineEditLic.text(), self.spinBoxQty.value() ]) if self.spinBoxQty.value() is 0: qty = 'Ilimitati' else: qty = str(self.spinBoxQty.value()) sender = base64.b64decode( conf['Mail']['sender'][2:-1]).decode('utf-8') recipient = self.lineEditEmail.text() ctx = 'Gentile Cliente,<br><br>Grazie per aver scelto il nostro prodotto Aron Proxy,<br>' ctx += 'nel seguito inviamo i dati per l\'attivazione della licenza.<br><br>' ctx += 'Cliente: %s<br>Nome: %s<br>Codice: %s<br>Licenza: %s<br>Quantita\' devices: %s<br><br>' \ 'Cordiali Saluti,<br><br>' \ 'Computer Time s.r.l' % \ (self.lineEditClient.text(), self.lineEditName.text(), self.lineEditReq.text(), self.lineEditLic.text(), qty) msg = MIMEMultipart('alternative') msg['Subject'] = u'Computer Time :: Licenza per Aron Proxy' msg['From'] = sender msg['To'] = recipient message = MIMEText(ctx, 'html') msg.attach(message) s = smtplib.SMTP( base64.b64decode(conf['Mail']['server'][2:-1]).decode('utf-8'), 25) s.login( base64.b64decode(conf['Mail']['user'][2:-1]).decode('utf-8'), base64.b64decode( conf['Mail']['password'][2:-1]).decode('utf-8')) s.sendmail(sender, recipient, msg.as_string()) s.quit() self._loadtable()
def _delete_user(self): sql_query.Q(action='delete_user', kwargs=[ self.tableWidget.item(self.tableWidget.currentRow(), 0).text() ]) self.load_table()
def closeEvent(self, event): if self._want_to_close: super(DialogLogin, self).closeEvent() else: event.ignore() sql_query.Q(action='log', kwargs=[self.EditLogin.text(), codes.msg(code=404) + self.EditLogin.text()]) qApp.exit(0)
def accept(self): if self.EditDialog.text() == '': QMessageBox.about(self, 'Attenzione', codes.msg(code=308)) else: if self.EditDialog.isReadOnly() is False: self._save() sql_query.Q(action='new_hw', kwargs=[self.EditDialog.text(), self._client]) self.hide()
def _delete_it(self): sql_query.Q(action='delete_it_item', kwargs=[ self.tableWidget.item(self.tableWidget.currentRow(), 0).text() ]) self.EditDialog.setText('') self.load_table()
def load_table(self): db_table = sql_query.Q(action='load_item') for i in reversed(range(self.tableWidget.rowCount())): self.tableWidget.removeRow(i) for row in range(0, len(db_table)): self.tableWidget.insertRow(self.tableWidget.rowCount()) value = QTableWidgetItem(str(db_table[row][0]), 0) self.tableWidget.setItem(row, 0, value) row += 1
def accept(self): if self.EditDialog.text() == '': QMessageBox.about(self, 'Attenzione', codes.msg(code=308)) else: if self._item == 'LAN' or self._item == 'WAN': if iptools.ipv4.validate_ip(self.EditDialog.text()) is True: sql_query.Q(action='new_line', kwargs=[self._hardware, self._item, self.EditDialog.text(), self._client]) self.hide() return else: QMessageBox.about(self, 'Attenzione', codes.msg(code=311)) return sql_query.Q(action='new_line', kwargs=[self._hardware, self._item, self.EditDialog.text(), self._client]) self.hide()
def _save(self): try: sql_query.Q(action='save_it_new', kwargs=[self.EditDialog.text()]) self.EditDialog.setReadOnly(True) self.btItSave.setDisabled(True) self.EditDialog.setText('') self.buttonBox.setDisabled(False) self.load_table() except: QMessageBox.about(self, 'Attenzione', codes.msg(code=307))
def accept(self): if self.EditNew.text() == '' or self.EditConferm.text() == '': QMessageBox.about(self, 'Attenzione', codes.msg(code=309)) if self.EditNew.text() == self.EditConferm.text(): sql_query.Q(action='update_pwd', kwargs=[self.EditNew.text(), self._client]) self.hide() else: self.EditNew.clear() self.EditConferm.clear() QMessageBox.about(self, 'Attenzione', codes.msg(code=310))
def accept(self): if self.EditLogin.text() == '' or self.EditPass.text() == '': QMessageBox.about(self, 'Attenzione', codes.msg(code=114)) else: try: access = sql_query.Q(action='login', kwargs=[self.EditLogin.text()]) if len(access) is 0: self.EditLogin.clear() self.EditPass.clear() self.EditLogin.setFocus() elif bcrypt.hashpw(str(self.EditPass.text()).encode('utf-8'), str(access[0][1]).encode('utf-8')) == str(access[0][2]).encode('utf-8'): self._login = self.EditLogin.text() sql_query.Q(action='log', kwargs=[self.EditLogin.text(), codes.msg(code=115)]) self._access = self.hide() else: self.EditLogin.clear() self.EditPass.clear() self.EditLogin.setFocus() sql_query.Q(action='log', kwargs=[self.EditLogin.text(), codes.msg(code=404 + self.EditLogin.text())]) except: QMessageBox.about(self, 'Attenzione', codes.msg(code=401))
def _modify(self): try: self.btSave.setEnabled(True) self.EditDialog.setText(self.tableWidget.selectedItems()[0].text()) db_table = sql_query.Q( action='load_user', kwargs=[self.tableWidget.selectedItems()[0].text()]) self.EditDialogPwd.setText(db_table[0][1]) self.checkBox.setCheckState(db_table[0][2]) self.modify = 'True' except: pass
def _save(self): try: if self.modify == 'False': sql_query.Q(action='save_new_user', kwargs=[ self.EditDialog.text(), self.EditDialogPwd.text(), self.checkBox.checkState() ]) else: sql_query.Q(action='update_user', kwargs=[ self.EditDialog.text(), self.checkBox.checkState() ]) self.modify = 'False' self.EditDialog.setText('') self.EditDialogPwd.setText('') self.EditDialog.setReadOnly(True) self.EditDialogPwd.setReadOnly(True) self.load_table() self.btSave.setDisabled(True) except: QMessageBox.about(self, 'Attenzione', codes.msg(code=307))
def load_table(self): db_table = sql_query.Q(action='load_users') for i in reversed(range(self.tableWidget.rowCount())): self.tableWidget.removeRow(i) for row in range(0, len(db_table)): self.tableWidget.insertRow(self.tableWidget.rowCount()) user = QTableWidgetItem(str(db_table[row][0]), 0) self.tableWidget.setItem(row, 0, user) if db_table[row][2] == 2: pix = QPixmap("images/enable.png") else: pix = QPixmap("images/disable.png") img = QLabel(self) img.setPixmap(QPixmap(pix).scaled(16, 16)) self.tableWidget.setCellWidget(row, 1, img) row += 1
def __init__(self, parent=None): QDialog.__init__(self, parent) self.setupUi(self) self.comboBox.setFocus() self._want_to_close = False users_list = sql_query.Q(action='load_users') self.tableWidget.setColumnWidth(0, 200) self.tableWidget.setColumnWidth(1, 100) self.tableWidget.setColumnWidth(2, 360) self.comboBox.clear() logs = QPixmap("images/log.png") self.btFind.setIcon(QIcon(logs)) self.btFind.setToolTip('Logs del sistema') self.btFind.setToolTipDuration(10000) self.comboBox.addItem('Tutti') for item in range(0, len(users_list)): self.comboBox.addItem(users_list[item][0]) self.logs() self.btFind.clicked.connect(self.logs)
def _loadtable(self): for i in reversed(range(self.tableWidget.rowCount())): self.tableWidget.removeRow(i) db_table = sql_query.Q(action='license') for row in range(0, len(db_table)): self.tableWidget.insertRow(self.tableWidget.rowCount()) for column in range(0, 11): if column == 9 and db_table[row][9] == 1: pix = QPixmap("images/enable.png") img = QLabel(self) img.setPixmap(QPixmap(pix).scaled(16, 16)) self.tableWidget.setCellWidget(row, 9, img) elif column == 9 and db_table[row][9] is None: pix = QPixmap("images/disable.png") img = QLabel(self) img.setPixmap(QPixmap(pix).scaled(16, 16)) self.tableWidget.setCellWidget(row, 9, img) elif column == 5 and db_table[row][5] < datetime.date.today(): value = QTableWidgetItem(str(db_table[row][column]), 0) value.setForeground(QColor(Qt.red)) value.setTextAlignment(Qt.AlignHCenter) value.setTextAlignment(Qt.AlignVCenter) self.tableWidget.setItem(row, column, value) elif column == 5 and db_table[row][5] >= datetime.date.today(): value = QTableWidgetItem(str(db_table[row][column]), 0) value.setForeground(QColor(Qt.green)) value.setTextAlignment(Qt.AlignHCenter) value.setTextAlignment(Qt.AlignVCenter) self.tableWidget.setItem(row, column, value) else: if column == 3 and db_table[row][3] is 0: value = QTableWidgetItem(str('Ilimitati'), 0) else: value = QTableWidgetItem(str(db_table[row][column]), 0) value.setTextAlignment(Qt.AlignHCenter) value.setTextAlignment(Qt.AlignVCenter) self.tableWidget.setItem(row, column, value) column += 1 row += 1
def keyPressEvent(self, event): if event.key() == Qt.Key_Return: self.accept() if event.key() == Qt.Key_Escape: sql_query.Q(action='log', kwargs=[self.EditLogin.text(), codes.msg(code=404) + self.EditLogin.text()]) qApp.exit(0)
def _delete(self): client = self.tableWidget.item(self.tableWidget.currentRow(), 0).text() lic = self.tableWidget.item(self.tableWidget.currentRow(), 7).text() sql_query.Q(action='delete_lic', kwargs=[client, lic]) self._loadtable()