class MainWindow(AttendanceHandler, QtGui.QMainWindow): #M2 inharit attendanceHandler __doc__ = ''' This is the main window of the software ''' def __init__(self,parent = None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) conf = {'user':'******', 'password':'******'} self.db = DB(conf) self.query = self.db.query self.signal() self.today = str(datetime.datetime.today()).split()[0] self.today = '2013-12-10' self.attandance_table = self.ui.attandance_table self.ui.date_from.setDate(datetime.datetime.today()) self.ui.date_to.setDate(datetime.datetime.today()) self.holiday = ['2013-12-18'] #M3 its depands on holiday list self.get_shift_id(str(self.ui.shift.currentText())) self.show_day() def signal(self): QtCore.QObject.connect(self.ui.actionAdd_Employee,QtCore.SIGNAL("triggered()"),self.add_employee) QtCore.QObject.connect(self.ui.actionCompany_Setup,QtCore.SIGNAL("triggered()"),self.add_employer) QtCore.QObject.connect(self.ui.actionConfiguation,QtCore.SIGNAL("triggered()"),self.leave_configuration) QtCore.QObject.connect(self.ui.actionPostion_Configuration,QtCore.SIGNAL("triggered()"),self.add_position) QtCore.QObject.connect(self.ui.actionDepartment_Configuration,QtCore.SIGNAL("triggered()"),self.add_department) QtCore.QObject.connect(self.ui.actionShifting_Configuration,QtCore.SIGNAL("triggered()"),self.create_shift) QtCore.QObject.connect(self.ui.actionWages_Setup,QtCore.SIGNAL("triggered()"),self.wages_setup) QtCore.QObject.connect(self.ui.actionList_Of_Employee,QtCore.SIGNAL("triggered()"),self.list_of_emp) QtCore.QObject.connect(self.ui.actionBank_List,QtCore.SIGNAL("triggered()"),self.bank_list) QtCore.QObject.connect(self.ui.actionCreate_Public_Holiday,QtCore.SIGNAL("triggered()"),self.public_holiday) QtCore.QObject.connect(self.ui.actionAdvance_Payment,QtCore.SIGNAL("triggered()"),self.advance) QtCore.QObject.connect(self.ui.actionNon_Regular_Employee,QtCore.SIGNAL("triggered()"),self.non_regular_employee) QtCore.QObject.connect(self.ui.actionPay_Advance_Amount,QtCore.SIGNAL("triggered()"),self.pay_advance_amount) QtCore.QObject.connect(self.ui.search, QtCore.SIGNAL("clicked()"), self.show_day) QtCore.QObject.connect(self.ui.save, QtCore.SIGNAL("clicked()"), self.attandance) QtCore.QObject.connect(self.ui.shift,QtCore.SIGNAL("currentIndexChanged(QString)"),self.get_shift_id) QtCore.QObject.connect(self.ui.position,QtCore.SIGNAL("currentIndexChanged(QString)"),self.position_id) QtCore.QObject.connect(self.ui.actionEmployee_Details,QtCore.SIGNAL("triggered()"),self.emp_info) def emp_info(self): obj = AllInfo(self.query,empId='') obj.exec_() def add_employee(self): obj = EmployeeInformation(self.query,self.db) obj.exec_() def add_employer(self): obj = EmployerInformation(self.query,self.db) obj.exec_() def leave_configuration(self): obj = LeaveConfiguration(self.query,self.db) obj.exec_() def add_position(self): obj = PostionConf(self.query,self.db) obj.exec_() def add_department(self): obj = DepartmentConf(self.query,self.db) obj.exec_() def create_shift(self): obj = ShiftCreate(self.query,self.db) obj.exec_() def wages_setup(self): obj = WagesSetup(self.query) obj.exec_() def list_of_emp(self): obj = EmployeeList(self.query) obj.exec_() def bank_list(self): obj = BankSheet(self.query,self.db) obj.exec_() def non_regular_employee(self): obj = NonRegularEmployee(self.query,self.db) obj.exec_() def advance(self): obj = AdvancePayment(self.query,self.db) obj.exec_() def public_holiday(self): obj = PublicHoliday(self.query) obj.exec_() def pay_advance_amount(self): pass
class MainWindow(QtGui.QMainWindow): __doc__ = """ This is the main window of the software """ def __init__(self, parent=None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) conf = {"user": "******", "password": "******"} self.db = DB(conf) self.query = self.db.query self.signal() self.today = str(datetime.datetime.today()).split()[0] self.today = "2013-12-10" self.attandance_table = self.ui.attandance_table self.ui.date_from.setDate(datetime.datetime.today()) self.ui.date_to.setDate(datetime.datetime.today()) self.leave = [ ("", "Total Hour"), ("", "Plb Holiday"), ("", "Holiday"), ("", "Sick Leave"), ("", "Yearly"), ("", "Bereavement"), ("", "Voting"), ("", "Rate"), ("", "Gross Pay"), ("", "total"), ] self.shift_id, self.position_id = "", "" self.set_header() self.get_position_name() self.get_shift_name() self.phl = {"2013-12-13": "Publc H1", "2013-12-17": "Publc H2"} self.show_day() # self.attandance() def signal(self): QtCore.QObject.connect(self.ui.actionAdd_Employee, QtCore.SIGNAL("triggered()"), self.add_employee) QtCore.QObject.connect(self.ui.actionCompany_Setup, QtCore.SIGNAL("triggered()"), self.add_employer) QtCore.QObject.connect(self.ui.actionConfiguation, QtCore.SIGNAL("triggered()"), self.leave_configuration) QtCore.QObject.connect(self.ui.actionPostion_Configuration, QtCore.SIGNAL("triggered()"), self.add_position) QtCore.QObject.connect( self.ui.actionDepartment_Configuration, QtCore.SIGNAL("triggered()"), self.add_department ) QtCore.QObject.connect(self.ui.actionShifting_Configuration, QtCore.SIGNAL("triggered()"), self.create_shift) QtCore.QObject.connect(self.ui.actionWages_Setup, QtCore.SIGNAL("triggered()"), self.wages_setup) QtCore.QObject.connect(self.ui.actionList_Of_Employee, QtCore.SIGNAL("triggered()"), self.list_of_emp) QtCore.QObject.connect(self.ui.actionBank_List, QtCore.SIGNAL("triggered()"), self.bank_list) QtCore.QObject.connect(self.ui.actionCreate_Public_Holiday, QtCore.SIGNAL("triggered()"), self.public_holiday) QtCore.QObject.connect(self.ui.actionAdvance_Payment, QtCore.SIGNAL("triggered()"), self.advance) QtCore.QObject.connect( self.ui.actionNon_Regular_Employee, QtCore.SIGNAL("triggered()"), self.non_regular_employee ) QtCore.QObject.connect(self.ui.actionPay_Advance_Amount, QtCore.SIGNAL("triggered()"), self.pay_advance_amount) QtCore.QObject.connect(self.ui.search, QtCore.SIGNAL("clicked()"), self.show_day) QtCore.QObject.connect(self.ui.save, QtCore.SIGNAL("clicked()"), self.attandance) QtCore.QObject.connect(self.ui.shift, QtCore.SIGNAL("currentIndexChanged(QString)"), self.get_shift_id) QtCore.QObject.connect(self.ui.position, QtCore.SIGNAL("currentIndexChanged(QString)"), self.position_id) QtCore.QObject.connect(self.ui.actionEmployee_Details, QtCore.SIGNAL("triggered()"), self.emp_info) def emp_info(self): obj = AllInfo(self.query, empId="") obj.exec_() def position_id(self, var): self.query.exec_(""" select positions_id from positions where title = '%s' """ % (var)) while self.query.next(): self.position_id = self.query.value(0).toInt()[0] ############## position id is here return self.position_id def get_shift_id(self, var): self.query.exec_(""" select regular_wages_setup_id from regular_wages_setup where title = '%s' """ % (var)) while self.query.next(): self.shift_id = self.query.value(0).toInt()[0] ################ shift_id is here self.query.exec_( """select first_name,last_name from employee_information where regular_wages_setup_id = '%s' and positions_id_positions = '%s' """ % (self.shift_id, self.position_id) ) empList = [] while self.query.next(): empList.append(str(self.query.value(0).toString()) + " " + str(self.query.value(1).toString())) self.ui.attandance_table.setRowCount(len(empList)) for i, j in enumerate(empList): item = QtGui.QTableWidgetItem("%s" % j) self.ui.attandance_table.setItem(i, 0, item) # self.query.exec_(""" select employee_information_id,regular_wages_setup_id,working_hour,positions_id,leaves_id # from attendance where date '%s' between '%s'; """%(self.ui.date_from.)) while self.query.next(): empID = self.query.value(0).toString() self.query.exec_(""" select """) def add_employee(self): obj = EmployeeInformation(self.query, self.db) obj.exec_() def add_employer(self): obj = EmployerInformation(self.query, self.db) obj.exec_() def leave_configuration(self): obj = LeaveConfiguration(self.query, self.db) obj.exec_() def add_position(self): obj = PostionConf(self.query, self.db) obj.exec_() def add_department(self): obj = DepartmentConf(self.query, self.db) obj.exec_() def create_shift(self): obj = ShiftCreate(self.query, self.db) obj.exec_() def wages_setup(self): obj = WagesSetup(self.query) obj.exec_() def list_of_emp(self): obj = EmployeeList(self.query) obj.exec_() def bank_list(self): obj = BankSheet(self.query, self.db) obj.exec_() def non_regular_employee(self): obj = NonRegularEmployee(self.query, self.db) obj.exec_() def advance(self): obj = AdvancePayment(self.query, self.db) obj.exec_() def public_holiday(self): obj = PublicHoliday(self.query) obj.exec_() def pay_advance_amount(self): pass # obj = PayAdvanceAmount(self.query) # obj.exec_() def get_shift_name(self): try: shiftList = [] self.query.exec_(""" select title from regular_wages_setup ;""") while self.query.next(): shiftList.append(self.query.value(0).toString()) self.ui.shift.addItems(shiftList) except Exception, e: print e
class MainWindow(AttendanceHandler, QtGui.QMainWindow): #M2 inharit attendanceHandler __doc__ = ''' This is the main window of the software ''' def __init__(self, parent=None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) conf = {'user': '******', 'password': '******'} self.db = DB(conf) self.query = self.db.query self.signal() self.today = str(datetime.datetime.today()).split()[0] self.today = '2013-12-10' self.attandance_table = self.ui.attandance_table self.ui.date_from.setDate(datetime.datetime.today()) self.ui.date_to.setDate(datetime.datetime.today()) self.holiday = ['2013-12-18'] #M3 its depands on holiday list self.get_shift_id(str(self.ui.shift.currentText())) self.show_day() def signal(self): QtCore.QObject.connect(self.ui.actionAdd_Employee, QtCore.SIGNAL("triggered()"), self.add_employee) QtCore.QObject.connect(self.ui.actionCompany_Setup, QtCore.SIGNAL("triggered()"), self.add_employer) QtCore.QObject.connect(self.ui.actionConfiguation, QtCore.SIGNAL("triggered()"), self.leave_configuration) QtCore.QObject.connect(self.ui.actionPostion_Configuration, QtCore.SIGNAL("triggered()"), self.add_position) QtCore.QObject.connect(self.ui.actionDepartment_Configuration, QtCore.SIGNAL("triggered()"), self.add_department) QtCore.QObject.connect(self.ui.actionShifting_Configuration, QtCore.SIGNAL("triggered()"), self.create_shift) QtCore.QObject.connect(self.ui.actionWages_Setup, QtCore.SIGNAL("triggered()"), self.wages_setup) QtCore.QObject.connect(self.ui.actionList_Of_Employee, QtCore.SIGNAL("triggered()"), self.list_of_emp) QtCore.QObject.connect(self.ui.actionBank_List, QtCore.SIGNAL("triggered()"), self.bank_list) QtCore.QObject.connect(self.ui.actionCreate_Public_Holiday, QtCore.SIGNAL("triggered()"), self.public_holiday) QtCore.QObject.connect(self.ui.actionAdvance_Payment, QtCore.SIGNAL("triggered()"), self.advance) QtCore.QObject.connect(self.ui.actionNon_Regular_Employee, QtCore.SIGNAL("triggered()"), self.non_regular_employee) QtCore.QObject.connect(self.ui.actionPay_Advance_Amount, QtCore.SIGNAL("triggered()"), self.pay_advance_amount) QtCore.QObject.connect(self.ui.search, QtCore.SIGNAL("clicked()"), self.show_day) QtCore.QObject.connect(self.ui.save, QtCore.SIGNAL("clicked()"), self.attandance) QtCore.QObject.connect(self.ui.shift, QtCore.SIGNAL("currentIndexChanged(QString)"), self.get_shift_id) QtCore.QObject.connect(self.ui.position, QtCore.SIGNAL("currentIndexChanged(QString)"), self.position_id) QtCore.QObject.connect(self.ui.actionEmployee_Details, QtCore.SIGNAL("triggered()"), self.emp_info) def emp_info(self): obj = AllInfo(self.query, empId='') obj.exec_() def add_employee(self): obj = EmployeeInformation(self.query, self.db) obj.exec_() def add_employer(self): obj = EmployerInformation(self.query, self.db) obj.exec_() def leave_configuration(self): obj = LeaveConfiguration(self.query, self.db) obj.exec_() def add_position(self): obj = PostionConf(self.query, self.db) obj.exec_() def add_department(self): obj = DepartmentConf(self.query, self.db) obj.exec_() def create_shift(self): obj = ShiftCreate(self.query, self.db) obj.exec_() def wages_setup(self): obj = WagesSetup(self.query) obj.exec_() def list_of_emp(self): obj = EmployeeList(self.query) obj.exec_() def bank_list(self): obj = BankSheet(self.query, self.db) obj.exec_() def non_regular_employee(self): obj = NonRegularEmployee(self.query, self.db) obj.exec_() def advance(self): obj = AdvancePayment(self.query, self.db) obj.exec_() def public_holiday(self): obj = PublicHoliday(self.query) obj.exec_() def pay_advance_amount(self): pass
class MainWindow(QtGui.QMainWindow): __doc__ = ''' This is the main window of the software ''' def __init__(self, parent=None): QtGui.QWidget.__init__(self, parent) self.ui = Ui_MainWindow() self.ui.setupUi(self) conf = {'user': '******', 'password': '******'} self.db = DB(conf) self.query = self.db.query self.signal() self.today = str(datetime.datetime.today()).split()[0] self.today = '2013-12-10' self.attandance_table = self.ui.attandance_table self.ui.date_from.setDate(datetime.datetime.today()) self.ui.date_to.setDate(datetime.datetime.today()) self.leave = [('', 'Total Hour'), ('', 'Plb Holiday'), ('', 'Holiday'), ('', 'Sick Leave'), ('', 'Yearly'), ('', 'Bereavement'), ('', 'Voting'), ('', 'Rate'), ('', 'Gross Pay'), ('', 'total')] self.shift_id, self.position_id = '', '' self.set_header() self.get_position_name() self.get_shift_name() self.phl = {'2013-12-13': 'Publc H1', '2013-12-17': 'Publc H2'} self.show_day() #self.attandance() def signal(self): QtCore.QObject.connect(self.ui.actionAdd_Employee, QtCore.SIGNAL("triggered()"), self.add_employee) QtCore.QObject.connect(self.ui.actionCompany_Setup, QtCore.SIGNAL("triggered()"), self.add_employer) QtCore.QObject.connect(self.ui.actionConfiguation, QtCore.SIGNAL("triggered()"), self.leave_configuration) QtCore.QObject.connect(self.ui.actionPostion_Configuration, QtCore.SIGNAL("triggered()"), self.add_position) QtCore.QObject.connect(self.ui.actionDepartment_Configuration, QtCore.SIGNAL("triggered()"), self.add_department) QtCore.QObject.connect(self.ui.actionShifting_Configuration, QtCore.SIGNAL("triggered()"), self.create_shift) QtCore.QObject.connect(self.ui.actionWages_Setup, QtCore.SIGNAL("triggered()"), self.wages_setup) QtCore.QObject.connect(self.ui.actionList_Of_Employee, QtCore.SIGNAL("triggered()"), self.list_of_emp) QtCore.QObject.connect(self.ui.actionBank_List, QtCore.SIGNAL("triggered()"), self.bank_list) QtCore.QObject.connect(self.ui.actionCreate_Public_Holiday, QtCore.SIGNAL("triggered()"), self.public_holiday) QtCore.QObject.connect(self.ui.actionAdvance_Payment, QtCore.SIGNAL("triggered()"), self.advance) QtCore.QObject.connect(self.ui.actionNon_Regular_Employee, QtCore.SIGNAL("triggered()"), self.non_regular_employee) QtCore.QObject.connect(self.ui.actionPay_Advance_Amount, QtCore.SIGNAL("triggered()"), self.pay_advance_amount) QtCore.QObject.connect(self.ui.search, QtCore.SIGNAL("clicked()"), self.show_day) QtCore.QObject.connect(self.ui.save, QtCore.SIGNAL("clicked()"), self.attandance) QtCore.QObject.connect(self.ui.shift, QtCore.SIGNAL("currentIndexChanged(QString)"), self.get_shift_id) QtCore.QObject.connect(self.ui.position, QtCore.SIGNAL("currentIndexChanged(QString)"), self.position_id) QtCore.QObject.connect(self.ui.actionEmployee_Details, QtCore.SIGNAL("triggered()"), self.emp_info) def emp_info(self): obj = AllInfo(self.query, empId='') obj.exec_() def position_id(self, var): self.query.exec_( """ select positions_id from positions where title = '%s' """ % (var)) while self.query.next(): self.position_id = self.query.value(0).toInt()[ 0] ############## position id is here return self.position_id def get_shift_id(self, var): self.query.exec_( """ select regular_wages_setup_id from regular_wages_setup where title = '%s' """ % (var)) while self.query.next(): self.shift_id = self.query.value(0).toInt()[ 0] ################ shift_id is here self.query.exec_( """select first_name,last_name from employee_information where regular_wages_setup_id = '%s' and positions_id_positions = '%s' """ % (self.shift_id, self.position_id)) empList = [] while self.query.next(): empList.append( str(self.query.value(0).toString()) + ' ' + str(self.query.value(1).toString())) self.ui.attandance_table.setRowCount(len(empList)) for i, j in enumerate(empList): item = QtGui.QTableWidgetItem('%s' % j) self.ui.attandance_table.setItem(i, 0, item) #self.query.exec_(""" select employee_information_id,regular_wages_setup_id,working_hour,positions_id,leaves_id # from attendance where date '%s' between '%s'; """%(self.ui.date_from.)) while self.query.next(): empID = self.query.value(0).toString() self.query.exec_(""" select """) def add_employee(self): obj = EmployeeInformation(self.query, self.db) obj.exec_() def add_employer(self): obj = EmployerInformation(self.query, self.db) obj.exec_() def leave_configuration(self): obj = LeaveConfiguration(self.query, self.db) obj.exec_() def add_position(self): obj = PostionConf(self.query, self.db) obj.exec_() def add_department(self): obj = DepartmentConf(self.query, self.db) obj.exec_() def create_shift(self): obj = ShiftCreate(self.query, self.db) obj.exec_() def wages_setup(self): obj = WagesSetup(self.query) obj.exec_() def list_of_emp(self): obj = EmployeeList(self.query) obj.exec_() def bank_list(self): obj = BankSheet(self.query, self.db) obj.exec_() def non_regular_employee(self): obj = NonRegularEmployee(self.query, self.db) obj.exec_() def advance(self): obj = AdvancePayment(self.query, self.db) obj.exec_() def public_holiday(self): obj = PublicHoliday(self.query) obj.exec_() def pay_advance_amount(self): pass #obj = PayAdvanceAmount(self.query) #obj.exec_() def get_shift_name(self): try: shiftList = [] self.query.exec_(""" select title from regular_wages_setup ;""") while self.query.next(): shiftList.append(self.query.value(0).toString()) self.ui.shift.addItems(shiftList) except Exception, e: print e