Subversion Repositories SmartDukaan

Rev

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