Subversion Repositories SmartDukaan

Rev

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