Subversion Repositories SmartDukaan

Rev

Rev 5512 | Rev 5944 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5512 Rev 5513
Line 106... Line 106...
106
    @property
106
    @property
107
    def get_total_inventory(self):
107
    def get_total_inventory(self):
108
        if self.currentInventory:
108
        if self.currentInventory:
109
            i = 0
109
            i = 0
110
            for entry in self.currentInventory:
110
            for entry in self.currentInventory:
111
                i += entry.availability
111
                i += entry.availability - entry.reserved
112
            return i
112
            return i
113
        
113
        
114
        else:
114
        else:
115
            return 0;
115
            return 0;
116
    
116
    
Line 164... Line 164...
164
    item = ManyToOne("Item", primary_key=True)
164
    item = ManyToOne("Item", primary_key=True)
165
    warehouse = ManyToOne("Warehouse", primary_key=True)
165
    warehouse = ManyToOne("Warehouse", primary_key=True)
166
    availability = Field(Integer)
166
    availability = Field(Integer)
167
    using_options(shortnames=True)
167
    using_options(shortnames=True)
168
    using_table_options(mysql_engine="InnoDB")
168
    using_table_options(mysql_engine="InnoDB")
-
 
169
 
-
 
170
class SupplierInventorySnapshot(Entity):
-
 
171
    item = ManyToOne("Item", primary_key=True)
-
 
172
    warehouse = ManyToOne("Warehouse", primary_key=True)
-
 
173
    availability = Field(Integer)
-
 
174
    using_options(shortnames=True)
-
 
175
    using_table_options(mysql_engine="InnoDB")
169
 
176
 
170
class ItemInventoryHistory(Entity):
177
class ItemInventoryHistory(Entity):
171
    id = Field(Integer, primary_key=True, autoincrement = True)    
178
    id = Field(Integer, primary_key=True, autoincrement = True)    
172
    timestamp = Field(DateTime, default=datetime.datetime.now())
179
    timestamp = Field(DateTime, default=datetime.datetime.now())
173
    availability = Field(Integer)
180
    availability = Field(Integer)