Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
23506 amit.gupta 1
package com.spice.profitmandi.web.controller;
2
 
3
import java.time.LocalDateTime;
23618 amit.gupta 4
import java.time.temporal.ChronoUnit;
23621 amit.gupta 5
import java.util.ArrayList;
23618 amit.gupta 6
import java.util.Arrays;
7
import java.util.HashMap;
23506 amit.gupta 8
import java.util.List;
23618 amit.gupta 9
import java.util.Map;
23506 amit.gupta 10
 
11
import javax.servlet.http.HttpServletRequest;
23612 amit.gupta 12
 
23568 govind 13
import org.apache.logging.log4j.LogManager;
14
import org.apache.logging.log4j.Logger;
23506 amit.gupta 15
import org.springframework.beans.factory.annotation.Autowired;
16
import org.springframework.beans.factory.annotation.Value;
17
import org.springframework.scheduling.annotation.Scheduled;
18
import org.springframework.stereotype.Controller;
19
import org.springframework.transaction.annotation.Transactional;
20
import org.springframework.ui.Model;
21
import org.springframework.web.bind.annotation.RequestMapping;
22
import org.springframework.web.bind.annotation.RequestMethod;
23
 
23618 amit.gupta 24
import com.spice.profitmandi.common.enumuration.RechargeStatus;
23506 amit.gupta 25
import com.spice.profitmandi.common.enumuration.SchemeType;
23618 amit.gupta 26
import com.spice.profitmandi.common.model.RechargeCredential;
23506 amit.gupta 27
import com.spice.profitmandi.common.web.client.RestClient;
23618 amit.gupta 28
import com.spice.profitmandi.dao.entity.dtr.RechargeTransaction;
23511 amit.gupta 29
import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
23506 amit.gupta 30
import com.spice.profitmandi.dao.entity.fofo.Purchase;
23612 amit.gupta 31
import com.spice.profitmandi.dao.repository.dtr.RechargeTransactionRepository;
23511 amit.gupta 32
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
23506 amit.gupta 33
import com.spice.profitmandi.dao.repository.fofo.PurchaseRepository;
23612 amit.gupta 34
import com.spice.profitmandi.service.recharge.provider.OxigenRechargeProviderService;
35
import com.spice.profitmandi.service.recharge.provider.ThinkWalnutDigitalRechargeProviderService;
23506 amit.gupta 36
import com.spice.profitmandi.service.scheme.SchemeService;
37
import com.spice.profitmandi.web.util.MVCResponseSender;
38
 
39
@Controller
23511 amit.gupta 40
@Transactional(rollbackFor=Throwable.class)
23506 amit.gupta 41
public class CronController {
23618 amit.gupta 42
 
43
	@Value("${oxigen.recharge.enquiry.url}")
44
	private String oxigenRechargeEnquiryUrl;
45
 
46
	@Value("${oxigen.recharge.auth.key}")
47
	private String oxigenRechargeAuthKey;
48
 
49
	@Value("${oxigen.recharge.validation.url}")
50
	private String oxigenRechargeValidationUrl;
51
 
52
	@Value("${oxigen.recharge.validation.auth.key}")
53
	private String oxigenRechargeValidationAuthKey;
54
 
55
	@Value("${think.walnut.digital.recharge.transaction.mobile.url}")
56
	private String thinkWalnutDigitalRechargeTransactionMobileUrl;
57
 
58
	@Value("${think.walnut.digital.recharge.transaction.mobile.username}")
59
	private String thinkWalnutDigitalRechargeTransactionMobileUserName;
60
 
61
	@Value("${think.walnut.digital.recharge.transaction.mobile.password}")
62
	private String thinkWalnutDigitalRechargeTransactionMobilePassword;
63
 
64
	@Value("${think.walnut.digital.recharge.transaction.dth.url}")
65
	private String thinkWalnutDigitalRechargeTransactionDthUrl;
66
 
67
	@Value("${think.walnut.digital.recharge.transaction.dth.username}")
68
	private String thinkWalnutDigitalRechargeTransactionDthUserName;
69
 
70
	@Value("${think.walnut.digital.recharge.transaction.dth.password}")
71
	private String thinkWalnutDigitalRechargeTransactionDthPassword;
72
 
73
	@Value("${think.walnut.digital.recharge.enquiry.url}")
74
	private String thinkWalnutDigitalRechargeEnquiryUrl;
75
 
76
	@Value("${think.walnut.digital.recharge.enquiry.username}")
77
	private String thinkWalnutDigitalRechargeEnquiryUserName;
78
 
79
	@Value("${think.walnut.digital.recharge.enquiry.password}")
80
	private String thinkWalnutDigitalRechargeEnquiryPassword;
81
 
82
	@Value("${think.walnut.digital.recharge.auth.key}")
83
	private String thinkWalnutDigitalRechargeAuthKey;
23506 amit.gupta 84
 
85
	@Autowired
86
	PurchaseRepository purchaseRepository;
87
 
88
	@Autowired
89
	SchemeService schemeService;
90
 
91
	@Autowired
23612 amit.gupta 92
	RechargeTransactionRepository rechargeTransactionRepository;
93
 
94
	@Autowired
23511 amit.gupta 95
	FofoOrderRepository fofoOrderRepository;
23530 ashik.ali 96
 
97
	@Autowired
23612 amit.gupta 98
	ThinkWalnutDigitalRechargeProviderService thinkWalnutDigitalRechargeProviderService;
99
 
100
	@Autowired
101
	OxigenRechargeProviderService oxigenRechargeProviderService; 
102
 
103
	@Autowired
23530 ashik.ali 104
	private RestClient restClient;
23511 amit.gupta 105
 
106
	@Autowired
23506 amit.gupta 107
	private MVCResponseSender mvcResponseSender;
108
 
109
	@Value("${prod}")
110
	private boolean prod;
111
 
112
 
23612 amit.gupta 113
	private static final Logger LOGGER = LogManager.getLogger(CronController.class);
23506 amit.gupta 114
 
115
	@Scheduled(cron = "0 45 6 * * *")
116
	public void executeJob() throws Exception {
117
		if(prod) {
118
			String uri = "/cron/process-schemes";
23530 ashik.ali 119
			restClient.get(SchemeType.HTTP, "localhost", 8080, uri, null);
23506 amit.gupta 120
		}
121
	}
122
 
23618 amit.gupta 123
	@RequestMapping(value = "/cron/reconcile-recharge", method = RequestMethod.GET)
124
	public String reconcileRecharge(Model model) throws Exception {
125
		LocalDateTime fromDate = LocalDateTime.now().truncatedTo(ChronoUnit.DAYS).minusDays(30);
126
		LocalDateTime toDate = LocalDateTime.now().truncatedTo(ChronoUnit.DAYS);
23621 amit.gupta 127
		List<RechargeStatus> nonSuccessRechargeStatuses = new ArrayList<>(Arrays.asList(RechargeStatus.values()));
23620 amit.gupta 128
		LOGGER.info("nonSuccessRechargeStatuses {} ", nonSuccessRechargeStatuses);
23618 amit.gupta 129
		nonSuccessRechargeStatuses.remove(RechargeStatus.SUCCESS);
130
		nonSuccessRechargeStatuses.remove(RechargeStatus.FAILED);
131
		RechargeCredential thinkWalnutDigitalRechargeEnquiryCredential = new RechargeCredential();
132
		thinkWalnutDigitalRechargeEnquiryCredential.setRechargeUrl(thinkWalnutDigitalRechargeEnquiryUrl);
133
		thinkWalnutDigitalRechargeEnquiryCredential.setRechargeUserName(thinkWalnutDigitalRechargeEnquiryUserName);
134
		thinkWalnutDigitalRechargeEnquiryCredential.setRechargePassword(thinkWalnutDigitalRechargeEnquiryPassword);
135
		thinkWalnutDigitalRechargeEnquiryCredential.setRechargeAuthKey(thinkWalnutDigitalRechargeAuthKey);
136
		Map<String, RechargeStatus> requestRechargeStatusChanged = new HashMap<>();
137
		List<RechargeTransaction> rechargeTransactions = rechargeTransactionRepository.selectAllBetweenTimestamp(nonSuccessRechargeStatuses,fromDate, toDate);
23612 amit.gupta 138
		for(RechargeTransaction rechargeTransaction : rechargeTransactions) {
23626 amit.gupta 139
			try {
140
				int providerId = rechargeTransaction.getProviderId();
141
				if(providerId==1) {
142
					oxigenRechargeProviderService.doCheckStatusRequest(oxigenRechargeEnquiryUrl, oxigenRechargeAuthKey, rechargeTransaction);
143
				} else if(providerId==2) {
144
					thinkWalnutDigitalRechargeProviderService.doCheckStatusRequest(thinkWalnutDigitalRechargeEnquiryCredential, rechargeTransaction);
145
				}
146
				if(rechargeTransaction.getStatus().equals(RechargeStatus.SUCCESS) || rechargeTransaction.getStatus().equals(RechargeStatus.FAILED)) {
147
					requestRechargeStatusChanged.put(rechargeTransaction.getRequestId(), rechargeTransaction.getStatus());
148
				}
149
			} catch (Exception e) {
150
				LOGGER.info("Could not check status for Request {}", rechargeTransaction.getRequestId());
23612 amit.gupta 151
			}
152
		}
23618 amit.gupta 153
		model.addAttribute("response", mvcResponseSender.createResponseString(requestRechargeStatusChanged));
154
		return "response";
155
	}
23612 amit.gupta 156
 
23506 amit.gupta 157
	@RequestMapping(value = "/cron/process-schemes", method = RequestMethod.GET)
23558 amit.gupta 158
	public String createScheme(HttpServletRequest request, Model model) throws Exception {
23564 amit.gupta 159
		LocalDateTime fromDate = LocalDateTime.now().minusDays(15);
23506 amit.gupta 160
		LOGGER.info("Started execution at {}", LocalDateTime.now());
161
		List<Purchase> purchases = purchaseRepository.selectFromPurchaseCompleteDate(fromDate);
162
		for (Purchase purchase : purchases) {
163
			try {
164
				schemeService.processSchemeIn(purchase.getId(), purchase.getFofoId());
165
			} catch (Exception e) {
166
				LOGGER.error("Error while processing purchase {} for scheme In ", purchase.getId());
167
				e.printStackTrace();
168
 
169
			}
170
		}
23511 amit.gupta 171
		List<FofoOrder> fofoOrders = fofoOrderRepository.selectFromSaleDate(fromDate);
172
		for (FofoOrder fofoOrder: fofoOrders) {
173
			try {
174
				schemeService.processSchemeOut(fofoOrder.getId(), fofoOrder.getFofoId());
175
			} catch (Exception e) {
176
				LOGGER.error("Error while processing sale order {} for scheme Out", fofoOrder.getId());
177
			}
178
		}
23506 amit.gupta 179
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
180
		return "response";
181
	}
182
 
183
}