staff_wages/models/staff_wages.py
# -*- coding: utf-8 -*-
from odoo import fields, models, api
from odoo.exceptions import UserError
READONLY_STATES = {
'done': [('readonly', True)],
}
change = [('time', u'计时'),
('piece', u'计件'),
('efficiency', u'计效')]
class StaffWages(models.Model):
_name = 'staff.wages'
_description = u'员工工资'
_inherit = ['mail.thread']
_order = "name"
@api.one
@api.depends('date')
def _compute_period_id(self):
self.name = self.env['finance.period'].get_period(self.date)
date = fields.Date(u'记帐日期', required=True, states=READONLY_STATES)
name = fields.Many2one(
'finance.period',
u'会计期间',
compute='_compute_period_id', ondelete='restrict', store=True)
state = fields.Selection([('draft', u'草稿'),
('done', u'已完成')], u'状态', default='draft',
index=True,
)
line_ids = fields.One2many('wages.line', 'order_id', u'工资明细行', states=READONLY_STATES,
copy=True)
payment = fields.Many2one('bank.account', u'付款方式')
other_money_order = fields.Many2one('other.money.order', u'对应付款单', readonly=True, ondelete='restrict',
help=u'确认时生成的对应付款单', copy=False)
voucher_id = fields.Many2one(
'voucher', u'计提工资凭证', readonly=True, ondelete='restrict', copy=False)
change_voucher_id = fields.Many2one(
'voucher', u'修正计提凭证', readonly=True, ondelete='restrict', copy=False)
note = fields.Char(u'备注', help=u'本月备注')
totoal_wage = fields.Float(u'应发工资合计')
totoal_endowment = fields.Float(u'应扣养老合计')
totoal_health = fields.Float(u'应扣医疗合计')
totoal_unemployment = fields.Float(u'应扣失业合计')
totoal_housing_fund = fields.Float(u'应扣住房合计')
totoal_personal_tax = fields.Float(u'应扣个税合计')
totoal_amount = fields.Float(u'实发工资合计')
totoal_endowment_co = fields.Float(u'应扣公司养老合计')
totoal_health_co = fields.Float(u'应扣公司医疗合计')
totoal_unemployment_co = fields.Float(u'应扣公司失业合计')
totoal_housing_fund_co = fields.Float(u'应扣公司住房合计')
totoal_injury = fields.Float(u'应扣公司工伤保险合计',
help=u'公司承担的工伤保险合计')
totoal_maternity = fields.Float(u'应扣公司生育保险合计',
help=u'公司承担的生育保险合计')
@api.onchange('line_ids')
def _total_amount_wage(self):
# todo 测试onchange + compute
self.totoal_amount = sum(line.amount_wage for line in self.line_ids)
self.totoal_wage = sum(line.all_wage for line in self.line_ids)
self.totoal_endowment = sum(line.endowment for line in self.line_ids)
self.totoal_health = sum(line.health for line in self.line_ids)
self.totoal_unemployment = sum(
line.unemployment for line in self.line_ids)
self.totoal_housing_fund = sum(
line.housing_fund for line in self.line_ids)
self.totoal_personal_tax = sum(
line.personal_tax for line in self.line_ids)
self.totoal_endowment_co = sum(
line.endowment_co for line in self.line_ids)
self.totoal_health_co = sum(line.health_co for line in self.line_ids)
self.totoal_unemployment_co = sum(
line.unemployment_co for line in self.line_ids)
self.totoal_housing_fund_co = sum(
line.housing_fund_co for line in self.line_ids)
self.totoal_injury = sum(line.injury for line in self.line_ids)
self.totoal_maternity = sum(line.maternity for line in self.line_ids)
@api.one
def staff_wages_confirm(self):
"""
确认方法
:return:
"""
if self.state == 'done':
raise UserError(u'请不要重复确认')
if not self.voucher_id:
raise UserError(u'工资单还未计提，请先计提')
other_money_order = self._other_pay() # 支付工资的其他支出单
self.create_other_pay_housing_fund() # 住房公积金的其他支出单
self.create_other_pay_social_security() # 社保的其他支出单
self.write({
'other_money_order': other_money_order.id,
'state': 'done',
})
def voucher_unlink(self, voucher):
"""
删除凭证时，判断如果已确认则撤销确认并删除
:param voucher: 凭证
:return:
"""
if voucher.state == 'done':
voucher.voucher_draft()
return voucher.unlink()
@api.one
def staff_wages_accrued(self):
"""
计提方法，如计提凭证已存在，判断当前期间是否与工资期间相同。
如相同，反审核计提凭证并重新生成计提凭证；
如不同，生成并审核修正凭证。
:return:
"""
if not self.line_ids:
raise UserError(u'明细行不能为空')
if not self.voucher_id:
# 生成并审核计提凭证
voucher = self.create_voucher(self.date)
voucher.voucher_done()
self.voucher_id = voucher.id
else:
# 如计提凭证已存在，判断当前期间是否与工资期间相同
date = fields.Date.context_today(self)
if self.voucher_id.period_id == self.env['finance.period'].get_period(date):
# 如相同，反审核计提凭证并重新生成计提凭证
voucher, self.voucher_id = self.voucher_id, False
self.voucher_unlink(voucher)
voucher = self.create_voucher(self.date)
voucher.voucher_done()
self.voucher_id = voucher.id
else:
# 如不同，生成并审核修正凭证
self.change_voucher()
@api.one
def change_voucher(self):
"""
生成并审核修正计提凭证
:return:
"""
before_voucher = self.voucher_id
date = fields.Date.context_today(self)
if self.change_voucher_id:
# 如果修正计提凭证存在，则删除后重新生成修正计提凭证
change_voucher, self.change_voucher_id = self.change_voucher_id, False
self.voucher_unlink(change_voucher)
change_voucher = self.create_voucher(date)
for change_line in change_voucher.line_ids:
for before_line in before_voucher.line_ids:
if change_line.account_id == before_line.account_id \
and change_line.auxiliary_id == before_line.auxiliary_id:
change_line.credit -= before_line.credit
change_line.debit -= before_line.debit
continue
for change_line in change_voucher.line_ids:
if change_line.credit == 0 and change_line.debit == 0:
change_line.unlink()
if not change_voucher.line_ids:
change_voucher.unlink()
else:
change_voucher.voucher_done()
self.write({'change_voucher_id': change_voucher.id})
def create_credit_line(self, voucher, name, account, credit, auxiliary_id):
"""
生成贷方行
:param voucher: 凭证
:param name: 摘要
:param account: 借方科目
:param credit: 贷方金额
:return:
"""
vals = {
'voucher_id': voucher.id,
'name': name,
'account_id': account.id,
'credit': credit,
'auxiliary_id': auxiliary_id and auxiliary_id.id,
}
voucher_line = self.env['voucher.line'].create(vals)
return voucher_line
@api.multi
def create_voucher(self, date):
"""
生成并审核计提凭证
:param date: 一个日期
:return:
"""
self.ensure_one()
vouch_obj = self.env['voucher'].create({'date': date, 'ref': '%s,%s' % (self._name, self.id)})
credit_account = self.env.ref('staff_wages.staff_wages')
res = {}
for line in self.line_ids:
staff = self.env['staff.contract'].search(
[('staff_id', '=', line.name.id)])
debit_account = staff.job_id and staff.job_id.account_id \
or self.env.ref('finance.small_business_chart5602001')
if debit_account not in res:
res[debit_account] = {'debit': 0}
val = res[debit_account]
val.update({
'debit': val.get('debit') + line.all_wage + line.housing_fund_co
+ line.endowment_co + line.health_co + line.unemployment_co
+ line.injury + line.maternity,
'voucher_id': vouch_obj.id,
'account_id': debit_account.id,
'name': u'提本月工资'})
# 生成借方凭证行
for account_id, val in res.iteritems():
self.env['voucher.line'].create(
dict(val, account_id=account_id.id))
# 生成贷方凭证行
endowment_co = self.env.ref(
'staff_wages.categ_endowment_co') # 公司缴纳养老类别
health_co = self.env.ref('staff_wages.categ_health_co') # 公司缴纳医疗类别
unemployment_co = self.env.ref(
'staff_wages.categ_unemployment_co') # 公司缴纳失业类别
maternity = self.env.ref('staff_wages.categ_maternity') # 公司缴纳生育类别
injury = self.env.ref('staff_wages.categ_injury') # 公司缴纳工伤类别
housing_co = self.env.ref(
'staff_wages.categ_housing_fund_co') # 公司缴纳住房公积金类别
for line in self.line_ids:
self.create_credit_line(
vouch_obj, u'提本月工资', credit_account.account_id, line.all_wage, line.name.auxiliary_id)
self.create_credit_line(
vouch_obj, u'提本月养老保险', endowment_co.account_id, self.totoal_endowment_co, False)
self.create_credit_line(
vouch_obj, u'提本月医疗保险', health_co.account_id, self.totoal_health_co, False)
self.create_credit_line(
vouch_obj, u'提本月失业保险', unemployment_co.account_id, self.totoal_unemployment_co, False)
self.create_credit_line(
vouch_obj, u'提本月生育保险', maternity.account_id, self.totoal_maternity, False)
self.create_credit_line(vouch_obj, u'提本月工伤保险',
injury.account_id, self.totoal_injury, False)
self.create_credit_line(
vouch_obj, u'提本月公积金', housing_co.account_id, self.totoal_housing_fund_co, False)
return vouch_obj
@api.multi
def _other_pay(self):
'''选择结算账户，生成其他支出单 '''
self.ensure_one()
StaffWages = self.env.ref('staff_wages.staff_wages')
endowment = self.env.ref('staff_wages.endowment')
unemployment = self.env.ref('staff_wages.unemployment')
housing_fund = self.env.ref('staff_wages.housing_fund')
health = self.env.ref('staff_wages.health')
personal_tax = self.env.ref('staff_wages.personal_tax')
other_money_order = self.with_context(type='other_pay').env['other.money.order'].create({
'state': 'draft',
'date': fields.Date.context_today(self),
'bank_id': self.payment.id,
})
for line in self.line_ids:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': line.all_wage,
'category_id': StaffWages and StaffWages.id,
'auxiliary_id': line.name.auxiliary_id.id,
})
if self.totoal_endowment:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': -1 * self.totoal_endowment,
'category_id': endowment and endowment.id
})
if self.totoal_unemployment:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': -1 * self.totoal_unemployment,
'category_id': unemployment and unemployment.id
})
if self.totoal_housing_fund:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': -1 * self.totoal_housing_fund,
'category_id': housing_fund and housing_fund.id
})
if self.totoal_health:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': -1 * self.totoal_health,
'category_id': health and health.id
})
if self.totoal_personal_tax:
self.env['other.money.order.line'].create({
'other_money_id': other_money_order.id,
'amount': -1 * self.totoal_personal_tax,
'category_id': personal_tax and personal_tax.id
})
return other_money_order
@api.multi
def create_other_pay_housing_fund(self):
"""
生成住房公积金的其他支出单
审核时生成凭证：
借：应付职工薪酬-公积金 公司公积金
其他应付款-代扣公积金 个人公积金
贷： 付款方式对应的科目
:return: 其他支出单
"""
self.ensure_one()
housing_co = self.env.ref(
'staff_wages.categ_housing_fund_co') # 公司缴纳住房公积金类别
housing = self.env.ref('staff_wages.housing_fund') # 个人缴纳住房公积金类别
order = self.with_context(type='other_pay').env['other.money.order'].create({
'state': 'draft',
'date': fields.Date.context_today(self),
'bank_id': self.payment.id,
'note': self.name.name,
})
self.create_other_order_line(
order, housing_co, self.totoal_housing_fund_co)
self.create_other_order_line(order, housing, self.totoal_housing_fund)
return order
@api.multi
def create_other_pay_social_security(self):
"""
生成社保的其他支出单
审核时生成凭证：
借： 5个公司的，3个个人的
贷： 付款方式对应的科目
:return: 其他支出单
"""
self.ensure_one()
endowment_co = self.env.ref(
'staff_wages.categ_endowment_co') # 公司缴纳养老类别
health_co = self.env.ref('staff_wages.categ_health_co') # 公司缴纳医疗类别
unemployment_co = self.env.ref(
'staff_wages.categ_unemployment_co') # 公司缴纳失业类别
maternity = self.env.ref('staff_wages.categ_maternity') # 公司缴纳生育类别
injury = self.env.ref('staff_wages.categ_injury') # 公司缴纳工伤类别
endowment = self.env.ref('staff_wages.endowment') # 个人缴纳养老类别
health = self.env.ref('staff_wages.health') # 个人缴纳医疗类别
unemployment = self.env.ref('staff_wages.unemployment') # 个人缴纳失业类别
order = self.with_context(type='other_pay').env['other.money.order'].create({
'state': 'draft',
'date': fields.Date.context_today(self),
'bank_id': self.payment.id,
'note': self.name.name,
})
# 公司的
self.create_other_order_line(
order, endowment_co, self.totoal_endowment_co)
self.create_other_order_line(order, health_co, self.totoal_health_co)
self.create_other_order_line(
order, unemployment_co, self.totoal_unemployment_co)
self.create_other_order_line(order, maternity, self.totoal_maternity)
self.create_other_order_line(order, injury, self.totoal_injury)
# 个人的
self.create_other_order_line(order, endowment, self.totoal_endowment)
self.create_other_order_line(order, health, self.totoal_health)
self.create_other_order_line(
order, unemployment, self.totoal_unemployment)
return order
def create_other_order_line(self, order, category_id, amount):
"""
生成其他支出单明细行
:param order: 其他支出单
:param category_id: 类别
:param amount: 金额
:return:
"""
if amount:
line = self.env['other.money.order.line'].create({
'other_money_id': order.id,
'amount': amount,
'category_id': category_id and category_id.id
})
return line
@api.one
def staff_wages_draft(self):
if self.state == 'draft':
raise UserError(u'请不要重复撤销')
if self.other_money_order:
other_money_order = self.other_money_order
self.write({
'other_money_order': False,
'state': 'draft',
})
if other_money_order.state == 'done':
other_money_order.other_money_draft()
other_money_order.unlink()
@api.multi
def unlink(self):
"""
删除工资单同时（反审核并）删除对应的会计凭证
:return:
"""
for record in self:
# 先解除凭证和工资单关系，再将它们删除
voucher, record.voucher_id = record.voucher_id, False
change_voucher, record.change_voucher_id = record.change_voucher_id, False
self.voucher_unlink(voucher)
self.voucher_unlink(change_voucher)
return super(StaffWages, self).unlink()
class WagesLine(models.Model):
_name = 'wages.line'
_description = u'工资明细'
name = fields.Many2one('staff', u'员工', required=True)
date_number = fields.Float(u'出勤天数')
basic_wage = fields.Float(u'基础工资')
basic_date = fields.Float(u'基础天数')
wage = fields.Float(u'出勤工资', compute='_all_wage_value', store=True)
add_hour = fields.Float(u'加班小时')
add_wage = fields.Float(u'加班工资')
other_wage = fields.Float(u'补助')
deduction = fields.Float(u'扣款')
all_wage = fields.Float(u'应发工资', store=True, compute='_all_wage_value')
endowment = fields.Float(u'个人养老保险')
health = fields.Float(u'个人医疗保险')
unemployment = fields.Float(u'个人失业保险')
housing_fund = fields.Float(u'个人住房公积金')
endowment_co = fields.Float(u'公司养老保险',
help=u'公司承担的养老保险')
health_co = fields.Float(u'公司医疗保险',
help=u'公司承担的医疗保险')
unemployment_co = fields.Float(u'公司失业保险',
help=u'公司承担的失业保险')
injury = fields.Float(u'公司工伤保险',
help=u'公司承担的工伤保险')
maternity = fields.Float(u'公司生育保险',
help=u'公司承担的生育保险')
housing_fund_co = fields.Float(u'公司住房公积金',
help=u'公司承担的住房公积金')
personal_tax = fields.Float(
u'个人所得税', store=True, compute='_personal_tax_value')
amount_wage = fields.Float(
u'实发工资', store=True, compute='_amount_wage_value')
order_id = fields.Many2one('staff.wages', u'工资表', index=True,
required=True, ondelete='cascade')
_sql_constraints = [
('staff_uniq', 'unique(order_id, name)', '同一个工资单不能出现重名员工工资行')
]
@api.onchange('date_number', 'basic_wage', 'basic_date')
def change_wage_addhour(self):
if self.date_number > 31 or self.basic_date > 31:
# todo 修正月份日期判断
raise UserError(u'一个月不可能超过31天')
if self.date_number >= self.basic_date:
self.add_hour = 8 * (self.date_number - self.basic_date)
self.date_number = self.basic_date
self.add_wage = round(
2 * (self.add_hour / 8) * (self.basic_wage / (self.basic_date or 1)), 2)
@api.onchange('add_hour')
def change_add_wage(self):
if self.add_hour:
self.add_wage = round(
2 * (self.add_hour / 8) * (self.basic_wage / (self.basic_date or 1)), 2)
@api.onchange('name')
def change_social_security(self):
"""
选择员工后，自动带出五险一金
:return:
"""
social_security = self.env['staff.contract'].search(
[('staff_id', '=', self.name.id)])
self.basic_wage = social_security.basic_wage
self.endowment = social_security.endowment
self.health = social_security.health
self.unemployment = social_security.unemployment
self.housing_fund = social_security.housing_fund
self.endowment_co = social_security.endowment_co
self.health_co = social_security.health_co
self.unemployment_co = social_security.unemployment_co
self.housing_fund_co = social_security.housing_fund_co
self.injury = social_security.injury
self.maternity = social_security.maternity
@api.one
@api.depends('date_number', 'basic_date', 'add_wage', 'other_wage', 'basic_wage', 'deduction')
def _all_wage_value(self):
if self.date_number >= self.basic_date:
self.wage = self.basic_wage
else:
self.wage = round(
(self.date_number / self.basic_date or 1) * self.basic_wage, 2)
self.all_wage = self.wage + self.add_wage + self.other_wage - self.deduction
@api.one
@api.depends('all_wage', 'endowment', 'health', 'unemployment', 'housing_fund')
def _personal_tax_value(self):
total = self.all_wage - self.endowment - \
self.health - self.unemployment - self.housing_fund
amount = total - 3500
if amount > 80000:
self.personal_tax = round(amount * 0.45 - 13505, 2)
elif amount > 55000:
self.personal_tax = round(amount * 0.35 - 5505, 2)
elif amount > 35000:
self.personal_tax = round(amount * 0.3 - 2755, 2)
elif amount > 9000:
self.personal_tax = round(amount * 0.25 - 1005, 2)
elif amount > 4500:
self.personal_tax = round(amount * 0.2 - 555, 2)
elif amount > 1500:
self.personal_tax = round(amount * 0.1 - 105, 2)
elif amount >= 0:
self.personal_tax = round(amount * 0.03, 2)
else:
self.personal_tax = 0
@api.one
@api.depends('all_wage', 'endowment', 'health', 'unemployment', 'housing_fund', 'personal_tax')
def _amount_wage_value(self):
self.amount_wage = self.all_wage - self.endowment - self.health - \
self.unemployment - self.housing_fund - self.personal_tax
class AddWagesChange(models.Model):
_inherit = 'staff.contract'
wages_change = fields.Selection(change, u'记工类型')