Subversion Repositories SmartDukaan

Rev

Rev 23344 | Rev 23369 | 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 {
23344 ashik.ali 514
		Purchase purchase = purchaseRepository.selectByIdAndFofoId(purchaseId, retailerId);
23365 ashik.ali 515
		if(purchase.getCompleteTimestamp() != null) {
516
			List<Order> orders = orderRepository.selectByAirwayBillOrInvoiceNumber(purchase.getPurchaseReference(), retailerId);
517
			LocalDateTime billingTimestamp = LocalDateTime.now();
518
			if(!orders.isEmpty()){
519
				billingTimestamp = orders.get(0).getBillingTimestamp();
520
			}
521
			List<Scheme> schemes = schemeRepository.selectActiveAll(SchemeType.IN, billingTimestamp);
522
			float totalCashback = 0;
523
			if(schemes.isEmpty()){
524
				return;
525
			}
526
			List<InventoryItem> inventoryItems = inventoryItemRepository.selectByPurchaseId(purchaseId);
527
			LOGGER.info("SchemeIn filter inventoryItems {}", inventoryItems);
528
 
529
			Map<InventoryItem, Set<Scheme>> inventoryItemSchemesMap = this.toInventoryItemSchemesMap(schemes, inventoryItems);
530
 
531
			if(inventoryItemSchemesMap.isEmpty()){
532
				return;
533
			}
534
			Map<InventoryItem, Set<Scheme>> notAllInventoryItemSchemesMap = new HashMap<>();
535
			Map<InventoryItem, Set<Scheme>> allInventoryItemSchemesMap = new HashMap<>();
536
			Set<Integer> itemIds = new HashSet<>();
537
 
538
			for(Map.Entry<InventoryItem, Set<Scheme>> inventoryItemSchemesEntry : inventoryItemSchemesMap.entrySet()){
539
				Set<Scheme> notAllSchemes = new HashSet<>();
540
				Set<Scheme> allSchemes = new HashSet<>();
541
				for(Scheme scheme : inventoryItemSchemesEntry.getValue()){
542
					if(!scheme.isRetailerAll()){
543
						notAllSchemes.add(scheme);
544
					}else{
545
						allSchemes.add(scheme);
546
					}
22859 ashik.ali 547
				}
23365 ashik.ali 548
				notAllInventoryItemSchemesMap.put(inventoryItemSchemesEntry.getKey(), notAllSchemes);
549
				allInventoryItemSchemesMap.put(inventoryItemSchemesEntry.getKey(), allSchemes);
550
				itemIds.add(inventoryItemSchemesEntry.getKey().getItemId());
22859 ashik.ali 551
			}
23365 ashik.ali 552
 
553
			List<Item> items = itemRepository.selectByIds(itemIds);
554
			Map<Integer, String> itemStringMap = this.toItemStringMap(items);
555
 
556
			Map<Integer, Float> itemIdCashbackMap = new HashMap<>();
557
			Map<Integer, Integer> itemIdCashbackCountMap = new HashMap<>();
558
 
559
			for(Map.Entry<InventoryItem, Set<Scheme>> allInventoryItemSchemesEntry : allInventoryItemSchemesMap.entrySet()){
560
				for(Scheme scheme : allInventoryItemSchemesEntry.getValue()){
561
					InventoryItem inventoryItem = allInventoryItemSchemesEntry.getKey();
562
					float cashback = this.createSchemeInOut(scheme, inventoryItem);
563
					if(!itemIdCashbackMap.containsKey(inventoryItem.getItemId())){
564
						itemIdCashbackMap.put(inventoryItem.getItemId(), cashback);
565
						itemIdCashbackCountMap.put(inventoryItem.getItemId(), 1);
566
					}else{
567
						itemIdCashbackMap.put(inventoryItem.getItemId(), itemIdCashbackMap.get(inventoryItem.getItemId()) + cashback);
568
						itemIdCashbackCountMap.put(inventoryItem.getItemId(), itemIdCashbackCountMap.get(inventoryItem.getItemId()) + 1);
569
					}
570
					totalCashback = totalCashback + cashback;
23339 ashik.ali 571
				}
22859 ashik.ali 572
			}
573
 
23365 ashik.ali 574
			//Map<Integer, Float> itemIdCashbackMap = new HashMap<>();
575
 
576
 
577
			Set<Integer> schemeIds = this.inventoryItemSchemesMapToSchemeIds(notAllInventoryItemSchemesMap);
578
			if(!schemeIds.isEmpty()){
579
				List<Integer> foundSchemeIds = retailerSchemeRepository.selectSchemeIds(schemeIds, retailerId);
580
				for(Map.Entry<InventoryItem, Set<Scheme>> notAllInventoryItemSchemesEntry : notAllInventoryItemSchemesMap.entrySet()){
581
					for(Scheme scheme : notAllInventoryItemSchemesEntry.getValue()){
582
						if(foundSchemeIds.contains(scheme.getId())){
583
							InventoryItem inventoryItem = notAllInventoryItemSchemesEntry.getKey();
584
							float cashback = this.createSchemeInOut(scheme, inventoryItem);
585
							if(!itemIdCashbackMap.containsKey(inventoryItem.getItemId())){
586
								itemIdCashbackMap.put(inventoryItem.getItemId(), cashback);
587
								itemIdCashbackCountMap.put(inventoryItem.getItemId(), 1);
588
							}else{
589
								itemIdCashbackMap.put(inventoryItem.getItemId(), itemIdCashbackMap.get(inventoryItem.getItemId()) + cashback);
590
								itemIdCashbackCountMap.put(inventoryItem.getItemId(), itemIdCashbackCountMap.get(inventoryItem.getItemId()) + 1);
591
							}
592
							totalCashback = totalCashback + cashback;
23339 ashik.ali 593
						}
22653 ashik.ali 594
					}
595
				}
596
			}
23365 ashik.ali 597
			for(Map.Entry<Integer, Float> itemIdCashbackEntry : itemIdCashbackMap.entrySet()){
598
				walletService.addAmountToWallet(retailerId, purchaseId, WalletReferenceType.SCHEME_IN,
599
						itemIdCashbackCountMap.get(itemIdCashbackEntry.getKey())+"pcs of item "+
600
						itemStringMap.get(itemIdCashbackEntry.getKey()) +
601
				" Added for SCHEME_IN against invoiceNumber ["+purchase.getPurchaseReference()+"]", totalCashback);
602
			}
603
			purchase.setCashback(totalCashback);
604
			purchaseRepository.persist(purchase);
22653 ashik.ali 605
		}
606
	}
607
 
22859 ashik.ali 608
	private float createSchemeInOut(Scheme scheme, InventoryItem inventoryItem){
609
		float amount = this.getAmount(inventoryItem, scheme);
610
		SchemeInOut schemeInOut = new SchemeInOut();
611
		schemeInOut.setSchemeId(scheme.getId());
612
		schemeInOut.setInventoryItemId(inventoryItem.getId());
613
		schemeInOut.setAmount(amount);
614
		schemeInOutRepository.persist(schemeInOut);
615
		return amount;
616
	}
617
 
618
	private float getAmount(InventoryItem inventoryItem, Scheme scheme){
22653 ashik.ali 619
		float amount = 0;
22859 ashik.ali 620
		float totalTaxRate = inventoryItem.getIgstRate() + inventoryItem.getSgstRate() + inventoryItem.getCgstRate();
621
		float taxableSellingPrice = inventoryItem.getUnitPrice() / (1 + totalTaxRate / 100);
622
 
22653 ashik.ali 623
		if(scheme.getAmountType() == SchemeAmountType.PERCENTAGE){
22859 ashik.ali 624
			amount = taxableSellingPrice * scheme.getAmount() / 100;
22653 ashik.ali 625
		}else{
626
			amount = scheme.getAmount();
627
		}
22859 ashik.ali 628
		return amount;
22653 ashik.ali 629
	}
630
 
22859 ashik.ali 631
	private Map<Integer, InventoryItem> toInventoryItemIdInventoryItemMap(List<InventoryItem> inventoryItems){
632
		Map<Integer, InventoryItem> itemIdInventoryItemMap = new HashMap<>();
633
		for(InventoryItem inventoryItem : inventoryItems){
634
			itemIdInventoryItemMap.put(inventoryItem.getId(), inventoryItem);
22653 ashik.ali 635
		}
22859 ashik.ali 636
		return itemIdInventoryItemMap;
22653 ashik.ali 637
	}
22859 ashik.ali 638
 
639
 
640
	private Set<Integer> toInventoryItemIds(Set<FofoOrderItem> fofoOrderItems){
641
		Set<Integer> inventoryItemIds = new HashSet<>();
642
		//Map<Integer, Set<FofoLineItem>> fofoOrderItemIdFofoLineItemsMap = this.toFofoOrderItemIdFofoLineItems(fofoOrderItems);
643
		for(FofoOrderItem fofoOrderItem : fofoOrderItems){
644
			for(FofoLineItem fofoLineItem : fofoOrderItem.getFofoLineItems()){
645
				inventoryItemIds.add(fofoLineItem.getInventoryItemId());
646
			}
647
		}
648
		return inventoryItemIds;
649
	}
22653 ashik.ali 650
 
651
	@Override
23365 ashik.ali 652
	public void processSchemeOut(int fofoOrderId, int retailerId) throws ProfitMandiBusinessException {
653
		FofoOrder fofoOrder = fofoOrderRepository.selectByFofoIdAndOrderId(retailerId, fofoOrderId);
22859 ashik.ali 654
		List<Scheme> schemes = schemeRepository.selectActiveAll(SchemeType.OUT, LocalDateTime.now());
655
		LOGGER.info("Active Schemes {}", schemes);
656
		float totalCashback = 0;
657
		if(schemes.isEmpty()){
23365 ashik.ali 658
			return;
22859 ashik.ali 659
		}
22653 ashik.ali 660
 
22925 ashik.ali 661
		List<FofoOrderItem> fofoOrderItems = orderService.getByOrderId(fofoOrderId);
22859 ashik.ali 662
		//LOGGER.info("fofoOrderItems {}", fofoOrderItems);
663
 
664
		Map<FofoOrderItem, Set<Scheme>> fofoOrderItemSchemesMap = this.toFofoOrderItemSchemesMap(schemes, fofoOrderItems);
665
 
666
		LOGGER.info("fofoOrderItemSchemesMap {}", fofoOrderItemSchemesMap);
667
 
668
		if(fofoOrderItemSchemesMap.isEmpty()){
23365 ashik.ali 669
			return;
22859 ashik.ali 670
		}
671
 
672
		Set<Integer> inventoryItemIds = this.toInventoryItemIds(fofoOrderItemSchemesMap.keySet());
673
 
674
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
675
 
676
		Map<Integer, InventoryItem> inventoryItemIdInventoryItemMap = this.toInventoryItemIdInventoryItemMap(inventoryItems);
677
 
678
		Map<FofoOrderItem, Set<Scheme>> notAllFofoOrderItemSchemesMap = new HashMap<>();
679
		Map<FofoOrderItem, Set<Scheme>> allFofoOrderItemSchemesMap = new HashMap<>();
680
 
681
		for(Map.Entry<FofoOrderItem, Set<Scheme>> fofoOrderItemSchemesEntry : fofoOrderItemSchemesMap.entrySet()){
682
			Set<Scheme> notAllSchemes = new HashSet<>();
683
			Set<Scheme> allSchemes = new HashSet<>();
684
			for(Scheme scheme : fofoOrderItemSchemesEntry.getValue()){
685
				if(!scheme.isRetailerAll()){
686
					notAllSchemes.add(scheme);
687
				}else{
688
					allSchemes.add(scheme);
689
				}
22653 ashik.ali 690
			}
22859 ashik.ali 691
			notAllFofoOrderItemSchemesMap.put(fofoOrderItemSchemesEntry.getKey(), notAllSchemes);
692
			allFofoOrderItemSchemesMap.put(fofoOrderItemSchemesEntry.getKey(), allSchemes);
22653 ashik.ali 693
		}
22859 ashik.ali 694
 
695
		for(Map.Entry<FofoOrderItem, Set<Scheme>> allFofoOrderItemSchemesEntry : allFofoOrderItemSchemesMap.entrySet()){
696
			for(FofoLineItem fofoLineItem : allFofoOrderItemSchemesEntry.getKey().getFofoLineItems()){
697
				for(Scheme scheme : allFofoOrderItemSchemesEntry.getValue()){
698
					float cashback = this.createSchemeInOut(scheme, inventoryItemIdInventoryItemMap.get(fofoLineItem.getInventoryItemId()));
699
					totalCashback = totalCashback + cashback;
700
				}
701
			}
22653 ashik.ali 702
		}
703
 
22859 ashik.ali 704
		Set<Integer> schemeIds = this.fofoLineItemSchemesMapToSchemeIds(notAllFofoOrderItemSchemesMap);
705
 
706
		if(!schemeIds.isEmpty()){
707
			List<Integer> foundSchemeIds = retailerSchemeRepository.selectSchemeIds(schemeIds, retailerId);
708
 
709
			for(Map.Entry<FofoOrderItem, Set<Scheme>> notAllFofoOrderItemSchemesEntry : notAllFofoOrderItemSchemesMap.entrySet()){
710
				for(FofoLineItem fofoLineItem : notAllFofoOrderItemSchemesEntry.getKey().getFofoLineItems()){
711
					for(Scheme scheme : notAllFofoOrderItemSchemesEntry.getValue()){
712
						if(foundSchemeIds.contains(scheme.getId())){
713
							float cashback = this.createSchemeInOut(scheme, inventoryItemIdInventoryItemMap.get(fofoLineItem.getInventoryItemId()));
714
							totalCashback = totalCashback + cashback;
22653 ashik.ali 715
						}
716
					}
717
				}
22859 ashik.ali 718
			}	
22653 ashik.ali 719
		}
22859 ashik.ali 720
		if(totalCashback > 0){
721
			walletService.addAmountToWallet(retailerId, fofoOrderId, WalletReferenceType.SCHEME_OUT, "Added for SCHEME_OUT", totalCashback);
23365 ashik.ali 722
			fofoOrder.setCashback(totalCashback);
723
			fofoOrderRepository.persist(fofoOrder);
22859 ashik.ali 724
		}
22653 ashik.ali 725
	}
23297 ashik.ali 726
 
22653 ashik.ali 727
}