forked from mohitsarla/wages
/
nonRegularEmployee.py
66 lines (59 loc) · 3.27 KB
/
nonRegularEmployee.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
from PyQt4 import QtCore, QtGui
from Ui.nonRegularEmployee import Ui_Dialog
import testdb
class NonRegularEmployee(QtGui.QDialog):
def __init__(self,query,db,parent = None):
QtGui.QDialog.__init__(self,parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.query = query
self.add_shift()
QtCore.QObject.connect(self.ui.comboBox,QtCore.SIGNAL('currentIndexChanged(QString)'),self.get_emp)
QtCore.QObject.connect(self.ui.save,QtCore.SIGNAL("clicked()"),self.onclick_save)
def add_shift(self):
self.shiftList = []
self.query.exec_(""" select title from non_regular_wages_setup ;""")
while self.query.next():
self.shiftList.append(self.query.value(0).toString())
self.ui.comboBox.addItems(self.shiftList)
dataList = []
self.query.exec_(""" select employee_name,employee_id,salary,date,bonus,comissions,tips from non_regular_wages_employee_info ;""")
while self.query.next():
dataList.append((self.query.value(0).toString(),self.query.value(1).toString(),self.query.value(2).toString(),self.query.value(3).toString(),
self.query.value(4).toString(),self.query.value(5).toString(),self.query.value(6).toString()))
self.ui.tableWidget_3.setRowCount(len(dataList))
for i in range(len(dataList)):
for j in range(len(dataList[i])):
item = QtGui.QTableWidgetItem(str(dataList[i][j]))
self.ui.tableWidget_3.setItem(i,j,item)
def get_emp(self,var):
print "vaar is",var
dataList = []
self.query.exec_(""" select non_regular_wages_setup_id from non_regular_wages_setup where title = '%s' """%(var))
while self.query.next():
self.id = self.query.value(0).toInt()[0]
print "====",self.id
self.query.exec_(""" select first_name,last_name,employee_id,rate from employee_information where non_regular_wages_setup_id = %s """%(self.id))
while self.query.next():
dataList.append((self.query.value(0).toString()+' '+self.query.value(1).toString(),self.query.value(2).toString(),self.query.value(3).toString()))
self.ui.tableWidget_3.setRowCount(len(dataList))
for i in range(len(dataList)):
for j in range(len(dataList[i])):
item = QtGui.QTableWidgetItem(str(dataList[i][j]))
self.ui.tableWidget_3.setItem(i,j,item)
def onclick_save(self) :
self.ui.save.setEnabled(False)
li = []
for row in range(self.ui.tableWidget_3.rowCount()):
rowdata = []
for column in range(self.ui.tableWidget_3.columnCount()):
item = self.ui.tableWidget_3.item(row,column)
rowdata.append(str(item.text()))
li.append(tuple(rowdata))
print "--------------",li
for i in li:
print "i is",i
self.query.exec_(""" insert into non_regular_wages_employee_info (title,employee_name,employee_id,salary,date,bonus,comissions,tips)
values('%s','%s','%s','%s','%s','%s','%s','%s')"""%(self.ui.comboBox.currentText(),i[0],i[1],i[2],i[3],i[4],i[5],i[6]))
print self.query.isActive()
QtGui.QMessageBox.information(self,'Message','Record Inserted Successfully !!!')