# Part of Odoo. See LICENSE file for full copyright and licensing details. from datetime import datetime from freezegun import freeze_time from odoo import Command from odoo.addons.stock.tests.test_generate_serial_numbers import StockGenerateCommon from odoo.addons.stock.tests.test_picking_tours import TestStockPickingTour from odoo.tools.misc import get_lang class TestStockLot(StockGenerateCommon): @classmethod def setUpClass(cls): super().setUpClass() cls.product_lot = cls.env['product.product'].create({ 'name': 'Tracked by Lot Numbers', 'tracking': 'lot', 'is_storable': True, 'use_expiration_date': True, }) def _import_lots(self, lots, move): location_id = move.location_id move_lines_vals = move.split_lots(lots) move_lines_commands = move._generate_serial_move_line_commands(move_lines_vals, location_dest_id=location_id) move.update({'move_line_ids': move_lines_commands}) def test_set_multiple_lot_name_with_expiration_date_01(self): """ In a move line's `lot_name` field, pastes a list of lots and expiration dates. Checks the values are correctly interpreted and the expiration dates are correctly created depending of the user lang's date format. """ user_lang = self.env['res.lang'].browse([get_lang(self.env).id]) # Try first with the "day/month/year" date format. user_lang.date_format = "%d/%m/%y" list_lot_and_qty = [ {'lot_name': "ln01", "date": "03/05/25", "datetime": datetime.strptime('2025-05-03', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "06/05/25", "datetime": datetime.strptime('2025-05-06', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "03/06/25", "datetime": datetime.strptime('2025-06-03', "%Y-%m-%d")}, {'lot_name': "ln04", "date": "06/06/25", "datetime": datetime.strptime('2025-06-06', "%Y-%m-%d")}, {'lot_name': "ln05", "date": "03/07/25", "datetime": datetime.strptime('2025-07-03', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, list_lot_and_qty[i]["datetime"]) # Same test but with with the "month/day/year" date format this time. user_lang.date_format = "%m/%d/%y" list_lot_and_qty = [ {'lot_name': "ln01", "date": "03/05/25", "datetime": datetime.strptime('2025-03-05', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "06/05/25", "datetime": datetime.strptime('2025-06-05', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "03/06/25", "datetime": datetime.strptime('2025-03-06', "%Y-%m-%d")}, {'lot_name': "ln04", "date": "06/06/25", "datetime": datetime.strptime('2025-06-06', "%Y-%m-%d")}, {'lot_name': "ln05", "date": "03/07/25", "datetime": datetime.strptime('2025-03-07', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, list_lot_and_qty[i]["datetime"]) def test_set_multiple_lot_name_with_expiration_date_02_product_dont_use_expiration_date(self): """ In a move line's `lot_name` field, pastes a list of lots and expiration dates. Checks the values are correctly interpreted and since the product doesn't use expiration date, the expiration dates should be ignored. """ self.product_lot.use_expiration_date = False user_lang = self.env['res.lang'].browse([get_lang(self.env).id]) # Try first with the "day/month/year" date format. user_lang.date_format = "%d/%m/%y" list_lot_and_qty = [ {'lot_name': "ln01", "date": "03/05/25", "datetime": datetime.strptime('2025-05-03', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "06/05/25", "datetime": datetime.strptime('2025-05-06', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "03/06/25", "datetime": datetime.strptime('2025-06-03', "%Y-%m-%d")}, {'lot_name': "ln04", "date": "06/06/25", "datetime": datetime.strptime('2025-06-06', "%Y-%m-%d")}, {'lot_name': "ln05", "date": "03/07/25", "datetime": datetime.strptime('2025-07-03', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, False) def test_set_multiple_lot_name_with_expiration_date_03_adaptive_date_format(self): """ Checks if the given dates don't follow the user lang's date format, the created expiration date will follow the first given date's format (at least in the scope of the limitations). """ user_lang = self.env['res.lang'].browse([get_lang(self.env).id]) # Month first in the system but day in the first place in the given dates. user_lang.date_format = "%m/%d/%y" list_lot_and_qty = [ {'lot_name': "ln01", "date": "30/05/25", "datetime": datetime.strptime('2025-05-30', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "06/05/25", "datetime": datetime.strptime('2025-05-06', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "01/06/25", "datetime": datetime.strptime('2025-06-01', "%Y-%m-%d")}, {'lot_name': "ln04", "date": "06/06/25", "datetime": datetime.strptime('2025-06-06', "%Y-%m-%d")}, {'lot_name': "ln05", "date": "01/07/25", "datetime": datetime.strptime('2025-07-01', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, list_lot_and_qty[i]["datetime"]) # Now, tries with day first but the year is at the first place in the given dates. user_lang.date_format = "%d/%m/%y" list_lot_and_qty = [ {'lot_name': "ln01", "date": "89/05/04", "datetime": datetime.strptime('1989-05-04', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "10/05/06", "datetime": datetime.strptime('2010-05-06', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "12/06/15", "datetime": datetime.strptime('2012-06-15', "%Y-%m-%d")}, {'lot_name': "ln04", "date": "30/06/06", "datetime": datetime.strptime('2030-06-06', "%Y-%m-%d")}, {'lot_name': "ln05", "date": "04/07/08", "datetime": datetime.strptime('2004-07-08', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, list_lot_and_qty[i]["datetime"]) def test_set_multiple_lot_name_with_expiration_date_04_written_months(self): """ Checks the expiration date is correctly created when the month is written in letters. """ list_lot_and_qty = [ {'lot_name': "ln01", "date": "01 march 2077", "datetime": datetime.strptime('2077-03-01', "%Y-%m-%d")}, {'lot_name': "ln02", "date": "11 april 2077", "datetime": datetime.strptime('2077-04-11', "%Y-%m-%d")}, {'lot_name': "ln03", "date": "10 december 2077", "datetime": datetime.strptime('2077-12-10', "%Y-%m-%d")}, ] list_as_string = '\n'.join([f'{line["lot_name"]};{line["date"]}' for line in list_lot_and_qty]) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) for i, move_line in enumerate(move.move_line_ids): self.assertEqual(move_line.lot_name, list_lot_and_qty[i]['lot_name']) self.assertEqual(move_line.quantity, 1) self.assertEqual(move_line.expiration_date, list_lot_and_qty[i]["datetime"]) @freeze_time('2025-9-13') def test_set_multiple_lot_name_with_expiration_date_05_import_dates(self): """ When importing lot names, quantities and expiration dates, make sure the date is not replaced by the computed date and if there's no date, it takes the computed date. """ self.product_lot.expiration_time = 10 receipt_picking = self.env['stock.picking'].create({ 'picking_type_id': self.warehouse.in_type_id.id, 'location_id': self.env.ref('stock.stock_location_suppliers').id, 'location_dest_id': self.warehouse.lot_stock_id.id, 'state': 'draft', 'move_ids': [Command.create({ 'product_id': self.product_lot.id, 'product_uom_qty': 20, 'location_id': self.env.ref('stock.stock_location_suppliers').id, 'location_dest_id': self.warehouse.lot_stock_id.id, })] }) action_context = { 'default_company_id': self.env.company.id, 'default_picking_id': receipt_picking.id, 'default_picking_type_id': self.warehouse.in_type_id.id, 'default_location_id': receipt_picking.location_id.id, 'default_location_dest_id': receipt_picking.location_dest_id.id, 'default_product_id': self.product_lot.id, 'default_tracking': 'lot', } move_line_vals = self.env['stock.move'].action_generate_lot_line_vals( action_context, 'import', None, 0, 'lot1;10;2025-12-31\nlot2;7\nlot3;3;1970-1-1' ) self.assert_move_line_vals_values(move_line_vals, [ {'quantity': 10, 'lot_name': 'lot1', 'expiration_date': datetime.strptime('2025-12-31', "%Y-%m-%d")}, {'quantity': 7, 'lot_name': 'lot2', 'expiration_date': datetime.strptime('2025-9-23', "%Y-%m-%d")}, {'quantity': 3, 'lot_name': 'lot3', 'expiration_date': datetime.strptime('1970-1-1', "%Y-%m-%d")}, ]) @freeze_time('2023-04-17') def test_set_multiple_lot_name_with_expiration_date_05_wrong_given_date(self): """ This test ensure when the given dates aren't correctly written, the full string is used as the lot's name. """ today = datetime(day=17, month=4, year=2023) list_lot_and_qty = [ "ln01\t31/12", # Day is missing but the date is valid. "ln02\t1989-04", # Day is missing but the date is valid. "ln03\t01", # Single number: will be used as the quantity. "ln04\t1989", # Single number: will be used as the quantity. "ln05\t1989.04", # Signle number (with decimal): will be used as the quantity. "ln06\t1989+04", # Wrong, all the string will be used as the lot name. "ln07\tdacember", # Typo, all the string will be used as the lot name. "ln08\tdecember", # Day and year are missing but the date is valid. ] list_as_string = '\n'.join(list_lot_and_qty) move = self.get_new_move(product=self.product_lot) self._import_lots(list_as_string, move) self.assertEqual(len(move.move_line_ids), len(list_lot_and_qty)) self.assertEqual(move.move_line_ids[0].lot_name, "ln01") self.assertEqual(move.move_line_ids[0].quantity, 1) self.assertEqual(move.move_line_ids[0].expiration_date, datetime(day=31, month=12, year=2023)) self.assertEqual(move.move_line_ids[1].lot_name, "ln02") self.assertEqual(move.move_line_ids[1].quantity, 1) self.assertEqual(move.move_line_ids[1].expiration_date, datetime(day=17, month=4, year=1989)) self.assertEqual(move.move_line_ids[2].lot_name, "ln03") self.assertEqual(move.move_line_ids[2].quantity, 1) self.assertEqual(move.move_line_ids[2].expiration_date, today) self.assertEqual(move.move_line_ids[3].lot_name, "ln04") self.assertEqual(move.move_line_ids[3].quantity, 1989) self.assertEqual(move.move_line_ids[3].expiration_date, today) self.assertEqual(move.move_line_ids[4].lot_name, "ln05") self.assertEqual(move.move_line_ids[4].quantity, 1989.04) self.assertEqual(move.move_line_ids[4].expiration_date, today) self.assertEqual(move.move_line_ids[5].lot_name, "ln06\t1989+04") self.assertEqual(move.move_line_ids[5].quantity, 1) self.assertEqual(move.move_line_ids[5].expiration_date, today) self.assertEqual(move.move_line_ids[6].lot_name, "ln07\tdacember") self.assertEqual(move.move_line_ids[6].quantity, 1) self.assertEqual(move.move_line_ids[6].expiration_date, today) self.assertEqual(move.move_line_ids[7].lot_name, "ln08") self.assertEqual(move.move_line_ids[7].quantity, 1) self.assertEqual(move.move_line_ids[7].expiration_date, datetime(day=17, month=12, year=2023)) def test_set_multiple_lot_name_with_expiration_date_06_one_line(self): """ Checks the pasted data are correctly parsed even if the user pastes only one line. """ user_lang = self.env['res.lang'].browse([get_lang(self.env).id]) user_lang.date_format = "%d/%m/%y" for lot_name in ["lot-001;20;4 Aug 2048", "lot-001\t04/08/2048\t20"]: move = self.get_new_move(product=self.product_lot) self._import_lots(lot_name, move) self.assertEqual(move.move_line_ids.lot_name, "lot-001") self.assertEqual(move.move_line_ids.quantity, 20) self.assertEqual(move.move_line_ids.expiration_date, datetime(day=4, month=8, year=2048)) class TestProductExpiryTour(TestStockPickingTour): @freeze_time("2020-06-01") def test_generate_serial_with_expiration(self): """ Ensure that serial/lot numbers generated using the 'Generate Serials/Lots' button in Detailed Operations have expiration dates set. """ product_exp = self.env['product.product'].create({ 'name': 'Product Exp', 'is_storable': True, 'tracking': 'serial', 'use_expiration_date': True, 'expiration_time': 2, }) self.env['stock.move'].create({ 'product_id': product_exp.id, 'product_uom_qty': 2, 'product_uom': product_exp.uom_id.id, 'picking_id': self.receipt.id, }) self.receipt.action_confirm() url = self._get_picking_url(self.receipt.id) self.start_tour(url, 'test_generate_serial_with_expiration', login='admin')