Subversion Repositories SmartDukaan

'''

Created on 29-Jul-2011

@author: Chandranshu

'''

from elixir.entity import Entity

from elixir.fields import Field

from elixir.options import using_options, using_table_options

from elixir.relationships import ManyToOne

from shop2020.thriftpy.purchase.ttypes import LineItem as TLineItem

from shop2020.utils.Utils import to_java_date

from sqlalchemy.types import Integer, String, Float, DateTime, Boolean

import datetime

class LineItem(Entity):

    '''

    classdocs

    '''

    purchaseOrder = ManyToOne("PurchaseOrder", primary_key=True)

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

    productGroup = Field(String(100))

    brand = Field(String(100))

    modelNumber = Field(String(50))

    modelName = Field(String(50))

    color = Field(String(20))

    itemNumber = Field(String(20))

    quantity = Field(Float)

    unfulfilledQuantity = Field(Float)

    createdAt = Field(DateTime)

    unitPrice = Field(Float)

    nlc = Field(Float)

    fulfilled = Field(Boolean)

    availableQuantity = Field(Integer) 

    reservedQuantity = Field(Integer)

    avgSales = Field(Float)

    minStockLevel = Field(Integer)

    numberOfDaysStock = Field(Integer)

    suggestedQuantity = Field(Integer)

    numberOfDaysInStock = Field(Integer)

    rtoOrders = Field(Integer)

    lastXdaysSale = Field(String(50))

    previouslyOrderedQty = Field(Integer)

    mrp = Field(Float)

    nlcP = Field(Float)

    vatDiff = Field(Float)

    igstRate = Field(Float)

    sgstRate = Field(Float)

    cgstRate = Field(Float)

    hsnCode = Field(String(12))

    invoicePrice = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

    def __init__(self, purchase_order, t_line_item):

        '''

        Constructor

        '''

        self.purchaseOrder = purchase_order

        self.itemId = t_line_item.itemId

        self.productGroup = t_line_item.productGroup

        self.brand = t_line_item.brand

        self.modelNumber = t_line_item.modelNumber

        self.modelName = t_line_item.modelName

        self.color = t_line_item.color

        self.itemNumber = t_line_item.itemNumber

        self.quantity = t_line_item.quantity

        self.unfulfilledQuantity = t_line_item.unfulfilledQuantity

        self.createdAt = datetime.datetime.now()

        self.unitPrice = t_line_item.unitPrice

        self.nlc = t_line_item.nlc

        self.fulfilled = False

        if t_line_item.availableQuantity:

            self.availableQuantity = t_line_item.availableQuantity

        if t_line_item.reservedQuantity:

            self.reservedQuantity = t_line_item.reservedQuantity

        if t_line_item.avgSales:

            self.avgSales = t_line_item.avgSales

        if t_line_item.minStockLevel:

            self.minStockLevel = t_line_item.minStockLevel

        if t_line_item.numberOfDaysStock:

            self.numberOfDaysStock = t_line_item.numberOfDaysStock

        if t_line_item.rtoOrders:

            self.rtoOrders = t_line_item.rtoOrders

        if t_line_item.suggestedQuantity:

            self.suggestedQuantity = t_line_item.suggestedQuantity

        if t_line_item.numberOfDaysInStock:

            self.numberOfDaysInStock = t_line_item.numberOfDaysInStock

        if t_line_item.lastXdaysSale:

            self.lastXdaysSale = t_line_item.lastXdaysSale

        if t_line_item.previouslyOrderedQty:

            self.previouslyOrderedQty = t_line_item.previouslyOrderedQty

        if t_line_item.mrp:

            self.mrp = t_line_item.mrp

        self.nlcP = t_line_item.nlcP

        self.vatDiff = t_line_item.vatDiff

        self.cgstRate = t_line_item.cgstRate

        self.sgstRate = t_line_item.sgstRate

        self.igstRate = t_line_item.igstRate

        self.hsnCode = t_line_item.hsnCode

    def to_thrift_object(self):

        t_line_item = TLineItem()

        t_line_item.orderId = self.purchaseOrder.id

        t_line_item.itemId = self.itemId

        #TODO: Fetch the next 5 items from the catalog service

        t_line_item.productGroup = self.productGroup

        t_line_item.brand = self.brand

        t_line_item.modelNumber = self.modelNumber

        t_line_item.modelName = self.modelName

        t_line_item.color = self.color

        t_line_item.itemNumber = self.itemNumber

        t_line_item.quantity = self.quantity

        if t_line_item.quantity < 0:

            t_line_item.quantity = 0

        t_line_item.unfulfilledQuantity = self.unfulfilledQuantity

        t_line_item.createdAt = to_java_date(self.createdAt)

        t_line_item.unitPrice = self.unitPrice

        t_line_item.nlc = self.nlc

        t_line_item.fulfilled = self.fulfilled

        t_line_item.availableQuantity = self.availableQuantity

        t_line_item.reservedQuantity = self.reservedQuantity

        t_line_item.avgSales = self.avgSales

        t_line_item.minStockLevel = self.minStockLevel

        t_line_item.numberOfDaysStock = self.numberOfDaysStock

        t_line_item.suggestedQuantity = self.suggestedQuantity

        t_line_item.numberOfDaysInStock = self.numberOfDaysInStock

        t_line_item.rtoOrders = self.rtoOrders

        t_line_item.lastXdaysSale = self.lastXdaysSale

        t_line_item.previouslyOrderedQty = self.previouslyOrderedQty

        t_line_item.mrp = self.mrp

        t_line_item.nlcP = self.nlcP

        t_line_item.vatDiff = self.vatDiff

        t_line_item.sgstRate = self.sgstRate

        t_line_item.hsnCode = self.hsnCode

        t_line_item.cgstRate = self.cgstRate

        t_line_item.igstRate = self.igstRate

        t_line_item.sgstRate = self.sgstRate

        t_line_item.invoicePrice = self.invoicePrice

        return t_line_item