|
- from odoo.exceptions import UserError
- from odoo import fields, models, api
-
-
- class PartnerStatementsReportWizard(models.TransientModel):
- _name = "partner.statements.report.wizard"
- _description = u"业务伙伴对账单向导"
-
- @api.model
- def _get_company_start_date(self):
- return self._get_company_start_date_impl()
-
- @api.model
- def _get_company_start_date_impl(self):
- ''' 获取当前登录用户公司的启用日期 '''
- return self.env.user.company_id.start_date
-
- partner_id = fields.Many2one('partner', string=u'业务伙伴', required=True,
- help=u'查看某一个业务伙伴的对账单报表')
- from_date = fields.Date(string=u'开始日期', required=True, default=_get_company_start_date,
- help=u'查看本次报表的开始日期') # 默认公司启用日期
- to_date = fields.Date(string=u'结束日期', required=True,
- default=lambda self: fields.Date.context_today(self),
- help=u'查看本次报表的结束日期') # 默认当前日期
- company_id = fields.Many2one(
- 'res.company',
- string=u'公司',
- change_default=True,
- default=lambda self: self.env.company)
- is_doc = fields.Boolean(u'打印word格式')
-
- def partner_statements_without_goods(self):
- """
- 业务伙伴对账单: 不带商品明细
- :return: action
- """
- for s in self:
- if s.from_date > s.to_date:
- raise UserError(u'结束日期不能小于开始日期！\n开始日期:%s 结束日期:%s ' %
- (s.from_date, s.to_date))
-
- if self.env.context.get('default_customer'): # 客户
- view = self.env.get('sell.order') != None \
- and self.env.ref('sell.customer_statements_report_list') \
- or self.env.ref('money.customer_statements_report_simple_list')
- name = u'客户对账单:' + s.partner_id.name
- res_model = 'customer.statements.report'
- else: # 供应商
- view = self.env.get('buy.order') != None \
- and self.env.ref('buy.supplier_statements_report_list') \
- or self.env.ref('money.supplier_statements_report_simple_list')
- name = u'供应商对账单:' + s.partner_id.name
- res_model = 'supplier.statements.report'
-
- # 打印word格式
- if s.is_doc:
- data = {
- 'partner_id': s.partner_id.id,
- 'from_date': s.from_date,
- 'to_date': s.to_date,
- }
- if res_model == 'supplier.statements.report':
- return self.env.ref('money.report_supplier_statements_report').report_action([], data=data)
- if res_model == 'customer.statements.report':
- return self.env.ref('money.report_customer_statements_report').report_action([], data=data)
-
- # 浏览器格式
- return {
- 'name': name,
- 'view_mode': 'list',
- 'res_model': res_model,
- 'view_id': False,
- 'views': [(view.id, 'list')],
- 'limit': 65535,
- 'type': 'ir.actions.act_window',
- 'target': 'main',
- 'domain': [('partner_id', '=', s.partner_id.id), ('date', '>=', s.from_date), ('date', '<=', s.to_date)]
- }
-
- def _create_statements_report_with_goods(self, partner_id, name, date, done_date, order_amount,
- benefit_amount, fee, amount, pay_amount, discount_money,
- balance_amount, note, move_id, ptype):
- """
- 生成无商品明细的对账单记录
- """
- if ptype == 'customer':
- model = self.env['customer.statements.report.with.goods']
- else:
- model = self.env['supplier.statements.report.with.goods']
- record_id = model.create({
- 'partner_id': partner_id,
- 'name': name,
- 'date': date,
- 'done_date': done_date,
- 'order_amount': order_amount,
- 'benefit_amount': benefit_amount,
- 'fee': fee,
- 'amount': amount,
- 'pay_amount': pay_amount,
- 'discount_money': discount_money,
- 'balance_amount': balance_amount,
- 'note': note,
- 'move_id': move_id}).id
-
- return record_id
-
- def _create_statements_report_with_goods_line(self, goods_code, goods_name, attribute_id, uom_id,
- quantity, price, discount_amount, without_tax_amount,
- tax_amount, order_amount, balance_amount, ptype):
- """
- 生成带商品明细的对账单记录
- """
- if ptype == 'customer':
- model = self.env['customer.statements.report.with.goods']
- else:
- model = self.env['supplier.statements.report.with.goods']
-
- record_id = model.create({
- 'goods_code': goods_code,
- 'goods_name': goods_name,
- 'attribute_id': attribute_id,
- 'uom_id': uom_id,
- 'quantity': quantity,
- 'price': price,
- 'discount_amount': discount_amount,
- 'without_tax_amount': without_tax_amount,
- 'tax_amount': tax_amount,
- 'order_amount': order_amount,
- 'balance_amount': balance_amount}).id
-
- return record_id
-
- def partner_statements_with_goods(self):
- """
- 业务伙伴对账单: 带商品明细
- :return: action
- """
- for s in self:
- res_ids = []
- if s.from_date > s.to_date:
- raise UserError(u'结束日期不能小于开始日期。\n开始日期:%s 结束日期:%s ' %
- (s.from_date, s.to_date))
-
- if self.env.context.get('default_customer'): # 客户
- reports = self.env['customer.statements.report'].search([('partner_id', '=', s.partner_id.id),
- ('date', '>=',
- s.from_date),
- ('date', '<=', s.to_date)])
- for report in reports:
- # 生成无商品明细的对账单记录
- record_id = self._create_statements_report_with_goods(report.partner_id.id,
- report.name,
- report.date,
- report.done_date,
- report.sale_amount,
- report.benefit_amount,
- report.fee,
- report.amount,
- report.pay_amount,
- report.discount_money,
- report.balance_amount,
- report.note,
- report.move_id.id,
- 'customer')
- res_ids.append(record_id)
-
- # 生成带商品明细的对账单记录
- if report.move_id:
- # report.amount<0时为销售退货单，否则为销售发货单
- line_ids = (report.amount < 0 and report.move_id.line_in_ids
- or report.move_id.line_out_ids)
- for line in line_ids:
- record_id = self._create_statements_report_with_goods_line(line.goods_id.code,
- line.goods_id.name,
- line.attribute_id.id,
- line.uom_id.id,
- line.goods_qty,
- line.price,
- line.discount_amount,
- line.amount,
- line.tax_amount,
- line.subtotal,
- report.balance_amount,
- 'customer')
- res_ids.append(record_id)
- view = self.env.ref(
- 'sell.customer_statements_report_with_goods_list')
-
- return {
- 'name': u'客户对账单:' + s.partner_id.name,
- 'view_mode': 'list',
- 'res_model': 'customer.statements.report.with.goods',
- 'view_id': False,
- 'views': [(view.id, 'list')],
- 'limit': 65535,
- 'type': 'ir.actions.act_window',
- 'target': 'main',
- 'domain': [('id', 'in', res_ids)],
- 'context': {'is_customer': True, 'is_supplier': False},
- }
- else: # 供应商
- reports = self.env['supplier.statements.report'].search([('partner_id', '=', s.partner_id.id),
- ('date', '>=',
- s.from_date),
- ('date', '<=', s.to_date)])
- for report in reports:
- # 生成带商品明细的对账单记录
- record_id = self._create_statements_report_with_goods(report.partner_id.id,
- report.name,
- report.date,
- report.done_date,
- report.purchase_amount,
- report.benefit_amount,
- 0,
- report.amount,
- report.pay_amount,
- report.discount_money,
- report.balance_amount,
- report.note,
- report.move_id.id,
- 'supplier')
- res_ids.append(record_id)
-
- # 生成带商品明细的对账单记录
- if report.move_id:
- # report.amount<0时为采购退货单，否则为采购入库单
- line_ids = (report.amount < 0 and report.move_id.line_out_ids
- or report.move_id.line_in_ids)
- for line in line_ids:
- record_id = self._create_statements_report_with_goods_line(line.goods_id.code,
- line.goods_id.name,
- line.attribute_id.id,
- line.uom_id.id,
- line.goods_qty,
- line.price,
- line.discount_amount,
- line.amount,
- line.tax_amount,
- line.subtotal,
- report.balance_amount,
- 'supplier')
- res_ids.append(record_id)
-
- view = self.env.ref(
- 'buy.supplier_statements_report_with_goods_list')
-
- return {
- 'name': u'供应商对账单:' + s.partner_id.name,
- 'view_mode': 'list',
- 'res_model': 'supplier.statements.report.with.goods',
- 'view_id': False,
- 'views': [(view.id, 'list')],
- 'limit': 65535,
- 'type': 'ir.actions.act_window',
- 'target': 'main',
- 'domain': [('id', 'in', res_ids)],
- 'context': {'is_customer': False, 'is_supplier': True},
- }
-
- @api.onchange('from_date')
- def onchange_from_date(self):
- """
- 客户对账单向导上过滤出是客户的业务伙伴，供应商上过滤出是供应商的业务伙伴
- :return: domain
- """
- if self.env.context.get('default_customer'):
- return {'domain': {'partner_id': [('c_category_id', '!=', False)]}}
- else:
- return {'domain': {'partner_id': [('s_category_id', '!=', False)]}}
|
