Subversion Repositories SmartDukaan

Rev

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