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()
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 __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()
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()
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(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(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
