# -*- coding: utf-8 -*- # Part of Odoo. See LICENSE file for full copyright and licensing details. from datetime import date, datetime from pytz import timezone, utc from odoo import fields from odoo.exceptions import ValidationError from odoo.addons.resource.models.resource import Intervals from odoo.addons.resource.tests.common import TestResourceCommon from odoo.tests.common import TransactionCase def datetime_tz(year, month, day, hour=0, minute=0, second=0, microsecond=0, tzinfo=None): """ Return a `datetime` object with a given timezone (if given). """ dt = datetime(year, month, day, hour, minute, second, microsecond) return timezone(tzinfo).localize(dt) if tzinfo else dt def datetime_str(year, month, day, hour=0, minute=0, second=0, microsecond=0, tzinfo=None): """ Return a fields.Datetime value with the given timezone. """ dt = datetime(year, month, day, hour, minute, second, microsecond) if tzinfo: dt = timezone(tzinfo).localize(dt).astimezone(utc) return fields.Datetime.to_string(dt) class TestIntervals(TransactionCase): def ints(self, pairs): recs = self.env['base'] return [(a, b, recs) for a, b in pairs] def test_union(self): def check(a, b): a, b = self.ints(a), self.ints(b) self.assertEqual(list(Intervals(a)), b) check([(1, 2), (3, 4)], [(1, 2), (3, 4)]) check([(1, 2), (2, 4)], [(1, 4)]) check([(1, 3), (2, 4)], [(1, 4)]) check([(1, 4), (2, 3)], [(1, 4)]) check([(3, 4), (1, 2)], [(1, 2), (3, 4)]) check([(2, 4), (1, 2)], [(1, 4)]) check([(2, 4), (1, 3)], [(1, 4)]) check([(2, 3), (1, 4)], [(1, 4)]) def test_intersection(self): def check(a, b, c): a, b, c = self.ints(a), self.ints(b), self.ints(c) self.assertEqual(list(Intervals(a) & Intervals(b)), c) check([(10, 20)], [(5, 8)], []) check([(10, 20)], [(5, 10)], []) check([(10, 20)], [(5, 15)], [(10, 15)]) check([(10, 20)], [(5, 20)], [(10, 20)]) check([(10, 20)], [(5, 25)], [(10, 20)]) check([(10, 20)], [(10, 15)], [(10, 15)]) check([(10, 20)], [(10, 20)], [(10, 20)]) check([(10, 20)], [(10, 25)], [(10, 20)]) check([(10, 20)], [(15, 18)], [(15, 18)]) check([(10, 20)], [(15, 20)], [(15, 20)]) check([(10, 20)], [(15, 25)], [(15, 20)]) check([(10, 20)], [(20, 25)], []) check( [(0, 5), (10, 15), (20, 25), (30, 35)], [(6, 7), (9, 12), (13, 17), (22, 23), (24, 40)], [(10, 12), (13, 15), (22, 23), (24, 25), (30, 35)], ) def test_difference(self): def check(a, b, c): a, b, c = self.ints(a), self.ints(b), self.ints(c) self.assertEqual(list(Intervals(a) - Intervals(b)), c) check([(10, 20)], [(5, 8)], [(10, 20)]) check([(10, 20)], [(5, 10)], [(10, 20)]) check([(10, 20)], [(5, 15)], [(15, 20)]) check([(10, 20)], [(5, 20)], []) check([(10, 20)], [(5, 25)], []) check([(10, 20)], [(10, 15)], [(15, 20)]) check([(10, 20)], [(10, 20)], []) check([(10, 20)], [(10, 25)], []) check([(10, 20)], [(15, 18)], [(10, 15), (18, 20)]) check([(10, 20)], [(15, 20)], [(10, 15)]) check([(10, 20)], [(15, 25)], [(10, 15)]) check([(10, 20)], [(20, 25)], [(10, 20)]) check( [(0, 5), (10, 15), (20, 25), (30, 35)], [(6, 7), (9, 12), (13, 17), (22, 23), (24, 40)], [(0, 5), (12, 13), (20, 22), (23, 24)], ) class TestErrors(TestResourceCommon): def setUp(self): super(TestErrors, self).setUp() def test_create_negative_leave(self): # from > to with self.assertRaises(ValidationError): self.env['resource.calendar.leaves'].create({ 'name': 'error cannot return in the past', 'resource_id': False, 'calendar_id': self.calendar_jean.id, 'date_from': datetime_str(2018, 4, 3, 20, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 3, 0, 0, 0, tzinfo=self.jean.tz), }) with self.assertRaises(ValidationError): self.env['resource.calendar.leaves'].create({ 'name': 'error caused by timezones', 'resource_id': False, 'calendar_id': self.calendar_jean.id, 'date_from': datetime_str(2018, 4, 3, 10, 0, 0, tzinfo='UTC'), 'date_to': datetime_str(2018, 4, 3, 12, 0, 0, tzinfo='Etc/GMT-6') }) class TestCalendar(TestResourceCommon): def setUp(self): super(TestCalendar, self).setUp() def test_get_work_hours_count(self): self.env['resource.calendar.leaves'].create({ 'name': 'Global Leave', 'resource_id': False, 'calendar_id': self.calendar_jean.id, 'date_from': datetime_str(2018, 4, 3, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 3, 23, 59, 59, tzinfo=self.jean.tz), }) self.env['resource.calendar.leaves'].create({ 'name': 'leave for Jean', 'calendar_id': self.calendar_jean.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 5, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 5, 23, 59, 59, tzinfo=self.jean.tz), }) hours = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.jean.tz), ) self.assertEqual(hours, 32) hours = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.jean.tz), compute_leaves=False, ) self.assertEqual(hours, 40) # leave of size 0 self.env['resource.calendar.leaves'].create({ 'name': 'zero_length', 'calendar_id': self.calendar_patel.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 3, 0, 0, 0, tzinfo=self.patel.tz), 'date_to': datetime_str(2018, 4, 3, 0, 0, 0, tzinfo=self.patel.tz), }) hours = self.calendar_patel.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.patel.tz), ) self.assertEqual(hours, 35) # leave of medium size leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero_length', 'calendar_id': self.calendar_patel.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 3, 9, 0, 0, tzinfo=self.patel.tz), 'date_to': datetime_str(2018, 4, 3, 12, 0, 0, tzinfo=self.patel.tz), }) hours = self.calendar_patel.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.patel.tz), ) self.assertEqual(hours, 32) leave.unlink() # leave of very small size leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero_length', 'calendar_id': self.calendar_patel.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 3, 0, 0, 0, tzinfo=self.patel.tz), 'date_to': datetime_str(2018, 4, 3, 0, 0, 10, tzinfo=self.patel.tz), }) hours = self.calendar_patel.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.patel.tz), ) self.assertEqual(hours, 35) leave.unlink() # no timezone given should be converted to UTC # Should equal to a leave between 2018/04/03 10:00:00 and 2018/04/04 10:00:00 self.env['resource.calendar.leaves'].create({ 'name': 'no timezone', 'calendar_id': self.calendar_patel.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 3, 4, 0, 0), 'date_to': datetime_str(2018, 4, 4, 4, 0, 0), }) hours = self.calendar_patel.get_work_hours_count( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 23, 59, 59, tzinfo=self.patel.tz), ) self.assertEqual(hours, 28) hours = self.calendar_patel.get_work_hours_count( datetime_tz(2018, 4, 2, 23, 59, 59, tzinfo=self.patel.tz), datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), ) self.assertEqual(hours, 0) leave.unlink() def test_calendar_working_hours_count(self): calendar = self.env.ref('resource.resource_calendar_std_35h') calendar.tz = 'UTC' res = calendar.get_work_hours_count( fields.Datetime.from_string('2017-05-03 14:03:00'), # Wednesday (8:00-12:00, 13:00-16:00) fields.Datetime.from_string('2017-05-04 11:03:00'), # Thursday (8:00-12:00, 13:00-16:00) compute_leaves=False) self.assertEqual(res, 5.0) def test_calendar_working_hours_24(self): self.att_4 = self.env['resource.calendar.attendance'].create({ 'name': 'Att4', 'calendar_id': self.calendar_jean.id, 'dayofweek': '2', 'hour_from': 0, 'hour_to': 24 }) res = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 6, 19, 23, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 6, 21, 1, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertAlmostEqual(res, 24.0) def test_plan_hours(self): self.env['resource.calendar.leaves'].create({ 'name': 'global', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 11, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 11, 23, 59, 59, tzinfo=self.jean.tz), }) time = self.calendar_jean.plan_hours(2, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2018, 4, 10, 10, 0, 0, tzinfo=self.jean.tz)) time = self.calendar_jean.plan_hours(20, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2018, 4, 12, 12, 0, 0, tzinfo=self.jean.tz)) time = self.calendar_jean.plan_hours(5, datetime_tz(2018, 4, 10, 15, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 12, 12, 0, 0, tzinfo=self.jean.tz)) # negative planning time = self.calendar_jean.plan_hours(-10, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 6, 14, 0, 0, tzinfo=self.jean.tz)) # zero planning with holidays time = self.calendar_jean.plan_hours(0, datetime_tz(2018, 4, 11, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 12, 8, 0, 0, tzinfo=self.jean.tz)) time = self.calendar_jean.plan_hours(0, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.jean.tz)) # very small planning time = self.calendar_jean.plan_hours(0.0002, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 10, 8, 0, 0, 720000, tzinfo=self.jean.tz)) # huge planning time = self.calendar_jean.plan_hours(3000, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2019, 9, 16, 16, 0, 0, tzinfo=self.jean.tz)) def test_plan_days(self): self.env['resource.calendar.leaves'].create({ 'name': 'global', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 11, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 11, 23, 59, 59, tzinfo=self.jean.tz), }) time = self.calendar_jean.plan_days(1, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2018, 4, 10, 16, 0, 0, tzinfo=self.jean.tz)) time = self.calendar_jean.plan_days(3, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, datetime_tz(2018, 4, 12, 16, 0, 0, tzinfo=self.jean.tz)) time = self.calendar_jean.plan_days(4, datetime_tz(2018, 4, 10, 16, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 17, 16, 0, 0, tzinfo=self.jean.tz)) # negative planning time = self.calendar_jean.plan_days(-10, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 3, 27, 8, 0, 0, tzinfo=self.jean.tz)) # zero planning time = self.calendar_jean.plan_days(0, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz)) # very small planning returns False in this case # TODO: decide if this behaviour is alright time = self.calendar_jean.plan_days(0.0002, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=True) self.assertEqual(time, False) # huge planning # TODO: Same as above # NOTE: Maybe allow to set a max limit to the method time = self.calendar_jean.plan_days(3000, datetime_tz(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), compute_leaves=False) self.assertEqual(time, False) class TestResMixin(TestResourceCommon): def setUp(self): super(TestResMixin, self).setUp() def test_work_days_data(self): # Looking at Jean's calendar # Viewing it as Jean data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 16, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 5, 'hours': 40}) # Viewing it as Patel # Views from 2018/04/01 20:00:00 to 2018/04/06 12:00:00 data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 16, 0, 0, tzinfo=self.patel.tz), ) self.assertEqual(data, {'days': 4.5, 'hours': 36}) # We see only 36 hours # Viewing it as John # Views from 2018/04/02 09:00:00 to 2018/04/07 02:00:00 data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 6, 16, 0, 0, tzinfo=self.john.tz), ) # still showing as 5 days because of rounding, but we see only 39 hours self.assertEqual(data, {'days': 4.875, 'hours': 39}) # Looking at John's calendar # Viewing it as Jean # Views from 2018/04/01 15:00:00 to 2018/04/06 14:00:00 data = self.john.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 1.4375, 'hours': 13}) # Viewing it as Patel # Views from 2018/04/01 11:00:00 to 2018/04/06 10:00:00 data = self.john.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.patel.tz), ) self.assertEqual(data, {'days': 1.1875, 'hours': 10}) # Viewing it as John data = self.john.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.john.tz), ) self.assertEqual(data, {'days': 2, 'hours': 20}) # using Jean as a timezone reference data = self.john.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.john.tz), calendar=self.calendar_jean, ) self.assertEqual(data, {'days': 5, 'hours': 40}) # half days leave = self.env['resource.calendar.leaves'].create({ 'name': 'half', 'calendar_id': self.calendar_jean.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 14, 0, 0, tzinfo=self.jean.tz), }) data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 4.5, 'hours': 36}) # using John as a timezone reference, leaves are outside attendances data = self.john.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.john.tz), calendar=self.calendar_jean, ) self.assertEqual(data, {'days': 5, 'hours': 40}) leave.unlink() # leave size 0 leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), }) data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 5, 'hours': 40}) leave.unlink() # leave very small size leave = self.env['resource.calendar.leaves'].create({ 'name': 'small', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 1, tzinfo=self.jean.tz), }) data = self.jean.get_work_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data['days'], 5) self.assertAlmostEqual(data['hours'], 40, 2) def test_leaves_days_data(self): # Jean takes a leave self.env['resource.calendar.leaves'].create({ 'name': 'Jean is visiting India', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 10, 8, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 10, 16, 0, 0, tzinfo=self.jean.tz), }) # John takes a leave for Jean self.env['resource.calendar.leaves'].create({ 'name': 'Jean is comming in USA', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 12, 8, 0, 0, tzinfo=self.john.tz), 'date_to': datetime_str(2018, 4, 12, 16, 0, 0, tzinfo=self.john.tz), }) # Jean asks to see how much leave he has taken data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.jean.tz), ) # Sees only 1 day and 8 hours because, as john is in UTC-7 the second leave is not in # the attendances of Jean self.assertEqual(data, {'days': 1, 'hours': 8}) # Patel Asks to see when Jean has taken some leaves # Patel should see the same data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.patel.tz), ) self.assertEqual(data, {'days': 1, 'hours': 8}) # use Patel as a resource, jean's leaves are not visible datas = self.patel.get_leave_days_data( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.patel.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.patel.tz), calendar=self.calendar_jean, ) self.assertEqual(datas['days'], 0) self.assertEqual(datas['hours'], 0) # Jean takes a leave for John # Gives 3 hours (3/8 of a day) self.env['resource.calendar.leaves'].create({ 'name': 'John is sick', 'calendar_id': self.john.resource_calendar_id.id, 'resource_id': self.john.resource_id.id, 'date_from': datetime_str(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 10, 20, 0, 0, tzinfo=self.jean.tz), }) # John takes a leave # Gives all day (12 hours) self.env['resource.calendar.leaves'].create({ 'name': 'John goes to holywood', 'calendar_id': self.john.resource_calendar_id.id, 'resource_id': self.john.resource_id.id, 'date_from': datetime_str(2018, 4, 13, 7, 0, 0, tzinfo=self.john.tz), 'date_to': datetime_str(2018, 4, 13, 18, 0, 0, tzinfo=self.john.tz), }) # John asks how much leaves he has # He sees that he has only 15 hours of leave in his attendances data = self.john.get_leave_days_data( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.john.tz), ) self.assertEqual(data, {'days': 0.9375, 'hours': 10}) # half days leave = self.env['resource.calendar.leaves'].create({ 'name': 'half', 'calendar_id': self.calendar_jean.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 14, 0, 0, tzinfo=self.jean.tz), }) data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 0.5, 'hours': 4}) leave.unlink() # leave size 0 leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), }) data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data, {'days': 0, 'hours': 0}) leave.unlink() # leave very small size leave = self.env['resource.calendar.leaves'].create({ 'name': 'small', 'calendar_id': self.calendar_jean.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 1, tzinfo=self.jean.tz), }) data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(data['days'], 0) self.assertAlmostEqual(data['hours'], 0, 2) leave.unlink() def test_list_leaves(self): jean_leave = self.env['resource.calendar.leaves'].create({ 'name': "Jean's son is sick", 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': False, 'date_from': datetime_str(2018, 4, 10, 0, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 10, 23, 59, 59, tzinfo=self.jean.tz), }) leaves = self.jean.list_leaves( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.jean.tz), ) self.assertEqual(leaves, [(date(2018, 4, 10), 8, jean_leave)]) # half days leave = self.env['resource.calendar.leaves'].create({ 'name': 'half', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 14, 0, 0, tzinfo=self.jean.tz), }) leaves = self.jean.list_leaves( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(leaves, [(date(2018, 4, 2), 4, leave)]) leave.unlink() # very small size leave = self.env['resource.calendar.leaves'].create({ 'name': 'small', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 1, tzinfo=self.jean.tz), }) leaves = self.jean.list_leaves( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(len(leaves), 1) self.assertEqual(leaves[0][0], date(2018, 4, 2)) self.assertAlmostEqual(leaves[0][1], 0, 2) self.assertEqual(leaves[0][2].id, leave.id) leave.unlink() # size 0 leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), }) leaves = self.jean.list_leaves( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(leaves, []) leave.unlink() def test_list_work_time_per_day(self): working_time = self.john.list_work_time_per_day( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.john.tz), ) self.assertEqual(working_time, [ (date(2018, 4, 10), 8), (date(2018, 4, 13), 12), ]) # change john's resource's timezone self.john.resource_id.tz = 'Europe/Brussels' self.assertEqual(self.john.tz, 'Europe/Brussels') self.assertEqual(self.calendar_john.tz, 'America/Los_Angeles') working_time = self.john.list_work_time_per_day( datetime_tz(2018, 4, 9, 0, 0, 0, tzinfo=self.john.tz), datetime_tz(2018, 4, 13, 23, 59, 59, tzinfo=self.john.tz), ) self.assertEqual(working_time, [ (date(2018, 4, 10), 8), (date(2018, 4, 13), 12), ]) # half days leave = self.env['resource.calendar.leaves'].create({ 'name': 'small', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 14, 0, 0, tzinfo=self.jean.tz), }) working_time = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(working_time, [ (date(2018, 4, 2), 4), (date(2018, 4, 3), 8), (date(2018, 4, 4), 8), (date(2018, 4, 5), 8), (date(2018, 4, 6), 8), ]) leave.unlink() # very small size leave = self.env['resource.calendar.leaves'].create({ 'name': 'small', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 1, tzinfo=self.jean.tz), }) working_time = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(len(working_time), 5) self.assertEqual(working_time[0][0], date(2018, 4, 2)) self.assertAlmostEqual(working_time[0][1], 8, 2) leave.unlink() # size 0 leave = self.env['resource.calendar.leaves'].create({ 'name': 'zero', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), 'date_to': datetime_str(2018, 4, 2, 10, 0, 0, tzinfo=self.jean.tz), }) working_time = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 2, 0, 0, 0, tzinfo=self.jean.tz), datetime_tz(2018, 4, 6, 23, 0, 0, tzinfo=self.jean.tz), ) self.assertEqual(working_time, [ (date(2018, 4, 2), 8), (date(2018, 4, 3), 8), (date(2018, 4, 4), 8), (date(2018, 4, 5), 8), (date(2018, 4, 6), 8), ]) leave.unlink() class TestTimezones(TestResourceCommon): def setUp(self): super(TestTimezones, self).setUp() self.tz1 = 'Etc/GMT+6' self.tz2 = 'Europe/Brussels' self.tz3 = 'Etc/GMT-10' self.tz4 = 'Etc/GMT+10' def test_work_hours_count(self): # When no timezone => UTC count = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 10, 8, 0, 0), datetime_tz(2018, 4, 10, 12, 0, 0), ) self.assertEqual(count, 4) # This timezone is not the same as the calendar's one count = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.tz1), datetime_tz(2018, 4, 10, 12, 0, 0, tzinfo=self.tz1), ) self.assertEqual(count, 0) # Using two different timezones # 10-04-2018 06:00:00 - 10-04-2018 02:00:00 count = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 10, 12, 0, 0, tzinfo=self.tz3), ) self.assertEqual(count, 0) # Using two different timezones # 2018-4-10 06:00:00 - 2018-4-10 22:00:00 count = self.calendar_jean.get_work_hours_count( datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 10, 12, 0, 0, tzinfo=self.tz4), ) self.assertEqual(count, 8) def test_plan_hours(self): dt = self.calendar_jean.plan_hours(10, datetime_tz(2018, 4, 10, 8, 0, 0)) self.assertEqual(dt, datetime_tz(2018, 4, 11, 10, 0, 0)) dt = self.calendar_jean.plan_hours(10, datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.tz4)) self.assertEqual(dt, datetime_tz(2018, 4, 11, 22, 0, 0, tzinfo=self.tz4)) def test_plan_days(self): dt = self.calendar_jean.plan_days(2, datetime_tz(2018, 4, 10, 8, 0, 0)) self.assertEqual(dt, datetime_tz(2018, 4, 11, 14, 0, 0)) # We lose one day because of timezone dt = self.calendar_jean.plan_days(2, datetime_tz(2018, 4, 10, 8, 0, 0, tzinfo=self.tz4)) self.assertEqual(dt, datetime_tz(2018, 4, 12, 4, 0, 0, tzinfo=self.tz4)) def test_work_data(self): # 09-04-2018 10:00:00 - 13-04-2018 18:00:00 data = self.jean.get_work_days_data( datetime_tz(2018, 4, 9, 8, 0, 0), datetime_tz(2018, 4, 13, 16, 0, 0), ) self.assertEqual(data, {'days': 4.75, 'hours': 38}) # 09-04-2018 00:00:00 - 13-04-2018 08:00:00 data = self.jean.get_work_days_data( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz3), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz3), ) self.assertEqual(data, {'days': 4, 'hours': 32}) # 09-04-2018 08:00:00 - 14-04-2018 12:00:00 data = self.jean.get_work_days_data( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz4), ) self.assertEqual(data, {'days': 5, 'hours': 40}) def test_leave_data(self): self.env['resource.calendar.leaves'].create({ 'name': '', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), 'date_to': datetime_str(2018, 4, 9, 14, 0, 0, tzinfo=self.tz2), }) # 09-04-2018 10:00:00 - 13-04-2018 18:00:00 data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 9, 8, 0, 0), datetime_tz(2018, 4, 13, 16, 0, 0), ) self.assertEqual(data, {'days': 0.5, 'hours': 4}) # 09-04-2018 00:00:00 - 13-04-2018 08:00:00 data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz3), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz3), ) self.assertEqual(data, {'days': 0.75, 'hours': 6}) # 09-04-2018 08:00:00 - 14-04-2018 12:00:00 data = self.jean.get_leave_days_data( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz4), ) self.assertEqual(data, {'days': 0.75, 'hours': 6}) def test_leaves(self): leave = self.env['resource.calendar.leaves'].create({ 'name': '', 'calendar_id': self.jean.resource_calendar_id.id, 'resource_id': self.jean.resource_id.id, 'date_from': datetime_str(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), 'date_to': datetime_str(2018, 4, 9, 14, 0, 0, tzinfo=self.tz2), }) # 09-04-2018 10:00:00 - 13-04-2018 18:00:00 leaves = self.jean.list_leaves( datetime_tz(2018, 4, 9, 8, 0, 0), datetime_tz(2018, 4, 13, 16, 0, 0), ) self.assertEqual(leaves, [(date(2018, 4, 9), 4, leave)]) # 09-04-2018 00:00:00 - 13-04-2018 08:00:00 leaves = self.jean.list_leaves( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz3), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz3), ) self.assertEqual(leaves, [(date(2018, 4, 9), 6, leave)]) # 09-04-2018 08:00:00 - 14-04-2018 12:00:00 leaves = self.jean.list_leaves( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz4), ) self.assertEqual(leaves, [(date(2018, 4, 9), 6, leave)]) def test_works(self): work = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 9, 8, 0, 0), datetime_tz(2018, 4, 13, 16, 0, 0), ) self.assertEqual(work, [ (date(2018, 4, 9), 6), (date(2018, 4, 10), 8), (date(2018, 4, 11), 8), (date(2018, 4, 12), 8), (date(2018, 4, 13), 8), ]) work = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz3), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz3), ) self.assertEqual(len(work), 4) self.assertEqual(work, [ (date(2018, 4, 9), 8), (date(2018, 4, 10), 8), (date(2018, 4, 11), 8), (date(2018, 4, 12), 8), ]) work = self.jean.list_work_time_per_day( datetime_tz(2018, 4, 9, 8, 0, 0, tzinfo=self.tz2), datetime_tz(2018, 4, 13, 16, 0, 0, tzinfo=self.tz4), ) self.assertEqual(work, [ (date(2018, 4, 9), 8), (date(2018, 4, 10), 8), (date(2018, 4, 11), 8), (date(2018, 4, 12), 8), (date(2018, 4, 13), 8), ])