def test_get_available_sellables_query(self): # Sellable and query without supplier sellable = self.create_sellable() self.create_storable(product=sellable.product, branch=self.create_branch()) self.assertIn( sellable, self.store.find(Sellable, Sellable.get_available_sellables_query(self.store))) sellable.close() self.assertNotIn( sellable, self.store.find(Sellable, Sellable.get_available_sellables_query(self.store))) delivery_sellable = sysparam(self.store).DELIVERY_SERVICE.sellable delivery_sellable.status = Sellable.STATUS_AVAILABLE # Deliveries are treated differently, that's why they should # not be present here self.assertNotIn( sellable, self.store.find(Sellable, Sellable.get_available_sellables_query(self.store)))
def get_sellable_view_query(self): branch = api.get_current_branch(self.store) branch_query = Or(Field('_stock_summary', 'branch_id') == branch.id, Eq(Field('_stock_summary', 'branch_id'), None)) query = And(branch_query, Sellable.get_available_sellables_query(self.store)) return self.sellable_view, query
def get_sellable_view_query(self): # The stock quantity of consigned products can not be # decreased manually. See bug 5212. query = And(Eq(Product.consignment, False), self.sellable_view.branch_id == self.model.branch_id, Sellable.get_available_sellables_query(self.store)) return self.sellable_view, query
def get_sellable_view_query(self): branch = api.get_current_branch(self.store) branch_query = Or(ProductStockItem.branch_id == branch.id, Eq(ProductStockItem.branch_id, None)) query = And(branch_query, Sellable.get_available_sellables_query(self.store)) return self.sellable_view, query
def get_sellable_view_query(self): return ( self.sellable_view, # FIXME: How to do this using sellable_view.find_by_branch ? And( Or(ProductStockItem.branch_id == self.model.branch.id, Eq(ProductStockItem.branch_id, None)), Sellable.get_available_sellables_query(self.store)))
def get_sellable_view_query(self): branch = self.model.branch branch_query = ProductStockItem.branch_id == branch.id # The stock quantity of consigned products can not be # decreased manually. See bug 5212. query = And(branch_query, Product.consignment == False, Sellable.get_available_sellables_query(self.store)) return self.sellable_view, query
def get_sellable_view_query(self): branch = self.model.branch # Also include products that are not storable branch_query = Or(self.sellable_view.branch_id == branch.id, Eq(self.sellable_view.branch_id, None)) # The stock quantity of consigned products can not be # decreased manually. See bug 5212. query = And(branch_query, Sellable.get_available_sellables_query(self.store)) return self.sellable_view, query
def get_sellable_view_query(self): return ( self.sellable_view, # FIXME: How to do this using sellable_view.find_by_branch ? And( Or( Field('_stock_summary', 'branch_id') == self.model.branch.id, Eq(Field('_stock_summary', 'branch_id'), None)), Sellable.get_available_sellables_query(self.store)))
def get_sellable_view_query(self): return (self.sellable_view, # FIXME: How to do this using sellable_view.find_by_branch ? And(Or(ProductStockItem.branch_id == self.model.branch.id, ProductStockItem.branch_id == None), Sellable.get_available_sellables_query(self.store)))
def get_sellable_view_query(self): return (self.sellable_view, # FIXME: How to do this using sellable_view.find_by_branch ? And(Or(Field('_stock_summary', 'branch_id') == self.model.branch.id, Eq(Field('_stock_summary', 'branch_id'), None)), Sellable.get_available_sellables_query(self.store)))