Subversion Repositories SmartDukaan

Rev

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

Rev 4748 Rev 4762
Line 64... Line 64...
64 
    comments = Field(String(200))
 64 
    comments = Field(String(200))
65 
    catalog_item_id = Field(Integer)
 65 
    catalog_item_id = Field(Integer)
66 
    feature_id = Field(Integer)
 66 
    feature_id = Field(Integer)
67 
    feature_description = Field(String(200))
 67 
    feature_description = Field(String(200))
68 
    mrp = Field(Float)
 68 
    mrp = Field(Float)
69 
    mop = Field(Float)
 - 
 
70 
    sellingPrice = Field(Float)
 69 
    sellingPrice = Field(Float)
71 
    dealerPrice = Field(Float)
 - 
 
72 
    transfer_price = Field(Float)
 - 
 
73 
    weight = Field(Float)
 70 
    weight = Field(Float)
74 
    addedOn = Field(DateTime)
 71 
    addedOn = Field(DateTime)
75 
    updatedOn = Field(DateTime)
 72 
    updatedOn = Field(DateTime)
76 
    startDate = Field(DateTime)
 73 
    startDate = Field(DateTime)
77 
    retireDate = Field(DateTime)
 74 
    retireDate = Field(DateTime)
Line 82... Line 79...
82 
    bestSellingRank = Field(Integer)
 79 
    bestSellingRank = Field(Integer)
83 
    currentInventory = OneToMany('CurrentInventorySnapshot')
 80 
    currentInventory = OneToMany('CurrentInventorySnapshot')
84 
    inventoryHistory = OneToMany('ItemInventoryHistory')
 81 
    inventoryHistory = OneToMany('ItemInventoryHistory')
85 
    iteminfo = OneToMany("ItemInfo")
 82 
    iteminfo = OneToMany("ItemInfo")
86 
    statusChangeLog = OneToMany("ItemChangeLog")
 83 
    statusChangeLog = OneToMany("ItemChangeLog")
87 
    hotspotCategory = Field(String(50))
 - 
 
88 
    preferredWarehouse = Field(String(50))
 84 
    preferredWarehouse = Field(Integer)
89 
    defaultForEntity = Field(Boolean)
 85 
    defaultForEntity = Field(Boolean)
90 
    risky = Field(Boolean)
 86 
    risky = Field(Boolean)
91 
    expectedDelay = Field(Integer)
 87 
    expectedDelay = Field(Integer)
92 
    warranty_period = Field(Integer)
 88 
    warranty_period = Field(Integer)
93 
    defaultWarehouse = Field(String(50))
 89 
    defaultWarehouse = Field(Integer)
94 
    isWarehousePreferenceSticky = Field(Boolean)
 90 
    isWarehousePreferenceSticky = Field(Boolean)
95 
    preferredVendor = Field(Integer)
 91 
    preferredVendor = Field(Integer)
96 
    using_options(shortnames=True)
 92 
    using_options(shortnames=True)
97 
    using_table_options(mysql_engine="InnoDB")
 93 
    using_table_options(mysql_engine="InnoDB")
98
94
Line 116... Line 112...
116 
 
 112 
 
117 
class VendorItemMapping(Entity):
 113 
class VendorItemMapping(Entity):
118 
    vendor = ManyToOne('Vendor', primary_key=True)
 114 
    vendor = ManyToOne('Vendor', primary_key=True)
119 
    item_key = Field(String(200), primary_key=True)
 115 
    item_key = Field(String(200), primary_key=True)
120 
    item = ManyToOne('Item')
 116 
    item = ManyToOne('Item')
121 
    vendor_category = Field(String(50))
 - 
 
122 
    using_options(shortnames=True)
 117 
    using_options(shortnames=True)
123 
    using_table_options(mysql_engine="InnoDB")
 118 
    using_table_options(mysql_engine="InnoDB")
124
119
125 
class VendorItemPricing(Entity):
 120 
class VendorItemPricing(Entity):
126 
    vendor = ManyToOne('Vendor', primary_key=True)
 121 
    vendor = ManyToOne('Vendor', primary_key=True)
Line 183... Line 178...
183 
class Category(Entity):
 178 
class Category(Entity):
184 
    id = Field(Integer, primary_key=True, autoincrement=False)
 179 
    id = Field(Integer, primary_key=True, autoincrement=False)
185 
    label = Field(String(50))
 180 
    label = Field(String(50))
186 
    description = Field(String(200))
 181 
    description = Field(String(200))
187 
    parent_category_id = Field(Integer)
 182 
    parent_category_id = Field(Integer)
- 
 
 183 
    display_name = Field(String(50))
188 
    using_options(shortnames=True)
 184 
    using_options(shortnames=True)
189 
    using_table_options(mysql_engine="InnoDB")
 185 
    using_table_options(mysql_engine="InnoDB")
190 
 
 186 
 
191 
class SimilarItems(Entity):
 187 
class SimilarItems(Entity):
192 
    item = ManyToOne('Item', primary_key=True)
 188 
    item = ManyToOne('Item', primary_key=True)