def __init__(self, query, parent=None):
QtGui.QDialog.__init__(self, parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.query = query
QtCore.QObject.connect(self.ui.comboBox,
QtCore.SIGNAL("currentIndexChanged(QString)"),
self.add)
QtCore.QObject.connect(self.ui.comboBox_2,
QtCore.SIGNAL("currentIndexChanged(QString)"),
self.get_data)
def __init__(self,query,parent = None):
QtGui.QDialog.__init__(self,parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.query = query
QtCore.QObject.connect(self.ui.comboBox,QtCore.SIGNAL("currentIndexChanged(QString)"),self.add)
QtCore.QObject.connect(self.ui.comboBox_2,QtCore.SIGNAL("currentIndexChanged(QString)"),self.get_data)
class EmployeeList(QtGui.QDialog):
def __init__(self,query,parent = None):
QtGui.QDialog.__init__(self,parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.query = query
QtCore.QObject.connect(self.ui.comboBox,QtCore.SIGNAL("currentIndexChanged(QString)"),self.add)
QtCore.QObject.connect(self.ui.comboBox_2,QtCore.SIGNAL("currentIndexChanged(QString)"),self.get_data)
def add(self,strg) :
self.ui.comboBox_2.show()
self.ui.comboBox_2.clear()
if strg == 'Payment Type Wise' :
self.ui.comboBox_2.clear()
li = ['Contract-Based','Salary-Based','Wages-Based']
self.ui.comboBox_2.addItems(li)
if strg == 'Shift Wise' :
self.ui.comboBox_2.clear()
self.titleList = []
self.query.exec_(""" select title from regular_wages_setup ;""")
while self.query.next():
self.titleList.append(self.query.value(0).toString())
self.query.exec_(""" select title from non_regular_wages_setup ;""")
while self.query.next():
self.titleList.append(self.query.value(0).toString())
self.ui.comboBox_2.addItems(self.titleList)
def get_data(self,strg) :
dataList = []
if strg == 'Wages-Based' :
self.query.exec_(""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """%('Wages'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if strg == 'Salary-Based' :
self.query.exec_(""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """%('Salary'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if strg == 'Contract-Based' :
self.query.exec_(""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """%('Contract'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if self.titleList :
ids = []
for i in range(len(self.titleList)) :
try :
self.query.exec_(""" select regular_wages_setup_id from regular_wages_setup where title='%s' ;"""%(self.titleList[i]))
while self.query.next():
ids.append(self.query.value(0).toInt()[0])
self.query.exec_(""" select non_regular_wages_setup_id from non_regular_wages_setup where title='%s' ;"""%(self.titleList[i]))
while self.query.next():
ids.append(self.query.value(0).toInt()[0])
except Exception, e:
print e
print "lis is",ids
for i in range(len(ids)):
try :
dataList = []
self.query.exec_(""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where regular_wages_setup_id = %s """%(ids[i]))
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.query.value(7).toInt()[0]))
self.query.exec_(""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where non_regular_wages_setup_id = %s """%(ids[i]))
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.query.value(7).toInt()[0]))
except Exception, e:
print e
self.enter_data(dataList)
class EmployeeList(QtGui.QDialog):
def __init__(self, query, parent=None):
QtGui.QDialog.__init__(self, parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
self.query = query
QtCore.QObject.connect(self.ui.comboBox,
QtCore.SIGNAL("currentIndexChanged(QString)"),
self.add)
QtCore.QObject.connect(self.ui.comboBox_2,
QtCore.SIGNAL("currentIndexChanged(QString)"),
self.get_data)
def add(self, strg):
self.ui.comboBox_2.show()
self.ui.comboBox_2.clear()
if strg == 'Payment Type Wise':
self.ui.comboBox_2.clear()
li = ['Contract-Based', 'Salary-Based', 'Wages-Based']
self.ui.comboBox_2.addItems(li)
if strg == 'Shift Wise':
self.ui.comboBox_2.clear()
self.titleList = []
self.query.exec_(""" select title from regular_wages_setup ;""")
while self.query.next():
self.titleList.append(self.query.value(0).toString())
self.query.exec_(
""" select title from non_regular_wages_setup ;""")
while self.query.next():
self.titleList.append(self.query.value(0).toString())
self.ui.comboBox_2.addItems(self.titleList)
def get_data(self, strg):
dataList = []
if strg == 'Wages-Based':
self.query.exec_(
""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """
% ('Wages'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if strg == 'Salary-Based':
self.query.exec_(
""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """
% ('Salary'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if strg == 'Contract-Based':
self.query.exec_(
""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where payment_type='%s' """
% ('Contract'))
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.query.value(7).toInt()[0]))
self.enter_data(dataList)
if self.titleList:
ids = []
for i in range(len(self.titleList)):
try:
self.query.exec_(
""" select regular_wages_setup_id from regular_wages_setup where title='%s' ;"""
% (self.titleList[i]))
while self.query.next():
ids.append(self.query.value(0).toInt()[0])
self.query.exec_(
""" select non_regular_wages_setup_id from non_regular_wages_setup where title='%s' ;"""
% (self.titleList[i]))
while self.query.next():
ids.append(self.query.value(0).toInt()[0])
except Exception, e:
print e
print "lis is", ids
for i in range(len(ids)):
try:
dataList = []
self.query.exec_(
""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where regular_wages_setup_id = %s """
% (ids[i]))
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.query.value(7).toInt()[0]))
self.query.exec_(
""" select first_name,last_name,address,mobile_no1,account_no,rate,date_of_joining,employee_information_id
from employee_information where non_regular_wages_setup_id = %s """
% (ids[i]))
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.query.value(7).toInt()[0]))
except Exception, e:
print e
self.enter_data(dataList)
