def __init__(self,query,db,parent=None):
QtGui.QDialog.__init__(self,parent)
self.ui = Ui_Position()
self.ui.setupUi(self)
self.query = query
self.db = db
self.signal()
self.fetch_dept()
class PostionConf(QtGui.QDialog):
def __init__(self,query,db,parent=None):
QtGui.QDialog.__init__(self,parent)
self.ui = Ui_Position()
self.ui.setupUi(self)
self.query = query
self.db = db
self.signal()
self.fetch_dept()
def signal(self):
QtCore.QObject.connect(self.ui.add,QtCore.SIGNAL("clicked()"),self.onclick_add)
def onclick_add(self):
if len(str(self.ui.positionName.text())) == 0 :
QtGui.QMessageBox.warning(self,'Warning','Please Add Position !!!')
else :
self.query.exec_("""insert into positions (title) values ('%s')"""%(self.ui.positionName.text()))
self.fetch_dept()
QtGui.QMessageBox.information(self,'Information','Position Saved !!!')
self.ui.positionName.clear()
def fetch_dept(self):
self.ui.treeWidget.clear()
self.query.exec_(""" select title from positions ;""")
dept = []
while self.query.next():
dept.append(self.query.value(0).toString())
for i in range(len(dept)):
item = QtGui.QTreeWidgetItem(self.ui.treeWidget)
item.setText(0, dept[i])
