GoodERP
Nelze vybrat více než 25 témat Téma musí začínat písmenem nebo číslem, může obsahovat pomlčky („-“) a může být dlouhé až 35 znaků.

142 lines
5.4KB

  1. # Copyright 2016 上海开阖软件有限公司 (http://www.osbzr.com)
  2. # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).
  3. from odoo import api, fields, models, _
  4. '''
  5. 会计月末的成本核算方法
  6. 库存收发明细表全部使用个别计价
  7. 月末结账时再根据此核算方法生成发出成本差异凭证
  8. '''
  9. CORE_COST_METHOD = [('average', '全月一次加权平均法'),
  10. ('std', '定额成本'),
  11. ('fifo', '个别计价法'),
  12. ]
  13. AVAILABLE_PRIORITIES = [
  14. ('0', 'E'),
  15. ('1', 'D'),
  16. ('2', 'C'),
  17. ('3', 'B'),
  18. ('4', 'A'),
  19. ]
  20. class Goods(models.Model):
  21. _name = 'goods'
  22. _description = '商品'
  23. _inherit = ['mail.thread', 'mail.activity.mixin']
  24. _order = 'priority desc'
  25. @api.model
  26. def _get_default_not_saleable_impl(self):
  27. return False
  28. @api.model
  29. def _get_default_not_saleable(self):
  30. return self._get_default_not_saleable_impl()
  31. @api.model
  32. def _get_default_not_buyable_impl(self):
  33. return False
  34. @api.model
  35. def _get_default_not_buyable(self):
  36. return self._get_default_not_buyable_impl()
  37. def name_get(self):
  38. '''在many2one字段里显示 编号_名称'''
  39. res = []
  40. for Goods in self:
  41. res.append((Goods.id, Goods.code and (
  42. Goods.code + '_' + Goods.name) or Goods.name))
  43. return res
  44. @api.model
  45. def name_search(self, name='', args=None, operator='ilike', limit=100):
  46. '''在many2one字段中支持按编号搜索'''
  47. args = args or []
  48. code_search_goods = []
  49. if name:
  50. goods_id = self.search([('code', '=', name)])
  51. if goods_id:
  52. return goods_id.name_get()
  53. args.append(('code', 'ilike', name))
  54. goods_ids = self.search(args)
  55. if goods_ids:
  56. code_search_goods = goods_ids.name_get()
  57. args.remove(('code', 'ilike', name))
  58. search_goods = super(Goods, self).name_search(
  59. name=name, args=args,
  60. operator=operator, limit=limit
  61. )
  62. for good_tup in code_search_goods: # 去除重复产品
  63. if good_tup not in search_goods:
  64. search_goods.append(good_tup)
  65. return search_goods
  66. @api.model_create_multi
  67. def create(self, vals_list):
  68. '''导入商品时,如果辅助单位为空,则用计量单位来填充它'''
  69. for vals in vals_list:
  70. if not vals.get('uos_id'):
  71. vals.update({'uos_id': vals.get('uom_id')})
  72. return super().create(vals_list)
  73. def copy(self, default=None):
  74. ''' 避免复制时提示名称和编号不可重复 '''
  75. if default is None:
  76. default = {}
  77. if 'name' not in default:
  78. default.update(name=_('%s (copy)') % (self.name))
  79. if self.code and 'code' not in default:
  80. default.update(code=_('%s (copy)') % (self.code))
  81. return super(Goods, self).copy(default=default)
  82. code = fields.Char('编号')
  83. name = fields.Char('名称', required=True, copy=False)
  84. priority = fields.Selection(AVAILABLE_PRIORITIES, '商品重要性', default='0')
  85. category_id = fields.Many2one('core.category', '核算类别',
  86. ondelete='restrict',
  87. domain=[('type', '=', 'goods')],
  88. required=True,
  89. help='从会计科目角度划分的类别',
  90. )
  91. uom_id = fields.Many2one('uom', ondelete='restrict',
  92. string='计量单位', required=True)
  93. uos_id = fields.Many2one('uom', ondelete='restrict', string='辅助单位')
  94. conversion = fields.Float(
  95. string='转化率', default=1, digits=(16, 3),
  96. help='1个辅助单位等于多少计量单位的数量,如1箱30个苹果,这里就输入30')
  97. cost = fields.Float('成本',
  98. digits='Price')
  99. cost_method = fields.Selection(CORE_COST_METHOD, '存货计价方法',
  100. help='''GoodERP仓库模块使用先进先出规则匹配
  101. 每次出库对应的入库成本和数量,但不实时记账。
  102. 财务月结时使用此方法相应调整发出成本''')
  103. tax_rate = fields.Float('税率(%)',
  104. help='商品税率')
  105. not_saleable = fields.Boolean('不可销售',
  106. default=_get_default_not_saleable,
  107. help='商品是否不可销售,勾选了就不可销售,未勾选可销售')
  108. not_buyable = fields.Boolean('不可采购',
  109. default=_get_default_not_buyable,
  110. help='商品是否不可采购,勾选了就不可采购,未勾选可采购')
  111. active = fields.Boolean('启用', default=True)
  112. company_id = fields.Many2one(
  113. 'res.company',
  114. string='公司',
  115. change_default=True,
  116. default=lambda self: self.env.company)
  117. brand = fields.Many2one('core.value', '品牌',
  118. ondelete='restrict',
  119. domain=[('type', '=', 'brand')],
  120. context={'type': 'brand'})
  121. size = fields.Char('尺寸')
  122. _sql_constraints = [
  123. ('conversion_no_zero', 'check(conversion != 0)', '商品的转化率不能为0')
  124. ]
上海开阖软件有限公司 沪ICP备12045867号-1