Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
30859 tejbeer 1
package com.spice.profitmandi.web.controller;
2
 
3
import java.math.BigDecimal;
4
import java.math.RoundingMode;
5
import java.time.LocalDate;
6
import java.time.LocalDateTime;
7
import java.util.Arrays;
8
import java.util.HashMap;
9
import java.util.List;
10
import java.util.Map;
11
import java.util.Map.Entry;
12
import java.util.stream.Collectors;
13
 
14
import javax.servlet.http.HttpServletRequest;
15
import javax.transaction.Transactional;
16
 
17
import org.apache.logging.log4j.LogManager;
18
import org.apache.logging.log4j.Logger;
19
import org.springframework.beans.factory.annotation.Autowired;
20
import org.springframework.stereotype.Controller;
21
import org.springframework.ui.Model;
22
import org.springframework.web.bind.annotation.RequestBody;
23
import org.springframework.web.bind.annotation.RequestMapping;
24
import org.springframework.web.bind.annotation.RequestMethod;
25
 
26
import com.spice.profitmandi.common.enumuration.MessageType;
27
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
28
import com.spice.profitmandi.common.model.CustomRetailer;
29
import com.spice.profitmandi.common.model.SendNotificationModel;
30
import com.spice.profitmandi.dao.entity.auth.AuthUser;
31
import com.spice.profitmandi.dao.entity.dtr.CreditAccount;
32
import com.spice.profitmandi.dao.entity.dtr.CreditStatus;
30913 tejbeer 33
import com.spice.profitmandi.dao.entity.fofo.CurrentPartnerDailyInvestment;
30859 tejbeer 34
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
35
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
36
import com.spice.profitmandi.dao.entity.transaction.SDCreditRequirement;
37
import com.spice.profitmandi.dao.entity.transaction.SanctionRequest;
38
import com.spice.profitmandi.dao.enumuration.fofo.Gateway;
39
import com.spice.profitmandi.dao.enumuration.transaction.CreditRisk;
40
import com.spice.profitmandi.dao.enumuration.transaction.SanctionStatus;
41
import com.spice.profitmandi.dao.model.SanctionRequestModel;
42
import com.spice.profitmandi.dao.model.SdCreditRequirementModel;
43
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
44
import com.spice.profitmandi.dao.repository.dtr.CreditAccountRepository;
45
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
46
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
30913 tejbeer 47
import com.spice.profitmandi.dao.repository.fofo.CurrentPartnerDailyInvestmentRepository;
30859 tejbeer 48
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
49
import com.spice.profitmandi.dao.repository.transaction.SDCreditRequirementRepository;
50
import com.spice.profitmandi.dao.repository.transaction.SanctionRequestRepository;
51
import com.spice.profitmandi.service.NotificationService;
52
import com.spice.profitmandi.service.transaction.SDCreditService;
53
import com.spice.profitmandi.service.user.RetailerService;
54
 
55
@Controller
56
@Transactional(rollbackOn = Throwable.class)
57
public class SDCreditController {
58
 
59
	@Autowired
60
	private RetailerService retailerService;
61
 
62
	@Autowired
63
	SDCreditRequirementRepository sdCreditRequirementRepository;
64
 
65
	@Autowired
66
	SanctionRequestRepository sanctionRequestRepository;
67
 
68
	@Autowired
69
	PartnerDailyInvestmentRepository partnerDailyInvestmentRepository;
70
 
71
	@Autowired
72
	private FofoStoreRepository fofoStoreRepository;
73
 
74
	@Autowired
75
	private CreditAccountRepository creditAccountRepository;
76
 
77
	@Autowired
78
	private SDCreditService sdCreditService;
79
 
80
	@Autowired
81
	private NotificationService notificationService;
82
 
83
	@Autowired
84
	private AuthRepository authRepository;
85
 
86
	@Autowired
87
	private UserRepository userRepository;
88
 
30913 tejbeer 89
	@Autowired
90
	private CurrentPartnerDailyInvestmentRepository currentPartnerDailyInvestmentRepository;
91
 
30859 tejbeer 92
	private static final Logger LOGGER = LogManager.getLogger(SDCreditController.class);
93
 
94
	@RequestMapping(value = "/getSDCreditReq", method = RequestMethod.GET)
95
	public String getSDCreditReq(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
96
 
97
		Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(true);
98
 
99
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
100
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
30913 tejbeer 101
		Map<Integer, CurrentPartnerDailyInvestment> currentPartnerDailyInvestmentMap = currentPartnerDailyInvestmentRepository
102
				.selectAll().stream().collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
30859 tejbeer 103
 
104
		for (Entry<Integer, CustomRetailer> customRetailerEntry : customRetailerMap.entrySet()) {
105
			int fofoId = customRetailerEntry.getKey();
106
 
107
			SDCreditRequirement sdCreditRequirement = sdCreditRequirementMap.get(customRetailerEntry.getKey());
108
 
30919 tejbeer 109
			if (sdCreditRequirement != null) {
30913 tejbeer 110
 
30910 tejbeer 111
				BigDecimal utilizedLimit = new BigDecimal(sdCreditService.getUtilizationAmount(fofoId));
112
 
113
				BigDecimal availableLimit = sdCreditRequirement.getLimit().subtract(utilizedLimit);
114
 
115
				LOGGER.info("utilizedLimit {} ", utilizedLimit);
116
 
117
				LOGGER.info("availableLimit {} ", availableLimit);
118
 
119
				sdCreditRequirement.setUtilizedAmount(utilizedLimit);
120
 
121
				sdCreditRequirement.setAvailableLimit(availableLimit);
122
 
30859 tejbeer 123
				sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
124
			}
125
 
126
		}
127
 
128
		model.addAttribute("customRetailerMap", customRetailerMap);
129
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
130
		return "sd-credit";
131
	}
132
 
133
	@RequestMapping(value = "/creditRequirement", method = RequestMethod.POST)
134
	public String sdCredit(HttpServletRequest request, @RequestBody SdCreditRequirementModel sdCreditRequirementModel,
135
			Model model) throws Exception {
136
 
137
		LOGGER.info("sdCreditRequirementModel {} ", sdCreditRequirementModel);
138
 
139
		int fofoId = sdCreditRequirementModel.getFofoId();
140
 
141
		SDCreditRequirement sdCreditRequirement = sdCreditRequirementRepository
142
				.selectByFofoId(sdCreditRequirementModel.getFofoId());
143
 
144
		FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(sdCreditRequirementModel.getFofoId());
145
		BigDecimal suggestedAmount = new BigDecimal((fofoStore.getMinimumInvestment() * 0.1));
146
 
147
		LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
148
 
149
		sdCreditRequirement.setSecurityCheck(sdCreditRequirementModel.getSecurityCheck());
150
		// sdCreditRequirement.setSecurityCheck(2);
151
 
152
		sdCreditRequirement.setInterestRate(sdCreditRequirementModel.getInterest());
153
		sdCreditRequirement.setFreeDays(sdCreditRequirementModel.getFreeDays());
154
		sdCreditRequirement.setLimit(sdCreditRequirementModel.getLimit());
155
		sdCreditRequirement.setSuggestedLimit(suggestedAmount);
30865 tejbeer 156
		BigDecimal utilizedLimit = new BigDecimal(sdCreditService.getUtilizationAmount(fofoId));
157
 
158
		BigDecimal availableLimit = sdCreditRequirement.getLimit().subtract(utilizedLimit);
159
 
30909 tejbeer 160
		LOGGER.info("utilizedLimit {} ", utilizedLimit);
161
 
162
		LOGGER.info("availableLimit {} ", availableLimit);
163
 
30859 tejbeer 164
		sdCreditRequirement.setUtilizedAmount(utilizedLimit);
165
 
166
		sdCreditRequirement.setAvailableLimit(availableLimit);
167
		sdCreditRequirement.setCreditDays(15);
168
		sdCreditRequirement.setRisk(CreditRisk.NO_RISK);
169
 
170
		sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
171
 
172
		if (sdCreditRequirement.getSecurityCheck() > 0) {
173
 
174
			CreditAccount creditAccount = creditAccountRepository
175
					.selectByFofoIdAndGateway(sdCreditRequirementModel.getFofoId(), Gateway.SDDIRECT);
176
			if (creditAccount == null) {
177
				creditAccount = new CreditAccount();
178
				creditAccount.setFofoId(sdCreditRequirementModel.getFofoId());
179
				creditAccount.setGateway(Gateway.SDDIRECT);
180
				creditAccount.setCreditStatus(CreditStatus.SANCTIONED);
181
				creditAccount.setActive(false);
182
 
183
				creditAccount.setUpdatedOn(LocalDateTime.now());
184
 
185
				creditAccountRepository.persist(creditAccount);
186
			}
187
 
188
			creditAccount.setInterestRate(sdCreditRequirement.getInterestRate().floatValue());
189
			creditAccount.setSanctionedAmount(sdCreditRequirement.getLimit().floatValue());
190
			creditAccount.setAvailableAmount(availableLimit.floatValue());
191
			creditAccount.setFreeDays(sdCreditRequirement.getFreeDays());
192
			creditAccount.setUpdatedOn(LocalDateTime.now());
193
 
194
		}
195
		LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
196
 
197
		CustomRetailer customRetailer = retailerService.getFofoRetailer(sdCreditRequirementModel.getFofoId());
198
 
30865 tejbeer 199
		sdCreditRequirement = sdCreditRequirementRepository.selectByFofoId(sdCreditRequirementModel.getFofoId());
200
 
30859 tejbeer 201
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = new HashMap<>();
202
		sdCreditRequirementMap.put(sdCreditRequirement.getFofoId(), sdCreditRequirement);
203
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
204
		model.addAttribute("customRetailer", customRetailer);
205
 
206
		return "sd-credit-requirement-row";
207
 
208
	}
209
 
210
	@RequestMapping(value = "/getSanctionRequest", method = RequestMethod.GET)
211
	public String getSanctionRequest(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
212
 
213
		List<SanctionRequest> sanctionRequests = sanctionRequestRepository.selectByDate(LocalDate.now());
214
 
215
		List<Integer> fofoIds = sanctionRequests.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
216
 
217
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
218
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
219
 
220
		if (!sanctionRequests.isEmpty()) {
221
 
222
			Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
223
			Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
224
					.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
225
					.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
226
 
227
			model.addAttribute("customRetailerMap", customRetailerMap);
228
 
229
			model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
230
 
231
		}
232
 
233
		model.addAttribute("sanctionRequests", sanctionRequests);
234
 
235
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
236
 
237
		model.addAttribute("sanctionStatus", SanctionStatus.values());
238
		return "sanction-request";
239
 
240
	}
241
 
242
	@RequestMapping(value = "/sanctionRequest", method = RequestMethod.POST)
243
	public String sanctionRequest(HttpServletRequest request, @RequestBody SanctionRequestModel sanctionRequestModel,
244
			Model model) throws Exception {
245
 
246
		LOGGER.info("sanctionRequestModel {} ", sanctionRequestModel);
247
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
248
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
249
 
250
		SanctionRequest sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
251
		List<Integer> fofoIds = sanctionRequestRepository.selectByDate(LocalDate.now()).stream().map(x -> x.getFofoId())
252
				.collect(Collectors.toList());
253
 
254
		Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
255
 
256
		LOGGER.info("freeDays {} ", sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays());
257
 
258
		if (sanctionRequestModel.getStatus().equals(SanctionStatus.APPROVED)) {
259
			CustomRetailer customRetailer = customRetailerMap.get(sanctionRequest.getFofoId());
260
			sanctionRequest.setApprovalTimestamp(LocalDateTime.now());
261
			BigDecimal availableAmount = sdCreditService.getAvailableAmount(sanctionRequest.getFofoId());
262
 
263
			String title = "Sanction Request Approved";
264
			String url = "http://app.smartdukaan.com/pages/home/credit";
265
			String message = "congratulations! Your credit limit is increased for today Rs."
266
					+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
267
					+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP);
268
			notificationService.sendNotification(sanctionRequest.getFofoId(), title, MessageType.notification, title,
269
					message, url);
270
 
271
			AuthUser authUser = authRepository.selectById(sanctionRequest.getAuthId());
272
 
273
			SendNotificationModel sendNotificationModel = new SendNotificationModel();
274
			sendNotificationModel.setCampaignName("Loan");
275
			sendNotificationModel.setTitle("Sanction Request Approved");
276
			sendNotificationModel.setMessage("congratulations! Your Partner  " + customRetailer.getBusinessName()
277
					+ "credit limit is increased for today Rs."
278
					+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
279
					+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP));
280
			sendNotificationModel.setType("url");
281
			sendNotificationModel.setUrl("https://app.smartdukaan.com/pages/home/credit");
282
			sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(2));
283
			sendNotificationModel.setMessageType(MessageType.notification);
284
			sendNotificationModel
285
					.setUserIds(Arrays.asList(userRepository.selectByEmailId(authUser.getEmailId()).getId()));
286
			System.out.println(sendNotificationModel);
287
			notificationService.sendNotification(sendNotificationModel);
288
 
289
		}
290
 
291
		if (sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() >= sanctionRequestModel
292
				.getFreeDays()) {
293
			sanctionRequest.setFreeDays(sanctionRequestModel.getFreeDays());
294
		} else {
295
			throw new ProfitMandiBusinessException("Free Days", "Free Days", "Free Days is not more than "
296
					+ sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() + " days ");
297
		}
298
 
299
		sanctionRequest.setApprovalAmount(sanctionRequestModel.getApprovalAmount());
300
		sanctionRequest.setStatus(sanctionRequestModel.getStatus());
301
 
302
		Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
303
				.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
304
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
305
		sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
306
		model.addAttribute("customRetailerMap", customRetailerMap);
307
		model.addAttribute("sanctionRequest", sanctionRequest);
308
		model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
309
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
310
 
311
		model.addAttribute("sanctionStatus", SanctionStatus.values());
312
 
313
		return "sanction-request-row";
314
 
315
	}
316
 
317
}