############################################################################## # # Copyright (c) 2002-2005 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 AccessControl import ClassSecurityInfo from Acquisition import aq_base from Products.ERP5Type import Permissions, PropertySheet, Interface from Products.ERP5Type.XMLMatrix import XMLMatrix from Products.ERP5.Document.DeliveryLine import DeliveryLine from Products.ERP5.Document.Movement import Movement from zLOG import LOG class InventoryLine(DeliveryLine): """ An Inventory Line describe the inventory of a resource, by variations. """ meta_type = 'ERP5 Inventory Line' portal_type = 'Inventory Line' add_permission = Permissions.AddPortalContent isPortalContent = 1 isRADContent = 1 # Declarative security security = ClassSecurityInfo() security.declareObjectProtected(Permissions.View) # Declarative interfaces __implements__ = ( Interface.Variated, ) # Declarative properties property_sheets = ( PropertySheet.Base , PropertySheet.XMLObject , PropertySheet.CategoryCore , PropertySheet.Amount , PropertySheet.Inventory , PropertySheet.Task , PropertySheet.Arrow , PropertySheet.Movement , PropertySheet.VariationRange , PropertySheet.ItemAggregation ) 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'] DeliveryLine._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.AccessContentsInformation, 'getTotalInventory') def getTotalInventory(self): """ Returns the inventory if no cell or the total inventory if cells """ if not self.hasCellContent(): return self.getInventory() else: # Use MySQL aggregate = self.InventoryLine_zGetTotal()[0] return aggregate.total_inventory security.declareProtected(Permissions.AccessContentsInformation, 'getQuantity') def getQuantity(self): """ Computes a quantity which allows to reach inventory """ if not self.hasCellContent(): # 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_category = self.getDestinationSection() , simulation_state = self.getPortalCurrentInventoryStateList() ) inventory = self.getInventory() if current_inventory in (None, ''): current_inventory = 0.0 return self.getInventory() - current_inventory return self.getInventory() else: return None ### (kev) This method can't be deleted as long as Delivery.newCellContent() has its own # XMLMatrix.newCellContent() method. The latter is kept because we fear its deletion will # break existing scripts and code in ERP5. (kev) security.declareProtected(Permissions.ModifyPortalContent, 'newCellContent') newCellContent = XMLMatrix.newCellContent def _setItemIdList(self, value): """ Computes total_quantity of all given items and stores this total_quantity in the inventory attribute of the cell """ if value is None: return 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.getQuantity() self.setInventory(quantity) def _setProducedItemIdList(self, value): """ Computes total_quantity of all given items and stores this total_quantity in the quantity attribute of the cell """ if value is None: return 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 """ if value is None: return 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 # Required for indexing security.declareProtected(Permissions.AccessContentsInformation, 'getInventoriatedQuantity') def getInventoriatedQuantity(self): """ Take into account efficiency in converted target quantity """ return Movement.getInventoriatedQuantity(self)