############################################################################## # # OpenERP, Open Source Management Solution # Copyright (C) 2004-2009 Tiny SPRL (). # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as # published by the Free Software Foundation, either version 3 of the # License, or (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU Affero General Public License for more details. # # You should have received a copy of the GNU Affero General Public License # along with this program. If not, see . # ############################################################################## import datetime import openerp from openerp import api, models from openerp.osv import fields, osv class stock_production_lot(osv.osv): _inherit = 'stock.production.lot' def _get_date(dtype): """Return a function to compute the limit date for this type""" def calc_date(self, cr, uid, context=None): """Compute the limit date for a given date""" if context is None: context = {} if not context.get('product_id', False): date = False else: product = openerp.registry(cr.dbname)['product.product'].browse( cr, uid, context['product_id']) duration = getattr(product, dtype) # set date to False when no expiry time specified on the product date = duration and (datetime.datetime.today() + datetime.timedelta(days=duration)) return date and date.strftime('%Y-%m-%d %H:%M:%S') or False return calc_date _columns = { 'life_date': fields.datetime('End of Life Date', help='This is the date on which the goods with this Serial Number may become dangerous and must not be consumed.'), 'use_date': fields.datetime('Best before Date', help='This is the date on which the goods with this Serial Number start deteriorating, without being dangerous yet.'), 'removal_date': fields.datetime('Removal Date', help='This is the date on which the goods with this Serial Number should be removed from the stock.'), 'alert_date': fields.datetime('Alert Date', help="This is the date on which an alert should be notified about the goods with this Serial Number."), } # Assign dates according to products data def create(self, cr, uid, vals, context=None): context = dict(context or {}) context['product_id'] = vals.get('product_id', context.get('default_product_id') or context.get('product_id')) return super(stock_production_lot, self).create(cr, uid, vals, context=context) _defaults = { 'life_date': _get_date('life_time'), 'use_date': _get_date('use_time'), 'removal_date': _get_date('removal_time'), 'alert_date': _get_date('alert_time'), } # Onchange added in new api to avoid having to change views class StockProductionLot(models.Model): _inherit = 'stock.production.lot' @api.onchange('product_id') def _onchange_product(self): defaults = self.with_context( product_id=self.product_id.id).default_get( ['life_date', 'use_date', 'removal_date', 'alert_date']) for field, value in defaults.items(): setattr(self, field, value) class stock_quant(osv.osv): _inherit = 'stock.quant' def _get_quants(self, cr, uid, ids, context=None): return self.pool.get('stock.quant').search(cr, uid, [('lot_id', 'in', ids)], context=context) _columns = { 'removal_date': fields.related('lot_id', 'removal_date', type='datetime', string='Removal Date', store={ 'stock.quant': (lambda self, cr, uid, ids, ctx: ids, ['lot_id'], 20), 'stock.production.lot': (_get_quants, ['removal_date'], 20), }), } def apply_removal_strategy(self, cr, uid, location, product, qty, domain, removal_strategy, context=None): if removal_strategy == 'fefo': order = 'removal_date, in_date, id' return self._quants_get_order(cr, uid, location, product, qty, domain, order, context=context) return super(stock_quant, self).apply_removal_strategy(cr, uid, location, product, qty, domain, removal_strategy, context=context) class product_product(osv.osv): _inherit = 'product.template' _columns = { 'life_time': fields.integer('Product Life Time', help='When a new a Serial Number is issued, this is the number of days before the goods may become dangerous and must not be consumed.'), 'use_time': fields.integer('Product Use Time', help='When a new a Serial Number is issued, this is the number of days before the goods starts deteriorating, without being dangerous yet.'), 'removal_time': fields.integer('Product Removal Time', help='When a new a Serial Number is issued, this is the number of days before the goods should be removed from the stock.'), 'alert_time': fields.integer('Product Alert Time', help='When a new a Serial Number is issued, this is the number of days before an alert should be notified.'), } # vim:expandtab:smartindent:tabstop=4:softtabstop=4:shiftwidth=4: