| 4503 |
mandeep.dh |
1 |
'''
|
|
|
2 |
Created on 29-Jul-2011
|
|
|
3 |
|
|
|
4 |
@author: Chandranshu
|
|
|
5 |
'''
|
|
|
6 |
from elixir.entity import Entity
|
|
|
7 |
from elixir.fields import Field
|
|
|
8 |
from elixir.options import using_options, using_table_options
|
|
|
9 |
from elixir.relationships import ManyToOne
|
|
|
10 |
from shop2020.thriftpy.purchase.ttypes import LineItem as TLineItem
|
|
|
11 |
from shop2020.utils.Utils import to_java_date
|
|
|
12 |
from sqlalchemy.types import Integer, String, Float, DateTime, Boolean
|
|
|
13 |
import datetime
|
|
|
14 |
|
|
|
15 |
|
|
|
16 |
class LineItem(Entity):
|
|
|
17 |
'''
|
|
|
18 |
classdocs
|
|
|
19 |
'''
|
|
|
20 |
purchaseOrder = ManyToOne("PurchaseOrder", primary_key=True)
|
|
|
21 |
itemId = Field(Integer, primary_key=True, autoincrement=False)
|
|
|
22 |
productGroup = Field(String(100))
|
|
|
23 |
brand = Field(String(100))
|
|
|
24 |
modelNumber = Field(String(50))
|
|
|
25 |
modelName = Field(String(50))
|
|
|
26 |
color = Field(String(20))
|
|
|
27 |
itemNumber = Field(String(20))
|
|
|
28 |
quantity = Field(Float)
|
|
|
29 |
unfulfilledQuantity = Field(Float)
|
|
|
30 |
createdAt = Field(DateTime)
|
|
|
31 |
unitPrice = Field(Float)
|
| 7672 |
rajveer |
32 |
nlc = Field(Float)
|
| 4503 |
mandeep.dh |
33 |
fulfilled = Field(Boolean)
|
| 6821 |
amar.kumar |
34 |
availableQuantity = Field(Integer)
|
|
|
35 |
reservedQuantity = Field(Integer)
|
|
|
36 |
avgSales = Field(Float)
|
|
|
37 |
minStockLevel = Field(Integer)
|
|
|
38 |
numberOfDaysStock = Field(Integer)
|
|
|
39 |
suggestedQuantity = Field(Integer)
|
|
|
40 |
numberOfDaysInStock = Field(Integer)
|
| 8182 |
amar.kumar |
41 |
rtoOrders = Field(Integer)
|
| 6880 |
amar.kumar |
42 |
lastXdaysSale = Field(String(50))
|
|
|
43 |
previouslyOrderedQty = Field(Integer)
|
| 9416 |
amar.kumar |
44 |
mrp = Field(Float)
|
| 4503 |
mandeep.dh |
45 |
using_options(shortnames=True)
|
|
|
46 |
using_table_options(mysql_engine="InnoDB")
|
|
|
47 |
|
|
|
48 |
def __init__(self, purchase_order, t_line_item):
|
|
|
49 |
'''
|
|
|
50 |
Constructor
|
|
|
51 |
'''
|
|
|
52 |
self.purchaseOrder = purchase_order
|
|
|
53 |
self.itemId = t_line_item.itemId
|
|
|
54 |
self.productGroup = t_line_item.productGroup
|
|
|
55 |
self.brand = t_line_item.brand
|
|
|
56 |
self.modelNumber = t_line_item.modelNumber
|
|
|
57 |
self.modelName = t_line_item.modelName
|
|
|
58 |
self.color = t_line_item.color
|
|
|
59 |
self.itemNumber = t_line_item.itemNumber
|
|
|
60 |
self.quantity = t_line_item.quantity
|
| 5450 |
mandeep.dh |
61 |
self.unfulfilledQuantity = t_line_item.unfulfilledQuantity
|
| 4503 |
mandeep.dh |
62 |
self.createdAt = datetime.datetime.now()
|
|
|
63 |
self.unitPrice = t_line_item.unitPrice
|
| 7672 |
rajveer |
64 |
self.nlc = t_line_item.nlc
|
| 4503 |
mandeep.dh |
65 |
self.fulfilled = False
|
| 9416 |
amar.kumar |
66 |
if t_line_item.availableQuantity:
|
|
|
67 |
self.availableQuantity = t_line_item.availableQuantity
|
|
|
68 |
if t_line_item.reservedQuantity:
|
|
|
69 |
self.reservedQuantity = t_line_item.reservedQuantity
|
|
|
70 |
if t_line_item.avgSales:
|
|
|
71 |
self.avgSales = t_line_item.avgSales
|
|
|
72 |
if t_line_item.minStockLevel:
|
|
|
73 |
self.minStockLevel = t_line_item.minStockLevel
|
|
|
74 |
if t_line_item.numberOfDaysStock:
|
|
|
75 |
self.numberOfDaysStock = t_line_item.numberOfDaysStock
|
|
|
76 |
if t_line_item.rtoOrders:
|
|
|
77 |
self.rtoOrders = t_line_item.rtoOrders
|
|
|
78 |
if t_line_item.suggestedQuantity:
|
|
|
79 |
self.suggestedQuantity = t_line_item.suggestedQuantity
|
|
|
80 |
if t_line_item.numberOfDaysInStock:
|
|
|
81 |
self.numberOfDaysInStock = t_line_item.numberOfDaysInStock
|
|
|
82 |
if t_line_item.lastXdaysSale:
|
|
|
83 |
self.lastXdaysSale = t_line_item.lastXdaysSale
|
|
|
84 |
if t_line_item.previouslyOrderedQty:
|
|
|
85 |
self.previouslyOrderedQty = t_line_item.previouslyOrderedQty
|
|
|
86 |
if t_line_item.mrp:
|
|
|
87 |
self.mrp = t_line_item.mrp
|
| 4503 |
mandeep.dh |
88 |
|
|
|
89 |
def to_thrift_object(self):
|
|
|
90 |
t_line_item = TLineItem()
|
|
|
91 |
t_line_item.orderId = self.purchaseOrder.id
|
|
|
92 |
t_line_item.itemId = self.itemId
|
|
|
93 |
#TODO: Fetch the next 5 items from the catalog service
|
|
|
94 |
t_line_item.productGroup = self.productGroup
|
|
|
95 |
t_line_item.brand = self.brand
|
|
|
96 |
t_line_item.modelNumber = self.modelNumber
|
|
|
97 |
t_line_item.modelName = self.modelName
|
|
|
98 |
t_line_item.color = self.color
|
|
|
99 |
t_line_item.itemNumber = self.itemNumber
|
|
|
100 |
t_line_item.quantity = self.quantity
|
| 6882 |
amar.kumar |
101 |
if t_line_item.quantity < 0:
|
|
|
102 |
t_line_item.quantity = 0
|
| 4503 |
mandeep.dh |
103 |
t_line_item.unfulfilledQuantity = self.unfulfilledQuantity
|
|
|
104 |
t_line_item.createdAt = to_java_date(self.createdAt)
|
| 6837 |
amar.kumar |
105 |
t_line_item.unitPrice = self.unitPrice
|
| 7672 |
rajveer |
106 |
t_line_item.nlc = self.nlc
|
| 4503 |
mandeep.dh |
107 |
t_line_item.fulfilled = self.fulfilled
|
| 6821 |
amar.kumar |
108 |
t_line_item.availableQuantity = self.availableQuantity
|
|
|
109 |
t_line_item.reservedQuantity = self.reservedQuantity
|
|
|
110 |
t_line_item.avgSales = self.avgSales
|
|
|
111 |
t_line_item.minStockLevel = self.minStockLevel
|
|
|
112 |
t_line_item.numberOfDaysStock = self.numberOfDaysStock
|
|
|
113 |
t_line_item.suggestedQuantity = self.suggestedQuantity
|
|
|
114 |
t_line_item.numberOfDaysInStock = self.numberOfDaysInStock
|
| 8182 |
amar.kumar |
115 |
t_line_item.rtoOrders = self.rtoOrders
|
| 6857 |
amar.kumar |
116 |
t_line_item.lastXdaysSale = self.lastXdaysSale
|
| 6880 |
amar.kumar |
117 |
t_line_item.previouslyOrderedQty = self.previouslyOrderedQty
|
| 9416 |
amar.kumar |
118 |
t_line_item.mrp = self.mrp
|
| 4503 |
mandeep.dh |
119 |
return t_line_item
|