Subversion Repositories SmartDukaan

Rev

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

Rev 384 Rev 483
Line 12... Line 12...
12 
 
 12 
 
13 
 
 13 
 
14 
 
 14 
 
15 
class Warehouse(Entity):
 15 
class Warehouse(Entity):
16 
    id = Field(Integer, primary_key=True, autoincrement=True)
 16 
    id = Field(Integer, primary_key=True, autoincrement=True)
17 
    location = Field(String(20))
 17 
    location = Field(String(200))
18 
    status = Field(Integer)
 18 
    status = Field(Integer)
19 
    addedOn = Field(DateTime)
 19 
    addedOn = Field(DateTime)
- 
 
 20 
    lastCheckedOn = Field(DateTime)
- 
 
 21 
    tinNumber = Field(String(50))
- 
 
 22 
    pincode = Field(String(10))
- 
 
 23 
    vendorString = Field(String(50))
20 
    inventory = OneToMany('CurrentInventorySnapshot')
 24 
    inventory = OneToMany('CurrentInventorySnapshot')
21 
    inventoryHistory = OneToMany('ItemInventoryHistory')
 25 
    inventoryHistory = OneToMany('ItemInventoryHistory')
22
26
23 
    def __repr__(self):
 27 
    def __repr__(self):
24 
        return "<warehouse>%s</warehouse>" %(self.location)
 28 
        return "<warehouse>%s</warehouse>" %(self.location)
Line 30... Line 34...
30 
            items.append(ci.item)
 34 
            items.append(ci.item)
31 
        return items
35 
        return items
32
36
33 
class Item(Entity):
 37 
class Item(Entity):
34 
    id = Field(Integer, primary_key=True, autoincrement=True)
 38 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 39 
    manufacturer_name = Field(String(100))
- 
 
 40 
    model_number = Field(String(50))
- 
 
 41 
    model_name = Field(String(50))
- 
 
 42 
    category = Field(String(50))
- 
 
 43 
    comments = Field(String(200))
35 
    catalog_item_id = Field(Integer)
 44 
    catalog_item_id = Field(Integer)
36 
    vendor_item_id = Field(Integer)
 45 
    vendor_item_id = Field(String(50))
37 
    feature_id = Field(Integer)
 46 
    feature_id = Field(Integer)
38 
    feature_description = Field(String(200))
 47 
    feature_description = Field(String(200))
- 
 
 48 
    mrp = Field(Float)
- 
 
 49 
    mop = Field(Float)
- 
 
 50 
    sellingPrice = Field(Float)
- 
 
 51 
    weight = Field(Float)
39 
    addedOn = Field(DateTime)
 52 
    addedOn = Field(DateTime)
40 
    status = Field(Integer)
 - 
 
41 
    initDate = Field(DateTime)
 - 
 
42 
    startDate = Field(DateTime)
 53 
    startDate = Field(DateTime)
43 
    retireDate = Field(DateTime)
 54 
    retireDate = Field(DateTime)
44 
    weight = Field(Float)
 55 
    status = Field(Integer)
45 
    prices = OneToMany("Price")
 - 
 
46 
    currentInventory = OneToMany('CurrentInventorySnapshot')
 56 
    currentInventory = OneToMany('CurrentInventorySnapshot')
47 
    inventoryHistory = OneToMany('ItemInventoryHistory')
 57 
    inventoryHistory = OneToMany('ItemInventoryHistory')
48 
    iteminfo = OneToMany("ItemInfo")
 58 
    iteminfo = OneToMany("ItemInfo")
49 
    statusChangeLog = OneToMany("ItemChangeLog")
 59 
    statusChangeLog = OneToMany("ItemChangeLog")
50
60
Line 90... Line 100...
90 
        return "<ItemInfo><key>%s</key><value>%s</value></ItemInfo>" % (self.key, self.value)
 100 
        return "<ItemInfo><key>%s</key><value>%s</value></ItemInfo>" % (self.key, self.value)
91
101
92 
 
 102 
 
93 
class CurrentInventorySnapshot(Entity):
 103 
class CurrentInventorySnapshot(Entity):
94 
    #id = Field(Integer, primary_key=True)
 104 
    #id = Field(Integer, primary_key=True)
95 
    checkedOn = Field(DateTime, default=datetime.datetime.now())
 105 
    #checkedOn = Field(DateTime, default=datetime.datetime.now())
96 
    availibility = Field(Integer)
 106 
    availibility = Field(Integer)
97 
    item = ManyToOne("Item")
 107 
    item = ManyToOne("Item")
98 
    warehouse = ManyToOne("Warehouse")
 108 
    warehouse = ManyToOne("Warehouse")
99
109
100 
    def __repr__(self):
 110 
    def __repr__(self):