Subversion Repositories SmartDukaan

Rev

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