Subversion Repositories SmartDukaan

Rev

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