############################################################################## # # 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 Acquisition import aq_base from AccessControl import ClassSecurityInfo from Products.ERP5Type import Permissions, PropertySheet, Interface from Products.ERP5.Document.DeliveryCell import DeliveryCell class InventoryCell(DeliveryCell): """ An InventoryCell allows to define specific inventory for each variation of a resource in an inventory 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.MappedValue , PropertySheet.ItemAggregation ) def _edit(self, REQUEST=None, force_update = 0, **kw): DeliveryCell._edit(self, REQUEST=REQUEST, force_update = force_update, **kw) # Calculate inventory item_list = self.getAggregateValueList() if len(item_list) > 0: inventory = 0 for item in item_list: if item.getQuantity() not in (None, ''): inventory += item.getQuantity() self.setInventory(inventory) 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 or 0.0 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( \ to_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 # XXX Following methods should be useless now # security.declareProtected( Permissions.AccessContentsInformation, 'getInventory' ) # def getInventory(self): # """ # No acquisition for inventories: either defined or None # """ # if 'inventory' in self.getMappedValuePropertyList([]): # return getattr(aq_base(self), 'inventory', None) # 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 # """ # 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.getRemainingQuantity() # 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