GoodERP
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.

121 lines
4.8KB

  1. # Copyright 2016 上海开阖软件有限公司 (http://www.osbzr.com)
  2. # License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl).
  3. from datetime import date
  4. from odoo import models, fields, api
  5. from odoo.exceptions import UserError
  6. class BuyOrderTrackWizard(models.TransientModel):
  7. _name = 'buy.order.track.wizard'
  8. _description = '采购订单跟踪表向导'
  9. @api.model
  10. def _default_date_start(self):
  11. return self.env.user.company_id.start_date
  12. @api.model
  13. def _default_date_end(self):
  14. return date.today()
  15. date_start = fields.Date('开始日期', default=_default_date_start,
  16. help='报表汇总的开始日期,默认为公司启用日期')
  17. date_end = fields.Date('结束日期', default=_default_date_end,
  18. help='报表汇总的结束日期,默认为当前日期')
  19. partner_id = fields.Many2one('partner', '供应商',
  20. help='只统计选定的供应商')
  21. goods_id = fields.Many2one('goods', '商品',
  22. help='只统计选定的商品')
  23. order_id = fields.Many2one('buy.order', '订单号',
  24. help='只统计选定的订单号')
  25. warehouse_dest_id = fields.Many2one('warehouse', '仓库',
  26. help='只统计选定的仓库')
  27. company_id = fields.Many2one(
  28. 'res.company',
  29. string='公司',
  30. change_default=True,
  31. default=lambda self: self.env.company)
  32. def _get_domain(self):
  33. '''返回wizard界面上条件'''
  34. domain = [
  35. ('order_id.date', '>=', self.date_start),
  36. ('order_id.date', '<=', self.date_end)
  37. ]
  38. if self.goods_id:
  39. domain.append(('goods_id', '=', self.goods_id.id))
  40. if self.partner_id:
  41. domain.append(('order_id.partner_id', '=', self.partner_id.id))
  42. if self.order_id:
  43. domain.append(('order_id.id', '=', self.order_id.id))
  44. if self.warehouse_dest_id:
  45. domain.append(('order_id.warehouse_dest_id',
  46. '=', self.warehouse_dest_id.id))
  47. return domain
  48. def _get_wh_in_date(self, line):
  49. '''对于一个buy order line,返回一个入库日期'''
  50. wh_in_date = None
  51. move_line = self.env['wh.move.line']
  52. wh_move_line = move_line.search([
  53. ('buy_line_id', '=', line.id),
  54. ('state', '=', 'done')
  55. ])
  56. if len(wh_move_line) > 1: # 如果是分批入库,则入库单明细行上的buy_line_id相同
  57. wh_in_date = wh_move_line[0].date
  58. else:
  59. wh_in_date = wh_move_line.date
  60. return wh_in_date
  61. def _prepare_track_line(self, line, qty, amount, qty_not_in):
  62. '''返回跟踪表明细行(非小计行)'''
  63. return {
  64. 'goods_code': line.goods_id.code,
  65. 'goods_id': line.goods_id.id,
  66. 'attribute': line.attribute_id.name,
  67. 'uom': line.uom_id.name,
  68. 'date': line.order_id.date,
  69. 'order_name': line.order_id.name,
  70. 'partner_id': line.order_id.partner_id.id,
  71. 'warehouse_dest_id': line.order_id.warehouse_dest_id.id,
  72. 'goods_state': line.order_id.goods_state,
  73. 'qty': qty,
  74. 'amount': amount,
  75. 'qty_not_in': qty_not_in,
  76. 'planned_date': line.order_id.planned_date,
  77. 'wh_in_date': self._get_wh_in_date(line), # 入库日期
  78. 'note': line.note,
  79. 'type': line.order_id.type,
  80. }
  81. def button_ok(self):
  82. self.ensure_one()
  83. res = []
  84. if self.date_end < self.date_start:
  85. raise UserError('开始日期不能大于结束日期!')
  86. buy_order_line = self.env['buy.order.line']
  87. for line in buy_order_line.search(self._get_domain(), order='goods_id'):
  88. is_buy = line.order_id.type == 'buy' and 1 or -1 # 是否采购订单
  89. # 以下分别为明细行上数量、采购额、未入库数量,退货时均取反
  90. qty = is_buy * line.quantity
  91. amount = is_buy * line.subtotal
  92. qty_not_in = is_buy * (line.quantity - line.quantity_in)
  93. # 创建跟踪表明细行(非小计行)
  94. track = self.env['buy.order.track'].create(
  95. self._prepare_track_line(line, qty, amount, qty_not_in))
  96. res.append(track.id)
  97. view = self.env.ref('buy.buy_order_track_list')
  98. return {
  99. 'name': '采购订单跟踪表',
  100. 'view_mode': 'list',
  101. 'view_id': False,
  102. 'views': [(view.id, 'list')],
  103. 'res_model': 'buy.order.track',
  104. 'type': 'ir.actions.act_window',
  105. 'target': 'main',
  106. 'domain': [('id', 'in', res)],
  107. 'limit': 65535,
  108. }
上海开阖软件有限公司 沪ICP备12045867号-1