Subversion Repositories SmartDukaan

Rev

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

Rev 602 Rev 609
Line 14... Line 14...
14 
 
 14 
 
15 
class BestSellers(Entity):
 15 
class BestSellers(Entity):
16 
    item_id = Field(Integer, primary_key=True)
 16 
    item_id = Field(Integer, primary_key=True)
17 
    priority = Field(Integer)
 17 
    priority = Field(Integer)
18 
    status = Field(Integer)
 18 
    status = Field(Integer)
19
- 
 
20 
class BestDeals(Entity):
 - 
 
21 
    item_id = Field(Integer, primary_key=True)
 - 
 
22 
    priority = Field(Integer)
 - 
 
23 
    status = Field(Integer)
 - 
 
24 
 
 19 
 
25 
class Warehouse(Entity):
 20 
class Warehouse(Entity):
26 
    id = Field(Integer, primary_key=True, autoincrement=True)
 21 
    id = Field(Integer, primary_key=True, autoincrement=True)
27 
    location = Field(String(200))
 22 
    location = Field(String(200))
28 
    status = Field(Integer)
 23 
    status = Field(Integer)
Line 47... Line 42...
47 
class Item(Entity):
 42 
class Item(Entity):
48 
    id = Field(Integer, primary_key=True, autoincrement=True)
 43 
    id = Field(Integer, primary_key=True, autoincrement=True)
49 
    manufacturer_name = Field(String(100))
 44 
    manufacturer_name = Field(String(100))
50 
    model_number = Field(String(50))
 45 
    model_number = Field(String(50))
51 
    model_name = Field(String(50))
 46 
    model_name = Field(String(50))
- 
 
 47 
    color = Field(String(20))
52 
    category = Field(String(50))
 48 
    category = Field(String(50))
53 
    comments = Field(String(200))
 49 
    comments = Field(String(200))
54 
    catalog_item_id = Field(Integer)
 50 
    catalog_item_id = Field(Integer)
55 
    vendor_item_id = Field(String(50))
 51 
    vendor_item_id = Field(String(50))
56 
    feature_id = Field(Integer)
 52 
    feature_id = Field(Integer)
57 
    feature_description = Field(String(200))
 53 
    feature_description = Field(String(200))
58 
    mrp = Field(Float)
 54 
    mrp = Field(Float)
59 
    mop = Field(Float)
 55 
    mop = Field(Float)
60 
    sellingPrice = Field(Float)
 56 
    sellingPrice = Field(Float)
- 
 
 57 
    dealerPrice = Field(Float)
61 
    weight = Field(Float)
 58 
    weight = Field(Float)
62 
    addedOn = Field(DateTime)
 59 
    addedOn = Field(DateTime)
- 
 
 60 
    updatedOn = Field(DateTime)
63 
    startDate = Field(DateTime)
 61 
    startDate = Field(DateTime)
64 
    retireDate = Field(DateTime)
 62 
    retireDate = Field(DateTime)
65 
    status = Field(Integer)
 63 
    status = Field(Integer)
- 
 
 64 
    bestDealText = Field(String(100))
- 
 
 65 
    bestDealValue = Field(Integer)
66 
    currentInventory = OneToMany('CurrentInventorySnapshot')
 66 
    currentInventory = OneToMany('CurrentInventorySnapshot')
67 
    inventoryHistory = OneToMany('ItemInventoryHistory')
 67 
    inventoryHistory = OneToMany('ItemInventoryHistory')
68 
    iteminfo = OneToMany("ItemInfo")
 68 
    iteminfo = OneToMany("ItemInfo")
69 
    statusChangeLog = OneToMany("ItemChangeLog")
 69 
    statusChangeLog = OneToMany("ItemChangeLog")
70
70
Line 86... Line 86...
86 
    def get_all_warehouses(self):
 86 
    def get_all_warehouses(self):
87 
        warehouses = []
 87 
        warehouses = []
88 
        for ci in self.currentInventory:
 88 
        for ci in self.currentInventory:
89 
            warehouses.append(ci.warehouse)
 89 
            warehouses.append(ci.warehouse)
90 
        return warehouses
 90 
        return warehouses
91 
 
 - 
 
92 
 
 91
93 
class Price(Entity):
 - 
 
94 
    id = Field(Integer, primary_key=True, autoincrement=True)
 - 
 
95 
    price = Field(Float)
 - 
 
96 
    warehouse_id = Field(Integer)
 - 
 
97 
    item = ManyToOne("Item")
 - 
 
98
- 
 
99 
    def __repr__(self):
 - 
 
100 
        return "<price><item_id> %d </item_id><warehouse_id> %d </warehouse_id><val> %f </val> </price>" % (self.item.id, self.warehouse_id, self.price)
 - 
 
101 
 
 - 
 
102
- 
 
103 
class ItemInfo(Entity):
 92 
class ItemInfo(Entity):
104 
    id = Field(Integer, primary_key=True, autoincrement=True)
 93 
    id = Field(Integer, primary_key=True, autoincrement=True)
105 
    key = Field(String(30))
 94 
    key = Field(String(30))
106 
    value = Field(String(100))
 95 
    value = Field(String(100))
107 
    item = ManyToOne("Item")
 96 
    item = ManyToOne("Item")