Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
68 ashish 1
namespace java in.shop2020.model.v1.order
95 ashish 2
namespace py shop2020.thriftpy.model.v1.order
68 ashish 3
/***
4
	Order objects.
5
*/
483 rajveer 6
enum OrderStatus{
845 chandransh 7
	PAYMENT_PENDING,
8
	PAYMENT_FAILED,
483 rajveer 9
	INIT,
10
	SUBMITTED_FOR_PROCESSING,
11
	ACCEPTED,
12
	INVENTORY_LOW,
495 rajveer 13
	REJECTED,
483 rajveer 14
	BILLED,
15
	READY_FOR_SHIPPING,
16
	SHIPPED_FROM_WH,
17
	SHIPPED_TO_LOGST,
18
	IN_TRANSIT,
19
	DELIVERY_SUCCESS,
20
	DELIVERY_FAILED_FIRST_ATTEMPT,
21
	DELIVERY_FAILED_SECOND_ATTEMPT,
22
	DELIVERY_FAILED_THIRD_ATTEMPT,
23
	DELIVERY_FAILED_WORNG_ADDRESS
24
	COMPLETED,
25
	CANCELED,
2537 chandransh 26
	FAILED,
27
	SALES_RETURN_IN_TRANSIT,
2611 chandransh 28
	SALES_RET_RECEIVED,
2537 chandransh 29
	DOA_PICKUP_REQUESTED,
30
	DOA_RETURN_AUTHORIZED,
31
	DOA_RETURN_IN_TRANSIT,
2600 chandransh 32
	DOA_RECEIVED,
2537 chandransh 33
	DOA_CERT_INVALID,
2614 chandransh 34
	DOA_CERT_VALID,
35
	SALES_RET_RESHIPPED,
36
	DOA_INVALID_RESHIPPED,
37
	DOA_RESHIPPED,
38
	SALES_RET_REFUNDED,
39
	DOA_VALID_REFUNDED,
40
	DOA_INVALID_REFUNDED,
41
	REFUNDED
483 rajveer 42
}
43
 
44
enum TransactionStatus{
45
	INIT,
46
	IN_PROCESS,
47
	COMPLETED,
48
	FAILED
49
}
50
 
51
 
52
struct LineItem{
53
	1:i64 id,
698 chandransh 54
	2:i64 item_id,
956 chandransh 55
	3:string productGroup
56
	4:string brand,
57
	5:string model_number,
58
	6:string color
59
	7:string model_name,
60
	8:string extra_info,
61
	9:double quantity,
62
	10:double unit_price,
63
	11:double unit_weight,
64
	12:double total_price,
1000 varun.gupt 65
	13:double transfer_price,
2780 chandransh 66
	14:double total_weight,
67
	15:optional i64 imei_number,
68
	16:optional string item_number
483 rajveer 69
}
70
 
71
 
72
struct Order{
73
	1:i64 id,
74
	2:i64 warehouse_id,
75
	/**
76
		item info
77
	**/
78
	3:list<LineItem> lineitems,
79
	/**
80
	  logistics info
81
	**/
82
	4:i64 logistics_provider_id,
83
	5:string airwaybill_no,
84
	6:string tracking_id,
85
	7:i64 expected_delivery_time,
86
	/**
87
	  customer info
88
	**/
89
	8:i64 customer_id,
90
	9:string customer_name,
91
	10:string customer_mobilenumber,
92
	11:string customer_pincode,
735 chandransh 93
	12:string customer_address1,
94
	13:string customer_address2,
95
	14:string customer_email,
96
	15:string customer_city,
97
	16:string customer_state,
483 rajveer 98
 
99
	/**
100
		status and misc info
101
	**/
735 chandransh 102
	17:OrderStatus status,
103
	18:string statusDescription,
104
	19:double total_amount,
105
	20:double total_weight,
483 rajveer 106
	/**
107
		billing info
108
	**/
735 chandransh 109
	21:string invoice_number,
110
	22:string billed_by,
483 rajveer 111
	/**
112
		timestamps
113
	**/
735 chandransh 114
	23:i64 created_timestamp,
115
	24:i64 accepted_timestamp,
116
	25:i64 billing_timestamp,
117
	26:i64 shipping_timestamp,
1115 chandransh 118
	27:i64 pickup_timestamp,
119
	28:i64 delivery_timestamp,
1210 chandransh 120
	29:i64 outofstock_timestamp,
121
	30:i64 jacket_number,
1223 chandransh 122
	31:string receiver,
123
	32:i64 batchNo,
2537 chandransh 124
	33:i64 serialNo,
125
	34:bool doaFlag,
2675 vikas 126
	35:string pickupRequestNo,
127
	36:i64 transactionId
483 rajveer 128
}
129
 
130
struct Transaction{
131
	1:i64 id,
132
	2:list<Order> orders,
680 rajveer 133
	3:i64 createdOn,
134
	4:TransactionStatus transactionStatus,
135
	5:string statusDescription,
136
	6:i64 shoppingCartid,
2219 varun.gupt 137
	7:i64 customer_id,
138
	8:string coupon_code
483 rajveer 139
}
140
 
141
struct Alert{
142
	1:i64 id,
143
	2:i64 order_id,
144
	3:i64 type,
145
	4:i64 time_set,
146
	5:string comment,
147
	6:i64 time_unset
148
}
149
 
2688 chandransh 150
struct ReturnOrder{
151
	1:i64 orderId,
2697 chandransh 152
	2:i64 warehouseId,
153
    3:i64 jacketNumber,
154
    4:string invoiceNumber,
155
    5:i64 itemId,
156
    6:string productGroup,
157
    7:string brand,
158
    8:string modelNumber,
159
    9:string modelName,
160
    10:string color,
161
    11:double totalPrice,
162
    12:double transferPrice,
163
    13:bool processedStatus,
164
    14:i64 createdAt,
165
    15:i64 processedAt
2688 chandransh 166
}
167
 
483 rajveer 168
exception TransactionServiceException{
169
	1:i32 errorCode,
170
	2:string message
171
}
172
 
173
service TransactionService{
174
 
763 rajveer 175
	/**
176
	* For closing the open session in sqlalchemy
177
	*/
178
	void closeSession(),
179
 
483 rajveer 180
	i64 createTransaction(1:Transaction transaction) throws (1:TransactionServiceException ex),
181
 
182
	//	Get transaction methods.
183
	Transaction getTransaction(1:i64 id) throws (1:TransactionServiceException ex),
184
	list<Transaction> getTransactionsForCustomer(1:i64 customerId, 2:i64 from_date, 3:i64 to_date, 4:TransactionStatus status) throws (1:TransactionServiceException ex),
185
	list<Transaction> getTransactionsForShoppingCartId(1:i64 shoppingCartId) throws (1:TransactionServiceException ex),
186
	TransactionStatus getTransactionStatus(1:i64 transactionId) throws (1:TransactionServiceException ex),
187
	bool changeTransactionStatus(1:i64 transactionId, 2:TransactionStatus status, 3:string description) throws (1:TransactionServiceException ex),
1382 varun.gupt 188
 
1398 varun.gupt 189
	bool enqueueTransactionInfoEmail(1:i64 transactionId) throws (1:TransactionServiceException ex),
1382 varun.gupt 190
 
483 rajveer 191
	//	Order getter and setters
192
 
193
	/*
194
	list<Transaction> getTransactionsForShipmentStatus(1:ShipmentStatus status, 2:i64 from_date, 3:i64 to_date) throws (1:TransactionServiceException ex),
195
	list<Transaction> getTransactionsForCustomer(1:i64 customerId, 2:i64 from_date, 3:i64 to_date, 4:TransactionStatus status) throws (1:TransactionServiceException ex),
196
	list<Transaction> getTransactionsForCustomerAndShipmentStatus(1:i64 customerId, 2:i64 from_date, 3:i64 to_date, 4:ShipmentStatus status) throws (1:TransactionServiceException ex),
197
	list<Transaction> getTransactionsForShoppingCartId(1:i64 shoppingCartId) throws (1:TransactionServiceException ex),
198
	TransactionStatus getTransactionStatus(1:i64 transactionId) throws (1:TransactionServiceException ex),
199
	bool changeTransactionStatus(1:i64 transactionId, 2:TransactionStatus status, 3:string description) throws (1:TransactionServiceException ex),
200
	*/
201
 
202
	list<Order> getAllOrders(1:OrderStatus status, 2:i64 from_date, 3:i64 to_date, 4:i64 warehouse_id) throws (1:TransactionServiceException ex),
1111 varun.gupt 203
 
1115 chandransh 204
	/**
205
	Returns orders within a range of their billing dates
206
	*/
1000 varun.gupt 207
	list<Order> getOrdersByBillingDate(1:OrderStatus status, 2:i64 start_billing_date, 3:i64 end_billing_date, 4:i64 warehouse_id) throws (1:TransactionServiceException ex),
1111 varun.gupt 208
 
1382 varun.gupt 209
	/**
210
	Returns order ids for orders which can be returned
211
	*/
212
	list<i64> getReturnableOrdersForCustomer(1:i64 customer_id, 2:i64 limit) throws (1:TransactionServiceException ex),
213
 
214
	/**
215
	Returns order ids for orders which can be cancelled
216
	*/
217
	list<i64> getCancellableOrdersForCustomer(1:i64 customer_id, 2:i64 limit) throws (1:TransactionServiceException ex),
218
 
483 rajveer 219
	bool changeOrderStatus(1:i64 orderId, 2:OrderStatus status, 3:string description) throws (1:TransactionServiceException ex),
1147 chandransh 220
 
221
	/**
222
	Add billing details such as the bill number and the biller to the Order.
223
	*/
224
	bool addBillingDetails(1:i64 orderId, 2:string invoice_number, 3:string billed_by) throws (1:TransactionServiceException ex),
225
 
226
	/**
2363 chandransh 227
	Adds jacket number and IMEI no. to the order. Doesn't update the IMEI no. if a -1 is supplied.
228
	Also marks the order as billed and sets the billing timestamp.
229
	Return false if it doesn't find the order with the given ID.
1147 chandransh 230
	*/
2780 chandransh 231
	bool addJacketNumber(1:i64 orderId, 2:i64 jacketNumber, 3:i64 imeiNumber, 4:string itemNumber, 5:string billedBy) throws (1:TransactionServiceException ex),
495 rajveer 232
 
922 rajveer 233
	bool acceptOrder(1:i64 orderId) throws (1:TransactionServiceException ex),
234
	bool billOrder(1:i64 orderId) throws (1:TransactionServiceException ex),
1000 varun.gupt 235
 
1529 ankur.sing 236
	/**
237
	Returns list of orders for given transaction Id. Also filters based on customer Id so that
238
	only user who owns the transaction can view its order details.
239
	*/
240
	list<Order> getOrdersForTransaction(1:i64 transactionId 2:i64 customerId)  throws (1:TransactionServiceException ex),
241
 
483 rajveer 242
	list<Order> getOrdersForCustomer(1:i64 customerId, 2:i64 from_date, 3:i64 to_date, 4:OrderStatus status) throws (1:TransactionServiceException ex),
243
	i64 createOrder(1:Order order) throws (1:TransactionServiceException ex),
244
	Order getOrder(1:i64 id) throws (1:TransactionServiceException ex),
245
	list<LineItem> getLineItemsForOrder(1:i64 orderId) throws (1:TransactionServiceException ex),
246
 
1529 ankur.sing 247
 
757 chandransh 248
	/**
1529 ankur.sing 249
	Returns an order for the order Id. Also checks if the order belongs to the customer whose Id is passed.
250
	Throws exception if either order Id is invalid or order does not below to the customer whose Id is passed.
251
	*/
252
	Order getOrderForCustomer(1:i64 orderId, 2:i64 customerId) throws (1:TransactionServiceException ex),
253
 
254
	/**
1223 chandransh 255
	 Create a batch of all the pending orders for the given warehouse.
256
	 The returned list is orderd by created_timestamp.
257
	 If there are no pending orders, an empty list is returned.
1244 chandransh 258
	 */
1223 chandransh 259
	list<Order> batchOrders(1:i64 warehouseId) throws (1:TransactionServiceException ex),
260
 
261
	/**
262
	Mark the given order as out of stock. Throws an exception if the order with the given Id couldn't be found. 
1244 chandransh 263
	*/
1210 chandransh 264
	bool markOrderAsOutOfStock(1:i64 orderId) throws (1:TransactionServiceException ex),
265
 
266
	/**
757 chandransh 267
	Marks all BILLED orders for a warehouse and a provider as SHIPPED_FROM_WH
268
	*/
269
	bool markOrdersAsManifested(1:i64 warehouseId, 2:i64 providerId) throws (1:TransactionServiceException ex),
1115 chandransh 270
 
271
	/**
272
	Marks all SHIPPED_FROM_WH orders of the previous day for a provider as SHIPPED_TO_LOGISTICS.
273
	Returns a list of orders that were shipped from warehouse but did not appear in the pick-up report.
274
	Raises an exception if we encounter report for an AWB number that we did not ship.
275
	*/
1244 chandransh 276
	list<Order> markOrdersAsPickedUp(1:i64 providerId, 2:map<string, string> pickupDetails) throws (1:TransactionServiceException ex),
1134 chandransh 277
 
278
	/**
279
	Marks all orders with AWBs in the given map as delivered. Also sets the delivery timestamp and
280
	the name of the receiver.
281
	Raises an exception if we encounter report for an AWB number that we did not ship.
282
	*/
283
	void markOrdersAsDelivered(1:i64 providerId, 2:map<string, string> deliveredOrders) throws (1:TransactionServiceException ex),
284
 
285
	/**
286
	Mark all orders with AWBs in the given map as failed. Also sets the delivery timestamp.
287
	Raises an exception if we encounter report for an AWB number that we did not ship.
288
	*/
289
	void markOrdersAsFailed(1:i64 providerId, 2:map<string, string> returnedOrders) throws (1:TransactionServiceException ex),
290
 
1244 chandransh 291
	/**
292
	Update the status description of orders whose AWB numbers are keys of the Map.
293
	*/
294
	void updateNonDeliveryReason(1:i64 providerId, 2:map<string, string> undeliveredOrders) throws (1:TransactionServiceException ex),
295
 
1407 ankur.sing 296
	/**
297
	Returns the list of orders whose delivery time has passed but have not been
298
	delivered yet for the given provider and warehouse. To get a complete list of
299
	undelivered orders, pass them as -1. 
300
	Returns an empty list if no such orders exist.
301
	*/
302
	list<Order> getUndeliveredOrders(1:i64 providerId, 2:i64 warehouseId),
303
 
483 rajveer 304
	//Alerts apis 
305
	list<Alert> getAlerts(1:i64 orderId, 2:bool valid),
306
	void setAlert(1:i64 orderId, 2:bool unset, 3:i64 type, 4: string comment),
1599 ankur.sing 307
 
308
	/**
309
	Return the number of valid orders. (OrderStatus >= OrderStatus.SUBMITTED_FOR_PROCESSING)
310
	*/
1628 ankur.sing 311
	i64 getValidOrderCount(),
312
 
313
	/**
314
	Returns the number of distinct customers who have done successful transactions
315
	*/
316
	i64 getNoOfCustomersWithSuccessfulTransaction(),
317
 
318
	/**
1731 ankur.sing 319
	Returns the minimum and maximum amounts of a valid order. (OrderStatus >= OrderStatus.SUBMITTED_FOR_PROCESSING)
320
	List contains two values, first minimum amount and second maximum amount.	
1628 ankur.sing 321
	*/
1886 ankur.sing 322
	list<double> getValidOrdersAmountRange(),
1628 ankur.sing 323
 
1886 ankur.sing 324
	/**
325
	Returns list of Orders in descending order by Order creation date. List is restricted to limit Orders.
326
	If limit is passed as 0, then all valid Orders are returned. 
327
	*/
2537 chandransh 328
	list<Order> getValidOrders(1:i64 limit),
1628 ankur.sing 329
 
2537 chandransh 330
	/**
331
	Toggle the DOA flag of an order. This should be used to flag an order for follow-up and unflag it when the follow-up is complete.
332
	Returns the final flag status.
333
	Throws an exception if the order with the given id couldn't be found or if the order status is not DELVIERY_SUCCESS. 
334
	*/
335
	bool toggleDOAFlag(1:i64 orderId) throws (1:TransactionServiceException ex),
336
 
337
	/**
338
	Sends out an email to the account manager of the original courier provider used to ship the order.
339
	If the order status was DELIVERY_SUCCESS, it is changed to be DOA_PICKUP_REQUESTED.
340
	If the order status was DOA_PICKUP_REQUESTED, it is left unchanged.
341
	For any other status, it returns false.
342
	Throws an exception if the order with the given id couldn't be found.
343
	*/
344
	bool requestPickupNumber(1:i64 orderId) throws (1:TransactionServiceException ex),
345
 
346
	/**
347
	If the order status is DOA_PICKUP_REQUESTED, it does the following
348
		1. Sends out an email to the customer with the dispatch advice that he has to print as an attachment.
349
		2. Changes order status to be DOA_PICKUP_AUTHORIZED.
350
		3. Returns true
2589 chandransh 351
	If the order is in any other status, it returns false.
2537 chandransh 352
	Throws an exception if the order with the given id couldn't be found.
353
	*/
354
	bool authorizePickup(1:i64 orderId, 2:string pickupNumber) throws (1:TransactionServiceException ex),
2589 chandransh 355
 
356
	/**
2765 chandransh 357
	Marks all DOA_PICKUP_AUTHORIZED orders of the previous day for a provider as DOA_RETURN_IN_TRANSIT.
358
	Returns a list of orders that were authorized for pickup but did not appear in the pick-up report.
359
	*/
360
	list<Order> markDoasAsPickedUp(1:i64 providerId, 2:map<string, string> pickupDetails),
361
 
362
	/**
2600 chandransh 363
	If the order status is DOA_RETURN_AUTHORIZED or DOA_RETURN_IN_TRANSIT, marks the order status as DOA_RECEIVED and returns true.
2614 chandransh 364
	If the order status is SALES_RETURN_IN_TRANSIT, marks the order status as SALES_RET_RECEIVED and returns true.
2589 chandransh 365
	If the order is in any other state, it returns false.
366
	Throws an exception if the order with the given id couldn't be found.
367
	*/
2614 chandransh 368
	bool receiveReturn(1:i64 orderId) throws (1:TransactionServiceException ex),
2589 chandransh 369
 
370
	/**
2600 chandransh 371
	Used to validate the DOA certificate for an order in the DOA_RECEIVED state. If the certificate is valid,
2614 chandransh 372
	the order state is changed to DOA_CERT_VALID. If the certificate is invalid, the order state is changed to DOA_CERT_INVALID.
2589 chandransh 373
	If the order is in any other state, it returns false.
374
	Throws an exception if the order with the given id couldn't be found.
375
	*/
376
	bool validateDoa(1:i64 orderId, 2:bool isValid) throws (1:TransactionServiceException ex),
2614 chandransh 377
 
378
	/**
379
	If the order is in SALES_RET_RECEIVED or DOA_CERT_INVALID state, it does the following:
380
		1. Creates a new order for processing in the BILLED state. All billing information is saved.
381
		2. Marks the current order as one of the final states SALES_RET_RESHIPPED and DOA_INVALID_RESHIPPED depending on what state the order started in.
382
 
383
	If the order is in DOA_CERT_VALID state, it does the following:
384
		1. Creates a new order for processing in the SUBMITTED_FOR_PROCESSING state.
385
		2. Creates a return order for the warehouse executive to return the DOA material.
386
		3. Marks the current order as the final DOA_RESHIPPED state.
387
 
388
	Returns the id of the newly created order.
389
 
390
	Throws an exception if the order with the given id couldn't be found.
391
	*/
392
	i64 reshipOrder(1:i64 orderId) throws (1:TransactionServiceException ex),
393
 
394
	/**
395
	If the order is in SALES_RET_RECEIVED, DOA_CERT_VALID or DOA_CERT_INVALID state, it does the following:
396
		1. Creates a refund request for batch processing.
397
		2. Creates a return order for the warehouse executive to return the shipped material.
398
		3. Marks the current order as SALES_RET_REFUNDED, DOA_VALID_REFUNDED or DOA_INVALID_REFUNDED final states.
399
 
400
	If the order is in SUBMITTED_FOR_PROCESSING or INVENTORY_LOW state, it does the following:
401
		1. Creates a refund request for batch processing.
402
		2. Marks the current order as the REFUNDED final state.
403
 
404
	Returns True if it is successful, False otherwise.
405
 
406
	Throws an exception if the order with the given id couldn't be found.
407
	*/
2688 chandransh 408
	bool refundOrder(1:i64 orderId) throws (1:TransactionServiceException ex),
409
 
410
	/**
411
	Get all return orders created between the from and to dates for the given warehouse.
412
	Ignores the warehouse if it is passed as -1.
413
	*/
414
	list<ReturnOrder> getReturnOrders(1:i64 warehouseId, 2:i64 fromDate, 3:i64 toDate),
415
 
416
	/**
2700 chandransh 417
	Returns the ReturnOrder corresponding to the given id.
418
	Throws an exception if the return order with the given id couldn't be found.
419
	*/
420
	ReturnOrder getReturnOrder(1:i64 id) throws (1:TransactionServiceException ex),
421
 
422
	/**
2688 chandransh 423
	Marks the return order with the given id as processed. Raises an exception if no such return order exists. 
424
	*/
425
	void processReturn(1:i64 returnOrderId) throws (1:TransactionServiceException ex)
1115 chandransh 426
}