Subversion Repositories SmartDukaan

Rev

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