Use root to search on period and search on closed periods

products_by_location can be called by users without read access to period.
And only closed period has cache.

review875002