コード例 #1
0
ファイル: listOfEmployee.py プロジェクト: skyview059/wages
class Short_EmployeeList(QtGui.QDialog):
    def __init__(self, query, parent=None):
        QtGui.QDialog.__init__(self, parent)
        self.ui = Ui_EmpList()
        self.ui.setupUi(self)
        self.query = query

        QtCore.QObject.connect(self.ui.lineEdit,
                               QtCore.SIGNAL("textChanged(QString)"),
                               self.filter_data)
        QtCore.QObject.connect(
            self.ui.treeWidget,
            QtCore.SIGNAL("itemDoubleClicked(QTreeWidgetItem*,int)"),
            self.send_id)

        self.showdata()

    def send_id(self, item, text):
        name = item.text(0)
        empid = item.text(1)
        self.li = [name, empid]
        self.close()

    def get_list(self):
        return self.li

    def filter_data(self, var):
        li = []
        self.query.exec_(
            """ select first_name, last_name,employee_id from employee_information
                             where first_name LIKE '%s%%' or employee_id LIKE '%s%%' """
            % (var, var))
        while self.query.next():
            self.ui.treeWidget.clear()
            li.append((self.query.value(0).toString() + ' ' +
                       self.query.value(1).toString(),
                       self.query.value(2).toString()))
        for i in li:
            item = QtGui.QTreeWidgetItem(self.ui.treeWidget)
            item.setText(0, i[0])
            item.setText(1, i[1])

    def showdata(self):
        li = []
        self.query.exec_(
            """ select concat(first_name,' ',last_name),employee_id from employee_information ; """
        )
        while self.query.next():
            li.append((self.query.value(0).toString(),
                       self.query.value(1).toString()))
        for i in li:
            item = QtGui.QTreeWidgetItem(self.ui.treeWidget)
            item.setText(0, i[0])
            item.setText(1, i[1])
コード例 #2
0
ファイル: listOfEmployee.py プロジェクト: mohitsarla/wages
class AllInfo(QtGui.QDialog):
    def __init__(self,query,empId,parent = None):
        QtGui.QDialog.__init__(self,parent)
        self.ui = Ui_EmpList()
        self.ui.setupUi(self)
        self.query = query

        QtCore.QObject.connect(self.ui.lineEdit,QtCore.SIGNAL("textChanged(QString)"),self.filter_data)
        QtCore.QObject.connect(self.ui.treeWidget,QtCore.SIGNAL("itemDoubleClicked(QTreeWidgetItem*,int)"),self.send_id)
	     
        
        self.showdata()


    def send_id(self,item,text) :
        name = item.text(0)
        empid = item.text(1)
        self.li = [name,empid]
        self.query.exec_(""" select employee_information_id from employee_information where employee_id='%s' """%(empid))
        while self.query.next():
            empId = self.query.value(0).toString()
        
        obj = EmployeeAllInformation(self.query,empId)
        obj.exec_()
        


    def get_list(self):
        return self.li
    
    def filter_data(self,var):
        li = []
        self.query.exec_(""" select first_name, last_name,employee_id from employee_information
                             where first_name LIKE '%s%%' or employee_id LIKE '%s%%' """%(var,var)) 
        while self.query.next():
            self.ui.treeWidget.clear()
            li.append((self.query.value(0).toString()+' '+self.query.value(1).toString(),self.query.value(2).toString()))
        for i in li:
            item = QtGui.QTreeWidgetItem(self.ui.treeWidget)
            item.setText(0,i[0])
            item.setText(1,i[1])
            
    def showdata(self):
        li =[]
        self.query.exec_(""" select concat(first_name,' ',last_name),employee_id from employee_information ; """)
        while self.query.next():
            li.append((self.query.value(0).toString(),self.query.value(1).toString()))
        for i in li:
            item = QtGui.QTreeWidgetItem(self.ui.treeWidget)
            item.setText(0,i[0])
            item.setText(1,i[1])
コード例 #3
0
ファイル: listOfEmployee.py プロジェクト: skyview059/wages
    def __init__(self, query, empId, parent=None):
        QtGui.QDialog.__init__(self, parent)
        self.ui = Ui_EmpList()
        self.ui.setupUi(self)
        self.query = query

        QtCore.QObject.connect(self.ui.lineEdit,
                               QtCore.SIGNAL("textChanged(QString)"),
                               self.filter_data)
        QtCore.QObject.connect(
            self.ui.treeWidget,
            QtCore.SIGNAL("itemDoubleClicked(QTreeWidgetItem*,int)"),
            self.send_id)

        self.showdata()
コード例 #4
0
ファイル: listOfEmployee.py プロジェクト: mohitsarla/wages
    def __init__(self,query,empId,parent = None):
        QtGui.QDialog.__init__(self,parent)
        self.ui = Ui_EmpList()
        self.ui.setupUi(self)
        self.query = query

        QtCore.QObject.connect(self.ui.lineEdit,QtCore.SIGNAL("textChanged(QString)"),self.filter_data)
        QtCore.QObject.connect(self.ui.treeWidget,QtCore.SIGNAL("itemDoubleClicked(QTreeWidgetItem*,int)"),self.send_id)
	     
        
        self.showdata()