Subversion Repositories SmartDukaan

Rev

Rev 4370 | Rev 4406 | 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,
108
	34:i32 warrantyPeriod
85 ashish 109
}
110
 
1343 chandransh 111
struct VendorItemPricing{
1349 chandransh 112
	1:i64 vendorId,
113
	2:i64 itemId,
1343 chandransh 114
	3:double transferPrice,
115
	4:double mop,
116
	5:double dealerPrice
117
}
118
 
1967 rajveer 119
struct Category{
120
	1:i64 id,
121
	2:string label,
122
	3:string description,
123
	4:i64 parent_category_id,
124
	/**
125
	* This field should not be used.
126
	*/
127
	5:list<i64> children_category_ids
128
}
2113 ankur.sing 129
 
130
struct VendorItemMapping{
131
	1:i64 vendorId,
132
	2:string itemKey,
133
	3:i64 itemId,
134
	4:string vendorCategory
135
}
2983 chandransh 136
 
137
struct ItemShippingInfo{
138
	1:bool isActive,
139
	2:optional bool isRisky,
140
	3:optional i64 quantity
141
}
142
 
3556 rajveer 143
struct Source{
144
	1:i64 id,
145
	2:string name,
146
	3:string identifier
147
}
148
 
149
struct SourceItemPricing{
150
	1:i64 sourceId,
151
	2:i64 itemId,
152
	3:double mrp,
153
	4:double sellingPrice
154
}
155
 
4024 chandransh 156
struct AvailableAndReservedStock {
157
	1:i64 itemId,
158
	2:i64 available,
159
	3:i64 reserved,
160
	4:i64 minimumStock
161
}
162
 
4295 varun.gupt 163
struct ProductNotificationRequest	{
164
	1:Item item,
165
	2:string email,
166
	3:i64 addedOn
167
}
168
 
169
struct ProductNotificationRequestCount	{
170
	1:Item item,
171
	2:i64 count
172
}
173
 
121 ashish 174
exception InventoryServiceException{
85 ashish 175
	1:i64 id,
176
	2:string message
177
}
178
 
3374 rajveer 179
service InventoryService extends GenericService.GenericService{
763 rajveer 180
 
85 ashish 181
/**
182
	Availability and inventory attributes	
183
*/
184
	//all add and update methods - added by Ashish
123 ashish 185
	i64 addItem(1:Item item) throws (1:InventoryServiceException cex),
186
	i64 updateItem(1:Item item) throws (1:InventoryServiceException cex),
121 ashish 187
	i64 addWarehouse(1:Warehouse warehouse) throws (1:InventoryServiceException cex),
2983 chandransh 188
 
189
	/**
4332 anupam.sin 190
	add a new vendor
191
	*/
192
	i64 addVendor(1:Vendor vendor) throws (1:InventoryServiceException cex),
193
	bool addWarehouseVendorMapping(1:i64 warehouse_id, 2:i64 vendorId),
194
	list<Vendor> getVendorsForWarehouse(1:i64 warehouse_id),
195
	list<Warehouse> getWarehousesForVendor(1:i64 vendorId),
196
 
197
	/**
2983 chandransh 198
	Checks if the item given to the corresponding itemId is active. If it's active,
199
	whether it's risky and if it's risky, its inventory position.
200
	*/
201
	ItemShippingInfo isActive(1:i64 itemId) throws (1:InventoryServiceException isex),
202
 
2033 rajveer 203
	string getItemStatusDescription(1:i64 itemId) throws (1:InventoryServiceException isex),
3323 chandransh 204
 
205
	/**
206
	Stores the incremental warehouse updates of items.
207
	*/
208
	void updateInventoryHistory(1:i64 warehouse_id, 2:string timestamp, 3:map<string, i64> availability) throws (1:InventoryServiceException cex),
209
 
210
	/**
211
	Stores the final inventory stocks of items.
212
	*/
483 rajveer 213
	void updateInventory(1:i64 warehouse_id, 2:string timestamp, 3:map<string, i64> availability) throws (1:InventoryServiceException cex),
2983 chandransh 214
 
4320 rajveer 215
	/**
216
	Add the inventory to existing stock.
217
	*/
218
	void addInventory(1:i64 itemId, 2:i64 warehouseId, 3:i64 quantity) throws (1:InventoryServiceException cex),
219
 
103 ashish 220
	//all delete methods
121 ashish 221
	void retireWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
103 ashish 222
 
223
	//Item management apis
121 ashish 224
	void startItemOn(1:i64 item_id, 2:i64 timestamp) throws (1:InventoryServiceException cex),
225
	void retireItemOn(1:i64 item_id, 2:i64 timestamp) throws (1:InventoryServiceException cex),
226
	void changeItemStatus(1:i64 item_id, 2:i64 timestamp, 3:status newstatus) throws (1:InventoryServiceException cex),
85 ashish 227
	//Other accessor methods - added by Ashish
121 ashish 228
	Item getItem(1:i64 item_id) throws (1:InventoryServiceException cex),
632 rajveer 229
	list<Item> getItemsByCatalogId(1:i64 catalog_item_id) throws  (1:InventoryServiceException cex),
121 ashish 230
	list<Item> getAllItems(1:bool isActive) throws (1:InventoryServiceException cex),
231
	list<Item> getAllItemsByStatus(1:status itemStatus) throws (1:InventoryServiceException cex),
232
	ItemInventory getItemInventory(1:i64 item_id) throws (1:InventoryServiceException cex),
632 rajveer 233
	ItemInventory getItemInventoryByItemId(1:i64 item_id) throws (1:InventoryServiceException cex),
234
	//ItemInventory getItemInventoryByCatalogId(1:i64 item_id) throws (1:InventoryServiceException cex),
121 ashish 235
	i64 getItemAvailibilityAtWarehouse(1:i64 warehouse_id, 2:i64 item_id) throws (1:InventoryServiceException cex),
2076 rajveer 236
	bool markItemAsContentComplete(1:i64 entityId, 2:i64 category, 3:string brand, 4:string modelName, 5:string modelNumber) throws (1:InventoryServiceException cex),
646 chandransh 237
 
3355 chandransh 238
	/**
3848 chandransh 239
	Gets at most 'limit' items starting at the given offset. Returns an empty list if there are no more items at the given offset.
240
	*/
241
	list<Item> getAllItemsInRange(1:i64 offset, 2:i64 limit) throws (1:InventoryServiceException cex),
242
 
243
	/**
244
	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.
245
	*/
246
	list<Item> getAllItemsByStatusInRange(1:status itemStatus, 2:i64 offset, 3:i64 limit) throws (1:InventoryServiceException cex),
247
 
248
	/**
249
	Gets a count of all items by status
250
	*/
251
	i32 getItemCountByStatus(1:bool useStatus, 2:status itemStatus),
252
	/**
3355 chandransh 253
	Determines the warehouse that should be used to fulfil an order for the given item.
254
	It first checks all the warehouses which are in the logistics location given by the
255
	warehouse_loc parameter. If none of the warehouses there have any inventory, then the
256
	preferred warehouse for the item is used. 
1157 rajveer 257
 
3355 chandransh 258
	Returns an ordered list of size 4 with following elements in the given order:
259
	1. Logistics location of the warehouse which was finally picked up to ship the order.  
260
	2. Id of the warehouse which was finally picked up.
261
	3. Inventory size in the selected warehouse.
262
	4. Expected delay added by the category manager.
646 chandransh 263
	 */
264
	list<i64> getItemAvailabilityAtLocation(1:i64 warehouse_loc, 2:i64 item_id) throws (1:InventoryServiceException isex),
3355 chandransh 265
 
121 ashish 266
	list<Warehouse> getAllWarehouses(1:bool isActive) throws (1:InventoryServiceException cex),
1343 chandransh 267
 
268
	/**
269
	 Returns the warehouse with the given id.
270
	*/
121 ashish 271
	Warehouse getWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
272
	list<Warehouse> getAllWarehousesForItem(1:i64 item_id) throws (1:InventoryServiceException cex),
502 rajveer 273
	list<Item> getAllItemsForWarehouse(1:i64 warehouse_id) throws (1:InventoryServiceException cex),
274
 
862 chandransh 275
	/**
276
	 Increases the reservation count for an item in a warehouse. Should always succeed normally.
277
	*/
278
	bool reserveItemInWarehouse(1:i64 itemId, 2:i64 warehouseId, 3:double quantity) throws (1:InventoryServiceException cex),
279
 
280
	/**
281
	 Decreases the reservation count for an item in a warehouse. Should always succeed normally.
282
	*/
283
	bool reduceReservationCount(1:i64 itemId, 2:i64 warehouseId, 3:double quantity) throws (1:InventoryServiceException cex),
284
 
502 rajveer 285
	// for home page .... best deals, best sellers and latest arrivals
588 chandransh 286
	list<Item> getBestSellers() throws (1:InventoryServiceException isex),
1924 rajveer 287
	list<i64> getBestSellersCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:i64 category) throws (1:InventoryServiceException cex),
588 chandransh 288
	i64 getBestSellersCount() throws (1:InventoryServiceException cex),
289
 
290
	list<Item> getBestDeals() throws (1:InventoryServiceException isex),
1924 rajveer 291
	list<i64> getBestDealsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:i64 category) throws (1:InventoryServiceException cex),
588 chandransh 292
	i64 getBestDealsCount() throws (1:InventoryServiceException cex),
293
 
2975 chandransh 294
	/**
295
	Returns a list of items sorted in the descending order by start date.
296
	The list is limited to the 'latest_arrivals_count' configuraiton parameter.
297
	*/
588 chandransh 298
	list<Item> getLatestArrivals() throws (1:InventoryServiceException isex),
2975 chandransh 299
 
300
	/**
301
	Returns the list of catalog ids of latest arrivals in the given categories of the given brand.
302
	To ignore the categories, pass the list as empty. To ignore brand, pass it as null.   
303
	*/
304
	list<i64> getLatestArrivalsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:string brand, 4:list<i64> categories) throws (1:InventoryServiceException cex),
305
 
306
	/**
307
	Get the total number of latest arrivals we are willing to show.
308
	The count's upper bound is the 'latest_arrivals_count' configuraiton parameter.
309
	*/
632 rajveer 310
	i64 getLatestArrivalsCount() throws (1:InventoryServiceException cex),
311
 
1157 rajveer 312
 
313
	i64 generateNewEntityID(),
314
 
315
	/**
1343 chandransh 316
	Returns the pricing information of an item associated with the vendor of the given warehouse.
317
	Raises an exception if either the item, vendor or the associated pricing information can't be found.
318
	*/
4283 anupam.sin 319
	VendorItemPricing getItemPricing(1:i64 itemId, 2:i64 vendorId) throws (1:InventoryServiceException cex),
1343 chandransh 320
 
321
	/**
1157 rajveer 322
	* Store category object and retrieve it
323
	*/
1967 rajveer 324
	/**
632 rajveer 325
	bool putCategoryObject(1:binary object),
326
	binary getCategoryObject()
1967 rajveer 327
	*/
328
 
329
	/**
330
	* All category related functions
331
	*/
332
	bool addCategory(1:Category category),
333
	Category getCategory(1:i64 id),
1990 ankur.sing 334
	list<Category> getAllCategories(),
1967 rajveer 335
 
1990 ankur.sing 336
	/**
337
	Returns the list of vendor pricing information of an item.
338
	Raises an exception if item not found corresponding to itemId
339
	*/
340
	list<VendorItemPricing> getAllItemPricing(1:i64 itemId) throws (1:InventoryServiceException cex),
341
 
342
 
343
	/**
2113 ankur.sing 344
	Adds vendor prices corresponding to the item. If pricing already exists then updates the prices. 
1990 ankur.sing 345
	Raises an exception if either the item or vendor can't be found corresponding to their ids.
346
	*/
2113 ankur.sing 347
	void addVendorItemPricing(1:VendorItemPricing vendorItemPricing) throws (1:InventoryServiceException cex),
1990 ankur.sing 348
 
2063 ankur.sing 349
	/**
350
	Return list of all vendors
351
	*/
2113 ankur.sing 352
	list<Vendor> getAllVendors(), 
2063 ankur.sing 353
 
2113 ankur.sing 354
	/**
355
	Checks if the item exists in VendorItemMapping for the given hotspot parameters (ProductGroup,Brand,ModelNumber,Color),
356
	vendor and category.
357
	Returns true if it exists else false.
358
	*/
359
	bool itemExists(1:string productGroup, 2:string brand, 3:string modelNumber, 4:string color, 5:i64 vendor_id, 6:string category),
360
 
361
	/**
2356 ankur.sing 362
	Adds VendorItemMapping. Updates VendorItemMapping if exists corresponding to the item key.  
2113 ankur.sing 363
	*/
2356 ankur.sing 364
	void addVendorItemMapping(1:string key, 2:VendorItemMapping vendorItemMapping) throws (1:InventoryServiceException cex),
2113 ankur.sing 365
 
366
	/**
367
	Returns the list of vendor item mapping corresponding to itemId passed as parameter.
368
	Raises an exception if item not found corresponding to itemId
369
	*/
370
	list<VendorItemMapping> getVendorItemMappings(1:i64 itemId) throws (1:InventoryServiceException cex),
371
 
372
	/**
373
	Checks if similar item exists (with same ProductGroup, Brand, ModelNumber, Color)
374
	If yes, returns the itemId else returns 0
375
	*/
2284 ankur.sing 376
	i64 checkSimilarItem(1:string productGroup, 2:string brand, 3:string modelNumber, 4:string color),
377
 
378
	/**
379
	Marks/Unmarks an item as risky. This flag is used for automatic marking of an item as INACTIVE in case of zero inventory.
380
	*/
2356 ankur.sing 381
	void changeItemRiskyFlag(1:i64 itemId, 2:bool risky),
382
 
383
	/**
384
	Returns list of items marked as risky.
385
	*/
386
	list<Item> getItemsByRiskyFlag(),
387
 
388
	/**
389
	Returns list of items with any status except PHASED_OUT and filtered by vendor category.
390
	Raises exception if vendorCategory is null. 
391
	*/
2807 rajveer 392
	list<Item> getItemsByVendorCategory(1:string vendorCategory),
393
 
394
	/**
395
	Returns list of catalog ids of items with same similarity index as of the given itemId 
396
	*/
397
	list<i64> getSimilarItemsCatalogIds(1:i64 beginIndex, 2:i64 totalItems, 3:i64 itemId),
3079 rajveer 398
 
399
	/**
400
	Add user requests for out of stock items. Once user will ask for notify me an entry will 
401
	*/
3086 rajveer 402
	bool addProductNotification(i64 itemId, string email),
3079 rajveer 403
 
3086 rajveer 404
	/**
405
		Send the product notifications to the users for items which has stock.
406
	*/
3348 varun.gupt 407
	bool sendProductNotifications(),
3079 rajveer 408
 
3348 varun.gupt 409
	/**
410
		Returns list of brand names for a given category Id
411
	*/
3556 rajveer 412
	list<string> getAllBrandsByCategory(1:i64 categoryId),
413
 
414
	/**
415
	Return list of all sources
416
	*/
417
	list<Source> getAllSources(), 
418
 
419
	/**
420
	Returns the pricing information of an item. If no information is found, exception will be thrown.
421
	*/
422
	SourceItemPricing getItemPricingBySource(1:i64 itemId, 2:i64 sourceId) throws (1:InventoryServiceException cex),
423
 
424
	/**
425
	Adds prices to be displayed corresponding to the item if user comes from a source.
426
	If item is not found or source is not found, it will throw exception.
427
	*/
428
	void addSourceItemPricing(1:SourceItemPricing sourceItemPricing) throws (1:InventoryServiceException cex),
429
 
430
	/**
431
	Returns the list of source pricing information of an item.
432
	Raises an exception if item not found corresponding to itemId
433
	*/
434
	list<SourceItemPricing> getAllSourcePricing(1:i64 itemId) throws (1:InventoryServiceException cex),
435
 
436
	/**
437
	Get the item for a given itemId and sourceId. MRP and sellingPrice will be updated for source if we have different prices for source.
438
	*/
3872 chandransh 439
	Item getItemForSource(1:i64 item_id, 2:optional i64  sourceId) throws (1:InventoryServiceException cex),
440
 
441
	/**
442
	Searches items matching the the given terms in the catalog and returns results within the specified range.
443
	*/
444
	list<Item> searchItemsInRange(1:list<string> searchTerms, 2:i64 offset, 3:i64 limit),
445
 
446
	/**
447
	Gets the count of search results for the given search terms so that the user can go through all the pages.
448
	*/
4024 chandransh 449
	i32 getSearchResultCount(1:list<string> searchTerms),
450
 
451
	/**
4063 chandransh 452
	Returns a list of inventory stock for items for which there are pending orders for the given vendor.
4024 chandransh 453
	*/
4295 varun.gupt 454
	list<AvailableAndReservedStock> getPendingOrdersInventory(1:i64 vendorid),
455
 
456
	/**
457
	Returns a list of product notifications added after a supplied datetime
458
	*/
459
	list<ProductNotificationRequest> getProductNotifications(1:i64 startDateTime),
460
 
461
	/**
462
	Returns a list of count of requests for product notification against each item
463
	*/
464
	list<ProductNotificationRequestCount> getProductNotificationRequestCount(1:i64 startDateTime)
4370 anupam.sin 465
 
466
	/**
467
	This method creates a purchase order from an excel sheet containing Item Id and Quantity column and returns the PO Id.
468
	*/
469
	string processPurchaseOrder(1:string filename 2:i32 vendorId) throws (1:InventoryServiceException cex)
4295 varun.gupt 470
}