Subversion Repositories SmartDukaan

Rev

Rev 30922 | Rev 30929 | 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));
101
		for (Entry<Integer, CustomRetailer> customRetailerEntry : customRetailerMap.entrySet()) {
102
			int fofoId = customRetailerEntry.getKey();
103
 
104
			SDCreditRequirement sdCreditRequirement = sdCreditRequirementMap.get(customRetailerEntry.getKey());
105
 
30923 tejbeer 106
			if (sdCreditRequirement != null) {
30913 tejbeer 107
 
30923 tejbeer 108
				BigDecimal utilizedLimit = new BigDecimal(sdCreditService.getUtilizationAmount(fofoId));
30910 tejbeer 109
 
30923 tejbeer 110
				BigDecimal availableLimit = sdCreditRequirement.getLimit().subtract(utilizedLimit);
30910 tejbeer 111
 
30923 tejbeer 112
				LOGGER.info("utilizedLimit {} ", utilizedLimit);
30910 tejbeer 113
 
30923 tejbeer 114
				LOGGER.info("availableLimit {} ", availableLimit);
30910 tejbeer 115
 
30923 tejbeer 116
				sdCreditRequirement.setUtilizedAmount(utilizedLimit);
30910 tejbeer 117
 
30923 tejbeer 118
				sdCreditRequirement.setAvailableLimit(availableLimit);
119
 
30859 tejbeer 120
				sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
121
			}
122
 
123
		}
124
 
30922 tejbeer 125
		model.addAttribute("customRetailerMap", customRetailerMap);
126
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
127
		return "sd-credit";
30921 tejbeer 128
	}
129
 
30859 tejbeer 130
	@RequestMapping(value = "/creditRequirement", method = RequestMethod.POST)
131
	public String sdCredit(HttpServletRequest request, @RequestBody SdCreditRequirementModel sdCreditRequirementModel,
132
			Model model) throws Exception {
133
 
134
		LOGGER.info("sdCreditRequirementModel {} ", sdCreditRequirementModel);
135
 
136
		int fofoId = sdCreditRequirementModel.getFofoId();
137
 
138
		SDCreditRequirement sdCreditRequirement = sdCreditRequirementRepository
139
				.selectByFofoId(sdCreditRequirementModel.getFofoId());
140
 
141
		FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(sdCreditRequirementModel.getFofoId());
142
		BigDecimal suggestedAmount = new BigDecimal((fofoStore.getMinimumInvestment() * 0.1));
143
 
144
		LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
145
 
146
		sdCreditRequirement.setSecurityCheck(sdCreditRequirementModel.getSecurityCheck());
147
		// sdCreditRequirement.setSecurityCheck(2);
148
 
149
		sdCreditRequirement.setInterestRate(sdCreditRequirementModel.getInterest());
150
		sdCreditRequirement.setFreeDays(sdCreditRequirementModel.getFreeDays());
151
		sdCreditRequirement.setLimit(sdCreditRequirementModel.getLimit());
152
		sdCreditRequirement.setSuggestedLimit(suggestedAmount);
30865 tejbeer 153
		BigDecimal utilizedLimit = new BigDecimal(sdCreditService.getUtilizationAmount(fofoId));
154
 
155
		BigDecimal availableLimit = sdCreditRequirement.getLimit().subtract(utilizedLimit);
156
 
30909 tejbeer 157
		LOGGER.info("utilizedLimit {} ", utilizedLimit);
158
 
159
		LOGGER.info("availableLimit {} ", availableLimit);
160
 
30859 tejbeer 161
		sdCreditRequirement.setUtilizedAmount(utilizedLimit);
162
 
163
		sdCreditRequirement.setAvailableLimit(availableLimit);
164
		sdCreditRequirement.setCreditDays(15);
165
		sdCreditRequirement.setRisk(CreditRisk.NO_RISK);
166
 
167
		sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
168
 
169
		if (sdCreditRequirement.getSecurityCheck() > 0) {
170
 
171
			CreditAccount creditAccount = creditAccountRepository
172
					.selectByFofoIdAndGateway(sdCreditRequirementModel.getFofoId(), Gateway.SDDIRECT);
173
			if (creditAccount == null) {
174
				creditAccount = new CreditAccount();
175
				creditAccount.setFofoId(sdCreditRequirementModel.getFofoId());
176
				creditAccount.setGateway(Gateway.SDDIRECT);
177
				creditAccount.setCreditStatus(CreditStatus.SANCTIONED);
178
				creditAccount.setActive(false);
179
 
180
				creditAccount.setUpdatedOn(LocalDateTime.now());
181
 
182
				creditAccountRepository.persist(creditAccount);
183
			}
184
 
185
			creditAccount.setInterestRate(sdCreditRequirement.getInterestRate().floatValue());
186
			creditAccount.setSanctionedAmount(sdCreditRequirement.getLimit().floatValue());
187
			creditAccount.setAvailableAmount(availableLimit.floatValue());
188
			creditAccount.setFreeDays(sdCreditRequirement.getFreeDays());
189
			creditAccount.setUpdatedOn(LocalDateTime.now());
190
 
191
		}
192
		LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
193
 
194
		CustomRetailer customRetailer = retailerService.getFofoRetailer(sdCreditRequirementModel.getFofoId());
195
 
30865 tejbeer 196
		sdCreditRequirement = sdCreditRequirementRepository.selectByFofoId(sdCreditRequirementModel.getFofoId());
197
 
30859 tejbeer 198
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = new HashMap<>();
199
		sdCreditRequirementMap.put(sdCreditRequirement.getFofoId(), sdCreditRequirement);
200
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
201
		model.addAttribute("customRetailer", customRetailer);
202
 
203
		return "sd-credit-requirement-row";
204
 
205
	}
206
 
207
	@RequestMapping(value = "/getSanctionRequest", method = RequestMethod.GET)
208
	public String getSanctionRequest(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
209
 
210
		List<SanctionRequest> sanctionRequests = sanctionRequestRepository.selectByDate(LocalDate.now());
211
 
212
		List<Integer> fofoIds = sanctionRequests.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
213
 
214
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
215
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
216
 
217
		if (!sanctionRequests.isEmpty()) {
218
 
219
			Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
220
			Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
221
					.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
222
					.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
223
 
224
			model.addAttribute("customRetailerMap", customRetailerMap);
225
 
226
			model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
227
 
228
		}
229
 
230
		model.addAttribute("sanctionRequests", sanctionRequests);
231
 
232
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
233
 
234
		model.addAttribute("sanctionStatus", SanctionStatus.values());
235
		return "sanction-request";
236
 
237
	}
238
 
239
	@RequestMapping(value = "/sanctionRequest", method = RequestMethod.POST)
240
	public String sanctionRequest(HttpServletRequest request, @RequestBody SanctionRequestModel sanctionRequestModel,
241
			Model model) throws Exception {
242
 
243
		LOGGER.info("sanctionRequestModel {} ", sanctionRequestModel);
244
		Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
245
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
246
 
247
		SanctionRequest sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
248
		List<Integer> fofoIds = sanctionRequestRepository.selectByDate(LocalDate.now()).stream().map(x -> x.getFofoId())
249
				.collect(Collectors.toList());
250
 
251
		Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
252
 
253
		LOGGER.info("freeDays {} ", sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays());
254
 
255
		if (sanctionRequestModel.getStatus().equals(SanctionStatus.APPROVED)) {
256
			CustomRetailer customRetailer = customRetailerMap.get(sanctionRequest.getFofoId());
257
			sanctionRequest.setApprovalTimestamp(LocalDateTime.now());
258
			BigDecimal availableAmount = sdCreditService.getAvailableAmount(sanctionRequest.getFofoId());
259
 
260
			String title = "Sanction Request Approved";
261
			String url = "http://app.smartdukaan.com/pages/home/credit";
262
			String message = "congratulations! Your credit limit is increased for today Rs."
263
					+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
264
					+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP);
265
			notificationService.sendNotification(sanctionRequest.getFofoId(), title, MessageType.notification, title,
266
					message, url);
267
 
268
			AuthUser authUser = authRepository.selectById(sanctionRequest.getAuthId());
269
 
270
			SendNotificationModel sendNotificationModel = new SendNotificationModel();
271
			sendNotificationModel.setCampaignName("Loan");
272
			sendNotificationModel.setTitle("Sanction Request Approved");
273
			sendNotificationModel.setMessage("congratulations! Your Partner  " + customRetailer.getBusinessName()
274
					+ "credit limit is increased for today Rs."
275
					+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
276
					+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP));
277
			sendNotificationModel.setType("url");
278
			sendNotificationModel.setUrl("https://app.smartdukaan.com/pages/home/credit");
279
			sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(2));
280
			sendNotificationModel.setMessageType(MessageType.notification);
281
			sendNotificationModel
282
					.setUserIds(Arrays.asList(userRepository.selectByEmailId(authUser.getEmailId()).getId()));
283
			System.out.println(sendNotificationModel);
284
			notificationService.sendNotification(sendNotificationModel);
285
 
286
		}
287
 
288
		if (sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() >= sanctionRequestModel
289
				.getFreeDays()) {
290
			sanctionRequest.setFreeDays(sanctionRequestModel.getFreeDays());
291
		} else {
292
			throw new ProfitMandiBusinessException("Free Days", "Free Days", "Free Days is not more than "
293
					+ sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() + " days ");
294
		}
295
 
296
		sanctionRequest.setApprovalAmount(sanctionRequestModel.getApprovalAmount());
297
		sanctionRequest.setStatus(sanctionRequestModel.getStatus());
298
 
299
		Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
300
				.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
301
				.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
302
		sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
303
		model.addAttribute("customRetailerMap", customRetailerMap);
304
		model.addAttribute("sanctionRequest", sanctionRequest);
305
		model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
306
		model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
307
 
308
		model.addAttribute("sanctionStatus", SanctionStatus.values());
309
 
310
		return "sanction-request-row";
311
 
312
	}
313
 
314
}