Subversion Repositories SmartDukaan

Rev

Rev 4375 | Rev 4423 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
85 ashish 1
namespace java in.shop2020.model.v1.catalog
95 ashish 2
namespace py shop2020.thriftpy.model.v1.catalog
85 ashish 3
 
3374 rajveer 4
include "GenericService.thrift"
5
 
85 ashish 6
/**
7
	Objects
8
*/
9
 
123 ashish 10
/**
1330 chandransh 11
Caution :- Never ever change the numbers in it. Please confirm from @Chandranshu or @Rajveer before any changes in enum and other entries in file.
123 ashish 12
**/
103 ashish 13
enum status{
123 ashish 14
	PHASED_OUT = 0,		//Item is no longer selling
15
	DELETED = 1,		//Item has been deliberately deleted 
3009 chandransh 16
	PAUSED = 2,			//Item's sale has been paused manually.
123 ashish 17
	ACTIVE = 3,			//Item is available for sale as of now
2984 rajveer 18
	IN_PROCESS = 4,		//Item has been added, but content is not available for the same
19
	CONTENT_COMPLETE = 5,  //The content for this item has been completed. We can start selling the item now.
3009 chandransh 20
	PAUSED_BY_RISK = 6    //Item's sale has been automatically paused since it was marked as risky
103 ashish 21
}
22
 
646 chandransh 23
enum WarehouseLocation{
1330 chandransh 24
	Mumbai = 0,
25
	Delhi = 1,
646 chandransh 26
	Bangalore = 2,
27
	Kolkata = 3
28
}
29
 
1330 chandransh 30
struct Vendor{
31
	1:i64 id,
32
	2:string name
33
}
34
 
2841 chandransh 35
enum BillingType {
36
	OURS = 0,
37
	EXTERNAL = 1
38
}
39
 
483 rajveer 40
/* 
41
Warehouse fields details
42
location: it is full address
43
vendorString: some key for the warehouse
44
*/
85 ashish 45
struct Warehouse{
46
	1:i64 id,
752 chandransh 47
	2:string displayName,
48
	3:string location,
49
	4:status warehouseStatus,
50
	5:i64 addedOn,
51
	6:i64 lastCheckedOn,
52
	7:string tinNumber,
53
	8:string pincode,
54
	9:string vendorString,
2824 chandransh 55
	10:WarehouseLocation logisticsLocation,
56
	11:string vendor,
4375 anupam.sin 57
	12:BillingType billingType
85 ashish 58
}
4024 chandransh 59
 
115 ashish 60
/* */
85 ashish 61
struct ItemInventory{
62
	1:i64 id,
483 rajveer 63
	2:map<i64,i64> availability
85 ashish 64
}
65
 
483 rajveer 66
 
85 ashish 67
struct ItemInventoryHistory{
68
	1:i64 item_id,
69
	2:i64 warehouse_id,
70
	3:i64 timestamp,
71
	4:i64 availability
72
}
73
 
74
struct Item{
75
	1:i64 id,
956 chandransh 76
	2:string productGroup
77
	3:string brand,
78
	4:string modelNumber,
2128 ankur.sing 79
	5:string modelName,
80
	6:string color,
81
	7:i64 category,
82
	8:string comments,
83
	9:i64 catalogItemId,
84
	10:i64 featureId,
85
	11:string featureDescription,
86
	12:ItemInventory itemInventory,
2127 ankur.sing 87
	13:optional double mrp, //maxmimum retail price
2491 ankur.sing 88
	14:optional double mop, //market operative price
2127 ankur.sing 89
	15:optional double sellingPrice, //Selling price
2491 ankur.sing 90
	16:optional double transferPrice,
2127 ankur.sing 91
	17:optional double weight,
2128 ankur.sing 92
	18:i64 addedOn,
2491 ankur.sing 93
	19:optional i64 startDate,
94
	20:optional i64 retireDate,
720 chandransh 95
	21:status itemStatus,
2128 ankur.sing 96
	22:string status_description,
97
	23:map<string,string> otherInfo,
98
	24:string bestDealText,
2127 ankur.sing 99
	25:optional double bestDealValue,
2491 ankur.sing 100
	26:optional double dealerPrice,
2128 ankur.sing 101
	27:bool defaultForEntity,
102
	28:i64 updatedOn,
2127 ankur.sing 103
	29:optional i64 bestSellingRank, 
2249 ankur.sing 104
	30:string hotspotCategory,
3355 chandransh 105
	31:bool risky,
3359 chandransh 106
	32:optional i32 expectedDelay,
4295 varun.gupt 107
	33:optional string preferredWarehouse,
4406 anupam.sin 108
	34:optional string defaultWarehouse,
109
	35:optional bool isWarehousePreferenceSticky,
110
	36:i32 warrantyPeriod
85 ashish 111
}
112
 
1343 chandransh 113
struct VendorItemPricing{
1349 chandransh 114
	1:i64 vendorId,
115
	2:i64 itemId,
1343 chandransh 116
	3:double transferPrice,
117
	4:double mop,
118
	5:double dealerPrice
119
}
120
 
1967 rajveer 121
struct Category{
122
	1:i64 id,
123
	2:string label,
124
	3:string description,
125
	4:i64 parent_category_id,
126
	/**
127
	* This field should not be used.
128
	*/
129
	5:list<i64> children_category_ids
130
}
2113 ankur.sing 131
 
132
struct VendorItemMapping{
133
	1:i64 vendorId,
134
	2:string itemKey,
135
	3:i64 itemId,
136
	4:string vendorCategory
137
}
2983 chandransh 138
 
139
struct ItemShippingInfo{
140
	1:bool isActive,
141
	2:optional bool isRisky,
142
	3:optional i64 quantity
143
}
144
 
3556 rajveer 145
struct Source{
146
	1:i64 id,
147
	2:string name,
148
	3:string identifier
149
}
150
 
151
struct SourceItemPricing{
152
	1:i64 sourceId,
153
	2:i64 itemId,
154
	3:double mrp,
155
	4:double sellingPrice
156
}
157
 
4024 chandransh 158
struct AvailableAndReservedStock {
159
	1:i64 itemId,
160
	2:i64 available,
161
	3:i64 reserved,
162
	4:i64 minimumStock
163
}
164
 
4295 varun.gupt 165
struct ProductNotificationRequest	{
166
	1:Item item,
167
	2:string email,
168
	3:i64 addedOn
169
}
170
 
171
struct ProductNotificationRequestCount	{
172
	1:Item item,
173
	2:i64 count
174
}
175
 
121 ashish 176
exception InventoryServiceException{
85 ashish 177
	1:i64 id,
178
	2:string message
179
}
180
 
3374 rajveer 181
service InventoryService extends GenericService.GenericService{
763 rajveer 182
 
85 ashish 183
/**
184
	Availability and inventory attributes	
185
*/
186
	//all add and update methods - added by Ashish
123 ashish 187
	i64 addItem(1:Item item) throws (1:InventoryServiceException cex),
188
	i64 updateItem(1:Item item) throws (1:InventoryServiceException cex),
121 ashish 189
	i64 addWarehouse(1:Warehouse warehouse) throws (1:InventoryServiceException cex),
2983 chandransh 190
 
191
	/**
4332 anupam.sin 192
	add a new vendor
193
	*/
194
	i64 addVendor(1:Vendor vendor) throws (1:InventoryServiceException cex),
195
	bool addWarehouseVendorMapping(1:i64 warehouse_id, 2:i64 vendorId),
196
	list<Vendor> getVendorsForWarehouse(1:i64 warehouse_id),
197
	list<Warehouse> getWarehousesForVendor(1:i64 vendorId),
198
 
199
	/**
2983 chandransh 200
	Checks if the item given to the corresponding itemId is active. If it's active,
201
	whether it's risky and if it's risky, its inventory position.
202
	*/
203
	ItemShippingInfo isActive(1:i64 itemId) throws (1:InventoryServiceException isex),
204
 
2033 rajveer 205
	string getItemStatusDescription(1:i64 itemId) throws (1:InventoryServiceException isex),
3323 chandransh 206
 
207
	/**
208
	Stores the incremental warehouse updates of items.
209
	*/
210
	void updateInventoryHistory(1:i64 warehouse_id, 2:string timestamp, 3:map<string, i64> availability) throws (1:InventoryServiceException cex),
211
 
212
	/**
213
	Stores the final inventory stocks of items.
214
	*/
483 rajveer 215
	void updateInventory(1:i64 warehouse_id, 2:string timestamp, 3:map<string, i64> availability) throws (1:InventoryServiceException cex),
2983 chandransh 216
 
4320 rajveer 217
	/**
218
	Add the inventory to existing stock.
219
	*/
220
	void addInventory(1:i64 itemId, 2:i64 warehouseId, 3:i64 quantity) throws (1:InventoryServiceException cex),
221
 
103 ashish 222
	//all delete methods
121 ashish 223
	void retireWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
103 ashish 224
 
225
	//Item management apis
121 ashish 226
	void startItemOn(1:i64 item_id, 2:i64 timestamp) throws (1:InventoryServiceException cex),
227
	void retireItemOn(1:i64 item_id, 2:i64 timestamp) throws (1:InventoryServiceException cex),
228
	void changeItemStatus(1:i64 item_id, 2:i64 timestamp, 3:status newstatus) throws (1:InventoryServiceException cex),
85 ashish 229
	//Other accessor methods - added by Ashish
121 ashish 230
	Item getItem(1:i64 item_id) throws (1:InventoryServiceException cex),
632 rajveer 231
	list<Item> getItemsByCatalogId(1:i64 catalog_item_id) throws  (1:InventoryServiceException cex),
121 ashish 232
	list<Item> getAllItems(1:bool isActive) throws (1:InventoryServiceException cex),
233
	list<Item> getAllItemsByStatus(1:status itemStatus) throws (1:InventoryServiceException cex),
234
	ItemInventory getItemInventory(1:i64 item_id) throws (1:InventoryServiceException cex),
632 rajveer 235
	ItemInventory getItemInventoryByItemId(1:i64 item_id) throws (1:InventoryServiceException cex),
236
	//ItemInventory getItemInventoryByCatalogId(1:i64 item_id) throws (1:InventoryServiceException cex),
121 ashish 237
	i64 getItemAvailibilityAtWarehouse(1:i64 warehouse_id, 2:i64 item_id) throws (1:InventoryServiceException cex),
2076 rajveer 238
	bool markItemAsContentComplete(1:i64 entityId, 2:i64 category, 3:string brand, 4:string modelName, 5:string modelNumber) throws (1:InventoryServiceException cex),
646 chandransh 239
 
3355 chandransh 240
	/**
3848 chandransh 241
	Gets at most 'limit' items starting at the given offset. Returns an empty list if there are no more items at the given offset.
242
	*/
243
	list<Item> getAllItemsInRange(1:i64 offset, 2:i64 limit) throws (1:InventoryServiceException cex),
244
 
245
	/**
246
	Gets at most 'limit' items starting at the given offset in the given status. Returns an empty list if there are no more items at the given offset.
247
	*/
248
	list<Item> getAllItemsByStatusInRange(1:status itemStatus, 2:i64 offset, 3:i64 limit) throws (1:InventoryServiceException cex),
249
 
250
	/**
251
	Gets a count of all items by status
252
	*/
253
	i32 getItemCountByStatus(1:bool useStatus, 2:status itemStatus),
254
	/**
3355 chandransh 255
	Determines the warehouse that should be used to fulfil an order for the given item.
256
	It first checks all the warehouses which are in the logistics location given by the
257
	warehouse_loc parameter. If none of the warehouses there have any inventory, then the
258
	preferred warehouse for the item is used. 
1157 rajveer 259
 
3355 chandransh 260
	Returns an ordered list of size 4 with following elements in the given order:
261
	1. Logistics location of the warehouse which was finally picked up to ship the order.  
262
	2. Id of the warehouse which was finally picked up.
263
	3. Inventory size in the selected warehouse.
264
	4. Expected delay added by the category manager.
646 chandransh 265
	 */
266
	list<i64> getItemAvailabilityAtLocation(1:i64 warehouse_loc, 2:i64 item_id) throws (1:InventoryServiceException isex),
3355 chandransh 267
 
121 ashish 268
	list<Warehouse> getAllWarehouses(1:bool isActive) throws (1:InventoryServiceException cex),
1343 chandransh 269
 
270
	/**
271
	 Returns the warehouse with the given id.
272
	*/
121 ashish 273
	Warehouse getWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
274
	list<Warehouse> getAllWarehousesForItem(1:i64 item_id) throws (1:InventoryServiceException cex),
502 rajveer 275
	list<Item> getAllItemsForWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
276
 
862 chandransh 277
	/**
278
	 Increases the reservation count for an item in a warehouse. Should always succeed normally.
279
	*/
280
	bool reserveItemInWarehouse(1:i64 itemId, 2:i64 warehouseId, 3:double quantity) throws (1:InventoryServiceException cex),
281
 
282
	/**
283
	 Decreases the reservation count for an item in a warehouse. Should always succeed normally.
284
	*/
285
	bool reduceReservationCount(1:i64 itemId, 2:i64 warehouseId, 3:double quantity) throws (1:InventoryServiceException cex),
286
 
502 rajveer 287
	// for home page .... best deals, best sellers and latest arrivals
588 chandransh 288
	list<Item> getBestSellers() throws (1:InventoryServiceException isex),
1924 rajveer 289
	list<i64> getBestSellersCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:i64 category) throws (1:InventoryServiceException cex),
588 chandransh 290
	i64 getBestSellersCount() throws (1:InventoryServiceException cex),
291
 
292
	list<Item> getBestDeals() throws (1:InventoryServiceException isex),
1924 rajveer 293
	list<i64> getBestDealsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:i64 category) throws (1:InventoryServiceException cex),
588 chandransh 294
	i64 getBestDealsCount() throws (1:InventoryServiceException cex),
295
 
2975 chandransh 296
	/**
297
	Returns a list of items sorted in the descending order by start date.
298
	The list is limited to the 'latest_arrivals_count' configuraiton parameter.
299
	*/
588 chandransh 300
	list<Item> getLatestArrivals() throws (1:InventoryServiceException isex),
2975 chandransh 301
 
302
	/**
303
	Returns the list of catalog ids of latest arrivals in the given categories of the given brand.
304
	To ignore the categories, pass the list as empty. To ignore brand, pass it as null.   
305
	*/
306
	list<i64> getLatestArrivalsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:list<i64> categories) throws (1:InventoryServiceException cex),
307
 
308
	/**
309
	Get the total number of latest arrivals we are willing to show.
310
	The count's upper bound is the 'latest_arrivals_count' configuraiton parameter.
311
	*/
632 rajveer 312
	i64 getLatestArrivalsCount() throws (1:InventoryServiceException cex),
313
 
1157 rajveer 314
 
315
	i64 generateNewEntityID(),
316
 
317
	/**
1343 chandransh 318
	Returns the pricing information of an item associated with the vendor of the given warehouse.
319
	Raises an exception if either the item, vendor or the associated pricing information can't be found.
320
	*/
4283 anupam.sin 321
	VendorItemPricing getItemPricing(1:i64 itemId, 2:i64 vendorId) throws (1:InventoryServiceException cex),
1343 chandransh 322
 
323
	/**
1157 rajveer 324
	* Store category object and retrieve it
325
	*/
1967 rajveer 326
	/**
632 rajveer 327
	bool putCategoryObject(1:binary object),
328
	binary getCategoryObject()
1967 rajveer 329
	*/
330
 
331
	/**
332
	* All category related functions
333
	*/
334
	bool addCategory(1:Category category),
335
	Category getCategory(1:i64 id),
1990 ankur.sing 336
	list<Category> getAllCategories(),
1967 rajveer 337
 
1990 ankur.sing 338
	/**
339
	Returns the list of vendor pricing information of an item.
340
	Raises an exception if item not found corresponding to itemId
341
	*/
342
	list<VendorItemPricing> getAllItemPricing(1:i64 itemId) throws (1:InventoryServiceException cex),
343
 
344
 
345
	/**
2113 ankur.sing 346
	Adds vendor prices corresponding to the item. If pricing already exists then updates the prices. 
1990 ankur.sing 347
	Raises an exception if either the item or vendor can't be found corresponding to their ids.
348
	*/
2113 ankur.sing 349
	void addVendorItemPricing(1:VendorItemPricing vendorItemPricing) throws (1:InventoryServiceException cex),
1990 ankur.sing 350
 
2063 ankur.sing 351
	/**
352
	Return list of all vendors
353
	*/
2113 ankur.sing 354
	list<Vendor> getAllVendors(), 
2063 ankur.sing 355
 
2113 ankur.sing 356
	/**
357
	Checks if the item exists in VendorItemMapping for the given hotspot parameters (ProductGroup,Brand,ModelNumber,Color),
358
	vendor and category.
359
	Returns true if it exists else false.
360
	*/
361
	bool itemExists(1:string productGroup, 2:string brand, 3:string modelNumber, 4:string color, 5:i64 vendor_id, 6:string category),
362
 
363
	/**
2356 ankur.sing 364
	Adds VendorItemMapping. Updates VendorItemMapping if exists corresponding to the item key.  
2113 ankur.sing 365
	*/
2356 ankur.sing 366
	void addVendorItemMapping(1:string key, 2:VendorItemMapping vendorItemMapping) throws (1:InventoryServiceException cex),
2113 ankur.sing 367
 
368
	/**
369
	Returns the list of vendor item mapping corresponding to itemId passed as parameter.
370
	Raises an exception if item not found corresponding to itemId
371
	*/
372
	list<VendorItemMapping> getVendorItemMappings(1:i64 itemId) throws (1:InventoryServiceException cex),
373
 
374
	/**
375
	Checks if similar item exists (with same ProductGroup, Brand, ModelNumber, Color)
376
	If yes, returns the itemId else returns 0
377
	*/
2284 ankur.sing 378
	i64 checkSimilarItem(1:string productGroup, 2:string brand, 3:string modelNumber, 4:string color),
379
 
380
	/**
381
	Marks/Unmarks an item as risky. This flag is used for automatic marking of an item as INACTIVE in case of zero inventory.
382
	*/
2356 ankur.sing 383
	void changeItemRiskyFlag(1:i64 itemId, 2:bool risky),
384
 
385
	/**
386
	Returns list of items marked as risky.
387
	*/
388
	list<Item> getItemsByRiskyFlag(),
389
 
390
	/**
391
	Returns list of items with any status except PHASED_OUT and filtered by vendor category.
392
	Raises exception if vendorCategory is null. 
393
	*/
2807 rajveer 394
	list<Item> getItemsByVendorCategory(1:string vendorCategory),
395
 
396
	/**
397
	Returns list of catalog ids of items with same similarity index as of the given itemId 
398
	*/
399
	list<i64> getSimilarItemsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:i64 itemId),
3079 rajveer 400
 
401
	/**
402
	Add user requests for out of stock items. Once user will ask for notify me an entry will 
403
	*/
3086 rajveer 404
	bool addProductNotification(i64 itemId, string email),
3079 rajveer 405
 
3086 rajveer 406
	/**
407
		Send the product notifications to the users for items which has stock.
408
	*/
3348 varun.gupt 409
	bool sendProductNotifications(),
3079 rajveer 410
 
3348 varun.gupt 411
	/**
412
		Returns list of brand names for a given category Id
413
	*/
3556 rajveer 414
	list<string> getAllBrandsByCategory(1:i64 categoryId),
415
 
416
	/**
417
	Return list of all sources
418
	*/
419
	list<Source> getAllSources(), 
420
 
421
	/**
422
	Returns the pricing information of an item. If no information is found, exception will be thrown.
423
	*/
424
	SourceItemPricing getItemPricingBySource(1:i64 itemId, 2:i64 sourceId) throws (1:InventoryServiceException cex),
425
 
426
	/**
427
	Adds prices to be displayed corresponding to the item if user comes from a source.
428
	If item is not found or source is not found, it will throw exception.
429
	*/
430
	void addSourceItemPricing(1:SourceItemPricing sourceItemPricing) throws (1:InventoryServiceException cex),
431
 
432
	/**
433
	Returns the list of source pricing information of an item.
434
	Raises an exception if item not found corresponding to itemId
435
	*/
436
	list<SourceItemPricing> getAllSourcePricing(1:i64 itemId) throws (1:InventoryServiceException cex),
437
 
438
	/**
439
	Get the item for a given itemId and sourceId. MRP and sellingPrice will be updated for source if we have different prices for source.
440
	*/
3872 chandransh 441
	Item getItemForSource(1:i64 item_id, 2:optional i64  sourceId) throws (1:InventoryServiceException cex),
442
 
443
	/**
444
	Searches items matching the the given terms in the catalog and returns results within the specified range.
445
	*/
446
	list<Item> searchItemsInRange(1:list<string> searchTerms, 2:i64 offset, 3:i64 limit),
447
 
448
	/**
449
	Gets the count of search results for the given search terms so that the user can go through all the pages.
450
	*/
4024 chandransh 451
	i32 getSearchResultCount(1:list<string> searchTerms),
452
 
453
	/**
4063 chandransh 454
	Returns a list of inventory stock for items for which there are pending orders for the given vendor.
4024 chandransh 455
	*/
4295 varun.gupt 456
	list<AvailableAndReservedStock> getPendingOrdersInventory(1:i64 vendorid),
457
 
458
	/**
459
	Returns a list of product notifications added after a supplied datetime
460
	*/
461
	list<ProductNotificationRequest> getProductNotifications(1:i64 startDateTime),
462
 
463
	/**
464
	Returns a list of count of requests for product notification against each item
465
	*/
466
	list<ProductNotificationRequestCount> getProductNotificationRequestCount(1:i64 startDateTime)
4370 anupam.sin 467
 
468
	/**
469
	This method creates a purchase order from an excel sheet containing Item Id and Quantity column and returns the PO Id.
470
	*/
471
	string processPurchaseOrder(1:string filename 2:i32 vendorId) throws (1:InventoryServiceException cex)
4295 varun.gupt 472
}