人事管理系统

# -*- coding: utf-8 -*- from openerp import tools import time import datetime import math from dateutil import relativedelta from openerp import SUPERUSER_ID from openerp.osv import osv, fields from openerp.tools.translate import _ from openerp import api, tools import openerp.addons.decimal_precision as dp from openerp.tools.safe_eval import safe_eval as eval from datetime import timedelta class hr_salary_rule_category(osv.osv): _inherit='hr.salary.rule.category' _rec_name="code" # 主键约束 _sql_constraints=[ ('name_uniq','unique(code)',u'编码已存在，请重新录入！'), ] class hr_salary_rule(osv.osv): _inherit='hr.salary.rule' _rec_name="code" # 主键约束 _sql_constraints=[ ('name_uniq','unique(code)',u'编码已存在，请重新录入！'), ] class hr_payroll_structure(osv.osv): _inherit='hr.payroll.structure' # 主键约束 _sql_constraints=[ ('name_uniq','unique(code)',u'编码已存在，请重新录入！'), ] class hr_payroll_structure(osv.osv): _inherit='hr.payroll.structure' _columns={ 'rule_ids':fields.many2many('hr.salary.rule', 'hr_structure_salary_rule_rel', 'struct_id', 'rule_id', 'Salary Rules'), } class xwage_change(osv.osv): _name='xwage.change' _description=u'工资变动'# 对象名 _columns={ 'xwage_num':fields.char(u'工资变动单',readonly=True), 'xwage_company':fields.many2one('res.company',u'公司',), 'xcompany_name':fields.char(u'公司名称',), 'xwage_employee':fields.many2one('hr.employee',u'员工'), 'xemployee_name':fields.char(u'员工名称'), 'xreg_date':fields.date(u'登记日期',readonly=True), 'xeffective_date':fields.date(u'生效日期',readonly=True), 'xwage_sta':fields.selection([('1',u'草稿'),('2',u'待确认'),('3',u'待生效'),('4',u'已生效')],u'是否生效',readonly=True), 'xwage_change0':fields.one2many('xwage.change.old','change_old',u'对应子表'), 'rule_ids':fields.many2many('hr.salary.rule', 'xwage_change_rule_rel', 'struct_id', 'rule_id', 'Salary Rules'), 'struct_id': fields.many2one('hr.payroll.structure', u'结构'), 'date_from': fields.date(u'开始日期', required=True), 'date_to': fields.date(u'结束日期',required=True), 'contract_id': fields.many2one('hr.contract', u'合同', required=True), } _defaults={ 'xreg_date':datetime.datetime.now(), 'xwage_sta':'1', 'date_from': lambda *a: time.strftime('%Y-%m-01'), 'date_to': lambda *a: str(datetime.datetime.now() + relativedelta.relativedelta(months=+1, day=1, days=-1))[:10], } _rec_name="xwage_num" def onchange_xwage_company(self, cr, uid, ids, xwage_employee, context=None): res = {} if xwage_employee: pdocbg = self.pool.get('res.company').browse(cr, uid, xwage_employee ,context=context) res['xcompany_name'] = pdocbg.name return{'value':res} # 重写新建函数，生成流水号 def create_sequence(self, cr, uid, vals, context=None): """ 创建序列号 """ seq = { 'name': vals['prefix'], 'implementation': 'no_gap', 'prefix': vals['prefix'], 'padding': 3, 'number_increment': 1 } if 'company_id' in vals: seq['company_id'] = vals['company_id'] yseq_id = self.pool.get('ir.sequence').search(cr, uid, [('name', '=', seq['name'])]) yflg = 0 for rec in self.pool.get('ir.sequence').browse(cr, uid, yseq_id): yflg = 1 break if yflg: return self.pool.get('ir.sequence').browse(cr, uid, yseq_id[0]).id else: return self.pool.get('ir.sequence').create(cr, uid, seq) #重置创建函数添加一条新数据 def create(self, cr, uid, vals, context=None): if not 'sequence_id' in vals or not vals['sequence_id']: # 如果没有序列号，则新建 prefix ="GZBD"+str(datetime.datetime.now().strftime('%y'))+str(datetime.datetime.now().strftime('%m')) vals.update({'prefix':prefix}) vals.update({'sequence_id': self.create_sequence(cr, SUPERUSER_ID, vals, context)}) # 获取流水号 vals['xwage_num'] = self.pool.get('ir.sequence').get_id(cr, SUPERUSER_ID, vals['sequence_id']) return super(xwage_change, self).create(cr, uid, vals, context) def but_check(self, cr, uid, ids, context=None): lan= self.browse(cr, uid, ids, context) x=0 for ll in lan.rule_ids: for lp in ll: x=1 if x==1: self.write(cr, uid, ids, {"xwage_sta": '3'}, context=context) #获取工资变动后的信息 lcn=lan.struct_id #结构ID cr.execute("""DELETE FROM hr_structure_salary_rule_rel where struct_id= %s """,(lcn.id,)) for xa in lan.rule_ids: for xb in xa: code=xb.id #工资规则编码 #获取当前工资结构的明细ID cr.execute("""INSERT INTO hr_structure_salary_rule_rel(struct_id, rule_id) VALUES (%s, %s)""",(lcn.id,code)) else: raise osv.except_osv(u"警告：" ,u"工资结构无任何变动信息!") return True def but_queren(self, cr, uid, ids, context=None): self.write(cr, uid, ids, {"xeffective_date": datetime.datetime.now()}, context=context) self.write(cr, uid, ids, {"xwage_sta": '4'}, context=context) def onchange_employee_id(self, cr, uid, ids, date_from, date_to,xwage_employee=False, contract_id=False, context=None): empolyee_obj = self.pool.get('hr.employee') contract_obj = self.pool.get('hr.contract') input_obj = self.pool.get('hr.payslip.input') #defaults res = {'value':{ 'contract_id': False,'struct_id': False}} if (not xwage_employee) or (not date_from) or (not date_to): return res xemployee_name = empolyee_obj.browse(cr, uid,xwage_employee, context=context) res['value'].update({'xemployee_name': xemployee_name.name}) if contract_id: #set the list of contract for which the input have to be filled contract_ids = [contract_id] else: #if we don't give the contract, then the input to fill should be for all current contracts of the employee contract_ids = self.get_contract(cr, uid,xwage_employee, date_from, date_to, context=context) if not contract_ids: return res contract_record = contract_obj.browse(cr, uid, contract_ids[0], context=context) res['value'].update({ 'contract_id': contract_record and contract_record.id or False }) struct_record = contract_record and contract_record.struct_id or False if not struct_record: return res res['value'].update({ 'struct_id': struct_record.id, }) return res def get_contract(self, cr, uid, employee, date_from, date_to, context=None): """ @param employee: browse record of employee @param date_from: date field @param date_to: date field @return: returns the ids of all the contracts for the given employee that need to be considered for the given dates """ contract_obj = self.pool.get('hr.contract') clause = [] #a contract is valid if it ends between the given dates clause_1 = ['&',('date_end', '<=', date_to),('date_end','>=', date_from)] #OR if it starts between the given dates clause_2 = ['&',('date_start', '<=', date_to),('date_start','>=', date_from)] #OR if it starts before the date_from and finish after the date_end (or never finish) clause_3 = ['&',('date_start','<=', date_from),'|',('date_end', '=', False),('date_end','>=', date_to)] clause_final = [('employee_id', '=', employee),'|','|'] + clause_1 + clause_2 + clause_3 contract_ids = contract_obj.search(cr, uid, clause_final, context=context) return contract_ids def onchange_contract_id(self, cr, uid, ids, date_from, date_to,xwage_employee=False, contract_id=False, context=None): #TODO it seems to be the mess in the onchanges, we should have onchange_employee => onchange_contract => doing all the things res = {'value':{ } } context = dict(context or {}, contract=True) if not contract_id: res['value'].update({'struct_id': False}) return self.onchange_employee_id(cr, uid, ids, date_from=date_fr