Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
22653 ashik.ali 1
package com.spice.profitmandi.service.scheme;
2
 
22859 ashik.ali 3
import java.time.LocalDateTime;
23019 ashik.ali 4
import java.util.ArrayList;
22653 ashik.ali 5
import java.util.HashMap;
22859 ashik.ali 6
import java.util.HashSet;
22653 ashik.ali 7
import java.util.List;
8
import java.util.Map;
9
import java.util.Set;
10
 
22859 ashik.ali 11
import org.slf4j.Logger;
12
import org.slf4j.LoggerFactory;
22653 ashik.ali 13
import org.springframework.beans.factory.annotation.Autowired;
14
import org.springframework.stereotype.Component;
15
 
22859 ashik.ali 16
import com.spice.profitmandi.common.enumuration.DateTimePattern;
22653 ashik.ali 17
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
22859 ashik.ali 18
import com.spice.profitmandi.common.model.CreateSchemeRequest;
22653 ashik.ali 19
import com.spice.profitmandi.common.model.ProfitMandiConstants;
23019 ashik.ali 20
import com.spice.profitmandi.common.model.SchemeModel;
22859 ashik.ali 21
import com.spice.profitmandi.common.util.StringUtils;
23339 ashik.ali 22
import com.spice.profitmandi.dao.entity.catalog.Item;
22653 ashik.ali 23
import com.spice.profitmandi.dao.entity.catalog.RetailerScheme;
24
import com.spice.profitmandi.dao.entity.catalog.Scheme;
25
import com.spice.profitmandi.dao.entity.fofo.FofoLineItem;
23365 ashik.ali 26
import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
22859 ashik.ali 27
import com.spice.profitmandi.dao.entity.fofo.FofoOrderItem;
22653 ashik.ali 28
import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
23339 ashik.ali 29
import com.spice.profitmandi.dao.entity.fofo.Purchase;
22859 ashik.ali 30
import com.spice.profitmandi.dao.entity.fofo.SchemeInOut;
31
import com.spice.profitmandi.dao.entity.fofo.SchemeItem;
23344 ashik.ali 32
import com.spice.profitmandi.dao.entity.transaction.Order;
22653 ashik.ali 33
import com.spice.profitmandi.dao.enumuration.catalog.SchemeAmountType;
34
import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;
22859 ashik.ali 35
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
22653 ashik.ali 36
import com.spice.profitmandi.dao.repository.catalog.RetailerSchemeRepository;
37
import com.spice.profitmandi.dao.repository.catalog.SchemeRepository;
22859 ashik.ali 38
import com.spice.profitmandi.dao.repository.dtr.RetailerRepository;
23019 ashik.ali 39
import com.spice.profitmandi.dao.repository.fofo.FofoLineItemRepository;
40
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
23365 ashik.ali 41
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
22653 ashik.ali 42
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
23339 ashik.ali 43
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
22859 ashik.ali 44
import com.spice.profitmandi.dao.repository.fofo.SchemeInOutRepository;
45
import com.spice.profitmandi.dao.repository.fofo.SchemeItemRepository;
23344 ashik.ali 46
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
23365 ashik.ali 47
import com.spice.profitmandi.service.order.OrderService;
22859 ashik.ali 48
import com.spice.profitmandi.service.wallet.WalletService;
22653 ashik.ali 49
 
22859 ashik.ali 50
import in.shop2020.model.v1.catalog.ItemType;
51
import in.shop2020.model.v1.order.WalletReferenceType;
52
 
22653 ashik.ali 53
@Component
54
public class SchemeServiceImpl implements SchemeService {
55
 
22859 ashik.ali 56
	private static final Logger LOGGER = LoggerFactory.getLogger(SchemeServiceImpl.class);
57
 
22653 ashik.ali 58
	@Autowired
59
	private InventoryItemRepository inventoryItemRepository;
60
 
61
	@Autowired
22925 ashik.ali 62
	private OrderService orderService;
22653 ashik.ali 63
 
64
	@Autowired
65
	private SchemeRepository schemeRepository;
66
 
67
	@Autowired
22859 ashik.ali 68
	private RetailerRepository retailerRepository;
69
 
70
	@Autowired
22653 ashik.ali 71
	private RetailerSchemeRepository retailerSchemeRepository;
72
 
73
	@Autowired
22859 ashik.ali 74
	private SchemeInOutRepository schemeInOutRepository;
22653 ashik.ali 75
 
76
	@Autowired
22859 ashik.ali 77
	private ItemRepository itemRepository;
22653 ashik.ali 78
 
22859 ashik.ali 79
	@Autowired
80
	private SchemeItemRepository schemeItemRepository;
81
 
82
	@Autowired
83
	private WalletService walletService;
84
 
23019 ashik.ali 85
	@Autowired
86
	private FofoOrderItemRepository fofoOrderItemRepository;
87
 
88
	@Autowired
89
	private FofoLineItemRepository fofoLineItemRepository;
90
 
23339 ashik.ali 91
	@Autowired
92
	private PurchaseRepository purchaseRepository;
93
 
23344 ashik.ali 94
	@Autowired
95
	private OrderRepository orderRepository;
96
 
23365 ashik.ali 97
	@Autowired
98
	private FofoOrderRepository fofoOrderRepository;
99
 
22653 ashik.ali 100
	@Override
22859 ashik.ali 101
	public void saveScheme(int creatorId, CreateSchemeRequest createSchemeRequest) throws ProfitMandiBusinessException {
102
 
23019 ashik.ali 103
		this.validateCreateSchemeRequest(createSchemeRequest);
22653 ashik.ali 104
 
22859 ashik.ali 105
		Scheme scheme = this.toScheme(creatorId, createSchemeRequest);
106
 
23019 ashik.ali 107
		if(scheme.getStartDateTime().isAfter(scheme.getEndDateTime())){
108
			throw new ProfitMandiBusinessException(ProfitMandiConstants.START_DATE + ", " + ProfitMandiConstants.END_DATE, scheme.getStartDateTime() + ", " + scheme.getEndDateTime(), "SCHM_VE_1005");
22653 ashik.ali 109
		}
110
 
22859 ashik.ali 111
		this.validateItemIds(createSchemeRequest);
112
		schemeRepository.persist(scheme);
113
		if(!createSchemeRequest.isRetailerAll()){
114
			this.validateRetailerIds(createSchemeRequest);
115
			for(int retailerId : createSchemeRequest.getRetailerIds()){
116
				RetailerScheme retailerScheme = new RetailerScheme();
117
				retailerScheme.setRetailerId(retailerId);
118
				retailerScheme.setSchemeId(scheme.getId());
119
				retailerSchemeRepository.persist(retailerScheme);
120
			}
22653 ashik.ali 121
		}
22859 ashik.ali 122
		for(int itemId : createSchemeRequest.getItemIds()){
123
			SchemeItem schemeItem = new SchemeItem();
124
			schemeItem.setSchemeId(scheme.getId());
125
			schemeItem.setItemId(itemId);
126
			schemeItemRepository.persist(schemeItem);
127
		}
128
 
22653 ashik.ali 129
	}
22859 ashik.ali 130
 
23019 ashik.ali 131
	private void validateCreateSchemeRequest(CreateSchemeRequest createSchemeRequest) throws ProfitMandiBusinessException{
132
		if(createSchemeRequest.getName() == null || createSchemeRequest.getName().isEmpty()){
133
			throw new ProfitMandiBusinessException(ProfitMandiConstants.NAME, createSchemeRequest.getName(), "SCHM_VE_1000");
134
		}
135
		if(createSchemeRequest.getAmount() <= 0){
136
			throw new ProfitMandiBusinessException(ProfitMandiConstants.AMOUNT, createSchemeRequest.getAmount(), "SCHM_VE_1001");
137
		}
138
 
139
		if(SchemeAmountType.valueOf(createSchemeRequest.getAmountType()) == SchemeAmountType.PERCENTAGE && createSchemeRequest.getAmount() > 100){
140
			throw new ProfitMandiBusinessException(ProfitMandiConstants.AMOUNT, createSchemeRequest.getAmount(), "SCHM_VE_1002");
141
		}
142
 
143
		if(createSchemeRequest.getStartDateTimeString() == null || createSchemeRequest.getStartDateTimeString().isEmpty()){
144
			throw new ProfitMandiBusinessException(ProfitMandiConstants.START_DATE, createSchemeRequest.getStartDateTimeString(), "SCHM_VE_1003");
145
		}
146
 
147
		if(createSchemeRequest.getEndDateTimeString() == null || createSchemeRequest.getStartDateTimeString().isEmpty()){
148
			throw new ProfitMandiBusinessException(ProfitMandiConstants.END_DATE, createSchemeRequest.getEndDateTimeString(), "SCHM_VE_1004");
149
		}
150
	}
151
 
22859 ashik.ali 152
	private Scheme toScheme(int creatorId, CreateSchemeRequest createSchemeRequest){
153
		Scheme scheme = new Scheme();
154
		scheme.setName(createSchemeRequest.getName());
155
		scheme.setDescription(createSchemeRequest.getDescription());
156
		scheme.setType(SchemeType.valueOf(createSchemeRequest.getType()));
157
		scheme.setAmountType(SchemeAmountType.valueOf(createSchemeRequest.getAmountType()));
158
		scheme.setAmount(createSchemeRequest.getAmount());
23019 ashik.ali 159
		scheme.setStartDateTime(StringUtils.toDateTime(createSchemeRequest.getStartDateTimeString(), DateTimePattern.DD_MM_YYYY_T_HH_MM_SS));
160
		scheme.setEndDateTime(StringUtils.toDateTime(createSchemeRequest.getEndDateTimeString(), DateTimePattern.DD_MM_YYYY_T_HH_MM_SS));
22859 ashik.ali 161
		scheme.setCreatedBy(creatorId);
162
		scheme.setRetailerAll(createSchemeRequest.isRetailerAll());
163
		return scheme;
164
	}
165
 
166
	private void validateRetailerIds(CreateSchemeRequest createSchemeRequest) throws ProfitMandiBusinessException{
22925 ashik.ali 167
		if(createSchemeRequest.getRetailerIds() == null || createSchemeRequest.getRetailerIds().isEmpty()){
168
			throw new ProfitMandiBusinessException(ProfitMandiConstants.RETAILER_ID, createSchemeRequest.getRetailerIds(), "SCHM_1001");
22859 ashik.ali 169
		}
22870 ashik.ali 170
		List<Integer> foundRetailerIds = retailerRepository.selectIdsByIds(createSchemeRequest.getRetailerIds());
22859 ashik.ali 171
		if(foundRetailerIds.size() != createSchemeRequest.getRetailerIds().size()){
172
			createSchemeRequest.getRetailerIds().removeAll(foundRetailerIds);
22925 ashik.ali 173
			throw new ProfitMandiBusinessException(ProfitMandiConstants.RETAILER_ID, createSchemeRequest.getRetailerIds(), "SCHM_1002");
22859 ashik.ali 174
		}
175
	}
176
 
177
	private void validateItemIds(CreateSchemeRequest createSchemeRequest) throws ProfitMandiBusinessException{
178
		if(createSchemeRequest.getItemIds() == null || createSchemeRequest.getItemIds().isEmpty()){
22925 ashik.ali 179
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ITEM_ID, createSchemeRequest.getItemIds(), "SCHM_1003");
22859 ashik.ali 180
		}
181
		List<Integer> foundItemIds = itemRepository.selectIdsByIdsAndType(createSchemeRequest.getItemIds(), ItemType.SERIALIZED);
182
		if(foundItemIds.size() != createSchemeRequest.getItemIds().size()){
183
			createSchemeRequest.getItemIds().removeAll(foundItemIds);
22925 ashik.ali 184
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ITEM_ID, createSchemeRequest.getItemIds(), "SCHM_1004");
22859 ashik.ali 185
		}
186
	}
187
 
188
	@Override
189
	public Scheme getSchemeById(int schemeId) throws ProfitMandiBusinessException {
190
		Scheme scheme = schemeRepository.selectById(schemeId);
191
		if(!scheme.isRetailerAll()){
23019 ashik.ali 192
			List<Integer> retailerIds = retailerSchemeRepository.selectRetailerIdsBySchemeId(scheme.getId());
193
			scheme.getRetailerIds().addAll(retailerIds);
22859 ashik.ali 194
		}
195
		List<Integer> itemIds = schemeItemRepository.selectItemIdsBySchemeId(scheme.getId());
23339 ashik.ali 196
		List<Item> items = itemRepository.selectByIds(new HashSet<>(itemIds));
197
		scheme.setItemStringMap(this.toItemStringMap(items));
22859 ashik.ali 198
		return scheme;
199
	}
23019 ashik.ali 200
 
23339 ashik.ali 201
	public Map<Integer, String> toItemStringMap(List<Item> items){
202
		Map<Integer, String> itemMap = new HashMap<>();
203
		for(Item item : items){
204
			itemMap.put(item.getId(), this.getItemString(item));
205
		}
206
		return itemMap;
207
	}
208
 
209
	public String getItemString(Item item){
210
		StringBuilder itemString = new StringBuilder();
211
		if(item.getBrand() != null && !item.getBrand().isEmpty()){
212
			itemString.append(item.getBrand().trim());
213
		}
214
		itemString.append(" ");
215
		if(item.getModelName() != null && !item.getModelName().isEmpty()){
216
			itemString.append(item.getModelName().trim());
217
		}
218
		itemString.append(" ");
219
		if(item.getModelNumber() != null && !item.getModelNumber().isEmpty()){
220
			itemString.append(item.getModelNumber().trim());
221
		}
222
		itemString.append(" ");
223
		if(item.getColor() != null && !item.getColor().isEmpty()){
224
			itemString.append(item.getColor().trim());
225
		}
226
		return itemString.toString();
227
	}
228
 
229
	private Set<Integer> schemeItemsToItemIds(List<SchemeItem> schemeItems){
230
		Set<Integer> itemIds = new HashSet<>();
231
		for(SchemeItem schemeItem : schemeItems){
232
			itemIds.add(schemeItem.getItemId());
233
		}
234
		return itemIds;
235
	}
236
 
23019 ashik.ali 237
	@Override
238
	public List<SchemeModel> getAllSchemeModels(LocalDateTime startDateTime, LocalDateTime endDateTime) {
239
		List<Scheme> schemes = schemeRepository.selectAllBetweenCreateTimestamp(startDateTime, endDateTime);
240
		Map<Integer, Scheme> schemeIdSchemeMap = this.toSchemeIdSchemeMap(schemes);
241
		List<SchemeItem> schemeItems = schemeItemRepository.selectBySchemeIds(schemeIdSchemeMap.keySet());
23339 ashik.ali 242
		Set<Integer> itemIds = this.schemeItemsToItemIds(schemeItems);
243
		List<Item> items = itemRepository.selectByIds(itemIds);
244
		Map<Integer, String> itemStringMap = this.toItemStringMap(items);
245
		this.addItemIdsToSchemes(schemeItems, schemeIdSchemeMap, itemStringMap);
23019 ashik.ali 246
		List<RetailerScheme> retailerSchemes = retailerSchemeRepository.selectBySchemeIds(schemeIdSchemeMap.keySet());
247
		this.addRetailerIdsToSchemes(retailerSchemes, schemeIdSchemeMap);
248
		return this.toSchemeModels(schemeIdSchemeMap);
249
	}
250
 
23339 ashik.ali 251
	private void addItemIdsToSchemes(List<SchemeItem> schemeItems, Map<Integer, Scheme> schemeIdSchemeMap, Map<Integer, String> itemStringMap){
23019 ashik.ali 252
		for(SchemeItem schemeItem : schemeItems){
253
			schemeIdSchemeMap.get(schemeItem.getSchemeId())
23339 ashik.ali 254
			.getItemStringMap()
255
			.put(schemeItem.getItemId(), itemStringMap.get(schemeItem.getItemId()));
23019 ashik.ali 256
		}
257
	}
258
 
259
	private void addRetailerIdsToSchemes(List<RetailerScheme> retailerSchemes, Map<Integer, Scheme> schemeIdSchemeMap){
260
		for(RetailerScheme retailerScheme : retailerSchemes){
261
			schemeIdSchemeMap.get(retailerScheme.getSchemeId())
262
			.getRetailerIds()
263
			.add(retailerScheme.getRetailerId());
264
		}
265
	}
266
 
267
	private List<SchemeModel> toSchemeModels(Map<Integer, Scheme> schemeIdSchemeMap){
268
		List<SchemeModel> schemeModels = new ArrayList<>();
269
		for(Map.Entry<Integer, Scheme> schemeIdSchemeEntry : schemeIdSchemeMap.entrySet()){
270
			schemeModels.add(this.toSchemeModel(schemeIdSchemeEntry.getValue()));
271
		}
272
		return schemeModels;
273
	}
274
 
275
	private SchemeModel toSchemeModel(Scheme scheme){
276
		SchemeModel schemeModel = new SchemeModel();
277
		schemeModel.setSchemeId(scheme.getId());
278
		schemeModel.setName(scheme.getName());
279
		schemeModel.setDescription(scheme.getDescription());
280
		schemeModel.setSchemeType(scheme.getType().toString());
281
		schemeModel.setAmountType(scheme.getAmountType().toString());
282
		schemeModel.setAmount(scheme.getAmount());
283
		schemeModel.setStartDateTime(StringUtils.toString(scheme.getStartDateTime()));
284
		schemeModel.setEndDateTime(StringUtils.toString(scheme.getEndDateTime()));
285
		schemeModel.setCreateTimestamp(StringUtils.toString(scheme.getCreateTimestamp()));
286
		schemeModel.setActiveTimestamp(StringUtils.toString(scheme.getActiveTimestamp()));
287
		schemeModel.setExpireTimestamp(StringUtils.toString(scheme.getExpireTimestamp()));
288
		schemeModel.setCreatedBy(scheme.getCreatedBy());
23339 ashik.ali 289
		schemeModel.setItemStringMap(scheme.getItemStringMap());
23019 ashik.ali 290
		schemeModel.setRetailerIds(scheme.getRetailerIds());
291
		return schemeModel;
292
	}
22653 ashik.ali 293
 
294
	@Override
295
	public void activeSchemeById(int schemeId) throws ProfitMandiBusinessException {
296
		Scheme scheme = schemeRepository.selectById(schemeId);
297
		if(scheme.getActiveTimestamp() != null){
22925 ashik.ali 298
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ACTIVE_TIMESTAMP, scheme.getActiveTimestamp(), "SCHM_1005");
22653 ashik.ali 299
		}
300
		if(scheme.getExpireTimestamp() != null){
22925 ashik.ali 301
			throw new ProfitMandiBusinessException(ProfitMandiConstants.EXPIRE_TIMESTAMP, scheme.getExpireTimestamp(), "SCHM_1006");
22653 ashik.ali 302
		}
22859 ashik.ali 303
		scheme.setActiveTimestamp(LocalDateTime.now());
304
		schemeRepository.persist(scheme);
23019 ashik.ali 305
		if(scheme.getType() == SchemeType.IN){
306
			this.processPreviousPurchases(scheme);
307
		}else if(scheme.getType() == SchemeType.OUT){
308
			this.processPreviousSales(scheme);
309
		}
22653 ashik.ali 310
	}
23019 ashik.ali 311
 
312
	private void processPreviousPurchases(Scheme scheme) throws ProfitMandiBusinessException{
313
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectBetweenDates(scheme.getStartDateTime(), LocalDateTime.now());
314
		List<Integer> itemIds = schemeItemRepository.selectItemIdsBySchemeId(scheme.getId());
23339 ashik.ali 315
		List<Item> items = itemRepository.selectByIds(new HashSet<>(itemIds));
316
		Map<Integer, String> itemStringMap = this.toItemStringMap(items);
23019 ashik.ali 317
		List<InventoryItem> completedInventoryItems = this.toFilteredPurchaseCompletedInventoryItems(inventoryItems, itemIds, true);
318
 
319
		if(scheme.isRetailerAll()){
320
			for(InventoryItem inventoryItem : completedInventoryItems){
321
				float cashback = this.createSchemeInOut(scheme, inventoryItem);
23339 ashik.ali 322
				walletService.addAmountToWallet(inventoryItem.getFofoId(), inventoryItem.getPurchaseId(), WalletReferenceType.SCHEME_IN, "Added SCHEME_IN for item "+itemStringMap.get(inventoryItem.getItemId())+" against invoiceNumber ["+inventoryItem.getPurchase().getPurchaseReference() +"]", cashback);
23019 ashik.ali 323
			}
324
		}else{
325
			List<Integer> retailerIds = retailerSchemeRepository.selectRetailerIdsBySchemeId(scheme.getId());
326
			for(InventoryItem inventoryItem : completedInventoryItems){
327
				if(retailerIds.contains(inventoryItem.getFofoId())){
328
					float cashback = this.createSchemeInOut(scheme, inventoryItem);
23339 ashik.ali 329
					walletService.addAmountToWallet(inventoryItem.getFofoId(), inventoryItem.getPurchaseId(), WalletReferenceType.SCHEME_IN, "Added SCHEME_IN for item "+itemStringMap.get(inventoryItem.getItemId())+" against invoiceNumber ["+inventoryItem.getPurchase().getPurchaseReference() +"]", cashback);
23019 ashik.ali 330
				}
331
			}
332
		}
333
 
334
	}
335
 
336
 
337
 
23297 ashik.ali 338
	private Map<Integer, Integer> toInventoryItemIdFofoOrderIdMap(List<FofoLineItem> fofoLineItems, Map<Integer, FofoOrderItem> fofoOrderItemIdFofoOrderItemMap){
23019 ashik.ali 339
		Map<Integer, Integer> inventoryItemIdFofoOrderIdMap = new HashMap<>();
340
 
341
		for(FofoLineItem fofoLineItem : fofoLineItems){
342
			inventoryItemIdFofoOrderIdMap.put(
343
					fofoLineItem.getInventoryItemId(),
344
					fofoOrderItemIdFofoOrderItemMap.get(fofoLineItem.getFofoOrderItemId()).getOrderId());
345
		}
346
		return inventoryItemIdFofoOrderIdMap;
347
	}
348
 
349
	private void processPreviousSales(Scheme scheme) throws ProfitMandiBusinessException{
350
		List<FofoOrderItem> fofoOrderItems = fofoOrderItemRepository.selectBetweenDates(scheme.getStartDateTime(), LocalDateTime.now());
351
 
352
		Map<Integer, FofoOrderItem> fofoOrderItemIdFofoOrderItemMap = this.toFofoOrderItemIdFofoOrderItemMap(fofoOrderItems);
22653 ashik.ali 353
 
23019 ashik.ali 354
		List<FofoLineItem> fofoLineItems = fofoLineItemRepository.selectByFofoOrderItemIds(fofoOrderItemIdFofoOrderItemMap.keySet());
355
 
23297 ashik.ali 356
		Map<Integer, Integer> inventoryItemIdFofoOrderIdMap = this.toInventoryItemIdFofoOrderIdMap(fofoLineItems, fofoOrderItemIdFofoOrderItemMap);
23019 ashik.ali 357
 
358
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIdFofoOrderIdMap.keySet());
359
 
360
		List<Integer> itemIds = schemeItemRepository.selectItemIdsBySchemeId(scheme.getId());
361
 
362
		List<InventoryItem> completedInventoryItems = this.toFilteredPurchaseCompletedInventoryItems(inventoryItems, itemIds, false);
363
 
364
 
365
		if(scheme.isRetailerAll()){
366
			for(InventoryItem inventoryItem : completedInventoryItems){
367
				float cashback = this.createSchemeInOut(scheme, inventoryItem);
23297 ashik.ali 368
				walletService.addAmountToWallet(inventoryItem.getFofoId(), inventoryItem.getPurchaseId(), WalletReferenceType.SCHEME_OUT, "Added for SCHEME_OUT", cashback);
23019 ashik.ali 369
			}
370
		}else{
371
			List<Integer> retailerIds = retailerSchemeRepository.selectRetailerIdsBySchemeId(scheme.getId());
372
			for(InventoryItem inventoryItem : completedInventoryItems){
373
				if(retailerIds.contains(inventoryItem.getFofoId())){
374
					float cashback = this.createSchemeInOut(scheme, inventoryItem);
23297 ashik.ali 375
					walletService.addAmountToWallet(inventoryItem.getFofoId(), inventoryItemIdFofoOrderIdMap.get(inventoryItem.getId()), WalletReferenceType.SCHEME_OUT, "Added for SCHEME_OUT", cashback);
23019 ashik.ali 376
				}
377
			}
378
		}
379
	}
380
 
381
	private Map<Integer, FofoOrderItem> toFofoOrderItemIdFofoOrderItemMap(List<FofoOrderItem> fofoOrderItems){
382
		Map<Integer, FofoOrderItem> fofoOrderItemIdFofoOrderItemMap = new HashMap<>();
383
		for(FofoOrderItem fofoOrderItem : fofoOrderItems){
384
			fofoOrderItemIdFofoOrderItemMap.put(fofoOrderItem.getId(), fofoOrderItem);
385
		}
386
		return fofoOrderItemIdFofoOrderItemMap;
387
	}
388
 
389
	private List<InventoryItem> toFilteredPurchaseCompletedInventoryItems(List<InventoryItem> inventoryItems, List<Integer> itemIds, boolean purchase){
390
		List<InventoryItem> completedInventoryItems = new ArrayList<>();
391
		for(InventoryItem inventoryItem : inventoryItems){
392
			if(purchase && inventoryItem.getPurchase().getCompleteTimestamp() != null && itemIds.contains(inventoryItem.getItemId())){
393
				completedInventoryItems.add(inventoryItem);
23297 ashik.ali 394
			}else if(!purchase && itemIds.contains(inventoryItem.getItemId())){
395
				completedInventoryItems.add(inventoryItem);
23019 ashik.ali 396
			}
397
		}
398
		return completedInventoryItems;
399
	}
400
 
22653 ashik.ali 401
	@Override
402
	public void expireSchemeById(int schemeId) throws ProfitMandiBusinessException {
403
		Scheme scheme = schemeRepository.selectById(schemeId);
404
		if(scheme.getActiveTimestamp() == null){
22925 ashik.ali 405
			throw new ProfitMandiBusinessException(ProfitMandiConstants.ACTIVE_TIMESTAMP, scheme.getActiveTimestamp(), "SCHM_1007");
22653 ashik.ali 406
		}
407
		if(scheme.getExpireTimestamp() != null){
22925 ashik.ali 408
			throw new ProfitMandiBusinessException(ProfitMandiConstants.EXPIRE_TIMESTAMP, scheme.getExpireTimestamp(), "SCHM_1008");
22653 ashik.ali 409
		}
22859 ashik.ali 410
		scheme.setExpireTimestamp(LocalDateTime.now());
411
		schemeRepository.persist(scheme);
22653 ashik.ali 412
	}
22859 ashik.ali 413
 
23019 ashik.ali 414
	private Map<Integer, Scheme> toSchemeIdSchemeMap(List<Scheme> schemes){
415
		Map<Integer, Scheme> schemeIdSchemeMap = new HashMap<>();
22859 ashik.ali 416
		for(Scheme scheme : schemes){
23019 ashik.ali 417
			schemeIdSchemeMap.put(scheme.getId(), scheme);
22859 ashik.ali 418
		}
23019 ashik.ali 419
		return schemeIdSchemeMap;
22859 ashik.ali 420
	}
421
 
422
	private Set<Integer> inventoryItemSchemesMapToSchemeIds(Map<InventoryItem, Set<Scheme>> inventoryItemSchemesMap){
423
		Set<Integer> schemeIds = new HashSet<>();
424
		for(Map.Entry<InventoryItem, Set<Scheme>> inventoryItemSchemesEntry : inventoryItemSchemesMap.entrySet()){
425
			for(Scheme scheme : inventoryItemSchemesEntry.getValue()){
426
				schemeIds.add(scheme.getId());
427
			}
428
		}
429
		return schemeIds;
430
	}
431
 
432
	private Set<Integer> fofoLineItemSchemesMapToSchemeIds(Map<FofoOrderItem, Set<Scheme>> fofoLineItemSchemesMap){
433
		Set<Integer> schemeIds = new HashSet<>();
434
		for(Map.Entry<FofoOrderItem, Set<Scheme>> inventoryItemSchemesEntry : fofoLineItemSchemesMap.entrySet()){
435
			for(Scheme scheme : inventoryItemSchemesEntry.getValue()){
436
				schemeIds.add(scheme.getId());
437
			}
438
		}
439
		return schemeIds;
440
	}
441
 
442
	private Set<Integer> inventoryItemsToItemIds(List<InventoryItem> inventoryItems){
443
		Set<Integer> itemIds = new HashSet<>();
444
		for(InventoryItem inventoryItem : inventoryItems){
445
			itemIds.add(inventoryItem.getItemId());
446
		}
447
		return itemIds;
448
	}
449
 
450
	private Set<Integer> fofoOrderItemsToItemIds(List<FofoOrderItem> fofoOrderItems){
451
		Set<Integer> itemIds = new HashSet<>();
452
		for(FofoOrderItem fofoOrderItem : fofoOrderItems){
453
			itemIds.add(fofoOrderItem.getItemId());
454
		}
455
		return itemIds;
456
	}
457
 
458
	private Map<Integer, Set<Scheme>> toItemIdSchemesMap(List<SchemeItem> schemeItems, List<Scheme> schemes){
23019 ashik.ali 459
		Map<Integer, Scheme> schemeIdSchemesMap = this.toSchemeIdSchemeMap(schemes);
22859 ashik.ali 460
		Map<Integer, Set<Scheme>> itemIdSchemesMap = new HashMap<>();
461
		for(SchemeItem schemeItem : schemeItems){
462
			if(!itemIdSchemesMap.containsKey(schemeItem.getItemId())){
463
				Set<Scheme> schemesSet = new HashSet<>();
464
				schemesSet.add(schemeIdSchemesMap.get(schemeItem.getSchemeId()));
465
				itemIdSchemesMap.put(schemeItem.getItemId(), schemesSet);
466
			}else{
467
				itemIdSchemesMap.get(schemeItem.getItemId()).add(schemeIdSchemesMap.get(schemeItem.getSchemeId()));
468
			}
469
		}
470
		return itemIdSchemesMap;
471
	}
22653 ashik.ali 472
 
22859 ashik.ali 473
	private Map<InventoryItem, Set<Scheme>> toInventoryItemSchemesMap(List<Scheme> schemes, List<InventoryItem> inventoryItems){
474
		Set<Integer> schemeIds = new HashSet<>();
475
		for(Scheme scheme : schemes){
476
			schemeIds.add(scheme.getId());
477
		}
478
		Set<Integer> itemIds = this.inventoryItemsToItemIds(inventoryItems);
479
		List<SchemeItem> schemeItems = schemeItemRepository.selectBySchemeIdsAndItemIds(schemeIds, itemIds);
22653 ashik.ali 480
 
22859 ashik.ali 481
		Map<Integer, Set<Scheme>> itemIdSchemesMap = this.toItemIdSchemesMap(schemeItems, schemes);
482
		Map<InventoryItem, Set<Scheme>> inventoryItemSchemsMap = new HashMap<>();
483
		for(InventoryItem inventoryItem : inventoryItems){
484
			if(itemIdSchemesMap.containsKey(inventoryItem.getItemId())){
485
				inventoryItemSchemsMap.put(inventoryItem, itemIdSchemesMap.get(inventoryItem.getItemId()));
486
			}
487
		}
488
		return inventoryItemSchemsMap;
489
	}
490
 
491
	private Map<FofoOrderItem, Set<Scheme>> toFofoOrderItemSchemesMap(List<Scheme> schemes, List<FofoOrderItem> fofoOrderItems){
492
		Set<Integer> schemeIds = new HashSet<>();
22653 ashik.ali 493
		for(Scheme scheme : schemes){
22859 ashik.ali 494
			schemeIds.add(scheme.getId());
495
		}
496
		Set<Integer> itemIds = this.fofoOrderItemsToItemIds(fofoOrderItems);
497
		List<SchemeItem> schemeItems = schemeItemRepository.selectBySchemeIdsAndItemIds(schemeIds, itemIds);
498
 
499
		Map<FofoOrderItem, Set<Scheme>> fofoOrderItemSchemsMap = new HashMap<>();
500
 
501
		if(!schemeItems.isEmpty()){
502
			Map<Integer, Set<Scheme>> itemIdSchemesMap = this.toItemIdSchemesMap(schemeItems, schemes);
503
			for(FofoOrderItem fofoOrderItem : fofoOrderItems){
504
				if(itemIdSchemesMap.containsKey(fofoOrderItem.getItemId())){
505
					fofoOrderItemSchemsMap.put(fofoOrderItem, itemIdSchemesMap.get(fofoOrderItem.getItemId()));
506
				}
22653 ashik.ali 507
			}
508
		}
22859 ashik.ali 509
		return fofoOrderItemSchemsMap;
510
	}
511
 
512
	@Override
23365 ashik.ali 513
	public void processSchemeIn(int purchaseId, int retailerId) throws ProfitMandiBusinessException {
23369 ashik.ali 514
		LOGGER.info("Trying to process SchemeIn with purchaseId [{}] and retailerId [{}]", purchaseId, retailerId);
23344 ashik.ali 515
		Purchase purchase = purchaseRepository.selectByIdAndFofoId(purchaseId, retailerId);
23369 ashik.ali 516
		LOGGER.info("purchase is completed = {}", (purchase.getCompleteTimestamp() != null));
23365 ashik.ali 517
		if(purchase.getCompleteTimestamp() != null) {
518
			List<Order> orders = orderRepository.selectByAirwayBillOrInvoiceNumber(purchase.getPurchaseReference(), retailerId);
519
			LocalDateTime billingTimestamp = LocalDateTime.now();
520
			if(!orders.isEmpty()){
521
				billingTimestamp = orders.get(0).getBillingTimestamp();
522
			}
523
			List<Scheme> schemes = schemeRepository.selectActiveAll(SchemeType.IN, billingTimestamp);
524
			float totalCashback = 0;
525
			if(schemes.isEmpty()){
526
				return;
527
			}
528
			List<InventoryItem> inventoryItems = inventoryItemRepository.selectByPurchaseId(purchaseId);
529
			LOGGER.info("SchemeIn filter inventoryItems {}", inventoryItems);
530
 
531
			Map<InventoryItem, Set<Scheme>> inventoryItemSchemesMap = this.toInventoryItemSchemesMap(schemes, inventoryItems);
532
 
533
			if(inventoryItemSchemesMap.isEmpty()){
534
				return;
535
			}
536
			Map<InventoryItem, Set<Scheme>> notAllInventoryItemSchemesMap = new HashMap<>();
537
			Map<InventoryItem, Set<Scheme>> allInventoryItemSchemesMap = new HashMap<>();
538
			Set<Integer> itemIds = new HashSet<>();
539
 
540
			for(Map.Entry<InventoryItem, Set<Scheme>> inventoryItemSchemesEntry : inventoryItemSchemesMap.entrySet()){
541
				Set<Scheme> notAllSchemes = new HashSet<>();
542
				Set<Scheme> allSchemes = new HashSet<>();
543
				for(Scheme scheme : inventoryItemSchemesEntry.getValue()){
544
					if(!scheme.isRetailerAll()){
545
						notAllSchemes.add(scheme);
546
					}else{
547
						allSchemes.add(scheme);
548
					}
22859 ashik.ali 549
				}
23365 ashik.ali 550
				notAllInventoryItemSchemesMap.put(inventoryItemSchemesEntry.getKey(), notAllSchemes);
551
				allInventoryItemSchemesMap.put(inventoryItemSchemesEntry.getKey(), allSchemes);
552
				itemIds.add(inventoryItemSchemesEntry.getKey().getItemId());
22859 ashik.ali 553
			}
23365 ashik.ali 554
 
555
			List<Item> items = itemRepository.selectByIds(itemIds);
556
			Map<Integer, String> itemStringMap = this.toItemStringMap(items);
557
 
558
			Map<Integer, Float> itemIdCashbackMap = new HashMap<>();
559
			Map<Integer, Integer> itemIdCashbackCountMap = new HashMap<>();
560
 
561
			for(Map.Entry<InventoryItem, Set<Scheme>> allInventoryItemSchemesEntry : allInventoryItemSchemesMap.entrySet()){
562
				for(Scheme scheme : allInventoryItemSchemesEntry.getValue()){
563
					InventoryItem inventoryItem = allInventoryItemSchemesEntry.getKey();
564
					float cashback = this.createSchemeInOut(scheme, inventoryItem);
565
					if(!itemIdCashbackMap.containsKey(inventoryItem.getItemId())){
566
						itemIdCashbackMap.put(inventoryItem.getItemId(), cashback);
567
						itemIdCashbackCountMap.put(inventoryItem.getItemId(), 1);
568
					}else{
569
						itemIdCashbackMap.put(inventoryItem.getItemId(), itemIdCashbackMap.get(inventoryItem.getItemId()) + cashback);
570
						itemIdCashbackCountMap.put(inventoryItem.getItemId(), itemIdCashbackCountMap.get(inventoryItem.getItemId()) + 1);
571
					}
572
					totalCashback = totalCashback + cashback;
23339 ashik.ali 573
				}
22859 ashik.ali 574
			}
575
 
23365 ashik.ali 576
			//Map<Integer, Float> itemIdCashbackMap = new HashMap<>();
577
 
578
 
579
			Set<Integer> schemeIds = this.inventoryItemSchemesMapToSchemeIds(notAllInventoryItemSchemesMap);
580
			if(!schemeIds.isEmpty()){
581
				List<Integer> foundSchemeIds = retailerSchemeRepository.selectSchemeIds(schemeIds, retailerId);
582
				for(Map.Entry<InventoryItem, Set<Scheme>> notAllInventoryItemSchemesEntry : notAllInventoryItemSchemesMap.entrySet()){
583
					for(Scheme scheme : notAllInventoryItemSchemesEntry.getValue()){
584
						if(foundSchemeIds.contains(scheme.getId())){
585
							InventoryItem inventoryItem = notAllInventoryItemSchemesEntry.getKey();
586
							float cashback = this.createSchemeInOut(scheme, inventoryItem);
587
							if(!itemIdCashbackMap.containsKey(inventoryItem.getItemId())){
588
								itemIdCashbackMap.put(inventoryItem.getItemId(), cashback);
589
								itemIdCashbackCountMap.put(inventoryItem.getItemId(), 1);
590
							}else{
591
								itemIdCashbackMap.put(inventoryItem.getItemId(), itemIdCashbackMap.get(inventoryItem.getItemId()) + cashback);
592
								itemIdCashbackCountMap.put(inventoryItem.getItemId(), itemIdCashbackCountMap.get(inventoryItem.getItemId()) + 1);
593
							}
594
							totalCashback = totalCashback + cashback;
23339 ashik.ali 595
						}
22653 ashik.ali 596
					}
597
				}
598
			}
23365 ashik.ali 599
			for(Map.Entry<Integer, Float> itemIdCashbackEntry : itemIdCashbackMap.entrySet()){
600
				walletService.addAmountToWallet(retailerId, purchaseId, WalletReferenceType.SCHEME_IN,
601
						itemIdCashbackCountMap.get(itemIdCashbackEntry.getKey())+"pcs of item "+
602
						itemStringMap.get(itemIdCashbackEntry.getKey()) +
23369 ashik.ali 603
				" Added for SCHEME_IN against invoiceNumber ["+purchase.getPurchaseReference()+"]", itemIdCashbackEntry.getValue());
23365 ashik.ali 604
			}
605
			purchase.setCashback(totalCashback);
606
			purchaseRepository.persist(purchase);
22653 ashik.ali 607
		}
608
	}
609
 
22859 ashik.ali 610
	private float createSchemeInOut(Scheme scheme, InventoryItem inventoryItem){
611
		float amount = this.getAmount(inventoryItem, scheme);
612
		SchemeInOut schemeInOut = new SchemeInOut();
613
		schemeInOut.setSchemeId(scheme.getId());
614
		schemeInOut.setInventoryItemId(inventoryItem.getId());
615
		schemeInOut.setAmount(amount);
616
		schemeInOutRepository.persist(schemeInOut);
617
		return amount;
618
	}
619
 
620
	private float getAmount(InventoryItem inventoryItem, Scheme scheme){
22653 ashik.ali 621
		float amount = 0;
22859 ashik.ali 622
		float totalTaxRate = inventoryItem.getIgstRate() + inventoryItem.getSgstRate() + inventoryItem.getCgstRate();
623
		float taxableSellingPrice = inventoryItem.getUnitPrice() / (1 + totalTaxRate / 100);
624
 
22653 ashik.ali 625
		if(scheme.getAmountType() == SchemeAmountType.PERCENTAGE){
22859 ashik.ali 626
			amount = taxableSellingPrice * scheme.getAmount() / 100;
22653 ashik.ali 627
		}else{
628
			amount = scheme.getAmount();
629
		}
22859 ashik.ali 630
		return amount;
22653 ashik.ali 631
	}
632
 
22859 ashik.ali 633
	private Map<Integer, InventoryItem> toInventoryItemIdInventoryItemMap(List<InventoryItem> inventoryItems){
634
		Map<Integer, InventoryItem> itemIdInventoryItemMap = new HashMap<>();
635
		for(InventoryItem inventoryItem : inventoryItems){
636
			itemIdInventoryItemMap.put(inventoryItem.getId(), inventoryItem);
22653 ashik.ali 637
		}
22859 ashik.ali 638
		return itemIdInventoryItemMap;
22653 ashik.ali 639
	}
22859 ashik.ali 640
 
641
 
642
	private Set<Integer> toInventoryItemIds(Set<FofoOrderItem> fofoOrderItems){
643
		Set<Integer> inventoryItemIds = new HashSet<>();
644
		//Map<Integer, Set<FofoLineItem>> fofoOrderItemIdFofoLineItemsMap = this.toFofoOrderItemIdFofoLineItems(fofoOrderItems);
645
		for(FofoOrderItem fofoOrderItem : fofoOrderItems){
646
			for(FofoLineItem fofoLineItem : fofoOrderItem.getFofoLineItems()){
647
				inventoryItemIds.add(fofoLineItem.getInventoryItemId());
648
			}
649
		}
650
		return inventoryItemIds;
651
	}
22653 ashik.ali 652
 
653
	@Override
23365 ashik.ali 654
	public void processSchemeOut(int fofoOrderId, int retailerId) throws ProfitMandiBusinessException {
655
		FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(retailerId, fofoOrderId);
22859 ashik.ali 656
		List<Scheme> schemes = schemeRepository.selectActiveAll(SchemeType.OUT, LocalDateTime.now());
657
		LOGGER.info("Active Schemes {}", schemes);
658
		float totalCashback = 0;
659
		if(schemes.isEmpty()){
23365 ashik.ali 660
			return;
22859 ashik.ali 661
		}
22653 ashik.ali 662
 
22925 ashik.ali 663
		List<FofoOrderItem> fofoOrderItems = orderService.getByOrderId(fofoOrderId);
22859 ashik.ali 664
		//LOGGER.info("fofoOrderItems {}", fofoOrderItems);
665
 
666
		Map<FofoOrderItem, Set<Scheme>> fofoOrderItemSchemesMap = this.toFofoOrderItemSchemesMap(schemes, fofoOrderItems);
667
 
668
		LOGGER.info("fofoOrderItemSchemesMap {}", fofoOrderItemSchemesMap);
669
 
670
		if(fofoOrderItemSchemesMap.isEmpty()){
23365 ashik.ali 671
			return;
22859 ashik.ali 672
		}
673
 
674
		Set<Integer> inventoryItemIds = this.toInventoryItemIds(fofoOrderItemSchemesMap.keySet());
675
 
676
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
677
 
678
		Map<Integer, InventoryItem> inventoryItemIdInventoryItemMap = this.toInventoryItemIdInventoryItemMap(inventoryItems);
679
 
680
		Map<FofoOrderItem, Set<Scheme>> notAllFofoOrderItemSchemesMap = new HashMap<>();
681
		Map<FofoOrderItem, Set<Scheme>> allFofoOrderItemSchemesMap = new HashMap<>();
682
 
683
		for(Map.Entry<FofoOrderItem, Set<Scheme>> fofoOrderItemSchemesEntry : fofoOrderItemSchemesMap.entrySet()){
684
			Set<Scheme> notAllSchemes = new HashSet<>();
685
			Set<Scheme> allSchemes = new HashSet<>();
686
			for(Scheme scheme : fofoOrderItemSchemesEntry.getValue()){
687
				if(!scheme.isRetailerAll()){
688
					notAllSchemes.add(scheme);
689
				}else{
690
					allSchemes.add(scheme);
691
				}
22653 ashik.ali 692
			}
22859 ashik.ali 693
			notAllFofoOrderItemSchemesMap.put(fofoOrderItemSchemesEntry.getKey(), notAllSchemes);
694
			allFofoOrderItemSchemesMap.put(fofoOrderItemSchemesEntry.getKey(), allSchemes);
22653 ashik.ali 695
		}
22859 ashik.ali 696
 
697
		for(Map.Entry<FofoOrderItem, Set<Scheme>> allFofoOrderItemSchemesEntry : allFofoOrderItemSchemesMap.entrySet()){
698
			for(FofoLineItem fofoLineItem : allFofoOrderItemSchemesEntry.getKey().getFofoLineItems()){
699
				for(Scheme scheme : allFofoOrderItemSchemesEntry.getValue()){
700
					float cashback = this.createSchemeInOut(scheme, inventoryItemIdInventoryItemMap.get(fofoLineItem.getInventoryItemId()));
701
					totalCashback = totalCashback + cashback;
702
				}
703
			}
22653 ashik.ali 704
		}
705
 
22859 ashik.ali 706
		Set<Integer> schemeIds = this.fofoLineItemSchemesMapToSchemeIds(notAllFofoOrderItemSchemesMap);
707
 
708
		if(!schemeIds.isEmpty()){
709
			List<Integer> foundSchemeIds = retailerSchemeRepository.selectSchemeIds(schemeIds, retailerId);
710
 
711
			for(Map.Entry<FofoOrderItem, Set<Scheme>> notAllFofoOrderItemSchemesEntry : notAllFofoOrderItemSchemesMap.entrySet()){
712
				for(FofoLineItem fofoLineItem : notAllFofoOrderItemSchemesEntry.getKey().getFofoLineItems()){
713
					for(Scheme scheme : notAllFofoOrderItemSchemesEntry.getValue()){
714
						if(foundSchemeIds.contains(scheme.getId())){
715
							float cashback = this.createSchemeInOut(scheme, inventoryItemIdInventoryItemMap.get(fofoLineItem.getInventoryItemId()));
716
							totalCashback = totalCashback + cashback;
22653 ashik.ali 717
						}
718
					}
719
				}
22859 ashik.ali 720
			}	
22653 ashik.ali 721
		}
22859 ashik.ali 722
		if(totalCashback > 0){
723
			walletService.addAmountToWallet(retailerId, fofoOrderId, WalletReferenceType.SCHEME_OUT, "Added for SCHEME_OUT", totalCashback);
23365 ashik.ali 724
			fofoOrder.setCashback(totalCashback);
725
			fofoOrderRepository.persist(fofoOrder);
22859 ashik.ali 726
		}
22653 ashik.ali 727
	}
23297 ashik.ali 728
 
22653 ashik.ali 729
}