难点:
1.递归函数
2.借贷方求和
3.循环明细科目
# -*- coding: utf-8 -*-
from odoo import models, fields, api
from math import ceil
import logging
import time
from pprint import pformat
_logger = logging.getLogger(__name__)
class AccountMoveReportPrint(models.AbstractModel):
_name = 'report.account_print_ext.report_account_move_print'
def _paginate(self, items, max_per_page=5):
"""
分页函数
items 为要分页的条目们
max_per_page 设定每页条数
返回：页数
"""
count = len(items)
return int(ceil(float(count) / max_per_page))
def _get_account_name(self, id):
account_name = self.env['account.account'].browse(id).name_get()[0]
# Account move print use Account here:
return account_name[1]
def _get_account_partner(self, id, name):
value = 'account.account,' + str(id)
partner_prop_acc = self.env['ir.property'].search([('value_reference', '=', value)], {})
if partner_prop_acc:
return name
else:
return False
def _get_exchange_rate(self, line):
'''
Exchange rate: Debit or Credit / currency ammount
Why not get it from currency code + date ?
'''
exchange_rate = False
if line.amount_currency:
if line.debit > 0:
exchange_rate = line.debit / line.amount_currency
if line.credit > 0:
exchange_rate = line.credit / (-1 * line.amount_currency)
return exchange_rate
def _get_unit_price(self, line):
'''
Unit price：Debit or Credit / Quantity
'''
unit_price = False
if line.quantity:
if line.debit > 0:
unit_price = line.debit / line.quantity
if line.credit > 0:
unit_price = line.credit / line.quantity
return unit_price
def _rmb_format(self, value):
"""
将数值按位数分开
"""
if value < 0.01:
# 值为0的不输出，即返回12个空格
return ['' for i in range(12)]
# 先将数字转为字符，去掉小数点，然后和12个空格拼成列表，取最后12个元素返回
return (['' for i in range(12)] + list(('%0.2f' % value).replace('.', '')))[-12:]
def _rmb_upper(self, value):
"""
人民币大写
来自：http://topic.csdn.net/u/20091129/20/b778a93d-9f8f-4829-9297-d05b08a23f80.html
传入浮点类型的值返回 unicode 字符串
"""
rmbmap = [u"零", u"壹", u"贰", u"叁", u"肆", u"伍", u"陆", u"柒", u"捌", u"玖"]
unit = [u"分", u"角", u"元", u"拾", u"佰", u"仟", u"万", u"拾", u"佰", u"仟", u"亿",
u"拾", u"佰", u"仟", u"万", u"拾", u"佰", u"仟", u"兆"]
nums = map(int, list(str('%0.2f' % value).replace('.', '')))
words = []
zflag = 0 # 标记连续0次数，以删除万字，或适时插入零字
start = len(nums) - 3
for i in range(start, -3, -1): # 使i对应实际位数，负数为角分
if 0 != nums[start - i] or len(words) == 0:
if zflag:
words.append(rmbmap[0])
zflag = 0
words.append(rmbmap[nums[start - i]])
words.append(unit[i + 2])
elif 0 == i or (0 == i % 4 and zflag < 3): # 控制‘万/元’
words.append(unit[i + 2])
zflag = 0
else:
zflag += 1
if words[-1] != unit[0]: # 结尾非‘分’补整字
words.append(u"整")
return ''.join(words)
def _print_ext(self, id):
return []
def _get_page_ext(self, id):
"""计算页数"""
lists = []
list = self._print_ext(id)
length = len(list)
lent = 0
if length % 10 == 0:
lent = length / 10
else:
lent = length / 10 + 1
i = 1
while i <= lent:
lists.append(i * 10)
i += 1
return lists
class AccountMoveLine(models.Model):
_inherit = 'account.move'
gross_amount_ext = fields.Char(string=u"总额")
class AccountMoveReport(models.AbstractModel):
_name = 'report.account_print_ext.report_account_move'
_inherit = 'report.account_print_ext.report_account_move_print'
def parse_account_code(self, num, accounts, res):
res.append(accounts)
accounts_parent = accounts.parent_id
if not accounts_parent:
if len(res) > num:
return res[::-1][num - 1].code
else:
return res[::-1][-1].code
return self.parse_account_code(num, accounts_parent, res)
def get_id(self, id):
"""获取凭证中科目的id"""
move_id = self.env['account.move'].search([('id', '=', id), ('company_id', '=', self.env.user.company_id.id)])
items = []
if move_id.line_ids:
for line in move_id.line_ids:
id = line.id
items.append(id)
return items
def unique_code(self, id, print_level):
move_id = self.env['account.move'].search([('id', '=', id)])
list1 = []
list2 = list(move_id.line_ids.mapped('account_id'))
accounts = list(set(list2))
accounts.sort(key=list2.index)
for account_id in accounts:
code = self.parse_account_code(print_level, accounts=account_id, res=[])
list1.append(code)
new_list = list(set(list1))
new_list.sort(key=list1.index)
return new_list
def _print_ext(self, id):
start = time.time()
print_level = self._context.get('account_level')
lists = []
items = self.get_id(id)
codes = self.unique_code(id,print_level)
for code in codes:
res = self.env['account.move.line'].search([('account_id.code', 'like', code), ('id', 'in', items)])
sum_debit = sum(x.debit for x in res)
sum_credit = sum(x.credit for x in res)
account_id = self.env['account.account'].search(
[('code', '=', code), ('company_id', '=', self.env.user.company_id.id)])
account_name = code + account_id.name
data = {
'name': u'详情请见明细页',
'code': code,
'account_name': account_name,
'debit': sum_debit,
'credit': sum_credit,
}
lists.append(data)
end = time.time()
_logger.info(u'时间间隔为%s'%(pformat(end-start)))
return lists
@api.model
def render_html(self, docids, data=None):
docids = data.get('ids')
report_obj = self.env['report']
docs = self.env['account.move'].sudo().browse(docids)
for doc in docs:
doc.gross_amount_ext = ("%.2f" % doc.amount)
docargs = {
'docs': docs,
'lists': self._print_ext,
'line_num': 10,
'page': self._get_page_ext,
}
return report_obj.render('account_print_ext.report_account_move', docargs)
网友评论