def show_joblog(ls):
print(ls)
#管理员登录
if ls[2]:
p=LinkMysql().select_admin(ls[0])
pwd=(" ".join('%s' %id for id in p))
print(pwd)
if ls[1]==pwd:
landing.hide()
myWin.get_user(ls[0])
myWin.show()
else:
landing.show_error()
#员工登录
if ls[3]:
p1=LinkMysql().select_staff(ls[0])
pwd1=(" ".join('%s' %id for id in p1))
print(pwd1)
if ls[1]==pwd1:
landing.hide()
myWin.get_user(ls[0])
myWin.show()
else:
landing.show_error()
def add_to_database(self):
self.value=[]
self.value.append(self.t_id.toPlainText())
self.value.append(self.t_rank.toPlainText())
self.value.append(self.t_name.toPlainText())
self.value.append(self.t_sex.toPlainText())
self.value.append(self.t_marriage.toPlainText())
self.value.append(self.t_bir.toPlainText())
self.value.append(self.t_nation.toPlainText())
self.value.append(self.t_tel.toPlainText())
self.value.append(self.t_mail.toPlainText())
self.value.append(self.t_edu.toPlainText())
self.value.append(self.t_salary.toPlainText())
self.value.append(self.t_entry.toPlainText())
self.value.append(self.t_depid.toPlainText())
self.value.append(self.t_duty.toPlainText())
self.value.append(self.t_politics.toPlainText())
self.value.append(self.t_skills.toPlainText())
self.value.append(self.t_dep.toPlainText())
print(self.value)
sql = "INSERT INTO staff values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql1(sql,self.value):
QMessageBox.information(self,"温馨提示", "添加成功",QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry)
print('Something wrong')
def add_to_database(self):
self.value = []
self.value.append(self.id_ln.text())
self.value.append(self.name_ln.text())
self.value.append(self.pw_ln.text())
self.value.append(self.tel_ln.text())
self.value.append(self.mail_ln.text())
self.value.append(self.dep_ln.text())
self.value.append(self.work_ln.text())
if not self.id_ln.text():
QMessageBox.warning(self, '温馨提示', '请输入管理员id', QMessageBox.Retry)
print('Something wrong')
else:
id = int(self.id_ln.text())
print(self.value)
sql = "INSERT INTO sys_admin values (%s,%s,%s,%s,%s,%s,%s)"
if id < 1000:
QMessageBox.warning(self, '温馨提示', '管理员id要大于1000',
QMessageBox.Retry)
print('Something wrong')
elif LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生,请重试',
QMessageBox.Retry)
print('Something wrong')
def __init__(self,parent = None):
super(salary_staff_console,self).__init__(parent)
#设置界面大小、名称、背景
self.resize(500,600)
self.setWindowTitle('工资管理')
#窗体属性
self.setWindowFlags(Qt.Widget)
sql="SELECT staId,staName,origin_salary FROM salary order by staId"
#数据列名
col_lst=['员工Id','姓名','底薪']
type=1
data=LinkMysql().select_single(sql,type)
#数据的大小
row = len(data)
vol = len(data[0])
#插入表格
self.MyTable = QtWidgets.QTableWidget(row,vol)
self.MyTable.setColumnCount(vol)
self.MyTable.setRowCount(row)
self.MyTable.setEditTriggers(QtWidgets.QAbstractItemView.NoEditTriggers)
self.MyTable.setSelectionBehavior(QtWidgets.QAbstractItemView.SelectRows)
self.MyTable.setObjectName("MyTable")
font = QtGui.QFont('微软雅黑',10)
#设置字体、表头
self.MyTable.horizontalHeader().setFont(font)
self.MyTable.setHorizontalHeaderLabels(col_lst)
#设置竖直方向表头不可见
self.MyTable.verticalHeader().setVisible(False)
self.MyTable.setFrameShape(QFrame.NoFrame)
#构建表格插入数据
for i in range(row):
for j in range(vol):
temp_data = data[i][j] # 临时记录，不能直接插入表格
self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格
self.MyTable.setItem(i, j, self.data1)
#编辑按钮
self.qle = QLineEdit()
self.qle.setText('请输入员工id')
self.qle.setFont(font)
#垂直布局
layout = QVBoxLayout()
layout.addWidget(self.qle)
layout.addWidget(self.MyTable)
self.setLayout(layout)
def del_data(self):
#是否删除的对话框
tmp = '请输入部门id'
tmp1 = self.qle.text()
reply = QMessageBox.question(self, 'Message',
'Are you sure to delete it ?',
QMessageBox.Yes | QMessageBox.No,
QMessageBox.No)
if reply == QMessageBox.Yes:
#当前行
if tmp1 == tmp:
row_2 = self.MyTable.currentRow()
userid = self.MyTable.item(row_2, 0).text()
else:
userid = self.qle.text()
ls = int(userid)
print(ls)
sql = "delete from department where dId= %s "
if LinkMysql().commit_sql(sql, ls):
#删除表格
QMessageBox.information(self, "温馨提示", "删除成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '无法删除,请检查该部门是否有员工',
QMessageBox.Retry)
print('Something wrong')
def del_data(self):
#是否删除的对话框
tmp = '请输入员工id'
tmp1 = self.qle.text()
reply = QMessageBox.question(self, 'Message',
'Are you sure to delete it ?',
QMessageBox.Yes | QMessageBox.No,
QMessageBox.No)
if reply == QMessageBox.Yes:
if tmp1 == tmp:
row_2 = self.MyTable.currentRow()
userid = self.MyTable.item(row_2, 0).text()
else:
userid = self.qle.text()
ls = int(userid)
print(ls)
sql = "update staff_bad set sta_remarks=NULL where staId= %s "
if LinkMysql().commit_sql(sql, ls):
#删除表格
QMessageBox.information(self, "温馨提示", "删除成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误产生', QMessageBox.Retry)
print('Something wrong')
def __init__(self, user_id):
super(salary_query_panel, self).__init__()
self.setupUi(self)
sql = 'select * from salary where staId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
print(self.data)
times = self.data[0][4]
origin = self.data[0][2]
award = self.data[0][3]
realSalary = origin + award - (times * 100)
self.sa_id.setText(str(self.data[0][0]))
self.sa_name.setText(self.data[0][1])
self.sa_or.setText(str(self.data[0][2]))
self.sa_aw.setText(str(self.data[0][3]))
self.sa_times.setText(str(self.data[0][4]))
self.real_sa.setText(str(realSalary))
self.sa_id.setReadOnly(True)
self.sa_name.setReadOnly(True)
self.sa_or.setReadOnly(True)
self.sa_aw.setReadOnly(True)
self.sa_times.setReadOnly(True)
self.real_sa.setReadOnly(True)
def save_to_database(self):
self.value=[]
self.value.append(self.mon_id.text())
self.value.append(self.mon_name.text())
self.value.append(self.mon_date.text())
self.value.append(self.mon_awa.text())
self.value.append(self.mon_re.toPlainText())
print(self.value)
sql0="delete from monthrecord where staId=%s"
LinkMysql().commit_sql(sql0,self.user_id)
sql = "INSERT INTO monthrecord values (%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql,self.value):
QMessageBox.information(self,"温馨提示", "修改成功",QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry)
print('Something wrong')
self.close()
def __init__(self, user_id):
super(sys_secret_panel, self).__init__()
self.setupUi(self)
self.user_id = user_id
sql = 'select * from sys_view where staId=%s'
print(self.user_id)
self.data = LinkMysql().select_sql(sql, user_id)
print(self.data)
self.id_ln.setText(str(self.data[0][0]))
self.osec_ln.setText(self.data[0][1])
def save_to_database(self):
self.value = []
self.value.append(self.sa_id.text())
self.value.append(self.sa_name.text())
self.value.append(self.sa_or.text())
self.value.append(self.sa_aw.text())
self.value.append(self.sa_times.text())
print(self.value)
sql0 = "delete from salary where staId=%s"
LinkMysql().commit_sql(sql0, self.user_id)
sql = "INSERT INTO salary values (%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry)
print('Something wrong')
self.close()
def __init__(self, user_id):
super(change_secret_panel, self).__init__()
self.setupUi(self)
self.user_id = user_id
self.admit.clicked.connect(self.change)
sql = 'select * from staff where stId=%s'
sql1 = 'select staPwd from sys_staff where staId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
self.data1 = LinkMysql().select_sql(sql1, user_id)
self.pwd = (" ".join('%s' % id for id in self.data1))
self.id_ln.setText(str(user_id))
self.name_ln.setText(self.data[0][2])
self.osec_ln.setText(self.pwd)
self.id_ln.setReadOnly(True)
self.name_ln.setReadOnly(True)
self.osec_ln.setReadOnly(True)
def save_to_database(self):
self.value = []
self.value.append(self.id_ln.text())
self.value.append(self.name_ln.text())
self.value.append(self.pw_ln.text())
self.value.append(self.tel_ln.text())
self.value.append(self.mail_ln.text())
self.value.append(self.dep_ln.text())
self.value.append(self.work_ln.text())
print(self.value)
sql0 = "delete from sys_admin where aId=%s"
LinkMysql().commit_sql(sql0, self.user_id)
sql = "INSERT INTO sys_admin values (%s,%s,%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry)
print('Something wrong')
self.close()
def save_to_database(self):
da = self.ch_date.date().toString('yyyy-MM-dd')
self.value = []
self.value.append(self.ch_id.text())
self.value.append(self.ch_name.text())
self.value.append(self.ch_dep.text())
self.value.append(self.ch_work.text())
self.value.append(da)
print(self.value)
sql0 = "delete from checking_in where staId=%s"
LinkMysql().commit_sql(sql0, self.user_id)
sql = "INSERT INTO checking_in values (%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry)
print('Something wrong')
self.close()
def __init__(self,user_id):
super(act_modify_panel,self).__init__()
self.setupUi(self)
self.user_id=user_id
sql='select * from activity where acId=%s'
self.data=LinkMysql().select_sql(sql,user_id)
print(self.data)
self.time.setDate(QDate(self.data[0][2]))
self.title_ln.setText(self.data[0][1])
self.con_ln.setText(self.data[0][3])
def save_to_database(self):
self.value = []
self.value.append(self.did_ln.text())
self.value.append(self.ddirname_ln.text())
self.value.append(self.ddir_ln.text())
self.value.append(self.ddir_tel.text())
self.value.append(self.ddir_mail.text())
self.value.append(self.dintr_ln.toPlainText())
print(self.value)
sql0 = "delete from department where dId=%s"
LinkMysql().commit_sql(sql0, self.user_id)
sql = "INSERT INTO department values (%s,%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '请检查该部门无员工后再进行更改',
QMessageBox.Retry)
print('Something wrong')
self.close()
def save_to_database(self):
dateTime= self.time.date().toString('yyyy-MM-dd')
print(dateTime)
self.value=[]
self.value.append(self.title_ln.text())
self.value.append(dateTime)
self.value.append(self.con_ln.toPlainText())
self.value.append(1)
print(self.value)
sql0="delete from activity where acId=%s"
LinkMysql().commit_sql(sql0,self.user_id)
sql = "INSERT INTO activity(acTitle,acTime,acContent,acbuilder) values (%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql,self.value):
QMessageBox.information(self,"温馨提示", "修改成功",QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示','有错误发生,请重试',QMessageBox.Retry)
print('Something wrong')
self.close()
def change(self):
new_sec = self.nsec_ln.text()
sql = 'update sys_staff set staPwd=%s where staId=%s'
ls = []
ls.append(new_sec)
ls.append(self.user_id)
if LinkMysql().commit_sql(sql, ls):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '修改失败', QMessageBox.Retry)
print('Something wrong')
def __init__(self, user_id):
super(check_modify_panel, self).__init__()
self.setupUi(self)
self.user_id = user_id
sql = 'select * from checking_in where staId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
self.ch_id.setText(str(self.data[0][0]))
self.ch_name.setText(self.data[0][1])
self.ch_dep.setText(self.data[0][2])
self.ch_work.setText(self.data[0][3])
self.ch_date.setDate(QDate(self.data[0][4]))
def __init__(self,user_id):
super(mon_modify_panel,self).__init__()
self.setupUi(self)
self.user_id=user_id
sql='select * from monthrecord where staId=%s'
self.data=LinkMysql().select_sql(sql,user_id)
self.mon_id.setText(str(self.data[0][0]))
self.mon_name.setText(self.data[0][1])
self.mon_date.setText(str(self.data[0][2]))
self.mon_awa.setText(str(self.data[0][3]))
self.mon_re.setText(self.data[0][4])
def __init__(self, user_id):
super(dep_modify_panel, self).__init__()
self.setupUi(self)
self.user_id = user_id
sql = 'select * from department where dId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
self.did_ln.setText(str(self.data[0][0]))
self.ddirname_ln.setText(self.data[0][1])
self.ddir_ln.setText(self.data[0][2])
self.ddir_tel.setText(self.data[0][3])
self.ddir_mail.setText(self.data[0][4])
self.dintr_ln.setText(self.data[0][5])
def __init__(self, user_id):
super(sys_admin_modify_panel, self).__init__()
self.setupUi(self)
self.user_id = user_id
sql = 'select * from sys_admin where aId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
self.id_ln.setText(str(self.data[0][0]))
self.name_ln.setText(self.data[0][1])
self.pw_ln.setText(self.data[0][2])
self.tel_ln.setText(self.data[0][3])
self.mail_ln.setText(str(self.data[0][4]))
self.dep_ln.setText(self.data[0][5])
self.work_ln.setText(self.data[0][6])
def save_to_database(self):
self.value = []
self.value.append(self.nsec_ln.text())
self.value.append(self.user_id)
print(self.value)
sql = "call pupdate(%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "修改成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生,请重试', QMessageBox.Retry)
print('Something wrong')
self.close()
def add_to_database(self):
self.value = []
self.value.append(self.mon_id.text())
self.value.append(self.mon_name.text())
self.value.append(self.mon_date.text())
self.value.append(self.mon_awa.text())
self.value.append(self.mon_re.toPlainText())
print(self.value)
sql = "INSERT INTO monthrecord values (%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生', QMessageBox.Retry)
print('Something wrong')
def order_data(self):
sql = "SELECT stId,stName,stDepartment,stPositionalTitles,stSex,stNum FROM staff order by stNum"
type = 1
data = LinkMysql().select_single(sql, type)
#数据的大小
row = len(data)
vol = len(data[0])
self.MyTable.setRowCount(row)
#构建表格插入数据
for i in range(row):
for j in range(vol):
temp_data = data[i][j] # 临时记录，不能直接插入表格
self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格
self.MyTable.setItem(i, j, self.data1)
print('This is order-area')
def add_to_database(self):
da = self.ch_date.date().toString('yyyy-MM-dd')
self.value = []
self.value.append(self.ch_id.text())
self.value.append(self.ch_name.text())
self.value.append(self.ch_dep.text())
self.value.append(self.ch_work.text())
self.value.append(da)
print(self.value)
sql = "INSERT INTO checking_in values (%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '有错误发生', QMessageBox.Retry)
print('Something wrong')
def refresh_data(self):
sql="SELECT staId,staPwd FROM sys_staff order by staId"
data=LinkMysql().select_single(sql,type)
#数据的大小
row = len(data)
vol = len(data[0])
self.MyTable.setRowCount(row)
#构建表格插入数据
for i in range(row):
for j in range(vol):
temp_data = data[i][j] # 临时记录，不能直接插入表格
self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格
self.MyTable.setItem(i, j, self.data1)
print('This is refresh-area')
def add_to_database(self):
self.value = []
self.value.append(self.did_ln.text())
self.value.append(self.ddirname_ln.text())
self.value.append(self.ddir_ln.text())
self.value.append(self.ddir_tel.text())
self.value.append(self.ddir_mail.text())
self.value.append(self.dintr_ln.toPlainText())
print(self.value)
sql = "INSERT INTO department values (%s,%s,%s,%s,%s,%s)"
if LinkMysql().commit_sql(sql, self.value):
QMessageBox.information(self, "温馨提示", "添加成功", QMessageBox.Ok)
print('You succeed')
else:
QMessageBox.warning(self, '温馨提示', '请检查部门id是否重复', QMessageBox.Retry)
print('Something wrong')
def __init__(self, user_id):
super(staff_bad_panel, self).__init__()
self.setupUi(self)
sql = 'select * from staff_bad where staId=%s'
self.data = LinkMysql().select_sql(sql, user_id)
print(self.data)
self.id.setText(str(self.data[0][0]))
self.name.setText(self.data[0][1])
self.dep.setText(self.data[0][2])
self.work.setText(self.data[0][3])
self.remark.setText(self.data[0][4])
self.id.setReadOnly(True)
self.name.setReadOnly(True)
self.dep.setReadOnly(True)
self.work.setReadOnly(True)
self.remark.setReadOnly(True)
def refresh_data(self):
sql = "SELECT dId,dName,dDirector FROM department order by dId"
type = 1
data = LinkMysql().select_single(sql, type)
#数据的大小
row = len(data)
vol = len(data[0])
self.MyTable.setRowCount(row)
#构建表格插入数据
for i in range(row):
for j in range(vol):
temp_data = data[i][j] # 临时记录，不能直接插入表格
self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格
self.MyTable.setItem(i, j, self.data1)
print('This is refresh-area')
def refresh_data(self):
sql = "SELECT staId,staName,staDep FROM checking_in order by Time desc"
type = 1
data = LinkMysql().select_single(sql, type)
#数据的大小
row = len(data)
vol = 3
self.MyTable.setRowCount(row)
#构建表格插入数据
for i in range(row):
for j in range(vol):
temp_data = data[i][j] # 临时记录，不能直接插入表格
self.data1 = QTableWidgetItem(str(temp_data)) # 转换后可插入表格
self.MyTable.setItem(i, j, self.data1)
print('This is refresh-area')