dquo
/
occ-tax
Watch 1
Star 1
Wiki 捐赠
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
occ-tax/cn_tax_base/models/to_tax.py

516 lines
24KB
Raw Permalink Blame History 

  1. # -*- coding: utf-8 -*-

  2. ##############################################################################

  3. #

  4. #    OpenERP, Open Source Management Solution

  5. #    Copyright (C) 2016  武康开源软件(宣一敏).

  6. #

  7. #    This program is free software: you can redistribute it and/or modify

  8. #    it under the terms of the GNU Affero General Public License as

  9. #    published by the Free Software Foundation, either version 3 of the

  10. #    License, or (at your option) any later version.

  11. #

  12. #    This program is distributed in the hope that it will be useful,

  13. #    but WITHOUT ANY WARRANTY; without even the implied warranty of

  14. #    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

  15. #    GNU Affero General Public License for more details.

  16. #

  17. #    You should have received a copy of the GNU Affero General Public License

  18. #    along with this program.  If not, see <http://www.gnu.org/licenses/>.

  19. #

  20. ##############################################################################

  21. 

  22. from odoo import api, fields, models, tools, _

  23. from lxml import etree

  24. from odoo.exceptions import UserError

  25. import base64

  26. import io

  27. import zipfile

  28. from datetime import date

  29. 

  30. class SpecificBusinessTypes(models.Model):

  31.     _name = 'specific.business.types'

  32.     _description = '特定业务类型'

  33.     _rec_name= 'code'

  34. 

  35.     code = fields.Char('编码')

  36.     name = fields.Char('名称')

  37.     active = fields.Boolean(default=True)

  38. 

  39. class IdType(models.Model):

  40.     _name = 'id.type'

  41.     _description = '证件类型'

  42.     _rec_name= 'code'

  43. 

  44.     code = fields.Char('编码')

  45.     name = fields.Char('名称')

  46.     active = fields.Boolean(default=True)

  47. 

  48. class AbandonedCollection(models.Model):

  49.     _name = 'abandoned.collection'

  50.     _description = '放弃享受减按1%征收率原因'

  51.     _rec_name= 'code'

  52. 

  53.     code = fields.Char('编码')

  54.     name = fields.Char('名称')

  55.     active = fields.Boolean(default=True)

  56. 

  57. class AccountMove(models.Model):

  58.     _inherit = 'account.move'

  59. 

  60.     """

  61.         客户生成销售xml，存附件

  62.         供应商生成xml，存附件

  63.         批量生成xml。

  64.     """

  65. 

  66.     cn_invoice_type = fields.Many2one('cn.invoice.type', string='发票类型')

  67.     cn_invoice_type_code = fields.Char(string='发票类型编码', related='cn_invoice_type.code', store=True)

  68.     specific_business_types = fields.Many2one('specific.business.types', string='特定业务类型')

  69.     is_taxed = fields.Boolean('是否含税', default=False, compute='_compute_is_taxed', store=True)

  70.     is_natural_person = fields.Boolean('受票方自然人标识', default=False, compute='_compute_is_company', store=True)

  71.     id_type = fields.Many2one('id.type', string='证件类型')

  72.     is_show_buy_bank = fields.Boolean('是否展示购买方银行账号', default=True, compute='_compute_show_bank', store=True)

  73.     is_show_sell_bank = fields.Boolean('是否展示销售方银行账号', default=True, compute='_compute_show_bank', store=True)

  74.     abandoned_collection = fields.Many2one('abandoned.collection', string='放弃享受减按1%征收率原因')

  75.     payee = fields.Char(string='收款人')

  76.     checker = fields.Char(string='收款人')

  77. 

  78.     @api.depends('partner_id', 'partner_id.company_type')

  79.     def _compute_is_company(self):

  80.         self.ensure_one()

  81.         if self.partner_id and self.partner_id.company_type == 'company':

  82.             self.is_natural_person = False

  83.         else:

  84.             self.is_natural_person = True

  85. 

  86.     @api.depends('move_type', 'partner_id', 'partner_id.bank_ids', 'partner_bank_id')

  87.     def _compute_show_bank(self):

  88.         self.ensure_one()

  89.         if self.move_type == 'out_invoice':  # 销售发票

  90.             if self.partner_id.bank_ids:

  91.                 self.is_show_buy_bank = True

  92.             else:

  93.                 self.is_show_buy_bank = False

  94.             if self.partner_bank_id:

  95.                 self.is_show_sell_bank = True

  96.             else:

  97.                 self.is_show_sell_bank = False

  98. 

  99.         else:

  100.             if self.partner_id.bank_ids:

  101.                 self.is_show_sell_bank = True

  102.             else:

  103.                 self.is_show_sell_bank = False

  104.             if self.env.company.bank_ids:

  105.                 self.is_show_buy_bank = True

  106.             else:

  107.                 self.is_show_buy_bank = False

  108. 

  109.     @api.depends("invoice_line_ids", "invoice_line_ids.tax_ids", "invoice_line_ids.tax_ids.price_include")

  110.     def _compute_is_taxed(self):

  111.         self.ensure_one()

  112.         line_taxed = []

  113.         for line in self.invoice_line_ids:

  114.             line_taxed = line_taxed + [tax.price_include for tax in line.tax_ids]

  115. 

  116.         taxed = list(set(line_taxed))

  117.         if len(taxed) > 1:

  118.             raise UserError('明细行不可以即含税又不含税')

  119.         if taxed:

  120.             if taxed[0] == True:

  121.                 self.is_taxed = True

  122.             else:

  123.                 self.is_taxed = False

  124. 

  125. 

  126. 

  127.     def action_to_cn_invoice(self):

  128.         return {

  129.             'name': _('导出发票'),

  130.             'res_model': 'account.to.cn.invoice',

  131.             'view_mode': 'form',

  132.             'context': {

  133.                 'active_model': 'account.move',

  134.                 'active_ids': self.ids,

  135.             },

  136.             'target': 'new',

  137.             'type': 'ir.actions.act_window',

  138.         }

  139. 

  140.     def to_cn_invoice_dz_xml(self):

  141.         # 清掉已开票，用于生成xml

  142.         for line in self.invoice_line_ids:

  143.             line.write({

  144.                 'is_cn_invoice': False,

  145.             })

  146.         # 开始写xml

  147.         business = etree.Element("business",  comment=u"发票开具", id="FPKJ")

  148.         self._to_dz_xml_top(business)

  149.         tree = etree.ElementTree(business)

  150.         xml_content = etree.tostring(tree, pretty_print=True, encoding="GBK")

  151.         attachment = self.env['ir.attachment'].create({

  152.             'type': 'binary',

  153.             'name': '电子发票-%s.xml' % self.name,

  154.             'res_model': 'mail.compose.message',

  155.             'datas': base64.encodebytes(xml_content),

  156.             'company_id': self.company_id.id,

  157.         })

  158.         self.message_post(attachment_ids=[attachment.id])

  159.         # filename = '电子发票-%s.xml' % self.name

  160.         # return http.send_file(base64.encodebytes(xml_content), filename=filename, as_attachment=True)

  161.         return xml_content

  162. 

  163.     def to_cn_invoice_xml(self):

  164.         #清掉已开票，用于生成xml

  165.         for line in self.invoice_line_ids:

  166.             line.write({

  167.                 'is_cn_invoice': False,

  168.             })

  169.         #开始写xml

  170.         Kp = etree.Element('Kp')

  171.         self._to_xml_top(Kp)

  172.         tree = etree.ElementTree(Kp)

  173.         xml_content = etree.tostring(tree, pretty_print=True, encoding="GBK")

  174.         attachment = self.env['ir.attachment'].create({

  175.             'type': 'binary',

  176.             'name': '纸质发票-%s.xml' % self.name,

  177.             'res_model': 'mail.compose.message',

  178.             'datas': base64.encodebytes(xml_content),

  179.             'company_id': self.company_id.id,

  180.         })

  181.         self.message_post(attachment_ids=[attachment.id])

  182.         return xml_content

  183. 

  184.     def _to_xml_top(self, Kp):

  185.         # 处理xml发票张数

  186.         # 处理XML头

  187.         Version = etree.SubElement(Kp, 'Version')

  188.         Version.text = '3.0'

  189.         Fpxx = etree.SubElement(Kp, 'Fpxx')

  190.         # 处理xml发票张数

  191.         Zsl = etree.SubElement(Fpxx, 'Zsl')  # 单据数量

  192.         i = 0 #单据数量

  193.         invoice = '%s'%(self.name)

  194.         amount_top = self.env.company.invoice_top_amount

  195.         all_invoiced = False

  196.         while not all_invoiced:

  197.             # 发票头

  198.             if self.move_type == 'out_invoice': #销售发票

  199.                 fapiao_name = self.partner_id.name

  200.                 fapiao_vat = self.partner_id.vat

  201.                 fapiao_address = "%s%s%s %s"%(self.partner_id.city, self.partner_id.street, self.partner_id.street2, self.partner_id.phone)

  202.                 fapiao_bank = ''

  203.                 if self.partner_id.bank_ids:

  204.                     fapiao_bank = '%s %s' % (self.partner_id.bank_ids[0].bank_id.name, self.partner_id.bank_ids[0].acc_number)

  205. 

  206.             if self.move_type == 'in_invoice': #采购发票

  207.                 fapiao_name = self.env.company.name

  208.                 fapiao_vat = self.env.company.vat

  209.                 fapiao_address = "%s%s%s %s" % (

  210.                 self.env.company.city, self.env.company.street, self.env.company.street2, self.env.company.phone)

  211.                 fapiao_bank = ''

  212.                 if self.env.company.bank_ids:

  213.                     fapiao_bank = '%s %s' % (

  214.                     self.env.company.bank_ids[0].bank_id.name, self.env.company.bank_ids[0].acc_number)

  215.             fapiao_note = self.ref or ''

  216. 

  217.             Fpsj = etree.SubElement(Fpxx, 'Fpsj')

  218.             Fp = etree.SubElement(Fpsj, 'Fp')

  219.             Djh = etree.SubElement(Fp, 'Djh')  # 单据号

  220.             Djh.text = invoice

  221.             Spbmbbh = etree.SubElement(Fp, 'Spbmbbh')  # 商品编码版本号

  222.             Spbmbbh.text = '19.0'

  223.             Hsbz = etree.SubElement(Fp, 'Hsbz')  # 含税标志

  224.             Hsbz.text = '0'

  225.             Sgbz = etree.SubElement(Fp, 'Sgbz')  # 含税标志

  226.             Sgbz.text = '0'

  227.             Gfmc = etree.SubElement(Fp, 'Gfmc')  # 购方名称

  228.             Gfmc.text = fapiao_name

  229.             Gfsh = etree.SubElement(Fp, 'Gfsh')  # 购方税号

  230.             Gfsh.text = fapiao_vat

  231.             Gfdzdh = etree.SubElement(Fp, 'Gfdzdh')  # 购方地址电话

  232.             Gfdzdh.text = fapiao_address

  233.             Gfyhzh = etree.SubElement(Fp, 'Gfyhzh')  # 购方银行帐号

  234.             Gfyhzh.text = fapiao_bank

  235.             Skr = etree.SubElement(Fp, 'Skr')  # 收款人

  236.             Skr.text = ''

  237.             Fhr = etree.SubElement(Fp, 'Fhr')  # 复核人

  238.             Fhr.text = ''

  239.             Bz = etree.SubElement(Fp, 'Bz')  # 备注

  240.             Bz.text = fapiao_note

  241.             Spxx = etree.SubElement(Fp, 'Spxx')

  242.             # 发票明细行

  243.             all_invoiced = self._mixi(amount_top, Spxx)

  244.             i += 1

  245.             Djh.text = '%s%d'%(invoice, i)

  246.         Zsl.text = str(i)

  247. 

  248.     def _mixi(self, amount_top, Spxx):

  249.         # 明细计算内容,

  250.         total_untaxed = i = 0

  251.         all_invoiced = True

  252.         for line in self.invoice_line_ids:

  253.             if len(line.tax_ids.ids) > 1:

  254.                 raise UserError('多种税率无法开纸质发票！')

  255.             if line.is_cn_invoice:

  256.                 continue

  257.             total_untaxed += (line.credit or line.debit)

  258.             if (line.credit or line.debit) > amount_top:

  259.                 raise UserError('系统不支持单行商品金额超上限！')

  260.             if total_untaxed > amount_top:

  261.                 # todo 单行超开票上限拆分多张发票

  262.                 all_invoiced = False

  263.                 total_untaxed = total_untaxed - (line.credit or line.debit)

  264.                 continue

  265.             else:

  266.                 Sph = etree.SubElement(Spxx, 'Sph')

  267.                 Kce = etree.SubElement(Sph, 'Kce')  # 扣除额

  268.                 Kce.text = ''

  269.                 Spbm = etree.SubElement(Sph, 'Spbm')  # 商品编码

  270.                 tax_category_id = line.product_id.tax_category_id or line.product_id.categ_id.tax_category_id

  271.                 if tax_category_id:

  272.                     Spbm.text = str(tax_category_id.code)

  273.                 else:

  274.                     raise UserError('未在产品/产品分类上设置税收编码！')

  275.                 Dj = etree.SubElement(Sph, 'Dj')  # 单价

  276.                 tax_rate = 0

  277.                 price = line.price_unit

  278.                 price_include = False

  279.                 if line.tax_ids:

  280.                     tax_rate = round(line.tax_ids[0].amount/100,2)

  281.                     price_include = line.tax_ids[0].price_include

  282.                 if price_include:

  283.                     dj = '%s'%(price/(1+tax_rate/100))

  284.                 else:

  285.                     dj = '%s'%(price)

  286.                 Dj.text = dj

  287.                 Spmc = etree.SubElement(Sph, 'Spmc')  # 商品名称

  288.                 Spmc.text = line.product_id.name

  289.                 Ggxh = etree.SubElement(Sph, 'Ggxh')  # 规格型号

  290.                 Ggxh.text = '-'.join([tag.name for tag in line.product_id.product_tag_ids])

  291.                 Slv = etree.SubElement(Sph, 'Slv')  # 税率

  292.                 Slv.text = '%s'%(tax_rate)

  293.                 Xh = etree.SubElement(Sph, 'Xh')  # 序号

  294.                 i += 1

  295.                 Xh.text = '%d'%(i)

  296.                 Lslbz = etree.SubElement(Sph, 'Lslbz')  # 零标识，0出口退税，1免税

  297.                 Lslbz.text = ''

  298.                 Syyhzcbz = etree.SubElement(Sph, 'Syyhzcbz')  # 优惠政策标识：0不使用，1使用

  299.                 Syyhzcbz.text = '0'

  300.                 Sl = etree.SubElement(Sph, 'Sl')  # 数量

  301.                 Sl.text = '%.2f'%(round(line.quantity, 2))

  302.                 Je = etree.SubElement(Sph, 'Je')  # 金额

  303.                 Je.text = '%.2f'%(round((line.credit or line.debit), 2))

  304.                 Se = etree.SubElement(Sph, 'Se')  # 税额

  305.                 if tax_rate:

  306.                     Se.text = '%.2f' % (line.price_total - round((line.credit or line.debit), 2))

  307.                 else:

  308.                     Se.text = '0'

  309.                 Yhzcsm = etree.SubElement(Sph, 'Yhzcsm')  # 优惠政策说明

  310.                 Yhzcsm.text = ''

  311.                 Qyspbm = etree.SubElement(Sph, 'Qyspbm')  # 企业商品编码

  312.                 Qyspbm.text = ''

  313.                 Jldw = etree.SubElement(Sph, 'Jldw')  # 计量单位

  314.                 Jldw.text = line.product_uom_id.name

  315. 

  316.                 line.write({

  317.                     'is_cn_invoice': True,

  318.                 })

  319.         return all_invoiced

  320. 

  321.     def _to_dz_xml_top(self, business):

  322.         i = 0  # 单据数量

  323.         invoice = '%s' % (self.name)

  324.         amount_top = self.env.company.invoice_top_amount

  325.         all_invoiced = False

  326.         while not all_invoiced:

  327.             if self.move_type == 'out_invoice':  # 销售发票

  328.                 fapiao_no = '%s%d' % (invoice, i)

  329.                 fapiao_name = self.partner_id.name

  330.                 fapiao_vat = self.partner_id.vat

  331.                 fapiao_address = "%s%s%s %d" % (

  332.                 self.partner_id.city, self.partner_id.street, self.partner_id.street2, self.partner_id.phone)

  333.                 fapiao_bank = ''

  334.                 if self.partner_id.bank_ids:

  335.                     fapiao_bank = '%s %s' % (

  336.                     self.partner_id.bank_ids[0].bank_id.name, self.partner_id.bank_ids[0].acc_number)

  337.                 fapiao_note = self.ref or ''

  338. 

  339.                 company_name = self.env.company.name

  340.                 company_vat = self.env.company.vat

  341.                 company_address = "%s%s%s %s" % (

  342.                     self.env.company.city, self.env.company.street, self.env.company.street2, self.env.company.phone)

  343.                 company_bank = ''

  344.                 if self.env.company.bank_ids:

  345.                     company_bank = '%s %s' % (

  346.                         self.env.company.bank_ids[0].bank_id.name, self.env.company.bank_ids[0].acc_number)

  347.                 # 发票头

  348.                 REQUEST_COMMON_FPKJ = etree.SubElement(business, 'REQUEST_COMMON_FPKJ')

  349.                 REQUEST_COMMON_FPKJ.set("class", "REQUEST_COMMON_FPKJ")

  350.                 COMMON_FPKJ_FPT = etree.SubElement(REQUEST_COMMON_FPKJ, 'COMMON_FPKJ_FPT')

  351.                 COMMON_FPKJ_FPT.set("class", "COMMON_FPKJ_FPT")

  352.                 FPQQLSH = etree.SubElement(COMMON_FPKJ_FPT, 'FPQQLSH')  # 开票请求流水号

  353.                 FPQQLSH.text = fapiao_no

  354.                 KPLX = etree.SubElement(COMMON_FPKJ_FPT, 'KPLX')  # 开票类型 0为蓝字，1为红字

  355.                 KPLX.text = '0'

  356.                 XSF_NSRSBH = etree.SubElement(COMMON_FPKJ_FPT, 'XSF_NSRSBH')  # 销售方纳税人识别号

  357.                 XSF_NSRSBH.text = company_vat

  358.                 XSF_MC = etree.SubElement(COMMON_FPKJ_FPT, 'XSF_MC')  # 销售方名称

  359.                 XSF_MC.text = company_name

  360.                 XSF_DZDH = etree.SubElement(COMMON_FPKJ_FPT, 'XSF_DZDH')  # 销售方地址、电话

  361.                 XSF_DZDH.text = company_address

  362.                 XSF_YHZH = etree.SubElement(COMMON_FPKJ_FPT, 'XSF_YHZH')  # 销售方银行帐号

  363.                 XSF_YHZH.text = company_bank

  364.                 GMF_NSRSBH = etree.SubElement(COMMON_FPKJ_FPT, 'GMF_NSRSBH')  # 购买主纳税人识别号

  365.                 GMF_NSRSBH.text = fapiao_vat

  366.                 GMF_MC = etree.SubElement(COMMON_FPKJ_FPT, 'GMF_MC')  # 购方名称

  367.                 GMF_MC.text = fapiao_name

  368.                 GMF_DZDH = etree.SubElement(COMMON_FPKJ_FPT, 'GMF_DZDH')  # 购方地址、电话

  369.                 GMF_DZDH.text = fapiao_address

  370.                 GMF_YHZH = etree.SubElement(COMMON_FPKJ_FPT, 'GMF_YHZH')  # 购方银行帐号

  371.                 GMF_YHZH.text = fapiao_bank

  372.                 KPR = etree.SubElement(COMMON_FPKJ_FPT, 'KPR')  # 开票人

  373.                 KPR.text = ''

  374.                 SKR = etree.SubElement(COMMON_FPKJ_FPT, 'SKR')  # 收款人

  375.                 SKR.text = ''

  376.                 FHR = etree.SubElement(COMMON_FPKJ_FPT, 'FHR')  # 复核人

  377.                 FHR.text = ''

  378.                 YFP_DM = etree.SubElement(COMMON_FPKJ_FPT, 'YFP_DM')  # 原发票代码，红字必须

  379.                 YFP_DM.text = ''

  380.                 YFP_HM = etree.SubElement(COMMON_FPKJ_FPT, 'YFP_HM')  # 原发票号码，红字必须

  381.                 YFP_HM.text = ''

  382.                 BZ = etree.SubElement(COMMON_FPKJ_FPT, 'BZ')  # 备注

  383.                 BMB_BBH = etree.SubElement(COMMON_FPKJ_FPT, 'BMB_BBH')  # 版本号

  384.                 BMB_BBH.text = '18.0'

  385.                 JSHJ = etree.SubElement(COMMON_FPKJ_FPT, 'JSHJ')  # 价税合计

  386.                 HJJE = etree.SubElement(COMMON_FPKJ_FPT, 'HJJE')  # 合计金额（不含税）

  387.                 HJSE = etree.SubElement(COMMON_FPKJ_FPT, 'HJSE')  # 合计税额

  388.                 HSBZ = etree.SubElement(COMMON_FPKJ_FPT, 'HSBZ')  # 税率

  389.                 HJSE.text = '0.00'

  390.                 COMMON_FPKJ_XMXXS = etree.SubElement(REQUEST_COMMON_FPKJ, 'COMMON_FPKJ_XMXXS')

  391.                 COMMON_FPKJ_XMXXS.set("class", "COMMON_FPKJ_XMXX")

  392.                 COMMON_FPKJ_XMXXS.set("size", "1")

  393.                 # 发票明细行

  394.                 all_invoiced = self._dzmixi(COMMON_FPKJ_XMXXS, amount_top)

  395.                 BZ.text = fapiao_note

  396.                 HJJE.text = '%.2f'%self.amount_untaxed_signed

  397.                 JSHJ.text = '%.2f'%self.amount_total_signed

  398.                 HJSE.text = '%.2f'%(self.amount_total_signed - self.amount_untaxed_signed)

  399.                 HSBZ.text = '0'

  400. 

  401.     def _dzmixi(self, COMMON_FPKJ_XMXXS, amount_top):

  402.         total_untaxed = 0

  403.         all_invoiced = True

  404.         for line in self.invoice_line_ids:

  405.             if len(line.tax_ids.ids) > 1:

  406.                 raise UserError('多种税率无法开纸质发票！')

  407.             if line.is_cn_invoice:

  408.                 continue

  409.             total_untaxed += (line.credit or line.debit)

  410.             if (line.credit or line.debit) > amount_top:

  411.                 raise UserError('系统不支持单行商品金额超上限！')

  412.             if total_untaxed > amount_top:

  413.                 # todo 单行超开票上限拆分多张发票

  414.                 all_invoiced = False

  415.                 total_untaxed = total_untaxed - (line.credit or line.debit)

  416.                 continue

  417.             else:

  418.                 amount = (line.credit or line.debit)  # 成交人民币

  419.                 COMMON_FPKJ_XMXX = etree.SubElement(COMMON_FPKJ_XMXXS, 'COMMON_FPKJ_XMXX')

  420.                 FPHXZ = etree.SubElement(COMMON_FPKJ_XMXX, 'FPHXZ')  # 发票行性质，0正常行，1折扣行，2被折扣行

  421.                 FPHXZ.text = '0'

  422.                 XMMC = etree.SubElement(COMMON_FPKJ_XMXX, 'XMMC')  # 商品名称

  423.                 XMMC.text = line.product_id.name

  424.                 GGXH = etree.SubElement(COMMON_FPKJ_XMXX, 'GGXH')  # 规格型号

  425.                 GGXH.text = '-'.join([tag.name for tag in line.product_id.product_tag_ids])

  426.                 DW = etree.SubElement(COMMON_FPKJ_XMXX, 'DW')  # 计量单位

  427.                 DW.text = line.product_uom_id.name

  428.                 SPBM = etree.SubElement(COMMON_FPKJ_XMXX, 'SPBM')  # 税收编码

  429.                 tax_category_id = line.product_id.tax_category_id or line.product_id.categ_id.tax_category_id

  430.                 if tax_category_id:

  431.                     SPBM.text = str(tax_category_id.code)

  432.                 else:

  433.                     raise UserError('未在产品/产品分类上设置税收编码！')

  434.                 ZXBM = etree.SubElement(COMMON_FPKJ_XMXX, 'ZXBM')  # 企业编码

  435.                 ZXBM.text = ''

  436.                 YHZCBS = etree.SubElement(COMMON_FPKJ_XMXX, 'YHZCBS')  # 优惠政策标识：0不使用，1使用

  437.                 YHZCBS.text = '0'

  438.                 LSLBS = etree.SubElement(COMMON_FPKJ_XMXX, 'LSLBS')  # 零标识，0出口退税，1免税

  439.                 ZZSTSGL = etree.SubElement(COMMON_FPKJ_XMXX, 'ZZSTSGL')  # 优惠政策说明？？

  440.                 XMSL = etree.SubElement(COMMON_FPKJ_XMXX, 'XMSL')  # 数量

  441.                 XMSL.text = '%.2f'%(round(line.quantity, 2))

  442.                 XMDJ = etree.SubElement(COMMON_FPKJ_XMXX, 'XMDJ')  # 单价

  443.                 tax_rate = 0

  444.                 price = line.price_unit

  445.                 price_include = False

  446.                 if line.tax_ids:

  447.                     tax_rate = round(line.tax_ids[0].amount / 100, 2)

  448.                     price_include = line.tax_ids[0].price_include

  449.                 if price_include:

  450.                     dj = '%s' % (price / (1 + tax_rate / 100))

  451.                 else:

  452.                     dj = '%s' % (price)

  453.                 XMDJ.text = dj

  454.                 XMJE = etree.SubElement(COMMON_FPKJ_XMXX, 'XMJE')  # 金额

  455.                 XMJE.text = '%.2f'%(round((line.credit or line.debit), 2))

  456.                 SE = etree.SubElement(COMMON_FPKJ_XMXX, 'SE')  # 税额

  457.                 if tax_rate:

  458.                     SE.text = '%.2f' % (line.price_total - round((line.credit or line.debit), 2))

  459.                 else:

  460.                     SE.text = '0'

  461.                 SL = etree.SubElement(COMMON_FPKJ_XMXX, 'SL')  # 税率

  462.                 SL.text = '%s'%(tax_rate)

  463.                 KCE = etree.SubElement(COMMON_FPKJ_XMXX, 'KCE')  # 扣除额

  464.                 KCE.text = '0'

  465.         return all_invoiced

  466. 

  467. class AccountToCnInvoice(models.TransientModel):

  468.     _name = 'account.to.cn.invoice'

  469.     _description = '开发票'

  470. 

  471.     name = fields.Char('File Name', readonly=True)

  472.     is_new_type = fields.Boolean('开全电发票', default=True)

  473.     cn_invoice_type = fields.Many2one('cn.invoice.type', string='发票类型')

  474. 

  475.     data = fields.Binary('File', readonly=True, attachment=False)

  476.     img = fields.Binary('图片', attachment=True)

  477.     is_updata = fields.Boolean('开始上传', default=True)

  478.     state = fields.Selection([('draft', 'draft'), ('done', 'done'), ('end', 'end')], default='draft')

  479. 

  480.     def export_excel(self):

  481.         pass

  482. 

  483.     def invoice_updata(self):

  484.         pass

  485. 

  486.     def confirm_updata(self):

  487.         pass

  488. 

  489.     def act_getfile(self):

  490.         invoice_ids = self.env['account.move'].browse(self._context.get('active_ids'))

  491.         stream = io.BytesIO()

  492.         with zipfile.ZipFile(stream, 'w', compression=zipfile.ZIP_DEFLATED, allowZip64=True) as doc_zip:

  493.             i = 1

  494.             for invoice in invoice_ids:

  495.                 if self.cn_invoice_type.code in ['zp', 'pp']:

  496.                     invoice_xml = invoice.to_cn_invoice_xml()

  497.                     name = '纸质发票/%s.xml' % invoice.name.replace('/', '-')

  498.                 elif self.cn_invoice_type.code in ['dzzp', 'dzfp']:

  499.                     invoice_xml = invoice.to_cn_invoice_dz_xml()

  500.                     name = '电子发票/%s.xml' % invoice.name.replace('/', '-')

  501.                 doc_zip.writestr(name, invoice_xml)

  502.                 i += 1

  503.         name = "%s.zip" % (date.today())

  504.         self.write({

  505.             'data': base64.encodebytes(stream.getvalue()),

  506.             'name': name,

  507.             'state': 'done',

  508.         })

  509.         return {

  510.             'type': 'ir.actions.act_window',

  511.             'res_model': 'account.to.cn.invoice',

  512.             'view_mode': 'form',

  513.             'res_id': self.id,

  514.             'views': [(False, 'form')],

  515.             'target': 'new',

  516.         }
上海开阖软件有限公司 沪ICP备12045867号-1