Subversion Repositories SmartDukaan

class Vendor(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    name = Field(String(50))

    warehouses = OneToMany('Warehouse')

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class Warehouse(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    displayName = Field(String(50))

    location = Field(String(200))

    addedOn = Field(DateTime)

    lastCheckedOn = Field(DateTime)

    tinNumber = Field(String(50))

    pincode = Field(String(10))

    vendorString = Field(String(50))

    badInventory = OneToMany('BadInventorySnapshot')

    inventory = OneToMany('CurrentInventorySnapshot')

    inventoryHistory = OneToMany('ItemInventoryHistory')

    logisticsLocation = Field(Integer)

    vendor = ManyToOne('Vendor')

    billingType = Field(Integer)

    inventoryType = Field(Enum('GOOD', 'BAD', 'VIRTUAL'))

    warehouseType = Field(Enum('OURS', 'THIRD_PARTY'))

    shippingWarehouseId = Field(Integer)

    billingWarehouseId = Field(Integer)

    transferDelayInHours = Field(Integer)

    isAvailabilityMonitored = Field(Boolean)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

    def __repr__(self):

        return "<warehouse>%s</warehouse>" %(self.location)

    @property

    def all_items(self):

        items = []

        for ci in self.inventory:

            items.append(ci.item)

        return items 

    currentInventory = OneToMany('CurrentInventorySnapshot')

    inventoryHistory = OneToMany('ItemInventoryHistory')

    @property

    def get_total_inventory(self):

        if self.currentInventory:

            i = 0

            for entry in self.currentInventory:

                i += entry.availability - entry.reserved

            return i

        else:

            return 0;

    @property

    def get_all_warehouses(self):

        return [ci.warehouse for ci in self.currentInventory]

class VendorItemMapping(Entity):

    vendor = ManyToOne('Vendor', primary_key=True)

    item_key = Field(String(200), primary_key=True)

    item = ManyToOne('Item')

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class VendorItemPricing(Entity):

    vendor = ManyToOne('Vendor', primary_key=True)

    item = ManyToOne('Item', primary_key=True)

    mop = Field(Float)

    dealerPrice = Field(Float)

    transfer_price = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class VendorItemProcurementDelay(Entity):

    vendor = ManyToOne('Vendor', primary_key=True)

    item = ManyToOne('Item', primary_key=True)

    procurementDelay = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class VendorHolidays(Entity):

    vendor = ManyToOne('Vendor', primary_key=True)

    holidayType = Field(Integer, primary_key=True, autoincrement=False)

    holidayValue = Field(Integer, primary_key=True, autoincrement=False)

    occasion = Field(String(100))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class CurrentInventorySnapshot(Entity):

    item = ManyToOne("Item", primary_key=True)

    warehouse = ManyToOne("Warehouse", primary_key=True)

    availability = Field(Integer)

    reserved = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

    def __repr__(self):

        return "<current inventory><availability> %s </availability><time>%s</time><item>%s</item><warehouse>%s</warehouse></current inventory>" %(self.availability, self.checkedOn, self.item, self.warehouse)

class BadInventorySnapshot(Entity):

    item = ManyToOne("Item", primary_key=True)

    warehouse = ManyToOne("Warehouse", primary_key=True)

    availability = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class SupplierInventorySnapshot(Entity):

    item = ManyToOne("Item", primary_key=True)

    warehouse = ManyToOne("Warehouse", primary_key=True)

    availability = Field(Integer)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ItemInventoryHistory(Entity):

    id = Field(Integer, primary_key=True, autoincrement = True)    

    timestamp = Field(DateTime, default=datetime.datetime.now())

    availability = Field(Integer)

    item = ManyToOne("Item")

    warehouse = ManyToOne("Warehouse")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

    def __repr__(self):

        pass

class MissedInventoryUpdate(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    itemKey = Field(String(200))

    quantity = Field(Integer)

    warehouseId = Field(Integer)

    isIgnored = Field(Boolean)

    timestamp = Field(DateTime)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ItemAvailabilityCache(Entity):

    itemId = Field(Integer, primary_key=True, autoincrement=False)

    warehouseId = Field(Integer)

    expectedDelay = Field(Integer)

    billingWarehouseId = Field(Integer)

    sellingPrice = Field(Float) 

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")