############################################################################## # # Copyright (c) 2002 Nexedi SARL and Contributors. All Rights Reserved. # Jean-Paul Smets-Solanes <jp@nexedi.com> # # WARNING: This program as such is intended to be used by professional # programmers who take the whole responsability of assessing all potential # consequences resulting from its eventual inadequacies and bugs # End users who are looking for a ready-to-use solution with commercial # garantees and support are strongly adviced to contract a Free Software # Service Company # # This program is Free Software; you can redistribute it and/or # modify it under the terms of the GNU General Public License # as published by the Free Software Foundation; either version 2 # 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 General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. # ############################################################################## from Globals import InitializeClass, PersistentMapping from Acquisition import aq_base, aq_inner, aq_parent, aq_self from AccessControl import ClassSecurityInfo from Products.ERP5.ERP5Globals import current_inventory_state_list from Products.CMFCore.WorkflowCore import WorkflowAction from Products.ERP5Type import Permissions, PropertySheet, Constraint, Interface from Products.ERP5.Document.DeliveryCell import DeliveryCell from Products.ERP5.Document.Movement import Movement class InventoryCell(DeliveryCell): """ A DeliveryCell allows to define specific quantities for each variation of a resource in a delivery line. """ meta_type = 'ERP5 Inventory Cell' portal_type = 'Inventory Cell' add_permission = Permissions.AddPortalContent isPortalContent = 1 isRADContent = 1 isMovement = 1 # Declarative security security = ClassSecurityInfo() security.declareObjectProtected(Permissions.View) # Declarative interfaces __implements__ = ( Interface.Variated, ) # Declarative properties property_sheets = ( PropertySheet.Base , PropertySheet.CategoryCore , PropertySheet.Amount , PropertySheet.Inventory , PropertySheet.Task , PropertySheet.Movement , PropertySheet.Price , PropertySheet.Predicate , PropertySheet.Domain , PropertySheet.MappedValue , PropertySheet.ItemAggregation ) # Factory Type Information factory_type_information = \ { 'id' : portal_type , 'meta_type' : meta_type , 'description' : """\ Une ligne tarifaire.""" , 'icon' : 'order_line_icon.gif' , 'product' : 'ERP5' , 'factory' : 'addInventoryCell' , 'immediate_view' : 'inventory_cell_view' , 'allow_discussion' : 1 , 'allowed_content_types': ('', ) , 'filter_content_types' : 1 , 'global_allow' : 1 , 'actions' : ( { 'id' : 'view' , 'name' : 'View' , 'category' : 'object_view' , 'action' : 'inventory_cell_view' , 'permissions' : ( Permissions.View, ) } , { 'id' : 'list' , 'name' : 'Object Contents' , 'category' : 'object_action' , 'action' : 'folder_contents' , 'permissions' : ( Permissions.View, ) } , { 'id' : 'print' , 'name' : 'Print' , 'category' : 'object_print' , 'action' : 'inventory_cell_print' , 'permissions' : ( Permissions.View, ) } , { 'id' : 'metadata' , 'name' : 'Metadata' , 'category' : 'object_view' , 'action' : 'metadata_edit' , 'permissions' : ( Permissions.View, ) } , { 'id' : 'translate' , 'name' : 'Translate' , 'category' : 'object_action' , 'action' : 'translation_template_view' , 'permissions' : ( Permissions.TranslateContent, ) } ) } def _edit(self, REQUEST=None, force_update = 0, **kw): kw = kw.copy() item_id_list = kw.get('item_id_list', None) if item_id_list is not None: del kw['item_id_list'] produced_item_id_list = kw.get('produced_item_id_list', None) if produced_item_id_list is not None: del kw['produced_item_id_list'] consumed_item_id_list = kw.get('consumed_item_id_list', None) if consumed_item_id_list is not None: del kw['consumed_item_id_list'] DeliveryCell._edit(self, REQUEST=REQUEST, force_update = force_update, **kw) # Update consumption last if item_id_list is not None: self._setItemIdList(item_id_list) if produced_item_id_list is not None : self._setProducedItemIdList(produced_item_id_list) if consumed_item_id_list is not None : self._setConsumedItemIdList(consumed_item_id_list) security.declareProtected( Permissions.ModifyPortalContent, 'hasCellContent' ) def hasCellContent(self, base_id='movement'): """ This method can be overriden """ return 0 security.declareProtected(Permissions.AccessContentsInformation, 'getQuantity') def getQuantity(self): """ Computes a quantity which allows to reach inventory Bug fix method for Coramy purpose - Coramy used production_quantity as property list of mapped value which generated errors of stock. It can be safely removed in the near future. """ aself = aq_base(self) if hasattr(aself, 'production_quantity') or hasattr(aself, 'consumption_quantity'): # Error - we must fix this if getattr(aself, 'production_quantity', 0.0) > 0.0: self.setProductionQuantity(aself.production_quantity) elif getattr(aself, 'consumption_quantity', 0.0) > 0.0: self.setConsumptionQuantity(aself.consumption_quantity) if hasattr(aself, 'production_quantity'): delattr(self, 'production_quantity') if hasattr(aself, 'consumption_quantity'): delattr(self, 'consumption_quantity') if hasattr(self, 'mapped_value_property_list'): if 'consumption_quantity' in self.mapped_value_property_list: self.mapped_value_property_list = filter(lambda s: s!='consumption_quantity',self.mapped_value_property_list) if 'production_quantity' in self.mapped_value_property_list: self.mapped_value_property_list = filter(lambda s: s!='production_quantity',self.mapped_value_property_list) if 'quantity' not in self.mapped_value_property_list: self.mapped_value_property_list = list(self.mapped_value_property_list) + ['quantity'] # First check if quantity already exists quantity = self._baseGetQuantity() if quantity not in (0.0, 0, None): return quantity # Make sure inventory is defined somewhere (here or parent) if getattr(aq_base(self), 'inventory', None) is None: return 0.0 # No inventory defined, so no quantity # Find total of movements in the past - XXX resource_value = self.getResourceValue() if resource_value is not None: # Inventories can only be done in "real" locations / sectinos, not categories thereof # -> therefore we use node and section current_inventory = resource_value.getInventory( at_date = self.getStartDate(), variation_text = self.getVariationText(), node = self.getDestination(), section = self.getDestinationSection(), simulation_state = current_inventory_state_list) inventory = self.getInventory() if current_inventory in (None, ''): current_inventory = 0.0 return self.getInventory() - current_inventory return self.getInventory() security.declareProtected( Permissions.AccessContentsInformation, 'getInventory' ) def getInventory(self): """ Returns the quantity if defined on the cell or acquire it """ # Call a script on the context if 'inventory' in self.getMappedValuePropertyList([]): if getattr(aq_base(self), 'inventory', None) is not None: return getattr(self, 'inventory') else: return self.aq_parent.getProperty('inventory') else: return None # return None def _setItemIdList(self, value): """ Computes total_quantity of all given items and stores this total_quantity in the inventory attribute of the cell """ previous_item_list = self.getAggregateValueList() given_item_id_list = value item_object_list = [] for item in given_item_id_list : item_result_list = self.portal_catalog(id = item, portal_type="Piece Tissu") if len(item_result_list) == 1 : try : object = item_result_list[0].getObject() except : object = None else : object = None if object is not None : # if item was in previous_item_list keep it if object in previous_item_list : # we can add this item to the list of aggregated items item_object_list.append(object) # if new item verify if variated_resource of item == variated_resource of movement elif (self.getResource() == object.getResource()) and (self.getVariationCategoryList() == object.getVariationCategoryList()) : # we can add this item to the list of aggregated items item_object_list.append(object) # update item_id_list and build relation self.setAggregateValueList(item_object_list) # update inventory if needed if len(item_object_list)>0 : quantity = 0 for object_item in item_object_list : quantity += object_item.getRemainingQuantity() self.setInventory(quantity) # Required for indexing security.declareProtected(Permissions.AccessContentsInformation, 'getInventoriatedQuantity') def getInventoriatedQuantity(self): """ Take into account efficiency in converted target quantity """ return Movement.getInventoriatedQuantity(self) security.declareProtected(Permissions.AccessContentsInformation, 'getStartDate') def getStartDate(self): """ Take into account efficiency in converted target quantity """ return Movement.getStartDate(self) security.declareProtected(Permissions.AccessContentsInformation, 'getStopDate') def getStopDate(self): """ Take into account efficiency in converted target quantity """ return Movement.getStopDate(self) def _setProducedItemIdList(self, value): """ Computes total_quantity of all given items and stores this total_quantity in the quantity attribute of the cell """ previous_item_list = self.getAggregateValueList() given_item_id_list = value item_object_list = [] for item in given_item_id_list : item_result_list = self.portal_catalog(id = item, portal_type="Piece Tissu") if len(item_result_list) == 1 : try : object = item_result_list[0].getObject() except : object = None else : object = None if object is not None : # if item was in previous_item_list keep it if object in previous_item_list : # we can add this item to the list of aggregated items item_object_list.append(object) # if new item verify if variated_resource of item == variated_resource of movement elif (self.getResource() == object.getResource()) and (self.getVariationCategoryList() == object.getVariationCategoryList()) : # now verify if item can be moved (not already done) last_location_title = object.getLastLocationTitle() if self.getDestinationTitle() != last_location_title or last_location_title == '' : # we can add this item to the list of aggregated items item_object_list.append(object) # update item_id_list and build relation self.setAggregateValueList(item_object_list) # update inventory if needed if len(item_object_list)>0 : quantity = 0 for object_item in item_object_list : quantity += object_item.getQuantity() self.setProductionQuantity(quantity) def _setConsumedItemIdList(self, value): """ Computes total_quantity of all given items and stores this total_quantity in the quantity attribute of the cell """ previous_item_list = self.getAggregateValueList() given_item_id_list = value item_object_list = [] for item in given_item_id_list : item_result_list = self.portal_catalog(id = item, portal_type="Piece Tissu") if len(item_result_list) == 1 : try : object = item_result_list[0].getObject() except : object = None else : object = None if object is not None : # if item was in previous_item_list keep it if object in previous_item_list : # we can add this item to the list of aggregated items item_object_list.append(object) # if new item verify if variated_resource of item == variated_resource of movement elif (self.getResource() == object.getResource()) and (self.getVariationCategoryList() == object.getVariationCategoryList()) : # now verify if item can be moved (not already done) last_location_title = object.getLastLocationTitle() if self.getDestinationTitle() == last_location_title or last_location_title == '' : # we can add this item to the list of aggregated items item_object_list.append(object) # update item_id_list and build relation self.setAggregateValueList(item_object_list) # update inventory if needed if len(item_object_list)>0 : quantity = 0 for object_item in item_object_list : quantity += object_item.getRemainingQuantity() # we reset the location of the item object_item.setLocation('') self.setConsumptionQuantity(quantity) def getProducedItemIdList(self): """ Returns list of items if production_quantity != 0.0 """ if self.getProductionQuantity() != 0.0 : return self.getItemIdList() else : return [] def getConsumedItemIdList(self): """ Returns list of items if consumption_quantity != 0.0 """ if self.getConsumptionQuantity() != 0.0 : return self.getItemIdList() else : return [] # Inventory cataloging security.declareProtected(Permissions.AccessContentsInformation, 'getConvertedInventory') def getConvertedInventory(self): """ provides a default inventory value - None since no inventory was defined. """ return self.getInventory() # XXX quantity unit is missing